[gumball3000]

PHP код:

enum pData
{
    mcrimes[1024],
        
}; 


PHP код:

function InsertCrime(playerid, id, level, reason[])
{
    if(PlayerData[id][WantedLevel] == 0) PlayerData[id][TrackLose] = 30; 
    new ini, string[256], longstring[1024];
    ini = PlayerData[id][WantedLevel];
    if(level + PlayerData[id][WantedLevel] > 6) PlayerData[id][WantedLevel] = 6;
    else PlayerData[id][WantedLevel] = level + PlayerData[id][WantedLevel];
    SetPlayerWantedLevel(id,PlayerData[id][WantedLevel]);
    ini = PlayerData[id][WantedLevel]-ini;
    
    format(string, sizeof(string), "You've commited a Crime (%s). W: +%d, Reporter: %s.", reason, ini, PlayerData[playerid][Name]);
    SendClientMessage(id, COLOR_LIGHTRED, string);
    format(string, sizeof(string), "Current Wanted Level: %d", PlayerData[id][WantedLevel]);
    SendClientMessage(id, COLOR_YELLOW, string);
    
    new date[50];
    new y,m,d,h,mi,s;
    getdate(y,m,d);
    gettime(h,mi,s);
    format(date,sizeof(date),"%02d.%02d.%d %02d:%02d:%02d",d,m,y,h,mi,s);
    
    strmid(MDCData[id][PlayerData[id][MDC]][mDate], date, 0, strlen(date), 255);
    strmid(MDCData[id][PlayerData[id][MDC]][mReporter], PlayerData[playerid][Name], 0, strlen(PlayerData[playerid][Name]), 255);
    strmid(MDCData[id][PlayerData[id][MDC]][mReason], reason, 0, strlen(reason), 255);    
    
    format(longstring, sizeof(longstring), "%s\n%s: %s - %s", longstring, date, reason, PlayerData[playerid][Name]);
    mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%d' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]);
    mysql_tquery(SQL, longstring, "", "");
    
    PlayerData[id][MDC] += 1;
    PlayerData[id][Crimes] += 1;
    
    new str[128];
    mysql_format(SQL, str,128,"UPDATE `users` SET `WantedLevel`='%d' WHERE `ID`='%d' LIMIT 1",PlayerData[id][WantedLevel],PlayerData[id][ID]);
    mysql_tquery(SQL, str, "", "");
    mysql_format(SQL, str,128,"UPDATE `users` SET `LastCrime`='%s', `LastReporter`='%s' WHERE `ID`='%d' LIMIT 1",reason,PlayerData[playerid][Name],PlayerData[id][ID]);
    mysql_tquery(SQL, str, "", "");
    mysql_format(SQL, str,128,"UPDATE `users` SET `LastDate`='%s', `Crimes`='%d' WHERE `ID`='%d' LIMIT 1",date,PlayerData[id][Crimes],PlayerData[id][ID]);
    mysql_tquery(SQL, str, "", "");
    return 1;
} 


I am editing this script, i added mcrimes to that enum but i have a problem here: mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%d' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]);

Instead of getting a string in mysql i get some random number when the function is executed, mcrimes collumn in mysql is varchar of 1024. Any idea what am i doing wrong?