CABAL数据库操作代码

已于 2023-12-03 21:09:26 修改
阅读量626 收藏
点赞数
文章标签： 数据库 sql database
于 2021-12-26 12:01:38 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/weixin_43199687/article/details/122153453
版权
本文详细介绍了如何在数据库查询分析器中执行SQL指令，用于更新角色的技能代码、注册账户、在存储过程中查找特定关键字，并根据角色ID定制角色的数据，包括属性、库存、装备、技能列表和灵魂能力。同时展示了针对不同角色（狂剑士、双剑士、魔导士等）的详细数据更新操作，涉及多个数据库表的更新和插入。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

在查询分析器里执行指令

调出技能代码

SELECT Data from cabal_skilllist_table where CharacterIdx= x

（角色ID）
注释SELECT Data字段名 from cabal_skilllist_table表名 where CharacterIdx字段序号= x（角色ID）

写入技能代码
UPDATE cabal_skilllist_table SET Data = 0x技能代码 WHERE CharacterIdx = x（x是角色ID）
9300012200天堂之怒
9200012300狂风暴雪
B400012400昊天神辉

注册SQL语句:

exec dbo.cabal_tool_registerAccount '账号','密码'

在所有存储过程中查找一个关键字

select a.text,b.name,b.xtype from dbo.syscomments a,dbo.sysobjects b

   where a.id=b.id and PATINDEX('%关键字%', a.text)>0 order by xtype

USE [Server01]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_newchar]    Script Date: 2023/12/3 21:08:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_newchar]
(
	@Name VARCHAR(16),
	@CharacterIdx  INT,
	@Style INT,
	@StyleMastery INT
)
AS
BEGIN

declare @RegTime dateTime, @userNum int, @serverIdx int, @result int, @sty int
set @userNum = @characterIdx/8
set @serverIdx = dbo.getServerIdx()
set @RegTime = getDate()

SET NOCOUNT ON

DECLARE @CR_SUCCESS INT
DECLARE @CR_DATABRK INT		
DECLARE @CR_NAMEDUP INT	
DECLARE @CR_BADWORD INT

SET @CR_SUCCESS = 0xA0
SET @CR_DATABRK = 0x02	
SET @CR_NAMEDUP = 0x03
SET @CR_BADWORD = 0x04

IF NOT @StyleMastery BETWEEN 1 AND 6
BEGIN
	SELECT @CR_DATABRK
	RETURN
END

IF EXISTS (SELECT * FROM cabal_badwoard WHERE badword = @Name )
BEGIN
	SELECT @CR_BADWORD
	RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE Name = @Name)
BEGIN
	SELECT @CR_NAMEDUP
	RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE CharacterIdx = @CharacterIdx)
BEGIN
	SELECT @CR_DATABRK
	RETURN
END
	

SET XACT_ABORT ON
BEGIN TRAN

INSERT INTO cabal_character_table
(
	CharacterIdx, Name,
	LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
	WorldIdx, [Position], Style, 
	HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField
)
SELECT
	@CharacterIdx, @Name,
	LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
	WorldIdx, Position, @Style,
	HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField
FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

IF @@ROWCOUNT <> 1
BEGIN
	ROLLBACK TRAN
	SELECT @CR_DATABRK
	RETURN
END

INSERT INTO cabal_inventory_table (CharacterIdx, Data)
SELECT @CharacterIdx, InventoryData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_equipment_table (CharacterIdx, Data)
SELECT @CharacterIdx, EquipmentData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_skilllist_table (CharacterIdx, Data)
SELECT @CharacterIdx, SkillData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_quickslot_table (CharacterIdx, Data)
SELECT @CharacterIdx, QuickSlotData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_questdata_table (characterIdx, Data, Flags)
SELECT @CharacterIdx, QuestData, QuestFlagsData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_soul_ability_table (characterIdx, PassiveAbilityData, BlendedAbilityData)
SELECT @CharacterIdx, PassiveAbilityData, BlendedAbilityData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

EXEC cabal_sp_linked_update_character_count @CharacterIdx, 1
		
SELECT @CR_SUCCESS + @StyleMastery

COMMIT TRAN

