function blog2DB($task)
{
global $db_conn;
foreach ($task as $parameters) {
// Getting coauthor's ID
if ($parameters["coauthor_name"]) {
$sth = $db_conn->prepare("SELECT id FROM gmj_blogs WHERE lower(name)='" . $parameters["coauthor_name"] . "' AND site='" . $parameters["site"] . "'");
$sth->execute();
$coauthorId = $sth->fetchColumn();
if ($coauthorId == "") {
$coauthorId = getUserId($parameters["coauthor_name"], $parameters["site"]);
if ($coauthorId == "na") {
// Site is unavailable, temporarily stopping processing
updateTaskStatus($parameters["id"], 0);
return exit;
}
// Coauthor not found
if ($coauthorId == 0) {
$db_conn->exec("UPDATE gmj_tasks SET coauthor_name='' WHERE id='" . $parameters["id"] . "'");
}
}
} else {
$coauthorId = 0;
}
updateTaskStatus($parameters["id"], 1);
// Processing blog's pages one by one
for ($i = $parameters["pages_parsed"];; $i++) {
$blogPosts = getPostsTable($parameters["author_id"], $parameters["site"], $i);
if ($blogPosts == "noaccess") {
// Blog's owner unexpectedly blocked access to his/her blog, terminating
// Make notification!
// ...
$db_conn->exec("DELETE gmj_tasks,gmj_emails FROM gmj_tasks INNER JOIN gmj_emails WHERE gmj_tasks.id='" . $parameters["id"] . "' AND gmj_emails.id='" . $parameters["id"] . "'");
return exit;
break;
}
if ($blogPosts == "na") {
// Site is unavailable, temporarily stopping processing
updateTaskStatus($parameters["id"], 0);
return exit;
break;
}
if ($blogPosts) {
// Inserting posts in the DB
insertBlogPosts($blogPosts, $parameters["author_id"], $parameters["site"], $coauthorId);
$db_conn->exec("UPDATE gmj_tasks SET pages_parsed=pages_parsed+1 WHERE id='" . $parameters["id"] . "'");
} else {
updateTaskStatus($parameters["id"], 2);
break;
}
}
}
}
// Forbid to open this file directly from browser
if (preg_match("/addTask.php/i", $_SERVER['PHP_SELF'])) {
header("Location: ../index.php");
}
// Checking access to blog
$blogPosts = getPostsTable($blogId, $_POST['site']);
if ($blogPosts == "noaccess") {
exit($error[0] . $textCommon[1] . " <b>" . $_POST['blogName'] . "</b> " . $textErrors[7] . $error[1]);
}
if ($blogPosts == "na") {
exit($error[0] . naErrorMessage($_POST['site']) . $error[1]);
}
// Inserting a new task into the DB, $taskId will be ID of the newly added task
$taskId = insert2DB('tasks', array($_POST['site'], $blogId, $coAuthorName, $realName, $realSurname, $images));
if ($coAuthorName != "") {
// Trying to get coauthor's ID from the DB
$sth = $db_conn->prepare("SELECT id FROM gmj_blogs WHERE lower(name)='" . $coAuthorName . "' AND site='" . $_POST['site'] . "'");
$sth->execute();
$coauthorId = $sth->fetchColumn();
} else {
$coauthorId = 0;
}
if ($coAuthorName == "" || $coAuthorName != "" && $coauthorId != "") {
// Inserting topics ($blogPosts) from the first (0) page
insertBlogPosts($blogPosts, $blogId, $_POST['site'], $coauthorId);
$db_conn->exec("UPDATE gmj_tasks SET pages_parsed=pages_parsed+1 WHERE id='" . $taskId . "'");
}
// Notifying me about a new task
$message = "Some guy with IP " . $_SERVER['REMOTE_ADDR'] . " has just added a new task for blog " . $_POST['blogName'] . " (email " . $_POST['email'] . ").";
mail('*****@*****.**', 'New task for GMJ book', $message);
