Non-object Issue

[The-Ensemble]

Ok I have this line of text in my php functions admin file that keeps getting booted when executed. with the error

Fatal error: Call to a member function on a non-object in {file} on line 8

Line 8:

PHP Code:

  $mainsqry = $vbulletin->db->query_read("SELECT favid, name, displayid FROM " . TABLE_PREFIX . "favavorites_main ORDER BY displayid"); 


Whats the problem? I've switched from $vbulletin->db to $db, that wasn't it, there query layout is the same as other parts of the file that works fine. I don't get what the problem is at all.

Help?

[Opserty]

Post the lines above this line. (One line on its own its only good for solving syntax errors )

Most likely the vBulletin backend/core is not initiating correctly.

[Marco van Herwaarden]

Is this code inside a function?

[The-Ensemble]

Yes the code is inside a function, heres the function.

PHP Code:

function get_mains() 
  {
  $mainsqry = $vbulletin->db->query_read("SELECT favid, name, displayid FROM " . TABLE_PREFIX . "favavorites_main ORDER BY displayid");
  $recordsetm = $db->fetch_array($mainsqry);
  while($record = mysql_fetch_assoc($recordsetm)) {
    $mains[$record['mainid']] = $record;
    $mains[$record['mainid']][cats] = array();
  }
  
  return $mains;
} 


[Marco van Herwaarden]

The add the following as the first line of the function:

PHP Code:

global $vbulletin; 


[The-Ensemble]

Thanks, I've added that and its rejecting the same line again.

[Marco van Herwaarden]

change it to:

PHP Code:

global $vbulletin, $db; 


You use both $vbulletin and $db in your script.

[Marco van Herwaarden]

Also, why do you use:

PHP Code:

  $recordsetm = $db->fetch_array($mainsqry);
  while($record = mysql_fetch_assoc($recordsetm)) { 


instead of:

PHP Code:

  while($record = $db->fetch_array($mainsqry)) { 


[The-Ensemble]

I was chopping and changing the coding various ways to see which part it was, I was going to revert it back after I'd got it working.