query("UPDATE ".$wpdb->prefix."alfie_reactions SET approved='1' WHERE r_id ='".$r_id."'");
wp_redirect("admin.php?page=alfie-review");
}
if(isset($_GET['delete']))
{
$r_id =intval($_GET['delete']);
$wpdb->query("DELETE FROM ".$wpdb->prefix."alfie_reactions WHERE r_id ='".$r_id."'");
wp_redirect("admin.php?page=alfie-review");
}
if(isset($_GET['readrev']))
{
$r_id =intval($_GET['readrev']);
$row = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."alfie_reactions WHERE r_id = '".$r_id."'");
echo "APPROVE REVIEW
Name:".$row->naam."
Email:".$row->email."
Review:
";
echo $row->message;
} else {?>
" width="100" heigth="100">
Manage reviews here.
Some people migth have submitted a review. Please approve the review here and look if it is no crap.
| Email |
Date submitted |
Read review |
Approve |
Delete |
get_results("SELECT * FROM ".$wpdb->prefix."alfie_reactions WHERE approved='0' ORDER BY datum DESC");
foreach ( $parse_result as $elems )
{?>
| email;?> |
datum;?> |
Read |
Y |
Delete |