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

[Logician]

Get an error with this:

Can't find FULLTEXT index matching the column list
This query works on 3.x structure but apparently it is not possible to do this with one query in vb 4.x due to db changes

[FlyingRon]

I've inherited an existing vB/WebTemplates installation. The files installed seem to be identical to the 4.0.1 I downloaded. The TEXT and HTML webtemplates when run display the header and footers (and even insert the edit this page link if that is allowed) but the actual contents of the template do not appear in the output. The webquery used also is executed.

If I use the PHP type, then I get output that I specifically print (but no headers or footers).

Pretty much behave the same if I use the test ones, old ones we had lying around, or attempt to generate new ones.

Any ideas?

[Logician]

I've inherited an existing vB/WebTemplates installation. The files installed seem to be identical to the 4.0.1 I downloaded. The TEXT and HTML webtemplates when run display the header and footers (and even insert the edit this page link if that is allowed) but the actual contents of the template do not appear in the output. The webquery used also is executed.

If I use the PHP type, then I get output that I specifically print (but no headers or footers).

Pretty much behave the same if I use the test ones, old ones we had lying around, or attempt to generate new ones.

Any ideas?
Edit the webtemplate you have this problem and check which theme its using. (In the section that says "Using a Theme?").

Then edit that theme (eg. Two Column Theme) and make sure it has this variable in it:
{includedtemplate}

If it does, try disabling all other pluggins/products/hacks but webtemplates and see if this solve the problem (in case another hack is clashing with WT).

If this also does not solve the problem, give me admin cp/ftp access to your board and I can check.

[FlyingRon]

Thanks, Log....putting the includedtemplate into the style fixed it.

[Christos Teriakis]

Hello,

Seems to be very useful addon. Can someone tell me if it supports CMS widgers or Forum blocks? Or do I need to build my own?

Thank you
Chris

[Naijasite]

best page creator

[Naijasite]

Please how do i make all the Template to be edited by WYSIWYG?

[ged]

Hi, first of all, I'd like to say I've searched the entire topic to prevent double posting same problem. :)

I'm trying to modify webquery WQ_lastxthreadfromforumy only to show thread title's first 20 characters:

SELECT threadid, LEFT(title, 20), dateline
FROM " . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5

Can you tell me what I did wrong? :)

Thank you very much.

[Logician]

Hi, first of all, I'd like to say I've searched the entire topic to prevent double posting same problem. :)

I'm trying to modify webquery WQ_lastxthreadfromforumy only to show thread title's first 20 characters:

SELECT threadid, LEFT(title, 20), dateline
FROM " . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5Can you tell me what I did wrong? :)

Thank you very much.
I believe this should work:

SELECT threadid, LEFT(title, 20) as title, dateline
FROM thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5

[ged]

I believe this should work:

SELECT threadid, LEFT(title, 20) as title, dateline
FROM thread
WHERE sticky=0 AND visible=1 AND forumid=6
ORDER BY dateline DESC
LIMIT 5
Thank you very much, unbelievable support speed! :)

[Logician]

