[AJUDA] Mobis somem ao relogar [URGENTE] 08.07.13 11:36
Pessoal eu uso a DB, SWF e o Emulador do Daniel SDP (Atualizado 04/07)... Quando eu coloco uma mobi no quarto, ao relogar esse mobi some do quarto e do meu inventário...
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]DELIMITER $$[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]--[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]-- Procedimientos[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]--[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`([/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]IN roomid int(10) unsigned[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif])[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]BEGIN[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]FROM items_rooms[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]JOIN items ON (items.item_id = items_rooms.item_id)[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]WHERE items_rooms.room_id = roomid;[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]END$$[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`([/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]IN userid int(10) unsigned[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif])[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]BEGIN[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]SELECT items_users.item_id, items.base_id, items_extradata.data[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]FROM items_users[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]JOIN items ON (items.item_id = items_users.item_id)[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]WHERE items_users.user_id = userid;[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]END$$[/font][/color][color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif][/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]DELIMITER ;[/font][/color]
[color=#4e565e][font='Trebuchet MS', tahoma, helvetica, arial, sans-serif]
Recomendamos a BH Servers com proteção DDOS gratuita em Cloud Server de alta performance. Entrega imediata.