Implementare Posedate 2011

alutare! Astazi stateam si nu aveam ce face si m-am gandit sa fac niste quaries noi pentru serverele PvP:

Sa fac o descriere intai: Sunt Armurile Posedate(Ca si Skin), dar au cam toate bonusurile schimbate( cu exceptia rezistentei la magie.

Bonusuri: +0
12 Rez. Magie
4 Viteza de Miscare
1000 PV
150 Defensiva

+1
14 Rez. Magie
6 Viteza de Miscare
2000 PV
200 Defensiva

+2
16 Rez. Magie
8 Viteza de Miscare
3000 PV
300 Defensiva

+3
18 Rez. Magie
10 Viteza de Miscare
4000 PV
400 Defensiva

+4
20 Rez. Magie
12 Viteza de Miscare
5000 PV
500 Defensiva

+5
22 Rez. Magie
14 Viteza de Miscare
6000 PV
600 Defensiva

+6
24 Rez. Magie
18 Viteza de Miscare
7000 PV
700 Defensiva

+7
26 Rez. Magie
20 Viteza de Miscare
8000 PV
800 Defensiva

+8
28 Rez. Magie
50 Viteza de Miscare
9000 PV
900 Defensiva

+9
30 Rez. Magie
100 Viteza de Miscare
10000 PV
2000 Defensiva

Cod:

INSERT INTO item_proto VALUES ('11310', 0x41726D7572C3A320706F7365646174C3A32B30, 0x41726D7572C3A320706F7365646174C3A32B30, '2', '0', '0', '2', '312', '1', '1', '', '120000', '120000', '11311', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '1000', '0', '150', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11311', 0x41726D7572C3A320706F7365646174C3A32B31, 0x41726D7572C3A320706F7365646174C3A32B31, '2', '0', '0', '2', '312', '1', '1', '', '120000', '130000', '11312', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '2000', '0', '200', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11312', 0x41726D7572C3A320706F7365646174C3A32B32, 0x41726D7572C3A320706F7365646174C3A32B32, '2', '0', '0', '2', '312', '1', '1', '', '120000', '145000', '11313', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '3000', '0', '300', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11313', 0x41726D7572C3A320706F7365646174C3A32B33, 0x41726D7572C3A320706F7365646174C3A32B33, '2', '0', '0', '2', '312', '1', '1', '', '120000', '165000', '11314', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '4000', '0', '400', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11314', 0x41726D7572C3A320706F7365646174C3A32B34, 0x41726D7572C3A320706F7365646174C3A32B34, '2', '0', '0', '2', '312', '1', '1', '', '120000', '190000', '11315', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '5000', '0', '500', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
INSERT INTO item_proto VALUES ('11315', 0x41726D7572C3A320706F7365646174C3A32B35, 0x41726D7572C3A320706F7365646174C3A32B35, '2', '0', '0', '2', '312', '1', '1', '', '120000', '220000', '11316', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '6000', '0', '600', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
INSERT INTO item_proto VALUES ('11316', 0x41726D7572C3A320706F7365646174C3A32B36, 0x41726D7572C3A320706F7365646174C3A32B36, '2', '0', '0', '2', '312', '1', '1', '', '120000', '265000', '11317', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '7000', '0', '700', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
INSERT INTO item_proto VALUES ('11317', 0x41726D7572C3A320706F7365646174C3A32B37, 0x41726D7572C3A320706F7365646174C3A32B37, '2', '0', '0', '2', '312', '1', '1', '', '120000', '325000', '11318', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '8000', '0', '800', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
INSERT INTO item_proto VALUES ('11318', 0x41726D7572C3A320706F7365646174C3A32B38, 0x41726D7572C3A320706F7365646174C3A32B38, '2', '0', '0', '2', '312', '1', '1', '', '120000', '405000', '11319', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '50', '1', '9000', '0', '900', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
INSERT INTO item_proto VALUES ('11319', 0x41726D7572C3A320706F7365646174C3A32B39, 0x41726D7572C3A320706F7365646174C3A32B39, '2', '0', '0', '2', '312', '1', '1', '', '120000', '515000', '11978', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '100', '1', '10000', '0', '2000', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1');
INSERT INTO item_proto VALUES ('11510', 0x436F7374756D20706F73656461742B30, 0x436F7374756D20706F73656461742B30, '2', '0', '0', '2', '308', '1', '1', '', '120000', '120000', '11511', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '1000', '0', '150', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11511', 0x436F7374756D20706F73656461742B31, 0x436F7374756D20706F73656461742B31, '2', '0', '0', '2', '308', '1', '1', '', '120000', '130000', '11512', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '2000', '0', '200', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11512', 0x436F7374756D20706F73656461742B32, 0x436F7374756D20706F73656461742B32, '2', '0', '0', '2', '308', '1', '1', '', '120000', '145000', '11513', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '3000', '0', '300', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11513', 0x436F7374756D20706F73656461742B33, 0x436F7374756D20706F73656461742B33, '2', '0', '0', '2', '308', '1', '1', '', '120000', '165000', '11514', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '4000', '0', '400', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11514', 0x436F7374756D20706F73656461742B34, 0x436F7374756D20706F73656461742B34, '2', '0', '0', '2', '308', '1', '1', '', '120000', '190000', '11515', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '5000', '0', '500', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
INSERT INTO item_proto VALUES ('11515', 0x436F7374756D20706F73656461742B35, 0x436F7374756D20706F73656461742B35, '2', '0', '0', '2', '308', '1', '1', '', '120000', '220000', '11516', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '6000', '0', '600', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
INSERT INTO item_proto VALUES ('11516', 0x436F7374756D20706F73656461742B36, 0x436F7374756D20706F73656461742B36, '2', '0', '0', '2', '308', '1', '1', '', '120000', '265000', '11517', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '7000', '0', '700', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
INSERT INTO item_proto VALUES ('11517', 0x436F7374756D20706F73656461742B37, 0x436F7374756D20706F73656461742B37, '2', '0', '0', '2', '308', '1', '1', '', '120000', '325000', '11518', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '8000', '0', '800', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
INSERT INTO item_proto VALUES ('11518', 0x436F7374756D20706F73656461742B38, 0x436F7374756D20706F73656461742B38, '2', '0', '0', '2', '308', '1', '1', '', '120000', '405000', '11519', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '50', '1', '9000', '0', '900', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
INSERT INTO item_proto VALUES ('11519', 0x436F7374756D20706F73656461742B39, 0x436F7374756D20706F73656461742B39, '2', '0', '0', '2', '308', '1', '1', '', '120000', '515000', '11979', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '100', '1', '10000', '0', '2000', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1');
INSERT INTO item_proto VALUES ('11710', 0x506C61746F73C3A320706F7365646174C3A32B30, 0x506C61746F73C3A320706F7365646174C3A32B30, '2', '0', '0', '2', '300', '1', '1', '', '120000', '120000', '11711', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '1000', '0', '150', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11711', 0x506C61746F73C3A320706F7365646174C3A32B31, 0x506C61746F73C3A320706F7365646174C3A32B31, '2', '0', '0', '2', '300', '1', '1', '', '120000', '130000', '11712', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '2000', '0', '200', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11712', 0x506C61746F73C3A320706F7365646174C3A32B32, 0x506C61746F73C3A320706F7365646174C3A32B32, '2', '0', '0', '2', '300', '1', '1', '', '120000', '145000', '11713', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '3000', '0', '300', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11713', 0x506C61746F73C3A320706F7365646174C3A32B33, 0x506C61746F73C3A320706F7365646174C3A32B33, '2', '0', '0', '2', '300', '1', '1', '', '120000', '165000', '11714', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '4000', '0', '400', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('11714', 0x506C61746F73C3A320706F7365646174C3A32B34, 0x506C61746F73C3A320706F7365646174C3A32B34, '2', '0', '0', '2', '300', '1', '1', '', '120000', '190000', '11715', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '5000', '0', '500', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
INSERT INTO item_proto VALUES ('11715', 0x506C61746F73C3A320706F7365646174C3A32B35, 0x506C61746F73C3A320706F7365646174C3A32B35, '2', '0', '0', '2', '300', '1', '1', '', '120000', '220000', '11716', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '6000', '0', '600', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
INSERT INTO item_proto VALUES ('11716', 0x506C61746F73C3A320706F7365646174C3A32B36, 0x506C61746F73C3A320706F7365646174C3A32B36, '2', '0', '0', '2', '300', '1', '1', '', '120000', '265000', '11717', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '7000', '0', '700', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
INSERT INTO item_proto VALUES ('11717', 0x506C61746F73C3A320706F7365646174C3A32B37, 0x506C61746F73C3A320706F7365646174C3A32B37, '2', '0', '0', '2', '300', '1', '1', '', '120000', '325000', '11718', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '8000', '0', '800', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
INSERT INTO item_proto VALUES ('11718', 0x506C61746F73C3A320706F7365646174C3A32B38, 0x506C61746F73C3A320706F7365646174C3A32B38, '2', '0', '0', '2', '300', '1', '1', '', '120000', '405000', '11719', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '50', '1', '9000', '0', '900', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
INSERT INTO item_proto VALUES ('11719', 0x506C61746F73C3A320706F7365646174C3A32B39, 0x506C61746F73C3A320706F7365646174C3A32B39, '2', '0', '0', '2', '300', '1', '1', '', '120000', '515000', '11981', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '100', '1', '10000', '0', '2000', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1');
INSERT INTO item_proto VALUES ('12010', 0x5665736DC3A26E7420706F73656461742B30, 0x5665736DC3A26E7420706F73656461742B30, '2', '0', '0', '2', '284', '1', '1', '', '120000', '120000', '12011', '181', '0', '15', '1', '80', '0', '0', '8', '12', '37', '4', '1', '1000', '0', '150', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('12011', 0x5665736DC3A26E7420706F73656461742B31, 0x5665736DC3A26E7420706F73656461742B31, '2', '0', '0', '2', '284', '1', '1', '', '120000', '130000', '12012', '182', '0', '15', '1', '80', '0', '0', '8', '14', '37', '6', '1', '2000', '0', '200', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('12012', 0x5665736DC3A26E7420706F73656461742B32, 0x5665736DC3A26E7420706F73656461742B32, '2', '0', '0', '2', '284', '1', '1', '', '120000', '145000', '12013', '183', '0', '15', '1', '80', '0', '0', '8', '16', '37', '8', '1', '3000', '0', '300', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('12013', 0x5665736DC3A26E7420706F73656461742B33, 0x5665736DC3A26E7420706F73656461742B33, '2', '0', '0', '2', '284', '1', '1', '', '120000', '165000', '12014', '184', '0', '15', '1', '80', '0', '0', '8', '18', '37', '10', '1', '4000', '0', '400', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '-1');
INSERT INTO item_proto VALUES ('12014', 0x5665736DC3A26E7420706F73656461742B34, 0x5665736DC3A26E7420706F73656461742B34, '2', '0', '0', '2', '284', '1', '1', '', '120000', '190000', '12015', '185', '0', '15', '1', '80', '0', '0', '8', '20', '37', '12', '1', '5000', '0', '500', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '30', '-1');
INSERT INTO item_proto VALUES ('12015', 0x5665736DC3A26E7420706F73656461742B35, 0x5665736DC3A26E7420706F73656461742B35, '2', '0', '0', '2', '284', '1', '1', '', '120000', '220000', '12016', '186', '0', '15', '1', '80', '0', '0', '8', '22', '37', '14', '1', '6000', '0', '600', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '40', '-1');
INSERT INTO item_proto VALUES ('12016', 0x5665736DC3A26E7420706F73656461742B36, 0x5665736DC3A26E7420706F73656461742B36, '2', '0', '0', '2', '284', '1', '1', '', '120000', '265000', '12017', '187', '0', '15', '1', '80', '0', '0', '8', '24', '37', '18', '1', '7000', '0', '700', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '50', '-1');
INSERT INTO item_proto VALUES ('12017', 0x5665736DC3A26E7420706F73656461742B37, 0x5665736DC3A26E7420706F73656461742B37, '2', '0', '0', '2', '284', '1', '1', '', '120000', '325000', '12018', '188', '0', '15', '1', '83', '0', '0', '8', '26', '37', '20', '1', '8000', '0', '800', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '65', '-1');
INSERT INTO item_proto VALUES ('12018', 0x5665736DC3A26E7420706F73656461742B38, 0x5665736DC3A26E7420706F73656461742B38, '2', '0', '0', '2', '284', '1', '1', '', '120000', '405000', '12019', '189', '0', '15', '1', '86', '0', '0', '8', '28', '37', '50', '1', '9000', '0', '900', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '80', '-1');
INSERT INTO item_proto VALUES ('12019', 0x5665736DC3A26E7420706F73656461742B39, 0x5665736DC3A26E7420706F73656461742B39, '2', '0', '0', '2', '284', '1', '1', '', '120000', '515000', '11982', '514', '0', '15', '1', '92', '0', '0', '8', '30', '37', '100', '1', '10000', '0', '2000', '0', '25', '0', '0', '0', '0', '0', '0', '0', '0', '15', '100', '-1');