How do I extract a list of private forums?

[DarkReaper]

Several hacks out there require manual specification of the forumids of private forums on the board. I looked through the tables some through phpMyadmin and couldn't find a "isprivate" setting. Where is this?

[tubedogg]

There isn't a setting like that. What happens when you set 'private' when creating a forum is that there are permissions inserted into the forumpermission table for all groups except mods and admins.

[DarkReaper]

Doh!

SELECT forumid FROM forumpermission WHERE usergroupid=2 AND canview=0

That selects all the forums which are invisible and inaccessable to the 'registered' usergroup.

Is there any way I could get the results returned in a row, seperated by commas/spaces?

[tubedogg]

$forumids = $DB_site->query("SELECT forumid FROM forumpermission WHERE usergroupid=2 AND canview=0");
$num = $DB_site->num_rows($forumids); $i=0;
while ($forumid = $DB_site->fetch_array($forumids)) {
  $list .= $forumid[forumid];
  $i++;
  if ($i < $num) {
    $list .= ","; // change this to a space if wanted/needed
  }
} 

[DarkReaper]

Thanks

I'm not sure how to select things from more than one table at a time, so how would I do this:

Select forumid from forumpermission where usergropuid=2 and canview=0 and also select forumid from forum where active=0 and displayorder=0

[DarkReaper]

*bump*

[tubedogg]

$forumids = $DB_site->query("SELECT forumpermission.forumid,forum.forumid FROM forumpermission,forum WHERE (forumpermission.usergroupid='2' AND forumpermission.canview='0') XOR (forum.active='0' XOR forum.displayorder='0')");

Try that...probably won't work, but worth a shot.

[DarkReaper]

Database error in vBulletin Control Panel: Invalid SQL: SELECT forumpermission.forumid,forum.forumid FROM forumpermission,forum WHERE (forumpermission.usergroupid='2' AND forumpermission.canview='0') XOR (forum.active='0' XOR forum.displayorder='0')
mysql error: You have an error in your SQL syntax near 'XOR (forum.active='0' XOR forum.displayorder='0')' at line 1

[tubedogg]

$forumids = $DB_site->query("SELECT forumpermission.forumid,forum.forumid FROM forumpermission,forum WHERE (forumpermission.usergroupid='2' AND forumpermission.canview='0') OR (forum.active='0' OR forum.displayorder='0')");

k try this

[DarkReaper]

That didn't work too well either:

|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1|1 |1|1|1|1|1|1|1|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2 |2|2|2|2|2|2|2|2|2|2|2|2|2|2|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3 |3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|3|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4 |4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|4|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5 |5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|5|6|6|6|6|6|6|6|6|6|6 |6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|6|7|7|7 |7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7|7 |7|7|7|7|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|1 94|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194|194 |194|194|194|194|194|194|194|194|194|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16 |16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16|16 |16|16|16|16|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17 |17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|17|192|192|192 |192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|1 92|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192|192 |192|192|192|192|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|1 93|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193|193 |193|193|193|193|193|193|193|193|193|193|193|191|191|191|191|191|191|191|191|191|191|191|1 91|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191 |191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|191|189|189|189|189|1 89|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189 |189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|189|1 89|189|189|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190 |190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|190|1 90|190|190|190|190|190|190|190|190|190|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30| 30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30|30| 30|30|30|30|30|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32| 32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|32|33|33|33| 33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33| 33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|33|34|34|34|34|34|34|34|34|34|34|34| 34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34|34| 34|34|34|34|34|34|34|34|34|34|34|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35| 35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35|35| 35|35|35|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36| 36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|36|37|37|37|37|37| 37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37| 37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|37|38|38|38|38|38|38|38|38|38|38|38|38|38| 38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38|38| 38|38|38|38|38|38|38|38|38|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39| 39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39|39| 39|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40| 40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|40|41|41|41|41|41|41|41| 41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|41| 41|41|41|41|41|41|41|41|41|41|41|41|41|41|41|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42| 42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42|42| 42|42|42|42|42|42|42|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43| 43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|43|44| 44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44| 44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|44|203|203|203|203|203|203|203 |203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|2 03|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203|203 |202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|2 02|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202|202 |202|202|202|202|202|202|202|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|2 01|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201|201 |201|201|201|201|201|201|201|201|201|201|201|201|201|201|200|200|200|200|200|200|200|200|2 00|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200 |200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|200|199|1 99|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199 |199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|199|1 99|199|199|199|199|199|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198 |198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|198|1 98|198|198|198|198|198|198|198|198|198|198|198|198|126|126|126|126|126|126|126|126|126|126 |126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|1 26|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|126|127|127|127 |127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|1 27|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127|127 |127|127|127|127|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|1 24|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124|124 |124|124|124|124|124|124|124|124|124|124|124|125|125|125|125|125|125|125|125|125|125|125|1 25|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125 |125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|125|76|76|76|76|76|76 |76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76 |76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|76|139|139|139|139|139|139|139|139|139|139|1 39|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139 |139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|139|79|79|79|79|7 9|79|79|79|79

[dwh]

Doh!

SELECT forumid FROM forumpermission WHERE usergroupid=2 AND canview=0

That selects all the forums which are invisible and inaccessable to the 'registered' usergroup.

Is there any way I could get the results returned in a row, seperated by commas/spaces?

Does this code work in vb3? If not, is there a replacement (yes, I already wrote this question on vb.org, but if someone has a quick answer, would most appreciatre it)