Option Data From Table

[SorentoUltimate]

Hello, i writeing a new addon and i have a problem.
i try to load data from a ta table for an option but i cannot make it !!!!

Option Code

select:eval
require_once(DIR . '/includes/functions_colors.php');
$options = fetch_colors_options_array();

_

functions_colors.php

<?php

error_reporting(E_ALL & ~E_NOTICE);

// ###################### Fetch Colors as Options #######################
// Return Colors Options Array
function fetch_colors_options_array()
{

  global $vbulletin;
  $out = array();    

  // fetch Colors
  $getcolors = $db->query_read("
    SELECT colorid, colorname
    FROM `" . TABLE_PREFIX . "colors`
   ");
    
    echo 'After Get';

  while ($colorrow = $db->fetch_array($getcolors))
  {
    $out["$colorrow[colorid]"] = "$colorrow[colorname]";
  }    

  return $out;

}

?>

_

Error :

Fatal error: Call to a member function on a non-object in /......./......./......./......./forum/includes/functions_colors.php on line 14

[Lynne]

Did you include global.php or init.php in your main file? If not, $db->query_read is not valid since it is a vbulletin thing.

[SorentoUltimate]

no i don't include,

need to include global.php or init.php to functions_colors.php or to plugin i call function ???

[Lynne]

Well, or you need to use standard php language to access the database.

[SorentoUltimate]

Originally Posted by Lynne

Well, or you need to use standard php language to access the database.

Where to put global.php and(or) init.php ??

[Lynne]

Well, you need to include it before you make any database calls. So, in either file I would think is fine. Depends on if you will need it again or not.

[SorentoUltimate]

Originally Posted by Lynne

Well, you need to include it before you make any database calls. So, in either file I would think is fine. Depends on if you will need it again or not.

ok, thanks
i try and if i have any more problem i write it

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

i put require_once('./global.php'); at option code

and now the option code are

select:eval
require_once('./global.php');
require_once(DIR . '/includes/functions_colors.php');
$options = fetch_colors_options_array();

but now the error are :

Fatal error: Call to a member function on a non-object in /......./......./......./......./forum/global.php on line 242