Adding a variable fetch_post_info()

[sp00fer]

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:

$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?

[Logikos]

Try this query:

PHP Code:

$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.postid)
        WHERE post.postid = $postid
"); 


[sp00fer]

no change, $post[userdiv] is still empty when used in the postbit template

The SQL query definately works, i added this to check it:

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.