Posting this here, as I believe you're meant to do first off. Plus it could probably be improved a touch. Thought I would share it anyway.
Basically it is for use with portals, as it gives some indication of what each forum is. Handy if people pass by your front page and haven't visited your forums yet, as it gives a description of an individual forum after the title.
Anyway, here's the code:
<?
// this line needs to be set to point to your config.php file.
include("$DOCUMENT_ROOT/forums/includes/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
// set admin forum
$adminforum = 1;
// MySql query
$sql =mysql_query("SELECT * FROM forum WHERE forumid != $adminforum AND displayorder != 0 AND threadcount > 1 ORDER BY RAND() LIMIT 1");
// Loop out of DB & PHP, into HTML
while ($news = mysql_fetch_array($sql)){
Edit:\ weird its showing up as 'latest hack' on mainpage
Posting this here, as I believe you're meant to do first off. Plus it could probably be improved a touch. Thought I would share it anyway.
Basically it is for use with portals, as it gives some indication of what each forum is. Handy if people pass by your front page and haven't visited your forums yet, as it gives a description of an individual forum after the title.
Anyway, here's the code:
<?
// this line needs to be set to point to your config.php file.
include("$DOCUMENT_ROOT/forums/includes/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
// set admin forum
$adminforum = 1;
// MySql query
$sql =mysql_query("SELECT * FROM forum WHERE forumid != $adminforum AND displayorder != 0 AND threadcount > 1 ORDER BY RAND() LIMIT 1");
// Loop out of DB & PHP, into HTML
while ($news = mysql_fetch_array($sql)){
Some of us have more than I admin forum, adminforum should be a comma separated list and the query should be and forumid not in ($adminforum), or something like that :)
Also, you should really include global.php to have the standard $DB_site object and to use all the forum usergroup constraints.
Screenie shotty please
Screenie shotty please
There isn't much to take a screenshot of: this piece of code simply randomly selects one forum on your board and displays a table *ick* with the forumname and its description.
It doesn't use templates, and isn't of much use on its own - it needs to be used in your already existant portal.