Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 24 Mar 2013, 14:36
cravendale cravendale is offline
 
Join Date: Oct 2010
Mass Prefix Change?

Hi,

Is there a tool or as I was looking for, an SQL query to mass change all threads within a specific forum to a specified prefix
without having to do all the posts manually?

thanks
Reply With Quote
  #2  
Old 24 Mar 2013, 16:12
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Did you try a search? I seem to recall a modification to mass change prefixes.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 24 Mar 2013, 16:45
cravendale cravendale is offline
 
Join Date: Oct 2010
There is this...
Change Threads' Prefix Inline
http://www.vbulletin.org/forum/showt...ghlight=prefix

But it will only allow working per page rather than mass.
Even changing per page is going to take a long time.

Can see any other mod for vB 4 that will do this?
Reply With Quote
  #4  
Old 24 Mar 2013, 20:45
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
That is the one I was thinking of. Otherwise, you would need to query your database. Something like:

UPDATE thread SET prefixid=xxxx WHERE forumid=yyyy AND prefixid=zzzzzz

(Never tried - try on a backup database first and be sure to backup your live site before doing it there.)
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
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 05:35.

Layout Options | Width: Wide Color: