vb.org Archive - How to add usertitle to CMS

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - How to add usertitle to CMS (https://vborg.vbsupport.ru/showthread.php?t=320111)

SilverBoy

09-04-2015 11:56 AM

How to add usertitle to CMS

Hi

I want to add usertitle and User Biography to CMS article, I tried to add user.usertitle to the sql query which was in article.php file around line 170 and start with

PHP Code:


		
			
if (self::QUERY_BASIC == $required_query OR self::QUERY_CONTENT == $required_query)

        {

             $sql = "SELECT node.nodeid, node.showrating, node.setpublish, node.new,

directly after user.username, but I get unexpected error after that directly I don't know why !!?

So could you please help me in showing both usretirle and userbio in the articles?

Thanks in advance.

BirdOPrey5

09-06-2015 09:10 AM

From what I can see it's only returning data from the node table, if the user table hasn't been joined in the query you can't pull data from the user table in the same query.

What is the full SQL query? You only posted a small part so i can't be sure.

SilverBoy

09-08-2015 02:09 AM

Thank ypi Joe, I figured it out using the steps explained in How to add new field to the CMS article in article section.

All times are GMT. The time now is 09:16 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00948 seconds Memory Usage 1,710KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: