function daoCreateArticle($articleArray) { $articleArray['body'] = makeSafeForDAO($articleArray['body']); $articleArray['title'] = makeSafeForDAO($articleArray['title']); if ($articleArray['is_draft'] != "NULL") { $isdraft = 1; } else { $isdraft = "NULL"; } $query = "INSERT INTO articles (" . "author, author_username, body, category, comment_to, " . "date_posted, time_posted, intro, is_draft, is_deleted, " . "picture_url, priority, title, view_count, language) " . "VALUES ('" . $articleArray['author'] . "','" . $articleArray['author_username'] . "','" . $articleArray['body'] . "'," . $articleArray['category'] . "," . $articleArray['comment_to'] . ",'" . $articleArray['date_posted'] . "','" . $articleArray['time_posted'] . "','" . $articleArray['intro'] . "'," . $isdraft . "," . "NULL" . ",'" . $articleArray['picture_url'] . "'," . $articleArray['priority'] . ",'" . $articleArray['title'] . "'," . $articleArray['view_count'] . "," . $articleArray['language'] . ");"; debug($query); $result = insertRow($query); if ($result) { return lastAddedID(); } else { return false; } }
function addArticle($articleArray) { if (isset($articleArray['articleid'])) { if ($articleArray['articleid'] > 0) { $result = daoUpdateArticle($articleArray); } else { $result = daoCreateArticle($articleArray); } } else { $result = daoCreateArticle($articleArray); } if ($result) { global $logtype; global $eventdesc; $feedback[] = "creating_article_successful"; $feedback[] = $result; if (isset($articleArray['articleid']) && $articleArray['articleid'] > 0) { write_log_entry($articleArray['articleid'], $logtype['article'], "editarticleORcomment,"); } else { write_log_entry(lastAddedID(), $logtype['article'], "createarticleORcomment,"); } } else { $feedback[] = "creating_article_failed"; $feedback[] = "-1"; } return array_reverse($feedback); }