";
?>
prefix."croer_meta ");
$meta_old = array();
while ($row= mysql_fetch_array($meta_result)) {
// 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;
return mysql_query($query);
}
function croer_get_just_sorted($croer_cat) {
global $wpdb;
$query= "SELECT post_id, post_rank ".
"FROM ".$wpdb->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) {
//echo "croer_cat=".$croer_cat;
$sorts = croer_get_sorted($croer_cat);
$placecount = 1;
$sorts_list = array();
?>
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;
}*/
}
?>