function print_parent_article_link($articleid)
{
$query = "SELECT title FROM articles WHERE articleid = " . $articleid . ";";
$table = getTable($query);
$row = getNextRow($table);
echo '<a href="index.php?articleid=' . $articleid . '&m_c=va">' . stripslashes($row['title']) . '</a>';
}
function getArray($query)
{
$table = getTable($query);
$array = array();
while ($row = getNextRow($table)) {
$array[] = $row;
}
return $array;
}
function getAllUsersNames()
{
$query = "SELECT firstname FROM user ORDER BY firstname ASC";
$table = getTable($query);
while ($row = getNextRow($table)) {
$newtable[] = $row['firstname'];
// Add name to array
}
return $newtable;
}
function getAllLanguageIds()
{
$query = "SELECT id FROM Languages";
$table = getTable($query);
while ($row = getNextRow($table)) {
$newtable[] = $row['id'];
// Add id to array
}
return $newtable;
}
function textSearchService($text, $partialmatch, $author, $checkcomments)
{
if (strlen($text) < 3) {
return NULL;
}
$text = makeSafeForDAO($text);
$selectfrom = "SELECT * FROM articles ";
$where = "WHERE body LIKE '%" . $text . "%' AND is_deleted IS NULL AND is_draft IS NULL ";
$orderby = " ORDER BY date_posted DESC, time_posted DESC;";
$findWordAlone = "| " . $text . "[ !?,.:;'/)]|i";
$findWordAnywhere = "|" . $text . "|i";
if ($partialmatch == 0) {
$pattern = $findWordAlone;
} else {
$pattern = $findWordAnywhere;
}
if ($author == "0") {
} else {
$where .= " AND author_username = '******' ";
}
if ($checkcomments == "0") {
$where .= " AND comment_to IS NULL";
}
$query = $selectfrom . $where . $orderby;
$newtable = array();
$table = getTable($query);
$num_rows = getRowsAffected($table);
if ($table && $num_rows > 0) {
while ($row = getNextRow($table)) {
if (preg_match($pattern, $row['body'])) {
$newtable[] = $row;
// Add row to array
}
}
return $newtable;
} else {
return NULL;
}
}
function nextArticleRowDAO($table)
{
return getNextRow($table);
}
