<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>[10652] sites/trunk/wordpress.org/public_html/wp-content/plugins: Support Forum: add a native implementation of the bbPress Also Viewing user script.</title>
</head>
<body>
<style type="text/css"><!--
#msg dl.meta { border: 1px #006 solid; background: #369; padding: 6px; color: #fff; }
#msg dl.meta dt { float: left; width: 6em; font-weight: bold; }
#msg dt:after { content:':';}
#msg dl, #msg dt, #msg ul, #msg li, #header, #footer, #logmsg { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; }
#msg dl a { font-weight: bold}
#msg dl a:link { color:#fc3; }
#msg dl a:active { color:#ff0; }
#msg dl a:visited { color:#cc6; }
h3 { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold; }
#msg pre { white-space: pre-line; overflow: auto; background: #ffc; border: 1px #fa0 solid; padding: 6px; }
#logmsg { background: #ffc; border: 1px #fa0 solid; padding: 1em 1em 0 1em; }
#logmsg p, #logmsg pre, #logmsg blockquote { margin: 0 0 1em 0; }
#logmsg p, #logmsg li, #logmsg dt, #logmsg dd { line-height: 14pt; }
#logmsg h1, #logmsg h2, #logmsg h3, #logmsg h4, #logmsg h5, #logmsg h6 { margin: .5em 0; }
#logmsg h1:first-child, #logmsg h2:first-child, #logmsg h3:first-child, #logmsg h4:first-child, #logmsg h5:first-child, #logmsg h6:first-child { margin-top: 0; }
#logmsg ul, #logmsg ol { padding: 0; list-style-position: inside; margin: 0 0 0 1em; }
#logmsg ul { text-indent: -1em; padding-left: 1em; }#logmsg ol { text-indent: -1.5em; padding-left: 1.5em; }
#logmsg > ul, #logmsg > ol { margin: 0 0 1em 0; }
#logmsg pre { background: #eee; padding: 1em; }
#logmsg blockquote { border: 1px solid #fa0; border-left-width: 10px; padding: 1em 1em 0 1em; background: white;}
#logmsg dl { margin: 0; }
#logmsg dt { font-weight: bold; }
#logmsg dd { margin: 0; padding: 0 0 0.5em 0; }
#logmsg dd:before { content:'\00bb';}
#logmsg table { border-spacing: 0px; border-collapse: collapse; border-top: 4px solid #fa0; border-bottom: 1px solid #fa0; background: #fff; }
#logmsg table th { text-align: left; font-weight: normal; padding: 0.2em 0.5em; border-top: 1px dotted #fa0; }
#logmsg table td { text-align: right; border-top: 1px dotted #fa0; padding: 0.2em 0.5em; }
#logmsg table thead th { text-align: center; border-bottom: 1px solid #fa0; }
#logmsg table th.Corner { text-align: left; }
#logmsg hr { border: none 0; border-top: 2px dashed #fa0; height: 1px; }
#header, #footer { color: #fff; background: #636; border: 1px #300 solid; padding: 6px; }
#patch { width: 100%; }
#patch h4 {font-family: verdana,arial,helvetica,sans-serif;font-size:10pt;padding:8px;background:#369;color:#fff;margin:0;}
#patch .propset h4, #patch .binary h4 {margin:0;}
#patch pre {padding:0;line-height:1.2em;margin:0;}
#patch .diff {width:100%;background:#eee;padding: 0 0 10px 0;overflow:auto;}
#patch .propset .diff, #patch .binary .diff {padding:10px 0;}
#patch span {display:block;padding:0 10px;}
#patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;}
#patch ins {background:#dfd;text-decoration:none;display:block;padding:0 10px;}
#patch del {background:#fdd;text-decoration:none;display:block;padding:0 10px;}
#patch .lines, .info {color:#888;background:#fff;}
--></style>
<div id="msg">
<dl class="meta" style="font-size: 105%">
<dt style="float: left; width: 6em; font-weight: bold">Revision</dt> <dd><a style="font-weight: bold" href="http://meta.trac.wordpress.org/changeset/10652">10652</a><script type="application/ld+json">{"@context":"http://schema.org","@type":"EmailMessage","description":"Review this Commit","action":{"@type":"ViewAction","url":"http://meta.trac.wordpress.org/changeset/10652","name":"Review Commit"}}</script></dd>
<dt style="float: left; width: 6em; font-weight: bold">Author</dt> <dd>dd32</dd>
<dt style="float: left; width: 6em; font-weight: bold">Date</dt> <dd>2021-02-10 07:29:20 +0000 (Wed, 10 Feb 2021)</dd>
</dl>
<pre style='padding-left: 1em; margin: 2em 0; border-left: 2px solid #ccc; line-height: 1.25; font-size: 105%; font-family: sans-serif'>Support Forum: add a native implementation of the bbPress Also Viewing user script.
<a href="http://meta.trac.wordpress.org/changeset/10651">[10651]</a> didn't quite import how I anticipated it to.
See <a href="http://meta.trac.wordpress.org/ticket/2552">#2552</a>.</pre>
<h3>Added Paths</h3>
<ul>
<li>sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/</li>
<li><a href="#sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingwporgbbpalsoviewingjs">sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.js</a></li>
<li><a href="#sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingwporgbbpalsoviewingphp">sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.php</a></li>
</ul>
<h3>Removed Paths</h3>
<ul>
<li><a href="#sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingjs">sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.js</a></li>
<li><a href="#sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingphp">sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.php</a></li>
</ul>
</div>
<div id="patch">
<h3>Diff</h3>
<a id="sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingwporgbbpalsoviewingjsfromrev10651sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingjs"></a>
<div class="copfile"><h4 style="background-color: #eee; color: inherit; margin: 1em 0; padding: 1.3em; font-size: 115%">Copied: sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.js (from rev 10651, sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.js)</h4>
<pre class="diff"><span>
<span class="info" style="display: block; padding: 0 10px; color: #888">--- sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.js (rev 0)
+++ sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.js 2021-02-10 07:29:20 UTC (rev 10652)
</span><span class="lines" style="display: block; padding: 0 10px; color: #888">@@ -0,0 +1,166 @@
</span><ins style="background-color: #dfd; text-decoration:none; display:block; padding: 0 10px">+/**
+ * WordPress.org bbPress Also Viewing.
+ *
+ * This was based on the Also Viewing User Script by Jason Stallings
+ * @see https://gist.github.com/Clorith/20596176f85495da865cf41a90b43576
+ */
+(function() {
+ var options = window._alsoViewing,
+ currentlyViewing = options.currentlyViewing || [],
+ page = options.currentPage || '',
+ banner = false,
+ isTyping = false,
+ _n = wp.i18n._n,
+ __ = wp.i18n.__,
+ NoLongerTyping;
+
+ if ( ! options || ! page ) {
+ return;
+ }
+
+ jQuery( document ).on( 'ready', function($) {
+ maybeDisplay();
+
+ if ( options.heartbeatTime ) {
+ setInterval( updateState, options.heartbeatTime * 1000 );
+ }
+
+ if ( options.refreshInterval ) {
+ setInterval( refreshViewers, options.refreshInterval * 1000 );
+ }
+ } );
+
+ // Display the banner when required.
+ function maybeDisplay() {
+ var userCount = currentlyViewing.length,
+ userList = [],
+ userlistPretty;
+
+ if ( ! banner ) {
+ if ( ! userCount ) {
+ return;
+ }
+
+ jQuery('#main').before(
+ '<div id="also-viewing-banner" style="display: none; font-size: 14px; color: #fff; line-height: 30px; font-family: Helvetica,sans-serif; background: #d54e21; border-bottom: 1px solid #dfdfdf; width:100%; height:30px; text-align: center; position: initial; top: 32px; left: 0; z-index: 9999;"></div>'
+ );
+ banner = jQuery( '#also-viewing-banner' );
+ }
+
+ if ( ! userCount ) {
+ banner.show( false );
+ } else {
+ userList = currentlyViewing.map( function( item ) {
+ return item.who + ( item.isTyping ? ' ' + __( '(is typing)', 'wporg-bbp-also-viewing' ) : '' );
+ } );
+
+ if ( userCount > 1 ) {
+ userlistPretty = __( '%1$s and %2$s' )
+ .replace( '%1$s', userList.slice( 0, -1 ).join( ', ' ) )
+ .replace( '%2$s', userList.slice( -1 ) );
+ } else {
+ userlistPretty = userList.join( ', ' ); // only one element.
+ }
+
+ banner.text(
+ _n( '%s is also viewing this page.', '%s are also viewing this page.', userCount, 'wporg-bbp-also-viewing' )
+ .replace( '%s', userlistPretty )
+ );
+ banner.show( true );
+ }
+ }
+
+ // Pin the banner to the top of the screen when scrolling.
+ jQuery(window).scroll( function() {
+ if ( ! banner ) {
+ return;
+ }
+
+ if ( jQuery(window).scrollTop() > 200 ) {
+ banner.css( 'position', 'fixed' );
+ } else {
+ banner.css( 'position', 'initial' );
+ }
+ });
+
+ // When a textarea is focused, mark the user as typing.
+ jQuery(document).on( 'keydown', 'textarea', function() {
+ transmitIsTyping();
+
+ clearInterval( NoLongerTyping );
+
+ NoLongerTyping = setTimeout(function() {
+ transmitNoLongerTyping();
+ }, 15000 );
+ } );
+
+ function transmitIsTyping() {
+ // Avoid re-transmitting repeatedly, we only need to do so on state changes.
+ if ( isTyping ) {
+ return;
+ }
+
+ isTyping = true;
+
+ updateState();
+ }
+
+ function transmitNoLongerTyping() {
+ // Avoid re-transmitting repeatedly, we only need to do so on state changes.
+ if ( ! isTyping ) {
+ return;
+ }
+
+ isTyping = false;
+
+ updateState();
+ }
+
+ // Update the viewing state of the browser on the server.
+ // This ensures that we're still shown as viewing / typing.
+ function updateState() {
+ jQuery.ajax( {
+ url: options.restAPIEndpoint + page,
+ method: 'POST',
+ beforeSend: function( xhr ) {
+ xhr.setRequestHeader( 'X-WP-Nonce', options.restAPINonce );
+ },
+ data: {
+ isTyping: isTyping,
+ }
+ } );
+ }
+
+ // Update the list of users currently viewing this page.
+ function refreshViewers() {
+ jQuery.ajax( {
+ url: options.restAPIEndpoint + page,
+ method: 'GET',
+ beforeSend: function( xhr ) {
+ xhr.setRequestHeader( 'X-WP-Nonce', options.restAPINonce );
+ }
+ } ).done( function( response ) {
+ currentlyViewing = response;
+ maybeDisplay();
+ } );
+ }
+
+ // Remove us as viewing this page.
+ jQuery(window).on( 'beforeunload', function() {
+ jQuery.ajax( {
+ url: options.restAPIEndpoint + page,
+ method: 'DELETE',
+ beforeSend: function( xhr ) {
+ xhr.setRequestHeader( 'X-WP-Nonce', options.restAPINonce );
+ }
+ } );
+ } );
+
+ // DEBUG. Expose the functions for testing.
+ window.alsoViewing = {
+ refreshViewers: refreshViewers,
+ updateState: updateState,
+ transmitIsTyping: transmitIsTyping,
+ transmitNoLongerTyping: transmitNoLongerTyping,
+ }
+})();
</ins><span class="cx" style="display: block; padding: 0 10px">\ No newline at end of file
</span></span></pre></div>
<a id="sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingwporgbbpalsoviewingphpfromrev10651sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingphp"></a>
<div class="copfile"><h4 style="background-color: #eee; color: inherit; margin: 1em 0; padding: 1.3em; font-size: 115%">Copied: sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.php (from rev 10651, sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.php)</h4>
<pre class="diff"><span>
<span class="info" style="display: block; padding: 0 10px; color: #888">--- sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.php (rev 0)
+++ sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing/wporg-bbp-also-viewing.php 2021-02-10 07:29:20 UTC (rev 10652)
</span><span class="lines" style="display: block; padding: 0 10px; color: #888">@@ -0,0 +1,442 @@
</span><ins style="background-color: #dfd; text-decoration:none; display:block; padding: 0 10px">+<?php
+namespace WordPressdotorg\BBP_Also_Viewing;
+use function WordPressdotorg\SEO\Canonical\get_canonical_url;
+
+/**
+ * Plugin Name: bbPress: Also Viewing
+ * Description: Adds an Also Viewing functionality for logged in users.
+ * Version: 1.0
+ * Author: WordPress.org
+ * Author URI: https://wordpress.org/
+ * License: GPLv2 or later
+ *
+ */
+
+/**
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License, version 2, as
+ * published by the Free Software Foundation.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, see <http://www.gnu.org/licenses/>.
+ */
+
+const TOGGLE_KEY = 'toggle-also-viewing';
+const USER_OPTION = 'also-viewing';
+const NONCE = 'also-viewing';
+const TIMEOUT = 5 * \MINUTE_IN_SECONDS;
+const REFRESH_INT = 45; // How often the client should check for new viewers.
+const CACHE_GROUP = 'also-viewing';
+const CACHE_TIME = 5 * \MINUTE_IN_SECONDS;
+
+function init() {
+ if ( ! allowed_for_user() ) {
+ return;
+ }
+
+ // Add a UI to enable/disable the feature.
+ add_action( 'admin_bar_menu', __NAMESPACE__ . '\admin_bar_menu', 1000 );
+ maybe_toggle();
+
+ // If enabled, queue up the JS, and register the API endpoints.
+ if ( enabled() ) {
+ add_action( 'wp_enqueue_scripts', __NAMESPACE__ . '\wp_enqueue_scripts' );
+
+ // Record the user as being on the page.
+ add_action( 'wp_head', __NAMESPACE__ . '\user_viewing', 10, 0 );
+ }
+
+ // Add some REST API endpoints for JS usage:
+ add_action( 'rest_api_init', __NAMESPACE__ . '\rest_api_init' );
+
+ // Maintain it, maybe create the storage table, and setup a cron to cleanup hourly if needed.
+ add_action( 'admin_init', __NAMESPACE__ . '\maybe_create_table' );
+ add_action( 'also_viewing_cleanup', __NAMESPACE__ . '\cron_cleanup' );
+ add_action( 'admin_init', function() {
+ if ( ! wp_next_scheduled ( 'also_viewing_cleanup' ) ) {
+ wp_schedule_event( time(), 'hourly', 'also_viewing_cleanup', $args );
+ }
+ } );
+}
+add_action( 'init', __NAMESPACE__ . '\init' );
+
+/**
+ * Whether Also Viewing is enabled for the current user.
+ *
+ * @return bool
+ */
+function enabled() {
+ return
+ allowed_for_user() &&
+ get_user_meta( get_current_user_id(), 'also-viewing', true );
+}
+
+/**
+ * Whether Also Viewing is able to be activated for the current user.
+ *
+ * @return bool
+ */
+function allowed_for_user() {
+ // TODO: Enable for non-moderator? users with more than x replies?
+ return is_user_logged_in() && current_user_can( 'moderate' );
+}
+
+/**
+ * The current page "slug"/"path" for refering to the current request.
+ *
+ * This uses the WordPress.org SEO plugin for the canonical url, or falls back to REQUEST_URI.
+ *
+ * @return string The path for the current page, eg. 'view/no-replies'
+ */
+function current_page() {
+ $page = false;
+
+ // If on WordPress.org, use the canonical url for the page.
+ if ( is_callable( '\WordPressdotorg\SEO\Canonical\get_canonical_url' ) ) {
+ $page = \WordPressdotorg\SEO\Canonical\get_canonical_url();
+ }
+ if ( ! $page ) {
+ $page = $_SERVER['REQUEST_URI'];
+ }
+
+ return sanitize_page_url_for_db( $page );
+}
+
+/**
+ * Sanitizes a given string/url/path to the format used for uniquely identifying pages.
+ *
+ * @param string $page The strng/url/path
+ *
+ * @return string The sanitized $page.
+ */
+function sanitize_page_url_for_db( $page ) {
+ if ( parse_url( $page, PHP_URL_SCHEME ) ) {
+ $page = parse_url( $page, PHP_URL_PATH );
+ }
+
+ list( $page, ) = explode( '?', $page );
+
+ // Remove the leading path component of the site.
+ $home_path = parse_url( home_url(), PHP_URL_PATH );
+ if ( $home_path && $home_path === substr( $page, 0, strlen( $home_path ) ) ) {
+ $page = substr( $page, strlen( $home_path ) );
+ }
+
+ // No leading/trailing slash.
+ $page = trim( $page, '/' );
+
+ return $page;
+}
+
+/**
+ * Load the JS and bootstrap it.
+ */
+function wp_enqueue_scripts() {
+ wp_enqueue_script(
+ 'also-viewing',
+ plugins_url( 'wporg-bbp-also-viewing.js', __FILE__ ),
+ [ 'jquery', 'wp-i18n' ],
+ filemtime( __DIR__ . '/wporg-bbp-also-viewing.js' )
+ );
+ wp_set_script_translations( 'also-viewing', 'wporg-bbp-also-viewing' );
+
+ wp_localize_script(
+ 'also-viewing',
+ '_alsoViewing',
+ [
+ 'restAPIEndpoint' => rest_url( 'wporg/v1/currentlyViewing/' ),
+ 'restAPINonce' => wp_create_nonce( 'wp_rest' ),
+ 'currentPage' => current_page(),
+ 'currentlyViewing' => get_others_currently_viewing( current_page() ),
+ 'heartbeatTime' => TIMEOUT / 2,
+ 'refreshInterval' => REFRESH_INT,
+ ]
+ );
+
+}
+
+/**
+ * Add a Admin bar entry to enable/disable the Also Viewing tool.
+ */
+function admin_bar_menu( $wp_admin_bar ) {
+ $args = [
+ 'id' => 'toggle_translator',
+ 'title' => '<span class="ab-icon dashicons-welcome-view-site"></span> ' . __( 'Also Viewing', 'wporg-bbp-also-viewing' ),
+ 'href' => wp_nonce_url( add_query_arg( TOGGLE_KEY, (int)( ! enabled() ) ), NONCE ),
+ 'meta' => [
+ 'class' => 'toggle-also-viewing',
+ 'title' => ( enabled() ? __( 'Disable also viewing', 'wporg-bbp-also-viewing' ) : __( 'Enable also viewing', 'wporg-bbp-also-viewing' ) )
+ ]
+ ];
+ $wp_admin_bar->add_node( $args );
+
+ // Add a descriptive sub-child menu.
+ $args['title'] = $args['meta']['title'];
+ $args['parent'] = $args['id'];
+ $args['id'] .= '-child';
+ $wp_admin_bar->add_node( $args );
+}
+
+/**
+ * Handle the admin bar toggle actions.
+ */
+function maybe_toggle() {
+ if (
+ ! isset( $_GET[ TOGGLE_KEY ] ) ||
+ ! isset( $_GET['_wpnonce'] ) ||
+ ! wp_verify_nonce( $_GET['_wpnonce'], NONCE )
+ ) {
+ return;
+ }
+
+ update_user_meta( get_current_user_id(), USER_OPTION, (int) $_GET[ TOGGLE_KEY ] );
+
+ // Cleanup.
+ if ( ! enabled() ) {
+ clear_viewing( null, get_current_user_id() );
+ }
+
+ wp_safe_redirect( remove_query_arg( [ TOGGLE_KEY, '_wpnonce' ] ) );
+ die();
+}
+
+/**
+ * Get the list of users who are currently viewing a page.
+ *
+ * @param string $page The page to get the userse for.
+ *
+ * @return array Array of user names + if they're typing.
+ */
+function get_currently_viewing( $page ) {
+ global $wpdb;
+
+ $return = [];
+ $table = get_table();
+ $page = sanitize_page_url_for_db( $page );
+
+ $users = wp_cache_get( $page, CACHE_GROUP );
+ if ( false === $users ) {
+ $users = $wpdb->get_results( $wpdb->prepare(
+ "SELECT user_id, typing, last_updated
+ FROM {$table}
+ WHERE page = %s",
+ $page
+ ) );
+
+ wp_cache_set( $page, $users, CACHE_GROUP, CACHE_TIME );
+ }
+
+ foreach ( $users as $u ) {
+ // Ignore expired records.
+ if ( strtotime( $u->last_updated ) < time() - TIMEOUT ) {
+ continue;
+ }
+
+ $return[] = [
+ 'who' => get_user_by( 'id', $u->user_id )->display_name,
+ 'isTyping' => (bool) $u->typing,
+ 'user_id' => (int) $u->user_id,
+ ];
+ }
+
+ return $return;
+}
+
+/**
+ * Get the list of OTHER users who are currently viewing a page.
+ *
+ * @param string $page The page to get the userse for.
+ *
+ * @return array Array of user names + if they're typing.
+ */
+function get_others_currently_viewing( $page ) {
+ $users = get_currently_viewing( $page );
+ foreach ( $users as $i => $u ) {
+ if ( $u->user_id == get_current_user_id() ) {
+ unset( $users[ $i ] );
+ }
+ }
+
+ return array_values( $users );
+}
+
+/**
+ * Mark a user as currently viewing/typing on the current page.
+ *
+ * @param string $page The page being viewed. Default current page.
+ * @param bool $typing If the current user is typing. Default false.
+ * @param int $user_id The user ID who is viewing/typing.
+ *
+ * @return bool
+ */
+function user_viewing( $page = false, $typing = false, $user_id = false ) {
+ global $wpdb;
+
+ if ( $page ) {
+ $page = sanitize_page_url_for_db( $page );
+ } else {
+ $page = current_page();
+ }
+
+ if ( ! $user_id ) {
+ $user_id = get_current_user_id();
+ }
+
+ $table = get_table();
+ $typing = (int) $typing;
+ $now = current_time( 'mysql', true );
+
+ $ret = (bool) $wpdb->query( $wpdb->prepare(
+ "INSERT INTO `{$table}` ( `user_id`, `page`, `typing`, `timestamp`, `last_updated` )
+ VALUES ( %d, %s, %d, %s, %s )
+ ON DUPLICATE KEY UPDATE `typing` = VALUES( `typing` ), `last_updated` = VALUES( `last_updated` )",
+ $user_id,
+ $page,
+ $typing,
+ $now,
+ $now,
+ ) );
+
+ // Clear the cache.
+ wp_cache_delete( $page, CACHE_GROUP );
+
+ return $ret;
+}
+
+/**
+ * Mark a user as no longer viewing a page.
+ *
+ * @param string $page The page to no longer view. Defaults to clearing all pages.
+ * @param int $user_id The user ID no longer viewing the page. Default current user.
+ */
+function clear_viewing( $page = null, $user_id = false ) {
+ global $wpdb;
+
+ $table = get_table();
+ if ( ! $user_id ) {
+ $user_id = get_current_user_id();
+ }
+
+ if ( is_null( $page ) ) {
+ $pages = $wpdb->get_col( $wpdb->prepare(
+ "SELECT page FROM `{$table}` WHERE user_id = %d",
+ $user_id
+ ) );
+ $wpdb->delete(
+ $table,
+ [ 'user_id' => $user_id ]
+ );
+ } else {
+ $pages = (array) $page;
+
+ $wpdb->delete(
+ $table,
+ [
+ 'user_id' => $user_id,
+ 'page' => $page
+ ]
+ );
+ }
+
+ foreach ( $pages as $p ) {
+ wp_cache_delete( $page, CACHE_GROUP );
+ }
+}
+
+/**
+ * Register the REST API urls used by the javascript.
+ */
+function rest_api_init() {
+ register_rest_route( 'wporg/v1', '/currentlyViewing/(?P<page>.+)', [
+ [
+ 'methods' => 'GET',
+ 'callback' => function( $request ) {
+ return get_others_currently_viewing( (string) $request['page'] );
+ },
+ 'permission_callback' => 'is_user_logged_in',
+ ],
+ [
+ 'methods' => 'POST',
+ 'callback' => function( $request ) {
+ return user_viewing(
+ (string) $request['page'],
+ ! empty( $request['isTyping'] ) && 'false' !== $request['isTyping']
+ );
+ },
+ 'permission_callback' => 'is_user_logged_in',
+ ],
+ [
+ 'methods' => 'DELETE',
+ 'callback' => function( $request ) {
+ return clear_viewing( (string) $request['page'] );
+ },
+ 'permission_callback' => 'is_user_logged_in',
+ ],
+ ] );
+}
+
+/**
+ * Clean out viewing users hourly.
+ */
+function cron_cleanup() {
+ global $wpdb;
+
+ $before = gmdate( 'Y-m-d H:i:s', time() - TIMEOUT );
+ $table = get_table();
+
+ $results = $wpdb->get_results( $wpdb->prepare(
+ "SELECT user_id, page FROM `{$table}` WHERE last_updated < %s",
+ $before
+ ) );
+
+ foreach ( $results as $r ) {
+ clear_viewing( $r->page, $r->user_id );
+ }
+}
+
+/**
+ * The table name used for storing the state of users.
+ *
+ * @return string
+ */
+function get_table() {
+ global $wpdb;
+
+ return $wpdb->prefix . 'also_viewing';
+}
+
+/**
+ * Maybe create the database table used for this plugin.
+ *
+ * This only runs once per site, ever.
+ */
+function maybe_create_table() {
+ global $wpdb;
+
+ if ( get_site_option( 'also-viewing' ) ) {
+ return;
+ }
+
+ $table = get_table();
+
+ $wpdb->query(
+ "CREATE TABLE IF NOT EXISTS `{$table}` (
+ `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(20) unsigned NOT NULL,
+ `page` varchar(255) NOT NULL DEFAULT '',
+ `typing` tinyint(1) unsigned NOT NULL DEFAULT 0,
+ `timestamp` datetime NOT NULL,
+ `last_updated` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `user_id_page` (`user_id`,`page`),
+ KEY `page` (`page`)
+ )"
+ );
+
+ update_site_option( 'also-viewing', true );
+}
</ins><span class="cx" style="display: block; padding: 0 10px">\ No newline at end of file
</span></span></pre></div>
<a id="sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingjs"></a>
<div class="delfile"><h4 style="background-color: #eee; color: inherit; margin: 1em 0; padding: 1.3em; font-size: 115%">Deleted: sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.js</h4>
<pre class="diff"><span>
<span class="info" style="display: block; padding: 0 10px; color: #888">--- sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.js 2021-02-10 07:27:44 UTC (rev 10651)
+++ sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.js 2021-02-10 07:29:20 UTC (rev 10652)
</span><span class="lines" style="display: block; padding: 0 10px; color: #888">@@ -1,166 +0,0 @@
</span><del style="background-color: #fdd; text-decoration:none; display:block; padding: 0 10px">-/**
- * WordPress.org bbPress Also Viewing.
- *
- * This was based on the Also Viewing User Script by Jason Stallings
- * @see https://gist.github.com/Clorith/20596176f85495da865cf41a90b43576
- */
-(function() {
- var options = window._alsoViewing,
- currentlyViewing = options.currentlyViewing || [],
- page = options.currentPage || '',
- banner = false,
- isTyping = false,
- _n = wp.i18n._n,
- __ = wp.i18n.__,
- NoLongerTyping;
-
- if ( ! options || ! page ) {
- return;
- }
-
- jQuery( document ).on( 'ready', function($) {
- maybeDisplay();
-
- if ( options.heartbeatTime ) {
- setInterval( updateState, options.heartbeatTime * 1000 );
- }
-
- if ( options.refreshInterval ) {
- setInterval( refreshViewers, options.refreshInterval * 1000 );
- }
- } );
-
- // Display the banner when required.
- function maybeDisplay() {
- var userCount = currentlyViewing.length,
- userList = [],
- userlistPretty;
-
- if ( ! banner ) {
- if ( ! userCount ) {
- return;
- }
-
- jQuery('#main').before(
- '<div id="also-viewing-banner" style="display: none; font-size: 14px; color: #fff; line-height: 30px; font-family: Helvetica,sans-serif; background: #d54e21; border-bottom: 1px solid #dfdfdf; width:100%; height:30px; text-align: center; position: initial; top: 32px; left: 0; z-index: 9999;"></div>'
- );
- banner = jQuery( '#also-viewing-banner' );
- }
-
- if ( ! userCount ) {
- banner.show( false );
- } else {
- userList = currentlyViewing.map( function( item ) {
- return item.who + ( item.isTyping ? ' ' + __( '(is typing)', 'wporg-bbp-also-viewing' ) : '' );
- } );
-
- if ( userCount > 1 ) {
- userlistPretty = __( '%1$s and %2$s' )
- .replace( '%1$s', userList.slice( 0, -1 ).join( ', ' ) )
- .replace( '%2$s', userList.slice( -1 ) );
- } else {
- userlistPretty = userList.join( ', ' ); // only one element.
- }
-
- banner.text(
- _n( '%s is also viewing this page.', '%s are also viewing this page.', userCount, 'wporg-bbp-also-viewing' )
- .replace( '%s', userlistPretty )
- );
- banner.show( true );
- }
- }
-
- // Pin the banner to the top of the screen when scrolling.
- jQuery(window).scroll( function() {
- if ( ! banner ) {
- return;
- }
-
- if ( jQuery(window).scrollTop() > 200 ) {
- banner.css( 'position', 'fixed' );
- } else {
- banner.css( 'position', 'initial' );
- }
- });
-
- // When a textarea is focused, mark the user as typing.
- jQuery(document).on( 'keydown', 'textarea', function() {
- transmitIsTyping();
-
- clearInterval( NoLongerTyping );
-
- NoLongerTyping = setTimeout(function() {
- transmitNoLongerTyping();
- }, 15000 );
- } );
-
- function transmitIsTyping() {
- // Avoid re-transmitting repeatedly, we only need to do so on state changes.
- if ( isTyping ) {
- return;
- }
-
- isTyping = true;
-
- updateState();
- }
-
- function transmitNoLongerTyping() {
- // Avoid re-transmitting repeatedly, we only need to do so on state changes.
- if ( ! isTyping ) {
- return;
- }
-
- isTyping = false;
-
- updateState();
- }
-
- // Update the viewing state of the browser on the server.
- // This ensures that we're still shown as viewing / typing.
- function updateState() {
- jQuery.ajax( {
- url: options.restAPIEndpoint + page,
- method: 'POST',
- beforeSend: function( xhr ) {
- xhr.setRequestHeader( 'X-WP-Nonce', options.restAPINonce );
- },
- data: {
- isTyping: isTyping,
- }
- } );
- }
-
- // Update the list of users currently viewing this page.
- function refreshViewers() {
- jQuery.ajax( {
- url: options.restAPIEndpoint + page,
- method: 'GET',
- beforeSend: function( xhr ) {
- xhr.setRequestHeader( 'X-WP-Nonce', options.restAPINonce );
- }
- } ).done( function( response ) {
- currentlyViewing = response;
- maybeDisplay();
- } );
- }
-
- // Remove us as viewing this page.
- jQuery(window).on( 'beforeunload', function() {
- jQuery.ajax( {
- url: options.restAPIEndpoint + page,
- method: 'DELETE',
- beforeSend: function( xhr ) {
- xhr.setRequestHeader( 'X-WP-Nonce', options.restAPINonce );
- }
- } );
- } );
-
- // DEBUG. Expose the functions for testing.
- window.alsoViewing = {
- refreshViewers: refreshViewers,
- updateState: updateState,
- transmitIsTyping: transmitIsTyping,
- transmitNoLongerTyping: transmitNoLongerTyping,
- }
-})();
</del><span class="cx" style="display: block; padding: 0 10px">\ No newline at end of file
</span></span></pre></div>
<a id="sitestrunkwordpressorgpublic_htmlwpcontentpluginswporgbbpalsoviewingphp"></a>
<div class="delfile"><h4 style="background-color: #eee; color: inherit; margin: 1em 0; padding: 1.3em; font-size: 115%">Deleted: sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.php</h4>
<pre class="diff"><span>
<span class="info" style="display: block; padding: 0 10px; color: #888">--- sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.php 2021-02-10 07:27:44 UTC (rev 10651)
+++ sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-also-viewing.php 2021-02-10 07:29:20 UTC (rev 10652)
</span><span class="lines" style="display: block; padding: 0 10px; color: #888">@@ -1,442 +0,0 @@
</span><del style="background-color: #fdd; text-decoration:none; display:block; padding: 0 10px">-<?php
-namespace WordPressdotorg\BBP_Also_Viewing;
-use function WordPressdotorg\SEO\Canonical\get_canonical_url;
-
-/**
- * Plugin Name: bbPress: Also Viewing
- * Description: Adds an Also Viewing functionality for logged in users.
- * Version: 1.0
- * Author: WordPress.org
- * Author URI: https://wordpress.org/
- * License: GPLv2 or later
- *
- */
-
-/**
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License, version 2, as
- * published by the Free Software Foundation.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program; if not, see <http://www.gnu.org/licenses/>.
- */
-
-const TOGGLE_KEY = 'toggle-also-viewing';
-const USER_OPTION = 'also-viewing';
-const NONCE = 'also-viewing';
-const TIMEOUT = 5 * \MINUTE_IN_SECONDS;
-const REFRESH_INT = 45; // How often the client should check for new viewers.
-const CACHE_GROUP = 'also-viewing';
-const CACHE_TIME = 5 * \MINUTE_IN_SECONDS;
-
-function init() {
- if ( ! allowed_for_user() ) {
- return;
- }
-
- // Add a UI to enable/disable the feature.
- add_action( 'admin_bar_menu', __NAMESPACE__ . '\admin_bar_menu', 1000 );
- maybe_toggle();
-
- // If enabled, queue up the JS, and register the API endpoints.
- if ( enabled() ) {
- add_action( 'wp_enqueue_scripts', __NAMESPACE__ . '\wp_enqueue_scripts' );
-
- // Record the user as being on the page.
- add_action( 'wp_head', __NAMESPACE__ . '\user_viewing', 10, 0 );
- }
-
- // Add some REST API endpoints for JS usage:
- add_action( 'rest_api_init', __NAMESPACE__ . '\rest_api_init' );
-
- // Maintain it, maybe create the storage table, and setup a cron to cleanup hourly if needed.
- add_action( 'admin_init', __NAMESPACE__ . '\maybe_create_table' );
- add_action( 'also_viewing_cleanup', __NAMESPACE__ . '\cron_cleanup' );
- add_action( 'admin_init', function() {
- if ( ! wp_next_scheduled ( 'also_viewing_cleanup' ) ) {
- wp_schedule_event( time(), 'hourly', 'also_viewing_cleanup', $args );
- }
- } );
-}
-add_action( 'init', __NAMESPACE__ . '\init' );
-
-/**
- * Whether Also Viewing is enabled for the current user.
- *
- * @return bool
- */
-function enabled() {
- return
- allowed_for_user() &&
- get_user_meta( get_current_user_id(), 'also-viewing', true );
-}
-
-/**
- * Whether Also Viewing is able to be activated for the current user.
- *
- * @return bool
- */
-function allowed_for_user() {
- // TODO: Enable for non-moderator? users with more than x replies?
- return is_user_logged_in() && current_user_can( 'moderate' );
-}
-
-/**
- * The current page "slug"/"path" for refering to the current request.
- *
- * This uses the WordPress.org SEO plugin for the canonical url, or falls back to REQUEST_URI.
- *
- * @return string The path for the current page, eg. 'view/no-replies'
- */
-function current_page() {
- $page = false;
-
- // If on WordPress.org, use the canonical url for the page.
- if ( is_callable( '\WordPressdotorg\SEO\Canonical\get_canonical_url' ) ) {
- $page = \WordPressdotorg\SEO\Canonical\get_canonical_url();
- }
- if ( ! $page ) {
- $page = $_SERVER['REQUEST_URI'];
- }
-
- return sanitize_page_url_for_db( $page );
-}
-
-/**
- * Sanitizes a given string/url/path to the format used for uniquely identifying pages.
- *
- * @param string $page The strng/url/path
- *
- * @return string The sanitized $page.
- */
-function sanitize_page_url_for_db( $page ) {
- if ( parse_url( $page, PHP_URL_SCHEME ) ) {
- $page = parse_url( $page, PHP_URL_PATH );
- }
-
- list( $page, ) = explode( '?', $page );
-
- // Remove the leading path component of the site.
- $home_path = parse_url( home_url(), PHP_URL_PATH );
- if ( $home_path && $home_path === substr( $page, 0, strlen( $home_path ) ) ) {
- $page = substr( $page, strlen( $home_path ) );
- }
-
- // No leading/trailing slash.
- $page = trim( $page, '/' );
-
- return $page;
-}
-
-/**
- * Load the JS and bootstrap it.
- */
-function wp_enqueue_scripts() {
- wp_enqueue_script(
- 'also-viewing',
- plugins_url( 'wporg-bbp-also-viewing.js', __FILE__ ),
- [ 'jquery', 'wp-i18n' ],
- filemtime( __DIR__ . '/wporg-bbp-also-viewing.js' )
- );
- wp_set_script_translations( 'also-viewing', 'wporg-bbp-also-viewing' );
-
- wp_localize_script(
- 'also-viewing',
- '_alsoViewing',
- [
- 'restAPIEndpoint' => rest_url( 'wporg/v1/currentlyViewing/' ),
- 'restAPINonce' => wp_create_nonce( 'wp_rest' ),
- 'currentPage' => current_page(),
- 'currentlyViewing' => get_others_currently_viewing( current_page() ),
- 'heartbeatTime' => TIMEOUT / 2,
- 'refreshInterval' => REFRESH_INT,
- ]
- );
-
-}
-
-/**
- * Add a Admin bar entry to enable/disable the Also Viewing tool.
- */
-function admin_bar_menu( $wp_admin_bar ) {
- $args = [
- 'id' => 'toggle_translator',
- 'title' => '<span class="ab-icon dashicons-welcome-view-site"></span> ' . __( 'Also Viewing', 'wporg-bbp-also-viewing' ),
- 'href' => wp_nonce_url( add_query_arg( TOGGLE_KEY, (int)( ! enabled() ) ), NONCE ),
- 'meta' => [
- 'class' => 'toggle-also-viewing',
- 'title' => ( enabled() ? __( 'Disable also viewing', 'wporg-bbp-also-viewing' ) : __( 'Enable also viewing', 'wporg-bbp-also-viewing' ) )
- ]
- ];
- $wp_admin_bar->add_node( $args );
-
- // Add a descriptive sub-child menu.
- $args['title'] = $args['meta']['title'];
- $args['parent'] = $args['id'];
- $args['id'] .= '-child';
- $wp_admin_bar->add_node( $args );
-}
-
-/**
- * Handle the admin bar toggle actions.
- */
-function maybe_toggle() {
- if (
- ! isset( $_GET[ TOGGLE_KEY ] ) ||
- ! isset( $_GET['_wpnonce'] ) ||
- ! wp_verify_nonce( $_GET['_wpnonce'], NONCE )
- ) {
- return;
- }
-
- update_user_meta( get_current_user_id(), USER_OPTION, (int) $_GET[ TOGGLE_KEY ] );
-
- // Cleanup.
- if ( ! enabled() ) {
- clear_viewing( null, get_current_user_id() );
- }
-
- wp_safe_redirect( remove_query_arg( [ TOGGLE_KEY, '_wpnonce' ] ) );
- die();
-}
-
-/**
- * Get the list of users who are currently viewing a page.
- *
- * @param string $page The page to get the userse for.
- *
- * @return array Array of user names + if they're typing.
- */
-function get_currently_viewing( $page ) {
- global $wpdb;
-
- $return = [];
- $table = get_table();
- $page = sanitize_page_url_for_db( $page );
-
- $users = wp_cache_get( $page, CACHE_GROUP );
- if ( false === $users ) {
- $users = $wpdb->get_results( $wpdb->prepare(
- "SELECT user_id, typing, last_updated
- FROM {$table}
- WHERE page = %s",
- $page
- ) );
-
- wp_cache_set( $page, $users, CACHE_GROUP, CACHE_TIME );
- }
-
- foreach ( $users as $u ) {
- // Ignore expired records.
- if ( strtotime( $u->last_updated ) < time() - TIMEOUT ) {
- continue;
- }
-
- $return[] = [
- 'who' => get_user_by( 'id', $u->user_id )->display_name,
- 'isTyping' => (bool) $u->typing,
- 'user_id' => (int) $u->user_id,
- ];
- }
-
- return $return;
-}
-
-/**
- * Get the list of OTHER users who are currently viewing a page.
- *
- * @param string $page The page to get the userse for.
- *
- * @return array Array of user names + if they're typing.
- */
-function get_others_currently_viewing( $page ) {
- $users = get_currently_viewing( $page );
- foreach ( $users as $i => $u ) {
- if ( $u->user_id == get_current_user_id() ) {
- unset( $users[ $i ] );
- }
- }
-
- return array_values( $users );
-}
-
-/**
- * Mark a user as currently viewing/typing on the current page.
- *
- * @param string $page The page being viewed. Default current page.
- * @param bool $typing If the current user is typing. Default false.
- * @param int $user_id The user ID who is viewing/typing.
- *
- * @return bool
- */
-function user_viewing( $page = false, $typing = false, $user_id = false ) {
- global $wpdb;
-
- if ( $page ) {
- $page = sanitize_page_url_for_db( $page );
- } else {
- $page = current_page();
- }
-
- if ( ! $user_id ) {
- $user_id = get_current_user_id();
- }
-
- $table = get_table();
- $typing = (int) $typing;
- $now = current_time( 'mysql', true );
-
- $ret = (bool) $wpdb->query( $wpdb->prepare(
- "INSERT INTO `{$table}` ( `user_id`, `page`, `typing`, `timestamp`, `last_updated` )
- VALUES ( %d, %s, %d, %s, %s )
- ON DUPLICATE KEY UPDATE `typing` = VALUES( `typing` ), `last_updated` = VALUES( `last_updated` )",
- $user_id,
- $page,
- $typing,
- $now,
- $now,
- ) );
-
- // Clear the cache.
- wp_cache_delete( $page, CACHE_GROUP );
-
- return $ret;
-}
-
-/**
- * Mark a user as no longer viewing a page.
- *
- * @param string $page The page to no longer view. Defaults to clearing all pages.
- * @param int $user_id The user ID no longer viewing the page. Default current user.
- */
-function clear_viewing( $page = null, $user_id = false ) {
- global $wpdb;
-
- $table = get_table();
- if ( ! $user_id ) {
- $user_id = get_current_user_id();
- }
-
- if ( is_null( $page ) ) {
- $pages = $wpdb->get_col( $wpdb->prepare(
- "SELECT page FROM `{$table}` WHERE user_id = %d",
- $user_id
- ) );
- $wpdb->delete(
- $table,
- [ 'user_id' => $user_id ]
- );
- } else {
- $pages = (array) $page;
-
- $wpdb->delete(
- $table,
- [
- 'user_id' => $user_id,
- 'page' => $page
- ]
- );
- }
-
- foreach ( $pages as $p ) {
- wp_cache_delete( $page, CACHE_GROUP );
- }
-}
-
-/**
- * Register the REST API urls used by the javascript.
- */
-function rest_api_init() {
- register_rest_route( 'wporg/v1', '/currentlyViewing/(?P<page>.+)', [
- [
- 'methods' => 'GET',
- 'callback' => function( $request ) {
- return get_others_currently_viewing( (string) $request['page'] );
- },
- 'permission_callback' => 'is_user_logged_in',
- ],
- [
- 'methods' => 'POST',
- 'callback' => function( $request ) {
- return user_viewing(
- (string) $request['page'],
- ! empty( $request['isTyping'] ) && 'false' !== $request['isTyping']
- );
- },
- 'permission_callback' => 'is_user_logged_in',
- ],
- [
- 'methods' => 'DELETE',
- 'callback' => function( $request ) {
- return clear_viewing( (string) $request['page'] );
- },
- 'permission_callback' => 'is_user_logged_in',
- ],
- ] );
-}
-
-/**
- * Clean out viewing users hourly.
- */
-function cron_cleanup() {
- global $wpdb;
-
- $before = gmdate( 'Y-m-d H:i:s', time() - TIMEOUT );
- $table = get_table();
-
- $results = $wpdb->get_results( $wpdb->prepare(
- "SELECT user_id, page FROM `{$table}` WHERE last_updated < %s",
- $before
- ) );
-
- foreach ( $results as $r ) {
- clear_viewing( $r->page, $r->user_id );
- }
-}
-
-/**
- * The table name used for storing the state of users.
- *
- * @return string
- */
-function get_table() {
- global $wpdb;
-
- return $wpdb->prefix . 'also_viewing';
-}
-
-/**
- * Maybe create the database table used for this plugin.
- *
- * This only runs once per site, ever.
- */
-function maybe_create_table() {
- global $wpdb;
-
- if ( get_site_option( 'also-viewing' ) ) {
- return;
- }
-
- $table = get_table();
-
- $wpdb->query(
- "CREATE TABLE IF NOT EXISTS `{$table}` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) unsigned NOT NULL,
- `page` varchar(255) NOT NULL DEFAULT '',
- `typing` tinyint(1) unsigned NOT NULL DEFAULT 0,
- `timestamp` datetime NOT NULL,
- `last_updated` datetime NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `user_id_page` (`user_id`,`page`),
- KEY `page` (`page`)
- )"
- );
-
- update_site_option( 'also-viewing', true );
-}
</del><span class="cx" style="display: block; padding: 0 10px">\ No newline at end of file
</span></span></pre>
</div>
</div>
</body>
</html>