View Single Post
  #3  
Old 06-09-2016, 07:01 PM
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Location: Libya
Posts: 497
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the author not come online for more than a year on his forum, if there is one can help I can send the files to him to make a check.

--------------- Added [DATE]1465507930[/DATE] at [TIME]1465507930[/TIME] ---------------

Quote:
Originally Posted by Dave View Post
Have you asked the author of the plugin? We don't really know how the plugin works, nor do we have access to the (paid) plugin to look into it.
If you want to help please send me your email in PM and I will send you a copy from the plugin.

--------------- Added [DATE]1465528553[/DATE] at [TIME]1465528553[/TIME] ---------------

Hi
I figured out the problem position
here is the code
PHP Code:
$sql "SELECT a.pagetext,a.contentid, a.previewimage, node.nodeid, node.parentnode, node.url, info.title, node.myfeaturetype
   FROM " 
TABLE_PREFIX "cms_article as a
   LEFT JOIN " 
TABLE_PREFIX "cms_node AS node ON a.contentid = node.contentid
   INNER JOIN " 
TABLE_PREFIX "cms_nodeinfo AS info ON info.nodeid = node.nodeid
            WHERE node.myfeaturetype = '4'
            ORDER BY node.publishdate DESC "
;
 
//WHERE node.contenttypeid = " . vB_Types::instance()->getContentTypeID("vBCms_Section").
 //AND ((node.permissionsfrom IN ($viewlist)  AND node.hidden = 0) OR (node.permissionsfrom IN ($publishlist))) ORDER BY node.nodeleft

 
$result $vbulletin->db->query_read_slave($sql);
 
$sections = array();
 while (
$section $vbulletin->db->fetch_array($result)) {
  
$pagetext $section["pagetext "];
  
$sections[] = array(
       
'title' => $section['title'],
       
'link' => $vbulletin->options['bburl']."/content.php?".$section['nodeid'].'-'.$section['url'],
       
'description' => get_summary($pagetext,$des_length),
       
'image' => $previewimage 
$section["pagetext "] return values if I put any one from DB query
for example
PHP Code:
$pagetext $section["previewimage"]; 
will return the value
all fields which is not mediumtext type will return value, and all fields with mediumtext format return NULL
could you help in this?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01252 seconds
  • Memory Usage 1,782KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete