DELIMITER $$---- Procedimientos--CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN roomid int(10) unsigned)BEGINSELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.dat aFROM items_roomsJOIN items ON (items.item_id = items_rooms.item_id)LEFT JOIN items_extradata ON (items_extradata.ite m_id = items.item_id)WHERE items_rooms.room_id = roomid;END$$CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)BEGINSELECT items_users.item_id, items.base_id, items_extradata.dat aFROM items_usersJOIN items ON (items.item_id = items_users.item_id)LEFT JOIN items_extradata ON (items_extradata.ite m_id = items.item_id)WHERE items_users.user_id = userid;END$$DELIMITER ;
No hay comentarios:
Publicar un comentario