Commit graph

319 commits

Author SHA1 Message Date
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
NeuromancerXI
950fc1f982 [LUA/SQL] Item and Key Item ENUM updates
Adds KI 3269 -> 3346
Adds Item ENMs for Mog Kupons
Adds item_basic entries for Mog Kupons
2023-12-10 08:57:33 -08:00
claywar
2bde44bf02
Merge pull request #4676 from CatsAndBoats/rdm_augment_convert
Fixes "Augment Convert" effect on Murgleis.
2023-11-06 18:24:05 -05:00
Aeltorian
d8e7952a59 Fixes "Augment Convert" effect on all Murgleis weapon variations 2023-11-05 11:51:46 -05:00
TeoTwawki
4bac6870a7 Remove a few out of many guild items that do not belong at all
https://github.com/LandSandBoat/server/issues/1191#issuecomment-1793498084
2023-11-04 13:28:12 -04:00
claywar
f79d5cc0fe
Adjust prices of failing SQL entries
Remove comment

Only log on failure

Handle comments in item_basic
2023-11-04 08:10:08 -04:00
claywar
a8b6ebe663
Add magian minDamage example and some Anarchy trials
Retain weaponskill information if skillchain is formed
2023-09-12 14:42:35 -04:00
claywar
faa01f8389
Add gainExp listener to Magian Trials with example
Pass PMob back into Lua from EXPERIENCE_POINTS listener
Add additional safety to checkKillCredit

Fix logic, syntax in command

Fix shadowing in wyvern.lua
2023-09-10 11:15:06 -04:00
claywar
777c06be24
Add additional magian items to enum, adjust db names, add H2H trials 2023-09-10 08:09:50 -04: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
Xaver-DaRed
478fd9ece7 Make distinction between starting scrolls (exclusive) and regular ones 2023-08-15 17:51:55 +02:00
Delaide
b41626e82d
[SQL] Add some missing item_equipment and item_weapon entries. Fix some incorrect MIDs
With corrections to item_basic.sql
As per the previous PR request, single space between EOL and comment.
2023-08-14 21:31:38 -04:00
Corey Sotiropoulos
4a155316a6 Remove AH categories from items flagged NOAUCTION 2023-08-13 17:26:28 -04:00
claywar
d444dfc1c3
Use unique names for magian upgradeable items in item_basic 2023-08-08 09:54:43 -04:00
claywar
332b280e6c
Add onTrade logic, pearl prizeRank lookup
Fix issues with reward ranks in onTrade


Fix byte order for pearl number and item flags


