mmo-ref/landsandboat
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
41844 commits 75 branches 0 tags 1.3 GiB
Commit graph

65 commits

Author SHA1 Message Date
sruon
6bf63da04d Linkshell vendors converted to lua 2026-06-18 18:36:07 -06:00
sruon
809edb261a Chip Goblins guild shops converted to Lua 2026-06-18 01:28:32 -06:00
Xaver
220e2a6791
Merge pull request #10349 from sruon/akamafula_shop 
[lua, sql] Akamafula converted to standard shop
 2026-06-18 08:42:42 +02:00
sruon
70f316d2a0 Akamafula converted to standard shop 2026-06-18 00:13:53 -06:00
sruon
f1a47645ea Yabby Tanmikey guild shop converted to Lua 2026-06-17 21:21:09 -06:00
sruon
bdae3da585 Kopopo guild shop converted to lua 2026-06-15 16:20:36 -06:00
sruon
65202a708e Mep Nhapopoluko Guild Shop converted to lua 2026-06-15 16:14:45 -06:00
sruon
b4dd0af85c Amulya Guild Shop converted to lua 2026-06-13 20:27:47 -06:00
sruon
2e1ac6e323 Lua-driven Guild Shops 2026-06-12 17:49:39 -06:00
Lance-XI
2c2ca20d03 [sql] Update pseudo guilds and clean-up 2026-02-16 22:45:53 -05:00
Lance-XI
fc758a3050 [sql] Update quantity of items sold by Tenshodo guild 2026-02-12 20:44:22 -05:00
Lance-XI
d676d817f6 [sql] Update quantity of items sold by Fishing guild 2026-02-08 13:54:23 -05:00
Lance-XI
11fae471ea [sql] Update quantity of items sold by Woodworking guild 2026-02-06 23:56:47 -05:00
Lance-XI
90707ef70b [sql] Update quantity of items sold by Smithing guild 2026-02-05 22:39:24 -05:00
Lance-XI
4246fc4d19 [sql] Update quantity of items sold by Cooking guild 2026-02-04 21:11:38 -05:00
Lance-XI
b741c57ff0 [sql] Update quantity of items sold by Leathercraft guild 2026-02-03 20:44:09 -05:00
Lance-XI
1b7c3f81ab [sql] Update quantity of items sold by Goldsmith guild 2026-02-02 22:48:29 -05:00
Lance-XI
36a86a1b25 [sql] Update quantity of items sold by Clothcraft guild 2026-02-01 15:16:39 -05:00
Lance-XI
622a3794fc [sql] Update quantity of items sold by Bonecraft guild 2026-02-01 01:07:03 -05:00
Lance-XI
eb98f20f6d [sql] Update quantity of items for alchemy guild 2026-01-31 17:18:50 -05:00
sruon
17f1c74348 Visala stock 2025-07-31 23:07:36 -06:00
sruon
88223d1c9e
Merge pull request #7611 from sruon/ls_guild_shop 
Set up the Linkshell vendors as proper guild vendors, general cleanup
 2025-06-04 10:23:42 +01: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
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
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
TeoTwawki
1802362b20 Drop price of platinum ores. 
I've changed the range of the limited shop to be substantially lower. The numbers are NOT retail accurate. Neither are the existing ones, because retail changed most of this long ago in multiple waves of QoL changes.  The "max" the npc will pay a players price is 1/3 what the sql column says when there is zero in stock.

Closes #1173
 2022-01-18 21:27:00 -05: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
7a51bce3b2 Disable Curio Vendor Moogle items from guild shops 2020-11-24 03:12:18 -08:00
Zach Toogood
e617e0137d Merge branch 'feature/mercantilism' into release 
# Conflicts:
#	src/map/lua/lua_baseentity.cpp
 2020-09-26 09:30:40 +03:00
Tokenr
2fea9c7e65 Guild shops 2020-09-13 19:08:42 +02:00
Kain
d231db75fd changed function to all guild vendors that are open 24/7 
updated guild vendors to use npc_util (I haven't verified that it doesn't break anything but would appreciate some feedback from a Tester):
* Cletae
* Celestina
 2020-07-03 00:51:20 -07:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08: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
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
ShelbyZ
c6ad69b7cc Fixing guild_shops.sql min_price,max_price 
- in some cases min_price,max_price was lower than the item sell price
- attempted to move min_price to 133% of the sell price
- arbitrary max_price if necessary
 2019-01-01 18:34:57 -08:00
Zynjec
9f35d8e3cd
Updated NPC Amalasanda 2018-07-17 20:06:27 -04:00
TeoTwawki
17894f1d9f Fix some reverse min/max guild pricing and duplicate rows. 2018-03-14 15:18:03 -04:00
TeoTwawki
dd91c3f7a8 Slap the single quotes off of non string values.. 2017-06-29 15:19:41 -04:00
TeoTwawki
45fd374357 Corrected Fuma Shuriken pricing 
I got on retail using someone elses account to check firsthand: ffxiclopedia is wrong, ffxiah is wrong.
I may be slightly off from minimal fame differences.
Better than it was.
 2017-06-29 14:55:18 -04:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
Hozu
aee25a21c1 SQL: Guild shop prices/quantities update 
As requested by @bendangelo, his source is http://pastebin.com/vByTKTye
 2015-10-06 11:25:45 -04:00