Minimum Stats and Start Level

Results 1 to 5 of 5
  1. #1
    Registered WarriorBurn is offline
    MemberRank
    Mar 2016 Join Date
    22Posts

    config Minimum Stats and Start Level


    RaGEZONE Recommends

    RaGEZONE Recommends

    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.


  2. #2
    Registered ToKISKISKIS is offline
    MemberRank
    Nov 2016 Join Date
    12Posts

    Re: Stats

    search g_arrLevelStatValue on atumsj.cpp. line 4700~

  3. #3
    Registered WarriorBurn is offline
    MemberRank
    Mar 2016 Join Date
    22Posts

    Re: Stats

    I also want to set it as level 11 for start

  4. #4
    Hardcore Member EricThom is offline
    MemberRank
    Dec 2014 Join Date
    100Posts

    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_"¸¦ Ãß°¡ÇÔ.
     @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;

  5. #5
    Minimum Stats and Start Level Future is offline
    SupervisorRank
    Dec 2011 Join Date
    1,690Posts

    Re: Stats

    Try searching the next time:

    [Help] Instant level 110 and only 1 quest

    #Closed




    Quote Originally Posted by A Wise Man
    P-Servers are NOT dead. Bugs need squishing. Quests need fixing. Unfortunately, majority of people don't know the difference between a computer and a toaster so...




Advertisement