XoopsModules25x /
lexikon
| @@ 353-367 (lines=15) @@ | ||
| 350 | function unichr($a) { |
|
| 351 | return mb_convert_encoding(pack("N",$a), mb_internal_encoding(), 'UCS-4BE'); |
|
| 352 | } |
|
| 353 | for ($a = 48; $a < (48 + 10); ++$a) { |
|
| 354 | $letterlinks = array(); |
|
| 355 | $initial = unichr($a); |
|
| 356 | $sql = $xoopsDB->query('SELECT entryID FROM ' |
|
| 357 | . $xoopsDB->prefix('lxentries') |
|
| 358 | . " WHERE init = '$initial' AND submit = '0' AND offline ='0' AND request = '0' " |
|
| 359 | . $catperms |
|
| 360 | . ''); |
|
| 361 | $howmany = $xoopsDB->getRowsNum($sql); |
|
| 362 | $letterlinks['total'] = $howmany; |
|
| 363 | $letterlinks['id'] = unichr($a); |
|
| 364 | $letterlinks['linktext'] = unichr($a); |
|
| 365 | ||
| 366 | $alpha['initial'][] = $letterlinks; |
|
| 367 | } |
|
| 368 | for ($a = 65; $a < (65 + 26); ++$a) { |
|
| 369 | $letterlinks = array(); |
|
| 370 | $initial = unichr($a); |
|
| @@ 368-382 (lines=15) @@ | ||
| 365 | ||
| 366 | $alpha['initial'][] = $letterlinks; |
|
| 367 | } |
|
| 368 | for ($a = 65; $a < (65 + 26); ++$a) { |
|
| 369 | $letterlinks = array(); |
|
| 370 | $initial = unichr($a); |
|
| 371 | $sql = $xoopsDB->query('SELECT entryID FROM ' |
|
| 372 | . $xoopsDB->prefix('lxentries') |
|
| 373 | . " WHERE init = '$initial' AND submit = '0' AND offline ='0' AND request = '0' " |
|
| 374 | . $catperms |
|
| 375 | . ''); |
|
| 376 | $howmany = $xoopsDB->getRowsNum($sql); |
|
| 377 | $letterlinks['total'] = $howmany; |
|
| 378 | $letterlinks['id'] = unichr($a); |
|
| 379 | $letterlinks['linktext'] = unichr($a); |
|
| 380 | ||
| 381 | $alpha['initial'][] = $letterlinks; |
|
| 382 | } |
|
| 383 | for ($a = 1040; $a < (1040 + 32); ++$a) { |
|
| 384 | $letterlinks = array(); |
|
| 385 | $initial = unichr($a); |
|
| @@ 383-396 (lines=14) @@ | ||
| 380 | ||
| 381 | $alpha['initial'][] = $letterlinks; |
|
| 382 | } |
|
| 383 | for ($a = 1040; $a < (1040 + 32); ++$a) { |
|
| 384 | $letterlinks = array(); |
|
| 385 | $initial = unichr($a); |
|
| 386 | $sql = $xoopsDB->query('SELECT entryID FROM ' |
|
| 387 | . $xoopsDB->prefix('lxentries') |
|
| 388 | . " WHERE init = '$initial' AND submit = '0' AND offline ='0' AND request = '0' " |
|
| 389 | . $catperms |
|
| 390 | . ''); |
|
| 391 | $howmany = $xoopsDB->getRowsNum($sql); |
|
| 392 | $letterlinks['total'] = $howmany; |
|
| 393 | $letterlinks['id'] = unichr($a); |
|
| 394 | $letterlinks['linktext'] = unichr($a); |
|
| 395 | $alpha['initial'][] = $letterlinks; |
|
| 396 | } |
|
| 397 | ||
| 398 | return $alpha; |
|
| 399 | } |
|
| @@ 169-179 (lines=11) @@ | ||
| 166 | $catids = implode(',', $allowed_cats); |
|
| 167 | $catperms = " AND categoryID IN ($catids) "; |
|
| 168 | $alpha = array(); |
|
| 169 | for ($a = 65; $a < (65+26); $a++ ) { |
|
| 170 | $letterlinks = array(); |
|
| 171 | $initial = chr($a); |
|
| 172 | $sql = $xoopsDB -> query ( "SELECT entryID FROM " . $xoopsDB -> prefix ( "lxentries") . " WHERE init = '$initial' AND submit = '0' AND offline ='0' AND request = '0' ".$catperms.""); |
|
| 173 | $howmany = $xoopsDB -> getRowsNum( $sql ); |
|
| 174 | $letterlinks['total'] = $howmany; |
|
| 175 | $letterlinks['id'] = chr($a); |
|
| 176 | $letterlinks['linktext'] = chr($a); |
|
| 177 | ||
| 178 | $alpha['initial'][] = $letterlinks; |
|
| 179 | } |
|
| 180 | ||
| 181 | return $alpha; |
|
| 182 | } |
|
