Need help in the reportlist and banlist

[Kid_Buu]

Hi, I have the commands /reportlist and /banlist but they have an error.
What happens is only shows a single report or a ban, could someone help me?

[Mahmoud Tornado]

Hi, I have the commands /reportlist and /banlist but they have an error.
What happens is only shows a single report or a ban, could someone help me?

May you forget this.

Code Select Expand

local q = QuerySQL( Ban, "SELECT * FROM BannedPlayers" ), i = 0;  // Change it to your ban database
 while( GetSQLColumnData( q, 0 ) )
 {
  local
   Name = GetSQLColumnData( q, 0 ),
   Reason = GetSQLColumnData( q, 2 );   //Delete it if you don't have reason.
   MessagePlayer("[#00de00]Banned: [#fbf3f3]"+Name+", Reason: "+Reason+".",player);
  GetSQLNextRow( q );
  i++;
 }