Please how do i make all the Template to be edited by WYSIWYG?
WYSIWYG editor applies to TEXT Webtemplates only. This is for technical reasons. Vb editor may convert special chacters like (< > & " ') so it is not possible to use it with PHP or HTML webtemplates.

[mfowler70]

Installed on 4.2.0 PL 3 and get the following at the top of the page when viewing any of the sample templates:

Deprecated: Assigning the return value of new by reference is deprecated in /home/xxx/xxx/board/view.php on line 787

Deprecated: Assigning the return value of new by reference is deprecated in /home/xxx/xxx/board/view.php on line 916

[mfowler70]

Nevermind. I did the same thing Darth did here (https://vborg.vbsupport.ru/showpost.php?p=2099565&postcount=32) and the problem is now solved.

Great mod!

[bradleyj]

I was wondering do I have to link each page individually or is their like one page I link to and it shows all of the content I wasnt sure if that was addressed in the information giving to install. If it is im too blind to see it apparently. Could you direct me in the right direction or tell me the info please..

Thank you for your hard work btw you always bring good mods

[Logician]

I was wondering do I have to link each page individually or is their like one page I link to and it shows all of the content I wasnt sure if that was addressed in the information giving to install. If it is im too blind to see it apparently. Could you direct me in the right direction or tell me the info please..

Thank you for your hard work btw you always bring good mods
By default you create a webtemplate and then link it individually in any page you like.

However in the test installation, I created a demo webtemplate (theme named Site Information Pages Template) which automatically groups certain webtemplates and provide a navigation bar for all of them. You can check this demo if you want to group and link certain webtemplates together.

[deadlySniper]

I am having issues where the themes are not adopting my default themes layout.
http://ptheroes.com/forum/view.php?pg=test

[hugh_]

Is it possible to reference pages generated by this mod using THIS_SCRIPT ==?

Thanks.

[Logician]

Is it possible to reference pages generated by this mod using THIS_SCRIPT ==?

Thanks.
Not individual webtemplates but webtemplates in general is possible with THIS_SCRIPT == 'view'

[hugh_]

I also need to reference a template with the scriptname, what should I use?

Thanks!

[Logician]

I also need to reference a template with the scriptname, what should I use?

Thanks!
Please read message id 222, 223, 224 in the thread:
https://vborg.vbsupport.ru/showpost.php?p=2362806&postcount=223

[hugh_]

Thank you. This is very useful.

[haze108]

thank you so much !

[selwonk]

I've just installed WebTemplates on a new forum. I used it very successfully on a forum I sold a few years ago and, IMHO, it remains far and away the best CMS mod available for vBulletin.

One slight problem I'm experiencing is with table styling. It's possible I solved this when I used it before, but I can't get it to work now.

The rendered HTML table looks like this:<table cellspacing="5" cellpadding="5" border="1">
<thead>
<tr>
<th>Username</th>
<th>No. of referrals</th>
</tr>
</thead>
<tbody><tr>
<td>Prof Pat Pending</td>
<td>3</td>
</tr><tr>
<td>Raven</td>
<td>1</td>
</tr><tr>
<td>Water Cooled</td>
<td>1</td>
</tr></tbody>
</table>The border is rendered correctly, but:

a) the TH attribute does not render as bold;
b) the cellpadding is ignored;
c) the cellspacing is ignored.

Whilst I appreciate that the general consensus is to avoid TABLE tags and replace with DIVs, this is tabular data so perfectly suited to a TABLE.

Are there vBulletin CSS table classes that I've overlooked which might help me to render my tables in a suitably vBulletinesque way?

Thanks in advance!

[selwonk]

Ok.

I hadn't considered checking the WebTemplate themes. :rolleyes:

If anybody is looking to apply custom styling to elements within WebTemplates pages, add a new CSS block before </head> in your selected theme and set customisation there. :)

[Logician]

Ok.

I hadn't considered checking the WebTemplate themes. :rolleyes:

If anybody is looking to apply custom styling to elements within WebTemplates pages, add a new CSS block before </head> in your selected theme and set customisation there. :)
Alternatively you can use plain in-line CSS to design any HTML elements.

Eg.
<th style="font-weight:bold; color:#000099">Username</th>

Webtemplates does not "touch" your styling actually. Its vb's style sheet that applies to any webtemplate content.

[EricGT]

I love this mod. It would be great if each page template could pass a unique 'THIS_SCRIPT' variable though. I have several WebTemplate pages that each have their own navigation tab. Due to the fact that the same script generates all of them, only one of these tabs can be the 'Selected tab'' when it is clicked, allowing it to have a different color title text and to show a submenu. I worked around this by hacking the functions_navigation.php file, but it would be great to have this addressed within the mod.

Thanks for a great system. Even with a v4.2.1 CMS install, there is still a real need for the abilities this mod provides.

[EricGT]

I love this mod. It would be great if each page template could pass a unique 'THIS_SCRIPT' variable though. I have several WebTemplate pages that each have their own navigation tab. Due to the fact that the same script generates all of them, only one of these tabs can be the 'Selected tab'' when it is clicked, allowing it to have a different color title text and to show a submenu. I worked around this by hacking the functions_navigation.php file, but it would be great to have this addressed within the mod.

