1
2
3
4
5
6
7
8
| $mAchat = $bdd->prepare("INSERT INTO rooms(roomtype, caption, owner, description, category, state, users_now, users_max, model_name, score, tags, password, wallpaper, floor, landscape, allow_pets, allow_pets_eat, room_blocking_disabled, allow_hidewall, wallthick, floorthick, group_id, mute_settings, ban_settings, kick_settings, chat_mode, chat_size, chat_speed, chat_extra_flood, chat_hearing_distance, trade_settings, push_enabled, pull_enabled, enables_enabled, respect_notifications_enabled, pet_morphs_allowed, spull_enabled, spush_enabled, frapper_enabled) VALUES (?, ?, ?, (SELECT description, category, state, users_now, users_max, model_name, score, tags, password, wallpaper, floor, landscape, allow_pets, allow_pets_eat, room_blocking_disabled, allow_hidewall, wallthick, floorthick, group_id, mute_settings, ban_settings, kick_settings, chat_mode, chat_size, chat_speed, chat_extra_flood, chat_hearing_distance, trade_settings, push_enabled, pull_enabled, enables_enabled, respect_notifications_enabled, pet_morphs_allowed, spull_enabled, spush_enabled, frapper_enabled)) FROM rooms WHERE id = ?;");
$mAchat->execute(array("private", "Studio", $_SESSION['id'], "793"));
$sid = $bdd->query("SELECT MAX(id) FROM rooms");
$did = $sid->fetch(PDO::FETCH_ASSOC);
$mMembre = $bdd->prepare("INSERT INTO items(user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos, limited_number, limited_stack) VALUES (?, ?, (SELECT base_item, extra_data, x, y, z, rot, wall_pos, limited_number, limited_stack)) FROM items WHERE room_id = ?;");
$mMembre->execute(array($_SESSION['id'], $did, "793")); |
