Most visitors online was 8830 , on 6 Feb 2024
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!USE [atum2_db_1]
GO
--------------------------------------------------------------
-- 9.30. update stored procedures
--------------------------------------------------------------
--!!!!
-- Name:
-- Desc:
-- 2006-04-10 by cmkwon, ÆĶó¹?ÅÍ ?ß°¡(@i_DownSPIOnDeath INT, -- 2006-04-10 by cmkwon)
-- 2006-11-15 by cmkwon, ÀÎÀÚ 2°³ ?ß°¡
-- @i_GameContinueTimeInSecondOfToday INT, -- 2006-11-15 by cmkwon, ¿À´? ÇÏ·ç °ÔÀÓ ÁøÇà ½?°£
-- @i_LastGameEndDate VARCHAR(30) -- 2006-11-15 by cmkwon, ¸¶Áö¸· °ÔÀÓ Á¾·á ³¯Â¥½?°£
--====
ALTER PROCEDURE [dbo].[atum_SaveCharacterCriticalData]
@i_CharacterUID INT,
@i_Level TINYINT,
@i_CharacterMode TINYINT,
@i_Experience FLOAT,
@i_DownExperience FLOAT,
@i_DownSPIOnDeath INT, -- 2006-04-10 by cmkwon
@i_BodyCondition BIGINT,
@i_PetLevel TINYINT,
@i_PetExperience FLOAT,
@i_Position_X FLOAT,
@i_Position_Y FLOAT,
@i_Position_Z FLOAT,
@i_MapIndex SMALLINT,
@i_ChannelIndex SMALLINT,
@i_HP SMALLINT,
@i_DP SMALLINT,
@i_SP SMALLINT,
@i_EP SMALLINT,
@i_currentHP FLOAT,
@i_currentDP FLOAT,
@i_currentSP SMALLINT,
@i_currentEP FLOAT,
@i_totalPlayTime BIGINT,
@i_GameContinueTimeInSecondOfToday INT, -- 2006-11-15 by cmkwon, ¿À´? ÇÏ·ç °ÔÀÓ ÁøÇà ½?°£
@i_LastGameEndDate VARCHAR(30), -- 2006-11-15 by cmkwon, ¸¶Áö¸· °ÔÀÓ Á¾·á ³¯Â¥½?°£
@i_PCBangtotalPlayTime BIGINT, -- 2007-06-07 by dhjin, PC¹æ ?Ñ Ç?·¹À? ½?°£
@i_SecretInfoOption INT -- // 2008-06-23 by dhjin, EP3 À¯ÀúÁ¤º¸¿É¼Ç
AS
UPDATE td_Character
SET Level = @i_Level,
CharacterMode = @i_CharacterMode,
Experience = @i_Experience,
DownExperience = @i_DownExperience,
DownSPIOnDeath = @i_DownSPIOnDeath, -- 2006-04-10 by cmkwon
BodyCondition = @i_BodyCondition,
PetLevel = @i_PetLevel,
PetExperience = @i_PetExperience,
Position_X = @i_Position_X,
Position_Y = @i_Position_Y,
Position_Z = @i_Position_Z,
MapIndex = @i_MapIndex,
ChannelIndex = @i_ChannelIndex,
HP = @i_HP,
DP = @i_DP,
SP = @i_SP,
EP = @i_EP,
currentHP = @i_currentHP,
currentDP = @i_currentDP,
currentSP = @i_currentSP,
currentEP = @i_currentEP,
TotalPlayTime = @i_totalPlayTime,
PCBangTotalPlayTime = @i_PCBangtotalPlayTime,
SecretInfoOption = @i_SecretInfoOption -- // 2008-06-23 by dhjin, EP3 À¯ÀúÁ¤º¸¿É¼Ç
WHERE UniqueNumber = @i_CharacterUID
--------------------------------------------------------------------------------
-- 2006-11-15 by cmkwon
-- atum2_db_account.dbo.td_account Å×À?ºí¿¡ °ÔÀÓÁö¼Ó½?°£, ¸¶Áö¸· °ÔÀÓ Á¾·á½?°£À» ¾÷µ¥À?Æ® ÇÑ´Ù.
UPDATE atum2_db_account.dbo.td_account
SET LastGameEndDate = @i_LastGameEndDate
FROM atum2_db_account.dbo.td_account a, td_character c
WHERE c.UniqueNumber = @i_CharacterUID AND a.AccountUniqueNumber = c.AccountUniqueNumber
No this is completely offtopic, when you watched his videos >.<
Just one word: NO!nope, this thread for playtime problem. that thread for playtime problem. (this=that)=no problem )))
No, not really, look at his first video, he's level 35.he gets exp but uses an gm char which is already max lvl ....