Thanks for a great system. Even with a v4.2.1 CMS install, there is still a real need for the abilities this mod provides.

After I posted the above comments, I looked through this thread and found the navigation tab issue brought up over and over, with no satisfactory answer. I think it is pretty important to be able to have more than one WebTemplate-generated page linked to in the navigation bar and still have the 'Selected' function of the nav tabs work. I'm not sure why something this fundamental wasn't addressed long ago.

The answer was a simple one. I put a conditional statement above the line where the 'THIS_SCRIPT' constant was defined. It takes the pg= value and assigns it as the THIS_SCRIPT constant.

Drawing from something Logician did, I took it a step further and looked for an underscore in the pg= value. If one was found, the text to the left of the underscore and the underscore itself becomes the THIS_SCRIPT value. This way, if there are a large number of submenu items for a WebTemplates-generated page, all of the sub-pages can highlight the correct navigation tab if the same prefix is used in their template names, without having to list each of their THIS_SCRIPT values in the navigation tabs admin area. That variable only allows 30 characters of data, so that capacity could quickly become exhausted.

In the canned templates installed with this mod, every template that used the Site Information Pages Template theme has a template name that starts with 'info_'. With this naming schema, every Webtemplates-generated page that used that prefix would highlight the same navigation tab using my mod to this mod, if the value 'info_' was added as the Tab Script(s) value for that tab.

Anyway, I am a little embarrassed to share the code I used. I am a PERL programmer that is new to PHP and I couldn't get the Regex conditionals to function for me cleanly in PHP, so the code is a little sloppy. It works great though. In the view.php file, replace the // #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'view'); with the code below.

// #################### DEFINE IMPORTANT CONSTANTS #######################

if (preg_match('/view\.php/i', $_SERVER['REQUEST_URI'])) {
$SelectResult = preg_split( '/=/', $_SERVER['REQUEST_URI'] );
$SelectVariable = $SelectResult[1];
if (preg_match('/_/i', $SelectVariable)) {
$SelectResult2 = preg_split( '/_/', $SelectVariable );
$SelectVariable = $SelectResult2[0] . '_';
}
} else {
$SelectVariable = 'view';
}
define('THIS_SCRIPT', $SelectVariable);

The THIS_SCRIPT value will then be whatever you named a given template, unless your template name has an underscore '_' in it. Then, it will be all of the name left of the underscore and the underscore itself. I left the underscore in there to prevent any accidental matches with other names. 'Info', for instance, might get used in a variable name that did not start with 'info_'.

I hope this info helps. If you find this helpful and can clean up my See-Spot-Run Regex's in my code, I'd appreciate it if you could post the cleaned up code here, so I can see what I was doing wrong. I had to use the two preg_split commands because I couldn't pull the relevant data out of the string in the conditional matches. This is really easy in PERL. I suspect it is in PHP as well. I just got tired of trying to make it work. Thanks and thanks again to Logician, for a wonderful mod.

[brandon515]

Is there a way to create a web query that would list the last x number of threads for a forum for a specific date?

Thanks,
Brandon

[Logician]

Is there a way to create a web query that would list the last x number of threads for a forum for a specific date?

Thanks,
Brandon
Its possible. You can customize default webqueries named "$WQ_last10threadfromforum2" OR "$WQ_last5threadcontentsfromforum2".

Eg.

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 = '2'
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 5


can become:

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 = '2' AND t.dateline < UNIX_TIMESTAMP('2010-03-27 03:00:00')
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 5


OR


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 = '2' AND t.dateline < UNIX_TIMESTAMP('2010-03-27 03:00:00') AND t.dateline > UNIX_TIMESTAMP('2010-01-01 03:00:00')
AND t.open = '1'
AND t.visible = '1'
ORDER BY t.dateline DESC
LIMIT 0 , 5

[Muhammad Rahman]

try install in vB 4.2.1 ,,
but give error .
Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\diskus\view.php on line 787

Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\diskus\view.php on line 916

anyone can help ??

[Logician]

