.:: Delete Unused Custom Avatars ::.

[Kumaro]

I can't imagine how many avatars are uploaded into my database and are not even used. With over 10000 members, i'm pretty sure deleting these unused ones would decrease the size of my db significantly.

I would like to see a hack made that would search through the database for custom avatars that were uploaded and delete them if it is not used by any member.

-Thanks

[g-force2k2]

im not sure if they are deleted afterwards... but running this query may do the trick... but it is only an assumption...

PHP Code:

$DB_site->query("DELETE FROM customavatar WHERE userid=0"); 


regards...

g-force2k2

[Kumaro]

I get this error when I run this from the admin panel

Invalid SQL: $DB_site->query("DELETE FROM customavatar WHERE userid=0");
mysql error: You have an error in your SQL syntax near '$DB_site->query("DELETE FROM customavatar WHERE userid=0")' at line 1

mysql error number: 1064

[g-force2k2]

you mean using Fire Fly's query hack?

run this query then...

PHP Code:

DELETE FROM customavatar WHERE userid=0 


regards...

g-force2k2

[Kumaro]

well, the query worked...i have no idea if the unused avatars got deleted though....hopefully i'll see a difference in my db.

[Kumaro]

thank you very much g-force for your time and help.

[g-force2k2]

yeah np Kumaro... i was observing the some vb php files today and the code that i gave you wasn't neccessary :P but it did no harm either... i found that if a user removes their custom avatar or changes to a regular one that the custom avatar is automatically deleted so no probs either way i guess

g-force2k2