I ve an error in my DB that not save the characters, non position and level in the world. after restart server. The character go back for level 1. thx.
I don't know if it will be of use to you, but: Code: CREATE PROCEDURE dbo.lin_SaveCharacter ( @subjob_id INT, @pledge_id INT, @class INT, @world INT, @xloc INT, @yloc INT, @zloc INT, @IsInVehicle INT, @HP FLOAT, @MP FLOAT, @max_HP FLOAT, @max_MP FLOAT, @SP INT, @Exp BIGINT, @Lev INT, @align INT, @PK INT, @duel INT, @pkpardon INT, @ST_underware INT, @ST_right_ear INT, @ST_left_ear INT, @ST_neck INT, @ST_right_finger INT, @ST_left_finger INT, @ST_head INT, @ST_right_hand INT, @ST_left_hand INT, @ST_gloves INT, @ST_chest INT, @ST_legs INT, @ST_feet INT, @ST_back INT, @ST_both_hand INT, @Face_Index INT, @Hair_Shape_Index INT, @Hair_Color_Index INT, @ssq_dawn_round INT, @char_id INT, @subjob0_class INT, @subjob1_class INT, @subjob2_class INT, @subjob3_class INT, @CP FLOAT, @max_CP FLOAT, @ST_hair INT, @wedding INT , @division INT, @pledge_group INT, @AcademyLev INT, @KarmaOrig INT, @PKdiff INT, @ST_face INT, @CursedTimeEquip INT, @TitleColor INT, @WeddingTelTime INT, @ST_HairAll INT, @ST_Agathon INT, @ST_LeftBracelet INT, @ST_RightBracelet INT, @ST_Talisman1 INT, @ST_Talisman2 INT, @ST_Talisman3 INT, @ST_Talisman4 INT, @ST_Talisman5 INT, @ST_Talisman6 INT, @Souls INT ) AS SET NOCOUNT ON UPDATE user_data SET subjob_id = @subjob_id, class= @class, world= @world, xloc= @xloc, yloc= @yloc, zloc= @zloc, IsInVehicle= @IsInVehicle, HP= @HP, MP= @MP, max_HP= @max_HP, max_MP= @max_MP, SP= @SP, Exp= @Exp, Lev= @Lev, align= @align, PK= @PK, duel= @duel, pkpardon= @pkpardon, ST_underware= @ST_underware, ST_right_ear= @ST_right_ear, ST_left_ear= @ST_left_ear, ST_neck= @ST_neck, ST_right_finger= @ST_right_finger, ST_left_finger= @ST_left_finger, ST_head= @ST_head, ST_right_hand= @ST_right_hand, ST_left_hand= @ST_left_hand, ST_gloves= @ST_gloves, ST_chest= @ST_chest, ST_legs= @ST_legs, ST_feet= @ST_feet, ST_back= @ST_back, ST_both_hand= @ST_both_hand, Face_Index= @Face_Index, Hair_Shape_Index= @Hair_Shape_Index, Hair_Color_Index= @Hair_Color_Index , ssq_dawn_round = @ssq_dawn_round, subjob0_class = @subjob0_class, subjob1_class = @subjob1_class, subjob2_class = @subjob2_class, subjob3_class = @subjob3_class, cp = @CP, max_cp = @max_CP, ST_hair = @ST_hair, wedding = @wedding, division = @division, pledge_group = @pledge_group, AcademyLev = @AcademyLev, KarmaOrig = @KarmaOrig, PKdiff = @PKdiff, ST_face = @ST_face, CursedTimeEquip = @CursedTimeEquip, TitleColor = @TitleColor, WeddingTelTime = @WeddingTelTime, ST_left_bracelet = @ST_LeftBracelet, ST_right_bracelet = @ST_RightBracelet, ST_hairall = @ST_HairAll, ST_agathon = @ST_Agathon, souls = @Souls, talisman1 = @ST_Talisman1, talisman2 = @ST_Talisman2, talisman3 = @ST_Talisman3, talisman4 = @ST_Talisman4, talisman5 = @ST_Talisman5, talisman6 = @ST_Talisman6 WHERE char_id= @char_id GO
Server: Msg 207, Level 16, State 1, Procedure lin_SaveCharacter, Line 75 Invalid column name 'wedding'. more a error
Error sql: EXEC lin_SaveCharacter 0,0,0,1,145140,22530,-2136,0,302.017000,104.064000,302.017000,104.064000,10000000,48229,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,161,4,0,0,0,1,0,0,0,1,0,-1,-1,-1,120.806800,120.806800,0,0,0,0,0,0,0,0,0,16777215,0,0,0,0,0,0,0,0,0,0,0,0,0 (0) Error 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function lin_SaveCharacter has too many arguments specified. [.\CUser.cpp][1346] Character save error Нужна помощь/need help