Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Stats limit/Autoreborn Script Integrated for EP8 (75% working)

Joined
Apr 22, 2010
Messages
815
Reaction score
82
Good day, ragezoners!

I have shared to you my modified stats limit script with automatic reborn for episode 8 aka the rise of assassins. This is compatible only for ep8 so you better test it than to ask first, ok? So, here's it:

Code:
create trigger [dbo].[statslimit] on [dbo].[chainfo] 
after update as declare @maxpowstats bigint, @maxintstats bigint, 
@maxdexstats bigint, @maxvitstats bigint, @maxstmstats bigint,
@statpenalty bigint

set @maxpowstats  = 15000
set @maxdexstats  = 15000
set @maxintstats  = 10000
set @maxvitstats  = 15000
set @maxstmstats  = 10000
set @statpenalty = 1



update [rangame1].[dbo].[chainfo]
set 
[chainfo].chastremain = [chainfo].chastremain + 
                    (case when inserted.[chapower] >  @maxpowstats then ( case when @statpenalty = 0 then (inserted.[chapower] - @maxpowstats) else 0 end) else 0 end) +
                    (case when inserted.chadex >  @maxdexstats  then  ( case when @statpenalty = 0 then (inserted.chadex - @maxdexstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrong >  @maxvitstats  then ( case when @statpenalty = 0 then (inserted.chastrong - @maxvitstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrength >  @maxstmstats then ( case when @statpenalty = 0 then (inserted.chastrength -  @maxstmstats)  else 0 end) else 0 end) +
                    (case when inserted.chaspirit >  @maxintstats  then ( case when @statpenalty = 0 then (inserted.chaspirit - @maxintstats)  else 0 end) else 0 end)
,[chainfo].chapower = case when inserted.[chapower] >  @maxpowstats  then (case when @statpenalty = 0 then @maxpowstats else (@maxpowstats - @statpenalty) end) else inserted.[chapower] end 
,[chainfo].chadex = case when inserted.chadex >  @maxdexstats  then (case when @statpenalty = 0 then @maxdexstats else (@maxdexstats - @statpenalty) end)  else inserted.chadex end 
,[chainfo].chastrong = case when inserted.chastrong >  @maxvitstats  then (case when @statpenalty = 0 then @maxvitstats else (@maxvitstats - @statpenalty) end)  else inserted.chastrong end 
,[chainfo].chastrength = case when inserted.chastrength >  @maxstmstats  then (case when @statpenalty = 0 then @maxstmstats else (@maxstmstats - @statpenalty) end) else  inserted.chastrength end 
,[chainfo].chaspirit = case when inserted.chaspirit >  @maxintstats  then (case when @statpenalty = 0 then @maxintstats else (@maxintstats - @statpenalty) end) else  inserted.chaspirit end 
from inserted 
where inserted.[chaname] = [chainfo].[chaname] 
and [chainfo].[chaspecial] =0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005f000000030000000800000003000200080000000300030008000000030004000800000003000500080000000300060008000000030007000800000003000800080000000300090008000000020000000800000002000100080000000200020008000000020003000800000002000400080000000200050008000000020006000800000002000700080000000200080008000000020009000800000002000a000800000002000b000800000002000c000800000002000d000800000002000e000800000002000f0008000000020010000800000002001100080000000200120008000000020013000800000002001400080000000200150008000000020016000800000002001700080000000200180008000000020019000800000002001a000800000002001b000800000002001c000800000002001d000800000002001e0008000000010000000800000001000100080000000100020008000000010003000800000001000400080000000100050008000000010006000800000001000700080000000100080008000000010009000800000001000a000800000001000b000800000001000c000800000001000d000800000001000e000800000001000f0008000000010010000800000001001100080000000100120008000000010013000800000001001400080000000100150008000000010016000800000001001700080000000100180008000000010019000800000001001a000800000001001b0008000000000000000800000000000100080000000000020008000000000003000800000000000400080000000000050008000000000006000800000000000700080000000000080008000000000009000800000000000a000800000000000b000800000000000c000800000000000d000800000000000e000800000000000f0008000000000010000800000000001100080000000000120008000000000013000800000000001400080000000000150008000000000016000800000000001700080000000000180008000000000019000800000000001a0008000000 ),
changeclass = 0
 
from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 1
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005700000007000000080000000700030008000000070004000800000007000500080000000700060008000000070007000800000007000800080000000700090008000000060000000800000006000100080000000600020008000000060003000800000006000400080000000600050008000000060006000800000006000700080000000600080008000000060009000800000006000a000800000006000b000800000006000c000800000006000d000800000006000e000800000006000f00080000000600100008000000060011000800000006001200080000000600130008000000060014000800000006001500080000000600160008000000060017000800000006001800080000000600190008000000050000000800000005000100080000000500020008000000050003000800000005000400080000000500050008000000050006000800000005000700080000000500080008000000050009000800000005000a000800000005000b000800000005000c000800000005000d000800000005000e000800000005000f0008000000050010000800000005001100080000000500120008000000050013000800000005001400080000000500150008000000050016000800000005001700080000000500180008000000050019000800000005001a0008000000040000000800000004000100080000000400020008000000040003000800000004000400080000000400050008000000040006000800000004000700080000000400080008000000040009000800000004000a000800000004000b000800000004000c000800000004000d000800000004000e000800000004000f00080000000400100008000000040011000800000004001200080000000400130008000000040014000800000004001500080000000400160008000000040017000800000004001800080000000400190008000000 ),
changeclass = 0

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 2
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000b000000080000000b000100080000000b000300080000000b000400080000000b000600080000000b000700080000000b000800080000000b000900080000000b000a00080000000a000000080000000a000100080000000a000200080000000a000300080000000a000400080000000a000500080000000a000600080000000a000700080000000a000800080000000a000900080000000a000a00080000000a000b00080000000a000c00080000000a000d00080000000a000e00080000000a000f00080000000a001000080000000a001100080000000a001200080000000a001300080000000a001400080000000a001500080000000a001600080000000a001700080000000a001800080000000a001900080000000a001a00080000000a001b00080000000a001c0008000000090000000800000009000100080000000900020008000000090003000800000009000400080000000900050008000000090006000800000009000700080000000900080008000000090009000800000009000a000800000009000b000800000009000c000800000009000d000800000009000e000800000009000f0008000000090010000800000009001100080000000900120008000000090013000800000009001400080000000900150008000000090016000800000009001700080000000900180008000000090019000800000009001a000800000009001b0008000000080000000800000008000100080000000800020008000000080003000800000008000400080000000800050008000000080006000800000008000700080000000800080008000000080009000800000008000a000800000008000b000800000008000c000800000008000d000800000008000e000800000008000f0008000000080010000800000008001100080000000800120008000000080013000800000008001400080000000800150008000000080016000800000008001700080000000800180008000000080019000800000008001a0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 4
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 8
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 16
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 32
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005f000000030000000800000003000200080000000300030008000000030004000800000003000500080000000300060008000000030007000800000003000800080000000300090008000000020000000800000002000100080000000200020008000000020003000800000002000400080000000200050008000000020006000800000002000700080000000200080008000000020009000800000002000a000800000002000b000800000002000c000800000002000d000800000002000e000800000002000f0008000000020010000800000002001100080000000200120008000000020013000800000002001400080000000200150008000000020016000800000002001700080000000200180008000000020019000800000002001a000800000002001b000800000002001c000800000002001d000800000002001e0008000000010000000800000001000100080000000100020008000000010003000800000001000400080000000100050008000000010006000800000001000700080000000100080008000000010009000800000001000a000800000001000b000800000001000c000800000001000d000800000001000e000800000001000f0008000000010010000800000001001100080000000100120008000000010013000800000001001400080000000100150008000000010016000800000001001700080000000100180008000000010019000800000001001a000800000001001b0008000000000000000800000000000100080000000000020008000000000003000800000000000400080000000000050008000000000006000800000000000700080000000000080008000000000009000800000000000a000800000000000b000800000000000c000800000000000d000800000000000e000800000000000f0008000000000010000800000000001100080000000000120008000000000013000800000000001400080000000000150008000000000016000800000000001700080000000000180008000000000019000800000000001a0008000000 ),
changeclass = 0
 
from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 64
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 128
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000b000000080000000b000100080000000b000300080000000b000400080000000b000600080000000b000700080000000b000800080000000b000900080000000b000a00080000000a000000080000000a000100080000000a000200080000000a000300080000000a000400080000000a000500080000000a000600080000000a000700080000000a000800080000000a000900080000000a000a00080000000a000b00080000000a000c00080000000a000d00080000000a000e00080000000a000f00080000000a001000080000000a001100080000000a001200080000000a001300080000000a001400080000000a001500080000000a001600080000000a001700080000000a001800080000000a001900080000000a001a00080000000a001b00080000000a001c0008000000090000000800000009000100080000000900020008000000090003000800000009000400080000000900050008000000090006000800000009000700080000000900080008000000090009000800000009000a000800000009000b000800000009000c000800000009000d000800000009000e000800000009000f0008000000090010000800000009001100080000000900120008000000090013000800000009001400080000000900150008000000090016000800000009001700080000000900180008000000090019000800000009001a000800000009001b0008000000080000000800000008000100080000000800020008000000080003000800000008000400080000000800050008000000080006000800000008000700080000000800080008000000080009000800000008000a000800000008000b000800000008000c000800000008000d000800000008000e000800000008000f0008000000080010000800000008001100080000000800120008000000080013000800000008001400080000000800150008000000080016000800000008001700080000000800180008000000080019000800000008001a0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 256
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 512
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 1024
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 2048
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 4096
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 8192
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [chainfo] set [chainfo].chalevel=1, 
[chainfo].chareborn=[chainfo].chareborn + 1, 
[chainfo].chaexp=0, 
[chainfo].chastremain = 100*[chainfo].chareborn, 
[chainfo].chapower = 0, 
[chainfo].chastrong = 0, 
[chainfo].chastrength = 0, 
[chainfo].chaspirit = 0, 
[chainfo].chadex = 0, 
[chainfo].chaintel = 0, 
[chainfo].chamoney = [chainfo].chamoney - 20000000
from inserted
where inserted.chalevel = 235 
and [chainfo].chareborn < 200 
and [chainfo].chaname=inserted.chaname 
and [chainfo].usernum =inserted.usernum
and [chainfo].chamoney >= 20000000
and [chainfo].chaonline=0

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adpow',''),
[chainfo].chapower=[chainfo].chapower+replace([chainfo].chaguname,'adpow',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adpow','')*1000)
from inserted
where left(inserted.chaguname,5)='adpow'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adpow','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adpow','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'addex',''),
[chainfo].chadex=[chainfo].chadex+replace([chainfo].chaguname,'addex',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'addex','')*1000)
from inserted
where left(inserted.chaguname,5)='addex'
and [chainfo].chastremain>=replace([chainfo].chaguname,'addex','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'addex','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adint',''),
[chainfo].chaspirit=[chainfo].chaspirit+replace([chainfo].chaguname,'adint',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adint','')*1000)
from inserted
where left(inserted.chaguname,5)='adint'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adint','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adint','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'advit',''),
[chainfo].chastrong=[chainfo].chastrong+replace([chainfo].chaguname,'advit',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'advit','')*1000)
from inserted
where left(inserted.chaguname,5)='advit'
and [chainfo].chastremain>=replace([chainfo].chaguname,'advit','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'advit','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adstm',''),
[chainfo].chastrength=[chainfo].chastrength+replace([chainfo].chaguname,'adstm',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adstm','')*1000)
from inserted
where left(inserted.chaguname,5)='adstm'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adstm','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adstm','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum


Hopefully, it works for you. For those who have a better script than this, you may share if you want. Don't be selfish!

Thank you and more powers :)

:junglejane::junglejane::junglejane:
 
Last edited by a moderator:
Elite Diviner
Joined
Apr 3, 2011
Messages
425
Reaction score
41
how about if only the stats limit not the autoreborn ?..

Msg 8197, Level 16, State 4, Procedure statslimit, Line 1
Object 'dbo.chainfo' does not exist or is invalid for this operation.
 
Experienced Elementalist
Joined
Dec 8, 2012
Messages
265
Reaction score
41
autoreborn have bug.. they can do 30+ reborns in 1 hour even not going on level :)

