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

[Robert Basil]

Originally Posted by Logician

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

You have a typo above.

LEFT JOIN forum f ON f.forumid = t.forumidpostid

Should be:

LEFT JOIN forum f ON f.forumid = t.forumid

After fixing the typo it works great, thanks!

[Robert Basil]

Here is how I am using your script. Everything on the page is pulled from the database using your script (except for the racing map)

http://www.pocketbikeplanet.com/view.php?pg=racing

I'm also using it for other areas of the site as well.

I've been a VB admin for over 4 years now and this is by far my favorite script.

P.S. To others using this script, please don't send me PM's or Email's for help. Post you questions in this thread and I'll try and help.

[Spinball]

Originally Posted by Logician

I don't get your problem exactly. All I'm saying is that IF your webtemplate is "PHP parsed" you can NOT include any header and footer in it, otherwise you'd get PARSE error. (This is also stated in help document). Headers and footers are for "TEXT" or "HTML" parsed webtemplates.

If your webtemplate is already TEXT or HTML parsed but you still get an parse error, then paste the content of your header and webtemplate that gives the error and I'll check.

So how do you get the header and footer displayed on a page if the template is PHP?
I have created a template which does a standard search of a database and displays the results. Problem is that there is no header and footer like there is with HTML pages.

[Robert Basil]

How do I tell the code below to show the last 3 posts from each forum and sort them by forum?

This is what I have so far...

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, t.iconid, t.forumid
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumid
WHERE t.forumid
IN ( 19, 116 )
AND t.open = '1'
AND t.visible = '1'
ORDER BY forumtitle DESC
LIMIT 0 , 3

[Robert Basil]

Just an update on my progress...

I tried using the code:

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, t.iconid, t.forumid
FROM thread t
LEFT JOIN post p ON p.postid = t.firstpostid
LEFT JOIN forum f ON f.forumid = t.forumid
WHERE t.forumid
IN ( 19, 116 )
AND t.open = '1'
AND t.visible = '1'
GROUP BY f.title
ORDER BY forumtitle DESC
LIMIT 0 , 3

The code above does two things that confuse me. (Keep in mind I am a very novice mySQL guy, so I am easily confused)

#1. It only grabs one thread from each forum. (2 threads total on the page even though the limit is set to 3)

#2. The thread that it grabs is the oldest thread, not the newest one.

I've tried so many different query's I'm about ready to pull my hair out. Any ideas Logician??

[Marco van Herwaarden]

This is an extreme difficult thing to do in just 1 query. I have seen your other post about this also, but didn't have a brainwave for a solution yet. Maybe when i wake up.

[Spinball]

You're only getting two rows in your result because your are grouping by forum and you are selecting from 2 forums.
I don't have a quick solution either. But I would start looking at nested selects, maybe.

[Robert Basil]

Originally Posted by MarcoH64

This is an extreme difficult thing to do in just 1 query. I have seen your other post about this also, but didn't have a brainwave for a solution yet. Maybe when i wake up.

Any help you can provide would be great! Thanks!

[Robert Basil]

Originally Posted by Spinball

You're only getting two rows in your result because your are grouping by forum and you are selecting from 2 forums.
I don't have a quick solution either. But I would start looking at nested selects, maybe.

Well, you lost me as soon as you said "nested selects".

I admit I'm way over my head here with mySQL query syntax knowledge.

[Spinball]

Originally Posted by Sportbikeworld

Well, you lost me as soon as you said "nested selects".

I admit I'm way over my head here with mySQL query syntax knowledge.

Short term visit the MySQL website, longer term, buy a book. Or go on a course. I have been fortunate enough to have been sent on about 3 SQL courses at Oracle in Reading (UK) by my previous employer and if you make money from your board then taking the time/money to amass some SQL knowledge will be a worthwhile investment.

Logician - any help on my question above, please?