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 }