[DWard]

Show newest user in Signature Stats
This will show you how to display the newest user in your signature image

Open your signature.php file and Find:

	$totalonline = $numberregistered + $numberguest;

Below that, add:

// GETTING NEWEST USER
      
 	$newestuser = $DB_site->query("SELECT username FROM " . TABLE_PREFIX . "user AS user ORDER BY userid DESC LIMIT 1");
      	$nuser = mysql_result($newestuser,0);

Then your $output string should be a little like this (look for bold text):

$output = "MEMBERS: $numbermembers THREADS: $totalthreads POSTS: $totalposts ONLINE: $totalonline NEWEST USER: $nuser";

If you have any problems, just reply in this thread