Website: Prune Tracks 2.1 (X)Aseco [php/mysql]

This is the place where you can find everything related to the dedicated server, control scripts and community tools.

Moderators: Pit Crew, TM-Patrol

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Website: Prune Tracks 2.1 (X)Aseco [php/mysql]

Post by nouseforname » 19 Jan 2009 12:32


  • Prunetracks.php

  • Update to Website:
  • I modified the whole script to a webpage now.
    you have to input the path to your matchsettings file and choose the server. than you will get a list of tracks which are not in matchsettings anymore. now you could mark tracks if you want to keep them in database. then click "prune tracks" to delete all data. then the option to "optimize your database" will appear.

    may you need to configure your webservers "open_basedir" function to get it working.

    Update version 2.1:
    • - Fixed errors in markup and css, now page is W3 valid
      - no change in config and function


    Update version 2.0:
    • - added standard path for matchsettings file in config
      - now all tracks are checked after track list appears, this will avoid to delete some data accidently

      - added seperate pack with password security for those who want it

      hope you'll like the improvement.

      Nouse web tools
  • copy the files to your webserver
  • configure all necessary items in config.php.
  • call "prunetracks.php" in your webbrowser.
  • enjoy

    the download package includes:
  • prunetrack.php
  • dbopt.php
  • config.php
  • classes/tmfcolorparser.inc

    thanks to f*ckfish for his help.
  • ------------------------------------------------------

    i'll keep the old version for those who wanna have only the script.

    is a script to delete older tracks from database.
    It compares matchsettings challenge entrys with database challenge entrys. All challenges which are NOT in matchsettings will be deleted from table "challenges", "records", "rs_times" and "rs_karma".
    This will be useful specially for older databases with lots of tracks. The display of statspage will be more actual and using rcp database is easier, at least my opinion. :)
    I tested it quite good at several databases and i hope it will be useful for somebody. pls let me know your opinion about.
    don't forget this is just the second script i wrote but i think my style improved already a bit. :)

    You have to configure the matchsettings path and the database connection before using it.
    Due to a little difference in column name between Xaseco and Aseco, Aseco users have to change that name in line ~87.

    Pls read the information inside the file first.

    It could be executed in console or as webpage. Tested at windows and Linux. After using i suggest to use the optimize function eg. in phpmyqdmin or at my "cheatrec delete page"

    I recommend to make a backup of your database before.
Last edited by nouseforname on 27 Apr 2011 14:49, edited 14 times in total.
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

Pesky
smooth traffic navigator
smooth traffic navigator
Posts: 262
Joined: 19 Mar 2008 16:25
Owned TM-games: TMN, TMUF
Manialink(s): rrmania
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by Pesky » 19 Jan 2009 12:49

Nice :thumbsup:

But doesnt it affect the Server-Rank directly?

Now your Server-Rank is calculated even with already deleted maps because they are still in the Database. Or am i wrong?

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by nouseforname » 19 Jan 2009 13:00

Pesky wrote:Nice :thumbsup:

But doesnt it affect the Server-Rank directly?

Now your Server-Rank is calculated even with already deleted maps because they are still in the Database. Or am i wrong?
that wouldn't be fair to "new" players. they never would have a chance to get server rank top.
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

Pesky
smooth traffic navigator
smooth traffic navigator
Posts: 262
Joined: 19 Mar 2008 16:25
Owned TM-games: TMN, TMUF
Manialink(s): rrmania
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by Pesky » 19 Jan 2009 13:11

I agree with you there. But afaik only Mistral Aseco clears the database so your Rank Value changes. XAseco doesnt, or am i wrong? In this case your script is very useful. Thx for it.

TripleT
smooth traffic navigator
smooth traffic navigator
Posts: 193
Joined: 12 Feb 2008 15:14
Owned TM-games: TMNF
Location: Germany

Re: Prune Tracks (X)Aseco [php/mysql]

Post by TripleT » 19 Jan 2009 15:33

first of all thanks for this script it is very useful! But isn't it like Pesky sayed?

