Jump to content

Update Database value based on another value

Demont

By Demont
in PHP Coding Help

Recommended Posts

Demont Member

Demont

Posted
Posted

What I mean is, I have a custom script for a MUD(Multi-User Dungeon) to add rooms in the 'world', which is this:

 

<?php 
require("sessions.php");
include("connect.php");
include("userinfo.php");

$result = mysql_query("select * from rooms where room='$roomin' order by room"); 
while($row = mysql_fetch_array($result)){
  $roomname=$row['roomname'];
  $roomdesc=$row['roomdesc'];
  $room=$row['room'];
  $north=$row['north'];
  $south=$row['south'];
  $east=$row['east'];
  $west=$row['west'];
  $up=$row['up'];
  $down=$row['down'];
}



//This code runs if the form has been submitted
if (isset($_POST['submit'])) {

//This makes sure they did not leave any fields blank
if (!$_POST['roomname'] | !$_POST['roomdesc'] ) {
die('You did not complete all of the required fields');
}



// now we insert it into the database
mysql_query("UPDATE rooms
SET roomname='".$_POST['roomname']."', roomdesc='".$_POST['roomdesc']."', north='".$_POST['north']."', south='".$_POST['south']."', east='".$_POST['east']."', west='".$_POST['west']."', up='".$_POST['up']."', down='".$_POST['down']."', mnorth='".$_POST['mnorth']."', msouth='".$_POST['msouth']."', meast='".$_POST['meast']."', mwest='".$_POST['mwest']."', mup='".$_POST['mup']."', mdown='".$_POST['mdown']."'
WHERE room='$roomin'") or die(mysql_error());




?>

<title>The Roman Empire</title>
<body bgcolor="grey">
<table width="800"
       border="1"
       cellpadding="0"
       align="center"
       bgColor="CC0000">
<!-- Row 1 -->
<tr>
<td width="800" align="center" valign="middle">
<font size="5"><font color="gold">The Roman Empire</font></font>
<br>
<a href="http://www.tregame.com" border="0"><img src="/img/spqr.jpg"></a>
<br>
</td>
</tr>

<tr>
<td width="800" align="center" valign="middle">
<center><h1>Edited/Created</h1>
<p>Room Edited/Created, go <a href="addroom.php">Back</a>.</p></center>
</td>
</tr>

<?php
}
else
{
?>

<body bgcolor="grey">
<table width="800"
       border="1"
       cellpadding="0"
       align="center"
       bgColor="CC0000">
<!-- Row 1 -->
<tr>
<td width="800" align="center" valign="middle">
<font size="5"><font color="gold">The Roman Empire</font></font>
<br>
<a href="http://www.tregame.com" border="0"><img src="/img/spqr.jpg"></a>
<br>
<?php
Print "You are editing $roomname <b>(Room Number): $roomin</b><br><br> It is connected to North: $north<br>South: $south<br>East: $east<br>West: $west<br>Up: $up<br>Down: $down"; 
?>
</td>
</tr>



<form action="addroom.php" method="post">
<table width="800"
       border="1"
       cellpadding="0"
       align="center"
       bgColor="CC0000">

<tr>
<td width="400" align="center" valign="middle">
Room Name:
</td>
<td width="400" align="center" valign="middle">
<INPUT TYPE="text" NAME="roomname" SIZE="30" value="<?php Print $roomname; ?>">
</td>
</tr>

<tr>
<td width="400" align="center" valign="middle">
Room Description:
</td>
<td width="400" align="center" valign="middle">
<TEXTAREA NAME="roomdesc" ROWS=6 COLS=40><?php Print $roomdesc; ?>
</TEXTAREA>
</td>
</tr>



<tr>
<td width="400" align="center" valign="middle">
Connect North To(Click checkbox too):
</td>
<td width="400" align="center" valign="middle">
<?php
print "<select name='north' length='20'>";
      $room1="SELECT * from rooms order by room";
      $room2=mysql_query($room1) or die("Could not select Room");
      while ($room3=mysql_fetch_array($room2))
      {
        print "<option>$room3[room]</option>";
      }
      print "</select><br>";
?>
<INPUT TYPE="checkbox" NAME="mnorth" VALUE="1">
</td>
</tr>

<tr>
<td width="400" align="center" valign="middle">
Connect South To(Click checkbox too if able to move south):
</td>
<td width="400" align="center" valign="middle">
<?php
print "<select name='south' length='20'>";
      $room1="SELECT * from rooms order by room";
      $room2=mysql_query($room1) or die("Could not select Room");
      while ($room3=mysql_fetch_array($room2))
      {
        print "<option>$room3[room]</option>";
      }
      print "</select><br>";
?>
<INPUT TYPE="checkbox" NAME="msouth" VALUE="1">
</td>
</tr>
<tr>
<td width="400" align="center" valign="middle">
Connect East To(Click checkbox too if able to move east):
</td>
<td width="400" align="center" valign="middle">
<?php
print "<select name='east' length='20'>";
      $room1="SELECT * from rooms order by room";
      $room2=mysql_query($room1) or die("Could not select Room");
      while ($room3=mysql_fetch_array($room2))
      {
        print "<option>$room3[room]</option>";
      }
      print "</select><br>";
?>
<INPUT TYPE="checkbox" NAME="meast" VALUE="1">
</td>
</tr>
<tr>
<td width="400" align="center" valign="middle">
Connect West To(Click checkbox too if able to move west):
</td>
<td width="400" align="center" valign="middle">
<?php
print "<select name='west' length='20'>";
      $room1="SELECT * from rooms order by room";
      $room2=mysql_query($room1) or die("Could not select Room");
      while ($room3=mysql_fetch_array($room2))
      {
        print "<option>$room3[room]</option>";
      }
      print "</select><br>";
?>
<INPUT TYPE="checkbox" NAME="mwest" VALUE="1">
</td>
</tr>
<tr>
<td width="400" align="center" valign="middle">
Connect Up To(Click checkbox too if able to move up):
</td>
<td width="400" align="center" valign="middle">
<?php
print "<select name='up' length='20'>";
      $room1="SELECT * from rooms order by room";
      $room2=mysql_query($room1) or die("Could not select Room");
      while ($room3=mysql_fetch_array($room2))
      {
        print "<option>$room3[room]</option>";
      }
      print "</select><br>";
?>
<INPUT TYPE="checkbox" NAME="mup" VALUE="1">
</td>
</tr>
<tr>
<td width="400" align="center" valign="middle">
Connect Down To(Click checkbox too if able to move down):
</td>
<td width="400" align="center" valign="middle">
<?php
print "<select name='down' length='20'>";
      $room1="SELECT * from rooms order by room";
      $room2=mysql_query($room1) or die("Could not select Room");
      while ($room3=mysql_fetch_array($room2))
      {
        print "<option>$room3[room]</option>";
      }
      print "</select><br>";
?>

<INPUT TYPE="checkbox" NAME="mdown" VALUE="1">
</td>
</tr>
<tr><th colspan=2><input type="submit" name="submit" value="Add Room"></th></tr> </table>
</form>
<table width="800"
       border="1"
       cellpadding="0"
       align="center"
       bgColor="CC0000">
<!-- Row 1 -->
<tr>
<td width="800" align="center" valign="middle">
<center><b><p>IMPORTANT:If you want the room to be able to connect to another, you have to click the check box. Also, if you reedit a room, you need to make sure that the previous connections are put back in place!</b></p></center>
</td>
</tr>

</table>

<?php
}
?>

 

Now, when I edit a room, I have manually put in the direction of the previous room. Say, I want to add a room to the west, and I check the checkbox to enable movement to the west. What I don't know how to do, or go about doing, is making it so that the room to the west automatically updates to know that a room was added, and enable movement from the east back to the west.

 

Add room to the west: Move west, have to remember room number of West and add it into the East room via drop down box.

 

Now, another question:

 

Each time I reedit a room, the values become reset and do not retain the values I previously set. How do I make it so that the values are automatically set to what they previously were, like the room numbers?

 

Room 1 connects to room 123, for instance. How would I go about making so that each time I wanted to re-edit a room that the dropdown would be on room 123, and not back to 1?

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.