function getCommentList($blogid, $search) { $list = array('title' => "{$search}", 'items' => array()); $search = escapeSearchString($search); $context = Model_Context::getInstance(); $pool = DBModel::getInstance(); $pool->reset('Comments'); $pool->setAlias("Comments", "c"); $pool->setAlias("Entries", "e"); $pool->join("Entries", "inner", array(array("c.entry", "eq", "e.id"), array("c.blogid", "eq", "e.blogid"), array("e.draft", "eq", 0))); $pool->setQualifier('c.blogid', 'eq', $blogid); $pool->setQualifier('c.entry', '>', 0); $pool->setQualifier('parent', 'eq', NULL); $pool->setQualifier('isfiltered', 'eq', 0); $pool->setQualifierSet(array("c.comment", "like", $search, true), "OR", array("c.name", "like", $search, true)); if (doesHaveOwnership()) { $pool->setQualifier("c.secret", "eq", 0); $pool = getPrivateCategoryExclusionQualifier($pool, $blogid); } $pool->setOrder("c.written", "asc"); if ($entry == 0) { $pool->setOrder('written', 'desc'); } else { if ($order == 'DESC') { $pool->setOrder('id', 'desc'); } else { $pool->setOrder('id', 'asc'); } } if ($result = $pool->getAll()) { $comments = coverComments($result); } if ($result = $pool->getAll("c.id, c.entry, c.parent, c.name, c.comment, c.written, e.slogan")) { foreach ($result as $comment) { array_push($list['items'], $comment); } } return $list; }
function getComments($entry, $order = 'ASC') { global $database; $comments = array(); $aux = $entry == 0 ? 'ORDER BY written DESC' : 'ORDER BY id ' . ($order == 'DESC' ? 'DESC' : 'ASC'); $sql = "SELECT *\n\t\tFROM {$database['prefix']}Comments\n\t\tWHERE blogid = " . getBlogId() . "\n\t\t\tAND entry = {$entry}\n\t\t\tAND parent IS NULL\n\t\t\tAND isfiltered = 0 {$aux}"; if ($result = POD::queryAll($sql)) { $comments = coverComments($result); } return $comments; }
function getComments($entry, $order = 'ASC') { $comments = array(); $context = Model_Context::getInstance(); $pool = DBModel::getInstance(); $pool->reset('Comments'); $pool->setQualifier('blogid', 'eq', $context->getProperty('blog.id')); $pool->setQualifier('entry', 'eq', $entry); $pool->setQualifier('parent', 'eq', NULL); $pool->setQualifier('isfiltered', 'eq', 0); if ($entry == 0) { $pool->setOrder('written', 'desc'); } else { if ($order == 'DESC') { $pool->setOrder('id', 'desc'); } else { $pool->setOrder('id', 'asc'); } } if ($result = $pool->getAll()) { $comments = coverComments($result); } return $comments; }