How do i get the userid from the username?

[killervette]

The result for the script echos this "The userid for is ". I specify a username that exists case sensitive.

[assassingod]

It should still work if you replace

PHP Code:

require("./global.php"); 


with

PHP Code:

chdir("YOUR forum directoru");
require("./global.php"); 


[assassingod]

Originally Posted by killervette

The result for the script echos this "The userid for is ". I specify a username that exists case sensitive.

Recheck my script, I missed out a $. It works perfectly now, ive tested it

Sorry!

[killervette]

I put

chdir("/mainforum/");
require("./global.php");

i have the file in the root and my directory is mainforum

[Andreas]

The directory is REALLY /mainforum?
I doubt that ... except you are in a chroot-jail.
More likely it is smt.h like /var/htdocs/youraccount/html/mainforum

[Quarterbore]

I have a situation where I also need to convert a USERNAME from a template to a USERID inside a main php file....

I tried to use the code above in my file like this:

$getuser = $vbulletin->db->query("
 SELECT userid,username
 FROM myuser
 WHERE username = $username
");
$user = $DB_site->fetch_array($getuser);
echo("The userid for $user[username] is <b>$user[userid]</b>");

I know my post is getting the correct $username into this but I am getting a MYSQL error that says...

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT userid,username
FROM XXXXXXXXXX
WHERE username = Quarterbore;

MySQL Error : Unknown column 'Quarterbore' in 'where clause'
Error Number : 1054
Date : Saturday, May 6th 2006 @ 05:17:49 PM
Script : http://www.XXXXXXXXXX.com/XXXXXXXXXX.php
Referrer : http://www.XXXXXXXXXX.com/XXXXXXXXXX.php?do=ad&id=50
IP Address : XXX.XXX.XXXX
Username : Quarterbore
Classname : vb_database

I just can't finish my minor addition until I can get this basic change of $username into $userid

I would really appreciate any help!

[bairy]

you can use

PHP Code:

$user = $vbulletin->db->query_first("SELECT userid FROM user WHERE username = '$username' 


(You were missing the ' to surround $username, but query_first does it all in one for you anyway.)

$user['userid'] will then contain the userid

[Marco van Herwaarden]

Can we please keep vB3.5 questions and solutions in the vB3.5 forum. This to avoid confusion.