[help] reset/reborn

[4pLay]

need some itsy bitsy help regarding reset/reborn?

and i also knew about this link but got some problem on executing the query.

http://forum.ragezone.com/f459/reset-system-2-a-457889/

 

[Myster Dev]

need some itsy bitsy help regarding reset/reborn?

and i also knew about this link but got some problem on executing the query.

http://forum.ragezone.com/f459/reset-system-2-a-457889/

Do as what error says

 

[4pLay]

Do as what error says

bro! can you guide me thru? still encountering some error.

im desperate now! pls! pls! guide me?!... im being such a cry baby here..

thanks you! god bless!

 

[Myster Dev]

bro! can you guide me thru? still encountering some error.

im desperate now! pls! pls! guide me?!... im being such a cry baby here..

thanks you! god bless!

charIDX (int), channel and etc...

 

[4pLay]

charIDX (int), channel and etc...

you mean to say that i need to add this columns?

Spoiler

-- CHARACTER
DECLARE logout_time datetime, LogiN_time datetime, oldRestTime AS int, restTime AS int
DECLARE
@CH_WORLDIDX INT,
@CH_POSITION INT,
@CH_LEV INT,
@CH_EXP BIGINT,
@CH_STR INT,
@CH_DEX INT,
@CH_INT INT,
@CH_PNT INT,
@CH_RANK INT,
@CH_ALZ BIGINT,
--@CH_ALZ_XORED BIGINT,
@CH_STYLE INT,
@CH_FLAGS INT,
@CH_HP INT,
@CH_MP INT,
@CH_SP INT,
@CH_SWDPNT INT,
@CH_MAGPNT INT,
@CH_RANKEXP INT,
@CH_PENALTYEXP INT,
@CH_WARPBFIELD INT,
@CH_MAPSBFIELD INT,
@CH_NAME VARCHAR(50),
@CH_RP INT,
@CH_REPUTATION INT,
@CH_PKPENALTY INT,
@CH_NATION TINYINT,
@CRAFTLEVEL0 INT,
@CRAFTLEVEL1 INT,
@CRAFTLEVEL2 INT,
@CRAFTLEVEL3 INT,
@CRAFTLEVEL4 INT,
CraftexP0 INT,
CraftexP1 INT,
CraftexP2 INT,
CraftexP3 INT,
CraftexP4 INT,
@CRAFTFLAGS VARBINARY(16),
Reserved1 BIGINT

 

[kalandralover]

How did you solve this? I have the same error but haven't been able to fix it yet.