[Help] MYSQL /setadmin problem
#1

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;
}
Reply
#2

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 /\
Reply
#3

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


Forum Jump:


Users browsing this thread: 1 Guest(s)