Releases: ACEmulator/ACE-World-16PY-Patches
ACE World Database v0.9.281
ACE World Database v0.9.281
The following commit is included in this release: V0.9.281 (#1691)* Update Swift Set (#1672)
- Update 04816 Novice Soldier's Finesse Weapon Aptitude.sql
Update from Dagger to Finesse Weapons
Update 04817 Apprentice Soldier's Finesse Weapon Aptitude.sql
Update 04818 Journeyman Soldier's Finesse Weapon Aptitude.sql
Update 04819 Master Soldier's Finesse Weapon Aptitude.sql
Update KillTaskSpectralClawsBlades0812.sql (#1673)
Update kill task count to match contract
Update Prodigal Banderling (#1675)
Update Prodigal Banderling
Corrects Harraag's appearance (an incorrect setup was used).
Corrects adds in the last room from Loud Lou retail video and deletes unnecessary generator.
Sets respawn to 5 min (timed from video). Previously, was 10 min.
Adds missing Banderling NPCs to outdoor landblocks (4 from pcap, 2 from vlocs, also seen in the video).
Adds missing proc spell rate to the dagger reward.
Revises the stats on Haraag's weapon based on the wiki (adds missing proc spell rate, lightning cleaving). Also adjusts Harraag's skills to account for large melee, missile and magic defense bonuses on the weapon.
- Update 87339 Harraag's Lair.sql
Co-authored-by: Ty Conner [email protected]
- Update Vissidal Undead (#1677)
Corrects scale, and sets skills and armor level from pcaps. Revises spellbook based on some retail screenshots.
- Update 72510 Materialized Hoshino Kei.sql (#1678)
Swaps motion table to make her float when she moves, as seen in retail video by Immortal Bob.
- Update Sanamar Collector (#1679)
Now takes 31349 yellow armband from Mosswart Elder as per bug report from justindz.
Update Bur (#1681)
Update Bur
Revises Southern Catacombs spawns for a closer match to retail (as seen in Berek retail video). Also reduces mushroom spawn rate which was excessive. In the pcap, mushrooms make up 6-7% of the spawns. Currently, more than half of spawns appear to be mushrooms.
Cleans up duplicate Baby Thrungus in Kor Gursha and adds emote so they roam around (as seen in Tzepesh retail video).
- Update 00D4.sql
Added missing exit portals from vlocs, and filled in some sections that were left empty.
- Update Northern Caverns
Same treatment for the Northern Caverns.
Adds missing descriptions to decorative house items sold on Bur.
- update eastern catacombs
Same treatment for Eastern Catacombs.
Add Jungle Orchid Quest (#1682)
Add Jungle Orchid Quest
Adds the quest:
http://acpedia.org/wiki/Jungle_Orchid
- correct typo
Corrected a typo not found in the npc speech pcap.
Update Rynthid Outdoors (#1684)
Update Rynthid Outdoors
Adjusts skills on rynthid to match the pcap skill estimates. In general, magic was too high, and in some cases melee and missile were too low.
Revises outdoor generators for a better match to retail based on Loud Lou video. From the video, I estimated respawn to be longer than 5 min but less than 10, so set to 7 min.
Fixes Rynthid Crystal so it will generate adds.
- ring spell and drop table
Changes version of heavy lightning ring cast by some Rynthid to a lower damage version. The higher damage version, which can do close to 500 damage per hit, was used by mistake.
Corrects drop table for Aspect of Rage and Torment, so each cloak has an independent 5% chance of dropping.
- update indoor rynthid
Same treatment for dungeon rynthid.
- Update Paradox Olthoi (#1685)
Sets skills and armor values from the pcap, and revises resistance mods to match existing olthoi.
Corrects scale of Ward Guardian, and a few other olthoi.
Corrects body table of Sentinel type olthoi, which were previously doing 0 damage with one of their body part.
Adds missing idle emote to some olthoi.
- Fix Prodigal Lugian (#1686)
Corrects a number of issues with the Prodigal Lugian quest reported by players. In retail, multiple people could do this quest without interfering with each other. As is, the quest only works properly for one person at a time, and can cause others to get stuck for over 30 min due to unnecessary use of events and landblock keep alives.
This redesigns the quest, allowing multiple people to work on the trials at the same time (such as in the Burun Kings quest where a similar mechanic is used).
Also resolves console errors - missing combat table on a boulder, and failing to spawn weenie, which had not been included.
Corrects energy cage mechanic, and scene at the end of one trial.
Corrects final fight. As seen in the pcap, adds are clearly spawned by Kresovus around him, thus removing multiple unnecessary wave gens.
Adds missing emote to boulder in Trial of the Arm, which in retail, could be "moved" if the person had a high enough base strength (thus, the name of the trial). This is why this boulder is useable in the pcap. If strength was not high enough, it could alternatively be killed.
Fixes a bug where the Trial of the Mind was purely cosmetic (i.e., did not stamp the...truncated (10000 bytes)automated database build - 2024-07-15T02:57:02Z
ACE World Database v0.9.280
ACE World Database v0.9.280
The following commit is included in this release: V0.9.280 (#1653)* Update 37585 Soul Bound Staff.sql (#1640)
Adjusting critical multiplier and frequency on the SB staff for a closer match to retail.
Based on a retail video of Berek fighting Aerbax, with pierce vul 8, the average on normal hits was 1317 (based on 66 shots). The critical average was 4432 (based on 11 shots). This is with pierce vul 8.
Without pierce vul (only on the staff's pierce rend), the normal hit average is 1031 (total 40 shots) and 3506 on criticals (total 10 shots).
Either way, criticals are about 3.5 more damage than normal hits. Also, out of the 149 shots in the video, 25 were criticals, which is a .1677 rate. Subtracting 1% for eye of remorseless aug, and rounding down to be more conservative, gives 15% chance to critical.
Update Floating City (#1644)
Update Floating City
Update the Floating City to end of retail.
Also made minor adjustments to the skills of the creatures found here based on the pcaps. These creatures are also found in other old quests (e.g., Mage Academy) updated around the same time.
Added missing attributes and rebalanced skills for Banderling Smasher (including that found on Olthoi Island).
https://asheron.fandom.com/wiki/Floating_City_Quest
- Create 73170 Random Portal Generator.sql
Added missing random portal generator.
- Update Major Atlan Stone Quests (#1647)
Updates the dungeons to end of retail spawns.
https://asheron.fandom.com/wiki/Smoldering_Stone_Quest
- Updated Cells of the Black Book Portals 32674, 32675, 32676, 32677, 32678, 0089 (#1648)
Database/Patches/6 LandBlockExtendedData/0089.sql (Cells of the Black Book Surface Portal)
Database/Patches/9 WeenieDefaults/Portal/Portal/32674 Cells of the Black Book.sql
Database/Patches/9 WeenieDefaults/Portal/Portal/32675 Cells of the Black Book.sql
Database/Patches/9 WeenieDefaults/Portal/Portal/32676 Cells of the Black Book.sql
Database/Patches/9 WeenieDefaults/Portal/Portal/32677 Cells of the Black Book.sql
Database/Patches/9 WeenieDefaults/Portal/Portal/32678 Surface.sql (Cells of the Black Book Surface Portal)32674, 32675, 32676, 32677 Cells of the Black Book Portal drops
Updated portal destinations for Cells of the Black Book portals to match Landblocks Google Sheets PCAPS.PCAP Data (from Landblocks Google Sheet) shows four entrances
Cells of the Black Book (Entrance 1) - 32674
0x008902DC 0 -200 -0.087583 0.707107 0 0 -0.707107
Cells of the Black Book (Entrance 2) - 32675
0x008902F5 200 -420 -0.375722 1 0 0 0
Cells of the Black Book (Entrance 3) - 32676
0x008902FF 220 0 0 0 0 0 -1
Cells of the Black Book (Entrance 4) - 32677
0x00890318 420 -220 0 -0.707107 0 0 -0.707107Previously all portals were mistakenly set to the same drop point (North side)
Now updated to 4 different drops W, S, N, E.--
Updated 0089.sql Add 4th Surface Portal to Cells of the Black Book
@teleloc 0x00890113 [67.000122 -240 -12] 1 0 0 0From vloc2loc data (0089)
Surface - @teleloc 0x00890150 [180 -67 -12] 1 0 0 0
Surface - @teleloc 0x008901E7 [240 -353 -12] 1 0 0 0
Surface - @teleloc 0x00890224 [352.999878 -180 -12] 1 0 0 0
(MISSING) Surface - @teleloc 0x00890113 [67.000122 -240 -12] 1 0 0 0From world_objects (landcell '89%')
37576 14 890150 -101.2 7.37 -0.05 Surface (10.3S, 50.3E).
37826 14 89010000000 -100.95 6.18 -0.05 Surface (10.3S, 50.3E).
37854 14 890224 -100.48 6.9 -0.05 Surface (10.3S, 50.3E).
(MISSING) 38026 14 890113 -101.67 6.65 -0.05 Surface (10.3S, 50.3E).--
32678 Cells of the Black Book Surface Portal NOT YET IMPLEMENTED
Update Cells of the Black Book Surface Portal(s) to deposit you outside the bunker.
/* @teleloc 0xBE720015 [60.000000 107.998047 6.006000] 1 0 0 0 /
/ this matches world_objects exit portal data for landcell 89.. that shows "Surface (10.3S, 50.3E)"From world_objects (landcell '89%')
37576 14 890150 -101.2 7.37 -0.05 Surface (10.3S, 50.3E).
37826 14 89010000000 -100.95 6.18 -0.05 Surface (10.3S, 50.3E).
37854 14 890224 -100.48 6.9 -0.05 Surface (10.3S, 50.3E).
38026 14 890113 -101.67 6.65 -0.05 Surface (10.3S, 50.3E).
- Update Forgotten Tunnnels 43118, 43119, 43120 portals 'not yet implemented' (#1649)
Database/Patches/9 WeenieDefaults/Portal/Portal/43118 Forgotten Tunnels.sql
Database/Patches/9 WeenieDefaults/Portal/Portal/43119 Forgotten Tunnels.sql
Database/Patches/9 WeenieDefaults/Portal/Portal/43120 Forgotten Tunnels.sql-- Set Destinations according to Landblock Google Sheet PCAP data
43118 Source: 93.1S, 56.9W
@teleloc 0x380B0102 [60.0445 20.7545 -5.663] -0.999965 0 0 0.008334
-- Set Destination:
@teleloc 0x8B02026b [0 -20 18.004999160767] 0.70710700750351 0 0 -0.70710700750351
-- W side of dungeon43119 Source 92.9S, 56.4W
@teleloc 0x380B0106 [179.998 69.0345 -5.663] -0.999579 0 0 -0.028995
-- Set Destination:
@teleloc 0x8B020282 [130 -200 18.004999160767] 1 0 0 0
-- S side of dungeon43120 Source 93.6S, 56.6W
@teleloc 0x380A0102 [132.106 ...truncated (10000 bytes)automated database build - 2024-05-26T19:28:43Z
ACE World Database v0.9.279
ACE World Database v0.9.279
The following commit is included in this release: V0.9.279 (#1634)* Update Soul Hunter Quest (#1630)
Added missing properties to several quest items (attuned, bonded, description, etc.).
Filled section of the dungeon that had been left empty.
Corrected crafting interaction text (retail text found on Maggie the Jack Cat's old website).
Composite weapons (#1631)
Update 03977 Salvaged Ivory.sql
Update 33990 Composite Bow with Superb Handle.sql
Update 33991 Composite Bow with Fine Handle.sql
Update 33993 Composite Crossbow with Superb Handle.sql
Update 33996 Composite Bow with Exquisite Handle.sql
Update 33998 Composite Crossbow with Exquisite Handle.sql
Update 87748 Composite Atlatl with Fine Handle.sql
Update 87749 Composite Atlatl with Superb Handle.sql
Update 87750 Composite Atlatl with Exquisite Handle.sql
Update 87751 Composite Crossbow with Fine Handle.sql
Update 33990 Composite Bow with Superb Handle.sql
Update 09069 Infinite Ivory.sql
Update 33990 Composite Bow with Superb Handle.sql
Update 33991 Composite Bow with Fine Handle.sql
Update 33993 Composite Crossbow with Superb Handle.sql
Update 33996 Composite Bow with Exquisite Handle.sql
Update 33998 Composite Crossbow with Exquisite Handle.sql
Update 87748 Composite Atlatl with Fine Handle.sql
Update 87749 Composite Atlatl with Superb Handle.sql
Update 87750 Composite Atlatl with Exquisite Handle.sql
Update 87751 Composite Crossbow with Fine Handle.sql
Update Shroud Cabal and Others (#1632)
Update Shroud Cabal and Others
Adds missing properties to Shroud Cabal quest items (value, description).
Adds missing MMD reward to this quest.
Adds missing clothing base to Reflective Shard (from low Harbinger quest) to match retail screenshot.
Corrects clothing base on Golden Gromnie (item in Ulgrim's basement) to match retail screenshot (i.e., so gromnie is actually gold, not blue).
- Update 00EC.sql
Respawn to 5 min (instead of 7).
Update the Tumerok Vanguard Outposts to end of retail (#1633)
normalize
Misc Updates (#1635)
Numerous Updates
Added Mask of the Hopeslayer, Enhanced Robe of the Tundra Colors, Guard Hrothgar, Falatacot Abbess Head
Add Vacant Golem pet
fix merge errors
Update 06948 Monster Fly Trap.sql
Update 06950 Monster Sundew.sql
Update 06952 Monster Pitcher Plant.sql
fix recipes
Update 09217 Fly Trap.sql
Co-authored-by: Ty Conner [email protected]
- Update Frozen Fortress (#1636)
Corrected armor, spellbooks and skills for several bloodstones based on pcaps.
Removed duplicate spawns and added all possible mobs to generators based on retail video. As seen in the video, the spawns inside the dungeon are random.
Corrected a line of npc dialog based on retail video.
- Update Bloodstone Wand (#1637)
Increased critical frequency to 0.25 from 0.06. This is a wand from a level 200 quest, and should be on the upper end for quest critical frequencies (for example, in the world db, the singularity scepte has a critical frequency of 0.25).
Neftet Skill Rebalance (#1638)
Neftet Skill Rebalance
Updated skill levels for Neftet golems and mummies based on pcaps. Also corrected some spellbooks. In general, magic skills were too high, while some melee skills were too low.
Correct mu-miyah lord creature magic
normalize
.
Update Shadow March (#1639)
Added missing shadow types (royal and viamontian knight types).
Revised spawn density to match retail based on pcaps.
- finalize
Co-authored-by: TectonicRifts [email protected]
Co-authored-by: ziang4891 [email protected]
Co-authored-by: OptimShi [email protected]automated database build - 2024-03-15T04:21:35Z
ACE World Database v0.9.278
ACE World Database v0.9.278
The following commit is included in this release: V0.9.278 (#1626)* Move Lugian Assault Legendary Quest counter stamp from Commander Presk to Raksaa (#1616)
Move Lugian Assault Legendary Quest counter stamp from Commander Presk to Raksaa
Update 51923 Raksaa.sql
Legendary Quest stamp was placed in the wrong location
Co-authored-by: ziang4891 [email protected]
- Armor of Darkness Quest Fixes (#1617)
Adds reset interval to pressure plates controlling bridges to resolve issue of the bridge constantly going up and down as multiple players step on the plate.
Ries Woron will now take a piece of armor and hand back the same piece as per retail. This can be used to reset any dyed piece back to its original color.
Hoshino Sarcophagus Fix (#1618)
Hoshino Sarcophagus Fix
The sarcophagus guards now spawn.
The guards are now a voidmage and bloodmage with retail wcids, as documented here:
https://www.immortalbob.com/phpBB3/viewtopic.php?f=3&t=322
- Update 52293 Spectral Bloodmage.sql
Removed activate on death.
- Prismatic Armor Fixes (#1619)
The quest now correctly uses the empty Enchanted Decanters (19482) from the Arcanum Research Facility.
Corrects properties on decanter and crystallized essence to match pcap and allow for crafting interaction.
Update Harbinger Quest (#1620)
Update Harbinger Quest
Revised final fight for Empowered Harbinger based on Loud Lou retail video and pcap:
Hands and children now spawn on a 10 min linkable generator (timed from video). These also respawn throughout the fight, even when the essences have spawned. Thus, not on events.
Harbinger now used as generator for the essences directly, instead of an event. Removed event and event generators that were no longer necessary.
The empowered and essenceless Harbingers now drop correct arm tokens (previously had been swapped).
update on death broadcast
Add ProcSpellRate to Clubs of Cunning (#1621)
Update 33239 Tunnels to the Harbinger (#1622)
Update 33239 Tunnels to the Harbinger
Updates the Vincadi portal to the Weakened Harbinger to send the player to the correct dungeon (6446).
correct on death broadcast
Update 46356 Popkin of the Gate (#1623)
Sets the 190M XP reward to no share.
Update Nexus (#1624)
Update Nexus
Updates the Nexus landblock 0110 to match the pcap and retail video by Tzepesh. This corrects spawn placement, and adds the missing traps (present in the original landblock from world DB, and seen in the video, meaning they were not removed). Also adds damage rating to Nexus Commander (as in the video).
https://www.youtube.com/watch?v=0W13OWw8SkU
- Update 0110.sql
Increased level of lightning trap to 7.
- Misc Fixes (#1625)
Corrects composite crossbow with handle recipes to use the crossbow (not bow) as the base.
Removes nether resistance from Decaying Ruschk Laktar, and sets other resistances to be similar to other undead Ruschk.
Sets attack type to thrust for 46392 Shadowfire Isparian Spear.
Corrects stats on Composite Crossbow with Fine Handle based on what's listed on both wikis.
cosmetic change, nothing to see here
normalize
More cosmetic
normalize again
Update Asheron's Departure Lower (#1627)
Sets the quest pickup timers to 20 hours for the level 15-79 version of Bur flagging. This quest is not on the exception list from the Quest for Freedom, and should have a 20 hour timer like most others.
Update Empyrean Rescue and Four Corners (#1628)
Update Empyrean Rescue and Four Corners
Empyrean Rescue
Clean up of last room to match the pcap and Berek retail video.
Rebalanced boss creatures, as much as possible based on pcap skills and damage seen in the retail video - in general, magic was too high, while melee and missile were too low. It was previously possible for archers to machine gun and hit for over 10k damage per hit.
Corrected bloodstone so no longer ethereal (tusker fists now works on it, as seen in the video).
Undead Commanders corrected (spellbook removed, they are melee only) and deal increased melee damage.
Removed unnecessary event and generator to open a portal. Instead, virindi now summons portal on death (portal summon purple animation is seen in the video).Four Corners
Updated skills of Bak'tshay Lackeys based on pcap.
Update F93B.sql
Update 37517 Enhanced Health Elixir.sql (#1629)
when potions stacked they would become 775 bu each, should be 75 each
normalize
finalize
Co-authored-by: Jesse L.K. Overton [email protected]
Co-authored-by: ziang4891 [email protected]
Co-authored-by: TectonicRifts [email protected]
Co-authored-by: Boop-AC [email protected]
Co-authored-by: Derpymcgavin [email protected]automated database build - 2024-01-20T19:40:25Z
ACE World Database v0.9.277
ACE World Database v0.9.277
The following commit is included in this release: V0.9.277 (#1610)* Fix Quiddity Bow Resistance Cleave (#1606)
currently when you go thru the great hall portal you are able to recall. which allows you skip half the quest.
Added correct Default Palette for Masonry Golem
Fix adept gem of blade prot recipe to create 2 gems (#1612)
Fix Northwatch supply gens to create northwatch crate instead of freebooter (#1613)
Fix Littoral Siraluun Hoeroa for MOA (#1614)
Fix Grand Knight emote logic for Dericost Ruin rewards (#1615)
normal and finalize
Co-authored-by: Boop-AC [email protected]
Co-authored-by: Fire-Chimp [email protected]
Co-authored-by: Raile [email protected]
Co-authored-by: OptimShi [email protected]automated database build - 2023-12-16T16:58:12Z
ACE World Database v0.9.276
ACE World Database v0.9.276
The following commit is included in this release: V0.9.276 (#1604)* Add Channeling Stone Hatchet recipe (#1592)
Add Channeling Stone Hatchet recipe
Add proc rate to channeling bone bow (#1593)
Remove Swarm Demon Life Immunity (#1594)
Make Invisible Assailant skills MOA compliant (#1595)
Fix AOD Bridge Timer (#1596)
Fix Protecting Picketed Pets Bugs (#1597)
society fix for retail meta (#1598)
error in text that retail meta would not proceed due to the missing ,
Fix Deewain timers and turn-in emotes (#1599)
Fix GY colo timers (#1600)
Add missing recipes to lower mukkir slayer stones (#1601)
Fix Swamp Cavern gen (#1602)
Update some text to match retail meta (#1603)
Co-authored-by: Ross Elliott [email protected]
normalize
Update 69994 Night Club Attendant.sql
Ilte Krongal
Co-Authored-By: Fire-Chimp [email protected]
Co-Authored-By: OptimShi [email protected]
Create 69994.es
normalize
finalize
Co-authored-by: Boop-AC [email protected]
Co-authored-by: Fire-Chimp [email protected]
Co-authored-by: OptimShi [email protected]
Co-authored-by: Ross Elliott [email protected]automated database build - 2023-11-17T05:41:36Z
ACE World Database v0.9.275
ACE World Database v0.9.275
The following commit is included in this release: V0.9.275 (#1589)* rynthid tentacle current mana fix (#1587)
rynthid tentacle current mana fix
- Update 43479 Light Infused Healing Kit.sql (#1588)
ACE-PCAP-Dynamics-Exports/Database/3-Core/9 WeenieDefaults/SQL/Healer/Misc
/43479 Light Infused Healing Kit.sq
.
..
normalize
Update 69986 Night Club Shirt.sql
Update 33D9.sql
Update BC9F.sql
normalize
Add 2H weapons to Sturdy Steel Chests (#1590)
Update 5874.sql (#1591)
Update 5874.sql
maze had alot of holes that needed fixed
- Update 5874.sql
removed 72121. no idea how it was added. i only added 72119
- finalize
Co-authored-by: Fire-Chimp [email protected]
Co-authored-by: Boop-AC [email protected]automated database build - 2023-10-25T01:54:21Z
ACE World Database v0.9.274
ACE World Database v0.9.274
The following commit is included in this release: V0.9.274 (#1583)* fluff ints added (#1572)
added unenchantable and weild requirements. basically fluff stuff. keeps the id panel from being empty.
- add delete self (#1573)
in retail if you had a corrupter amber to the fountain it deleted itself
Fix Atamarr emotes (#1574)
Stormwood Staff Spell Fix (#1575)
Fix spells on Seasoned Explorer Nether Staff (#1576)
Fix Spectral Blade and Claws Contract (#1577)
Fix Red Rune Silveran Mace TurnIn (#1578)
Fix deru tree royal olthoi jelly (#1579)
Deru Tree lockout fix (#1580)
Fix Nimble Fingers buffs (#1581)
fix spell on t5 rare Hieroglyph of Healing Mastery, from Incantation of Heal Self -> Incantation of Healing Mastery Self (#1582)
normalize
Fix Apostate Finale portal restrictions (#1584)
Fix 575 LP Viridian Statues (#1585)
geraine host fix (#1586)
http://acpedia.org/wiki/Geraine%27s_Hosts
Note: In order for this quest to count as one of the Legendary Key Quests you must turn in all 7 books to the Mhoire Lieutenant in Wai Jhou.
you were able to get credit for this quest by turning in the 1st 4 books into the soldier. which is not retail
normalize
More statue updates
normalize
finalize
Co-authored-by: Fire-Chimp [email protected]
Co-authored-by: Boop-AC [email protected]
Co-authored-by: gmriggs [email protected]automated database build - 2023-09-08T17:49:06Z
ACE World Database v0.9.273
ACE World Database v0.9.273
The following commit is included in this release: V0.9.273 (#1570)* Update Agents
Update 03980 Impenetrability Incantation.sql
normalize
Update Olthoi Hunter
Fix spell ID for Prodigal Harbinger teleport on Vincadi Harbinger Tunnels portal (#1571)
Sync up Tunnel portal emotes
Create 03930.sql
normalize
Viridian Portal updates
Update 30361 Loop of Opposing Benedictions.sql
Co-Authored-By: OptimShi [email protected]
normalize
More Viridian Portal updates
Ancient Statue adjustments
normalize
finalize
Co-authored-by: Jesse L.K. Overton [email protected]
Co-authored-by: OptimShi [email protected]automated database build - 2023-08-16T16:36:39Z
ACE World Database v0.9.272
ACE World Database v0.9.272
The following commit is included in this release: V0.9.272 (#1569)* Gurog Ice Cave Fix (#1566)
added attuned and bonded
- normalize and finalize
Co-authored-by: sLackeR-hub [email protected]
Co-authored-by: Fire-Chimp [email protected]automated database build - 2023-07-26T02:02:22Z