Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER $$
- --
- -- Procedures
- --
- 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$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(
- IN userid int(10) unsigned
- )
- BEGIN
- SELECT items_users.item_id, items.base_id, items_extradata.data
- FROM items_users
- JOIN items ON (items.item_id = items_users.item_id)
- LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
- WHERE items_users.user_id = userid;
- END$$
- DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement