Clean Bar

Hello community, I have a little problem but i was have the solution for it, but unfortunately i have forgotten it.

Anyway the problem is: I want to make the new characters appearing with clean bar.

https://forum.ragezone.com/cache.php...om%2FZe8ue.jpg

It's related to default quest.

Open your SHARD's [_AddNewChar] SP, find these lines:

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)

---

After that line, add this:

Code:

---

-- Fix F1 1-4 bug
UPDATE _CharQuest SET [Status] = '5', StartTime = '2013-10-31 00:00:00', EndTime = '2013-10-31 00:00:00', QuestData1 = 31458135, QuestData2 = 0 WHERE (CharID = @NewCharID AND QuestID IN (1,2))

---

execute the SP, create a char, see if it's gone :)

good luck

Quote:

---

Originally Posted by Witchy Moo

It's related to default quest.

Open your SHARD's [_AddNewChar] SP, find these lines:

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)

---

After that line, add this:

Code:

---

-- Fix F1 1-4 bug
UPDATE _CharQuest SET [Status] = '5', StartTime = '2013-10-31 00:00:00', EndTime = '2013-10-31 00:00:00', QuestData1 = 31458135, QuestData2 = 0 WHERE (CharID = @NewCharID AND QuestID IN (1,2))

---

execute the SP, create a char, see if it's gone :)

good luck

---

It's gone now, but it won't effect anything else?
btw, thanks :)

it won't :), it just marks that quest id 1 and 2 are finished.

Quote:

---

Originally Posted by Witchy Moo

it won't :), it just marks that quest id 1 and 2 are finished.

---

Okay, It worked now :)