I am trying to get a row from a custom table included in the $post array. (ie, the array used in templates that has all the post info in).
So i went in functions.php, found the fetch_post_info($postid) function and edited like this:
Code:
$postcache["$postid"] = $vbulletin->db->query_first("
SELECT divs.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 divs on divs.userid=post.userid
WHERE post.postid = $postid
");
The bits i changed are highlighted in green. The SQL query is valid, but no new variables appear in the $post array. The $post[userdiv] variable returns an empty string when i call it in a template......what am i doing wrong?