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?
How do I extract a list of private forums?
Collapse
X
-
How do I extract a list of private forums?
Seriously! - The Definitive Home of All Things Serious
Seriously! Forums
To recieve support on these forums, enter your username here.Tags: None -
Doh!
Code:SELECT forumid FROM forumpermission WHERE usergroupid=2 AND canview=0
Is there any way I could get the results returned in a row, seperated by commas/spaces?Seriously! - The Definitive Home of All Things Serious
Seriously! Forums
To recieve support on these forums, enter your username here.Comment
-
PHP Code:$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
}
}
Comment
-
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=0Last edited by DarkReaper; Wed 31 Oct '01, 2:48pm.Seriously! - The Definitive Home of All Things Serious
Seriously! Forums
To recieve support on these forums, enter your username here.Comment
-
*bump*Seriously! - The Definitive Home of All Things Serious
Seriously! Forums
To recieve support on these forums, enter your username here.Comment
-
$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.Comment
-
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 1Seriously! - The Definitive Home of All Things Serious
Seriously! Forums
To recieve support on these forums, enter your username here.Comment
-
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|79Seriously! - The Definitive Home of All Things Serious
Seriously! Forums
To recieve support on these forums, enter your username here.Comment
-
Originally posted by DarkReaperDoh!
Code:SELECT forumid FROM forumpermission WHERE usergroupid=2 AND canview=0
Is there any way I could get the results returned in a row, seperated by commas/spaces?Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment