Minimum Stats and Start Level

Status
Not open for further replies.

WarriorBurn

Newbie Spellweaver
Joined
Mar 22, 2016
Messages
23
Reaction score
0
Guys how many stats the player should have when his level 11 and the max is 123 , all Mission removed

and whats the code for it please?

Thank you.
 
Sort by date Sort by votes
E

EricThom

Junior Spellweaver
Joined
Dec 15, 2014
Messages
116
Reaction score
6
Re: Stats

Code: 
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, À¥¿¡¼­ »ç¿ë °¡´ÉÇÑ Ä³¸¯ÅÍ »ý¼º ÇÁ·Î½ÃÀú Ãß°¡ - "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;
 
Upvote 0
Status
Not open for further replies.