Error when tp and F1 1-4 slot

[hellspawn80]

hi, im testing clean db vsro1.188 for the moment and i have error with F1 1-4 slot for all new char. i know i can fix it by query for the char already exist but not for new char .. maybe someone know storedprocedure to fix it ?

and i saw that error appear in my SR_GameServer when i Teleport , my F1 slot 1-4 reset .. maybe its the same prob ?

msg is not completely used : IP:192.168.0.10 NoDir:0x0122 (0x0000) (MsgType:3), 14 - 5

thanks all

[MentaL]

[wien27]

hi, im testing clean db vsro1.188 for the moment and i have error with F1 1-4 slot for all new char. i know i can fix it by query for the char already exist but not for new char .. maybe someone know storedprocedure to fix it ?

and i saw that error appear in my SR_GameServer when i Teleport , my F1 slot 1-4 reset .. maybe its the same prob ?

msg is not completely used : IP:192.168.0.10 NoDir:0x0122 (0x0000) (MsgType:3), 14 - 5

thanks all

We are entering the first shard the database , programability -> _ call addnewchard Modify the table, and I called the code provided below :
(Sro_Vt_Shard -> Programability -> _AddNewChar - Modify)

-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)

English: The above code below and paste this code

UPDATE _CharQuest set Status = 5 , QuestData1 = 77594711 where CharID = @NewCharID and QuestID = 1
UPDATE _CharQuest set Status = 5 where CharID = @NewCharID and QuestID = 2

We are entering the first shard the database , programability -> _ call addnewchard Modify the table, and I called the code provided below :

[hellspawn80]

We are entering the first shard the database , programability -> _ call addnewchard Modify the table, and I called the code provided below :
(Sro_Vt_Shard -> Programability -> _AddNewChar - Modify)


English: The above code below and paste this code

We are entering the first shard the database , programability -> _ call addnewchard Modify the table, and I called the code provided below :

Hi, if i understand you .. i have to add this

UPDATE _CharQuest set Status = 5 , QuestData1 = 77594711 where CharID = @NewCharID and QuestID = 1
UPDATE _CharQuest set Status = 5 where CharID = @NewCharID and QuestID = 2

just after that

-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)

in my _addNewChar procedure .. like that?

-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
UPDATE _CharQuest set Status = 5 , QuestData1 = 77594711 where CharID = @NewCharID and QuestID = 1
UPDATE _CharQuest set Status = 5 where CharID = @NewCharID and QuestID = 2

[hellspawn80]

anyone ?

[RenePunik]

anyone ?

It must be like that:

----------------------------------------------------------------------------- 
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
----------------------------------------------------------------------------- 
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2) 
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0 
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
UPDATE _CharQuest set Status = 5 , QuestData1 = 77594711 where CharID = @NewCharID and QuestID = 1
UPDATE _CharQuest set Status = 5 where CharID = @NewCharID and QuestID = 2
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION 
RETURN -17 
END

[hellspawn80]

thx ! testing ! :)