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

48 commits

Author SHA1 Message Date
bliven-was-taken
28391a3e0e (sql) Fix Item ID of GP Item Carapace Subligar 
The Carapace Subligar entry was using the Horn +1 entry.
 2026-01-28 15:30:22 -05:00
bliven-was-taken
0723ff4e8f Change Royal Bookshelf GP Value 2026-01-03 18:06:13 -05:00
bliven-was-taken
8ba4733b25 Correct Silver Hairpin Item ID 2025-05-14 09:56:08 -04:00
WinterSolstice8
927af78c82 [sql] Actually use Scale/Solid greaves item ID in Smithing gp 2024-12-09 18:36:25 -07: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
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
SevenG
7493a16138 Updated IDs from mog garden to fished items 2023-06-13 12:58:57 -06:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
EpicTaru
faf4d3e4f7 [sql]Fixes typo in ItemID Leathercraft guild points item Leather Shield. 
*Currently displays 12295 as the ItemID for Leather Shield.
*ItemID 12295 actually is the Round Shield (a Woodworking item).
*Changed ItemID to be 12294, the correct ItemID for Leather Shield.

Credit goes to @Metal36 for discovering this typo!
 2022-06-15 13:59:22 -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
Nireya
da0a9f261c Correct several Guild Points items 2020-09-01 14:47:16 -04:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
isotor
1090f5d480 Fix errors in guild point item table 2019-05-08 12:51:28 +03:00
Matthew James Davis
29da312a49 fix(guild_item_points): Fix Turtle Bangles +1 item id 2019-01-23 21:08:20 +09:00
Matthew James Davis
695fddaca6 fix(guild_item_points): Add proper Goldsmithing / Amateur ids 
Also, standardize the comments to (100 / 2500) format.
 2019-01-23 21:02:47 +09:00
Matthew James Davis
7c24da026a fix(guild_item_points): Add Cooking item ids 2019-01-23 20:54:25 +09:00
Matthew James Davis
78064dc736 fix(guild_item_points): Add Alchemy item ids 2019-01-23 20:18:26 +09:00
Matthew James Davis
ae981c57d5 fix(guild_item_points): Add Bonecraft item ids 2019-01-23 20:03:19 +09:00
Matthew James Davis
30b8cc28b4 fix(guild_item_points): Add Leathercraft item ids 2019-01-23 19:32:45 +09:00
Matthew James Davis
ea3416befb fix(guild_item_points): Add Clothcraft item ids 2019-01-23 19:10:46 +09:00
Matthew James Davis
59d8d6283f fix(guild_item_points): Add Goldsmithing item ids 2019-01-23 18:38:11 +09:00
Matthew James Davis
d9fb5ee6a5 fix(guild_item_points): Add Blacksmithing item ids 
Also update some wiki values to http://www011.upp.so-net.ne.jp/iris/gtable.html so everything is consistent.
 2019-01-23 18:18:37 +09:00
Matthew James Davis
36d965f8b6 fix(guild_item_points): Add Cooking points 2019-01-23 17:41:42 +09:00
Matthew James Davis
707750a069 fix(guild_item_points): Add Alchemy points 2019-01-23 17:22:48 +09:00
Matthew James Davis
034e5b5516 fix(guild_item_points): Add Bonecraft points 2019-01-23 17:01:42 +09:00
Matthew James Davis
fde3a94794 fix(guild_item_points): Add Leathercraft points 2019-01-23 16:41:34 +09:00
Matthew James Davis
5ba2d5257b fix(guild_item_points): Add Clothcraft points 2019-01-23 16:20:04 +09:00
Matthew James Davis
57e9b0e6cd wip 2019-01-13 23:24:12 +09:00
Matthew James Davis
82607280fb fix(guild_item_points.sql): Add goldsmithing points 2019-01-13 00:22:37 +09:00
Matthew James Davis
d17ec0ed92 fix(guild_item_points.sql): Add blacksmithing points 2019-01-12 23:50:48 +09:00
Matthew James Davis
ced261009a fix(guild_item_points.sql): Add woodworking points 2019-01-12 22:08:44 +09:00
Matthew James Davis
544031773c fix(guild_item_points): Add points for fishing 2019-01-12 21:03:10 +09:00
Matthew James Davis
a9af3532b4 fix(guild_item_points.sql): Add cooking and woodworking item ids 2019-01-12 20:46:03 +09:00
Matthew James Davis
c04f21f0fa style(guild_item_points.sql): Reformat and annotate rows 2019-01-12 18:56:54 +09:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
Alexsis987
4491fe8144 Update guild_item_points.sql 
Incorrect Item ID for Zafmlug Bass. Should have been the same value as line 55
 2015-12-11 21:21:49 -06:00
teschnei
a5c7029567 SQL: fixed an incorrect item ID for alchemy guild points 2015-05-06 18:23:43 -06:00
nesstea
735ba4d2c4 [GUILD] Adjusted incorrect values 
Wiki lied to me!
 2015-04-19 02:27:08 -07:00
whasf
cc607e1f69 SQL: Change table type to our standard 2015-03-28 10:23:19 -05:00
teschnei
245432028a SQL: fixed guild_item_points pattern being 1 based instead of 0 based 2015-03-26 22:17:11 -06:00
nesstea
1313e97702 sql for kj 2015-03-18 16:40:15 -07:00