} else { $confirmation = 2; } } global $smarty; $id_shop = $context->shop->id; $id_lang = $context->language->id; $id_tdpost = Tools::getValue('tdpost'); if (Tools::getValue('replytocom')) { $replytocom = Tools::getValue('replytocom'); } else { $replytocom = 0; } $numofrepost = Configuration::get('td_numofrepost') ? Configuration::get('td_numofrepost') : 5; $numofcomments = Configuration::get('td_numofcomments') ? Configuration::get('td_numofcomments') : 5; $postcomments = tdpsblogModel::getComments($id_tdpost); $posttotalcomments = count(tdpsblogModel::getTotalCommentsByPost($id_tdpost)); $postcateogyr = tdpsblogModel::getPostCategory(); //print_r($postcateogyr); // print_r($postcomments); $tdblogpspost = $psblogobject->gettdBlogPostByID($id_tdpost, $id_lang, $id_shop); $data = array(); foreach ($tdblogpspost as $tdblogps) { $data[] = $tdblogps; } if (file_exists(_PS_THEME_DIR_ . 'modules/tdpsblog/form.tpl')) { $smarty->assign('comments_form', _PS_THEME_DIR_ . 'modules/tdpsblog/form.tpl'); } else { $smarty->assign('comments_form', _PS_MODULE_DIR_ . 'tdpsblog/views/templates/front/form.tpl'); } if (file_exists(_PS_THEME_DIR_ . 'modules/tdpsblog/comments.tpl')) {
public static function getComments($id_tdpost, $parent = 0) { $context = Context::getContext(); $id_shop = $context->shop->id; $id_lang = $context->language->id; $results = Db::getInstance()->ExecuteS(' SELECT ctd.`id_tdpsblog_comments`, ctd.`id_tdpsblog`, ctd.`comment_author_name`, ctd.`comment_author_email`, ctd.`comment_date`, ctd.`comment_parent`, ctd.`active`, ctd1.`comments_text`, ctd1.`id_lang` FROM `' . _DB_PREFIX_ . 'tdpsblog_comments` ctd INNER JOIN `' . _DB_PREFIX_ . 'tdpsblog_comments_lang` ctd1 ON (ctd.`id_tdpsblog_comments` = ctd1.`id_tdpsblog_comments`) WHERE ctd1.`id_lang` = ' . (int) $context->language->id . ' AND ctd.id_tdpsblog = ' . (int) $id_tdpost . ' AND ctd.active = 1 ' . 'AND ctd.comment_parent =' . (int) $parent . ' ORDER BY ctd.id_tdpsblog_comments ASC'); foreach ($results as $result) { $sub_comments = tdpsblogModel::getComments($id_tdpost, $result['id_tdpsblog_comments']); if ($sub_comments && count($sub_comments) > 0) { $result['sub_comments'] = $sub_comments; } $tdpspostcomments[] = $result; } return isset($tdpspostcomments) ? $tdpspostcomments : false; }