bbPress Showcase Tag: members online

bbPress Showcase Tag: members online http://bbshowcase.org/forums/ bbPress Showcase Tag: members online en Thu, 24 May 2012 15:57:29 +0000 guly on "Members Online - Hide User Online Status" http://bbshowcase.org/forums/topic/members-online-hide-user-online-status#post-2169 Sat, 23 Oct 2010 11:33:54 +0000 guly 2169@http://bbshowcase.org/forums/ I don't have your plugin development skills, unfortunately, though I did hack something up that seems to work OK: 1. Two extra huge queries sounded expensive. So I added a field to bb_users called user_hide. This is probably *heresy* to modify the bb_users table instead of adding to bb_usermeta, but adding to the user table is standard procedure in other forum scripts (such as phpbb) and I assume it's cheaper than querying the database 2-3 times? 2. in functions.bb-core.php, update function bb_get_profile_info_keys to include a profile key tied to user hide: 'user_hide' => array(0, __('Hide online status'), 'checkbox', '1', '0'), 3. in profile-edit.php, under: <code>foreach( $profile_info_keys as $key => $label ) {</code> add: <code> if ($key == 'user_hide') { global $bbdb; //unsure if I need to declare this? $passkey = $$key; //workaround. I don't know how to pass a variable-variable ($$) through MYSQL $bbdb->query( "UPDATE $bbdb->users SET user_hide = '$passkey' WHERE ID = '$user->ID'" ); </code> 4. Updated the query in members_online.php plugin to retrieve the user_hide value: <code> $results=$bbdb->get_results("SELECT ID,user_login,user_hide FROM $bbdb->users LEFT JOIN $bbdb->usermeta ON ID=user_id WHERE meta_key='last_online' AND cast(meta_value AS unsigned)>'$time' ORDER BY meta_value DESC"); </code> 5. Added conditional handling of each displayed name. Instead of just: <code> $output.=" <a rel='nofollow' href='".attribute_escape($uri.$stub)."'>$value</a>, "; </code> Do this instead: <code> //if user_hide is false, then handle it normally. if ($result->user_hide == 0) { $output.=" <a rel='nofollow' href='".attribute_escape($uri.$stub)."'>$value</a>, "; } else { //if user_hide is not false, then only display for Mods/admins, and give it (hidden) formatting. if (($bb_current_user->capabilities[moderator] = true) || ($bb_current_user->capabilities[administrator] = true)) { $output.=" <a rel='nofollow' href='".attribute_escape($uri.$stub)."'>($value)</a>, "; } </code> 7. Setup a cron job on my server to run every 4 min. tried wp-cron but too darn complicated... couldn't figure it out. _ck_ do you think running the cron job every 4 min will pickup all users? Could I set it to run less frequently? _ck_ on "Members Online - Hide User Online Status" http://bbshowcase.org/forums/topic/members-online-hide-user-online-status#post-2168 Fri, 22 Oct 2010 13:37:59 +0000 _ck_ 2168@http://bbshowcase.org/forums/ Actually, you'll have to pull the user_ids and then do a <code>bb_cache_users</code> It will add 2 extra (big) queries for that "feature". The real solution might be to completely rewrite the plugin so it simply builds the resulting string to display every few minutes, instead of doing the queries on each and every page load. Then when it builds the string to display it can check all the options without all the overhead on each page load. It will also become significantly faster for busy sites. Store the string in the regular bb_options. This is about all the help I can give you for now, I am on a bbpress "break" for the rest of the year. Good luck! guly on "Members Online - Hide User Online Status" http://bbshowcase.org/forums/topic/members-online-hide-user-online-status#post-2167 Fri, 22 Oct 2010 13:28:12 +0000 guly 2167@http://bbshowcase.org/forums/ Actually I think it's just fetching ID and user_login. Here is the query: <code>$results=$bbdb->get_results("SELECT ID,user_login FROM $bbdb->users LEFT JOIN $bbdb->usermeta ON ID=user_id WHERE meta_key='last_online' AND cast(meta_value AS unsigned)>'$time' ORDER BY meta_value DESC");</code> If I run a var_dump, here are the variables it's pulling up: <code>now : array(1) { [0]=> object(stdClass)#103 (2) { ["ID"]=> string(1) "1" ["user_login"]=> string(5) "admin" } } today : array(4) { [0]=> object(stdClass)#103 (2) { ["ID"]=> string(1) "1" ["user_login"]=> string(5) "admin" } [1]=> object(stdClass)#100 (2) { ["ID"]=> string(5) "44700" ["user_login"]=> string(5) "user2" } [2]=> object(stdClass)#99 (2) { ["ID"]=> string(5) "44561" ["user_login"]=> string(5) "user3" } [3]=> object(stdClass)#101 (2) { ["ID"]=> string(5) "55563" ["user_login"]=> string(5) "user5" } } </code> _ck_ on "Members Online - Hide User Online Status" http://bbshowcase.org/forums/topic/members-online-hide-user-online-status#post-2166 Fri, 22 Oct 2010 12:35:16 +0000 _ck_ 2166@http://bbshowcase.org/forums/ I can't remember but it probably already fetches/catches all the users data in one query anyway. If not, it could be converted. So adding additional usermeta doesn't add queries. guly on "Members Online - Hide User Online Status" http://bbshowcase.org/forums/topic/members-online-hide-user-online-status#post-2165 Fri, 22 Oct 2010 11:50:10 +0000 guly 2165@http://bbshowcase.org/forums/ Hi _ck_ I am going to tweak your Members Online code to give users the opportunity to hide their status, if they choose (though mods and admins would still get to see their status). I was wondering what approach you think is best: 1. Create a new bb_usermeta value 'dont_show_online' for each user who opts out. When function members_online_now() runs, it checks whether dont_show_online exists each online user. Then you could do all sorts of things like SKIP showing the user to normal users, show their name in italics to mods/admins, etc. The main disadvantage I see is you have to do an extra mysql query each time members_online_now() runs, and my understanding is that too many queries = bad. 2. store the bb_usermeta value 'last_online' as a compound variable, using implode()/explode(), so the stored 'last_online' value in mysql table is "1287724455,1" (1287724455=time,1=flag for 'don't display my online status'). 3. Other approach. Thanks! massbase on "Members Online, - Editing the output" http://bbshowcase.org/forums/topic/members-online-editing-the-output#post-1384 Wed, 17 Jun 2009 12:31:46 +0000 massbase 1384@http://bbshowcase.org/forums/ I got the link working, correctly for the permalink. <pre><code>function members_online_now($time=0) { global $bbdb, $members_online; $members_online['footer']=false; if (empty($time)) {$time=time()-$members_online['timeout'];} $members=$bbdb->get_results("SELECT ID,user_login FROM $bbdb->users LEFT JOIN $bbdb->usermeta ON ID=user_id WHERE meta_key='last_online' AND cast(meta_value AS unsigned)>'$time' ORDER BY meta_value DESC"); if (!empty($members)) { $profile=bb_get_option('uri')."profile/"; $output=""; foreach ($members as $member) {$output.="<a rel='nofollow' href='$profile$member->user_login'>$member->user_login</a>, ";} echo rtrim($output,", "); } }</code></pre> but i was wondering if you could do this but using the gravatar instead of text. massbase on "Members Online, - Editing the output" http://bbshowcase.org/forums/topic/members-online-editing-the-output#post-1383 Wed, 17 Jun 2009 11:59:57 +0000 massbase 1383@http://bbshowcase.org/forums/ hey ck, i need to edit the text that outputs the "online users today"... reason being is that i have permalinks on, so the links to the profile doesnt work, becuase it uses id, rather than name, i dont know what bit to edit from the code. my plan is too get the gravatar of the user show up instead of text, that links to <a href="http://www.sitename.com/profile/username" rel="nofollow">http://www.sitename.com/profile/username</a> (not id) thanks.