errors

Stevee

Posting Freak
Mar 29, 2011
580
35
How would I possibly fix this error? [Err] 1304 - PROCEDURE getroomitems already exists
[Err] --
-- Base de datos: `habbo`
--

--
-- 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;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
 

Users who are viewing this thread

Top