new.php

<?php
  include_once ("functions.php");

  if(!isUser())
  {
    setFlash("請登入", "error");
    echo '<script type="text/javascript">';
    echo " window.location='index.php';";
    echo "</script>";
    exit;
  }

  $title = "新增 IP 地址設定";
  $page = "new";

  $link = mysql_connect(MYSQL_LOCATION, MYSQL_USERNAME, MYSQL_PASSWORD) or exit("無法與MySQL建立連線");
  mysql_select_db(MYSQL_DATABASE);

  include ("header.php");
?>

<div class='container'>
	<div class='row'>
		<div class='span4'>
			<h1><?php echo $title ?></h1>
		</div>
		<div class='span12'>
			<form action='update.php' method='post'>
				<fieldset>
					<div class="clearfix">
						<label for="IP_last_4_digits">IP位址</label>
						<div class="input">
						<select name='IP_last_4_digits'>
							<?php
								/* 產生未使用的 IP */
								$link = mysql_connect(MYSQL_LOCATION, MYSQL_USERNAME, MYSQL_PASSWORD) or die("無法與MySQL建立連線");
								mysql_select_db(MYSQL_DATABASE);
								$result = mysql_query("select * from ips");
								
								for ( $counter = 0; $row = mysql_fetch_row( $result ); $counter++)
								{
									$ipaddr = $row[0];//ip
									$used = $row[1];//used
									if(!$used)
									{
										print('<option value="'.htmlspecialchars($ipaddr).'">'.htmlspecialchars($ipaddr).'</option>');
									}
								}
							?>
						</select>
						</div>
					</div>
					<div class="clearfix">
						<label for="machine_feature">機器功能</label>
						<div class="input">
						<input type='text' name='machine_feature' size='20' maxlength='50' value="web server"/>
						</div>
					</div>
					<div class="clearfix">
						<label for="machine_ports">使用的連接埠</label>
						<div class="input">
						<input type='text' name='machine_ports' size='20' maxlength='50' value="80"/>
						</div>
					</div>
					<div class="clearfix">
						<label for="machine_owner">負責人</label>
						<div class="input">
						<?php if(isSuperUser()): ?>
						<select name='machine_owner'>
							<?php
							/* 產生使用者清單 */
							$result = mysql_query("select name from users");
							
							for ( $counter = 0; $row = mysql_fetch_row( $result ); $counter++)
							{
								$userName = $row[0];//ip
								if ($userName == $_SESSION['userName']) {
									print('<option value="'.$userName.'" selected="selected">'.$userName.'</option>');
								}
								else
								{
									print('<option value="'.$userName.'">'.$userName.'</option>');
								}
							}
							?>
						</select>
						<?php else: ?>
						<select name='machine_owner' disabled="disabled">
							<option value="<?php print($_SESSION['userName'])?>"><?php print($_SESSION['userName'])?></option>
						</select>
						<?php endif;?>
						</div>
					</div>
					<div class="clearfix">
						<label for="machine_location">機器所在位置</label>
						<div class="input">
						<input type='text' name='machine_location' size='20' maxlength='50' value="no idea"/>
						</div>
					</div>
					<div class="actions">
						<input class="primary btn" type='submit' name='submit' value='加入機器' />
						<input class="btn" type='reset' value='清除重填' />
					</div>
				</fieldset>
			</form>
		</div>
	</div>
</div>
<?php 
  include ("footer.php"); 
  mysql_close($link);
?>