<?php

/*

Plugin Name: Category Page 

Plugin URI: http://pixline.net/wordpress-plugins/category-page-wordpress-plugin/en/

Description: Use pages as category archive header, or list some posts from a category into a post/page. 

Author: Pixline

Version: 2.5

Author URI: http://pixline.net/

Copyright (C) 2008 Paolo Tresso / Pixline (http://pixline.net/)

This program 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.

*/

if(preg_match('#' . basename(__FILE__) . '#', $_SERVER['PHP_SELF'])) { die('You are not allowed to call this page directly.'); }

define("PAGE2CAT_VERSION","2.5");

define("PLUGIN_PATH",get_bloginfo('url')."/wp-content/plugins/page2cat/");

define('PIXLINE_FOOTER','<p><hr style="margin-top:50px;height:1px;background:#CCC;border:0px;clear:both;" />

<strong>

<a href="http://pixline.net/wordpress-plugins/category-page-wordpress-plugin/en/">Category Page</a></strong> plugin 

<small> | 

<a href="http://talks.pixline.net/forum.php?id=3">Support Forum</a> | 

GPL2&copy; &ge; 2007 <a href="http://pixline.net/about/en/">Paolo Tresso / Pixline</a> | 

If you like this plugin, support its development with a <a href="https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=paolo%40pixline%2enet&item_name=Support%20to%20opensource%20projects%20at%20Pixline&no_shipping=1&cn=Something%20to%20say%3f&tax=0&currency_code=EUR&lc=IT&bn=PP%2dDonationsBF&charset=UTF%2d8">small donation</a>.</p>');

$wpdb->page2cat	= $table_prefix . 'page2cat';

######################################################

# check version. #

######################################################

$p2c_version = get_option('pixline_page2cat_version');

	register_activation_hook(__FILE__, 'page2cat_install');

// DB installation. usually happen just one time.

function page2cat_install(){

global $wpdb, $p2c_version;

if ($version < 6):

	$query = "

	CREATE TABLE  `".$wpdb->prefix."page2cat` (

	 `rel_ID` BIGINT NOT NULL AUTO_INCREMENT ,

	 `page_ID` BIGINT NOT NULL ,

	 `cat_ID` BIGINT NOT NULL ,

	PRIMARY KEY (  `rel_ID` ) ,

	INDEX (  `page_ID` ,  `cat_ID` )

	);

	";

	if(is_file(ABSPATH . 'wp-admin/includes/upgrade.php')){ 

		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

	}elseif(is_file(ABSPATH . 'wp-admin/upgrade-functions.php')){

		require_once(ABSPATH . 'wp-admin/upgrade-functions.php');

	}

	if($wpdb->get_var("SHOW TABLES LIKE '".$wpdb->prefix."page2cat'") != $wpdb->prefix."page2cat") {

	dbDelta($query);

	delete_option('pixline_page2cat_version');

	add_option('pixline_page2cat_version', 6);

	}

update_option('p2c_use_empty','false');

update_option('p2c_show_used_pages','false');

update_option('p2c_catlist_limit',5);

update_option('p2c_catlist_title','');

endif;

delete_option('p2c_use_img');		// deprecated, so we're going to delete it anyway.

if( !get_option('p2c_use_empty')) 		update_option('p2c_use_empty','false');

if(!get_option('p2c_show_used_pages')) 	update_option('p2c_show_used_pages','false');

if(!get_option('p2c_catlist_limit')) 	update_option('p2c_catlist_limit',5);

if(!get_option('p2c_catlist_title')) 	update_option('p2c_catlist_title','');

}

######################################

# setup management and option panels #

######################################

// adds a panel under "manage » category pages"

// shows actual connections, and allow creations of new ones.

function page2cat_manage_page(){

global $wpdb, $wp_db_version;

	#print_r($_POST); #die();

	// multiple delete

	if( isset($_POST['deleteit']) && !empty($_POST['p2c_reldel'])):

		foreach($_POST['p2c_reldel'] as $key=>$id):

			$query = "DELETE FROM {$wpdb->page2cat} WHERE rel_ID = '".$id."' LIMIT 1;";

			$daje = $wpdb->get_results($query);

		endforeach;

	echo '<div id="message" class="updated fade">

			<p><strong>Some connections deleted.</strong></p></div>';

	endif;

	// multiple link

	if( isset($_POST['action']) && $_POST['p2c_linkto'] == true && $_POST['multipageid'] != ""):

#	print_r($_POST);

		$pageid = $_POST['multipageid'][0];

		foreach($_POST['p2c_reladd'] as $key=>$id):		

		if(trim($id)!=""):

			$query = "INSERT INTO {$wpdb->page2cat} (rel_ID, page_ID, cat_ID) VALUES ('', '".$pageid."', '".$id."');";

			$daje = $wpdb->get_results($query);

		endif;

		endforeach;

		echo '<div id="message" class="updated fade">

			<p><strong>Connections created.</strong></p></div>';

	elseif( isset($_POST['action']) && $_POST['p2c_update'] == true):

#	print_r($_POST); die();

		$pageid = $_POST['pageid'];

		foreach($pageid as $cat_id=>$page_id):

			if(trim($page_id) != ""):

			$sql = "INSERT INTO {$wpdb->page2cat} (rel_ID, page_ID, cat_ID) VALUES ('', '".$page_id."', '".$cat_id."');";

			$result = $wpdb->get_results($sql);

			endif;

		endforeach;

		echo('<div id="message" class="updated fade">

		<p><strong>New Category Page created succesfully.</strong></p></div>');

	endif;

	// single delete, confirm request

	if( isset($_REQUEST['p2cdel']) && !isset($_REQUEST['p2c_confirm']) ):

		$relid = $wpdb->escape($_REQUEST['p2cdel']);

		echo "<div class='wrap'><h2>Delete this Category &rsaquo; Page relation?</h2>";

		$opt = $wpdb->get_results("SELECT * FROM {$wpdb->page2cat} WHERE rel_ID = '".$relid."' LIMIT 1;");

		$catid = $opt[0]->cat_ID;

		$pageid = $opt[0]->page_ID;

		$catname = get_cat_name($catid);

		$page = get_page($pageid); 

		$title = $page->post_title;

		echo "<form name='p2c_confirm' method='post'>";

		echo "<p>You are going to delete the relationship between 

		Category <em>".$catname."</em> and Page <em>".$title."</em>. Confirm?</p>";

		echo '<p>

		<input type="hidden" name="p2cdel" value="'.$relid.'" />

		<input type="hidden" name="p2c_confirm" value="true" />

		<input type="reset" name="revert" value="Cancel" />

		<input type="submit" name="confirm" value="DELETE &raquo;" />

		</p></form>';

		echo "</div>";

	endif;

	// confirmed, so delete this connection

	if( isset($_REQUEST['p2cdel']) && $_REQUEST['p2c_confirm'] == 'true'):

	$relid = $wpdb->escape($_REQUEST['p2cdel']);

	$myopts = $wpdb->get_results("DELETE FROM {$wpdb->page2cat} WHERE rel_ID = '".$relid."' LIMIT 1;");

	echo('<div id="message" class="updated fade"><p><strong>You have succesfully deleted a connection.</strong></p></div>');

	echo "<div class='wrap'><a href='edit.php?page=category-pages'>Back to Category Pages manage page</a></div>";

	endif;

	/*

		real pages

	*/

	$count_used = $wpdb->get_var("SELECT count(*) FROM {$wpdb->page2cat};");

	if($wp_db_version >= 6124):	// this is WordPress >= 2.3

	$count_full = $wpdb->get_var("SELECT count(*) 

		FROM {$wpdb->terms} AS t LEFT JOIN {$wpdb->term_taxonomy} AS tt 

		ON t.term_id = tt.term_id WHERE tt.taxonomy='category';");

	$count_noempty = $wpdb->get_var("SELECT count(*) 

		FROM {$wpdb->terms} AS t LEFT JOIN {$wpdb->term_taxonomy} AS tt 

		ON t.term_id = tt.term_id WHERE tt.taxonomy='category' AND tt.count != '0';");

	else: // WP < 2.3

	$count_full = $wpdb->get_var("SELECT count(*) FROM {$wpdb->categories};");

	$count_noempty = $wpdb->get_var("SELECT count(*) FROM {$wpdb->categories}; WHERE category_count != '0';");

	endif;

	$count_free = $count_full - $count_used;

	if(get_option('p2c_use_empty') == "false"): $count_usable = $count_noempty - $count_used; else : $count_usable = $count_free; endif;

	// this is the already connected page

	$myopts = $wpdb->get_results("SELECT * FROM {$wpdb->page2cat} ORDER BY page_ID ASC;");

	$usedcats = array();

	$usedpages = array();

		if($_REQUEST['view'] == 'new'): 

			$css1 = ''; 	$css2 = ' class="current"'; 

			$pagetitle = "<small>New connection</small>"; 

		else: 

			$css1 = ' class="current"'; $css2 = ''; 

			$pagetitle = "<small>Manage connections</small>"; 

		endif;

	if( !isset($_REQUEST['p2cdel'])):

		echo "<div class='wrap'><h2>Category Pages</h2>";

		echo '<ul class="subsubsub">

		<li><a href="edit.php?page=category-pages"'.$css1.'>Manage connections ('.$count_used.')</a> |</li>

		<li><a href="edit.php?page=category-pages&view=new"'.$css2.'>Free categories ('.$count_usable.'/'.$count_free.')</a></li>

		</ul>';

if($_REQUEST['view'] != 'new'):

		if(count($myopts) != 0):

#		echo "<div><p>These categories and these pages are already connected each other. You can view the category page in your website, clicking on the Category name. You can also edit or delete each connection.</p>";

		echo "<div class='tablenav'>";

		echo "<div class='tablenav-pages'>&nbsp;</div>";

		echo '<div style="float: left">

			<form id="p2c_del" name="p2c_del" method="post"/>

			<input type="hidden" name="page" value="category-pages" />

			<input type="hidden" name="view" value="'.$_REQUEST['view'].'" />

			<input type="hidden" name="action" value="p2c_del" />

			<input type="submit" value="Delete Checked" name="deleteit" class="button-secondary delete" />

			</div>';

		echo "<br style='clear:both;' />";

		echo "</div>";

		echo "<br style='clear:both;' />";

		echo '

			';

		echo "<table class='widefat'>";

			echo "<thead>";

			echo "<tr>

				<th>";

			if($wp_db_version >= 7098): echo "<input type='checkbox' onclick='checkAll(document.getElementById(\"p2c_del\"));' />" ;

				else: echo " "; endif; 

			echo "</th>

			<th>Host <strong>Category</strong></th>

			<th>Header <strong>Page</strong></th>

			<th>&nbsp;</th>

			</tr>";

			echo "</thead><tbody>";

		foreach($myopts as $opt):

			$catid = $opt->cat_ID;

			$pageid = $opt->page_ID;

			$catname = get_cat_name($catid);

			$usedcats[] = $catid;

			$usedpages[] = $pageid;

			$page = get_page($pageid); 

			$title = $page->post_title;

		echo "<tr>

			<td><input type='checkbox' value='".$opt->rel_ID."' name='p2c_reldel[]' class='p2cbox' /></td>

			<td><strong><a href='../?cat=".$catid."' title='View this Category Page in your website.'>".$catname."</a></strong>

				<!-- (cat #".$catid.") --></td>

			<td><strong><a href='page.php?action=edit&post=".$pageid."' title='Edit this page.'>".$title." 

				<!-- (page #".$pageid.") --></td>

			<td><a href='?page=category-pages&amp;p2cdel=".$opt->rel_ID."' class='delete' title='Delete this connection permanently.'>Delete</a></td>

			</tr>";

		endforeach;

		echo "</tbody>";

		echo "</table>";

		echo "<div class='tablenav'>";

		echo "<div class='tablenav-pages'>&nbsp;</div>";

		echo '<div style="float: left">

			<form name="p2c_del" method="post"/>

			<input type="hidden" name="page" value="category-pages" />

			<input type="hidden" name="view" value="'.$_REQUEST['view'].'" />

			<input type="hidden" name="action" value="p2c_del" />

			<input type="submit" value="Delete Checked" name="deleteit" class="button-secondary delete" />

			</form>

			</div>';

		echo "<br style='clear:both;' />";

		echo "</div>";

		else:

		echo "<p>Sorry, no Category &raquo; Page connection available (yet). Maybe you want to <a href='edit.php?page=category-pages&view=new'>create some new connections</a>?</p>";

		endif;

else:

// this is the 'new' page

		$usedcats = $wpdb->get_col("SELECT cat_ID FROM {$wpdb->page2cat};");

#		print_r($usedcats);

		$opt3 = get_option('p2c_use_empty');

		if($opt3 == "true"): $empty = false; $excats = ""; elseif($opt3 == "false"): $empty = true; $excats = implode(',',$usedcats); endif;

		$catdef = array('type' => 'post', 'child_of' => 0, 'orderby' => 'name', 'order' => 'ASC',

		'hide_empty' => $empty, 'include_last_update_time' => false, 'hierarchical' => true, 

		'exclude' => $excats, 'include' => '', 'number' => '', 'pad_counts' => true);

		$others = get_categories($catdef);

		$used = count($usedcats);

		$count = count($others);

		if( $count == 0):

		echo "<p>Sorry, you don't have any usable category (or there are some, but empty; <a href='options-general.php?page=category-page-options'>check your settings</a>).</p>";

		else:

#		echo "<h3>New connections</h3>";

#		echo "<div><p>These categories aren't connected with any page. Here you can setup a connection with an existent page, or create a brand new one.</p>";

		echo "<form id='page2cat_manage' name='page2cat_manage' method='post'>";

		$pages_already_used = implode(',',$usedpages);

		if(get_option('p2c_show_used_pages')=='true') $exclude = $pages_already_used; else $exclude ="";

		// wp_dropdown_pages settings (for both boxes in this page)

		$pre_ddprefs = array('depth' => 0, 'child_of' => 0, 'selected' => 0, 

			'echo' => 0,'name' => 'multipageid[]', 'exclude' => $exclude, 

			'show_option_none' => '(none)');

/*		

		echo "<div class='tablenav'>";

		echo "<div class='tablenav-pages'>

			<input type='submit' name='p2c_update' value='Update Category Pages' class='button'/>

			<br style='clear:both;' />

			</div>";

		echo '<div style="float:left;">

			<input type="hidden" name="page" value="category-pages" />

			<input type="hidden" name="view" value="'.$_REQUEST['view'].'" />

			<input type="hidden" name="action" value="p2c_multilink" />

			Link checked to: 

			'.wp_dropdown_pages($pre_ddprefs).'

			<input type="submit" value="Link them!" name="p2c_linkto" class="button-secondary" />

			</div>';

		echo "<br style='clear:both;'/>&nbsp;<br style='clear:both;' />";

		echo "</div>";

*/

			echo "<table class='widefat'>";

			echo "<thead>";

			echo "<tr>

			<th>";

			if($wp_db_version >= 7098): echo "<input type='checkbox' onclick='checkAll(document.getElementById(\"page2cat_manage\"));' />"; 

				else: echo " "; endif; 

			echo "</th>";

			echo "<th>Host Category</th>

			<th>Choose Page</th>

			<th>Create New Page</th>

			</tr>";

			echo "</thead><tbody>";

			foreach($others as $otro):

			switch($wp_db_version):

			// "7098"=>"2.5",	"6124"=>"2.3.3", "5183"=>"2.2.1", "4773"=>"2.1.3"

				case ( $wp_db_version < 5183 ):	// WP 2.1.3 and smaller

				$versioned_catid = $otro->cat_ID;

				$versioned_catname = $otro->cat_name;

				$versioned_slug = $otro->category_nicename;

				$versioned_count = $otro->category_count + $otro->posts_private;

				break;

				case ( $wp_db_version >= 5183 ):	// WP 2.2.1 and greater

				default:

				$versioned_catid = $otro->term_id;

				$versioned_catname = $otro->name;

				$versioned_slug = $otro->category_nicename;

				$versioned_count = $otro->count;

				break;

			endswitch;

			// wp_dropdown_pages settings

			$ddprefs = array('depth' => 0, 'child_of' => 0, 'selected' => 0, 

				'echo' => 0,'name' => 'pageid['.$versioned_catid.']', 

				'exclude' => $exclude, 'show_option_none' => '(none)');

			$output = "<tr>

			<td><input type='checkbox' value='".$versioned_catid."' name='p2c_reladd[]' /></td>

			<td>".$versioned_catname." <!-- (".$versioned_count.") --></td>

			<td>".wp_dropdown_pages($ddprefs)."</td>";

			$output .= "<td><a href='page-new.php?p2c=".$versioned_catid."'>Create New</a></td>

			</tr>";

			$stringhe[$versioned_catname] = $output;

			endforeach;

			asort($stringhe);

			reset($stringhe);

			foreach($stringhe as $stringa):

				echo $stringa;

			endforeach;

			echo "</tbody>";

			echo "</table>";

			echo "<div class='tablenav'>";

			echo "<div style='float:right;'>

				<input type='submit' name='p2c_update' value='Update Category Pages' class='button'/>

				</div>";

			echo '<div style="float:left;">

				<input type="hidden" name="page" value="category-pages" />

				<input type="hidden" name="view" value="'.$_REQUEST['view'].'" />

				<input type="hidden" name="action" value="p2c_multilink" />

				Link checked to: 

				'.wp_dropdown_pages($pre_ddprefs).'

				<input type="submit" value="Link them!" name="p2c_linkto" class="button-secondary" />

				</div>';

			echo "<br style='clear:both;'/>";

			echo "</div>";

endif;

		echo "</form>";

		endif;

		echo PIXLINE_FOOTER;

		echo "</div>";

	endif;

}

// adds styles in admin head (WP 2.5+)