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 || | | 50 || respawn_times | ||
|- | |- | ||
| 51 || | | 51 || [[quarmdb:rule_values|rule_values]] | ||
|- | |- | ||
| 52 || | | 52 || saylink | ||
|- | |- | ||
| 53 || | | 53 || skill_caps | ||
|- | |- | ||
| 54 || | | 54 || skill_difficulty | ||
|- | |- | ||
| 55 || [[quarmdb: | | 55 || [[quarmdb:spawn2|spawn2]] | ||
|- | |- | ||
| 56 || [[quarmdb: | | 56 || [[quarmdb:spawn_condition_values|spawn_condition_values]] | ||
|- | |- | ||
| 57 || [[quarmdb: | | 57 || [[quarmdb:spawn_conditions|spawn_conditions]] | ||
|- | |- | ||
| 58 || [[quarmdb: | | 58 || [[quarmdb:spawn_events|spawn_events]] | ||
|- | |- | ||
| 59 || [[quarmdb: | | 59 || [[quarmdb:spawnentry|spawnentry]] | ||
|- | |- | ||
| 60 || | | 60 || [[quarmdb:spawngroup|spawngroup]] | ||
|- | |- | ||
| 61 || | | 61 || spell_globals | ||
|- | |- | ||
| 62 || | | 62 || spells_en | ||
|- | |- | ||
| 63 || | | 63 || spells_new | ||
|- | |- | ||
| 64 || | | 64 || start_zones | ||
|- | |- | ||
| 65 || | | 65 || starting_items | ||
|- | |- | ||
| 66 || | | 66 || titles | ||
|- | |- | ||
| 67 || | | 67 || tradeskill_recipe | ||
|- | |- | ||
| 68 || | | 68 || tradeskill_recipe_entries | ||
|- | |- | ||
| 69 || | | 69 || traps | ||
|- | |- | ||
| 70 || | | 70 || variables | ||
|- | |- | ||
| 71 || | | 71 || zone | ||
|- | |- | ||
| 72 || | | 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
- 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
- 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