The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb






Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Huge tags = sphere crash
Author Message
Coruja
Sphere Developer
*****

Posts: 987
Likes Given: 5
Likes Received: 226 in 187 posts
Joined: Jul 2012
Reputation: 7

Dimension Shard

Post: #4
RE: Huge tags = sphere crash
this tag is used on my SQL paperdoll sync engine
all @Equip/@Unequip got stored on this tag to later call a TIMERF (2~4 seconds) and run a single SQL command to everything stored. This engine is used to prevent overload on SQL server using another new command for each @Equip/@Unequip

function to reproduce the exact behavior:
Quote:[FUNCTION lol]
TAG.Sync.Paperdoll="layer1=NULL, layercor1=NULL, layer2=NULL, layercor2=NULL, layer6=NULL, layercor6=NULL, layer6=5447, layercor6=713, layer1=5184, layercor1=NULL, layer2=7030, layercor2=2057, layer6=NULL, layercor6=NULL, layer6=5138, layercor6=2057, layer1=NULL, layercor1=NULL, layer2=NULL, layercor2=NULL, layer6=NULL, layercor6=NULL, layer6=5447, layercor6=713, layer22=NULL, layercor22=NULL, layer22=9860, layercor22=1940, layer2=5122, layercor2=NULL, layer2=NULL, layercor2=NULL, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer2=5122, layercor2=NULL, layer2=NULL, layercor2=NULL, layer22=NULL, layercor22=NULL, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer22=9860, layercor22=1940, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer22=NULL, layercor22=NULL, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer22=9860, layercor22=1940, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer22=NULL, layercor22=NULL, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer22=9860, layercor22=1940, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer22=NULL, layercor22=NULL, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer22=9860, layercor22=1940, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer22=NULL, layercor22=NULL, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=2207, layer22=9860, layercor22=1940, layer8=NULL, layercor8=NULL, layer8=4234, layercor8=71, layer1=5184, layercor1=NULL, layer2=7030, layercor2=2057, layer6=NULL, layercor6=NULL, layer6=5138, layercor6=2057, layer1=NULL, layercor1=NULL, layer2=NULL, layercor2=NULL, layer6=NULL, layercor6=NULL, layer6=5447, layercor6=713, layer1=5184, layercor1=NULL, layer2=7030, layercor2=2057, layer6=NULL, layercor6=NULL, layer6=5138, layercor6=2057, layer1=NULL, layercor1=NULL, layer2=NULL, layercor2=NULL, layer20=NULL, layercor20=NULL, layer6=NULL, layercor6=NULL, layer6=5447, layercor6=713, layer2=3912, layercor2=NULL, layer2=NULL, layercor2=NULL, layer2=3912, layercor2=NULL, layer2=NULL, layercor2=NULL, layer1=5184, layercor1=NULL, layer2=7030, layercor2=2057, layer6=NULL, layercor6=NULL, layer6=5138, layercor6=2057, layer1=NULL, layercor1=NULL, layer2=NULL, layercor2=NULL, layer6=NULL, layercor6=NULL, layer6=5447, layercor6=713"
LOCAL.SQL=<DB.AEXECUTE SQLAsyncResponse, UPDATE paperdoll SET <TAG.SQLSync.PaperdollItem> WHERE uid='<UID>' LIMIT 1>

[FUNCTION SQLAsyncResponse]
IF !(<ARGN2>)
SERV.LOG @SQL error: <ARGS>
ENDIF
04-28-2014 05:14 AM
Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Messages In This Thread
Huge tags = sphere crash - Coruja - 04-28-2014, 03:21 AM
RE: Huge tags = sphere crash - Alaric - 04-28-2014, 03:45 AM
RE: Huge tags = sphere crash - Feeh - 04-28-2014, 04:14 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014 05:14 AM
RE: Huge tags = sphere crash - Ben - 04-28-2014, 05:36 AM
RE: Huge tags = sphere crash - XuN - 04-28-2014, 05:39 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014, 06:06 AM
RE: Huge tags = sphere crash - XuN - 04-28-2014, 06:49 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014, 07:07 AM
RE: Huge tags = sphere crash - Ben - 04-28-2014, 10:18 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014, 12:59 PM
RE: Huge tags = sphere crash - Feeh - 04-29-2014, 08:53 AM
RE: Huge tags = sphere crash - Coruja - 04-29-2014, 04:33 PM
RE: Huge tags = sphere crash - Ben - 04-29-2014, 08:40 PM
RE: Huge tags = sphere crash - Coruja - 04-30-2014, 02:35 AM
RE: Huge tags = sphere crash - Avatar - 04-30-2014, 06:12 AM
RE: Huge tags = sphere crash - Ben - 04-30-2014, 07:30 AM
RE: Huge tags = sphere crash - Avatar - 04-30-2014, 08:30 AM
RE: Huge tags = sphere crash - Coruja - 05-02-2014, 11:30 AM
RE: Huge tags = sphere crash - Avatar - 05-06-2014, 10:32 AM
RE: Huge tags = sphere crash - Extreme - 05-10-2014, 02:42 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)