Welcome!

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!

Minimum Stats and Start Level

Status
Not open for further replies.
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.
 
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.
Back
Top