How to disable 1~60 quests that gives free exp scrolls & sox

[devdash]

How to disable 1~60 quests that gives free exp scrolls & sox



thanks in advance.

[ZαKuRα]

dbo._RefQuest
dbo._RefQuestReward

QEV_ALL_BASIC_3

/**/
USE SRO_VT_SHARD
Declare @ToDelete varchar(74)
SET @ToDelete = 'QEV_ALL_BASIC_10'

Declare @newCount int
SET @newCount = (SELECT COUNT(QuestCodeName) FROM _RefQuestRewardItems WHERE QuestCodeName like @ToDelete)
Declare @Zero int
SET @Zero = 0
WHILE (@Zero < @newCount-1)
BEGIN
DELETE TOP (1) FROM _RefQuestRewardItems WHERE QuestCodeName like @ToDelete
SET @Zero = @Zero+1
END
/**/

[#HB]

You can just disable them through _RefQuest, no need to disable anything else since it controls the branches.

[devdash]

thanks i really appreciate your answers, i will try both methods now, and i will write back the result

[concucu]

set service = 0 chardefaultquest

[devdash]

Originally Posted by concucu

set service = 0 chardefaultquest

i will try that too

thanks to all i think i will follow concucu method, looks perfect, tell me if iam wrong please

but here is two quests i dont understand what are they...



i noticed after using concucu method, that the message warn pop up still with the qeuests on it


as u see i dont have the quests, and i can't get it from the NPC, and it still pop up in aram-quest-window

now iam going to try the other methods..

solved throw do all the method as one
thanks to all the answers, and actually if anyone want to do this too, do all the methods

ZαKuRα & #HB & concucu
Special thanks <3

close topic please...

[#HB]

_CharDefault_Quest is the list of quests that a character starts with after creating his character. So, it's not related to what you're asking for.

[devdash]

Originally Posted by #HB

_CharDefault_Quest is the list of quests that a character starts with after creating his character. So, it's not related to what you're asking for.

yes that's right, and since u can't take it from anywhere else "I guess" so its just like disabled it,
but i did all the methods just to make sure i get ride of it for-ever
thanks bro for the explain..