Minimum Stats and Start Level

[WarriorBurn]

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.

[MentaL]

[ToKISKISKIS]

search g_arrLevelStatValue on atumsj.cpp. line 4700~

[WarriorBurn]

I also want to set it as level 11 for start

[EricThom]

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_"¸¦ Ãß°¡ÇÔ.
 @CharacterNameForSearch		VARCHAR(64),
 @accountName				VARCHAR(20),
 @accountUniqueNumber		INT,
 @gender						TINYINT,
	@Race			SMALLINT,
 @UnitKind		INT,
 @InfluenceType	TINYINT,
 @SelectableInfluenceMask	TINYINT,		-- 2005-12-07 by cmkwon
 @PilotFace		TINYINT,
 @CharacterMode	TINYINT,
 @AuToStatType	TINYINT,
 @AttaCKPart		SMALLINT,
 @defensePart	SMALLINT,
	@FuelPart		SMALLINT,
 @SoulPart		SMALLINT,
 @ShieldPart		SMALLINT,
	@DodgePart		SMALLINT,
 @GuiLdName		VARCHAR(30),
 @GuiLdUniqueNumber	INT,
 @level			TINYINT,
 @experience		FLOAT,
 @bodyCondition	BIGINT,
 @Propensity		INT,
	@Status			TINYINT,
	@PKWinPoint		SMALLINT,
	@PKLossPoint	SMALLINT,
 @Material		SMALLINT,
	@HP				SMALLINT,
	@DP				SMALLINT,
	@SP				SMALLINT,
	@EP				SMALLINT,
 @petname		VARCHAR(20),
	@PetLevel		TINYINT,
 @Petexperience	FLOAT,
	@Position_X		FLOAT,
	@Position_Y		FLOAT,
	@Position_Z		FLOAT,
	@MapIndex		SMALLINT,
	@ChannelIndex	SMALLINT,
 @MaxLevel		TINYINT,
	@currentHP		FLOAT,
	@currentDP		FLOAT,
	@currentSP		SMALLINT,
	@currentEP		FLOAT,
 @bonusStat		TINYINT,
 @bonusSkillPoint	TINYINT,
 @lastPartyID	BIGINT
AS
	DECLARE @AccoutTypeAppliedRace INT
	SET @AccoutTypeAppliedRace = @Race | (SELECT AccountType FROM atum2_db_account.dbo.td_account
								WITH (NOLOCK) WHERE AccountUniqueNumber = @accountUniqueNumber)


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, @accountName, @accountUniqueNumber, @gender, @AccoutTypeAppliedRace,
	 @UnitKind, @InfluenceType, @SelectableInfluenceMask, @PilotFace, @CharacterMode, @AuToStatType, @AttaCKPart, @defensePart, @FuelPart,
	 @SoulPart, @ShieldPart, @DodgePart, @GuiLdName, @GuiLdUniqueNumber,
	 @level, @experience, 0, 0, @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, @bonusSkillPoint, @lastPartyID, 0, 0, GetDate(), NULL,GetDate())
	DECLARE @Uniquenumber INT
	SET @Uniquenumber = (SELECT uniquenumber FROM td_Character WITH (NOLOCK) WHERE charactername = @i_CharacterName)
	-- kiem tra xem da tao duoc chua
	IF  @Uniquenumber IS NULL)
	BEGIN
		SELECT 0;
		RETURN;
	END
	--
	IF ( @UnitKind = 1)     -- BT, B-Gear
		BEGIN
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7001950, 1500, 1, 2		-- 1Çü ¹«±â
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7900000, 150, 1, 4		-- 2Çü ¹«±â
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7001230, 1, 1, 6			-- ¿£Áø
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7000970, 1, 1, 0		-- ±âº» ·¹À?´Ù
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 8010100, 1, 1, 5		-- ¾Æ¸Ó - º£ÀÏ 2005-12-03 by cmkwon
		END
	ELSE IF ( @UnitKind = 16)    -- OT, M-Gear
		BEGIN
		EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7001950, 1500, 1, 2		-- 1Çü ¹«±â
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7900000, 150, 1, 4		-- 2Çü ¹«±â
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7002580, 1, 1, 6			-- ¿£Áø
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7000970, 1, 1, 0		-- ±âº» ·¹À?´Ù
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 8011100, 1, 1, 5		-- ¾Æ¸Ó - µ?Ææ´? 2005-12-03 by cmkwon
		END
	ELSE IF ( @UnitKind = 256)     -- DT, A-Gear
		BEGIN
		EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7000050, 1000, 1, 2		-- 1Çü ¹«±â
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7900440, 300, 1, 4			-- 2Çü ¹«±â - °¡µå
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7002590, 1, 1, 6			-- ¿£Áø
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7011500, 1, 1, 0		-- ¹?Å° ·¹À?´Ù
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 8012100, 1, 1, 5		-- ¾Æ¸Ó - °¡´? 2005-12-03 by cmkwon
		END
	ELSE IF ( @UnitKind = 4096)     -- ST, I-Gear
		BEGIN
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7001950, 1500, 1, 2		-- 1Çü ¹«±â
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7900000, 150, 1, 4		-- 2Çü ¹«±â
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7002570, 1, 1, 6			-- ¿£Áø
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 7000970, 1, 1, 0		-- ±âº» ·¹À?´Ù
			EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum_for_default @Uniquenumber, 8013100, 1, 1, 5		-- ¾Æ¸Ó - ¹ÙÀδ? 2005-12-03 by cmkwon
		END
	
	EXEC dbo.atum_admin_InsertStoreItem_DB_by_CharacUniqueNum @Uniquenumber, 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 = @Uniquenumber
	EXEC dbo.atum_admin_SetMoney @i_CharacterName, 0


	SELECT count(*) FROM td_Character WITH (NOLOCK) WHERE AccountUniqueNumber = @accountUniqueNumber AND 0 = Race & 0x4000;

[Future]

Try searching the next time:

[Help] Instant level 110 and only 1 quest

#Closed