80er Rüssis

hey epvp community,

ich hab folgendes problem
ich kenn mich nicht so gut aus
und würde gerne wissen wie ich
z.B. die 80er Rüssis, schuhe wie qilin, furchtmaske etc
in die db einfügen kann
ich weis nicht genau was querys sind und alle ergebnisse von der SuFu verstehe ich nicht..

hab zb das hier von Marco_A
kann mir einer bitte genau erklären was ich damit machen muss? :S


INSERT INTO `item_proto` VALUES ('42000', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B30, 0x536D6172616764737461686C2D50616E7A65722B30, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42001', '490', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '2', '0', '154', '0', '26', '0', '0', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('42001', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B31, 0x536D6172616764737461686C2D50616E7A65722B31, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42002', '491', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '5', '0', '154', '0', '26', '0', '5', '0', '127', '127', '127', '127', '127', '5', '3', '0');
INSERT INTO `item_proto` VALUES ('42002', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B32, 0x536D6172616764737461686C2D50616E7A65722B32, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42003', '492', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '8', '0', '154', '0', '26', '0', '10', '0', '127', '127', '127', '127', '127', '10', '3', '0');
INSERT INTO `item_proto` VALUES ('42003', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B33, 0x536D6172616764737461686C2D50616E7A65722B33, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42004', '493', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '12', '0', '154', '0', '26', '0', '15', '0', '127', '127', '127', '127', '127', '15', '3', '0');
INSERT INTO `item_proto` VALUES ('42004', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B34, 0x536D6172616764737461686C2D50616E7A65722B34, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42005', '494', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '16', '0', '154', '0', '26', '0', '20', '0', '127', '127', '127', '127', '127', '30', '3', '0');
INSERT INTO `item_proto` VALUES ('42005', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B35, 0x536D6172616764737461686C2D50616E7A65722B35, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42006', '495', '0', '15', '1', '84', '0', '0', '8', '-8', '37', '20', '10', '20', '0', '154', '0', '26', '0', '25', '0', '127', '127', '127', '127', '127', '40', '3', '0');
INSERT INTO `item_proto` VALUES ('42006', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B36, 0x536D6172616764737461686C2D50616E7A65722B36, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42007', '496', '0', '15', '1', '84', '0', '0', '8', '-6', '37', '20', '10', '24', '0', '154', '0', '26', '0', '30', '0', '127', '127', '127', '127', '127', '50', '3', '0');
INSERT INTO `item_proto` VALUES ('42007', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B37, 0x536D6172616764737461686C2D50616E7A65722B37, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42008', '497', '0', '15', '1', '86', '0', '0', '8', '-6', '37', '20', '10', '29', '0', '154', '0', '26', '0', '35', '0', '127', '127', '127', '127', '127', '65', '3', '0');
INSERT INTO `item_proto` VALUES ('42008', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B38, 0x536D6172616764737461686C2D50616E7A65722B38, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '42009', '498', '0', '15', '1', '88', '0', '0', '8', '-6', '37', '20', '10', '34', '0', '154', '0', '26', '0', '40', '0', '127', '127', '127', '127', '127', '80', '3', '0');
INSERT INTO `item_proto` VALUES ('42009', 0xC8B8EFBFBDEFBFBDEFBFBDC8A92B39, 0x536D6172616764737461686C2D50616E7A65722B39, '2', '0', '0', '2', '56', '1', '1', '', '1', '0', '0', '0', '0', '15', '1', '90', '0', '0', '8', '-5', '37', '20', '10', '40', '0', '154', '0', '26', '0', '45', '0', '127', '127', '127', '127', '127', '100', '3', '0');
INSERT INTO `item_proto` VALUES ('44000', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B30, 0x536D6172616774616E7A75672B30, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44001', '490', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '2', '0', '154', '0', '26', '0', '0', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('44001', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B31, 0x536D6172616774616E7A75672B31, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44002', '491', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '5', '0', '154', '0', '26', '0', '5', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('44002', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B32, 0x536D6172616774616E7A75672B32, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44003', '492', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '8', '0', '154', '0', '26', '0', '10', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('44003', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B33, 0x536D6172616774616E7A75672B33, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44004', '493', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '12', '0', '154', '0', '26', '0', '15', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('44004', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B34, 0x536D6172616774616E7A75672B34, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44005', '494', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '16', '0', '154', '0', '26', '0', '20', '0', '127', '127', '127', '127', '127', '30', '3', '0');
INSERT INTO `item_proto` VALUES ('44005', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B35, 0x536D6172616774616E7A75672B35, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44006', '495', '0', '15', '1', '84', '0', '0', '8', '-8', '37', '20', '10', '20', '0', '154', '0', '26', '0', '25', '0', '127', '127', '127', '127', '127', '40', '3', '0');
INSERT INTO `item_proto` VALUES ('44006', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B36, 0x536D6172616774616E7A75672B36, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44007', '496', '0', '15', '1', '84', '0', '0', '8', '-6', '37', '20', '10', '24', '0', '154', '0', '26', '0', '30', '0', '127', '127', '127', '127', '127', '50', '3', '0');
INSERT INTO `item_proto` VALUES ('44007', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B37, 0x536D6172616774616E7A75672B37, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44008', '497', '0', '15', '1', '86', '0', '0', '8', '-6', '37', '20', '10', '29', '0', '154', '0', '26', '0', '35', '0', '127', '127', '127', '127', '127', '65', '3', '0');
INSERT INTO `item_proto` VALUES ('44008', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B38, 0x536D6172616774616E7A75672B38, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '44009', '498', '0', '15', '1', '88', '0', '0', '8', '-6', '37', '20', '10', '34', '0', '154', '0', '26', '0', '40', '0', '127', '127', '127', '127', '127', '80', '3', '0');
INSERT INTO `item_proto` VALUES ('44009', 0xEFBFBDEFBFBDEFBFBDC7BBEFBFBD2B39, 0x536D6172616774616E7A75672B39, '2', '0', '0', '2', '52', '1', '1', '', '1', '0', '0', '0', '0', '15', '1', '90', '0', '0', '8', '-5', '37', '20', '10', '40', '0', '154', '0', '26', '0', '45', '0', '127', '127', '127', '127', '127', '100', '3', '0');
INSERT INTO `item_proto` VALUES ('46000', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B30, 0x536D61726167742D50616E7A65722B30, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46001', '490', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '2', '0', '145', '0', '41', '0', '0', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('46001', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B31, 0x536D61726167742D50616E7A65722B31, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46002', '491', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '5', '0', '145', '0', '41', '0', '8', '0', '127', '127', '127', '127', '127', '5', '3', '0');
INSERT INTO `item_proto` VALUES ('46002', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B32, 0x536D61726167742D50616E7A65722B32, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46003', '492', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '8', '0', '145', '0', '41', '0', '16', '0', '127', '127', '127', '127', '127', '10', '3', '0');
INSERT INTO `item_proto` VALUES ('46003', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B33, 0x536D61726167742D50616E7A65722B33, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46004', '493', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '12', '0', '145', '0', '41', '0', '24', '0', '127', '127', '127', '127', '127', '15', '3', '0');
INSERT INTO `item_proto` VALUES ('46004', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B34, 0x536D61726167742D50616E7A65722B34, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46005', '494', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '16', '0', '145', '0', '41', '0', '32', '0', '127', '127', '127', '127', '127', '30', '3', '0');
INSERT INTO `item_proto` VALUES ('46005', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B35, 0x536D61726167742D50616E7A65722B35, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46006', '495', '0', '15', '1', '84', '0', '0', '8', '-8', '37', '20', '10', '20', '0', '145', '0', '41', '0', '41', '0', '127', '127', '127', '127', '127', '40', '3', '0');
INSERT INTO `item_proto` VALUES ('46006', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B36, 0x536D61726167742D50616E7A65722B36, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46007', '496', '0', '15', '1', '84', '0', '0', '8', '-6', '37', '20', '10', '24', '0', '145', '0', '41', '0', '50', '0', '127', '127', '127', '127', '127', '50', '3', '0');
INSERT INTO `item_proto` VALUES ('46007', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B37, 0x536D61726167742D50616E7A65722B37, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46008', '497', '0', '15', '1', '86', '0', '0', '8', '-6', '37', '20', '10', '29', '0', '145', '0', '41', '0', '59', '0', '127', '127', '127', '127', '127', '65', '3', '0');
INSERT INTO `item_proto` VALUES ('46008', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B38, 0x536D61726167742D50616E7A65722B38, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '46009', '498', '0', '15', '1', '88', '0', '0', '8', '-6', '37', '20', '10', '34', '0', '145', '0', '41', '0', '68', '0', '127', '127', '127', '127', '127', '80', '3', '0');
INSERT INTO `item_proto` VALUES ('46009', 0xEFBFBDE6B8B6EFBFBDEFBFBD2B39, 0x536D61726167742D50616E7A65722B39, '2', '0', '0', '2', '44', '1', '1', '', '1', '0', '0', '0', '0', '15', '1', '90', '0', '0', '8', '-5', '37', '20', '10', '40', '0', '145', '0', '41', '0', '86', '0', '127', '127', '127', '127', '127', '100', '3', '0');
INSERT INTO `item_proto` VALUES ('48000', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B30, 0x536D61726167742D4B6C656964756E672B30, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48001', '490', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '2', '0', '154', '0', '26', '0', '0', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('48001', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B31, 0x536D61726167742D4B6C656964756E672B31, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48002', '491', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '5', '0', '154', '0', '26', '0', '5', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('48002', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B32, 0x536D61726167742D4B6C656964756E672B32, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48003', '492', '0', '15', '1', '80', '0', '0', '8', '-10', '37', '20', '10', '8', '0', '154', '0', '26', '0', '10', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('48003', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B33, 0x536D61726167742D4B6C656964756E672B33, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48004', '493', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '12', '0', '154', '0', '26', '0', '15', '0', '127', '127', '127', '127', '127', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('48004', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B34, 0x536D61726167742D4B6C656964756E672B34, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48005', '494', '0', '15', '1', '82', '0', '0', '8', '-8', '37', '20', '10', '16', '0', '154', '0', '26', '0', '20', '0', '127', '127', '127', '127', '127', '30', '3', '0');
INSERT INTO `item_proto` VALUES ('48005', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B35, 0x536D61726167742D4B6C656964756E672B35, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48006', '495', '0', '15', '1', '84', '0', '0', '8', '-8', '37', '20', '10', '20', '0', '154', '0', '26', '0', '25', '0', '127', '127', '127', '127', '127', '40', '3', '0');
INSERT INTO `item_proto` VALUES ('48006', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B36, 0x536D61726167742D4B6C656964756E672B36, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48007', '496', '0', '15', '1', '84', '0', '0', '8', '-6', '37', '20', '10', '24', '0', '154', '0', '26', '0', '30', '0', '127', '127', '127', '127', '127', '50', '3', '0');
INSERT INTO `item_proto` VALUES ('48007', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B37, 0x536D61726167742D4B6C656964756E672B37, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48008', '497', '0', '15', '1', '86', '0', '0', '8', '-6', '37', '20', '10', '29', '0', '154', '0', '26', '0', '35', '0', '127', '127', '127', '127', '127', '65', '3', '0');
INSERT INTO `item_proto` VALUES ('48008', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B38, 0x536D61726167742D4B6C656964756E672B38, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '48009', '498', '0', '15', '1', '88', '0', '0', '8', '-6', '37', '20', '10', '34', '0', '154', '0', '26', '0', '40', '0', '127', '127', '127', '127', '127', '80', '3', '0');
INSERT INTO `item_proto` VALUES ('48009', 0xEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBD2B39, 0x536D61726167742D4B6C656964756E672B39, '2', '0', '0', '2', '28', '1', '1', '', '1', '0', '0', '0', '0', '15', '1', '90', '0', '0', '8', '-5', '37', '20', '10', '40', '0', '154', '0', '26', '0', '45', '0', '127', '127', '127', '127', '127', '100', '3', '0');

Querys sind Codes die du in die Datenbank in Navicat einfügen kannst.

Du gehst in die Tabelle Player und dort in die item_proto

anschließend gehst du oben links in der ecke auf file. und dort auf Query Table

Hinter dem Semikolon, drückst du einmal enter und fügst dann die Query dort ein. Anschließend Drückst du auf den Grünen Pfeil und wartest bis alles durchgelaufen ist.

Dann nur noch schließen und ingame /reload p eingeben dann haste die items in der DB drinne.

was meinste mit Semikolon..
also hab bis dahin des jetzt so gemacht

Weißte nicht was ein Semikolon ist? :D

das hier

>>> ; <<<

Dahinter Enter Drücken sodas du in eine neue Zeile kommst :D

achso :D
ok habs jetzt glaube
danke^^

hab jetzt ingame /reload p eingegeben
und wenn ich jetzt den code für zb smaragd panzer eingebe ist der nicht im invi
bzw ist er vllt aber halt unsichtbar so das ich im invi nichts sehe aber diese inviplätze besetzt sind^^

Ja du hast die Icons usw nicht im Client drin kein wunder dass es nicht geht

siehst du die bonis?

wenn nicht muss du die noch in die item proto einfügen.

kannst du dir rüsstung anziehen?

ist sie sichtbar?

wenn nicht musst du sie noch in die item list einfügen