惊天动地三变端~·求指教~~

q348409157 · 发表于 2013-8-3 16:06:15

http://www.iopq.com/thread-16952585-1-2.html 我用的是这个端请问怎么修改初试等级~··我喜欢从1级开始练 ~~求大神指教~···

我爱越越 · 发表于 2013-9-8 20:51:35

你真牛x我下端都没法解压打开数据库点第二行数据库引擎查询然后把这些复制进去，点绿色对号然后点执行。就o了
USE [Server01]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_newchar] Script Date: 03/14/2013 13:51:02 ******/
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=1, [EXP], [STR]+8000, [DEX]+8000, [INT]+8000, [PNT], Rank, Alz+21000000000,
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

EXEC cabal_sp_linked_update_character_count @CharacterIdx, 1

SELECT @CR_SUCCESS + @StyleMastery

COMMIT TRAN

UPDATE cabal_character_table SET Style = Style+(1-1)*8+25165824, SP = 1638425000, Reputation = 1000000  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 RANK=2570,SWDPNT=64356909,MAGPNT=64356909,REPUTATION=2010720000,WARPBFIELD=4095,MAPSBFIELD=4095 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0x4D01014600540101480055010149009001014B007C01014E007D01014F007E010150007F01015100A501016600A601016700DA01016800E101016900E201016A00E301016B002C01FF5200D000090300D100090000A3010147002E010853002F01085400A401014400CC00140700CA00140800CE00140900CD00140A00CB00140B0039010355003A01035600DD001402003701035700C401014500DB01014A0037000904002200090600D900140C00DA00140D00DC00140E00DB00140F00D200141000E401016C003F00091100E501016D004400091200D80014130027000914002B000901003300090500CC01012300CD01012400CE01012500CF01012600E600042000DF00142100 WHERE CharacterIdx = @characteridx
end
if(@Sty=10)--双剑士
begin
UPDATE cabal_character_table SET RANK=2570,SWDPNT=64356909,MAGPNT=64356909,REPUTATION=2010720000,WARPBFIELD=4095,MAPSBFIELD=4095 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0x4D01014600560101480057010149009201014B008001014E008101014F0082010150008301015100A501016600A601016700DA01016800E601016900E701016A00E801016B002C01FF5200D100090300D000090400A3010147002E010853002F01085400C401014500CC00140700A401014400CD0014080039010355003A01035600CA00140B00D300140C0023000906004000090D004600140E001F00140F003800091000D5001411003701035700D700141200D200141300D600141400CF00140100D9011400004400140200DC01014A00D801140500E901016C00CB00140A00EA01016D002C00090900CC01012300CD01012400CE01012500CF01012600E600042000DF00142100 WHERE CharacterIdx = @characteridx
end
if(@Sty=11)--魔导师
begin
UPDATE cabal_character_table SET RANK=2570,SWDPNT=64356909,MAGPNT=64356909,REPUTATION=2010720000,WARPBFIELD=4095,MAPSBFIELD=4095 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xCC01012300CD01012400CE01012500CF010126004D01014600580101480059010149009401014B00D000090000D100090100A301014700E800142200A401014400EA00092900DF00142A00EC00142B008B00092F00EB001430008D00093100E200143500E300143600A7000937008C00093300C401014500E600043900890009200086000921002C01FF520030010853002F010854003A0103550038010356003701035700A501016600A601016700DA01016800EB01016900EC01016A00ED01016B008A0009260088000924008700092500DD01014A00EE01016C00EF01016D00E4001432007E000923007D00092E00E500012D00 WHERE CharacterIdx = @characteridx
end
if(@Sty=12)--弓手
begin
UPDATE cabal_character_table SET RANK=2570,SWDPNT=64356909,MAGPNT=64356909,REPUTATION=2010720000,WARPBFIELD=4095,MAPSBFIELD=4095 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xCC01012300CD01012400CE01012500CF010126004B010143004D010146005A010148005B010149009601014B008701014E008801014F0089010150008A01015100D100090000D000090100A301014700A401014400F100142900F500142A00F400142B00F300142C009800092D009B00092E009C00092F00F7001430001201143100DF0014320010011433001101143400F200143500C401014500D701143600D601143700A800093800F600093900E6000420002C01FF520030010854002F010855003A0103530038010356003701035700A501016600A601016700DA01016800F001016900F101016A00F201016B00DE01014A0099000927009A00092800F301016C00F401016D00 WHERE CharacterIdx = @characteridx
end
if(@Sty=13)--盾战士
begin
UPDATE cabal_character_table SET RANK=2570,SWDPNT=64356909,MAGPNT=64356909,REPUTATION=2010720000,WARPBFIELD=4095,MAPSBFIELD=4095 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xCC01012300CD01012400CE01012500CF010126004C010143004D010146005C010148005D010149009801014B008401014E008501014F008601015000D100090200E600042100D000090300A301014700F900142200C4010145000F0009060026000907002900090800A401014400D5011409002D00090A003500090B00D401140C002400090D00FB001427003900090E00E000142800E1001429004100090F00200009100019000911002C01FF52002E010853002F0108540039010355003A01035600A501016600A601016700DA01016800F501016900F601016A00F701016B00DF01014A00F801016C00F901016D0044000913001C0009000016000901000B0009040047000905009F00092F003701035700F800142000FA00142A00DF00142B00 WHERE CharacterIdx = @characteridx
end
if(@Sty=14)--魔剑士
begin
UPDATE cabal_character_table SET RANK=2570,SWDPNT=64356909,MAGPNT=64356909,REPUTATION=2010720000,WARPBFIELD=4095,MAPSBFIELD=4095 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xCC01012300CD01012400CE01012500CF0101260002000900004D010146005E010148005F010149009A01014B00D001014E00D101014F00D201015000D301015100A301014700D100090100D000090200FF00142200210009030011000904000001142000030114210042000905003A00090600250009070006011427001D00090800160009090005011428002A00090A004400090B002E00090C000D01142D000E01142E000F01142F002C01FF52002E0108530039010354003A010355002F01085700A501016600A601016700DA01016800FA01016900FB01016A00FC01016B00E001014A00FD01016C00FE01016D00A401014400F100143000EF00143100E600043200DF001433003600090D00010114340007011435001500090E000900090F0019000910002600091100020114370004010938003701035600FE00142900 WHERE CharacterIdx = @characteridx
end

SET XACT_ABORT OFF

SET NOCOUNT OFF
END

我爱越越 · 发表于 2013-9-8 20:52:07

求上传你的端我下来玩玩我可帮你了你也帮帮我

我爱越越 · 发表于 2013-9-8 20:52:31

我要开服想弄个好端

我爱越越 · 发表于 2013-9-8 20:54:15

LEV=1, [EXP], [STR]+8000, [DEX]+8000, [INT]+8000, [PNT], Rank, Alz+21000000000这里改你的上线等级属性点 lev+1当人就是1及咯

我爱越越 · 发表于 2013-9-8 21:02:32

我爱越越发表于 2013-9-8 20:54
LEV=1, [EXP], [STR]+8000, [DEX]+8000, +8000, , Rank, Alz+21000000000这里改你的上线等级属性点 lev+1当 ...

lev=1别误导你啊

		自动登录	找回密码
密码			注册

[求助] 惊天动地三变端~·求指教~~