creating plugin issue

[Honourable]

Hi,

I would like

to run this plugin

PHP Code:

$this->registry->db->query_read_slave(("SET CHARACTER SET utf8");
$stream =  $this->registry->db->query_read_slave(("                        
            SELECT stream.*, users.* FROM " . TABLE_PREFIX . "dmods_stream AS stream
            INNER JOIN " . TABLE_PREFIX . "user AS users USING (userid)
            WHERE stream.touserid = 0 || stream.touserid = " . $this->registry->userinfo['userid'] . "
            ORDER BY stream.dateline DESC  
        ");

        $streamHTML = "";

while($item = $this->registry->db->fetch_array($stream)) {

            if ($item['type'] == 'status') {
                        
            // Unserialize params
            $streamdata = unserialize($item['parameters']);
            
            $templater = vB_Template::create('lywomen_allstatuses');

            $templater->register('stream', $streamdata);
            $templater->register('streaminfo', $item);
            
            $streamHTML .= $templater->render();

            }
}

vB_Template::preRegister('ad_global_below_navbar', array('streamHTML' => $streamHTML)); 


in this template ad_global_below_navbar

using this

PHP Code:

<ul id="webticker">
{vb:raw streamHTML}
</ul> 


and in this template lywomen_allstatuses which contains the bits

PHP Code:

<li><span class="usersign"><a href="member.php?u={vb:raw streaminfo.userid}">{vb:raw streaminfo.username}</a></span> {vb:raw stream.status}</li> 


I'm having a problem with the plugin as internal error for whole website once I make it activated I tried to hook the plugin in parse_templates as well as process_templates_complete also loads of hooks but non of them works

some hook places such as procces_templates_complete it does get rid of internal error yet is not doing what it suppose such as displaying data out in ad_global_below_navbar template


any suggestions as I'm makin connection to the database retrieve elements contained within a table then construct out in template

I will be more than happy if I can see any help or hint at least

Many thanks in advance

[kh99]

Try changing all occurences of $this->registry->db-> to $vbulletin->db-> , and use hook parse_templates.

[Honourable]

Hi,

I changed variables names maybe conflict with something else

but it still not working

PHP Code:

$streamxha =  $this->registry->db->query_read_slave(("                        
            SELECT stream.*, users.* FROM " . TABLE_PREFIX . "dmods_stream AS stream
            INNER JOIN " . TABLE_PREFIX . "user AS users USING (userid)
            WHERE stream.touserid = 0 || stream.touserid = " . $this->registry->userinfo['userid'] . "
            ORDER BY stream.dateline DESC  
        ");

$streamhtmlxha = "";

while($itemxha = $this->registry->db->fetch_array($streamxha)) {

                        
            // Unserialize params
            $streamdataxha = unserialize($itemxha['parameters']);
            
            $templater = vB_Template::create('lywomen_allstatuses');

            $templater->register('streamxha', $streamdataxha);
            $templater->register('streaminfoxha', $itemxha);
            
            $streamhtmlxha .= $templater->render();

}

vB_Template::preRegister('ad_global_below_navbar', array('streamhtmlxha' => $streamhtmlxha)); 


looking forward to your help

--------------- Added [DATE]1371931663[/DATE] at [TIME]1371931663[/TIME] ---------------

seconds I will try ur suggestion please dont leave

i will update u in seconds

--------------- Added [DATE]1371931850[/DATE] at [TIME]1371931850[/TIME] ---------------

I changed any occurance of $this->registry->db-> to $vbulletin->db->

adn the hook place to parse_templates

is not working unfurunately

please what do you think?

--------------- Added [DATE]1371931939[/DATE] at [TIME]1371931939[/TIME] ---------------

Also this making a huge conflict as when I browse any registered user with us it tells me
this user is not register once I disable the plugin I can browse users profile with no problem

what do you think?

note the internal error is gone now yet is not display the content that should be retrieved from db

[kh99]

Can you post again the exact code you're using?

[Honourable]

Here u go

PHP Code:

$vbulletin->db->query_read_slave(("SET CHARACTER SET utf8");
$stream =  $vbulletin->db->query_read_slave(("                        
            SELECT stream.*, users.* FROM " . TABLE_PREFIX . "dmods_stream AS stream
            INNER JOIN " . TABLE_PREFIX . "user AS users USING (userid)
            WHERE stream.touserid = 0 || stream.touserid = " . $this->registry->userinfo['userid'] . "
            ORDER BY stream.dateline DESC  
        ");

        $streamHTML = "";

while($item = $vbulletin->db->fetch_array($stream)) {

            if ($item['type'] == 'status') {
                        
            // Unserialize params
            $streamdata = unserialize($item['parameters']);
            
            $templater = vB_Template::create('lywomen_allstatuses');

            $templater->register('stream', $streamdata);
            $templater->register('streaminfo', $item);
            
            $streamHTML .= $templater->render();

            }
}

vB_Template::preRegister('ad_global_below_navbar', array('streamHTML' => $streamHTML)); 


[kh99]

Try this:

PHP Code:

$vbulletin->db->query_read_slave("SET CHARACTER SET utf8");
$stream =  $vbulletin->db->query_read_slave("                        
            SELECT stream.*, users.* FROM " . TABLE_PREFIX . "dmods_stream AS stream
            INNER JOIN " . TABLE_PREFIX . "user AS users USING (userid)
            WHERE stream.touserid = 0 || stream.touserid = " . $vbulletin->userinfo['userid'] . "
            ORDER BY stream.dateline DESC  
        ");

        $streamHTML = "";

while($item = $vbulletin->db->fetch_array($stream)) {

            if ($item['type'] == 'status') {
                        
            // Unserialize params
            $streamdata = unserialize($item['parameters']);
            
            $templater = vB_Template::create('lywomen_allstatuses');

            $templater->register('stream', $streamdata);
            $templater->register('streaminfo', $item);
            
            $streamHTML .= $templater->render();

            }
}

vB_Template::preRegister('ad_global_below_navbar', array('streamHTML' => $streamHTML)); 


[Honourable]

still not working???

--------------- Added [DATE]1371932856[/DATE] at [TIME]1371932856[/TIME] ---------------

just to let you know when I delete this bit

PHP Code:

$vbulletin->db->query_read_slave(("SET CHARACTER SET utf8"); 
$stream =  $vbulletin->db->query_read_slave(("                         
            SELECT stream.*, users.* FROM " . TABLE_PREFIX . "dmods_stream AS stream
            INNER JOIN " . TABLE_PREFIX . "user AS users USING (userid) 
            WHERE stream.touserid = 0 || stream.touserid = " . $vbulletin->userinfo['userid'] . " 
            ORDER BY stream.dateline DESC   
        "); 


I can browse users profile but still not working the sql query seems to me is the issue
as it makes problem in the whole forum if it existed??

[kh99]

Try the above code again (I just fixed a couple things instead of posting it all again).

[Honourable]

ur last edit works great

please explain to me what was the problem I really want to learn

many thanks in advance

[kh99]

Well, first I should have told you to replace $this->registry with $vbulletin, because there was one that didn't have a ->db on it. $this is used when inside an object method. I guess you copied the code from a class definition, so those had to be changed.

Also, these two lines had extra '(' characters (in red):

$vbulletin->db->query_read_slave(("SET CHARACTER SET utf8"); 
$stream =  $vbulletin->db->query_read_slave(("