cromctf.com

CROM - Quake3 Community
It is currently Tue Apr 24, 2018 10:03 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: Sun Oct 22, 2017 3:33 am 
Offline

Joined: Thu Jun 16, 2011 1:14 pm
Posts: 30
Hey guys,

We'd like to set up voodoo stats on our q3 osp ictf server, but having a hard time with it due to older php code mostly. Our host is running mysql and php7. If anyone has any experience with this, maybe updated vsp php files/configs.. we'd appreciate any pointers you may have.
Thanks,

Dec


Top
 Profile  
 
PostPosted: Sun Oct 22, 2017 12:25 pm 
Offline

Joined: Mon Nov 24, 2014 7:35 pm
Posts: 259
A couple of years ago on my clan server I was able to modify voodoostats and get it working properly. I've uploaded a copy of my files for you. I sent you a PM with the link.

If you still can't get it working, let me know and I'll upload it to my server and figure out what's wrong for you.


Top
 Profile  
 
PostPosted: Sat Oct 28, 2017 5:30 pm 
Offline

Joined: Mon Nov 24, 2014 7:35 pm
Posts: 259
I've been working on it in my spare time for you. Voodoostats is coded in an older version of PHP and as a result, much of it is deprecated.

I've been converting all of the database calls over to PDO - replacing the deprecated, insecure mysql_ functions.

There's a ton of small things, too. Like the .sql file has TYPE = MYISAM ; instead of the new ENGINE = MYISAM ;

It uses the deprecated <? a million times instead of the updated <?php


Top
 Profile  
 
PostPosted: Sun Oct 29, 2017 12:32 pm 
Offline

Joined: Thu Jun 16, 2011 1:14 pm
Posts: 30
Unum,

Thanks for all the work. It's really, really appreciated. We all miss obsessively looking over our voodoo stats, hoping our worst games didn't skew them too much :]


Top
 Profile  
 
PostPosted: Mon Jan 08, 2018 4:13 am 
Offline

Joined: Thu Jun 16, 2011 7:16 am
Posts: 322
Hey Unum,

Thanks for posting what needed to be done. I have picked this up and fixed a few other things and I do have the stats processor up and running. However, it does not seem to generate CTF related statistics such as "Best Flag Capper" etc. Looking at the sql queries, it is expecting Quake 3 to log the ctf related information to the games.log log file.
Are there some special server commands that need to be set for Quake 3 to log these things to the log file?

Also, accuracy stuff is missing but I read somewhere that setting g_autoaction to 16 should allow quake to start logging accuracy info to the log file.

-Dev!l

Update: Nevermind, there were still a couple of things that had to be ported over to the newer php/mysql syntax. Once that is done, everything is running smootly now.

_________________
/bind 7 "say yesyesyes"


Top
 Profile  
 
PostPosted: Thu Jan 11, 2018 11:26 pm 
Offline

Joined: Thu Jun 16, 2011 1:14 pm
Posts: 30
Running smoothly indeed. We're obsessing over q3 stats once again, just like old times heh. Thank you Dev :>
Thanks for your efforts as well Unum.

Dec


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


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 post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group