Beispiel #1
0
 $comments->order = "time DESC";
 $comments->limit = "0, " . $set[0]['perpage_comments'];
 $comments->multiSelect = 1;
 if ($comments->row()) {
     $array_com[] = $comments->row();
 }
 unset($comments);
 /******************************************/
 require_once './lib/exist.php';
 $comments_exist = new CheckExist();
 $comments_exist->tableE = $tbl_blog_comments;
 $comments_exist->conditionE = "bid = '{$id}' AND deleted = '0'";
 $comments_total = $comments_exist->exist();
 /* Generate Pagenavi for comments */
 require_once './lib/pagenavi.php';
 $naviObj = new pagenavi();
 $naviObj->tableE = $tbl_blog_comments;
 // required
 $naviObj->conditionE = "bid = '{$id}' AND deleted = '0'";
 $TotalRows = $comments_total;
 $max_pages = ceil($TotalRows / $set[0]["perpage_comments"]);
 $array_pages_c[$count]['bid'] = $id;
 //if (is_numeric($page) && $page <= $max_pages) {
 if ($TotalRows > $set[0]["perpage_comments"]) {
     $naviObj->totalrows = $TotalRows;
     $naviObj->showperpage = $set[0]["perpage_comments"];
     $array_pages_c[$count]['content'] = $naviObj->rowpages('1');
     // global parameter, defined in config.php
 }
 unset($naviObj);
 //}
