[MYSQL] error: Call to a member function fetch_array()

[ezak]

I'm trying o make this modification Threads notifications work with VB4


and get this error

PHP Code:

Fatal error: Call to a member function fetch_array() on a non-object in /home/username/public_html/vbtest/includes/class_bootstrap.php(1212) : eval()'d code on line 11 


follwing this error found this

PHP Code:

($hook = vBulletinHook::fetch_hook('notifications_list')) ? eval($hook) : false; 


-- but I don't know where is "eval()d code on line 11"

following the notifications_list hook in this modification
found this

EDITED BY BOP5

PHP Code:

    // fetch user readed threads 
    $notifications_get = $vbulletin->db->query_read("
        SELECT * FROM . nlp_notifications_read
        WHERE userid = " . $vbulletin->userinfo['userid'] . 
        iif(((THIS_SCRIPT == 'SHOWTHREAD') AND $threadid),'AND threadid =' . $threadid));
    while($notifications_ids = $db->fetch_array($notifications_get))
    {
        //if(THIS_SCRIPT == 'SHOWTHREAD' AND $threadid = $notifications_ids['threadid']) continue;
        $notifications_threadids .= ', ' . $notifications_ids['threadid'];
    } 


I dont' know where is the error , and how to solve it
is this mysql functions is not working with VB4 ?

[BirdOPrey5]

The problem is with the line:

while($notifications_ids = $db->fetch_array($notifications_get))

You should update all database calls from $db->blah_blah_blah to $vbulletin->db->blah_blah_blah

and make sure you've made $vbulletin global in the plugin by calling:

global $vbulletin;

if it hasn't been done already in the code... it doesn't hurt to call it again if you're not sure.

While you are allowed up update a mod for personal use, please do not post any additional full plugins from the mod- the code is copyright from the original author and he did not give permission to re-use the code.

Only the most minimal code necessary to answer a specific question should be posted in the future.

[ezak]

thanks alot sir and sorry for that miss

the error has gone >>> but nothing appear for seeing the modification is working, I think the problem is in the templates

I need an reference for how to convert the templates form vb3 to vb4

[BirdOPrey5]

Check out this article:
https://vborg.vbsupport.ru/showthread.php?t=228078

There are quite a few changes in both template syntax and how templates are called in plugins. This wasn't going to be something you can upgrade with a couple of lines edited.