Portal Software - WebTemplates 4.x: VB Integrated CMS (Content Management System)

(This hack is for vb version 4.x and above. For vb 3.x, version see my profile for relevant threads.)

"WebTemplates" is a vBulletin integrated Content Management System which allows you to create vb integrated "HTML" pages in your vb admin cp very easily. The pages can inherit your vbulletin skin/style, can recognize logged-in user, can be applied permissions per user or usergroup basis, can keep visit logs, hit counts and do many more.


WEBTEMPLATES 4.x BASIC FEATURES:

• Very Easy Installation : Webtemplates can be installed to your board without modifying even a single vbulletin file. It is coded as a vb product and can be imported very easily.
• Apply VB Permissions: You can ban any webtemplate to any user or usergroups easily. 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.
• Page Counter : Each webtemplate has a built-in counter and you can display page count to your visitors and you can edit it or turn it OFF/ON per webtemplate basis.
• Visitor Logging&Tracking : You can track certain users' (by usergroup or userid) webtemplate visits to see who visited a webtemplate and when. This is configurable per webtemplate basis.
• Site Contributers (Editor) Support : 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. vB's WYSIWYG editor is supported in Editor interface.
• Page Browsers & Who is Online Display: Webtemplates can display who is browsing that webtemplate while visitor is reading them (like default forum browse display of vbulletin). Webtemplate visits can also be monitored in who is online page.
• Header/Footer Inclusion : Webtemplates can automatically use headers/footers (your default vb header/footer or custom ones)
• Help Documents : The script comes with an extensive help document.
• Admin Panel in Webtemplates : 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.
• SEO friendly URLs: You can make webtemplate URLs seo friendly in vb settings (Requires apache server).
• XML Import/Export : XML Import/Export feature allows you to backup your webtemplates and use other hack users webtemplates in your board.

ADVANCED FEATURES FOR ADVANCED USERS:

• Webquery Feature : With advanced "webquery" feature you can create dynamic webtemplates which include database query results. For instance you can easily add "last 10 threads forum X", "most active users list" etc. to your webtemplates with default webqueries that comes with installation or you can create your custom webqueries with basic SQL knowledge.
• Multi Parsing : Webtemplates can parse PHP or HTML or TEXT (=smilie/img tags/bbcode parsing like vb posts). This means you can design a page just like vb posts (TEXT parsing), standart HTML (HTML parsing) or even in PHP (PHP parsing).
• PHPINCLUDE per webtemplate : Every webtemplate has its own "phpinclude" field which you can run PHP codes before loading the Webtemplate
• Theme Support : 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 single theme for all of them, then just insert their content into this theme. If you change theme later, all 20 pages' visual will change automatically.
• Conditionals : Webtemplates supports VB3 template conditionals so you can design webtemplates which change their display under different conditions.
• 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.

