Raised This Month: $51 Target: $400
 12% 

Clan API (Clan Management Interface) v1.2


Post New Thread Reply   
 
Thread Tools Display Modes
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-27-2006 , 23:33   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #101

Quote:
Originally Posted by vvg125 View Post
Uh, I'm not sure whether this is database related or plugin related but it won't connect to the database.

When I checked the error logs, it says access denied to database but when I looked at what it's trying to cennect to, it's ip address 66.55.154.122.

The database host is varsql.gamereviewz.net and I set it that way in clan_sql.ini and I had the clanapi.cfg read the clan_sql.ini.
There's a networking concept called "DNS". Basically, your domain name is simply a placeholder for whatever IP address your server really is. In this case, the IP is 66.55.154.122.

If you don't believe me, try going to Start -> Run -> "cmd", then type "ping varsql.gamereviewz.net". It should say "Pinging 66.55.154.122", or something close to that if the IP changed since you typed this out.

But anyway, I can't help you with your username/password issue. I'd need to literally have access to the database to do it, since I don't know if you picked the wrong username or password.
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
vvg125
AMX Mod X Beta Tester
Join Date: Dec 2006
Location: Queens (Douglaston), New
Old 12-27-2006 , 23:38   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #102

Yea... I just saw the stupidity in what I just said.

Well, thanks anyway.
vvg125 is offline
Send a message via AIM to vvg125 Send a message via MSN to vvg125 Send a message via Yahoo to vvg125
vvg125
AMX Mod X Beta Tester
Join Date: Dec 2006
Location: Queens (Douglaston), New
Old 12-28-2006 , 01:27   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #103

Sorry about this... I now know the database info is right because the website for the clan API plugin works but it hasn't created the clan_members table. It did however create the clan_web table and add the web admins correctly.

Someone else had a similar problem in the thread earlier where it says " Query failed Table 'techdb.clan_members' doesn't exist"

Thanks again for your patience...
vvg125 is offline
Send a message via AIM to vvg125 Send a message via MSN to vvg125 Send a message via Yahoo to vvg125
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-28-2006 , 09:46   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #104

Run this query on your database:

CREATE TABLE IF NOT EXISTS clan_members (authid VARCHAR (36),rank VARCHAR(33),name VARCHAR (33))
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
vvg125
AMX Mod X Beta Tester
Join Date: Dec 2006
Location: Queens (Douglaston), New
Old 12-28-2006 , 13:54   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #105

Alright, everything's running fine now. Thanks for the help and the plugins awesome.
vvg125 is offline
Send a message via AIM to vvg125 Send a message via MSN to vvg125 Send a message via Yahoo to vvg125
Eismann1976
Senior Member
Join Date: Feb 2006
Old 12-29-2006 , 08:37   Re: Clan API (Clan Management Interface) v1.1
Reply With Quote #106

Quote:
Originally Posted by Hawk552 View Post
I think I isolated the problem (a quite stupid issue).

I've uploaded v1.2 but I can't test it. There's also a new plugin for it that I coded a while ago, clan_config. I've added it and instructions on how to use it.
Iīve testet it on a testserver

Connecting to 85.25.131.59:27040...
Connection accepted by 85.25.131.59:27040
Kicked by Console: " "Clan tag -=Stammi= reserved."
Kicked :" "Clan tag -=Stammi= reserve

The SteamID is in der clan_members table of course
__________________
Eismann1976 is offline
Send a message via ICQ to Eismann1976
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-29-2006 , 10:31   Re: Clan API (Clan Management Interface) v1.1
Reply With Quote #107

Quote:
Originally Posted by Eismann1976 View Post
Iīve testet it on a testserver

Connecting to 85.25.131.59:27040...
Connection accepted by 85.25.131.59:27040
Kicked by Console: " "Clan tag -=Stammi= reserved."
Kicked :" "Clan tag -=Stammi= reserve

The SteamID is in der clan_members table of course
Are you sure you changed maps after you added them? Are you sure their Steam ID wasn't listed as STEAM_ID_PENDING or something like that?
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
Eismann1976
Senior Member
Join Date: Feb 2006
Old 12-29-2006 , 14:22   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #108

Thats it ! SteamID is listed as STEAM_ID_PENDING. But i canīt do anything. Everytime i try to connect the same Probleme. I think the check will be better after 3 or 5 seconds. :-/
__________________
Eismann1976 is offline
Send a message via ICQ to Eismann1976
Hawk552
AMX Mod X Moderator
Join Date: Aug 2005
Old 12-29-2006 , 14:27   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #109

Quote:
Originally Posted by Eismann1976 View Post
Thats it ! SteamID is listed as STEAM_ID_PENDING. But i canīt do anything. Everytime i try to connect the same Probleme. I think the check will be better after 3 or 5 seconds. :-/
It actually waits 10 seconds.

I can't help with this problem, it's totally out of my control.
__________________
Hawk552 is offline
Send a message via AIM to Hawk552
Eismann1976
Senior Member
Join Date: Feb 2006
Old 12-29-2006 , 14:47   Re: Clan API (Clan Management Interface) v1.2
Reply With Quote #110

Quote:
Originally Posted by Hawk552 View Post
It actually waits 10 seconds.

I can't help with this problem, it's totally out of my control.
Oh, but if the plugin 10 seconds wait, why the server kicks bevor the client can connect. I mean the server kick the client 1 or 2 seconds after the beginn of the connect and bevor he is on the server finally ^^.

If i type in the console connect ip, the connect will beginn and 1 or 2 seconds after this command i will be kicked.
If i am on the server and change my name everything is ok and if i type now retry in the console the client connect new without any problem.

I hope you now wat i mean.
__________________
Eismann1976 is offline
Send a message via ICQ to Eismann1976
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:22.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode