[RELEASE] Show category list on non vb pages

Here is another one. This one will display a list of categories on a non vb page;

See it in action here:
http://www.extremeforums.com/include...rylist.inc.php

<?php
require("/full/path/to/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM category ORDER BY title ASC";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://www.extremeforums.com/forums/index.php?categoryid=$latest_array[categoryid]\">$latest_array[title]</A></FONT><BR>";
}
 
?>

Edit the echo statement as you see fit

~Chris

[Edited by TechTalk on 08-10-2000 at 05:33 PM]

What code does one use to include this inside a vBulletin template. Such as a footer or header file?

How do you use this inside in vBulletin page?

what about the php code to include on a non vbulletin page ?

Well assuming you named it "categorylist.inc.php" you would call it like this:

<?php
include("/full/path/to/categorylist.inc.php");
?>

Hope this helps

~Chris

thanks gonna try it as soon as i get some sleep first hehe

i tried it and got this error

Fatal error: Failed opening required 'admin/config.php' in /home/usr1/www.animeboards.net/htdocs/forums/categorylist.inc.php on line 2

Fatal error: Failed opening required 'admin/config.php' in
/home/usr1/www.animeboards.net/htdocs/forums/categorylist.inc.php on line 2

You obviously have an error in the path you placed in the include statement. The path would not include the http://www.animeboards.net URL.

Most likely the path is something along the lines of:
/home/usr1/htdocs/forums/categorylist.inc.php

The above path is just a guess based on the error you included!

Nonono.

eva - just try putting in the full absolute path to your config.php. My guess would be at:
/home/usr1/www.animeboards.net/htdocs/forums/admin/config.php

kwakoe - The path in the error is the path of the script that was running, so it HAS to be right, unless eva was using IIS, because that generates some weird error messages occasionally. But that path is Unix...

Originally posted by Ed Sullivan
Nonono.

eva - just try putting in the full absolute path to your config.php. My guess would be at:
/home/usr1/www.animeboards.net/htdocs/forums/admin/config.php

i am on a linux machine....

i put in this

<?php
include("/home/user1/www.animeboards.net/htdocs/forums/categorylist.inc.php");
?>

there's no reference to config in the php code i made on the page... don't know how to

here's my url for the categorylist
http://animeboards.net/forums/categorylist.inc.php

how do i hide more than 1 private forum from the list ?

I am installing all of these non-vb page hacks.
Just need the private message and whois online for this...I am working on it, don't know if I will do it.

To you question, to hide more than one private forum I made the private forums the highest forum ids.
Like 25 and 26 then instead of having equals a number I hide it by asking for less than 25.
Do you know what I mean?

It just worked out because I had it this way and it seems to be the easiest way for me.
If I want more private forums later I will just add them after 25 and I will not have a problem.

Hope that helped at all.

Later.