Sample WebTemplates from Sites using this hack:
(Most are from 3.x versions but WebTemplate look and feel didn't change much so all will give you the idea.)

http://www.worldwideknights.com/view_mission.htm
http://www.theadminzone.com/forums/view.php?pg=aboutus
http://www.hystersisters.com/vb2/view_guidelines.htm
http://www.worldwideknights.com/view_info.htm
http://www.hystersisters.com/vb2/view_books.htm
http://www.worldwideknights.com/view_spread.htm
http://www.makeuptalk.com/forums/view.php?pg=makeuptalk-newsletter
http://www.bklab.com (entire site is designed with Webtemplates only)
(Actually this hack is one of the most popular vb hacks so it is used by hundreds -if not thousands- of vbulletin sites and you can easily find them if you go to google and search "Logician's WebTemplates" WITH quotation marks)

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..

From FAQ 13: Vbulletin already has a CMS now , why would I need this hack?

If you have CMS license, you might not need Webtemplates. On the other hand, CMS license is paid, webtemplates is free and many forum owners don't have CMS licenses.

Also please note that vb has CMS since 2010. Webtemplates was first released for vb2.x in 2002 and it was around in vb3.x, 3.5.x and above for thousands of vbulletin users who have developed their sites around webtemplates CMS. So regardless of new vb CMS owners might or might not need it, Webtemplates 4.x is still realased and supported as a courtesy to its old users and fans. I personally prefer and use Webtemplates over vb CMS and this hack lives for people who agrees with me.

Version Updates:
12.October.2013 - > Version 4.0.2
* Minor fixes for PHP 5.4.x (Fixes "Deprecated: Assigning the return value of new by reference is deprecated" errors in new PHP versions.
14.July.2012 - > Version 4.0.1
* Vbulletin changed WYSIWYG editor parsing in vb4.2.x so hack's editor.php is updated accordingly.
9.September.2010 - > Version 4.0.00
* Hack 4.00.00 is released.

[ozzy47]

Ahh cool, thanks for reporting back, I would have never though of that as I have always used FileZilla.

[dawges]

Finally added this. Thank you, now i can remove like 3 mods that this one alone replaced.

[Pocket Aces]

How to use this mod in custom style? Header is all messed up.

[wildheart]

Great mod thank you so much!

Is there a way to make these templates accessible via tapatalk?

[Logician]

Originally Posted by wildheart

Great mod thank you so much!

Is there a way to make these templates accessible via tapatalk?

I don't know a way to do that but this is really about tapatalk, not webtemplates. Tapatalk app can pull information from webtemplates if they design it like that so asking this in their forum might have a better chance of getting it done.

[midnz]

Hi Logician, I was wondering if you can solve my puzzle:

I'm using your default web query $WQ_last10threadfromforum2 but changed it to extract threads from forum#121 and it works as it should.

PHP Code:

SELECT threadid, title, postusername,postuserid,dateline 
FROM " . TABLE_PREFIX . "thread 
WHERE sticky=0 AND visible=1 AND forumid=121
ORDER BY dateline DESC
LIMIT 10 


I duplicated that web query ($WQ_last10threadfromforum3) and tried to extract the threads from forumid=230 but it didn't work. The resulting display was blank.

PHP Code:

SELECT threadid, title, postusername,postuserid,dateline 
FROM " . TABLE_PREFIX . "thread 
WHERE sticky=0 AND visible=1 AND forumid=230
ORDER BY dateline DESC
LIMIT 1 


... and so I executed an SQL Query and noticed the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=230
ORDER' at line 2

So, I did the same with the code that works as it should:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=121
ORDER' at line 2

But that one does in fact display the last ten threads from forum#121.
I did try to read the 5.1.72 manual until my eyes crossed and fell out on to my cheeks.
Can you help please?

Logician's WebTemplates 4.0.2
MySQL Version - 5.1.72-cll
vB 4.2.2

[Logician]

Originally Posted by midnz

Hi Logician, I was wondering if you can solve my puzzle:

I'm using your default web query $WQ_last10threadfromforum2 but changed it to extract threads from forum#121 and it works as it should.

PHP Code:

SELECT threadid, title, postusername,postuserid,dateline 
FROM " . TABLE_PREFIX . "thread 
WHERE sticky=0 AND visible=1 AND forumid=121
ORDER BY dateline DESC
LIMIT 10 


I duplicated that web query ($WQ_last10threadfromforum3) and tried to extract the threads from forumid=230 but it didn't work. The resulting display was blank.

PHP Code:

SELECT threadid, title, postusername,postuserid,dateline 
FROM " . TABLE_PREFIX . "thread 
WHERE sticky=0 AND visible=1 AND forumid=230
ORDER BY dateline DESC
LIMIT 1 


... and so I executed an SQL Query and noticed the following error:
So, I did the same with the code that works as it should:
But that one does in fact display the last ten threads from forum#121.
I did try to read the 5.1.72 manual until my eyes crossed and fell out on to my cheeks.
Can you help please?

Logician's WebTemplates 4.0.2
MySQL Version - 5.1.72-cll
vB 4.2.2

You can't directly run these SQL queries in applications like phpmyadmin because it has a vbulletin replacement in it. (which is " . TABLE_PREFIX . " ).

So its NORMAL that BOTH of these queries will produce a syntax error when you try to run them "as they are" in tools like phpmyadmin. If you want to run them there, you need to remove " . TABLE_PREFIX . " part and use this query:

PHP Code:

SELECT threadid, title, postusername,postuserid,dateline 
FROM thread 
WHERE sticky=0 AND visible=1 AND forumid=230
ORDER BY dateline DESC
LIMIT 10 


or

PHP Code:

SELECT threadid, title, postusername,postuserid,dateline 
 FROM thread 
 WHERE sticky=0 AND visible=1 AND forumid=121
 ORDER BY dateline DESC
 LIMIT 10 


These should run fine in phpmyadmin.

However this still does not explain why your query is not running in webtemplates. I suspect there is another problem somewhere else rather than the query syntax. I don't know if your webmaster email in config.php file is accurate but if webquery died with a DB error (like syntax error) you would get a DB error notification in your email. Since you didn't get it, I'd think that there is no problem with your webquery.

Blank pages usually means PHP errors and they happen in servers where PHP error display is turned off in php.ini. If it was on, the page would display the error and we would have more clue. Since its off, I don't know what is causing the error but maybe you can check it in your server's php error log. I'd suspect something about the webtemplate your recently created (rather than webquery).

So my first suggestion is, create a new test webtemplate with nothing in it but a simple "hello there $WQ_last10threadfromforum3" and see if it will also produce a blank page. If it works, then you can understand its somehow related to the content of your other webtemplate (not webquery!). It might be clashing with an other plugin or smt.

It would really help if you enable php error display in server so that we'll see the error message that blank page is suppose to produce.

[midnz]

Originally Posted by Logician

However this still does not explain why your query is not running in webtemplates. I suspect there is another problem somewhere else rather than the query syntax.

You were 100% correct. The problem was within my brain. I hadn't ticked that webquery to run in the page that I wanted it to run in.



Thanks for your effort. My apologies for wasting your time.

[Hasanudin]

vB 4.2.2

bellow 'Site Help Pages' :

Error: Header Template is Customised

[tbworld]

I do not use this mod, but I believe the error message is saying that it cannot auto insert changes to the header template, due to it being already modified.

You should always test a new modification on a default vbulletin setup (no customizations) -- a test board. Make sure you read the thread on this mod since there are some change you will have to make to run it on v4.2.2.