call $bbuserinfo but wont work.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Halfhidden
    Senior Member
    • Sep 2009
    • 140
    • 4.0.x

    [Forum] call $bbuserinfo but wont work.

    Hi I'm having a bit of trouble understanding how to call a list of additional users from Vbulletin.
    Here's what I have:
    PHP Code:
    $answer .= '<select name="'.$formbit[id].'">'
    $members $db->query_read("SELECT * FROM " TABLE_PREFIX "user 
    WHERE usergroupid = 24
    ORDER BY username ASC"
    ); 
        while(
    $row $db->fetch_array($members)) { 
    $answer .= '<option value="'.$row[username].'"'
    if (
    $row[username] == $thisanswer) { 
    $answer .= 'selected="selected"'

    $answer .= '>'.$row[username].'</option>'

    $answer .= '</select>'
    As you can see I've called the users from group id 24 but I have no idea how to call the additional users from that group as well.

    Thanks for any help.
  • Halfhidden
    Senior Member
    • Sep 2009
    • 140
    • 4.0.x

    #2
    It's ok I've worked it out thanks. Here's how I did it:
    PHP Code:
    $usgid 24
    $answer .= '<select name="'.$formbit[id].'">'
    $members $db->query_read("SELECT * FROM " TABLE_PREFIX "user 
    WHERE usergroupid = '
    $usgid' OR membergroupids = '$usgid' OR membergroupids LIKE \"$usgid,%\" OR membergroupids LIKE \"%,$usgid\" OR membergroupids LIKE \"%,$usgid,%\" 
    ORDER BY username ASC"
    ); 
        while(
    $row $db->fetch_array($members)) { 
    $answer .= '<option value="'.$row[username].'"'
    if (
    $row[username] == $thisanswer) { 
    $answer .= 'selected="selected"'

    $answer .= '>'.$row[username].'</option>'

    $answer .= '</select>'

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