AlliedModders - View Single Post - [solved] Sql-problem with stats and bots

Mordekay · **Author**

I'm getting this error on every map change:

Code:

L 01/26/2021 - 18:52:56: [gungame.amxx] Could not execute query [INSERT INTO `gg_stats` (authid,name,timestamp,wins,points,streak,serverip) VALUES ('BOT','Deadlynome','1611683576','0','21','0','89.163.190.40:27515'),('BOT','Firestorm','1611683576','0','21','0','89.163.190.40:27515'),('BOT','bussemann','1611683576','0',] -- err #1062 [Duplicate entry 'BOT-89.163.190.40:27515' for key 'PRIMARY']

status

meta list

amxx list

Code:

18:58:27 Currently loaded plugins:
                name                    version     author            file             status   
          [  1] AMXBans Core            6.13        YamiKaitou        amxbans_core.am  running  
          [  2] AMXBans Main            6.13        YamiKaitou        amxbans_main.am  running  
          [  3] Admin Commands          1.9.0.5235  AMXX Dev Team     admincmd.amxx    running  
          [  4] Admin Help              1.9.0.5235  AMXX Dev Team     adminhelp.amxx   running  
          [  5] Slots Reservation       1.9.0.5235  AMXX Dev Team     adminslots.amxx  running  
          [  6] Multi-Lingual System    1.9.0.5235  AMXX Dev Team     multilingual.am  running  
          [  7] Menus Front-End         1.9.0.5235  AMXX Dev Team     menufront.amxx   running  
          [  8] Commands Menu           1.9.0.5235  AMXX Dev Team     cmdmenu.amxx     running  
          [  9] Players Menu            1.9.0.5235  AMXX Dev Team     plmenu.amxx      running  
          [ 10] Maps Menu               1.9.0.5235  AMXX Dev Team     mapsmenu.amxx    running  
          [ 11] Plugin Menu             1.9.0.5235  AMXX Dev Team     pluginmenu.amxx  running  
          [ 12] Admin Chat              1.9.0.5235  AMXX Dev Team     adminchat.amxx   running  
          [ 13] Anti Flood              1.9.0.5235  AMXX Dev Team     antiflood.amxx   running  
          [ 14] Scrolling Message       1.9.0.5235  AMXX Dev Team     scrollmsg.amxx   running  
18:58:27  [ 15] Info. Messages          1.9.0.5235  AMXX Dev Team     imessage.amxx    running  
          [ 16] Admin Votes             1.9.0.5235  AMXX Dev Team     adminvote.amxx   running  
          [ 17] Nextmap Chooser         1.9.0.5235  AMXX Dev Team     mapchooser.amxx  running  
          [ 18] TimeLeft                1.9.0.5235  AMXX Dev Team     timeleft.amxx    running  
          [ 19] Pause Plugins           1.9.0.5235  AMXX Dev Team     pausecfg.amxx    running  
          [ 20] Stats Configuration     1.9.0.5235  AMXX Dev Team     statscfg.amxx    running  
          [ 21] StatsX                  1.9.0.5235  AMXX Dev Team     statsx.amxx      running  
          [ 22] CS Misc. Stats          1.9.0.5235  AMXX Dev Team     miscstats.amxx   debug    
          [ 23] CS Stats Logging        1.9.0.5235  AMXX Dev Team     stats_logging.a  running  
          [ 24] Anti Silent-run         1.2         Numb              antisilentrun.a  running  
          [ 25] Lame Connection Punish  1.2         MeRcyLeZZ         lame_connection  running  
          [ 26] Files Check             1.0         ConnorMcLeod      filescheck.amxx  running  
          [ 27] GunGame AMXX            2.13c       Avalanche         gungame.amxx     running  
          [ 28] HLstatsX CE Ingame Plu  1.6.19 (HL  psychonic         hlstatsx_comman  running  
          [ 29] Ultimate Gore           1.6         JTP10181          amx_gore_ultima  running  
18:58:27  [ 30] VAC Ban Status          0.4         bugsy             vacbans.amxx     running  
          [ 31] AMXBans Flagged         6.13        YamiKaitou        amxbans_freeze.  running  
          [ 32] AMXBans Flagged         6.13        YamiKaitou        amxbans_flagged  running  
         32 plugins, 32 running

I'm using the original gungame 2.13c except added 2 letters in client_disconnected-funktion to prevent the warning.