$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 . "',";