SQL Query in profile tab

[TriggerHappy123]

I made a plugin to add a new tab to a users profile, how would i make the data thats shown in the tab be from an executed MySQL Query?

PHP Code:

class vB_ProfileBlock_MyModification extends vB_ProfileBlock
{
    var $template_name = 'memberinfo_block_mymodification';

    function confirm_empty_wrap()
    {
        return false;
    }

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

    function prepare_output($id = '', $options = array())
    {
        $this->block_data['mymodification'] = 'QUERY HERE'; // what would i do here
    }
} 


[Dismounted]

The DB object can be called inside the class using $this->registry->db.

[TriggerHappy123]

Sorry i'm a php noob. A simple example using my code?

[Dismounted]

If you do not know PHP - I doubt any examples are going to help, dealing with SQL and the like is a bit further down the track. I would suggest you learn PHP as best you can before dealing with vBulletin.

[Lynne]

You would put the query inside the function prepare_output. You would not put it in "$this->block_data['mymodification']" as that should contain the html to output. You would do the query as Hanson suggestion, then get the results and put it in the block_data.

[TriggerHappy123]

If you do not know PHP

I never said that, im a noob in php. I can write scripts and i have dealt with using databases before. I just need an example on how to do it with vbulletin, and it's weird template system.

[Lynne]

You would do something like this:

PHP Code:

    function prepare_output($id = '', $options = array()) 
    { 
$subres = $this->registry->db->query_read("SELECT STATEMENT HERE");
$result = $this->registry->db->fetch_array($subres);

        $this->block_data['mymodification'] = 'HTML OUTPUT'; 
    } 


[TriggerHappy123]

Thanks, will try it out. I would +rep you only vb.org doesn't have rep