<?php

        if(!defined('KEY'))
        {
            header('HTTP/1.1 404 Not Found');
            exit(file_get_contents('../../404.html'));
        }


    if($ok)
    {
        $res = query("DELETE FROM `". PREFIX ."pubs`
                      WHERE `id` IN (". implode(', ', array_map('intval', $POST['array1'])) .")");

        redirect();
    }


    include ROOT .'/libs/paginator.php';

    $paginator = new Paginator($GET['num'], NUM_PUBS);

    $res = $paginator->count_query('SELECT `id`, `subtitle`, `text`, `public`
                                    FROM `'. PREFIX .'pubs`
                                    WHERE `public` = "1"
                                    ORDER BY `id` DESC');

    $navigation = $paginator->create_menu();

    if(mysql_num_rows($res) > 0)
    {
        $data = array();
        $publics = '';
        $tpl = get_tpl('admin/publics/row_publics');

        while($row = mysql_fetch_assoc($res))
        {
            $data['id'] = $row['id'];
            $data['subtitle'] = htmlspecialchars($row['subtitle']);
            $data['text'] = $row['text'];

            if($ed)
            {
                $POST = chars($POST);  

                if(!$POST['value1'])
                    $errors_array[] = NO_SUBTITLE;

                if(!$POST['value2'])
                    $errors_array[] = NO_TEXT;

                if(count($errors_array) == 0)
                {
                    $res = query("UPDATE `". PREFIX ."pubs`
                              SET `subtitle` = '". magic_off($POST['value1'])."',
                              `text` = '". magic_off($POST['value2']) ."'
                              WHERE `id` = '". $row['id'] ."'");

                    redirect();   
                }
            }

            $publics .= parse_tpl($tpl, $data);
        }
    }
    else
    {
        $tpl = get_tpl('publics/no_publics');
        $data['no_publics'] = NO_PUBS;
        $publics = parse_tpl($tpl, $data);
    }