View Single Post
  #1  
Old 01-30-2009, 04:31 AM
Saintless Saintless is offline
 
Join Date: Nov 2005
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Postbit Ligecy need to show coustomised field value

Hi Experts
I need to show a custom column field of vb_socialgroupmember table, say field name 'member_status' which will retrieve by user id of poster. Like,
"SELECT member_status FROM vb_socialgroupmember WHERE userid='who post/reply the thread'"
it will be retrive no/one/more row, user may the member of diffrent group so can have diffrent status of diffrent group. those all status if any will show in postbit legacy.
i am trying to put the above query in showthread.php page within a loop at line 1047,

while ($post = $db->fetch_array($posts))
{
$status_show=$db->query_read("SELECT member_status FROM vb_socialgroupmember WHERE userid=".$post['userid']."");
while($poster_status=$db->fetch_array($status_show))
{
eval('$poster_group_status .= "' . fetch_template('postbit_status_show') . '";');
}

I add a template name 'postbit_status_show' and put the following code there
<div class="smallfont">
Status :$poster_status[member_status]
</div>
Then in 'postbit_legacy' template i put '$poster_group_status' above code $post[joindate] where i want to show the status.but it is not working.
Is there any problem in this code or any new way to do this task, please help.

Thankx in advance
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01197 seconds
  • Memory Usage 1,761KB
  • 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
  • (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