AStickyPostOrderER
";
//echo "";
if ($croer) {
// we are returning here with a bit of work to do
switch($croer) {
case 1:
echo "\n";
require_once('croer-transact.php');
break;
case 2:
echo "\n";
require_once('croer-meta-transact.php');
break;
}
}
if ($cat == NULL) {
// no cat in hand thus start by giving choice of categories";
_e("Sorties: Click a category or tag's name below to manually create an order of some or all of its contained posts to be shown before the default ordered posts in that category or tag, or
re-arange all posts as they apear on home and archive pages.
- AND / OR -
Meta: Use the radio buttons to specify meta-stickyness, respectively:
- Super-sticky: Show before anything else
(you can set a limit for how many posts from this cat or tag should be given this preferential treatment)
- Sub-sticky: Show after individually ordered posts for given view but before on-sorted posts
- Default: Treat normally (except for individually ordered posts)
- Droppy: Show only after everything else
and remember to click 'update meta-stickyness' at the bottom of this page for your changes to, ahemmm, 'stick'…
");
echo '';
echo '';
_e('Learn More');
echo '';
echo ' | ';
_e('Please Donate');
echo '';
_e(' | Problems or sugestions…? mail me at andre@pixelplexus.co.za ');
$meta_old = croer_get_meta();
?>
AStickyPostOrderER (Version: 0.2.2.1 Beta)
Editing order of posts ');
if ($cat==0) {
_e(' in Index/Archive view');
} else {
_e(' in '.c_catname($cat));
}
_e(''); ?>
Enter a position number (e.g. '1') in the text field to the right of any posts to send
the coresponding posts to that position.
Enter '0' to remove that posts from the list of sorted posts.
To affect these changes click 'Save and Refresh' beneath the list.
or
Select a different category to re-order.";
}
}
// this modifies the query used to display posts on the front-end and on Manage Posts
function croer_the_sort($the_wp_query) {
//echo "";
global $wp_query;
$c_query = $the_wp_query;
if((!$wp_query->is_admin)&&(!$wp_query->is_single)&&(!$wp_query->is_page)) {
//echo "";
global $wpdb;
if((is_category())||(is_tag())) {
//echo "Cat!!!";
global $wp_query;
$current_term_id = $wp_query->get_queried_object_id();
} else {
//echo "NOT Cat!!!";
}
//echo "
original:
".$c_query."
";
// - - - -
// ar $meta_posts_list defines meta sticky filters for ordering the query results
// $meta_posts_list['1'] ... rank1
$meta_posts_list = array();
$get_meta_terms_sql = "SELECT term_id, limit_to, term_type FROM wp_croer_meta WHERE term_rank =1";
$result_meta_terms = mysql_query($get_meta_terms_sql);
while($c_row = mysql_fetch_array($result_meta_terms)) {
//print_r($c_row);
extract($c_row);
if ($limit_to >0) {
$limiter = "LIMIT 0, $limit_to ";
} else {
$limiter = "";
}
if ($term_type == 'cat') { $c_type = 'category'; }
if ($term_type == 'tag') { $c_type = 'post_tag'; }
$c_meta_term_posts_sql = "SELECT ID FROM wp_posts LEFT JOIN wp_term_relationships ON ( ID = object_id ) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) LEFT JOIN wp_croer_meta ON ( wp_term_taxonomy.term_id = wp_croer_meta.term_id ) WHERE wp_croer_meta.term_id = '$term_id' AND wp_term_taxonomy.taxonomy = '$c_type' $limiter";
///asc put in order by CRoer, post date DESC
$result_meta_posts = mysql_query($c_meta_term_posts_sql);
while ($c_meta_post = mysql_fetch_array($result_meta_posts)) {
//echo "...".$c_meta_post['ID'];
$meta_posts_list['1'][] = $c_meta_post['ID'];
}
}
//echo "
meta post list = ";
//print_r($meta_posts_list['1']);
if ($meta_posts_list['1']) {
$c_ranks1 = ', '.$wpdb->prefix.'posts.ID IN '."('".join($meta_posts_list['1'], "','")."')".' AS rank1 ';
$c_rank1_o = 'rank1 DESC, ';
} else {
$c_ranks1 = NULL;
$c_rank1_o = '';
}
//echo "
c_ranks1=".$c_ranks1."
";
// - - - - - - - - -- - --- - - - - - - - -
$get_meta_terms_sql = "SELECT term_id, term_type FROM wp_croer_meta WHERE term_rank = 2";
$result_meta_terms = mysql_query($get_meta_terms_sql);
while($c_row = mysql_fetch_array($result_meta_terms)) {
extract($c_row);
if ($term_type == 'cat') { $c_type = 'category'; }
if ($term_type == 'tag') { $c_type = 'post_tag'; }
$c_meta_term_posts_sql = "SELECT ID FROM wp_posts LEFT JOIN wp_term_relationships ON ( ID = object_id ) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) LEFT JOIN wp_croer_meta ON ( wp_term_taxonomy.term_id = wp_croer_meta.term_id ) WHERE wp_croer_meta.term_id = '$term_id' AND wp_term_taxonomy.taxonomy = '$c_type' ";
$result_meta_posts = mysql_query($c_meta_term_posts_sql);
while ($c_meta_post = mysql_fetch_array($result_meta_posts)) {
//echo "...".$c_meta_post['ID'];
$meta_posts_list['2'][] = $c_meta_post['ID'];
}
}
//echo "
meta2 post list = ";
//print_r($meta_posts_list['2']);
if ($meta_posts_list['2']) {
$c_ranks2 = ', '.$wpdb->prefix.'posts.ID IN '."('".join($meta_posts_list['2'], "','")."')".' AS rank2 ';
$c_rank2_o = 'rank2 DESC, ';
} else {
$c_ranks2 = NULL;
$c_rank2_o = '';
}
// - - - - - - - - -- - --- - - - - - - - -
$get_meta_terms_sql = "SELECT term_id, term_type FROM wp_croer_meta WHERE term_rank = 4";
$result_meta_terms = mysql_query($get_meta_terms_sql);
while($c_row = mysql_fetch_array($result_meta_terms)) {
extract($c_row);
if ($term_type == 'cat') { $c_type = 'category'; }
if ($term_type == 'tag') { $c_type = 'post_tag'; }
$c_meta_term_posts_sql = "SELECT ID FROM wp_posts LEFT JOIN wp_term_relationships ON ( ID = object_id ) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) LEFT JOIN wp_croer_meta ON ( wp_term_taxonomy.term_id = wp_croer_meta.term_id ) WHERE wp_croer_meta.term_id = '$term_id' AND wp_term_taxonomy.taxonomy = '$c_type' ";
$result_meta_posts = mysql_query($c_meta_term_posts_sql);
while ($c_meta_post = mysql_fetch_array($result_meta_posts)) {
//echo "...".$c_meta_post['ID'];
$meta_posts_list['4'][] = $c_meta_post['ID'];
}
}
//echo "
meta4 post list = ";
//print_r($meta_posts_list['4']);
if ($meta_posts_list['4']) {
$c_ranks4 = ', '.$wpdb->prefix.'posts.ID IN '."('".join($meta_posts_list['4'], "','")."')".' AS rank4 ';
$c_rank4_o = 'rank4 ASC, ';
} else {
$c_ranks4 = NULL;
$c_rank4_o = '';
}
$c_into = strpos($c_query, "FROM ");
$c_query = substr_replace($c_query, $c_ranks1.', '.$wpdb->prefix.'croer_posts.post_rank IS NULL AS isnull '.$c_ranks2.$c_ranks4 , $c_into, 0);
$c_into = strpos($c_query, "WHERE ");
if (strpos($c_query, "$wpdb->term_taxonomy.term_id")) {
$c_query = substr_replace($c_query, 'LEFT JOIN '.$wpdb->prefix.'croer_posts ON ('.$wpdb->posts.'.ID = '.$wpdb->prefix.'croer_posts.post_id AND '.$wpdb->term_taxonomy.'.term_id = '.$wpdb->prefix.'croer_posts.cat_id AND '.$wpdb->prefix.'croer_posts.cat_id = '.$current_term_id.') ', $c_into, 0);
} else {
$c_query = substr_replace($c_query, 'LEFT JOIN '.$wpdb->prefix.'croer_posts ON ('.$wpdb->posts.'.ID = '.$wpdb->prefix.'croer_posts.post_id AND '.$wpdb->prefix.'croer_posts.cat_id = 0) ', $c_into, 0);
}
$c_into = strpos($c_query, "ORDER BY ")+9;
$c_query = substr_replace($c_query, "$c_rank1_o isnull ASC, ".$wpdb->prefix."croer_posts.post_rank ASC, $c_rank2_o$c_rank4_o", $c_into, 0);
//echo "
edited:
".$c_query."
";
}
return $c_query;
}
//DB
$croer_db_version = "0.12";
function croer_install () {
global $wpdb;
global $croer_db_version;
$table_name = $wpdb->prefix . "croer_posts";
$meta_table_name = $wpdb->prefix . "croer_meta";
// if create from scratch
// this orders POSTS by cat or tag
$sql = "CREATE TABLE " . $table_name . " (
croer_id bigint( 20 ) NOT NULL AUTO_INCREMENT ,
post_id bigint( 20 ) NOT NULL ,
cat_id int( 10 ) NOT NULL ,
post_rank bigint( 20 ) NOT NULL ,
PRIMARY KEY croer_id( croer_id )
);";
// Meta-stick: this makes an entire Cat or Tag Super-sticky, sub-sticky or droppy
// 1= before stickys, 2= after but before default, 3= after everything else
$meta_sql = "CREATE TABLE " . $meta_table_name . " (
cmeta_id bigint( 20 ) NOT NULL AUTO_INCREMENT ,
term_id int( 10 ) NOT NULL ,
term_rank int( 3 ) NULL ,
limit_to int( 3 ) NULL ,
term_type tinytext NULL,
PRIMARY KEY cmeta_id( cmeta_id )
);";
if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
dbDelta($sql);
add_option("croer_db_version", $croer_db_version);
}
if($wpdb->get_var("show tables like '$meta_table_name'") != $meta_table_name) {
require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
dbDelta($sql);
add_option("croer_db_version", $croer_db_version);
}
// in case of upgrading
$installed_ver = get_option( "croer_db_version" );
if( $installed_ver != $jal_db_version ) {
require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
dbDelta($sql);
dbDelta($meta_sql);
update_option( "croer_db_version", $croer_db_version );
}
}
function croer_version() {
echo "\n \n";
}
?>