• Das in deine Datenbank importieren:

    -- ------------------------------ Procedure structure for `getroomitems`-- ----------------------------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 ;

    HTML | PHP | CSS | MYSQL

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!