30.10.2011, 11:51
It still says ( SELECT name FROM gangs WHERE ID = 3) Cowboy: test
Thanks for helping
EDIT: A fast question
This is from my login dialog. Where should I free the result?
Should I free it with the first one or the second, thanks again
Thanks for helping

EDIT: A fast question
This is from my login dialog. Where should I free the result?
pawn Код:
case 2:
{
if(!response) return Kick(playerid);
GetPlayerName(playerid, pName, sizeof(pName));
mysql_real_escape_string(inputtext, escapepass);
format(Query, sizeof(Query), "SELECT `name` FROM users WHERE name = '%s' AND password = '%s'", pName, escapepass);
mysql_query(Query);
mysql_store_result();
if(!mysql_num_rows())
{
ShowPlayerDialog(playerid...)
}
else if(mysql_num_rows() == 1)
{
format(Query, sizeof(Query), "SELECT * FROM users WHERE name = '%s'", pName);
mysql_query(Query);
mysql_store_result();
while(mysql_fetch_row_format(Query,"|"))
{
mysql_fetch_field_row(field, "score");
SetPlayerScore(playerid, strval(field));
mysql_fetch_field_row(field, "money");
GivePlayerMoney(playerid, strval(field));
mysql_fetch_field_row(field, "adminlevel");
PlayerInfo[playerid][pAdminLevel] = strval(field);
mysql_fetch_field_row(field, "gang");
PlayerInfo[playerid][Gang] = strval(field);
}
// mysql_free_result();
PlayerInfo[playerid][pLogged] = 1;
}
// mysql_free_result();
}