blob: da8a8e499807c0122b0a51c64e585d457768a33c (
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
}
?>
|