Bravo List - Invites

Quote:

Originally Posted by Catralkid (Post 43974)

Hi,

Is there any way of getting a list of members for my site and how many invites that they have. V 7.2

Try this but it might not work

Code:

 


 include "include/ts_functions.php";



  if (isset($_GET["action"])){$lim = $_GET["action"];}else{$lim = "10";} 



$result = sql_query("SELECT * FROM users ORDER BY class DESC,invites LIMIT 10");



echo "






";


while($row = mysql_fetch_array($result))

  {

  echo "";

  echo "";

  echo "";

  echo "";

  echo "";

  echo "";

  echo "";

  }
Or try this


	Code:
	
 if (isset($_GET["action"])){$lim = $_GET["action"];}else{$lim = "10";}

 

$db=mysqli_connect("localhost","root","PASSWORD","DB_NAME");  

  $result = mysqli_query($db,"SELECT * FROM users ORDER BY class DESC,invites LIMIT $lim");



echo "


name
Registered
Last Login
Last Access
invite

" . $row['username'] . " " . $row['added'] . " " . $row['last_login'] . " " . $row['last_access'] . " " . $row['invites'] . "


















";



while($row = mysqli_fetch_array($result))

  {

  echo "";

  echo "";

  echo "";

  echo "";

  echo "";

  echo "";

  echo "";

  }

echo "name Registered Last Login Last Access invites
" . $row['username'] . " " . $row['added'] . " " . $row['last_login'] . " " . $row['last_access'] . " " . $row['invites'] . "
";


remember if you are going to use the second one, you will need to add your db info 



If you want more results then do the following..





	Code:
	
/filename.php?action=1000

and change the number to how many you wont all just add the TS7.2 pager function