MySQL Problem
#2

You don't need GetPlayerDeath and GetPlayerKills.

pawn Code:
public OnPlayerDeath(playerid, killerid, reason)
{
    ResetPlayerWeapons(playerid);
    format(String,256,"UPDATE `Users` SET Death=Death+1 WHERE `Nick`='%s'",GetName(playerid));
    mysql_query(String);
    if(IsPlayerConnected(killerid))
    {
        SendDeathMessage(killerid,playerid,reason);
        format(String,256,"UPDATE `Users` SET Kills=Kills+1 WHERE `Nick`='%s'",GetName(killerid));
        mysql_query(String);
        if(GetPlayerKills(killerid) == Levels[GetPlayerLevel(killerid)+1])
        {
            format(String,256,"!%i o`i`д i`?од %s б?лa*ъй?a* , дu`зчi"",GetPlayerLevel(killerid) + 1,GetName(killerid));
            SendClientMessageToAllEx(killerid,c_orange,String);
            format(String,256,"
.%i б?лa*ъй?a* , o`i`йъ i`?од",GetPlayerLevel(killerid) + 1);
            SendClientMessage(killerid,c_orange,String);
            format(String,256,"
/Level Commands %i - o`i` о?ъ i`цфa*ъ бфчa*a~a*ъ дзa~u`a*ъ i`?од u`i`e^ дчu`",GetPlayerLevel(killerid) + 1);
            SendClientMessage(killerid,c_orange,String);
            format(String,256,"
UPDATE `Users` SET Level=Level+1 WHERE `Nick`='%s'",GetName(playerid));
            mysql_query(String);
        }
    }
    ResetPlayerMoney(playerid);
    return true;
}
Reply


Messages In This Thread
MySQL Problem - by EviLpRo - 31.07.2011, 09:30
Re: MySQL Problem - by Sergei - 31.07.2011, 09:33
Re: MySQL Problem - by EviLpRo - 31.07.2011, 09:38

Forum Jump:


Users browsing this thread: 1 Guest(s)