Quarm Database: Difference between revisions

From EQArchives
Jump to navigationJump to search
 
(6 intermediate revisions by the same user not shown)
Line 102: Line 102:
| 49 || rule_sets
| 49 || rule_sets
|-
|-
| 50 || [[quarmdb:rule_values|rule_values]]
| 50 || respawn_times
|-
|-
| 51 || saylink
| 51 || [[quarmdb:rule_values|rule_values]]
|-
|-
| 52 || skill_caps
| 52 || saylink
|-
|-
| 53 || skill_difficulty
| 53 || skill_caps
|-
|-
| 54 || [[quarmdb:spawn2|spawn2]]
| 54 || skill_difficulty
|-
|-
| 55 || [[quarmdb:spawn_condition_values|spawn_condition_values]]
| 55 || [[quarmdb:spawn2|spawn2]]
|-
|-
| 56 || [[quarmdb:spawn_conditions|spawn_conditions]]
| 56 || [[quarmdb:spawn_condition_values|spawn_condition_values]]
|-
|-
| 57 || [[quarmdb:spawn_events|spawn_events]]
| 57 || [[quarmdb:spawn_conditions|spawn_conditions]]
|-
|-
| 58 || [[quarmdb:spawnentry|spawnentry]]
| 58 || [[quarmdb:spawn_events|spawn_events]]
|-
|-
| 59 || [[quarmdb:spawngroup|spawngroup]]
| 59 || [[quarmdb:spawnentry|spawnentry]]
|-
|-
| 60 || spells_en
| 60 || [[quarmdb:spawngroup|spawngroup]]
|-
|-
| 61 || spells_new
| 61 || spell_globals
|-
|-
| 62 || start_zones
| 62 || spells_en
|-
|-
| 63 || starting_items
| 63 || spells_new
|-
|-
| 64 || titles
| 64 || start_zones
|-
|-
| 65 || tradeskill_recipe
| 65 || starting_items
|-
|-
| 66 || tradeskill_recipe_entries
| 66 || titles
|-
|-
| 67 || traps
| 67 || tradeskill_recipe
|-
|-
| 68 || variables
| 68 || tradeskill_recipe_entries
|-
|-
| 69 || zone
| 69 || traps
|-
|-
| 70 || zone_points
| 70 || variables
|-
|-
| 71 || zone_server
| 71 || zone
|-
|-
| 72 || zone_state_dump
| 72 || zone_points
|-
|-
| 73 || zoneserver_auth
| 73 || zone_server
|-
| 74 || zone_state_dump
|-
| 75 || zoneserver_auth
|}
|}


Line 207: Line 211:
# petitions
# petitions
# player_titlesets
# player_titlesets
# qs_merchant_transaction_log
# qs_player_aa_purchase_log
# qs_player_aa_rate_hourly
# qs_player_coin_move_log
# qs_player_events
# qs_player_fte_events
# qs_player_ground_spawns_log
# qs_player_handin_log
# qs_player_item_delete_log
# qs_player_item_desyncs_log
# qs_player_item_move_log
# qs_player_killed_by_log
# qs_player_loot_records_log
# qs_player_npc_kill_log
# qs_player_qglobal_updates_log
# qs_player_speech
# qs_player_trade_items_log
# qs_player_trade_log
# qs_player_ts_event_log
# qs_trader_audit
# quake_data
# quest_globals
# raid_details
# raid_members
# reports
# trader
# webdata_character
# webdata_servers

Latest revision as of 12:59, 20 December 2023

Content Data

# Tables_in_quarmdb
1 aa_actions
2 aa_effects
3 altadv_vars
4 base_data
5 blocked_spells
6 books
7 char_create_combinations
8 char_create_point_allocations
9 command_settings
10 damageshieldtypes
11 doors
12 eqtime
13 faction_list
14 faction_list_mod
15 fishing
16 forage
17 goallists
18 graveyard
19 grid
20 grid_entries
21 ground_spawns
22 horses
23 item_tick
24 items
25 keyring_data
26 launcher
27 launcher_zones
28 level_exp_mods
29 logsys_categories
30 lootdrop
31 lootdrop_entries
32 loottable
33 loottable_entries
34 merchantlist
35 npc_emotes
36 npc_faction
37 npc_faction_entries
38 npc_spells
39 npc_spells_effects
40 npc_spells_effects_entries
41 npc_spells_entries
42 npc_types
43 npc_types_metadata
44 npc_types_tint
45 object
46 pets
47 proximities
48 races
49 rule_sets
50 respawn_times
51 rule_values
52 saylink
53 skill_caps
54 skill_difficulty
55 spawn2
56 spawn_condition_values
57 spawn_conditions
58 spawn_events
59 spawnentry
60 spawngroup
61 spell_globals
62 spells_en
63 spells_new
64 start_zones
65 starting_items
66 titles
67 tradeskill_recipe
68 tradeskill_recipe_entries
69 traps
70 variables
71 zone
72 zone_points
73 zone_server
74 zone_state_dump
75 zoneserver_auth

Player Data

  1. account
  2. account_flags
  3. account_ip
  4. account_name_reservation
  5. account_rewards
  6. banned_ips
  7. character_alternate_abilities
  8. character_bind
  9. character_buffs
  10. character_consent
  11. character_corpse_items
  12. character_corpse_items_backup
  13. character_corpses
  14. character_corpses_backup
  15. character_currency
  16. character_data
  17. character_faction_values
  18. character_inspection_messages
  19. character_inventory
  20. character_keyring
  21. character_languages
  22. character_legacy_items
  23. character_lookup
  24. character_memmed_spells
  25. character_pet_buffs
  26. character_pet_info
  27. character_pet_inventory
  28. character_skills
  29. character_soulmarks
  30. character_spells
  31. character_timers
  32. character_zone_flags
  33. client_version
  34. friends

Server Data

The tables in this section are largely server-specific and aren't content that would normally be replicated/reused on other server instances.

  1. bugs
  2. chatchannels
  3. commands_log
  4. discovered_items
  5. eventlog
  6. gm_ips
  7. group_id
  8. group_leaders
  9. guild_members
  10. guild_ranks
  11. guilds
  12. hackers
  13. mail
  14. merchantlist_temp
  15. name_filter
  16. object_contents
  17. petitions
  18. player_titlesets
  19. qs_merchant_transaction_log
  20. qs_player_aa_purchase_log
  21. qs_player_aa_rate_hourly
  22. qs_player_coin_move_log
  23. qs_player_events
  24. qs_player_fte_events
  25. qs_player_ground_spawns_log
  26. qs_player_handin_log
  27. qs_player_item_delete_log
  28. qs_player_item_desyncs_log
  29. qs_player_item_move_log
  30. qs_player_killed_by_log
  31. qs_player_loot_records_log
  32. qs_player_npc_kill_log
  33. qs_player_qglobal_updates_log
  34. qs_player_speech
  35. qs_player_trade_items_log
  36. qs_player_trade_log
  37. qs_player_ts_event_log
  38. qs_trader_audit
  39. quake_data
  40. quest_globals
  41. raid_details
  42. raid_members
  43. reports
  44. trader
  45. webdata_character
  46. webdata_servers