no change, $post[userdiv] is still empty when used in the postbit template
The SQL query definately works, i added this to check it:
Code:
if (!isset($postcache["$postid"]))
{
$postcache["$postid"] = $vbulletin->db->query_first("
SELECT divs.userdiv as userdiv,post.*,
IF(visible = 2, 1, 0) AS isdeleted,
" . (THIS_SCRIPT == 'postings' ? " deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason," : "") . "
editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason
FROM " . TABLE_PREFIX . "post AS post
" . (THIS_SCRIPT == 'postings' ? "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON (deletionlog.primaryid = post.postid AND deletionlog.type = 'post')" : "") . "
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON (editlog.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "divs AS divs ON (divs.userid = post.userid)
WHERE post.postid = $postid
");
if(isset ($postcache[$postid][userdiv])){die($postcache[$postid][userdiv]);}
}
The script correctly terminates and returns a valid entry of divs.userdiv ..... but the information is not passed to the postbit template (or anywhere else) that i can actually use it.