• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Minimum Stats and Start Level

Status
Not open for further replies.
WarriorBurn

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
The Best DDoS Protected Servers
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.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
133
Guests online
10,465
Total visitors
10,598
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,311
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top