Location: PHPKode > projects > phpBlogger > profile.php
<?php session_start();
/* * ********************************************************************
*  Copyright notice PHP Blogger 1.2.
*
*  (c) 2011 Predrag Rukavina - admin[at]phpblogger[dot]org
*  All rights reserved
*
*  This script is part of the PHP Blogger project. 
*  The PHP Blogger 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');
require_once ('languages/lang_english.php');
require_once ('salt.php');
require_once ('classes/securesession.class.php');
$ss = new SecSession();
$ss->check_browser = true;
$ss->check_ip_blocks = 2;
$ss->secure_word = $salt;
$ss->regenerate_id = true;
if($aconfig == 2){
if (!$ss->Check() || !isset($_SESSION['loggedin']) || !$_SESSION['loggedin']){
header('Location: userpanel.php');
die();
}
}
$cid = $_GET['cid'];
$cid = $conn->addq($cid);
$drecordSet = &$conn->Execute('SELECT * FROM users WHERE username = ? LIMIT 1', array($cid));
if($drecordSet) {
	if($drecordSet->fields == 0) {
                include 'notfound.php';
		$drecordSet->Close();
		$conn->Close();
		die();
	}
        }
if(!$drecordSet)
	print $conn->ErrorMsg();
else
	while(!$drecordSet->EOF) {
		$dval[] = $drecordSet->fields;
		$drecordSet->MoveNext();
	}
function get_db_results() {
        $cid = $_GET['cid'];
        global $conn;
        $cid = $conn->addq($cid);
        $_query = sprintf('SELECT SQL_CALC_FOUND_ROWS * FROM comment where texty = ? ORDER by commid desc LIMIT %d,%d',   
		SmartyPaginate::getCurrentIndex(),SmartyPaginate::getLimit());
	$arecordSet = $conn->Execute($_query,array($cid));
        
	if(!$arecordSet)
		print $conn->ErrorMsg();
	else
		while(!$arecordSet->EOF) {
			$_data[] = $arecordSet->GetRowAssoc(false);
			$arecordSet->MoveNext();
		}
	$_query = "SELECT FOUND_ROWS() as total";
	$brecordSet = $conn->Execute($_query);
	if(!$brecordSet)
		print $conn->ErrorMsg();
	else
		$_row = $brecordSet->GetRowAssoc();
	$total = $brecordSet->fields['total'];
	SmartyPaginate::setTotal($total);
	return @$_data;
	$arecordSet->Close();
	$brecordSet->Close();
}
require ('libs/SmartyPaginate.class.php');
SmartyPaginate::connect();
SmartyPaginate::setLimit(12);
SmartyPaginate::setUrl('profile.php');
$smarty->caching = $caching;
$smarty->assign('results',get_db_results());
SmartyPaginate::assign($smarty);
$crecordSet = &$conn->Execute("SELECT * FROM reviews LIMIT 70");
if(!$crecordSet)
	print $conn->ErrorMsg();
else
	while(!$crecordSet->EOF) {
		$cval[] = $crecordSet->fields;
		$crecordSet->MoveNext();
	}
$iconfig['date'] = '%I:%M %p';
$iconfig['time'] = '%H:%M:%S';
$smarty->assign('iconfig',$iconfig);
$smarty->assign('today',strtotime('+ 1 hours'));
$smarty->assign('reviews',@$cval);
$smarty->assign('users',@$dval);
$next = @$_GET['next'];
$incid = $cid . @$next;
$smarty->display('profile.php', $incid);
SmartyPaginate::reset();
$smarty->display('footer.php');
$crecordSet->Close();
$drecordSet->Close();
$conn->Close();
##############################
# profile.php  version 1.1.6.#
##############################
?>
Return current item: phpBlogger