function resetSystem()
{
require "includes/config.php";
mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Could not connect to MySQL server!");
mysql_select_db($mysql_db) or die("Could not select awsome database!");
mysql_query("UPDATE `activities` SET `placestaken` = 0 WHERE `placestaken` != 0");
mysql_query("TRUNCATE TABLE `activities_bookings`");
mysql_query("TRUNCATE TABLE `paperwork_bookings`");
mysql_query("TRUNCATE TABLE `payment_bookings`");
get_activity_info(FALSE, FALSE, TRUE);
}
<?php
$inputwidth = 200;
$selectwidth = $inputwidth;
$textareawidth = 300;
require "includes/config.php";
$activityinfo = get_activity_info(FALSE, FALSE, TRUE);
$activities = $_SESSION['activitydetails'];
?>
<u>Manage Activities</u><br />
<div id="activitylist" style="float:left;">
<input class="sysbutton" style="margin-top: 10px; margin-bottom: 20px;" onclick="addActivity();" type="button" value="Add New Activity">
<?php
mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Could not connect to MySQL server!");
mysql_select_db($mysql_db) or die("Could not select {$site_title_text} database!");
foreach ($activities as $activity) {
?>
<div id="activity_<?php
print $activity->id;
?>
">
<input style="width: 300px;" onclick="beginActivityEdit('<?php
print $activity->id;
?>
');" type="button" value="<?php
print $activity->name;
?>
">
<a id="deletebtn" href="javascript:deleteActivity('<?php
print $activity->id;
?>
function editBooking($userid)
{
include_once "includes/displayfunc.php";
$booking_details = mysql_query("SELECT * FROM `activities_bookings` WHERE `user_id` = {$userid} LIMIT 1;");
$booking_details = mysql_fetch_object($booking_details);
?>
<div style="margin-bottom: 10px;">Edit booking selections.</div>
<form id="bookingform" name="bookingform" action="">
<div id="activityinfo" style="display: none;">
<?php
get_activity_info($userid, TRUE);
print $_SESSION['activitydetails_json'];
?>
</div>
<div id="reviewscreen"></div>
<div id="bookingfields">
<div style="margin-bottom: 10px;">Make your selections.</div>
<div id="activityfields">
<?php
print createActivityFields();
?>
</div>
<!-- admin extra -->
<div id="userbookingdata" style="display: none;">
<input id="selectedactivities" type="hidden" value="<?php
print $booking_details->bookings;
?>
" />
</div>
<!-- end admin extra -->
<div id="totalcost"></div>
<div id="bookjsonload">
<script language="JavaScript" type="text/javascript">
updateActivities('startover');
</script>
</div>
<input class="sysbutton" id="startover" name="startover" type="button" onclick="clearSelections();" value="Start Over"/>
<input class="sysbutton" type="button" value="Edit Booking" onclick="checkBooking('Edit+Booking', '<?php
print $userid;
?>
');" />
<input class="sysbutton" type="button" value="Delete Booking" onclick="deleteBooking('<?php
print $userid;
?>
');" />
</div>
</form>
<?php
}