Beispiel #2
0
     }
     $max_pages = ceil($TotalRows / $set[0]["perpage_gallery"]);
     if ($max_pages > 1 && $page_current <= $max_pages) {
         $page_url = 'gallery/page/' . $page_current . '/';
     } else {
         if ($max_pages > 1 && $page_current > $max_pages) {
             $page_url = 'gallery/page/' . $max_pages . '/';
         } else {
             $page_url = 'gallery/';
         }
     }
     header("Location:" . ROOT_DIR . $page_url);
     /******************************************/
 } else {
     /* Load :: Page Navigation */
     $naviObj = new pagenavi();
     $naviObj->tableE = $tbl_gallery;
     // required
     if ($Myadmin == 1) {
         $naviObj->conditionE = "";
     } else {
         $naviObj->conditionE = " visibility = '1' AND UNIX_TIMESTAMP(date) < {$timestamp} ";
     }
     $TotalRows = $naviObj->exist();
     $max_pages = ceil($TotalRows / $set[0]["perpage_gallery"]);
     if (is_numeric($page) && $page <= $max_pages) {
         if ($TotalRows > $set[0]["perpage_gallery"]) {
             $naviObj->totalrows = $TotalRows;
             $titleG = $TotalRows . " " . $gal_numbers;
             //$naviObj->title = '';
             $naviObj->showperpage = $set[0]["perpage_gallery"];
Beispiel #3
0
        if ($Myadmin == 1) {
            $blog->condition = "";
        } else {
            $blog->condition = " deleted = '0' AND visibility = '1' AND UNIX_TIMESTAMP(date) < {$timestamp} ";
        }
        $blog->order = 'date DESC';
        //$blog->limit     = "$begin, " . $set[0]['perpage_blog'];
        $blog->module = 'blog';
        $blog->template = 'blog/list.tpl';
        if ($_GET['bid']) {
            $blog->toogle = $_GET['bid'];
        }
        $blog->replace = 'true';
        $blog->row();
        /******************************************/
        /* Delete :: Object SELECT */
        unset($blog);
        /******************************************/
    } else {
        /* Load :: Page Navigation */
        require_once './lib/pagenavi.php';
        $naviObj = new pagenavi();
        $naviObj->tableE = $tbl_blog;
        // required
        $naviObj->conditionE = "id = '{$bid}' AND deleted = '0' ";
        $TotalRows = $naviObj->exist();
        include 'show.php';
    }
} else {
    $tpl->display("block_deactivated.tpl");
}
Beispiel #4
0
function page($table, $bid, $pageid, $TotalRows)
{
    global $tpl;
    $objResponse = new xajaxResponse();
    include 'settings/config.php';
    include 'settings/tables.php';
    include 'settings/template.php';
    require_once 'lib/select.php';
    require_once 'lib/pagenavi.php';
    if ($table == $tbl_blog_comments) {
        $max_pages = ceil($TotalRows / $set[0]["perpage_comments"]);
        if (is_numeric($pageid) == false) {
            if ($pageid == 'first') {
                $pageid = 1;
            }
            if ($pageid == 'last') {
                $pageid = $max_pages;
            }
        }
        $begin_c = ($pageid - 1) * $set[0]["perpage_comments"];
        /* Print :: SELECT :: Comments */
        $comments = new SelectEntrys();
        $comments->cols = 'id, bid, time, name, comment, lang';
        $comments->table = $tbl_blog_comments;
        $comments->condition = "bid = '{$bid}' AND deleted = '0'";
        $comments->order = "time DESC";
        $comments->limit = "{$begin_c}, " . $set[0]['perpage_comments'];
        $comments->multiSelect = 1;
        //$comments->br          = 1;
        $array_com[] = $comments->row();
        unset($comments);
        /******************************************/
        /* Modify Comment Array */
        foreach ($array_com as $array_com2) {
            for ($b = 0; $b < count($array_com2); $b++) {
                //replace url links
                $array_com2[$b]['comment'] = str_replace("www.", "http://www.", $array_com2[$b]['comment']);
                $array_com2[$b]['comment'] = str_replace("http://http://", "http://", $array_com2[$b]['comment']);
                //$array_com2[$b]['comment'] = preg_replace("[[:alpha:]]+://[^<>[:space:]]+[[:alnum:]/]", "<a href=\"\\0\" class='postedlink' target='_blank'>\\0</a>", $array_com2[$b]['comment']);
                //avoid layout damage
                $array_com2[$b]['comment'] = wordwrap($array_com2[$b]['comment'], 60, " ", 1);
                //decoding
                $array_com2[$b]['comment'] = utf8_encode($array_com2[$b]['comment']);
                //line breaks
                $array_com2[$b]['comment_unformatted'] = $array_com2[$b]['comment'];
                $array_com2[$b]['comment'] = nl2br($array_com2[$b]['comment']);
            }
            $array_com3[] = $array_com2;
        }
        /******************************************/
        /* Generate Pagenavi for comments */
        $naviObj = new pagenavi();
        $naviObj->tableE = $tbl_blog_comments;
        // required
        $naviObj->conditionE = "bid = '{$bid}' AND deleted = '0'";
        if (is_numeric($pageid) && $pageid <= $max_pages) {
            if ($TotalRows > $set[0]["perpage_comments"]) {
                $naviObj->totalrows = $TotalRows;
                $naviObj->showperpage = $set[0]["perpage_comments"];
                $pages_c = $naviObj->rowpages($pageid);
                // global parameter, defined in config.php
            }
            unset($naviObj);
        }
        if ($TotalRows == $set[0]['perpage_comments']) {
            $p_in = "p_cpages_" . $bid;
            $p_in2 = "p_cpages2_" . $bid;
            $p_out = "p_page_" . $bid;
            $p_out2 = "p_page2_" . $bid;
            $objResponse->remove($p_in);
            $objResponse->remove($p_in2);
            $objResponse->assign($p_out, "innerHTML", '&nbsp;');
            $objResponse->assign($p_out2, "innerHTML", '&nbsp;');
        }
        /******************************************/
        /* Generate output */
        $tpl->assign('array_com', $array_com3);
        $tpl->assign('xajax_bid', $bid);
        $tpl->assign('pages_c', $pages_c);
        $tpl->assign('blog_id', $bid);
        $tpl->assign('com_total', $TotalRows);
        $tpl->assign('page_id', $pageid);
        $tpl->assign('Myadmin', $Myadmin);
        $html = $tpl->fetch("pagenavi_ajax.tpl");
        $html2 = $tpl->fetch("blog/comments_show.tpl");
        $p_name = "p_comments_" . $bid;
        $p_name2 = "p_cpages_" . $bid;
        $p_name3 = "p_cpages2_" . $bid;
        $html4 = $tpl->fetch("blog/comments.tpl");
        $objResponse->assign($p_name, "innerHTML", $html2);
        if ($TotalRows > $set[0]['perpage_comments']) {
            $objResponse->assign($p_name2, "innerHTML", $html);
        }
        if ($TotalRows > $set[0]['perpage_comments']) {
            $objResponse->assign($p_name3, "innerHTML", $html);
        }
        //p_cpages_4
        // $objResponse->remove($p_name2);
        // $objResponse->assign($p_name2,"innerHTML","");
        $bullshit = 0;
        //   if ($TotalRows > $set[0]['perpage_comments'] and $bullshit == 0) { $objResponse->assign($p_name2,"innerHTML",$html5);  $bullshit =1; }
        //if ($TotalRows > $set[0]['perpage_comments']) $objResponse->assign($p_name3,"innerHTML",$html);
        //  $objResponse->assign($p_name,"innerHTML",$html2);
        /******************************************/
    }
    return $objResponse;
}