Pets armor

[sanchez]

 

run this on your sql ....

-- Pet fixes if you edit any pet you need to run this on your sql
-- a_grade must be 1 to work on Human+Type+Pet+Armor+weapons
-- a_grade must be 2 to work on Animal+Type+Pet+Armor+weapons
-- a_grade must be 3 to work on Demon+Type+Pet+Armor+weapons

-- Human Type Pet Weapons
UPDATE t_item SET a_grade = 1 where a_index = 3212;
UPDATE t_item SET a_grade = 1 where a_index = 3213;
UPDATE t_item SET a_grade = 1 where a_index = 3214;
UPDATE t_item SET a_grade = 1 where a_index = 3215;
UPDATE t_item SET a_grade = 1 where a_index = 3216;
UPDATE t_item SET a_grade = 1 where a_index = 4980;
UPDATE t_item SET a_grade = 1 where a_index = 4981;
UPDATE t_item SET a_grade = 1 where a_index = 4982;
UPDATE t_item SET a_grade = 1 where a_index = 4983;
UPDATE t_item SET a_grade = 1 where a_index = 4984;
UPDATE t_item SET a_grade = 1 where a_index = 4985;
UPDATE t_item SET a_grade = 1 where a_index = 4986;
UPDATE t_item SET a_grade = 1 where a_index = 4987;
UPDATE t_item SET a_grade = 1 where a_index = 6771;
UPDATE t_item SET a_grade = 1 where a_index = 6772;
UPDATE t_item SET a_grade = 1 where a_index = 6773;
UPDATE t_item SET a_grade = 1 where a_index = 6774;
UPDATE t_item SET a_grade = 1 where a_index = 6775;
UPDATE t_item SET a_grade = 1 where a_index = 6776;
UPDATE t_item SET a_grade = 1 where a_index = 6777;
UPDATE t_item SET a_grade = 1 where a_index = 6778;
UPDATE t_item SET a_grade = 1 where a_index = 6779;

-- Human Type Pet Armor
UPDATE t_item SET a_grade = 1 where a_index = 4988;
UPDATE t_item SET a_grade = 1 where a_index = 4989;
UPDATE t_item SET a_grade = 1 where a_index = 4990;
UPDATE t_item SET a_grade = 1 where a_index = 4991;
UPDATE t_item SET a_grade = 1 where a_index = 4992;
UPDATE t_item SET a_grade = 1 where a_index = 4993;
UPDATE t_item SET a_grade = 1 where a_index = 4994;
UPDATE t_item SET a_grade = 1 where a_index = 4995;
UPDATE t_item SET a_grade = 1 where a_index = 4996;
UPDATE t_item SET a_grade = 1 where a_index = 4997;
UPDATE t_item SET a_grade = 1 where a_index = 4998;
UPDATE t_item SET a_grade = 1 where a_index = 4999;
UPDATE t_item SET a_grade = 1 where a_index = 5000;
UPDATE t_item SET a_grade = 1 where a_index = 5001;
UPDATE t_item SET a_grade = 1 where a_index = 6780;
UPDATE t_item SET a_grade = 1 where a_index = 6781;
UPDATE t_item SET a_grade = 1 where a_index = 6782;
UPDATE t_item SET a_grade = 1 where a_index = 6783;
UPDATE t_item SET a_grade = 1 where a_index = 6784;
UPDATE t_item SET a_grade = 1 where a_index = 6785;
UPDATE t_item SET a_grade = 1 where a_index = 6786;
UPDATE t_item SET a_grade = 1 where a_index = 6787;
UPDATE t_item SET a_grade = 1 where a_index = 6788;
UPDATE t_item SET a_grade = 1 where a_index = 6789;

-- Animal Type Pet weapon
UPDATE t_item SET a_grade = 2 where a_index = 4877;
UPDATE t_item SET a_grade = 2 where a_index = 4878;
UPDATE t_item SET a_grade = 2 where a_index = 4879;
UPDATE t_item SET a_grade = 2 where a_index = 4880;
UPDATE t_item SET a_grade = 2 where a_index = 4881;
UPDATE t_item SET a_grade = 2 where a_index = 4882;
UPDATE t_item SET a_grade = 2 where a_index = 4883;
UPDATE t_item SET a_grade = 2 where a_index = 4884;
UPDATE t_item SET a_grade = 2 where a_index = 4885;
UPDATE t_item SET a_grade = 2 where a_index = 4886;
UPDATE t_item SET a_grade = 2 where a_index = 4887;
UPDATE t_item SET a_grade = 2 where a_index = 4888;
UPDATE t_item SET a_grade = 2 where a_index = 4889;
UPDATE t_item SET a_grade = 2 where a_index = 4890;
UPDATE t_item SET a_grade = 2 where a_index = 6734;
UPDATE t_item SET a_grade = 2 where a_index = 6735;
UPDATE t_item SET a_grade = 2 where a_index = 6736;
UPDATE t_item SET a_grade = 2 where a_index = 6737;
UPDATE t_item SET a_grade = 2 where a_index = 6738;
UPDATE t_item SET a_grade = 2 where a_index = 6739;
UPDATE t_item SET a_grade = 2 where a_index = 6740;
UPDATE t_item SET a_grade = 2 where a_index = 6741;
UPDATE t_item SET a_grade = 2 where a_index = 6742;
UPDATE t_item SET a_grade = 2 where a_index = 6743;

