[AcidoX]

Hi there, i have a problem with GG SQL stats. I have changed the user/pw/db in the .sma file, also i have changed cvRate = register_cvar("gg_sql_updaterate","1"); from 3, my gungame.cfg

; GunGame AMXX 2.11c

// basic cvars
gg_enabled 1
gg_vote_setting 2
gg_vote_custom ""
gg_changelevel_custom ""
gg_map_setup "sv_alltalk 0; mp_chattime 10"
gg_endmap_setup ""
gg_join_msg 1
gg_colored_messages 1
gg_save_temp 300
gg_status_display 1
gg_map_iterations 1
gg_ignore_bots 0
gg_block_equips 0
gg_leader_display 1
gg_leader_display_x -1.0
gg_leader_display_y 0.0
gg_allow_changeteam 2
gg_disable_money 1
gg_winner_motd 1
gg_afk_protection 0

// autovote cvars
gg_autovote_rounds 0
gg_autovote_delay 8.0
gg_autovote_ratio 0.51
gg_autovote_time 10.0

// stats cvars
gg_stats_file "gungame.stats"
gg_stats_ip 1
gg_stats_prune 0
gg_stats_mode 2
gg_stats_winbonus 1.5

// deathmatch cvars
gg_dm 1
gg_dm_sp_time 1.0
gg_dm_sp_mode 1
gg_dm_spawn_random 2
gg_dm_start_random 1
gg_dm_spawn_delay 3.0
gg_dm_spawn_afterplant 1
gg_dm_corpses 0
gg_dm_countdown 2

// objective cvars
gg_block_objectives 0
gg_bomb_defuse_lvl 1
gg_host_touch_reward 0
gg_host_rescue_reward 0
gg_host_kill_reward 0
gg_host_kill_penalty 0

// teamplay cvars
gg_teamplay 0
gg_teamplay_melee_mod 0.33
gg_teamplay_nade_mod 0.50
gg_teamplay_timeratio 1

// gameplay cvars
gg_ff_auto 1
gg_weapon_order "glock18,usp,p228,deagle,fiveseven,elite,m3,xm1014,tmp,mac10,mp5navy,ump45,p90,galil,famas,ak47,scout,m4a1,sg552,aug,m249,hegrenade,knife"
gg_max_lvl 3
gg_triple_on 0
gg_turbo 1
gg_knife_pro 1
gg_knife_elite 0
gg_suicide_penalty 1
gg_worldspawn_suicide 1
gg_pickup_others 0
gg_handicap_on 0
gg_top10_handicap 1
gg_warmup_timer_setting 60
gg_warmup_weapon "knife"
gg_warmup_multi 0
gg_nade_glock 1
gg_nade_smoke 0
gg_nade_flash 0
gg_extra_nades 1
gg_nade_refresh 5.0
gg_kills_per_lvl 3
gg_kills_botmod 1.0
gg_give_armor 100
gg_give_helmet 10
gg_ammo_amount 200
gg_refill_on_kill 1
gg_tk_penalty 1
gg_awp_oneshot 1
gg_bots_skipnade 0

// sound cvars
gg_sound_levelup "sound/gungame/smb3_powerup.wav"
gg_sound_leveldown "sound/gungame/smb3_powerdown.wav"
gg_sound_levelsteal "sound/gungame/smb3_1-up.wav"
gg_sound_nade "sound/gungame/nade_level.wav"
gg_sound_knife "sound/gungame/knife_level.wav"
gg_sound_welcome "sound/gungame/gungame2.wav"
gg_sound_triple "sound/gungame/smb_star.wav"
gg_sound_winner "media/Half-Life03.mp3;media/Half-Life08.mp3;media/Half-Life11.mp3;media/Half-Life17.mp3"
gg_sound_takenlead "sound/gungame/takenlead.wav"
gg_sound_tiedlead "sound/gungame/tiedlead.wav"
gg_sound_lostlead "sound/gungame/lostlead.wav"
gg_lead_sounds 0.8

// random weapon order cvars (leave blank to disable)
gg_weapon_order1 ""
gg_weapon_order2 ""
gg_weapon_order3 ""
gg_weapon_order4 ""
gg_weapon_order5 ""
gg_weapon_order6 ""
gg_weapon_order7 ""
gg_weapon_order8 ""
gg_weapon_order9 ""
gg_weapon_order10 ""

// valid weapon names for gg_weapon_order:
//
// ak47, aug, awp, deagle, elite, famas, fiveseven, g3sg1, galil, glock18, hegrenade, knife,
// m249, m3, m4a1, mac10, mp5navy, p228, p90, scout, sg550, sg552, tmp, ump45, usp, xm1014

