vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   WebTemplates 2.x: VB Integrated Content Management System (https://vborg.vbsupport.ru/showthread.php?t=54875)

Velocd 07-01-2003 05:09 AM

Whoa, this looks incredible. I'll await the vB3 version, and then mess around with it on my localhost for testing. ;)

alesis404 07-01-2003 05:14 AM

Even without the search feature this thing rocks and few hours playing you can do some very cool things!!

Using a php include I grab a html page that is uploaded to my server by a program called sMonitor, I was able to edit the sMonitor page so it blends right into my page with other stuff...very cool and might I add..dynamic!

Intex 07-01-2003 06:13 AM

Logician - I've recreated the webqueries as you suggested (even though they all looked like they were there anyway) and I still have the problem.

When visiting the test page I get the following error:

Code:

SELECT threadid, title, postusername,postuserid,dateline FROM thread WHERE sticky=0 AND visible=1 AND forumid=2 ORDER BY
dateline DESC LIMIT 10 mysql error: You have an error in your SQL syntax near ' SELECT threadid, title,
postusername,postuserid' at line 1 mysql error number: 1064 Date: Tuesday 01st of July 2003 08:13:06 AM Script: http://<br />
<a href="http://test....hp?pg=test</a>
Referer: http://test.com/forum/admin/webtemplate.php? -->


When visiting the phptest [private] page I get:

Code:

Warning: Wrong datatype for second argument in call to in_array in c:\program files\apache group\apache\htdocs\forum\view.php on line 93

Warning: Wrong datatype for second argument in call to in_array in c:\program files\apache group\apache\htdocs\forum\view.php on line 93

Warning: Wrong datatype for second argument in call to in_array in c:\program files\apache group\apache\htdocs\forum\view.php on line 93

etc. etc.

and when visiting priv_privatemessages [Private] [Draft] I get:

Code:

SELECT dateline,privatemessageid, fromuserid, touserid, title, message, touser.username AS tousername, fromuser.username
AS fromusername FROM privatemessage LEFT JOIN user AS touser ON (touser.userid=privatemessage.touserid) LEFT JOIN
user AS fromuser ON (fromuser.userid=privatemessage.fromuserid) WHERE folderid='0'
ORDER BY privatemessageid DESC LIMIT 30 mysql error: You have an error in your SQL syntax near ' SELECT
dateline,privatemessagei' at line 1 mysql error number: 1064 Date: Tuesday 01st of July 2003 08:16:04 AM Script: http://<br />
<a href="http://test....temessages</a>
Referer: http://test.com/forum/admin/webtemplate.php? -->

Your other version of the hack works fine btw. although I know these run independently.

Logician 07-01-2003 07:23 AM

Quote:

Logician - I've recreated the webqueries as you suggested (even though they all looked like they were there anyway) and I still have the problem.

When visiting the test page I get the following error:
Thx for trying..

I'm not sure why this problem occurs in your server. I thought it was related to wrong entries in the webquery table but considering the fact that you created them manually now and still problem is there, this does not look like the culprit now.

I installed this hack in different servers with different configurations and vb versions, but never run into such a problem.

The weird thing is, you are having "SQL syntax error" in your webqueries however the query in the error log seems just fine.

For instance your error logs indicates an SQL syntax error in query:
[sql]
SELECT threadid, title, postusername,postuserid,dateline FROM thread WHERE sticky=0 AND visible=1 AND forumid=2 ORDER BY
dateline DESC LIMIT 10
[/sql]
But this is a perfectly ok query and you'll see that it will run ok, if for instance you run it in your phpmyadmin.

Since I can not confirm the problem in my localhost, I'm not sure how I can help you.

If you want to give it a secondshot, I'd say, delete (drop) all hack tables (wt2_templates,wt2_queries,wt2_themes,wt2_visitlog s) and recreate them (you don't need to redo other installation steps).

If this does not help, I would need admin CP/FTP/phpmyadmin access to server that is producing the error to track the problem, if you want it fixed.

Intex 07-01-2003 07:55 AM

Logician - thx for your time. I'll try dropping the tables first and then if that doesn't work I can setup access for you. Do you have ICQ / Messenger etc so we can work through it?

PM me your details if you don't want any info here.

Floris 07-01-2003 07:56 PM

Quote:

Yesterday at 01:49 PM Mist said this in Post #10
Another amazing hack by Logician :)

I'm lost for words ... ;)

- miSt


I agree with you there mist,
very very nice work !!

ap0c 07-01-2003 10:39 PM

I'll be giving this a workout over the holiday weekend, thanks

reismarktq2 07-01-2003 10:42 PM

Great work, updated from 0.1 in a snap.

[high]* reismarktq2 clicks install. :)[/high]

AuthorZone.Com 07-02-2003 02:06 AM

Nice!
Is there a way to add another feature where the script links to the templates we create on an index page so I can use it for Book reviews and news sections? Any way to have it do it automatically and by category?

Logician 07-02-2003 07:51 AM

Quote:

Today at 06:06 AM AuthorZone.Com said this in Post #39
Nice!
Is there a way to add another feature where the script links to the templates we create on an index page so I can use it for Book reviews and news sections? Any way to have it do it automatically and by category?

Sure why not..

You can create a webquery that gets webtemplate names from webtemplate category X and list them in an other webtemplate.

For instance this sample lists webtemplate names in category 1 (your custom pages) in an other webtemplate.


All times are GMT. The time now is 11:40 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03399 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete