Subs-MembersOnline.php 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265
  1. <?php
  2. /**
  3. * Simple Machines Forum (SMF)
  4. *
  5. * @package SMF
  6. * @author Simple Machines http://www.simplemachines.org
  7. * @copyright 2011 Simple Machines
  8. * @license http://www.simplemachines.org/about/smf/license.php BSD
  9. *
  10. * @version 2.1 Alpha 1
  11. */
  12. if (!defined('SMF'))
  13. die('Hacking attempt...');
  14. /* This file currently only holds the function for showing a list of online
  15. users used by the board index and SSI. In the future it'll also contain
  16. functions used by the Who's online page.
  17. array getMembersOnlineStats(array membersOnlineOptions)
  18. - retrieve a list and several other statistics of the users currently
  19. online on the forum.
  20. - used by the board index and SSI.
  21. - also returns the membergroups of the users that are currently online.
  22. - (optionally) hides members that chose to hide their online presense.
  23. */
  24. // Retrieve a list and several other statistics of the users currently online.
  25. function getMembersOnlineStats($membersOnlineOptions)
  26. {
  27. global $smcFunc, $context, $scripturl, $user_info, $modSettings, $txt;
  28. // The list can be sorted in several ways.
  29. $allowed_sort_options = array(
  30. '', // No sorting.
  31. 'log_time',
  32. 'real_name',
  33. 'show_online',
  34. 'online_color',
  35. 'group_name',
  36. );
  37. // Default the sorting method to 'most recent online members first'.
  38. if (!isset($membersOnlineOptions['sort']))
  39. {
  40. $membersOnlineOptions['sort'] = 'log_time';
  41. $membersOnlineOptions['reverse_sort'] = true;
  42. }
  43. // Not allowed sort method? Bang! Error!
  44. elseif (!in_array($membersOnlineOptions['sort'], $allowed_sort_options))
  45. trigger_error('Sort method for getMembersOnlineStats() function is not allowed', E_USER_NOTICE);
  46. // Get it from the cache and send it back.
  47. if (($temp = cache_get_data('membersOnlineStats-' . $membersOnlineOptions['sort'], 240)) !== null)
  48. return $temp;
  49. // Initialize the array that'll be returned later on.
  50. $membersOnlineStats = array(
  51. 'users_online' => array(),
  52. 'list_users_online' => array(),
  53. 'online_groups' => array(),
  54. 'num_guests' => 0,
  55. 'num_spiders' => 0,
  56. 'num_buddies' => 0,
  57. 'num_users_hidden' => 0,
  58. 'num_users_online' => 0,
  59. );
  60. // Get any spiders if enabled.
  61. $spiders = array();
  62. $spider_finds = array();
  63. if (!empty($modSettings['show_spider_online']) && ($modSettings['show_spider_online'] < 3 || allowedTo('admin_forum')) && !empty($modSettings['spider_name_cache']))
  64. $spiders = unserialize($modSettings['spider_name_cache']);
  65. // Load the users online right now.
  66. $request = $smcFunc['db_query']('', '
  67. SELECT
  68. lo.id_member, lo.log_time, lo.id_spider, mem.real_name, mem.member_name, mem.show_online,
  69. mg.online_color, mg.id_group, mg.group_name
  70. FROM {db_prefix}log_online AS lo
  71. LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = lo.id_member)
  72. LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = {int:reg_mem_group} THEN mem.id_post_group ELSE mem.id_group END)',
  73. array(
  74. 'reg_mem_group' => 0,
  75. )
  76. );
  77. while ($row = $smcFunc['db_fetch_assoc']($request))
  78. {
  79. if (empty($row['real_name']))
  80. {
  81. // Do we think it's a spider?
  82. if ($row['id_spider'] && isset($spiders[$row['id_spider']]))
  83. {
  84. $spider_finds[$row['id_spider']] = isset($spider_finds[$row['id_spider']]) ? $spider_finds[$row['id_spider']] + 1 : 1;
  85. $membersOnlineStats['num_spiders']++;
  86. }
  87. // Guests are only nice for statistics.
  88. $membersOnlineStats['num_guests']++;
  89. continue;
  90. }
  91. elseif (empty($row['show_online']) && empty($membersOnlineOptions['show_hidden']))
  92. {
  93. // Just increase the stats and don't add this hidden user to any list.
  94. $membersOnlineStats['num_users_hidden']++;
  95. continue;
  96. }
  97. // Some basic color coding...
  98. if (!empty($row['online_color']))
  99. $link = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '" style="color: ' . $row['online_color'] . ';">' . $row['real_name'] . '</a>';
  100. else
  101. $link = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
  102. // Buddies get counted and highlighted.
  103. $is_buddy = in_array($row['id_member'], $user_info['buddies']);
  104. if ($is_buddy)
  105. {
  106. $membersOnlineStats['num_buddies']++;
  107. $link = '<strong>' . $link . '</strong>';
  108. }
  109. // A lot of useful information for each member.
  110. $membersOnlineStats['users_online'][$row[$membersOnlineOptions['sort']] . $row['member_name']] = array(
  111. 'id' => $row['id_member'],
  112. 'username' => $row['member_name'],
  113. 'name' => $row['real_name'],
  114. 'group' => $row['id_group'],
  115. 'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
  116. 'link' => $link,
  117. 'is_buddy' => $is_buddy,
  118. 'hidden' => empty($row['show_online']),
  119. 'is_last' => false,
  120. );
  121. // This is the compact version, simply implode it to show.
  122. $membersOnlineStats['list_users_online'][$row[$membersOnlineOptions['sort']] . $row['member_name']] = empty($row['show_online']) ? '<em>' . $link . '</em>' : $link;
  123. // Store all distinct (primary) membergroups that are shown.
  124. if (!isset($membersOnlineStats['online_groups'][$row['id_group']]))
  125. $membersOnlineStats['online_groups'][$row['id_group']] = array(
  126. 'id' => $row['id_group'],
  127. 'name' => $row['group_name'],
  128. 'color' => $row['online_color']
  129. );
  130. }
  131. $smcFunc['db_free_result']($request);
  132. // If there are spiders only and we're showing the detail, add them to the online list - at the bottom.
  133. if (!empty($spider_finds) && $modSettings['show_spider_online'] > 1)
  134. {
  135. $sort = $membersOnlineOptions['sort'] === 'log_time' && $membersOnlineOptions['reverse_sort'] ? 0 : 'zzz_';
  136. foreach ($spider_finds as $id => $count)
  137. {
  138. $link = $spiders[$id] . ($count > 1 ? ' (' . $count . ')' : '');
  139. $membersOnlineStats['users_online'][$sort . $spiders[$id]] = array(
  140. 'id' => 0,
  141. 'username' => $spiders[$id],
  142. 'name' => $link,
  143. 'group' => $txt['spiders'],
  144. 'href' => '',
  145. 'link' => $link,
  146. 'is_buddy' => false,
  147. 'hidden' => false,
  148. 'is_last' => false,
  149. );
  150. $membersOnlineStats['list_users_online'][$sort . $spiders[$id]] = $link;
  151. }
  152. }
  153. // Time to sort the list a bit.
  154. if (!empty($membersOnlineStats['users_online']))
  155. {
  156. // Determine the sort direction.
  157. $sortFunction = empty($membersOnlineOptions['reverse_sort']) ? 'ksort' : 'krsort';
  158. // Sort the two lists.
  159. $sortFunction($membersOnlineStats['users_online']);
  160. $sortFunction($membersOnlineStats['list_users_online']);
  161. // Mark the last list item as 'is_last'.
  162. $userKeys = array_keys($membersOnlineStats['users_online']);
  163. $membersOnlineStats['users_online'][end($userKeys)]['is_last'] = true;
  164. }
  165. // Also sort the membergroups.
  166. ksort($membersOnlineStats['online_groups']);
  167. // Hidden and non-hidden members make up all online members.
  168. $membersOnlineStats['num_users_online'] = count($membersOnlineStats['users_online']) + $membersOnlineStats['num_users_hidden'] - (isset($modSettings['show_spider_online']) && $modSettings['show_spider_online'] > 1 ? count($spider_finds) : 0);
  169. cache_put_data('membersOnlineStats-' . $membersOnlineOptions['sort'], $membersOnlineStats, 240);
  170. return $membersOnlineStats;
  171. }
  172. // Check if the number of users online is a record and store it.
  173. function trackStatsUsersOnline($total_users_online)
  174. {
  175. global $modSettings, $smcFunc;
  176. $settingsToUpdate = array();
  177. // More members on now than ever were? Update it!
  178. if (!isset($modSettings['mostOnline']) || $total_users_online >= $modSettings['mostOnline'])
  179. $settingsToUpdate = array(
  180. 'mostOnline' => $total_users_online,
  181. 'mostDate' => time()
  182. );
  183. $date = strftime('%Y-%m-%d', forum_time(false));
  184. // No entry exists for today yet?
  185. if (!isset($modSettings['mostOnlineUpdated']) || $modSettings['mostOnlineUpdated'] != $date)
  186. {
  187. $request = $smcFunc['db_query']('', '
  188. SELECT most_on
  189. FROM {db_prefix}log_activity
  190. WHERE date = {date:date}
  191. LIMIT 1',
  192. array(
  193. 'date' => $date,
  194. )
  195. );
  196. // The log_activity hasn't got an entry for today?
  197. if ($smcFunc['db_num_rows']($request) === 0)
  198. {
  199. $smcFunc['db_insert']('ignore',
  200. '{db_prefix}log_activity',
  201. array('date' => 'date', 'most_on' => 'int'),
  202. array($date, $total_users_online),
  203. array('date')
  204. );
  205. }
  206. // There's an entry in log_activity on today...
  207. else
  208. {
  209. list ($modSettings['mostOnlineToday']) = $smcFunc['db_fetch_row']($request);
  210. if ($total_users_online > $modSettings['mostOnlineToday'])
  211. trackStats(array('most_on' => $total_users_online));
  212. $total_users_online = max($total_users_online, $modSettings['mostOnlineToday']);
  213. }
  214. $smcFunc['db_free_result']($request);
  215. $settingsToUpdate['mostOnlineUpdated'] = $date;
  216. $settingsToUpdate['mostOnlineToday'] = $total_users_online;
  217. }
  218. // Highest number of users online today?
  219. elseif ($total_users_online > $modSettings['mostOnlineToday'])
  220. {
  221. trackStats(array('most_on' => $total_users_online));
  222. $settingsToUpdate['mostOnlineToday'] = $total_users_online;
  223. }
  224. if (!empty($settingsToUpdate))
  225. updateSettings($settingsToUpdate);
  226. }
  227. ?>