try install in vB 4.2.1 ,,
but give error .
Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\diskus\view.php on line 787

Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\diskus\view.php on line 916anyone can help ??
Its not about vb version, its about PHP version in your server.

Edit view.php, find lines 787 and 916 and put a @ symbol at the beginning of files. Error will be gone.

[tommyxv]

After I posted the above comments, I looked through this thread and found the navigation tab issue brought up over and over, with no satisfactory answer. I think it is pretty important to be able to have more than one WebTemplate-generated page linked to in the navigation bar and still have the 'Selected' function of the nav tabs work. I'm not sure why something this fundamental wasn't addressed long ago.

The answer was a simple one. I put a conditional statement above the line where the 'THIS_SCRIPT' constant was defined. It takes the pg= value and assigns it as the THIS_SCRIPT constant.

Drawing from something Logician did, I took it a step further and looked for an underscore in the pg= value. If one was found, the text to the left of the underscore and the underscore itself becomes the THIS_SCRIPT value. This way, if there are a large number of submenu items for a WebTemplates-generated page, all of the sub-pages can highlight the correct navigation tab if the same prefix is used in their template names, without having to list each of their THIS_SCRIPT values in the navigation tabs admin area. That variable only allows 30 characters of data, so that capacity could quickly become exhausted.

In the canned templates installed with this mod, every template that used the Site Information Pages Template theme has a template name that starts with 'info_'. With this naming schema, every Webtemplates-generated page that used that prefix would highlight the same navigation tab using my mod to this mod, if the value 'info_' was added as the Tab Script(s) value for that tab.

Anyway, I am a little embarrassed to share the code I used. I am a PERL programmer that is new to PHP and I couldn't get the Regex conditionals to function for me cleanly in PHP, so the code is a little sloppy. It works great though. In the view.php file, replace the // #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'view'); with the code below.

// #################### DEFINE IMPORTANT CONSTANTS #######################

if (preg_match('/view\.php/i', $_SERVER['REQUEST_URI'])) {
$SelectResult = preg_split( '/=/', $_SERVER['REQUEST_URI'] );
$SelectVariable = $SelectResult[1];
if (preg_match('/_/i', $SelectVariable)) {
$SelectResult2 = preg_split( '/_/', $SelectVariable );
$SelectVariable = $SelectResult2[0] . '_';
}
} else {
$SelectVariable = 'view';
}
define('THIS_SCRIPT', $SelectVariable);

The THIS_SCRIPT value will then be whatever you named a given template, unless your template name has an underscore '_' in it. Then, it will be all of the name left of the underscore and the underscore itself. I left the underscore in there to prevent any accidental matches with other names. 'Info', for instance, might get used in a variable name that did not start with 'info_'.

I hope this info helps. If you find this helpful and can clean up my See-Spot-Run Regex's in my code, I'd appreciate it if you could post the cleaned up code here, so I can see what I was doing wrong. I had to use the two preg_split commands because I couldn't pull the relevant data out of the string in the conditional matches. This is really easy in PERL. I suspect it is in PHP as well. I just got tired of trying to make it work. Thanks and thanks again to Logician, for a wonderful mod.

This works great. For the life of me I cannot figure out what this was never implemented in the mod. Who wouldn't want the correct tab highlighted for the page?

Thanks

[bulbasnore]

I must be missing some syntax change in the versions. Can't find it in the vb manual? Can anyone spot it?

In PHP Include:
$cleantestvar =& $vbulletin->input->clean_gpc('g', 'imageid', TYPE_INT);

In template:
<center><img src="http://pokegym.net/gallery/displayimage.php?imageid=$cleantestvar"></center>
Welcome to the PokeGym Researching Tower, $bbuserinfo[username]!
<if condition="is_member_of($bbuserinfo, 33)"><a href="http://pokegym.net/gallery/editimage.php?i=$cleantestvar" target=_blank>Edit</a> this image or metadata</if>

This used to work until the version change (and upgrade to new web templates, hooray!)

So passing this gives a blank page!
http://server/forums/view.php?pg=towercard&imageid=52494
with nothing in Apache error_log.