i recommend reborn on website
 
Experienced Elementalist
Joined
May 16, 2011
Messages
225
Reaction score
8
Good day, ragezoners!

I have shared to you my modified stats limit script with automatic reborn for episode 8 aka the rise of assassins. This is compatible only for ep8 so you better test it than to ask first, ok? So, here's it:

Code:
create trigger [dbo].[statslimit] on [dbo].[chainfo] 
after update as declare @maxpowstats bigint, @maxintstats bigint, 
@maxdexstats bigint, @maxvitstats bigint, @maxstmstats bigint,
@statpenalty bigint

set @maxpowstats  = 15000
set @maxdexstats  = 15000
set @maxintstats  = 10000
set @maxvitstats  = 15000
set @maxstmstats  = 10000
set @statpenalty = 1



update [rangame1].[dbo].[chainfo]
set 
[chainfo].chastremain = [chainfo].chastremain + 
                    (case when inserted.[chapower] >  @maxpowstats then ( case when @statpenalty = 0 then (inserted.[chapower] - @maxpowstats) else 0 end) else 0 end) +
                    (case when inserted.chadex >  @maxdexstats  then  ( case when @statpenalty = 0 then (inserted.chadex - @maxdexstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrong >  @maxvitstats  then ( case when @statpenalty = 0 then (inserted.chastrong - @maxvitstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrength >  @maxstmstats then ( case when @statpenalty = 0 then (inserted.chastrength -  @maxstmstats)  else 0 end) else 0 end) +
                    (case when inserted.chaspirit >  @maxintstats  then ( case when @statpenalty = 0 then (inserted.chaspirit - @maxintstats)  else 0 end) else 0 end)
,[chainfo].chapower = case when inserted.[chapower] >  @maxpowstats  then (case when @statpenalty = 0 then @maxpowstats else (@maxpowstats - @statpenalty) end) else inserted.[chapower] end 
,[chainfo].chadex = case when inserted.chadex >  @maxdexstats  then (case when @statpenalty = 0 then @maxdexstats else (@maxdexstats - @statpenalty) end)  else inserted.chadex end 
,[chainfo].chastrong = case when inserted.chastrong >  @maxvitstats  then (case when @statpenalty = 0 then @maxvitstats else (@maxvitstats - @statpenalty) end)  else inserted.chastrong end 
,[chainfo].chastrength = case when inserted.chastrength >  @maxstmstats  then (case when @statpenalty = 0 then @maxstmstats else (@maxstmstats - @statpenalty) end) else  inserted.chastrength end 
,[chainfo].chaspirit = case when inserted.chaspirit >  @maxintstats  then (case when @statpenalty = 0 then @maxintstats else (@maxintstats - @statpenalty) end) else  inserted.chaspirit end 
from inserted 
where inserted.[chaname] = [chainfo].[chaname] 
and [chainfo].[chaspecial] =0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005f000000030000000800000003000200080000000300030008000000030004000800000003000500080000000300060008000000030007000800000003000800080000000300090008000000020000000800000002000100080000000200020008000000020003000800000002000400080000000200050008000000020006000800000002000700080000000200080008000000020009000800000002000a000800000002000b000800000002000c000800000002000d000800000002000e000800000002000f0008000000020010000800000002001100080000000200120008000000020013000800000002001400080000000200150008000000020016000800000002001700080000000200180008000000020019000800000002001a000800000002001b000800000002001c000800000002001d000800000002001e0008000000010000000800000001000100080000000100020008000000010003000800000001000400080000000100050008000000010006000800000001000700080000000100080008000000010009000800000001000a000800000001000b000800000001000c000800000001000d000800000001000e000800000001000f0008000000010010000800000001001100080000000100120008000000010013000800000001001400080000000100150008000000010016000800000001001700080000000100180008000000010019000800000001001a000800000001001b0008000000000000000800000000000100080000000000020008000000000003000800000000000400080000000000050008000000000006000800000000000700080000000000080008000000000009000800000000000a000800000000000b000800000000000c000800000000000d000800000000000e000800000000000f0008000000000010000800000000001100080000000000120008000000000013000800000000001400080000000000150008000000000016000800000000001700080000000000180008000000000019000800000000001a0008000000 ),
changeclass = 0
 
from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 1
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005700000007000000080000000700030008000000070004000800000007000500080000000700060008000000070007000800000007000800080000000700090008000000060000000800000006000100080000000600020008000000060003000800000006000400080000000600050008000000060006000800000006000700080000000600080008000000060009000800000006000a000800000006000b000800000006000c000800000006000d000800000006000e000800000006000f00080000000600100008000000060011000800000006001200080000000600130008000000060014000800000006001500080000000600160008000000060017000800000006001800080000000600190008000000050000000800000005000100080000000500020008000000050003000800000005000400080000000500050008000000050006000800000005000700080000000500080008000000050009000800000005000a000800000005000b000800000005000c000800000005000d000800000005000e000800000005000f0008000000050010000800000005001100080000000500120008000000050013000800000005001400080000000500150008000000050016000800000005001700080000000500180008000000050019000800000005001a0008000000040000000800000004000100080000000400020008000000040003000800000004000400080000000400050008000000040006000800000004000700080000000400080008000000040009000800000004000a000800000004000b000800000004000c000800000004000d000800000004000e000800000004000f00080000000400100008000000040011000800000004001200080000000400130008000000040014000800000004001500080000000400160008000000040017000800000004001800080000000400190008000000 ),
changeclass = 0

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 2
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000b000000080000000b000100080000000b000300080000000b000400080000000b000600080000000b000700080000000b000800080000000b000900080000000b000a00080000000a000000080000000a000100080000000a000200080000000a000300080000000a000400080000000a000500080000000a000600080000000a000700080000000a000800080000000a000900080000000a000a00080000000a000b00080000000a000c00080000000a000d00080000000a000e00080000000a000f00080000000a001000080000000a001100080000000a001200080000000a001300080000000a001400080000000a001500080000000a001600080000000a001700080000000a001800080000000a001900080000000a001a00080000000a001b00080000000a001c0008000000090000000800000009000100080000000900020008000000090003000800000009000400080000000900050008000000090006000800000009000700080000000900080008000000090009000800000009000a000800000009000b000800000009000c000800000009000d000800000009000e000800000009000f0008000000090010000800000009001100080000000900120008000000090013000800000009001400080000000900150008000000090016000800000009001700080000000900180008000000090019000800000009001a000800000009001b0008000000080000000800000008000100080000000800020008000000080003000800000008000400080000000800050008000000080006000800000008000700080000000800080008000000080009000800000008000a000800000008000b000800000008000c000800000008000d000800000008000e000800000008000f0008000000080010000800000008001100080000000800120008000000080013000800000008001400080000000800150008000000080016000800000008001700080000000800180008000000080019000800000008001a0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 4
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 8
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 16
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 32
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005f000000030000000800000003000200080000000300030008000000030004000800000003000500080000000300060008000000030007000800000003000800080000000300090008000000020000000800000002000100080000000200020008000000020003000800000002000400080000000200050008000000020006000800000002000700080000000200080008000000020009000800000002000a000800000002000b000800000002000c000800000002000d000800000002000e000800000002000f0008000000020010000800000002001100080000000200120008000000020013000800000002001400080000000200150008000000020016000800000002001700080000000200180008000000020019000800000002001a000800000002001b000800000002001c000800000002001d000800000002001e0008000000010000000800000001000100080000000100020008000000010003000800000001000400080000000100050008000000010006000800000001000700080000000100080008000000010009000800000001000a000800000001000b000800000001000c000800000001000d000800000001000e000800000001000f0008000000010010000800000001001100080000000100120008000000010013000800000001001400080000000100150008000000010016000800000001001700080000000100180008000000010019000800000001001a000800000001001b0008000000000000000800000000000100080000000000020008000000000003000800000000000400080000000000050008000000000006000800000000000700080000000000080008000000000009000800000000000a000800000000000b000800000000000c000800000000000d000800000000000e000800000000000f0008000000000010000800000000001100080000000000120008000000000013000800000000001400080000000000150008000000000016000800000000001700080000000000180008000000000019000800000000001a0008000000 ),
changeclass = 0
 
from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 64
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 128
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000b000000080000000b000100080000000b000300080000000b000400080000000b000600080000000b000700080000000b000800080000000b000900080000000b000a00080000000a000000080000000a000100080000000a000200080000000a000300080000000a000400080000000a000500080000000a000600080000000a000700080000000a000800080000000a000900080000000a000a00080000000a000b00080000000a000c00080000000a000d00080000000a000e00080000000a000f00080000000a001000080000000a001100080000000a001200080000000a001300080000000a001400080000000a001500080000000a001600080000000a001700080000000a001800080000000a001900080000000a001a00080000000a001b00080000000a001c0008000000090000000800000009000100080000000900020008000000090003000800000009000400080000000900050008000000090006000800000009000700080000000900080008000000090009000800000009000a000800000009000b000800000009000c000800000009000d000800000009000e000800000009000f0008000000090010000800000009001100080000000900120008000000090013000800000009001400080000000900150008000000090016000800000009001700080000000900180008000000090019000800000009001a000800000009001b0008000000080000000800000008000100080000000800020008000000080003000800000008000400080000000800050008000000080006000800000008000700080000000800080008000000080009000800000008000a000800000008000b000800000008000c000800000008000d000800000008000e000800000008000f0008000000080010000800000008001100080000000800120008000000080013000800000008001400080000000800150008000000080016000800000008001700080000000800180008000000080019000800000008001a0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 256
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 512
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 1024
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 2048
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 4096
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 8192
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [chainfo] set [chainfo].chalevel=1, 
[chainfo].chareborn=[chainfo].chareborn + 1, 
[chainfo].chaexp=0, 
[chainfo].chastremain = 100*[chainfo].chareborn, 
[chainfo].chapower = 0, 
[chainfo].chastrong = 0, 
[chainfo].chastrength = 0, 
[chainfo].chaspirit = 0, 
[chainfo].chadex = 0, 
[chainfo].chaintel = 0, 
[chainfo].chamoney = [chainfo].chamoney - 20000000
from inserted
where inserted.chalevel = 235 
and [chainfo].chareborn < 200 
and [chainfo].chaname=inserted.chaname 
and [chainfo].usernum =inserted.usernum
and [chainfo].chamoney >= 20000000
and [chainfo].chaonline=0

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adpow',''),
[chainfo].chapower=[chainfo].chapower+replace([chainfo].chaguname,'adpow',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adpow','')*1000)
from inserted
where left(inserted.chaguname,5)='adpow'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adpow','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adpow','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'addex',''),
[chainfo].chadex=[chainfo].chadex+replace([chainfo].chaguname,'addex',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'addex','')*1000)
from inserted
where left(inserted.chaguname,5)='addex'
and [chainfo].chastremain>=replace([chainfo].chaguname,'addex','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'addex','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adint',''),
[chainfo].chaspirit=[chainfo].chaspirit+replace([chainfo].chaguname,'adint',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adint','')*1000)
from inserted
where left(inserted.chaguname,5)='adint'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adint','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adint','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'advit',''),
[chainfo].chastrong=[chainfo].chastrong+replace([chainfo].chaguname,'advit',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'advit','')*1000)
from inserted
where left(inserted.chaguname,5)='advit'
and [chainfo].chastremain>=replace([chainfo].chaguname,'advit','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'advit','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adstm',''),
[chainfo].chastrength=[chainfo].chastrength+replace([chainfo].chaguname,'adstm',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adstm','')*1000)
from inserted
where left(inserted.chaguname,5)='adstm'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adstm','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adstm','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum


Hopefully, it works for you. For those who have a better script than this, you may share if you want. Don't be selfish!

Thank you and more powers :)

:junglejane::junglejane::junglejane:

no credit lol this is re-share
it's already share long time ago
 
Initiate Mage
Joined
Dec 22, 2011
Messages
32
Reaction score
3
It is possible to make the stats into unlimited ?

and how can I edit the limit of energy, melee, and etc.. in one character??
 
Initiate Mage
Joined
Dec 22, 2011
Messages
32
Reaction score
3
I'am just wondering on how to edit the max stats on ep8 assassin
Does anyone how to do it ?? please Share or i need to know HOW ?? :/:
 
Elite Diviner
Joined
Apr 3, 2011
Messages
425
Reaction score
41
I'am just wondering on how to edit the max stats on ep8 assassin
Does anyone how to do it ?? please Share or i need to know HOW ?? :/:
if Ep8, open your database named "RanGame1"then click on dbo.Charinfo>>triggers>>then edit the statslimit trigger, if you dont have try to SEARCH the SCRIPT!
 
Initiate Mage
Joined
Dec 22, 2011
Messages
32
Reaction score
3
#shelin
I don't have any triggers in my databse I tried to search but i did not find it
can you please link it to me Thank You
 
Junior Spellweaver
Joined
Apr 7, 2013
Messages
137
Reaction score
8
Good day, ragezoners!

I have shared to you my modified stats limit script with automatic reborn for episode 8 aka the rise of assassins. This is compatible only for ep8 so you better test it than to ask first, ok? So, here's it:

Code:
create trigger [dbo].[statslimit] on [dbo].[chainfo] 
after update as declare @maxpowstats bigint, @maxintstats bigint, 
@maxdexstats bigint, @maxvitstats bigint, @maxstmstats bigint,
@statpenalty bigint

set @maxpowstats  = 15000
set @maxdexstats  = 15000
set @maxintstats  = 10000
set @maxvitstats  = 15000
set @maxstmstats  = 10000
set @statpenalty = 1



update [rangame1].[dbo].[chainfo]
set 
[chainfo].chastremain = [chainfo].chastremain + 
                    (case when inserted.[chapower] >  @maxpowstats then ( case when @statpenalty = 0 then (inserted.[chapower] - @maxpowstats) else 0 end) else 0 end) +
                    (case when inserted.chadex >  @maxdexstats  then  ( case when @statpenalty = 0 then (inserted.chadex - @maxdexstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrong >  @maxvitstats  then ( case when @statpenalty = 0 then (inserted.chastrong - @maxvitstats) else 0 end) else 0 end) + 
                    (case when inserted.chastrength >  @maxstmstats then ( case when @statpenalty = 0 then (inserted.chastrength -  @maxstmstats)  else 0 end) else 0 end) +
                    (case when inserted.chaspirit >  @maxintstats  then ( case when @statpenalty = 0 then (inserted.chaspirit - @maxintstats)  else 0 end) else 0 end)
,[chainfo].chapower = case when inserted.[chapower] >  @maxpowstats  then (case when @statpenalty = 0 then @maxpowstats else (@maxpowstats - @statpenalty) end) else inserted.[chapower] end 
,[chainfo].chadex = case when inserted.chadex >  @maxdexstats  then (case when @statpenalty = 0 then @maxdexstats else (@maxdexstats - @statpenalty) end)  else inserted.chadex end 
,[chainfo].chastrong = case when inserted.chastrong >  @maxvitstats  then (case when @statpenalty = 0 then @maxvitstats else (@maxvitstats - @statpenalty) end)  else inserted.chastrong end 
,[chainfo].chastrength = case when inserted.chastrength >  @maxstmstats  then (case when @statpenalty = 0 then @maxstmstats else (@maxstmstats - @statpenalty) end) else  inserted.chastrength end 
,[chainfo].chaspirit = case when inserted.chaspirit >  @maxintstats  then (case when @statpenalty = 0 then @maxintstats else (@maxintstats - @statpenalty) end) else  inserted.chaspirit end 
from inserted 
where inserted.[chaname] = [chainfo].[chaname] 
and [chainfo].[chaspecial] =0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005f000000030000000800000003000200080000000300030008000000030004000800000003000500080000000300060008000000030007000800000003000800080000000300090008000000020000000800000002000100080000000200020008000000020003000800000002000400080000000200050008000000020006000800000002000700080000000200080008000000020009000800000002000a000800000002000b000800000002000c000800000002000d000800000002000e000800000002000f0008000000020010000800000002001100080000000200120008000000020013000800000002001400080000000200150008000000020016000800000002001700080000000200180008000000020019000800000002001a000800000002001b000800000002001c000800000002001d000800000002001e0008000000010000000800000001000100080000000100020008000000010003000800000001000400080000000100050008000000010006000800000001000700080000000100080008000000010009000800000001000a000800000001000b000800000001000c000800000001000d000800000001000e000800000001000f0008000000010010000800000001001100080000000100120008000000010013000800000001001400080000000100150008000000010016000800000001001700080000000100180008000000010019000800000001001a000800000001001b0008000000000000000800000000000100080000000000020008000000000003000800000000000400080000000000050008000000000006000800000000000700080000000000080008000000000009000800000000000a000800000000000b000800000000000c000800000000000d000800000000000e000800000000000f0008000000000010000800000000001100080000000000120008000000000013000800000000001400080000000000150008000000000016000800000000001700080000000000180008000000000019000800000000001a0008000000 ),
changeclass = 0
 
from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 1
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005700000007000000080000000700030008000000070004000800000007000500080000000700060008000000070007000800000007000800080000000700090008000000060000000800000006000100080000000600020008000000060003000800000006000400080000000600050008000000060006000800000006000700080000000600080008000000060009000800000006000a000800000006000b000800000006000c000800000006000d000800000006000e000800000006000f00080000000600100008000000060011000800000006001200080000000600130008000000060014000800000006001500080000000600160008000000060017000800000006001800080000000600190008000000050000000800000005000100080000000500020008000000050003000800000005000400080000000500050008000000050006000800000005000700080000000500080008000000050009000800000005000a000800000005000b000800000005000c000800000005000d000800000005000e000800000005000f0008000000050010000800000005001100080000000500120008000000050013000800000005001400080000000500150008000000050016000800000005001700080000000500180008000000050019000800000005001a0008000000040000000800000004000100080000000400020008000000040003000800000004000400080000000400050008000000040006000800000004000700080000000400080008000000040009000800000004000a000800000004000b000800000004000c000800000004000d000800000004000e000800000004000f00080000000400100008000000040011000800000004001200080000000400130008000000040014000800000004001500080000000400160008000000040017000800000004001800080000000400190008000000 ),
changeclass = 0

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 2
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000b000000080000000b000100080000000b000300080000000b000400080000000b000600080000000b000700080000000b000800080000000b000900080000000b000a00080000000a000000080000000a000100080000000a000200080000000a000300080000000a000400080000000a000500080000000a000600080000000a000700080000000a000800080000000a000900080000000a000a00080000000a000b00080000000a000c00080000000a000d00080000000a000e00080000000a000f00080000000a001000080000000a001100080000000a001200080000000a001300080000000a001400080000000a001500080000000a001600080000000a001700080000000a001800080000000a001900080000000a001a00080000000a001b00080000000a001c0008000000090000000800000009000100080000000900020008000000090003000800000009000400080000000900050008000000090006000800000009000700080000000900080008000000090009000800000009000a000800000009000b000800000009000c000800000009000d000800000009000e000800000009000f0008000000090010000800000009001100080000000900120008000000090013000800000009001400080000000900150008000000090016000800000009001700080000000900180008000000090019000800000009001a000800000009001b0008000000080000000800000008000100080000000800020008000000080003000800000008000400080000000800050008000000080006000800000008000700080000000800080008000000080009000800000008000a000800000008000b000800000008000c000800000008000d000800000008000e000800000008000f0008000000080010000800000008001100080000000800120008000000080013000800000008001400080000000800150008000000080016000800000008001700080000000800180008000000080019000800000008001a0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 4
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 8
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 16
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 32
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005f000000030000000800000003000200080000000300030008000000030004000800000003000500080000000300060008000000030007000800000003000800080000000300090008000000020000000800000002000100080000000200020008000000020003000800000002000400080000000200050008000000020006000800000002000700080000000200080008000000020009000800000002000a000800000002000b000800000002000c000800000002000d000800000002000e000800000002000f0008000000020010000800000002001100080000000200120008000000020013000800000002001400080000000200150008000000020016000800000002001700080000000200180008000000020019000800000002001a000800000002001b000800000002001c000800000002001d000800000002001e0008000000010000000800000001000100080000000100020008000000010003000800000001000400080000000100050008000000010006000800000001000700080000000100080008000000010009000800000001000a000800000001000b000800000001000c000800000001000d000800000001000e000800000001000f0008000000010010000800000001001100080000000100120008000000010013000800000001001400080000000100150008000000010016000800000001001700080000000100180008000000010019000800000001001a000800000001001b0008000000000000000800000000000100080000000000020008000000000003000800000000000400080000000000050008000000000006000800000000000700080000000000080008000000000009000800000000000a000800000000000b000800000000000c000800000000000d000800000000000e000800000000000f0008000000000010000800000000001100080000000000120008000000000013000800000000001400080000000000150008000000000016000800000000001700080000000000180008000000000019000800000000001a0008000000 ),
changeclass = 0
 
