Commit graph

19 commits

Author SHA1 Message Date
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
Zach Toogood
05b1a7f961 [chore] Clean up some formatting in SQL files 2022-07-05 12:49:26 +03: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
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
teschnei
facdb1084f CORE: reworked all items extra data into one field
added weight/length/ranking indicators to fish
fixed various WS trial unlock weapons' latent effects not functioning properly
fixed skillchains not giving as many WS points as they should
2015-01-02 21:49:37 -07:00
diatanato
4f68013e86 CORE: FIX for AI (npc is not BattleEntity) and Augments (only armor can be augment) 2013-06-18 10:23:15 +00:00
addnad
1dc3785621 CORE/SQL: Adding the basics of the augment system. THIS MODIFIES CHAR INVENTORY, BACKUP YOUR INVENTORY TABLE.
This also modifies @additem to allow for additional arguments: @additem itemid quantity augment0 augment0value augment1 augment1value augment2 augment2value augment3 augment3value
If an augment value isn't supplied, it is assumed to be 0.
2013-06-15 05:56:16 +00:00
teschnei
865ff3252d CORE: revised linkshell names - added Encode/DecodeString to convert between regular strings and 6bit character strings
delivery box: some more changes to cancel the correct item when canceling items
DATABASE: changed signature and linkshell name - they are now stored as plain text and can be freely modified via queries
2013-05-05 05:33:03 +00:00
addnad
e523ca0a04 Contrary to popular opinion, I'm not dead. Or undead.
This patch should fix new linkshells (bug 795) AND crafting signatures. 
WARNING: THIS PATCH CHANGES SQL SCHEMA, BACK UP YOUR DATABASE FIRST.
2013-04-19 06:56:22 +00:00
Ezekyel38
682144d7cd CORE add new function for BCNM item and testimony, createWornItem() and hasWornItem()
LUA: update bcnm.lua, now you can use orb and testimony only one time
DB: update char_inventory.sql
2013-01-20 23:22:07 +00:00
diatanato
f4ac14b67d SQL: refactoring - chars 2012-10-25 15:15:09 +00:00
diatanato
9a3e278c9b - DSGame-server обновлен для работы с клиентом v30120208_8
- начало работ над linkshell
- начало работ над обменом между персонажами (trade)
2012-02-19 16:07:14 +00:00
onetimeffxi
7a160120a7 2011-09-16 15:56:24 +00:00