Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------------
- -- Host: 127.0.0.1
- -- Server version: 5.1.63-community - MySQL Community Server (GPL)
- -- Server OS: Win64
- -- HeidiSQL version: 7.0.0.4053
- -- Date/time: 2012-09-02 22:13:54
- -- --------------------------------------------------------
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET NAMES utf8 */;
- /*!40014 SET FOREIGN_KEY_CHECKS=0 */;
- -- Dumping database structure for novaemulator_1
- CREATE DATABASE IF NOT EXISTS `novaemulator_1` /*!40100 DEFAULT CHARACTER SET utf8 */;
- USE `novaemulator_1`;
- -- Dumping structure for procedure novaemulator_1.getroomitems
- DELIMITER //
- 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//
- DELIMITER ;
- -- Dumping structure for procedure novaemulator_1.getuseritems
- DELIMITER //
- 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 ;
- /*!40014 SET FOREIGN_KEY_CHECKS=1 */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Add Comment
Please, Sign In to add comment