Call to a member function query_read() on a non-object

[Kyojii]

I seem to run into this problem a lot and it's always a pain to fix. This is being used to make a bbcode with this mod: https://vborg.vbsupport.ru/showthrea...44#post2346244 .

PHP Code:

<?php
require_once('./global.php');
$query = $db->query_read("SELECT `userid`, `username` FROM " . TABLE_PREFIX . "user WHERE UPPER(`username`) = UPPER(".$value.")");
$user = $db->fetch_array($query);

$avatar = fetch_avatar_url($user['userid']);
$avatar = ($avatar['hascustom']) ? $avatar[0].'&amp;type=thumb' : $avatar[0];

$url = fetch_seo_url('member', array('userid' => $users['userid'], 'username' => $users['username']), array(), 'userid', 'username');
$output = "<img style='height: 16px;' src='".$avatar."'><a href='".$url."</a>";

return $output;
?>

I added the require_once on global to try and fix it but it didn't work. Every time I have this problem I always find this as well: https://vborg.vbsupport.ru/showthread.php?t=235092 but that never fixed it either. Changing the query to vB::$db->query_read(" simply changes the error saying that the class vB isn't defined. also using $vbulletin->db->query_read doesn't seem to solve the problem either.

[Badshah93]

Below this code

require_once('./global.php');

Add

global $db;

[cellarius]

I prefer to have $vbulletin global and use $vbulletin->db.

[Badshah93]

Below this code

require_once('./global.php');

Add

global $db;

or you change $db-> with $vbulletin->db

and no need of globalizing $vbulletin as global.php is called.

also using $vbulletin->db->query_read doesn't seem to solve the problem either.

its because in next line you are using

$db->fetch_array

[Kyojii]

Thanks guys.

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

Originally Posted by Badshah93

or you change $db-> with $vbulletin->db

and no need of globalizing $vbulletin as global.php is called.



its because in next line you are using

$db->fetch_array

Nope, globalizing $db works however even replacing both lines with $vbulletin->db the error occurs.

[Pandemikk]

Are you using this within a hook? If so, you should remove that require because global.php has already been included.

[Badshah93]

Originally Posted by Kyojii

Thanks guys.

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



Nope, globalizing $db works however even replacing both lines with $vbulletin->db the error occurs.

you can use this also in place of $db.

$GLOBALS['vbulletin']->db