Username from ID?

Nick R · 06-28-2006, 03:38 PM

If i had a user's id but in the table i need the username as well what would i do. For example in a table i had 2 columns. I Inserted a new row:

You must first be a registered member to view any code.

X = userid Y= username. How would i do this?

Not terribly clear i know...

Arnoud · 06-28-2006, 03:42 PM

$vbulletin->userinfo[username]?

Nick R · 06-28-2006, 03:44 PM

hold on a sec ;)

Nick R · 06-28-2006, 03:47 PM

Ok, i mean like in a php script i have got a userid off someone would would i have to do to make a variabel for the username eg.

You must first be a registered member to view any code.

xD or maybe not

Nick R · 06-28-2006, 03:49 PM

You could do it like

Quote:

SELECT username from user WHERE userid =$ID

Arnoud · 06-28-2006, 03:50 PM

Oh like that.

You could add a query, but I believe vB has a function for this. I wouldn't know which one though, have a look at some hacks which would use this.

Nick R · 06-28-2006, 04:42 PM

I have... what i came up with was this:

Quote:

$Shout['username'] = fetch_musername($Shout, 'usergroupid');

which isn't really helpful becuase it uses shout...

Arnoud · 06-28-2006, 04:54 PM

Is that the exact code?

Nick R · 06-28-2006, 04:58 PM

Well not all the code in the file. all the code in the file is:

You must first be a registered member to view any code.

Arnoud · 06-28-2006, 05:03 PM

Try using:

You must first be a registered member to view any code.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Allowing members to change their username	doggy1	vBulletin Modification Requests	7	07-11-2006 09:35 AM
how can i get the user id and username just with PHP?	AnoxiA	General vBulletin Support	12	02-04-2006 04:21 PM
How mod to set color for username?	DungIT	vBulletin Modification Requests	1	07-01-2005 08:31 AM
1 missing phrase and request change username.	D3LTA	Site Feedback	2	01-17-2005 01:46 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)