| Server IP : 162.241.126.129 / Your IP : 3.142.135.24 Web Server : Apache System : Linux 162-241-126-129.cprapid.com 4.18.0-477.27.2.el8_8.x86_64 #1 SMP Fri Sep 29 08:21:01 EDT 2023 x86_64 User : rvway5nu4 ( 1018) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/rvway5nu4/www/ |
Upload File : |
<?php
//require_once('./setting.php');
//echo ABSPATH; exit; // F:\xampp\htdocs\carivon/
include("./config/data.config.php");
include("$LIB_DIR/functions.lib.php");
include("$LIB_DIR/db.php");
include("$LIB_DIR/db/mysqli.php");
include("$LIB_DIR/data.constant.php");
include("$LIB_DIR/sitemsgs.php");
include("$LIB_DIR/class.paging.php");
include("$LIB_DIR/functions.mailer.php");
$error='';
$msg='';
if( !isset( $_SESSION['SESS_id'] ) && ( $_SESSION['SESS_type'] == 'AD' ) ){
$_SESSION['msg'] = '<div class="alert alert-warning" >There is no login.</div>';
header('Location: '.SUB_DIR_PROJECT.'/index.php');
exit;
}
global $SITE_URL, $IMG_DIR;
$db = new Db( $DB_HOST, $DB_USERNAME, $DB_PASSWORD, $DB_NAME, $DB_REPORT_ERROR, $DB_PERSISTENT_CONN);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8"/>
<title>Caravon</title>
<!-- mobile responsive meta -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php require_once($ROOT_DIR.'/page_content/us/common/header_common_link1.php'); ?>
<?php //require_once($ROOT_DIR.'/page_content/us/common/header_common_link2.php'); ?>
<?php require_once($ROOT_DIR.'/page_content/us/common/header_common_link3.php'); ?>
<?php require_once($ROOT_DIR.'/page_content/us/common/header_common_link4.php'); ?>
</head>
<body>
<!-- <div class="preloader"></div> -->
<div class="page-wrapper" >
<!-- space for preloader -->
<header class="site-header header-one" >
<div class="top-header">
<?php require_once($ROOT_DIR.'/page_content/us/common/header_top.php'); ?>
</div><!-- /.top-header -->
<nav class="navbar navbar-expand-lg navbar-light header-navigation stricky header-style-one" >
<?php require_once($ROOT_DIR.'/page_content/us/common/header_nav.php'); ?>
</nav>
</header><!-- /.site-header -->
<?php // require_once($ROOT_DIR.'/page_content/minimal-bootstrap-carousel_h.php'); ?>
<?php // require_once($ROOT_DIR.'/page_content/us/home/minimal-bootstrap-carousel.php'); ?>
<!--Start AAAAAAAAAAAAAAAAAAAAAAAAAAAAA -->
<div style="margin:20px 0px 20px 0px;">
<div class="container">
<div class="row">
<div class="col-lg-12">
<h3 class="">DON'T SEE A PRICE? CALL 800-774-8330 OR EMAIL OUR SALES STAFF FOR THE BEST PRICING.</h2>
<h5 class="">Manufacturers have what's called minimum advertised pricing so we aren't aloud to list our low low prices!!</h3>
</div>
</div>
</div>
</div>
<div class="">
<div class="container">
<div class="row">
<div class="col-lg-3 d-none d-sm-block">
<div class="blog-sidebar">
<form class="mb-30" method="get" action="<?php echo site_url.'used.php'; ?>" >
<?php require_once($ROOT_DIR.'/page_content/used_sidebar.php'); ?>
</form>
</div><!-- /.blog-sidebar -->
</div><!-- /.col-lg-4 -->
<div class="col-lg-9 col-sm-12 col-xs-12">
<article class="product_loop">
<div class="row">
<?php
$sort_by = $_REQUEST['sort_by'];
if (!$sort_by)
{ $sort_by = "i_sortOrder";
}
$sort_order = $_REQUEST['sort_order'];
if (!$sort_order)
{ $sort_order = "desc";
}
GLOBAL $COLORS, $IMG_DIR, $TEMPLATE_DIR, $ARR_STATUS, $ARR_USERS_INDEX;
global $SEARCH_RECORDS,$PREV_PAGE_LINK,$NEXT_PAGE_LINK,$TOTAL_RECORDSET,$PAGE_NAVS, $CURRENT_PAGE_NO, $TOTAL_PAGES, $ARR_GLOBAL_STATUS, $ARR_USERS;
global $PROMPT, $ARR_GLOBAL_STATUS, $ARR_USERS, $ARR_STATUS, $HTTP_SESSION_VARS, $HTTP_POST_FILES, $HTTP_POST_VARS, $DOCUMENT_ROOT, $PIC_DIR, $BANNER_DIR, $TEMP_DIR, $MAP_VROOT_FILE_PATH, $ARR_INDENTITY_TYPE, $ARR_TITLE;
$CURRENT_PAGE_NO=0;
$TOTAL_PAGES=0;
$TOTAL_RECORDSET=0;
$MAX=12;
$page = ( isset( $_REQUEST['page'] ) ) ? $_REQUEST['page'] : 0 ;
if(!($page))
$page = 0 ;
$lastrow=$MAX+$page;
$SUB_SQL = '';
$next_links = '';
if( !empty($_REQUEST['search'] ) ){
$search = addslashes(trim($_REQUEST['search']));
$SUB_SQL .= " AND v_title LIKE '$search%' " ;
$next_links .= "&search=$search";
}
if( !empty($_REQUEST['year'] ) ){
$year = addslashes(trim($_REQUEST['year']));
$SUB_SQL .= " AND year LIKE '$year%' " ;
$next_links .= "&year=$year";
}
if( !empty($_REQUEST['model'] ) ){
$model = addslashes(trim($_REQUEST['model']));
$SUB_SQL .= " AND model LIKE '$model%' ";
$next_links .= "&model=$model";
}
if( !empty($_REQUEST['brand'] ) ){
$brand = addslashes(trim($_REQUEST['brand']));
$SUB_SQL .= " AND brand LIKE '$brand%' ";
$next_links .= "&brand=$brand";
}
if( !empty($_REQUEST['type'] ) ){
$type = addslashes(trim($_REQUEST['type']));
$SUB_SQL .= " AND brand LIKE '$type%' ";
$next_links .= "&type=$type";
}
if( !empty($_REQUEST['length'] ) ){
$length = addslashes(trim($_REQUEST['length']));
$SUB_SQL .= " AND length LIKE '$length%' " ;
$next_links .= "&length=$length";
}
if( !empty($_REQUEST['width'] ) ){
$width = addslashes(trim($_REQUEST['width']));
$SUB_SQL .= " AND width LIKE '$width%' " ;
$next_links .= "&width=$width";
}
if( !empty($_REQUEST['of_axles'] ) ){
$of_axles = addslashes(trim($_REQUEST['of_axles']));
$SUB_SQL .= " AND of_axles LIKE '$of_axles%' " ;
$next_links .= "&of_axles=$of_axles";
}
$SERCHSUBQUERY_Product = '';
$next_links .= "&sort_by=$sort_by&sort_order=$sort_order";
$query1 = "select count( * ) as total from tbl_items where 1 ".$SUB_SQL;
$query2 = "select * from tbl_items where 1 ".$SUB_SQL;
$query2.=" order by $sort_by $sort_order limit $page, $MAX ";
$result=$db->query($query1);
if($result->num_rows)
{
$TOTAL_RECORDSET= $result->row['total'];
}
if($TOTAL_RECORDSET > 0)
{
$result=$db->query($query2);
if ($result->num_rows)
{ $slno=$page+1;
foreach($result->rows AS $key=>$val )
{ //echo '<pre>'; print_r($val); echo '</pre>'; exit;
foreach($val AS $key1=>$val1 )
{
$$key1 = stripslashes($val1);
}
$img_flag = 1;
for( $i=1; $i < 11 ; $i++ ) {
$img = 'v_image'.$i;
$imgsrc = $$img;
//echo $v_image1; exit;
$target = "$DOCUMENT_ROOT$PIC_DIR/$imgsrc";
if ( $$img != '' && file_exists("$target"))
{
if( $img_flag == 1){
$img_flag = 2;
$imgSRC = $SITE_URL.'/pic/'.$imgsrc;
}
}
}
$img_src = ( isset($imgSRC )) ? $imgSRC : site_url.'/img/partners/aaa.jpg';
$new_arrival = ( $new_arrival_select == 1 ) ? '<span class="tag tag-pill tag-new">New Arrival</span>' : '';
$Reduced = ( $reduced_select == 1 ) ? '<span class="tag tag-pill tag-reduced">Reduced</span>' : '';
$In_Stock = ( $in_stock_select == 1 ) ? '<span class="tag tag-pill tag-instock">In Stock</span>' : '';
?>
<div class="col-md-6 col-lg-4 col-xl-4">
<div class="card">
<a href="<?php echo site_url.'item_detail.php?i_itemID='.$i_itemID; ?>" class="item-title">
<img class="img-fluid img-rounded lazyloaded" alt="<?php echo $v_title; ?>" title="<?php echo $v_title; ?>"src="<?php echo $img_src; ?>">
<div class="item-name"><?php echo $v_title; ?></div>
</a>
<div class="info-bar">
<ul>
<li>Sleeps: <?php echo $sleeps; ?></li>
<li>Width: <?php echo $width; ?></li>
<li>Length: <?php echo $length; ?></li>
</ul>
</div>
<div class="card-block">
<div class="item-price">
</div><!-- /.item-price -->
<div class="item-attributes px-0">
<?php echo $new_arrival; ?>
<?php echo $Reduced; ?>
<?php echo $In_Stock; ?>
</div>
<div class="item-stock-number">
<span class="stock-word">Stock #:</span> <span class="stock-number"><?php echo $stock; ?></span>
</div>
</div><!-- /.card-block -->
<a href="<?php echo site_url.'item_detail.php?i_itemID='.$i_itemID; ?>" class="btn btn-primary btn-block">View Details</a>
</div><!-- /.card -->
</div>
<?php
}
}
}else
{
$SEARCH_RECORDS.="<div class='col-sm-12'> No Item </div>";
}
if($page > 0)
{ $prevpage=$page - $MAX;
//$PREV_PAGE_LINK="| <a href='used.php?page=$prevpage&$next_links' class=menulink>Prev Page</a> |";
$PREV_PAGE_LINK = '<li data-lp="1" class="first disabled"><a href="used.php?page='.$prevpage.'&'.$next_links.'">←</a></li>';
}
if($TOTAL_RECORDSET > $lastrow)
{ //$NEXT_PAGE_LINK="| <a href='used.php?page=$lastrow&$next_links' class=menulink>Next Page</a> |";
$NEXT_PAGE_LINK ='<li data-lp="3" class="last"><a href="used.php?page='.$lastrow.'&'.$next_links.'">→</a></li>';
}
$PAGE_NAVS="";
// echo "total".$TOTAL_RECORDSET."<br>";
// echo "max".$MAX."<br>";
for($i=0,$toPrint=1;$i< $TOTAL_RECORDSET;$i+=$MAX,$toPrint++)
{ if ($lastrow-$i==$MAX)
{ //$PAGE_NAVS.=" <B>".$toPrint."</b> | ";
$PAGE_NAVS.='<li data-lp="'.$i.'" class="active"><a href="javascript:void(0);">'.(($i+12)/12).'</a></li>';
$CURRENT_PAGE_NO = $toPrint;
}
else
{ //$PAGE_NAVS.=" <a href='used.php?page=$i&$next_links' class=menulink>$toPrint</a> |";
$PAGE_NAVS .= '<li data-lp="1" class=""><a href="used.php?page='.$i.'&'.$next_links.'">'.(($i+12)/12).'</a></li>';
}
$TOTAL_PAGES=$toPrint;
}
?>
</div>
</article>
<div class="col-sm-12" style="margin-top:20px;" >
<div class="row d-flex justify-content-center">
<ul class="pagination">
<?php echo $PREV_PAGE_LINK; ?>
<?php echo $PAGE_NAVS; ?>
<?php echo $NEXT_PAGE_LINK; ?>
</ul>
</div>
</div>
<div class="col-sm-12" style="margin-top:20px;" >
<div class="row d-flex justify-content-center">
<p class="disclaimer-text" style="margin-top:20px;" >Don’t see a price? Click the Get Sale Price button, Call, or Email our sales staff for the best pricing. <br></p>
</div>
</div>
</div><!-- /.col-lg-8 -->
</div><!-- /.row -->
</div><!-- /.container -->
</div><!-- /.blog blog-single -->
<!--End AAAAAAAAAAAAAAAAAAAAAAAAAAAAA -->
</div><!-- /.page-wrapper -->
<footer class="crop">
<?php require_once($ROOT_DIR.'/page_content/us/common/footer_middle.php'); ?>
<?php require_once($ROOT_DIR.'/page_content/us/common/footer_bottom.php'); ?>
</footer>
<a href="#" data-target="html" class="scroll-to-target scroll-to-top"><i class="fa fa-long-arrow-up"></i></a>
<!-- /.scroll-to-top -->
<?php require_once($ROOT_DIR.'/page_content/us/common/footer_js.php'); ?>
<script >
$('#partner_tab_2').hide();
$(".tabparner").on("click", function(){
var tabparner_id = $(this).attr('id');
//alert("The paragraph was clicked." + tabparner_id);
if( tabparner_id == 'tab_1' ){
$("#tab_1").addClass("activetab");
$("#tab_1").removeClass("deactivetab");
$("#tab_2").removeClass("activetab");
$("#tab_2").addClass("deactivetab");
$('#partner_tab_1').show();
$('#partner_tab_2').hide();
}
if( tabparner_id == 'tab_2' ){
$("#tab_2").addClass("activetab");
$("#tab_2").removeClass("deactivetab");
$("#tab_1").removeClass("activetab");
$("#tab_1").addClass("deactivetab");
$('#partner_tab_1').hide();
$('#partner_tab_2').show();
}
});
</script>
</body>
</html>