Mysql_Get_Feild bug. -
(I switched from strikenkids to gstylez, so ive been fixing bugs with the switch all night. This is a bug i cant figure out.)
Re: Mysql_Get_Feild bug. -
Re: Mysql_Get_Feild bug. -
pawn Код:
if(dialogid ==2)
{
TogglePlayerControllable(playerid, 0);
new string[64], pname[MAX_PLAYER_NAME], query[128];
GetPlayerName(playerid, pname, sizeof(pname));
format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `name` = '%s' AND `password` = md5('%s');", pname, inputtext);
mysql_query(query); mysql_store_result();
if(mysql_num_rows() == 0)
{
format(string, 256, "You specified the wrong password for %s!", pname);
SendClientMessage(playerid, red, string);
ShowPlayerDialog(playerid, 2, 1,"Wrong Password", "That Password is incorrect. Please try again.","login", "cancel");
}
else
{
new pdata[128];
mysql_get_field("level", pdata); playerdata[playerid][level] = strval(pdata);
mysql_get_field("Joins", pdata); playerdata[playerid][Joins] = strval(pdata);
mysql_get_field("Deaths", pdata); playerdata[playerid][Deaths] = strval(pdata);
mysql_get_field("Kills", pdata); playerdata[playerid][Kills] = strval(pdata);
mysql_get_field("Kicks", pdata); playerdata[playerid][Kicks] = strval(pdata);
mysql_get_field("Banned", pdata); playerdata[playerid][Banned] = strval(pdata);
mysql_get_field("BanReason", pdata); playerdata[playerid][BanReason] = strval(pdata);
mysql_get_field("Score", pdata); playerdata[playerid][Score] = strval(pdata);
mysql_get_field("Money", pdata); playerdata[playerid][Money] = strval(pdata);
mysql_get_field("Slots", pdata); playerdata[playerid][Slots] = strval(pdata);
if(playerdata[playerid][Banned]==1)
{
SendClientMessage(playerid, COLOR_RED,"You are banned, so go away!");
Kick(playerid);
}
else
{
playerdata[playerid][logged] = 1;
SendClientMessage(playerid, green, "You have succesfully logged in!");
PlayerPlaySound(playerid,1057,0.0,0.0,0.0);
new pip[16];
GetPlayerIp(playerid, pip, sizeof(pip));
printf("%s (%i) logged in with the ip %s", pname, playerid, pip);
SetTimerEx("Save", 25000, true, "i", playerid);
}
}
mysql_free_result();
if(response == 0)
{
SendClientMessage(playerid, red, "Screw You To, Bye!");
Kick(playerid);
}
return 1;
}
Re: Mysql_Get_Feild bug. -
You forgot to do mysql_retrieve_row(); to retrieve the next row in the query. Read the error next time: "Reason: Fields/Rows are empty."