[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