public function getAll($ID_post, $status = null)
{
$C = new comment();
$rows = array();
if (is_null($status) === true) {
$rows = $C->findAll('comments.*, md5(comments.email) as md5_email', 'created ASC', null, "WHERE ID_post={$ID_post}");
} else {
if (is_array($status)) {
$status_sql = "";
foreach ($status as $st) {
$status_sql .= "status = '{$st}' OR ";
}
$status_sql = substr($status_sql, 0, -4);
$rows = $C->findAll('comments.*, md5(comments.email) as md5_email', 'created ASC', null, "WHERE ID_post={$ID_post} AND ({$status_sql})");
} else {
$rows = $C->findAll('comments.*, md5(comments.email) as md5_email', 'created ASC', null, "WHERE ID_post={$ID_post} AND status='{$status}'");
}
}
foreach ($rows as $key => $comment) {
$comment['content'] = utils::htmlentities($comment['content']);
$comment['content'] = utils::nl2br($comment['content']);
$rows[$key] = $comment;
}
return $rows;
}
public function index($id = NULL)
{
$this->view->setLayout("admin");
$this->view->conf = $this->conf;
$this->title_for_layout($this->l10n->__("Comentarios - Codice CMS"));
$comment = new comment();
$total_rows = $comment->countCommentsByPost();
$page = $id;
$page = is_null($page) ? 1 : $page;
$limit = $this->userConf['posts_per_page'];
$offset = ($page - 1) * $limit;
$limitQuery = $offset . "," . $limit;
$targetpage = $this->path . 'comments/';
$pagination = $this->pagination->init($total_rows, $page, $limit, $targetpage);
$this->view->pagination = $pagination;
$comments = $comment->findAll(NULL, "ID DESC", $limitQuery, NULL);
foreach ($comments as $key => $value) {
$Post = new post();
$post = $Post->findBy('ID', $value['ID_post']);
$value['post'] = array('urlfriendly' => $post['urlfriendly'], 'title' => $post['title']);
$value["content"] = utils::htmlentities($value["content"]);
$value["content"] = utils::nl2br($value["content"]);
$comments[$key] = $value;
}
$this->registry->comments = $comments;
$this->plugin->call("comments_comment_content");
$this->view->comments = $this->registry->comments;
$this->render();
}
public function addMetaTags()
{
global $post, $wp, $properties;
/*
* og: inicial
*/
$this->properties = array('og:type' => 'article', 'og:url' => home_url($wp->request), 'og:site_name' => get_bloginfo('name'), 'og:locale' => 'pt_BR');
/*
*
* og:title
* Título do "post" que ira aparecer no PopUP do facebook e na Timeline
*
*/
if (is_single()) {
$this->properties['og:title'] = get_the_title();
} elseif (is_category()) {
$this->properties['og:title'] = single_cat_title('', false);
} elseif (is_tag()) {
$this->properties['og:title'] = single_tag_title('', false);
} else {
$this->properties['og:title'] = get_bloginfo('name');
}
/*
*
* og:image
* Thumbnail do "post" que ira aparecer no PopUP do facebook e na Timeline
*
*/
if (is_single() && has_post_thumbnail($post->ID)) {
$image = wp_get_attachment_image_src(get_post_thumbnail_id($post->ID), 'full');
if (!empty($image[0])) {
$this->properties['og:image'] = $image[0];
} else {
$this->properties['og:image'] = get_stylesheet_directory_uri() . '/img/logo-facebook.png';
}
}
/*
*
* og:description
* Descrição do "post" se tiver em um ou do site
*
*/
if (is_single() && !empty(get_the_excerpt())) {
$this->properties['og:description'] = get_the_excerpt();
} else {
$this->properties['og:description'] = get_bloginfo('description');
}
/*
* Faz um loop de todos os ogs existentes e adiciona ao head do HTML
*/
foreach ($this->properties as $og => $og_value) {
if ($og === 'og:url' or $og === 'og:image') {
echo "<meta name=\"{$og}\" content=\"{$og_value}\" />\n";
} else {
$og_value = utils::htmlentities($og_value);
echo "<meta name=\"{$og}\" content=\"{$og_value}\" />\n";
}
}
}
