vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   .:: Delete Unused Custom Avatars ::. (https://vborg.vbsupport.ru/showthread.php?t=42696)

Kumaro 08-24-2002 04:15 PM

.:: Delete Unused Custom Avatars ::.
 
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 08-24-2002 04:18 PM

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 08-24-2002 05:47 PM

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 08-24-2002 05:58 PM

you mean using Fire Fly's query hack?

run this query then...

PHP Code:

DELETE FROM customavatar WHERE userid=

regards...

g-force2k2

Kumaro 08-24-2002 09:16 PM

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 08-24-2002 09:16 PM

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

g-force2k2 08-25-2002 05:16 AM

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


All times are GMT. The time now is 10:59 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00977 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete