[PHP] Bans table

[mpa]

Is it possible to do this in geisors aac?

http://eloth.mine.nu/index.php?action=bans

 

[EvulMastah]

mysql_connect("host", "user", "pass") or die ("Could not connect to MySQL Server.");
mysql_select_db("database") or die ("Could not select database.");

 

[christiandb]

thanks man could you have a look at my inquisition thread? I really dont know what to do

 

[mpa]

How can I make It order by time instead of level?

 

[EvulMastah]

It doesnt order by level, the level order is to get the highest leveled character from the banned account, anyways:

$query = mysql_query("SELECT * FROM bans ORDER BY expires DESC");

 

[mpa]

On what line should i put this? Sorry if im stupid but im in the roof now...
Edit: Could be good to have something like "If gm deleted don't show".

 

[EvulMastah]

Just replace this:

$query = mysql_query("SELECT * FROM bans");

to this one:

$query = mysql_query("SELECT * FROM bans ORDER BY expires DESC");

 

[mpa]

When a player is auto banned because of excessive unjustified player killing no gm has banned him. Can you make it so it shows Autobanned or something instead? And also if a player is deleted or gamemaster is deleted it should show "by deleted player" or "by deleted admin".
Only if you want, you have already made a great script.
Thank you for that!