The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
If someone could help me, I sure would appreciate it.
I added a column to table post: post.to_user (btw, values are stored correctly) which is a userid I added this plugin to hook: showthread_query Code:
$hook_query_fields = ",user.username AS to_username"; $hook_query_joins = "LEFT JOIN " . TABLE_PREFIX . "user AS u ON(u.userid = post.to_user)"; Code:
$hook_query_joins = "LEFT JOIN " . TABLE_PREFIX . "user AS u ON(u.userid = post.to_user)"; I previously ran the following query in phpMyAdmin, and got the correct results: Code:
SELECT user.username AS to_username FROM post LEFT JOIN user ON ( user.userid = post.to_user ) WHERE post.postid = 173 (I'm running 3.6.5) |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|