Originally Posted by
Caosfox
ok, if nothing of this post help you (like me, followed every thing and still underbar is screwed). try this (works on vsro DB released by chernobyl)
* FIRST... MAKE BACKUP OF SHARD DB *
1) enable chinese beginer quest (if you have it disabled)
2) edit procedure _AddNewChar (at shard db)
3) look for this :
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)
* this creates the default beginer quest, and edit the damn underbar*
4) right under that insert.. blah blah blah.. put 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
so looks like this :
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
5) save and create a new char.
notes:
first update command disable the "put lame commands and bug underbar" instruction (quest number 1 *eventquest* to 5 *5 = quest done*)
second update, simply marks "chinese beginer quest" as done, and is delete from quest list (quest number 2 *chinese beginer quest* to 5 *quest done*)
tested with chinese and euro chars, and is working (on chernobyl DB, no idea on the others dbs)