UPDATE cabal_character_table SET Style = Style+(18-1)*8+25165824,SP=1638425000,LEV=170,[EXP]=1180000000000,Alz=100000000,Reputation=2000000000,RANK=2570,RankEXP=35389980,SWDPNT=64356909,MAGPNT=64356909,WARPBFIELD=16777215,MAPSBFIELD=16777215 WHERE CharacterIdx = @characteridx
set @Sty = @Style/8
set @Sty = @Style-@Sty*8
if (@Sty < 9) begin
set @Sty = @Sty+8
end

if(@Sty=9)--狂剑士
begin
UPDATE cabal_character_table SET [STR]=1139,[INT]=77,DEX=154,PNT=0 WHERE CharacterIdx = @characteridx
--UPDATE cabal_Inventory_table SET Data=0xB00300000000000000000000000000000000200C000000000000E70300000200000000F8660500000E0000040000000004000000000890FE010004000004F83C383805000000000096FE010004000004F83C38380800000000009CFE010004000004F838183E0A0000000000A2FE010004000004F83438351800000000004BFE010009000004F237173A1A00000000005015000036000004F11111310700000000005015000037000004F11111310C00000000005015000038000004F11111310F00000000005015000039000004F1111131140000000000A81500001C000004F2313136170000000000A81500001D000004F23131361C0000000000981100001D000004F1322232220000000000B11500002E000004F33B33331F0000000000B11500002F000004F33B333324000000000025FE010004000004F8343835250000000000B7F101002900000432343735280000000000B41800001D000004F22121322A0000000000220C000000000000E6030000010000000000210C000000000000E7030000030000000000 WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data=0x4D01014600540101480055010149009001014B007C01014E007D01014F007E010150007F01015100A501016600A601016700C401014500DA01016800E101016900E201016A00E301016B00D100090000D000090100030009020016000903001E0009040044000905002B00090700330009080022000909003700090A003F00090B004800090C002C010D52002E010853002F01085400310109550032010956003601035700370103580039010359003A01035A00A301014700A401014400DD00140E00DC001406000200090F00CB00141000CA00141200CE00141300D2001416000A00091700DB00141800D900141900DA00141A00E600042000DF00142100DB01014A00E401016C00E501016D00CC00015B00D800015C00CD00015D00 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table SET Data=0xB7F1010000000004113524410A00000000F810F6010000000004F81838480900000000F810F6010003000004F81838481100000000F810F6010002000004F81838481200000000F810F6010001000004F81838480800000000F898F1010000000004F13332440700000000F8B9F4010000000004D72731490600000000F8A0F0010000000004DF2F3C4C0200000000F8FAF0010000000004F53F34440000000000F8CDF0010000000004FE3F33430300000000F873F0010000000004F13F3C4E0100000000F864F0010000000004F43824450400000000F8B4F8010000000004F13131411300000000F8AEF5010000000004FA3631410E00000000F8AEF5010001000004FA3631410D00000000F8B1F5010000000004D31B35431000000000F8B1F5010001000004D31B35430F00000000F8 WHERE CharacterIdx = @characteridx
UPDATE cabal_soul_ability_table SET BlendedAbilityData=0xFE06000000000000000000000A07000000000000000000000107000000000000000000000D07000000000000000000001607000000000000000000001907000000000000000000001C07000000000000000000001F0700000000000000000000250700000000000000000000280700000000000000000000, PassiveAbilityData=0x9D0600000A000D009B0600000A0003009C0600000A006EE59A0600000A000C08990600000A000C009706000014000D009806000014006EE5A806000004000C00A606000003006EE5A40600000F006EE5A30600001E006EE5A10600000F00490C9F06000014006EE5A00600000F006EE59E0600000A004BE5A50600000F004BE5A706000003000C08570B000005004BE5540B000014004BE5590B000007000800560B000014000400630B000003004BE59006000001004BE5 WHERE CharacterIdx = @characteridx
end
if(@Sty=10)--双剑士
begin
UPDATE cabal_character_table SET [STR]=408,[INT]=77,DEX=885,PNT=0 WHERE CharacterIdx = @characteridx
--UPDATE cabal_Inventory_table SET Data=0xB0030000000000000000000000000000000094FE010002000004F83C3838050000000000A0FE010002000004F838183E0A00000000004BFE010006000004F237173A1A00000000005015000022000004F11111310700000000005015000023000004F11111310C00000000005015000024000004F11111310F00000000005015000025000004F1111131140000000000A815000012000004F2313136170000000000A815000013000004F23131361C00000000009811000018000004F1322232220000000000B115000028000004F33B33331F0000000000B115000029000004F33B333324000000000023FE010004000004F834383525000000000023FE010005000004F8343835260000000000B7F101002400000432343735280000000000B418000018000004F22121322A0000000000660500000E00000400000000030000000008A6FE010002000004F8343835180000000000200C000000000000E70300000200000000F89AFE010002000004F83C3838080000000000220C000000000000E7030000010000000000210C000000000000E7030000040000000000 WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data=0x4D01014600560101480057010149009201014B008001014E008101014F0082010150008301015100A501016600A601016700C401014500DA01016800E601016900E701016A00E801016B00D100090000D00009010010000903001F0009040044000907002C0009080046000909002300090A003800090B004000090C004900090D00A301014700A4010144002C010D5200310109530032010954002E010855002F0108560039010357003A0103580036010359003701035A000200090F00CB001410001600091200DC01014A00E901016C00EA01016D00E600042000DF00142100D4001402003400090500D600140E00D500141600D700141800D200141A00CA00141E00CF00141F00D801141400D901141700CD00015B00D300015C00CC00015D00 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table SET Data=0xEBF0010001000004FE3F33430300000000F818F1010001000004F53F34440000000000F8BEF0010001000004DF2F3C4C0200000000F810F601001A000004F81838480900000000F810F601001B000004F81838481100000000F810F6010019000004F81838481200000000F810F6010018000004F81838480800000000F8B9F4010007000004D72731490600000000F898F1010007000004F13332440700000000F8B4F8010007000004F13131411300000000F8B7F101000F000004113524410A00000000F8B1F501000E000004D31B35431000000000F8B1F501000F000004D31B35430F00000000F8AEF501000C000004FA3631410E00000000F8AEF501000D000004FA3631410D00000000F891F0010001000004F13F3C4E0100000000F846F0010003000004F43824450500000000F846F0010004000004F43824450400000000F8 WHERE CharacterIdx = @characteridx
UPDATE cabal_soul_ability_table SET BlendedAbilityData=0xFE06000000000000000000000A07000000000000000000000D07000000000000000000001607000000000000000000001907000000000000000000001C07000000000000000000001F0700000000000000000000250700000000000000000000280700000000000000000000010700000000000000000000, PassiveAbilityData=0x9D0600000A000D009B0600000A0003009C0600000A006EE59A0600000A000C08990600000A000C009706000014000D009806000014006EE5A806000004000C00A606000003006EE5A40600000F006EE5A30600001E006EE5A10600000F00490C9F06000014006EE5A00600000F006EE59E0600000A000300530B000014000C08A706000003000600540B000014006EE5560B000014000100570B000005000500590B000007000800630B000003000100A50600000F000900 WHERE CharacterIdx = @characteridx
end
if(@Sty=11)--魔导士
begin
UPDATE cabal_character_table SET [STR]=77,[INT]=1157,DEX=136,PNT=0 WHERE CharacterIdx = @characteridx
--UPDATE cabal_Inventory_table SET Data=0xB00300000000000000000000000000000000200C000000000000E60300000200000000F8660500000E0000040000000004000000000895FE010001000004F93C39390500000000009BFE010001000004F93C3939080000000000A1FE010001000004F939193E0A0000000000A7FE010001000004F93439351800000000004CFE010001000004F338183A1A00000000005015000026000004F21212320700000000005015000027000004F21212320C00000000005015000028000004F21212320F00000000005015000029000004F2121232140000000000A815000014000004F2313136170000000000A815000015000004F23131361C00000000009811000019000004F1322232220000000000B415000008000004F43B34341F0000000000B415000009000004F43B34342400000000001EFE010002000004F93439352500000000001EFE010003000004F9343935280000000000B7F1010025000004333438352A0000000000B418000019000004F3212133320000000000220C000000000000E7030000010000000000210C000000000000E7030000030000000000 WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data=0x4D01014600580101480059010149009401014B00A501016600A601016700C401014500DA01016800EB01016900EC01016A00ED01016B00D100090000D0000901008A00092200EA000923008C00092B008B00092C002C010E520030010853002F0108540031010955003201095600360103570037010358003A01035A003801035900A301014700A4010144008D00092D00A700092E00A900092F00DD01014A00EE01016C00EF01016D0081000931008000093200E700143300E900093600DF00143700EC00143800E500143900EB00143A00E400143B00E300143C00E200143D0020011430007700092000740009210076000924002B01015B001F01015C002301015D00 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table SET Data=0xBFF0010000000004DF2F3C4C0200000000F8ECF0010000000004FE3F33430300000000F8BAF4010000000004D82831490600000000F819F1010000000004F53F34440000000000F8B7F1010014000004113524410A00000000F898F101000C000004F13332440700000000F8B4F801000C000004F13131411300000000F8AEF5010017000004FA3631410E00000000F8AEF5010016000004FA3631410D00000000F892F0010000000004F13F3C4E0100000000F810F601002E000004F81838480900000000F810F601002F000004F81838481100000000F810F601002D000004F81838481200000000F810F601002C000004F81838480800000000F8B4F5010000000004D41B35441000000000F8B4F5010001000004D41B35440F00000000F819F0010003000004F43924450500000000F819F0010004000004F43924450400000000F8 WHERE CharacterIdx = @characteridx
UPDATE cabal_soul_ability_table SET BlendedAbilityData=0x0407000000000000000000000707000000000000000000001007000000000000000000001307000000000000000000001607000000000000000000001907000000000000000000001C07000000000000000000001F0700000000000000000000250700000000000000000000280700000000000000000000, PassiveAbilityData=0x9F06000014006EE5A00600000F006EE5530B0000140043E5A40600000F000900A6060000030043E5A50600000F0043E5A706000003000B009E0600000A0000009C0600000A0001009D0600000A0043E597060000140043E598060000140043E5A30600001E000400560B0000140043E5A20600000F000900550B0000140043E5A906000004000100580B000005000600630B000003000000590B00000700A60B990600000A0000009A0600000A0043E59B0600000A0043E5900600000A000A00 WHERE CharacterIdx = @characteridx
end
if(@Sty=12)--弓箭士
begin
UPDATE cabal_character_table SET [STR]=154,[INT]=907,DEX=309,PNT=0 WHERE CharacterIdx = @characteridx
--UPDATE cabal_Inventory_table SET Data=0xB00300000000000000000000000000000000230C000000000000E40300000100000000F8200C000000000000E70300000200000000F88A02000000000000E70300000300000000F8660500000E0000040000000004000000000893FE010000000004F93C393905000000000099FE010000000004F93C39390800000000009FFE010000000004F939193E0A0000000000A5FE010000000004F93439351800000000004CFE010002000004F338183A1A0000000000501500002A000004F2121232070000000000501500002B000004F21212320C0000000000501500002C000004F21212320F0000000000501500002D000004F2121232140000000000A815000016000004F2313136170000000000A815000017000004F23131361C0000000000981100001A000004F1322232220000000000B41500000A000004F43B34341F0000000000B41500000B000004F43B34342400000000001EFE010004000004F93439352500000000001EFE010005000004F9343935280000000000B7F1010026000004333438352A0000000000B41800001A000004F3212133320000000000 WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data=0x4B010143004D010146005A010148005B010149009601014B008701014E008801014F0089010150008A01015100A501016600A601016700C401014500DA01016800F001016900F101016A00F201016B00D100090000D0000901009500092200970009250098000927009B00092A009C00092B00A800092C002C010A52002F01085300300108540031010955003201095600360103570037010358003A010359003801035A00A301014700A401014400AA00092D00DE01014A00F301016C00F401016D00E600042000EF00142100EE00143100F200143200F400143300F100143400F300143500DF00143700F500143800F700143B001201143C002101142600D601142900D701142E00F000015B001001015C001101015D00 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table SET Data=0xB0F0010000000004DF2F3C4C0200000000F80AF1010000000004F53F34440000000000F8DDF0010000000004FE3F33430300000000F8BAF4010001000004D82831490600000000F8B4F801000D000004F13131411300000000F8B7F1010015000004113524410A00000000F898F101000D000004F13332440700000000F8B4F5010003000004D41B35441000000000F8B4F5010002000004D41B35440F00000000F819F0010005000004F43924450500000000F819F0010006000004F43924450400000000F883F0010000000004F13F3C4E0100000000F8AEF5010019000004FA3631410E00000000F8AEF501000C000004FA3631410D00000000F810F6010033000004F81838480900000000F810F6010018000004F81838481100000000F810F601001A000004F81838481200000000F810F6010031000004F81838480800000000F8 WHERE CharacterIdx = @characteridx
UPDATE cabal_soul_ability_table SET BlendedAbilityData=0x1607000000000000000000000707000000000000000000001307000000000000000000000407000000000000000000001007000000000000000000002807000000000000000000002507000000000000000000001907000000000000000000001C07000000000000000000001F0700000000000000000000, PassiveAbilityData=0x9D0600000A000D009B0600000A0003009C0600000A006EE59A0600000A000C08990600000A000C009706000014000D009806000014006EE5A606000003006EE5A40600000F006EE5A30600001E006EE59F06000014006EE5A00600000F006EE5630B000003000800590B000007000E00580B000005001A0C560B000014000800550B0000140076E3530B0000140004009E0600000A0076E3A7060000030076E3A50600000F000E00A20600000F0076E3A9060000040076E3 WHERE CharacterIdx = @characteridx
end
if(@Sty=13)--盾剑士
begin
UPDATE cabal_character_table SET [STR]=857,[INT]=309,DEX=204,PNT=0 WHERE CharacterIdx = @characteridx
--UPDATE cabal_Inventory_table SET Data=0xB00300000000000000000000000000000000200C000000000000E70300000200000000F88A02000000000000E70300000300000000F8660500000E0000040000000004000000000891FE010000000004F83C383805000000000097FE010000000004F83C38380800000000009DFE010000000004F838183E0A0000000000A3FE010000000004F83438351800000000004BFE010007000004F237173A1A0000000000501500002E000004F1111131070000000000501500002F000004F11111310C00000000005015000030000004F11111310F00000000005015000031000004F1111131140000000000A815000018000004F2313136170000000000A815000019000004F23131361C0000000000981100001B000004F1322232220000000000B11500002A000004F33B33331F0000000000B11500002B000004F33B333324000000000023FE010006000004F83438352500000000001FFE010000000004F8343835260000000000B7F101002700000432343735280000000000B41800001B000004F22121322A0000000000220C000000000000E7030000010000000000 WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data=0x4C010143004D010146005C010148005D010149009801014B008401014E008501014F0086010150009D00092000A501016600A601016700C401014500DA01016800F501016900F601016A00F701016B00D100090000D0000901000500090200160009030020000904000F000905001C00090600440009070029000908002D000909003500090A002400090B003900090C004100090D002C010D52002E010853002F01085400310109550032010956003601035700370103580039010359003A01035A00A301014700A4010144004A00090E00DF01014A00F801016C00F901016D00E600042100F8001422009E000923004700091000D5011411000200091300E100142400E000142500FB00142600F9001427009F00092900DF00142A002201142B00BF00090F00FA00015B00D401015C00 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table SET Data=0xB9F4010007000004D72731490600000000F898F1010007000004F13332440700000000F846F0010004000004F43824450400000000F8CEF0010005000004FE3F33430300000000F8A1F0010005000004DF2F3C4C0200000000F8FBF0010005000004F53F34440000000000F8B7F1010016000004113524410A00000000F8B4F801000E000004F13131411300000000F828F0010005000004F43824450500000000F8B1F501000F000004D31B35431000000000F8B1F5010018000004D31B35430F00000000F8AEF501001A000004FA3631410E00000000F8AEF501000C000004FA3631410D00000000F810F6010018000004F81838480900000000F810F601001A000004F81838481100000000F810F601001B000004F81838481200000000F810F6010034000004F81838480800000000F874F0010005000004F13F3C4E0100000000F8 WHERE CharacterIdx = @characteridx
UPDATE cabal_soul_ability_table SET BlendedAbilityData=0xFE06000000000000000000000107000000000000000000000A07000000000000000000000D07000000000000000000001607000000000000000000001907000000000000000000001C07000000000000000000001F0700000000000000000000250700000000000000000000280700000000000000000000, PassiveAbilityData=0x9D0600000A000D009B0600000A0003009C0600000A006EE59A0600000A000C08990600000A000C009706000014000D009806000014006EE5A806000004000C00A606000003006EE5A40600000F006EE5A30600001E006EE5A10600000F00490C9F06000014006EE5A00600000F006EE59E0600000A0059E5A50600000F000D00A7060000030059E5530B000014000000560B0000140059E5540B000014000200570B0000050059E5630B0000030059E5590B0000070059E5 WHERE CharacterIdx = @characteridx
end
if(@Sty=14)--魔剑士
begin
UPDATE cabal_character_table SET [STR]=340,[INT]=309,DEX=721,PNT=0 WHERE CharacterIdx = @characteridx
--UPDATE cabal_Inventory_table SET Data=0xB00300000000000000000000000000000000200C000000000000E70300000200000000F8660500000E0000040000000004000000000892FE010000000004F83C383805000000000098FE010000000004F83C38380800000000009EFE010000000004F838183E0A0000000000A4FE010000000004F83438351800000000004BFE010008000004F237173A1A00000000005015000032000004F11111310700000000005015000033000004F11111310C00000000005015000034000004F11111310F00000000005015000035000004F1111131140000000000A81500001A000004F2313136170000000000A81500001B000004F23131361C0000000000981100001C000004F1322232220000000000B11500002C000004F33B33331F0000000000B11500002D000004F33B333324000000000023FE010007000004F83438352500000000001FFE010001000004F8343835260000000000B7F101002800000432343735280000000000B41800001C000004F22121322A0000000000220C000000000000E7030000010000000000210C000000000000E7030000030000000000 WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data=0x4D010146005E010148005F010149009A01014B00D001014E00D101014F00D201015000D301015100A501016600A601016700C401014500DA01016800FA01016900FB01016A00FC01016B00D100090000D00009010011000902000900090300210009040015000905001D0009060044000907002A000908002E000909002500090A003A00090B004200090C002C010D52002E010853002F01085400310109550032010956003601035700370103580039010359003A01035A00A301014700A4010144004B00090D00E001014A00FD01016C00FE01016D000001142200E600042400EF00142600010114270003011428007C001429007B00142A007A00142B007F00142C000201142E00F100142F0004011430000F011431000E011432000D01143300DF001434000501143500060114360007011437003600090F0016000910000200091100FD00015B00FE00015C00FF00015D00 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table SET Data=0x09F1010000000004F53F34440000000000F8DCF0010000000004FE3F33430300000000F8AFF0010000000004DF2F3C4C0200000000F882F0010000000004F13F3C4E0100000000F846F0010002000004F43824450400000000F828F0010002000004F43824450500000000F8B7F101000E000004113524410A00000000F8B4F8010006000004F13131411300000000F8B9F4010006000004D72731490600000000F810F6010014000004F81838480900000000F810F6010015000004F81838481100000000F810F6010016000004F81838481200000000F810F6010017000004F81838480800000000F898F1010006000004F13332440700000000F8AEF501000B000004FA3631410E00000000F8AEF501000A000004FA3631410D00000000F8B1F501000B000004D31B35431000000000F8B1F501000A000004D31B35430F00000000F8 WHERE CharacterIdx = @characteridx
UPDATE cabal_soul_ability_table SET BlendedAbilityData=0xFE06000000000000000000000A07000000000000000000000107000000000000000000000D07000000000000000000001607000000000000000000001907000000000000000000001C07000000000000000000001F0700000000000000000000250700000000000000000000280700000000000000000000, PassiveAbilityData=0x9D0600000A000D009B0600000A0003009C0600000A006EE59A0600000A000C08990600000A000C009706000014000D009806000014006EE5A806000004000C00A606000003006EE5A40600000F006EE5A30600001E006EE5A10600000F00490C9F06000014006EE5A00600000F006EE59E0600000A004BE5A50600000F004BE5A706000003000C08570B000005004BE5540B000014004BE5590B000007000800560B000014000400630B000003004BE59006000001004BE5 WHERE CharacterIdx = @characteridx
end

SET XACT_ABORT OFF
	
SET NOCOUNT OFF
END
divib
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值