mambax7 /
adslight
| Total Complexity | 115 |
| Total Lines | 725 |
| Duplicated Lines | 0 % |
| Changes | 0 | ||
Complex classes like Utility often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use Utility, and based on these observations, apply Extract Interface, too.
| 1 | <?php namespace XoopsModules\Adslight; |
||
| 49 | class Utility |
||
| 50 | { |
||
| 51 | use Common\VersionChecks; //checkVerXoops, checkVerPhp Traits |
||
| 52 | |||
| 53 | use Common\ServerStats; // getServerStats Trait |
||
| 54 | |||
| 55 | use Common\FilesManagement; // Files Management Trait |
||
| 56 | |||
| 57 | //--------------- Custom module methods ----------------------------- |
||
| 58 | |||
| 59 | |||
| 60 | public static function expireAd() |
||
| 61 | { |
||
| 62 | global $xoopsDB, $xoopsConfig, $xoopsModule, $myts, $meta, $moduleDirName, $main_lang; |
||
| 63 | |||
| 64 | $datenow = time(); |
||
| 65 | $message = ''; |
||
| 66 | |||
| 67 | $result5 = $xoopsDB->query('SELECT lid, title, expire, type, desctext, date, email, submitter, photo, valid, hits, comments, remind FROM ' . $xoopsDB->prefix('adslight_listing') . " WHERE valid='Yes'"); |
||
| 68 | |||
| 69 | while (list($lids, $title, $expire, $type, $desctext, $dateann, $email, $submitter, $photo, $valid, $hits, $comments, $remind) = $xoopsDB->fetchRow($result5)) { |
||
| 70 | $title = $myts->htmlSpecialChars($title); |
||
| 71 | $expire = $myts->htmlSpecialChars($expire); |
||
| 72 | $type = $myts->htmlSpecialChars($type); |
||
| 73 | $desctext =& $myts->displayTarea($desctext, 1, 1, 1, 1, 1); |
||
| 74 | $submitter = $myts->htmlSpecialChars($submitter); |
||
| 75 | $remind = $myts->htmlSpecialChars($remind); |
||
| 76 | $supprdate = $dateann + ($expire * 86400); |
||
| 77 | $almost = $GLOBALS['xoopsModuleConfig']['adslight_almost']; |
||
| 78 | |||
| 79 | // give warning that add is about to expire |
||
| 80 | |||
| 81 | if ($almost > 0 && ($supprdate - $almost * 86400) < $datenow |
||
| 82 | && 'Yes' === $valid |
||
| 83 | && 0 == $remind) { |
||
| 84 | $xoopsDB->queryF('UPDATE ' . $xoopsDB->prefix('adslight_listing') . " SET remind='1' WHERE lid=$lids"); |
||
| 85 | |||
| 86 | if ($email) { |
||
| 87 | $tags = []; |
||
| 88 | $subject = '' . _ADSLIGHT_ALMOST . ''; |
||
| 89 | $tags['TITLE'] = $title; |
||
| 90 | $tags['HELLO'] = '' . _ADSLIGHT_HELLO . ''; |
||
| 91 | $tags['YOUR_AD_ON'] = '' . _ADSLIGHT_YOUR_AD_ON . ''; |
||
| 92 | $tags['VEDIT_AD'] = '' . _ADSLIGHT_VEDIT_AD . ''; |
||
| 93 | $tags['YOUR_AD'] = '' . _ADSLIGHT_YOUR_AD . ''; |
||
| 94 | $tags['SOON'] = '' . _ADSLIGHT_SOON . ''; |
||
| 95 | $tags['VIEWED'] = '' . _ADSLIGHT_VU . ''; |
||
| 96 | $tags['TIMES'] = '' . _ADSLIGHT_TIMES . ''; |
||
| 97 | $tags['WEBMASTER'] = '' . _ADSLIGHT_WEBMASTER . ''; |
||
| 98 | $tags['THANKS'] = '' . _ADSLIGHT_THANKS . ''; |
||
| 99 | $tags['TYPE'] = static::getNameType($type); |
||
| 100 | $tags['DESCTEXT'] = $desctext; |
||
| 101 | $tags['HITS'] = $hits; |
||
| 102 | $tags['META_TITLE'] = $meta['title']; |
||
| 103 | $tags['SUBMITTER'] = $submitter; |
||
| 104 | $tags['DURATION'] = $expire; |
||
| 105 | $tags['LINK_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewads.php?' . '&lid=' . $lids; |
||
| 106 | $mail =& getMailer(); |
||
| 107 | $mail->setTemplateDir(XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/' . $xoopsConfig['language'] . '/mail_template/'); |
||
| 108 | $mail->setTemplate('listing_expires.tpl'); |
||
| 109 | $mail->useMail(); |
||
| 110 | $mail->multimailer->isHTML(true); |
||
| 111 | $mail->setFromName($meta['title']); |
||
| 112 | $mail->setFromEmail($xoopsConfig['adminmail']); |
||
| 113 | $mail->setToEmails($email); |
||
| 114 | $mail->setSubject($subject); |
||
| 115 | $mail->assign($tags); |
||
| 116 | $mail->send(); |
||
| 117 | echo $mail->getErrors(); |
||
| 118 | } |
||
| 119 | } |
||
| 120 | |||
| 121 | // expire ad |
||
| 122 | |||
| 123 | if ($supprdate < $datenow) { |
||
| 124 | if (0 != $photo) { |
||
| 125 | $result2 = $xoopsDB->query('SELECT url FROM ' . $xoopsDB->prefix('adslight_pictures') . ' WHERE lid=' . $xoopsDB->escape($lids)); |
||
| 126 | |||
| 127 | while (list($url) = $xoopsDB->fetchRow($result2)) { |
||
| 128 | $destination = XOOPS_ROOT_PATH . '/uploads/AdsLight'; |
||
| 129 | $destination2 = XOOPS_ROOT_PATH . '/uploads/AdsLight/thumbs'; |
||
| 130 | $destination3 = XOOPS_ROOT_PATH . '/uploads/AdsLight/midsize'; |
||
| 131 | if (file_exists("$destination/$url")) { |
||
| 132 | unlink("$destination/$url"); |
||
| 133 | } |
||
| 134 | if (file_exists("$destination2/thumb_$url")) { |
||
| 135 | unlink("$destination2/thumb_$url"); |
||
| 136 | } |
||
| 137 | if (file_exists("$destination3/resized_$url")) { |
||
| 138 | unlink("$destination3/resized_$url"); |
||
| 139 | } |
||
| 140 | } |
||
| 141 | } |
||
| 142 | |||
| 143 | $xoopsDB->queryF('DELETE FROM ' . $xoopsDB->prefix('adslight_listing') . ' WHERE lid=' . $xoopsDB->escape($lids)); |
||
| 144 | |||
| 145 | // Specification for Japan: |
||
| 146 | // $message = ""._ADS_HELLO." $submitter,\n\n"._ADS_STOP2."\n $type : $title\n $desctext\n"._ADS_STOP3."\n\n"._ADS_VU." $lu "._ADS_VU2."\n\n"._ADS_OTHER." ".XOOPS_URL."/modules/myAds\n\n"._ADS_THANK."\n\n"._ADS_TEAM." ".$meta['title']."\n".XOOPS_URL.""; |
||
| 147 | if ($email) { |
||
| 148 | $tags = []; |
||
| 149 | $subject = '' . _ADSLIGHT_STOP . ''; |
||
| 150 | $tags['TITLE'] = $title; |
||
| 151 | $tags['HELLO'] = '' . _ADSLIGHT_HELLO . ''; |
||
| 152 | $tags['TYPE'] = static::getNameType($type); |
||
| 153 | $tags['DESCTEXT'] = $desctext; |
||
| 154 | $tags['HITS'] = $hits; |
||
| 155 | $tags['META_TITLE'] = $meta['title']; |
||
| 156 | $tags['SUBMITTER'] = $submitter; |
||
| 157 | $tags['YOUR_AD_ON'] = '' . _ADSLIGHT_YOUR_AD_ON . ''; |
||
| 158 | $tags['EXPIRED'] = '' . _ADSLIGHT_EXPIRED . ''; |
||
| 159 | $tags['MESSTEXT'] = stripslashes($message); |
||
| 160 | $tags['OTHER'] = '' . _ADSLIGHT_OTHER . ''; |
||
| 161 | $tags['WEBMASTER'] = '' . _ADSLIGHT_WEBMASTER . ''; |
||
| 162 | $tags['THANKS'] = '' . _ADSLIGHT_THANKS . ''; |
||
| 163 | $tags['VIEWED'] = '' . _ADSLIGHT_VU . ''; |
||
| 164 | $tags['TIMES'] = '' . _ADSLIGHT_TIMES . ''; |
||
| 165 | $tags['TEAM'] = '' . _ADSLIGHT_TEAM . ''; |
||
| 166 | $tags['DURATION'] = $expire; |
||
| 167 | $tags['LINK_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewads.php?' . '&lid=' . $lids; |
||
| 168 | $mail =& getMailer(); |
||
| 169 | $mail->setTemplateDir(XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/' . $xoopsConfig['language'] . '/mail_template/'); |
||
| 170 | $mail->setTemplate('listing_expired.tpl'); |
||
| 171 | $mail->useMail(); |
||
| 172 | $mail->multimailer->isHTML(true); |
||
| 173 | $mail->setFromName($meta['title']); |
||
| 174 | $mail->setFromEmail($xoopsConfig['adminmail']); |
||
| 175 | $mail->setToEmails($email); |
||
| 176 | $mail->setSubject($subject); |
||
| 177 | $mail->assign($tags); |
||
| 178 | $mail->send(); |
||
| 179 | echo $mail->getErrors(); |
||
| 180 | } |
||
| 181 | } |
||
| 182 | } |
||
| 183 | } |
||
| 184 | |||
| 185 | //updates rating data in itemtable for a given user |
||
| 186 | |||
| 187 | /** |
||
| 188 | * @param $sel_id |
||
| 189 | */ |
||
| 190 | public static function updateUserRating($sel_id) |
||
| 191 | { |
||
| 192 | global $xoopsDB, $moduleDirName, $main_lang; |
||
| 193 | |||
| 194 | $usid = Request::getInt('usid', 0, 'GET'); |
||
| 195 | |||
| 196 | $query = 'SELECT rating FROM ' . $xoopsDB->prefix('adslight_user_votedata') . ' WHERE usid=' . $xoopsDB->escape($sel_id) . ' '; |
||
| 197 | //echo $query; |
||
| 198 | $voteresult = $xoopsDB->query($query); |
||
| 199 | $votesDB = $xoopsDB->getRowsNum($voteresult); |
||
| 200 | $totalrating = 0; |
||
| 201 | while (list($rating) = $xoopsDB->fetchRow($voteresult)) { |
||
| 202 | $totalrating += $rating; |
||
| 203 | } |
||
| 204 | $finalrating = $totalrating / $votesDB; |
||
| 205 | $finalrating = number_format($finalrating, 4); |
||
| 206 | $query = 'UPDATE ' . $xoopsDB->prefix('adslight_listing') . " SET user_rating=$finalrating, user_votes=$votesDB WHERE usid=" . $xoopsDB->escape($sel_id) . ''; |
||
| 207 | //echo $query; |
||
| 208 | $xoopsDB->query($query) || exit(); |
||
| 209 | } |
||
| 210 | |||
| 211 | //updates rating data in itemtable for a given item |
||
| 212 | |||
| 213 | /** |
||
| 214 | * @param $sel_id |
||
| 215 | */ |
||
| 216 | public static function updateItemRating($sel_id) |
||
| 235 | } |
||
| 236 | |||
| 237 | /** |
||
| 238 | * @param $sel_id |
||
| 239 | * @param string $status |
||
| 240 | * |
||
| 241 | * @return int |
||
| 242 | */ |
||
| 243 | public static function getTotalItems($sel_id, $status = '') |
||
| 244 | { |
||
| 245 | global $xoopsDB, $mytree, $moduleDirName; |
||
| 246 | $categories = Adslight\Utility::getMyItemIds('adslight_view'); |
||
| 247 | $count = 0; |
||
| 248 | $arr = []; |
||
| 249 | if (in_array($sel_id, $categories)) { |
||
| 250 | $query = 'SELECT SQL_CACHE count(*) FROM ' . $xoopsDB->prefix('adslight_listing') . ' WHERE cid=' . (int)$sel_id . " AND valid='Yes' AND status!='1'"; |
||
| 251 | |||
| 252 | $result = $xoopsDB->query($query); |
||
| 253 | list($thing) = $xoopsDB->fetchRow($result); |
||
| 254 | $count = $thing; |
||
| 255 | $arr = $mytree->getAllChildId($sel_id); |
||
| 256 | $size = count($arr); |
||
| 257 | for ($i = 0; $i < $size; ++$i) { |
||
| 258 | if (in_array($arr[$i], $categories)) { |
||
| 259 | $query2 = 'SELECT SQL_CACHE count(*) FROM ' . $xoopsDB->prefix('adslight_listing') . ' WHERE cid=' . (int)$arr[$i] . " AND valid='Yes' AND status!='1'"; |
||
| 260 | |||
| 261 | $result2 = $xoopsDB->query($query2); |
||
| 262 | list($thing) = $xoopsDB->fetchRow($result2); |
||
| 263 | $count += $thing; |
||
| 264 | } |
||
| 265 | } |
||
| 266 | } |
||
| 267 | |||
| 268 | return $count; |
||
| 269 | } |
||
| 270 | |||
| 271 | /** |
||
| 272 | * @param $permtype |
||
| 273 | * |
||
| 274 | * @return mixed |
||
| 275 | */ |
||
| 276 | public static function getMyItemIds($permtype) |
||
| 295 | } |
||
| 296 | |||
| 297 | /** |
||
| 298 | * Returns a module's option |
||
| 299 | * @param $option module option's name |
||
| 300 | * @param string $repmodule |
||
| 301 | * |
||
| 302 | * @return option's value |
||
| 303 | */ |
||
| 304 | public static function getModuleOption($option, $repmodule = 'adslight') |
||
| 305 | { |
||
| 306 | global $xoopsModule; |
||
| 307 | static $tbloptions = []; |
||
| 308 | if (is_array($tbloptions) && array_key_exists($option, $tbloptions)) { |
||
| 309 | return $tbloptions[$option]; |
||
| 310 | } |
||
| 311 | |||
| 312 | $retval = false; |
||
| 313 | if (isset($GLOBALS['xoopsModuleConfig']) |
||
| 314 | && (is_object($xoopsModule) |
||
| 315 | && $xoopsModule->getVar('dirname') == $repmodule |
||
| 316 | && $xoopsModule->getVar('isactive'))) { |
||
| 317 | if (isset($GLOBALS['xoopsModuleConfig'][$option])) { |
||
| 318 | $retval = $GLOBALS['xoopsModuleConfig'][$option]; |
||
| 319 | } |
||
| 320 | } else { |
||
| 321 | /** @var XoopsModuleHandler $moduleHandler */ |
||
| 322 | $moduleHandler = xoops_getHandler('module'); |
||
| 323 | $module = $moduleHandler->getByDirname($repmodule); |
||
| 324 | /** @var XoopsModuleHandler $moduleHandler */ |
||
| 325 | $configHandler = xoops_getHandler('config'); |
||
| 326 | if ($module) { |
||
| 327 | $moduleConfig = $configHandler->getConfigsByCat(0, $GLOBALS['xoopsModule']->getVar('mid')); |
||
| 328 | if (null !== ($helper->getConfig($option))) { |
||
| 329 | $retval = $helper->getConfig($option); |
||
| 330 | } |
||
| 331 | } |
||
| 332 | } |
||
| 333 | $tbloptions[$option] = $retval; |
||
| 334 | |||
| 335 | return $retval; |
||
| 336 | } |
||
| 337 | |||
| 338 | public static function showImage() |
||
| 339 | { |
||
| 340 | global $moduleDirName; |
||
| 341 | echo "<script type=\"text/javascript\">\n"; |
||
| 342 | echo "<!--\n\n"; |
||
| 343 | echo "function showimage() {\n"; |
||
| 344 | echo "if (!document.images)\n"; |
||
| 345 | echo "return\n"; |
||
| 346 | echo "document.images.avatar.src=\n"; |
||
| 347 | echo "'" . XOOPS_URL . "/modules/adslight/assets/images/img_cat/' + document.imcat.img.options[document.imcat.img.selectedIndex].value\n"; |
||
| 348 | echo "}\n\n"; |
||
| 349 | echo "//-->\n"; |
||
| 350 | echo "</script>\n"; |
||
| 351 | } |
||
| 352 | |||
| 353 | //Reusable Link Sorting Functions |
||
| 354 | |||
| 355 | /** |
||
| 356 | * @param $orderby |
||
| 357 | * |
||
| 358 | * @return string |
||
| 359 | */ |
||
| 360 | public static function convertOrderByIn($orderby) |
||
| 391 | } |
||
| 392 | |||
| 393 | /** |
||
| 394 | * @param $orderby |
||
| 395 | * |
||
| 396 | * @return string |
||
| 397 | */ |
||
| 398 | public static function convertOrderByTrans($orderby) |
||
| 399 | { |
||
| 400 | global $main_lang; |
||
| 401 | $orderbyTrans = ''; |
||
| 402 | if ('hits ASC' === $orderby) { |
||
| 403 | $orderbyTrans = '' . _ADSLIGHT_POPULARITYLTOM . ''; |
||
| 404 | } |
||
| 405 | if ('hits DESC' === $orderby) { |
||
| 406 | $orderbyTrans = '' . _ADSLIGHT_POPULARITYMTOL . ''; |
||
| 407 | } |
||
| 408 | if ('title ASC' === $orderby) { |
||
| 409 | $orderbyTrans = '' . _ADSLIGHT_TITLEATOZ . ''; |
||
| 410 | } |
||
| 411 | if ('title DESC' === $orderby) { |
||
| 412 | $orderbyTrans = '' . _ADSLIGHT_TITLEZTOA . ''; |
||
| 413 | } |
||
| 414 | if ('date ASC' === $orderby) { |
||
| 415 | $orderbyTrans = '' . _ADSLIGHT_DATEOLD . ''; |
||
| 416 | } |
||
| 417 | if ('date DESC' === $orderby) { |
||
| 418 | $orderbyTrans = '' . _ADSLIGHT_DATENEW . ''; |
||
| 419 | } |
||
| 420 | if ('price ASC' === $orderby) { |
||
| 421 | $orderbyTrans = _ADSLIGHT_PRICELTOH; |
||
| 422 | } |
||
| 423 | if ('price DESC' === $orderby) { |
||
| 424 | $orderbyTrans = '' . _ADSLIGHT_PRICEHTOL . ''; |
||
| 425 | } |
||
| 426 | |||
| 427 | return $orderbyTrans; |
||
| 428 | } |
||
| 429 | |||
| 430 | /** |
||
| 431 | * @param $orderby |
||
| 432 | * |
||
| 433 | * @return string |
||
| 434 | */ |
||
| 435 | public static function convertOrderByOut($orderby) |
||
| 436 | { |
||
| 437 | if ('title ASC' === $orderby) { |
||
| 438 | $orderby = 'titleA'; |
||
| 439 | } |
||
| 440 | if ('date ASC' === $orderby) { |
||
| 441 | $orderby = 'dateA'; |
||
| 442 | } |
||
| 443 | if ('hits ASC' === $orderby) { |
||
| 444 | $orderby = 'hitsA'; |
||
| 445 | } |
||
| 446 | if ('price ASC' === $orderby) { |
||
| 447 | $orderby = 'priceA'; |
||
| 448 | } |
||
| 449 | if ('title DESC' === $orderby) { |
||
| 450 | $orderby = 'titleD'; |
||
| 451 | } |
||
| 452 | if ('date DESC' === $orderby) { |
||
| 453 | $orderby = 'dateD'; |
||
| 454 | } |
||
| 455 | if ('hits DESC' === $orderby) { |
||
| 456 | $orderby = 'hitsD'; |
||
| 457 | } |
||
| 458 | if ('price DESC' === $orderby) { |
||
| 459 | $orderby = 'priceD'; |
||
| 460 | } |
||
| 461 | |||
| 462 | return $orderby; |
||
| 463 | } |
||
| 464 | |||
| 465 | /** |
||
| 466 | * @param string $caption |
||
| 467 | * @param string $name |
||
| 468 | * @param string $value |
||
| 469 | * @param string $width |
||
| 470 | * @param string $height |
||
| 471 | * @param string $supplemental |
||
| 472 | * |
||
| 473 | * @return XoopsFormDhtmlTextArea|\XoopsFormEditor |
||
| 474 | */ |
||
| 475 | public static function getEditor($caption, $name, $value = '', $width = '100%', $height = '300px', $supplemental = '') |
||
| 476 | { |
||
| 477 | global $xoopsModule; |
||
| 478 | $options = []; |
||
| 479 | $isAdmin = $GLOBALS['xoopsUser']->isAdmin($xoopsModule->getVar('mid')); |
||
| 480 | |||
| 481 | if (class_exists('XoopsFormEditor')) { |
||
| 482 | $options['name'] = $name; |
||
| 483 | $options['value'] = $value; |
||
| 484 | $options['rows'] = 20; |
||
| 485 | $options['cols'] = '100%'; |
||
| 486 | $options['width'] = $width; |
||
| 487 | $options['height'] = $height; |
||
| 488 | if ($isAdmin) { |
||
| 489 | $myEditor = new \XoopsFormEditor(ucfirst($name), $GLOBALS['xoopsModuleConfig']['adslightAdminUser'], $options, $nohtml = false, $onfailure = 'textarea'); |
||
| 490 | } else { |
||
| 491 | $myEditor = new \XoopsFormEditor(ucfirst($name), $GLOBALS['xoopsModuleConfig']['adslightEditorUser'], $options, $nohtml = false, $onfailure = 'textarea'); |
||
| 492 | } |
||
| 493 | } else { |
||
| 494 | $myEditor = new \XoopsFormDhtmlTextArea(ucfirst($name), $name, $value, '100%', '100%'); |
||
| 495 | } |
||
| 496 | |||
| 497 | // $form->addElement($descEditor); |
||
| 498 | |||
| 499 | return $myEditor; |
||
| 500 | } |
||
| 501 | |||
| 502 | /** |
||
| 503 | * @param $tablename |
||
| 504 | * |
||
| 505 | * @return bool |
||
| 506 | */ |
||
| 507 | public static function checkTableExists($tablename) |
||
| 508 | { |
||
| 509 | global $xoopsDB; |
||
| 510 | $result = $xoopsDB->queryF("SHOW TABLES LIKE '$tablename'"); |
||
| 511 | |||
| 512 | return ($xoopsDB->getRowsNum($result) > 0); |
||
| 513 | } |
||
| 514 | |||
| 515 | /** |
||
| 516 | * @param $fieldname |
||
| 517 | * @param $table |
||
| 518 | * |
||
| 519 | * @return bool |
||
| 520 | */ |
||
| 521 | public static function checkFieldExists($fieldname, $table) |
||
| 522 | { |
||
| 523 | global $xoopsDB; |
||
| 524 | $result = $xoopsDB->queryF("SHOW COLUMNS FROM $table LIKE '$fieldname'"); |
||
| 525 | |||
| 526 | return ($xoopsDB->getRowsNum($result) > 0); |
||
| 527 | } |
||
| 528 | |||
| 529 | /** |
||
| 530 | * @param $field |
||
| 531 | * @param $table |
||
| 532 | * |
||
| 533 | * @return mixed |
||
| 534 | */ |
||
| 535 | public static function addField($field, $table) |
||
| 541 | } |
||
| 542 | |||
| 543 | /** |
||
| 544 | * @param $cid |
||
| 545 | * |
||
| 546 | * @return bool |
||
| 547 | */ |
||
| 548 | public static function getCatNameFromId($cid) |
||
| 549 | { |
||
| 550 | global $xoopsDB, $xoopsConfig, $myts, $moduleDirName; |
||
| 551 | |||
| 552 | $sql = 'SELECT SQL_CACHE title FROM ' . $xoopsDB->prefix('adslight_categories') . " WHERE cid = '$cid'"; |
||
| 553 | |||
| 554 | if (!$result = $xoopsDB->query($sql)) { |
||
| 555 | return false; |
||
| 556 | } |
||
| 557 | |||
| 558 | if (!$arr = $xoopsDB->fetchArray($result)) { |
||
| 559 | return false; |
||
| 560 | } |
||
| 561 | |||
| 562 | $title = $arr['title']; |
||
| 563 | |||
| 564 | return $title; |
||
| 565 | } |
||
| 566 | |||
| 567 | /** |
||
| 568 | * @return mixed |
||
| 569 | */ |
||
| 570 | public static function goCategory() |
||
| 571 | { |
||
| 572 | global $xoopsDB; |
||
| 573 | |||
| 574 | $xt = new \XoopsTree($xoopsDB->prefix('adslight_categories'), 'cid', 'pid'); |
||
| 575 | $jump = XOOPS_URL . '/modules/adslight/viewcats.php?cid='; |
||
| 576 | ob_start(); |
||
| 577 | $xt->makeMySelBox('title', 'title', 0, 1, 'pid', 'location="' . $jump . '"+this.options[this.selectedIndex].value'); |
||
| 578 | $block['selectbox'] = ob_get_contents(); |
||
| 579 | ob_end_clean(); |
||
| 580 | |||
| 581 | return $block; |
||
| 582 | } |
||
| 583 | |||
| 584 | // ADSLIGHT Version 2 // |
||
| 585 | // Fonction rss.php RSS par categories |
||
| 586 | /** |
||
| 587 | * @return array |
||
| 588 | */ |
||
| 589 | public static function returnAllAdsRss() |
||
| 590 | { |
||
| 591 | global $xoopsDB; |
||
| 592 | |||
| 593 | $cid = Request::getInt('cid', null, 'GET'); |
||
| 594 | |||
| 595 | $result = []; |
||
| 596 | |||
| 597 | $sql = 'SELECT lid, title, price, date, town FROM ' . $xoopsDB->prefix('adslight_listing') . " WHERE valid='yes' AND cid=" . $xoopsDB->escape($cid) . ' ORDER BY date DESC'; |
||
| 598 | |||
| 599 | $resultValues = $xoopsDB->query($sql); |
||
| 600 | while (false !== ($resultTemp = $xoopsDB->fetchBoth($resultValues))) { |
||
| 601 | array_push($result, $resultTemp); |
||
| 602 | } |
||
| 603 | |||
| 604 | return $result; |
||
| 605 | } |
||
| 606 | |||
| 607 | // Fonction fluxrss.php RSS Global |
||
| 608 | |||
| 609 | /** |
||
| 610 | * @return array |
||
| 611 | */ |
||
| 612 | public static function returnAllAdsFluxRss() |
||
| 613 | { |
||
| 614 | global $xoopsDB; |
||
| 615 | |||
| 616 | $result = []; |
||
| 617 | |||
| 618 | $sql = 'SELECT lid, title, price, desctext, date, town FROM ' . $xoopsDB->prefix('adslight_listing') . " WHERE valid='yes' ORDER BY date DESC LIMIT 0,15"; |
||
| 619 | |||
| 620 | $resultValues = $xoopsDB->query($sql); |
||
| 621 | while (false !== ($resultTemp = $xoopsDB->fetchBoth($resultValues))) { |
||
| 622 | array_push($result, $resultTemp); |
||
| 623 | } |
||
| 624 | |||
| 625 | return $result; |
||
| 626 | } |
||
| 627 | |||
| 628 | /** |
||
| 629 | * @param $type |
||
| 630 | * |
||
| 631 | * @return mixed |
||
| 632 | */ |
||
| 633 | public static function getNameType($type) |
||
| 634 | { |
||
| 635 | global $xoopsDB; |
||
| 636 | $sql = $xoopsDB->query('SELECT nom_type FROM ' . $xoopsDB->prefix('adslight_type') . " WHERE id_type='" . $xoopsDB->escape($type) . "'"); |
||
| 637 | list($nom_type) = $xoopsDB->fetchRow($sql); |
||
| 638 | |||
| 639 | return $nom_type; |
||
| 640 | } |
||
| 641 | |||
| 642 | /** |
||
| 643 | * @param $format |
||
| 644 | * @param $number |
||
| 645 | * |
||
| 646 | * @return mixed |
||
| 647 | */ |
||
| 648 | public static function getMoneyFormat($format, $number) |
||
| 649 | { |
||
| 650 | $regex = '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?' . '(?:#([0-9]+))?(?:\.([0-9]+))?([in%])/'; |
||
| 651 | if ('C' === setlocale(LC_MONETARY, 0)) { |
||
| 652 | setlocale(LC_MONETARY, ''); |
||
| 653 | } |
||
| 654 | |||
| 655 | setlocale(LC_ALL, 'en_US'); |
||
| 656 | // setlocale(LC_ALL, 'fr_FR'); |
||
| 657 | |||
| 658 | $locale = localeconv(); |
||
| 659 | preg_match_all($regex, $format, $matches, PREG_SET_ORDER); |
||
| 660 | foreach ($matches as $fmatch) { |
||
| 661 | $value = (float)$number; |
||
| 662 | $flags = [ |
||
| 663 | 'fillchar' => preg_match('/\=(.)/', $fmatch[1], $match) ? $match[1] : ' ', |
||
| 664 | 'nogroup' => preg_match('/\^/', $fmatch[1]) > 0, |
||
| 665 | 'usesignal' => preg_match('/\+|\(/', $fmatch[1], $match) ? $match[0] : '+', |
||
| 666 | 'nosimbol' => preg_match('/\!/', $fmatch[1]) > 0, |
||
| 667 | 'isleft' => preg_match('/\-/', $fmatch[1]) > 0 |
||
| 668 | ]; |
||
| 669 | $width = trim($fmatch[2]) ? (int)$fmatch[2] : 0; |
||
| 670 | $left = trim($fmatch[3]) ? (int)$fmatch[3] : 0; |
||
| 671 | $right = trim($fmatch[4]) ? (int)$fmatch[4] : $locale['int_frac_digits']; |
||
| 672 | $conversion = $fmatch[5]; |
||
| 673 | |||
| 674 | $positive = true; |
||
| 675 | if ($value < 0) { |
||
| 676 | $positive = false; |
||
| 677 | $value *= -1; |
||
| 678 | } |
||
| 679 | $letter = $positive ? 'p' : 'n'; |
||
| 680 | |||
| 681 | $prefix = $suffix = $cprefix = $csuffix = $signal = ''; |
||
| 682 | |||
| 683 | $signal = $positive ? $locale['positive_sign'] : $locale['negative_sign']; |
||
| 684 | switch (true) { |
||
| 685 | case 1 == $locale["{$letter}_sign_posn"] |
||
| 686 | && '+' == $flags['usesignal']: |
||
| 687 | $prefix = $signal; |
||
| 688 | break; |
||
| 689 | case 2 == $locale["{$letter}_sign_posn"] |
||
| 690 | && '+' == $flags['usesignal']: |
||
| 691 | $suffix = $signal; |
||
| 692 | break; |
||
| 693 | case 3 == $locale["{$letter}_sign_posn"] |
||
| 694 | && '+' == $flags['usesignal']: |
||
| 695 | $cprefix = $signal; |
||
| 696 | break; |
||
| 697 | case 4 == $locale["{$letter}_sign_posn"] |
||
| 698 | && '+' == $flags['usesignal']: |
||
| 699 | $csuffix = $signal; |
||
| 700 | break; |
||
| 701 | case '(' === $flags['usesignal']: |
||
| 702 | case 0 == $locale["{$letter}_sign_posn"]: |
||
| 703 | $prefix = '('; |
||
| 704 | $suffix = ')'; |
||
| 705 | break; |
||
| 706 | } |
||
| 707 | if (!$flags['nosimbol']) { |
||
| 708 | $currency = $cprefix . ('i' === $conversion ? $locale['int_curr_symbol'] : $locale['currency_symbol']) . $csuffix; |
||
| 709 | } else { |
||
| 710 | $currency = ''; |
||
| 711 | } |
||
| 712 | $space = $locale["{$letter}_sep_by_space"] ? ' ' : ''; |
||
| 713 | |||
| 714 | $value = number_format($value, $right, $locale['mon_decimal_point'], $flags['nogroup'] ? '' : $locale['mon_thousands_sep']); |
||
| 715 | $value = @explode($locale['mon_decimal_point'], $value); |
||
| 716 | |||
| 717 | $n = strlen($prefix) + strlen($currency) + strlen($value[0]); |
||
| 718 | if ($left > 0 && $left > $n) { |
||
| 719 | $value[0] = str_repeat($flags['fillchar'], $left - $n) . $value[0]; |
||
| 720 | } |
||
| 721 | $value = implode($locale['mon_decimal_point'], $value); |
||
| 722 | if ($locale["{$letter}_cs_precedes"]) { |
||
| 723 | $value = $prefix . $currency . $space . $value . $suffix; |
||
| 724 | } else { |
||
| 725 | $value = $prefix . $value . $space . $currency . $suffix; |
||
| 726 | } |
||
| 727 | if ($width > 0) { |
||
| 728 | $value = str_pad($value, $width, $flags['fillchar'], $flags['isleft'] ? STR_PAD_RIGHT : STR_PAD_LEFT); |
||
| 729 | } |
||
| 730 | |||
| 731 | $format = str_replace($fmatch[0], $value, $format); |
||
| 732 | } |
||
| 733 | |||
| 734 | return $format; |
||
| 735 | } |
||
| 736 | |||
| 737 | /** |
||
| 738 | * Saves permissions for the selected category |
||
| 739 | * |
||
| 740 | * saveCategory_Permissions() |
||
| 741 | * |
||
| 742 | * @param array $groups : group with granted permission |
||
| 743 | * @param integer $categoryid : categoryid on which we are setting permissions |
||
| 744 | * @param string $perm_name : name of the permission |
||
| 745 | * @return boolean : TRUE if the no errors occured |
||
| 746 | */ |
||
| 747 | |||
| 748 | public static function saveCategoryPermissions($groups, $categoryId, $permName) |
||
| 774 | } |
||
| 775 | } |
||
| 776 |
Loading history...
The PSR-1: Basic Coding Standard recommends that a file should either introduce new symbols, that is classes, functions, constants or similar, or have side effects. Side effects are anything that executes logic, like for example printing output, changing ini settings or writing to a file.
The idea behind this recommendation is that merely auto-loading a class should not change the state of an application. It also promotes a cleaner style of programming and makes your code less prone to errors, because the logic is not spread out all over the place.
To learn more about the PSR-1, please see the PHP-FIG site on the PSR-1.