Ty Conner
7a181ad1dc
Fix Night Club Shirt descriptions ( #4403 )
...
Fixes incorrect LongDesc
2025-12-23 15:12:31 -05:00
Galli
c6c3448182
Fix DB Tools to Reference correct DB container name. ( #4339 )
...
* Update CompileAuthenticationBase.sh
Modify file to correct 'acedb' to 'ace-db' to conform with docker-compose.yml and docker.env
* Update DockerCompileAuthenticationBase.bat
Modify file to correct 'acedb' to 'ace-db' to conform with docker-compose.yml and docker.env
* Update DockerCompileAuthenticationBase.sh
Modify file to correct 'acedb' to 'ace-db' to conform with docker-compose.yml and docker.env
* Update DockerExportShardBase.bat
Modify file to correct 'acedb' to 'ace-db' to conform with docker-compose.yml and docker.env
* Update DockerExportShardBase.sh
Modify file to correct 'acedb' to 'ace-db' to conform with docker-compose.yml and docker.env
* Update DockerExportWorldBase.bat
Modify file to correct 'acedb' to 'ace-db' to conform with docker-compose.yml and docker.env
* Update DockerExportWorldBase.sh
Modify file to correct 'acedb' to 'ace-db' to conform with docker-compose.yml and docker.env
2025-07-22 14:10:11 -04:00
Galli
2b94205eb5
Database tooling additions for Linux/macOS users ( #4328 )
...
* Create CompileAuthenticationBase.sh
Script for Linux/macOS users
* Create DockerExportShardBase.sh
Script for Linux/macOS users
* Create DockerCompileAuthenticationBase.sh
Script for Linux/macOS users
* Update DockerExportShardBase.sh
Script for Linux/macOS users
* Create DockerExportWorldBase.sh
Script for Linux/macOS users
* Create ExportAuthenticationBase.sh
Script for Linux/macOS users
* Create ExportShardBase.sh
Script for Linux/macOS users
* Create ExportWorldBase.sh
Script for Linux/macOS users
* Create RebaseShardBase.sh
Script for Linux/macOS users
* Create RebaseWorldBase.sh
Script for Linux/macOS users
* Update README.md
Added information concerning DB Tooling for export and rebase.
2025-07-16 00:33:49 -04:00
Ty Conner
e5e12b3d84
Update 2025-05-08-00-Fix-Enscorcelled-Robe.sql
2025-06-22 19:45:06 -04:00
Boop-AC
bb5b972c50
Enscorcelled Robe Biota Update Script ( #4316 )
2025-05-10 22:13:04 -04:00
Boop-AC
6b0934dccc
Biota updates for PR 1733 Renegade Kalindan Fix ( #4293 )
2025-03-16 00:28:05 -04:00
OptimShi
0185587a49
Shard SQL Updates to go with Patches PR ( #4118 )
2024-03-15 00:33:12 -04:00
gmriggs
dab61fe621
update spell on existing Hieroglyph of Healing Mastery items ( #4038 )
2023-09-08 14:00:41 -04:00
Ty Conner
3a77d9e26b
Create 2023-07-25-00-Fix-Geraine-Tomes.sql ( #4030 )
2023-07-25 23:43:48 -04:00
sLackeR-hub
86d1509a7a
Purified Weapon Fix ( #4023 )
...
* PerfectWeaponFix
* ChangedName
2023-07-25 22:23:20 -04:00
gmriggs
7ba36c25fb
fix taulandoi critical frequency ( #3972 )
2023-04-09 16:17:47 -04:00
gmriggs
a715c79129
more enchanted/empowered phial pea bonding ( #3968 )
2023-04-09 14:20:38 -04:00
gmriggs
b4ffd9ff3c
add Bonded property to existing Enchanted Platinum Phial Peas ( #3959 )
2023-03-21 22:09:41 -04:00
Schneebs
8c09875bd0
retrofix for Nether Society Orb ( #3889 )
2022-09-15 01:34:22 -04:00
Ty Conner
59548c590e
Create 2022-06-10-00-Update-Items.sql ( #3859 )
2022-06-10 10:55:22 -04:00
Ty Conner
9fce5cd7ff
Several Retroactive to Shard Item Fixes ( #3853 )
...
* Create 2022-05-14-00-Fix-Slayer-Damage.sql
Co-Authored-By: Fire-Chimp <49045665+Fire-Chimp@users.noreply.github.com>
* Create 2022-05-14-01-Fix-Black-Cloud-Bow.sql
* Create 2022-05-14-02-Fix-Exquisite-Lense.sql
* Create 2022-05-14-03-Fix-Nether-Society-Orb.sql
* Create 2022-05-14-04-Fix-Aegis-of-the-Golden-Flame.sql
* Create 2022-05-14-05-Fix-Nekodes.sql
* Create 2022-05-14-06-Fix-Gauntlet-Backpacks.sql
Co-authored-by: Fire-Chimp <49045665+Fire-Chimp@users.noreply.github.com>
2022-06-05 20:56:24 -04:00
Boop-AC
2956246d80
Biota update script for shield of perfect light fix ( #3791 )
2022-01-20 00:44:53 -05:00
Boop-AC
eaec517cfd
Biota update script for red rune silveran weapon fixes ( #3790 )
2022-01-20 00:44:17 -05:00
Ty Conner
f33ebd3bd3
Remove incorrect spells learned from Stipends ( #3775 )
...
* Remove incorrect spells learned from Stipends
* Update 2022-01-06-00-Remove-Stipend-Spells-From-Players.sql
* Update 2022-01-06-00-Remove-Stipend-Spells-From-Players.sql
2022-01-08 14:16:31 -05:00
Boop-AC
a9418b28a8
Update script for stormwood daggers (content PR 1226) ( #3759 )
2021-12-21 12:54:24 -05:00
Schneebs
ab6e1659ec
retroactively fix critfreq on Orb of Darkest Flame ( #3753 )
...
* retroactively fix critfreq on Orb of Darkest Flame
* Update Database/Updates/Shard/2021-12-03-Update-Heart-of-Darkest-Flame.sql
Co-authored-by: gmriggs <gmriggs@gmail.com>
Co-authored-by: Ty Conner <tyconner@itcproductions.com>
Co-authored-by: gmriggs <gmriggs@gmail.com>
2021-12-21 12:54:11 -05:00
gmriggs
e2a8d5ebd6
update critical frequency on some items ( #3731 )
...
* update critical frequency on some items
* add vortex thorn
2021-11-07 03:53:28 -05:00
Ty Conner
880c031102
Update SQL Writer output ( #3694 )
...
* Update SQL Writer output
* Update SQLWriter.cs
* Add PacketOpCodeNames
* Update PropertyInt.cs
* Update PropertyInt.cs
2021-10-18 21:33:27 -04:00
gmriggs
838d4f7e84
fix missing DefaultCombatStyle on existing casters ( #3671 )
2021-09-08 12:48:02 -04:00
OptimShi
d18762dc9a
Fix for ChasingOswald stamp ( #3666 )
...
* Fix for ChasingOswald stamp
* Update 2021-08-30-00-ChasingOswald.sql
Co-authored-by: Ty Conner <tyconner@itcproductions.com>
2021-08-31 00:30:46 -04:00
OptimShi
6274d404e0
Chasing Oswald - Requires Content Update ( #3652 )
...
* Update to Chasing Oswald completion quest stamp to match Contract
* Added newline to SQL update
* Blank new line...
2021-08-29 21:21:12 -04:00
OptimShi
a4f36d66f9
Added script to reset all PetDevice in ace_shard to the proper pet ( #3631 )
2021-07-28 00:13:16 -04:00
gmriggs
0bbe1f91c8
add semicolons ( #3616 )
2021-07-15 19:47:35 -04:00
gmriggs
9fc6c7ba8a
fix defense imbues ( #3614 )
...
* fix defense imbues
* update comment
2021-07-14 17:18:26 -04:00
gmriggs
70a6f18c03
retroactively fix weenieType on rynthid tentacle bow ( #3598 )
2021-06-28 14:55:00 -04:00
Ty Conner
dd5d1ddcbc
Create 2021-03-18-00-Update-Casting-Stone.sql ( #3504 )
2021-03-18 13:24:10 -04:00
Ty Conner
93723a0845
Rebase SQL scripts ( #3402 )
...
* Rebase SQL scripts
Archive previous SQL base
* .
update mysql to latest, no real changes found
* Update ShardBase.sql
2020-12-30 14:21:39 -05:00
gmriggs
9075e6d8c4
WieldSkill -> WieldSkillType for t7+ non-elemental casters ( #3354 )
...
* WieldSkill -> WieldSkillType t7+ for non-elemental casters
* add warning message
* add db script to fix existing shard items
2020-11-15 22:58:31 -05:00
gmriggs
67d6a47e13
add cleanup script for grub / pack doll TTR ( #3349 )
...
* add cleanup script for grub / pack doll TTR
* add more pack dolls
2020-11-03 01:42:16 -05:00
gmriggs
90e0dde41e
sync defense imbue salvage for existing shard items ( #3338 )
...
* sync defense imbue salvage for existing shard items
* updating filename
2020-10-30 13:27:23 -04:00
gmriggs
51f392d3e9
add missing ItemCurMana fields to rares ( #3326 )
2020-10-25 21:39:59 -04:00
gmriggs
5e32292d2f
add shard update script to sync level 200 pet device names ( #3317 )
2020-10-20 12:43:50 -04:00
Ty Conner
92347f7b77
Add Fixup script for one more casino key ( #3256 )
2020-10-01 16:44:56 -04:00
Ty Conner
86c7d20a6d
Update script to fix existing casino key lockcodes ( #3244 )
...
* Create 2020-09-18-00-Update-Casino-Keys.sql
* Update 2020-09-18-00-Update-Casino-Keys.sql
2020-09-18 04:06:04 -04:00
gmriggs
e03d4378dd
update crit rate for existing bloodstone wands ( #3209 )
2020-09-10 08:08:46 -04:00
gmriggs
e327049005
adding chance tables for gem count ( #3199 )
...
* add scaffolding
* adding chance tables for gem count
* update scaffolding
* update var names
* moving treasure-gem-count.sql test file to WorldBase and 16PY-patches
2020-09-10 08:03:01 -04:00
gmriggs
e1a6798b29
allow clothing w/ armor level that only covers extremities (head / hands / feet) to be tinkered with steel profiles ( #3158 )
2020-08-27 00:14:13 -04:00
Ty Conner
ddf879223f
Add fix-up script for PetDevices ( #3108 )
...
* Add fixup script for PetDevices
* Update appveyor.yml
* Update Player_Location.cs
2020-08-08 14:14:16 -04:00
Ty Conner
6f5e9093f1
Update script for Facility Hub Portal Gem ( #3049 )
2020-06-27 18:34:03 -04:00
Ty Conner
54c35b1b7b
Resync some item properties with world database ( #3043 )
...
* Resync some item properties with world database
* Update 2020-06-25-00-Update-Some-Items.sql
2020-06-26 21:47:32 -04:00
Ty Conner
837a663226
Fix burden of Colo Backpack ( #3030 )
2020-06-20 03:30:26 -04:00
gmriggs
a47b0be310
update trinket cleanup script ( #2966 )
...
* update trinket cleanup script
* .
2020-05-05 19:55:03 -04:00
gmriggs
757d8f8804
update black thistle ( #2948 )
2020-04-18 16:44:33 -04:00
gmriggs
8280ff073c
fix copper / silver salvage ( #2929 )
2020-04-18 16:15:12 -04:00
Ty Conner
4a24710f4e
Fix spell bar position save issue ( #2918 )
...
* Fix spell bar position save issue
* Update 2020-04-11-00-Update-Character-SpellBars.sql
* Switch CharacterPropertiesSpellBar to composite key
* Fix incorrect indexes in SpellBars
* Update ShardDatabaseOfflineTools.cs
* Update PropertyManager.cs
* Update DatabaseManager.cs
* Update 2020-04-11-00-Update-Character-SpellBars.sql
* Update 2020-04-11-00-Update-Character-SpellBars.sql
* Update ShardDatabaseOfflineTools.cs
* Update 2020-04-11-00-Update-Character-SpellBars.sql
* Update ShardDatabaseOfflineTools.cs
* Update DeveloperDatabaseCommands.cs
* Update Program.cs
* Update 2020-04-11-00-Update-Character-SpellBars.sql
* Update 2020-04-11-00-Update-Character-SpellBars.sql
* Update ShardDatabaseOfflineTools.cs
* Update ShardDbContext.cs
* .
* Update DeveloperDatabaseCommands.cs
* Update DeveloperDatabaseCommands.cs
optimizations by @gmriggs
Co-Authored-By: gmriggs <gmriggs@gmail.com>
Co-authored-by: gmriggs <gmriggs@gmail.com>
2020-04-12 17:01:22 -04:00
