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

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


Post New Thread Reply   
 
Thread Tools Display Modes
mykey
Member
Join Date: Dec 2005
Location: UK
Old 09-07-2007 , 14:29   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #41

Quote:
Originally Posted by SeToY View Post
Mykey, can you tell me, how i can order the chart bx Most / lowest wins?

Edit2: and why i am not shown on this list? the database shows this:

Authid: Wins: last name:
STEAM_0:1:13217301 11 -=][NGG][=- SeToY
Php/mysql is not my strongpoint, I just slightly altered Styles's files. Hopefully he will be able to give you an answer, as far as I can see the results should already be ordered by wins.

@Styles:
Definitely keep this open, a lot of people want this. Myself included.
__________________
Gungame League Launches September 2007!
mykey is offline
bitchin
Junior Member
Join Date: Jul 2007
Old 09-07-2007 , 14:55   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #42

styles i thinks you should maintain this, with a stylesheet to make it look the part, i reckon it'll be pretty sweet, i always come back to check on this to see how it is progressing, keep up the good work
bitchin is offline
Styles
Veteran Member
Join Date: Jul 2004
Location: California
Old 09-08-2007 , 00:52   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #43

I might the reason I haven't is because I actually released something regardless it was crap but it is something. I am going to do a complete re-write. But I don't like how it has yet to be stickied but that other guys has and it doesn't even have a release.
Styles is offline
Send a message via AIM to Styles
SeToY
SourceMod Donor
Join Date: Jul 2006
Location: Germany
Old 09-08-2007 , 04:56   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #44

Quote:
Originally Posted by mykey View Post
Php/mysql is not my strongpoint, I just slightly altered Styles's files. Hopefully he will be able to give you an answer, as far as I can see the results should already be ordered by wins.

@Styles:
Definitely keep this open, a lot of people want this. Myself included.
but in the database there are more people listet.. with wins around 11 and 15... maybe i should delete the database?
__________________
Success is a lousy teacher. It seduces smart people into thinking they can't lose.
- Bill Gates

Quote:
Originally Posted by Hawk552
SeToY is a retard, scumbag and asshole and you shouldn't pretend that he isn't.
SeToY is offline
Podunk
Senior Member
Join Date: Nov 2005
Location: Florida
Old 09-10-2007 , 16:59   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #45

after using the one from the official site a couple months ago, i found it was much more efficient to just directly parse/sort the stats file with php.


Although, in some circumstances, this wont work

Code:
$lines = file("C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\hlds\cstrike\gungame.stats");
foreach($lines as $line){
    $split = explode("\t",$line);
    if ($split[1] > 9)
    {
        $record['wins'] = $split[1];
        $record['name'] = $split[2];
        $records[] = $record;
    }
}

for($a=0;$a<count($records);$a++){
    for($b=$a;$b<count($records);$b++){
        if ($records[$a]['wins']<$records[$b]['wins'])
        {
            $tmp = $records[$a];
            $records[$a] = $records[$b];
            $records[$b] = $tmp;
        }
    }
}
__________________
Check out my website at http://matthewmiller.info
Podunk is offline
Send a message via MSN to Podunk
Nofius
Member
Join Date: May 2005
Location: Mora || Dalarna
Old 09-21-2007 , 05:37   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #46

Im really confused about one thing

I have the sql plugin and updated my sql.cfg with db settings and they are correct. When restarting server it puts in new database structur as it should.
My gg stats file is filled with stats.. But it never update the database to me, have set it to update every map but it doesnt. My database is empty.

What could be wrong ?
__________________
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-21-2007 at 05:58.
Nofius is offline
Mordekay
Squirrel of Fortune
Join Date: Apr 2006
Location: Germany
Old 09-21-2007 , 07:29   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #47

The sql informations for gungame belong into the gungame.cfg afaik
__________________

Mordekay is offline
Nofius
Member
Join Date: May 2005
Location: Mora || Dalarna
Old 09-21-2007 , 09:13   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #48

So i should have it in the sql.cfg ?
Will try use it in gungame.cfg instead

// Nofius

EDIT: Well put the sql info in gungame.cfg but still my databse is empty... seems he is not sending in the stats from gungame stats file.

What could be wrong ?
And yes all database info is correct and server adress.
When i use the diffrent cvars in hlsw into the server it respons at it should be.
__________________
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-21-2007 at 09:47.
Nofius is offline
Mordekay
Squirrel of Fortune
Join Date: Apr 2006
Location: Germany
Old 09-21-2007 , 12:16   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #49

What is your setting for gg_stats_mode?
__________________

Mordekay is offline
Nofius
Member
Join Date: May 2005
Location: Mora || Dalarna
Old 09-21-2007 , 12:42   Re: [SQL] Web based stats - [Live View :: Released Version [1.2] Current Version: 1.2
Reply With Quote #50

2 or should it be something else ?
__________________
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
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 01:21.


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