PDA

View Full Version : Mass change post icon


ade_dnb
07-15-2008, 09:42 AM
Is there any way I can mass change the post icon for a specific forum? Ive had a look through the database and it looks like the forum id is stored in a different place to the icon id so im not sure about doing an SQL query.

I can't do it the easy way and change all the icons because ive got quite a few that can't have the same icon as others.

Any help on this will save me going through all the posts and doing them by hand. :eek:

--------------- Added 1216131208 at 1216131208 ---------------

Ok im a nonse..... Was looking at post table not thread.......

So ive changed all of the threads that I wanted to using this query UPDATE `directrs_vbul1`.`vb_thread` SET `iconid` = '15' WHERE `vb_thread`.`forumid` =48 Is there anywhere else that the iconid is stored?

kpmedia
07-24-2010, 06:10 PM
Thanks for this post. I need to do this myself, on a forum.
Did this work for you?
Did you have to change the iconid anywhere else?

I know this thread is 2+ years old, but maybe you're still around.