DAoC DB – Import Test Results #1
Hi guys I am going to let you guys in on how I am preparing the mass data importing for DAoC DB.
Human Readable Data
First I gather the data, and after some basic parsing I end up with a human readable file.
PHP Parser
Next I run this through my own custom parser in php
SQL Checking
Finally, I run this script and look at the output SQL to see if it is what I am expecting
For this test I am handling update information from the following types:
- Quest Update – to set quest level
- NPC Create – to associate npc names to starting and finishing quests
- Show Dialog – to create quests, steps, related, rewards.
- Custom Text Window - to support delves from items to get the magical bonuses
- Merchant Window – to create basic item information, and sell price
- Object Interact Request – to associate a merchant window to a merchant
After loading up the entire tutorial zone data I compare what I expect to what I received.
Quest Offer with XP reward
The quest offer window has a ton of information.
- To start with a query to remove any existing quests that match an ID is run. [GOOD]
- A quest entry is made with the following information:
- ID – [GOOD]
- Name – [GOOD]
- Summary – [GOOD]
- Offer Text – [GOOD]
- OptionalRewardsChoiceMax – [GOOD]
- RewardLevel – [GOOD]
- Gold – [GOOD]
- Exp -value is 80, this can be interpreted as 80% of the xp needed to reach level 2
- ZoneID – not set [BAD]
- Type [GOOD]
- StartNPC [GOOD]
Notes:
- I have not removed the player name from this window.
- In the quest creation, where it deletes the quest, I should really be running a cleanup of quest rewards, steps and related rows.
- Zone ID is not set
Quest Update
This quest update is the only place I can find where it sets a quest level.
- A query is run to update a quests level [GOOD]
Notes:
- This query is run multiple times, and should only apply once, will need to store and prevent this.
- Perhaps capture the dots on the map and draw them onto the zone minimap
Quest Finish with XP Reward
The quest finish window has a bunch more information.
- FinishText [GOOD]
- FinishNPC [GOOD]
- Quest Steps [GOOD]
- Quest Related [OKAY] – this picks up anything that is capitalised, and in this case returns a npc name and “Quest Icons”, we can’t be picky though.
Quest Offer with Item Rewards
Here we create the basic information for the items, as well as make sure the rewards choice max is set.
- OptionalRewardsChoiceMax – [GOOD]
- Item
- Check if item exists
- Create item
- Level [GOOD]
- DPS_AF [GOOD]
- SPD_ABS [GOOD]
- Hand [GOOD]
- DamageType [GOOD]
- Type [GOOD]
- Weight [GOOD]
- Condition [GOOD]
- Durability [GOOD]
- Quality [GOOD]
- Bonus [GOOD]
- Model [GOOD]
- Color [GOOD]
- Effect [GOOD]
- Flag [GOOD]
- Extension [GOOD]
- Name [GOOD]
- ChargeID [GOOD}
Notes:
- I'm going to have to manually tweak this, as the name given in the quest reward window does not match the name given in the delve window.
- Monetary reward is also a percentage of a certain level, need to figure this out.
Merchant Window
Should capture the basic information
- Check if item exists
- Create item
- All values are good, apart from Condition, Durability, Quality and Bonus.
Notes:
- Where are the con,dur,qual and bonus from merchant window?
Item Delve
Should capture the magical bonuses
- Check if item exists
- Extra delve
- CanTrade [GOOD]
- CanSell [GOOD]
- CanDrop [GOOD]
- BonusLevel [GOOD]
- LevelRequirement [GOOD]
- ReuseTimer [GOOD]
- Charges [GOOD}
- Item bonuses
- Check if bonus type exists [GOOD]
- Create bonus type [GOOD]
- Create bonus entry with bonus type and amount [GOOD]
List of Tasks
- Incorrect value in the Exp field for Quest. (need to map this out)
- Incorrect value for Money reward for Quest (need to map this out)
- I have not removed the player name from the quest dialog.
- In the quest creation, where it deletes the quest, I should really be running a cleanup of quest rewards, steps and related rows.
- Zone ID is not set for a quest
- Quest update query is run multiple times, and should only apply once, will need to store and prevent this.
- Perhaps capture the dots on the map and draw them onto the zone minimap
- Where are the con,dur,qual and bonus from merchant window?
- Albion tutorial item name does not match delve window. I’m going to have to manually tweak this.
