[Help] MYSQL /setadmin problem

[Help] MYSQL /setadmin problem - 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: [Help] MYSQL /setadmin problem (/showthread.php?tid=353289)

[Help] MYSQL /setadmin problem - andrew2695 - 22.06.2012

I'm trying to make a /setadmin command using MySQL database but I keep getting That player is not online. And its not going well.
Here the code. Anyone know whats wrong?

pawn Код:

CMD:setadmin(playerid, params[])
{
       new iD, gMessage[250], pName[24], NewAdmin[24], gQuery[250], Level;
       if(sscanf(params, "ui", iD, Level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
       else if(!IsPlayerConnected(iD)) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online.");
       else
       {
               GetPlayerName(playerid, pName, sizeof(pName));
               GetPlayerName(iD, NewAdmin, sizeof(NewAdmin));
               format(gQuery, sizeof(gQuery), "UPDATE Accounts SET Admin = '%i' WHERE Username = '%s'", Level, NewAdmin);
               mysql_query(gQuery);

               format(gMessage, sizeof(gMessage), "* You have set %s has a level %i admin.", NewAdmin, Level);
               SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

               format(gMessage, sizeof(gMessage), "* You have been set as a level %i admin.", Level);
               SendClientMessage(iD, 0xFFFFFFFF, gMessage);
       }
       return 1;
}

Re: [Help] MYSQL /setadmin problem - Ricop522 - 22.06.2012

Could you show us the mysql_log ?

(mysql_debug(1))

pawn Код:

CMD:setadmin(playerid, params[])
{
       new iD, gMessage[250], pName[24], NewAdmin[24], gQuery[250], Level;
       if(sscanf(params, "ui", iD, Level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
       if(!IsPlayerConnected(iD)) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online.");
       GetPlayerName(playerid, pName, sizeof(pName));
       GetPlayerName(iD, NewAdmin, sizeof(NewAdmin));
       
       format(gQuery, sizeof(gQuery), "UPDATE Accounts SET Admin = %i WHERE Username = '%s'", Level, NewAdmin);
       mysql_query(gQuery);

       format(gMessage, sizeof(gMessage), "* You have set %s has a level %i admin.", NewAdmin, Level);
       SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

       format(gMessage, sizeof(gMessage), "* You have been set as a level %i admin.", Level);
       SendClientMessage(iD, 0xFFFFFFFF, gMessage);
       
       return 1;
}

Its the same code, I dont modify nothing /\

Re: [Help] MYSQL /setadmin problem - andrew2695 - 22.06.2012

Here the debug http://pastebin.com/WJG2C09d