[Forum] Forumblock executing a query on db ? $this->registry->query ?

[Eqvaliser]

SOLVED!!!


trying to run a single query in a forumblock, and refering to a old post Forum block stuff

anyway trying to get this snippit to run but constantly getting function not found....

code snippet AFTER reading This post from 2005

$getclasslist = $this->registry->query("SELECT * FROM ".TABLE_PREFIX."egr");
while($row= $this->registry->db->fetch_array($getclasslist))
{

my own code

$getclasslist = $vbulletin->db->query("SELECT * FROM ".TABLE_PREFIX."egr");
while($row= $vbulletin->db->fetch_array($getclasslist))
{

Both give excaktly same error :
Fatal error: Call to undefined method vB_Registry::query() in C:\xampp\xampp\htdocs\emod\includes\block\html.php(95) : eval()'d code on line 25


Why ?

[Eqvaliser]

SOLVED : for some reason this works now

$getclasslist = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."egr");
while($row = $vbulletin->db->fetch_array($getclasslist))