vb.org Archive - How do I call information from a field that I have added in userfield table?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - How do I call information from a field that I have added in userfield table? (https://vborg.vbsupport.ru/showthread.php?t=32629)

In the forumhome template of VB 2.2.1

I would like the text to read as follows in the browser:
"Welcome to our newest member Mike , from U of Montreal."

geting it's information as follows:
"Welcome to our newest member <$newusername>, from <field9 of userfields table>."

Here is the template code where this should be inserted:
Welcome to our newest member, <a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$newuserid"><b>$newusername </b></a>.

Thank you for helping me out, I have been able to make all other modifications that I needed in the postbit but I cannot figure out how to call up the information here in forumhome.

In index.php, replace this:

Code:

// get newest member

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

$newusername=$getnewestusers['username'];

$newuserid=$getnewestusers['userid'];

with this:

Code:

// get newest member

$getnewestusers=$DB_site->query_first("SELECT userid,username,field9 FROM user LEFT JOIN userfield USING (userid) WHERE user.userid=$numbersmembers[max]");

$newusername=$getnewestusers['username'];

$newuserid=$getnewestusers['userid'];

$newuserlocation=$getnewestusers[field9];

Now use $newuserlocation to show that field in the forumhome template.

Firefly,

Thanks for posting a response so quickly, I really appreciate you helping me, unfortunately it did not work.

Here is the email error message that I get when I modify index.php as you suggested:

--------------
Database error in vBulletin 2.2.1:

Invalid SQL: SELECT userid,username,field9 FROM user LEFT JOIN userfield USING (userid) WHERE user.userid=4
mysql error: Column: 'userid' in field list is ambiguous

mysql error number: 1052

Date: Sunday 25th of November 2001 12:29:12 AM
Script: http://www.dentist2b.com/bb/bb/
Referer:
--------------

This is what my userfield table looks like from phpMyAdmin, although I really do not know if this will help you at all:

Database dentist2_forum - table userfield
Field Type Attributes Null Default Extra
userid int(10) UNSIGNED No 0
field6 char(250) No
field7 char(250) No
field8 char(250) No
field9 char(250) No

Indexes : Keyname Unique Fulltext Field
PRIMARY Yes No userid

Space usage : Type Usage
Data 4,020 Bytes
Index 2,048 Bytes
Total 6,068 Bytes
Row Statistic : Statements Value
Format fixed
Rows 4
Row length ? 1,005
Row size ? 1,517 Bytes

Thanks.

Sorry, my bad.
I forgot to specify the table before the userid field:

Code:

// get newest member

$getnewestusers=$DB_site->query_first("SELECT user.userid,username,field9 FROM user LEFT JOIN userfield USING (userid) WHERE user.userid=$numbersmembers[max]");

$newusername=$getnewestusers['username'];

$newuserid=$getnewestusers['userid'];

$newuserlocation=$getnewestusers[field9];

Thanks Firefly :D

You have been very helpful, everything works perfectly now.

much appreciated!!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01867 seconds Memory Usage 1,730KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: