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.

daocdb_19

 

PHP Parser

Next I run this through my own custom parser in php

daocdb_20

 

SQL Checking

Finally, I run this script and look at the output SQL to see if it is what I am expecting

daocdb_18

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.
About these ads