06-16-2011, 10:22 AM
admin's Avatar
admin admin is offline
Site Staff | Web Development
Join Date: Jul 2003
Posts: 4,310
Thanked 654 Times in 457 Posts
Notes for myself, but sharing it in public.

PHP Code:
UPDATE prefix_thread SET iconid 21 WHERE forumid 12 
In this query, I'm replacing all threads in forum 12 with icon 21.

Each forum/subforum in vBulletin has a forumid, which can be seen in the Forum Manager in admincp. Hover over the forum name, and in your status bar, you'll see
The icons for threads are the same as icons for posts. Icon 21 is the ID# given to the icon, as added in the Post Icons Manager in admincp. When hovering, you'll see (somewhere in the URL string)
Note that the table "prefix_threads" will need to be changed to match the prefix for your forum.

Queries are best run from a program like SQLyog Pro for $99. phpmyadmin sucks by comparison, as do most free MySQL tools -- including the official MySQL interface. SQLyog makes life easier. I need to spend time wisely when working on websites, and SQLyog helps me do that.

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
Someday, 12:01 PM
admin's Avatar
Ads / Sponsors
Join Date: ∞
Posts: 42
Thanks: ∞
Thanked 42 Times in 42 Posts
05-10-2014, 09:27 PM
kpmedia's Avatar
kpmedia kpmedia is offline
Site Staff | Web Hosting, Photo
Join Date: Feb 2004
Posts: 4,311
Thanked 374 Times in 341 Posts
Just now searched Google for this -- "vbulletin sql change icons" -- and here it was on our own site.

- Did my advice help you? Then become a Premium Member and support this site.
- Please Like Us on Facebook | Follow Us on Twitter

- Need a good web host? Ask me for help! Get the shared, VPS, semi-dedicated, cloud, or reseller you need.
Reply With Quote

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spammer Dedication Thread (i.e. Sites to Avoid, Things NOT to Buy!) admin General Discussion 14 12-21-2013 12:37 AM
Desktop background and icons changes after taking screenshot! Sossity Computers 1 12-22-2010 07:34 AM
Change sticky color in vBulletin themes admin Website and Server Troubleshooting 2 07-13-2010 02:22 PM
Anybody here know how to change your IP address? wayshway Computers 15 06-26-2006 11:13 PM

Thread Tools

All times are GMT -5. The time now is 09:33 AM