Pesky
smooth traffic navigator
smooth traffic navigator
Posts: 262
Joined: 19 Mar 2008 16:25
Owned TM-games: TMN, TMUF
Manialink(s): rrmania
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by Pesky » 19 Jan 2009 16:46

maybe Xymph can say something about it if the Rank is calculated including deleted Maps. Would be interesting

Xymph
Pit Crew
Pit Crew
Posts: 5719
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by Xymph » 19 Jan 2009 17:44

Pesky wrote:But doesnt it affect the Server-Rank directly?

Now your Server-Rank is calculated even with already deleted maps because they are still in the Database. Or am i wrong?
Ranks are computed using only those tracks that are active on the server (ie. in the matchsettings file plus later additions), not on all the ones that are in the database. So pruning shouldn't affect the ranks.
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

Pesky
smooth traffic navigator
smooth traffic navigator
Posts: 262
Joined: 19 Mar 2008 16:25
Owned TM-games: TMN, TMUF
Manialink(s): rrmania
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by Pesky » 19 Jan 2009 18:25

Thx for the Info :)

TripleT
smooth traffic navigator
smooth traffic navigator
Posts: 193
Joined: 12 Feb 2008 15:14
Owned TM-games: TMNF
Location: Germany

Re: Prune Tracks (X)Aseco [php/mysql]

Post by TripleT » 20 Jan 2009 13:54

that is great to hear then this is a great script nouseforname (lol i realize that this is the first time i write your name though i have seen you so many times on this forum :roflol: )

User avatar
jimos94
happy cruiser
happy cruiser
Posts: 122
Joined: 06 Jan 2007 22:52
Owned TM-games: TMUF
Manialink(s): fun
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by jimos94 » 23 Jan 2009 14:42

:thumbsup: GooD JoB :thumbsup:
http://www.tm-planet.net/ Server hosting, Interviews, Events and more :)

nocturne
solid chaser
solid chaser
Posts: 1390
Joined: 08 Jun 2007 18:48
Owned TM-games: all
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by nocturne » 24 Jan 2009 22:55

Kind of nifty... It'd be great to try, but unfortunately there's a few removed tracks I need to save the recs for -- the regs get really serious about their recs if a track ends up coming back.

Would be great to make it into a web interface like your other script, that way tracks could be checked first before removal, or even just just a space in the config section to set a trackID/challengeID 'whitelist'.

DB's getting too big as it is... An SQL dump nowadays is weighing in at over 2.5 million lines and 200mb.... :roflol:

TripleT
smooth traffic navigator
smooth traffic navigator
Posts: 193
Joined: 12 Feb 2008 15:14
Owned TM-games: TMNF
Location: Germany

Re: Prune Tracks (X)Aseco [php/mysql]

Post by TripleT » 28 Jan 2009 10:17

afaik you can delete seperate tracks with their recs in rcp4 but im am not quite sure

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Re: Prune Tracks (X)Aseco [php/mysql]

Post by nouseforname » 28 Jan 2009 10:56

nocturne wrote: Would be great to make it into a web interface like your other script, that way tracks could be checked first before removal, or even just just a space in the config section to set a trackID/challengeID 'whitelist'.
i'll think about. but i am uite buisy right now with other things.
also planned to update the other script too.
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

nouseforname
swift roadking
swift roadking
Posts: 840
Joined: 20 Apr 2008 08:58
Owned TM-games: TMUF,TMNF, TMN
Manialink(s): therookies
Location: Germany
Contact:

Re: (X)Aseco Website Prune Tracks [php/mysql]

Post by nouseforname » 18 Feb 2009 19:40

Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

User avatar
Ant
TM-Patrol
TM-Patrol
Posts: 1845
Joined: 01 Dec 2007 17:04
Owned TM-games: TMN, TMUF, TM Wii
Location: London, England
Contact:

Re: Website: Prune Tracks (X)Aseco [php/mysql]

Post by Ant » 19 Feb 2009 03:32

Sounds very useful - i'll give it a go :thumbsup:

EDIT: I tried this out but the webpage script finds 11 tracks when I press view, and i'm sure some of them are still in my tracklist :ftw:

Post Reply