LimitInfo -> basetab_sg

[boifan]

Came across this function which reads LimitInfo field in basetab_sg.
Code is not mine whatsoever, just wanted to share maybe someone will find it useful.

[LIST]
[*][COLOR=#000088]function[/COLOR][COLOR=#000000] getchardata[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$charname[/COLOR][COLOR=#666600],[/COLOR][COLOR=#000000]$opt[/COLOR][COLOR=#666600]){[/COLOR]
[*][COLOR=#000000]    $char [/COLOR][COLOR=#666600]=[/COLOR][COLOR=#000000] $this[/COLOR][COLOR=#666600]->[/COLOR][COLOR=#000000]myfetch[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$this[/COLOR][COLOR=#666600]->[/COLOR][COLOR=#000000]myquery[/COLOR][COLOR=#666600]([/COLOR][COLOR=#008800]"select decode(LimitInfo,'UgCf#@+2YanWe765') FROM basetab_sg where Name = '$charname' "[/COLOR][COLOR=#666600]));[/COLOR]
[*][COLOR=#000000]    $blob [/COLOR][COLOR=#666600]=[/COLOR][COLOR=#000000]  $this[/COLOR][COLOR=#666600]->[/COLOR][COLOR=#000000]strToHex[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$char[/COLOR][COLOR=#666600][[/COLOR][COLOR=#006666]0[/COLOR][COLOR=#666600]]);[/COLOR]
[*][COLOR=#000088]if[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$opt [/COLOR][COLOR=#666600]==[/COLOR][COLOR=#008800]'level'[/COLOR][COLOR=#666600])[/COLOR][COLOR=#000088]return[/COLOR][COLOR=#000000] hexdec[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]52[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]));[/COLOR]
[*][COLOR=#000088]if[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$opt [/COLOR][COLOR=#666600]==[/COLOR][COLOR=#008800]'coin'[/COLOR][COLOR=#666600])[/COLOR][COLOR=#000088]return[/COLOR][COLOR=#000000] hexdec[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]26[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]24[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]22[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]20[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]));[/COLOR]
[*][COLOR=#000088]if[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$opt [/COLOR][COLOR=#666600]==[/COLOR][COLOR=#008800]'salary'[/COLOR][COLOR=#666600])[/COLOR][COLOR=#000088]return[/COLOR][COLOR=#000000] hexdec[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]66[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]64[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]62[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]60[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]));[/COLOR]
[*][COLOR=#000088]if[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$opt [/COLOR][COLOR=#666600]==[/COLOR][COLOR=#008800]'credit'[/COLOR][COLOR=#666600])[/COLOR][COLOR=#000088]return[/COLOR][COLOR=#000000] hexdec[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]74[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]72[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]70[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]68[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]));[/COLOR]
[*][COLOR=#000088]if[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$opt [/COLOR][COLOR=#666600]==[/COLOR][COLOR=#008800]'exp'[/COLOR][COLOR=#666600])[/COLOR][COLOR=#000088]return[/COLOR][COLOR=#000000] hexdec[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]44[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]42[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]40[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]38[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]).[/COLOR][COLOR=#000000]substr[/COLOR][COLOR=#666600]([/COLOR][COLOR=#000000]$blob[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]36[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]2[/COLOR][COLOR=#666600]));[/COLOR]
[*][COLOR=#666600]}[/COLOR]
[/LIST]

UgCf#@+2YanWe765 = decode key

Credits to Necrentos for Coding.
PS: Some people already know this and more but are too greedy to share with community... Shame on you

 

[arpan]

Can you explain more about this?

 

[boifan]

In that example you can pull some infos from every character, like coins,salary,credit,experience.
of course if you edit it to read some other blob for example MemberInfo in Guildtab_sg you can probably read infos about a certain guild etc,

 

[arpan]

Interesting. Thank you.. :

 

[arpan]

Looks like this ain't working for me. Did you try this out?

--- UPDATE --

It worked. Thank you.

 

[necrentos]

its my old code =)

 

[boifan]

sorry Necrentos, don't really remember where i encountered it, anyway added credits to you

 

[imrain01]

any guide how to use this please.Php or mysql ?

 

[necrentos]

its ok, thanks for the credits =)

 

[oleghalin]

is it universal decode key? Or just for LimitInfo?