[Kubad]

i have this onclientdisconnect and my server crash and i dont know why but i im solo on server saving working fine

PHP Code:

char querydis[1024],name[32],steamid[32];
    GetClientAuthId(client, AuthId_Steam2, steamid, sizeof(steamid));
    GetClientName(client,name,sizeof(name));
    FormatEx(querydis, sizeof(querydis), "UPDATE  `JBStats` SET  `nick`= '%s', `ctkills`= '%i', `ctdeaths`= '%i', `ctheadshots`= '%i', `tkills`= '%i', `tdeaths`= '%i', `theadshots`= '%i', `days`= '%i', `hours`= '%i', `minutes`= '%i' WHERE  `JBStats`.`steamid` =  '%s'", name, ctkills[client], ctdeaths[client], ctheadshot[client], tkills[client], tdeaths[client], theadshot[client], days[client], hours[client], minutes[client], steamid);
    SQL_Query(DBstats, querydis,GetClientSerial(client)); 


[Reiko1231]

Use threaded query via SQL_TQuery. Non-threaded query forces server to wait for responce, and one query can take significant time to execute (more than 1 second). So if you have for example 20 players, your server will hang up for long time after map end, because this event force all players to reconnect to server again after map changed.

[Kubad]

yeah i found already but thank you

[shavit]

You can perform SQL injection using this.
When processing any user input, you should escape it. Look up SQL_EscapeString, escape the name and make sure the SteamID is valid (GetClientAuthId returns true if it is).