Compressing String Variables

[Stolao]

Today i was working on a script that requires multiple character variables and was using imploded strings to compress them when i reached the 128 character limit per string, so I looked around and found we don't have a compression script such as phps gzcompress(),

Can someone make a compression method like this for rAthena?

[Brian]

I believe the limit for permanent string variables was 255 ?

(Also, temporary string variables could be longer than 255 because they are not limited by the column length in SQL.)

It sounds like you're hitting the 128 limit because you are imploding an array, which is limited to 128 elements.

[QQfoolsorellina]

How about

charat(<string>,<index>)

setchar(<string>,<char>,<index>)

?

Edited January 27, 2013 by QQfoolsorellina

[Emistry]

if you want....you can try change the datatype in sql to "text" ...then it will be able to store more than 255 characters.

like i did in this script...

https://rathena.org/board/index.php?/files/file/2550-%7B?%7D/

otherwise, change your way to save the variable...like using bitmask...or etc....

[Stolao]

I found a way to reduce the compressed script, by using

set .@N,<num>;   Number
set .@S$,.@N;   Number -> String
set .@H$,axtoi(.@S$);  String -> Hex

to compress it into a smaller variable (approximately 27% smaller)

Edit:

@Brain, Yes sorry it was 255 not 128 my mistake

@Emistry Would doing this have any negative side effects?

Edit2:

Edited January 28, 2013 by Stolao

[AnnieRuru]

I found a way to reduce the compressed script, by using

set .@N,<num>; Number
set .@S$,.@N; Number -> String
set .@H$,axtoi(.@S$); String -> Hex

to compress it into a smaller variable (approximately 27% smaller)

you sure ?

however my result is getting more lengthy variable instead of shorter

prontera,155,180,5    script    ksdfhksfjs    100,{
   .@a$ = "32767";
   mes .@a$ +" = ["+ getstrlen(.@a$) +"]";
   mes axtoi(.@a$) +" = ["+ getstrlen( axtoi(.@a$) ) +"]";
   close;
}

---

@Emistry Would doing this have any negative side effects?

I start to doubt this also

struct global_reg {

char str[32];

char value[256];

};

after change value[1000]

and use this script

prontera,155,180,5    script    ksdfhksfjs    100,{
   for ( .@i = 0; .@i < 20; .@i++ )
       a$ = a$ +"#"+ .@i;
   dispbottom getstrlen(a$) +"";
   end;
}

I still getting the limit at 255 char

and my SQL query also getting a very weird result

ALTER TABLE `ragnarok`.`global_reg_value` MODIFY COLUMN `value` text NOT NULL;

getting same result

---

I've found this method though

http://rathena.org/board/topic/73223-bitshifting-data/#entry151036

prontera,155,180,5    script    ksdfhksfjs    100,{
   .@a = 32767;
   query_sql "select unhex("+ .@a +")", .@b$;
   dispbottom .@b$;
   query_sql "select hex('"+ escape_sql(.@b$) +"')", .@c;
   dispbottom .@c +"";
   end;
}

Edited January 31, 2013 by AnnieRuru

[Stolao]

@AnnieRuru

Ya after some testing I found this out, i was trying to go to hex not convert a number from hex making it bigger,

I was thinking about adding a src mod for Base16(Hex) and/or Base32 algorithm compression

Example

set .A$,"1073741824";
set .B$,Compress16(.A$);
set .C$,Compress32(.A$);
.A$ == "1073741824"
.B$ == "40000000"
.C$ == "1000000"

Edited January 31, 2013 by Stolao