How to edit Quest Reward for Report Job Change to Gildas?

[coldrain90]

As in the Topic title seen i need help in editing the quest reward anyone knows how to?

[Cieldaron]

1.) Open Arcadia -> QuestResource.dbo
2.) Search the Job Change Quest-line.
3.) Edit the values in the table e.g.:

Spoiler:

exp
jp
gold
holicpoint

These are the values for the item you will get automatically:

Spoiler:

default_reward_id (Item-ID)
default_reward_level (Item-Rank?)
default_reward_quantity (Yeah...the item's amount)

And these are the values of the items you may choose between (up to 3 different items):

Spoiler:

optional_reward_id1
optional_reward_level1
optional_reward_quantity1


optional_reward_id2
optional_reward_level2
optional_reward_quantity2


optional_reward_id3
optional_reward_level3
optional_reward_quantity3

And if you want to make quests repeatable infinitely:
Change "repeatable" from 0 to 1.

You may also use this Query:

Spoiler:

[code]
UPDATE [Arcadia].[dbo].[QuestResource]
SET [repeatable] = 1
GO

UPDATE [Arcadia].[dbo].[QuestResource]
SET [repeatable] = 0
WHERE [id] = 1034
GO

UPDATE [Arcadia].[dbo].[QuestResource]
SET [repeatable] = 0
WHERE [id] = 1025
GO
[code]

limit_level means the level you must have reached to start this quest.

limit_job_level means the joblevel you must have to start a quest.

Greez,

Cieldaron

[wisp66]

Originally Posted by Cieldaron

1.) Open Arcadia -> QuestResource.dbo
2.) Search the Job Change Quest-line.
3.) Edit the values in the table e.g.:
[spoiler
exp
jp
gold
holicpoint
[/spoiler]
These are the values for the item you will get automatically:

Spoiler:

default_reward_id (Item-ID)
default_reward_level (Item-Rank?)
default_reward_quantity (Yeah...the item's amount)

And these are the values of the items you may choose between (up to 3 different items):

Spoiler:

optional_reward_id1
optional_reward_level1
optional_reward_quantity1


optional_reward_id2
optional_reward_level2
optional_reward_quantity2


optional_reward_id3
optional_reward_level3
optional_reward_quantity3

And if you want to make quests repeatable infinitely:
Change "repeatable" from 0 to 1.

You may also use this Query:

Spoiler:

[code]
UPDATE [Arcadia].[dbo].[QuestResource]
SET [repeatable] = 1
GO

UPDATE [Arcadia].[dbo].[QuestResource]
SET [repeatable] = 0
WHERE [id] = 1034
GO

UPDATE [Arcadia].[dbo].[QuestResource]
SET [repeatable] = 0
WHERE [id] = 1025
GO
[code]

limit_level means the level you must have reached to start this quest.

limit_job_level means the joblevel you must have to start a quest.

Greez,

Cieldaron

good post
but as u see from it being optional reward 1-3 this is only one reason why for anyone whos pmed me... thats wq isnt 100% added yet i mean there is others but 1 reason alone is the quest line would be limited to 3 rewards it asks for 6.
with current db lay out and gameserv.exe we cant do 6 ... work arounds are avail but spawning of fantics would need to be added and working first be for this is even concidered worth it....we are getting close tho.
jw has most of the quest line npcs finished if not all finished already.
thought id post this so those who pmed me would have a better explained reason why we havent added it or mentioned adding to a repack

[Cieldaron]

Thanks for the info.

I didn't test editing the values except of the "repeatable" 'cause I was in a hurry, just wrote the querys for other ppl to experiment around with them.

I excluded two quests from the "repeatable"-query 'cause I wasn't sure which one was the jobchange-quest.

If the jobchange-quest is repeatable, you won't be able to finish the quest -> get another job than your basic job anymore.

/sorry for my engrish. (:

[wisp66]

Originally Posted by Cieldaron

Thanks for the info.

I didn't test editing the values except of the "repeatable" 'cause I was in a hurry, just wrote the querys for other ppl to experiment around with them.

I excluded two quests from the "repeatable"-query 'cause I wasn't sure which one was the jobchange-quest.

If the jobchange-quest is repeatable, you won't be able to finish the quest -> get another job than your basic job anymore.

/sorry for my engrish. (:

your english was fine and made perfect sense