Help with MySQL saving.
#1

Alright, so I can read fine from the database, but the script doesn't save the data in the database. Anyone have any suggestions on how to fix the issue?
pawn Код:
GetPlayerPos(playerid, Player[playerid][LastX], Player[playerid][LastY], Player[playerid][LastZ]);
        GetPlayerHealth(playerid, Player[playerid][LastHealth]);
        GetPlayerArmour(playerid, Player[playerid][LastArmour]);
        Player[playerid][LastInterior] = GetPlayerInterior(playerid);
        new query[718],
            Pname[MAX_PLAYER_NAME],
            escpname[128]; //Variables
        GetPlayerName(playerid, Pname, 255); //Gets the player name
        mysql_real_escape_string(Pname, escpname);
        format(query, sizeof(query), "UPDATE playerinfo SET AdminLevel=%d,LastX=%f, LastY='%f', LastZ='%f', LastWorld=%d,\
        LastInterior=%d, LastSkin=%d, LastHealth=%f, LastArmour=%f, LastLoginYear=%d, LastLoginMonth=%d, LastLoginDay=%d,\
        Group=%d, GroupRank=%d, House=%d, Banned=%d, Muted=%d, Money=%d, WepSlot0=%d, WepSlot1=%d, WepSlot2=%d WHERE Player = '%s'"
,
        Player[playerid][AdminLevel], Player[playerid][LastX], Player[playerid][LastY],
        Player[playerid][LastZ], Player[playerid][LastWorld], Player[playerid][LastInterior],
        Player[playerid][LastSkin], Player[playerid][LastHealth], Player[playerid][LastArmour],
        Player[playerid][LastLoginYear], Player[playerid][LastLoginMonth], Player[playerid][LastLoginDay],
        Player[playerid][Group], Player[playerid][GroupRank], Player[playerid][House],
        Player[playerid][Banned], Player[playerid][Muted], Player[playerid][Money],
        Player[playerid][WepSlot0][0], Player[playerid][WepSlot1][0], Player[playerid][WepSlot2][0], escpname);
        mysql_query(query); //queries
        print("Player successfully saved");
        return 1;
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)