23.10.2014, 19:33
Sending this error but no idea if it's anything to do with it:
Here's where the code is put
the query is sending but always returning 0 rows
pawn Код:
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:27:12] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.0.1, `health` = 0.000000, `armour` = 0.000000,`gender` = 0, `pDisX` = 50.000000' at line 1
Here's where the code is put
pawn Код:
case DIALOG_LOGIN:
{
new hash[129];
WP_Hash(hash, sizeof(hash), inputtext);
if(!strcmp(hash, Account[playerid][Password]))
{
SCM(playerid, COLOR_GREEN, "You have successfully logged into "GAMEMODE_SHORTNAME". You will be spawned in a minute.");
SCM(playerid, COLOR_GREEN, "Remember, if you need help use "EMBED_WHITE"/assistance");
SCM(playerid, COLOR_GREEN, "And if you find a player is breaking the rules use "EMBED_WHITE"/report");
mysql_format(sqlHandle, gVar3000, sizeof(gVar3000), "SELECT * FROM `samp_users` WHERE 'Username' = '%s' AND Password = '%s'", Name[playerid], Account[playerid][Password]);
mysql_tquery(sqlHandle, gVar3000, "OnAccountLoad", "d", playerid);
}
else
{
SCM(playerid, COLOR_DEATHRED, "[ERR] You appear to have entered an incorrect password.");
KickDelay(playerid);
}
}