SQL query to change thread icons in vBulletin
Notes for myself, but sharing it in public. :thumb:
PHP Code:
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 Code:
&id=21 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. |
Just now searched Google for this -- "vbulletin sql change icons" -- and here it was on our own site. :laugh:
|
Site design, images and content © 2002-2024 The Digital FAQ, www.digitalFAQ.com
Forum Software by vBulletin · Copyright © 2024 Jelsoft Enterprises Ltd.