Can someone help...

[Mike Gaidin]

Or at least point me in the right direction. I'm looking for a hack that will post the newest member to my forum on a non-vB page.

[Admin]

Create a new PHP file, named newest.php for example, and put this in it:

PHP Code:

<?php

require('./global.php');
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];

?>

and change the path to global.php.
Now you can use SSI to include this page in your homepage.
Good luck!

[Mike Gaidin]

Great!!! Thanks!!

*runs off to try it*

[Mike Gaidin]

I tried it, but nothing shows up. It's just blank.

[auto]

PHP Code:

 <?php

require('./global.php');
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];

print "<a href='$bburl/member.php?s=$sessionhash&action=getinfo&userid=$newuserid'>$newusername</a>";
?>

Try that

[Mike Gaidin]

That worked perfectly! Thanks auto! Thanks FireFly!

[Admin]

LOL, I forgot to actually SHOW it!
You're welcome.