Data Loss

[Maxi605]

Sometimes when a player DC's or gets kicked by the server (Maybe banned) his data gets deleted when he rejoins, he has 1.000.000 points (Example) and when he gets in again, 0.

[GuskiS]

You mean karma saving thing? It is hard to understand this one.

[Maxi605]

No, i'm talking about the data that saves the server like your points, kills as T, kills as D, kills as I, etc.

[GuskiS]

They are called stats. Anyways, will check, but needs a bit more info.

[Maxi605]

Not much info on it, when a client DC's sometimes it looses the stats, when i used a anti-retry, the player gets kicked for doing retry and then is when the stats gets lost, he starts from zero, we fixed that and it worked but it seems to be another trigger for it or something

[GuskiS]

If you could do some sort of testing that could help.

Trouble-in-Terrorist-Town/scripting/ttt_stats_system.sma

Line 199 in 1ddd585

format(temp, charsmax(temp), "SELECT * FROM ttt_stats WHERE player_name = ^"%s^"", g_szPlayerName[id]);

before this line, add log_amx("TTT - MySQL_Load: %d == %s", id, g_szPlayerName[id])

=======================================

Trouble-in-Terrorist-Town/scripting/ttt_stats_system.sma

Line 230 in 1ddd585

if(SQL_NumResults(query) > 0)

before this line, add log_amx("TTT - MySQL_LoadData: %d == %s == %d", id, g_szPlayerName[id], SQL_NumResults(query))

=======================================

Trouble-in-Terrorist-Town/scripting/ttt_stats_system.sma

Line 379 in 1ddd585

format(temp, charsmax(temp), "INSERT INTO ttt_stats (player_name, gwk, kills_i, kills_d, kills_t, rdm, innocent, detective, traitor, bomb_planted, bomb_exploded, bomb_defused, total_points) VALUES (^"%s^", '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d');",

before this line, add log_amx("TTT - table_insert: %d == %s", id, g_szPlayerName[id], name) where name is get_user_name functions result.

[GuskiS]

Let me know if those results when something weird happens.
Also, do check if there are no duplicates in database for that player_name

[Maxi605]

Ok, i'll give upload it to the server.

[Maxi605]

The problem doesn't just happen with 1 name, it happens randomly (there's a trigger obviously) when the client attemps a conection to the server