PHP - error al instalar script openlist

<?php

class SystemConsts {

	const DB='test',

	HOST='localhost',

    DSN='mysql:dbname=test;host=localhost',

    USERNAME='root',

	PASSWORD='root';

}

?>

<?php

class SystemConsts {

	const DB='nombre de la base de datos',

	HOST='localhost',

    	DSN='mysql:dbname=dbone;host=localhost',

    	USERNAME='root',

	PASSWORD='contraseña';

}

?>

<?php

	error_reporting(0);//TODO: uncomment in prod

	define('DEFAULT_LANGUAGE','en.lang.php');

	// define('DEFAULT_LANGUAGE','ru.lang.php');

	//$page_limit=20;

	//$date_limit=60;

	define ('CONF_PAGE_LIMIT',100);  //number of ad per page

	define ('CONF_DATE_LIMIT',60); //limit after how many days ad won't show

	date_default_timezone_set('Europe/London');

	// date_default_timezone_set('Europe/Moscow');

	// define ('CONF_LANG','ru');

	define ('CONF_LANG','en-us');

	define('CONF_ENC','UTF-8');

	define('DATE_FORMAT','d/m/Y');

	//define(DATE_FORMAT,'Д, d л Y');

	define('PHOTO_SIZE_LIMIT','50000');

	define ('PHOTO_TYPES','jpg,jpeg,pjpeg,gif,png,bmp,tiff');

	define('SITE_URL','http://localhost/');

	// define('SITE_URL','http://openlist.co/');

	define('TPL_PATH','tpl/');

	define('ADMIN_EMAIL','admin@openList.co');

	define('MONSTER_EMAIL','monster@openList.co');

	define('LOG_EMAIL','log@openList.co');

	define('CONF_VERSION_LANG','');

?>

error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED

<?php

	include ('../config.php');

