FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
HL Query with MySQL (no ActivePerl)

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    The Ville.org Half-Life Gaming Community Forum Index -> F-A-Q
View previous topic :: View next topic  
Author Message
Hosway[CJP]
Registered User


Joined: 18 Aug 2002
Location: Deltona, FL
Posts: 483

PostPosted: Fri Sep 05, 2003 2:45 pm    Post subject: HL Query with MySQL (no ActivePerl) Reply with quote

Ok, before i was looking for a stats script with no MySQL as database, which i believe rob told me to get psychostats (required activeperl). Worked well n' all but now i'm looking for a script that is only backened by MySQL and nothing else. So if anyone knows where I can get such script, please let me know. If not, its k00.
_________________

---
Hosway[CJP] is now Doppelgangster.
Come, let's talk with swords!
Back to top
View user's profile Send private message Visit poster's website AIM Address
OpTlk
Registered User


Joined: 27 Apr 2002
Location: San Diego, CA Guild:=US-V=
Posts: 2176

PostPosted: Fri Sep 05, 2003 2:53 pm    Post subject: Reply with quote

I may be reading your post incorrectly...but doesnt HLStats save into a MySQL db? why not use that? --> hlstats.org
_________________

http://www.myspace.com/pvallone
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
Robert E. Lee
Registered User


Joined: 18 Jul 2001

Posts: 2904

PostPosted: Fri Sep 05, 2003 3:00 pm    Post subject: Reply with quote

Hlstats uses Mysql to store the stats and Perl to collect them.
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Warhammer
Server Admin
Server Admin


Joined: 12 Aug 2001
Location: Atlantuh, Jawjuh
Posts: 1226

PostPosted: Fri Sep 05, 2003 5:41 pm    Post subject: Reply with quote

MySQL is a database server - all it will do is store the data that HLStats sends it. You'll need something else to make web pages out of it, like Perl, ASP, or PHP. Most of the packaged HL stats systems will be based around Perl or PHP.
_________________
Support wildlife. Throw a party!
Back to top
View user's profile Send private message Send e-mail AIM Address
Hosway[CJP]
Registered User


Joined: 18 Aug 2002
Location: Deltona, FL
Posts: 483

PostPosted: Tue Sep 09, 2003 2:09 pm    Post subject: Reply with quote

Warhammer wrote:
MySQL is a database server - all it will do is store the data that HLStats sends it. You'll need something else to make web pages out of it, like Perl, ASP, or PHP. Most of the packaged HL stats systems will be based around Perl or PHP.


Does MySQL store hlstats automatically?? Don't i need like an adminmod script in order to do that??

Ok, so I need some sort of PHP Script that will gather the stats and display them as a (Probably HTML template) web page. How/Where do I get that?

Sorry for the confusion

PS: I tried the hlstats.org but tthe page wouldn't display ( ) but will keep trying
_________________

---
Hosway[CJP] is now Doppelgangster.
Come, let's talk with swords!
Back to top
View user's profile Send private message Visit poster's website AIM Address
Robert E. Lee
Registered User


Joined: 18 Jul 2001

Posts: 2904

PostPosted: Tue Sep 09, 2003 9:30 pm    Post subject: Reply with quote

Here's what happens.. In the servers autoexec.cfg you add a line called logaddress, you point that IP address and port to your webserver to collect the stats.. like this..

Code:

logaddress 192.168.1.20 27500


Then you run hlstats.pl which is a perl script to collect the incoming server data and it put it in the database for storage. All of the appropriate scripts and instructions are in the hlstats zip file thats located here.

http://sourceforge.net/project/showfiles.php?group_id=20371
_________________
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    The Ville.org Half-Life Gaming Community Forum Index -> F-A-Q All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group