aboutsummaryrefslogtreecommitdiff
path: root/admin/navigation/functions.php
blob: 68ab7c3fcf1bb5bfcb04a9043bdcb3750f77b2ae (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<style> 

ul {
	margin: 0;
}
 
#contentLeft {
	width: 400px;
}
 
#contentLeft li {
	list-style: none;
	margin: 0 0 4px 0;
	padding: 10px;
	background-color:#a1a1a1;
	border: #CCCCCC solid 1px;
	color:#fff;
	text-align:center;
	cursor:move;
}

</style>
<script type="text/javascript" src="scripts/jquery-ui-1.7.1.custom.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){ 
						   
	$(function() {
		$("#contentLeft ul").sortable({ opacity: 0.6, cursor: 'move', update: function() {
			var order = $(this).sortable("serialize") + '&action=updateOrder'; 
			$.post("navigation/updateDB.php", order, function(theResponse){
				 $("#updateStatus").html(theResponse);
			}); 															 
		}								  
		});
	});
 
});	
</script> 
<?php
/**
 * Bayonet Content Management System
 * Copyright (C) 2008  Joseph Hunkeler & Evan O'Connell
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */ 
 
/**
 * Note to anyone feeling the need to edit this file...
 * You MUST declare $db as global inside your functions in order access MySQL from here.
 */

function ListNavigation(){
  
  global $db;
  $result = $db->Query("SELECT `nav_id`, `title`, `weight` FROM `bayonet_navigation` ORDER BY `weight`");
  $data = $db->Fetch($result);
  
  ?>
  	 	 <div id="contentLeft">
	 		<table> 
	 			<tr>
				 	<th>News Reel Order</th>
			 		<td id="updateStatus"></td>
			 	</tr>
		 	</table>
		 	<ul>
  <?php
  
  foreach($data as $nav){
  	
	  	echo "<li id=\"recordsArray_{$nav['nav_id']}\">{$nav['title']}</li>";  
  }
  ?>
  		  </ul>
		  Click and drag on a slide to change the order. Wait for confirmation indicating the changes have been saved.
	 	</div> 
  <?php
  
}
?>