| [ Index ] |
PHP Cross Reference of MyBB 1.8.38 |
[Summary view] [Print] [Text view]
1 <?php 2 /** 3 * MyBB 1.8 4 * Copyright 2014 MyBB Group, All Rights Reserved 5 * 6 * Website: http://www.mybb.com 7 * License: http://www.mybb.com/about/license 8 * 9 */ 10 11 class datacache 12 { 13 /** 14 * Cache contents. 15 * 16 * @var array 17 */ 18 public $cache = array(); 19 20 /** 21 * The current cache handler we're using 22 * 23 * @var CacheHandlerInterface 24 */ 25 public $handler = null; 26 27 /** 28 * A count of the number of calls. 29 * 30 * @var int 31 */ 32 public $call_count = 0; 33 34 /** 35 * A list of the performed calls. 36 * 37 * @var array 38 */ 39 public $calllist = array(); 40 41 /** 42 * The time spent on cache operations 43 * 44 * @var float 45 */ 46 public $call_time = 0; 47 48 /** 49 * Explanation of a cache call. 50 * 51 * @var string 52 */ 53 public $cache_debug; 54 55 /** 56 * @var array 57 */ 58 public $moderators; 59 60 /** 61 * @var array 62 */ 63 public $built_moderators; 64 65 /** 66 * @var array 67 */ 68 public $moderators_forum_cache; 69 70 /** 71 * Build cache data. 72 * 73 */ 74 function cache() 75 { 76 global $db, $mybb; 77 78 require_once MYBB_ROOT."/inc/cachehandlers/interface.php"; 79 80 switch($mybb->config['cache_store']) 81 { 82 // Disk cache 83 case "files": 84 require_once MYBB_ROOT."/inc/cachehandlers/disk.php"; 85 $this->handler = new diskCacheHandler(); 86 break; 87 // Memcache cache 88 case "memcache": 89 require_once MYBB_ROOT."/inc/cachehandlers/memcache.php"; 90 $this->handler = new memcacheCacheHandler(); 91 break; 92 // Memcached cache 93 case "memcached": 94 require_once MYBB_ROOT."/inc/cachehandlers/memcached.php"; 95 $this->handler = new memcachedCacheHandler(); 96 break; 97 // eAccelerator cache 98 case "eaccelerator": 99 require_once MYBB_ROOT."/inc/cachehandlers/eaccelerator.php"; 100 $this->handler = new eacceleratorCacheHandler(); 101 break; 102 // Xcache cache 103 case "xcache": 104 require_once MYBB_ROOT."/inc/cachehandlers/xcache.php"; 105 $this->handler = new xcacheCacheHandler(); 106 break; 107 // APC cache 108 case "apc": 109 require_once MYBB_ROOT."/inc/cachehandlers/apc.php"; 110 $this->handler = new apcCacheHandler(); 111 break; 112 // APCu cache 113 case "apcu": 114 require_once MYBB_ROOT."/inc/cachehandlers/apcu.php"; 115 $this->handler = new apcuCacheHandler(); 116 break; 117 // Redis cache 118 case "redis": 119 require_once MYBB_ROOT."/inc/cachehandlers/redis.php"; 120 $this->handler = new redisCacheHandler(); 121 break; 122 } 123 124 if($this->handler instanceof CacheHandlerInterface) 125 { 126 if(!$this->handler->connect()) 127 { 128 $this->handler = null; 129 } 130 } 131 else 132 { 133 // Database cache 134 $query = $db->simple_select("datacache", "title,cache"); 135 while($data = $db->fetch_array($query)) 136 { 137 // use native_unserialize() over my_unserialize() for performance reasons 138 $this->cache[$data['title']] = native_unserialize($data['cache']); 139 } 140 } 141 } 142 143 /** 144 * Read cache from files or db. 145 * 146 * @param string $name The cache component to read. 147 * @param boolean $hard If true, cannot be overwritten during script execution. 148 * @return mixed 149 */ 150 function read($name, $hard=false) 151 { 152 global $db, $mybb; 153 154 // Already have this cache and we're not doing a hard refresh? Return cached copy 155 if(isset($this->cache[$name]) && $hard == false) 156 { 157 return $this->cache[$name]; 158 } 159 // If we're not hard refreshing, and this cache doesn't exist, return false 160 // It would have been loaded pre-global if it did exist anyway... 161 else if($hard == false && !($this->handler instanceof CacheHandlerInterface)) 162 { 163 return false; 164 } 165 166 if($this->handler instanceof CacheHandlerInterface) 167 { 168 get_execution_time(); 169 170 $data = $this->handler->fetch($name); 171 172 $call_time = get_execution_time(); 173 $this->call_time += $call_time; 174 $this->call_count++; 175 176 if($mybb->debug_mode) 177 { 178 $hit = true; 179 if($data === false) 180 { 181 $hit = false; 182 } 183 $this->debug_call('read:'.$name, $call_time, $hit); 184 } 185 186 // No data returned - cache gone bad? 187 if($data === false) 188 { 189 // Fetch from database 190 $query = $db->simple_select("datacache", "title,cache", "title='".$db->escape_string($name)."'"); 191 $cache_data = $db->fetch_array($query); 192 193 if($cache_data) 194 { 195 // use native_unserialize() over my_unserialize() for performance reasons 196 $data = native_unserialize($cache_data['cache']); 197 198 // Update cache for handler 199 get_execution_time(); 200 201 $hit = $this->handler->put($name, $data); 202 203 $call_time = get_execution_time(); 204 $this->call_time += $call_time; 205 $this->call_count++; 206 207 if($mybb->debug_mode) 208 { 209 $this->debug_call('set:'.$name, $call_time, $hit); 210 } 211 } 212 else 213 { 214 $data = false; 215 } 216 } 217 } 218 // Else, using internal database cache 219 else 220 { 221 $query = $db->simple_select("datacache", "title,cache", "title='$name'"); 222 $cache_data = $db->fetch_array($query); 223 224 if(empty($cache_data['title'])) 225 { 226 $data = false; 227 } 228 else 229 { 230 // use native_unserialize() over my_unserialize() for performance reasons 231 $data = native_unserialize($cache_data['cache']); 232 } 233 } 234 235 // Cache locally 236 $this->cache[$name] = $data; 237 238 if($data !== false) 239 { 240 return $data; 241 } 242 else 243 { 244 return false; 245 } 246 } 247 248 /** 249 * Update cache contents. 250 * 251 * @param string $name The cache content identifier. 252 * @param mixed $contents The cache content. 253 */ 254 function update($name, $contents) 255 { 256 global $db, $mybb; 257 258 $this->cache[$name] = $contents; 259 260 // We ALWAYS keep a running copy in the db just incase we need it 261 $dbcontents = $db->escape_string(my_serialize($contents)); 262 263 $replace_array = array( 264 "title" => $db->escape_string($name), 265 "cache" => $dbcontents 266 ); 267 $db->replace_query("datacache", $replace_array, "", false); 268 269 // Do we have a cache handler we're using? 270 if($this->handler instanceof CacheHandlerInterface) 271 { 272 get_execution_time(); 273 274 $hit = $this->handler->put($name, $contents); 275 276 $call_time = get_execution_time(); 277 $this->call_time += $call_time; 278 $this->call_count++; 279 280 if($mybb->debug_mode) 281 { 282 $this->debug_call('update:'.$name, $call_time, $hit); 283 } 284 } 285 } 286 287 /** 288 * Delete cache contents. 289 * Originally from frostschutz's PluginLibrary 290 * github.com/frostschutz 291 * 292 * @param string $name Cache name or title 293 * @param boolean $greedy To delete a cache starting with name_ 294 */ 295 function delete($name, $greedy = false) 296 { 297 global $db, $mybb, $cache; 298 299 // Prepare for database query. 300 $dbname = $db->escape_string($name); 301 $where = "title = '{$dbname}'"; 302 303 // Delete on-demand or handler cache 304 if($this->handler instanceof CacheHandlerInterface) 305 { 306 get_execution_time(); 307 308 $hit = $this->handler->delete($name); 309 310 $call_time = get_execution_time(); 311 $this->call_time += $call_time; 312 $this->call_count++; 313 314 if($mybb->debug_mode) 315 { 316 $this->debug_call('delete:'.$name, $call_time, $hit); 317 } 318 } 319 320 // Greedy? 321 if($greedy) 322 { 323 $name .= '_'; 324 $names = array(); 325 $keys = array_keys($cache->cache); 326 327 foreach($keys as $key) 328 { 329 if(strpos($key, $name) === 0) 330 { 331 $names[$key] = 0; 332 } 333 } 334 335 $ldbname = strtr($dbname, 336 array( 337 '%' => '=%', 338 '=' => '==', 339 '_' => '=_' 340 ) 341 ); 342 343 $where .= " OR title LIKE '{$ldbname}=_%' ESCAPE '='"; 344 345 if($this->handler instanceof CacheHandlerInterface) 346 { 347 $query = $db->simple_select("datacache", "title", $where); 348 349 while($row = $db->fetch_array($query)) 350 { 351 $names[$row['title']] = 0; 352 } 353 354 // ...from the filesystem... 355 $start = strlen(MYBB_ROOT."cache/"); 356 foreach((array)@glob(MYBB_ROOT."cache/{$name}*.php") as $filename) 357 { 358 if($filename) 359 { 360 $filename = substr($filename, $start, strlen($filename)-4-$start); 361 $names[$filename] = 0; 362 } 363 } 364 365 foreach($names as $key => $val) 366 { 367 get_execution_time(); 368 369 $hit = $this->handler->delete($key); 370 371 $call_time = get_execution_time(); 372 $this->call_time += $call_time; 373 $this->call_count++; 374 375 if($mybb->debug_mode) 376 { 377 $this->debug_call('delete:'.$name, $call_time, $hit); 378 } 379 } 380 } 381 } 382 383 // Delete database cache 384 $db->delete_query("datacache", $where); 385 } 386 387 /** 388 * Debug a cache call to a non-database cache handler 389 * 390 * @param string $string The cache key 391 * @param string $qtime The time it took to perform the call. 392 * @param boolean $hit Hit or miss status 393 */ 394 function debug_call($string, $qtime, $hit) 395 { 396 global $mybb, $plugins; 397 398 $debug_extra = ''; 399 if($plugins->current_hook) 400 { 401 $debug_extra = "<div style=\"float_right\">(Plugin Hook: {$plugins->current_hook})</div>"; 402 } 403 404 if($hit) 405 { 406 $hit_status = 'HIT'; 407 } 408 else 409 { 410 $hit_status = 'MISS'; 411 } 412 413 $cache_data = explode(':', $string); 414 $cache_method = $cache_data[0]; 415 $cache_key = $cache_data[1]; 416 417 $this->cache_debug = "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\"> 418 <tr> 419 <td style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#{$this->call_count} - ".ucfirst($cache_method)." Call</strong></div></td> 420 </tr> 421 <tr style=\"background-color: #fefefe;\"> 422 <td><span style=\"font-family: Courier; font-size: 14px;\">({$mybb->config['cache_store']}) [{$hit_status}] ".htmlspecialchars_uni($cache_key)."</span></td> 423 </tr> 424 <tr> 425 <td bgcolor=\"#ffffff\">Call Time: ".format_time_duration($qtime)."</td> 426 </tr> 427 </table> 428 <br />\n"; 429 430 $this->calllist[$this->call_count]['key'] = $string; 431 $this->calllist[$this->call_count]['time'] = $qtime; 432 } 433 434 /** 435 * Select the size of the cache 436 * 437 * @param string $name The name of the cache 438 * @return integer the size of the cache 439 */ 440 function size_of($name='') 441 { 442 global $db; 443 444 if($this->handler instanceof CacheHandlerInterface) 445 { 446 $size = $this->handler->size_of($name); 447 if(!$size) 448 { 449 if($name) 450 { 451 $query = $db->simple_select("datacache", "cache", "title='{$name}'"); 452 return strlen($db->fetch_field($query, "cache")); 453 } 454 else 455 { 456 return $db->fetch_size("datacache"); 457 } 458 } 459 else 460 { 461 return $size; 462 } 463 } 464 // Using MySQL as cache 465 else 466 { 467 if($name) 468 { 469 $query = $db->simple_select("datacache", "cache", "title='{$name}'"); 470 return strlen($db->fetch_field($query, "cache")); 471 } 472 else 473 { 474 return $db->fetch_size("datacache"); 475 } 476 } 477 } 478 479 /** 480 * Update the MyBB version in the cache. 481 * 482 */ 483 function update_version() 484 { 485 global $mybb; 486 487 $version = array( 488 "version" => $mybb->version, 489 "version_code" => $mybb->version_code 490 ); 491 492 $this->update("version", $version); 493 } 494 495 /** 496 * Update the attachment type cache. 497 * 498 */ 499 function update_attachtypes() 500 { 501 global $db; 502 503 $types = array(); 504 505 $query = $db->simple_select('attachtypes', '*', 'enabled=1'); 506 while($type = $db->fetch_array($query)) 507 { 508 $type['extension'] = my_strtolower($type['extension']); 509 $types[$type['extension']] = $type; 510 } 511 512 $this->update("attachtypes", $types); 513 } 514 515 /** 516 * Update the smilies cache. 517 * 518 */ 519 function update_smilies() 520 { 521 global $db; 522 523 $smilies = array(); 524 525 $query = $db->simple_select("smilies", "*", "", array('order_by' => 'disporder', 'order_dir' => 'ASC')); 526 while($smilie = $db->fetch_array($query)) 527 { 528 $smilies[$smilie['sid']] = $smilie; 529 } 530 531 $this->update("smilies", $smilies); 532 } 533 534 /** 535 * Update the posticon cache. 536 * 537 */ 538 function update_posticons() 539 { 540 global $db; 541 542 $icons = array(); 543 544 $query = $db->simple_select("icons", "iid, name, path"); 545 while($icon = $db->fetch_array($query)) 546 { 547 $icons[$icon['iid']] = $icon; 548 } 549 550 $this->update("posticons", $icons); 551 } 552 553 /** 554 * Update the badwords cache. 555 * 556 */ 557 function update_badwords() 558 { 559 global $db; 560 561 $badwords = array(); 562 563 $query = $db->simple_select("badwords", "*"); 564 while($badword = $db->fetch_array($query)) 565 { 566 $badwords[$badword['bid']] = $badword; 567 } 568 569 $this->update("badwords", $badwords); 570 } 571 572 /** 573 * Update the usergroups cache. 574 * 575 */ 576 function update_usergroups() 577 { 578 global $db; 579 580 $query = $db->simple_select("usergroups"); 581 582 $gs = array(); 583 while($g = $db->fetch_array($query)) 584 { 585 $gs[$g['gid']] = $g; 586 } 587 588 $this->update("usergroups", $gs); 589 } 590 591 /** 592 * Update the forum permissions cache. 593 * 594 * @return bool When failed, returns false. 595 */ 596 function update_forumpermissions() 597 { 598 global $forum_cache, $db; 599 600 $this->forum_permissions = $this->built_forum_permissions = array(0); 601 602 // Get our forum list 603 cache_forums(true); 604 if(!is_array($forum_cache)) 605 { 606 return false; 607 } 608 609 reset($forum_cache); 610 $fcache = array(); 611 612 // Resort in to the structure we require 613 foreach($forum_cache as $fid => $forum) 614 { 615 $this->forum_permissions_forum_cache[$forum['pid']][$forum['disporder']][$forum['fid']] = $forum; 616 } 617 618 // Sort children 619 foreach($fcache as $pid => $value) 620 { 621 ksort($fcache[$pid]); 622 } 623 ksort($fcache); 624 625 // Fetch forum permissions from the database 626 $query = $db->simple_select("forumpermissions"); 627 while($forum_permission = $db->fetch_array($query)) 628 { 629 $this->forum_permissions[$forum_permission['fid']][$forum_permission['gid']] = $forum_permission; 630 } 631 632 $this->build_forum_permissions(); 633 $this->update("forumpermissions", $this->built_forum_permissions); 634 635 return true; 636 } 637 638 /** 639 * Build the forum permissions array 640 * 641 * @access private 642 * @param array $permissions An optional permissions array. 643 * @param int $pid An optional permission id. 644 */ 645 private function build_forum_permissions($permissions=array(), $pid=0) 646 { 647 $usergroups = array_keys($this->read("usergroups", true)); 648 if(!empty($this->forum_permissions_forum_cache[$pid])) 649 { 650 foreach($this->forum_permissions_forum_cache[$pid] as $main) 651 { 652 foreach($main as $forum) 653 { 654 $perms = $permissions; 655 foreach($usergroups as $gid) 656 { 657 if(isset($this->forum_permissions[$forum['fid']][$gid]) && $this->forum_permissions[$forum['fid']][$gid]) 658 { 659 $perms[$gid] = $this->forum_permissions[$forum['fid']][$gid]; 660 } 661 if(!empty($perms[$gid])) 662 { 663 $perms[$gid]['fid'] = $forum['fid']; 664 $this->built_forum_permissions[$forum['fid']][$gid] = $perms[$gid]; 665 } 666 } 667 $this->build_forum_permissions($perms, $forum['fid']); 668 } 669 } 670 } 671 } 672 673 /** 674 * Update the stats cache (kept for the sake of being able to rebuild this cache via the cache interface) 675 * 676 */ 677 function update_stats() 678 { 679 require_once MYBB_ROOT."inc/functions_rebuild.php"; 680 rebuild_stats(); 681 } 682 683 /** 684 * Update the statistics cache 685 * 686 */ 687 function update_statistics() 688 { 689 global $db; 690 691 $query = $db->simple_select('users', 'uid, username, referrals', 'referrals>0', array('order_by' => 'referrals', 'order_dir' => 'DESC', 'limit' => 1)); 692 $topreferrer = $db->fetch_array($query); 693 694 $timesearch = TIME_NOW - 86400; 695 696 $query = $db->query(" 697 SELECT u.uid, u.username, COUNT(*) AS poststoday 698 FROM {$db->table_prefix}posts p 699 LEFT JOIN {$db->table_prefix}users u ON (p.uid=u.uid) 700 WHERE p.dateline > {$timesearch} AND p.visible=1 701 GROUP BY u.uid, u.username 702 ORDER BY poststoday DESC 703 "); 704 705 $most_posts = 0; 706 $topposter = array(); 707 while($user = $db->fetch_array($query)) 708 { 709 if($user['poststoday'] > $most_posts) 710 { 711 $most_posts = $user['poststoday']; 712 $topposter = $user; 713 } 714 } 715 716 $query = $db->simple_select('users', 'COUNT(uid) AS posters', 'postnum>0'); 717 $posters = $db->fetch_field($query, 'posters'); 718 719 $statistics = array( 720 'time' => TIME_NOW, 721 'top_referrer' => (array)$topreferrer, 722 'top_poster' => (array)$topposter, 723 'posters' => $posters 724 ); 725 726 $this->update('statistics', $statistics); 727 } 728 729 /** 730 * Update the moderators cache. 731 * 732 * @return bool Returns false on failure 733 */ 734 function update_moderators() 735 { 736 global $forum_cache, $db; 737 738 $this->built_moderators = array(0); 739 740 // Get our forum list 741 cache_forums(true); 742 if(!is_array($forum_cache)) 743 { 744 return false; 745 } 746 747 reset($forum_cache); 748 $fcache = array(); 749 750 // Resort in to the structure we require 751 foreach($forum_cache as $fid => $forum) 752 { 753 $this->moderators_forum_cache[$forum['pid']][$forum['disporder']][$forum['fid']] = $forum; 754 } 755 756 // Sort children 757 foreach($fcache as $pid => $value) 758 { 759 ksort($fcache[$pid]); 760 } 761 ksort($fcache); 762 763 $this->moderators = array(); 764 765 // Fetch moderators from the database 766 $query = $db->query(" 767 SELECT m.*, u.username, u.usergroup, u.displaygroup 768 FROM ".TABLE_PREFIX."moderators m 769 LEFT JOIN ".TABLE_PREFIX."users u ON (m.id=u.uid) 770 WHERE m.isgroup = '0' 771 ORDER BY u.username 772 "); 773 while($moderator = $db->fetch_array($query)) 774 { 775 $this->moderators[$moderator['fid']]['users'][$moderator['id']] = $moderator; 776 } 777 778 if(!function_exists("sort_moderators_by_usernames")) 779 { 780 function sort_moderators_by_usernames($a, $b) 781 { 782 return strcasecmp($a['username'], $b['username']); 783 } 784 } 785 786 //Fetch moderating usergroups from the database 787 $query = $db->query(" 788 SELECT m.*, u.title 789 FROM ".TABLE_PREFIX."moderators m 790 LEFT JOIN ".TABLE_PREFIX."usergroups u ON (m.id=u.gid) 791 WHERE m.isgroup = '1' 792 ORDER BY u.title 793 "); 794 while($moderator = $db->fetch_array($query)) 795 { 796 $this->moderators[$moderator['fid']]['usergroups'][$moderator['id']] = $moderator; 797 } 798 799 foreach(array_keys($this->moderators) as $fid) 800 { 801 if(isset($this->moderators[$fid]['users'])) 802 { 803 uasort($this->moderators[$fid]['users'], 'sort_moderators_by_usernames'); 804 } 805 } 806 807 $this->build_moderators(); 808 809 $this->update("moderators", $this->built_moderators); 810 811 return true; 812 } 813 814 /** 815 * Update the users awaiting activation cache. 816 * 817 */ 818 function update_awaitingactivation() 819 { 820 global $db; 821 822 $query = $db->simple_select('users', 'COUNT(uid) AS awaitingusers', 'usergroup=\'5\''); 823 $awaitingusers = (int)$db->fetch_field($query, 'awaitingusers'); 824 825 $data = array( 826 'users' => $awaitingusers, 827 'time' => TIME_NOW 828 ); 829 830 $this->update('awaitingactivation', $data); 831 } 832 833 /** 834 * Build the moderators array 835 * 836 * @access private 837 * @param array $moderators An optional moderators array (moderators of the parent forum for example). 838 * @param int $pid An optional parent ID. 839 */ 840 private function build_moderators($moderators=array(), $pid=0) 841 { 842 if(isset($this->moderators_forum_cache[$pid])) 843 { 844 foreach($this->moderators_forum_cache[$pid] as $main) 845 { 846 foreach($main as $forum) 847 { 848 $forum_mods = array(); 849 if(count($moderators)) 850 { 851 $forum_mods = $moderators; 852 } 853 // Append - local settings override that of a parent - array_merge works here 854 if(isset($this->moderators[$forum['fid']])) 855 { 856 if(is_array($forum_mods) && count($forum_mods)) 857 { 858 $forum_mods = array_merge($forum_mods, $this->moderators[$forum['fid']]); 859 } 860 else 861 { 862 $forum_mods = $this->moderators[$forum['fid']]; 863 } 864 } 865 $this->built_moderators[$forum['fid']] = $forum_mods; 866 $this->build_moderators($forum_mods, $forum['fid']); 867 } 868 } 869 } 870 } 871 872 /** 873 * Update the forums cache. 874 * 875 */ 876 function update_forums() 877 { 878 global $db; 879 880 $forums = array(); 881 882 // Things we don't want to cache 883 $exclude = array("unapprovedthreads", "unapprovedposts", "threads", "posts", "lastpost", "lastposter", "lastposttid", "lastposteruid", "lastpostsubject", "deletedthreads", "deletedposts"); 884 885 $query = $db->simple_select("forums", "*", "", array('order_by' => 'pid,disporder')); 886 while($forum = $db->fetch_array($query)) 887 { 888 foreach($forum as $key => $val) 889 { 890 if(in_array($key, $exclude)) 891 { 892 unset($forum[$key]); 893 } 894 } 895 $forums[$forum['fid']] = $forum; 896 } 897 898 $this->update("forums", $forums); 899 } 900 901 /** 902 * Update usertitles cache. 903 * 904 */ 905 function update_usertitles() 906 { 907 global $db; 908 909 $usertitles = array(); 910 $query = $db->simple_select("usertitles", "utid, posts, title, stars, starimage", "", array('order_by' => 'posts', 'order_dir' => 'DESC')); 911 while($usertitle = $db->fetch_array($query)) 912 { 913 $usertitles[] = $usertitle; 914 } 915 916 $this->update("usertitles", $usertitles); 917 } 918 919 /** 920 * Update reported content cache. 921 * 922 */ 923 function update_reportedcontent() 924 { 925 global $db; 926 927 $query = $db->simple_select("reportedcontent", "COUNT(rid) AS unreadcount", "reportstatus='0'"); 928 $unreadcount = $db->fetch_field($query, 'unreadcount'); 929 930 $query = $db->simple_select("reportedcontent", "COUNT(rid) AS reportcount"); 931 $reportcount = $db->fetch_field($query, 'reportcount'); 932 933 $query = $db->simple_select("reportedcontent", "dateline", "reportstatus='0'", array('order_by' => 'dateline', 'order_dir' => 'DESC', 'limit' => 1)); 934 $dateline = $db->fetch_field($query, 'dateline'); 935 936 $reports = array( 937 'unread' => $unreadcount, 938 'total' => $reportcount, 939 'lastdateline' => $dateline, 940 ); 941 942 $this->update("reportedcontent", $reports); 943 } 944 945 /** 946 * Update mycode cache. 947 * 948 */ 949 function update_mycode() 950 { 951 global $db; 952 953 $mycodes = array(); 954 $query = $db->simple_select("mycode", "regex, replacement", "active=1", array('order_by' => 'parseorder')); 955 while($mycode = $db->fetch_array($query)) 956 { 957 $mycodes[] = $mycode; 958 } 959 960 $this->update("mycode", $mycodes); 961 } 962 963 /** 964 * Update the mailqueue cache 965 * 966 * @param int $last_run 967 * @param int $lock_time 968 */ 969 function update_mailqueue($last_run=0, $lock_time=0) 970 { 971 global $db; 972 973 $query = $db->simple_select("mailqueue", "COUNT(*) AS queue_size"); 974 $queue_size = $db->fetch_field($query, "queue_size"); 975 976 $mailqueue = $this->read("mailqueue"); 977 if(!is_array($mailqueue)) 978 { 979 $mailqueue = array(); 980 } 981 $mailqueue['queue_size'] = $queue_size; 982 if($last_run > 0) 983 { 984 $mailqueue['last_run'] = $last_run; 985 } 986 $mailqueue['locked'] = $lock_time; 987 988 $this->update("mailqueue", $mailqueue); 989 } 990 991 /** 992 * Update update_check cache (dummy function used by upgrade/install scripts) 993 */ 994 function update_update_check() 995 { 996 $update_cache = array( 997 "dateline" => TIME_NOW 998 ); 999 1000 $this->update("update_check", $update_cache); 1001 } 1002 1003 /** 1004 * Update default_theme cache 1005 */ 1006 function update_default_theme() 1007 { 1008 global $db; 1009 1010 $query = $db->simple_select("themes", "name, tid, properties, stylesheets", "def='1'", array('limit' => 1)); 1011 $theme = $db->fetch_array($query); 1012 $this->update("default_theme", $theme); 1013 } 1014 1015 /** 1016 * Updates the tasks cache saving the next run time 1017 */ 1018 function update_tasks() 1019 { 1020 global $db; 1021 1022 $query = $db->simple_select("tasks", "nextrun", "enabled=1", array("order_by" => "nextrun", "order_dir" => "asc", "limit" => 1)); 1023 $next_task = $db->fetch_array($query); 1024 1025 $task_cache = $this->read("tasks"); 1026 if(!is_array($task_cache)) 1027 { 1028 $task_cache = array(); 1029 } 1030 $task_cache['nextrun'] = $next_task['nextrun']; 1031 1032 if(!$task_cache['nextrun']) 1033 { 1034 $task_cache['nextrun'] = TIME_NOW+3600; 1035 } 1036 1037 $this->update("tasks", $task_cache); 1038 } 1039 1040 /** 1041 * Updates the banned IPs cache 1042 */ 1043 function update_bannedips() 1044 { 1045 global $db; 1046 1047 $banned_ips = array(); 1048 $query = $db->simple_select("banfilters", "fid,filter", "type=1"); 1049 while($banned_ip = $db->fetch_array($query)) 1050 { 1051 $banned_ips[$banned_ip['fid']] = $banned_ip; 1052 } 1053 $this->update("bannedips", $banned_ips); 1054 } 1055 1056 /** 1057 * Updates the banned emails cache 1058 */ 1059 function update_bannedemails() 1060 { 1061 global $db; 1062 1063 $banned_emails = array(); 1064 $query = $db->simple_select("banfilters", "fid, filter", "type = '3'"); 1065 1066 while($banned_email = $db->fetch_array($query)) 1067 { 1068 $banned_emails[$banned_email['fid']] = $banned_email; 1069 } 1070 1071 $this->update("bannedemails", $banned_emails); 1072 } 1073 1074 /** 1075 * Updates the search engine spiders cache 1076 */ 1077 function update_spiders() 1078 { 1079 global $db; 1080 1081 $spiders = array(); 1082 $query = $db->simple_select("spiders", "sid, name, useragent, usergroup", "", array("order_by" => "LENGTH(useragent)", "order_dir" => "DESC")); 1083 while($spider = $db->fetch_array($query)) 1084 { 1085 $spiders[$spider['sid']] = $spider; 1086 } 1087 $this->update("spiders", $spiders); 1088 } 1089 1090 function update_most_replied_threads() 1091 { 1092 global $db, $mybb; 1093 1094 $threads = array(); 1095 1096 $query = $db->simple_select("threads", "tid, subject, replies, fid, uid", "visible='1'", array('order_by' => 'replies', 'order_dir' => 'DESC', 'limit_start' => 0, 'limit' => $mybb->settings['statslimit'])); 1097 while($thread = $db->fetch_array($query)) 1098 { 1099 $threads[] = $thread; 1100 } 1101 1102 $this->update("most_replied_threads", $threads); 1103 } 1104 1105 function update_most_viewed_threads() 1106 { 1107 global $db, $mybb; 1108 1109 $threads = array(); 1110 1111 $query = $db->simple_select("threads", "tid, subject, views, fid, uid", "visible='1'", array('order_by' => 'views', 'order_dir' => 'DESC', 'limit_start' => 0, 'limit' => $mybb->settings['statslimit'])); 1112 while($thread = $db->fetch_array($query)) 1113 { 1114 $threads[] = $thread; 1115 } 1116 1117 $this->update("most_viewed_threads", $threads); 1118 } 1119 1120 /** 1121 * @deprecated 1122 */ 1123 function update_banned() 1124 { 1125 // "banned" cache removed 1126 } 1127 1128 function update_birthdays() 1129 { 1130 global $db; 1131 1132 $birthdays = array(); 1133 1134 // Get today, yesterday, and tomorrow's time (for different timezones) 1135 $bdaytime = TIME_NOW; 1136 $bdaydate = my_date("j-n", $bdaytime, '', 0); 1137 $bdaydatetomorrow = my_date("j-n", ($bdaytime+86400), '', 0); 1138 $bdaydateyesterday = my_date("j-n", ($bdaytime-86400), '', 0); 1139 1140 $query = $db->simple_select("users", "uid, username, usergroup, displaygroup, birthday, birthdayprivacy", "birthday LIKE '$bdaydate-%' OR birthday LIKE '$bdaydateyesterday-%' OR birthday LIKE '$bdaydatetomorrow-%'"); 1141 while($bday = $db->fetch_array($query)) 1142 { 1143 // Pop off the year from the birthday because we don't need it. 1144 $bday['bday'] = explode('-', $bday['birthday']); 1145 array_pop($bday['bday']); 1146 $bday['bday'] = implode('-', $bday['bday']); 1147 1148 if($bday['birthdayprivacy'] != 'all') 1149 { 1150 if(isset($birthdays[$bday['bday']]['hiddencount'])) 1151 { 1152 ++$birthdays[$bday['bday']]['hiddencount']; 1153 } 1154 else 1155 { 1156 $birthdays[$bday['bday']]['hiddencount'] = 1; 1157 } 1158 continue; 1159 } 1160 1161 // We don't need any excess caleries in the cache 1162 unset($bday['birthdayprivacy']); 1163 1164 if(!isset($birthdays[$bday['bday']]['users'])) 1165 { 1166 $birthdays[$bday['bday']]['users'] = array(); 1167 } 1168 1169 $birthdays[$bday['bday']]['users'][] = $bday; 1170 } 1171 1172 $this->update("birthdays", $birthdays); 1173 } 1174 1175 function update_groupleaders() 1176 { 1177 global $db; 1178 1179 $groupleaders = array(); 1180 1181 $query = $db->simple_select("groupleaders"); 1182 while($groupleader = $db->fetch_array($query)) 1183 { 1184 $groupleaders[$groupleader['uid']][] = $groupleader; 1185 } 1186 1187 $this->update("groupleaders", $groupleaders); 1188 } 1189 1190 function update_threadprefixes() 1191 { 1192 global $db; 1193 1194 $prefixes = array(); 1195 $query = $db->simple_select("threadprefixes", "*", "", array('order_by' => 'prefix', 'order_dir' => 'ASC')); 1196 1197 while($prefix = $db->fetch_array($query)) 1198 { 1199 $prefixes[$prefix['pid']] = $prefix; 1200 } 1201 1202 $this->update("threadprefixes", $prefixes); 1203 } 1204 1205 function update_forumsdisplay() 1206 { 1207 global $db; 1208 1209 $fd_statistics = array(); 1210 1211 $time = TIME_NOW; // Look for announcements that don't end, or that are ending some time in the future 1212 $query = $db->simple_select("announcements", "fid", "enddate = '0' OR enddate > '{$time}'", array("order_by" => "aid")); 1213 1214 if($db->num_rows($query)) 1215 { 1216 while($forum = $db->fetch_array($query)) 1217 { 1218 if(!isset($fd_statistics[$forum['fid']]['announcements'])) 1219 { 1220 $fd_statistics[$forum['fid']]['announcements'] = 1; 1221 } 1222 } 1223 } 1224 1225 // Do we have any mod tools to use in our forums? 1226 $query = $db->simple_select("modtools", "forums, tid", '', array("order_by" => "tid")); 1227 1228 if($db->num_rows($query)) 1229 { 1230 unset($forum); 1231 while($tool = $db->fetch_array($query)) 1232 { 1233 $forums = explode(",", $tool['forums']); 1234 1235 foreach($forums as $forum) 1236 { 1237 if(!$forum) 1238 { 1239 $forum = -1; 1240 } 1241 1242 if(!isset($fd_statistics[$forum]['modtools'])) 1243 { 1244 $fd_statistics[$forum]['modtools'] = 1; 1245 } 1246 } 1247 } 1248 } 1249 1250 $this->update("forumsdisplay", $fd_statistics); 1251 } 1252 1253 /** 1254 * Update profile fields cache. 1255 * 1256 */ 1257 function update_profilefields() 1258 { 1259 global $db; 1260 1261 $fields = array(); 1262 $query = $db->simple_select("profilefields", "*", "", array('order_by' => 'disporder')); 1263 while($field = $db->fetch_array($query)) 1264 { 1265 $fields[] = $field; 1266 } 1267 1268 $this->update("profilefields", $fields); 1269 } 1270 1271 /** 1272 * Update the report reasons cache. 1273 * 1274 */ 1275 function update_reportreasons($no_plugins = false) 1276 { 1277 global $db; 1278 1279 $content_types = array('post', 'profile', 'reputation'); 1280 if(!$no_plugins) 1281 { 1282 global $plugins; 1283 $content_types = $plugins->run_hooks("report_content_types", $content_types); 1284 } 1285 1286 $reasons = array(); 1287 1288 $query = $db->simple_select("reportreasons", "*", "", array('order_by' => 'disporder')); 1289 while($reason = $db->fetch_array($query)) 1290 { 1291 if($reason['appliesto'] == 'all') 1292 { 1293 foreach($content_types as $content) 1294 { 1295 $reasons[$content][] = array( 1296 'rid' => $reason['rid'], 1297 'title' => $reason['title'], 1298 'extra' => $reason['extra'], 1299 ); 1300 } 1301 } 1302 elseif($reason['appliesto'] != '') 1303 { 1304 $appliesto = explode(",", $reason['appliesto']); 1305 foreach($appliesto as $content) 1306 { 1307 $reasons[$content][] = array( 1308 'rid' => $reason['rid'], 1309 'title' => $reason['title'], 1310 'extra' => $reason['extra'], 1311 ); 1312 } 1313 } 1314 } 1315 1316 $this->update("reportreasons", $reasons); 1317 } 1318 1319 /* Other, extra functions for reloading caches if we just changed to another cache extension (i.e. from db -> xcache) */ 1320 function reload_mostonline() 1321 { 1322 global $db; 1323 1324 $query = $db->simple_select("datacache", "title,cache", "title='mostonline'"); 1325 $this->update("mostonline", my_unserialize($db->fetch_field($query, "cache"))); 1326 } 1327 1328 function reload_plugins() 1329 { 1330 global $db; 1331 1332 $query = $db->simple_select("datacache", "title,cache", "title='plugins'"); 1333 $this->update("plugins", my_unserialize($db->fetch_field($query, "cache"))); 1334 } 1335 1336 function reload_last_backup() 1337 { 1338 global $db; 1339 1340 $query = $db->simple_select("datacache", "title,cache", "title='last_backup'"); 1341 $this->update("last_backup", my_unserialize($db->fetch_field($query, "cache"))); 1342 } 1343 1344 function reload_internal_settings() 1345 { 1346 global $db; 1347 1348 $query = $db->simple_select("datacache", "title,cache", "title='internal_settings'"); 1349 $this->update("internal_settings", my_unserialize($db->fetch_field($query, "cache"))); 1350 } 1351 1352 function reload_version_history() 1353 { 1354 global $db; 1355 1356 $query = $db->simple_select("datacache", "title,cache", "title='version_history'"); 1357 $this->update("version_history", my_unserialize($db->fetch_field($query, "cache"))); 1358 } 1359 1360 function reload_modnotes() 1361 { 1362 global $db; 1363 1364 $query = $db->simple_select("datacache", "title,cache", "title='modnotes'"); 1365 $this->update("modnotes", my_unserialize($db->fetch_field($query, "cache"))); 1366 } 1367 1368 function reload_adminnotes() 1369 { 1370 global $db; 1371 1372 $query = $db->simple_select("datacache", "title,cache", "title='adminnotes'"); 1373 $this->update("adminnotes", my_unserialize($db->fetch_field($query, "cache"))); 1374 } 1375 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| 2005 - 2021 © MyBB.de | Alle Rechte vorbehalten! | Sponsor: netcup | Cross-referenced by PHPXref |