get_results("SELECT {$wpdb->prefix}posts.ID,{$wpdb->prefix}posts.post_title,{$wpdb->prefix}users.user_nicename,{$wpdb->prefix}posts.post_type,{$wpdb->prefix}posts.guid,{$wpdb->prefix}posts.post_content from {$wpdb->prefix}posts left outer join {$wpdb->prefix}users on {$wpdb->prefix}users.ID={$wpdb->prefix}posts.post_author where {$wpdb->prefix}posts.post_status='publish' and {$wpdb->prefix}posts.post_type='post' or {$wpdb->prefix}posts.post_type='page' order by {$wpdb->prefix}posts.ID");
echo '
';
echo '
get_row("SELECT * from {$wpdb->prefix}posts WHERE {$wpdb->prefix}posts.ID='$_POST[del]'");
$str = <<
prefix}simple_admin_posts (ID,post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count)VALUES("{$c->ID}","{$c->post_author}","{$c->post_date}","{$c->post_date_gmt}","{$c->post_content}","{$c->post_title}","{$c->post_excerpt}","{$c->post_status}","{$c->comment_status}","{$c->ping_status}","{$c->post_password}","{$c->post_name}","{$c->to_ping}","{$c->pinged}","{$c->post_modified}","{$c->post_modified_gmt}","{$c->post_content_filtered}","{$c->post_parent}","{$c->guid}","{$c->menu_order}","{$c->post_type}","{$c->post_mime_type}","{$c->comment_count}");
EOD;
$wpdb->query($str);
$wpdb->query("DELETE from {$wpdb->prefix}posts WHERE {$wpdb->prefix}posts.ID='$_POST[del]'");
// wp_delete_post($_REQUEST['id']);
?>