Raised This Month: $159 Target: $400
 39% 

[RESOLVED] GunGame SQL problem


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Balage74
Member
Join Date: Dec 2006
Old 03-19-2007 , 20:12   [RESOLVED] GunGame SQL problem
Reply With Quote #1

Hello XxAvalanchexX!
first: thank you this plugin (gungame_sql+gungame plugin)
My problem, the sql plugin make a gg_stats tab in my sql server, but no upload the data... (this is not very big problem, I think, the next versions I will do set the sql)

my gungame cfg:
//1.15


// basic cvars
gg_enabled 1
gg_vote_setting 2
gg_vote_custom ""
gg_changelevel_custom ""
gg_map_setup "mp_timelimit 45; mp_winlimit 0; sv_alltalk 1; mp_chattime 10; mp_c4timer 35;mp_flashlight 1;mp_freezetime 2"
gg_join_msg 1
gg_colored_messages 1
gg_save_temp 300
gg_status_display 0
gg_map_iterations 1

// stats cvars
gg_stats_file "gungame.stats"
gg_stats_ip 0
gg_stats_prune 0
gg_stats_mode 1
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 0
gg_dm_start_random 1
gg_dm_spawn_delay 1.5
gg_dm_spawn_afterplant 1
gg_dm_corpses 1
gg_dm_countdown 0

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

// gameplay cvars
gg_ff_auto 1
gg_weapon_order "glock18,usp,p228,deagle,fiveseven,elite,m3,x m1014,tmp,mac10,mp5navy,ump45,p90,galil,famas ,ak47,scout,m4a1,sg552,sg550,aug,m249,hegrena de,knife"
gg_max_lvl 3
gg_triple_on 0
gg_turbo 1
gg_knife_pro 1
gg_worldspawn_suicide 1
gg_allow_changeteam 1
gg_pickup_others 1
gg_handicap_on 1
gg_top10_handicap 1
gg_warmup_timer_setting 30
gg_knife_warmup 1
gg_warmup_multi 0
gg_nade_glock 1
gg_nade_smoke 1
gg_nade_flash 1
gg_extra_nades 1
gg_kills_per_lvl 1
gg_give_armor 100
gg_give_helmet 1
gg_ammo_amount 200
gg_refill_on_kill 1
gg_tk_penalty 0
gg_awp_oneshot 1

// sound cvars
gg_sound_levelup "gungame/smb3_powerup.wav"
gg_sound_leveldown "gungame/smb3_powerdown.wav"
gg_sound_nade "gungame/nade_level.wav"
gg_sound_knife "gungame/knife_level.wav"
gg_sound_welcome "gungame/gungame2.wav"
gg_sound_triple "gungame/smb_star.wav"
gg_sound_winner "media/Half-Life08.mp3"

// 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 ""

//gungame

gg_sql_host "127.0.0.1"
gg_sql_user "***"
gg_sql_pass "******"
gg_sql_db "amx"
gg_sql_table "gg_stats"
gg_sql_updaterate 1


my plugins.ini:
; AMX Mod X plugins

; Admin Base - Always one has to be activated
;admin.amxx ; admin base (required for any admin-related)
admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

; Basic
admincmd.amxx ; basic admin console commands
adminhelp.amxx ; help command for admin console commands
adminslots.amxx ; slot reservation
multilingual.amxx ; Multi-Lingual management

; Menus
menufront.amxx ; front-end for admin menus
cmdmenu.amxx ; command menu (speech, settings)
plmenu.amxx ; players menu (kick, ban, client cmds.)
;telemenu.amxx ; teleport menu (Fun Module required!)
mapsmenu.amxx ; maps menu (vote, changelevel)

; Chat / Messages
adminchat.amxx ; console chat commands
antiflood.amxx ; prevent clients from chat-flooding the server
scrollmsg.amxx ; displays a scrolling message
imessage.amxx ; displays information messages
adminvote.amxx ; vote commands

; Map related
nextmap.amxx ; displays next map in mapcycle
mapchooser.amxx ; allows to vote for next map
timeleft.amxx ; displays time left on map

; Configuration
pausecfg.amxx ; allows to pause and unpause some plugins
statscfg.amxx ; allows to manage stats plugins via menu and commands

; Counter-Strike
restmenu.amxx ; restrict weapons menu
;statsx.amxx ; stats on death or round end (CSX Module required!)
;miscstats.amxx ; bunch of events announcement for Counter-Strike
;stats_logging.amxx ; weapons stats logging (CSX Module required!)

; Enable to use AMX Mod plugins
;amxmod_compat.amxx ; AMX Mod backwards compatibility layer

; Custom - Add 3rd party plugins here

sound_download_management.amxx
;ClientChecker.amxx
gungame.amxx //1.16b1
gungame_sql.amxx //1.02
atac.2.5.5.5.amxx
amxx_atac_cfg.1.1.09.amxx
;rate_manager.amx
;weaponarena.amxx
;clan_tag_checker.amxx
psrank3x.amxx
;amxbans.amxx
;admin_amxbans.amxx

what is the problem?

other request for gungame_sql stat for:
- how many "stole level" (knife kill)
- how many kills for weapons (remember my options:gg_pickup_others 1)
- how many friendly kill ( grenade level I killed the team member)
- how many level gained and level lost

I think, you very busy, but i very thanks your work, 'cause I like the gungame for 1.6.


(sorry my bad english, I'm from hungarian)

Last edited by XxAvalanchexX; 04-03-2007 at 17:26. Reason: marked resolved. author not responding.
Balage74 is offline
Send a message via MSN to Balage74 Send a message via Skype™ to Balage74
XxAvalanchexX
Veteran Member
Join Date: Oct 2004
Location: abort73.com
Old 03-19-2007 , 20:58   Re: GunGame SQL problem
Reply With Quote #2

Check your AMXx logs for reports from the plugin. It should always tell you something, whether it fails or succeeds. I don't have any plans to add extra stat tracking, because GunGame SQL takes the data from the gungame.stats file, and stat files are already too huge.
__________________
No longer around. Thanks your support, everyone! As always:
THIS ONES FOR YOU
3000 PTS
XxAvalanchexX is offline
Balage74
Member
Join Date: Dec 2006
Old 03-19-2007 , 21:21   Re: GunGame SQL problem
Reply With Quote #3

ok, I found the problem:
"L 03/16/2007 - 17:18:59: [gungame_sql.amxx] Could not connect to database. Error #2003: Can't connect to MySQL server on '127.0.0.1' (10061)
"
I will try define other sql_admin....
(admin_sql.amxx good working this admin user and password...)
thanks support.
Balage74 is offline
Send a message via MSN to Balage74 Send a message via Skype™ to Balage74
XxAvalanchexX
Veteran Member
Join Date: Oct 2004
Location: abort73.com
Old 03-23-2007 , 21:32   Re: GunGame SQL problem
Reply With Quote #4

Did you ever get this working?
__________________
No longer around. Thanks your support, everyone! As always:
THIS ONES FOR YOU
3000 PTS
XxAvalanchexX is offline
sandrucolazo
Junior Member
Join Date: Jun 2010
Old 12-05-2015 , 02:37   Re: GunGame SQL problem
Reply With Quote #5

Quote:
Originally Posted by Balage74 View Post
ok, I found the problem:
"L 03/16/2007 - 17:18:59: [gungame_sql.amxx] Could not connect to database. Error #2003: Can't connect to MySQL server on '127.0.0.1' (10061)
"
I will try define other sql_admin....
(admin_sql.amxx good working this admin user and password...)
thanks support.
Man, how did u resolve this problem?
Thanks a lot for the response.
sandrucolazo is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:42.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode