pawn Code:
case 0:
{
if(!response)return Kick(playerid);
mysql_format(gConnectionHandle, Query , "SELECT * FROM 'users' WHERE Username '%s' AND Password = md5('%s')",GetName(playerid),inputtext);
mysql_function_query(gConnectionHandle , Query , false ,"LoginPlayer" , "ii" , playerid,inputtext);
}
case 1:
{
if(!response)return Kick(playerid);
new IP[50];
GetPlayerIp(playerid,IP,sizeof (IP));
mysql_format(gConnectionHandle, Query, "INSERT INTO `users` (`Username`, `Password`, `Money`, `Score`, `Admin`, `Kills`, `Deaths`, `IP`) VALUES('%s' , md5('%s'), 5000, 0, 0, 0, 0, '%s')",GetName(playerid),inputtext,IP);
mysql_function_query(gConnectionHandle, Query, false , "OnQueryFinish", "ii",Query);
GivePlayerMoney(playerid,5000);
SetPlayerScore(playerid,0);
}