HEX
Server: Apache/2
System: Linux host.ouroempresas.com.br 3.10.0-1160.105.1.el7.x86_64 #1 SMP Thu Dec 7 15:39:45 UTC 2023 x86_64
User: silver (1010)
PHP: 8.2.28
Disabled: exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname
Upload Files
File: /home/silver/domains/jornaldecostarica.com.br/public_html/classificados/php/ad-favourite.php
<?php

if(!isset($_GET['page']))
    $_GET['page'] = 1;

$limit = 5;
$page = $_GET['page'];

if(checkloggedin()) {
    $item = array();
    $ses_userdata = get_user_data($_SESSION['user']['username']);
    $author_image = $ses_userdata['image'];

    $pagelimit = "";
    if($page != null && $limit != null){
        $limit = $limit;
        $offset = ($page-1)*$limit;
    }

    $total_item = ORM::for_table($config['db']['pre'].'favads')
        ->where('user_id', $_SESSION['user']['id'])
        ->count();

    $result = ORM::for_table($config['db']['pre'].'favads')
        ->select('product_id')
        ->where('user_id', $_SESSION['user']['id'])
        ->limit($limit)->offset($offset)
        ->find_many();
    if (count($result) > 0) {
        foreach ($result as $fav) {
            $info = ORM::for_table($config['db']['pre'].'product')->find_one($fav['product_id']);

            if (!empty($info)) {
                $item[$info['id']]['id'] = $info['id'];
                $item[$info['id']]['product_name'] = $info['product_name'];

                $description = strip_tags($info['description']);
                if (strlen($description) > 110) {

                    // truncate string
                    $stringCut = substr($description, 0, 110);
                    $endPoint = strrpos($stringCut, ' ');

                    //if the string doesn't contain any space then it will cut without word basis.
                    $description = $endPoint? substr($stringCut, 0, $endPoint) : substr($stringCut, 0);
                    $description .= '... <a href="'.$config['site_url'].'ad/'.$info['id'].'">'.$lang['READ_MORE'].'</a>';
                }
                $item[$info['id']]['desc'] = $description;
                $item[$info['id']]['featured'] = $info['featured'];
                $item[$info['id']]['urgent'] = $info['urgent'];
                $item[$info['id']]['highlight'] = $info['highlight'];
                $item[$info['id']]['address'] = strlimiter($info['location'],20);
                $item[$info['id']]['location'] = get_cityName_by_id($info['city']);
                $item[$info['id']]['city'] = get_cityName_by_id($info['city']);
                $item[$info['id']]['state'] = get_stateName_by_id($info['state']);
                $item[$info['id']]['country'] = get_countryName_by_id($info['country']);
                $item[$info['id']]['status'] = $info['status'];
                $item[$info['id']]['created_at'] = timeago($info['created_at']);

                $item[$info['id']]['rating'] = averageRating_by_itemid($info['id']);
                $item[$info['id']]['cat_id'] = $info['category'];
                $item[$info['id']]['sub_cat_id'] = $info['sub_category'];

                $get_main = get_maincat_by_id($info['category']);
                $get_sub = get_subcat_by_id($info['sub_category']);
                $item[$info['id']]['category'] = $get_main['cat_name'];
                $item[$info['id']]['sub_category'] = $get_sub['sub_cat_name'];

                $item[$info['id']]['favorite'] = check_product_favorite($info['id']);

                $tag = explode(',', $info['tag']);
                $tag2 = array();
                foreach ($tag as $val)
                {
                    //REMOVE SPACE FROM $VALUE ----
                    $val = trim($val);
                    $tag2[] = '<li><a href="listing?keywords='.$val.'">'.$val.'</a> </li>';
                }
                $item[$info['id']]['tag'] = implode('  ', $tag2);

                $picture     =   explode(',' ,$info['screen_shot']);
                $picture     =   $picture[0];
                $item[$info['id']]['picture'] = $picture;

                $price = price_format($info['price'],$info['country']);


                $item[$info['id']]['price'] = $price;

                $userinfo = get_user_data(null,$info['user_id']);

                $item[$info['id']]['username'] = $userinfo['username'];
                $author_url = create_slug($userinfo['username']);

                $item[$info['id']]['author_link'] = $config['site_url'].'profile/'.$author_url;

                $pro_url = create_slug($info['product_name']);
                $item[$info['id']]['link'] = $config['site_url'].'ad/' . $info['id'] . '/'.$pro_url;

                $cat_slug = create_slug($get_main['cat_name']);
                $item[$info['id']]['catlink'] = $config['site_url'].'category/'.$info['category'].'/'.$cat_slug;

                $subcat_slug = create_slug($get_sub['sub_cat_name']);
                $item[$info['id']]['subcatlink'] = $config['site_url'].'subcategory/'.$info['sub_category'].'/'.$subcat_slug;

                $city = create_slug($item[$info['id']]['city']);
                $item[$info['id']]['citylink'] = $config['site_url'].'city/'.$info['city'].'/'.$city;
            }


        }
    }


    $pagging = pagenav($total_item,$page,$limit,$link['FAVADS']);
    // Output to template
    $page = new HtmlTemplate ('templates/' . $config['tpl_name'] . '/ad-favourite.tpl');
    $page->SetParameter ('OVERALL_HEADER', create_header($lang['FAVOURITE_ADS']));
    $page->SetParameter ('RESUBMITADS', resubmited_ads_count($_SESSION['user']['id']));
    $page->SetParameter ('HIDDENADS', hidden_ads_count($_SESSION['user']['id']));
    $page->SetParameter ('PENDINGADS', pending_ads_count($_SESSION['user']['id']));
    $page->SetParameter ('FAVORITEADS', favorite_ads_count($_SESSION['user']['id']));
    $page->SetParameter ('EXPIREADS', expire_ads_count($_SESSION['user']['id']));
    $page->SetParameter ('MYADS', myads_count($_SESSION['user']['id']));
    $page->SetLoop ('ITEM', $item);
    $page->SetLoop ('PAGES', $pagging);
    $page->SetParameter ('TOTALITEM', $total_item);
    $page->SetParameter ('AUTHORUNAME', ucfirst($ses_userdata['username']));
    $page->SetParameter ('AUTHORNAME', ucfirst($ses_userdata['name']));
    $page->SetParameter ('AUTHORIMG', $author_image);
    $page->SetLoop ('HTMLPAGE', get_html_pages());
    $page->SetParameter('COPYRIGHT_TEXT', get_option("copyright_text"));
    $page->SetParameter ('OVERALL_FOOTER', create_footer());
    $page->CreatePageEcho();
}
else{
    error($lang['PAGE_NOT_FOUND'], __LINE__, __FILE__, 1);
    exit();
}
?>