Threaded Mode | Linear Mode

***Feeh*** · 04-29-2014 08:53 AM

Results of my local tests

Sphere Console Wrote:19:42:1:'feeh' commands 'lol'=1
19:43:1:'feeh' commands 'lol'=1

The Script used to test

Code:

[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.Sync.Paperdoll> WHERE uid='<UID>' LIMIT 1>

[FUNCTION SQLAsyncResponse]

IF !(<ARGN2>)

SERV.LOG @SQL error: <ARGS>

ENDIF

The SQL table and its content AFTER script execution

Code:

create table `paperdoll` (

    `uid` double ,

    `layer1` double ,

    `layercor1` double ,

    `layer2` double ,

    `layercor2` double ,

    `layer6` double ,

    `layercor6` double ,

    `layer8` double ,

    `layercor8` double ,

    `layer22` double ,

    `layercor22` double ,

    `layer20` double ,

    `layercor20` double 

); 

insert into `paperdoll` (`uid`, `layer1`, `layercor1`, `layer2`, `layercor2`, `layer6`, `layercor6`, `layer8`, `layercor8`, `layer22`, `layercor22`, `layer20`, `layercor20`) values('1',NULL,NULL,NULL,NULL,'5447','713','4234','71','9860','1940',NULL,NULL)​;

No crashes
Even with one or more missing columns on the SQL table, the server just spit the error saying the column didn't existed

WAMP provided MySQL server (installed on oct/2013, don't know the version)
SQLYog 8.5.5.0 to read/write/create the tables
Sphere built on (27/apr/2014).

--------------

Try logging the tag to the console, read its length, find the first 'a' character...anything that you think it will crash the server.
Try writing the tag value to a test table and not execute its content

Provide us the SQL table schema you're using or anything else that allow us to test it locally. I'm still in blinds

Threaded Mode \| Linear Mode Huge tags = sphere crash
Author	Message