[Dominick]

Originally posted by TECK
Look at the "article" query, and change the username with your field

I think I see what you are saying, if I understand correctly. here is the problem...

// | Articles
// +--------------------------------------------------------------

$articlebits = '';
$articlemaxnumber = iif ( $articlemax!=0 , 'LIMIT ' . $articlemax , '' );
$articles = $DB_site->query("
SELECT thread.threadid,thread.title,thread.lastpost,threa d.replycount,threa\d.postusername,thread.postuseri d,
thread.lastposter,thread.dateline,thread.views,pos t.pagetext as pagetext
" . iif ( $articleicon , ',thread.iconid' , '' ) . "
" . iif ( $articleavatar , ',avatar.avatarid,avatar.avatarpath,NOT ISNULL(c\ustomavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardat\eline' , '' ) . "
FROM thread
LEFT JOIN post ON( post.postid=thread.articleid )
" . iif ( $articleavatar , 'LEFT JOIN user ON( user.userid=thread.postuseri\d )
LEFT JOIN avatar ON( avatar.avatarid=user.avatarid )
LEFT JOIN customavatar ON( customavatar.userid=thread.postuserid )' , '' )
. "
WHERE thread.forumid IN( $articleforum ) AND thread.visible=1 AND thread.op\en<>10
ORDER BY thread.dateline DESC $articlemaxnumber
");
while ( $article = $DB_site->fetch_array( $articles ) )

the thread table in my forums dbase doesnt have an entry for a custom field that I set up for full name. If i follow the process properly, the right way to do it would have to be something like this.

new thread or post, push custom field entry from userfield to a new column in the thread table. So that vbhome lite can pull the data that it has. Seems easisest like that but frankly I dont feel experienced enough to do that, and I have a feeling there migth be an easier way.

-Dom