[Help] If WarPoints

[St34lth4ng3l]

I have a problem, if Users go to IF they have to relogg to keep their WarPoints, i found the Bug and changed the Procedure to:

USE [atum2_db_1]GO
/****** Object:  StoredProcedure [dbo].[atum_CharacterSaveDataInfinityFin]    Script Date: 02.11.2013 18:55:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--------------------------------------------------------------------------------
-- PROCEDURE NAME    : dbo.atum_CharacterSaveDataInfinityFin
-- DESC                : -- // 2009-09-09 ~ 2010 by dhjin, 인피니티 - 인피 종료 후 MainSvr에 인피 진행하면서 수정된 케릭터 정보 수정
--------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[atum_CharacterSaveDataInfinityFin]
    @i_CharacterUID        INT,
    @i_Level            TINYINT,
    @i_Experience        FLOAT,
    @i_DownExperience    FLOAT,
    @i_DownSPIOnDeath    INT,            -- 2006-04-10 by cmkwon
    @i_totalPlayTime    BIGINT,
    @i_PCBangtotalPlayTime    BIGINT,                        -- 2007-06-07 by dhjin, PC방 총 플레이 시간
    @i_SecretInfoOption        INT,                -- // 2008-06-23 by dhjin, EP3 유저정보옵션
    @i_AttackPart        SMALLINT,
    @i_DefensePart        SMALLINT,
    @i_FuelPart            SMALLINT,
    @i_SoulPart            SMALLINT,
    @i_ShieldPart        SMALLINT,
    @i_DodgePart        SMALLINT,
    @i_bstat            TINYINT,
    @i_bstatPoint        TINYINT,
    @i_LevelUpTime        VARCHAR(30),                --// 2006-12-18 by dhjin, 레벨업 시간
    @i_WarPoint            INT,                    --    // 2007-04-17 by dhjin, WP
    @i_CumulativeWarPoint    INT,                --    // 2007-05-28 by dhjin, 누적WP
    @i_MapIndex            SMALLINT,                            --    // 2009-09-09 ~ 2010 by dhjin, 인피니티 - 팅긴 유저 재접속 처리
    @i_ChannelIndex        SMALLINT                            --    // 2009-09-09 ~ 2010 by dhjin, 인피니티 - 팅긴 유저 재접속 처리
-- // 2009-02-17 by cmkwon, MARK for Yedang                    -- // 2008-09-04 by cmkwon, 예당 보안관련 숨긴 계정 적용 하기(SQL Server 2005이상만 지원하는 기능) - 
AS
    UPDATE td_Character
    SET    Level            = @i_Level,
        Experience        = @i_Experience,
        DownExperience  = @i_DownExperience,
        DownSPIOnDeath    = @i_DownSPIOnDeath,            -- 2006-04-10 by cmkwon
        totalPlayTime    = @i_totalPlayTime,
        PCBangtotalPlayTime = @i_PCBangtotalPlayTime,                        -- 2007-06-07 by dhjin, PC방 총 플레이 시간
        SecretInfoOption    = @i_SecretInfoOption,                -- // 2008-06-23 by dhjin, EP3 유저정보옵션
        AttackPart        = @i_AttackPart,
        DefensePart        = @i_DefensePart,
        FuelPart        = @i_FuelPart,
        SoulPart        = @i_SoulPart,
        ShieldPart        = @i_ShieldPart,
        DodgePart        = @i_DodgePart,
        BonusStat        = @i_bstat,
        BonusStatPoint    = @i_bstatPoint,
        LevelUpTime        = @i_LevelUpTime,            --    // 2006-12-18 by dhjin, 레벨업 시간
        WarPoint        = @i_WarPoint,                    --    // 2007-04-17 by dhjin, WP
        CumulativeWarPoint    = @i_CumulativeWarPoint,                    --    // 2007-05-28 by dhjin, 누적WP
        MapIndex        = @i_MapIndex,            --    // 2009-09-09 ~ 2010 by dhjin, 인피니티 - 팅긴 유저 재접속 처리
        ChannelIndex    = @i_ChannelIndex        --    // 2009-09-09 ~ 2010 by dhjin, 인피니티 - 팅긴 유저 재접속 처리
    WHERE UniqueNumber = @i_CharacterUID
    
    DECLARE @AccountUID INT = (SELECT AccountUniqueNumber FROM td_Character WHERE UniqueNumber = @i_CharacterUID)
    
    /*UPDATE atum2_db_account.dbo.td_Account
    SET WarPoint        = @i_WarPoint,
        CumulativeWarPoint    = @i_CumulativeWarPoint
    WHERE AccountUniqueNumber = @AccountUID*/