-- Animal Type Pet Charms
UPDATE t_item SET a_grade = 2 where a_index = 4891;
UPDATE t_item SET a_grade = 2 where a_index = 4892;
UPDATE t_item SET a_grade = 2 where a_index = 4893;
UPDATE t_item SET a_grade = 2 where a_index = 4894;
UPDATE t_item SET a_grade = 2 where a_index = 4895;
UPDATE t_item SET a_grade = 2 where a_index = 4896;
UPDATE t_item SET a_grade = 2 where a_index = 4897;
UPDATE t_item SET a_grade = 2 where a_index = 4898;
UPDATE t_item SET a_grade = 2 where a_index = 4899;
UPDATE t_item SET a_grade = 2 where a_index = 4901;
UPDATE t_item SET a_grade = 2 where a_index = 4902;
UPDATE t_item SET a_grade = 2 where a_index = 4903;
UPDATE t_item SET a_grade = 2 where a_index = 4904;
UPDATE t_item SET a_grade = 2 where a_index = 6744;
UPDATE t_item SET a_grade = 2 where a_index = 6745;
UPDATE t_item SET a_grade = 2 where a_index = 6746;
UPDATE t_item SET a_grade = 2 where a_index = 6747;
UPDATE t_item SET a_grade = 2 where a_index = 6748;
UPDATE t_item SET a_grade = 2 where a_index = 6749;
UPDATE t_item SET a_grade = 2 where a_index = 6750;
UPDATE t_item SET a_grade = 2 where a_index = 6751;
UPDATE t_item SET a_grade = 2 where a_index = 6752;
UPDATE t_item SET a_grade = 2 where a_index = 6753;

-- Demon Type Pet Armor
UPDATE t_item SET a_grade = 3 where a_index = 9008;
UPDATE t_item SET a_grade = 3 where a_index = 9009;
UPDATE t_item SET a_grade = 3 where a_index = 9010;
UPDATE t_item SET a_grade = 3 where a_index = 9011;
UPDATE t_item SET a_grade = 3 where a_index = 9012;
UPDATE t_item SET a_grade = 3 where a_index = 9013;
UPDATE t_item SET a_grade = 3 where a_index = 9014;
UPDATE t_item SET a_grade = 3 where a_index = 9015;
UPDATE t_item SET a_grade = 3 where a_index = 9016;
UPDATE t_item SET a_grade = 3 where a_index = 9017;
UPDATE t_item SET a_grade = 3 where a_index = 9018;
UPDATE t_item SET a_grade = 3 where a_index = 9019;
UPDATE t_item SET a_grade = 3 where a_index = 9020;
UPDATE t_item SET a_grade = 3 where a_index = 9021;
UPDATE t_item SET a_grade = 3 where a_index = 9022;
UPDATE t_item SET a_grade = 3 where a_index = 9023;
UPDATE t_item SET a_grade = 3 where a_index = 9024;
UPDATE t_item SET a_grade = 3 where a_index = 9025;
UPDATE t_item SET a_grade = 3 where a_index = 9026;
UPDATE t_item SET a_grade = 3 where a_index = 9027;
UPDATE t_item SET a_grade = 3 where a_index = 9028;
UPDATE t_item SET a_grade = 3 where a_index = 9029;
UPDATE t_item SET a_grade = 3 where a_index = 9030;
UPDATE t_item SET a_grade = 3 where a_index = 9031;

-- Demon Type Pet Tattoos and Wings
UPDATE t_item SET a_grade = 3 where a_index = 9032;
UPDATE t_item SET a_grade = 3 where a_index = 9033;
UPDATE t_item SET a_grade = 3 where a_index = 9034;
UPDATE t_item SET a_grade = 3 where a_index = 9035;
UPDATE t_item SET a_grade = 3 where a_index = 9036;
UPDATE t_item SET a_grade = 3 where a_index = 9037;
UPDATE t_item SET a_grade = 3 where a_index = 9038;
UPDATE t_item SET a_grade = 3 where a_index = 9039;
UPDATE t_item SET a_grade = 3 where a_index = 9040;
UPDATE t_item SET a_grade = 3 where a_index = 9041;
UPDATE t_item SET a_grade = 3 where a_index = 9042;
UPDATE t_item SET a_grade = 3 where a_index = 9043;
UPDATE t_item SET a_grade = 3 where a_index = 9044;
UPDATE t_item SET a_grade = 3 where a_index = 9045;
UPDATE t_item SET a_grade = 3 where a_index = 9046;
UPDATE t_item SET a_grade = 3 where a_index = 9047;
UPDATE t_item SET a_grade = 3 where a_index = 9048;
UPDATE t_item SET a_grade = 3 where a_index = 9049;
UPDATE t_item SET a_grade = 3 where a_index = 9050;
UPDATE t_item SET a_grade = 3 where a_index = 9051;
UPDATE t_item SET a_grade = 3 where a_index = 9052;
UPDATE t_item SET a_grade = 3 where a_index = 9053;
UPDATE t_item SET a_grade = 3 where a_index = 9054;
UPDATE t_item SET a_grade = 3 where a_index = 9055;

You are the best! =)) Thanks!