/
NLObP
/
AAEmu
ОбзорДокументацияВойти
/
NLObP
/
AAEmu
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
ДокументацияПоддержка
Политика конфиденциальностиПользовательское соглашениеПолитика использования «cookies»Согласие субъекта персональных данных
2026 ©
AAEmu/
SQL/updates/
..
2019-02-04_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-02-11_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-02-12_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-02-18_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-02-27_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-02-28_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-03-06_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-03-09_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-03-13_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-03-16_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-03-20_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-03-23_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-05-07_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2019-09-07_aaemu_game.sql

[Game] -add: marking deleted characters as deleted (#79)

7 лет назад
2020-04-29_aaemu_game_auction_house.sql

[SQL] updated table Items with field "bounded"

6 лет назад
2020-04-30_aaemu_game.sql

[Game] exclude Training Scarecrow from move objects [SQL] fixed database CHARSET=utf8mb4 to utf8

6 лет назад
2020-04-30_aaemu_game_items.sql

[Game] Fix: Chat channels

6 лет назад
2020-05-09_aaemu_game_items.sql

[Game] fix: Various

6 лет назад
2020-05-10_aaemu_game_mails.sql

[Game] update: wip ItemManager

6 лет назад
2020-05-14_aaemu_game_items.sql

[SQL] fixed: Items table

6 лет назад
2020-05-16_aaemu_game_auction_hourse.sql

Fixed sql file.

6 лет назад
2020-05-25_aaemu_game_auction_house.sql

db updates

6 лет назад
2020-12-04_aaemu_game_auction_house.sql

containerizes AAEmu.Login and AAEmu.Game services; updates docker-compose configuration to build&start services and db with a single command (#267)

5 лет назад
2020-12-09_aaemu_game_accounts.sql

Genesis public branch merge (#263)

5 лет назад
2020-12-09_aaemu_game_items.sql

[Items] CrafterId (#232)

6 лет назад
2020-12-10_aaemu_game_doodads.sql

Genesis public branch merge (#263)

5 лет назад
2020-12-10_aaemu_game_hostile_faction_kills.sql

Genesis public branch merge (#263)

5 лет назад
2020-12-10_aaemu_game_housing.sql

[SQL] Fixed two typos (#233)

6 лет назад
2020-12-26_aaemu_game_fix_world_id.sql

Genesis public branch merge (#263)

5 лет назад
2021-04-10_aaemu_game_ucc.sql

[UCC] Begin work, add "basic" UCC upload by Gene.

5 лет назад
2021-07-11_aaemu_game_transform.sql

Transform RC2 (#282)

5 лет назад
2021-07-15_aaemu_game_furniture.sql

[Game] Housing, Furniture and Backpacks (#283)

5 лет назад
2021-07-21_aaemu_game_transform.sql

[Game] New character spawn update (#286)

5 лет назад
2021-09-11_aaemu_game_ucc.sql

[Game] UCC (#346)

5 лет назад
2021-09-23_aaemu_game_music.sql

[Game] Music (#347)

5 лет назад
2021-11-12_aaemu_game_index_fix.sql

[SQL] Fix indexes (#351)

5 лет назад
2022-02-10_aaemu_game_characters-return_district.sql

[SQL] Updates table characters;

5 лет назад
2022-02-18_aaemu_game_characters-create_at&update_at_fix.sql

[Game] WIP: Doodad bug fixes: - Initialization of all doodads during spawn; - Fixed the work of the quest to obtain the pet and chopping trees (animation is correct); - Fixed infinite doodad spawn Id=7202 'Golden Ruins Whirlpool'; - Reduce doodad logs (to Trace); [Game] Added some checks on NULL; [DATA] Updated doodads & Npc: - corrected the height of NPC 'Maison' & doodad 'Golden Ruins Whirlpool'; - corrected the rotate of the painting in the house in Hatora; [Game] Fixed logout updatedAt and createdAt in Characters Table;

4 года назад
2022-05-14_aaemu_game_item_containers.sql

[Game] Persistent ItemContainers (#415)

4 года назад
2022-07-07_aaemu_game_coffers.sql

[Game] Coffers (#459)

4 года назад
2022-07-08_aaemu_game_doodad_data.sql

[Game] Coffers (#459)

4 года назад
2022-07-28_aaemu_game_expire_item.sql

[Game] Items with expiration date and limited buff effect times (#486)

4 года назад
2022-09-22_aaemu_game_mail_text.sql

[SQL] Changed mail text and title (#527)

4 года назад
2022-09-23_aaemu_game_characters_experience.sql

Added User Secrets support + Moving files + Documents (#728)

3 года назад
2023-10-08_aaemu_game_slaves.sql

[Game] Tradepack and Slave related update (#765)

3 года назад
2024-02-16_aaemu_game_ics.sql

[Game] In-Game cash shop rewrite (#826)

2 года назад
2024-03-11_aaemu_game_item_containers.sql

[Game] Mount/pet Equipment by cipherxof; (#832)

2 года назад
2024-05-04_aaemu_game_slaves_update.sql

[Game] Fixed persistent Vehicle saving (#917)

2 года назад
2024-05-10_aaemu_game_account_update.sql

[SQL] Additional update to previous update script (#926)

2 года назад
2024-06-14_aaemu_game_doodads_update.sql

[Game] WIP: Community Farms; (#975)

2 года назад
2024-07-10_aaemu_game_jury_points.sql

[Game] Implemented JuryPoint saving (#1005)

2 года назад
2024-08-04_aaemu_game_online_time.sql

[Game] Added online time tracking (#1061)

2 года назад
2024-10-29_aaemu_game_auction_house_update.sql

[Game] auction refactoring: (#1098)

2 года назад
2024-10-30_aaemu_game_auction_house_update.sql

[Game] auction refactoring: (#1098)

2 года назад
2024-10-30_aaemu_game_item_containers_update.sql

Hotfix/fix items item containers (#1100)

2 года назад
2024-10-30_aaemu_game_items_update.sql

Hotfix/fix items item containers (#1100)

2 года назад
2025-02-05_aaemu_login_ban_basics.sql

Improved Ban System, added update SQL script

2 года назад
2025-02-15_aaemu_game_audit_char_sus.sql

[Game] Add Audit table for suspicious characters (#1184)

год назад
readme.txt

[Game] Fixes doodad related timings (#744)

3 года назад
readme.txt
When your code update needs any changes to the MySQL tables, you will need to put a update script here, and also apply it in the initial sql files one folder up from here.
Files need to be named in the following format;
 
YYYY-MM-DD_aaemu_XXXX*.sql
 
Where YYYY-MM-DD is the date you introduced this change, and "XXXX" is either "login" or "game".
These scripts will get executed only one time at the start of running the Login or Game server. Installed scripts get logged into a updates table to the relevant to the server it's running for.
A server will only check and run scripts that are relevant to themselves, therefor the naming of the files is important.
 
When running a server that supports this new update system for the first time, it will assume that all related scripts in this folder were already installed, and will be marked as such.
 
The date part is technically not required, but it is used to handle update order, so please keep it consistent.