Clean Bar

[RenePunik]

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.

[MentaL]

[Witchy Moo]

It's related to default quest.

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

    -----------------------------------------------------------------------------
    -- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
    -----------------------------------------------------------------------------
    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:

-- 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

[RenePunik]

It's related to default quest.

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

    -----------------------------------------------------------------------------
    -- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
    -----------------------------------------------------------------------------
    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:

-- 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 :)

[Witchy Moo]

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

[RenePunik]

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

Okay, It worked now :)