Special Query (WHERE)

[Sarcoth]

Well, apparently it is difficult to get help on this sort of thing, but I think I finally figured it out.

This probably wasn't the best way to do it, but I tried it so many different ways I don't know what else I could have done.

I have a setting called showroster_display_groups which is a comma separated ID list. The admin enters the usergroupid's that they want to appear on my roster in the Settings page.

I added this to my showroster.php (custom) file:

PHP Code:

$displaygroups = array();
$displaygroups = explode(',', $vbulletin->options['showroster_display_groups']); 


Further down in the file, there is the query. Since I couldn't figure a way to get the WHERE to work, I removed it. That opened my roster up to including every usergroup.

A few lines below the query, I have a while statement that pulls the data to use from the query (at least that is what I think it does).

I added this at the start of the while statement:

PHP Code:

foreach ($displaygroups AS $mygroups) {
    if ($mygroups == $userinfo['usergroupid']) { 


I closed that at the end with two brackets and BINGO. It finally worked.

I can now remove my bitfield.xml file from my mod and focus on using the single .php file for my mod.

Next I need to figure out how to pull variables from my custom php file and use it in plugins. If anyone has any suggestions on that, please see my other thread.

https://vborg.vbsupport.ru/showthread.php?t=236314