Imbued Field Plate (cultural armor fixes)

[RinoaV]

Hello all,

I appologize in advance if this is the wrong place to post this.

This is my first attempt at helping out. While I was smithing the other night on my private lan server I noticed that the peq
revision 974 imbued cultural armor database entries were all linked to either Innoruuk or Erollisi Marr end products, so I went ahead
and updated the entries to match their correct end products.

Please backup your database if you decide to add these changes just to be on the safe side.

Imbued Field Breastplate(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23435' WHERE id = 46566 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23447' WHERE id = 46554 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23459' WHERE id = 46542 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23423' WHERE id = 46530 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23411' WHERE id = 46506 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23399' WHERE id = 46494 LIMIT 1 ;

Imbued Field Plate Boots(currently all linked to Eroliss Marr)

UPDATE tradeskill_recipe_entries SET item_id = '23443' WHERE id = 46650 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23455' WHERE id = 46638 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23467' WHERE id = 46626 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23431' WHERE id = 46614 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23395' WHERE id = 46602 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23419' WHERE id = 46590 LIMIT 1 ;

Imbued Field Plate Bracers(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23440' WHERE id = 46733 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23452' WHERE id = 46721 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23464' WHERE id = 46710 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23428' WHERE id = 46698 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23416' WHERE id = 46674 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23404' WHERE id = 46662 LIMIT 1 ;

Imbued Field Plate Cloak(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23437' WHERE id = 46805 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23449' WHERE id = 46793 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23461' WHERE id = 46781 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23425' WHERE id = 46769 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23401' WHERE id = 46745 LIMIT 1 ;

Imbued Field Plate Cloak (Mithaniel Marr) *Missing*

INSERT INTO tradeskill_recipe (`id`, `name`, `tradeskill`, `skillneeded`, `trivial`, `nofail`, `replace_container`, 
`notes`) VALUES ('10113', 'imbued field plate cloak', '63', '0', '228', '0', '0', NULL);
INSERT INTO tradeskill_recipe_entries (`id` ,`recipe_id` ,`item_id` ,`successcount` ,`failcount` ,`componentcount` 
,`iscontainer`) VALUES (NULL , '10113', '10482', '0', '0', '3', '0'), (NULL , '10113', '10489', '0', '0', '1', '0'), (NULL , 
'10113', '10491', '0', '0', '1', '0'), (NULL , '10113', '16488', '0', '0', '1', '0'), (NULL , '10113', '22056', '0', '0', 
1', '0'), (NULL , '10113', '22546', '0', '0', '1', '0'), (NULL , '10113', '22549', '0', '0', '1', '0'), (NULL , '10113', 
'10489', '1', '0', '0', '0'), (NULL , '10113', '23413', '1', '0', '0', '0'), (NULL , '10113', '10489', '0', '1', '0', '0'), 
(NULL , '10113', '39', '0', '0', '0', '1'), (NULL , '10113', '40', '0', '0', '0', '1');

Imbued Field Plate Collar(currently all linked to Erollisi Marr)

UPDATE tradeskill_recipe_entries SET item_id = '23434' WHERE id = 46889 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23446' WHERE id = 46877 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23458' WHERE id = 46865 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23422' WHERE id = 46853 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23386' WHERE id = 46841 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23410' WHERE id = 46829 LIMIT 1 ;

Imbued Field Plate Gauntlets(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23441' WHERE id = 46973 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23453' WHERE id = 46961 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23465' WHERE id = 46949 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23429' WHERE id = 46937 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23417' WHERE id = 46913 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23405' WHERE id = 46901 LIMIT 1 ;

Imbued Field Plate Girdle(currently all linked to Innoruuk)

Note: there is currently a dupe recipe 4863 and recipe 4864 both use imbued sapphires(Innoruuk) 4863 is updated to use
imbued plains pebble(Karana).

UPDATE tradeskill_recipe_entries SET item_id = '23438' WHERE id = 47045 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23450' WHERE id = 47033 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23462' WHERE id = 47021 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '22553' WHERE id = 46994 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23426' WHERE id = 46997 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23402' WHERE id = 46985 LIMIT 1 ;

Imbued Field Plate Girdle (Mithaniel Marr) *Missing*

INSERT INTO tradeskill_recipe (`id`, `name`, `tradeskill`, `skillneeded`, `trivial`, `nofail`, `replace_container`, 
`notes`) VALUES (NULL, 'imbued field plate girdle', '63', '0', '222', '0', '0', NULL);
INSERT INTO tradeskill_recipe_entries (`id`, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, 
`iscontainer`) VALUES (NULL, '10114', '10482', '0', '0', '2', '0'), (NULL, '10114', '10489', '0', '0', '1', '0'), (NULL, 
'10114', '10491', '0', '0', '1', '0'), (NULL, '10114', '16488', '0', '0', '1', '0'), (NULL, '10114', '22006', '0', '0', '1', 
'0'), (NULL, '10114', '22546', '0', '0', '1', '0'), (NULL, '10114', '22549', '0', '0', '1', '0'), (NULL, '10114', '10489', 
'1', '0', '0', '0'), (NULL, '10114', '23402', '1', '0', '0', '0'), (NULL, '10114', '10489', '0', '1', '0', '0')(NULL , 
'10114', '39', '0', '0', '0', '1'), (NULL , '10114', '40', '0', '0', '0', '1');

Imbued Field Plate Greaves(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23442' WHERE id = 47129 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23466' WHERE id = 47105 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23454' WHERE id = 47117 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23430' WHERE id = 47093 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23418' WHERE id = 47069 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23406' WHERE id = 47057 LIMIT 1 ;

Imbued Field Plate Helm(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23432' WHERE id = 47297 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23444' WHERE id = 47285 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23456' WHERE id = 47273 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23420' WHERE id = 47261 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23408' WHERE id = 47237 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23396' WHERE id = 47225 LIMIT 1 ;

Imbued Field Plate Helm *Duplicate Records*

Note: 7 duplicate helm recipes removed (4875, 4876, 4877, 4878, 4879, 4880, 4881)

DELETE FROM tradeskill_recipe WHERE id = 4875 LIMIT 1 ;
DELETE FROM tradeskill_recipe WHERE id = 4876 LIMIT 1 ;
DELETE FROM tradeskill_recipe WHERE id = 4877 LIMIT 1 ;
DELETE FROM tradeskill_recipe WHERE id = 4878 LIMIT 1 ;
DELETE FROM tradeskill_recipe WHERE id = 4879 LIMIT 1 ;
DELETE FROM tradeskill_recipe WHERE id = 4880 LIMIT 1 ;
DELETE FROM tradeskill_recipe WHERE id = 4881 LIMIT 1 ;

DELETE FROM tradeskill_recipe_entries WHERE recipe_id = 4875;
DELETE FROM tradeskill_recipe_entries WHERE recipe_id = 4876;
DELETE FROM tradeskill_recipe_entries WHERE recipe_id = 4877;
DELETE FROM tradeskill_recipe_entries WHERE recipe_id = 4878;
DELETE FROM tradeskill_recipe_entries WHERE recipe_id = 4879;
DELETE FROM tradeskill_recipe_entries WHERE recipe_id = 4880;
DELETE FROM tradeskill_recipe_entries WHERE recipe_id = 4881;

Imbued Field Plate Pauldrons(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23436' WHERE id = 47381 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23448' WHERE id = 47369 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23460' WHERE id = 47357 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23424' WHERE id = 47345 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23412' WHERE id = 47321 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23400' WHERE id = 47309 LIMIT 1 ;

Imbued Field Plate Vambraces(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23439' WHERE id = 47465 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23451' WHERE id = 47453 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23463' WHERE id = 47441 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23427' WHERE id = 47429 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23415' WHERE id = 47405 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23403' WHERE id = 47393 LIMIT 1 ;

Imbued Field Plate Visor(currently all linked to Innoruuk)

UPDATE tradeskill_recipe_entries SET item_id = '23433' WHERE id = 47549 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23445' WHERE id = 47537 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23457' WHERE id = 47525 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23421' WHERE id = 47513 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23409' WHERE id = 47489 LIMIT 1 ;
UPDATE tradeskill_recipe_entries SET item_id = '23397' WHERE id = 47477 LIMIT 1 ;

[So_1337]

Bugs that affect the PEQ database can be reported here at the PEQ forums, specifically the "Database Bugs" forum.

If you actually do the work and put some SQL together to correct the issue, you can post it in the MySQL Submissions Forum.

Cavedude (the primary person in charge of the PEQ database) checks these forums, but they aren't a priority for him.

Now that that's all out of the way: Nice work =) Looks like you spent a lot of time on getting these into order.

[RinoaV]

Originally Posted by So_1337

Bugs that affect the PEQ database can be reported here at the PEQ forums, specifically the "Database Bugs" forum.

If you actually do the work and put some SQL together to correct the issue, you can post it in the MySQL Submissions Forum.

Cavedude (the primary person in charge of the PEQ database) checks these forums, but they aren't a priority for him.

Thank you for the information and links, I will post the changes over there.

Originally Posted by So_1337

Now that that's all out of the way: Nice work =) Looks like you spent a lot of time on getting these into order.

Thank you, it it did take a bit of time to locate everything and change it all around, I also logged every step of the way so I could share the results with everyone when I completed it. Feels good to finally be able to give something back.