<?php
/**********************************************************************
*  Copyright notice PHP Enter
*
*  (c) 2011 Predrag Rukavina - admin[at]phpenter[dot]net
*  All rights reserved
*
*  This script is part of the PHP Enter project. 
*  The PHP Enter project is free software; you can redistribute it and/or
*  modify it under the terms of the GNU General Public License
*  as published by the Free Software Foundation; either version 2
*  of the License, or (at your option) any later version.
*
*  This program is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  You should have received a copy of the GNU General Public License
*  along with this program; if not, write to the Free Software
*  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
*  MA  02110-1301, USA.
*
*  This copyright notice MUST appear in all copies of the script!
************************************************************************/
include ('settings.php');
$arecordSet = $conn->Execute('SELECT * FROM categori ORDER BY name ASC');
if (!$arecordSet)
    print $conn->ErrorMsg();
else
    while (!$arecordSet->EOF) {
        if ($arecordSet->fields['cord'] == 0) {
            $aval[] = $arecordSet->fields;
        } else {
            $nval[] = $arecordSet->fields;
        }
        $arecordSet->MoveNext();
    }
/**
 * get_db_results()
 * 
 * @return
 */
function get_db_results() {
	$id = htmlspecialchars((int)$_GET['id']);
	global $conn;
	$_query = sprintf('SELECT SQL_CALC_FOUND_ROWS * FROM newser where idblog = '.$conn->qstr($id).' and (main = '.$conn->qstr('0').' or main = '.$conn->qstr('2').') ORDER BY bdate DESC LIMIT %d,%d',
		SmartyPaginate::getCurrentIndex(),SmartyPaginate::getLimit());
	$brecordSet = $conn->Execute($_query);
	if(!$brecordSet)
		print $conn->ErrorMsg();
	else
		while(!$brecordSet->EOF) {
			$_data[] = $brecordSet->GetRowAssoc(false);
			$brecordSet->MoveNext();
		}
	$_query = "SELECT FOUND_ROWS() as total";
	$crecordSet = $conn->Execute($_query);
	if(!$crecordSet)
		print $conn->ErrorMsg();
	else
		$_row = $crecordSet->GetRowAssoc();
	$total = $crecordSet->fields['total'];
	SmartyPaginate::setTotal($total);
	return @$_data;
	$brecordSet->Close();
	$crecordSet->Close();
}
require ('libs/SmartyPaginate.class.php');
SmartyPaginate::connect();
SmartyPaginate::setLimit(200);
SmartyPaginate::setUrl('press.php');
$smarty->caching = $caching;
$smarty->assign('results',get_db_results());
SmartyPaginate::assign($smarty);
$drecordSet = $conn->Execute('SELECT * FROM reviews ORDER BY revid DESC LIMIT 2,4');
if(!$drecordSet)
	print $conn->ErrorMsg();
else
	while(!$drecordSet->EOF) {
		$dval[] = $drecordSet->fields;
		$drecordSet->MoveNext();
	}
$erecordSet = $conn->Execute('SELECT * FROM newser_auto WHERE main = '.$conn->qstr('0').' ORDER BY bdate DESC LIMIT 6');
if(!$erecordSet)
	print $conn->ErrorMsg();
else
	while(!$erecordSet->EOF) {
		$eval[] = $erecordSet->fields;
		$erecordSet->MoveNext();
	}







$trecordSet = $conn->Execute('SELECT * FROM newser_auto WHERE main = '.$conn->qstr('0').' ORDER BY bdate DESC LIMIT 6');
if(!$trecordSet)
	print $conn->ErrorMsg();
else
	while(!$trecordSet->EOF) {
		$tval[] = $trecordSet->fields;
		$trecordSet->MoveNext();
	}

/* * ovan test att lägga in senaste nyheter som ticker*** */








$smarty->assign('categori',$aval);
$smarty->assign('subcat',@$nval);
@$smarty->assign('reviews',$dval);
$smarty->assign('newser',$eval);
$smarty->assign('ticker',$tval);
$id = htmlspecialchars((int)$_GET['id']);
@$next = htmlspecialchars((int)$_GET['next']);
$cid = $id.$next;
$smarty->display('auto-press.php',$cid);
$smarty->display('footer.php');
$arecordSet->Close();
$drecordSet->Close();
$erecordSet->Close();
$trecordSet->Close();
$conn->Close();
######################################
##press.php              4.1.4.##
######################################
?></div>
</div>
<footer class="mh-footer">












<div class="footer-bottom">
<div class="wrapper-inner clearfix">

<nav class="footer-nav clearfix">
<div class="menu-footer-container">
<ul id="menu-footer" class="menu">
<!--<li id="menu-item-1" class="menu-item"><a href="/contact.htm">Contact</a></li>-->
<li id="menu-item-2" class="menu-item"><a href="/aboutus.htm">About</a></li>
<li id="menu-item-3" class="menu-item"><a href="/terms.htm">Terms of Service</a></li>
<li id="menu-item-4" class="menu-item"><a href="/privacy.htm">Privacy Policy</a></li>
<li id="menu-item-5" class="menu-item"><a href="/member_page.htm">Member</a></li>
</ul>
</div>
</nav>

<div class="copyright-wrap">
<p class="copyright"> Copyright 2020 | <a href="https://coinalert.eu/" title="CoinAlert">CoinAlert</a></p>
</div>

</div>
</div>

</footer>









</body>
</html>