but now there is the Problem that they will loose their WP everytime they go to IF, and i cannot give the WP via Admin Tool because it's not inserting the new amount of WP, i checked all Update/Get/Change Procedures with WP but i cannot find the Error, may someone here is able to help me

[MentaL]

[pegasus82]

check arena_CopyDBInfo and arena_CopyDBInfo_Infinity

[St34lth4ng3l]

Thank you solved, i overlooked them both^^

[zermen]

Can you give me tutorial to fix bug War Point IF

[Future]

no, you can easily find it out yourself by checking the mentioned procedures pegasus82 ;)

[zermen]

UPDATE atum2_db_arena.dbo.td_Character
SET Race = sc.Race, UnitKind = sc.UnitKind, InfluenceType = sc.InfluenceType
, PilotFace = sc.PilotFace, AttackPart = sc.AttackPart, DefensePart = sc.DefensePart, FuelPart = sc.FuelPart, SoulPart = sc.SoulPart
, ShieldPart = sc.ShieldPart, DodgePart = sc.DodgePart, Level = sc.Level, Experience = sc.Experience, BodyCondition = sc.BodyCondition, Propensity = sc.Propensity
, Status = sc.Status, PKWinPoint = sc.PKWinPoint, PKLossPoint = sc.PKLossPoint, HP = sc.HP, DP = sc.DP, SP = sc.SP, EP = sc.EP
, BonusStat = sc.BonusStat, BonusStatPoint = sc.BonusStatPoint/*, WarPoint = sc.WarPoint, CumulativeWarPoint = sc.CumulativeWarPoint*/
, ArenaWin = sc.ArenaWin, ArenaLose = sc.ArenaLose, ArenaDisConnect = sc.ArenaDisConnect, TotalPlayTime = sc.TotalPlayTime, PCBangTotalPlayTime = sc.PCBangTotalPlayTime
,SecretInfoOption = sc.SecretInfoOption
FROM dbo.td_Character sc, atum2_db_arena.dbo.td_Character tc
WHERE tc.AccountUniqueNumber = @i_AccountUID AND tc.UniqueNumber = @i_ArenaCharacterUID AND sc.UniqueNumber = @i_CharacterUID
IF (@@Error <> 0)

TO

UPDATE atum2_db_arena.dbo.td_Character
SET Race = sc.Race, UnitKind = sc.UnitKind, InfluenceType = sc.InfluenceType
, PilotFace = sc.PilotFace, AttackPart = sc.AttackPart, DefensePart = sc.DefensePart, FuelPart = sc.FuelPart, SoulPart = sc.SoulPart
, ShieldPart = sc.ShieldPart, DodgePart = sc.DodgePart, Level = sc.Level, Experience = sc.Experience, BodyCondition = sc.BodyCondition, Propensity = sc.Propensity
, Status = sc.Status, PKWinPoint = sc.PKWinPoint, PKLossPoint = sc.PKLossPoint, HP = sc.HP, DP = sc.DP, SP = sc.SP, EP = sc.EP
, BonusStat = sc.BonusStat, BonusStatPoint = sc.BonusStatPoint, WarPoint = sc.WarPoint, CumulativeWarPoint = sc.CumulativeWarPoint
, ArenaWin = sc.ArenaWin, ArenaLose = sc.ArenaLose, ArenaDisConnect = sc.ArenaDisConnect, TotalPlayTime = sc.TotalPlayTime, PCBangTotalPlayTime = sc.PCBangTotalPlayTime
,SecretInfoOption = sc.SecretInfoOption
FROM dbo.td_Character sc, atum2_db_arena.dbo.td_Character tc
WHERE tc.AccountUniqueNumber = @i_AccountUID AND tc.UniqueNumber = @i_ArenaCharacterUID AND sc.UniqueNumber = @i_CharacterUID
IF (@@Error <> 0)

[Future]

Congratulations. I´m proud of you

[zermen]

arena_CopyDBInfo_Infinity = Succse
But
check arena_CopyDBInfo = Error
Msg 402, Level 16, State 1, Procedure arena_CopyDBInfo, Line 105
The data types nvarchar and varbinary are incompatible in the '&' operator.
Msg 402, Level 16, State 1, Procedure arena_CopyDBInfo, Line 117
The data types nvarchar and varbinary are incompatible in the '&' operator.
Msg 402, Level 16, State 1, Procedure arena_CopyDBInfo, Line 219
The data types nvarchar and varbinary are incompatible in the '&' operator.
How can fix it ?

- - - Updated - - -

help me please i loss WP when the incoming IF