[AJUDA URGENTE!!!] Fix Swift emulador 06.10.13 0:00
Alguem me ajuda com algum fix que funfa no emulador swift?? Eu preciso urgente acabei de divulga meu hotel e agora preciso do fix quem me arruma do meu +. O fix e para os mobis somem dos quartos
http://www.power-pixel.net/t48101-
DROP PROCEDURE IF EXISTS `getroomitems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)BEGINSELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedByFROM items_roomsJOIN 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
DROP PROCEDURE IF EXISTS `getroomitems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)BEGINSELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedByFROM items_roomsJOIN 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 ;-- ------------------------------ Procedure structure for `getuseritems`-- ----------------------------DROP PROCEDURE IF EXISTS `getuseritems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)BEGINSELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_dataFROM items_usersJOIN 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 ;
DROP PROCEDURE IF EXISTS `getroomitems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)BEGINSELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedByFROM items_roomsJOIN 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 ;-- ------------------------------ Procedure structure for `getuseritems`-- ----------------------------DROP PROCEDURE IF EXISTS `getuseritems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)BEGINSELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_dataFROM items_usersJOIN 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 ;
DROP PROCEDURE IF EXISTS `getroomitems`;[font=Verdana, Arial, Helvetica, sans-serif][/font]DELIMITER ;;[font=Verdana, Arial, Helvetica, sans-serif][/font]CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)[font=Verdana, Arial, Helvetica, sans-serif][/font]BEGIN[font=Verdana, Arial, Helvetica, sans-serif][/font]SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedBy[font=Verdana, Arial, Helvetica, sans-serif][/font]FROM items_rooms[font=Verdana, Arial, Helvetica, sans-serif][/font]JOIN items ON (items.item_id = items_rooms.item_id)[font=Verdana, Arial, Helvetica, sans-serif][/font]LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)[font=Verdana, Arial, Helvetica, sans-serif][/font]WHERE items_rooms.room_id = roomid;[font=Verdana, Arial, Helvetica, sans-serif][/font]END[font=Verdana, Arial, Helvetica, sans-serif][/font];;[font=Verdana, Arial, Helvetica, sans-serif][/font]DELIMITER ;[font=Verdana, Arial, Helvetica, sans-serif][/font][font=Verdana, Arial, Helvetica, sans-serif][/font]-- ----------------------------[font=Verdana, Arial, Helvetica, sans-serif][/font]-- Procedure structure for `getuseritems`[font=Verdana, Arial, Helvetica, sans-serif][/font]-- ----------------------------[font=Verdana, Arial, Helvetica, sans-serif][/font]DROP PROCEDURE IF EXISTS `getuseritems`;[font=Verdana, Arial, Helvetica, sans-serif][/font]DELIMITER ;;[font=Verdana, Arial, Helvetica, sans-serif][/font]CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)[font=Verdana, Arial, Helvetica, sans-serif][/font]BEGIN[font=Verdana, Arial, Helvetica, sans-serif][/font]SELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_data[font=Verdana, Arial, Helvetica, sans-serif][/font]FROM items_users[font=Verdana, Arial, Helvetica, sans-serif][/font]JOIN items ON (items.item_id = items_users.item_id)[font=Verdana, Arial, Helvetica, sans-serif][/font]LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)[font=Verdana, Arial, Helvetica, sans-serif][/font]WHERE items_users.user_id = userid;[font=Verdana, Arial, Helvetica, sans-serif][/font]END[font=Verdana, Arial, Helvetica, sans-serif][/font];;[font=Verdana, Arial, Helvetica, sans-serif][/font]DELIMITER ;
DROP PROCEDURE IF EXISTS `getroomitems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)BEGINSELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedByFROM items_roomsJOIN 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 ;-- ------------------------------ Procedure structure for `getuseritems`-- ----------------------------DROP PROCEDURE IF EXISTS `getuseritems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)BEGINSELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_dataFROM items_usersJOIN 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 ;
DROP PROCEDURE IF EXISTS `getroomitems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)BEGINSELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedByFROM items_roomsJOIN 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 ;-- ------------------------------ Procedure structure for `getuseritems`-- ----------------------------DROP PROCEDURE IF EXISTS `getuseritems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)BEGINSELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_dataFROM items_usersJOIN 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 ;
DROP PROCEDURE IF EXISTS `getroomitems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)BEGINSELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data, items.placedByFROM items_roomsJOIN 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 ;
DROP PROCEDURE IF EXISTS `getuseritems`;DELIMITER ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN userid int(10) unsigned)BEGINSELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_dataFROM items_usersJOIN 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 ;
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.rareid, items.group_data, items.placedBy
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 ;
-- ----------------------------
-- 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.rareid, 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)
WHERE items_users.user_id = userid;
END
;;
DELIMITER ;
Recomendamos a BH Servers com proteção DDOS gratuita em Cloud Server de alta performance. Entrega imediata.