but executing the template with $cleantestvar substituted with the value 52494 gives the desired result, so I'm guessing $cleantestvar is coming up null/blank.

Suggestions?

[Logician]

I must be missing some syntax change in the versions. Can't find it in the vb manual? Can anyone spot it?

In PHP Include:
$cleantestvar =& $vbulletin->input->clean_gpc('g', 'imageid', TYPE_INT);In template:
<center><img src="http://pokegym.net/gallery/displayimage.php?imageid=$cleantestvar"></center>
Welcome to the PokeGym Researching Tower, $bbuserinfo[username]!
<if condition="is_member_of($bbuserinfo, 33)"><a href="http://pokegym.net/gallery/editimage.php?i=$cleantestvar" target=_blank>Edit</a> this image or metadata</if>This used to work until the version change (and upgrade to new web templates, hooray!)

So passing this gives a blank page!
http://server/forums/view.php?pg=towercard&imageid=52494with nothing in Apache error_log.

but executing the template with $cleantestvar substituted with the value 52494 gives the desired result, so I'm guessing $cleantestvar is coming up null/blank.

Suggestions?
VB4.x has changed the structure of variable support in templates so I removed outside variable support from the hack as it is now too complicated to use for non-coder users.

In vb4.x you can't simply use a variable inside a template without registering it in the PHP code. So outside variables can still be used in webqueries etc. but to display them inside templates, they should be declared like "$templater->register('cleantestvar', $cleantestvar);" in view.php.

Or to avoid this, maybe you can trick vb by assigning your variable to an already recognized vb variable in phpinclude like:
$vbulletin->input->clean_array_gpc('r', array(
'cleantestvar' => TYPE_STR,
));

$vbulletin->options[cleantestvar] = $vbulletin->GPC['cleantestvar'];

As $vbulletin->options is a declared variable, vb will allow this in templates.

As for the error, you can trace it via PHP error log, not apache error log. You can enable it in WHM if already not enabled, or simply turn on screen display to see them posted directly to screen during running of the scripts.

[redrock]

Question, I have this installed just fine. I have the ProGamer Theme installed and each of the pre-installed templates don't bring across the background image of the theme. Please help!!

[hugh_]

I'm seeing the following errors since I upgraded to vbulletin 4.2.2 and php 5.4...

Warning: Assigning the return value of new by reference is deprecated in ..../includes/wt_class_core.php on line 305
Warning: Assigning the return value of new by reference is deprecated in ..../view.php on line 81

[ozzy47]

Warning: Assigning the return value of new by reference is deprecated in ....Bla Bla Bla

How to fix.

Open the file, view.php, in that file find the following (twice in the file):

$parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());

Replace with:
$parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());

Open the file, includes/wt_class_core, in that file find the following:

$bgclass =& $GLOBALS['bgclass'];

Replace it with this:

$bgclass = $GLOBALS['bgclass'];

Find:
$parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());

Replace with:
$parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());

Find:
$parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());

Replace with:
$parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());

[hugh_]

That worked. Thank you very much!

[ozzy47]

Not a problem, glad to help. :)

[redrock]

Fresh install on 4.2.2 Please help.

[ozzy47]

That screenshot don't help, you need to get the error message from your error logs, or from your email.

[redrock]

Where is the logs at?

[ozzy47]

If you are not sure where the are at, ask your host, they should be able to tell you where they are located on your setup.

[redrock]

I am the host lol. I rent a vps server. PM sent.

[ozzy47]

Then if you own the server, you should be able to find the logs, If you lease it from a service, contact them.

[redrock]

Its weird cause I installed the Advanced Application forms mod too and I get the same thing when I click on any of the links too

[redrock]

I think its not letting me modify the admin folder. hmmmm

[ozzy47]

Then I would suggest to do the following.

Open your config.php and below<?php add this line:

define('DISABLE_HOOKS', true);

So it looks like this:
<?php
define('DISABLE_HOOKS', true);
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 4.2.1

Go to your ACP, disable this mod, In Plugins & Products, then remove the define('DISABLE_HOOKS', true); from the config.php

Then you can uninstall the mod since it seems to blow your site up.

