Esses são os Fix para você aplicar na database new crypto , já foi testado , mais por segurança faça um backup de sua database.
Fix Mobs Sumir
- Spoiler:
-- 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 ;
