[PHP] Nouse Web Tool Bundle V2.1

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:

Re: [PHP] Nouse Web Tool Bundle V2.1

Post by nouseforname » 30 Dec 2010 12:33

deleted link, nos same info is in first post
Last edited by nouseforname on 30 Dec 2010 15:59, edited 1 time in total.
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

jamie_macdonald
TM-Patrol
TM-Patrol
Posts: 1612
Joined: 10 Jul 2008 19:48
Owned TM-games: TMUF, TMNF, TMS
Manialink(s): ET
Location: London, UK
Contact:

Re: [PHP] Nouse Web Tool Bundle V2.1

Post by jamie_macdonald » 30 Dec 2010 15:29

*stickied*

As it's so awesome and usefull :thumbsup:

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: [PHP] Nouse Web Tool Bundle V2.1

Post by nouseforname » 30 Dec 2010 15:42

thanks, then i maybe move all into one thread only, cause i made two threads, one is in xaseco section, cause most of the scripts are made for xaseco database. :)
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

User avatar
Knutselmaaster
swift roadking
swift roadking
Posts: 692
Joined: 16 Feb 2007 01:40
Owned TM-games: TMO/TMN/TMNF/TMU
Manialink(s): intr
Location: Between DisneyLand and Paris
Contact:

Re: [PHP] Nouse Web Tool Bundle V2.1

Post by Knutselmaaster » 18 Jan 2011 15:38

Hey Nouse,

Very nice package indeed :thumbsup:
After an update of my servers debian, php and mysql i have an error in the ranks.php.

Code: Select all

Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in /blablablabla/ranks.php on line 131
I have no knowledge at all on how to implement this change, could you please help me out?
I tried to change $db) into $mysql) on line 131 but it gave me this:

Code: Select all

Warning: mysql_db_query() expects parameter 3 to be resource, null given in /blablablabla/ranks.php on line 131

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: [PHP] Nouse Web Tool Bundle V2.1

Post by nouseforname » 19 Jan 2011 16:33

Knutselmaaster wrote:

Code: Select all

Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in /blablablabla/ranks.php on line 131
change:

Code: Select all

	$result =  mysql_db_query($db_name, "SELECT players.Id, players.Login, players.Nickname, rs_rank.avg 
										FROM players 
										INNER JOIN rs_rank
										ON players.Id=rs_rank.playerID
										WHERE players.Login IN ('".implode("','",$logins)."') 
										ORDER BY rs_rank.avg", $db) OR die(mysql_error());
to:

Code: Select all

	mysql_select_db($db_name, $db);
	$result =  mysql_query("SELECT players.Id, players.Login, players.Nickname, rs_rank.avg 
										FROM players 
										INNER JOIN rs_rank
										ON players.Id=rs_rank.playerID
										WHERE players.Login IN ('".implode("','",$logins)."') 
										ORDER BY rs_rank.avg") OR die(mysql_error()); 
Owner of the Rookie servers and some more. :)
Rookies HP
My Project
Rookies Manialinkcolor>

User avatar
Knutselmaaster
swift roadking
swift roadking
Posts: 692
Joined: 16 Feb 2007 01:40
Owned TM-games: TMO/TMN/TMNF/TMU
Manialink(s): intr
Location: Between DisneyLand and Paris
Contact:

Re: [PHP] Nouse Web Tool Bundle V2.1

Post by Knutselmaaster » 22 Jan 2011 23:51


User avatar
shoei
wheelbarrow operator
wheelbarrow operator
Posts: 24
Joined: 18 Nov 2010 06:43
Owned TM-games: tmuf

Re: [PHP] Nouse Web Tool Bundle V2.1

Post by shoei » 10 Dec 2011 21:37

hello,
Your tool is very useful area but I can not make it work properly was
especially the chat log and control

I truly understands how to structure the servers in my home directory

is it possible to provide images to help with tutorials for beginners in debian?
Image
Image

ccx
sunday driver
sunday driver
Posts: 55
Joined: 07 Feb 2009 22:41
Owned TM-games: TMUF

Re: [PHP] Nouse Web Tool Bundle V2.1

Post by ccx » 15 Oct 2012 18:10

Hello,
About the cheaters times to be deleted from the data base : Nouse goes from "http://www.gamers.org/tmf/dedimania_blacklist.txt".
(Cool script, thanx ! :thumbsup: )

But : is it possible to detect cheats directly in SQL ??
(I noticed for example some cheated times like : Rs_times.checkpoints = '10, 10, 10, etc..' but this in not always so simple.)
Dedimania avoid to register cheated times... is it possible to have the way they compute that ? (A cheated time is register in the Dedi, then disappear some minutes later)

I tried a simple SQL like :

Code: Select all

Select      ChallengeId
From        Records
Where     Checkpoints > ' '
Group by  ChallengeId
Having      Avg(Score)/1000 - Min(Score)/1000 > Avg(Score)/3000
So it is supposed to detect if best time (Min) is 30% better than average time (Avg) for a map.. but that doesn't works fine : some hard maps are plaid in 30sec. by better players, and 5 min by others => Avg can be 2 minutes :[
Pity there is not the Author time in the DB :(
Maybe I could base a SQL statement upon my own times.. as I am no more a noob player :mrgreen:

Please any idea of scripting an SQL able to detect cheaters ?
Thx.

ccx

Post Reply