25.09.2009, 17:29
pawn Код:
if(mysql_num_rows() != 0)
{
new pName1[MAX_PLAYER_NAME];
GetPlayerName(playerid,pName1,sizeof(pName1));
format(query,sizeof(query),"SELECT * FROM `/*tablename*/` WHERE Username = '%s' LIMIT 1", pName1);
mysql_query(query);
mysql_store_result();
new resultline[512],player[X][32];
mysql_fetch_field_row(resultline,"|");
split(resultline, player, '|');
PlayerInfo[playerid][Money] = strval(player[0]);
PlayerInfo[playerid][Admin] = strval(player[1]);
//other variables
mysql_free_result();
LoggedIn[playerid] = true;
SendClientMessage(playerid,NOTICE," You are now logged in!");
return 1;
}