[Logician]

Fresh install on 4.2.2 Please help.
Give more info please. At what URL do you get that error? When did it start to happen?

If you get it in regular vb pages, I doubt its about webtemplates. Webtemplates does not have any hooks in vb system which can effect other vb pages. A problem in the hack will only effect its own page.

BTW internal server error in all pages can mean you messed up .htacess file. If you changed it recently, change it back. (or at least temporarily remove it to get rid of the problem)

[redrock]

Long story short....I'm a dumbass. :) I was using FireFtp to upload files. My provider suggested to use filezilla to upload files and that did the trick. Something was happening when I uploaded using the firefox add-on. All is up and working now. Thanks!!

[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]

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.
SELECT threadid, title, postusername,postuserid,dateline
FROM " . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=121
ORDER BY dateline DESC
LIMIT 10I 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.
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 2So, 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 2But 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]

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.
SELECT threadid, title, postusername,postuserid,dateline
FROM " . TABLE_PREFIX . "thread
WHERE sticky=0 AND visible=1 AND forumid=121
ORDER BY dateline DESC
LIMIT 10I 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.
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:



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

or

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]

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.

http://imageshack.com/a/img32/1315/zw9u.jpg

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.

[JenniferK]

I am using the Header 2 location in ad management. I am running 4.2.2, using the default style. Based on advice I was given to correct a display issue (header 2 ad was just right of the header image instead of all the way to the right), this has been corrected on all forum pages, but it is still displaying incorrectly on the pages using webtemplates (see attachment). The attachement image is not a webtemplate page, but that is how it is still displaying there. To fix it on the forum pages, I entered this into additional.css:

.ad_global_header {
float:{vb:stylevar right};
margin-right:0px !important;
}
#ad_global_header1 {
float:{vb:stylevar left};
padding:0px !important;
margin:0px !important;
}
#ad_global_header2 {
float:{vb:stylevar right};
padding:0px !important;
margin-top:50px !important;
}

What can I do to fix it on the pages that use webtemplates?

[Logician]

I am using the Header 2 location in ad management. I am running 4.2.2, using the default style. Based on advice I was given to correct a display issue (header 2 ad was just right of the header image instead of all the way to the right), this has been corrected on all forum pages, but it is still displaying incorrectly on the pages using webtemplates (see attachment). The attachement image is not a webtemplate page, but that is how it is still displaying there. To fix it on the forum pages, I entered this into additional.css:

.ad_global_header {
float:{vb:stylevar right};
margin-right:0px !important;
}
#ad_global_header1 {
float:{vb:stylevar left};
padding:0px !important;
margin:0px !important;
}
#ad_global_header2 {
float:{vb:stylevar right};
padding:0px !important;
margin-top:50px !important;
}What can I do to fix it on the pages that use webtemplates?
Depends on the webtemplate. If its using a theme like "Default Basic Theme", then you can edit that theme's webtemplate "default_basic_theme1" and insert it after "{vb:raw headinclude}" part.

[JenniferK]

Yes, they are all Default Basic Theme that I am concerned with. I am not great at all of this, can you give me some more direction? I know what template to edit now, but what am I inserting exactly? Does it go immediately after "{vb:raw headinclude}"?

Sorry to be dense, my know-how with all of this is minimal.

[Logician]

Yes, they are all Default Basic Theme that I am concerned with. I am not great at all of this, can you give me some more direction? I know what template to edit now, but what am I inserting exactly? Does it go immediately after "{vb:raw headinclude}"?

Sorry to be dense, my know-how with all of this is minimal.
Yes according to what you described it seems that you need to edit webtemplate theme named "Default Basic Theme" and after the section {vb:raw headinclude} copy paste your code.

[JenniferK]

You mean the same code (as above) that I put into addition.css? If so, I did try that and the image was still in the same place but the code was listed out at the top of the page. If it is something else I am supposed to put after, then I'm not sure it that code would be.

[Logician]

You mean the same code (as above) that I put into addition.css? If so, I did try that and the image was still in the same place but the code was listed out at the top of the page. If it is something else I am supposed to put after, then I'm not sure it that code would be.
PM me admin cp access to your forum and also url to the problematic webtemplate and let me check.

