|
1
|
|
|
<?php |
|
2
|
|
|
/** |
|
3
|
|
|
* Module: Lexikon - glossary module |
|
4
|
|
|
* Version: v 1.00 |
|
5
|
|
|
* Release Date: 8 May 2004 |
|
6
|
|
|
* Author: hsalazar |
|
7
|
|
|
* Licence: GNU |
|
8
|
|
|
*/ |
|
9
|
|
|
|
|
10
|
|
|
use Xmf\Request; |
|
11
|
|
|
use XoopsModules\Lexikon\{ |
|
12
|
|
|
Helper, |
|
13
|
|
|
Utility |
|
14
|
|
|
}; |
|
15
|
|
|
/** @var Helper $helper */ |
|
16
|
|
|
/** @var Utility $utility */ |
|
17
|
|
|
|
|
18
|
|
|
$GLOBALS['xoopsOption']['template_main'] = 'lx_letter.tpl'; |
|
19
|
|
|
require __DIR__ . '/header.php'; |
|
20
|
|
|
require_once XOOPS_ROOT_PATH . '/header.php'; |
|
21
|
|
|
require_once XOOPS_ROOT_PATH . '/modules/lexikon/include/common.inc.php'; |
|
22
|
|
|
|
|
23
|
|
|
$helper = Helper::getInstance(); |
|
24
|
|
|
|
|
25
|
|
|
|
|
26
|
|
|
global $xoTheme, $xoopsUser; |
|
27
|
|
|
$myts = \MyTextSanitizer::getInstance(); |
|
28
|
|
|
|
|
29
|
|
|
$init = Request::getString('init', 0, 'GET'); |
|
30
|
|
|
$xoopsTpl->assign('firstletter', $init); |
|
31
|
|
|
require_once XOOPS_ROOT_PATH . '/class/pagenav.php'; |
|
32
|
|
|
$start = Request::getInt('start', 0, 'GET'); |
|
33
|
|
|
|
|
34
|
|
|
$publishedwords = $utility::countWords(); |
|
35
|
|
|
$xoopsTpl->assign('publishedwords', $publishedwords); |
|
36
|
|
|
|
|
37
|
|
|
//permissions |
|
38
|
|
|
/** @var \XoopsGroupPermHandler $grouppermHandler */ |
|
39
|
|
|
$grouppermHandler = xoops_getHandler('groupperm'); |
|
40
|
|
|
$groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS; |
|
41
|
|
|
$module_id = $xoopsModule->getVar('mid'); |
|
42
|
|
|
$allowed_cats = $grouppermHandler->getItemIds('lexikon_view', $groups, $module_id); |
|
43
|
|
|
$catids = implode(',', $allowed_cats); |
|
44
|
|
|
$catperms = " AND categoryID IN ($catids) "; |
|
45
|
|
|
|
|
46
|
|
|
$xoopsTpl->assign('multicats', (int)$helper->getConfig('multicats')); |
|
47
|
|
|
|
|
48
|
|
|
if (!function_exists('mb_ucfirst') && function_exists('mb_substr')) { |
|
49
|
|
|
/** |
|
50
|
|
|
* @param $string |
|
51
|
|
|
* @return string |
|
52
|
|
|
*/ |
|
53
|
|
|
function mb_ucfirst($string) |
|
54
|
|
|
{ |
|
55
|
|
|
$string = mb_ereg_replace('^[\ ]+', '', $string); |
|
56
|
|
|
$string = mb_strtoupper(mb_substr($string, 0, 1, 'UTF-8'), 'UTF-8') . mb_substr($string, 1, mb_strlen($string), 'UTF-8'); |
|
57
|
|
|
|
|
58
|
|
|
return $string; |
|
59
|
|
|
} |
|
60
|
|
|
} |
|
61
|
|
|
// To display the linked letter list |
|
62
|
|
|
$alpha = $utility::getAlphaArray(); |
|
63
|
|
|
$xoopsTpl->assign('alpha', $alpha); |
|
64
|
|
|
|
|
65
|
|
|
[$howmanyother] = $xoopsDB->fetchRow($xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('lxentries') . " WHERE init = '#' AND offline ='0' " . $catperms . ' ')); |
|
66
|
|
|
$xoopsTpl->assign('totalother', $howmanyother); |
|
67
|
|
|
|
|
68
|
|
|
// To display the list of categories |
|
69
|
|
|
if (1 == $helper->getConfig('multicats')) { |
|
70
|
|
|
$xoopsTpl->assign('block0', $utility::getCategoryArray()); |
|
71
|
|
|
$xoopsTpl->assign('layout', CONFIG_CATEGORY_LAYOUT_PLAIN); |
|
72
|
|
|
if ($utility::getModuleOption('useshots')) { |
|
73
|
|
|
$xoopsTpl->assign('show_screenshot', true); |
|
74
|
|
|
$xoopsTpl->assign('logo_maximgwidth', $helper->getConfig('logo_maximgwidth')); |
|
75
|
|
|
$xoopsTpl->assign('lang_noscreenshot', _MD_LEXIKON_NOSHOTS); |
|
76
|
|
|
} else { |
|
77
|
|
|
$xoopsTpl->assign('show_screenshot', false); |
|
78
|
|
|
} |
|
79
|
|
|
} |
|
80
|
|
|
|
|
81
|
|
|
// No initial: we need to see all letters |
|
82
|
|
|
if (!$init) { |
|
83
|
|
|
$entriesarray = []; |
|
84
|
|
|
$pagetype = 0; |
|
85
|
|
|
|
|
86
|
|
|
// How many entries will we show in this page? |
|
87
|
|
|
//$queryA = "SELECT w. * , c.name AS catname FROM ".$xoopsDB -> prefix( 'lxentries' )." w LEFT JOIN ".$xoopsDB -> prefix( 'lxcategories' )." c ON w.categoryID = c.categoryID WHERE w.submit = '0' AND w.offline = '0' ORDER BY w.term ASC"; |
|
88
|
|
|
//$resultA = $xoopsDB -> query ($queryA, $helper->getConfig('indexperpage'), $start ); |
|
89
|
|
|
$queryA = 'SELECT * FROM ' . $xoopsDB->prefix('lxentries') . " WHERE offline = '0' AND submit = '0' " . $catperms . ' ORDER BY term ASC'; |
|
90
|
|
|
$resultA = $xoopsDB->query($queryA, $helper->getConfig('indexperpage'), $start); |
|
91
|
|
|
|
|
92
|
|
|
$allentries = $xoopsDB->query('SELECT entryID FROM ' . $xoopsDB->prefix('lxentries') . " WHERE submit ='0' AND offline = '0' " . $catperms . ' ORDER BY term ASC '); |
|
93
|
|
|
$totalentries = $xoopsDB->getRowsNum($allentries); |
|
94
|
|
|
$xoopsTpl->assign('totalentries', $totalentries); |
|
95
|
|
|
|
|
96
|
|
|
while (list($entryID, $categoryID, $term, $init, $definition, $ref, $url, $uid, $submit, $datesub, $counter, $html, $smiley, $xcodes, $breaks, $block, $offline, $comments) = $xoopsDB->fetchRow($resultA)) { |
|
97
|
|
|
$eachentry = []; |
|
98
|
|
|
$xoopsModule = XoopsModule::getByDirname('lexikon'); |
|
99
|
|
|
$eachentry['dir'] = $xoopsModule->dirname(); |
|
100
|
|
|
|
|
101
|
|
|
if (1 == $helper->getConfig('multicats')) { |
|
102
|
|
|
$eachentry['catid'] = (int)$categoryID; |
|
103
|
|
|
$resultF = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $categoryID ORDER BY name ASC"); |
|
104
|
|
|
while (list($name) = $xoopsDB->fetchRow($resultF)) { |
|
105
|
|
|
$eachentry['catname'] = htmlspecialchars($name, ENT_QUOTES | ENT_HTML5); |
|
106
|
|
|
} |
|
107
|
|
|
} |
|
108
|
|
|
|
|
109
|
|
|
$eachentry['id'] = (int)$entryID; |
|
110
|
|
|
$eachentry['term'] = mb_ucfirst(htmlspecialchars($term, ENT_QUOTES | ENT_HTML5)); |
|
111
|
|
|
|
|
112
|
|
|
if ((0 !== $helper->getConfig('com_rule')) || ((0 != $helper->getConfig('com_rule')) && is_object($xoopsUser))) { |
|
|
|
|
|
|
113
|
|
|
if (0 != $comments) { |
|
114
|
|
|
$eachentry['comments'] = "<a href='entry.php?entryID=" . $eachentry['id'] . "'>" . $comments . ' ' . _COMMENTS . '</a>'; |
|
115
|
|
|
} else { |
|
116
|
|
|
$eachentry['comments'] = ''; |
|
117
|
|
|
} |
|
118
|
|
|
} |
|
119
|
|
|
|
|
120
|
|
|
if (!XOOPS_USE_MULTIBYTES) { |
|
121
|
|
|
$eachentry['definition'] = $myts->displayTarea($definition, $html, $smiley, $xcodes, 1, $breaks); |
|
122
|
|
|
} |
|
123
|
|
|
|
|
124
|
|
|
// Functional links |
|
125
|
|
|
$microlinks = $utility::getServiceLinks($eachentry); |
|
126
|
|
|
$eachentry['microlinks'] = $microlinks; |
|
127
|
|
|
|
|
128
|
|
|
$entriesarray['single'][] = $eachentry; |
|
129
|
|
|
} |
|
130
|
|
|
$pagenav = new \XoopsPageNav($totalentries, $helper->getConfig('indexperpage'), $start, 'start'); |
|
131
|
|
|
$entriesarray['navbar'] = '<div style="text-align:right;">' . $pagenav->renderNav(6) . '</div>'; |
|
132
|
|
|
|
|
133
|
|
|
$xoopsTpl->assign('entriesarray', $entriesarray); |
|
134
|
|
|
$xoopsTpl->assign('pagetype', '0'); |
|
135
|
|
|
$xoopsTpl->assign('pageinitial', _MD_LEXIKON_ALL); |
|
136
|
|
|
|
|
137
|
|
|
$utility::createPageTitle(htmlspecialchars(_MD_LEXIKON_BROWSELETTER . ' - ' . _MD_LEXIKON_ALL, ENT_QUOTES | ENT_HTML5)); |
|
138
|
|
|
} else { // $init does exist |
|
139
|
|
|
$pagetype = 1; |
|
140
|
|
|
// There IS an initial letter, so we want to show just that letter's terms |
|
141
|
|
|
$entriesarray2 = []; |
|
142
|
|
|
|
|
143
|
|
|
// How many entries will we show in this page? |
|
144
|
|
|
if (_MD_LEXIKON_OTHER == $init) { |
|
145
|
|
|
$queryB = 'SELECT entryID, categoryID, term, definition, uid, html, smiley, xcodes, breaks, comments FROM ' . $xoopsDB->prefix('lxentries') . " WHERE submit ='0' AND offline = '0' AND init = '#' " . $catperms . ' ORDER BY term ASC'; |
|
146
|
|
|
$resultB = $xoopsDB->query($queryB, $helper->getConfig('indexperpage'), $start); |
|
147
|
|
|
} else { |
|
148
|
|
|
$queryB = 'SELECT entryID, categoryID, term, definition, uid, html, smiley, xcodes, breaks, comments FROM ' . $xoopsDB->prefix('lxentries') . " WHERE submit ='0' AND offline = '0' AND init = '$init' AND init != '#' " . $catperms . ' ORDER BY term ASC'; |
|
149
|
|
|
$resultB = $xoopsDB->query($queryB, $helper->getConfig('indexperpage'), $start); |
|
150
|
|
|
} |
|
151
|
|
|
|
|
152
|
|
|
$entrieshere = $xoopsDB->getRowsNum($resultB); |
|
153
|
|
|
if (0 == $entrieshere) { |
|
154
|
|
|
redirect_header('<script>javascript:history.go(-1)</script>', 1, _MD_LEXIKON_NOTERMSINLETTER); |
|
155
|
|
|
} |
|
156
|
|
|
|
|
157
|
|
|
if (_MD_LEXIKON_OTHER == $init) { |
|
158
|
|
|
$allentries = $xoopsDB->query('SELECT entryID FROM ' . $xoopsDB->prefix('lxentries') . " WHERE init = '#' AND submit ='0' AND offline = '0' " . $catperms . ' ORDER BY term ASC '); |
|
159
|
|
|
} else { |
|
160
|
|
|
$allentries = $xoopsDB->query('SELECT entryID FROM ' . $xoopsDB->prefix('lxentries') . " WHERE init = '$init' AND init != '#' AND submit ='0' AND offline = '0' " . $catperms . ' ORDER BY term ASC '); |
|
161
|
|
|
} |
|
162
|
|
|
$totalentries = $xoopsDB->getRowsNum($allentries); |
|
163
|
|
|
$xoopsTpl->assign('totalentries', $totalentries); |
|
164
|
|
|
$utility::createPageTitle(htmlspecialchars(_MD_LEXIKON_BROWSELETTER . (isset($init['init']) ? (' - ' . $init['init']) : ''), ENT_QUOTES | ENT_HTML5)); |
|
165
|
|
|
|
|
166
|
|
|
while (list($entryID, $categoryID, $term, $definition, $uid, $html, $smiley, $xcodes, $breaks, $comments) = $xoopsDB->fetchRow($resultB)) { |
|
167
|
|
|
$eachentry = []; |
|
168
|
|
|
$xoopsModule = XoopsModule::getByDirname('lexikon'); |
|
169
|
|
|
$eachentry['dir'] = $xoopsModule->dirname(); |
|
170
|
|
|
|
|
171
|
|
|
if (1 == $helper->getConfig('multicats')) { |
|
172
|
|
|
$eachentry['catid'] = (int)$categoryID; |
|
173
|
|
|
$resultF = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $categoryID ORDER BY name ASC"); |
|
174
|
|
|
while (list($name) = $xoopsDB->fetchRow($resultF)) { |
|
175
|
|
|
$eachentry['catname'] = htmlspecialchars($name, ENT_QUOTES | ENT_HTML5); |
|
176
|
|
|
} |
|
177
|
|
|
} |
|
178
|
|
|
$eachentry['id'] = (int)$entryID; |
|
179
|
|
|
$eachentry['term'] = mb_ucfirst(htmlspecialchars($term, ENT_QUOTES | ENT_HTML5)); |
|
180
|
|
|
if ('#' === $init) { |
|
181
|
|
|
$eachentry['init'] = _MD_LEXIKON_OTHER; |
|
182
|
|
|
} else { |
|
183
|
|
|
$eachentry['init'] = $init; |
|
184
|
|
|
} |
|
185
|
|
|
|
|
186
|
|
|
if ((0 !== $helper->getConfig('com_rule')) || ((0 != $helper->getConfig('com_rule')) && is_object($xoopsUser))) { |
|
|
|
|
|
|
187
|
|
|
if (0 != $comments) { |
|
188
|
|
|
$eachentry['comments'] = "<a href='entry.php?entryID=" . $eachentry['id'] . "'>" . $comments . ' ' . _COMMENTS . '</a>'; |
|
189
|
|
|
} else { |
|
190
|
|
|
$eachentry['comments'] = ''; |
|
191
|
|
|
} |
|
192
|
|
|
} |
|
193
|
|
|
if (!XOOPS_USE_MULTIBYTES) { |
|
194
|
|
|
$eachentry['definition'] = $myts->displayTarea($definition, $html, $smiley, $xcodes, 1, $breaks); |
|
195
|
|
|
} |
|
196
|
|
|
|
|
197
|
|
|
// Functional links |
|
198
|
|
|
$microlinks = $utility::getServiceLinks($eachentry); |
|
199
|
|
|
$eachentry['microlinks'] = $microlinks; |
|
200
|
|
|
|
|
201
|
|
|
$entriesarray2['single'][] = $eachentry; |
|
202
|
|
|
} |
|
203
|
|
|
$pagenav = new \XoopsPageNav($totalentries, $helper->getConfig('indexperpage'), $start, 'init=' . $eachentry['init'] . '&start'); |
|
204
|
|
|
$entriesarray2['navbar'] = '<div style="text-align:right;">' . $pagenav->renderNav(6) . '</div>'; |
|
205
|
|
|
|
|
206
|
|
|
$xoopsTpl->assign('entriesarray2', $entriesarray2); |
|
207
|
|
|
$xoopsTpl->assign('pagetype', '1'); |
|
208
|
|
|
if ('#' === $eachentry['init']) { |
|
209
|
|
|
$xoopsTpl->assign('pageinitial', _MD_LEXIKON_OTHER); |
|
210
|
|
|
$utility::createPageTitle(htmlspecialchars(_MD_LEXIKON_BROWSELETTER . ' - ' . _MD_LEXIKON_OTHER, ENT_QUOTES | ENT_HTML5)); |
|
211
|
|
|
} else { |
|
212
|
|
|
$xoopsTpl->assign('pageinitial', mb_ucfirst($eachentry['init'])); |
|
213
|
|
|
} |
|
214
|
|
|
} |
|
215
|
|
|
|
|
216
|
|
|
$xoopsTpl->assign('lang_modulename', $xoopsModule->name()); |
|
217
|
|
|
$xoopsTpl->assign('lang_moduledirname', $xoopsModule->getVar('dirname')); |
|
218
|
|
|
$xoopsTpl->assign('alpha', $alpha); |
|
219
|
|
|
if (1 == $helper->getConfig('syndication')) { |
|
220
|
|
|
$xoopsTpl->assign('syndication', true); |
|
221
|
|
|
} |
|
222
|
|
|
if ($xoopsUser) { |
|
223
|
|
|
$xoopsTpl->assign('syndication', true); |
|
224
|
|
|
} |
|
225
|
|
|
// Meta data |
|
226
|
|
|
$publishedwords = 0; |
|
227
|
|
|
if ($publishedwords) { |
|
228
|
|
|
$meta_description = xoops_substr($utility::convertHtml2text($eachentry['definition']), 0, 150); |
|
229
|
|
|
if (1 == $helper->getConfig('multicats')) { |
|
230
|
|
|
$utility::extractKeywords($xoopsModule->name() . ' ,' . $eachentry['term'] . ', ' . $meta_description); |
|
231
|
|
|
$utility::getMetaDescription(htmlspecialchars($xoopsModule->name(), ENT_QUOTES | ENT_HTML5) . ' ' . $eachentry['catname'] . ' ' . $eachentry['term']); |
|
232
|
|
|
} else { |
|
233
|
|
|
$utility::extractKeywords(htmlspecialchars($xoopsModule->name(), ENT_QUOTES | ENT_HTML5) . ', ' . $eachentry['term'] . ', ' . $meta_description); |
|
234
|
|
|
$utility::getMetaDescription(htmlspecialchars($xoopsModule->name(), ENT_QUOTES | ENT_HTML5) . ' ' . $eachentry['term'] . ' ' . $meta_description); |
|
235
|
|
|
} |
|
236
|
|
|
} |
|
237
|
|
|
|
|
238
|
|
|
$xoopsTpl->assign('xoops_module_header', '<link rel="stylesheet" type="text/css" href="assets/css/style.css">'); |
|
239
|
|
|
|
|
240
|
|
|
require XOOPS_ROOT_PATH . '/footer.php'; |
|
241
|
|
|
|