Vb option array

[wolfe]

i have a vb option with a list of forum ids seperated by commas but when i use it in the php file $vbulletin->options[fids] in a query i get thread.forumid = (Array) error

how do i get around this.

thx in advance

[Dismounted]

Please post the code you are using.

[wolfe]

k

PHP Code:

    // Count all log entries
    $tcount = $vbulletin->db->query_first("
        SELECT COUNT(*) AS `tcount`
        FROM " . TABLE_PREFIX . "thread AS thread
        WHERE thread.forumid IN($vbulletin->options[fids])
    ");
    $vbulletin->db->free_result($fcount); 


[Dismounted]

PHP Code:

    // Count all log entries
    $tcount = $vbulletin->db->query_first("
        SELECT COUNT(*) AS `tcount`
        FROM " . TABLE_PREFIX . "thread AS thread
        WHERE thread.forumid IN(" . $vbulletin->options['fids'] . ")
    ");
    $vbulletin->db->free_result($fcount); 


[wolfe]

thx m8 worked a treat what about this one this giving errors

PHP Code:

$forumchoic = implode(',', fetch_search_forumids($vbulletin->options['fids'] ,'')); 


[Marco van Herwaarden]

If that option contains a list of comma-seperated values, then you are probably looking for explode() to convert it to an array. Also the 3rd parameter is not needed.

[wolfe]

PHP Code:

$forumchoic = explode(',', fetch_search_forumids("".$vbulletin->options['fids'] . "")); 


not working m8 getting error

Fatal error: Cannot pass parameter 1 by reference in /home/freec/public_html/findex.php on line 100

[Opserty]

Why have you all of a sudden decided to put down quotes around your $vbulletin->options variable?

[wolfe]

because i get an (Array) error otherwise

[Opserty]

You must pass the forum id's as an array to the fetch_search_forumids() function. Make sure you read the code behind the function when you start using them, it will easily prevent you from getting these errors and also make understanding vBulletin a lot better.

If the fetch_search_forumids() is a string you need to first explode() the string into an array then pass this array to the function

N.B. You won't be able to do it inline as you must the variable by reference:

PHP Code:

$vbulletin->options['fids'] = explode(',', $vbulletin->options['fids']);
$outcome = fetch_search_forumids($vbulletin->options['fids']);
// implode the forum ids or whatever you want 


Again I can't stress enough that you learn a heck of a lot about how a function works by just looking at the PHP code behind it.