Inserting SQL in PHP Problem - please help

[Warlord]

Originally Posted by SirAdrian

    function prepare_output($id = '', $options = array())
    {
        $this->block_data['longbox'] = '$db->query_first("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' ")';
    }

should be

    function prepare_output($id = '', $options = array())
    {
        $this->block_data['longbox'] = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' ");
    }

Needed to remove the extra ' ... ' around the $db->query_first() function call. That is supposed to be PHP - not a string. The query itself is already quoted with the double quotes.

Cheers

I tried that before and I freaked out the first time I did it that way because the profile stopped working at all and I got a white screen with the below error. :

Fatal error: Call to a member function query_first() on a non-object in /home/righscom/public_html/addons/projectfanboy/vb/member.php(463) : eval()'d code on line 247

I didn't realize it until now but I think that the error above is actually a step in the right direction, because it's telling me that I need to fix something else. I did some googling on that error and from what I can tell I need to globalise the variable $db->query_first by adding global $db->query_first; in my code.

After adding it to the top of the plugin my profile page loads but has the following error and now I feel like I'm back at step 1.

Parse error: syntax error, unexpected T_OBJECT_OPERATOR, expecting ',' or ';' in /home/righscom/public_html/addons/projectfanboy/vb/member.php(463) : eval()'d code on line 223.

Here's what my plugin looks like now.

global $db->query_first;

$blocklist = array_merge($blocklist, array(
	'longbox' => array(
		'class' => 'Longbox',
		'title' => 'Resume',
		'hook_location' => 'profile_left_last'
	)
));

class vB_ProfileBlock_Longbox extends vB_ProfileBlock
{
	var $template_name = 'memberinfo_block_longboxes';

	function confirm_empty_wrap()
	{
		return false;
	}

	function confirm_display()
	{
		return ($this->block_data['longbox'] != '');
	}

    function prepare_output($id = '', $options = array())
    {
        $this->block_data['longbox'] = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' , AND title = 'Resume' ");
    }