MySQL - no errors but it doesn't save
#1

Im just trying to make a simpe VIP system,but when i relog i do not have VIP even though i gave it to myself-when i test.
Here's some of the /givevip command:
pawn Код:
if(sscanf(params, "ui", targetP, vipLevel)) return SendClientMessage(playerid, COLOR_GREY, "USAGE:/givevip [PLAYER ID] [VIP LEVEL]");
       
        playerVariables[targetP][pVIP]=vipLevel;
       
        GetPlayerName(playerid, admName, sizeof(admName));
        GetPlayerName(targetP, targetPName, sizeof(targetPName));
       
        format(msgToA, sizeof(msgToA), "You have given VIP level %d to player %s", vipLevel, targetPName);
        format(msgToP, sizeof(msgToP), "You have been given VIP level %d", vipLevel);
       
        SendClientMessage(playerid, COLOR_YELLOW, msgToA);
        SendClientMessage(targetP, COLOR_YELLOW, msgToP);
And here are the lines for MySQL query,to save and get the VIP variable value:

pawn Код:
mysql_get_field("playerVIP", result);
                playerVariables[extraid][pVIP] = strval(result);
and
pawn Код:
format(saveQuery, sizeof(saveQuery), "%s playerVIP = 'd'", saveQuery, playerVariables[playerid][pVIP]);
mysql_query(saveQuery);
Reply


Messages In This Thread
MySQL - no errors but it doesn't save - by Tagathron - 16.12.2013, 15:30
Re: MySQL - no errors but it doesn't save - by Brandon_More - 16.12.2013, 15:53
Re: MySQL - no errors but it doesn't save - by Tagathron - 16.12.2013, 16:22

Forum Jump:


Users browsing this thread: 1 Guest(s)