Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 269737" data-attributes="member: 36373">I am sure one of you Expert Coders here on devbest can figure out what is wrong with thisThis is a screenshot of wth its doing:<img src="http://i.imgur.com/qdMJYsj.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />It's suppose to give a list of MY rooms NOT the welcome rooms! Thanks[CODE]&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix pixellightblue &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;Bot Shop&lt;/h2&gt;&lt;div class=&quot;box-content&quot;&gt;&lt;div style=&quot;text-align: left;&quot;&gt;&lt;div style=&quot;padding:5px&quot;&gt;&nbsp; &nbsp; &lt;form name=&quot;form&quot; action=&quot;/bots/insert.php&quot; onsubmit=&quot;return validateForm();&quot; method=&quot;post&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;span title=&quot;Don&amp;#39;t worry about the ID, it has been corrected for you.&quot;&gt;Bot ID: &lt;/span&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;id&quot; value=&quot;&lt;?php&nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT * FROM bots ORDER BY id DESC LIMIT 0,1&quot;;&nbsp; &nbsp; &nbsp; &nbsp; $result = mysql_query($sql);&nbsp; &nbsp; &nbsp; &nbsp; $info = mysql_fetch_array($result);&nbsp; &nbsp; &nbsp; &nbsp; $id = $info['id'];&nbsp; &nbsp; &nbsp; &nbsp; $addition = $id + 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo $addition;&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&quot; readonly /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span title=&quot;Pick your room&quot;&gt;Room ID: &lt;/span&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;select name=&quot;room_id&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; $getIDs = mysql_query('SELECT *, caption FROM rooms WHERE owner = &quot;'.$_SESSION['user']['username'].'&quot;');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_array($getIDs)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;option&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo $row['caption'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;br /&gt;&lt;/option&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span title=&quot;Name&quot;&gt;Bot name: &lt;/span&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;name&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span title=&quot;Motto&quot;&gt;Bot motto: &lt;/span&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;motto&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span title=&quot;Look&quot;&gt;Look: &lt;/span&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;look&quot;&nbsp; value=&quot;hd-180-7.sh-290-110.lg-270-91.ch-809-62.hr-828-45&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;span title=&quot;Position&quot;&gt;Coordinates: &lt;/span&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; X: &lt;input type=&quot;number&quot; name=&quot;x&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; Y: &lt;input type=&quot;number&quot; name=&quot;y&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; Z: &lt;input type=&quot;number&quot; name=&quot;z&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; Rotation: &lt;input type=&quot;number&quot; name=&quot;rotation&quot; /&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span title=&quot;Mode&quot;&gt;Walk mode: &lt;/span&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;select name=&quot;walk_mode&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option&gt;stand&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option&gt;freeroam&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option&gt;specified_range&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;Next Step &amp;raquo&quot; class=&quot;submit&quot;&gt;&nbsp; &nbsp; &lt;/form&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }&lt;/script&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;[/CODE]@[USER=37120]Nehalem[/USER]&nbsp; you helped me with my last code issue and Jerry you are pretty smart @[USER=35321]JerryCool[/USER]</blockquote>

[QUOTE="JayC, post: 269737, member: 36373"] [B][I]I am sure one of you Expert Coders here on devbest can figure out what is wrong with this[/I][/B] This is a screenshot of wth its doing: [IMG]http://i.imgur.com/qdMJYsj.png[/IMG] [B]It's suppose to give a list of MY rooms [I]NOT[/I] the welcome rooms! Thanks[/B] [CODE] <div class="habblet-container "> <div class="cbb clearfix pixellightblue "> <h2 class="title">Bot Shop</h2> <div class="box-content"> <div style="text-align: left;"> <div style="padding:5px"> <form name="form" action="/bots/insert.php" onsubmit="return validateForm();" method="post"> Bot ID: <input type="text" name="id" value="<?php $sql = "SELECT * FROM bots ORDER BY id DESC LIMIT 0,1"; $result = mysql_query($sql); $info = mysql_fetch_array($result); $id = $info['id']; $addition = $id + 1; echo $addition; ?>" readonly /> Room ID: <select name="room_id"> <?php $getIDs = mysql_query('SELECT *, caption FROM rooms WHERE owner = "'.$_SESSION['user']['username'].'"'); while($row = mysql_fetch_array($getIDs)){ echo "<option>"; echo $row['caption']; echo " </option>"; } ?> </select> Bot name: <input type="text" name="name" /> Bot motto: <input type="text" name="motto" /> Look: <input type="text" name="look" value="hd-180-7.sh-290-110.lg-270-91.ch-809-62.hr-828-45" /> Coordinates: X: <input type="number" name="x" /> Y: <input type="number" name="y" /> Z: <input type="number" name="z" /> Rotation: <input type="number" name="rotation" /> Walk mode: <select name="walk_mode"> <option>stand</option> <option>freeroam</option> <option>specified_range</option> </select> <input type="submit" value="Next Step &raquo" class="submit"> </form> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> </div> </div> </div></div> </div>[/CODE] @[USER=37120]Nehalem[/USER] you helped me with my last code issue and Jerry you are pretty smart @[USER=35321]JerryCool[/USER] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members