<?php
LC_send_no_cache_header();
//error_reporting(E_ALL);
//ini_set("display_errors",1);

if (!isset($_SESSION)) { session_start(); }
if (!isset($_SESSION['ABSPATH'])||!isset($_SESSION['is_admin'])) { exit; }

//echo $_SESSION['is_admin'];
//echo $_SESSION['ABSPATH'];

define('ABSPATH',$_SESSION['ABSPATH']);
define('DB_HOST',$_SESSION['DB_HOST']);
define('DB_USER',$_SESSION['DB_USER']);
define('DB_PASSWORD',$_SESSION['DB_PASSWORD']);
define('DB_NAME',$_SESSION['DB_NAME']);

$pagesize = 30;
$table_prefix = $_SESSION['table_prefix'];
$id = '';

require_once(ABSPATH . 'wp-content/plugins/WP-LinkCheck/function/common.php');
require_once(ABSPATH . 'wp-content/plugins/WP-LinkCheck/function/imagecheck.php');

if ($_SESSION['is_admin']) {
	$response = '';
	if (!isset($_GET['action'])) { exit; }
	
    if ($_GET['action'] == 'analyze' && isset($_GET['type']))
    {
        switch($_GET['type'])
        {
            case 'image':
            {
                $response = json_encode(LC_get_image_link());break;
            }
            case 'allimage':
            {
                $response = json_encode(LC_get_image_link(true));break;
            }
        }
    }

    if ($_GET['action'] == 'check' && isset($_GET['type']) && isset($_GET['id']))
    {
    	switch($_GET['type'])
    	{
    	    case 'image':
            {
            	//print_r($_SESSION["datatable"]);
                $response = LC_check_image_link($_GET['id']);break;
            }
    	}
    }
    
    if ($_GET['action'] == 'getrecordcount') {
    	$response = "[{\"count\": \"". LC_get_record_count() ."\"}]";
    }
    
    if ($_GET['action'] == 'printdatatable') {
    	print_r($_SESSION["datatable"]);
    	$response = '';
    }
    
    if ($_GET['action'] == 'gridbindcomplete') {
    	$response = json_encode($_SESSION["datatable"]);
    }
    
    echo $response;
}

function LC_check_image_link($id)
{
	global $pagesize;
	$idx = $id;
	$json = '';
	if($idx==''){$idx=1;}
	$ary = $_SESSION["datatable"];
	$currentpage = ceil($idx / $pagesize);
	$nextpage = ceil(($idx + 1) / $pagesize);
	if (isset($ary[$idx-1])) {
	$result = LC_checkRemoteFile($ary[$idx-1]['value']);
	$json =  "[{\"currentid\": \"" .  $idx .
			 "\",\"nextid\": \"" . ($idx + 1) . 
			 "\",\"currentpage\": \"" . $currentpage . 
			 "\",\"nextpage\": \"" . $nextpage . 
			 "\",\"result\": \"" . $result . "\"}]";
	LC_update_data_table($id, 1, $result);
	}
	return $json;
}

function LC_update_data_table($id, $checked, $result)
{
	$ary = $_SESSION["datatable"];
	$ary[$id-1]['checked'] = $checked;
	$ary[$id-1]['result'] = $result;
	$_SESSION["datatable"] = $ary;
}

function LC_get_image_link($allimage=false) {
        $i=0;
        global $table_prefix;
        $re = new regexexp();
        $ary = array();
        $conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
        mysql_query("set names 'utf8'",$conn);
        if (!$conn) { echo mysql_error(); exit; }
        if (!mysql_select_db(DB_NAME)) { echo mysql_error(); exit; }
        
        $sql = "SELECT ID as id, post_title, post_content, DATE_FORMAT(post_date, '%Y/%m/%d') as post_date FROM " . $table_prefix . "posts WHERE post_status = 'publish' AND post_content REGEXP '" . $re -> image_source ."' ";
        $result = mysql_query($sql);
        
        if (!$result) { echo mysql_error(); exit; }
        if (mysql_num_rows($result) == 0) { echo ''; exit; }

        while ($row = mysql_fetch_assoc($result)) {
            preg_match_all( '/'.$re -> image_source.'/' , $row["post_content"] , $matches);
            
            //print_r($matches);
            //$matches[i][0] - no img tag
            //$matches[i][1] - with img tag
            foreach ($matches[1] as $key => $value)
            {
            /*array_push($ary, array ( $i => array ( "id" => $row["id"] ,
                                                 "post_title" => $row["post_title"] ,
                                                 "post_date" =>  $row["post_date"],
                                                 "checked" => 0,
                                                 "result" => 0,
                                                 "key" => $key ,
                                                 "value" => $value)
                                                )
                                                );*/
            if (substr($value, 0, 7) != 'http://') {continue;}
            if (!$allimage && LC_startsWith($value, $_SESSION["blogurl"])) {continue;}
            $i++;
            array_push($ary, array ( "id" => $i ,
            						 "post_id" => $row["id"],
                                     "post_title" => $row["post_title"],
                                     "post_date" =>  $row["post_date"],
                                     "checked" => 0,
          						     "result" => '',
                                     "key" => $key ,
                                     "value" => $value)
                      );
            }

        }
        mysql_free_result($result);
        mysql_close();
        $_SESSION["datatable"] = $ary;
        return $_SESSION["datatable"];
}

function LC_get_record_count()
{
	$cnt = 0;
	try {
		$cnt = count($_SESSION["datatable"]);
	} catch (Exception $e) {
	}
	return $cnt;
}

function LC_send_no_cache_header () {
    header ( "Expires: Mon, 28 Jul 1981 06:00:00 GMT" );
    header ( "Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT" );
    header ( "Cache-Control: no-store, no-cache, must-revalidate" );
    header ( "Cache-Control: post-check=0, pre-check=0", false );
    header ( "Pragma: no-cache" );
}
?>