Raised This Month: $12 Target: $400
 3% 

[SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2]


Post New Thread Reply   
 
Thread Tools Display Modes
Nofius
Member
Join Date: May 2005
Location: Mora || Dalarna
Old 09-21-2007 , 12:45   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #51

gg_stats_file "gungame.stats"
gg_stats_ip 0
gg_stats_prune 2592000
gg_stats_mode 2
gg_stats_winbonus 1.5

and this is in my gungame.cfg

gg_sql_host "DatabaseIP306"
gg_sql_user "*****_gungame"
gg_sql_pass "*****"
gg_sql_db "******_gungame"
gg_sql_table "gg_stats"
gg_sql_updaterate "1"
__________________
Amxx v1.8.1.3746 || Amxbans 5.0 || PTB 1.8b3
www.csgubbar.com
public.csgubbar.com:27015 + 7 more. Check HP!
Nofius is offline
Nofius
Member
Join Date: May 2005
Location: Mora || Dalarna
Old 09-22-2007 , 03:38   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #52

Ok, find out a problem with gg_sql_updaterate "1"
Doesnt work to have it to 1 but when I change to 3 it updated the Database...

Bug ? or what ?

EDIT: And it doesnt show all the players in the statspage. Only shoing ppl up to 2 wins but there is many other that got more wins. What could be the problem ?

Have also change this to 0 gg_stats_prune 2592000
__________________
Amxx v1.8.1.3746 || Amxbans 5.0 || PTB 1.8b3
www.csgubbar.com
public.csgubbar.com:27015 + 7 more. Check HP!

Last edited by Nofius; 09-22-2007 at 04:59.
Nofius is offline
Styles
Veteran Member
Join Date: Jul 2004
Location: California
Old 09-23-2007 , 01:24   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #53

gg_sql_host "DatabaseIP"
gg_sql_user "*****_gungame"
gg_sql_pass "*****"
gg_sql_db "******_gungame"
gg_sql_table "gg_stats"
gg_sql_updaterate "1"

NO PORT
Styles is offline
Send a message via AIM to Styles
Nofius
Member
Join Date: May 2005
Location: Mora || Dalarna
Old 09-23-2007 , 04:16   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #54

Doesnt matter if i use port or not, still not showing all ppl on the web page.
And all ppl are in the database structure
__________________
Amxx v1.8.1.3746 || Amxbans 5.0 || PTB 1.8b3
www.csgubbar.com
public.csgubbar.com:27015 + 7 more. Check HP!
Nofius is offline
Styles
Veteran Member
Join Date: Jul 2004
Location: California
Old 09-23-2007 , 11:59   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #55

Humm make sure your ports are forwarded. And fill out the info in config.cfg or w/e it is.
Styles is offline
Send a message via AIM to Styles
Nofius
Member
Join Date: May 2005
Location: Mora || Dalarna
Old 09-23-2007 , 13:41   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #56

Dude, all connections work alright and the data is sending to the database but it isnt SHOWING all players on the web. just ppl that have 2 kills or less... I have players with more then 2 kills in the database but it doesnt show them. So there is no problem with the connection or so.
__________________
Amxx v1.8.1.3746 || Amxbans 5.0 || PTB 1.8b3
www.csgubbar.com
public.csgubbar.com:27015 + 7 more. Check HP!
Nofius is offline
XxAvalanchexX
Veteran Member
Join Date: Oct 2004
Location: abort73.com
Old 09-23-2007 , 18:37   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #57

What is the code you are using to output the players on the website?
__________________
No longer around. Thanks your support, everyone! As always:
THIS ONES FOR YOU
3000 PTS
XxAvalanchexX is offline
Podunk
Senior Member
Join Date: Nov 2005
Location: Florida
Old 09-25-2007 , 12:32   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #58

Quote:
Originally Posted by XxAvalanchexX View Post
What is the code you are using to output the players on the website?
I made a solution for this as well.


It includes 3 different SQL Priority Queues / Pumps, the cvar export mod to GG base, and a "score pusher" to push them to sql



Please PM me if you want the code Avalanche
__________________
Check out my website at http://matthewmiller.info
Podunk is offline
Send a message via MSN to Podunk
RasterMan
Senior Member
Join Date: Mar 2004
Location: Luton, UK
Old 09-27-2007 , 12:25   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #59

Its nice to see people working together to solve a problem
__________________
RasterMan is offline
Send a message via MSN to RasterMan
Styles
Veteran Member
Join Date: Jul 2004
Location: California
Old 09-27-2007 , 21:34   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #60

Well hes not understanding that you have to have SQL On and run that file to put the data into the mysql database.
Styles is offline
Send a message via AIM to Styles
Reply



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 11:25.


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