$publishdate = date("Y-m-d H:i:s", strtotime($item['date']));
$sql = "INSERT INTO `wp_blog_feed_comment` (`title`,`description`,`publishdate`,`wp_blog_url_id`,`inserttime`) \n VALUES ('" . remove_spacial_1(remove_spacial(clean_insert($item['title']))) . "','" . remove_spacial_1(remove_spacial(clean_insert($item['content']))) . "','" . $publishdate . "','" . $id . "','" . $date . "');";
mysql_query($sql);
}
}
} else {
if (!empty($feed)) {
foreach ($feed as $item) {
$publishdate = date("Y-m-d H:i:s", strtotime($item['date']));
$sql = "INSERT INTO `wp_blog_feed` (`title`,`description`,`publishdate`,`wp_blog_url_id`,`inserttime`) \n VALUES ('" . remove_spacial_1(remove_spacial(clean_insert($item['title']))) . "','" . remove_spacial_1(remove_spacial(clean_insert($item['description']))) . "','" . $publishdate . "','" . $id . "','" . $date . "');";
mysql_query($sql);
}
$feedComment = $Rss->getFeed('http://' . $host . '/comments/feed/', Rss::TXT);
foreach ($feedComment as $item) {
$publishdate = date("Y-m-d H:i:s", strtotime($item['date']));
$sql = "INSERT INTO `wp_blog_feed_comment` (`title`,`description`,`publishdate`,`wp_blog_url_id`,`inserttime`) \n VALUES ('" . remove_spacial_1(remove_spacial(clean_insert($item['title']))) . "','" . remove_spacial_1(remove_spacial(clean_insert($item['content']))) . "','" . $publishdate . "','" . $id . "','" . $date . "');";
mysql_query($sql);
}
}
}
} else {
//error entry code here
$sql25 = "INSERT INTO `tbl_error_log` (reason,message,type,keywordid) \n values ('','Url Not valid','wordpress','" . $id . "')";
mysql_query($sql25) or die(mysql_error());
}
}
}
}
}
echo "<BR><B>WORDPRESS CRON ENDED @</B> : " . date('Y-m-d H:i:s A') . "<br><br>";
}
$sql .= " VALUES ";
foreach ($subreddit_data as $k => $v) {
$data = $v->data;
$domain = clean_insert($data->domain);
$subreddit = clean_insert($data->subreddit);
$selftext = clean_insert($data->selftext);
$likes = $data->likes;
$author = clean_insert($data->author);
$score = $data->score;
$subreddit_id = clean_insert($data->subreddit_id);
$permalink = clean_insert($data->permalink);
$name = clean_insert($data->name);
$created = date('Y-m-d H:i:s', $data->created);
$url = clean_insert($data->url);
$title = clean_insert($data->title);
$num_comments = clean_insert($data->num_comments);
$create_time = date('Y-m-d H:i:s');
$sql .= "('" . $project_id . "',";
$sql .= "'" . $domain . "',";
$sql .= "'" . $subreddit . "',";
$sql .= "'" . $selftext . "',";
$sql .= "'" . $likes . "',";
$sql .= "'" . $author . "',";
$sql .= "'" . $score . "',";
$sql .= "'" . $subreddit_id . "',";
$sql .= "'" . $permalink . "',";
$sql .= "'" . $name . "',";
$sql .= "'" . $created . "',";
$sql .= "'" . $url . "',";
$sql .= "'" . $title . "',";
$sql .= "'" . $num_comments . "',";
