[RasterMan]

GunGame AMXX 2.13 Beta 4
Just managed to catch this error :

L 02/17/2011 - 15:40:25: Start of error session.
L 02/17/2011 - 15:40:25: Info (map "gg_dusty_fortress") (file "addons/amxmodx/logs/error_20110217.log")
L 02/17/2011 - 15:40:25: [AMXX] Displaying debug trace (plugin "gungame_with_sql.amxx")
L 02/17/2011 - 15:40:25: [AMXX] Run time error 4: index out of bounds
L 02/17/2011 - 15:40:25: [AMXX] [0] gungame_with_sql.sma::show_win_screen (line 6345)


[gungame_with_sql.amxx] Could not execute query [INSERT INTO `gg_winmotd` VALUES ('10','STEAM_0:1:11170595','^_^ Wester - [DK]','1','22','hegrenade','1','0','60','21','0', '0','49','439','0','1298033162','81.19.212.36 :27015');] -- err #1062 [Duplicate entry '10' for key 'PRIMARY']

[RasterMan]

I've gone back to beta 3 as beta 4 just crashes too much!
win2003rc2

[jarmenz]

If the gungame plugin inserts new record, its a high possibility that the plugin itselft wants to iterate the primary field. The database can handle it correctly. Try to find the INSERT statement in the gungame plugin and check if the inserted value for id field is emty, meaning - '' or null! And then compile the plugin.

[XxAvalanchexX]

Thanks for the report. I've fixed the out of bounds error, which probably led to the following SQL error.

Ava

[DeLsTer]

Could you post the fix? i have a heavily modified version and hate to go back to beta 3 and do all the modifications again

[XxAvalanchexX]

Sure.

Look for these lines in show_win_screen:

get_gg_authid(player,playerAuthid[player],31);
get_user_name(player,playerName[player],31);
            
// get new stats position
stats_clear_struct(playerStats[player]);
stats_get_position(player,playerAuthid[player],si);
            
SQL_QuoteString(db,playerSafeName[player],63,playerName[player]);
SQL_QuoteString(db,playerSafeAuthid[player],63,playerAuthid[player]);

len += formatex(motd[len],1535-len,"%s('%i','%s','%s','%i','%i','%s','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%s')",(len != origLen) ? "," : "",
    player,playerSafeAuthid[player],playerSafeName[player],team,level[player],lvlWeapon[player],flags,pointsExtraction[player][0],pointsExtraction[player][2],pointsExtraction[player][1],pointsExtraction[player][4],pointsExtraction[player][3],statsPosition[player][si],floatround(teamTimes[player][winningTeam-1]),floatround(teamTimes[player][losingTeam-1]),systime,serverip);

Change to this:

get_gg_authid(player,playerAuthid,31);
get_user_name(player,playerName,31);
            
// get new stats position
stats_clear_struct(playerStats[player]);
stats_get_position(player,playerAuthid,si);
            
SQL_QuoteString(db,playerSafeName,63,playerName);
SQL_QuoteString(db,playerSafeAuthid,63,playerAuthid);

len += formatex(motd[len],1535-len,"%s('%i','%s','%s','%i','%i','%s','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%s')",(len != origLen) ? "," : "",
    player,playerSafeAuthid,playerSafeName,team,level[player],lvlWeapon[player],flags,pointsExtraction[player][0],pointsExtraction[player][2],pointsExtraction[player][1],pointsExtraction[player][4],pointsExtraction[player][3],statsPosition[player][si],floatround(teamTimes[player][winningTeam-1]),floatround(teamTimes[player][losingTeam-1]),systime,serverip);

Ava