*New User* Hack on Non-VB Page >> Help

[badmeetsevil-]

Okay, what I'm trying to do is get the New Username (latest signup) on a non-vb page. Here's the .php file I made:

PHP Code:


<?php

require("admin/config.php");

$dbclassname="admin/db_$dbservertype.php";
require($dbclassname);

$DB_site=new DB_Sql_vb;

$DB_site->appname="VBulletin";
$DB_site->appshortname="VBulletin (forum)";
$DB_site->database=$dbname;
$DB_site->server=$servername;
$DB_site->user=$dbusername;
$DB_site->password=$dbpassword;

$DB_site->connect();


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


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

?>

Instead, I get the

"There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience."

..error. What did I do wrong!?

[badmeetsevil-]

*bump*

[Admin]

I'd just save this file as newest.php or something like that:

PHP Code:

<?php

error_reporting(7);

require("./global.php");

$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user ORDER BY joindate DESC LIMIT 1");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];

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

?>

But anyway, your problem is that:
a) you're missing the 's in your query:

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

and b) where are you getting $numbersmembers[max] from? You need to use another query to get it:

PHP Code:

$numbersmembers=$DB_site->query_first('SELECT MAX(userid) AS max FROM user'); 


So your file should look like this:

PHP Code:

<?php

require("admin/config.php");

$dbclassname="admin/db_$dbservertype.php";
require($dbclassname);

$DB_site=new DB_Sql_vb;

$DB_site->appname="VBulletin";
$DB_site->appshortname="VBulletin (forum)";
$DB_site->database=$dbname;
$DB_site->server=$servername;
$DB_site->user=$dbusername;
$DB_site->password=$dbpassword;

$DB_site->connect();

$numbersmembers=$DB_site->query_first('SELECT 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'];


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

?>

[badmeetsevil-]

Wow dude! It works! Thanks a bunch man.

[Admin]

Hehe, no problem.