Fantastic! you have just saved me some more work!

Thanks Logician!

nice addition in the latest release!

Hi Logician,

I ran the query for the 2.03 upgrade, but got the follwing error.
_____________________________________
Database glo_vb - Table wt2_visitlogs running on localhost
Error

SQL-query :

ALTER TABLE `wt2_templates` ADD `vbtemplates` MEDIUMTEXT NOT NULL

MySQL said:

Duplicate column name 'vbtemplates'
Back
____________________________________
However, i cant see that the table vbtemplates at all!

it seems that you run the query twice.

"vbtemplates" is not a new table, it is a column in wt2_templates table so check there. According to your error message it should be already there.

Hi Logician,

I ran the query the first time, and received a page cannot be displayed error.

So i ran the query again.

Itsalready there, have i done any damage running it twice?

Thanks!

nope.. go ahead and replace your files and you are set..

thanks! :banana:

Hi Logician!

You are a legend! this hack is magical! and i am only finished installing all the extra options! :knockedout:

Cant wait to utilise it to its full potential! :rambo:

However, i do have a very minor question! when i am in the edit section of the Webtemplates Header/Footer default_header_footer, the preview button does not seem to work? And on the bottom of the frame it says "Error on Page"

Seems to work fine when creating my own template?

I cant think of why? I have checked all the notes!

I just moved my vbulletin files from one URL to another. the database stil remains at the old URL. The rest of the baord seems to work fine. Webtemplates also seems to work fine when editing. However clicking the "Visit" linknext to a web template in teh admin CP I notice it goes to the old URL. Why is that? Can I change that somewhere? Or is it in the database?

Roxis, change your config file to the new sql location!

SQL hasn't changed. Database is still at ve.roxics.com while the site is at visionengine.com

Visit link uses the value of "$bburl" to locate the whereabouts of "view.php". And the value of $bburl is assigned by vbulletin according to your admin cp/options page setting.

So if that link is taking you to a wrong URL, it must be related to your wrong entry of your site url in admin cp options page.

Thanks Logician
That was the problem. Didn't even think to change that. :)

Any thoughts?

This might fix it:

edit webtemplate.php, find:

Replace it as:
Find:
Replace it as:
(2 instances, replace both)

Find:
REplace it as:

Thanks Logician! thats the fix! was it just a bug that slipped thru?

:)

Will your web templates allow flash to run inside of them?

Webtemplates can do anything regular HTML pages can do so yes they allow flash too. Just create your flash snippet and add it to your webtemplate just like you are adding in a regular .html page.

For some reason, i cant log out now that i have created my first webtemplate. Have you had any reported bugs of this nature?

what do you mean? You can log out in other forum pages but can not log out in webtemplate pages? Or cant log out in any pages? If later it is not related to the hack, your cookie is corrupted, clear it manually.

it very odd, i had no problems since installing the hack, but after i went to test the conditionals, i tried to log out, but i couldnt, so i was thinking "what has changed in the last 30minutes" I cant log out of the forums.

How can i manually clear the cookie? Ive tried changing the settings in Admin,but that didnt change things either.

Your probably right about the cookie being corrupted, but im not certain how to manually clear it.

check in vb.org or vb.com with keywords "corrupt+cookie" or "cant log out" you'll see many posts to see how you handle it.

thanks.

Have you had a chance to have a look at the post i left on the WebTemplates/WebQueries thread?

hello im using this and its absolutly great
im using it together with your news script logician and it owns.

however i want the following thing

i made a webtemplate index and i wanna include other webtemplates in it , how do i do it? thanks

Please check the thread, I already gave the webquery that does it.

i chekc everywhere and i only seem to find to list all templates but what i want is for example :

i created template : INFO
i created template : INDEX

now i want the content of INFO displayed in template INDEX by calling something like $INFO

is this possible? would be GREAT !

Check "theme" part in help document.

Hi,

I wonder if the webtemplate hack includes the user authentication or not? So, if the user is not logged in in that webtemplate page, there would be a login box there or sign up link there. Is the webtemplate page has the feature of session, checking the user's username and password in database if it is correct? I would like the page to include login box if not logged in. I am trying to make a form processing page using this webtemplate hack. Is it possible to achieve with this hack?

If you want only your login box to show (not the webtemplate itself), just add 1 in banned users field of your webtemplates and you will have exactly what you want.

If you want your login box to show inside webtemplate (so webtemplate itself is also displayed), use $WT_Login in your webtemplate content.

Thanks a lot Logician for the quick reply. One more question here, if I want to create a php form processing page and copy the code to the webtemplate page, can it handle the user authentication already? So when the user hit the submission button, if the webtemplate page showing not logged in, it cannot proceed. But if logged in, the submission succeeds.

I got other question not related with the hack though. When I create form processing page using php, I would like to get the userid of the user who is processing the form based on the vbulletin username, what is the variable of it? Should I look into the SQL table of 'user' in vbulletin database? Is the webtemplate page already handles that?

1- Yes. Just set the banned userid field in the TARGET webtemplate as 1
2- $bbuserinfo[userid]

So is it correct if inserting the variable like this?

$cin = mysqlconnect ("localhost","$bbuserinfo[userid]","password");

What would be the password variable?

sweet cool hack.

When can I await a 3.0 version for this great hack, Logician?

very nice hack - been playint with it all day

/me clicks install

i sort of get the drift on how it works but cant get it working vica-versa which i thought it would as it would make the queries dynamic.

The vistors count to this page i wanted to add to me index.php as a sort of counter but dont work does it.
Is there anyway i can make it work or am i going way overboard here or missed something?

Besides that it works well and yep if u have microstats just add $footer to end of your templates to get server load and web queries

@lasto: Sorry did not understand your question?

sorry Logician will try again :)

u know how your hack shows how many vistors have been on a page etc (sort of like a web counter) why cant i add that query to bottom of my forum homepage so it makes a counter there ?

Because webqueries and other webtemplate related features work only in your webtemplates (ie when view.php is run), not in your regular vb pages.

For instance to display/run that counter in your webtemplates, you first run "view.php" which has the code for the counter but to display your forum home page, you run "index.php" so counter code does not run.

You need an independent hack for your request. I can suggest hack requests forum..

nps and cheers for feedback

Hi..can someone help me here? I have problem creating php page with this hack...please take a look at this page... http://www.asianguild.com/forum/view.php?pg=oddss I am not sure what's wrong. I tried creating php page. Hope someone can help me. Thank you.