[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?

[Mister0]

the error is here

PHP код:

 mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%d' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]); 
    mysql_tquery(SQL, longstring, "", ""); 


yopu need to put '%s' not %d

PHP код:


 mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%s' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]); 
    mysql_tquery(SQL, longstring, "", ""); 


[gumball3000]

Quote:

Originally Posted by Mister0 the error is here PHP код:  mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%d' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]);      mysql_tquery(SQL, longstring, "", "");  yopu need to put '%s' not %d PHP код:  mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%s' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]);      mysql_tquery(SQL, longstring, "", "");

Thanks +rep that helped me get some data into the database but i have another problem now. The string does not get formatted like i want it to.

On player connect i get their old crimes string like this

PHP код:

    cache_get_field_content(0, "mcrimes", PlayerData[playerid][mcrimes], SQL, 129); 


And then when insercrime is called i do:

PHP код:

    format(longstring, sizeof(longstring), "%s", PlayerData[playerid][mcrimes]);
    
    format(longstring, sizeof(longstring), "%s\n%s: %s - %s", longstring, date, reason, PlayerData[playerid][Name]);
    mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%s' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]);
    mysql_tquery(SQL, longstring, "", "");
    strmid(PlayerData[playerid][mcrimes], longstring, 0, strlen(longstring), 1024); 


The problem i have is that i never get to insert multiple crimes just the first one goes into the database the next ones don't get formatted like this: %s\n%s: %s - %s

[gumball3000]

ok here is the actual problem

PHP код:

    format(longstring, sizeof(longstring), "%s", PlayerData[id][mcrimes]);
    
    format(longstring, sizeof(longstring), "%s\n%s: %s - %s", longstring, date, reason, PlayerData[playerid][Name]);
    mysql_format(SQL, longstring, 1024, "UPDATE `users` SET `mcrimes`='%s' WHERE `ID`='%d' LIMIT 1", longstring, PlayerData[id][ID]);
    mysql_tquery(SQL, longstring, "", "");
    strmid(PlayerData[id][mcrimes], longstring, 0, strlen(longstring), 1024); 


strmid(PlayerData[id][mcrimes], longstring, 0, strlen(longstring), 1024); does not put longstring in PlayerData[id][mcrimes]

i also tried PlayerData[id][mcrimes] = longstring;

I want PlayerData[id][mcrimes] to match what i have in the mcrimes table but i don't want to query the database for it.