MYSQL debug says saved, but nothing is saved
#7

pawn Code:
new query[1024];
        format(query, sizeof(query), "UPDATE Users SET \
        Money = '%d', \
        Level = '%d', \
        Admin = '%d', \
        Helper = '%d', \
        VipLevel = '%d', \
        Skin = '%d', \
        Kills = '%d', \
        Deaths = '%d', \
        Muted = '%d', \
        Cell = '%d', \
        Cigs = '%d', \
        Watch = '%d', \
        Mask = '%d', \
        GasCan = '%d', \
        Sprunk = '%d', \
        Stereo = '%d', \
        GoldCoins = '%d', \
        PaymentMethod = '%d', \
        DriversLic = '%d', \
        WeaponLic = '%d', \
        HeavyVLic = '%d', \
        PilotLic = '%d', \
        BlockedPM = '%d',\
        Proposing = '%d',\
        Warnings = '%d'\
        WHERE Username = '%s'"
,
        GetPlayerMoney(playerid),
        GetPlayerScore(playerid),
        GetPVarInt(playerid,"Level"),
        GetPVarInt(playerid,"Helper"),
        GetPVarInt(playerid,"Vip Level"),
        GetPVarInt(playerid,"Skin"),
        GetPVarInt(playerid,"Kills"),
        GetPVarInt(playerid,"Deaths"),
        GetPVarInt(playerid,"Muted"),
        GetPVarInt(playerid,"HasCellphone"),
        GetPVarInt(playerid,"HasCigs"),
        GetPVarInt(playerid,"HasWatch"),
        GetPVarInt(playerid,"HasMask"),
        GetPVarInt(playerid,"GasCan"),
        GetPVarInt(playerid,"HasSprunk"),
        GetPVarInt(playerid,"HasStereo"),
        GetPVarInt(playerid,"GoldCoins"),
        GetPVarInt(playerid,"PMethod"),
        GetPVarInt(playerid,"DriversLic"),
        GetPVarInt(playerid,"WeaponLic"),
        GetPVarInt(playerid,"HeavyVLic"),
        GetPVarInt(playerid,"PilotLic"),
        PInfo[playerid][BlockedPM],
        PInfo[playerid][Proposing],
        PInfo[playerid][Warnings],
        PInfo[playerid][Exp],
        PInfo[playerid][Phonebook],
        GetPlayerNameEx(playerid));
        mysql_query(query);
Here it is..
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 2 Guest(s)