@@ -86,7 +86,7 @@ discard block |
||
86 | 86 | // Находим все страницы данной инструкции |
87 | 87 | $criteria->add(new \Criteria('instrid', $instrid_page, '=')); |
88 | 88 | // Если мы редактируем, то убрать текущую страницу из списка выбора родительской |
89 | - if (!$this->isNew()) { |
|
89 | + if ( ! $this->isNew()) { |
|
90 | 90 | $criteria->add(new \Criteria('pageid', $this->getVar('pageid'), '<>')); |
91 | 91 | } |
92 | 92 | $criteria->setSort('weight'); |
@@ -151,7 +151,7 @@ discard block |
||
151 | 151 | $form->addElement($option_tray); |
152 | 152 | |
153 | 153 | // Если мы редактируем страницу |
154 | - if (!$this->isNew()) { |
|
154 | + if ( ! $this->isNew()) { |
|
155 | 155 | $form->addElement(new \XoopsFormHidden('pageid', $this->getVar('pageid'))); |
156 | 156 | } else { |
157 | 157 | $form->addElement(new \XoopsFormHidden('pageid', 0)); |
@@ -12,172 +12,172 @@ |
||
12 | 12 | */ |
13 | 13 | class Page extends \XoopsObject |
14 | 14 | { |
15 | - // constructor |
|
16 | - public function __construct() |
|
17 | - { |
|
18 | - // $this->XoopsObject(); |
|
19 | - $this->initVar('pageid', XOBJ_DTYPE_INT, null, false, 11); |
|
20 | - $this->initVar('pid', XOBJ_DTYPE_INT, 0, false, 11); |
|
21 | - $this->initVar('instrid', XOBJ_DTYPE_INT, 0, false, 11); |
|
22 | - $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
23 | - $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
24 | - $this->initVar('status', XOBJ_DTYPE_INT, 1, false, 1); |
|
25 | - $this->initVar('type', XOBJ_DTYPE_INT, 1, false, 1); |
|
26 | - $this->initVar('hometext', XOBJ_DTYPE_TXTAREA, null, false); |
|
27 | - $this->initVar('footnote', XOBJ_DTYPE_TXTAREA, '', false); |
|
28 | - $this->initVar('weight', XOBJ_DTYPE_INT, 0, false, 11); |
|
29 | - $this->initVar('keywords', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
30 | - $this->initVar('description', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
31 | - $this->initVar('comments', XOBJ_DTYPE_INT, 0, false, 11); |
|
32 | - $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
33 | - $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
34 | - $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false, 1); |
|
35 | - $this->initVar('dosmiley', XOBJ_DTYPE_INT, 0, false, 1); |
|
36 | - $this->initVar('doxcode', XOBJ_DTYPE_INT, 1, false, 1); |
|
37 | - $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false, 1); |
|
38 | - } |
|
39 | - |
|
40 | - /** |
|
41 | - * @return mixed |
|
42 | - */ |
|
43 | - public function getNewInstertId() |
|
44 | - { |
|
45 | - $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
46 | - return $newEnreg; |
|
47 | - } |
|
48 | - |
|
49 | - // Получаем форму |
|
50 | - |
|
51 | - /** |
|
52 | - * @param bool|null|string $action |
|
53 | - * @param int $instrid |
|
54 | - * @return \XoopsThemeForm |
|
55 | - */ |
|
56 | - public function getForm($action = false, $instrid = 0) |
|
57 | - { |
|
58 | - // Если нет $action |
|
59 | - if (false === $action) { |
|
60 | - $action = xoops_getenv('REQUEST_URI'); |
|
61 | - } |
|
62 | - |
|
63 | - // Подключаем формы |
|
64 | - include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
65 | - // Подключаем типы страниц |
|
66 | - $pagetypes = include $GLOBALS['xoops']->path('modules/instruction/include/pagetypes.inc.php'); |
|
67 | - |
|
68 | - // Название формы |
|
69 | - $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDPAGE) : sprintf(_AM_INSTRUCTION_FORMEDITPAGE); |
|
70 | - |
|
71 | - // Форма |
|
72 | - $form = new \XoopsThemeForm($title, 'instr_form_page', $action, 'post', true); |
|
73 | - // Название |
|
74 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
75 | - |
|
76 | - // Родительская страница |
|
77 | - // $pageHandler = xoops_getModuleHandler('page', 'instruction'); |
|
78 | - $criteria = new \CriteriaCompo(); |
|
79 | - // ID инструкции в которой данная страница |
|
80 | - $instrid_page = $this->isNew() ? $instrid : $this->getVar('instrid'); |
|
81 | - // Находим все страницы данной инструкции |
|
82 | - $criteria->add(new \Criteria('instrid', $instrid_page, '=')); |
|
83 | - // Если мы редактируем, то убрать текущую страницу из списка выбора родительской |
|
84 | - if (!$this->isNew()) { |
|
85 | - $criteria->add(new \Criteria('pageid', $this->getVar('pageid'), '<>')); |
|
86 | - } |
|
87 | - $criteria->setSort('weight'); |
|
88 | - $criteria->setOrder('ASC'); |
|
89 | - $inspage_arr = $pageHandler->getall($criteria); |
|
90 | - unset($criteria); |
|
91 | - // Подключаем трей |
|
92 | - include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
93 | - $mytree = new \XoopsObjectTree($inspage_arr, 'pageid', 'pid'); |
|
94 | - |
|
95 | - // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
96 | - $helper = Helper::getInstance(); |
|
97 | - $module = $helper->getModule(); |
|
98 | - |
|
99 | - if (Utility::checkVerXoops($module, '2.5.9')) { |
|
100 | - $mytree_select = $mytree->makeSelectElement('pid', 'title', '--', $this->getVar('pid'), true, 0, '', _AM_INSTRUCTION_PPAGEC); |
|
101 | - $form->addElement($mytree_select); |
|
102 | - } else { |
|
103 | - $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
104 | - } |
|
105 | - |
|
106 | - // Вес |
|
107 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_WEIGHTC, 'weight', 5, 5, $this->getVar('weight')), true); |
|
108 | - // Основной текст |
|
109 | - $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_HOMETEXTC, 'hometext', $this->getVar('hometext', 'e')), true); |
|
110 | - // Сноска |
|
111 | - $form_footnote = new \XoopsFormTextArea(_AM_INSTRUCTION_FOOTNOTEC, 'footnote', $this->getVar('footnote', 'e')); |
|
112 | - $form_footnote->setDescription(_AM_INSTRUCTION_FOOTNOTE_DSC); |
|
113 | - $form->addElement($form_footnote, false); |
|
114 | - unset($form_footnote); |
|
115 | - // Статус |
|
116 | - $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
117 | - // Тип страницы |
|
118 | - $form_type = new \XoopsFormSelect(_AM_INSTR_PAGETYPEC, 'type', $this->getVar('type')); |
|
119 | - $form_type->setDescription(_AM_INSTR_PAGETYPEC_DESC); |
|
120 | - $form_type->addOptionArray($pagetypes); |
|
121 | - $form->addElement($form_type, false); |
|
122 | - // Мета-теги ключевых слов |
|
123 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'keywords', 50, 255, $this->getVar('keywords')), false); |
|
124 | - // Мета-теги описания |
|
125 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'description', 50, 255, $this->getVar('description')), false); |
|
126 | - |
|
127 | - // Настройки |
|
128 | - $option_tray = new \XoopsFormElementTray(_OPTIONS, '<br>'); |
|
129 | - // HTML |
|
130 | - $html_checkbox = new \XoopsFormCheckBox('', 'dohtml', $this->getVar('dohtml')); |
|
131 | - $html_checkbox->addOption(1, _AM_INSTR_DOHTML); |
|
132 | - $option_tray->addElement($html_checkbox); |
|
133 | - // Смайлы |
|
134 | - $smiley_checkbox = new \XoopsFormCheckBox('', 'dosmiley', $this->getVar('dosmiley')); |
|
135 | - $smiley_checkbox->addOption(1, _AM_INSTR_DOSMILEY); |
|
136 | - $option_tray->addElement($smiley_checkbox); |
|
137 | - // ББ коды |
|
138 | - $xcode_checkbox = new \XoopsFormCheckBox('', 'doxcode', $this->getVar('doxcode')); |
|
139 | - $xcode_checkbox->addOption(1, _AM_INSTR_DOXCODE); |
|
140 | - $option_tray->addElement($xcode_checkbox); |
|
141 | - // |
|
142 | - $br_checkbox = new \XoopsFormCheckBox('', 'dobr', $this->getVar('dobr')); |
|
143 | - $br_checkbox->addOption(1, _AM_INSTR_DOAUTOWRAP); |
|
144 | - $option_tray->addElement($br_checkbox); |
|
145 | - // |
|
146 | - $form->addElement($option_tray); |
|
147 | - |
|
148 | - // Если мы редактируем страницу |
|
149 | - if (!$this->isNew()) { |
|
150 | - $form->addElement(new \XoopsFormHidden('pageid', $this->getVar('pageid'))); |
|
151 | - } else { |
|
152 | - $form->addElement(new \XoopsFormHidden('pageid', 0)); |
|
153 | - } |
|
154 | - // ID инструкции |
|
155 | - if ($instrid) { |
|
156 | - $form->addElement(new \XoopsFormHidden('instrid', $instrid)); |
|
157 | - } else { |
|
158 | - $form->addElement(new \XoopsFormHidden('instrid', 0)); |
|
159 | - } |
|
160 | - // |
|
161 | - $form->addElement(new \XoopsFormHidden('op', 'savepage')); |
|
162 | - // Кнопка |
|
163 | - $button_tray = new \XoopsFormElementTray('', ''); |
|
164 | - $button_tray->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
165 | - $save_btn = new \XoopsFormButton('', 'cancel', _AM_INSTR_SAVEFORM); |
|
166 | - $save_btn->setExtra('onclick="instrSavePage();"'); |
|
167 | - $button_tray->addElement($save_btn); |
|
168 | - $form->addElement($button_tray); |
|
169 | - |
|
170 | - return $form; |
|
171 | - } |
|
172 | - |
|
173 | - // |
|
174 | - |
|
175 | - /** |
|
176 | - * @return mixed |
|
177 | - */ |
|
178 | - public function getInstrid() |
|
179 | - { |
|
180 | - // Возвращаем ID инструкции |
|
181 | - return $this->getVar('instrid'); |
|
182 | - } |
|
15 | + // constructor |
|
16 | + public function __construct() |
|
17 | + { |
|
18 | + // $this->XoopsObject(); |
|
19 | + $this->initVar('pageid', XOBJ_DTYPE_INT, null, false, 11); |
|
20 | + $this->initVar('pid', XOBJ_DTYPE_INT, 0, false, 11); |
|
21 | + $this->initVar('instrid', XOBJ_DTYPE_INT, 0, false, 11); |
|
22 | + $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
23 | + $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
24 | + $this->initVar('status', XOBJ_DTYPE_INT, 1, false, 1); |
|
25 | + $this->initVar('type', XOBJ_DTYPE_INT, 1, false, 1); |
|
26 | + $this->initVar('hometext', XOBJ_DTYPE_TXTAREA, null, false); |
|
27 | + $this->initVar('footnote', XOBJ_DTYPE_TXTAREA, '', false); |
|
28 | + $this->initVar('weight', XOBJ_DTYPE_INT, 0, false, 11); |
|
29 | + $this->initVar('keywords', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
30 | + $this->initVar('description', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
31 | + $this->initVar('comments', XOBJ_DTYPE_INT, 0, false, 11); |
|
32 | + $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
33 | + $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
34 | + $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false, 1); |
|
35 | + $this->initVar('dosmiley', XOBJ_DTYPE_INT, 0, false, 1); |
|
36 | + $this->initVar('doxcode', XOBJ_DTYPE_INT, 1, false, 1); |
|
37 | + $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false, 1); |
|
38 | + } |
|
39 | + |
|
40 | + /** |
|
41 | + * @return mixed |
|
42 | + */ |
|
43 | + public function getNewInstertId() |
|
44 | + { |
|
45 | + $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
46 | + return $newEnreg; |
|
47 | + } |
|
48 | + |
|
49 | + // Получаем форму |
|
50 | + |
|
51 | + /** |
|
52 | + * @param bool|null|string $action |
|
53 | + * @param int $instrid |
|
54 | + * @return \XoopsThemeForm |
|
55 | + */ |
|
56 | + public function getForm($action = false, $instrid = 0) |
|
57 | + { |
|
58 | + // Если нет $action |
|
59 | + if (false === $action) { |
|
60 | + $action = xoops_getenv('REQUEST_URI'); |
|
61 | + } |
|
62 | + |
|
63 | + // Подключаем формы |
|
64 | + include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
65 | + // Подключаем типы страниц |
|
66 | + $pagetypes = include $GLOBALS['xoops']->path('modules/instruction/include/pagetypes.inc.php'); |
|
67 | + |
|
68 | + // Название формы |
|
69 | + $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDPAGE) : sprintf(_AM_INSTRUCTION_FORMEDITPAGE); |
|
70 | + |
|
71 | + // Форма |
|
72 | + $form = new \XoopsThemeForm($title, 'instr_form_page', $action, 'post', true); |
|
73 | + // Название |
|
74 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
75 | + |
|
76 | + // Родительская страница |
|
77 | + // $pageHandler = xoops_getModuleHandler('page', 'instruction'); |
|
78 | + $criteria = new \CriteriaCompo(); |
|
79 | + // ID инструкции в которой данная страница |
|
80 | + $instrid_page = $this->isNew() ? $instrid : $this->getVar('instrid'); |
|
81 | + // Находим все страницы данной инструкции |
|
82 | + $criteria->add(new \Criteria('instrid', $instrid_page, '=')); |
|
83 | + // Если мы редактируем, то убрать текущую страницу из списка выбора родительской |
|
84 | + if (!$this->isNew()) { |
|
85 | + $criteria->add(new \Criteria('pageid', $this->getVar('pageid'), '<>')); |
|
86 | + } |
|
87 | + $criteria->setSort('weight'); |
|
88 | + $criteria->setOrder('ASC'); |
|
89 | + $inspage_arr = $pageHandler->getall($criteria); |
|
90 | + unset($criteria); |
|
91 | + // Подключаем трей |
|
92 | + include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
93 | + $mytree = new \XoopsObjectTree($inspage_arr, 'pageid', 'pid'); |
|
94 | + |
|
95 | + // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
96 | + $helper = Helper::getInstance(); |
|
97 | + $module = $helper->getModule(); |
|
98 | + |
|
99 | + if (Utility::checkVerXoops($module, '2.5.9')) { |
|
100 | + $mytree_select = $mytree->makeSelectElement('pid', 'title', '--', $this->getVar('pid'), true, 0, '', _AM_INSTRUCTION_PPAGEC); |
|
101 | + $form->addElement($mytree_select); |
|
102 | + } else { |
|
103 | + $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
104 | + } |
|
105 | + |
|
106 | + // Вес |
|
107 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_WEIGHTC, 'weight', 5, 5, $this->getVar('weight')), true); |
|
108 | + // Основной текст |
|
109 | + $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_HOMETEXTC, 'hometext', $this->getVar('hometext', 'e')), true); |
|
110 | + // Сноска |
|
111 | + $form_footnote = new \XoopsFormTextArea(_AM_INSTRUCTION_FOOTNOTEC, 'footnote', $this->getVar('footnote', 'e')); |
|
112 | + $form_footnote->setDescription(_AM_INSTRUCTION_FOOTNOTE_DSC); |
|
113 | + $form->addElement($form_footnote, false); |
|
114 | + unset($form_footnote); |
|
115 | + // Статус |
|
116 | + $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
117 | + // Тип страницы |
|
118 | + $form_type = new \XoopsFormSelect(_AM_INSTR_PAGETYPEC, 'type', $this->getVar('type')); |
|
119 | + $form_type->setDescription(_AM_INSTR_PAGETYPEC_DESC); |
|
120 | + $form_type->addOptionArray($pagetypes); |
|
121 | + $form->addElement($form_type, false); |
|
122 | + // Мета-теги ключевых слов |
|
123 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'keywords', 50, 255, $this->getVar('keywords')), false); |
|
124 | + // Мета-теги описания |
|
125 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'description', 50, 255, $this->getVar('description')), false); |
|
126 | + |
|
127 | + // Настройки |
|
128 | + $option_tray = new \XoopsFormElementTray(_OPTIONS, '<br>'); |
|
129 | + // HTML |
|
130 | + $html_checkbox = new \XoopsFormCheckBox('', 'dohtml', $this->getVar('dohtml')); |
|
131 | + $html_checkbox->addOption(1, _AM_INSTR_DOHTML); |
|
132 | + $option_tray->addElement($html_checkbox); |
|
133 | + // Смайлы |
|
134 | + $smiley_checkbox = new \XoopsFormCheckBox('', 'dosmiley', $this->getVar('dosmiley')); |
|
135 | + $smiley_checkbox->addOption(1, _AM_INSTR_DOSMILEY); |
|
136 | + $option_tray->addElement($smiley_checkbox); |
|
137 | + // ББ коды |
|
138 | + $xcode_checkbox = new \XoopsFormCheckBox('', 'doxcode', $this->getVar('doxcode')); |
|
139 | + $xcode_checkbox->addOption(1, _AM_INSTR_DOXCODE); |
|
140 | + $option_tray->addElement($xcode_checkbox); |
|
141 | + // |
|
142 | + $br_checkbox = new \XoopsFormCheckBox('', 'dobr', $this->getVar('dobr')); |
|
143 | + $br_checkbox->addOption(1, _AM_INSTR_DOAUTOWRAP); |
|
144 | + $option_tray->addElement($br_checkbox); |
|
145 | + // |
|
146 | + $form->addElement($option_tray); |
|
147 | + |
|
148 | + // Если мы редактируем страницу |
|
149 | + if (!$this->isNew()) { |
|
150 | + $form->addElement(new \XoopsFormHidden('pageid', $this->getVar('pageid'))); |
|
151 | + } else { |
|
152 | + $form->addElement(new \XoopsFormHidden('pageid', 0)); |
|
153 | + } |
|
154 | + // ID инструкции |
|
155 | + if ($instrid) { |
|
156 | + $form->addElement(new \XoopsFormHidden('instrid', $instrid)); |
|
157 | + } else { |
|
158 | + $form->addElement(new \XoopsFormHidden('instrid', 0)); |
|
159 | + } |
|
160 | + // |
|
161 | + $form->addElement(new \XoopsFormHidden('op', 'savepage')); |
|
162 | + // Кнопка |
|
163 | + $button_tray = new \XoopsFormElementTray('', ''); |
|
164 | + $button_tray->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
165 | + $save_btn = new \XoopsFormButton('', 'cancel', _AM_INSTR_SAVEFORM); |
|
166 | + $save_btn->setExtra('onclick="instrSavePage();"'); |
|
167 | + $button_tray->addElement($save_btn); |
|
168 | + $form->addElement($button_tray); |
|
169 | + |
|
170 | + return $form; |
|
171 | + } |
|
172 | + |
|
173 | + // |
|
174 | + |
|
175 | + /** |
|
176 | + * @return mixed |
|
177 | + */ |
|
178 | + public function getInstrid() |
|
179 | + { |
|
180 | + // Возвращаем ID инструкции |
|
181 | + return $this->getVar('instrid'); |
|
182 | + } |
|
183 | 183 | } |
@@ -16,28 +16,28 @@ |
||
16 | 16 | */ |
17 | 17 | class CategoryHandler extends \XoopsPersistableObjectHandler |
18 | 18 | { |
19 | - /** |
|
20 | - * @param null|mixed $db |
|
21 | - */ |
|
22 | - public function __construct(\XoopsDatabase $db = null) |
|
23 | - { |
|
24 | - parent::__construct($db, 'instruction_cat', Category::class, 'cid', 'title'); |
|
25 | - } |
|
19 | + /** |
|
20 | + * @param null|mixed $db |
|
21 | + */ |
|
22 | + public function __construct(\XoopsDatabase $db = null) |
|
23 | + { |
|
24 | + parent::__construct($db, 'instruction_cat', Category::class, 'cid', 'title'); |
|
25 | + } |
|
26 | 26 | |
27 | - // Обновление даты обновления категории |
|
27 | + // Обновление даты обновления категории |
|
28 | 28 | |
29 | - /** |
|
30 | - * @param int $cid |
|
31 | - * @param null|int $time |
|
32 | - * @return mixed |
|
33 | - */ |
|
34 | - public function updateDateupdated($cid = 0, $time = null) |
|
35 | - { |
|
36 | - // Если не передали время |
|
37 | - $time = null === $time ? time() : (int)$time; |
|
38 | - // |
|
39 | - $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int)$cid); |
|
40 | - // |
|
41 | - return $this->db->query($sql); |
|
42 | - } |
|
29 | + /** |
|
30 | + * @param int $cid |
|
31 | + * @param null|int $time |
|
32 | + * @return mixed |
|
33 | + */ |
|
34 | + public function updateDateupdated($cid = 0, $time = null) |
|
35 | + { |
|
36 | + // Если не передали время |
|
37 | + $time = null === $time ? time() : (int)$time; |
|
38 | + // |
|
39 | + $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int)$cid); |
|
40 | + // |
|
41 | + return $this->db->query($sql); |
|
42 | + } |
|
43 | 43 | } |
@@ -34,9 +34,9 @@ |
||
34 | 34 | public function updateDateupdated($cid = 0, $time = null) |
35 | 35 | { |
36 | 36 | // Если не передали время |
37 | - $time = null === $time ? time() : (int)$time; |
|
37 | + $time = null === $time ? time() : (int) $time; |
|
38 | 38 | // |
39 | - $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int)$cid); |
|
39 | + $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int) $cid); |
|
40 | 40 | // |
41 | 41 | return $this->db->query($sql); |
42 | 42 | } |
@@ -118,7 +118,7 @@ |
||
118 | 118 | $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'metadescription', 50, 255, $this->getVar('metadescription')), false); |
119 | 119 | |
120 | 120 | // Если мы редактируем категорию |
121 | - if (!$this->isNew()) { |
|
121 | + if ( ! $this->isNew()) { |
|
122 | 122 | $form->addElement(new \XoopsFormHidden('instrid', $this->getVar('instrid'))); |
123 | 123 | } |
124 | 124 | // |
@@ -12,115 +12,115 @@ |
||
12 | 12 | */ |
13 | 13 | class Instruction extends \XoopsObject |
14 | 14 | { |
15 | - // constructor |
|
16 | - public function __construct() |
|
17 | - { |
|
18 | - // $this->XoopsObject(); |
|
19 | - $this->initVar('instrid', XOBJ_DTYPE_INT, null, false, 11); |
|
20 | - $this->initVar('cid', XOBJ_DTYPE_INT, 0, false, 5); |
|
21 | - $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
22 | - $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false); |
|
23 | - $this->initVar('status', XOBJ_DTYPE_INT, 0, false, 1); |
|
24 | - $this->initVar('pages', XOBJ_DTYPE_INT, 0, false, 11); |
|
25 | - $this->initVar('description', XOBJ_DTYPE_TXTAREA, null, false); |
|
26 | - $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
27 | - $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
28 | - $this->initVar('metakeywords', XOBJ_DTYPE_TXTBOX, '', false); |
|
29 | - $this->initVar('metadescription', XOBJ_DTYPE_TXTBOX, '', false); |
|
30 | - |
|
31 | - // Нет в таблице |
|
32 | - $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false); |
|
33 | - $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false); |
|
34 | - } |
|
35 | - |
|
36 | - /** |
|
37 | - * @return mixed |
|
38 | - */ |
|
39 | - public function getNewInstertId() |
|
40 | - { |
|
41 | - $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
42 | - return $newEnreg; |
|
43 | - } |
|
44 | - |
|
45 | - // Получаем форму |
|
46 | - |
|
47 | - /** |
|
48 | - * @param bool|null|string $action |
|
49 | - * @return \XoopsThemeForm |
|
50 | - */ |
|
51 | - public function getForm($action = false) |
|
52 | - { |
|
53 | - global $xoopsDB, $xoopsModule, $xoopsModuleConfig; |
|
54 | - // Если нет $action |
|
55 | - if (false === $action) { |
|
56 | - $action = xoops_getenv('REQUEST_URI'); |
|
57 | - } |
|
58 | - // Подключаем формы |
|
59 | - include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
60 | - |
|
61 | - // Название формы |
|
62 | - $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDINSTR) : sprintf(_AM_INSTRUCTION_FORMEDITINSTR); |
|
63 | - |
|
64 | - // Форма |
|
65 | - $form = new \XoopsThemeForm($title, 'forminstr', $action, 'post', true); |
|
66 | - //$form->setExtra('enctype="multipart/form-data"'); |
|
67 | - // Название инструкции |
|
68 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
69 | - // Категория |
|
70 | - $categoryHandler = new CategoryHandler; |
|
71 | - $criteria = new \CriteriaCompo(); |
|
72 | - $criteria->setSort('weight ASC, title'); |
|
73 | - $criteria->setOrder('ASC'); |
|
74 | - $instructioncat_arr = $categoryHandler->getall($criteria); |
|
75 | - unset($criteria); |
|
76 | - // Подключаем трей |
|
77 | - include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
78 | - $mytree = new \XoopsObjectTree($instructioncat_arr, 'cid', 'pid'); |
|
79 | - |
|
80 | - // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
81 | - $helper = Helper::getInstance(); |
|
82 | - $module = $helper->getModule(); |
|
83 | - |
|
84 | - if (Utility::checkVerXoops($module, '2.5.9')) { |
|
85 | - $mytree_select = $mytree->makeSelectElement('cid', 'title', '--', $this->getVar('cid'), true, 0, '', _AM_INSTRUCTION_CATC); |
|
86 | - $form->addElement($mytree_select); |
|
87 | - } else { |
|
88 | - $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
89 | - } |
|
90 | - |
|
91 | - // Описание |
|
92 | - $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_DESCRIPTIONC, 'description', $this->getVar('description', 'e')), true); |
|
93 | - // Статус |
|
94 | - $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
95 | - |
|
96 | - // Теги |
|
97 | - $dir_tag_ok = false; |
|
98 | - if (is_dir('../../tag') || is_dir('../tag')) { |
|
99 | - $dir_tag_ok = true; |
|
100 | - } |
|
101 | - // Если влючена поддержка тегов и есть модуль tag |
|
102 | - if (xoops_getModuleOption('usetag', 'instruction') && $dir_tag_ok) { |
|
103 | - $itemIdForTag = $this->isNew() ? 0 : $this->getVar('instrid'); |
|
104 | - // Подключаем форму тегов |
|
105 | - include_once $GLOBALS['xoops']->path('modules/tag/include/formtag.php'); |
|
106 | - // Добавляем элемент в форму |
|
107 | - $form->addElement(new \XoopsFormTag('tag', 60, 255, $itemIdForTag, 0)); |
|
108 | - } |
|
109 | - |
|
110 | - // Мета-теги ключевых слов |
|
111 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'metakeywords', 50, 255, $this->getVar('metakeywords')), false); |
|
112 | - // Мета-теги описания |
|
113 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'metadescription', 50, 255, $this->getVar('metadescription')), false); |
|
114 | - |
|
115 | - // Если мы редактируем категорию |
|
116 | - if (!$this->isNew()) { |
|
117 | - $form->addElement(new \XoopsFormHidden('instrid', $this->getVar('instrid'))); |
|
118 | - } |
|
119 | - // |
|
120 | - $form->addElement(new \XoopsFormHidden('op', 'saveinstr')); |
|
121 | - // Кнопка |
|
122 | - $form->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
123 | - return $form; |
|
124 | - } |
|
15 | + // constructor |
|
16 | + public function __construct() |
|
17 | + { |
|
18 | + // $this->XoopsObject(); |
|
19 | + $this->initVar('instrid', XOBJ_DTYPE_INT, null, false, 11); |
|
20 | + $this->initVar('cid', XOBJ_DTYPE_INT, 0, false, 5); |
|
21 | + $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
22 | + $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false); |
|
23 | + $this->initVar('status', XOBJ_DTYPE_INT, 0, false, 1); |
|
24 | + $this->initVar('pages', XOBJ_DTYPE_INT, 0, false, 11); |
|
25 | + $this->initVar('description', XOBJ_DTYPE_TXTAREA, null, false); |
|
26 | + $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
27 | + $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
28 | + $this->initVar('metakeywords', XOBJ_DTYPE_TXTBOX, '', false); |
|
29 | + $this->initVar('metadescription', XOBJ_DTYPE_TXTBOX, '', false); |
|
30 | + |
|
31 | + // Нет в таблице |
|
32 | + $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false); |
|
33 | + $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false); |
|
34 | + } |
|
35 | + |
|
36 | + /** |
|
37 | + * @return mixed |
|
38 | + */ |
|
39 | + public function getNewInstertId() |
|
40 | + { |
|
41 | + $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
42 | + return $newEnreg; |
|
43 | + } |
|
44 | + |
|
45 | + // Получаем форму |
|
46 | + |
|
47 | + /** |
|
48 | + * @param bool|null|string $action |
|
49 | + * @return \XoopsThemeForm |
|
50 | + */ |
|
51 | + public function getForm($action = false) |
|
52 | + { |
|
53 | + global $xoopsDB, $xoopsModule, $xoopsModuleConfig; |
|
54 | + // Если нет $action |
|
55 | + if (false === $action) { |
|
56 | + $action = xoops_getenv('REQUEST_URI'); |
|
57 | + } |
|
58 | + // Подключаем формы |
|
59 | + include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
60 | + |
|
61 | + // Название формы |
|
62 | + $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDINSTR) : sprintf(_AM_INSTRUCTION_FORMEDITINSTR); |
|
63 | + |
|
64 | + // Форма |
|
65 | + $form = new \XoopsThemeForm($title, 'forminstr', $action, 'post', true); |
|
66 | + //$form->setExtra('enctype="multipart/form-data"'); |
|
67 | + // Название инструкции |
|
68 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
69 | + // Категория |
|
70 | + $categoryHandler = new CategoryHandler; |
|
71 | + $criteria = new \CriteriaCompo(); |
|
72 | + $criteria->setSort('weight ASC, title'); |
|
73 | + $criteria->setOrder('ASC'); |
|
74 | + $instructioncat_arr = $categoryHandler->getall($criteria); |
|
75 | + unset($criteria); |
|
76 | + // Подключаем трей |
|
77 | + include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
78 | + $mytree = new \XoopsObjectTree($instructioncat_arr, 'cid', 'pid'); |
|
79 | + |
|
80 | + // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
81 | + $helper = Helper::getInstance(); |
|
82 | + $module = $helper->getModule(); |
|
83 | + |
|
84 | + if (Utility::checkVerXoops($module, '2.5.9')) { |
|
85 | + $mytree_select = $mytree->makeSelectElement('cid', 'title', '--', $this->getVar('cid'), true, 0, '', _AM_INSTRUCTION_CATC); |
|
86 | + $form->addElement($mytree_select); |
|
87 | + } else { |
|
88 | + $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
89 | + } |
|
90 | + |
|
91 | + // Описание |
|
92 | + $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_DESCRIPTIONC, 'description', $this->getVar('description', 'e')), true); |
|
93 | + // Статус |
|
94 | + $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
95 | + |
|
96 | + // Теги |
|
97 | + $dir_tag_ok = false; |
|
98 | + if (is_dir('../../tag') || is_dir('../tag')) { |
|
99 | + $dir_tag_ok = true; |
|
100 | + } |
|
101 | + // Если влючена поддержка тегов и есть модуль tag |
|
102 | + if (xoops_getModuleOption('usetag', 'instruction') && $dir_tag_ok) { |
|
103 | + $itemIdForTag = $this->isNew() ? 0 : $this->getVar('instrid'); |
|
104 | + // Подключаем форму тегов |
|
105 | + include_once $GLOBALS['xoops']->path('modules/tag/include/formtag.php'); |
|
106 | + // Добавляем элемент в форму |
|
107 | + $form->addElement(new \XoopsFormTag('tag', 60, 255, $itemIdForTag, 0)); |
|
108 | + } |
|
109 | + |
|
110 | + // Мета-теги ключевых слов |
|
111 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'metakeywords', 50, 255, $this->getVar('metakeywords')), false); |
|
112 | + // Мета-теги описания |
|
113 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'metadescription', 50, 255, $this->getVar('metadescription')), false); |
|
114 | + |
|
115 | + // Если мы редактируем категорию |
|
116 | + if (!$this->isNew()) { |
|
117 | + $form->addElement(new \XoopsFormHidden('instrid', $this->getVar('instrid'))); |
|
118 | + } |
|
119 | + // |
|
120 | + $form->addElement(new \XoopsFormHidden('op', 'saveinstr')); |
|
121 | + // Кнопка |
|
122 | + $form->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
123 | + return $form; |
|
124 | + } |
|
125 | 125 | } |
126 | 126 |
@@ -70,8 +70,8 @@ |
||
70 | 70 | $debug = false; |
71 | 71 | |
72 | 72 | if (!isset($GLOBALS['xoopsTpl']) || !($GLOBALS['xoopsTpl'] instanceof XoopsTpl)) { |
73 | - require_once $GLOBALS['xoops']->path('class/template.php'); |
|
74 | - $xoopsTpl = new \XoopsTpl(); |
|
73 | + require_once $GLOBALS['xoops']->path('class/template.php'); |
|
74 | + $xoopsTpl = new \XoopsTpl(); |
|
75 | 75 | } |
76 | 76 | |
77 | 77 | $moduleDirName = basename(dirname(__DIR__)); |
@@ -69,7 +69,7 @@ |
||
69 | 69 | |
70 | 70 | $debug = false; |
71 | 71 | |
72 | -if (!isset($GLOBALS['xoopsTpl']) || !($GLOBALS['xoopsTpl'] instanceof XoopsTpl)) { |
|
72 | +if ( ! isset($GLOBALS['xoopsTpl']) || ! ($GLOBALS['xoopsTpl'] instanceof XoopsTpl)) { |
|
73 | 73 | require_once $GLOBALS['xoops']->path('class/template.php'); |
74 | 74 | $xoopsTpl = new \XoopsTpl(); |
75 | 75 | } |
@@ -7,36 +7,36 @@ discard block |
||
7 | 7 | */ |
8 | 8 | function instruction_tag_iteminfo(&$items) |
9 | 9 | { |
10 | - if (empty($items) || !is_array($items)) { |
|
11 | - return false; |
|
12 | - } |
|
10 | + if (empty($items) || !is_array($items)) { |
|
11 | + return false; |
|
12 | + } |
|
13 | 13 | |
14 | - $items_id = []; |
|
15 | - foreach (array_keys($items) as $cat_id) { |
|
16 | - foreach (array_keys($items[$cat_id]) as $item_id) { |
|
17 | - $items_id[] = (int)$item_id; |
|
18 | - } |
|
19 | - } |
|
14 | + $items_id = []; |
|
15 | + foreach (array_keys($items) as $cat_id) { |
|
16 | + foreach (array_keys($items[$cat_id]) as $item_id) { |
|
17 | + $items_id[] = (int)$item_id; |
|
18 | + } |
|
19 | + } |
|
20 | 20 | |
21 | - $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
22 | - $items_obj = $itemHandler->getObjects(new \Criteria('instrid', '(' . implode(', ', $items_id) . ')', 'IN'), true); |
|
21 | + $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
22 | + $items_obj = $itemHandler->getObjects(new \Criteria('instrid', '(' . implode(', ', $items_id) . ')', 'IN'), true); |
|
23 | 23 | |
24 | - foreach (array_keys($items) as $cat_id) { |
|
25 | - foreach (array_keys($items[$cat_id]) as $item_id) { |
|
26 | - if (isset($items_obj[$item_id])) { |
|
27 | - $item_obj = $items_obj[$item_id]; |
|
28 | - $items[$cat_id][$item_id] = [ |
|
29 | - 'title' => $item_obj->getVar('title'), |
|
30 | - 'uid' => $item_obj->getVar('uid'), |
|
31 | - 'link' => "instr.php?id={$item_id}", |
|
32 | - 'time' => $item_obj->getVar('datecreated'), |
|
33 | - 'tags' => '', |
|
34 | - 'content' => '', |
|
35 | - ]; |
|
36 | - } |
|
37 | - } |
|
38 | - } |
|
39 | - unset($items_obj); |
|
24 | + foreach (array_keys($items) as $cat_id) { |
|
25 | + foreach (array_keys($items[$cat_id]) as $item_id) { |
|
26 | + if (isset($items_obj[$item_id])) { |
|
27 | + $item_obj = $items_obj[$item_id]; |
|
28 | + $items[$cat_id][$item_id] = [ |
|
29 | + 'title' => $item_obj->getVar('title'), |
|
30 | + 'uid' => $item_obj->getVar('uid'), |
|
31 | + 'link' => "instr.php?id={$item_id}", |
|
32 | + 'time' => $item_obj->getVar('datecreated'), |
|
33 | + 'tags' => '', |
|
34 | + 'content' => '', |
|
35 | + ]; |
|
36 | + } |
|
37 | + } |
|
38 | + } |
|
39 | + unset($items_obj); |
|
40 | 40 | } |
41 | 41 | |
42 | 42 | // Синхронизация тегов |
@@ -45,32 +45,32 @@ discard block |
||
45 | 45 | */ |
46 | 46 | function instruction_tag_synchronization($mid) |
47 | 47 | { |
48 | - $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
49 | - $linkHandler = xoops_getModuleHandler('link', 'tag'); |
|
48 | + $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
49 | + $linkHandler = xoops_getModuleHandler('link', 'tag'); |
|
50 | 50 | |
51 | - /* clear tag-item links */ |
|
52 | - if (version_compare($GLOBALS['xoopsDB']->getServerVersion(), '4.1.0', 'ge')): |
|
53 | - $sql = " DELETE FROM {$linkHandler->table}" |
|
54 | - . ' WHERE ' |
|
55 | - . " tag_modid = {$mid}" |
|
56 | - . ' AND ' |
|
57 | - . ' ( tag_itemid NOT IN ' |
|
58 | - . " ( SELECT DISTINCT {$itemHandler->keyName} " |
|
59 | - . " FROM {$itemHandler->table} " |
|
60 | - . " WHERE {$itemHandler->table}.status > 0" |
|
61 | - . ' ) ' |
|
62 | - . ' )'; |
|
63 | - else: |
|
64 | - $sql = " DELETE {$linkHandler->table} FROM {$linkHandler->table}" |
|
65 | - . " LEFT JOIN {$itemHandler->table} AS aa ON {$linkHandler->table}.tag_itemid = aa.{$itemHandler->keyName} " |
|
66 | - . ' WHERE ' |
|
67 | - . " tag_modid = {$mid}" |
|
68 | - . ' AND ' |
|
69 | - . " ( aa.{$itemHandler->keyName} IS NULL" |
|
70 | - . ' OR aa.status < 1' |
|
71 | - . ' )'; |
|
72 | - endif; |
|
73 | - if (!$result = $linkHandler->db->queryF($sql)) { |
|
74 | - //xoops_error($linkHandler->db->error()); |
|
75 | - } |
|
51 | + /* clear tag-item links */ |
|
52 | + if (version_compare($GLOBALS['xoopsDB']->getServerVersion(), '4.1.0', 'ge')): |
|
53 | + $sql = " DELETE FROM {$linkHandler->table}" |
|
54 | + . ' WHERE ' |
|
55 | + . " tag_modid = {$mid}" |
|
56 | + . ' AND ' |
|
57 | + . ' ( tag_itemid NOT IN ' |
|
58 | + . " ( SELECT DISTINCT {$itemHandler->keyName} " |
|
59 | + . " FROM {$itemHandler->table} " |
|
60 | + . " WHERE {$itemHandler->table}.status > 0" |
|
61 | + . ' ) ' |
|
62 | + . ' )'; |
|
63 | + else: |
|
64 | + $sql = " DELETE {$linkHandler->table} FROM {$linkHandler->table}" |
|
65 | + . " LEFT JOIN {$itemHandler->table} AS aa ON {$linkHandler->table}.tag_itemid = aa.{$itemHandler->keyName} " |
|
66 | + . ' WHERE ' |
|
67 | + . " tag_modid = {$mid}" |
|
68 | + . ' AND ' |
|
69 | + . " ( aa.{$itemHandler->keyName} IS NULL" |
|
70 | + . ' OR aa.status < 1' |
|
71 | + . ' )'; |
|
72 | + endif; |
|
73 | + if (!$result = $linkHandler->db->queryF($sql)) { |
|
74 | + //xoops_error($linkHandler->db->error()); |
|
75 | + } |
|
76 | 76 | } |
@@ -7,14 +7,14 @@ discard block |
||
7 | 7 | */ |
8 | 8 | function instruction_tag_iteminfo(&$items) |
9 | 9 | { |
10 | - if (empty($items) || !is_array($items)) { |
|
10 | + if (empty($items) || ! is_array($items)) { |
|
11 | 11 | return false; |
12 | 12 | } |
13 | 13 | |
14 | 14 | $items_id = []; |
15 | 15 | foreach (array_keys($items) as $cat_id) { |
16 | 16 | foreach (array_keys($items[$cat_id]) as $item_id) { |
17 | - $items_id[] = (int)$item_id; |
|
17 | + $items_id[] = (int) $item_id; |
|
18 | 18 | } |
19 | 19 | } |
20 | 20 | |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | . ' OR aa.status < 1' |
71 | 71 | . ' )'; |
72 | 72 | endif; |
73 | - if (!$result = $linkHandler->db->queryF($sql)) { |
|
73 | + if ( ! $result = $linkHandler->db->queryF($sql)) { |
|
74 | 74 | //xoops_error($linkHandler->db->error()); |
75 | 75 | } |
76 | 76 | } |
@@ -60,7 +60,8 @@ discard block |
||
60 | 60 | . " WHERE {$itemHandler->table}.status > 0" |
61 | 61 | . ' ) ' |
62 | 62 | . ' )'; |
63 | - else: |
|
63 | + else { |
|
64 | + : |
|
64 | 65 | $sql = " DELETE {$linkHandler->table} FROM {$linkHandler->table}" |
65 | 66 | . " LEFT JOIN {$itemHandler->table} AS aa ON {$linkHandler->table}.tag_itemid = aa.{$itemHandler->keyName} " |
66 | 67 | . ' WHERE ' |
@@ -68,7 +69,8 @@ discard block |
||
68 | 69 | . ' AND ' |
69 | 70 | . " ( aa.{$itemHandler->keyName} IS NULL" |
70 | 71 | . ' OR aa.status < 1' |
71 | - . ' )'; |
|
72 | + . ' )'; |
|
73 | + } |
|
72 | 74 | endif; |
73 | 75 | if (!$result = $linkHandler->db->queryF($sql)) { |
74 | 76 | //xoops_error($linkHandler->db->error()); |
@@ -9,9 +9,9 @@ discard block |
||
9 | 9 | */ |
10 | 10 | function instruction_com_update($pageid, $total_num) |
11 | 11 | { |
12 | - $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
13 | - $sql = 'UPDATE ' . $db->prefix('instruction_page') . ' SET comments = ' . $total_num . ' WHERE pageid = ' . $pageid; |
|
14 | - $db->query($sql); |
|
12 | + $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
13 | + $sql = 'UPDATE ' . $db->prefix('instruction_page') . ' SET comments = ' . $total_num . ' WHERE pageid = ' . $pageid; |
|
14 | + $db->query($sql); |
|
15 | 15 | } |
16 | 16 | |
17 | 17 | /** |
@@ -19,5 +19,5 @@ discard block |
||
19 | 19 | */ |
20 | 20 | function instruction_com_approve(&$comment) |
21 | 21 | { |
22 | - // notification mail here |
|
22 | + // notification mail here |
|
23 | 23 | } |