The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
How to find all users with bmp avatars
How can I find all users who have an avatar that is in bmp format?
|
#2
|
||||
|
||||
AdminCP -> Maintenance -> Execute SQL Query
Code:
select userid from customavatar where filename LIKE '%bmp%' If you have a table prefix, include your prefix before "customavatar". That will bring you back results with userid's for anyone with a bmp formatted avatar. |
3 благодарности(ей) от: | ||
MarkFL, RichieBoy67, zylstra |
#3
|
|||
|
|||
Awesome! Thanks, Gio!
|
Благодарность от: | ||
Gio~Logist |
#4
|
||||
|
||||
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|