Modules:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Put third party modules below here.              ;;
;; You can just list their names, without the _amxx ;;
;;  or file extension.                              ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; These modules will be auto-detected and loaded   ;;
;;  as needed.  You do not need to enable them here ;;
;;  unless you have problems.                       ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;fun
;engine
fakemeta
sockets
nvault
cstrike
;csx
;mysql

Plugins:

          [ 18] GunGame AMXX            2.11c       Avalanche         gungame.amxx     running  
          [ 19] GunGameSQL              1.04        Avalanche         gungame_sql.amx  running

And the problem is like this... It makes new table in the DB, but the table is empty, but the gungame.stats file is like this:

78.61.25.15:27005    0    S O M I C    1225359833    16
88.196.42.251:27005    0    Marco    1225358428    16
88.216.138.10:27005    0    robis    1225360841    15
62.212.206.72:27005    0    Ganjabas    1225357770    1
88.118.98.208:27005    2    vafalamej    1225370299    90
84.32.77.127:27005    0    InvektruM*    1225357770    9
78.57.181.118:50861    0    [nero]AURIs~    1225359833    16
78.60.110.163:62683    0    DirtyBo    1225359833    22
89.117.47.85:27005    0    STAR_TM=ImorTal_desTroyer    1225358428    10
83.131.228.240:49224    0    WIDRA [cro]    1225357770    7
78.59.7.250:63840    0    Energy drink    1225358428    15
89.235.203.34:27005    0    -=BeTeP=-[EST]    1225362791    54
62.80.224.195:27005    1    Yep thats me.    1225358428    49
78.62.25.59:27005    0    GrieNius    1225371682    36
78.57.107.196:27005    0    SkZ4~    1225358428    11
85.206.5.34:61922    0    death_row    1225358428    12
212.122.91.23:27005    0    AC/CD    1225360841    24
78.59.148.145:27005    1    as    1225366826    74
78.60.141.163:27005    0    HeAdShOt_LT    1225365635    73
78.62.18.143:27005    0    F2gs*UnFeR    1225359833    32
78.60.70.90:27005    0    FBI    1225365635    45
78.59.205.247:27005    0    So Easy    1225359833    28
78.60.70.90:1024    0    bombinis    1225365635    14
88.222.128.48:27005    0    nI    1225361664    39
78.58.252.229:27005    0    Future    1225359833    18
193.219.150.197:27005    2    613|Cili Sriuba    1225363881    92
84.32.124.193:27005    0    botas    1225359833    1
88.222.53.40:27005    0    kei    1225360841    24
88.222.155.134:27005    0    azet    1225360841    10
88.223.53.44:38328    2    byt    1225363881    111
88.222.201.171:27005    0    .Vy*    1225360841    6
212.122.75.184:24565    0    unnamed    1225361664    5
89.190.101.48:27005    0    Jah    1225362791    40
78.59.222.66:54075    0    shi'ar    1225362791    9
78.92.148.226:27005    0    Dj Nagy    1225360841    2
78.59.150.239:57151    0    -=69=- Gecko    1225361664    15
80.243.16.54:27005    0    zipas    1225363881    29
88.222.228.11:27005    0    universal    1225361664    4
78.58.89.65:27005    0    gazuota varske    1225361664    2
88.222.124.171:2292    0    TwhlFp`    1225362791    1
84.32.252.137:27005    0    niaaam    1225365635    42
78.57.214.152:27005    0    F.u.C.k  Y.u.o  A.l.L    1225362791    4
84.52.38.254:27005    0    sashka    1225371682    56
217.147.33.216:27005    0    1    1225363881    12
88.223.36.99:1225    0    aLLonE    1225365635    28
195.182.78.186:27005    0    invisible    1225362791    1
213.252.225.29:27005    0    GoodSmoke    1225363881    11
78.31.225.91:27005    0    Paulius    1225369045    32
78.59.60.143:27005    0    SenT1neLL    1225363881    1
84.52.188.244:27005    0    Kostolomac    1225365635    7
89.223.25.101:27005    0    x3on    1225363881    7
78.62.77.152:27005    0    arnas    1225363881    9
80.243.29.73:27005    2    Kevalas    1225371682    149
86.100.66.109:27005    0    **_-Zackary-_**[e.W.o]    1225366826    10
88.118.75.112:27005    0    -biohard-    1225371682    67
84.32.51.84:38171    0    Houmeris    1225366826    29
78.58.90.193:27005    0    6:)w    1225365635    1
80.243.21.130:27005    0    nabasnikas    1225366826    35
84.32.51.84:38170    0    cover me    1225366826    11
84.32.220.17:27005    0    VaVi    1225369045    42
79.133.230.186:27005    0    TaG    1225368008    18
80.243.24.243:27005    1    bar0s    1225368008    51
80.243.24.125:27005    0    so kebabed ! evy    1225366826    21
84.240.30.5:27005    1    STONYS--metned    1225370299    100
78.60.217.12:42849    0    magic mrb^    1225366826    4
85.255.61.179:27005    0    B    1225369045    56
213.226.170.168:27005    0    Ievasas    1225370299    23
88.118.77.3:27005    0    niuxai    1225371682    43
78.60.93.51:27005    0    rublis    1225368008    6
87.110.0.8:27005    0    25-T-N-S    1225371682    37
83.234.227.15:53224    0    miks    1225368008    7
213.190.63.31:27005    0    -Standartas- 3H    1225369045    28
86.100.74.65:27535    0    My name is shliurka    1225371682    27
78.60.230.228:27005    0    micra    1225368008    5
88.222.217.201:27005    0    -=Stumikas=-    1225368008    4
78.60.192.23:27005    0    Titano    1225368008    4
84.32.200.187:27005    0    Jenny    1225371682    55
78.61.243.218:27005    0    mantoske#18    1225369045    2
85.232.150.11:27005    0    Arma    1225370299    22
80.243.29.135:27005    1    [Lietuva]Danas    1225371682    76
83.171.11.253:27005    0    petrys    1225369045    7
213.164.99.66:27005    0    O.o    1225371682    22
62.212.206.112:27005    0    //Ganjabas//    1225370299    1
217.77.23.222:27005    0    HaZarD    1225370299    2
85.29.232.177:27005    0    Kaif    1225370299    4
88.222.116.133:27005    0    pim pim    1225371682    17
78.60.217.12:61525    0    magic mrb^    1225370299    4
87.110.5.179:27005    0    lFELT*l Xcore    1225371682    19
78.59.163.48:27005    0    [sTr1ike]KvaKsiusXD    1225371682    11
86.100.90.26:27005    0    Prirukes | zutkas    1225371682    4
84.55.4.17:27005    0    [Cheater][FTB]De_Moon_As    1225371682    1
78.63.173.96:27005    0    Flagger    1225371682    7
89.190.116.69:27005    0    COUNTER-STRIKE 1.6    1225371682    6
89.190.107.221:27005    0    WAIDUKLIS    1225371682    18
78.60.217.12:34129    0    magic mrb^    1225371682    4

Pls help anyone Thnx in advance...

[AcidoX]

I find the problem. Because the SQL db table doesnt have IP field. Or maybe im wrong?

Suggestion: Avalanche, in the new GG version make a built in SQL stats mode & file too...

[XxAvalanchexX]

I would like to include a built-in SQL mode sometime. Are there any messages from gungame_sql.amxx in your regular AMXX logs? What do you mean that it doesn't have the IP field? It should use the authid column, even though you are using gg_stats_ip.

EDIT: Actually, there might be a bug with setting the update rate to 1. Try setting it to 0 or -1 and it should fix the problem.

[AcidoX]

Ok, i will try it. For the built-in SQL version, it would be nice to add to the SQL table the ip column, to write stats by id/ip

Edit: set to -1, will report if anything changes.

Edit2: everything is working ok, making GG stats http://cs.grigai.lt:150/gg/ please rate it

Edit3: Avalanche, maybe you can add in the Stats SQL version a column to log something like this:

ID/IP lastname wins points, serverip i think not needed, and another table to log something like this:
gg_mapstats
de_dust2 AciD 10 1

10 - points 1 - wins, to log how many wins/points player scores on that map, then maybe i could make a statistic non kz, but to a gg something like this http://igtu.sytes.net/kz/ please comment my idea

[AcidoX]

Well? Why doesnt anybody comment my ideas?

[XxAvalanchexX]

I see why you might want something like gg_mapstats, but I think that in the end it would be utilized by very few people, so it's likely not something that I would include in an official release.

[AcidoX]

Hm...

[DaxMan]

Originally Posted by AcidoX Hm...

AcidoX, can you share your stats file ?

/DaxMan

[SeToY]

I like your idea

[AcidoX]

Well, maybe if Avalanche agree, and i would optimize the code, it could be the official GunGame Stats, because i made /top15 & /rank plugin too.