Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 381606" data-attributes="member: 36373">Another version added:[CODE]DROP TABLE IF EXISTS `room_starters`;CREATE TABLE `room_starters` (&nbsp; `id` int(11) unsigned NOT NULL AUTO_INCREMENT,&nbsp; PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;&lt;?php$randomRoomID = mysql_fetch_assoc(mysql_query(&quot;SELECT `id` FROM room_starters ORDER BY RAND() LIMIT 1&quot;));$getRoom = mysql_fetch_assoc(mysql_query(&quot;SELECT * FROM `rooms` WHERE id = '&quot;.$randomRoomID['id'].&quot;' LIMIT 1&quot;));$starterCaption = &quot;Welcome &quot; + $_SESSION['user']['username'];mysql_query(&quot;INSERT INTO `rooms` (roomtype, caption, owner, description, model_name, wallpaper, floor, wallthick, floorthick, allow_hidewall) VALUES ('public','&quot;.$starterCaption.&quot;','&quot;.$_SESSION['user']['id'].&quot;','Welcome to iHabbo','&quot;.$getRoom['model_name'].&quot;','&quot;.$getRoom['wallpaper'].&quot;','&quot;.$getRoom['floor'].&quot;','&quot;.$getRoom['wallthick'].&quot;','&quot;.$getRoom['floorthick'].&quot;','&quot;.$getRoom['allow_hidewall'].&quot;'));$lastRoomID = mysql_fetch_assoc(mysql_query(&quot;SELECT id FROM rooms ORDER BY `id` DESC LIMIT 1&quot;));$getItems = mysql_query(&quot;SELECT * FROM `items` WHERE room_id = '&quot;.$randomRoomID['id'].&quot;'&quot;);while($CurItem = mysql_fetch_assoc($getItems)){&nbsp;&nbsp; mysql_query(&quot;INSERT INTO `items` (user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos) VALUES ('&quot;.$_SESSION['user']['id'].&quot;','&quot;.$lastRoomID['id'].&quot;','&quot;.$getItems['base_item'].&quot;','&quot;.$getItems['extra_data'].&quot;','&quot;.$getItems['x'].&quot;','&quot;.$getItems['y'].&quot;','&quot;.$getItems['z'].&quot;','&quot;.$getItems['rot'].&quot;','&quot;.$getItems['wall_pos'].&quot;')&quot;);}?&gt;[/CODE]Add the table, put the room ID into the table, put the php code into the client and it will just grab directly from the room!</blockquote>

[QUOTE="JayC, post: 381606, member: 36373"] Another version added: [CODE]DROP TABLE IF EXISTS `room_starters`; CREATE TABLE `room_starters` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; <?php $randomRoomID = mysql_fetch_assoc(mysql_query("SELECT `id` FROM room_starters ORDER BY RAND() LIMIT 1")); $getRoom = mysql_fetch_assoc(mysql_query("SELECT * FROM `rooms` WHERE id = '".$randomRoomID['id']."' LIMIT 1")); $starterCaption = "Welcome " + $_SESSION['user']['username']; mysql_query("INSERT INTO `rooms` (roomtype, caption, owner, description, model_name, wallpaper, floor, wallthick, floorthick, allow_hidewall) VALUES ('public','".$starterCaption."','".$_SESSION['user']['id']."','Welcome to iHabbo','".$getRoom['model_name']."','".$getRoom['wallpaper']."','".$getRoom['floor']."','".$getRoom['wallthick']."','".$getRoom['floorthick']."','".$getRoom['allow_hidewall']."')); $lastRoomID = mysql_fetch_assoc(mysql_query("SELECT id FROM rooms ORDER BY `id` DESC LIMIT 1")); $getItems = mysql_query("SELECT * FROM `items` WHERE room_id = '".$randomRoomID['id']."'"); while($CurItem = mysql_fetch_assoc($getItems)){ mysql_query("INSERT INTO `items` (user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos) VALUES ('".$_SESSION['user']['id']."','".$lastRoomID['id']."','".$getItems['base_item']."','".$getItems['extra_data']."','".$getItems['x']."','".$getItems['y']."','".$getItems['z']."','".$getItems['rot']."','".$getItems['wall_pos']."')"); } ?>[/CODE] Add the table, put the room ID into the table, put the php code into the client and it will just grab directly from the room! [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members