[Frage]Smaragt rüstung

Ich wollte die smaragd rüstungen in meinen server einfügen, aber ich weis nicht wie man den Quary verändern muss damit die rüstung für eine andere Klasse ist.

Quote:

INSERT INTO `item_proto` VALUES ('42000', 0xC8B8A9B6B0C8A92B30, 0x536D6172616764737461686C2D50616E7A65722B30, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42001', '181', '0', '15', '1', '84', '0', '0', '8', '-10', '37', '2', '39', '2', '0', '115', '0', '40', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '1', '0'); INSERT INTO `item_proto` VALUES ('42001', 0xC8B8A9B6B0C8A92B31, 0x536D6172616764737461686C2D50616E7A65722B31, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42002', '182', '0', '15', '1', '84', '0', '0', '8', '-10', '37', '3', '39', '3', '0', '115', '0', '40', '0', '8', '-1', '-1', '-1', '-1', '-1', '-1', '5', '1', '0'); INSERT INTO `item_proto` VALUES ('42002', 0xC8B8A9B6B0C8A92B32, 0x536D6172616764737461686C2D50616E7A65722B32, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42003', '183', '0', '15', '1', '84', '0', '0', '8', '-10', '37', '4', '39', '4', '0', '115', '0', '40', '0', '16', '-1', '-1', '-1', '-1', '-1', '-1', '10', '1', '0'); INSERT INTO `item_proto` VALUES ('42003', 0xC8B8A9B6B0C8A92B33, 0x536D6172616764737461686C2D50616E7A65722B33, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42004', '184', '0', '15', '1', '85', '0', '0', '8', '-8', '37', '5', '39', '6', '0', '115', '0', '40', '0', '24', '-1', '-1', '-1', '-1', '-1', '-1', '15', '1', '0'); INSERT INTO `item_proto` VALUES ('42004', 0xC8B8A9B6B0C8A92B34, 0x536D6172616764737461686C2D50616E7A65722B34, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42005', '185', '0', '15', '1', '85', '0', '0', '8', '-8', '37', '6', '39', '7', '0', '115', '0', '40', '0', '32', '-1', '-1', '-1', '-1', '-1', '-1', '30', '2', '0'); INSERT INTO `item_proto` VALUES ('42005', 0xC8B8A9B6B0C8A92B35, 0x536D6172616764737461686C2D50616E7A65722B35, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42006', '186', '0', '15', '1', '86', '0', '0', '8', '-8', '37', '8', '39', '9', '0', '115', '0', '40', '0', '41', '-1', '-1', '-1', '-1', '-1', '-1', '40', '2', '0'); INSERT INTO `item_proto` VALUES ('42006', 0xC8B8A9B6B0C8A92B36, 0x536D6172616764737461686C2D50616E7A65722B36, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42007', '187', '0', '15', '1', '86', '0', '0', '8', '-6', '37', '11', '39', '12', '0', '115', '0', '40', '0', '50', '-1', '-1', '-1', '-1', '-1', '-1', '50', '2', '0'); INSERT INTO `item_proto` VALUES ('42007', 0xC8B8A9B6B0C8A92B37, 0x536D6172616764737461686C2D50616E7A65722B37, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42008', '188', '0', '15', '1', '87', '0', '0', '8', '-6', '37', '14', '39', '15', '0', '115', '0', '40', '0', '59', '-1', '-1', '-1', '-1', '-1', '-1', '65', '3', '0'); INSERT INTO `item_proto` VALUES ('42008', 0xC8B8A9B6B0C8A92B38, 0x536D6172616764737461686C2D50616E7A65722B38, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42009', '189', '0', '15', '1', '87', '0', '0', '8', '-6', '37', '17', '39', '18', '0', '115', '0', '40', '0', '68', '-1', '-1', '-1', '-1', '-1', '-1', '80', '3', '0'); INSERT INTO `item_proto` VALUES ('42009', 0xC8B8A9B6B0C8A92B39, 0x536D6172616764737461686C2D50616E7A65722B39, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '0', '0', '0', '15', '1', '87', '0', '0', '8', '-5', '37', '20', '39', '20', '0', '115', '0', '40', '0', '86', '-1', '-1', '-1', '-1', '-1', '-1', '100', '3', '0');

So sieht die Quary vom Krieger aus. Was muss ich daran verändern?

wie mann man die dann adden? also die id

Quote:

INSERT INTO `item_proto` VALUES ('42000', 0xC8B8A9B6B0C8A92B30, 0x536D6172616764737461686C2D50616E7A65722B30, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42001', '181', '0', '15', '1', '84', '0', '0', '8', '-10', '37', '2', '39', '2', '0', '115', '0', '40', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '1', '0'); INSERT INTO `item_proto` VALUES ('42001', 0xC8B8A9B6B0C8A92B31, 0x536D6172616764737461686C2D50616E7A65722B31, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42002', '182', '0', '15', '1', '84', '0', '0', '8', '-10', '37', '3', '39', '3', '0', '115', '0', '40', '0', '8', '-1', '-1', '-1', '-1', '-1', '-1', '5', '1', '0'); INSERT INTO `item_proto` VALUES ('42002', 0xC8B8A9B6B0C8A92B32, 0x536D6172616764737461686C2D50616E7A65722B32, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42003', '183', '0', '15', '1', '84', '0', '0', '8', '-10', '37', '4', '39', '4', '0', '115', '0', '40', '0', '16', '-1', '-1', '-1', '-1', '-1', '-1', '10', '1', '0'); INSERT INTO `item_proto` VALUES ('42003', 0xC8B8A9B6B0C8A92B33, 0x536D6172616764737461686C2D50616E7A65722B33, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42004', '184', '0', '15', '1', '85', '0', '0', '8', '-8', '37', '5', '39', '6', '0', '115', '0', '40', '0', '24', '-1', '-1', '-1', '-1', '-1', '-1', '15', '1', '0'); INSERT INTO `item_proto` VALUES ('42004', 0xC8B8A9B6B0C8A92B34, 0x536D6172616764737461686C2D50616E7A65722B34, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42005', '185', '0', '15', '1', '85', '0', '0', '8', '-8', '37', '6', '39', '7', '0', '115', '0', '40', '0', '32', '-1', '-1', '-1', '-1', '-1', '-1', '30', '2', '0'); INSERT INTO `item_proto` VALUES ('42005', 0xC8B8A9B6B0C8A92B35, 0x536D6172616764737461686C2D50616E7A65722B35, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42006', '186', '0', '15', '1', '86', '0', '0', '8', '-8', '37', '8', '39', '9', '0', '115', '0', '40', '0', '41', '-1', '-1', '-1', '-1', '-1', '-1', '40', '2', '0'); INSERT INTO `item_proto` VALUES ('42006', 0xC8B8A9B6B0C8A92B36, 0x536D6172616764737461686C2D50616E7A65722B36, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42007', '187', '0', '15', '1', '86', '0', '0', '8', '-6', '37', '11', '39', '12', '0', '115', '0', '40', '0', '50', '-1', '-1', '-1', '-1', '-1', '-1', '50', '2', '0'); INSERT INTO `item_proto` VALUES ('42007', 0xC8B8A9B6B0C8A92B37, 0x536D6172616764737461686C2D50616E7A65722B37, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42008', '188', '0', '15', '1', '87', '0', '0', '8', '-6', '37', '14', '39', '15', '0', '115', '0', '40', '0', '59', '-1', '-1', '-1', '-1', '-1', '-1', '65', '3', '0'); INSERT INTO `item_proto` VALUES ('42008', 0xC8B8A9B6B0C8A92B38, 0x536D6172616764737461686C2D50616E7A65722B38, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '42009', '189', '0', '15', '1', '87', '0', '0', '8', '-6', '37', '17', '39', '18', '0', '115', '0', '40', '0', '68', '-1', '-1', '-1', '-1', '-1', '-1', '80', '3', '0'); INSERT INTO `item_proto` VALUES ('42009', 0xC8B8A9B6B0C8A92B39, 0x536D6172616764737461686C2D50616E7A65722B39, '2', '0', '0', '2', '56', '1', '1', '', '150000', '50000', '0', '0', '0', '15', '1', '87', '0', '0', '8', '-5', '37', '20', '39', '20', '0', '115', '0', '40', '0', '86', '-1', '-1', '-1', '-1', '-1', '-1', '100', '3', '0');

also das erste das du meines wissens nach ändern musst ist die antiflag, hab ich rot markiert.

Für Krieger 56
Für Ninja 308
Für Sura 300
Für Schamanen 284

dazu kommt das du die vnums der rüssi natrülich ändern musst also z.b. für Kriger 42000-42009 für Ninja 44000-44009, für sura 46000-46009, für schamis 48000-48009. (grün markiert)

Auch die refine_vnum ändern, wie vnum, damit die rüstung auch richtig uppbar ist. (blau markiert)

abschließend clientside nicht vergessen:D

MfG

Delta619


€: sry xD nicht aufs datum geguckt :D