WebTemplates 3.x: VB Integrated Content Management System

After a long wait, here is the new 3.x version of Webtemplates for vB 3.x boards. 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. Or more simply putting, with this hack you can create regular HTML pages in your vB admin cp and these pages will be integrated into your vbulletin database about permissions, styles etc.


WEBTEMPLATES 3.x FEATURES:

• Easy Installation : Webtemplates can be installed to your board without modifying even a single vbulletin file, nor does it modify any vbulletin database table! It is coded as an add-on, not a hack.
• 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.
• Private Webtemplates : With 1 click you can make a webtemplate "private" and it will be displayed to only certain usergroups.
• Draft Webtemplates : You can put webtemplates in "draft" mode which makes them invisible to all but admins.
• 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 or ON per webtemplate basis.
• Visitor Logging&Tracking : You can track certain users' (by usergroup or userid) webtemplates visits to see who visited a webtemplate and when. This is configurable per webtemplate basis. Webtemplates have visits logs which admins can see.
• 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 Display : Webtemplates can display who is browsing that webtemplate while people is reading them (like default forum browse display of vbulletin)
• Who is Online Display : Webtemplates can display page visitors in who is online (This is Optional and require a simple hacking in file /functions_online.php). You can create private webtemplates which are hidden in who is online too.
• Header/Footer Inclusion : Webtemplates can automatically use headers/footers (your default vb header/footer or custom ones)
• Help Documents : The script comes with built-in & detailed help documents (they are webtemplates too).
• 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.
• Good Performance : Webtemplates 3.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.

ADVANCED FEATURES FOR ADVANCED USERS:

• Webquery Feature : With advanced "webquery" feature you can now add 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 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)
• 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.
• Archieve to Text File : 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.
• Outside Variables : 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)

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:
16.Feb.2005 - > Version 3.01

* Hack released.




3.5 Version :
https://vborg.vbsupport.ru/showthread.php?t=103076

[BigIke]

hmm.. nevermind. The link pops up in a different window somehow..

[ricoche]

How search engine friendly is this? Let's say you write articles or tutorials using this template system. Would this get spidered? I know lots of text the regular threads in vb will get picked up, but I am not sure if a full blown article in webtemplates will get spidered. Just wondering how SEO friendly this is.

Thanks very much.

[Logician]

Originally Posted by ricoche

How search engine friendly is this? Let's say you write articles or tutorials using this template system. Would this get spidered? I know lots of text the regular threads in vb will get picked up, but I am not sure if a full blown article in webtemplates will get spidered. Just wondering how SEO friendly this is.

Thanks very much.

Have you checked FAQ?

[BigIke]

Logician are you considering improving this hack? It is definetely my favorite out of all hacks released here. If you were, I have some ideas maybe to help you (just suggestions)..

a.) If there is a way, to parse pages as text and html? For example, on one of my pages I wanted to create a table, but also use the WYSIWYG editor below the table. This would be cool if possible.

b.) Polls in pages would also be sick

c.) Pages able to be searched from forum search

I know that coding is a hard job, because I am trying to learn PHP right now, and I'm stuck on like page 4 lol, so if you've got other priorities, I know the community and I would understand. Thanks for an awesome hack

[Logician]

Originally Posted by bringindaruckus

Logician are you considering improving this hack? It is definetely my favorite out of all hacks released here. If you were, I have some ideas maybe to help you (just suggestions)..

I appreciate your suggestions.

I agree that this hack has a lot of potential to be improved and I'd like to improve it. However my time that I can spend for my vb.org hacks are very limited and unfortunately I don't see a chance to improve this hack in the near future. As a matter of fact it even took me a year to port it to VB3 and I have other pending hacks to port before concentrating into webtemplates. Sorry about it.

a.) If there is a way, to parse pages as text and html? For example, on one of my pages I wanted to create a table, but also use the WYSIWYG editor below the table. This would be cool if possible.

if you change this line in view.php:

PHP Code:

if ($WT['doaction']=='text') {$includedtemplate=parse_bbcode2($WT['template'],0,1,1,1);} 


as

PHP Code:

if ($WT['doaction']=='text') {$includedtemplate=parse_bbcode2($WT['template'],1,1,1,1);} 


this should do what you wanted.

[SVTOA]

Outstanding work. No question.
In testing, there is no conflict of any kind with regard to using other portal software such as VBA. If you get creative with this add-on, there's a lot you can do with it. Example- you could use this for articles and such; with a more customizable format. You can index them by creating a new "forum" called "Articles" and then make the webtemplates into links. One suggestion I would add is if you have a board with multiple stylesets, you might also want to install ZeroTolerance's "Copy Templates from one style to another" hack. Then you can copy the webtemplates required when this is first installed to all your styles very quickly.

Anyway, this is great work you have done here Logician.

[Robert Basil]

How do I use a webquery to query two different tables?

I want to include the forum's name in the last post header.

I tried:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext
FROM " . TABLE_PREFIX . "thread t
LEFT JOIN " . TABLE_PREFIX . "post p ON p.postid = t.firstpostid
WHERE t.forumid In(108,109)
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 10

SELECT forumid, title, description, displayorder
FROM " . TABLE_PREFIX . "forum
WHERE forumid In(108,109)
ORDER BY title ASC
LIMIT 100

But it did not work.

And even if I do get both query's to work when I output them in the Query Results Row both Query's assign a value to the $WQfield[title] variable.

Any ideas how to get both query's to work and assign them the "title" variable to different names?

Thanks in advance, this is a great hack!

[Logician]

Originally Posted by Sportbikeworld

How do I use a webquery to query two different tables?

I want to include the forum's name in the last post header.

I tried:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext
FROM " . TABLE_PREFIX . "thread t
LEFT JOIN " . TABLE_PREFIX . "post p ON p.postid = t.firstpostid
WHERE t.forumid In(108,109)
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 10

SELECT forumid, title, description, displayorder
FROM " . TABLE_PREFIX . "forum
WHERE forumid In(108,109)
ORDER BY title ASC
LIMIT 100

But it did not work.

And even if I do get both query's to work when I output them in the Query Results Row both Query's assign a value to the $WQfield[title] variable.

Any ideas how to get both query's to work and assign them the "title" variable to different names?

Thanks in advance, this is a great hack!

Make a LEFT JOIN in first query:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumidpostid
WHERE t.forumid
IN ( 108, 109 )
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 10

[Robert Basil]

Originally Posted by Logician

Make a LEFT JOIN in first query:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumidpostid
WHERE t.forumid
IN ( 108, 109 )
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 10

Thanks for the fast response!

So to pull the info can I just use $WQfield[t.title] and $WQfield[f.title] ?

[Logician]

Originally Posted by Sportbikeworld

Thanks for the fast response!

So to pull the info can I just use $WQfield[t.title] and $WQfield[f.title] ?

ok let's change the query like this:

SELECT t.threadid, t.title, t.firstpostid, t.lastpost, f.title as forumtitle, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, p.pagetext
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumidpostid
WHERE t.forumid
IN ( 108, 109 )
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 10

now $WQfield[title] gives you thread title and $WQfield[forumtitle] gives you forum title.