Commit graph

25 commits

Author SHA1 Message Date
sruon
012d381bec Zoneline origination points; spawn slotting
Add the origin points for each zoneline as extracted from the DATs using xiregiondump
Adds target zonelines spawnbox scale and rotation to calculate spawn slots as retail does.

Co-Authored-By: atom0s <atom0s@users.noreply.github.com>
2026-02-19 00:34:44 -07:00
Umeboshi
96f674731a [sql] Add zoneline for Cirdas Caverns - Woh Gates 2025-03-13 17:27:02 -07:00
Corey Sotiropoulos
f202e592e7 [sql] Speed up Aria table inserts
See:
https://mariadb.com/kb/en/aria-storage-engine/
2024-01-11 22:33:23 -05:00
Zach Toogood
24f35c4c5e [sql] Replace MyISAM engine with Aria 2024-01-04 18:43:36 +00:00
Zach Toogood
ca3bdd22fe [SQL] Add COLLATE=utf8mb4_general_ci to all tables 2024-01-04 18:25:12 +00:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
TeoTwawki
dd02066118 Convert tables that are never written to back to MyISAM. Only tables we write to need InnoDB.
MyISAM = table level locking, fast but not safe for multiple simultaneous writes
InnoDB = row level locking, slow, but is safe for multiple simultaneous writes

```
Features                            MyISAM                        InnoDB
Type                                Non-Transactional             Transactional
Locking                             Table locking                 Row-level locking
Foreign keys                        No                            Yes
Table, index, data storage          Three separate files          Combined Tablespace
ACID                                No                            Yes
```
2021-11-10 08:09:45 -05:00
TeoTwawki
2589da530c Merge branch 'topaz' of https://github.com/DerpyProjectGroup/topaz into freedom
# Resolved Conflicts:
#	sql/job_points.sql
2021-04-18 13:49:29 -04:00
Ixion
c460a89139 Ixion is Come!
- Rebranding.
- Migrate to GitLab.
- Add support for database updates when using Docker.
- Give purpose to version.h (adjust minor version with client updates).
- Add an in-game `!ver` command.
- Remove references to AGPL.
2021-04-17 18:24:14 -04:00
TeoTwawki
276cf1a095 Merge branch 'canary' of https://github.com/topaz-next/topaz into freedom 2021-04-10 22:55:57 -04:00
TeoTwawki
de3066a3cb Remove even more banding references. The name "topaz" remains in places but all of "tpz" should be gone now. 2021-04-01 16:14:56 -04:00
Zach Toogood
9e4993893d Migrate all SQL tables from MyISAM to InnoDB 2021-02-05 17:07:08 +02:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
UnknownX
483da83306 Added the Shadowreign residential areas 2017-03-14 04:42:38 -05:00
Carsten.Wache
3708421fb0 Fix zoneline to Bearclaw Pinnacle 2016-11-09 00:41:30 +01:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
TeoTwawki
a1b75c166b Fixed irritating backwards zonelines at Spire of Dem and Spire of Mea.
Also changed the indents and whitespace of Misareaux_Coast/npcs/_0p0.lua so that it no longer looks like trash in my editor because IF YOUR WHITESACE IS BAD YOU SHOULD FEEL BAD kthx by.
2015-01-23 20:21:52 -05:00
TeoTwawki
e191154e56 Fixed irritating backwords zone-in spot in Upper Delkfutt's Tower. 2014-12-10 23:59:42 -05:00
gedads
bcd5a787ac script added default location when zoning in soa areas
sql added missing zonelines for soa
2014-07-05 22:34:30 +02:00
Apocalypse612
00870e8ec9 SQL: Fix some wrong zonelines entering/exiting Boneyard Gully 2014-03-10 15:54:03 -04:00
Ezekyel38
b92beab26f SCRIPTS: update keyitems list (thanx compmike19)
DATABASE: add zoneline for new zone (thanx gedads), add relic gun drop (thanx Kiri)
2013-07-09 11:28:59 +00:00
Ezekyel38
8ef50916f0 DB: add npc/monster for Xarcabard (S), Zvahl Bailey (S), Zvahl Keep (S), Western Adoulin, Eastern Adoulin, Yahse Hunting Grounds, Ceizak_Battlegrounds (Thanks to Gedads)
add zoneline for the new addon.
2013-04-03 21:25:50 +00:00
teschnei
6d363d2987 CORE: fix zonelines for adoulin zones (thanks gedads) 2013-03-31 23:06:00 +00:00
whasf
f00dd04526 SQL: Corrected sql in order to get into boneyard gully from the right entrance
(Thank you Gedads)
2013-02-01 01:28:05 +00:00
onetimeffxi
7a160120a7 2011-09-16 15:56:24 +00:00