Commit graph

44 commits

Author SHA1 Message Date
Frankie-hz
1ab44d853c [cpp] Fixes underflow in avatar perpetuation 2026-05-11 19:32:47 -04:00
MrSent
ce80dbd2dc Audit and update of pet list and pet skills 2026-03-03 18:16:02 +00:00
MrSent
4dc5020dad Update Summoner and Pet functionality
- Update pets.lua and mob_pool_mods.sql: Add Atomos spawn logic

- Update Pet claiming and failed BP re-engage
2026-02-23 16:24:04 +00:00
Umeboshi
642daafd7a [core][lua][sql] isJugPet() Lua Binding 2026-01-24 07:23:32 -08:00
sruon
5cb4a0aec8 Load pets model size and hitbox from DB 2025-11-29 13:16:32 -07:00
MowFord
381c9e2949
Implement Jug pet: Sweet Caroline 2025-09-10 22:21:35 -05:00
Aeshur
931b4bb86e [sql] Correct jug pet timers 2025-01-23 20:29:34 -05:00
TracentEden
def611a35a Add damage types to pets
Co-Authored-By: Nireya <Nireya@users.noreply.github.com>
2024-02-12 20:18:39 +02:00
Corey Sotiropoulos
f202e592e7 [sql] Speed up Aria table inserts
See:
https://mariadb.com/kb/en/aria-storage-engine/
2024-01-11 22:33:23 -05:00
Zach Toogood
24f35c4c5e [sql] Replace MyISAM engine with Aria 2024-01-04 18:43:36 +00:00
Zach Toogood
ca3bdd22fe [SQL] Add COLLATE=utf8mb4_general_ci to all tables 2024-01-04 18:25:12 +00:00
MowFord
aa30c9ec2e Cait Sith Avatar:
- Cait sith has proper name prefix and named properly to be "Cait Sith" instead of "The CaitSith"
- BPs Implemented
  - Regal Slash (BP:Rage): 3-hit physical
  - Level ? Holy (BP:Rage): aoe magical
    - Rolls a die and does dmg proportional to roll
    - Only does damage if the target's level is divisible by the roll
  - Mewing Lullaby (BP:Ward):
  AoE lullaby that resets TP
  - Eerie Eye (BP:Ward):
  conal silence/amnesia with appropriate elemental resist check for amnesia, but retail does light check for silence
  - Reraise II (BP:Ward):
  single-target 60-minute reraise II buff for any party member
  - Raise II (BP:Ward):
  single-target raise II for any party member
  - Altana's Favor (BP:Ward):
  2-hour ability gives arise to all party members in range
  (Arise and reraise III with infinite duration)
2023-11-07 20:03:20 -06:00
Corey Sotiropoulos
d92c54d1b4 [dbtool] Add function to dump DB to SQL files
Queries database then scans corresponding SQL file, replacing values
in INSERT statements with data from the database.

Is not smart about which INSERT statement gets which data; line-end
comments can get shuffled around if SQL file INSERTs are out of order
or missing. If you're doing INSERT or DELETE operations, make sure
to add a blank "INSERT INTO `table` VALUES ();" or manually remove
the INSERT statement respectively before dumping tables.
2023-08-23 22:50:08 -04:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
Zach Toogood
18c71fc244 [sql] Remove arbitrary sized AUTO_INCREMENT's 2022-10-16 15:33:34 +03:00
WinterSolstice8
e084e1172e [sql] Correct pet Siren mob pool 2022-09-19 23:19:10 -07:00
WinterSolstice8
ff79f1068e [core] [sql] [SMN] add Siren pet, add petskill sql 2022-07-23 23:35:11 -07:00
Zach Toogood
05b1a7f961 [chore] Clean up some formatting in SQL files 2022-07-05 12:49:26 +03:00
TeoTwawki
dd02066118 Convert tables that are never written to back to MyISAM. Only tables we write to need InnoDB.
MyISAM = table level locking, fast but not safe for multiple simultaneous writes
InnoDB = row level locking, slow, but is safe for multiple simultaneous writes