[Bluefin221]

I installed this, worked absolutely perfectly on the default VB theme however when I try to use my theme which I set as default TF_Ideal the background is missing and the template a bit messy.

The footer is also having some serious alignment problems, I searched through the threads and only one other user mentioned this but he/she received no answer, here is an image of whats happening.

https://vborg.vbsupport.ru/

[Logician]

I installed this, worked absolutely perfectly on the default VB theme however when I try to use my theme which I set as default TF_Ideal the background is missing and the template a bit messy.

The footer is also having some serious alignment problems, I searched through the threads and only one other user mentioned this but he/she received no answer, here is an image of whats happening.

http://www.prestigeclubgaming.com/forums/images/themeissue.png
Unfortunately my assistence with custom styles can be pretty limited (close to none) because:
1- I'm a coder and I have very limited designing skills.
2- There are way too many custom skins users have.

So I wish I could help but I can't. Hopefully you get help from another hack user or the designer of that custom skin.

[Bluefin221]

Unfortunately my assistence with custom styles can be pretty limited (close to none) because:
1- I'm a coder and I have very limited designing skills.
2- There are way too many custom skins users have.

So I wish I could help but I can't. Hopefully you get help from another hack user or the designer of that custom skin.

Thank you for at least responding, hopefully someone can help.

[JenniferK]

I have to throw in my thanks for prompt assistance to fix the issue I was having!

[Bluefin221]

I'll probably need to uninstall this :(

I read through every comment and one other person has the same theme and issue as me, no one responded to him, upon looking at his site its the exact same as mine. Real pity as this mod would have been perfect for me.

[dethfire]

There is no uninstall code for this?

[Logician]

There is no uninstall code for this?
Webtemplate Post-Installation FAQ: Question 20

[Replicators]

Well this was a heartbreaking experience, come to find out it only works on the default theme.

[Logician]

Well this was a heartbreaking experience, come to find out it only works on the default theme.
If you have a custom skin, you need to apply its CSS code to Webtemplate header/footer. Most skin designers don't follow vbulletin's general template structure ($headinclude - $header - $content - $footer) so it makes impossible for the hack to inherit their look without their CSS is applied to Webtemplate templates.

[TheLastSuperman]

Well this was a heartbreaking experience, come to find out it only works on the default theme.

Ohh but it does! See Logician's reply below yours ;).

If you have a custom skin, you need to apply its CSS code to Webtemplate header/footer. Most skin designers don't follow vbulletin's general template structure ($headinclude - $header - $content - $footer) so it makes impossible for the hack to inherit their look without their CSS is applied to Webtemplate templates.

I love this mod, have always loved it truth be told and now that vBAdvanced CMPS is pretty much phasing out I've been recommending this to everyone ;).

Thanks Logician, mean it!

[Gn_Snake]

If you have a custom skin, you need to apply its CSS code to Webtemplate header/footer. Most skin designers don't follow vbulletin's general template structure ($headinclude - $header - $content - $footer) so it makes impossible for the hack to inherit their look without their CSS is applied to Webtemplate templates.


Hi, Logician and thank you for this plugin.
I am years i use it but over time i changed my skin and today using the theme_default of this plugin the footer and the header misaligned on the page.
I did not understand what should I do to fix?

Thx

[Logician]

Hi, Logician and thank you for this plugin.
I am years i use it but over time i changed my skin and today using the theme_default of this plugin the footer and the header misaligned on the page.
I did not understand what should I do to fix?
Thx
If you give me the URL of your both pages (forum working fine and WT broken), I can take a look.

[Gn_Snake]

If you give me the URL of your both pages (forum working fine and WT broken), I can take a look.

Yes Logician,
These are the pages where the header part is misaligned:
http://www.hardwaregame.it/forum/view.php?pg=collaboratore
http://www.hardwaregame.it/forum/view.php?pg=la_sala_giochi

I removed the footer command because it seemed to me at the center of the page

Thx

[Logician]

Your custom skin has an additional CSS which you need to add to WT's head section:

