[Healian]

i am retrieving the data from SQLLite and storing them into enum

like

pawn Код:

enum pINF
{
    prSTEP,
    pSQ,
    pSA,
    pIP,
    pRDATE,
    pADMINLVL,
    pVIPLVL,
    pPLAYERRANK,
    pWANTEDLVL,
    pSCORE,
    pMONEY,
    pKILLS,
    pDEATHS,
    pX,
    pY,
    pZ,
    pINTERIOR,
    pWORLD,
    pHEALTH,
    pARMOR,
    pSKIN,
    pWEAP1,
    pWEAP1A,
    pWEAP2,
    pWEAP2A,
    pWEAP3,
    pWEAP3A,
    pWEAP4,
    pWEAP4A,
    pWEAP5,
    pWEAP5A,
    pWEAP6,
    pWEAP6A,
    pVEHI1,
    pVEHI2,
    pVEHI3,
    pVEHI4,
    pVEHI5,
    pJAILED,
    pJAILTIME,
    pWARNINGS,
    pMUTED,
    pCOLOR
};

new pInfo[MAX_PLAYERS][pINF];

Then i want to save the data back from those enums to the database so i tried something like this but it totally saves wrong values with wrong characters

SAMPLE from my save command

pawn Код:

format(Query, sizeof(Query), "UPDATE `Misc` SET JAILED = '%s', JAILEDTIME = '%s', WARNINGS = '%s', MUTED = '%s', COLOR = '%s' WHERE `NAME` = '%s'", DB_Escape(pInfo[playerid][pVEHI1]), DB_Escape(pInfo[playerid][pJAILED]), DB_Escape(pInfo[playerid][pJAILTIME]), DB_Escape(pInfo[playerid][pWARNINGS]), DB_Escape(pInfo[playerid][pMUTED]), DB_Escape(pInfo[playerid][pCOLOR]), DB_Escape(pName));
    db_query(DATABASE, Query);