Add purchase reward event finish
2023-07-29 08:37:03 -04:00
claywar
5b881a73d5
[db/enum] Add missing entries from Mog Bonanza 2023-07-28 18:35:45 -04:00
claywar
7ffd794220
Fix vendor sell price of Platinum Arrowheads 2023-07-16 14:36:32 -04:00
Helix Hamin
9ab598484f To make it easier, splitting this submission
This adds missing equipment to item_basic.sql. I will submit the item_equipment, item_weapon, etc separately.
2023-07-10 16:29:15 +08:00
NeuromancerXI
b7961e84ee Mog Kupon AW-UW / AW-UWII / AW-UWIII
* Updated items/dealer_moogle
* Corrected name for gazu_bracelets/+1 in item_basic and item_equipment
2023-06-20 08:39:07 -07:00
NeuromancerXI
8091d229e3 Mog Kupon AW-Mis
* dealer_moogle, items additions
* Typo correction for venery_bow in item_basic
2023-06-20 08:39:06 -07:00
NeuromancerXI
76a2728314 Expand Dealer Moogle Plumbing
* Adds in missing Mog Kupon Item/Key Item IDs
* Updates Mask Generation Function to apply appropriate bit shifts
* Updates Trade logic to account for scenarios where player may already have the Key Item corresponding to the Traded Item
* Updates comments to detail script behavior
* Adds Kupon IDs to xi.items
* Flags all Mog Kupon Items as non-vendorable
* TODO: Add in the items for each respective Kupon (WIP)
2023-06-20 08:39:05 -07:00
NeuromancerXI
c8e3ca13e3 Vendor buyback prices 2023-06-05
Priced obtained via Challoux in Port Jeuno.
2023-06-05 13:53:35 -07:00
Era-Lusiphur
41263b1d22 Item flag, NoSale, AH category, BaseSell, and stackSize adjustments 2023-04-18 09:48:06 -04:00
Zach Toogood
12bb5e1f09 [update] Update enums and db for Phuabo mount 2023-03-13 00:17:21 +00:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
claywar
209ea9a09f
[chore] Align Reforged AF+2/3 names with polutils 2022-12-18 08:49:49 -05:00
Zach Toogood
b671f76b4a Add missing mounts as of Nov22 update 2022-11-10 23:52:05 +00:00
Graves
0075ba159f
Spark vendor items adjusted the NPC sell prices to reflect retail (#2548)
* Spark vendor items adjusted the NPC sell prices

bought every item from 1-39 from sparks vendor on retail and sold to  the fameless NPC. i also have pictures of every price as well if needed but will post a couple to show for proof

* got rid of the extra ``

got rid of the extra lines
2022-08-17 05:10:01 -04:00
Illzbee
74c3e8a5aa BaseSell from retail
captured BaseSell from retail
2022-07-26 22:33:00 -04:00
WinterSolstice8
170fea1cb8 [sql] Audit prices of arrows/quivers/toolbags/ninja tools/shurikens/shuriken pouches
Co-authored-by: UynGH <102221430+UynGH@users.noreply.github.com>
2022-07-23 08:49:57 -07:00
claywar
7fbbc9f21c
Correct spell ID for Lhe Cipher Item 2022-07-17 17:08:20 -04:00
claywar
d8cee9de7a
[chore] Remove parentheses from usable item names 2022-07-17 07:38:16 -04:00
Aurasplash
ad200dfb61 Yngvi Choker
This was renamed and as it is RA/EX it should not be on the AH.
2022-07-12 09:59:16 -06:00
EpicTaru
7ad7efa89f Corrected AH category for Hajduk Ring/+1
Two rings, alone in a sea of earrings, now they can be reunited with their brethren!
2022-06-14 19:06:43 -05:00
Xaver-DaRed
a36cf7a8e8 Audit Item mods + other db tables
Co-authored-by: Hinekri <Hinekri@users.noreply.github.com>
2022-06-14 15:26:43 +02:00
Zach Toogood
53214d42e5
Merge pull request #1853 from neuromancerxi/vendor_prices
Vendor Price Data - 2022-05
2022-06-10 15:07:54 +03:00
NeuromancerXI
f3e60de558 Add comment recommending use of a fame neutral NPC 2022-06-09 14:07:02 -07:00
Xsoulsin
8871700af2 Update locations for gear
Update locations for the gear
2022-06-06 20:26:50 -07:00
Xsoulsin
f5fc19cc26 Gear Update
Added in gear updates for lvl 99, Missing Mods, Equipment
2022-06-06 18:23:50 -07:00
NeuromancerXI
c3eb7be44e Vendor Price Data - 2022-05
Retail vendor prices captured during May 2022 Return Home Campaign.
2022-06-01 05:40:16 -07:00
WinterSolstice8
4ef264c10d Make Crusade & Foil scrolls usable 2022-03-20 19:36:33 -07:00
Zach Toogood
ead8ed79a1 [mount] Add Byakko Mount 2022-03-11 08:35:57 +02:00
Kayanesa
993d3107b4
[Synth] updated items from 35523 to 34541 for issue #885 (#1376)
* [Synth] updated items from 35523 to 34541 for issue #855

Updated items from 35523 to 34541 for issue #855
Also created missing item skrymir_cord and skrymir_cord +1 from both item_basic and Item_equipment

* Re-roder synth item, added gear and stat for Skrymir cord

* Update following recommendation

* Changing  mistake to Skrymir cord

* Udate skrymir_cord flag

* Adding info to comment

* Reformating
2022-03-09 13:23:33 -05:00
RuthlessMortal
f9babf981b
SQL Gear Update (#1251)
* Gear Update

Gear that was missing mods or was not able to equip

* Update item_mods.sql

Update for Space

* Update item_mods.sql

Space Update

* Gear Updates

Added some Odyssey Gear that was missing mods or could not equip

* Update item_mods_pet.sql

* Update item_mods.sql

* Add what is missing

Added back forgot the space first time. Not able to find Mod at this time.

* Remove the Space

Removed the space that was not needed
2022-02-09 10:03:18 -05:00
TeoTwawki
bde5dbfe86 Merge branch 'base' of https://github.com/LandSandBoat/server into history/November-2021-ID-Updates 2021-11-28 13:14:16 -05:00
claywar
b2e26a5863
Merge branch 'base' into base 2021-11-26 16:38:01 -05:00
Xaver-DaRed
0e2a1215b8 Fix item_basic table manual import 2021-11-22 15:15:57 +01:00
Helix Hamin
ddca4501b4 Add some missing items, weapons, mods, etc.
Giving up on trying to complete the list this time around, before something comes in and messes up what I have done so far...

Also, added require("scripts/globals/items") to the item luas, and added the new use items to items.lua.

Update: Fixed the item luas to change the item id to the item name after adding to items.lua.
2021-11-19 14:33:36 +08:00
Zach Toogood
698c40bd30 [client update] add Iron Giant mount and some new KIs 2021-11-10 18:29:13 +02:00