public static function getLatestComments($id_lang = null) { $result = array(); if ($id_lang == null) { $id_lang = (int) Context::getContext()->language->id; } if (Configuration::get('smartshowhomecomments') != '' && Configuration::get('smartshowhomecomments') != null) { $limit = Configuration::get('smartshowhomecomments'); } else { $limit = 5; } $sql = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('SELECT * FROM ' . _DB_PREFIX_ . 'smart_blog_comment bc INNER JOIN ' . _DB_PREFIX_ . 'smart_blog_post_shop bps ON bc.id_post=bps.id_smart_blog_post and bps.id_shop = ' . (int) Context::getContext()->shop->id . ' WHERE bc.active= 1 ORDER BY bc.id_smart_blog_comment DESC limit 0, ' . $limit); $i = 0; foreach ($sql as $post) { $result[$i]['id_smart_blog_comment'] = $post['id_smart_blog_comment']; $result[$i]['id_parent'] = $post['id_parent']; $result[$i]['id_customer'] = $post['id_customer']; $result[$i]['id_post'] = $post['id_post']; $result[$i]['name'] = $post['name']; $result[$i]['email'] = $post['email']; $result[$i]['website'] = $post['website']; $result[$i]['active'] = $post['active']; $result[$i]['created'] = $post['created']; $result[$i]['content'] = $post['content']; $SmartBlogPost = new SmartBlogPost(); $result[$i]['slug'] = $SmartBlogPost->GetPostSlugById($post['id_post']); $i++; } return $result; }