OceanusMT2 110 Posted May 14, 2014 (edited) Alguem por amor de deus me diz o que esta mal ai?!?! Nas files originais as pedras estão todas maradas. Eu estou a tentar reparar isso! Eu meto essas pedras, dou /reload p e o jogo fica 100%. A porcaria é que não posso dar reload na máquina, porque senão não passo do "vais ser ligado". Tenho a certeza 100000000% absoluta que o problema é unicamente aqui. Alguem me diz porque? Sério..... ja estou a dois dias de volta disto -.- REPLACE INTO `item_proto` VALUES (28430, 'Pedra da Penetracao+4', 'Pedra da Penetracao+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0); REPLACE INTO `item_proto` VALUES (28530, 'Pedra da Penetracao+5', 'Pedra da Penetracao+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0); REPLACE INTO `item_proto` VALUES (28630, 'Gema da Penetracao+6', 'Gema da Penetracao+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0); REPLACE INTO `item_proto` VALUES (28730, 'Gema da Penetracao+7', 'Gema da Penetracao+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0); REPLACE INTO `item_proto` VALUES (28830, 'Gema da Penetracao+8', 'Gema da Penetracao+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0); REPLACE INTO `item_proto` VALUES (28930, 'Gema da Penetracao+9', 'Gema da Penetracao+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0); REPLACE INTO `item_proto` VALUES (28431, 'Pedra de Golpe Mortal+4', 'Pedra de Golpe Mortal+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28531, 'Pedra de Golpe Mortal+5', 'Pedra de Golpe Mortal+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28631, 'Gema de Golpe Mortal+6', 'Gema de Golpe Mortal+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28731, 'Gema de Golpe Mortal+7', 'Gema de Golpe Mortal+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28831, 'Gema de Golpe Mortal+8', 'Gema de Golpe Mortal+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28931, 'Gema de Golpe Mortal+9', 'Gema de Golpe Mortal+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28432, 'Pedra da Repeticao+4', 'Pedra da Repeticao+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28532, 'Pedra da Repeticao+5', 'Pedra da Repeticao+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28632, 'Gema da Repeticao+6', 'Gema da Repeticao+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28732, 'Gema da Repeticao+7', 'Gema da Repeticao+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28832, 'Gema da Repeticao+8', 'Gema da Repeticao+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 40, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28932, 'Gema da Repeticao+9', 'Gema da Repeticao+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28437, 'Pedra Anti-Monstros+4', 'Pedra Anti-Monstros+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28537, 'Pedra Anti-Monstros+5', 'Pedra Anti-Monstros+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63, 40, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28637, 'Gema Anti-Monstros+6', 'Gema Anti-Monstros+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28737, 'Gema Anti-Monstros+7', 'Gema Anti-Monstros+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28837, 'Gema Anti-Monstros+8', 'Gema Anti-Monstros+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28937, 'Gema Anti-Monstros+9', 'Gema Anti-Monstros+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28438, 'Pedra da Evasão+4', 'Pedra da Evasão+4', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28538, 'Pedra da Evasão+5', 'Pedra da Evasão+5', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28638, 'Gema da Evasão+6', 'Gema da Evasão+6', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28738, 'Gema da Evasão+7', 'Gema da Evasão+7', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28838, 'Gema da Evasão+8', 'Gema da Evasão+8', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28938, 'Gema da Evasão+9', 'Gema da Evasão+9', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28439, 'Pedra da Agilidade+4', 'Pedra da Agilidade+4', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28539, 'Pedra da Agilidade+5', 'Pedra da Agilidade+5', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28639, 'Gema da Agilidade+6', 'Gema da Agilidade+6', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28739, 'Gema da Agilidade+7', 'Gema da Agilidade+7', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28839, 'Gema da Agilidade+8', 'Gema da Agilidade+8', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28939, 'Gema da Agilidade+9', 'Gema da Agilidade+9', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28440, 'Pedra da Magia+4', 'Pedra da Magia+4', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28540, 'Pedra da Magia+5', 'Pedra da Magia+5', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28640, 'Gema da Magia+6', 'Gema da Magia+6', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28740, 'Gema da Magia+7', 'Gema da Magia+7', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 600, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28840, 'Gema da Magia+8', 'Gema da Magia+8', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28940, 'Gema da Magia+9', 'Gema da Magia+9', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28441, 'Pedra da Vida+4', 'Pedra da Vida+4', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28541, 'Pedra da Vida+5', 'Pedra da Vida+5', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28641, 'Gema da Vida+6', 'Gema da Vida+6', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28741, 'Gema da Vida+7', 'Gema da Vida+7', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28841, 'Gema da Vida+8', 'Gema da Vida+8', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28941, 'Gema da Vida+9', 'Gema da Vida+9', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28442, 'Pedra da Defesa+4', 'Pedra da Defesa+4', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28542, 'Pedra da Defesa+5', 'Pedra da Defesa+5', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28642, 'Gema da Defesa+6', 'Gema da Defesa+6', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28742, 'Gema da Defesa+7', 'Gema da Defesa+7', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28842, 'Gema da Defesa+8', 'Gema da Defesa+8', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54, 150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28942, 'Gema da Defesa+9', 'Gema da Defesa+9', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28443, 'Pedra da Pressa+4', 'Pedra da Pressa+4', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28543, 'Pedra da Pressa+5', 'Pedra da Pressa+5', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28643, 'Gema da Pressa+6', 'Gema da Pressa+6', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28743, 'Gema da Pressa+7', 'Gema da Pressa+7', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28843, 'Gema da Pressa+8', 'Gema da Pressa+8', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 40, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28943, 'Gema da Pressa+9', 'Gema da Pressa+9', 10, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28433, 'Pedra Anti-Guerreiro+4', 'Pedra Anti-Guerreiro+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28533, 'Pedra Anti-Guerreiro+5', 'Pedra Anti-Guerreiro+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28633, 'Gema Anti-Guerreiro+6', 'Gema Anti-Guerreiro+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28733, 'Gema Anti-Guerreiro+7', 'Gema Anti-Guerreiro+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28833, 'Gema Anti-Guerreiro+8', 'Gema Anti-Guerreiro+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28933, 'Gema Anti-Guerreiro+9', 'Gema Anti-Guerreiro+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28434, 'Pedra Anti-Ninja+4', 'Pedra Anti-Ninja+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28534, 'Pedra Anti-Ninja+5', 'Pedra Anti-Ninja+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28634, 'Gema Anti-Ninja+6', 'Gema Anti-Ninja+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28734, 'Gema Anti-Ninja+7', 'Gema Anti-Ninja+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28834, 'Gema Anti-Ninja+8', 'Gema Anti-Ninja+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28934, 'Gema Anti-Ninja+9', 'Gema Anti-Ninja+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28435, 'Pedra Anti-Sura+4', 'Pedra Anti-Sura+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 61, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28535, 'Pedra Anti-Sura+5', 'Pedra Anti-Sura+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 61, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28635, 'Gema Anti-Sura+6', 'Gema Anti-Sura+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 61, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28735, 'Gema Anti-Sura+7', 'Gema Anti-Sura+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 61, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28835, 'Gema Anti-Sura+8', 'Gema Anti-Sura+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 61, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28935, 'Gema Anti-Sura+9', 'Gema Anti-Sura+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 61, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28436, 'Pedra Anti-Xamã+4', 'Pedra Anti-Xamã+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28536, 'Pedra Anti-Xamã+5', 'Pedra Anti-Xamã+5', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28636, 'Gema Anti-Xamã+6', 'Gema Anti-Xamã+6', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28736, 'Gema Anti-Xamã+7', 'Gema Anti-Xamã+7', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28836, 'Gema Anti-Xamã+8', 'Gema Anti-Xamã+8', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, -1, -1, -1, -1, -1, -1, 0, 3, 0); REPLACE INTO `item_proto` VALUES (28936, 'Gema Anti-Xamã+9', 'Gema Anti-Xamã+9', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 62, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, -1, -1, -1, -1, -1, -1, 0, 3, 0); Não sei fazer o Spoilet, peço desculpas desde já :( Edited May 14, 2014 by morfo2 Spoiler adicionado (see edit history) Share this post Link to post Share on other sites
0 morfo2 4,680 Posted May 14, 2014 É "spoiler" que se diz e basta meteres a tag [ spoiler ] no começo e a tag [ / spoiler ] no fim (sem espaçamento).Não faças double-post. Share this post Link to post Share on other sites
0 Sprint 6 Posted May 14, 2014 O problema está que n é Replace INTO mas sim "INSERT INTO". Share this post Link to post Share on other sites
0 OceanusMT2 110 Posted May 14, 2014 Mas se eu faço "INSERT INTO". diz que ja existe o ID. Tenho de apagar tudo? Sério? é que eu ja usei várias vazes o REPLACE para poder substituir outras coisas que estavam mal. : Share this post Link to post Share on other sites
0 ThatGuyPT 457 Posted May 14, 2014 O problema está que n é Replace INTO mas sim "INSERT INTO". Mim conta mais por favor :like: 1 Annie reacted to this Share this post Link to post Share on other sites
0 Annie 1,207 Posted May 14, 2014 Mim conta mais por favor :like:AHUEHUEHUEHUE -- // --O problema está que n é Replace INTO mas sim "INSERT INTO".Que INSERT, se ele já tem os valores na tabela não pode inserir o que já tem , se quer alterar os valores atuais é algo tipo UPDATE. Share this post Link to post Share on other sites
0 OceanusMT2 110 Posted May 14, 2014 Mim conta mais por favor :like: Vou ter de apagar as linhas todas uma a uma para poder fazer o INSERT? Share this post Link to post Share on other sites
0 OceanusMT2 110 Posted May 14, 2014 AHUEHUEHUEHUE -- // --Que INSERT, se ele já tem os valores na tabela não pode inserir o que já tem , se quer alterar os valores atuais é algo tipo UPDATE. o comando update não faz nada.... da erro: UPDATE INTO `item_proto` VALUES (28430, 'Pedra da Penetracao+4', 'Pedra da Penetracao+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0); [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO `item_proto` VALUES (28430, 'Pedra da Penetracao+4', 'Pedra da Penetracao+4' at line 1 Share this post Link to post Share on other sites
0 Annie 1,207 Posted May 14, 2014 o comando update não faz nada.... da erro: UPDATE INTO `item_proto` VALUES (28430, 'Pedra da Penetracao+4', 'Pedra da Penetracao+4', 10, 0, 0, 1, 0, 0, 16, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, -1, -1, -1, -1, -1, -1, 0, 0, 0);[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO `item_proto` VALUES (28430, 'Pedra da Penetracao+4', 'Pedra da Penetracao+4' at line 1Porque essa não é a sintaxe do método UPDATE.É algo do genero:UPDATE * FROM database.tabela SET coluna1 = "valorNovoParaColuna1" WHERE name = "Exemplo"; Share this post Link to post Share on other sites
0 OceanusMT2 110 Posted May 14, 2014 o 67 tambem estava todo marado. Apenas fiz: UPDATE INTO `item_proto` VALUES...... e ficou 100%. Quando meto armas e depois se quiser alterar algo, uso sempre o UPDATE INTO Porque raio não posso fazer agora? Ja agora a versão do game é a 34083. Share this post Link to post Share on other sites
0 OceanusMT2 110 Posted May 14, 2014 Só para voltar a lembrar. Que se eu fizer com o UPDATE e depois ingame fizer /reload p trabalha tudo 100%. O problema é que depois não posso logar as contas -.- Share this post Link to post Share on other sites
0 OceanusMT2 110 Posted May 14, 2014 Apaguei as pedras todas. Voltei a tentar adicionar as query mas desta vez com o INSERT INTO.... não da para logar na mesma.... wtf -.- Share this post Link to post Share on other sites
0 OceanusMT2 110 Posted May 16, 2014 ...Mas ao quarto dia tudo ficou resolvido.conclusão:nunca, mas nunca mesmo utilizem uma query de outro item. Eu peguei uma query da pedra +4 porque era a única que trabalhava. Depoix fiz copy-paste dessa query e alterei tudo para as restantes pedras... Nunca funcionou!fiz uma query nova para cada pedra e ficou tudo 100%....Resolvido, podem fechar!Agradeço a mim por ser tao inteligente xD Share this post Link to post Share on other sites
0 .тιαgσ 624 Posted May 16, 2014 ...Mas ao quarto dia tudo ficou resolvido.conclusão:nunca, mas nunca mesmo utilizem uma query de outro item. Eu peguei uma query da pedra +4 porque era a única que trabalhava. Depoix fiz copy-paste dessa query e alterei tudo para as restantes pedras... Nunca funcionou!fiz uma query nova para cada pedra e ficou tudo 100%....Resolvido, podem fechar!Agradeço a mim por ser tao inteligente xD Share this post Link to post Share on other sites
Spoiler adicionado (see edit history)
Share this post
Link to post
Share on other sites