WinterSolstice8
cb0c7607d0
[core] [lua] [sql] Destroy nameflags and replace with a more sane system
...
Co-authored-by: atom0s <atom0s@live.com>
2024-04-19 20:53:02 -06: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
Zach Toogood
c4eae7c92e
[sql] Update mhflag to be uint16
2023-01-19 22:32:19 +00:00
jmcmorris
3882e4a295
Add tracking of pet's spawn level
2022-11-07 16:56:58 -08: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
joncloud
59f841ea71
Updated pet respawn on zone to be based upon the pet's HP instead of storing a boolean flag.
2015-04-13 18:48:13 -07:00
joncloud
629ad05d37
Added columns to persist pet zoning information to allow pets to follow masters while zoning. Fixed #1286 .
2015-04-13 18:23:14 -07:00
Alex Goolsby
7c82a4d0fd
SEARCH/CORE: store active job levels in db for search fixes #1095
2015-03-21 02:38:53 -04:00
teschnei
c17fa8c009
CORE: allow game server to tell apart zoning from logging in/out, fixed losing EFFECTFLAG_ON_ZONE when logging out
2014-12-31 15:24:59 -07:00
atom0s
0fecd349e8
SQL: Fix for default blob values.
...
CORE: Adjust the loading of bazaar messages to account for null entries.
2014-04-06 19:32:59 -07:00
whasf@dspt.info
f08d375513
SQL: Fix for creating a new character
2014-04-05 09:51:01 -04:00
atom0s
d3f84c2870
SQL: Changed bazaar message to use BLOB to allow auto-translate strings.
2014-04-04 11:55:34 -07:00
diatanato
f4ac14b67d
SQL: refactoring - chars
2012-10-25 15:15:09 +00:00
diatanato
958cbff2a0
в таблице char_stats будут храниться время смерти и время использования 2h способности
2012-01-29 18:18:43 +00:00
diatanato
4c7e229ac6
всего понемногу (возможна некоторая нестабильность версии)
...
- система чтения магии никуда не годится. удалил все, оставил только анимацию
- trigger для delivery_box
- новая система recast_time (еще не финал)
- сообщение bazaar теперь хранится в char_stats
- питомцы, нанося удары, оставляют на цели id хозяина
P.S. обновление таблицы char_stats без удаления персонажей - ALTER TABLE `char_stats` ADD `bazaar_message` VARCHAR(120) NOT NULL DEFAULT '\0' AFTER `title`;
2012-01-09 19:33:35 +00:00
diatanato
c9160c7a79
SQL: char_stats - new column "mhflag"
2012-01-03 17:13:32 +00:00
onetimeffxi
7a160120a7
2011-09-16 15:56:24 +00:00