<link href="http://www.hardwaregame.it/forum/clientscript/vbulletin_css/style00035l/additional.css?d=1458772949" type="text/css" rel="stylesheet">

[Gn_Snake]

Your custom skin has an additional CSS which you need to add to WT's head section:

<link href="http://www.hardwaregame.it/forum/clientscript/vbulletin_css/style00035l/additional.css?d=1458772949" type="text/css" rel="stylesheet">


I'm sorry i did not understand what i enter, and where? :o

[Logician]

I'm sorry i did not understand what i enter, and where? :o
I think easiest will be if you pm me your admin cp details.

[dmm2020]

Question I have: Does the HTML version parse the PHP tags if I embed them into HTML in this mod? I want to create some custom forms for my website with it.

[Logician]

Question I have: Does the HTML version parse the PHP tags if I embed them into HTML in this mod? I want to create some custom forms for my website with it.
HTML version does not parse PHP tags but there is also a PHP version which can directly run PHP so I believe you can use that one.

[dmm2020]

HTML version does not parse PHP tags but there is also a PHP version which can directly run PHP so I believe you can use that one.


Question I have then, does PHP version parse embedded HTML or do I have to echo the whole thing?

[dmm2020]

Reason being, is when I get to it in the next few days, I need to design a form that receives GET and POST data and then pass that on via email or PM depending on what I decide to do with it.

[MarkFL]

Reason being, is when I get to it in the next few days, I need to design a form that receives GET and POST data and then pass that on via email or PM depending on what I decide to do with it.

In my opinion, you would likely be better off simply creating a custom page that renders a custom template containing the form, and a support script that handles the actions based on the data input into the form.

I'm not trying to discourage use of this product...we use it at MHB in fact, but for the purpose you have stated, I would use my own custom code instead. :)

[Logician]

Question I have then, does PHP version parse embedded HTML or do I have to echo the whole thing?
It parses embed HTML. Eg. this works:

// This is a TEST PHP Code to demonstrate webtemplates hack PHP parsing feature:

echo "Time now is $today<br><br>";

echo "You registered <b>this</b> board at ".date('M-d-Y h:i:s',$vbulletin->userinfo[joindate]);

?>

<p><i>hello</i></p>
<?php

exit;

[dmm2020]

In my opinion, you would likely be better off simply creating a custom page that renders a custom template containing the form, and a support script that handles the actions based on the data input into the form.

I'm not trying to discourage use of this product...we use it at MHB in fact, but for the purpose you have stated, I would use my own custom code instead. :)

Actually, too much effort to create a complete custom product. I finished a form in 2 daysusing dhtmlx ajax and it's working fine and hope to go live with it this weekend on my website.

Still trying to figure out what issues was with other coders in the forum because I have this product completely implemented and replacing the vB CMS on my website.

[WOLF-G4MIN-X]

Not to sound stupid or anything, but I really dont get this. I installed it, i also get what its for, but the whole themes thing I dont understand. How can I at least have the theme be the same as my current vB theme ? Is that whole thing very complicated ?

I wish i would have the vBCMS, but my vB4 license back then I bought without the CMS, and I sure dont pay 200 Dollar or more to get it now for something A) i already have, the forum, and B) I dont want/need vB5.

Could someone maybe explain to me, how I can theme it the way I have my current site theme ?
Any help would be appreciated.

[Logician]

Not to sound stupid or anything, but I really dont get this. I installed it, i also get what its for, but the whole themes thing I dont understand. How can I at least have the theme be the same as my current vB theme ? Is that whole thing very complicated ?

I wish i would have the vBCMS, but my vB4 license back then I bought without the CMS, and I sure dont pay 200 Dollar or more to get it now for something A) i already have, the forum, and B) I dont want/need vB5.

Could someone maybe explain to me, how I can theme it the way I have my current site theme ?
Any help would be appreciated.
When you create a new webtemplate, set :
theme = "DEFAULT BASIC THEME"
header = "DEFAULT VB HEADER"
footer = "DEFAULT VB FOOTER"
and this web template will have your current vb theme. "test" webtemplate that comes with default installation is a good example.