Printable View
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
Quote:
Originally Posted by 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)
Quote:
-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
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
Quote:
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 thisQuote:
Originally Posted by wien27
just after thatQuote:
UPDATE _CharQuest set Status = 5 , QuestData1 = 77594711 where CharID = @NewCharID and QuestID = 1
UPDATE _CharQuest set Status = 5 where CharID = @NewCharID and QuestID = 2
in my _addNewChar procedure .. like that?Quote:
-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
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)
Quote:
-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
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
anyone ?
It must be like that:Quote:
Originally Posted by hellspawn80
Code:-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
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
thx ! testing ! :)