<?php
//redirect to release WIPs URL if r parameter is set
if (!empty($_GET['r'])) {
header('Location: http' . (empty($_SERVER['HTTPS']) || $_SERVER['HTTPS'] == 'off' ? '' : 's') . '://' . $_SERVER['SERVER_NAME'] . dirname($_SERVER['REQUEST_URI']) . '/wips.php?r=' . $_GET['r']);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Work in Progress Archive</title>
<link rel="stylesheet" type="text/css" href="../styles.css"/>
<link rel="stylesheet" type="text/css" href="tablestyles.css"/>
</head>
<body>
<table>
<thead>
<tr><th>Name (Click to Download)</th><th>For Release</th><th>Description</th></tr>
</thead>
<tbody>
<?php
include 'wiplist.php';
generate_list();
?>
</tbody>
</table>
</body>
</html>
echo $row3['eventStartDate'];
echo "</font></td>";
echo "<td><font face = 'Arial, Helvetica, sans-serif'>";
echo $row3['eventEndDate'];
echo "</font></td>";
echo "<td><font face = 'Arial, Helvetica, sans-serif'>";
echo $row3['eventStartTime'];
echo "</font></td>";
echo "<td><font face = 'Arial, Helvetica, sans-serif'>";
echo $row3['eventEndTime'];
echo "</font></td>";
echo "<td><font face = 'Arial, Helvetica, sans-serif'>";
echo $row3['eventDesc'];
echo "</font></td>";
echo "</tr>";
$y = $y - 1;
}
echo "</table>";
echo "<br/>";
echo "<a href='eventslocation.php' class='button black'>GO BACK</a>";
} else {
echo "<h2 class='center'>Search Events</h2>";
echo "<form name='queryroom' id ='queryname' method='POST' action='" . $PHP_SELF . "'>";
$query = "select buildingName from Building";
$x = "buildingName";
$st = generate_list($query, $x);
echo "\n<table >\n<tr><td> Building: </td>\n<td> " . $st . " </td></tr>\n</table>";
echo "<table style='text-align:center'>\n<tr><td> Select Start Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_start', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td> Select End Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_end', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td></td><td><br/>\n<input type='submit' name='submit' id='submit' value='QueryEvents'/>\n</td></tr></table>\n</form>";
echo "<button><a href='search.php'>BACK TO SEARCH</a></button>";
}
include 'footer.php';
<form id="form_clear" action="index.php" onsubmit="return clearTable();" method="post" >
<input type="submit" name="clear" value="Clear Purchase List" />
</form>
<div id="database">
<h4>Current purchase list:</h4>
<?php
/* update table Purchase_List according to the user input */
/* Generate a purchase list randomly */
if (isset($_POST['count']) && isset($_POST['percentage'])) {
$count = $_POST['count'];
//The number of rows
$percentage = $_POST['percentage'];
//The percentage of match:
generate_list($count, $percentage, $connection);
/* Create a purchase by user */
} else {
if (isset($_POST['ip']) && isset($_POST['delivery_country'])) {
$ip = $_POST['ip'];
//Your IP address
$delivery_country = $_POST['delivery_country'];
//Your delivery country
/* Insert the pruchase to the table Purchase_List */
$query = "INSERT INTO Purchase_List(IP, Country_Name) ";
$query .= "VALUES ('" . $ip . "', '" . $delivery_country . "') ";
mysqlQuery($connection, $query);
/* If the user want to empty the table Purchase_List */
} else {
if (isset($_POST['clear'])) {
$query = "TRUNCATE TABLE Purchase_List";
" <?php
post_class('lc-article lc-people-list');
?>
>
<div class='ninecol' id='contentarea'>
<div class='top-content'>
<article class='wireframe row'>
<header class='entry-header'>
<h1><?php
the_title();
?>
</h1>
</header>
<div class='entry-content article-text'>
<?php
echo generate_list($people_list, MODE_FULL_LIST);
?>
</div>
<?php
get_template_part('snippet-socialmedia-share');
?>
</article>
</div><!-- .top-content -->
</div><!-- #contentarea -->
</div><!-- #post-<?php
the_ID();
?>
-->
<?php
get_template_part('nav');
?>
<form action="addRequest.php" autocomplete="on" method="POST">
<table class='center'>
<tr><td> Name:</td><td><input type="text" name="creator" id="P1"><br> </tr>
<tr><td> Email: </td><td><input type="email" name="creatorEmail" id="P2" autocomplete="off"><br></tr>
<tr><td> Phone No: </td><td><input type="text" name="creatorPhone" id="P3" maxlength=10><br></tr>
<tr><td> Are you requesting for someone else?</td><td><input type="checkbox" id="switchAlias"/></tr>
<tr class="CP"><td> Details of concerned person:</td></tr>
<tr class="CP"><td> Name:</td><td><input type="text" name="concernedPName" id="CP1"><br></tr>
<tr class="CP"><td> Email: </td><td><input type="email" name="concernedPEmail" id="CP2" autocomplete="off"><br></tr>
<tr class="CP"><td> Phone No:</td> <td><input type="text" name="concernedPPhone" id="CP3" maxlength=10><br></tr>
<tr><td> <span style="font-weight: bold;">Details of Event:</span></td><td></tr>
<!-- <tr><td> Title:</td><td><input type="text" name="eventTitle" id="ti1"><br></tr>-->
<?php
echo "<tr><td>Event Title:</td><td>";
$query = "select * from eventTitle";
echo generate_list($query, "eventTitle");
echo "</td>";
?>
<tr><td> Select Building: </td><td>
<?php
if ($_GET['buildingname']) {
echo generateBuildingList1("buildingName", $_GET['buildingname']);
} else {
echo generateBuildingList("buildingName");
}
?>
</td></tr>
<?php
echo "<tr><td> Select Room:</td><td>";
if ($_GET['buildingname']) {
echo generateRoomList1("room", $_GET['roomName']);
</table>
</form>
<form name='deleteroom' method='POST' action ='s_addroom2.php' id="deleteRoom" >
<h2 align='center'>Delete Room</h2>
<table align='center'><tr><td>Select Room: </td>
<td><?php
echo $list2;
?>
</td></tr>
<tr><td></td><td><input type='submit' name='deleteroom' value='Delete'/i></td></tr>
</table></form>
<?php
$query = "select buildingName from Building;";
$r = 'bname';
$list1 = generate_list($query, $r);
?>
<form name='insert' action='s_addbuild2.php' method='post' id="addBuilding">
<h2 align='center'>Add Building</h2>
<table align='center'>
<tr><td>
Enter the new Building's Name : </td><td><input type='text' id='enter' name = 'Bname' />
<script type="text/javascript">
var f2 = new LiveValidation('enter');
f2.add( Validate.Presence );
</script>
</td>
</tr>
<tr><td></td><td><input type='submit' name='add' value='Add'/></td>
</tr></table>
</form><br/><br/><br/>
<?php
$TRACE_ENABLED = is_user_logged_in();
$TRACE_PREFIX = 'nav.php -- ';
$current_post_id = $post->ID;
$people_list = get_post_meta($post->ID, 'people_list', true);
if ($people_list) {
?>
<nav id="whoswho-side-toc">
<?php
echo generate_list($people_list, 'summary');
?>
</nav>
<?php
}
<?php
include "essential.php";
require_once "header.php";
?>
<h2>Edit Room</h2>
<?php
$id = $_GET['SNO'];
//echo $id;
$query1 = "select * from Room where roomId=" . $id . ";";
$q = "select buildingName from Building";
$x = "buildingName";
$st = generate_list($q, $x);
$result1 = execute($query1);
while ($row = mysql_fetch_row($result1)) {
?>
<form action="s_addroom3.php" method="post">
<table>
<tr>
<td>
RoomId:</td>
<td><input type='text' name='roomID' readonly value=<?php
echo $id;
?>
></td>
</tr>
<tr>
<td> Room Name</td>
<td> <input type='text' name='roomName' id='room' value=<?php
echo $row[1];
?>
<?php
include "lib/autoload.php";
if (file_exists("schema.php")) {
include "schema.php";
if (isset($config) && isset($schema)) {
echo "<p>Base de datos <b>{$config['db']}</b></p>";
echo "<ul>";
generate_conection($config);
generate_sql($config, $schema);
foreach ($schema as $tablename => $tabledata) {
generate_form($tablename, $tabledata);
generate_form_edit($tablename, $tabledata);
generate_adder($tablename, $tabledata);
generate_editer($tablename, $tabledata);
generate_list($tablename, $tabledata);
generate_deleter($tablename, $tabledata);
}
echo "<li>Finalizado</li>";
echo "</ul>";
}
}
<?php
include "essential.php";
require_once "header.php";
echo "<script type='text/javascript' src='js/calendarDateInput.js'> </script>";
if (!$_POST['submit']) {
echo "\n<h2 class='center'> Search Events </h2>\n\n<form name='queryroom' id ='queryname' method='POST' action='" . $PHP_SELF . "'>";
echo "<table class='center'>\n<tr><td style='text-align:right'>Search(Event Type) : </td><td>";
echo generate_list("select * from eventTitle", 'keyword');
echo "</td></tr>\n</table>\n<br/>\n<table style='text-align:center'>\n<tr><td> Select Start Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_start', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td> Select End Date: </td>\n<td><div id='divroomName'> <script>DateInput('date_end', true, 'YYYY-MM-DD')</script> </div></td>\n</tr>\n<tr><td></td><td><br/>\n<input type='submit' name='submit' id='submit' value='QueryEvents'/>\n</td></tr></table>\n</form>";
echo "<button><a href='search.php'>BACK TO SEARCH</a></button>";
} else {
$date_s = strtotime($_POST['date_start']);
$date_e = strtotime($_POST['date_end']);
if ($date_s > $date_e) {
header("Location:error.php?msg=ERROR: Your Date and time limits are wrong!");
}
$buildid = 1;
$roomid = 1;
$x = $_POST['date_start'];
$y = $_POST['date_end'];
$hardhik = $_POST['keyword'];
//echo $hardhik;
//$query2 = "select Building.buildingName,Requests.eventDesc,eventStartTime,eventEndTime,room,eventStartDate,eventEndDate from Requests,Room,Building where appStatus = 'Accepted' AND Requests.room = Room.roomName AND Building.buildId = Room.buildingName AND Requests.eventDesc LIKE '%".$hardhik."%' AND ((eventStartDate <= DATE '".$x."' AND eventEndDate >= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate >= DATE '".$y."' AND eventStartDate <= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate <= DATE '".$y."') OR (eventStartDate <= DATE '".$x."' AND eventEndDate <= DATE '".$y."' AND eventEndDate >= DATE '".$x."'));";
$query2 = "select Building.buildingName,Requests.eventDesc,eventStartTime,eventEndTime,room,eventStartDate,eventEndDate from Requests,Room,Building where appStatus = 'Accepted' AND Requests.room = Room.roomName AND Building.buildId = Room.buildingName AND Requests.eventTitle = '" . $hardhik . "' AND ((eventStartDate <= DATE '" . $x . "' AND eventEndDate >= DATE '" . $y . "') OR (eventStartDate >= DATE '" . $x . "' AND eventEndDate >= DATE '" . $y . "' AND eventStartDate <= DATE '" . $y . "') OR (eventStartDate >= DATE '" . $x . "' AND eventEndDate <= DATE '" . $y . "') OR (eventStartDate <= DATE '" . $x . "' AND eventEndDate <= DATE '" . $y . "' AND eventEndDate >= DATE '" . $x . "'));";
//$query2 = "select Building.buildingName,Instances.eventDesc,eventStartTime,eventEndTime,room,eventStartDate,eventEndDate from Instances,Room,Building where Instances.room = Room.roomName AND Building.buildId = Room.buildingName AND Instances.eventTitle = '".$hardhik."' AND ((eventStartDate <= DATE '".$x."' AND eventEndDate >= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate >= DATE '".$y."' AND eventStartDate <= DATE '".$y."') OR (eventStartDate >= DATE '".$x."' AND eventEndDate <= DATE '".$y."') OR (eventStartDate <= DATE '".$x."' AND eventEndDate <= DATE '".$y."' AND eventEndDate >= DATE '".$x."'));";
$result9 = execute($query2);
$y = mysql_num_rows($result9);
//echo $query2;
if ($y != 0) {
echo "<table id='box-table-a'>\n<thead>\n<tr>\n<th scope='col'>Building Name</th>\n<th scope='col'>Room</th>\n<th scope='col'>Start Date</th>\n<th scope='col'>End Date</th>\n<th scope='col'>Start Time</th>\n<th scope='col'>End Time</th>\n<th scope='col'>Description</th>\n</tr>\n</thead>";
