R63B Raum fehler...

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Procedure structure for dofastfoodlogin
-- ----------------------------
DROP PROCEDURE IF EXISTS `dofastfoodlogin`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `dofastfoodlogin`(IN `sso_ticket` VARCHAR(50))
NO SQL
BEGIN
SELECT users.username, users.id, users.credits, users.look, users.gender, user_fastfood.fastGames, user_fastfood.parachute, user_fastfood.missile, user_fastfood.shield, user_fastfood.ff_points FROM users
LEFT JOIN user_fastfood ON (user_fastfood.userid =users.id)
RIGHT JOIN user_tickets ON (user_tickets.userid = users.id)
WHERE user_tickets.sessionticket=sso_ticket;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for getroomitems
-- ----------------------------
DROP PROCEDURE IF EXISTS `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, items_limited.limited_number, items_group.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)

LEFT JOIN items_limited ON (items_limited.item_id = items.item_id)

LEFT JOIN items_group ON (items_group.id = items.item_id)

WHERE items_rooms.room_id = roomid;

END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for getusergroups
-- ----------------------------
DROP PROCEDURE IF EXISTS `getusergroups`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `getusergroups`(IN `userid` INT(10) UNSIGNED)
BEGIN

SELECT groups.*

FROM groups_users

JOIN groups ON (groups.id = groups_users.groupid)

WHERE groups_users.userid = userid AND groups_users.acepted = '1';

END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for getuseritems
-- ----------------------------
DROP PROCEDURE IF EXISTS `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, items_limited.limited_number, items_group.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)

LEFT JOIN items_limited ON (items_limited.item_id = items.item_id)

LEFT JOIN items_group ON (items_group.id = items.item_id)

WHERE items_users.user_id = userid;

END
;;
DELIMITER ;

-- ----------------------------
-- Function structure for convToSmallInt
-- ----------------------------
DROP FUNCTION IF EXISTS `convToSmallInt`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `convToSmallInt`(n INTEGER) RETURNS smallint(6)
RETURN n
;;
DELIMITER ;