[TUT] SQLx - the newest AMXX SQL driver set (advantages and usage) - Page 3

danielkza

Just kick the player in the query callback.

Drak

Quote:

Originally Posted by danielkza

Just kick the player in the query callback.

Durrrrrrrrrrrrr. Lol, thanks.

whosyourdaddy

kk what happens if u keep on getting

Code:

if ( failstate == TQUERY_CONNECT_FAILED )

cause of some reason im getting those here and there. is there something i can do to prevent it?

danielkza

Quote:

Originally Posted by whosyourdaddy

kk what happens if u keep on getting

Code:

if ( failstate == TQUERY_CONNECT_FAILED )

cause of some reason im getting those here and there. is there something i can do to prevent it?

Try printing the error string/number, it will tell you what went wrong.

**Hawk552**

Quote:

Originally Posted by whosyourdaddy

kk what happens if u keep on getting

Code:

if ( failstate == TQUERY_CONNECT_FAILED )

cause of some reason im getting those here and there. is there something i can do to prevent it?

danielkza is right. From what I hear, non-threaded connections can break up due to lack of activity, but if you're using a threaded query, the connection is made right when the query is called. We'd need to see the error to diagnose it.

whosyourdaddy

Code:

[MYSQLX] Threaded query error, location: 1
[MYSQLX] Message: Can't connect to MySQL server on 'xx.xxx.xx.xxx' (10060) (2003)
[MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '12429', '1', '78929'); 
[MYSQLX] Fail state: Connection Failed

i removed where its being located but xx.xx.xxx.xx has a real ip that has a succesfull connection

danielkza

Quote:

Originally Posted by whosyourdaddy

Code:

[MYSQLX] Threaded query error, location: 1
[MYSQLX] Message: Can't connect to MySQL server on 'xx.xxx.xx.xxx' (10060) (2003)
[MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '12429', '1', '78929'); 
[MYSQLX] Fail state: Connection Failed

i removed where its being located but xx.xx.xxx.xx has a real ip that has a succesfull connection

No it does not. Check the error message of SQL_Connect. And by the error, i'm positive the connections is being rejected/not getting to the IP at all.

whosyourdaddy · *Last edited by whosyourdaddy; 02-02-2009 at 13:50.*

Quote:

Originally Posted by danielkza

No it does not. Check the error message of SQL_Connect. And by the error, i'm positive the connections is being rejected/not getting to the IP at all.

SQL_connect works cause my regular queries dont give me any error messages, its just now and then my threaded queries give me error messages that connection has failed. is there a way i can make my query redo itself 5 times before quiting and sending me the error message, and other than threaded queries making a seperate connection whats the difference in using threaded queries from regular queries?

minimiller

sicko tutorial dude
ill be needing threaded queries pretty soon
<3

platzpatrone

great tuto! nice job ! very helpful here and there

send some