Repository navigation
Expand file tree
/
Copy pathvorp_fishing.sql
More file actions
46 lines (45 loc) · 4.68 KB
/
Copy pathvorp_fishing.sql
File metadata and controls
46 lines (45 loc) · 4.68 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
/* Bait Data*/
INSERT IGNORE INTO `items` (`item`, `label`, `limit`, `can_remove`, `type`, `usable`) VALUES
('p_baitBread01x', 'Bread Bait', '10', '1', 'item_standard', '1'),
('p_baitCorn01x', 'Corn Bait', '10', '1', 'item_standard', '1'),
('p_baitCheese01x', 'Cheese Bait', '10', '1', 'item_standard', '1'),
('p_baitWorm01x', 'Worm Bait', '10', '1', 'item_standard', '1'),
('p_baitCricket01x', 'Cricket Bait', '10', '1', 'item_standard', '1'),
('p_crawdad01x', 'Crawfish Bait', '10', '1', 'item_standard', '1'),
('p_finishedragonfly01x', 'Dragonfly Lure', '10', '1', 'item_standard', '1'),
('p_FinisdFishlure01x', 'Fish Lure', '10', '1', 'item_standard', '1'),
('p_finishdcrawd01x', 'Crawfish Lure', '10', '1', 'item_standard', '1'),
('p_finishedragonflylegendary01x', 'Legendary Dragonfly Lure', '10', '1', 'item_standard', '1'),
('p_finisdfishlurelegendary01x', 'Legendary Fish Lure', '10', '1', 'item_standard', '1'),
('p_finishdcrawdlegendary01x', 'Legendary Crawfish Lure', '10', '1', 'item_standard', '1'),
('p_lgoc_spinner_v4', 'Spinner V4', '10', '1', 'item_standard', '1'),
('p_lgoc_spinner_v6', 'Spinner V6', '10', '1', 'item_standard', '1');
/* Fish Data*/
INSERT IGNORE INTO `items` (`item`, `label`, `limit`, `can_remove`, `type`, `usable`) VALUES
('a_c_fishbluegil_01_ms', 'Blue Gil (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishbluegil_01_sm', 'Blue Gil (Small)', '10', '1', 'item_standard', '0'),
('a_c_fishbullheadcat_01_ms', 'Bullhead Cat (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishbullheadcat_01_sm', 'Bullhead Cat (Small)', '10', '1', 'item_standard', '0'),
('a_c_fishchainpickerel_01_ms', 'Chain Pickerel (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishchainpickerel_01_sm', 'Chain Pickerel (Small)', '10', '1', 'item_standard', '0'),
('a_c_fishchannelcatfish_01_lg', 'Channel Catfish (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishchannelcatfish_01_xl', 'Channel Catfish (Extra Large)', '10', '1', 'item_standard', '0'),
('a_c_fishlakesturgeon_01_lg', 'Lake Sturgeon (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishlargemouthbass_01_lg', 'Large Mouth Bass (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishlargemouthbass_01_ms', 'Large Mouth Bass (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishlongnosegar_01_lg', 'Long Nose Gar (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishmuskie_01_lg', 'Muskie (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishnorthernpike_01_lg', 'Northern Pike (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishperch_01_ms', 'Perch (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishperch_01_sm', 'Perch (Small)', '10', '1', 'item_standard', '0'),
('a_c_fishrainbowtrout_01_lg', 'Rainbow Trout (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishrainbowtrout_01_ms', 'Rainbow Trout (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishredfinpickerel_01_ms', 'Red Fin Pickerel (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishredfinpickerel_01_sm', 'Red Fin Pickerel (Small)', '10', '1', 'item_standard', '0'),
('a_c_fishrockbass_01_ms', 'Rock Bass (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishrockbass_01_sm', 'Rock Bass (Small)', '10', '1', 'item_standard', '0'),
('a_c_fishsalmonsockeye_01_lg', 'Salmon Sockeye (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishsalmonsockeye_01_ml', 'Salmon Sockeye (Medium-Large)', '10', '1', 'item_standard', '0'),
('a_c_fishsalmonsockeye_01_ms', 'Salmon Sockeye (Medium)', '10', '1', 'item_standard', '0'),
('a_c_fishsmallmouthbass_01_lg', 'Small Mouth Bass (Large)', '10', '1', 'item_standard', '0'),
('a_c_fishsmallmouthbass_01_ms', 'Small Mouth Bass (Medium)', '10', '1', 'item_standard', '0');