Location: PHPKode > scripts > Ja2BU > index.php
<?php session_start();
/**********************************************************************
*  Copyright notice Ja2BU 1.1.
*
*  (c) 2011 Predrag Rukavina - admin[at]phpform[dot]net
*  All rights reserved
*
*  This script is part of the Ja2BU project. 
*  The Ja2BU 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');
if($frontpage == 1) {
	function get_db_results() {
		global $conn;
		$_query = sprintf('SELECT SQL_CALC_FOUND_ROWS * FROM article WHERE main = ? ORDER BY blogid DESC LIMIT %d,%d',
			SmartyPaginate::getCurrentIndex(),SmartyPaginate::getLimit());
		$brecordSet = $conn->Execute($_query,array('1'));
		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();
	}
}
if($frontpage == 2) {
	function get_db_results() {
		global $conn;
		$_query = sprintf('SELECT SQL_CALC_FOUND_ROWS * FROM article WHERE main = ? ORDER BY blogid DESC LIMIT %d,%d',
			SmartyPaginate::getCurrentIndex(),SmartyPaginate::getLimit());
		$brecordSet = $conn->Execute($_query,array('2'));
		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(12);
SmartyPaginate::setUrl('');
include('session.php');
$smarty->caching = $caching;
$smarty->assign('results',get_db_results());
SmartyPaginate::assign($smarty);
$drecordSet = &$conn->Execute('SELECT * FROM onewse ORDER BY oids DESC LIMIT 12, 4');
if(!$drecordSet)
	print $conn->ErrorMsg();
else
	while(!$drecordSet->EOF) {
		$dval[] = $drecordSet->fields;
		$drecordSet->MoveNext();
	}
$erecordSet = &$conn->Execute('SELECT * FROM reviews ORDER BY revid DESC LIMIT 50');
if(!$drecordSet)
	print $conn->ErrorMsg();
else
	while(!$erecordSet->EOF) {
		$eval[] = $erecordSet->fields;
		$erecordSet->MoveNext();
	}
$frecordSet = &$conn->Execute('SELECT * FROM catags ORDER BY nofhash DESC LIMIT 12');
if(!$frecordSet)
	print $conn->ErrorMsg();
else
	while(!$frecordSet->EOF) {
		$fval[] = $frecordSet->fields;
		$frecordSet->MoveNext();
	}
$smarty->caching = $caching;
$smarty->assign('onewse',@$dval);
$smarty->assign('reviews',@$eval);
$smarty->assign('catags',@$fval);
if($frontpage == 1) {
	$smarty->display('questions.php');
}
if($frontpage == 2) {
	$smarty->display('snippets.php');
}
SmartyPaginate::reset();
$smarty->display('footer.php');
$drecordSet->Close();
$erecordSet->Close();
$frecordSet->Close();
$conn->Close();
######################################
##index.php                     1.1.##
######################################
?>
Return current item: Ja2BU