[Velocd]

A small tip that might save you a query. By looking at your code, it would seem if the new member has not made a post, then an extra query is being called anyway just to check. This can be avoided though.

In index.php replace:

PHP Code:

$getnewestusers=$DB_site->query_first("SELECT userid,username,posts FROM user WHERE userid=$numbersmembers[max]"); 


With:

PHP Code:

$getnewestusers=$DB_site->query_first("SELECT userid,username,posts,lastpost FROM user WHERE userid=$numbersmembers[max]"); 


Now in Link14716 hack, replace:

PHP Code:

$getnewusersposts=$DB_site->query_first("SELECT * FROM post WHERE userid=$newuserid LIMIT 1"); 
 $userfirstpost=$getnewusersposts['postid']; 
 
 if (!$getnewusersposts) {
 $firstpost="";
 } else {
 $firstpost=" | <a href='showthread.php?postid=$userfirstpost#post$userfirstpost'>First Post!</a>";
 } 


With:

PHP Code:

if(getnewestusers['lastpost'] != 0){
$getnewusersposts=$DB_site->query_first("SELECT * FROM post WHERE userid=$newuserid LIMIT 1"); 
 $userfirstpost=$getnewusersposts['postid']; 
 
 if (!$getnewusersposts) {
 $firstpost="";
 } else {
 $firstpost=" | <a href='showthread.php?postid=$userfirstpost#post$userfirstpost'>First Post!</a>";
 }
} 


This is untested, but should work