```
Features                            MyISAM                        InnoDB
Type                                Non-Transactional             Transactional
Locking                             Table locking                 Row-level locking
Foreign keys                        No                            Yes
Table, index, data storage          Three separate files          Combined Tablespace
ACID                                No                            Yes
```
2021-11-10 08:09:45 -05: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
ibm2431
055d1fabee Finalize furniture element SQL adjustments 2020-07-10 08:37:28 -07:00
ibm2431
5f111a04c8 Non-item-mod SQL day/element untangling, step 2 2020-07-10 08:37:28 -07:00
ibm2431
7794855df3 Non-item-mod SQL day/element untangling, step 1 2020-07-10 08:37:27 -07:00
ibm2431
45bfc2d4f6
GEO SQL and Header changes (#689)
* GEO SQL and header files

* Spell list additions and cleanup

* Adjust automaton controller to use new effect enums
2020-06-06 02:48:43 +00:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
TeoTwawki
b527bfe52f Revert "Adjust pet ID for Trust: Shatotto, add placeholders for all other trusts (we are all Shantotto!)."
This reverts commit b7deef2d86.
2018-08-19 16:35:58 -04:00
TeoTwawki
b7deef2d86 Adjust pet ID for Trust: Shatotto, add placeholders for all other trusts (we are all Shantotto!). 2018-08-18 19:24:15 -04:00
giroroxi
d2e2830b0f Trusts: Implement summon and release
Casting `Shantotto` will now cause Shantotto to spawn.
She can be released by selecting Release on the menu,
or by using a macro e.g `/refa all`.
2018-04-02 18:29:04 +01:00
ymkc
7135053464 Created seperate mob_pools for SMN spirits 2016-11-18 12:06:06 +00:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
Joshua Maurice
487af64c15 fixing player drg wyvern pet abilities 2015-10-04 20:43:57 -07:00
teschnei
b56de3880c SQL: automaton entries in mob and pet tables 2013-08-27 22:57:40 +00:00
deviltti
8083de40b9 CORE/SQL: Added support for concatenated Chocobo names...when we get there. Also realized that Adventuring Fellows should be handled like Jug Pets and names should be assigned based on mob_pool since the look data is partly determined by race, sex, and face. 2013-06-15 04:59:22 +00:00
Ezekyel38
2ea44d5022 Add Dynamis-Bastok
CORE: add some functions to create instance/enter/add time/leave dynamis
SQL: add all positions of statue in dynamis but many disappeared due to the last dynamis update of the official server (their names are "NPC")
GM COMMANDS: adddynatime <number>

Conditions to enter in dynamis : rank6, lvl65+, cs at xarcabard & bastok mines)
Conditions to reenter in dynamis : wait 1 real day (at midnight)
2012-08-31 15:18:58 +00:00
teschnei
10d8fcccfd JOB ABILITIES:
-summons will now have perpetuation cost, reduced by appropriate equipment
JOB TRAITS:
-auto-regen and auto-refresh will now apply
2012-08-14 01:32:41 +00:00
kegsay
0646343662 PET UPDATE : Jug pets can now be commanded to use a TP move using Sic (provided they have enough TP).
Also fixed a bug with pet zoning causing a crash (hopefully) and fixed the issue whereby pets would disappear when first hit. Also fixed an issue whereby zoning would cause an untethered pet (pet with no master). Added a new GM command @pettp 123 which sets your pet's TP to 123% (provided you have a pet out). Finally, corrected the Antlion model so it's correct.
2012-05-17 15:15:24 +00:00
kegsay
fd282d0302 PET UPDATE : DRG Wyverns now work, including using breath moves. Fixed some bugs, added some stuff, check the details.
Details: [FOR SUMMONERS] Fixed the avatar models so they are the correct sizes and also re-enabled Diabolos. For a LIMITED TIME ONLY, you can summon Alexander and have him fight for you, though there's no attack animations for the big guy. Odin is not in this as you must target a monster to summon him. Also fixed an issue whereby the pet commands wouldn't disappear when you release a pet. [FOR DRG] Added in pet wyverns (default name 'Wyvern'). They will assist your current battle target just like on retail. They will also use a breath move depending on your subjob and ability you use. Use a weaponskill to get your wyvern to use an elemental breath (offensive/hybrid wyvern only). Use a spell to get your wyvern to use a healing breath (if you're under 33% or 25% HP for defensive/hybrid wyverns respectively). 

SQL UPDATES
You must update spell_list.sql to add in Alexander. You must update mob_pool and mob_skill and pet_list for the correct models+wyvern abilities.
2012-05-15 01:45:58 +00:00
diatanato
199aa02d14 SQL : pet_list - имена питомцев без пробелов 2011-12-29 09:10:33 +00:00
K4NZ3N
78d61e53c0 ADDED pet constants and BST jug pets to the DB 2011-12-28 23:59:19 +00:00
onetimeffxi
7a160120a7 2011-09-16 15:56:24 +00:00