[Help] Experience problem

[lynb992]

[MentaL]

[GearWheel]

first write /playtime
if problem is this

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

[lynb992]

im sorry , the problem continues . (sorry my english :))



ACEonline EP 3.5

[GearWheel]

update td_account set totalplaytime=0 and use these codes on sql server
finally restart server

[lynb992]

problem continues , please watch new video

[GearWheel]

first write /playtime and look right system message is there write bla bla minutes hours %50 or %0 exp if hours>5 :)

[St34lth4ng3l]

What about adding Experience to your monsters in your database?!?!?!?!?!?!

[GearWheel]

the problem is fixed i guess,

http://forum.ragezone.com/f908/help-...28/index2.html

[St34lth4ng3l]

the problem is fixed i guess,

http://forum.ragezone.com/f908/help-...28/index2.html

No this is completely offtopic, when you watched his videos >.<

[GearWheel]

nope, this thread for playtime problem. that thread for playtime problem. (this=that)=no problem :))))

[St34lth4ng3l]

nope, this thread for playtime problem. that thread for playtime problem. (this=that)=no problem :))))

Just one word: NO!

Watch his second vid >.<

[GearWheel]

i speak with them and problem is resolved :P
you are right stealthangel but problem gamecontinuetimeoftoday bla bla

[empilein]

he gets exp but uses an gm char which is already max lvl ....

[St34lth4ng3l]

he gets exp but uses an gm char which is already max lvl ....

No, not really, look at his first video, he's level 35.