You are my hero Logican LOL :) thanks! I hope it'll be updated for vB3

Yeah thx its noted.

Logician - Your hacks are always top notch...Good Work!

just found a small typo in the instructions

should be

great hack Logician :)

fixed.. thanks!

Logician

OK, I've installed the hack. Templates created and the SQL queries had run successfully:

>>

Your SQL-query has been executed successfully :
The content of your file has been inserted. (23 Instructions)

<<


After installation I run the http://mysite/forum/admin/webtemplate.php and this works fine and displays the admin panel. Then I run into some different problems:


Your Custom Pages

Selecting 'Visit' for the 'Test' page produces the following error which is duplicated what looks like hundreds of times down the page:


Default WebTemplates

1. Selecting 'visit' for the 'invalid_pg' page displays but all the images do not relate to the right style, despite all the correct templates being in the correct style. The colours however for the style are correct (background etc.).
   
2. Selecting 'visit' for the 'phptest [Private]' page produces the following error
   
   
   Code:

   ---

   Warning: Wrong datatype for second argument in call to in_array in c:\program files\apache group\apache\htdocs\forum\view.php on line 93

   ---

3. Selecting 'visit' for the 'priv_privatemessages [Private] [Draft]' page produces the following error:
   
   
   Code:

   ---

   SELECT dateline,privatemessageid, fromuserid, touserid, title, message, touser.username
AS tousername, fromuser.username AS fromusername FROM privatemessage LEFT JOIN user AS touser ON
(touser.userid=privatemessage.touserid) LEFT JOIN user AS fromuser ON (fromuser.userid=privatemessage.fromuserid)
WHERE folderid='0' ORDER BY privatemessageid DESC LIMIT 30 mysql error: You have an error in your SQL syntax near ' SELECT
dateline,privatemessagei' at line 1 mysql error number: 1064 Date: Monday 30th of June 2003 10:19:29 PM Script: http://<br />
<a href="http://test..../test.com/</a>forum/forum/view.php?pg=priv_privatemessages Referer: http://<br />
<a href="http://test....plate.php?</a> -->

   ---

   Note the double 'forum' path as highlighted in yellow above.
   
4. Selecting 'visit' for the 'webqueryhelp [Draft]' page displays everything perfectly including my style header and footer.
   
5. Selecting 'visit' for the 'webtemplateshelp [Draft]' page displays everything perfectly including my style header and footer.
   
6. Selecting 'visit' for the 'webtemplates_variables [Draft]' page displays everything perfectly including my style header and footer.

It looks likes there is a problem with whenever it wants to access database information as the other pages are just general pages and don't have any queries.

The double forum/forum path is weird for starters and the one issue with display the incorrect footer / header for one of the pages (could this be using the footer and header in your templates that I see on the Admin page?).

Anyway, any ideas :).

This should be because invalid_pg is using a different header/footer. Edit it and change it to your default forum header and footer and it should ok..

This is not related to the hack, this is default vbulletin error reporting behaviour. You'll see the same URL in all DB errors.


I see..

It seems that while you are running the SQL queries, for some reason, default webqueries is not created ok. It can be an issue with phpmyadmin's inserting or escaping \ chars into the queries so bothering the webqueries.

Let's try this: Delete all webqueries in the webquery admin cp, then manually create them according to the attached file.I believe this should fix the problem.

Let me know how it went. Thx..

First off cool hack, easy to install!

**I have to ask because I did'nt read it anywheres, I know the links are not "search engine" freindly but *can* these pages somehow be searched within VB??