Quantcast SQL query to change thread icons in vBulletin - digitalFAQ Forum
  #1  
06-16-2011, 10:22 AM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,361
Thanked 604 Times in 445 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
Code:
&f=12
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)
Code:
&id=21
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
  #2  
05-10-2014, 09:27 PM
kpmedia's Avatar
kpmedia kpmedia is offline
Site Staff | Web Hosting, Photo
 
Join Date: Feb 2004
Posts: 4,295
Thanked 357 Times in 333 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
Reply




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 04:12 AM