"); find_replace_templatesets("postbit", "#".preg_quote('{$post[\'button_edit\']}')."#i", '{$post[\'button_tyl\']}{$post[\'button_edit\']}'); find_replace_templatesets("postbit_classic", "#".preg_quote('{$post[\'button_edit\']}')."#i", '{$post[\'button_tyl\']}{$post[\'button_edit\']}'); find_replace_templatesets("postbit_author_user", "#".preg_quote('{$lang->postbit_threads} {$post[\'threadnum\']}
')."#i", '{$lang->postbit_threads} {$post[\'threadnum\']}
%%TYL_NUMTHANKEDLIKED%%
'); find_replace_templatesets("member_profile", '#{\$reputation}(\r?)\n#', "{\$tyl_memprofile}\n\t\t\t\t{\$reputation}\n"); find_replace_templatesets("member_profile", '#{\$modoptions}(\r?)\n#', "{\$tyl_profile_box}\n\t\t\t{\$tyl_profile_stats}\n\t\t\t{\$modoptions}\n"); find_replace_templatesets("forumdisplay_thread","#".preg_quote('{$attachment_count}')."#i","{\$tyl_forumdisplay_thread_var}{\$attachment_count}"); find_replace_templatesets("search_results_threads_thread","#".preg_quote('{$attachment_count}')."#i","{\$tyl_search_page_var}{\$attachment_count}"); // Enable the tyl alert type if necessary. tyl_myalerts_set_enabled(1); } function thankyoulike_deactivate() { require_once MYBB_ROOT."/inc/adminfunctions_templates.php"; find_replace_templatesets("showthread", "#".preg_quote(' ')."#i", '', 0); find_replace_templatesets("postbit", "#".preg_quote('{$post[\'styleclass\']}')."#i", '', 0); find_replace_templatesets("postbit_classic", "#".preg_quote('{$post[\'styleclass\']}')."#i", '', 0); find_replace_templatesets("postbit", "#".preg_quote('')."(\r?)\n#", '', 0); find_replace_templatesets("postbit_classic", "#".preg_quote('')."(\r?)\n#", '', 0); find_replace_templatesets("postbit", "#".preg_quote('{$post[\'button_tyl\']}')."#i", '', 0); find_replace_templatesets("postbit_classic", "#".preg_quote('{$post[\'button_tyl\']}')."#i", '', 0); find_replace_templatesets("postbit_author_user", "#".preg_quote(' %%TYL_NUMTHANKEDLIKED%%
')."#i", '', 0); find_replace_templatesets("member_profile", '#(\t*)?{\$tyl_memprofile}(\r?)(\n?)#', "", 0); find_replace_templatesets("member_profile", '#(\t*)?{\$tyl_profile_box}(\r?)(\n?)#', "", 0); find_replace_templatesets("member_profile", '#(\t*)?{\$tyl_profile_stats}(\r?)(\n?)#', "", 0); find_replace_templatesets("forumdisplay_thread", '#{\$tyl_forumdisplay_thread_var}#', "", 0); find_replace_templatesets("search_results_threads_thread", '#{\$tyl_search_page_var}#', "", 0); // Disable the tyl alert type if necessary. tyl_myalerts_set_enabled(0); } /** * Enables or disables the tyl alert type. * When disabling, existing tyl alerts aren't deleted from the database, * but become invisible to users unless/until the tyl alert type is re-enabled. * @param integer 0 or 1. 0 to disable; 1 to enable. */ function tyl_myalerts_set_enabled($enabled) { global $db; if ($db->table_exists("alert_types")) { $db->update_query('alert_types', array('enabled' => $enabled), "code='tyl'"); if (function_exists('reload_mybbstuff_myalerts_alert_types')) { reload_mybbstuff_myalerts_alert_types(); } } } /** * Check whether a version of MyAlerts greater than 2.0.0 is present. * Optionally, check that it is activated too. * Optionally, check that the tyl alert type is registered too. * Optionally, check that any registered tyl alert type is also enabled. * @param boolean True iff an activation check should be performed. * @param boolean True iff a check for tyl alert type registration should be performed. * @param boolean True iff a check that any tyl alert type is enabled should be performed. * @return boolean True iff the check(s) succeeded. */ function tyl_have_myalerts($check_activated = false, $check_tyl_registered = false, $check_tyl_enabled = false) { $ret = false; if(function_exists("myalerts_info")) { $myalerts_info = myalerts_info(); if(version_compare($myalerts_info['version'], "2.0.0") >= 0 && (!$check_activated || (function_exists("myalerts_is_activated") && myalerts_is_activated()) ) ) { if (!$check_tyl_registered && !$check_tyl_enabled) { $ret = true; } else { global $cache; $alert_types = $cache->read('mybbstuff_myalerts_alert_types'); if((!$check_tyl_registered || (isset($alert_types['tyl']['code' ]) && $alert_types['tyl']['code' ] == 'tyl')) && (!$check_tyl_enabled || (isset($alert_types['tyl']['enabled']) && $alert_types['tyl']['enabled'] == 1 ))) { $ret = true; } } } } return $ret; } /** * Fully unintegrate from the MyAlerts system. * Warning: deletes ALL alerts of type tyl along with the tyl alert type itself. */ function tyl_myalerts_unintegrate() { global $db; if(tyl_have_myalerts()) { $alertTypeManager = MybbStuff_MyAlerts_AlertTypeManager::getInstance(); $alertType = $alertTypeManager->getByCode('tyl'); if ($alertType !== null) { $id = $alertType->getId(); if($id > 0) { // First delete the tyl alert type. $alertTypeManager->deleteById($id); if($db->table_exists("alerts") && $id > 0) { // Then delete all alerts of that type. $db->delete_query("alerts", "alert_type_id = '$id'"); } } } } } /** * Remove plugin-specific settings. * @param boolean Set to true if rebuild_settings() should be run after removing settings. */ function tyl_remove_settings($rebuild_settings = true) { global $db; $prefix = 'g33k_thankyoulike_'; $result = $db->simple_select('settinggroups', 'gid', "name = '{$prefix}settings'", array('limit' => 1)); $group = $db->fetch_array($result); if(!empty($group['gid'])) { $db->delete_query('settinggroups', "gid='{$group['gid']}'"); $db->delete_query('settings', "gid='{$group['gid']}'"); if ($rebuild_settings) rebuild_settings(); } } function thankyoulike_uninstall() { global $mybb, $db, $cache; $prefix = 'g33k_thankyoulike_'; if($mybb->request_method != 'post') { global $page, $lang; $lang->load('config_thankyoulike'); $page->output_confirm_action('index.php?module=config-plugins&action=deactivate&uninstall=1&plugin=thankyoulike', $lang->tyl_uninstall_message, $lang->tyl_uninstall); } // Remove templates $db->delete_query("templates", "title LIKE 'thankyoulike_%'"); $db->delete_query("templategroups", "prefix in ('thankyoulike')"); // Remove CSS rules for g33k_thankyoulike require_once MYBB_ADMIN_DIR."inc/functions_themes.php"; $db->delete_query("themestylesheets", "name = 'thankyoulike.css'"); $query = $db->simple_select("themes", "tid"); while($theme = $db->fetch_array($query)) { update_theme_stylesheet_list($theme['tid']); } // Remove plugin-specific settings. tyl_remove_settings(); // Only remove the database tables if the admin has selected not to keep data. if(!isset($mybb->input['no'])) { if($db->field_exists('tyl_unumtyls', 'users')) { $db->query("ALTER TABLE ".TABLE_PREFIX."users DROP column `tyl_unumtyls`"); } if($db->field_exists('tyl_unumrcvtyls', 'users')) { $db->query("ALTER TABLE ".TABLE_PREFIX."users DROP column `tyl_unumrcvtyls`"); } if($db->field_exists('tyl_unumptyls', 'users')) { $db->query("ALTER TABLE ".TABLE_PREFIX."users DROP column `tyl_unumptyls`"); } if($db->field_exists('tyl_lastadddeldate', 'users')) { $db->query("ALTER TABLE ".TABLE_PREFIX."users DROP column `tyl_lastadddeldate`"); } if($db->field_exists('tyl_pnumtyls', 'posts')) { $db->query("ALTER TABLE ".TABLE_PREFIX."posts DROP column `tyl_pnumtyls`"); } // Was dropped in 3.1.0; will not be present for that version and later. if($db->field_exists('tyl_tnumtyls', 'threads')) { $db->query("ALTER TABLE ".TABLE_PREFIX."threads DROP column `tyl_tnumtyls`"); } if($db->table_exists($prefix.'thankyoulike')) { $db->drop_table($prefix.'thankyoulike'); } if($db->table_exists($prefix.'stats')) { $db->drop_table($prefix.'stats'); } // Only unintegrate with MyAlerts (deleting all tyl alerts and the tyl alert type) // if the admin has selected not to keep data. tyl_myalerts_unintegrate(); } else if($db->table_exists($prefix.'stats')) { // Remove the stored version so that upgrades are properly triggered when a downgrade is performed in between. $db->delete_query($prefix.'stats', "title='version'"); } // Remove Thank You/Like Promotions Tables Fields if($db->field_exists("tylreceived", "promotions")) { $query = $db->simple_select("promotions", "pid", "tylreceived>'0'"); $pid = $db->fetch_array($query); if(!empty($pid['pid'])) { $db->delete_query("promotions", "pid='{$pid['pid']}'"); } $db->drop_column("promotions", "tylreceived"); } if($db->field_exists("tylreceivedtype", "promotions")) { $db->drop_column("promotions", "tylreceivedtype"); } if($db->field_exists("tylgiven", "promotions")) { $query = $db->simple_select("promotions", "pid", "tylgiven>'0'"); $pid = $db->fetch_array($query); if(!empty($pid['pid'])) { $db->delete_query("promotions", "pid='{$pid['pid']}'"); } $db->drop_column("promotions", "tylgiven"); } if($db->field_exists("tylgiventype", "promotions")) { $db->drop_column("promotions", "tylgiventype"); } // Remove from the usergroups table the fields for rate-limiting tyls. if($db->field_exists("tyl_limits_max", "usergroups")) { $db->drop_column("usergroups", "tyl_limits_max"); } if($db->field_exists("tyl_flood_interval", "usergroups")) { $db->drop_column("usergroups", "tyl_flood_interval"); } $cache->update_usergroups(); $cache->update_forums(); $cache->update_tasks(); } function thankyoulike_templatelist() { global $mybb, $lang, $templatelist; $prefix = 'g33k_thankyoulike_'; if($mybb->settings[$prefix.'enabled'] == "1") { $lang->load('thankyoulike', false, true); if($mybb->settings[$prefix.'thankslike'] == "like") { $prelang = $lang->tyl_like; $key_tyl_noun_one_sm = 'tyl_like_sm'; } else { $prelang = $lang->tyl_thankyou; $key_tyl_noun_one_sm = 'tyl_thankyou_sm'; } $lang->myalerts_setting_tyl = $lang->sprintf($lang->myalerts_setting_tyl, $lang->$key_tyl_noun_one_sm); $lang->tyl_send = $lang->sprintf($lang->tyl_send, $prelang); $lang->tyl_remove = $lang->sprintf($lang->tyl_remove, $prelang); // Register alert formatter. if(tyl_have_myalerts(true, true, true) && $mybb->user['uid']) { tyl_myalerts_formatter_load(); } // Cache all templates $template_list = ''; if (THIS_SCRIPT == 'showthread.php') { $template_list = "thankyoulike_users,thankyoulike_postbit_author_user,thankyoulike_postbit,thankyoulike_postbit_classic,thankyoulike_postbit_avatars,thankyoulike_postbit_classic_avatars,thankyoulike_users_avatars,thankyoulike_expcollapse,thankyoulike_button_add,thankyoulike_button_del"; } if (THIS_SCRIPT == 'forumdisplay.php') { $template_list = "thankyoulike_tyl_counter_forumdisplay_thread"; } if (THIS_SCRIPT == 'search.php') { $template_list = "thankyoulike_tyl_counter_search_page"; } if (THIS_SCRIPT == 'member.php') { $template_list = "thankyoulike_member_profile,thankyoulike_member_profile_box,thankyoulike_member_profile_box_content,thankyoulike_member_profile_box_continue_reading,thankyoulike_member_profile_rcvd_search,thankyoulike_member_profile_given_search,thankyoulike_forum_separator,thankyoulike_forum_link,thankyoulike_forum_separator_last,thankyoulike_member_profile_box_content_none,thankyoulike_member_profile_like_stats,thankyoulike_member_profile_like_stats_most_likedby_row,thankyoulike_member_profile_like_stats_most_liked_row,thankyoulike_member_profile_like_stats_no_most_liked,thankyoulike_member_profile_like_stats_no_most_likedby,thankyoulike_member_link"; } if (THIS_SCRIPT == 'announcements.php') { $template_list = "thankyoulike_postbit_author_user"; } if (THIS_SCRIPT == 'private.php') { $template_list = "thankyoulike_postbit_author_user"; } if (isset($templatelist)) { $templatelist .= ",".$template_list; } else { $templatelist = $template_list; } } } /** * Count the number of the user's own posts that s/he has tyled and that * nobody else has. * @param integer The user's ID. * @return integer The post count. */ function tyl_get_own_single_tyl_post_count($uid) { global $db; $prefix = 'g33k_thankyoulike_'; // Cache results as we may need them again // e.g. on a thread page where the same user has posted multiple times. static $owntylpostcounts = array(); if(!isset($owntylpostcounts[$uid])) { $query = $db->query("SELECT COUNT(pid) AS owntylposts FROM ".TABLE_PREFIX.$prefix."thankyoulike WHERE uid='$uid' AND uid=puid AND pid NOT IN ( SELECT pid FROM ".TABLE_PREFIX.$prefix."thankyoulike WHERE puid='$uid' GROUP BY pid HAVING COUNT(pid) > 1 ) "); $owntylpostcounts[$uid] = $db->fetch_field($query, 'owntylposts'); } return $owntylpostcounts[$uid]; } /** * Removes self-likes from like counts in a post if the applicable plugin setting is enabled. * * @param array &$post The database row of the post. (Potentially) modified by the function. * @param boolean $skip_postcounts Whether, for efficiency when not needed, to skip removal * of the count of single-like self-liked posts from * the given-likes post count. */ function tyl_check_remove_self_likes_from_post_array(&$post, $skip_postcounts = false) { global $mybb; $prefix = 'g33k_thankyoulike_'; $post['tyl_unumrcvtyls_self_rem'] = $post['tyl_unumrcvtyls']; $post['tyl_unumtyls_self_rem' ] = $post['tyl_unumtyls' ]; $post['tyl_unumptyls_self_rem' ] = $post['tyl_unumptyls' ]; if($mybb->settings[$prefix.'remowntylfromc'] == 1) { $owntylusercount = tyl_get_own_tyl_count($post['uid']); $post['tyl_unumrcvtyls_self_rem'] -= $owntylusercount; $post['tyl_unumtyls_self_rem' ] -= $owntylusercount; if(!$skip_postcounts) { $post['tyl_unumptyls_self_rem'] -= tyl_get_own_single_tyl_post_count($post['uid']); } } } /** * Checks whether tyl functionality is forbidden because the potentially (un)tyled post * is not the first post in the thread and in the plugin's ACP settings this has been * generally forbidden and not overridden for the post's containing forum. * @param integer $fid The ID of the forum containing the thread $thread. * @param array $thread The database row of the thread containing the post with ID $pid. * @param int $pid The ID of the potentially (un)tyled post. * @return boolean True if the tyl functionality is forbidden, false if it is not. */ function tyl_is_forbidden_due_to_first_thread_post_restriction($fid, $thread, $pid) { global $mybb; $prefix = 'g33k_thankyoulike_'; $forum_override_for_may_like_all_posts = tyl_in_forums($fid, $mybb->settings[$prefix.'firstalloverride']); $may_like_all_posts_in_thread = ($mybb->settings[$prefix.'firstall'] == "all" || $forum_override_for_may_like_all_posts); $is_first_post = ($thread['firstpost'] == $pid); return (!$is_first_post && !$may_like_all_posts_in_thread); } /** * Checks whether tyl buttons functionality is forbidden for various reasons, including: * 1. The forum is password-protected and the user has not supplied the correct password. * 2. The forum has been excluded in the plugin's ACP settings. * 3. The thread is closed and the user is not a moderator with edit override permission. * 4. The user is trying to (un)tyl his/her own post, but the plugin's ACP settings forbid this. * 5. The user is a member of a usergroup whose members have had the tyl functionality * hidden from them in the plugin's ACP settings. * 6. The user is trying to (un)tyl a post other than the first post in the thread * but this has been forbidden in the plugin's ACP settings. * @param array $thread The database row of the thread of the potentially (un)tyled post. * @param int $fid The ID of the forum within which the thread of the potentially (un)tyled post exists. * @param int $pid The ID of the potentially (un)tyled post. * @param int $post_userid The ID of the author of the potentially (un)tyled post. * @param int $tyl_userid The ID of the user who potentially will (un)tyl the post. * @param boolean $skip_forum_pw_protect_check Whether, to avoid potential database queries, * and assuming the check is not required, to skip the check for a password-protected forum. * @param array &$err_msgs An array of error messages which can be displayed to the user * to explain why the tyl functionality is forbidden to him/her. * Will be filled if and only if the function returns true. * @return boolean True if the tyl functionality is forbidden, false if it is not. */ function tyl_is_tyling_forbidden($thread, $fid, $pid, $post_userid, $tyl_userid, $skip_forum_pw_protect_check = true, &$err_msgs = array()) { global $mybb, $lang; $prefix = 'g33k_thankyoulike_'; $err_msgs = array(); $pre = ($mybb->settings[$prefix.'thankslike'] == "like" ? $pre = $lang->tyl_like : $lang->tyl_thankyou); if (!$skip_forum_pw_protect_check) { // Check whether this forum is password protected and we have a valid password. $forbidden_due_to_forum_pw_protect = check_forum_password($fid, 0, true); if ($forbidden_due_to_forum_pw_protect) { $err_msgs[] = $lang->error_nopermission_user_ajax; } } else $forbidden_due_to_forum_pw_protect = false; $forbidden_due_to_excluded_forum = tyl_in_forums($fid, $mybb->settings[$prefix.'exclude']); if ($forbidden_due_to_excluded_forum) { $err_msgs[] = $lang->tyl_error_excluded; } $forbidden_due_to_thread_closure = ($thread['closed'] == 1 && $mybb->settings[$prefix.'closedthreads'] != "1" && !is_moderator($fid, "caneditposts")); if ($forbidden_due_to_thread_closure) { $err_msgs[] = $lang->sprintf($lang->tyl_error_threadclosed, $pre); } $may_like_own_posts = ($mybb->settings[$prefix.'tylownposts'] == "1"); $is_own_post = ($post_userid == $tyl_userid); $forbidden_due_to_unlikeability_of_own_posts = (!$may_like_own_posts && $is_own_post); if ($forbidden_due_to_unlikeability_of_own_posts) { $err_msgs[] = $lang->sprintf($lang->tyl_error_own_post, $pre); } $forbidden_due_to_group_membership = (is_member($mybb->settings[$prefix.'hideforgroups'], $tyl_userid) || $mybb->settings[$prefix.'hideforgroups'] == "-1"); if ($forbidden_due_to_group_membership) { $err_msgs[] = $lang->sprintf($lang->tyl_error_hidden_from_group, $pre); } $forbidden_due_to_first_thread_post_restriction = tyl_is_forbidden_due_to_first_thread_post_restriction($fid, $thread, $pid); if ($forbidden_due_to_first_thread_post_restriction) { $err_msgs[] = $lang->sprintf($lang->tyl_error_first_post_only, $pre); } return ($forbidden_due_to_forum_pw_protect || $forbidden_due_to_excluded_forum || $forbidden_due_to_thread_closure || $forbidden_due_to_unlikeability_of_own_posts || $forbidden_due_to_group_membership || $forbidden_due_to_first_thread_post_restriction); } /** * Determine which, if either, of the add/remove tyl buttons to show for this post. * @param array $thread The database row of the thread of the potentially (un)tyled post. * @param int $fid The ID of the forum within which the thread of the potentially (un)tyled post exists. * @param int $pid The ID of the potentially (un)tyled post. * @param int $post_userid The ID of the author of the potentially (un)tyled post. * @param int $tyl_userid The ID of the user who potentially will (un)tyl the post. * @param boolean $has_tyled_post Whether the user with ID $tyl_userid has already tyled the post. * @return string One of 'del', 'add' or ''. */ function tyl_get_which_btn($thread, $fid, $pid, $post_userid, $tyl_userid, $has_tyled_post) { global $mybb; $prefix = 'g33k_thankyoulike_'; // Default to not showing a button $which_btn = ''; $liking_is_forbidden = tyl_is_tyling_forbidden($thread, $fid, $pid, $post_userid, $tyl_userid); if(!$liking_is_forbidden) { $may_remove_tyls = ($mybb->settings[$prefix.'removing'] == "1"); if($has_tyled_post && $may_remove_tyls) { // Show a remove button. $which_btn = 'del'; } else if(!$has_tyled_post) { // Show an add button. $which_btn = 'add'; } } return $which_btn; } function tyl_get_lang_key_likes_or_thanks($suffix = '') { global $mybb; $prefix = 'g33k_thankyoulike_'; $ret = $mybb->settings[$prefix.'thankslike']; if(substr($ret, -1) == 's') { $ret = substr($ret, 0, -1); } switch($suffix) { case 's': $ret .= 's'; break; case 'ed'; if(substr($ret, -1) != 'e') { $ret .= 'e'; } $ret .= 'd'; break; } return $ret; // Either "like", "likes", "liked", "thank", "thanks", or "thanked". } function tyl_set_lang_rcvd_given($tok_tyls = '') { global $lang; if(!$tok_tyls) { $tok_tyls = tyl_get_lang_key_likes_or_thanks('s'); } $key_tyls = 'tyl_'.$tok_tyls; $lang->tyl_rcvd = $lang->sprintf($lang->tyl_tyls_rcvd, $lang->$key_tyls); $lang->tyl_given = $lang->sprintf($lang->tyl_tyls_given, $lang->$key_tyls); } /** * Insert into the given post's 'user_details' field the user's tyl statistics * by replacing the placeholder '%%TYL_NUMTHANKEDLIKED%%'. * @param array &$post The database row of the post. Modified by this function. */ function tyl_set_up_stats_in_postbit(&$post) { global $mybb, $lang, $templates; $prefix = 'g33k_thankyoulike_'; // If removal of self-likes from counts is enabled, then remove self-likes from counts. tyl_check_remove_self_likes_from_post_array($post); tyl_set_lang_rcvd_given(); $post['tyl_unumrcvtyls_fmt'] = $post['tyl_unumrtyls'] = $lang->sprintf($lang->tyl_tyls_rcvd_bit, tyl_fmt_rcvd_tyls_count($post['tyl_unumrcvtyls_self_rem']), my_number_format($post['tyl_unumptyls_self_rem'])); $post['tyl_unumtyls_fmt'] = my_number_format($post['tyl_unumtyls_self_rem']); eval("\$tyl_thankslikes = \"".$templates->get("thankyoulike_postbit_author_user", 1, 0)."\";"); $post['user_details'] = preg_replace("#".preg_quote('%%TYL_NUMTHANKEDLIKED%%')."#i", $tyl_thankslikes, $post['user_details']); } function tyl_fmt_rcvd_tyls_count($count, $link = '') { global $mybb; $prefix = 'g33k_thankyoulike_'; $class = ''; $intervals = trim($mybb->settings[$prefix.'rcvdlikesclassranges']); if ($intervals) { $a = explode(',', $intervals); for ($i = 0; $i < count($a); $i++) { if ($count < $a[$i]) { break; } } if ($i > 0) { $class = 'tyl_rcvdlikesrange_'.$i; } } return ''.($link ? "' : '').my_number_format($count).($link ? '' : '').''; } /** * Remove from the supplied post's 'user_details' field * the placeholder for the user's tyl statistics, '%%TYL_NUMTHANKEDLIKED%%'. * @param array &$post The database row of the post. Updated by the function. */ function tyl_remove_stats_in_postbit(&$post) { $post['user_details'] = preg_replace("#".preg_quote('%%TYL_NUMTHANKEDLIKED%%
')."#i", "", $post['user_details']); } function tyl_query_post_likes($post, $pids = '') { global $mybb, $db; $prefix = 'g33k_thankyoulike_'; // Use pids if $pids are there, otherwise use $post['pid'] as we're probably in threaded view if($pids != '') { $conds = 'tyl.'.trim($pids); } else { $conds = "tyl.pid='".$post['pid']."'"; } // Set retrieve order switch($mybb->settings[$prefix.'sortorder']) { case "userdesc": $order = " ORDER BY username DESC"; break; case "dtasc": $order = " ORDER BY dateline ASC"; break; case "dtdesc": $order = " ORDER BY dateline DESC"; break; case "userasc": default: $order = " ORDER BY username ASC"; break; } return $db->query(" SELECT u.username, u.usergroup, u.displaygroup, u.avatar, tyl.* FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=tyl.uid) WHERE ".$conds." ".$order ); } function tyl_build_likers_list($tyl, &$comma, &$tyls, &$tyled, &$count) { global $mybb, $templates, $lang; $prefix = 'g33k_thankyoulike_'; $profile_link = get_profile_link($tyl['uid']); $avatar = format_avatar($tyl['avatar']); // Format username... or not $tyl_list = $mybb->settings[$prefix.'unameformat'] == "1" ? format_name($tyl['username'], $tyl['usergroup'], $tyl['displaygroup']) : $tyl['username']; $datedisplay_plain = my_date($mybb->settings[$prefix.'dtformat'], $tyl['dateline']); $datedisplay_next = $mybb->settings[$prefix.'showdt'] == "nexttoname" ? " (".$datedisplay_plain.")" : ""; $datedisplay_title = $mybb->settings[$prefix.'showdt'] == "astitle" ? "title='".$datedisplay_plain."'" : ""; eval("\$thankyoulike_users = \"".$templates->get($mybb->settings[$prefix.'likersdisplay'] == "avatars" ? "thankyoulike_users_avatars" : "thankyoulike_users", 1, 0)."\";"); $tyls .= trim($thankyoulike_users); $comma = $lang->comma; // Has this user tyled? if($tyl['uid'] == $mybb->user['uid']) { $tyled = 1; } $count++; } function tyl_build_post_likers_display(&$post, $tyls, $tyled, $count) { global $mybb, $templates, $theme, $lang; $prefix = 'g33k_thankyoulike_'; $unapproved_shade = ''; // Are we using thanks or like? Setup titles if($count == 1) { $tyl_user = $lang->tyl_user; $tyl_say = $lang->tyl_says; $tyl_like = $lang->tyl_likes; } else { $tyl_user = $lang->tyl_users; $tyl_say = $lang->tyl_say; $tyl_like = $lang->tyl_like; } if ($mybb->settings[$prefix.'thankslike'] == "like") { $pre = "l"; $lang->add_tyl = $lang->add_l; $lang->del_tyl = $lang->del_l; $lang->add_tyl_button_title = $lang->add_l_button_title; $lang->del_tyl_button_title = $lang->del_l_button_title; $tyl_like_or_say = $tyl_like; $tyl_title_collapsed = $lang->tyl_title_collapsed_l; $tyl_title = $lang->tyl_title_l; } else // $mybb->settings[$prefix.'thankslike'] == "thanks" { $pre = "ty"; $lang->add_tyl = $lang->add_ty; $lang->del_tyl = $lang->del_ty; $lang->add_tyl_button_title = $lang->add_ty_button_title; $lang->del_tyl_button_title = $lang->del_ty_button_title; $tyl_like_or_say = $tyl_say; $tyl_title_collapsed = $lang->tyl_title_collapsed_ty; $tyl_title = $lang->tyl_title_ty; } $tyled_user = get_user($post['uid']); if($mybb->settings[$prefix.'unameformat'] == "1") { $tyled_user['username'] = format_name($tyled_user['username'], $tyled_user['usergroup'], $tyled_user['displaygroup']); $tyl_profilelink = build_profile_link($tyled_user['username'], $tyled_user['uid']); } else { $tyl_profilelink = htmlspecialchars_uni($tyled_user['username']); } $lang->tyl_title = $lang->sprintf($tyl_title, $count, $tyl_user, $tyl_like_or_say, $tyl_profilelink); $lang->tyl_title_collapsed = $lang->sprintf($tyl_title_collapsed, $count, $tyl_user, $tyl_like_or_say, $tyl_profilelink); // Setup the collapsible elements if ($mybb->settings[$prefix.'collapsible'] == "1" && $mybb->settings[$prefix.'colldefault'] == "closed") { $tyl_title_display = "display: none;"; $tyl_title_display_collapsed = ""; $tyl_data_display = "display: none;"; $tyl_expcolimg = "collapse_collapsed.png"; $tyl_showhide = "[+]"; eval("\$tyl_expcol = \"".$templates->get("thankyoulike_expcollapse", 1, 0)."\";"); } else if ($mybb->settings[$prefix.'collapsible'] == "1" && $mybb->settings[$prefix.'colldefault'] == "open") { $tyl_title_display = ""; $tyl_title_display_collapsed = "display: none;"; $tyl_data_display = ""; $tyl_expcolimg = "collapse.png"; $tyl_showhide = "[-]"; eval("\$tyl_expcol = \"".$templates->get("thankyoulike_expcollapse", 1, 0)."\";"); } else { $tyl_title_display = ""; $tyl_title_display_collapsed = "display: none;"; $tyl_data_display = ""; $tyl_expcolimg = ""; $tyl_expcol = ""; $tyl_showhide = ""; $lang->tyl_title_collapsed = ""; } $thread = get_thread($post['tid']); $post['button_tyl'] = ''; if (($which_btn = tyl_get_which_btn($thread, $post['fid'], $post['pid'], $post['uid'], $mybb->user['uid'], $tyled))) { eval("\$post['button_tyl'] = \"".$templates->get("thankyoulike_button_$which_btn")."\";"); } $forbidden_due_to_first_thread_post_restriction = tyl_is_forbidden_due_to_first_thread_post_restriction($post['fid'], $thread, $post['pid']); $is_member_of_hidden_group = (is_member($mybb->settings[$prefix.'hidelistforgroups']) || $mybb->settings[$prefix.'hidelistforgroups'] == "-1"); $post['thankyoulike'] = ""; if($count>0 && !$forbidden_due_to_first_thread_post_restriction && !$is_member_of_hidden_group) { // We have thanks/likes to show $post['thankyoulike'] = $tyls; $post['tyl_display'] = ""; if($mybb->settings['postlayout'] == "classic") { eval("\$thankyoulike = \"".$templates->get($mybb->settings[$prefix.'likersdisplay'] == "avatars" ? "thankyoulike_postbit_classic_avatars" : "thankyoulike_postbit_classic")."\";"); } else { eval("\$thankyoulike = \"".$templates->get($mybb->settings[$prefix.'likersdisplay'] == "avatars" ? "thankyoulike_postbit_avatars" : "thankyoulike_postbit")."\";"); } $post['thankyoulike_data'] = $thankyoulike; $post['ty_count'] = $count; return true; } else { return false; } } function thankyoulike_postbit(&$post) { global $db, $mybb, $templates, $lang, $pids, $g33k_pcache, $theme; $prefix = 'g33k_thankyoulike_'; $lang->load("thankyoulike"); $unapproved_shade = ''; if ($mybb->settings[$prefix.'enabled'] == "1") { // Set up stats in postbit tyl_set_up_stats_in_postbit($post); // If this post is in an excluded forum, then end right here. if (tyl_in_forums($post['fid'], $mybb->settings[$prefix.'exclude'])) { return $post; } // Get all the thank you/like data for all the posts on this thread // Check first is it already fetched/cached? if(!is_array($g33k_pcache)) { $g33k_pcache = array(); $query = tyl_query_post_likes($post, $pids); while($t = $db->fetch_array($query)) { $g33k_pcache[$t['pid']][] = $t; } } $tyls = $comma = ''; $tyled = $count = 0; if(isset($g33k_pcache[$post['pid']])) { foreach($g33k_pcache[$post['pid']] AS $tyl) { tyl_build_likers_list($tyl, $comma, $tyls, $tyled, $count); } } if (!tyl_build_post_likers_display($post, $tyls, $tyled, $count)) { $tyl_title_display = ""; $tyl_title_display_collapsed = "display: none;"; $tyl_data_display = ""; $tyl_expcol = ""; $lang->tyl_title = ''; $lang->tyl_title_collapsed = ''; $post['tyl_display'] = "display: none;"; if($mybb->settings['postlayout'] == "classic") { eval("\$thankyoulike = \"".$templates->get($mybb->settings[$prefix.'likersdisplay'] == "avatars" ? "thankyoulike_postbit_classic_avatars" : "thankyoulike_postbit_classic")."\";"); } else { eval("\$thankyoulike = \"".$templates->get($mybb->settings[$prefix.'likersdisplay'] == "avatars" ? "thankyoulike_postbit_avatars" : "thankyoulike_postbit")."\";"); } $post['thankyoulike_data'] = $thankyoulike; $post['ty_count'] = $count; } } else { // Remove stats in postbit tyl_remove_stats_in_postbit($post); } $post['styleclass'] = ''; if($mybb->settings[$prefix.'highlight_popular_posts'] == 1 && $mybb->settings[$prefix.'highlight_popular_posts_count'] > 0) { if($post['tyl_pnumtyls'] >= $mybb->settings[$prefix.'highlight_popular_posts_count']) { $post['styleclass'] = ' popular_post'; } } return $post; } /** * Add a support for displaying total number of tyl for the first post of the thread in the forumdisplay_thread and/or search_results_threads_thread template. */ function thankyoulike_threads_udetails() { global $mybb, $db, $templates, $lang, $thread, $threadcache, $thread_cache, $tyl_forumdisplay_thread_var, $tyl_search_page_var; static $tyl_threads_cached = array(); $prefix = 'g33k_thankyoulike_'; $lang->load("thankyoulike"); $display_forum = ($mybb->settings[$prefix.'display_tyl_counter_forumdisplay'] == "1" && THIS_SCRIPT == "forumdisplay.php"); $display_search = ($mybb->settings[$prefix.'display_tyl_counter_search_page' ] == "1" && THIS_SCRIPT == "search.php" ); if($display_forum || $display_search) { $page_type = $display_forum ? 'forumdisplay_thread' : 'search_page'; $tcache = $display_forum ? $threadcache : $thread_cache; if(!$tyl_threads_cached) { $pids = array(); foreach($tcache as $t) { $pids[] = (int)$t['firstpost']; } $pids = implode(',', $pids); $query = $db->simple_select("posts","tid,tyl_pnumtyls","pid IN ($pids)"); while($post = $db->fetch_array($query)) { $tyl_threads_cached[$post['tid']] = (int)$post['tyl_pnumtyls']; } $key_1st_post_tyl_count = 'tyl_firstpost_tyl_count_'.$page_type; $key_tyls_sm = 'tyl_'.tyl_get_lang_key_likes_or_thanks('s').'_sm'; $lang->$key_1st_post_tyl_count = $lang->sprintf($lang->$key_1st_post_tyl_count, $lang->$key_tyls_sm); } $thread['tyls'] = $tyl_threads_cached[$thread['tid']]; eval("\$tyl_{$page_type}_var = \"" . $templates->get("thankyoulike_tyl_counter_{$page_type}") . "\";"); } } /** * Count the number of self-liked posts for either the given user or for all users. * @param mixed The given user's ID as an integer or null to count for all users. * @return integer The self-like count. */ function tyl_get_own_tyl_count($uid = null) { global $db; $prefix = 'g33k_thankyoulike_'; // Cache results as we may need them again // e.g. on a thread page where the same user has posted multiple times. static $owntylcounts = array(); if(!isset($owntylcounts[$uid])) { $where = "uid=puid"; // $uid of null means to count the self-likes of ALL users if(!is_null($uid)) { $where .= " AND uid='$uid'"; } $query = $db->simple_select($prefix."thankyoulike", "COUNT(tlid) AS owntyluser", $where); $owntylcounts[$uid] = $db->fetch_field($query, 'owntyluser'); } return $owntylcounts[$uid]; } function thankyoulike_postbit_udetails(&$post) { global $mybb, $lang; $prefix = 'g33k_thankyoulike_'; $lang->load("thankyoulike"); if ($mybb->settings[$prefix.'enabled'] == "1") { // Set up stats in postbit tyl_set_up_stats_in_postbit($post); } else { // Remove stats in postbit tyl_remove_stats_in_postbit($post); } return $post; } /** * If this plugin and MyAlerts are both enabled and integrated, then add/update an alert for the tyls of this post. */ function tyl_manage_alert_for_added_tyl($post, $from_uid) { global $db, $mybb; $prefix = 'g33k_thankyoulike_'; if($mybb->settings[$prefix.'enabled'] == "1" && tyl_have_myalerts(true, true, true)) { $uid = (int)$post['uid']; $tid = (int)$post['tid']; $pid = (int)$post['pid']; $subject = htmlspecialchars_uni($post['subject']); $fid = (int)$post['fid']; $alertType = MybbStuff_MyAlerts_AlertTypeManager::getInstance()->getByCode('tyl'); $counts = tyl_get_post_tyl_counts($pid, $post['tyl_last_alerted_tyl_id']); // Check whether one or more tyl alerts for this post exist, // with the latest alert ordered first. $query = $db->simple_select( 'alerts', 'id,unread,extra_details', 'object_id = '.$pid.' AND alert_type_id = '.$alertType->getId(), array('order_by' => 'id', 'order_dir' => 'DESC') ); $fields = $db->fetch_array($query); $db->free_result($query); // If there are no existing tyl alerts for this post, // or if the latest tyl alert for this post has already been read, // then create (another) one. if(!$fields || $fields['unread'] < 1) { $alert = new MybbStuff_MyAlerts_Entity_Alert($uid, $alertType, $pid, $from_uid); $alert->setExtraDetails( array_merge( $counts, array( 'tid' => $tid, 'pid' => $pid, 't_subject' => $subject, 'fid' => $fid ) ) ); MybbStuff_MyAlerts_AlertManager::getInstance()->addAlert($alert); } else // An unread alert for this post already exists - update it. { $alert_id = $fields['id']; unset($fields['id']); $extra_details = json_decode($fields['extra_details'], true); $extra_details['total_likes_count'] = $counts['total_likes_count']; $extra_details['new_likes_count' ] = $counts['new_likes_count' ]; $fields['extra_details'] = $db->escape_string(json_encode($extra_details)); $fields['from_user_id'] = $from_uid; $db->update_query('alerts', $fields, 'id = '.$alert_id); } } } function tyl_manage_alert_for_deleted_tyl($post, $from_uid) { global $mybb, $db; $prefix = 'g33k_thankyoulike_'; if($mybb->settings[$prefix.'enabled'] == "1" && tyl_have_myalerts(true, true, true) && $post && $from_uid) { $alertType = MybbStuff_MyAlerts_AlertTypeManager::getInstance()->getByCode('tyl'); // Check whether an existing unread likes alert for this post exists. $query = $db->simple_select( 'alerts', 'id,from_user_id,extra_details', 'object_id = '.$post['pid'].' AND unread = 1 AND alert_type_id = '.$alertType->getId() ); if($db->num_rows($query) > 0) { // Yes, an existing unread likes alert for this post exists. Manage it given the deleted like. $fields = $db->fetch_array($query); $db->free_result($query); $alert_id = $fields['id']; $counts = tyl_get_post_tyl_counts($post['pid'], $post['tyl_last_alerted_tyl_id']); $deleted = false; if($counts['new_likes_count'] <= 0) { if($counts['total_likes_count'] <= 0) { $deleted = true; $db->delete_query('alerts', "id={$alert_id}"); } else { $fields = array('unread' => 0); } } else { unset($fields['id']); $extra_details = json_decode($fields['extra_details'], true); $extra_details['total_likes_count'] = $counts['total_likes_count']; $extra_details['new_likes_count' ] = $counts['new_likes_count' ]; $fields['extra_details'] = $db->escape_string(json_encode($extra_details)); if ($from_uid == $fields['from_user_id']) { $tyl_table = TABLE_PREFIX.$prefix.'thankyoulike'; $query2 = $db->query(" SELECT uid FROM {$tyl_table} WHERE tlid = (SELECT MIN(tlid) FROM {$tyl_table} WHERE pid = {$post['pid']} AND tlid > {$post['tyl_last_alerted_tyl_id']} )"); $fields['from_user_id'] = $db->fetch_field($query2, 'uid'); } } if(!$deleted) { $db->update_query('alerts', $fields, 'id = '.$alert_id); } } } } function tyl_myalerts_alert_manager_mark_read($params) { global $mybb, $db; $prefix = 'g33k_thankyoulike_'; if($mybb->settings[$prefix.'enabled'] == "1" && tyl_have_myalerts(true, true, true)) { $alertType = MybbStuff_MyAlerts_AlertTypeManager::getInstance()->getByCode('tyl'); $query = $db->simple_select( 'alerts', 'object_id', 'id in ('.$params['alertIds'].') AND alert_type_id = '.$alertType->getId() ); $pids = array(); while($pid = $db->fetch_field($query, 'object_id')) { $pids[] = $pid; } $db->free_result($query); foreach ($pids as $pid) { $query2 = $db->simple_select($prefix.'thankyoulike', 'MAX(tlid) AS tyl_last_alerted_tyl_id', "pid = {$pid}"); $tyl_last_alerted_tyl_id = $db->fetch_field($query2, 'tyl_last_alerted_tyl_id'); if (!$tyl_last_alerted_tyl_id) { $tyl_last_alerted_tyl_id = 0; } $db->update_query('posts', array('tyl_last_alerted_tyl_id' => $tyl_last_alerted_tyl_id), "pid = {$pid}"); } } } /** * Returns an array containing two elements: * 1. `total_likes_count`: the total count of likes for the post with pid $pid. * 2. `new_likes_count` : the count of new likes for that post, being those * since the last alert for that post was clicked on by the post's author, * at which point the maximum like ID for that post was $tyl_last_alerted_tyl_id. */ function tyl_get_post_tyl_counts($pid, $tyl_last_alerted_tyl_id) { global $db; $prefix = 'g33k_thankyoulike_'; $tyl_table = TABLE_PREFIX.$prefix.'thankyoulike'; $query = $db->query(" SELECT COUNT(*) AS total_likes_count, (SELECT COUNT(*) FROM {$tyl_table} WHERE pid = {$pid} AND tlid > {$tyl_last_alerted_tyl_id}) AS new_likes_count FROM {$tyl_table} WHERE pid = {$pid}"); return $db->fetch_array($query); } /** * Defines the tyl alert formatter class and registers it with the MyAlerts plugin. * Assumes that checks for the presence of and integration with MyAlerts * have already been successfully performed. */ function tyl_myalerts_formatter_load() { global $mybb, $lang; if (class_exists('MybbStuff_MyAlerts_Formatter_AbstractFormatter') && class_exists('MybbStuff_MyAlerts_AlertFormatterManager')) { class ThankyouAlertFormatter extends MybbStuff_MyAlerts_Formatter_AbstractFormatter { public function formatAlert(MybbStuff_MyAlerts_Entity_Alert $alert, array $outputAlert) { global $mybb; $prefix = 'g33k_thankyoulike_'; if($mybb->settings[$prefix.'thankslike'] == "like") { $key_tyl_you_for_sm = 'tyl_likeyoufor_sm' ; $key_tyls_you_for_sm = 'tyl_likesyoufor_sm'; } else { $key_tyl_you_for_sm = 'tyl_thankyoufor_sm' ; $key_tyls_you_for_sm = 'tyl_thanksyoufor_sm'; } $alertContent = $alert->getExtraDetails(); $postLink = $this->buildShowLink($alert); switch($alertContent['total_likes_count']) { case 1: return $this->lang->sprintf( $this->lang->tyl_alert_one_tyl, $outputAlert['from_user'], $this->lang->$key_tyls_you_for_sm, $alertContent['t_subject'] ); case 2: return $this->lang->sprintf( $this->lang->tyl_alert_two_tyls, $outputAlert['from_user'], $alertContent['new_likes_count'], $this->lang->$key_tyl_you_for_sm, $alertContent['t_subject'] ); default: // Three or more tyls return $this->lang->sprintf( $this->lang->tyl_alert_three_or_more_tyls, $outputAlert['from_user'], $alertContent['total_likes_count'] - 1, $alertContent['new_likes_count'], $this->lang->$key_tyl_you_for_sm, $alertContent['t_subject'] ); } } public function init() { if(!$this->lang->thankyoulike) { $this->lang->load('thankyoulike'); } } public function buildShowLink(MybbStuff_MyAlerts_Entity_Alert $alert) { $alertContent = $alert->getExtraDetails(); $postLink = $this->mybb->settings['bburl'] . '/' . get_post_link((int)$alertContent['pid'], (int)$alertContent['tid']).'#pid'.(int)$alertContent['pid']; return $postLink; } } $code = 'tyl'; $formatterManager = MybbStuff_MyAlerts_AlertFormatterManager::getInstance(); if (!$formatterManager) { $formatterManager = MybbStuff_MyAlerts_AlertFormatterManager::createInstance($mybb, $lang); } if ($formatterManager) { $formatterManager->registerFormatter(new ThankyouAlertFormatter($mybb, $lang, $code)); } } } function thankyoulike_memprofile() { global $db, $mybb, $lang, $memprofile, $templates, $tyl_memprofile, $tyl_profile_stats, $uid, $post; $prefix = 'g33k_thankyoulike_'; $lang->load("thankyoulike"); if ($mybb->settings[$prefix.'enabled'] == "1") { $key_tyls = 'tyl_'.tyl_get_lang_key_likes_or_thanks('s'); $key_tyled = 'tyl_'.tyl_get_lang_key_likes_or_thanks('ed'); $lang->tyl_total_tyls_rcvd = $lang->sprintf($lang->tyl_total_tyls_rcvd , $lang->$key_tyls); $lang->tyl_total_tyls_given = $lang->sprintf($lang->tyl_total_tyls_given , $lang->$key_tyls); $lang->tyl_find_threads = $lang->sprintf($lang->tyl_find_tyled_threads , $lang->$key_tyled); $lang->tyl_find_posts = $lang->sprintf($lang->tyl_find_tyled_posts , $lang->$key_tyled); $lang->tyl_find_threads_for = $lang->sprintf($lang->tyl_find_tyled_threads_for, $lang->$key_tyled); $lang->tyl_find_posts_for = $lang->sprintf($lang->tyl_find_tyled_posts_for , $lang->$key_tyled); tyl_check_remove_self_likes_from_post_array($memprofile, true); $daysreg = (TIME_NOW - $memprofile['regdate']) / (24*3600); $tylpd = $memprofile['tyl_unumtyls_self_rem'] / $daysreg; $tylpd = round($tylpd, 2); if($tylpd > $memprofile['tyl_unumtyls_self_rem']) { $tylpd = $memprofile['tyl_unumtyls_self_rem']; } $tylrcvpd = $memprofile['tyl_unumrcvtyls_self_rem'] / $daysreg; $tylrcvpd = round($tylrcvpd, 2); if($tylrcvpd > $memprofile['tyl_unumrcvtyls_self_rem']) { $tylrcvpd = $memprofile['tyl_unumrcvtyls_self_rem']; } // Get total tyl and percentage $query1 = $db->query("SELECT SUM(tyl_unumtyls) as totalgiv, SUM(tyl_unumrcvtyls) as totalrcv FROM ".TABLE_PREFIX."users"); if($total = $db->fetch_array($query1)) { $totalgiv = (int)$total['totalgiv']; $totalrcv = (int)$total['totalrcv']; } if($mybb->settings[$prefix.'remowntylfromc'] == 1) { $owntyltotalcount = tyl_get_own_tyl_count(); $totalgiv -= $owntyltotalcount; $totalrcv -= $owntyltotalcount; } if($totalgiv > 0) { $percent = $memprofile['tyl_unumtyls_self_rem']*100/$totalgiv; $percent = round($percent, 2); } else { $percent = "0"; } if($totalrcv > 0) { $percent_rcv = $memprofile['tyl_unumrcvtyls_self_rem']*100/$totalrcv; $percent_rcv = round($percent_rcv, 2); } else { $percent_rcv = "0"; } if($percent > 100) { $percent = 100; } if($percent_rcv > 100) { $percent_rcv = 100; } if($memprofile['tyl_unumrcvtyls_self_rem'] > 0) { eval("\$tylrcvdlikessearch = \"".$templates->get("thankyoulike_member_profile_rcvd_search")."\";"); } else { $tylrcvdlikessearch = ''; } if($memprofile['tyl_unumtyls_self_rem'] > 0) { eval("\$tylgivenlikessearch = \"".$templates->get("thankyoulike_member_profile_given_search")."\";"); } else { $tylgivenlikessearch = ''; } $memprofile['tyl_unumtyls_fmt' ] = my_number_format ($memprofile['tyl_unumtyls_self_rem' ]); $memprofile['tyl_unumrcvtyls_fmt'] = tyl_fmt_rcvd_tyls_count ($memprofile['tyl_unumrcvtyls_self_rem']); $tylpd_percent_total = $lang->sprintf($lang->tyl_tylpd_percent_total, my_number_format($tylpd ), $percent , $totalgiv); $tylrcvpd_percent_total = $lang->sprintf($lang->tyl_tylpd_percent_total, my_number_format($tylrcvpd), $percent_rcv, $totalrcv); eval("\$tyl_memprofile = \"".$templates->get("thankyoulike_member_profile")."\";"); // Member Profile Box Start if($mybb->settings[$prefix.'show_memberprofile_box'] != 0) { global $theme, $tyl_profile_box, $tyl_profile_box_content; $tyl_profile_box = $tyl_profile_box_content = ""; if($mybb->settings[$prefix.'thankslike'] == "like") { $lang->tyl_profile_box_thead = $lang->sprintf($lang->tyl_profile_box_thead, $memprofile['username'], $lang->tyl_liked); $lang->tyl_profile_box_number = $lang->sprintf($lang->tyl_profile_box_number, $lang->tyl_likes); $lang->tyl_profile_box_content_none = $lang->sprintf($lang->tyl_profile_box_content_none, $memprofile['username'], $lang->tyl_liked_sm); } elseif($mybb->settings[$prefix.'thankslike'] == "thanks") { $lang->tyl_profile_box_thead = $lang->sprintf($lang->tyl_profile_box_thead, $memprofile['username'], $lang->tyl_thanked); $lang->tyl_profile_box_number = $lang->sprintf($lang->tyl_profile_box_number, $lang->tyl_thanks); $lang->tyl_profile_box_content_none = $lang->sprintf($lang->tyl_profile_box_content_none, $memprofile['username'], $lang->tyl_thanked_sm); } $unviewwhere = ''; $unviewable = get_unviewable_forums(true); if($unviewable) { $unviewwhere = " AND p.fid NOT IN ($unviewable)"; } $inactive = get_inactive_forums(); if($inactive) { $unviewwhere .= " AND p.fid NOT IN ($inactive)"; } $query = $db->query(" SELECT l.pid, count( * ) AS tylcount, p.subject, p.username, p.message, p.dateline, p.tid, p.fid, f.parentlist, t.poll as threadpoll, t.prefix as threadprefix FROM ".TABLE_PREFIX."g33k_thankyoulike_thankyoulike l LEFT JOIN ".TABLE_PREFIX."posts p ON (l.pid=p.pid) LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid) LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid = t.fid) WHERE p.visible='1' AND l.puid = {$memprofile['uid']}{$unviewwhere} GROUP BY l.pid ORDER BY tylcount DESC, l.pid ASC LIMIT 0,1" ); if($post = $db->fetch_array($query)) { global $parser; if(!$parser) { require_once MYBB_ROOT."inc/class_parser.php"; $parser = new postParser; } $parser_options = array( "allow_html" => (int)$mybb->settings[$prefix.'profile_box_post_allowhtml'], "allow_mycode" => (int)$mybb->settings[$prefix.'profile_box_post_allowmycode'], "allow_smilies" => (int)$mybb->settings[$prefix.'profile_box_post_allowsmilies'], "allow_imgcode" => (int)$mybb->settings[$prefix.'profile_box_post_allowimgcode'], "allow_videocode" => (int)$mybb->settings[$prefix.'profile_box_post_allowvideocode'], "nofollow_on" => 1, "filter_badwords" => 1 ); $postlink = get_post_link($post['pid'], $post['tid'])."#pid".$post['pid']; $thread = get_thread($post['tid']); $threadlink = get_thread_link($post['tid']); $forum_links = ''; if ($mybb->settings[$prefix.'profile_box_show_parent_forums'] == 1) { $forum_names = array(); $res = $db->simple_select('forums', 'fid,name', 'fid IN ('.$post['parentlist'].')'); while (($forum = $db->fetch_array($res))) { $forum_names[$forum['fid']] = $forum['name']; } $fids = explode(',', $post['parentlist']); $fid_last = array_pop($fids); foreach ($fids as $fid2) { if ($forum_links) eval('$forum_links .= "'.$templates->get('thankyoulike_forum_separator').'";'); $forum_url = get_forum_link($fid2); $forum_name = htmlspecialchars_uni($forum_names[$fid2]); eval('$forum_links .= "'.$templates->get('thankyoulike_forum_link').'";'); } eval('$forum_links .= "'.$templates->get('thankyoulike_forum_separator_last').'";'); $forum_url = get_forum_link($fid_last); $forum_name = htmlspecialchars_uni($forum_names[$fid_last]); } else { $forum_url = get_forum_link($post['fid']); $forum = get_forum($post['fid']); $forum_name = htmlspecialchars_uni($forum['name']); } eval('$forum_links .= "'.$templates->get('thankyoulike_forum_link').'";'); $post['subject'] = htmlspecialchars_uni($post['subject']); $memprofile['tylsubject'] = "{$parser->parse_badwords($post['subject'])}"; $memprofile['tylcount'] = tyl_fmt_rcvd_tyls_count((int)$post['tylcount'], $postlink); $memprofile['tyldatetime'] = my_date('relative', $post['dateline']); $cut_post_off = ($mybb->settings[$prefix.'profile_box_post_cutoff'] > 0 && my_strlen($post['message']) > $mybb->settings[$prefix.'profile_box_post_cutoff']); if($cut_post_off) { if($mybb->settings[$prefix.'profile_box_post_cutoff'] < 4) { $mybb->settings[$prefix.'profile_box_post_cutoff'] = 4; } $post['message'] = my_substr($post['message'], 0, $mybb->settings[$prefix.'profile_box_post_cutoff']-3, 0)."..."; } $memprofile['tylmessage'] = $parser->parse_message($post['message'], $parser_options); if ($cut_post_off) { eval("\$memprofile['tylmessage'] .= \"".$templates->get("thankyoulike_member_profile_box_continue_reading")."\";"); } $thread['subject'] = htmlspecialchars_uni($thread['subject']); $memprofile['tylthreadname'] = "{$parser->parse_badwords($thread['subject'])}"; $memprofile['tylforums'] = $forum_links; $memprofile['threadprefix'] = ''; if ($post['threadpoll']) { $memprofile['threadprefix'] = $lang->poll_prefix.' '; } if ($post['threadprefix'] != 0) { $threadprefix_a = build_prefixes($post['threadprefix']); if (!empty($threadprefix_a)) { $memprofile['threadprefix'] .= $threadprefix_a['displaystyle'].' '; } } eval("\$tyl_profile_box_content = \"".$templates->get("thankyoulike_member_profile_box_content")."\";"); } else { eval("\$tyl_profile_box_content = \"".$templates->get("thankyoulike_member_profile_box_content_none")."\";"); } eval("\$tyl_profile_box = \"".$templates->get("thankyoulike_member_profile_box")."\";"); } // Member Profile Box End if($mybb->settings[$prefix.'show_memberprofile_stats'] != 0) { if($mybb->settings[$prefix.'thankslike'] == 'thanks') { $key_tyls = 'tyl_thanks' ; $key_tyled_sm = 'tyl_thanked_sm'; } else { $key_tyls = 'tyl_likes' ; $key_tyled_sm = 'tyl_liked_sm'; } tyl_set_lang_rcvd_given(); $lang->tyl_most_tyled_by = $lang->sprintf($lang->tyl_most_tyled_by , $lang->$key_tyled_sm); $lang->tyl_most_tyled = $lang->sprintf($lang->tyl_most_tyled , $lang->$key_tyled_sm);; $lang->tyl_no_most_tyledby = $lang->sprintf($lang->tyl_no_most_tyledby, $memprofile['username'], $lang->$key_tyled_sm); $lang->tyl_no_most_tyled = $lang->sprintf($lang->tyl_no_most_tyled , $memprofile['username'], $lang->$key_tyled_sm); $lang->load('reputation'); $week = 60*60*24*7; $month = round(60*60*24*365/12); $threemonths = $month*3; $sixmonths = $threemonths*2; $twelvemonths = 60*60*24*365; $now = TIME_NOW; $tyl_table = TABLE_PREFIX.$prefix.'thankyoulike'; $exclconds = tyl_get_exclude_conds(); if($exclconds) { $exclconds = ' AND '.$exclconds; } $sql_rcv = " SELECT t.period, COUNT(*) AS cnt FROM (SELECT CASE WHEN tyl.dateline >= {$now} - {$week} THEN 'week' WHEN tyl.dateline >= {$now} - {$month} THEN 'month' WHEN tyl.dateline >= {$now} - {$threemonths} THEN '3months' WHEN tyl.dateline >= {$now} - {$sixmonths} THEN '6months' WHEN tyl.dateline >= {$now} - {$twelvemonths} THEN '12months' ELSE 'all' END period FROM {$tyl_table} tyl LEFT OUTER JOIN ".TABLE_PREFIX."posts p ON tyl.pid = p.pid WHERE tyl.puid = {$memprofile['uid']}{$exclconds} ) t GROUP BY t.period"; $query_rcv = $db->query($sql_rcv); $counts_rcv = array(); while ($row = $db->fetch_array($query_rcv)) { $counts_rcv[$row['period']] = $row['cnt']; } $db->free_result($query_rcv); $tyl_received_week = (!empty($counts_rcv['week' ]) ? $counts_rcv['week' ] : 0); $tyl_received_month = $tyl_received_week + (!empty($counts_rcv['month' ]) ? $counts_rcv['month' ] : 0); $tyl_received_3months = $tyl_received_month + (!empty($counts_rcv['3months' ]) ? $counts_rcv['3months' ] : 0); $tyl_received_6months = $tyl_received_3months + (!empty($counts_rcv['6months' ]) ? $counts_rcv['6months' ] : 0); $tyl_received_12months = $tyl_received_6months + (!empty($counts_rcv['12months']) ? $counts_rcv['12months'] : 0); $tyl_received_all = $tyl_received_12months + (!empty($counts_rcv['all' ]) ? $counts_rcv['all' ] : 0); $sql_gv = str_replace('tyl.puid = ', 'tyl.uid = ', $sql_rcv); $query_gv = $db->query($sql_gv); $counts_gv = array(); while ($row = $db->fetch_array($query_gv)) { $counts_gv[$row['period']] = $row['cnt']; } $db->free_result($query_gv); $tyl_given_week = (!empty($counts_gv['week' ]) ? $counts_gv['week' ] : 0); $tyl_given_month = $tyl_given_week + (!empty($counts_gv['month' ]) ? $counts_gv['month' ] : 0); $tyl_given_3months = $tyl_given_month + (!empty($counts_gv['3months' ]) ? $counts_gv['3months' ] : 0); $tyl_given_6months = $tyl_given_3months + (!empty($counts_gv['6months' ]) ? $counts_gv['6months' ] : 0); $tyl_given_12months = $tyl_given_6months + (!empty($counts_gv['12months']) ? $counts_gv['12months'] : 0); $tyl_given_all = $tyl_given_12months + (!empty($counts_gv['all' ]) ? $counts_gv['all' ] : 0); $max_likers = 5; $tyl_most_likedby_users = tyl_get_memprofile_stats_most_liked_tr($max_likers, $memprofile['uid'], $tyl_received_all, 'likedby'); $tyl_most_liked_users = tyl_get_memprofile_stats_most_liked_tr($max_likers, $memprofile['uid'], $tyl_given_all , 'liked' ); $tyl_profile_stats_head = $lang->sprintf($lang->tyl_profile_stats_head, $memprofile['username'], $lang->$key_tyls); eval('$tyl_profile_stats = "'.$templates->get('thankyoulike_member_profile_like_stats').'";'); } } } function tyl_get_memprofile_stats_most_liked_tr($max_likers, $prof_uid, $tot_likes, $which = 'likedby') { global $db, $templates, $lang, $mybb; $prefix = 'g33k_thankyoulike_'; $ret = ''; $sql = tyl_get_most_tylers_sql($max_likers, $prof_uid, $which); $query = $db->query($sql); while($row = $db->fetch_array($query)) { $tyl_cnt = $row['cnt']; $tyl_cnt_pc = tyl_format_percentage($tot_likes > 0 ? round($row['cnt']*100/$tot_likes) : 0); if($row['username']) { $tyl_username = $mybb->settings[$prefix.'unameformat'] == "1" ? format_name($row['username'], $row['usergroup'], $row['displaygroup']) : $row['username']; $tyl_profilelink = get_profile_link($row['uid']); eval('$tyl_member_link = "'.$templates->get('thankyoulike_member_link').'";'); } else { $tyl_member_link = $lang->tyl_deleted_member_name; } eval('$ret .= "'.$templates->get("thankyoulike_member_profile_like_stats_most_{$which}_row").'";'); } if(!$ret) { eval('$ret .= "'.$templates->get("thankyoulike_member_profile_like_stats_no_most_{$which}").'";'); } return $ret; } function tyl_format_percentage($pc) { global $lang; return $lang->sprintf($lang->tyl_pc, $pc); } function tyl_get_exclude_conds() { global $mybb; $prefix = 'g33k_thankyoulike_'; $conds = ''; if($mybb->settings[$prefix.'remowntylfromc'] == 1) { $conds = 'tyl.uid<>tyl.puid'; } $excl_count_forums = trim($mybb->settings[$prefix.'exclude_count']); $exclcountcond = ''; if($excl_count_forums == -1) { $exclcountcond = '0=1'; } else if($excl_count_forums != '') { $exclcountcond = "p.fid NOT IN ({$excl_count_forums})"; } if($exclcountcond) { if($conds) { $conds .= ' AND '; } $conds .= $exclcountcond; } return $conds; } function tyl_get_most_tylers_sql($max_likers, $uid, $which = 'likedby') { global $mybb; $prefix = 'g33k_thankyoulike_'; $tyl_table = TABLE_PREFIX.$prefix.'thankyoulike'; if($which == 'liked') { $uidkey1 = 'uid'; $uidkey2 = 'puid'; } else // assume $which == 'likedby' { $uidkey1 = 'puid'; $uidkey2 = 'uid'; } $exclconds = tyl_get_exclude_conds(); if($exclconds) { $exclconds = ' AND '.$exclconds; } return " SELECT u.uid, u.username, u.usergroup, u.displaygroup, COUNT(*) AS cnt FROM {$tyl_table} tyl LEFT OUTER JOIN ".TABLE_PREFIX."users u ON tyl.{$uidkey2} = u.uid LEFT OUTER JOIN ".TABLE_PREFIX."posts p ON tyl.pid = p.pid WHERE tyl.{$uidkey1} = {$uid}{$exclconds} GROUP BY tyl.{$uidkey2} ORDER BY cnt DESC LIMIT {$max_likers} "; } function thankyoulike_delete_thread($tid) { global $db; $prefix = 'g33k_thankyoulike_'; $thread = get_thread($tid); // Find all tyl data for this tid $query = $db->query(" SELECT tyl.* FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=tyl.pid) WHERE p.tid='{$tid}' "); $tlids = array(); $user_tyls = array(); $user_prcvtyls = array(); while($tyl_post = $db->fetch_array($query)) { $tlids[] = $tyl_post['tlid']; // Count # of posts and # of thanks received for every post to be subtracted if($user_prcvtyls[$tyl_post['puid']][$tyl_post['pid']]) { $user_prcvtyls[$tyl_post['puid']][$tyl_post['pid']]--; } else { $user_prcvtyls[$tyl_post['puid']][$tyl_post['pid']] = -1; } // Count the tyl counts for each user to be subtracted if($user_tyls[$tyl_post['uid']]) { $user_tyls[$tyl_post['uid']]--; } else { $user_tyls[$tyl_post['uid']] = -1; } } // Remove tyl count from users foreach($user_tyls as $uid => $subtract) { $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumtyls=tyl_unumtyls$subtract WHERE uid='$uid'"); } foreach($user_prcvtyls as $puid => $value) { $rcv = 0; $prcv = count($value); foreach($value as $ppid => $value1) { $rcv = $rcv + $value1; } $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumptyls=tyl_unumptyls-$prcv WHERE uid='$puid'"); $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumrcvtyls=tyl_unumrcvtyls$rcv WHERE uid='$puid'"); } // Delete the tyls if($tlids) { $tlids_count = count($tlids); $tlids = implode(',', $tlids); $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."stats SET value=value-$tlids_count WHERE title='total'"); $db->delete_query($prefix."thankyoulike", "tlid IN ($tlids)"); } } function thankyoulike_delete_post($pid) { global $db; $prefix = 'g33k_thankyoulike_'; $pid = intval($pid); $query = $db->simple_select("posts", "*", "pid='".$pid."'"); $post = $db->fetch_array($query); // Only delete if there are any tyls if($post['tyl_pnumtyls'] != 0) { // Find all tyl data for this pid $query = $db->query(" SELECT tyl.* FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl WHERE tyl.pid='{$pid}' "); $tlids = array(); $user_tyls = array(); while($tyl_post = $db->fetch_array($query)) { $tlids[] = $tyl_post['tlid']; // Count the tyl counts for each user to be subtracted if($user_tyls[$tyl_post['uid']]) { $user_tyls[$tyl_post['uid']]--; } else { $user_tyls[$tyl_post['uid']] = -1; } } // Remove tyl count from users if(is_array($user_tyls)) { foreach($user_tyls as $uid => $subtract) { $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumtyls=tyl_unumtyls$subtract WHERE uid='$uid'"); } } // Delete the tyls if($tlids) { $tlids_count = count($tlids); $tlids = implode(',', $tlids); $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumrcvtyls=tyl_unumrcvtyls-$tlids_count WHERE uid='".$post['uid']."'"); $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumptyls=tyl_unumptyls-1 WHERE uid='".$post['uid']."'"); $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."stats SET value=value-$tlids_count WHERE title='total'"); $db->delete_query($prefix."thankyoulike", "tlid IN ($tlids)"); } } } function thankyoulike_merge_posts($args) { global $db; $prefix = 'g33k_thankyoulike_'; $pids = $args['pids']; $tid = $args['tid']; $pidin = implode(',', $pids); // We first check which is the masterpid where others were merged, other posts should be gone by now $query1 = $db->simple_select("posts", "pid, uid", "pid IN ($pidin)"); $master = $db->fetch_array($query1); // Get all the tyls for all the pids to be merged $query = $db->query(" SELECT tyl.* FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl WHERE tyl.pid IN($pidin) ORDER BY tyl.pid ASC, tyl.dateline ASC "); $masterpiduid = array(); $tlids_remove = array(); $tlids_update = array(); $user_tyls = array(); $user_ptyls = array(); $user_rcvtyls = array(); while($tyl = $db->fetch_array($query)) { if($master['pid'] == $tyl['pid']) { // User has tyled master post $masterpiduid[$tyl['uid']] = 1; } else { if(($masterpiduid[$tyl['uid']]) || $tyl['uid'] == $master['uid']) { // User has tyled master post or is author of master post, remove tyl, update count $tlids_remove[] = $tyl['tlid']; if($user_tyls[$tyl['uid']]) { $user_tyls[$tyl['uid']]--; } else { $user_tyls[$tyl['uid']] = -1; } if($user_rcvtyls[$tyl['puid']][$tyl['pid']]) { $user_rcvtyls[$tyl['puid']][$tyl['pid']]--; } else { $user_rcvtyls[$tyl['puid']][$tyl['pid']] = -1; } } else { // User has not tyled master post, add it to the master post $tlids_update[] = $tyl['tlid']; } } } // Remove tyl count from users if(is_array($user_tyls)) { foreach($user_tyls as $uid => $subtract) { $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumtyls=tyl_unumtyls$subtract WHERE uid='$uid'"); } } if(is_array($user_rcvtyls)) { foreach($user_rcvtyls as $puid => $value) { $rcv = 0; $prcv = count($value); foreach($value as $ppid => $value1) { $rcv = $rcv + $value1; } $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumptyls=tyl_unumptyls-$prcv WHERE uid='$puid'"); $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumrcvtyls=tyl_unumrcvtyls$rcv WHERE uid='$puid'"); } } // Update the tyls moving to the masterpid and add them as tyls received to master post uid if($tlids_update) { $tlids_update_count = count($tlids_update); $tlids_update = implode(',', $tlids_update); $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumrcvtyls=tyl_unumrcvtyls+$tlids_update_count WHERE uid='".$master['uid']."'"); $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."thankyoulike SET pid=".$master['pid'].", puid=".$master['uid']." WHERE tlid IN ($tlids_update)"); } // Update overall tyl count and remove old tyls if($tlids_remove) { $tlids_count = count($tlids_remove); $tlids_remove = implode(',', $tlids_remove); $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."stats SET value=value-$tlids_count WHERE title='total'"); // Delete the tyls $db->delete_query($prefix."thankyoulike", "tlid IN ($tlids_remove)"); } } function thankyoulike_delete_user() { global $db, $user; $prefix = 'g33k_thankyoulike_'; // Only delete/update if the user had tyls if($user['tyl_unumtyls'] != 0) { // Find all tyl data for this user $query = $db->query(" SELECT tyl.*, p.tid FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=tyl.pid) WHERE tyl.uid='".$user['uid']."' "); $tlids = array(); $post_tyls = array(); $user_tyls = array(); while($tyl_user = $db->fetch_array($query)) { $tlids[] = $tyl_user['tlid']; // Count the tyl counts for each post to be subtracted if($post_tyls[$tyl_user['pid']]) { $post_tyls[$tyl_user['pid']]--; } else { $post_tyls[$tyl_user['pid']] = -1; } // Count tyls received by this user to be removed if($user_tyls[$tyl_user['puid']]) { $user_tyls[$tyl_user['puid']]--; } else { $user_tyls[$tyl_user['puid']] = -1; } } // Remove tyl count from posts if(is_array($post_tyls)) { foreach($post_tyls as $pid => $subtract) { $db->write_query("UPDATE ".TABLE_PREFIX."posts SET tyl_pnumtyls=tyl_pnumtyls$subtract WHERE pid='$pid'"); } } // Remove tyl received count from users if(is_array($user_tyls)) { foreach($user_tyls as $puid => $subtract) { $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumrcvtyls=tyl_unumrcvtyls$subtract WHERE uid='$puid'"); } } // Delete the tyls, update total if($tlids) { $tlids_count = count($tlids); $tlids = implode(',', $tlids); $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."stats SET value=value-$tlids_count WHERE title='total'"); $db->delete_query($prefix."thankyoulike", "tlid IN ($tlids)"); } } } function thankyoulike_wol_activity($user_activity) { global $user, $location; $split_loc = explode(".php", $user_activity['location']); if(isset($user['location']) && $split_loc[0] == $user['location']) { $filename = ''; } else { $filename = my_substr($split_loc[0], -my_strpos(strrev($split_loc[0]), "/")); } if ($filename == "tylsearch") { $user_activity['activity'] = "tyl_searching"; } return $user_activity; } function thankyoulike_friendly_wol_activity($plugin_array) { global $mybb, $lang; $prefix = 'g33k_thankyoulike_'; $lang->load("thankyoulike"); if ($plugin_array['user_activity']['activity'] == "tyl_searching") { if ($mybb->settings[$prefix.'thankslike'] == "like") { $plugin_array['location_name'] = $lang->sprintf($lang->tyl_wol_searching, "tylsearch.php", $lang->tyl_likes); } else { $plugin_array['location_name'] = $lang->sprintf($lang->tyl_wol_searching, "tylsearch.php", $lang->tyl_thanks); } } return $plugin_array; } function thankyoulike_settings_page() { global $db, $mybb, $g33k_settings_peeker; $prefix = 'g33k_thankyoulike_'; $query = $db->simple_select("settinggroups", "gid", "name='{$prefix}settings'", array('limit' => 1)); $group = $db->fetch_array($query); $g33k_settings_peeker = ($mybb->input["gid"] == $group["gid"]) && ($mybb->request_method != "post"); } function thankyoulike_settings_peeker() { global $g33k_settings_peeker; $prefix = 'g33k_thankyoulike_'; if($g33k_settings_peeker) { echo ''; } } // Start Thank You/Like Promotions Functions function thankyoulike_promotion_formcontainer_output_row(&$args) { global $run_module, $form_container, $mybb, $lang, $form, $options, $options_type, $promotion; if(!($run_module == 'user' && !empty($form_container->_title) && $mybb->get_input('module') == 'user-group_promotions' && in_array($mybb->get_input('action'), array('add', 'edit')))) { return; } $lang->load('config_thankyoulike'); if($args['label_for'] == 'requirements') { $options['tylreceived'] = $lang->setting_thankyoulike_promotion_rcv; $args['content'] = $form->generate_select_box('requirements[]', $options, $mybb->input['requirements'], array('id' => 'requirements', 'multiple' => true, 'size' => 5)); } if($args['label_for'] == 'timeregistered') { if($mybb->get_input('pid', 1) && !isset($mybb->input['tylreceived'])) { $tylreceived = $promotion['tylreceived']; $tylreceivedtype = $promotion['tylreceivedtype']; } else { $tylreceived = $mybb->get_input('tylreceived'); $tylreceivedtype = $mybb->get_input('tylreceivedtype'); } $form_container->output_row($lang->setting_thankyoulike_promotion_rcv, $lang->setting_thankyoulike_promotion_rcv_desc, $form->generate_numeric_field('tylreceived', (int)$tylreceived, array('id' => 'tylreceived'))." ".$form->generate_select_box("tylreceivedtype", $options_type, $tylreceivedtype, array('id' => 'tylreceivedtype')), 'tylreceived'); } if($args['label_for'] == 'requirements') { $options['tylgiven'] = $lang->setting_thankyoulike_promotion_gvn; $args['content'] = $form->generate_select_box('requirements[]', $options, $mybb->input['requirements'], array('id' => 'requirements', 'multiple' => true, 'size' => 5)); } if($args['label_for'] == 'timeregistered') { if($mybb->get_input('pid', 1) && !isset($mybb->input['tylgiven'])) { $tylgiven = $promotion['tylgiven']; $tylgiventype = $promotion['tylgiventype']; } else { $tylgiven = $mybb->get_input('tylgiven'); $tylgiventype = $mybb->get_input('tylgiventype'); } $form_container->output_row($lang->setting_thankyoulike_promotion_gvn, $lang->setting_thankyoulike_promotion_gvn_desc, $form->generate_numeric_field('tylgiven', (int)$tylgiven, array('id' => 'tylgiven'))." ".$form->generate_select_box("tylgiventype", $options_type, $tylgiventype, array('id' => 'tylgiventype')), 'tylgiven'); } } function thankyoulike_promotion_commit() { global $db, $mybb, $pid, $update_promotion; is_array($update_promotion) or $update_promotion = array(); $update_promotion['tylreceived'] = $mybb->get_input('tylreceived', 1); $update_promotion['tylreceivedtype'] = $db->escape_string($mybb->get_input('tylreceivedtype')); $update_promotion['tylgiven'] = $mybb->get_input('tylgiven', 1); $update_promotion['tylgiventype'] = $db->escape_string($mybb->get_input('tylgiventype')); if($mybb->get_input('action') == 'add') { $db->update_query('promotions', $update_promotion, "pid='{$pid}'"); } } function thankyoulike_promotion_task(&$args) { if(in_array('tylreceived', explode(',', $args['promotion']['requirements'])) && (int)$args['promotion']['tylreceived'] >= 0 && !empty($args['promotion']['tylreceivedtype'])) { $args['sql_where'] .= "{$args['and']}tyl_unumrcvtyls{$args['promotion']['tylreceivedtype']}'{$args['promotion']['tylreceived']}'"; $args['and'] = ' AND '; } if(in_array('tylgiven', explode(',', $args['promotion']['requirements'])) && (int)$args['promotion']['tylgiven'] >= 0 && !empty($args['promotion']['tylgiventype'])) { $args['sql_where'] .= "{$args['and']}tyl_unumtyls{$args['promotion']['tylgiventype']}'{$args['promotion']['tylgiven']}'"; $args['and'] = ' AND '; } } // Start Thank You/Like Counter Functions function acp_tyl_do_recounting() { global $db, $mybb, $lang; $prefix = "g33k_thankyoulike_"; $lang->load("config_thankyoulike"); if($mybb->request_method == "post") { if(!isset($mybb->input['page']) || $mybb->get_input('page', MyBB::INPUT_INT) < 1) { $mybb->input['page'] = 1; } if(isset($mybb->input['do_recounttyls'])) { if($mybb->input['page'] == 1) { // Log admin action log_admin_action($lang->tyl_admin_log_action); } if(!$mybb->get_input('tyls', MyBB::INPUT_INT)) { $mybb->input['tyls'] = 500; } $page = $mybb->get_input('page', MyBB::INPUT_INT); $per_page = $mybb->get_input('tyls', MyBB::INPUT_INT); if($per_page <= 0) { $per_page = 500; } $start = ($page-1) * $per_page; $end = $start + $per_page; $excl_forums = trim($mybb->settings[$prefix.'exclude']); if($excl_forums == -1) { $where = "WHERE 0=1"; } else if($excl_forums == '') { $where = ''; } else { $where = "WHERE p.fid NOT IN (".$excl_forums.")"; } $excl_count_forums = trim($mybb->settings[$prefix.'exclude_count']); if($excl_count_forums == -1) { $where_post_owner = ($where ? $where." AND" : "WHERE")." 0=1"; } else if($excl_count_forums != '') { $where_post_owner = ($where ? $where." AND" : "WHERE")." p.fid NOT IN (".$excl_count_forums.")"; } else { $where_post_owner = $where; } if ($page == 1) { $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."stats SET value=0 WHERE title='total'"); $db->write_query("UPDATE ".TABLE_PREFIX."posts SET tyl_pnumtyls=0"); $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumtyls=0, tyl_unumptyls=0, tyl_unumrcvtyls=0"); $query = $db->query(" SELECT tyl.tlid FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl LEFT JOIN ".TABLE_PREFIX."posts p ON ( p.pid = tyl.pid ) LEFT JOIN ".TABLE_PREFIX."users u ON ( u.uid = tyl.uid ) WHERE p.pid IS NULL OR u.uid IS NULL "); $tlids_remove = array(); while($orphan = $db->fetch_array($query)) { $tlids_remove[] = $orphan['tlid']; } if($tlids_remove) { $tlids_remove = implode(',', $tlids_remove); // Delete the tyls $db->delete_query($prefix."thankyoulike", "tlid IN ($tlids_remove)"); } // Lets also update the puid field in the db with uid values from the posts table // This is done to sync up the db with the puids of post tyled, since this feature wasn't there in v1.0 so data needs to be generated. $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."thankyoulike tyl LEFT JOIN ".TABLE_PREFIX."posts p ON ( p.pid=tyl.pid ) SET tyl.puid=p.uid"); // Update the number of tyled posts for the post owners, we do this here because this needs to be done in one swoop and will break if done in parts $db->write_query("UPDATE ".TABLE_PREFIX."users u JOIN (SELECT puid, COUNT(DISTINCT(t.pid)) AS pidcount FROM ".TABLE_PREFIX.$prefix."thankyoulike t LEFT JOIN ".TABLE_PREFIX."posts p ON p.pid=t.pid $where_post_owner GROUP BY puid) tyl ON ( u.uid=tyl.puid ) SET u.tyl_unumptyls=tyl.pidcount"); } $query1 = $db->simple_select($prefix."thankyoulike", "COUNT(tlid) AS num_tyls"); $num_tyls = $db->fetch_field($query1, 'num_tyls'); $query2 = $db->query(" SELECT tyl.*, p.tid, p.fid FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=tyl.pid) $where ORDER BY tyl.dateline ASC LIMIT $start, $per_page "); $tlids = array(); $post_tyls = array(); $user_tyls = array(); $user_rcvtyls = array(); while($tyl = $db->fetch_array($query2)) { // Total tyls $tlids[] = $tyl['tlid']; // Count the tyl for each post, thread and user if($post_tyls[$tyl['pid']]) { $post_tyls[$tyl['pid']]++; } else { $post_tyls[$tyl['pid']] = 1; } if(!tyl_in_forums($tyl['fid'], $mybb->settings[$prefix.'exclude_count'])) { if($user_tyls[$tyl['uid']]) { $user_tyls[$tyl['uid']]++; } else { $user_tyls[$tyl['uid']] = 1; } if($user_rcvtyls[$tyl['puid']]) { $user_rcvtyls[$tyl['puid']]++; } else { $user_rcvtyls[$tyl['puid']] = 1; } } } // Update the counts if(is_array($post_tyls)) { foreach($post_tyls as $pid => $add) { $db->write_query("UPDATE ".TABLE_PREFIX."posts SET tyl_pnumtyls=tyl_pnumtyls+$add WHERE pid='$pid'"); } } if(is_array($user_tyls)) { foreach($user_tyls as $uid => $add) { $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumtyls=tyl_unumtyls+$add WHERE uid='$uid'"); } } if(is_array($user_rcvtyls)) { foreach($user_rcvtyls as $puid => $add) { $db->write_query("UPDATE ".TABLE_PREFIX."users SET tyl_unumrcvtyls=tyl_unumrcvtyls+$add WHERE uid='$puid'"); } } if($tlids) { $tlids_count = count($tlids); $db->write_query("UPDATE ".TABLE_PREFIX.$prefix."stats SET value=value+$tlids_count WHERE title='total'"); } check_proceed($num_tyls, $end, ++$page, $per_page, "tyls", "do_recounttyls", $lang->tyl_success_thankyoulike_rebuilt); } else if(isset($mybb->input['do_reinitlasttylid'])) { if($mybb->input['page'] == 1) { // Log admin action log_admin_action($lang->tyl_admin_log_action2); } if(!$mybb->get_input('lasttylids', MyBB::INPUT_INT)) { $mybb->input['lasttylids'] = 500; } $next_pid = $mybb->get_input('page', MyBB::INPUT_INT); $per_page = $mybb->get_input('lasttylids', MyBB::INPUT_INT); if($per_page <= 0) { $per_page = 500; } $res = $db->simple_select('posts', 'MAX(pid) AS max_pid', 'tyl_last_alerted_tyl_id = 0'); $max_pid = $db->fetch_field($res, 'max_pid'); $db->free_result($res); $pids = ''; $res = $db->simple_select('posts', 'pid', "tyl_last_alerted_tyl_id = 0 AND pid >= {$next_pid}", array( 'order_by' => 'pid', 'order_dir' => 'ASC', 'limit' => $per_page )); while($pid = $db->fetch_field($res, 'pid')) { if($pids) { $pids .= ','; } $pids .= $pid; $next_pid = $pid; } $next_pid++; if($pids) { $alerts_sql = ($db->table_exists('alerts') && $db->table_exists('alert_types')) ? "AND NOT EXISTS ( SELECT * FROM ".TABLE_PREFIX."alerts a WHERE p.pid = a.object_id AND alert_type_id = ( SELECT id FROM ".TABLE_PREFIX."alert_types WHERE code='tyl' ) AND unread=1 )" : ''; $db->query(" UPDATE ".TABLE_PREFIX."posts AS dest, ( SELECT p.pid, (SELECT MAX(tyl.tlid) FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl WHERE p.pid = tyl.pid) AS max_tlid FROM ".TABLE_PREFIX."posts p WHERE tyl_last_alerted_tyl_id = 0 {$alerts_sql} AND EXISTS ( SELECT * FROM ".TABLE_PREFIX.$prefix."thankyoulike tyl2 WHERE p.pid = tyl2.pid ) AND p.pid IN ({$pids}) ) AS src SET dest.tyl_last_alerted_tyl_id = src.max_tlid WHERE dest.pid = src.pid"); } check_proceed($max_pid, $next_pid, $next_pid, $per_page, 'per_page', 'do_reinitlasttylid', $lang->tyl_success_thankyoulike_rebuilt2); } } } function acp_tyl_recount_form() { global $lang, $form_container, $form; $lang->load("config_thankyoulike"); $form_container->output_cell("{$lang->tyl_recount}

{$lang->tyl_recount_do_desc}

"); $form_container->output_cell($form->generate_numeric_field("tyls", 500, array('style' => 'width: 150px;', 'min' => 0))); $form_container->output_cell($form->generate_submit_button($lang->go, array("name" => "do_recounttyls"))); $form_container->construct_row(); $form_container->output_cell("{$lang->tyl_recount2}

{$lang->tyl_recount_do_desc2}

"); $form_container->output_cell($form->generate_numeric_field("lasttylids", 500, array('style' => 'width: 150px;', 'min' => 0))); $form_container->output_cell($form->generate_submit_button($lang->go, array("name" => "do_reinitlasttylid"))); $form_container->construct_row(); } function tyl_limits_usergroup_permission() { global $mybb, $lang, $form, $form_container; $prefix = 'g33k_thankyoulike_'; $lang->load("config_thankyoulike"); if($mybb->settings[$prefix.'limits'] == 1) { if(!empty($form_container->_title) & !empty($lang->users_permissions) & $form_container->_title == $lang->users_permissions) { $tyl_limits_options = array( "{$lang->tyl_limits_permissions_title}
{$lang->tyl_limits_permissions_desc}
".$form->generate_numeric_field('tyl_limits_max', $mybb->input['tyl_limits_max'], array('id' => 'max_tyl_limits', 'class' => 'field50', 'min' => 0)), "{$lang->tyl_flood_interval_title}
{$lang->tyl_flood_interval_desc}
".$form->generate_numeric_field('tyl_flood_interval', $mybb->input['tyl_flood_interval'], array('id' => 'max_flood_interval', 'class' => 'field50', 'min' => 0)) ); $form_container->output_row($lang->tyl_limits_permissions_system, "", "

".implode("

", $tyl_limits_options)."

"); } } } function tyl_limits_usergroup_permission_commit() { global $db, $mybb, $updated_group; $updated_group['tyl_limits_max'] = $db->escape_string((int)$mybb->input['tyl_limits_max']); $updated_group['tyl_flood_interval'] = $db->escape_string((int)$mybb->input['tyl_flood_interval']); } function tyl_preinstall_cleanup($for_upgrade = false) { global $db, $cache; $prefix = 'g33k_thankyoulike_'; //delete old unnecessary files if(file_exists(MYBB_ROOT."/admin/modules/tools/thankyoulike_recount.php")) { @unlink(MYBB_ROOT."/admin/modules/tools/thankyoulike_recount.php"); } if(file_exists(MYBB_ROOT."/inc/languages/english/admin/tools_thankyoulike_recount.lang.php")) { @unlink(MYBB_ROOT."/inc/languages/english/admin/tools_thankyoulike_recount.lang.php"); } // This column was dropped in 3.1.0 if($db->field_exists('tyl_tnumtyls', 'threads')) { $db->query("ALTER TABLE ".TABLE_PREFIX."threads DROP column `tyl_tnumtyls`"); } // Remove old templates, except, when we are upgrading, for user-modified templates. $and_where = ($for_upgrade ? ' AND sid=-2' : ''); $db->delete_query("templates", "title LIKE 'thankyoulike%'".$and_where); $db->delete_query("templategroups", "prefix in ('thankyoulike')"); // Remove old CSS rules for g33k_thankyoulike require_once MYBB_ADMIN_DIR."inc/functions_themes.php"; $db->delete_query("themestylesheets", "name='g33k_thankyoulike.css'"); $query = $db->simple_select("themes", "tid"); while($theme = $db->fetch_array($query)) { update_theme_stylesheet_list($theme['tid']); } // Remove old settings $result = $db->simple_select('settinggroups', 'gid', "name = '{$prefix}settings'", array('limit' => 1)); $group = $db->fetch_array($result); if(!empty($group['gid'])) { $db->delete_query('settinggroups', "gid='{$group['gid']}'"); $db->delete_query('settings', "gid='{$group['gid']}'"); if(!$for_upgrade) { rebuild_settings(); } } $cache->update_usergroups(); $cache->update_forums(); $cache->update_tasks(); } /** * Checks whether the value of a forumselect setting is inclusive of * the forum with ID $fid. * * Note: Always returns true when the forum setting is "All" (-1), * regardless of whether or not the forum with the supplied ID exists. * * @param int The ID of the forum for which to check for inclusion. * @param mixed The value of the forumselect setting to check within. * @return boolean True if inclusive; false if not. */ function tyl_in_forums($fid, $forums) { if($forums == -1) { return true; } else { $forums = explode(',', $forums); foreach($forums as $forum_id) { if(trim($forum_id) == $fid) { return true; } } } return false; } function tyl_user_users_merge_commit() { global $db, $source_user, $destination_user; $prefix = 'g33k_thankyoulike_'; $source_uid = $source_user['uid']; $dest_uid = $destination_user['uid']; $pids_liked_by_both = array(); $pids_liked_by_both_sql = 'SELECT pid FROM '.TABLE_PREFIX.$prefix."thankyoulike WHERE uid IN ($source_uid, $dest_uid) GROUP BY pid HAVING count(pid) > 1"; $result = $db->query($pids_liked_by_both_sql); while(($row = $db->fetch_array($result))) { $pids_liked_by_both[] = $row['pid']; } // Subtract from the count of tyls given by the source user the number of posts liked by both users // and add the result to the count of tyls given by the destination user. $dest_tyl_unumtyls = $destination_user['tyl_unumtyls'] + $source_user['tyl_unumtyls'] - count($pids_liked_by_both); $result = $db->query('SELECT pid FROM '.TABLE_PREFIX.$prefix."thankyoulike WHERE puid IN ($source_uid, $dest_uid) AND uid IN ($source_uid, $dest_uid) GROUP BY pid HAVING count(pid) > 1"); $count_of_own_posts_liked_by_both = $db->num_rows($result); // Subtract from the count of tyls received by the source user the number of own posts (of either user) liked by both users // and add the result to the count of tyls received by the dest user. $dest_tyl_unumrcvtyls = $destination_user['tyl_unumrcvtyls'] + $source_user['tyl_unumrcvtyls'] - $count_of_own_posts_liked_by_both; // Add to the count of liked posts of the destination user the count of liked posts of the source user. $dest_tyl_unumptyls = $destination_user['tyl_unumptyls'] + $source_user['tyl_unumptyls']; // Now update those tyl counts for the destination user. $db->update_query('users', array( 'tyl_unumtyls' => $dest_tyl_unumtyls, 'tyl_unumrcvtyls' => $dest_tyl_unumrcvtyls, 'tyl_unumptyls' => $dest_tyl_unumptyls ), "uid='$dest_uid'"); // Delete duplicated tyls from the (prefixed) thankyoulike table if there are any. if($pids_liked_by_both) { $dup_likes_of_source_user_sql = 'DELETE FROM '.TABLE_PREFIX.$prefix."thankyoulike WHERE uid = $source_uid AND puid = $dest_uid AND pid IN (".implode(',', $pids_liked_by_both).")"; $db->write_query($dup_likes_of_source_user_sql); } // Finally, update in the thankyoulike table the uids and puids matching the source user to the user ID of the dest user. $db->update_query($prefix.'thankyoulike', array('uid' => $dest_uid ), "uid='$source_uid'"); $db->update_query($prefix.'thankyoulike', array('puid' => $dest_uid), "puid='$source_uid'"); }