root/dev/common/admin/admin_navmanager.php @ 226

<?php
@set_time_limit(0);
require_once('common/includes/class.parser.php');
require_once('common/includes/class.kill.php');
require_once('common/admin/admin_menu.php');

$page = new Page();
$page->setAdmin();
$page->setTitle('Administration - Navigation - Top Navigation');

if ($_GET['incPrio'])
{
    increasePriority($_GET['incPrio']);
}
elseif ($_GET['decPrio'])
{
    decreasePriority($_GET['decPrio']);
}
elseif ($_POST['new'])
{
    newPage($_POST['name'], $_POST['url'], $_POST['target']);
}
elseif ($_POST['name'])
{
    renamePage($_POST['id'], $_POST['name']);
}
elseif ($_POST['target'])
{
    changeTarget($_POST['id'], $_POST['target']);
}
elseif ($_POST['newUrl'])
{
    changeUrl($_POST['id'], $_POST['newUrl']);
}
elseif ($_POST['delete'])
{
    delPage($_POST['id']);
}
elseif ($_POST['syncStat'])
{
    repairStatLink();
}

$html .= "<div class=block-header2>Navigation for intern pages</div>";
$qry = new DBQuery();
$query = "select * from kb3_navigation WHERE intern = 1 AND KBSITE = '".KB_SITE."';";
$result = $qry->execute($query);

if ($result)
{
    $html .= "<table class=kb-table>";
    $html .= "<tr><td width=100><u><b>Page</b></u></td><th colspan=2><u>Actions</u></th></tr>";
    $odd = false;
    while ($row = $qry->getRow())
    {
        $html .= "<tr class=$class><td>".$row['descr']."</td><form action ='?a=admin_navmanager' method='POST'><td><input name='name' type='text' value='".$row['descr']."'></td><td><input type='hidden' name='id' value='".$row['ID']."'><input type='submit' value='rename'></td></form></tr>";
        if (!$odd)
        {
            $odd = true;
            $class = 'kb-table-row-odd';
        }
        else
        {
            $odd = false;
            $class = 'kb-table-row-even';
        }
    }
    $html .= "<tr class=$class>";
    if (!$odd)
    {
        $odd = true;
        $class = 'kb-table-row-odd';
    }
    else
    {
        $odd = false;
        $class = 'kb-table-row-even';
    }
    $html .= "<tr class=$class><form action ='?a=admin_navmanager' method='POST'><td  colspan=2>Statlink must have the name \"Stats\"<br> during repair</td><td><input type='hidden' name='syncStat' value='1'><center><input type='submit' value='Repair Stats'></center></td></form></tr>";
    $html .= "</table>";
}
$html .= "<div class=block-header2>Navigation for extern pages</div>";
$qry = new DBQuery();
$query = "select * from kb3_navigation WHERE intern = 0 AND KBSITE = '".KB_SITE."';";
$result = $qry->execute($query);

if ($result)
{
    $html .= "<table class=kb-table>";
    $html .= "<tr><td width=100><u><b>Page</b></u></td><th colspan=2>Rename</th><th colspan=2>URL</th><th colspan=2>Target</th></tr>";
    $odd = false;
    while ($row = $qry->getRow())
    {
        $html .= "<tr class=$class><td>".$row['descr']."</td>";
        $html .= "<form action ='?a=admin_navmanager' method='POST'><td><input name='name' type='text' value='".$row['descr']."'></td><td><input type='hidden' name='id' value='".$row['ID']."'><input type='submit' value='rename'></td></form>";
        $html .= "<form action ='?a=admin_navmanager' method='POST'><td><input name='newUrl' type='text' value='".$row['url']."'></td><td><input type='hidden' name='id' value='".$row['ID']."'><input type='submit' value='change'></td></form>";
        $html .= "<form action ='?a=admin_navmanager' method='POST'><td><select name='target'>";
        $html .= "<option value='_self' ";
        if ($row['target'] == '_self')
        {
            $html .= "selected";
        }
        $html .= ">_self</option>";
        $html .= "<option value='_blank' ";
        if ($row['target'] == '_blank')
        {
            $html .= "selected";
        }
        $html .= ">_blank</option></select>";
        $html .= "</td><td><input type='hidden' name='id' value='".$row['ID']."'><input type='submit' value='change'></td></form>";
        $html .= "<form action ='?a=admin_navmanager' method='POST'><td><input name='delete' type='hidden' value='1'><input type='hidden' name='id' value='".$row['ID']."'><input type='submit' value='delete'></td></form>";
        $html .= "</tr>";
        if (!$odd)
        {
            $odd = true;
            $class = 'kb-table-row-odd';
        }
        else
        {
            $odd = false;
            $class = 'kb-table-row-even';
        }
    }
    $html .= "<tr class=$class><td colspan=10><b><u>New Page:</b></u></td></tr>";
    if (!$odd)
    {
        $odd = true;
        $class = 'kb-table-row-odd';
    }
    else
    {
        $odd = false;
        $class = 'kb-table-row-even';
    }
    $html .= "<tr class=$class><td>Description:</td>";
    $html .= "<form action ='?a=admin_navmanager' method='POST'><td><input name='name' type='text'></td>";
    $html .= "<td>URL:</td><td><input name='url' type='text' value='http://'></td><td>Target:</td>";
    $html .= "<td><select name='target'><option value='_self'>_self</option><option value='_blank'>_blank</option></select>";
    $html .= "</td><td><input type='hidden' name='new' value='1'><input type='submit' value='add'></td></form>";
    $html .= "</tr>";
    $html .= "</table>";
}

