Commit graph

319 commits

Author SHA1 Message Date
ibm2431
066195db8c
Merge pull request #410 from mrhappyasthma/wyrdstrand
Add the `BaseSell` value for Spool of Wyrdstrand.
2020-03-25 16:52:13 +00:00
wrenffxi
fe6c76ef99 [version update] 30200304_3 2020-03-15 13:32:42 -04:00
MrHappyAsthma
776cb2b06b Add the BaseSell value for Spool of Wyrdstrand.
Fixes https://github.com/project-topaz/topaz/issues/187

To apply this change, either run the `sql/item_basic.sql` file, or
just manually apply the following:

```
UPDATE item_basic SET BaseSell = 1319 WHERE name = "spool_of_wyrdstrand"
LIMIT 1
```
2020-03-11 00:27:12 -07:00
wrenffxi
04bfdac72f [version update] items 2020-02-25 18:51:52 -05:00
project-topaz
3df25d5215 Commits from upstream, 2020/01/14 to 2020/01/31 2020-01-31 17:43:44 -08:00
kaincenteno
64ce48ef87 Updated Stack size
Updated stacks from 12 to 99 on items of September 2019 update. *

* http://forum.square-enix.com/ffxi/threads/55899-September.-10-2019-%28JST%29-Version-Update
2020-01-13 21:15:53 -08:00
Topaz
aa6e168add Commits from upstream, 2019/12/11 to 2019/01/13 2020-01-13 10:25:10 -08:00
Kain
a142cd9fe6 Missing stackable items from 10OCT2019 update (#6367)
Stacks to 99:
Gyshal Greens
Pungent Powder
Prize Powder
Pungent Powder II *
Pungent Powder III *

http://forum.square-enix.com/ffxi/threads/55997-October.-10-2019-%28JST%29-Version-Update

* Error in SE side as prize powder II and III don't exist, they meant pungent powder II and III
2020-01-12 10:25:35 -07:00
m241dan
8484a678ab PR: New scrolls for the old merit spell (#6358)
* PR: SQL: Added item support for old RDM, BLM, and NIN merit spells

 - Added the 20 usable scroll items
 - Made it so the spells could be learned through scroll

* PR: Lua: Scripted the RDM, BLM, and NIN merit scrolls

* PR: Lua: Hasim, Susu, Sholby now stocked with missing scrolls
2020-01-09 18:45:03 -07:00
kaincenteno
f02e0cd16d Added Pyropox shop in Port Jeuno and fixed Kindlix charvar
Added Pyropox script and updated Port Jeuno IDs for her dialog.
Added initial charvar for both Kindlix and Pyropox on char creation.
Once player talks to them for first time, charvar is set to zero.
Fixed resell prices for items sold by Pyropox to match retail.
2020-01-03 08:28:19 -08:00
kaincenteno
f428442b99 Added Kindlix shop in Port Jeuno
Added Kindlix script and updated Port Jeuno IDs for her dialog
Decreased sell price for sparkling hand and crackler to match retail
2019-12-27 00:27:25 -08:00
wrenffxi
e6344ced9b [client update] items 2019-12-18 18:17:40 -05:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
wrenffxi
fbb72b54f2 [item qc] stack size, flags 2019-11-16 04:52:16 -05:00
wrenffxi
71f68dd376 [version update]
* Increased stack size on many items.
* Added 2 items to item_basic.sql
* Added 1 new title
* NPC ID shifts in 1 zone.
* Text ID shifts in 1 zone. Adjusted several TextID comments for matching.
* version.info
2019-10-17 22:18:33 -04:00
kaincenteno
ef1826be40 Removed guild shops that are open 24 hours from SQL and moved them
to tables inside shop.lua

Added generalGuild function in shop.lua to work with the guild vendors
that are open 24 hours. Log is set to -1 by default as there's no price
change

Lowered sell price for Mandrel as it's being sold for a cheaper price
2019-09-23 21:58:37 -07:00
wrenffxi
c6ed18e130 [2019-AUG-12 Client Update]
* no significant textID shifts
* minor npcID shifts
* added title, item
* zone Maquette_Abdhaljs-Legion is now Maquette_Abdhaljs-Legion_A
* added zone Maquette_Abdhaljs-Legion_B
* version info
2019-08-13 12:06:33 -04:00
wrenffxi
d405adb1b6 [Client Update] items, titles, textId, npcId, version 2019-07-11 14:52:07 -04:00
Zynjec
78d74a96d7
Merge pull request #6076 from TeoTwawki/guild-trash
Add some missing items to Windurst Waters Cooking guild: Miso, Soy Sauce, Dried Bonito
2019-06-24 21:30:38 -04:00
TeoTwawki
1726d0b5ca
Merge pull request #6059 from helixhamin/item_equipment_21747+
Add item equipment and mods for items 21673-21956
2019-06-20 23:00:34 -04:00
wrenffxi
e8b245ea61 [version update] item_basic 2019-06-16 14:29:39 -04:00
TeoTwawki
c310470be0 Add some missing items to Windurst Waters Cooking guild: Miso, Soy Sauce, Dried Benito
(mmm Ramen..)
2019-06-10 21:16:11 -04:00
helixhamin
73df8f62b2 Add item equipment and mods for items 21673-21956
Also did some cleanup of the item latent and added a couple latents.
2019-06-11 09:05:30 +08:00
helixhamin
013dbc1024 Revert name changes for those with a . in the name
Also updated the price for item 5677 (patriarch saute)
2019-06-03 13:44:17 +08:00
helixhamin
1f2781822d Added and fixed some item_equipment.sql entries.
Added mods for those also.
Please note, the changes to item_latents.sql is just moving things around so they are laid out more logically. I limited it to the first 200ish lines so as not to overwhelm a reviewer.
Also fixed some further misnamed items, and some mistakes in the item_usable.sql (No lua scripts here changed other than matching the name with the name fix in the appropriate sql table)
2019-06-03 09:42:58 +08:00
TeoTwawki
6dd3c0e990 This item was never attainable on retail so I'm wonder where this base sell price came from. 2019-05-29 07:57:07 -04:00
Julian Wechsler
045c5fe41c Fixed id's, added new items in item_basic that were missing to item_equipment, ran sql scripts successfully this time. 2019-05-19 23:05:27 -04:00
Julian Wechsler
2f6de1ed30 fixed item id 2019-05-19 22:54:45 -04:00
Julian Wechsler
5c41fa0e44 added missing items to item_basic and item_equipment 2019-05-19 16:56:49 -04:00
wrenffxi
05b9e218ce [client update] items 2019-05-13 16:18:25 -04:00
helixhamin
8bbcd70cba Add all missing item_basic, and fix some AH categories for items able to be sold on the AH.
This adds the last of the missing items to item_basic.sql, but there are still many errors from past additions that I will fix later. There is enough change here as it is...

Most items still need added to other SQLs (item_equipment, item_weapon, item_mods, etc) before the items do more than just exist.
2019-05-09 11:26:41 +08:00
helixhamin
ba85a62299 Added items and item stats (item mods/latents) to items 21579 to 21682
Fixed the -2% damage for item 21373:
https://www.bg-wiki.com/bg/Sihirik (Used the wrong modid)
Fixed the mistakes I made in altanas_repast_+1.lua and altanas_repast_+2.lua (Incorrect itemid)

All added weapons should now be equippable and should give most mods/latents. Any mods/latents that cannot be used are commented in the appropriate file.

Please note, all Dynamis (D) latents are unavailable. The mod for Dynamis (D) still needs to be created before effects can be implemented (Please check the last area for the item_latents.sql file for all items currently created with additional Dynamis (D) latent effects)
2019-05-06 16:09:12 +08:00
TeoTwawki
5bc9fa1bf4
Merge pull request #5913 from isotor/vendor_prices
Update a bunch of vendor prices, majority low cost exploitable
2019-05-05 12:52:03 -04:00
helixhamin
ef3dcee49d Add a couple items
Some food
And even a new WS!

Try this again...

(Not sure how Fenian Ring Shield Bash +50 got deleted...
I put it back!!!)
2019-05-03 16:04:50 +08:00
isotor
b05b8b34f6 Update a bunch of vendor prices, majority low cost exploitable 2019-05-02 10:16:43 +03:00
helixhamin
7249b1f3f7 Fix incorrect flags
Information based on POL Utils.
2019-04-30 17:42:16 +08:00
helixhamin
8561310454 Add more missing items, missing weapons, missing armor (item_armor for weapons), missing furniture, and corrected some pup attachments. 2019-04-22 17:10:02 +08:00
TeoTwawki
e0c7b0fe2f
Merge pull request #5862 from helixhamin/Missing_items_2_branch
Add ilvl 119 Mnk/Pup items
2019-04-19 10:21:11 -04:00
helixhamin
4afeb513ca Add ilevel items and a couple others (And some slight fixes to others) 2019-04-19 18:10:52 +08:00
helixhamin
2105d13132 Added missing item_basic up to item 21514.
Still need to verify missing items after that.
2019-04-17 17:37:34 +08:00
Julian Wechsler
da743c03aa Added a few missing items, added missing model ID's, fixed incorrect model ID's, added script for shadow lord shirt 2019-04-02 22:05:22 -04:00
wrenffxi
0b50dfe0cc [version update] items 2019-03-11 19:00:58 -04:00
wrenffxi
0324f1333f item names, item_basic 2019-02-10 10:26:20 -05:00
wrenffxi
7fdc5bf18f (30181222_1) Items 2019-01-10 05:48:48 -05:00
ShelbyZ
1a3ee2a75d BaseSell higher than shop sell price
- This would allow players to buy low and sell high adding gil to the
economy
2019-01-01 11:16:22 -08:00
Tahir Akhlaq
d5ac1d06a7
Merge pull request #5529 from TeoTwawki/meepmeep
adjust resale price of scroll_of_herb_pastoral to plug an exploit
2018-12-31 22:06:01 +00:00
TeoTwawki
d835e51ffa adjust resale price of scroll_of_herb_pastoral to plug an exploit 2018-12-31 16:12:43 -05:00
nfaletra
f26bf672f4 Add sub ids to the spells and fix their dumb flags 2018-12-31 09:07:26 -07:00
Zynjec
94ce3c3dee
Removed EX items from auction house 2018-07-04 12:04:36 -04:00
Tahir Akhlaq
cc0f333bfe
Merge pull request #4970 from helixhamin/Puppet_attachment_update_and_addition
Update the item_basic.sql and item_puppet.sql to include all current …
2018-06-27 12:37:56 +01:00