vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Portal Software - WebTemplates 4.x: VB Integrated CMS (Content Management System) (https://vborg.vbsupport.ru/showthread.php?t=250202)

ozzy47 10-13-2013 09:31 AM

Ahh cool, thanks for reporting back, I would have never though of that as I have always used FileZilla.

dawges 10-13-2013 09:29 PM

Finally added this. Thank you, now i can remove like 3 mods that this one alone replaced.

Pocket Aces 11-04-2013 02:30 PM

How to use this mod in custom style? Header is all messed up.

wildheart 02-14-2014 09:31 AM

Great mod thank you so much!

Is there a way to make these templates accessible via tapatalk?

Logician 02-14-2014 10:25 AM

Quote:

Originally Posted by wildheart (Post 2481057)
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 02-25-2014 07:00 AM

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.
PHP Code:

SELECT threadidtitlepostusername,postuserid,dateline 
FROM 
" . TABLE_PREFIX . "thread 
WHERE sticky
=AND visible=AND forumid=121
ORDER BY dateline DESC
LIMIT 10 

I 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.
PHP Code:

SELECT threadidtitlepostusername,postuserid,dateline 
FROM 
" . TABLE_PREFIX . "thread 
WHERE sticky
=AND visible=AND forumid=230
ORDER BY dateline DESC
LIMIT 1 

... and so I executed an SQL Query and noticed the following error:
Quote:

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 2
So, I did the same with the code that works as it should:
Quote:

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

Logician 02-25-2014 08:22 AM

Quote:

Originally Posted by midnz (Post 2483589)
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.
PHP Code:

SELECT threadidtitlepostusername,postuserid,dateline 
FROM 
" . TABLE_PREFIX . "thread 
WHERE sticky
=AND visible=AND forumid=121
ORDER BY dateline DESC
LIMIT 10 

I 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.
PHP Code:

SELECT threadidtitlepostusername,postuserid,dateline 
FROM 
" . TABLE_PREFIX . "thread 
WHERE sticky
=AND visible=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:


PHP Code:

SELECT threadidtitlepostusername,postuserid,dateline 
FROM thread 
WHERE sticky
=AND visible=AND forumid=230
ORDER BY dateline DESC
LIMIT 10 

or
PHP Code:

SELECT threadidtitlepostusername,postuserid,dateline 
 FROM thread 
 WHERE sticky
=AND visible=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 02-26-2014 04:29 AM

Quote:

Originally Posted by Logician (Post 2483600)
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 03-01-2014 06:24 AM

vB 4.2.2

bellow 'Site Help Pages' :

Quote:

Error: Header Template is Customised

tbworld 03-01-2014 10:17 AM

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.


All times are GMT. The time now is 01:16 PM.

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.01407 seconds
  • Memory Usage 1,765KB
  • 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
  • (6)bbcode_php_printable
  • (6)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