zaela-Server/utils/sql/git/required
2017-07-24 14:35:22 -04:00
..
.gitignore utils/sql/git added 2013-02-16 18:05:41 -08:00
2013_02_18_Merc_Rules_and_Tables.sql Moved merc save data from extended player profile to new merc table, save merc buffs, added cure and rez spells to healer merc. 2013-02-18 00:50:19 -05:00
2013_02_25_Impr_HT_LT.sql SK AA Touch of the Wicked should reduce reuse timers for Improved Harm Touch & Leech Touch as well as regular HT. Add to aa_actions with same redux rate as regular HT 2013-02-26 09:48:36 -05:00
2013_03_1_Merc_Rules_and_Equipment.sql Oops, it's not a leap year. 2013-03-01 00:34:25 -05:00
2013_03_23_Escape_FadingMemories.sql Fixed SQL 2013-03-24 08:36:53 -04:00
2013_04_04_NaturesBounty.sql Attempting manual merge for Nature's Bounty 2013-04-06 08:23:09 -04:00
2013_04_08_Salvage.sql Implemented Salvage AA. 2013-04-08 22:33:19 -04:00
2013_05_05_Account_Flags.sql Various customizations from DungeonCrawl 2013-05-05 18:20:22 -05:00
2013_05_05_Item_Tick.sql Various customizations from DungeonCrawl 2013-05-05 18:20:22 -05:00
2013_07_11_NPC_Special_Abilities.sql SQL Source update fixes for newer DB versions 2014-11-16 18:32:13 -06:00
2013_10_12_Merc_Special_Abilities.sql SQL Source update fixes for newer DB versions 2014-11-16 18:32:13 -06:00
2013_10_12_Merc_vwMercNpcTypes.sql Changed dates due to time of commit. 2013-10-12 00:52:02 -04:00
2013_10_31_Recipe_disabling.sql Add the ability to disable a tradeskill recipe 2013-10-31 17:58:44 +01:00
2013_11_07_BaseData.sql Prerelease commit 2013-11-06 13:48:35 -08:00
2013_11_13_Instrument_Singing_Mastery.sql Change INSERT to REPLACE 2013-11-13 21:59:38 -05:00
2013_11_18_AssistRadius.sql Added npc_types.assistradius, defaults to npc_types.aggroradius if set to 0 2013-11-18 12:44:39 -05:00
2013_12_26_MerchantList_Class_Required.sql Added support for merchant item filtering by class 2013-12-26 16:29:09 -05:00
2014_01_04_SongModCapAAs.sql Implemented SE_SongModCap 2014-01-04 19:20:59 -05:00
2014_01_08_SpellsNewAdditions.sql Added required SQL for previous changes 2014-01-08 14:06:39 -05:00
2014_01_09_PreservePetSize.sql Add pet size preservation like live 2014-01-09 14:25:29 -05:00
2014_01_20_MezMastery.sql Move Mez Mastery to DB 2014-01-20 16:24:17 -05:00
2014_01_20_Not_Extendable.sql Fix name of SQL file 2014-01-20 13:55:52 -05:00
2014_01_20_SpellCastingReinforcement.sql Move Spell Casting Reinforcement to aa_effects 2014-01-20 15:57:44 -05:00
2014_01_20_Weather.sql Live-Like weather. Big thanks to Robregen for figuring out the system! 2014-01-20 10:10:39 -08:00
2014_01_27_CritcalMendAA.sql Fix aaid for new req SQL 2014-01-27 20:55:11 -05:00
2014_02_02_SpellCriticalsAA.sql Fix for SQL 2014-03-02 17:36:18 -05:00
2014_02_13_Rename_instance_lockout_tables.sql Remove db name from sql. 2014-02-13 21:14:05 -05:00
2014_02_13_spells_new_update.sql fix for LimitCombatSkills 2014-02-15 22:34:48 -05:00
2014_02_20_buff_update.sql not_reflectable -> reflectable 2014-02-22 02:23:37 -05:00
2014_02_26_roambox_update.sql Better flee runspeed calculation. 2014-02-26 18:06:16 -08:00
2014_02_26_virulentvenomAA.sql Corrected 2014_02_26_virulentvenomAA.sql 2014-02-26 18:20:16 -08:00
2014_04_04_PhysicalResist.sql Renamed errant sql file. 2014-04-05 16:07:13 -07:00
2014_04_10_No_Target_With_Hotkey.sql Revert accident in 089360a3a5. Looks like it was meant for 7-10 instead of 4-10. 2014-08-22 22:28:40 -04:00
2014_04_12_SlowMitigation.sql Fix for npc_types table error setting SlowMitigation to null by default. 2014-05-04 01:02:04 -04:00
2014_04_18_Suppress_Command_Error.sql Added #command error message suppression for those who don't want to see 'Command is not recognized' constantly 2014-04-18 19:37:26 -05:00
2014_04_25_spawn_events.sql Fixed a zone crash in spawn_conditions. 2014-04-25 12:40:25 -07:00
2014_04_27_AISpellEffects.sql fix sql 2014-04-28 17:18:23 -04:00
2014_05_04_SlowMitigationFix.sql SQL file rename (added '0') 2014-05-05 21:18:08 -04:00
2014_06_25_AA_Updates.sql Minor typos. 2014-07-09 19:19:51 -04:00
2014_07_04_AA_Updates.sql Updated SE_Sanctuary - Adjust way hate lowering effect worked to be more accurate 2014-07-04 23:35:15 -04:00
2014_07_10_npc_spells.sql Update to how bonuses are calculated in chance to hit code to be 2014-07-23 21:24:21 -04:00
2014_08_02_spells_new.sql SQL 2014-08-02 10:43:48 -04:00
2014_08_12_NPC_raid_targets.sql Some people were having issues with the other one [skip ci] 2014-08-13 13:20:10 -04:00
2014_08_18_spells_new_update.sql Renames spells_new fields. 2014-08-18 20:58:31 -04:00
2014_08_20_merchantlist_probability.sql Adds new column to 'merchantlist' table. 2014-08-21 04:05:45 -04:00
2014_08_23_Complete_QueryServ_Table_Structures.sql Fixed non-conforming sql files. 2014-09-01 15:48:22 -07:00
2014_08_23_player_events_and_player_aa_rate_hourly.sql Fixed non-conforming sql files. 2014-09-01 15:48:22 -07:00
2014_08_24_character_lookup.sql Created character_lookup table for applications that mirrors all character_ table fields minus blob fields for application lookups 2014-08-24 08:52:14 -05:00
2014_09_09_attack_delay.sql Change NPCs to have their attack delay set in DB 2014-09-09 22:42:54 -04:00
2014_09_18_tellqueuesclean.sql Implement tell queues 2014-09-18 22:55:06 -04:00
2014_09_20_ban_messages.sql db_update.pl update 2014-11-16 18:17:04 -06:00
2014_10_11_RaidMOTD.sql Implement Raid MOTD for UF 2014-10-11 01:14:11 -04:00
2014_10_13_RaidLeadership.sql Partial implementation of leadership in raids 2014-10-13 21:36:59 -04:00
2014_10_18_group_mentor.sql Implement group mentor, leadership exp sharing (SoF+ only) 2014-10-18 00:17:46 -04:00
2014_10_19_raid_group_mentor.sql Implement group mentoring while in raids (SoF+ only) 2014-10-19 17:20:07 -04:00
2014_10_30_special_abilities_null.sql Fixed SQL to be current date, also it will no longer rely on a field that we removed from the db [skip ci] 2014-10-30 19:38:13 -07:00
2014_11_08_RaidMembers.sql Missed the actual sql 2014-11-08 15:22:54 -08:00
2014_11_13_spells_new_updates.sql fix 2014-11-14 00:34:17 -05:00
2014_11_26_InventoryTableUpdate.sql Minor bug fixes 2014-11-26 18:29:07 -05:00
2014_12_01_mercs_table_update.sql Mercenaries now spawn as the same Gender and Size of the Merchant they are purchased from. 2014-12-01 19:54:01 -06:00
2014_12_09_items_table_update.sql (RoF+) Implemented Hero's Forge Armor Models for Items. To use, set herosforgemodel field in the item table to a model number such as 63 (for example). 2014-12-09 21:18:56 -06:00
2014_12_13_inventory_table_update.sql Added required SQL. Without it, there will be item loss using the last commit! 2014-12-13 14:01:12 -06:00
2014_12_15_multiple_table_updates.sql (RoF+) Implemented the 6th Augment Slot for Items. 2014-12-15 17:55:23 -06:00
2014_12_24_npc_types_table_update.sql (RoF+) Added herosforgemodel field to the npc_types table. Not fully functional yet for NPCs (currently only displays helm correctly). 2014-12-24 02:31:37 -06:00
2014_12_24_npc_types_update.sql Update npc_types table. 2014-12-24 01:26:07 -05:00
2014_12_26_merc_weaponinfo_table_update.sql Fixed Mercenaries so they can spawn again after table field renames from recent change. 2014-12-26 00:11:51 -06:00
2014_12_31_npc_types_default_values_update.sql Fix issue with an old SQL update and newer database engines [skip ci] 2015-10-02 19:35:02 -05:00
2015_01_15_logsys_categories_table.sql Update database table to the real defaults that it was intended to have 2015-01-24 22:05:29 -06:00
2015_01_21_npc_types_update.sql Re-add 2015_01_21_npc_types_update.sql because Git was being weird 2015-01-22 00:15:47 -06:00
2015_01_25_logsys_Mercenaries_category.sql Added Logs::Mercenaries to the new Logging System. Logging of Mercenary information is off by default with the required SQL. 2015-01-25 12:31:07 -06:00
2015_01_28_quest_debug_log_category.sql Finish proper SQL. [skip ci] 2015-01-31 15:22:03 -05:00
2015_01_29_merc_stats_table_update.sql Added more information to Mercenary Logging. 2015-01-29 23:04:41 -06:00
2015_01_30_merc_attack_delay.sql Fix merc attack delay 2015-01-30 01:33:55 -05:00
2015_01_31_character_item_recast.sql Make items with long reuse timers show the timer after zone 2015-01-31 17:53:50 -05:00
2015_02_01_logsys_packet_logs.sql Add File 2015_02_01_logsys_packet_logs.sql 2015-02-01 21:43:50 -06:00
2015_02_02_logsys_packet_logs_with_dump.sql Implement Packet logs with dumps 2015-02-02 00:10:22 -06:00
2015_02_04_average_coin.sql Merge and fix the loot update branch, ready for merge I think 2015-02-04 23:13:02 -08:00
2015_02_12_zone_gravity.sql Missed .sql file [skip ci] 2015-02-12 22:32:36 -06:00
2015_05_20_BuffInstrumentMod.sql Bard instrument mods should be more consistent with live 2015-05-20 02:01:43 -04:00
2015_05_23_BuffDurations.sql Rework buff duration formulas 2015-05-23 02:20:36 -04:00
2015_05_23_dbstr_us.sql errant semi-colon, doesn't matter but still 2015-05-23 15:53:56 -07:00
2015_05_23_PetBuffInstrumentMod.sql Fix pet instrument mod issue 2015-05-23 17:14:08 -04:00
2015_05_25_npc_types_texture_fields.sql Add file 2015_05_25_npc_types_texture_fields.sql 2015-05-25 23:49:11 -05:00
2015_06_07_aa_update.sql And SQL for last commit 2015-06-07 23:42:28 -04:00
2015_06_30_runspeed_adjustments.sql Runspeed changes added to database update manifest 2015-06-30 23:57:13 -05:00
2015_07_01_Marquee_Rule.sql Oops. [skip ci] 2015-07-04 12:12:18 -04:00
2015_07_02_aa_rework.sql Final touch up on this, changelog + fix for sql classes default being left shifted 1. 2015-07-02 20:18:08 -07:00
2015_09_25_inventory_snapshots.sql Implemented 'Inventory Snapshot' feature 2015-09-25 23:07:05 -04:00
2015_11_01_perl_event_export_settings.sql Small adjustments to my rushing [skip ci] 2015-11-01 20:31:01 -06:00
2015_11_02_ai_idle_no_spell_recast_default_changes.sql Performance boost (exponential) - Adjusted default idle cast check timers in rules 2015-11-02 22:12:41 -06:00
2015_12_01_spell_scribe_restriction_rule.sql Added rule-based check for race/class restriction of spell scribing 2015-12-01 20:30:43 -05:00
2015_12_07_command_settings.sql Major change to how commands are loaded 2015-12-07 19:28:13 -05:00
2015_12_17_eqtime.sql eqtime is now stored in the DB. 2015-12-17 14:14:04 -08:00
2015_12_21_items_updates_evoitem.sql First step into implementing evolving items, added fields to database that were missing. 2015-12-21 05:39:39 -08:00
2015_12_29_quest_zone_events.sql Implemented standardized zone controller scripts (Rule Zone, UseZoneController) Defaulted to true 2015-12-29 04:08:10 -06:00
2016_01_08_command_find_aliases.sql Add command #findaliases 2016-01-08 17:19:10 -05:00
2016_03_05_secondary_recall.sql Implement extra bind points (secondary recall) 2016-03-05 16:28:53 -05:00
2016_07_03_npc_class_as_last_name.sql Added rule 'NPC:UseClassAsLastName' to allow certain npcs' class names to be hidden 2016-07-03 19:44:45 -04:00
2016_08_26_object_size_tilt.sql Add TiltX and TiltY manipulation to objects (Perl) 2016-08-26 06:39:39 -07:00
2016_08_27_ip_exemptions.sql World:EnableIPExemptions should be false by default. (Woops.) 2016-08-27 21:44:04 -04:00
2016_08_27_object_display_name.sql Add support for object display names 2016-08-27 22:24:08 -04:00
2016_12_01_pcnpc_only.sql Rename some spell fields 2016-12-01 13:35:19 -05:00
2017_01_10_book_languages.sql Fix for null columns in books.language crash 2017-01-30 03:08:00 -05:00
2017_01_30_book_languages_fix.sql Fix for null columns in books.language crash 2017-01-30 03:08:00 -05:00
2017_02_09_npc_spells_entries_type_update.sql Updated npc spell types to 32-bit mask 2017-02-09 17:57:55 -05:00
2017_02_15_bot_spells_entries.sql Moved bot spell entries out of npc spell entries (easier to manage bot changes by committing to non-bot manifest) 2017-02-15 07:42:17 -05:00
2017_02_26_npc_spells_update_for_bots.sql Moved bot npc spells entries to the 3000 + class id range 2017-02-26 05:47:10 -05:00
2017_03_09_inventory_version.sql First step of implementing inventory v2.0 2017-03-09 02:46:09 -05:00
2017_04_07_ignore_despawn.sql Added ignore_despawn column to npc_types to have NPCs ignore the despawn column in spawngroup. 2017-04-07 19:45:26 -07:00
2017_04_08_doors_disable_timer.sql Added 'disable_timer' to door objects (used for click once doors) 2017-04-08 21:08:15 -04:00
2017_04_10_graveyard.sql Graveyards!!! 2017-04-10 11:03:36 -07:00
2017_06_24_rule_values_expand.sql New rules made by developers are now automatically created when world boots up, this keeps from having to issue schema SQL updates every time rules are added. 2017-06-24 21:11:46 -05:00
2017_06_24_saylink_index.sql Speed up saylink retrieval x 1,000 - helpful for dialogues, plugins with many saylinks 2017-06-24 20:07:01 -05:00
2017_07_19_show_name.sql Add show_name and untargetable to npc_types fixes #637 2017-07-19 02:17:08 -04:00
2017_07_22_aura.sql Fix isquest issue with SQL 2017-07-24 14:35:22 -04:00