107 commits

Author	SHA1	Message	Date
collett	3460916f52	fix migration sql	2023-02-15 00:10:37 +09:00
Mordred	05d71fa9b1	Merge pull request #882 from T00fy/master ... case fix for sql changesets	2023-02-09 07:56:32 +01:00
Mordred	3ff6f2b283	fix migration script	2023-02-08 23:11:33 +01:00
Toofy	19c7d44e9e	case fix for sql changesets	2023-02-08 21:42:27 +00:00
Mordred	38b92fafa9	Create and load member lists of fcs.	2023-02-08 15:22:33 +01:00
Mordred	7af6846395	Fc is being loaded and sent to the master character. Member lists not maintained yet.	2023-02-07 14:13:47 +01:00
Toofy	d9192a655e	Fixing error Table 'sapphire.freecompany' doesn't exist	2023-02-03 23:06:56 +00:00
Mordred	f65fb8fba1	fix sql statement	2023-02-03 14:23:39 +01:00
Mordred	a4a2423b84	changed list fields to binary, reduced fields overall	2023-02-02 22:46:51 +01:00
Mordred	b6ce7f5177	added more db tables in regards of fcs	2023-02-02 22:46:51 +01:00
Mordred	68a5040fb9	Class and db table for basic FC representation	2023-02-02 22:46:51 +01:00
Rushi	7e0182028c	Fix more case-sensitive table names	2022-01-25 15:19:07 +01:00
Rushi	899d38a65a	Fix case-sensitive SQL scripts	2022-01-25 15:00:22 +01:00
Mordred	27b218fd78	Removed old code to further simplify warp mechanics	2022-01-16 11:57:04 +01:00
Mordred	f421021497	Update bnpcs to include nonpop flag	2021-12-17 14:53:13 +01:00
Alice Ogeda	3e73da6463	add initial friendlist impl; fix teri crash on login if commonlist is called; fix sql type and initial data on player creation;	2021-12-01 21:30:12 -03:00
Mordred	48ed9da414	Initial commit of Sapphire for FFXIV 3.0 "light rewrite"	2021-11-27 00:53:57 +01:00
Mordred	b17af41e67	Major rewrite of zonelines, aetherytes and discoveries	2019-10-21 23:24:26 +02:00
NotAdam	bd1130fe73	switch from binary to blobs, fix known array sizes in player obj	2019-07-06 15:00:26 +10:00
NotAdam	537abfcf16	add migration functionality to dbm	2019-06-16 00:14:05 +10:00
mordred	8cd18d6a33	Fixed quest complete size, db reinit needed	2019-03-26 09:27:48 +01:00
Mordred	c3700c6231	Update schema.sql	2019-03-25 07:57:25 +01:00
Mordred	be63e25c14	Added sql table for storing hunting log information	2019-03-24 23:49:52 +01:00
NotAdam	6d9ef0e6c3	add missing zonepositions, use move semantics for framework constructor	2019-03-17 13:50:01 +11:00
NotAdam	2743f4483e	remove utf8 bom from inserts.sql	2019-01-18 20:05:45 +11:00
Mordred	a230a2ca2a	Cleaned up some zoning code. Secondly, alot more bnpcs will spawn now	2019-01-14 22:29:52 +01:00
NotAdam	6e6ffc7cf3	fix housing object init structure, game no longer crashes/doesn't load	2019-01-10 20:38:27 +11:00
NotAdam	c03dc6dc80	initial pass to fix housing issues	2019-01-10 15:03:25 +11:00
Mordred	6f0f05eb30	Merge branch 'develop' of https://github.com/SapphireMordred/Sapphire into develop	2019-01-08 17:09:18 +01:00
Mordred	da67f6cae8	Very rudementary spawn implementation and db fix	2019-01-08 17:08:48 +01:00
NotAdam	76ea5d8a27	fix spawnpoint schema causing inserts to fail	2019-01-08 22:37:29 +11:00
Mordred	c1a3fa5915	Extended schema for spawnpoints	2019-01-06 23:34:19 +01:00
mordred	2ed9d84bd0	True out of source build now possible.	2019-01-02 15:09:59 +01:00
mordred	90831ea089	Use sapphire_dbm to initialize the db	2018-12-12 12:07:26 +01:00
NotAdam	795c8280d5	fix db schema so characters get created correctly	2018-12-07 20:12:20 +11:00
Mordred	23226f0e44	Fixed small event issues. Changed sapphire to use new DB setup. Database has to be created using the schema.sql and inserts.sql	2018-12-07 00:06:59 +01:00
NotAdam	60e643dd0e	housing item containers and some minor cleanup/refactoring	2018-12-04 23:00:49 +11:00
AriAvery	7d042d264e	housing instance	2018-12-01 21:40:30 +01:00
NotAdam	7b3a894349	Correct house db column sizes	2018-11-26 23:43:40 +11:00
NotAdam	89c8293eef	New land sql, run update_land.sql	2018-11-26 23:18:16 +11:00
NotAdam	df28bd934c	Remove old tables from update.sql	2018-11-23 17:37:46 +11:00
NotAdam	7f5ea70523	add ul'dah -> goblet warptaxi zoneposition	2018-11-22 01:19:18 +11:00
AriAvery	b188455c3e	D:	2018-11-19 10:32:58 +01:00
XeAri	664ccf2434	Update house.sql	2018-11-16 12:17:42 +01:00
XeAri	c21d9fd9e7	Update house.sql	2018-11-16 12:17:32 +01:00
AriAvery	3443dad247	sql tables	2018-11-16 12:16:08 +01:00
Mordred	a8040d9236	Added land type storage / loading / usage	2018-11-13 19:48:22 +01:00
NotAdam	9d7f3be448	add land/landset sql	2018-11-05 23:04:39 +11:00
Mordred	6fb2765e30	Opps, thanks Squall. ( missing backtick )	2018-10-15 08:16:57 +02:00
Mordred	b622764cf7	Fixed an error in Update.sql	2018-10-15 08:06:39 +02:00