vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Update datastore.smiliecache (https://vborg.vbsupport.ru/showthread.php?t=221835)

imported_silkroad 08-26-2009 05:47 PM
Update datastore.smiliecache
 
Hi.

We changed the URL in the smilie.smiliepath to use our Content Delivery Network (CDN). However, when we look in the access logs, it is not using the CDN. So, I checked the dB and found the old URLs in:

datastore.smiliecache

Code:
a:12:{i:11;a:7:{s:8:"smilieid";s:2:"11";s:5:"title";s:8:"Confused";s:10:"smilietext";s:10:":confused:";s:10:"smiliepath";s:47:"http://www.oursite.com/images/smilies/confused.gif";s:15:"imagecategoryid";s:1:"3";s:12:"displayorder";s:1:"1";s:9:"smilielen";s:2:"10";}i:8;a:7:{s:8:"smilieid";s:1:"8";s:5:"title";s:21:"Roll Eyes (Sarcastic)";s:10:"smilietext";s:10:":rolleyes:";s:10:"smiliepath";s:47:"http://www.oursite.com/images/smilies/rolleyes.gif";s:15:"imagecategoryid";s:1:"3";s:12:"displayorder";s:1:"1";s:9:"smilielen";s:2:"10";}i:7;a:7:{s:8:"smilieid";s:1:"7";s:5:"title";s:4:"Cool";s:10:"smilietext";s:6:":cool:";s:10:"smiliepath";s:43:"http://www.oursite.com/images/smilies/cool.gif"; .... blah blah blah
Is there a way to update this smilie cache in the datastore without manually editing the dB?

Thanks!

--------------- Added [DATE]1251385811[/DATE] at [TIME]1251385811[/TIME] ---------------

We are finding vB very "CDN" unfriendly. So much of the image and static .js files are hard coded into the PHP files and the templates.

So of the images are nearly impossible to "clean up" so we can "off them" to a CDN.

Currently our CDN serves approx 20 GB of vB images, css and js per day, or about 4M objects per day.... which is over 45 objects per second.

Frankly, vB needs to be more CDN friendly ! :(


All times are GMT. The time now is 01:22 PM.

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.01159 seconds
  • Memory Usage 1,709KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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