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

[Highlander]

Hi logician .. i tried it out and i will port all planned functions to webtemplates now :d

here is an example page
http://spielplanet2.de/forums/view.p...lpha_news_v0_2

everything seems to work fine .. but only 2 little not very important things a did not figure out

1. in the old webtemplates..there had been a webquery to show last 10 posts/theads of userX (userX means evry user see his own last posts/threads) like a personal control center ..
2. i need to query out 2 tables .. to make attachments visible as picture/link if i call out the query "show last Threads FROM forumid=2" .. so i would be able not to ashow only thread titels..of course its nice..but i just would like to show also the attachment made in the first post.. of our news forums

Example:
Thread 2345 has an attached image in Foruimd=23 -> it is possible to show up the attachment with a LEFT join in the query?

please help me out.. i read now 2 weeks evry hint in my sql books..but did not figure it our..maybe it isnt possible.. but if its possible i would like to implement the feature

greetings from germany

[Logician]

1- attached.
2- not possible

[MeTaL_oRgY]

Hi logician.. I pm?d u.. but I think I better ask here....
well.. I installed webtemplates just for one reason... I want pass-protected pages on my site. I?ve managed to have the login box on the page but when they log in they are re-directed to a re-directing page (lol) and then lead to the forum index. Is there anyway of having them redirected to the page index?? and after that is managed (if can be managed) how do I create pass-protected pages?

here?s my test page:
http://zelda.wi3k.net/test.php

thnx for ur time

[Logician]

Originally Posted by MeTaL_oRgY

Hi logician.. I pm?d u.. but I think I better ask here....
well.. I installed webtemplates just for one reason... I want pass-protected pages on my site. I?ve managed to have the login box on the page but when they log in they are re-directed to a re-directing page (lol) and then lead to the forum index. Is there anyway of having them redirected to the page index?? and after that is managed (if can be managed) how do I create pass-protected pages?

here?s my test page:
http://zelda.wi3k.net/test.php

thnx for ur time

Your page is down and I couldn't understand the question either. Please clarify.

[MeTaL_oRgY]

it´s not down Oo.... I´m there right no Oo...

well... what I want is to create a section on my website, lets say... emulation, and have it pass protected so guests can´t see it. In order to acces the page the visitors must register to the forum and then they will be able to acces the emulation page. In addition to this, I want to have the login form on a part of my menu to save time... I created the test page with the login box template, but when they log-in they are redirected to the forum index and I want em to be redirected to the test page.....

I´ve seen some scripts that allow you to have a website database but I guess what I want to have is a Website and forum database all in one... so ppl don´t have to register twice.

hope I clarify it... my english is not too good XD....

again, thnx for ur time

[Logician]

I fail to see how this page is related to webtemplates hack. It looks like a page of "Logician News" hack. If you use a login box in a "webtemplate" (not logician news hack!), it is suppose to take you to that webtemplate after you login successfully.

[MeTaL_oRgY]

lol, yeah, it?s the logicians news hack, as it?s my test page, I use it for everything I want before adding to my website. Your news hack works great!! thnx for that one by the way!

if you see below the news, you?ll see the login box, that?s a webtemplate .... and if you login it redirects to the forum and no to the test pagee, that?s what I don?t wnt ... I dunno if it?s possible or no...

[Logician]

Originally Posted by MeTaL_oRgY

lol, yeah, it?s the logicians news hack, as it?s my test page, I use it for everything I want before adding to my website. Your news hack works great!! thnx for that one by the way!

if you see below the news, you?ll see the login box, that?s a webtemplate .... and if you login it redirects to the forum and no to the test pagee, that?s what I don?t wnt ... I dunno if it?s possible or no...

Your login form lacks a hidden parameter such as this:
<input type="hidden" name="url" value="http://your url to jump after login">

[MeTaL_oRgY]

I guess I´m starting to get it.. thnx a lot for ur patiente and time logician!!! and thnx for creating such great hacks!!

[Highlander]

thx logician

wanna see what i maged till now with webtemplates? its still alpha study *smile*
http://spielplanet2.de/forums/view.p...lpha_news_v0_2 will finish about two weeks .. got not plenty of time to spend with coding all to my needs ...

ahh got a question.. ok tow queries.. wont qwork .. i see .. but how about a long querie wich crosses thread and attachment table ?
you just have integrated one in the standart installations of webtemplates.. ..something with LEFT JOIN and on this way you get tables and collumns from two tables .. is there really no way about?
something like that:

PHP Code:

SELECT * FROM threads ..... LEFT JOIN attachment WHERE id= 


is this a way out?

greetings
Highlander

[Logician]

Originally Posted by Highlander

is there really no way about?
something like that:

PHP Code:

SELECT * FROM threads ..... LEFT JOIN attachment WHERE id= 


is this a way out?

You can not do that because attachments are not attached to the threads they are attached to the posts.

So the actual query should be
SELECT post.*, attachment.* FROM post LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid where ...
but this does not even help you altough it successfully returns relevant attachments per post.

It does not work, because after you get the attachment info with this query you need some PHP code to do to display the attachment correctly. They are permissions code, extensions code etc.

Edit functions.php and check the code after this line and you'll understand me better:

PHP Code:

if ($post[attachmentid]!=0 and $post[attachmentvisible]) { 


Bottom line you can not do it.

[Highlander]

i am very sad .. so sad.. i will finish my live now .. cant live anymore with this malfunctions ..

okay.. so i looked and understand it now even a little bit better .. yes you are right the attachment table is crossing trough posts and threads table to get the right attachmend_id ..

hey but wait maybe there is an trick
When i selsect Threads from forum 304 .. i can arrange a selection from attachment table right beside to get the attachments from forum 304 ?
and i have a new question about the query i insert in the webquery list

when i insert this query:

PHP Code:

SELECT * FROM threads WHERE forumid=304 .. 


<- i am able to get the results from this forum . okai thats very fine and also very nice working

but what about showing up threads from more than one forum ?

PHP Code:

SELECT * FROM threads WHERE forumid=304,305,306 ORDER ..blabla.. 


i get now an error and no results.. anyway it dont matter.. its only one query..

Bug Report
$nowbrowsing -> is not showing up alwys..sometimes no session is showing up .. dont know why.. but i could figure out..that sometimes no session is started.. .. i am recognized with username end everything what belongs to this username.. but brwowsing around somtimes looses the session informations and nowbrowing is not function anymore .. have an idea?

How about this page:
http://spielplanet2.de/forums/view.php?s=$session[sessionhash]&pg=alpha_news_v0_2

it is okai for you to give you there some credits? And where do you want placed a 88x31 button or simple text link?
You did the biggest job on creating these sites.. so the credits belongs to you

[Logician]

Originally Posted by Highlander

$nowbrowsing -> is not showing up alwys..sometimes no session is showing up .. dont know why.. but i could figure out..that sometimes no session is started.. .. i am recognized with username end everything what belongs to this username.. but brwowsing around somtimes looses the session informations and nowbrowing is not function anymore .. have an idea?

yeah I know about that. Actually it shows you but when you refresh. I'll correct it in the next version.

it is okai for you to give you there some credits? And where do you want placed a 88x31 button or simple text link?

thx. no need for a button but if you like you can keep "powered by Logician Webtemplates v.x" text at the bottom.

[codemonkey]

One Question: When will the system work for vBulletin 3??

[Highlander]

the next version will be then for vb3?

*crying* .. i do not plan converting this year ..cause i build up so much with this versionb... i dont have the time to convert everything.. so i will try to use that for my need and newsfeeds

greetings..and much thanx for helping out in this thread...