from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 64
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 128
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000b000000080000000b000100080000000b000300080000000b000400080000000b000600080000000b000700080000000b000800080000000b000900080000000b000a00080000000a000000080000000a000100080000000a000200080000000a000300080000000a000400080000000a000500080000000a000600080000000a000700080000000a000800080000000a000900080000000a000a00080000000a000b00080000000a000c00080000000a000d00080000000a000e00080000000a000f00080000000a001000080000000a001100080000000a001200080000000a001300080000000a001400080000000a001500080000000a001600080000000a001700080000000a001800080000000a001900080000000a001a00080000000a001b00080000000a001c0008000000090000000800000009000100080000000900020008000000090003000800000009000400080000000900050008000000090006000800000009000700080000000900080008000000090009000800000009000a000800000009000b000800000009000c000800000009000d000800000009000e000800000009000f0008000000090010000800000009001100080000000900120008000000090013000800000009001400080000000900150008000000090016000800000009001700080000000900180008000000090019000800000009001a000800000009001b0008000000080000000800000008000100080000000800020008000000080003000800000008000400080000000800050008000000080006000800000008000700080000000800080008000000080009000800000008000a000800000008000b000800000008000c000800000008000d000800000008000e000800000008000f0008000000080010000800000008001100080000000800120008000000080013000800000008001400080000000800150008000000080016000800000008001700080000000800180008000000080019000800000008001a0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 256
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x00010000080000005d0000000f000200080000000f000300080000000f000400080000000f000500080000000f000600080000000f000700080000000e000000080000000e000100080000000e000200080000000e000300080000000e000400080000000e000500080000000e000600080000000e000700080000000e000800080000000e000900080000000e000a00080000000e000b00080000000e000c00080000000e000d00080000000e000e00080000000e000f00080000000e001000080000000e001100080000000e001200080000000e001300080000000e001400080000000e001500080000000e001600080000000e001700080000000e001800080000000e001900080000000e001a00080000000e001b00080000000e001c00080000000e001d00080000000d000000080000000d000100080000000d000200080000000d000300080000000d000400080000000d000500080000000d000600080000000d000700080000000d000800080000000d000900080000000d000a00080000000d000b00080000000d000c00080000000d000d00080000000d000e00080000000d000f00080000000d001000080000000d001100080000000d001200080000000d001300080000000d001400080000000d001500080000000d001600080000000d001700080000000d001800080000000d001900080000000d001a00080000000d001b00080000000d001c00080000000c000000080000000c000100080000000c000200080000000c000300080000000c000400080000000c000500080000000c000600080000000c000700080000000c000800080000000c000900080000000c000a00080000000c000b00080000000c000c00080000000c000d00080000000c000e00080000000c000f00080000000c001000080000000c001100080000000c001200080000000c001300080000000c001400080000000c001500080000000c001600080000000c001700080000000c001800080000000c001900080000000c001a00080000000c001b0008000000 ),
changeclass = 0 

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 512
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 1024
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 2048
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 4096
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [rangame1].[dbo].[chainfo]
set 
[chainfo].chaskills = convert(varbinary(max), 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000a000800150021000b000800150021000c000800150021000d000800150021000e000800150021000f0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001a000800150021001b000800150021001c000800150021001d000800150021001e0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000a000800150020000b000800150020000c000800150020000d000800150020000e000800150020000f0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001a000800150020001b000800150020001c000800150020001d000800150020001e000800150020001f00080015001f000000080015001f000100080015001f000200080015001f000300080015001f000400080015001f000500080015001f000600080015001f000700080015001f000800080015001f000900080015001f000a00080015001f000b00080015001f000c00080015001f000d00080015001f000e00080015001f000f00080015001f001000080015001f001100080015001f001200080015001f001300080015001f001400080015001f001500080015001f001600080015001f001700080015001f001800080015001f001900080015001f001a00080015001f001b00080015001f001c00080015001f001d00080015001f001e00080015001f001f00080015001f002500080015001e000000080015001e000100080015001e000200080015001e000300080015001e000400080015001e000500080015001e000600080015001e000700080015001e000800080015001e000900080015001e000a00080015001e000b00080015001e000c00080015001e000d00080015001e000e00080015001e000f00080015001e001000080015001e001100080015001e001200080015001e001300080015001e001400080015001e001500080015001e001600080015001e001700080015001e001800080015001e001900080015001e001a00080015001e001b00080015001e001c00080015001e001d00080015001e001e00080015001e001f00080015001e00200008001500 ),
changeclass = 0 ,
[chainfo].chaquest = convert(varbinary(max),0x010000002b0000000100000003000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000160000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001c0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000001d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002a0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002b0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000002c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000002d0000000100000001000000010000000000000000000000000200000000010100000000000101010000000001100100004800000000000000010000003000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000034000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000380000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000003c0000000100000001000000010000000000000000000000000200000001010000000000000101010000000001100100004800000000000000010000004000000001000000010000000100000000000000000000000002000000010100000000000001010100000000011001000048000000000000000100000044000000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ac000000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000aa010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ab010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ac010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000ad010000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000a2040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000a5040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b1040000010000000100000001000000000000000001000000020000000101000000000000010101000000000110010000480000000000000001000000b2040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000b3040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b4040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b6040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b7040000010000000100000001000000000000000000000000020000000101010000000000000101000000000110010000480000000000000001000000b8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000b9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ba040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bb040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000bc040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000bd040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c3040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000c4040000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000001000000c7040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c8040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000c9040000010000000100000001000000000000000000000000020000000101000000000000010101000000000110010000480000000000000001000000ca040000010000000100000001000000000000000000000000020000000100010000000000010101000000000110010000480000000000000001000000cb04000001000000010000000100000000000000000000000002000000010101000000000000010100000000011001000048000000000000000100000074080000010000000100000001000000000000000000000000020000000001010000000000010101000000000110010000480000000000000000000000)

from inserted 
where inserted.[chaname] = [chainfo].[chaname]
and chainfo.chaclass = 8192
and chainfo.changeclass = 1
and chainfo.chaonline = 0


update [chainfo] set [chainfo].chalevel=1, 
[chainfo].chareborn=[chainfo].chareborn + 1, 
[chainfo].chaexp=0, 
[chainfo].chastremain = 100*[chainfo].chareborn, 
[chainfo].chapower = 0, 
[chainfo].chastrong = 0, 
[chainfo].chastrength = 0, 
[chainfo].chaspirit = 0, 
[chainfo].chadex = 0, 
[chainfo].chaintel = 0, 
[chainfo].chamoney = [chainfo].chamoney - 20000000
from inserted
where inserted.chalevel = 235 
and [chainfo].chareborn < 200 
and [chainfo].chaname=inserted.chaname 
and [chainfo].usernum =inserted.usernum
and [chainfo].chamoney >= 20000000
and [chainfo].chaonline=0

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adpow',''),
[chainfo].chapower=[chainfo].chapower+replace([chainfo].chaguname,'adpow',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adpow','')*1000)
from inserted
where left(inserted.chaguname,5)='adpow'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adpow','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adpow','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'addex',''),
[chainfo].chadex=[chainfo].chadex+replace([chainfo].chaguname,'addex',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'addex','')*1000)
from inserted
where left(inserted.chaguname,5)='addex'
and [chainfo].chastremain>=replace([chainfo].chaguname,'addex','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'addex','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adint',''),
[chainfo].chaspirit=[chainfo].chaspirit+replace([chainfo].chaguname,'adint',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adint','')*1000)
from inserted
where left(inserted.chaguname,5)='adint'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adint','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adint','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'advit',''),
[chainfo].chastrong=[chainfo].chastrong+replace([chainfo].chaguname,'advit',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'advit','')*1000)
from inserted
where left(inserted.chaguname,5)='advit'
and [chainfo].chastremain>=replace([chainfo].chaguname,'advit','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'advit','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum

update chainfo set [chainfo].chaguname='addfinish',
[chainfo].chastremain=[chainfo].chastremain-replace([chainfo].chaguname,'adstm',''),
[chainfo].chastrength=[chainfo].chastrength+replace([chainfo].chaguname,'adstm',''),
[chainfo].chamoney=[chainfo].chamoney-(replace([chainfo].chaguname,'adstm','')*1000)
from inserted
where left(inserted.chaguname,5)='adstm'
and [chainfo].chastremain>=replace([chainfo].chaguname,'adstm','')
and [chainfo].chamoney>=replace([chainfo].chaguname,'adstm','')*1000
and inserted.chaname=[chainfo].chaname
and inserted.usernum=[chainfo].usernum


Hopefully, it works for you. For those who have a better script than this, you may share if you want. Don't be selfish!

Thank you and more powers :)

:junglejane::junglejane::junglejane:

sir I just want to clarify this is not working on autoreborn because when i execute your script it says "Command(s) completed successfully." but when i relogin again my character, the character level still 300 huhuhu:( I'ts not workin
 
Back
Top