[PHP] Nouse Web Tool Bundle V2.1

[nouseforname]

deleted link, nos same info is in first post

[jamie_macdonald]

*stickied*

As it's so awesome and usefull

[nouseforname]

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]

Hey Nouse,

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

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()); 

[Knutselmaaster]

Works like a charm, thanks Nouse!
http://www.racing.intenseclan.com/ranks/index-en.php

[shoei]

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?

[ccx]

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 :

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

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

ccx