WebTemplates 2.x: VB Integrated Content Management System

After a long wait, here is the new 2.x version of Webtemplates. First a short introduction for users who are not familiar with the old version:

This hack is a vbulletin integrated content management system. Term "Webtemplates" stands for dynamic webpages that reside in your MYSQL database and administered inside your vbulletin admin control panel. But they are more than regular site pages because they can automatically inherit visual design of your forum, can apply permissions according to your vb usergroup settings, can keep track of page counts, last visitorname/visit time, display page browsers in the page itself and in your whoisonline page etc. So basically webtemplates are dynamic web pages of your site which are powered by vbulletin.


WEBTEMPLATES 2.x FEATURES:
([New] indicates feature that is recently introduced in this 2.x version)

• Easy Installation : Webtemplates can be installed to your board without hacking even a single vbulletin file! It is coded as an add-on, not a hack.
• Conditionals : Webtemplates has built-in support for Logician's advanced templates conditionals so you can design webtemplates which change their display under different conditions. (Even if you don't have that hack installed)
• Private Webtemplates (NEW): With 1 click you can make a webtemplate "private" and it will be displayed to only certain usergroups.
• Apply VB Permissions: You can ban any webtemplate to any user or usergroup according to their userids or usergroupids. So for instance you can design a webtemplate which only members can see while guests can not or only user A can not see etc.
• Draft Webtemplates (NEW): You can put webtemplates in "draft" mode which makes them invisible to all but admins.
• Visitor Logging&Tracking (NEW): You can track certain users (by usergroup or userid) to monitor who visited a webtemplate and when. This is configurable per webtemplate basis.
• Site Contributers (Editor) Support (NEW): You can grant editing permissions for certain users or usergroups for your webtemplates individually and they will be able to update these webtemplates using their own editor interface.
• Categories (NEW): Webtemplates 2.x supports multi-categories for better webtemplate organizations.
• Multi Parsing (NEW): Webtemplates can now parse PHP or HTML or TEXT (=smilie/img tags/bbcode parsing like vb posts)
• Default variables : You can use/display certain variables in your webtemplates like username of the visitor, visitor email address, last visit time, page creation time, page last edit time, Last visitor name, last visit time etc.
• Outside Variables (NEW): Advanced users can now use outside variables in webtemplates, then webtemplates will accept/use/process user sent variables via HTTP_GET and HTTP_POST methods (eg. a HTML form can post to a webtemplate with this feature)
• Page Counter : Webtemplate has built-in counter and you can display page count to your visitors and you can edit it or turn it OFF or ON per webtemplate basis.
• Page Browsers Display (NEW): Webtemplates can display who is browsing that webtemplate while people is reading them (like default forum browse display of vbulletin)
• Who is Online Display (NEW): Webtemplates can display page visitors in who is online (This is Optional and require a simple hacking in file online.php). You can create private webtemplates which are hidden in who is online too.
• Theme Support (NEW): Webtemplates support "themes" which are parent webtemplates which include child webtemplates in them. For instance if you have 20 similiar pages which uses the same visual look, you can make a theme for them, then just insert their content into this theme. If you change theme later, all 20 pages' visual will change automatically.
• Header/Footer Inclusion : Webtemplates can use headers/footers (your default vb header/footer or custom ones)
• PHPINCLUDE per webtemplate (NEW) : Every webtemplate has its own "phpinclude" field which you can run PHP codes before loading the Webtemplate
• Help Documents : The script comes with built-in & detailed help documents (they are webtemplates too).
• Webquery Feature : With advanced "webquery" feature you can now add create dynamic webtemplates which include database query results. For instance you can easily add member count/post count/thread count/last 10 threads forum X etc. to your webtemplates with default webqueries that comes with installation or you can create your custom webqueries with basic SQL knowledge.
• Archieve to Text File (NEW): Webtemplates/Webqueries can be downloaded to a text file with one click for archiving purposes. You can also easily share these text files with other hack users.
• Login/Logout box (NEW): You can insert login/register box to your webtemplate if visitor is a guest and log off box if she is a member.
• Admin Panel in Webtemplates (NEW): Your webtemplates can include an "admin panel" displayed to only admins and by using them you can access many details and stats of your page while you are browsing them.
• Better Performance (NEW): Webtemplates 2.x structured so that it performs well even under heavy load conditions and high traffic servers. (See Performance issues below)
• Easy Back up: Simply back up your database (inside vbulletin or externally) and all your webtemplate structure is also backed up automatically.

For screenshots, FAQ, performance issues, migration from old version to new version, see below.

If you use the hack, clicking here will make sure you'll know about updates&bug fixes. It will also help me understand how many people is using the hack so please click the install button if you use it. Thank you..


Version Updates:
30.July.2003 - > Version 2.03

* Adds feature to include regular vbtemplates into webtemplates

