Oi,qnd reinicio o emu os mobis somem,vi alguns tutos,mais o codigo que eu colocava na ''SQL'' dava erro.
O ERRO:
Error
SQL query:
DELIMITER $$--
-- Procedimientos
--
CREATE DEFINER = `root`@`localhost` PROCEDURE `getroomitems` ( IN roomid INT( 10 ) UNSIGNED ) BEGIN SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data
FROM items_rooms
JOIN items ON ( items.item_id = items_rooms.item_id )
LEFT JOIN items_extradata ON ( items_extradata.item_id = items.item_id )
WHERE items_rooms.room_id = roomid;
END$$
MySQL said:
#1304 - PROCEDURE getroomitems already exists
O ERRO:
Error
SQL query:
DELIMITER $$--
-- Procedimientos
--
CREATE DEFINER = `root`@`localhost` PROCEDURE `getroomitems` ( IN roomid INT( 10 ) UNSIGNED ) BEGIN SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data
FROM items_rooms
JOIN items ON ( items.item_id = items_rooms.item_id )
LEFT JOIN items_extradata ON ( items_extradata.item_id = items.item_id )
WHERE items_rooms.room_id = roomid;
END$$
MySQL said:
#1304 - PROCEDURE getroomitems already exists