Raised This Month: $ Target: $400
 0% 

MYSQL - weird bug


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Schwabba
Senior Member
Join Date: Apr 2008
Old 06-17-2011 , 08:16   Re: MYSQL - weird bug
Reply With Quote #9

Quote:
Originally Posted by Sylwester
I suspect that the problem is caused by invalid steamid sent in the SELECT query (there is some checking in register_client to see if the steamid is correct, but there is none in Load_MySQL).
That could it be.

Quote:
Originally Posted by Sylwester
1. SQL_NumResults returns number of rows retrieved from database. If you execute SELECT ... WHERE steamid = '%s'; it will be greater than 0 for all steamids that are present in database so "if" condition will be false.
That's what i want, check if the steamid is in the database, if yes, load the entries, when not, insert the steamid to the database with money 0.

Quote:
Originally Posted by Sylwester
3. Using SQL_ReadResult to check if there were any rows retrieved from database is incorrect.
Why?

Last edited by Schwabba; 06-17-2011 at 11:14.
Schwabba is offline
 



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 23:30.


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