27.01.2011, 18:09
pawn Код:
new query[128];
format(query,sizeof(query),"SELECT * FROM Players WHERE username='%s' AND password=MD5('%s')",PlayerName(playerid),inputtext);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
mysql_free_result();
Stats[playerid][admin] = CMySQL_Int(PlayerName(playerid),"admin");
new string[128];
format(string,sizeof(string),"You have logged in as a level "#COL_YELLOW"%i "#COL_WHITE"admin",Stats[playerid][admin]);
Stats[playerid][money] = CMySQL_Int(PlayerName(playerid),"money");
Stats[playerid][LastX] = CMySQL_Float(PlayerName(playerid),"LastX");
printf("%f",Stats[playerid][LastX]);
Stats[playerid][LastY] = CMySQL_Float(PlayerName(playerid),"LastY");
Stats[playerid][LastZ] = CMySQL_Float(PlayerName(playerid),"LastZ");
GivePlayerMoney(playerid,Stats[playerid][money]);
SendClientMessage(playerid,COLOR_YELLOW,"Thank you for logging in!");
}
