Thanks a lot for your sharing your code with us. I didn't test it myself but if it is working as you explained, it can be useful to sites which use a different approach to this permission issue. I'll add it to the FAQ.

thanks War, testing it out now.

Logician do you know where to find the above text so that I can edit how it reads? thanks.

I think I found it in wt_wt.php in the admincp folder.

Cannot grasp how to pull a php page into this and have vb headers and footers show up as well...

Okies...I can pull it up with:
But after it submits the info from my form it goes back to that scripts default look...anyway to keep the vb look after submitting the form? Thanks...

I wonder why such a useful and necessary founction didn't include in the original vbb ?!!

because it's a forum software and not a cms system ;)

afaik they plan a product like this.

I am trying to format the output so that ONLY IF there is a 'dept', it will print out.
I tried putting code in the query output area as well as at the main page template.


Thanks! :)

I am having a little bit of trouble with the PHP template type. I have a PHP file that is working properly that pulls all banners from my phpadsnew database and displays it in a table. The page is sort of a "Our Sponsors" kind of thing:

<?php
echo $stylevar[htmldoctype];
echo $headinclude;
echo $header;
echo $navbar;
$host="localhost";
$user="xxxxx";
$password="xxxxx";
$database = "xxxxx";

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

$query = "select alt, imageurl, url, bannerid from phpads_banners order by alt";
$result = mysql_query($query)
or die ("Couldn't execute query.");

/* Display results in a table */
echo "<center><strong>Our Sponsors</strong></center>";

echo "<div align='center'>\n";
echo "<table border='0' cellpadding='2'>\n";

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>\n
\n
<td><a target='_blank' title='$alt' href='$url'><img src='$imageurl'</td>\n
\n
</tr>\n<td></td>";
}
echo "</table>\n";
?>

Why do I need to put the echo statements at the top? In the html templates I don't need to add those and it displays my style fine.

Also, why won't this template use the proper page title for the browser window? It just lists the URL and not the Site + User Friendly Name.

This is a GREAT hack btw!

Thanks!

The more I study this, the more I like it!!!

Many of us have now installed programs like Photopost in the same database as VB3. Would it be possible to query the photopost info, like newest picture in a catagory with a table prefix like pp_ ?