"; ?> prefix."croer_meta "); $meta_old = array(); if($meta_result) { while ($row = mysql_fetch_array($meta_result)) { //echo "fetch array:"; //print_r($row); // init for($i = 1; $i <= 4; $i++) { $meta_old[$row['term_type'].$row['term_id']][$i] = ''; } $meta_old[$row['term_type'].$row['term_id']][$row['term_rank']] = 'checked'; $meta_old[$row['term_type'].$row['term_id']]['limit_to'] = $row['limit_to']; } } //echo "meta old
"; //print_r ($meta_old); return $meta_old; } function croer_get_sorted($croer_cat) { global $wpdb; $query= "SELECT * ". "FROM ".$wpdb->prefix."croer_posts ". "LEFT JOIN $wpdb->posts ". "ON ".$wpdb->prefix."croer_posts.post_id = $wpdb->posts.ID ". "WHERE ".$wpdb->prefix."croer_posts.cat_id = $croer_cat ". "ORDER BY ".$wpdb->prefix."croer_posts.post_rank ASC"; //echo $query;?>
prefix."croer_posts ". "WHERE cat_id = $croer_cat ". "ORDER BY ".$wpdb->prefix."croer_posts.post_rank ASC"; return mysql_query($query); } function present_posts($croer_cat) { global $cat, $croer; //echo "croer_cat=".$croer_cat; $sorts = croer_get_sorted($croer_cat); //var_dump($sorts); $sorts_list = array(); ?>

Limit lists to records (default = 30).

=$soffset)&&($placecount<$limit)){ $placecount++; showrow($placecount+$soffset, $ID, $post_title, $post_name, $guid); $sorts_list[$placecount-1] = $ID; } $stotalcount++; }?> posts JOIN ($wpdb->term_relationships, $wpdb->term_taxonomy) ". "ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ". "WHERE $wpdb->term_taxonomy.term_id IN $c_cat_and_subcats AND post_type = 'post'"; //echo "br>".$query; } else { // not cat $query= "SELECT * ". "FROM $wpdb->posts JOIN ($wpdb->term_relationships, $wpdb->term_taxonomy) ". "ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id AND $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ". "WHERE post_type = 'post'"; } $query.="ORDER BY ID DESC ;"; // echo "
Q:".$query; $result = mysql_query($query); ?> =$usoffset)&&($placecount<$limit)){ $placecount++; showrow($placecount+$usoffset, $ID, $post_title, $post_name, $guid); } $ustotalcount++; } } ?>
Position ID Title Send To
Sorted:
Records to of found.
0) { ?>Previous Previous | Next NextNo Records found.
Un-sorted:
Records to of found.
0) {?> Previous Previous | Next NextNo Records found.

0) { echo " class='alternate'"; } echo ">"; echo "".$placecount.""; echo "".$ID.""; //echo "".$post_title.""; echo "".$post_title.""; echo "".""; echo ""; } // function c_catname($cat) {/* global $wpdb; $cat_sql= "SELECT name ". "FROM $wpdb->term_taxonomy LEFT JOIN $wpdb->terms ". "ON $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id ". "WHERE $wpdb->terms.term_id = $cat "; $cat_result = mysql_query($cat_sql); while ($row= mysql_fetch_array($cat_result)) { extract($row); return $name; }*/ } ?>