Most visitors online was 8830 , on 6 Feb 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!USE [SERVER01]
GO
/****** Object: StoredProcedure [dbo].[cabal_sp_newchar] Script Date: 02/10/2015 01:17:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_newchar]
(
[USER=1333344765]name[/USER] VARCHAR(16),
[USER=1333352388]Character[/USER]Idx INT,
[USER=24452]StYle[/USER] INT,
[USER=862733]Stylemaster[/USER]y INT
)
AS
BEGIN
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 [USER=862733]Stylemaster[/USER]y BETWEEN 1 AND 6
BEGIN
SELECT @CR_DATABRK
RETURN
END
IF EXISTS (SELECT * FROM cabal_badwoard WHERE badword = [USER=1333344765]name[/USER] )
BEGIN
SELECT @CR_BADWORD
RETURN
END
IF EXISTS (SELECT * FROM cabal_character_table WHERE Name = [USER=1333344765]name[/USER])
BEGIN
SELECT @CR_NAMEDUP
RETURN
END
IF EXISTS (SELECT * FROM cabal_character_table WHERE CharacterIdx = [USER=1333352388]Character[/USER]Idx)
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
[USER=1333352388]Character[/USER]Idx, [USER=1333344765]name[/USER],
LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
WorldIdx, Position, [USER=24452]StYle[/USER] +152,
HP, MP, SP +1111425024, SwdPNT +1111425024, MagPNT +1111425024, RankEXP, Flags, WarpBField = 4095, MapsBField = 4095
FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y
IF @@ROWCOUNT <> 1
BEGIN
ROLLBACK TRAN
SELECT @CR_DATABRK
RETURN
END
INSERT INTO cabal_inventory_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, InventoryData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y
INSERT INTO cabal_equipment_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, EquipmentData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y
INSERT INTO cabal_skilllist_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, SkillData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y
INSERT INTO cabal_quickslot_table (CharacterIdx, Data)
SELECT [USER=1333352388]Character[/USER]Idx, QuickSlotData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y
INSERT INTO cabal_questdata_table (characterIdx, Data, Flags)
SELECT [USER=1333352388]Character[/USER]Idx, QuestData, QuestFlagsData FROM cabal_new_character_data
WHERE ClassType = [USER=862733]Stylemaster[/USER]y
EXEC cabal_sp_linked_update_character_count [USER=1333352388]Character[/USER]Idx, 1
SELECT @CR_SUCCESS + [USER=862733]Stylemaster[/USER]y
COMMIT TRAN
SET XACT_ABORT OFF
SET NOCOUNT OFF
END