USE [atum2_db_1]GO
/****** Object: StoredProcedure [dbo].[atum_CreateCharacter] Script Date: 7/18/2017 9:22:08 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[atum_CreateCharacter]
@i_CharacterName VARCHAR(20), -- // 2009-01-21 by cmkwon, À¥¿¡¼ »ç¿ë °¡´ÉÇÑ ij¸¯Åà »ý¼º Ç÷νÃÀú Ãß°¡ - "i_"¸¦ Ãß°¡ÇÔ.
[USER=1333352388]Character[/USER]NameForSearch VARCHAR(64),
[USER=162874]account[/USER]Name VARCHAR(20),
[USER=162874]account[/USER]UniqueNumber INT,
[USER=109]gender[/USER] TINYINT,
@Race SMALLINT,
[USER=523252]Unit[/USER]Kind INT,
[USER=2000123458]Influence[/USER]Type TINYINT,
[USER=2000047081]Select[/USER]ableInfluenceMask TINYINT, -- 2005-12-07 by cmkwon
[USER=2000198015]Pilot[/USER]Face TINYINT,
[USER=1333352388]Character[/USER]Mode TINYINT,
[USER=2000159312]AuTo[/USER]StatType TINYINT,
[USER=165725]AttaCK[/USER]Part SMALLINT,
[USER=2000230007]def[/USER]ensePart SMALLINT,
@FuelPart SMALLINT,
[USER=762321]Soul[/USER]Part SMALLINT,
[USER=173438]Shield[/USER]Part SMALLINT,
@DodgePart SMALLINT,
[USER=237450]GuiL[/USER]dName VARCHAR(30),
[USER=237450]GuiL[/USER]dUniqueNumber INT,
[USER=501312]level[/USER] TINYINT,
[USER=2000198806]experience[/USER] FLOAT,
[USER=2000190331]body[/USER]Condition BIGINT,
[USER=524049]Pro[/USER]pensity INT,
@Status TINYINT,
@PKWinPoint SMALLINT,
@PKLossPoint SMALLINT,
[USER=262018]Mater[/USER]ial SMALLINT,
@HP SMALLINT,
@DP SMALLINT,
@SP SMALLINT,
@EP SMALLINT,
[USER=324840]petn[/USER]ame VARCHAR(20),
@PetLevel TINYINT,
[USER=804630]Pete[/USER]xperience FLOAT,
@Position_X FLOAT,
@Position_Y FLOAT,
@Position_Z FLOAT,
@MapIndex SMALLINT,
@ChannelIndex SMALLINT,
[USER=447213]Max[/USER]Level TINYINT,
@currentHP FLOAT,
@currentDP FLOAT,
@currentSP SMALLINT,
@currentEP FLOAT,
[USER=2000170033]bonus[/USER]Stat TINYINT,
[USER=2000170033]bonus[/USER]SkillPoint TINYINT,
[USER=2000122825]last[/USER]PartyID BIGINT
AS
DECLARE @AccoutTypeAppliedRace INT
SET @AccoutTypeAppliedRace = @Race | (SELECT AccountType FROM atum2_db_account.dbo.td_account
WITH (NOLOCK) WHERE AccountUniqueNumber = [USER=162874]account[/USER]UniqueNumber)
INSERT INTO td_Character(CharacterName,AccountName,AccountUniqueNumber,Gender,Race,UnitKind,InfluenceType,SelectableInfluenceMask,PilotFace,CharacterMode,AutoStatType,AttackPart,DefensePart,FuelPart,SoulPart,ShieldPart,DodgePart,GuildName,GuildUniqueNumber,Level,Experience,DownExperience,DownSPIOnDeath,BodyCondition,Propensity,Status,PKWinPoint
,PKLossPoint,Material,HP,DP,SP,EP,PetName,PetLevel,PetExperience,Position_X,Position_Y,Position_Z,MapIndex,ChannelIndex,MaxLevel,CurrentHP,CurrentDP,CurrentSP,CurrentEP,BonusStat,BonusStatPoint
,LastPartyID,RacingPoint,TotalPlayTime,CreatedTime,LastStartedTime,LevelUpTime)
VALUES (@i_CharacterName, [USER=162874]account[/USER]Name, [USER=162874]account[/USER]UniqueNumber, [USER=109]gender[/USER], @AccoutTypeAppliedRace,
[USER=523252]Unit[/USER]Kind, [USER=2000123458]Influence[/USER]Type, [USER=2000047081]Select[/USER]ableInfluenceMask, [USER=2000198015]Pilot[/USER]Face, [USER=1333352388]Character[/USER]Mode, [USER=2000159312]AuTo[/USER]StatType, [USER=165725]AttaCK[/USER]Part, [USER=2000230007]def[/USER]ensePart, @FuelPart,
[USER=762321]Soul[/USER]Part, [USER=173438]Shield[/USER]Part, @DodgePart, [USER=237450]GuiL[/USER]dName, [USER=237450]GuiL[/USER]dUniqueNumber,
[USER=501312]level[/USER], [USER=2000198806]experience[/USER], 0, 0, [USER=2000190331]body[/USER]Condition, [USER=524049]Pro[/USER]pensity, @Status,
@PKWinPoint, @PKLossPoint, [USER=262018]Mater[/USER]ial, @HP, @DP,
@SP, @EP, [USER=324840]petn[/USER]ame, @PetLevel, [USER=804630]Pete[/USER]xperience,
@Position_X, @Position_Y, @Position_Z, @MapIndex, @ChannelIndex,
[USER=447213]Max[/USER]Level, @currentHP, @currentDP, @currentSP, @currentEP,
[USER=2000170033]bonus[/USER]Stat, [USER=2000170033]bonus[/USER]SkillPoint, [USER=2000122825]last[/USER]PartyID, 0, 0, GetDate(), NULL,GetDate())
DECLARE [USER=2000184350]Unique[/USER]number INT
SET [USER=2000184350]Unique[/USER]number = (SELECT uniquenumber FROM td_Character WITH (NOLOCK) WHERE charactername = @i_CharacterName)
-- kiem tra xem da tao duoc chua
IF [USER=2000184350]Unique[/USER]number IS NULL)
BEGIN
SELECT 0;
RETURN;
END
--
IF ( [USER=523252]Unit[/USER]Kind = 1) -- BT, B-Gear
BEGIN
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7001950, 1500, 1, 2 -- 1Çü ¹«±â
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7900000, 150, 1, 4 -- 2Çü ¹«±â
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7001230, 1, 1, 6 -- ¿£Áø
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7000970, 1, 1, 0 -- ±âº» ·¹À?´Ù
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 8010100, 1, 1, 5 -- ¾Æ¸Ó - º£ÀÏ 2005-12-03 by cmkwon
END
ELSE IF ( [USER=523252]Unit[/USER]Kind = 16) -- OT, M-Gear
BEGIN
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7001950, 1500, 1, 2 -- 1Çü ¹«±â
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7900000, 150, 1, 4 -- 2Çü ¹«±â
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7002580, 1, 1, 6 -- ¿£Áø
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7000970, 1, 1, 0 -- ±âº» ·¹À?´Ù
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 8011100, 1, 1, 5 -- ¾Æ¸Ó - µ?Ææ´? 2005-12-03 by cmkwon
END
ELSE IF ( [USER=523252]Unit[/USER]Kind = 256) -- DT, A-Gear
BEGIN
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7000050, 1000, 1, 2 -- 1Çü ¹«±â
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7900440, 300, 1, 4 -- 2Çü ¹«±â - °¡µå
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7002590, 1, 1, 6 -- ¿£Áø
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7011500, 1, 1, 0 -- ¹?Å° ·¹À?´Ù
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 8012100, 1, 1, 5 -- ¾Æ¸Ó - °¡´? 2005-12-03 by cmkwon
END
ELSE IF ( [USER=523252]Unit[/USER]Kind = 4096) -- ST, I-Gear
BEGIN
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7001950, 1500, 1, 2 -- 1Çü ¹«±â
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7900000, 150, 1, 4 -- 2Çü ¹«±â
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7002570, 1, 1, 6 -- ¿£Áø
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 7000970, 1, 1, 0 -- ±âº» ·¹À?´Ù
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default [USER=2000184350]Unique[/USER]number, 8013100, 1, 1, 5 -- ¾Æ¸Ó - ¹ÙÀδ? 2005-12-03 by cmkwon
END
EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum [USER=2000184350]Unique[/USER]number, 7000022, 0 -- 2005-12-07 by cmkwon, ¾ÆÀ?ÅÛÀº ²À ?ß°¡ ÇؾßÇÔ
DECLARE @bIsRace INT
SET @bIsRace = 2048 & @AccoutTypeAppliedRace
UPDATE td_Character SET Level = 11, Experience = 0, BonusStat = 10
WHERE UniqueNumber = [USER=2000184350]Unique[/USER]number
EXEC dbo.atum_admin_SetMoney @i_CharacterName, 0
SELECT count(*) FROM td_Character WITH (NOLOCK) WHERE AccountUniqueNumber = [USER=162874]account[/USER]UniqueNumber AND 0 = Race & 0x4000;