How can I change from MySQL "Quest instant complate" (4.3.4 )

yilank

Silver Supporter
Veteran Member
42
2016
2
Location
London
Hi guys.

I would like to change some quests ending instant complate.

Example ; Bloodsail`s End >>>>> I have to kill 1 Npc but when I killed nothing happened. Then, I would like to change this quest ; When I take first time this quest I would like to make instant complate and back !?

Please someone can explain which Column in MySQL for change Quest Complate ?

Thx. Kind Regards.
 

IceNet

Gold Supporter
Veteran Member
116
2015
5
UPDATE `quest_template` SET `RequiredNpcOrGo1`='43794', `RequiredNpcOrGoCount1`='1' WHERE (`Id`='26703');

Run this, restart worldserver, delete cache, abandon quest and take again

Not tested.
 

yilank

Silver Supporter
Veteran Member
42
2016
2
Location
London
I already check MySQL , it is already like that columns. I mean I am already owner, but if I want to play like player, I would like to take and instant quest Currenty.( for every player ).

I Print Screen to MySQL and you can see already have this coment ( red circles )

View attachment MySQL_Columns.jpg

I am Grateful. Thanks a lot for answer.

Regards.
 

IceNet

Gold Supporter
Veteran Member
116
2015
5
Than delete the RequiredNpcOrGo1 & RequiredNpcOrGoCount1 (set to 0)

And restart/delete/etc again
 

yilank

Silver Supporter
Veteran Member
42
2016
2
Location
London
Yes yes yes :D :cool:
Finally i did.
Thx a lot IceNet, appreciate for that. I learn new thing...
I am gratefull to you. ( I am exciting now :D)

( I think when I want to instant complate, should I setuo -0- required columns ?)

Thx a lotttttttt again.

Regards...
 
Last edited:
Top