Login
    |

wheres the championship scores?
 
Post new topic   { POST_REPLY_TOPIC }    SKC MTA Server Forum Index -> General Chat
Previous topic :: Next topic  
Hitman
SKC Elite Member
Exceptionally fast DNS change award
User avatar

Joined: 25 Sep 2007
Posts: 2647
Location: Swansea, Wales


Posted: 04 Oct 2009, 07:04    Post subject: wheres the championship scores?

i'm assuming those on the front page aren't them, how can we check who's winning?
Top
Profile Send private message
AdiBoy
SKC Elite Member
Winner of Race championship May 2008Winner of Race championship June 20082nd place in Race championship March 2010Winner of Race championship April 20103rd place in Race championship May 20102nd place in Race championship September 20102nd place in Race championship October 2010
2nd place in Race championship January 20113rd place in Race championship February 2011
User avatar

Joined: 22 Sep 2007
Posts: 1995
Location: Home sweet home


Posted: 04 Oct 2009, 07:57    Post subject:

you can go in-game and to /top3 points
Top
Profile Send private message
Hitman
SKC Elite Member
Exceptionally fast DNS change award
User avatar

Joined: 25 Sep 2007
Posts: 2647
Location: Swansea, Wales


Posted: 04 Oct 2009, 08:08    Post subject:

there's no way of linking them to the site anymore?
Top
Profile Send private message
Hitman
SKC Elite Member
Exceptionally fast DNS change award
User avatar

Joined: 25 Sep 2007
Posts: 2647
Location: Swansea, Wales


Posted: 04 Oct 2009, 08:29    Post subject:

if its not possible, don't you think we should at least have a scoreboard on the front page, even if it has to be manually updated daily or something.. i would be willing to do that if the stats cannot be linked to the site
Top
Profile Send private message
Bagpuss
SKC Elite Member
User avatar

Joined: 19 Sep 2007
Posts: 1200
Location: NL


Posted: 04 Oct 2009, 09:55    Post subject:

Anything is possible, it's just taking the time to work out every kludge along the way. The most natural way to get the stats on the site is for the server to run MySQL to keep all it's stuff and for the site to read directly into that. But, apparently the MySQL module crashes the server, so that's not going to happen unless someone fixes it.

So, assuming that the scores are kept in a SQLite db, then we have to find a way to export that and pop it into the site's MySQL db, perhaps every 30 minutes (which basically was how the site was updated with the stats out of the old MTA:Race server, except the scripts used text files).
Top
Profile Send private message
AdiBoy
SKC Elite Member
Winner of Race championship May 2008Winner of Race championship June 20082nd place in Race championship March 2010Winner of Race championship April 20103rd place in Race championship May 20102nd place in Race championship September 20102nd place in Race championship October 2010
2nd place in Race championship January 20113rd place in Race championship February 2011
User avatar

Joined: 22 Sep 2007
Posts: 1995
Location: Home sweet home


Posted: 04 Oct 2009, 11:19    Post subject:

ye, no SQL modules work, all crash the server, dunno why..
there's also another way of doing this using php scripts, but i have to look into it; if any1 else wants to get his head into this here's the wiki: http://wiki.multitheftauto.com/wiki/Resource_Web_Access
Top
Profile Send private message
Display topics from previous: Sort by
Post new topic   { POST_REPLY_TOPIC }    SKC MTA Server Forum Index -> General Chat



Using mChat © phpBB3BBCodes.com
Powered by phpBB © 2001, 2005, 2007 phpBB Group
cron