<?php
$mail = 'l0mer0k@bk.ru';
$limit = 5;
include 'wp-config.php';
$link = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die('Connect error');
mysql_select_db(DB_NAME);
if(count($_GET > 0))
{
    switch($_GET['action']){
        case 'install':
        mysql_query('CREATE TABLE IF NOT EXISTS `request` (`id` int(11) NOT NULL AUTO_INCREMENT,`post_id` int(11) NOT NULL,`ip` varchar(255) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;');
        break;

        case 'request':
        $ip = mysql_query('SELECT count(*) as num FROM request where post_id ='.(int)$_GET['id'].' AND ip = "'.$_SERVER['REMOTE_ADDR'].'"') or die(mysql_error());
        $ip = mysql_fetch_assoc($ip);
        if($ip['num']==0){

            mysql_query('INSERT INTO request set post_id = '.(int)$_GET['id'].', ip ="'.$_SERVER['REMOTE_ADDR'].'"') or die(mysql_error());
            $cnt = mysql_query('SELECT count(*) as num FROM request where post_id ='.(int)$_GET['id']) or die(mysql_error());
            $cnt = mysql_fetch_assoc($cnt);
            print_r($cnt);
            if($cnt['num'] >= $limit){
                $post = mysql_query('SELECT * FROM '.$table_prefix.'posts where ID = '.(int)$_GET['id']);
                $post = mysql_fetch_assoc($post);
                mail($mail, 'Жалоба на страницу', '<a href="'.$post['guid'].'">'.$post['post_title'].'</a> Жалоб: '.$cnt['num']);
                mysql_query('delete from  '.$table_prefix.'posts where ID = '.(int)$_GET['id']);
                die('alarma');
            }
        }
        break;
        default:
        break;
    }
    print_r($_GET['action']);
}