vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   What's the best way to flag a POST?? (https://vborg.vbsupport.ru/showthread.php?t=217372)

barros001 06-28-2009 10:48 PM

What's the best way to flag a POST??
 
Hello...

What's the best way to flag a post?? What I want to do is, mark a certain post in a thread as featured, so I can use this flag somewhere else to display the featured posts.. One way I can imagine is to add a new column to the posts table, but as Im new to vbulletin (at all, specially for modifications) Im not sure if this is the best way to accomplish that. Is it a good practice to add new columns to vb tables? Another idea is to create a new table to map all featured posts.
Well, resuming, I need a way to add way to mark a post in a way I can use later, and if possible to make the RSS feeds to be able to use it as well. Any ideas?

Thanks in advance

Carlos Barros

Dismounted 06-29-2009 04:36 AM

Quote:

Originally Posted by barros001 (Post 1839180)
Is it a good practice to add new columns to vb tables? Another idea is to create a new table to map all featured posts.

Either way has its own pros and cons. On one hand, you'd be loading that data nearly every time posts are fetched. On the other, you'd need to join your own table to get the data. As such, you need to weigh in which is the best option for you. In this case, going for the separate table is probably a good idea, as you'll only need that data sparingly.


All times are GMT. The time now is 03:06 AM.

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.00945 seconds
  • Memory Usage 1,709KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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