digitalFAQ.com Forum

digitalFAQ.com Forum (https://www.digitalfaq.com/forum/)
-   Website and Server Troubleshooting (https://www.digitalfaq.com/forum/web-tech/)
-   -   SQL query to change thread icons in vBulletin (https://www.digitalfaq.com/forum/web-tech/3202-sql-query-change.html)

admin 06-16-2011 10:22 AM

SQL query to change thread icons in vBulletin
 
Notes for myself, but sharing it in public. :thumb:

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.

kpmedia 05-10-2014 09:27 PM

Just now searched Google for this -- "vbulletin sql change icons" -- and here it was on our own site. :laugh:


All times are GMT -5. The time now is 10:15 AM

Site design, images and content © 2002-2024 The Digital FAQ, www.digitalFAQ.com
Forum Software by vBulletin · Copyright © 2024 Jelsoft Enterprises Ltd.