[Healian]

i opened more than 3 threads in different questions and no one came and helped


and now i am facing an annoying problem when i execute my function which retrieve character data from the database the server crashes

code:

pawn Код:

stock ret_cDATA(playerid)
{
    new 
        Query[ 256 ],
        DBResult: Result,
        pName[ MAX_PLAYER_NAME ],
        Field[ 50 ]
    ;
    GetPlayerName(playerid, pName, sizeof(pName));
    format(Query, sizeof(Query), "SELECT * FROM `Accounts` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(pName));
    Result = db_query(DATABASE, Query);
    
    if(db_num_rows(Result))
    {   
        db_get_field_assoc(Result, "rSTEP", Field, 30);
        pInfo[playerid][prSTEP] = strval(Field);
        
        db_get_field_assoc(Result, "SQ", Field, 300);
        pInfo[playerid][pSQ] = strval(Field);
    
        db_get_field_assoc(Result, "SA", Field, 300);
        pInfo[playerid][pSA] = strval(Field);

        db_get_field_assoc(Result, "IP", Field, 30);
        pInfo[playerid][pIP] = strval(Field);
        
        db_get_field_assoc(Result, "REGISTRATIONDATE", Field, 30);
        pInfo[playerid][pRDATE] = strval(Field);
        
        db_get_field_assoc(Result, "VIPLEVEL", Field, 30);
        pInfo[playerid][pVIPLVL] = strval(Field);
        
        db_get_field_assoc(Result, "ADMINLEVEL", Field, 30);
        pInfo[playerid][pADMINLVL] = strval(Field);
        
        db_get_field_assoc(Result, "PLEVEL", Field, 30);
        pInfo[playerid][pPLAYERLVL] = strval(Field);
        
        db_get_field_assoc(Result, "WANTEDLEVEL", Field, 30);
        pInfo[playerid][pWANTEDLVL] = strval(Field);
    
        db_get_field_assoc(Result, "CASH", Field, 30);
        pInfo[playerid][pMONEY] = strval(Field);
    
        db_get_field_assoc(Result, "KILLS", Field, 30);
        pInfo[playerid][pKILLS] = strval(Field);
        
        db_get_field_assoc(Result, "DEATHS", Field, 30);
        pInfo[playerid][pDEATHS] = strval(Field);
        
        db_get_field_assoc(Result, "X", Field, 30);
        pInfo[playerid][pX] = strval(Field);
        
        db_get_field_assoc(Result, "Y", Field, 30);
        pInfo[playerid][pY] = strval(Field);
        
        db_get_field_assoc(Result, "Z", Field, 30);
        pInfo[playerid][pZ] = strval(Field);
        
        db_get_field_assoc(Result, "INTERIOR", Field, 30);
        pInfo[playerid][pINTERIOR] = strval(Field);
        
        db_get_field_assoc(Result, "WORLD", Field, 30);
        pInfo[playerid][pWORLD] = strval(Field);
        
        db_get_field_assoc(Result, "HEALTH", Field, 30);
        pInfo[playerid][pHEALTH] = strval(Field);
        
        db_get_field_assoc(Result, "ARMOR", Field, 30);
        pInfo[playerid][pARMOR] = strval(Field);
        
        db_get_field_assoc(Result, "SKIN", Field, 30);
        pInfo[playerid][pSKIN] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP1", Field, 30);
        pInfo[playerid][pWEAP1] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP1A", Field, 30);
        pInfo[playerid][pWEAP1A] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP2", Field, 30);
        pInfo[playerid][pWEAP2] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP2A", Field, 30);
        pInfo[playerid][pWEAP2A] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP3", Field, 30);
        pInfo[playerid][pWEAP3] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP3A", Field, 30);
        pInfo[playerid][pWEAP3A] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP4", Field, 30);
        pInfo[playerid][pWEAP4] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP4A", Field, 30);
        pInfo[playerid][pWEAP4A] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP5", Field, 30);
        pInfo[playerid][pWEAP5] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP5A", Field, 30);
        pInfo[playerid][pWEAP5A] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP6", Field, 30);
        pInfo[playerid][pWEAP6] = strval(Field);
        
        db_get_field_assoc(Result, "WEAP6A", Field, 30);
        pInfo[playerid][pWEAP6A] = strval(Field);
        
        db_get_field_assoc(Result, "JAILED", Field, 30);
        pInfo[playerid][pJAILED] = strval(Field);
        
        db_get_field_assoc(Result, "JAILEDTIME", Field, 30);
        pInfo[playerid][pJAILTIME] = strval(Field);
        
        db_get_field_assoc(Result, "WARNINGS", Field, 30);
        pInfo[playerid][pWARNINGS] = strval(Field);
        
        db_get_field_assoc(Result, "MUTED", Field, 30);
        pInfo[playerid][pMUTED] = strval(Field);
        
        db_get_field_assoc(Result, "COLOR", Field, 30);
        pInfo[playerid][pCOLOR] = strval(Field);
    }
}