2.02 users: apply this fix to update.
New users: Get the hack from the first post of this thread (which is the latest version), you don't need to apply this update.

12.July.2003 - > Version 2.02

* Fixes a bug with outside variables.

2.01 users: apply this fix to update.
New users: Get the hack from the first post of this thread (which is the latest version), you don't need to apply this update.

2.July.2003 - > Version 2.01

* Fixes bug that bothers webqueries if "Show Template Name" option enabled in vb admin cp
* Fixes bug in webquery $WQ_mostactivemembers
* Fixes visual look of webtemplate test
* Fixes visual look of admin panel and makes sure it looks ok in dark backgrounded boards too.

2.00 users: update here.
New users: Get the hack from the first post of this thread (which is the latest version), you don't need to apply this update.


Webtemplates 3.x (for vb.3.x) is released here:
https://vborg.vbsupport.ru/showthread.php?t=76422

[Velocd]

Whoa, this looks incredible. I'll await the vB3 version, and then mess around with it on my localhost for testing.

[alesis404]

Even without the search feature this thing rocks and few hours playing you can do some very cool things!!

Using a php include I grab a html page that is uploaded to my server by a program called sMonitor, I was able to edit the sMonitor page so it blends right into my page with other stuff...very cool and might I add..dynamic!

[Intex]

Logician - I've recreated the webqueries as you suggested (even though they all looked like they were there anyway) and I still have the problem.

When visiting the test page I get the following error:

SELECT threadid, title, postusername,postuserid,dateline FROM thread WHERE sticky=0 AND visible=1 AND forumid=2 ORDER BY 
dateline DESC LIMIT 10 mysql error: You have an error in your SQL syntax near ' SELECT threadid, title, 
postusername,postuserid' at line 1 mysql error number: 1064 Date: Tuesday 01st of July 2003 08:13:06 AM Script: http://<br />
<a href="http://test....hp?pg=test</a> Referer: http://test.com/forum/admin/webtemplate.php? -->

When visiting the phptest [private] page I get:

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

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

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

etc. etc.

and when visiting priv_privatemessages [Private] [Draft] I get:

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: Tuesday 01st of July 2003 08:16:04 AM Script: http://<br />
<a href="http://test....temessages</a> Referer: http://test.com/forum/admin/webtemplate.php? -->

Your other version of the hack works fine btw. although I know these run independently.

[Logician]

Logician - I've recreated the webqueries as you suggested (even though they all looked like they were there anyway) and I still have the problem.

When visiting the test page I get the following error:

Thx for trying..

I'm not sure why this problem occurs in your server. I thought it was related to wrong entries in the webquery table but considering the fact that you created them manually now and still problem is there, this does not look like the culprit now.

I installed this hack in different servers with different configurations and vb versions, but never run into such a problem.

The weird thing is, you are having "SQL syntax error" in your webqueries however the query in the error log seems just fine.

For instance your error logs indicates an SQL syntax error in query:
[sql]
SELECT threadid, title, postusername,postuserid,dateline FROM thread WHERE sticky=0 AND visible=1 AND forumid=2 ORDER BY
dateline DESC LIMIT 10
[/sql]
But this is a perfectly ok query and you'll see that it will run ok, if for instance you run it in your phpmyadmin.

Since I can not confirm the problem in my localhost, I'm not sure how I can help you.

If you want to give it a secondshot, I'd say, delete (drop) all hack tables (wt2_templates,wt2_queries,wt2_themes,wt2_visitlog s) and recreate them (you don't need to redo other installation steps).

If this does not help, I would need admin CP/FTP/phpmyadmin access to server that is producing the error to track the problem, if you want it fixed.

[Intex]

Logician - thx for your time. I'll try dropping the tables first and then if that doesn't work I can setup access for you. Do you have ICQ / Messenger etc so we can work through it?

PM me your details if you don't want any info here.

[Floris]

Yesterday at 01:49 PM Mist said this in Post #10
Another amazing hack by Logician

I'm lost for words ...

- miSt

I agree with you there mist,
very very nice work !!

[ap0c]

I'll be giving this a workout over the holiday weekend, thanks

[reismarktq2]

Great work, updated from 0.1 in a snap.

[high]* reismarktq2 clicks install. [/high]

[AuthorZone.Com]

Nice!
Is there a way to add another feature where the script links to the templates we create on an index page so I can use it for Book reviews and news sections? Any way to have it do it automatically and by category?

[Logician]

Today at 06:06 AM AuthorZone.Com said this in Post #39
Nice!
Is there a way to add another feature where the script links to the templates we create on an index page so I can use it for Book reviews and news sections? Any way to have it do it automatically and by category?

Sure why not..

You can create a webquery that gets webtemplate names from webtemplate category X and list them in an other webtemplate.

For instance this sample lists webtemplate names in category 1 (your custom pages) in an other webtemplate.