WebTemplates 3.5.x: VB Integrated CMS (Content Management System)

(This hack is for vb version 3.5.x AND 3.6.x. For vb 3.0.x and 2.x see my profile for relevant threads.)

(For vb 3.7 version, please go to this thread)

"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 3.5.x BASIC FEATURES:

• Very Easy Installation : Webtemplates can be installed to your board without modifying even a single vbulletin file. It is coded as an pluggin and supports phrase system for user interfaces.
• 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:
(Some 3.5 and some are 3.0 versions but WebTemplate look and feel didn't change much so both will give you the idea)
http://www.leatherneck.com/forums/view_aboutus.htm
http://www.hystersisters.com/vb2/view_funding.htm
http://www.theadminzone.com/forums/view.php?pg=aboutus
http://www.hystersisters.com/vb2/view_guidelines.htm
http://www.hystersisters.com/vb2/view_books.htm
http://www3.fertilethoughts.com/foru...hp?pg=acronyms
http://www.makeuptalk.com/forums/vie...alk-newsletter
http://www.bklab.com (entire site is designed with Webtemplates only!)

3.5 version Admin CP screenshot attached to this post. 3.0.x screenshots (here and here) also still applies for this version.

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

Note in 6.August. 2006 : I've tested Webtemplates with vbulletin 3.6.0 gold version and they are compatible. So this hack released here is both for vb 3.5.x AND 3.6.x

Note for vb 3.7.x : (29.July.2008): For vb 3.7.x, I released a new version here:
https://vborg.vbsupport.ru/showthread.php?t=186644


Version Updates:
16.Dec.2005 - > Version 3.5.01
* Hack released.
16.Dec.2005 - > Version 3.5.02
* A webquery bug fix for boards which use table_prefix. To upgrade just overwrite hack .php files.
17.Dec.2005 - > Version 3.5.03
* A minor bug in WOL page fixed. To upgrade overwrite hack .php files + reinstall product XML
17.Dec.2005 - > Version 3.5.04
* A bug fix for edit webtemplate page not remembering webtemplate's showbrowsers setting.To upgrade overwrite hack .php files
16.Jan.2006 - > Version 3.5.05
* A bug fix for boards which has too many usergroups. To upgrade overwrite hack .php files + uninstall product, then reinstall (your existing webtemplates will be intact)
20.Aug.2006 - > Version 3.6.00
* A bug fix that can cause a MYSQL warning in a few servers in WT admin cp. A minor and unusual problem that happens in certain servers and you don't need to upgrade if you don't see such a message. To upgrade overwrite /includes/wt_include.php and /admincp/wt_wt.php files.
1.Oct.2006 - > Version 3.6.01
* A minor bug fix for showing user avatar and ipaddress in webtemplates. To upgrade overwrite /includes/wt_include.php and view.php files.
2.May.2007 - > Version 3.6.02
* IMPORTANT SECURITY UPDATE! A security problem has been fixed in this version. To upgrade overwrite /includes/wt_include.php and view.php files which is attached to this post.
21.June.2008 - > Version 3.6.03
* Two minor bugs (1 & 2) fixed.
29.July.2008 - > Version 3.7.00
* A new version for vbulletin 3.7.x is released in a seperate thread here:
https://vborg.vbsupport.ru/showthread.php?t=186644

[rootnik]

is there a way to count the number or rows returned in a webquery?

Edit: I figured out how to do this by adding the following to my Query PHP include code (after) box.

PHP Code:

$num_rows = mysql_num_rows($WQfieldDB);
echo $num_rows; 


BUT, I need to be able to call $num_rows from within the template. Any help?

[Logician]

Originally Posted by rootnik

is there a way to count the number or rows returned in a webquery?

Edit: I figured out how to do this by adding the following to my Query PHP include code (after) box.

PHP Code:

$num_rows = mysql_num_rows($WQfieldDB);
echo $num_rows; 


BUT, I need to be able to call $num_rows from within the template. Any help?

SELECT count(*) as mycount FROM " . TABLE_PREFIX . "user

$WQfield[mycount]

[rootnik]

Originally Posted by leitel

I am trying to format the output so that ONLY IF there is a 'dept', it will print out.
I tried putting code in the query output area as well as at the main page template.

$WQfield[name]<br/>
<if condition="$WQfield['dept']">
     $WQfield[dept]<br/>
</if>

Thanks!

I'm also wanting to do something similar, but can not figure out how. Is it possible?

[bashy]

Hi peeps

I am trying to make a new page with this script (below)
It does not show how i want it to

Basically what it does is pulls a specified search criteria off
eBay and lists it on a on a page as you can see the script is
php and i thought it might have just been a case of cut and
pasting it into a new template, evidently not as it dont pull
the search criteria.....

Anyway please try yourselves and see what i mean and see if
there is a work around for me

PHP Code:

<?php
### Feel free to edit suitable values the first two values are very important
// tracking id is your ebay given id for affiliates
$TrackingID = '*****'; // ***** REQUIRED
// SID is for Commision Junction tracking and given to you by cj.com
$SID = "******"; // extra tracking

$TrackingProvider = "1"; // Either 0=No Affiliate, 1=Commission Junction, 5=Mediaplex
$DefaultItems = "NTL"; // Front Page items to display by default

### OTHER INFORMATION TO CHANGE (If Required)
$TableHeaderColour = "D5E1F5"; // results table header color
$TableBorderColour = "003399"; // Table Border Colour
$ResultsFontColour = "000000"; // Results Font Colour
$FontType = "2"; // 0=Arial, 2=Times New Roman, 3=Verdana, 
$LogoType = "5"; // What eBay Logo to Display
$ResultsPerPage = '50'; // number of listings to show
$EndingTimeColour = "FF0000";
$TableWidth = "750"; // Width of eBay Table Results

### YES / NO
$SearchDescriptions = "n"; // search title and description y or n
$ShowImages = "y"; // Display thumbnails
$ShowEndTime = "y"; // auction end times
$ShowBidNumbers = "y"; // number of bids
$PopUp = "y"; // links open in a new window when this set to yes
$PayPal = "y"; // paypal logo appears when available

### COUNTRY LOCATION SECTION ** See Installion/Help Guide for Country Codes
$LocationSiteID = "3"; //
### END CONFIGURATION

$item = $_GET['item'];
if (!$item) {$item ="$DefaultItems";}
   ?> 
<HTML>
<HEAD>
<TITLE><?php echo $item; ?> from the eBay auction place.</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</HEAD>

<BODY> 

<table width="<?php print "$TableWidth"; ?>" border="0" align="left" cellpadding="4" cellspacing="1" bgcolor="<?php print "$TableBorderColour"; ?>"> 
<tr> 
<td align="center" valign="top" bgcolor="<?php print "$TableHeaderColour"; ?>">  
<div align="center"> 
<form method="get"> 
<p align="left"> 
<input name="item" type="text" value="<?php echo $item; ?>" size="35" maxlength="100"> 
<input type="submit" name="Submit" value="Search eBay"> 
<br>
<font face="Verdana" size="2">
<A HREF="http://www.qksrv.net/click-<?php print "$TrackingID"; ?>-5463217?loc=http%3A//cgi4.ebay.co.uk/aw-cgi/eBayISAPI.dll%3FRegisterShow%26ssPageName%3Dh%3Ah%3Areg%3AUS" target="_blank">
<B><font color="#000080">Register with eBay</font></B></A></font></p>
</form> 
</div></td> 
</tr> 
</table> 
<p><br>
<br>
<br>
&nbsp;</p>
<table border="0" align="left" cellpadding="4" cellspacing="1"> 
<tr> 
<td align="center"><BR> 
<BR> 
<script language="JavaScript" src="http://ilapi.ebay.com/ws/eBayISAPI.dll?EKServer&amp;ai=s%7di%3a%3d%3a&amp;bdrcolor=<?php print "$TableBorderColour"; ?>&amp;cid=0&amp;encode=ISO-8859-1&amp;endcolor=<?php print "$EndingTimeColour"; ?>&amp;endtime=<?php print "$ShowEndTime"; ?>&amp;fntcolor=<?php print "$ResultsFontColour"; ?>&amp;fs=<?php print "$FontType"; ?>&amp;hdrcolor=<?php print "$TableHeaderColour"; ?>&amp;img=<?php print "$ShowImages"; ?>&amp;lnkcolor=0000FF&amp;logo=<?php print "$LogoType"; ?>&amp;num=<?php print "$ResultsPerPage"; ?>&amp;numbid=<?php print "$ShowBidNumbers"; ?>&amp;paypal=<?php print "$PayPal"; ?>&amp;popup=<?php print "$PopUp"; ?>&amp;prvd=<?php print "$TrackingProvider"; ?>&amp;query=<?php print "$item"; ?>&amp;r0=3&amp;shipcost=<?php print "$ShowShipping"; ?>&amp;sid=<?php print "$SID"; ?>&amp;siteid=<?php print "$LocationSiteID"; ?>&amp;sort=MetaEndSort&amp;sortby=<?php print "$SortBy"; ?>&amp;sortdir=asc&amp;srchdesc=<?php print "$SearchDescriptions"; ?>&amp;tbgcolor=FFFFFF&amp;tlecolor=FFCE63&amp;tlefs=0&amp;tlfcolor=000000&amp;track=<?php print "$TrackingID"; ?>&amp;width=<?php print "$TableWidth"; ?>"></script> 
<BR> </TD> 
</TR> 
</TABLE>
</BODY>
</HTML>

[WNxWakko]

Selecting PHP does not work. I tested it by trying something simple.

I made a new page and only typed in one word in the body portion. Saved it and when I try to view, I get a blank white page. If I toggle it to html, my word shows up on the page.

[Logician]

Originally Posted by WNxWakko

Selecting PHP does not work. I tested it by trying something simple.

I made a new page and only typed in one word in the body portion. Saved it and when I try to view, I get a blank white page. If I toggle it to html, my word shows up on the page.

There is a phptest template coming with default installation. Doesn't it work?

[WNxWakko]

I just installed it yesterday. I dont know what default one you are talking about that is php.

Like I said, I did a simple test to see if it worked. I typed TEST in the content window, set it to php and I get nothing. If I set it on text or html my word shows up on the page.

[Logician]

Originally Posted by WNxWakko

I just installed it yesterday. I dont know what default one you are talking about.

Like I said, I did a simple test to see if it worked. I typed TEST in the content window, set it to php and I get nothing. If I set it on text or html my word shows up on the page.

Installation STEP 3. Apply it. Then run webtemplate "phptest" and see if it is working.

[WNxWakko]

Ok, installed your samples. Yes that phptest works. But I still dont understand why a fresh new one with nothing more than one word would'nt work.

My homepage is a .php file but its 99% html and then I have some php bits in it to call other information in. So perhaps your php is ment to be purly php with nothing more I dont know.

[Logician]

Originally Posted by WNxWakko

Ok, installed your samples. Yes that phptest works. But I still dont understand why a fresh new one with nothing more than one word would'nt work.

My homepage is a .php file but its 99% html and then I have some php bits in it to call other information in. So perhaps your php is ment to be purly php with nothing more I dont know.

Reading user manual really helps: Section 1.3.1.4.3