SA-MP Forums Archive
Mysql problem [FIXED] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql problem [FIXED] (/showthread.php?tid=303884)



Mysql problem [FIXED] - Tanush123 - 15.12.2011

EDIT: I FIXED IT!













pawn Код:
CMD:setleader(playerid,params[])
{
    if(!IsPlayerAdmin(playerid)) return 0;
    if(sscanf(params,"ui",ID,orgid)) return SendClientMessage(playerid,grey,"USAGE: /setleader [playerid / partofname] [orgid]");
    if(ID == INVALID_PLAYER_ID) return SendClientMessage(playerid,red,"ERROR: That user is not connected.");
    if(PlayerInfo[ID][Member] != -255) return SendClientMessage(playerid,red,"You can't set a leader that is in an organization.");
    GetPlayerName(ID,pname,sizeof(pname));
    GetPlayerName(playerid,Nam,sizeof(Nam));
    CheckMySQL();
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        format(str,sizeof(str),"Administrator %s has set you the leader of (orgid: %d).",Nam,orgid);
        SendClientMessage(ID,orange,str);
        format(str,sizeof(str),"You have set %s the organization leader of (orgid: %d).",pname,orgid);
        SendClientMessage(playerid,orange,str);
        PlayerInfo[ID][Member] = orgid;
        PlayerInfo[ID][Genre] = strval(field[2]);
        PlayerInfo[ID][Leader] = 1;
        ResetPlayerWeapons(ID);
        mysql_free_result();
        format(str,sizeof(str),"UPDATE orgs SET Leader = '%s' WHERE Orgid = '%d'",pname,orgid);
        mysql_query(str);
    }
    else if(mysql_num_rows() == 0)
    {
        SendClientMessage(playerid,red,"ERROR: This Organization ID is not available.");
    }
    request[ID] = -255;
      return 1;
}
Well the problem is when i do setleader [playerid] [random org id] it sets the player that orgid while its not created in my mysql file