Quarm Database: Difference between revisions

From EQArchives
Jump to navigationJump to search
No edit summary
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Content Data ==
{|class="wikitable"
{|class="wikitable"
|-
|-
! Tables_in_quarmdb             
! # !! Tables_in_quarmdb             
|-
|-
| aa_actions
| 1 || aa_actions
|-
|-
| aa_effects
| 2 || aa_effects
|-
|-
| altadv_vars
| 3 || altadv_vars
|-
|-
| base_data
| 4 || base_data
|-
|-
| blocked_spells
| 5 || blocked_spells
|-
|-
| books
| 6 || books
|-
|-
| char_create_combinations
| 7 || char_create_combinations
|-
|-
| char_create_point_allocations
| 8 || char_create_point_allocations
|-
|-
| command_settings
| 9 || command_settings
|-
|-
| damageshieldtypes
| 10 || damageshieldtypes
|-
|-
| doors
| 11 || doors
|-
|-
| eqtime
| 12 || eqtime
|-
|-
| faction_list
| 13 || faction_list
|-
|-
| faction_list_mod
| 14 || faction_list_mod
|-
|-
| fishing
| 15 || fishing
|-
|-
| forage
| 16 || forage
|-
|-
| goallists
| 17 || goallists
|-
|-
| graveyard
| 18 || graveyard
|-
|-
| grid
| 19 || grid
|-
|-
| grid_entries
| 20 || grid_entries
|-
|-
| ground_spawns
| 21 || ground_spawns
|-
|-
| horses
| 22 || horses
|-
|-
| item_tick
| 23 || item_tick
|-
|-
| items
| 24 || items
|-
|-
| keyring_data
| 25 || keyring_data
|-
|-
| launcher
| 26 || launcher
|-
|-
| launcher_zones
| 27 || launcher_zones
|-
|-
| level_exp_mods
| 28 || level_exp_mods
|-
|-
| logsys_categories
| 29 || logsys_categories
|-
|-
| lootdrop
| 30 || lootdrop
|-
|-
| lootdrop_entries
| 31 || lootdrop_entries
|-
|-
| loottable
| 32 || loottable
|-
|-
| loottable_entries
| 33 || loottable_entries
|-
|-
| merchantlist
| 34 || merchantlist
|-
|-
| npc_emotes
| 35 || npc_emotes
|-
|-
| npc_faction
| 36 || npc_faction
|-
|-
| npc_faction_entries
| 37 || npc_faction_entries
|-
|-
| npc_spells
| 38 || npc_spells
|-
|-
| npc_spells_effects
| 39 || npc_spells_effects
|-
|-
| npc_spells_effects_entries
| 40 || npc_spells_effects_entries
|-
|-
| npc_spells_entries
| 41 || npc_spells_entries
|-
|-
| npc_types
| 42 || npc_types
|-
|-
| npc_types_metadata
| 43 || npc_types_metadata
|-
|-
| npc_types_tint
| 44 || npc_types_tint
|-
|-
| object
| 45 || object
|-
|-
| peq_admin
| 46 || pets
|-
|-
| pets
| 47 || proximities
|-
|-
| proximities
| 48 || races
|-
|-
| races
| 49 || rule_sets
|-
|-
| rule_sets
| 50 || respawn_times
|-
|-
| rule_values
| 51 || [[quarmdb:rule_values|rule_values]]
|-
|-
| saylink
| 52 || saylink
|-
|-
| skill_caps
| 53 || skill_caps
|-
|-
| skill_difficulty
| 54 || skill_difficulty
|-
|-
| spawn2
| 55 || [[quarmdb:spawn2|spawn2]]
|-
|-
| [[quarmdb:spawn_condition_values|spawn_condition_values]]
| 56 || [[quarmdb:spawn_condition_values|spawn_condition_values]]
|-
|-
| [[quarmdb:spawn_conditions|spawn_conditions]]
| 57 || [[quarmdb:spawn_conditions|spawn_conditions]]
|-
|-
| [[quarmdb:spawn_events|spawn_events]]
| 58 || [[quarmdb:spawn_events|spawn_events]]
|-
|-
| [[quarmdb:spawnentry|spawnentry]]
| 59 || [[quarmdb:spawnentry|spawnentry]]
|-
|-
| [[quarmdb:spawngroup|spawngroup]]
| 60 || [[quarmdb:spawngroup|spawngroup]]
|-
|-
| spells_en
| 61 || spell_globals
|-
|-
| spells_new
| 62 || spells_en
|-
|-
| start_zones
| 63 || spells_new
|-
|-
| starting_items
| 64 || start_zones
|-
|-
| titles
| 65 || starting_items
|-
|-
| tradeskill_recipe
| 66 || titles
|-
|-
| tradeskill_recipe_entries
| 67 || tradeskill_recipe
|-
|-
| traps
| 68 || tradeskill_recipe_entries
|-
|-
| variables
| 69 || traps
|-
|-
| zone
| 70 || variables
|-
|-
| zone_points
| 71 || zone
|-
|-
| zone_server
| 72 || zone_points
|-
|-
| zone_state_dump
| 73 || zone_server
|-
|-
| zoneserver_auth
| 74 || zone_state_dump
|-
| 75 || zoneserver_auth
|}
|}
== Player Data ==
# account
# account_flags
# account_ip
# account_name_reservation
# account_rewards
# banned_ips
# character_alternate_abilities
# character_bind
# character_buffs
# character_consent
# character_corpse_items
# character_corpse_items_backup
# character_corpses
# character_corpses_backup
# character_currency
# character_data
# character_faction_values
# character_inspection_messages
# character_inventory
# character_keyring
# character_languages
# character_legacy_items
# character_lookup
# character_memmed_spells
# character_pet_buffs
# character_pet_info
# character_pet_inventory
# character_skills
# character_soulmarks
# character_spells
# character_timers
# character_zone_flags
# client_version
# 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.
# bugs
# chatchannels
# commands_log
# discovered_items
# eventlog
# gm_ips
# group_id
# group_leaders
# guild_members
# guild_ranks
# guilds
# hackers
# mail
# merchantlist_temp
# name_filter
# object_contents
# petitions
# 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