Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 04 Sep 2015, 13:56
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Real name: Malik
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
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.
__________________
One of highly customized vBCMS used for news site.
www.manshor.net
Reply With Quote
  #2  
Old 06 Sep 2015, 11:10
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #3  
Old 08 Sep 2015, 04:09
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Real name: Malik
Thank ypi Joe, I figured it out using the steps explained in How to add new field to the CMS article in article section.
__________________
One of highly customized vBCMS used for news site.
www.manshor.net
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 23:01.

Layout Options | Width: Wide Color: