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:
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:
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].usernumHopefully, 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:
I'ts not workin