$html .= "<div class=block-header2>Order of the pages in Top Navigation Bar</div>";
$qry = new DBQuery();
$query = "select * from kb3_navigation WHERE nav_type = 'top' AND KBSITE = '".KB_SITE."' ORDER BY posnr ;";
$result = $qry->execute($query);

if ($result)
{
    $html .= "<table class=kb-table>";
    $html .= "<tr><th><u>Nr</u></th><td><u><b>Page</b></u></td><th colspan=2><u>Actions</u></th></tr>";
    $odd = false;
    while ($row = $qry->getRow())
    {
        if (!$odd)
        {
            $odd = true;
            $class = 'kb-table-row-odd';
        }
        else
        {
            $odd = false;
            $class = 'kb-table-row-even';
        }
        $html .= "<tr class=$class><td align=right>".$row['posnr']."</td><td>".$row['descr']."</td>";
        $html .= "<td><a href='?a=admin_navmanager&decPrio=".$row['ID']."'><b> move up </b></a></td>";
        $html .= "<td><a href='?a=admin_navmanager&incPrio=".$row['ID']."'><b> down </b></a></td>";
        $html .= "<tr>" ;
    }
    $html .= "</table>";
}
$page->addContext($menubox->generate());
$page->setContent($html);
$page->generate();

function increasePriority($id)
{
    $qry = new DBQuery();
    $query = "SELECT posnr FROM kb3_navigation WHERE ID = $id AND KBSITE = '".KB_SITE."'";
    $qry->execute($query);
    $row = $qry->getRow();
    $next = $row['posnr'] + 1;

    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET posnr = (posnr-1) WHERE nav_type = 'top' AND posnr = $next AND KBSITE = '".KB_SITE."'";
    $qry->execute($query);

    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET posnr = (posnr+1) WHERE ID = $id";
    $qry->execute($query);
}
function decreasePriority($id)
{
    $qry = new DBQuery();
    $query = "SELECT posnr FROM kb3_navigation WHERE ID = $id AND KBSITE = '".KB_SITE."'";
    $qry->execute($query);
    $row = $qry->getRow();
    $prev = $row['posnr']-1;

    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET posnr = (posnr+1) WHERE nav_type = 'top' AND posnr = $prev AND KBSITE = '".KB_SITE."'";
    $qry->execute($query);

    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET posnr = (posnr-1) WHERE ID = $id";
    $qry->execute($query);
}

function renamePage($id, $name)
{
    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET descr ='$name' WHERE ID=$id";
    $qry->execute($query);
}

function changeUrl($id, $url)
{
    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET url ='$url' WHERE ID=$id";
    $qry->execute($query);
}
function changeTarget($id, $target)
{
    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET target ='$target' WHERE ID=$id";
    $qry->execute($query);
}
function newPage($descr, $url, $target)
{
    $qry = new DBQuery();
    $query = "SELECT max(posnr) as nr FROM kb3_navigation WHERE nav_type='top' AND KBSITE = '".KB_SITE."'";
    $qry->execute($query);
    $row = $qry->getRow();
    $posnr = $row['nr'] + 1;
    $query = "INSERT INTO kb3_navigation SET descr='$descr', intern=0, nav_type='top',url='$url', target ='$target', posnr=$posnr, page='ALL_PAGES', KBSITE = '".KB_SITE."'";
    $qry->execute($query);
}
function delPage($id)
{
    $qry = new DBQuery();
    $query = "DELETE FROM kb3_navigation WHERE ID=$id";
    $qry->execute($query);
}
function repairStatLink()
{
    if (CORP_ID)
    {
        $statlink = '?a=corp_detail&crp_id='.CORP_ID;
    }elseif (ALLIANCE_ID)
    {
        $statlink = '?a=alliance_detail&all_id='.ALLIANCE_ID;
    }
    $qry = new DBQuery();
    $query = "UPDATE kb3_navigation SET url ='$statlink' WHERE descr='Stats' AND KBSITE = '".KB_SITE."'";
    $qry->execute($query);
}
?>