Sexy SWF bug.

-- ----------------------------
--  Procedure definition for `convToSmallInt`
-- ----------------------------
DROP FUNCTION IF EXISTS `convToSmallInt`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `convToSmallInt`(n INTEGER) RETURNS SMALLINT(6)
RETURN n
;;
DELIMITER ;
 
-- ----------------------------
--  Procedure definition 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 definition 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 definition 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 definition 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 ;