<?php
	require_once ('authorize1.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US">

<head>
<title>Moreno Travel</title>
<script src="sorttable.js"></script>
    <link href="style.css" rel="stylesheet" type="text/css" />
    <meta http-equiv="content-type"
        content="text/html; charset=utf-8" />



</head>


<?php include 'admin_header.php'; ?>

<h1>Create Overview</h1>



 <form method="post" action="admin_addpackagescript.php">

<select name='location_id'>
<option disabled=\"disabled\" selected=\"selected\">Select a location:</option> 
<?php

require_once('connectvars.php');
	

$dbh = mysql_connect(hostname, username, password)

	or die("Unable to connect to MySQL");

mysql_select_db (dbname, $dbh);

	$query = sprintf("SELECT * FROM location ");




	$result = mysql_query($query);


	if (!$result) {

    	$message  = 'Invalid query: ' . mysql_error() . "\n";

    	$message .= 'Whole query: ' . $query;

    	die($message);

	}


while ($row = mysql_fetch_assoc($result)) {
	



echo '<option value="'.$row['location_id'].'">'.$row['location_name'].'</option>';

	}	
?>


</select><br><br>


<strong>Package Name:</strong><br> <input size="100" type="text" name="package_name"  /> <br><i><font color="#C11B17" size="0.5px">*if the package is an extended visit, put the name of the package and then &lt;br>&lt;b>Extended Visit&lt;/b>
</font></i><br><br>
<strong>Duration:</strong> <br><input size="2" type="text" name="duration"  /> <i><font color="#C11B17" size="0.5px">Enter 'days' within the field.  If it is a day trip, enter "Day Trip".</font></i> <br><br>
<strong>Starting Price:</strong><i><font color="#C11B17" size="0.5px">$X,XXX (leave blank if unknown)</font></i><br> <input type="text" name="startingprice"  /><br><br>
<strong>Brochure Picture:</strong> <input type="text" name="brochurepic"  /><br><i><font color="#C11B17" size="0.5px">Place the name of the file stored.  Click <a href="admin_picturelist.php" target="blank">here</a> to see a list of pictures with filenames.  Click <a href="admin_uploadimage.php" target="blank">here</a> to upload a new image.</font><br><br>
<strong>Overview Picture:</strong> <input type="text" name="overviewpic"  /><br><i><font color="#C11B17" size="0.5px">Place the name of the file stored.  Click <a href="admin_picturelist.php" target="blank">here</a> to see a list of pictures with filenames.  Click <a href="admin_uploadimage.php" target="blank">here</a> to upload a new image.</font><br><br>
<strong>Overview Picture 2:</strong> <input type="text" name="overviewpic2"  /><br><i><font color="#C11B17" size="0.5px">Place the name of the file stored.  If no picture avialable, enter 'blank.jpg' into the field.  Click <a href="admin_picturelist.php" target="blank">here</a> to see a list of pictures with filenames.  Click <a href="admin_uploadimage.php" target="blank">here</a> to upload a new image.</font><br><br>
<strong>Feature:</strong><br> <input size="150" type="text" name="feature"><br><br>
<strong>Overview:</strong><br> <textarea cols="110" rows="10" name="overview"></textarea><br><br>
<strong>Package Includes:</strong><i><font color="#C11B17" size="0.5px"> Place each bulleted point within &lt;li> &lt;/li> tags, minus the bullet.  
Click <a href="admin_packageinclude.php" target="_blank">here</a> to view a format to be used by default.</font></i><br> <textarea cols="110" rows="15" name="includes"></textarea><br><br>
<strong>Does not Include:</strong><i><font color="#C11B17" size="0.5px"> IE: Air transportation, gratuities, personal expenses.</font></i><br> <textarea cols="110" rows="10" name="doesnotinclude"></textarea><br><br>
<strong>More Details:</strong><i><font color="#C11B17" size="0.5px"> Additional info (Optional tours, etc.)</font></i><br> <textarea cols="110" rows="10" name="moredetails"></textarea><br><br>
<strong>More Cities:</strong><i><font color="#C11B17" size="0.5px"> List small cities which will not have a city page (seperated by a &lt;br>).</font></i><br> <textarea cols="110" rows="10" name="morecities"></textarea><br><br>
<strong>More Attractions:</strong><i><font color="#C11B17" size="0.5px"> List small attractions which will not have a attraction page (seperated by a &lt;br>).</font></i><br> <textarea cols="110" rows="10" name="moreinfo"></textarea><br><br>
 <!-- <strong>Price Image:</strong> <input type="text" name="price_img"  /><br><i><font color="#C11B17" size="0.5px">If unknown, enter "quote".  Place the name of the file stored.  Click <a href="admin_pricepicturelist.php" target="blank">here</a> to see a list of pictures with filenames.  Click <a href="admin_uploadpriceimage.php" target="blank">here</a> to upload a new image.</font><br><br>-->
<strong>Price Layout:</strong><br><select name="price_layout">
<option disabled=\"disabled\" selected=\"selected\">Select a layout:</option> 
<option value="1">price package containing hotels with multiple star ratings</option>
<option value="2">price package based on star rating</option>
<option value="3">pricing notes only</option>
</select><br><br>

<strong>Price Notes:</strong><i><font color="#C11B17" size="0.5px"><br></font></i><br><textarea cols="110" rows="10" name="price_notes"></textarea><br><br>
<strong>LongTerm Package:</strong>
<br><select name="longterm">
<option disabled=\"disabled\" selected=\"selected\">Select option:</option> 
<option value="no">this is not a long term package</option>
<option value="yes">this is a long term package</option>

</select><br><br>



<strong>OfferItem:</strong>
<br><select name="saleitem">
<option disabled=\"disabled\" selected=\"selected\">Select option:</option> 
<option value="no">this is not a special offer</option>
<option value="yes">this is a special offer</option>

</select><br><br>



<input type="submit" value="Submit">
</form>
  




</ul><br><br><br>
</div>

</div>

</body>

</html>