Просмотр архива WAP История войны


<?php

if (!$user->isAuth()) {
    redirect('/');
    exit;
}


     
                

        $news = $db->prepare('select * from `news` where `id` = ?');
            $news -> execute([Clean :: int($_GET['id'])]);
                $news = $news -> fetch(PDO :: FETCH_OBJ);
            
            if(!isset($news->id)){
                redirect('/news');
                exit;
            }




        
          if(isset($_POST['submit']) and $user->get()->lvl > 6){
                $text = Clean :: str($_POST['text']);
                if(empty($text)){
                    Notif :: error('Введите сообщение','/news/view?id='.$news->id);
                    exit;
                }
               
               
              
               
               
               
               
              
               
                $add = $db->prepare('INSERT INTO `news_msg` (`text`,`user`,`time`,`news`) VALUES (?,?,?,?)');
                $add -> execute([$text,$user->get()->user_id,time(),$news->id]);
                $id = $db->lastInsertId();
                
               
                
              
                
                
                redirect('/news/view?id='.$news->id);
                    exit;
            }

                
                



        $all = $db->prepare('SELECT * FROM `news_msg` WHERE `news` = ? ORDER BY `id`  DESC');
        $all -> execute([$news->id]);
        $all = $all -> fetchAll();
        
    $peger = new ArrayPaginator('/news/view?id='.$news->id, 10); 
    $items = $peger->getItems($all);
            
        
        
        
        
        
        
echo $template->render('game.news_view',
                                 
                                 ['peger'   =>  $peger,
                                  'items'   =>  $items,
                                  'news'    => $news
                                 
                                 ]       
                                        
                                        );