if(isset($_POST['create'])) {

		$sitename = $_POST['sitename'];

		$siteurl = $_POST['siteurl'];

		$name = mysql_real_escape_string($_POST['name']);

		$email = mysql_real_escape_string($_POST['email']);

		$pass1 = $_POST['pass1'];

		$pass2 = $_POST['pass2'];

		$avatar = "http://www.gravatar.com/avatar/".md5( strtolower( trim( $email ) ) )."?d=".$siteurl."/images/avatar.png&s=90";

		function genRandomString() {

    $length = 10;

    $characters = '0123456789abcdefghijklmnopqrstuvwxyz';

    for ($p = 0; $p < $length; $p++) {

18      $string .= $characters[mt_rand(0, strlen($characters))];

    }

    return $string;

	}

	$universalid = genRandomString();

	if (!$sitename || !$siteurl || !$name || !$email) {

		header('Location: index.php?error=missing');

		exit();

	}

	if ($pass1 != $pass2) {

		header('Location: index.php?error=nomatch');

		exit();

	}

// CREATE TABLES

		// adboxes

		$sql = "CREATE TABLE IF NOT EXISTS `adboxes` (

  `id` int(8) NOT NULL AUTO_INCREMENT,

  `adcode` text COLLATE utf8_unicode_ci DEFAULT NULL,

  PRIMARY KEY (`id`) );";

		$query = mysql_query($sql);

		// admins

		$sql = "CREATE TABLE IF NOT EXISTS `admins` (

  `id` int(8) NOT NULL AUTO_INCREMENT,

  `email` varchar(256) COLLATE utf8_unicode_ci NOT NULL,

  `username` varchar(128) COLLATE utf8_unicode_ci NOT NULL,

  `password` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,

  `avatar` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,

  PRIMARY KEY (`id`) );";

		$query = mysql_query($sql);

		//  articles

		$sql = "CREATE TABLE IF NOT EXISTS `articles` (

  `id` int(16) NOT NULL AUTO_INCREMENT,

  `status` int(1) NOT NULL,

  `authorid` int(16) NOT NULL,

  `date` datetime NOT NULL,

  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,

  `categoryid` int(8) NOT NULL,

  `parentid` int(8) DEFAULT NULL,

  `body` text COLLATE utf8_unicode_ci NOT NULL,

  `resource` text COLLATE utf8_unicode_ci NOT NULL,

  `problem` text COLLATE utf8_unicode_ci,

  PRIMARY KEY (`id`));";

		$query = mysql_query($sql);

		//  articleviews

		$sql = "CREATE TABLE IF NOT EXISTS `articleviews` (

  `articleid` int(11) NOT NULL,

  `views` int(11) NOT NULL,

  PRIMARY KEY (`articleid`) ) ;";

		$query = mysql_query($sql);

		//  authors

		$sql = "CREATE TABLE IF NOT EXISTS `authors` (

  `id` int(16) NOT NULL AUTO_INCREMENT,

  `status` int(1) NOT NULL DEFAULT '0',

  `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL,

  `username` varchar(32) COLLATE utf8_unicode_ci NOT NULL,

  `password` varchar(40) COLLATE utf8_unicode_ci NOT NULL,

  `fname` varchar(32) COLLATE utf8_unicode_ci NOT NULL,

  `displayname` varchar(32) COLLATE utf8_unicode_ci NOT NULL,

  `bio` text COLLATE utf8_unicode_ci,

  `url` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,

  `gravatar` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,

  `mailopt` int(1) NOT NULL,

  PRIMARY KEY (`id`) ); ";

		$query = mysql_query($sql);

		//  categories

		$sql = "CREATE TABLE IF NOT EXISTS `categories` (

  `id` int(8) NOT NULL AUTO_INCREMENT,

  `parentid` int(8) DEFAULT NULL,

  `name` varchar(256) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`id`));";

		$query = mysql_query($sql);

		//  comments

		$sql = "CREATE TABLE IF NOT EXISTS `comments` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `author` varchar(24) COLLATE utf8_unicode_ci NOT NULL,

  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,

  `comment` text COLLATE utf8_unicode_ci NOT NULL,

  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

  `parent_id` int(11) NOT NULL DEFAULT '0',

  `post_id` int(11) NOT NULL DEFAULT '0',

  `accepted` tinyint(1) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  KEY `parent` (`parent_id`,`id`)

  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;";

		$query = mysql_query($sql);

		//  pages

		$sql = "CREATE TABLE IF NOT EXISTS `pages` (

  `id` int(8) NOT NULL AUTO_INCREMENT,

  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,

  `body` text COLLATE utf8_unicode_ci NOT NULL,

  `onmenu` int(1) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)) ;";

		$query = mysql_query($sql);

		//  settings

		$sql = "CREATE TABLE IF NOT EXISTS `settings` (

  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,

  `url` varchar(256) COLLATE utf8_unicode_ci NOT NULL,

  `minwords` int(8) NOT NULL,

  `maxwords` int(8) NOT NULL,

  `template` varchar(64) COLLATE utf8_unicode_ci NOT NULL,

  `logourl` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,

  `comments` int(1) NOT NULL,

  `commentmod` int(1) NOT NULL,

  `emailopt` int(1) NOT NULL,

  `skipqueue` int(1) NOT NULL,

  `distribution` int(1) NOT NULL,

  `universalid` varchar(16) DEFAULT NULL,

  `statcode` text COLLATE utf8_unicode_ci) ;";

		$query = mysql_query($sql);

// INSERT DATA INTO TABLES

		// admin

		$sql = "INSERT INTO `admins` VALUES (NULL, '".$email."', 'admin', '".md5($pass1)."', '".$name."', '".$avatar."');";

		$query = mysql_query($sql);

		// author (admin account)

		$sql = "INSERT INTO `authors` VALUES (NULL, 0, '".$email."', 'admin', '".md5($pass1)."', '".$name."', '".$name."', 'N/A', '".$siteurl."', '".$avatar."', 0);";

		$query = mysql_query($sql);

		// site settings

		$sql = "INSERT INTO `settings` VALUES ('".$sitename."', '".$siteurl."', 1, 1500, 'classic', NULL, 0, 0, 0, 1, 0, '".$universalid."', NULL);";

		$query = mysql_query($sql);

		// setup blank ad slots

		$sql = "INSERT INTO `adboxes` (`id`, `adcode`) VALUES  (1, '<img src=\"".$siteurl."/images/250.gif\" />'), (2, '<img src=\"".$siteurl."/images/468.gif\" />'), (3, '<img src=\"".$siteurl."/images/125.gif\" />');";

		$query = mysql_query($sql);

		// Insert Categories

		$sql = "INSERT INTO `categories` (`id`, `parentid`, `name`) VALUES

(1, NULL, 'Internet Business'),

(2, NULL, 'Arts & Entertainment'),

(3, NULL, 'Business'),

(4, NULL, 'Communications'),

(5, NULL, 'Computers'),

(6, NULL, 'Environment'),

(7, NULL, 'Fashion'),

(8, NULL, 'Finance'),

(9, NULL, 'Food & Beverage'),

(10, NULL, 'Health & Fitness'),

(11, NULL, 'Home & Family'),

(12, NULL, 'Politics'),

(13, NULL, 'Product Reviews'),

(14, NULL, 'Sports & Recreation'),

(15, NULL, 'Reference & Education'),

(16, NULL, 'Self Improvement'),

(17, NULL, 'Society'),

(18, NULL, 'Travel & Leisure'),

(19, NULL, 'Transportation'),

(20, NULL, 'Writing & Speaking'),

(21, 1, 'Ecommerce'),

(22, 1, 'Affiliate Programs'),

(23, 1, 'Auctions'),

(24, 1, 'Blogging'),

(25, 1, 'Domains'),

(26, 1, 'Ebooks'),

(27, 1, 'Email Marketing'),

(28, 1, 'Forums'),

(29, 1, 'Internet Marketing'),

(30, 1, 'Podcasts'),

(31, 1, 'PPC Advertising'),

(32, 1, 'RSS'),

(33, 1, 'Security'),

(34, 1, 'SEO'),

(35, 1, 'Site Promotion'),

(36, 1, 'Spam'),

(37, 1, 'Traffic Generation'),

(38, 1, 'Web Design'),

(39, 1, 'Web Hosting'),

(40, 2, 'Photography'),

(41, 2, 'Celebrities'),

(42, 2, 'Humanities'),

(43, 2, 'Humor'),

(44, 2, 'Music'),

(45, 2, 'Poetry'),

(46, 3, 'Advertising'),

(47, 3, 'Article Marketing'),

(48, 3, 'Careers'),

(49, 3, 'Customer Service'),

(50, 3, 'Entrepreneurs'),

(51, 3, 'Ethics'),

(52, 3, 'Home Based Business'),

(53, 3, 'Management'),

(54, 3, 'Marketing'),

(55, 3, 'Networking'),

(56, 3, 'Public Relations'),

(57, 3, 'Sales'),

(58, 3, 'Small Business'),

(59, 4, 'Broadband Internet'),

(60, 4, 'GPS'),

(61, 4, 'Mobile Phones'),

(62, 4, 'Satellite Radio'),

(63, 4, 'Satellite TV'),

(64, 4, 'Video Conferencing'),

(65, 4, 'VOIP'),

(66, 5, 'Computer Certification'),

(67, 5, 'Data Recovery'),

(68, 5, 'Games'),

(69, 5, 'Hardware'),

(70, 5, 'Networks'),

(71, 5, 'Software'),

(72, 5, 'Mobile'),

(73, 6, 'Agriculture'),

(74, 6, 'Green Living'),

(75, 7, 'Clothing'),

(76, 7, 'Jewelry'),

(77, 7, 'Runway'),

(78, 7, 'Shoes'),

(79, 8, 'Credit'),

(80, 8, 'Currency Trading'),

(81, 8, 'Debt Consolidation'),

(82, 8, 'Fundraising'),

(83, 8, 'Insurance'),

(84, 8, 'Investing'),

(85, 8, 'Investments'),

(86, 8, 'Leasing'),

(87, 8, 'Loans'),

(88, 8, 'Mortgage'),

(90, 8, 'Mutual Funds'),

(91, 8, 'Personal Finance'),

(92, 8, 'Real Estate'),

(93, 8, 'Stock Market'),

(94, 8, 'Taxes'),

(95, 8, 'Wealth Building'),

(96, 9, 'Coffee'),

(97, 9, 'Cooking'),

(98, 9, 'Gourmet'),

(99, 9, 'Recipes'),

(100, 9, 'Waiting Tables'),

(101, 9, 'Wine'),

(102, 10, 'Acne'),

(103, 10, 'Alternative Medicine'),

(104, 10, 'Beauty'),

(105, 10, 'Cardio'),

(106, 10, 'Depression'),

(107, 10, 'Diabetes'),

(108, 10, 'Exercise'),

(109, 10, 'Fitness Equipment'),

(110, 10, 'Hair Loss'),

(111, 10, 'Medicine'),

(112, 10, 'Meditation'),

(113, 10, 'Mens Issues'),

(114, 10, 'Muscle Building'),

(115, 10, 'Nutrition'),

(116, 10, 'Pollution'),

(117, 10, 'Supplements'),

(118, 10, 'Weight Loss'),

(119, 10, 'Womens Issues'),

(120, 10, 'Yoga'),

(121, 10, 'Disease'),

(122, 10, 'Cancer'),

(123, 11, 'Home Security'),

(124, 11, 'Babies'),

(125, 11, 'Crafts'),

(126, 11, 'Elderly Care'),

(127, 11, 'Gardening'),

(128, 11, 'Hobbies'),

(129, 11, 'Holidays'),

(130, 11, 'Home Improvement'),

(131, 11, 'Interior Design'),

(132, 11, 'Kids'),

(133, 11, 'Landscaping'),

(134, 11, 'Parental Care'),

(135, 11, 'Parenting'),

(136, 11, 'Pets'),

(137, 11, 'Pregnancy'),

(138, 12, 'Commentary'),

(139, 12, 'Current Events'),

(140, 12, 'History'),

(141, 13, 'Consumer Electronics'),

(142, 13, 'Digital Products'),

(143, 13, 'Movie Reviews'),

(144, 13, 'Music Reviews'),

(145, 14, 'Biking'),

(146, 14, 'Extreme'),

(147, 14, 'Fishing'),

(148, 14, 'Football'),

(149, 14, 'Gambling & Casinos'),

(150, 14, 'Golf'),

(151, 14, 'Hunting'),

(152, 14, 'Martial Arts'),

(153, 14, 'Running'),

(154, 14, 'Surfing'),

(155, 14, 'Tennis'),

(156, 15, 'Adult'),

(157, 15, 'College'),

(158, 15, 'Environmental'),

(159, 15, 'Homeschooling'),

(160, 15, 'K-12 Education'),

(161, 15, 'Language'),

(162, 15, 'Legal'),

(163, 15, 'Philosophy'),

(164, 15, 'Psychology'),

(165, 15, 'Science'),

(166, 15, 'Sociology'),

(167, 15, 'Weather'),

(168, 16, 'Attraction'),

(169, 16, 'Coaching'),

(170, 16, 'Creativity'),

(171, 16, 'Goal Setting'),

(172, 16, 'Grief'),

(173, 16, 'Happiness'),

(174, 16, 'Innovation'),

(175, 16, 'Inspirational'),

(176, 16, 'Leadership'),

(177, 16, 'Motivation'),

(178, 16, 'Organizing'),

(179, 16, 'Spirituality'),

(180, 16, 'Stress Management'),

(181, 16, 'Success'),

(182, 16, 'Time Management'),

(183, 17, 'Dating'),

(184, 17, 'Divorce'),

(185, 17, 'Marriage'),

(186, 17, 'Relationships'),

(187, 17, 'Religion'),

(188, 17, 'Sexuality'),

(189, 17, 'Weddings'),

(190, 18, 'Aviation'),

(191, 18, 'Boating'),

(192, 18, 'Cruises'),

(193, 18, 'Destinations'),

(194, 18, 'Outdoors'),

(195, 18, 'Travel Tips'),

(196, 18, 'Vacations'),

(197, 19, 'Boats'),

(198, 19, 'Cars'),

(199, 19, 'Motorcycles'),

(200, 19, 'RVs'),

(201, 19, 'Trucks-SUVS'),

(202, 20, 'Article Writing'),

(203, 20, 'Book Reviews');";

		$query = mysql_query($sql);

// Post to Synergy

	$post_data['siteurl'] = $siteurl;

	$post_data['sitename'] = $sitename;

	$post_data['universalid'] = $universalid;

	//traverse array and prepare data for posting (key1=value1)

	foreach ( $post_data as $key => $value) {

		$post_items[] = $key . '=' . $value;

	}

	//create the final string to be posted using implode()

	$post_details = implode ('&', $post_items);

	//create cURL connection

	$curl_connection = curl_init('http://www.articlesynergy.com/listener.php');

	//set options

	curl_setopt($curl_connection, CURLOPT_CONNECTTIMEOUT, 30);

	curl_setopt($curl_connection, CURLOPT_USERAGENT,

	  "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)");

	curl_setopt($curl_connection, CURLOPT_RETURNTRANSFER, true);

	curl_setopt($curl_connection, CURLOPT_SSL_VERIFYPEER, false);

	curl_setopt($curl_connection, CURLOPT_FOLLOWLOCATION, 0);

	//set data to be posted

	curl_setopt($curl_connection, CURLOPT_POSTFIELDS, $post_details);

	//perform our request

	$result = curl_exec($curl_connection);

	//close the connection

	curl_close($curl_connection);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"

	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>

	<title>ArticleSetup Installation</title>

	<style type="text/css">

		body { background: #ddd; font-family:Verdana, sans-serif;font-size:12px;line-height:16px;color:#222; }

		#container     { left: 50%; margin-left: -275px; position: relative; width: 550px; padding: 10px; background: white;}

		a:link, a:visited { color: #396EB7; text-decoration: none; }

		a:hover { text-decoration: underline; }

		p {line-height: 1.4em; font-size: 1em; padding: 5px 0 8px 5px; margin: 0; color: #666;}

		h1 { color: #333;font-size: 18px; color: #666; font-weight:lighter; margin:0 0 10px; padding: 10px 0; border-bottom: 1px solid #ECE8DA;}

		#footer	       { width:540px; border-top: 2px solid #F3F1E9; margin: 10px 0; height: 25px; padding: 5px;}

		#submitstyle { background-color:#f5f5f5;  border:1px solid #dedede;  border-top:1px solid #eee;    border-left:1px solid #eee;     font-family:"Lucida Grande", Tahoma, Arial, Verdana, sans-serif;    font-size:12px;    line-height:130%;    text-decoration:none;    font-weight:bold;    color:#336699;     cursor:pointer;     padding:5px 10px 6px 7px; /* Links */ }

 		#submitstyle:hover {     background-color:#dff4ff;   border:1px solid #c2e1ef;   color:#336699; }

		label { color: #666; float:left; width: 125px; padding: 5px 0;}

		input { color: #666; background: #fff; padding: 5px; border: 1px solid #ccc; }

	</style>

</head>

<body>

<div id="container">

<!-- CONTENT AREA -->

<div id="content">

<h1>ArticleSetup Installation (Step 2 of 2)</h1>

<p><b>Success!</b> <?php echo $sitename; ?> has been successfully installed. There are a few final steps you need to take: </p>

<p><b>Delete the install directory</b> - For security reasons, it's very important that you delete this /install folder in your server before you begin using your new directory. </p>

<p><b>Login to the admin dashboard</b> - ArticleSetup includes a fully-featured admin control panel that allows you to manage and monitor every aspect of your directory. The admin panel can be found at: <a href="<?php echo $siteurl; ?>/admin"><?php echo $siteurl; ?>/admin</a> and you will login with the username: <b>admin</b> and the password you chose on the previous page.</p>

<p><b>Polish your site's settings</b> - Once you've become comfortable with your admin panel, navigate to the site settings panel. From here, you can upload a logo, manage email settings, add stat tracking code and more. </p>

<p>Finally, if you need any support, feel free to visit our support forums at: <a href="http://articlesetup.com/forums">http://articlesetup.com/forums</a> for fast support. Thanks again for installing ArticleSetup, and good luck with your new directory! </p>

<?php } else { ?>

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"

	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>

	<title>ArticleSetup Installation</title>

	<style type="text/css">

		body { background: #ddd; font-family:Verdana, sans-serif;font-size:12px;line-height:16px;color:#222; }

		#container     { left: 50%; margin-left: -275px; position: relative; width: 550px; padding: 10px; background: white;}

		a:link, a:visited { color: #396EB7; text-decoration: none; }

		a:hover { text-decoration: underline; }

		p {line-height: 1.4em; font-size: 1em; padding: 5px 0 8px 5px; margin: 0; color: #666;}

		h1 { color: #333;font-size: 18px; color: #666; font-weight:lighter; margin:0 0 10px; padding: 10px 0; border-bottom: 1px solid #ECE8DA;}

		#footer	       { width:540px; border-top: 2px solid #F3F1E9; margin: 10px 0; height: 25px; padding: 5px;}

		#submitstyle { background-color:#f5f5f5;  border:1px solid #dedede;  border-top:1px solid #eee;    border-left:1px solid #eee;     font-family:"Lucida Grande", Tahoma, Arial, Verdana, sans-serif;    font-size:12px;    line-height:130%;    text-decoration:none;    font-weight:bold;    color:#336699;     cursor:pointer;     padding:5px 10px 6px 7px; /* Links */ }

 		#submitstyle:hover {     background-color:#dff4ff;   border:1px solid #c2e1ef;   color:#336699; }

		label { color: #666; float:left; width: 125px; padding: 5px 0;}

		input { color: #666; background: #fff; padding: 5px; border: 1px solid #ccc; }

	</style>

</head>

<body>

<div id="container">

<!-- CONTENT AREA -->

<div id="content">

	<h1>ArticleSetup Installation (Step 1 of 2)</h1>

				<?php

501	if($_GET["error"] == "nomatch") 

		echo '<p  style=" padding-left: 15px; color: red;">Passwords didn\'t Match</p>';

503	if($_GET["error"] == "missing")

		echo '<p  style="color: red; padding-left: 15px; color: red;">Please complete all fields</p>';

?>

<p><b>Welcome to Article Setup!</b> The installation process was designed to be simple, fast, and totally painless. Your brand new article directory should be up and running in less than 5 minutes. Let's get started!</p>

<p><b>NOTE</b> At this point, you should have already uploaded all files into your server, setup a fresh database, and entered your database information into the config.php file on your server. If you haven't already, please complete those steps before continuing.</p>

	<br/>

	<form style="padding-left: 15px;" name="submission" method="POST" action="index.php">

	<label>Site Name:</label>

516	<input type="text" name="sitename" style="width: 250px;" value="<?php echo $oldname; ?>">

	<br/>

	<label>Site URL:</label>

519	<input type="text" name="siteurl" style="width: 250px;" value="<?php echo $oldemail; ?>">

	<p style="font-size: .9em; padding: 0 35px 0 125px;"><em>NOTE: Site URL <u>must</u> be in exactly the following format: <b>http://www.example.com</b> OR <b>http://example.com</b> (no trailing slashes)</em></p>

	<br/>

	<label>Admin Email:</label>

523	<input type="text" name="email" style="width: 250px;" value="<?php echo $oldname; ?>">

	<br/>

	<label>Admin Name:</label>

526	<input type="text" name="name" style="width: 250px;" value="<?php echo $oldname; ?>">

	<br/>

	<label>Admin Username:</label>

	<p>admin</p>

	<label>Admin Password:</label>

	<input type="password" name="pass1" style="width: 250px;">

	<br/>

	<label>Password (again):</label>

	<input type="password" name="pass2" style="width: 250px;">

	<br/>

	<input name="create" type="hidden" id="create" />

	<div style="clear:both"></div>

	<br/><br/>

	<button type="submit" id="submitstyle">Continue to Step 2 &raquo;</button>

</form>

<?php } ?>

</body>

</html>

</div>

<!-- FOOTER -->

<div id="footer">

	<div style="float:right"><p>&copy; 2011 - ArticleSetup.com<br/></p></div>

</div>

</div>  <!-- close Container -->

</body>

</html>

<?php

$cathead = 0;

4 $metatitle = $sitetitle;

include('config.php');

include('header.php');

include('sidebar.php');

	if ($seourls == 1) {

		include ('paginator-seo.php');

	} else {

		include ('paginator.php');

	}

// Setup the home template

	$home = new Template("templates/".$template."/home.tpl");

	$home->set("siteurl", $siteurl);

	$home->set("contenttitle", "Most Recent Articles");

// Setup pagination controls

	$rowsquery = "select * from articles where status=0";

	$rowsresults = mysql_query($rowsquery,$connection) or die(mysql_error());

	$rows_results = mysql_num_rows($rowsresults);

	$pages = new Paginator;

	if ($seourls == 1) {

		$pages->nav = $siteurl;

	} else {

		$pages->urlparam = "?";

	}

	$pages->items_total = $rows_results;

	$pages->mid_range = 9;

	$pages->paginate();

	if ($pages->items_total) {

		$query = "select * from articles where status=0 order by date desc ".$pages->limit;

	} else {

		$query = "select * from articles where status=0	order by date desc";

	}

	$articleresults = mysql_query($query,$connection) or die(mysql_error());

	$num_results = mysql_num_rows($articleresults);

// BEGIN LOOPING THROUGH ALL ARTICLES

	if ($num_results == 0) {

		echo "<p>No articles found!</p>";

	} else {

		for ($i=0; $i <$num_results; $i++) {

			$row = mysql_fetch_assoc($articleresults);

		//Get article info

			$id = $row['id'];

			$authorid = $row['authorid'];

			$date = strtotime($row['date']);

			$artdate = date('m/d/y', $date);

			$categoryid = $row['categoryid'];

			$title = $row['title'];

			if ($seourls == 1) { $scrubtitle = generate_seo_link($title); }

			$body = strip_tags(substr($row['body'], 0, 300));

		//get author info

			$authorquery = "select * from authors where id=".$authorid;

			$authorresult = mysql_query($authorquery,$connection) or die(mysql_error());

			$authorinfo = mysql_fetch_array($authorresult);

			$authorname = $authorinfo['displayname'];

			if ($seourls == 1) { $scrubauthor = generate_seo_link($authorname); }

		//get category info

			$catquery = "select * from categories where id=".$categoryid;

			$catresult = mysql_query($catquery,$connection) or die(mysql_error());

			$catinfo = mysql_fetch_array($catresult);

			$categoryname = $catinfo['name'];

			$catparent = $catinfo['parentid'];

			if ($seourls == 1) {  $scrubcatname = generate_seo_link($categoryname); }

		// If this article doesn't have a parent, display this:

			if ($catparent == NULL) {

				if ($seourls == 1) { // With SEO URLS

					$displaycat = "<a href=\"".$siteurl."/category/".$categoryid."/"

					.$scrubcatname."/\"><b>".$categoryname."</b></a>";

				} else {

					$displaycat = "<a href=\"".$siteurl."/category.php?id=".$categoryid

					."\"><b>".$categoryname."</b></a>";

				}

			} else {

		// if it does have a parent, display this:

				$query = "select * from categories where id=".$catparent;

				$result = mysql_query($query,$connection) or die(mysql_error());

				$info = mysql_fetch_array($result);

				$parentname = $info['name'];

				if ($seourls == 1) { $scrubparent = generate_seo_link($parentname); }

				if ($seourls == 1) { // With SEO URLS

					$displaycat = "<a href=\"".$siteurl."/category/".$catparent

					."/".$scrubparent."/\"><b>".$parentname."</b></a> >

				   <a href=\"".$siteurl."/category/".$categoryid."/".$scrubcatname

				   ."/\"><b>".$categoryname."</b></a>";

				} else {

					$displaycat = "<a href=\"".$siteurl."/category.php?id=".$catparent

					."\"><b>".$parentname."</b></a> >

				   <a href=\"".$siteurl."/category.php?id=".$categoryid."\"><b>"

				   .$categoryname."</b></a>";

				}

			}

		// Display the articles!

			if ($seourls == 1) { // With SEO URLS

				$thisrow = "<h2><a href=\"".$siteurl."/".$id."/".$scrubtitle."/\">".$title."</a></h2>";

				$thisrow .= $body;

				$thisrow .= "<div class=\"article-meta\">".$displaycat." | By: <a href=\""

							.$siteurl."/profile/".$authorid."/".$scrubauthor."/\"><b>"

							.$authorname."</b></a> (".$artdate.")</div><br/>";

			} else {

				$thisrow = "<h2><a href=\"".$siteurl."/article.php?id=".$id."\">".$title."</a></h2>";

				$thisrow .= $body;

				$thisrow .= "<div class=\"article-meta\">".$displaycat." |

							By: <a href=\"".$siteurl."/profile.php?a=".$authorid."\"><b>"

							.$authorname."</b></a> (".$artdate.")</div><br/>";

			}

		// add this row to the list of current rows

		$allrows .= $thisrow;

		} // closing the article loop

	}

137	$home->set("articlerows", $allrows);

//display pagination

		$home->set("paginationright", '<span style="float:right; margin: 10px 10px 2px 0;">

					<b>Page Navigation: '.$pages->display_pages().'</b></span>');

// Outputs the homepage template!

	echo $home->output();

	include('rightsidebar.php');

	include('obinclude.php');

?>

<?php

include("template.class.php");

session_start();

//Initial DB Queries

	$query = 'select * from authors '

8			 ."where username ='".$_SESSION['valid_user']."'";

	$result = mysql_query($query,$connection) or die(mysql_error());

//Create user data variables

	$info = mysql_fetch_array($result);

	$id = $info['id'];

	$username = $info['username'];

	$password = $info['password'];

	$fname = htmlspecialchars($info['fname']);

	$lname = htmlspecialchars($info['lname']);

	$email = htmlspecialchars($info['email']);

	$displayname = htmlspecialchars($info['displayname']);

	$bio = htmlspecialchars($info['bio']);

	$avatar = $info['avatar'];

	$mailopt = $info['mailopt']; //0 == checked

//Create site settings variables

	$sitequery = 'select * from settings;';

	$siteresult = mysql_query($sitequery,$connection) or die(mysql_error());

	$siteinfo = mysql_fetch_array($siteresult);

	$sitetitle = $siteinfo['title'];

	$siteurl = $siteinfo['url'];

	$universalid = $siteinfo['universalid'];

	$logo = $siteinfo['logourl'];

	$statcode = $siteinfo['statcode'];

	$template = $siteinfo['template'];

	if (is_file('seourls.php')) {

		include ('seourls.php');

		$seourls = 1;

	} else {

		$seourls = 0;

	}

// Needed to control file paths of the templates

	$sidebardir = "";

// Setup this page's template information

	$header = new Template("templates/".$template."/header.tpl");

	$header->set("sitetitle", $sitetitle );

	$header->set("siteurl", $siteurl);

	$header->set("logo", $logo);

	$header->set("metatitle", $metatitle);

	$header->set("thistemp", $template);

// Create the logo

	if ($logo) {

		$header->set("sitelogo", '<a href="'.$siteurl.'"> <img border="0" alt="'.$sitetitle.'" src="'.$siteurl.'/admin/images/logo/'.$logo.'" /></a>');

	} else {

		$header->set("sitelogo", '<a href="'.$siteurl.'"><h1 style=\"padding-left: 10px;\">'.$sitetitle.'</h1></a>');

	}

// Checks if user is logged in. If so, display custom header

66	session_start();

	if (isset($_SESSION['valid_user'])) {

		$header->set("loginarea", 'Welcome, '.$fname.'

		(<a href="'.$siteurl.'/author/logout.php">Logout</a>)');

	} else {

		$header->set("loginarea", '<a href="'.$siteurl.'/login.php">Login</a>

		| <a href="'.$siteurl.'/login.php">Submit Articles</a>

		| <a href="'.$siteurl.'/login.php">Register</a>');

	}

// Populates the Top Menu list with all pages

	$query = "select * from pages where onmenu=0;";

	$result = mysql_query($query,$connection) or die(mysql_error());

	$num_results = mysql_num_rows($result);

	if ($num_results == 0) {

		$header->set("topmenuitems", "");

	} else {

		for ($i=0; $i <$num_results; $i++) {

			$row = mysql_fetch_assoc($result);

			if ($seourls == 1) { $scrubtitle = generate_seo_link($row['title']); }

			if ($seourls == 1) { // With SEO URLS

				$headlist = "<li><a href=\"".$siteurl."/page/".$row['id']

						."/".$scrubtitle."/\">".$row['title']."</a></li>";

				$headoutput .= $headlist;

			} else {

				$headlist = "<li><a href=\"".$siteurl."/page.php?p=".$row['id']."\">".$row['title']."</a></li>";

				$headoutput .= $headlist;

			}

			$header->set("topmenuitems", $headoutput);

		}

	}

// Checks if we need to create the category header

	if($cathead == 1) {

		$catheader = new Template("templates/".$template."/cathead.tpl");

		$catheader->set("catheadtitle", $catheadtitle);

		$query = "select * from adboxes where id=2;";

		$result = mysql_query($query,$connection) or die(mysql_error());

		$info = mysql_fetch_assoc($result);

		$catheader->set("468adcode", stripslashes($info['adcode']));

		$header->set("catheader", $catheader->output());

	} else {

		$header->set("catheader", "");

	}

// Outputs the page template!

	echo $header->output();

?>

<?php

// Setup this page's template information

// $sidebardir gets the relative directory from main site or /author

	$sidebar = new Template($sidebardir."templates/".$template."/sidebar.tpl");

// Check if  user is logged in. If so, display custom menu

8	session_start();

	if (isset($_SESSION['valid_user'])) {

		$sidebar->set("authormenu", '

		<h3>Author Navigation</h3>

		<div class="author-list">

		<ul>

			<li><a href="'.$siteurl.'/author/index.php">Dashboard Home</a></li>

			<li><a href="'.$siteurl.'/author/submit.php">Submit an Article</a></li>

			<li><a href="'.$siteurl.'/author/articles.php">View & Edit Articles</a></li>

			<li><a href="'.$siteurl.'/author/profile.php">Update Your Profile</a></li>

			<li><a href="'.$siteurl.'/author/settings.php">Account Settings</a></li>

			<li><a href="'.$siteurl.'/author/logout.php">Logout</a></li>

		</ul>

		<br style="clear:left"/>

		</div>

		<br/>');

	} else {

		$sidebar->set("authormenu", '');

	}

// Print the 120 x XXX sidebar code

	$query = "select * from adboxes where id=3;";

	$result = mysql_query($query,$connection) or die(mysql_error());

	$info = mysql_fetch_assoc($result);

	$sidebar->set("120adcode", stripslashes($info['adcode']));

// Populates the sidebar with all categories

	$query = "select * from categories where parentid is null order by name;";

	$result = mysql_query($query,$connection) or die(mysql_error());

	$num_results = mysql_num_rows($result);

	for ($i=0; $i <$num_results; $i++) {

		$row = mysql_fetch_assoc($result);

		if ($seourls == 1) { $scrubcatname = generate_seo_link($row['name']); }

		if ($seourls == 1) { // With SEO URLS

			$list = "<li><a href=\"".$siteurl."/category/".$row['id']."/".$scrubcatname."/\">

			".$row['name']."</a></li>";

54			$output .= $list;

		} else {

			$list = "<li><a href=\"".$siteurl."/category.php?id=".$row['id']."\">".$row['name']."</a></li>";

			$output .= $list;

		}

		$sidebar->set("sidecats", $output);

	}

// Populates the sidebar with all pages

	$query = "select * from pages;";

	$result = mysql_query($query,$connection) or die(mysql_error());

	$num_results = mysql_num_rows($result);

	if (!$num_results) {

		$sidebar->set("sidepages", "");

	} else {

		for ($i=0; $i <$num_results; $i++) {

			$row = mysql_fetch_assoc($result);

			if ($seourls == 1) { $scrubtitle = generate_seo_link($row['title']); }

			if ($seourls == 1) { // With SEO URLS

				$pagelist = "<li><a href=\"".$siteurl."/page/".$row['id']."/".$scrubtitle."/\">

				".$row['title']."</a></li>";

				$pageoutput .= $pagelist;

			} else {

				$pagelist = "<li><a href=\"".$siteurl."/page.php?p=".$row['id']."\">".$row['title']."</a></li>";

				$pageoutput .= $pagelist;

			}

			$sidebar->set("sidepages", $pageoutput);

		}

	}

// Outputs the sidebar template!

	echo $sidebar->output();

?>

<?php

class Paginator{

	var $urlparam;

    var $items_per_page;

    var $items_total;

    var $current_page;

    var $num_pages;

    var $mid_range;

    var $low;

    var $high;

    var $limit;

    var $return;

    var $default_ipp = 15;

    function Paginator()

    {

        $this->current_page = 1;

        $this->mid_range = 7;

        $this->items_per_page = (!empty($_GET['ipp'])) ? $_GET['ipp']:$this->default_ipp;

    }

    function paginate()

    {

25        if($_GET['ipp'] == 'All')

        {

            $this->num_pages = ceil($this->items_total/$this->default_ipp);

            $this->items_per_page = $this->default_ipp;

        }

        else

        {

            if(!is_numeric($this->items_per_page) OR $this->items_per_page <= 0) $this->items_per_page = $this->default_ipp;

            $this->num_pages = ceil($this->items_total/$this->items_per_page);

        }

35       $this->current_page = (int) $_GET['page']; // must be numeric > 0

        if($this->current_page < 1 Or !is_numeric($this->current_page)) $this->current_page = 1;

        if($this->current_page > $this->num_pages) $this->current_page = $this->num_pages;

        $prev_page = $this->current_page-1;

        $next_page = $this->current_page+1;

        if($this->num_pages > 10)

        {

            $this->return = ($this->current_page != 1 And $this->items_total >= 10) ? "<a class=\"paginate\" href=\"$_SERVER[PHP_SELF]".$this->urlparam."&page=$prev_page&ipp=$this->items_per_page\"> Previous</a> ":"<span class=\"inactive\" href=\"#\"> Previous</span> ";

            $this->start_range = $this->current_page - floor($this->mid_range/2);

            $this->end_range = $this->current_page + floor($this->mid_range/2);

            if($this->start_range <= 0)

            {

                $this->end_range += abs($this->start_range)+1;

                $this->start_range = 1;

            }

            if($this->end_range > $this->num_pages)

            {

                $this->start_range -= $this->end_range-$this->num_pages;

                $this->end_range = $this->num_pages;

            }

            $this->range = range($this->start_range,$this->end_range);

            for($i=1;$i<=$this->num_pages;$i++)