[PHP] Nouse Web Tool Bundle V2.1
Moderators: Pit Crew, TM-Patrol
-
- 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
deleted link, nos same info is in first post
Last edited by nouseforname on 30 Dec 2010 15:59, edited 1 time in total.
-
- 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
*stickied*
As it's so awesome and usefull
As it's so awesome and usefull

-
- 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
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. 

- Knutselmaaster
- 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
Hey Nouse,
Very nice package indeed
After an update of my servers debian, php and mysql i have an error in the ranks.php.
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:
Very nice package indeed

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 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
-
- 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
change: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
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());
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());
- Knutselmaaster
- 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
Works like a charm, thanks Nouse!
http://www.racing.intenseclan.com/ranks/index-en.php
http://www.racing.intenseclan.com/ranks/index-en.php
Re: [PHP] Nouse Web Tool Bundle V2.1
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?
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?
Re: [PHP] Nouse Web Tool Bundle V2.1
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 !
)
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 :
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
Please any idea of scripting an SQL able to detect cheaters ?
Thx.
ccx
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 !

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
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

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