Constant help needed. Learning how vBulletin works.

[Alan @ CIT]

Hi,

PHP Code:

$status = $vbulletin->db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "chat_info
WHERE chat_id = 1
"); 
 
if($status['status'] != 'Active'){
eval('print_output("' . fetch_template('cs_closed') . '");');
exit;
} 


The problem there is that you are running the query (query_read()) but not fetching an array of the results

When running a query, there are 2 parts.

1) query_read() - This runs the query and returns the result
2) fetch_array() - This converts the result into something PHP can understand

So, for your query, you need to change the code to:

PHP Code:

$result = $vbulletin->db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "chat_info
WHERE chat_id = 1
"); 
 
$status = $vbulletin->db->fetch_array($result);

if($status['status'] != 'Active'){
eval('print_output("' . fetch_template('cs_closed') . '");');
exit;
} 


The fetch_array function will return 1 row at a time, so if your query returns more than 1 row, then you need to use it in a while() loop. Eg:

PHP Code:

// ... run query here

while ($status = $vbulletin->db->fetch_array($result))
{
   // Do something to the returned table row
} 


vBulletin also includes a handy function called query_first(). This runs the query, and returns the first row from the result without having to call fetch_array() yourself.

For a query like yours, where there will only be 1 row returns, query_first() is ideal.

So, your code using query_first() would look like:

PHP Code:

$status = $vbulletin->db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "chat_info
WHERE chat_id = 1
"); 
 
if($status['status'] != 'Active'){
eval('print_output("' . fetch_template('cs_closed') . '");');
exit;
} 


Hope all that makes sense, and good luck with your script

Thanks,
Alan.