vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How to remove thread titles in existing replies? (https://vborg.vbsupport.ru/showthread.php?t=144318)

tobias_t 04-08-2007 08:45 AM

How to remove thread titles in existing replies?
 
Hello there,

One feature that always annoyed me in vBulletin was that the thread title was automatically inserted with a "Re:" in every reply posting. I think it was pointless and visually unpleasant, and hardly anybody ever used the title field to enter something specific in their replies.

Now I finally found out how to disable this feature in Admin CP. However, I would also like to remove all thread titles in existing thread replies (not for the initial thread postings of course) to clean up and unify the look of the forum.

How can this be done on a technical level?

Thanks, Tobias

Marco van Herwaarden 04-13-2007 11:56 AM

The following query will probably work, but is not tested:

[sql]UPDATE `post` AS p
LEFT JOIN thread AS t on (p.postid = t.firstpostid)
SET p.title = ""
WHERE t.firstpostid IS NULL[/sql]

Make sure to have a recent backup before running manual queries.


All times are GMT. The time now is 03:54 PM.

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.01583 seconds
  • Memory Usage 1,704KB
  • 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)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