Update Thread Title Global

[I.G.O.T.A.]

We have a pretty big thread and the title needs to be changed for each post. Instead of doing it manually if you change the first post how do you update it globally?

Thank you,
JJ

[I.G.O.T.A.]

Anyone?

[Inna]

If no one else in that thread has chosen manual title (for example thread title is "how to", but my post which is the 3rd one in that thread titles "how not to", then either you should
1) do it manually
2) run a query in phpmyadmin to change all titles of posts of this specific thread

[MarkFL]

Create a plugin hooked at "threaddata_presave" with the code:

PHP Code:

global $vbulletin;

if ($vbulletin->GPC['threadid'] == XXX)
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "post
        SET title = '" . $vbulletin->db->escape_string($vbulletin->GPC['title']) . "'
        WHERE threadid = " . $vbulletin->GPC['threadid'] . "
        AND parentid != 0
    ");
} 


Replace "XXX" with the threadid of the thread you want affected.

[I.G.O.T.A.]

Originally Posted by MarkFL

Create a plugin hooked at "threaddata_presave" with the code:

PHP Code:

global $vbulletin;

if ($vbulletin->GPC['threadid'] == XXX)
{
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "post
        SET title = '" . $vbulletin->db->escape_string($vbulletin->GPC['title']) . "'
        WHERE threadid = " . $vbulletin->GPC['threadid'] . "
        AND parentid != 0
    ");
} 


Replace "XXX" with the threadid of the thread you want affected.

Thanks!

Going to do this now.

--------------- Added [DATE]1518972702[/DATE] at [TIME]1518972702[/TIME] ---------------

Tried it and didn't work. Any idea what I did wrong?

[MarkFL]

Are you sure you used the correct thread id?

Before you saved the plugin, did you make it active?

[I.G.O.T.A.]

Originally Posted by MarkFL

Are you sure you used the correct thread id?

Before you saved the plugin, did you make it active?

Yes, then I went and changed the title and it didn't update the other posts.

[MarkFL]

Odd...it worked for me.

[I.G.O.T.A.]

Originally Posted by MarkFL

Odd...it worked for me.

It the thread ID just the number?

Is that the only thing to change?

[MarkFL]

Originally Posted by I.G.O.T.A.

It the thread ID just the number?

Is that the only thing to change?

Can you post a link to the thread?