Hey
Habe mir mal n paar Querys geholt
Und irgendwie nimmt es mein Server (2010 Daroo Files) nicht an....
Also wenn ich die Querys angucke dann sehen die schon ein bisschen komisch aus xD. Kann mir einer erklären wie ich die umschreiben muss dass sie funktionieren ? Und wäre einer vielleicht so lieb und würde die erste Query richtig umschreiben so dass ich nachher alle umschreiben kann.
Vielen Dank !
Euer Schlafhut
Habe mir mal n paar Querys geholt
PHP Code:
INSERT INTO player.item_proto VALUES (0320, 'Spada Dragonica +0', 'Spada Dragonica+0', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 233, 273, 100, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0321, 'Spada Dragonica +1', 'Spada Dragonica+1', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 241, 279, 150, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0322, 'Spada Dragonica +2', 'Spada Dragonica+2', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 244, 284, 200, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0323, 'Spada Dragonica +3', 'Spada Dragonica+3', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 245, 286, 250, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0324, 'Spada Dragonica +4', 'Spada Dragonica+4', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 250, 290, 300, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0325, 'Spada Dragonica +5', 'Spada Dragonica+5', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 252, 292, 325, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0326, 'Spada Dragonica +6', 'Spada Dragonica+6', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 254, 294, 350, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0327, 'Spada Dragonica +7', 'Spada Dragonica+7', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 260, 298, 400, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0328, 'Spada Dragonica +8', 'Spada Dragonica+8', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 261, 300, 450, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (0329, 'Spada Dragonica +9', 'Spada Dragonica+9', 1, 0, 0, 2, 312, 1, 16, 0, 10000, 10000, 320, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 2, 16, 8, 0, 54, 86, 270, 310, 500, -1, -1, -1, -1, -1, -1,0, 3, 0);
INSERT INTO player.item_proto VALUES (3250, 'Spadone spirito di Drago+0', 'Spadone spirito di Drago+0', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 3, 71, 2, 0, 0, 0, 216, 248, 123, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3251, 'Spadone spirito di Drago+1', 'Spadone spirito di Drago+1', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 6, 71, 3, 0, 0, 0, 216, 248, 156, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3252, 'Spadone spirito di Drago+2', 'Spadone spirito di Drago+2', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 8, 71, 3, 0, 0, 0, 216, 248, 212, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3253, 'Spadone spirito di Drago+3', 'Spadone spirito di Drago+3', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 10, 71, 5, 0, 0, 0, 216, 248, 254, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3254, 'Spadone spirito di Drago+4', 'Spadone spirito di Drago+4', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 12, 71, 5, 0, 0, 0, 216, 248, 298, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3255, 'Spadone spirito di Drago+5', 'Spadone spirito di Drago+5', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 14, 71, 7, 0, 0, 0, 216, 248, 342, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3256, 'Spadone spirito di Drago+6', 'Spadone spirito di Drago+6', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 17, 71, 7, 0, 0, 0, 216, 248, 397, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3257, 'Spadone spirito di Drago+7', 'Spadone spirito di Drago+7', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 20, 71, 9, 0, 0, 0, 216, 248, 462, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3258, 'Spadone spirito di Drago+8', 'Spadone spirito di Drago+8', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 25, 71, 12, 0, 0, 0, 216, 248, 513, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO player.item_proto VALUES (3259, 'Spadone spirito di Drago+9', 'Spadone spirito di Drago+9', 1, 3, 0, 3, 312, 1, 16, 0, 10000, 10000, 3271, 0, 0, 15, 1, 105, 0, 0, 7, 25, 17, 30, 71, 15, 0, 0, 0, 216, 248, 588, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO `item_proto` VALUES (1190, 'Coltello del Sole +0 ', 'Coltello del Sole +0', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8081, 19, 0, 5, 1, 105, 0, 0, 7, 120, 17, 3, 15, 2, 0, 0, 0, 211, 223, 150, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO `item_proto` VALUES (1191, 'Coltello del Sole +1 ', 'Coltello del Sole +1', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8082, 20, 0, 5, 1, 105, 0, 0, 7, 120, 17, 6, 15, 3, 0, 0, 0, 221, 233, 152, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO `item_proto` VALUES (1192, 'Coltello del Sole +2 ', 'Coltello del Sole +2', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8083, 21, 0, 5, 1, 105, 0, 0, 7, 120, 17, 8, 15, 3, 0, 0, 0, 231, 243, 156, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO `item_proto` VALUES (1193, 'Coltello del Sole +3 ', 'Coltello del Sole +3', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8084, 22, 0, 5, 1, 105, 0, 0, 7, 120, 17, 10, 15, 5, 0, 0, 0, 241, 253, 161, -1, -1, -1, -1, -1, -1, 0, 3, 0);
INSERT INTO `item_proto` VALUES (1194, 'Coltello del Sole +4 ', 'Coltello del Sole +4', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8085, 24, 0, 5, 1, 105, 0, 0, 7, 120, 17, 12, 15, 5, 0, 0, 0, 251, 263, 166, -1, -1, -1, -1, -1, -1, 5, 3, 0);
INSERT INTO `item_proto` VALUES (1195, 'Coltello del Sole +5 ', 'Coltello del Sole +5', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8086, 24, 0, 5, 1, 105, 0, 0, 7, 120, 17, 14, 15, 7, 0, 0, 0, 261, 273, 172, -1, -1, -1, -1, -1, -1, 10, 3, 0);
INSERT INTO `item_proto` VALUES (1196, 'Coltello del Sole +6 ', 'Coltello del Sole +6', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8087, 703, 0, 5, 1, 105, 0, 0, 7, 120, 17, 17, 15, 7, 0, 0, 0, 271, 283, 177, -1, -1, -1, -1, -1, -1, 15, 3, 0);
INSERT INTO `item_proto` VALUES (1197, 'Coltello del Sole +7 ', 'Coltello del Sole +7', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8088, 704, 0, 5, 1, 105, 0, 0, 7, 120, 17, 20, 15, 9, 0, 0, 0, 281, 293, 180, -1, -1, -1, -1, -1, -1, 20, 3, 0);
INSERT INTO `item_proto` VALUES (1198, 'Coltello del Sole +8 ', 'Coltello del Sole +8', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8089, 705, 0, 5, 1, 105, 0, 0, 7, 120, 17, 25, 15, 12, 0, 0, 0, 291, 303, 186, -1, -1, -1, -1, -1, -1, 25, 3, 0);
INSERT INTO `item_proto` VALUES (1199, 'Coltello del Sole +9 ', 'Coltello del Sole +9', 1, 1, 0, 1, 52, 1, 16, '', 30000, 100, 8090, 706, 0, 5, 1, 105, 0, 0, 7, 120, 17, 30, 15, 15, 0, 0, 0, 301, 313, 190, -1, -1, -1, -1, -1, -1, 30, 3, 0);
Also wenn ich die Querys angucke dann sehen die schon ein bisschen komisch aus xD. Kann mir einer erklären wie ich die umschreiben muss dass sie funktionieren ? Und wäre einer vielleicht so lieb und würde die erste Query richtig umschreiben so dass ich nachher alle umschreiben kann.
Vielen Dank !
Euer Schlafhut