Commit graph

14 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
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
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
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
7bd3d7c822 CORE: refactor delivery box
follows retail formula more accurately
fixed send box not starting from mog house
fixed canceled items not being left in the send box if not taken
added 'extra' column to preserve charges, signature, fish weight/length, etc to items being delivered
increased slot size in database to help stop a delivery box from being overflowed
2015-01-05 22:19:18 -07:00
atom0s
83b1d0d2fc SQL: Changed delivery_box.sql back to InnoDB because it is using transaction commands. (See rev. 1620; Thanks deviltti for spotting that.) 2014-01-09 19:25:14 +00:00
atom0s
d91549b194 SQL: Changed all tables to use MyISAM for much improved import / query times.
SQL: Changed all tables to use the charset of utf8.
2014-01-09 03:20:52 +00:00
teschnei
f9c61bf0f3 CORE: send item packets and logic
SCRIPTS: delivery NPCs
DATABASE: delivery updates
2013-04-15 22:58:38 +00:00
samuel.l.hyman
c6e46cca53 Delivery Boxes.
IMPORTANT NOTES: 
* Update the delivery_box table to use InnoDB as the engine or you will not have transaction support!

CORE:
* Added transactional methods to the Sql_* API
* Added/Fixed logic to allow delivery box drops and returns. (Take already worked)

DATABASE:
* Changed delivery_box to use InnoDB for transactional support.
2012-08-15 02:43:14 +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
c36e682222 DeliveryBox: частичная реализация получения почты 2011-12-26 16:05:20 +00:00