redirect_to("content.php");
}
include_once "includes/form_functions.php";
if (isset($_POST['submit'])) {
$errors = array();
$obavezna_polja = array('menu_name', 'position', 'visible', 'content');
$errors = array_merge($errors, check_required_fields($obavezna_polja));
$polje_sa_duzinom = array('menu_name' => 30);
$errors = array_merge($errors, check_max_fields_length($polje_sa_duzinom));
$id = mysql_prep($_GET['page']);
$menu = mysql_prep($_POST['menu_name']);
$position = mysql_prep($_POST['position']);
$visible = mysql_prep($_POST['visible']);
$content = mysql_prep($_POST['content']);
$page_get = get_page_by_id($id);
$pages_all = get_all_pages_for_subject($page_get['subject_id']);
$page_fetch = mysql_fetch_array($pages_all);
$count_pages = mysql_num_rows($pages_all);
$position_old = $page_get['position'];
if (empty($errors)) {
if ($position_old != $position) {
if ($position_old < $position) {
for ($i = $position_old; $i < $position; $i++) {
$new = $i + 1;
$qry = "UPDATE pages SET";
$qry .= " position={$i}";
$qry .= "\tWHERE position={$new} AND subject_id={$page_get['subject_id']}";
mysql_query($qry, $conn);
}
} else {
for ($i = $position_old; $i > $position; $i--) {
echo urlencode($select_sub['id']);
?>
"
onclick="return confirm('Are you sure?')">Delete subject</a>
</form>
<br />
<a href="content.php">Cancel</a>
<br />
<div>
<h3>Pages in this subject</h3>
<ul>
<?php
$sub_pages = get_all_pages_for_subject($select_sub['id']);
while ($page = mysql_fetch_array($sub_pages)) {
echo "<li><a href=\"content.php?page={$page['id']}\">{$page['menu_name']}</a></li>";
}
?>
</ul>
<br />
<a href="new_page.php?subj=<?php
echo $select_sub['id'];
?>
">+ Add a new page to this subject</a>
</div>
</td>
</tr>
function public_navigation($select_sub, $select_page, $public = true)
{
$output = "<ul class=\"subjects\">";
// 3. Izvrsiti query
$sub_set = get_all_subjects($public);
// 4. Ispsi podatke iz baze
while ($menu = mysql_fetch_array($sub_set)) {
$output .= "<li ";
if ($menu["id"] == $select_sub["id"]) {
$output .= "class=\"selected sel\" ";
}
$output .= "><a href=\"index.php?subj=" . urlencode($menu["id"]) . "\">{$menu['menu_name']}</a>";
if ($menu["id"] == $select_sub["id"]) {
$page_set = get_all_pages_for_subject($menu["id"], $public);
$output .= "<ul class=\"pages\">";
while ($page = mysql_fetch_array($page_set)) {
$output .= "<li ";
if ($page["id"] == $select_page["id"]) {
$output .= "class=\"selected\" ";
}
$output .= "><a href=\"index.php?page=" . urlencode($page["id"]) . "\">{$page['menu_name']}</a></li>";
}
$output .= "</ul>";
}
$output .= "</li>";
}
$output .= "<br/><br/>";
$output .= "<li><a href=\"staff.php\"> Staff page </a></li>";
$output .= "</ul>";
return $output;
}
