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.707107

Previously 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 0

From 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 0

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).
(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 dungeon

43119 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 dungeon

43120 Source 93.6S, 56.6W
@teleloc 0x380A0102 [132.106 ...truncated (10000 bytes)

automated database build - 2024-05-26T19:28:43Z