cpToolMenu($toolmenu);
$cfg = $inCore->loadComponentConfig('armedlist');
if (!isset($cfg['guest_enabled'])) {
$cfg['guest_enabled'] = 1;
}
if (!isset($cfg['user_link'])) {
$cfg['user_link'] = 1;
}
if (!isset($cfg['publish'])) {
$cfg['publish'] = 0;
}
if (!isset($cfg['is_comment'])) {
$cfg['is_comment'] = 1;
}
$inCore->loadModel('armedlist');
$model = new cms_model_armedlist();
if ($opt == 'saveconfig') {
if (!cmsCore::validateForm()) {
cmsCore::error404();
}
$cfg = array();
$cfg['guest_enabled'] = cmsCore::request('guest_enabled', 'int', 0);
$cfg['user_link'] = cmsCore::request('user_link', 'int', 0);
$cfg['publish'] = cmsCore::request('publish', 'int', 0);
$cfg['is_comment'] = cmsCore::request('is_comment', 'int', 0);
$inCore->saveComponentConfig('armedlist', $cfg);
cmsCore::addSessionMessage($_LANG['AD_CONFIG_SAVE_SUCCESS'], 'success');
cmsCore::redirectBack();
}
if ($opt == 'config') {
cpAddPathway($_LANG['AD_SETTINGS']);
function armedlist()
{
$inCore = cmsCore::getInstance();
$inPage = cmsPage::getInstance();
$inDB = cmsDatabase::getInstance();
$inUser = cmsUser::getInstance();
$model = new cms_model_armedlist();
global $_LANG;
$pagetitle = $inCore->getComponentTitle();
$inPage->addPathway($pagetitle, '/armedlist');
$inPage->setTitle($pagetitle);
$inPage->setDescription($pagetitle);
$inPage->addHeadJsLang(array('ERR_QUESTION'));
$cfg = $inCore->loadComponentConfig('armedlist');
if (!isset($cfg['guest_enabled'])) {
$cfg['guest_enabled'] = 1;
}
if (!isset($cfg['user_link'])) {
$cfg['user_link'] = 1;
}
if (!isset($cfg['publish'])) {
$cfg['publish'] = 0;
}
if (!isset($cfg['is_comment'])) {
$cfg['is_comment'] = 1;
}
$id = $inCore->request('id', 'int', 0);
$do = $inCore->do;
///////////////////////////////////// VIEW CATEGORY ////////////////////////////////////////////////////////////////////////////////
if ($do == 'view') {
if ($id > 0) {
//CURRENT CATEGORY
$sql = "SELECT *\n\t\t\t\tFROM cms_armedlist_cats\n\t\t\t\tWHERE id = '{$id}'\n\t\t\t\tORDER BY title ASC LIMIT 1\n\t\t\t\t";
$result = $inDB->query($sql);
if (!$inDB->num_rows($result)) {
cmsCore::error404();
}
$cat = $inDB->fetch_assoc($result);
//PAGE HEADING
$pagetitle = $cat['title'];
$inPage->setTitle($cat['title']);
$inPage->addPathway($cat['title']);
$inPage->setDescription($cat['title']);
}
//LIST OF SUBCATEGORIES
$sql = "SELECT *\n\t\t\tFROM cms_armedlist_cats\n\t\t\tWHERE parent_id = {$id} AND id > 0 AND published = 1\n\t\t\tORDER BY title ASC\n\t\t\t";
$result = $inDB->query($sql);
if ($inDB->num_rows($result)) {
$subcats = array();
while ($subcat = $inDB->fetch_assoc($result)) {
$subcats[] = $subcat;
}
$is_subcats = true;
} else {
$is_subcats = false;
}
//CURRENT CATEGORY CONTENT
$perpage = 15;
$page = $inCore->request('page', 'int', 1);
$records = 0;
if ($id > 0) {
$sql = "SELECT q.*, u.login, u.nickname\n\t\t\t\tFROM cms_armedlist_quests q\n\t\t\t\tLEFT JOIN cms_users u ON u.id = q.user_id\n\t\t\t\tWHERE q.category_id = {$id} AND q.published = 1\n\t\t\t\tORDER BY q.pubdate DESC\n\t\t\t\tLIMIT " . ($page - 1) * $perpage . ", {$perpage}";
$result_total = $inDB->query("SELECT id FROM cms_armedlist_quests WHERE category_id = {$id} AND published = 1");
$records = $inDB->num_rows($result_total);
} else {
$sql = "SELECT q.*, c.title cat_title, c.id cid, u.login, u.nickname\n\t\t\t\tFROM cms_armedlist_quests q\n\t\t\t\tLEFT JOIN cms_armedlist_cats c ON c.id = q.category_id\n\t\t\t\tLEFT JOIN cms_users u ON u.id = q.user_id\n\t\t\t\tWHERE q.published = 1\n\t\t\t\tORDER BY q.pubdate DESC\n\t\t\t\tLIMIT 15";
}
$result = $inDB->query($sql);
if ($inDB->num_rows($result)) {
$quests = array();
while ($con = $inDB->fetch_assoc($result)) {
$con['pubdate'] = $inCore->dateFormat($con['pubdate'], true, false, false);
$con['quest'] = nl2br($con['quest']);
$quests[] = $con;
}
$is_quests = true;
} else {
$is_quests = false;
}
cmsPage::initTemplate('components', 'com_armedlist_view')->assign('pagetitle', $pagetitle)->assign('id', $id)->assign('subcats', $subcats)->assign('is_subcats', $is_subcats)->assign('quests', $quests)->assign('cfg', $cfg)->assign('is_quests', $is_quests)->assign('is_user', $inUser->id)->assign('pagebar', cmsPage::getPagebar($records, $page, $perpage, '/armedlist/%id%-%page%', array('id' => $id)))->display('com_armedlist_view.tpl');
}
///////////////////////////////////// READ QUESTION ////////////////////////////////////////////////////////////////////////////////
if ($do == 'read') {
$sql = "SELECT con.*,\n\t\t\t\tcat.title cat_title, cat.id cat_id, u.login, u.nickname\n\t\t\t\tFROM cms_armedlist_quests con\n\t\t\t\tLEFT JOIN cms_armedlist_cats cat ON cat.id = con.category_id\n\t\t\t\tLEFT JOIN cms_users u ON u.id = con.user_id\n\t\t\t\tWHERE con.id = {$id} LIMIT 1";
$result = $inDB->query($sql);
if ($inDB->num_rows($result)) {
$inDB->query("UPDATE cms_armedlist_quests SET hits = hits + 1 WHERE id = {$id}");
$quest = $inDB->fetch_assoc($result);
$quest['pubdate'] = $inCore->dateFormat($quest['pubdate'], true, false, false);
$quest['answerdate'] = $inCore->dateFormat($quest['answerdate'], true, false, false);
if (mb_strlen($quest['quest']) > 40) {
$shortquest = mb_substr($quest['quest'], 0, 40) . '...';
} else {
$shortquest = $quest['quest'];
}
$quest['quest'] = nl2br($quest['quest']);
$inPage->setTitle($shortquest);
$inPage->setDescription($shortquest);
$inPage->addPathway($quest['cat_title'], '/armedlist/' . $quest['cat_id']);
$inPage->addPathway($shortquest);
cmsPage::initTemplate('components', 'com_armedlist_read')->assign('quest', $quest)->assign('cfg', $cfg)->assign('labels', array('comments' => $_LANG['ANSWERS'], 'add' => $_LANG['REPLY'], 'rss' => $_LANG['RSS_FEED'], 'not_comments' => $_LANG['NOT_ANSWERS']))->assign('is_admin', $inUser->is_admin)->display('com_armedlist_read.tpl');
} else {
cmsCore::error404();
}
}
///////////////////////////////////// SEND QUEST ////////////////////////////////////////////////////////////////////////////////
if ($do == 'sendquest') {
if (!$inUser->id && !$cfg['guest_enabled']) {
cmsCore::error404();
}
$inPage->setTitle($_LANG['SET_QUESTION']);
$inPage->addPathway($_LANG['SET_QUESTION']);
$inPage->addHeadJS('components/armedlist/js/common.js');
$error = '';
$captha_code = $inCore->request('code', 'str', '');
$message = $inCore->request('message', 'str', '');
$category_id = $inCore->request('category_id', 'int', '');
$published = $inUser->is_admin || $cfg['publish'] ? 1 : 0;
$is_submit = $inCore->inRequest('message');
if ($is_submit && !$inUser->id && !$inCore->checkCaptchaCode($inCore->request('code', 'str'))) {
$error = $_LANG['ERR_CAPTCHA'];
}
if (!$is_submit || $error) {
if (IS_BILLING && $inUser->id) {
cmsBilling::checkBalance('armedlist', 'add_quest');
}
cmsPage::initTemplate('components', 'com_armedlist_add')->assign('catslist', $inCore->getListItems('cms_armedlist_cats', $category_id))->assign('user_id', $inUser->id)->assign('message', htmlspecialchars($inCore->request('message', 'html', '')))->assign('error', $error)->display('com_armedlist_add.tpl');
} else {
//SAVE QUESTION
$sql = "INSERT INTO cms_armedlist_quests (category_id, pubdate, published, quest, answer, user_id, answeruser_id, answerdate, hits)\n\t\t\t\tVALUES ('{$category_id}', NOW(), '{$published}', '{$message}', '', '{$inUser->id}', 0, NOW(), 0)";
$inDB->query($sql);
$quest_id = $inDB->get_last_id('cms_armedlist_quests');
if (IS_BILLING && $inUser->id) {
cmsBilling::process('armedlist', 'add_quest');
}
$inPage->setTitle($_LANG['QUESTION_SEND']);
$inPage->addPathway($_LANG['QUESTION_SEND']);
if (!$published) {
echo '<div class="con_heading">' . $_LANG['QUESTION_SEND'] . '</div>';
echo '<div style="margin-top:10px">' . $_LANG['QUESTION_PREMODER'] . '</div>';
echo '<div style="margin-top:10px"><a href="/armedlist">' . $_LANG['CONTINUE'] . '</a></div>';
} elseif ($published) {
$category = $inDB->get_field('cms_armedlist_cats', "id={$category_id}", 'title');
//регистрируем событие
cmsActions::log('add_quest', array('object' => $_LANG['QUESTION'], 'object_url' => '/armedlist/quest' . $quest_id . '.html', 'object_id' => $quest_id, 'target' => $category, 'target_url' => '/armedlist/' . $category_id, 'target_id' => $category_id, 'description' => strip_tags(mb_strlen(strip_tags($message)) > 100 ? mb_substr($message, 0, 100) : $message)));
$inCore->redirect('/armedlist/quest' . $quest_id . '.html');
} else {
$inCore->redirect('/armedlist/quest' . $quest_id . '.html');
}
}
}
///////////////////////////////////// DELETE QUEST ////////////////////////////////////////////////////////////////////////////////
if ($do == 'delquest') {
$quest_id = $inCore->request('quest_id', 'int', 0);
$user_id = $inUser->id;
$sql = "SELECT con.id, con.quest, con.category_id\n\t\t\t\tFROM cms_armedlist_quests con\n\t\t\t\tWHERE con.id = '{$quest_id}' LIMIT 1";
$result = $inDB->query($sql);
$quest = $inDB->fetch_assoc($result);
if (!$user_id || !$quest_id || !$quest) {
$inCore->redirectBack();
}
if (!$inCore->inRequest('confirm')) {
if (cmsUser::userIsAdmin($user_id)) {
$inPage->setTitle($_LANG['DEL_QUES']);
$inPage->addPathway($_LANG['DEL_QUES']);
$confirm['title'] = $_LANG['DELETE_QUES'];
$confirm['text'] = $_LANG['YOU_REALY_DELETE_QUES'] . ':<br> "<a href="/armedlist/quest' . $quest['id'] . '.html">' . $quest['quest'] . '</a>"<br><br>';
$confirm['action'] = $_SERVER['REQUEST_URI'];
$confirm['yes_button'] = array();
$confirm['yes_button']['type'] = 'submit';
$confirm['yes_button']['name'] = 'confirm';
cmsPage::initTemplate('components', 'action_confirm')->assign('confirm', $confirm)->display('action_confirm.tpl');
} else {
$inCore->redirectBack();
}
}
if ($inCore->inRequest('confirm')) {
if (cmsUser::userIsAdmin($user_id)) {
$model->deleteQuest($quest_id);
}
$inCore->redirect('/armedlist/' . $quest['category_id']);
}
}
}