function wppa_create_session_entry($args) { global $wpdb; $args = wp_parse_args((array) $args, array('session' => wppa_get_session_id(), 'timestamp' => time(), 'user' => wppa_get_user(), 'ip' => $_SERVER['REMOTE_ADDR'], 'status' => 'valid', 'data' => false, 'count' => '1')); $query = $wpdb->prepare("INSERT INTO `" . WPPA_SESSION . "` \t(\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`session`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`timestamp`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`user`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`ip`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`status`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`data`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`count`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES ( %s, %s, %s, %s, %s, %s, %s )", $args['session'], $args['timestamp'], $args['user'], $args['ip'], $args['status'], $args['data'], $args['count']); $iret = @$wpdb->query($query); return $iret; }
function wppa_create_session_entry($args) { global $wpdb; $args = wp_parse_args((array) $args, array('session' => wppa_get_session_id(), 'timestamp' => time(), 'user' => wppa_get_user(), 'ip' => $_SERVER['REMOTE_ADDR'], 'status' => 'valid', 'data' => false, 'count' => '1')); // WPPA_SESSION is auto increment $query = $wpdb->prepare("INSERT INTO `" . WPPA_SESSION . "` \t(\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`session`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`timestamp`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`user`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`ip`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`status`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`data`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`count`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES ( %s, %s, %s, %s, %s, %s, %s )", $args['session'], $args['timestamp'], $args['user'], $args['ip'], $args['status'], $args['data'], $args['count']); $iret = $wpdb->query($query); // Succcessful insert: return record id if ($iret) { $result = $wpdb->get_var($wpdb->prepare("SELECT `id` FROM `" . WPPA_SESSION . "` WHERE `session` = %s ORDER BY `id` DESC LIMIT 1", wppa_get_session_id())); return $result; } else { return false; } }
function wppa_session_end() { global $wpdb; global $wppa_session; if (!wppa_get_session_id()) { return false; } $iret = $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_SESSION . "` SET `data` = %s WHERE `session` = %s", serialize($wppa_session), wppa_get_session_id())); if ($iret === false) { wppa_log('Error', 'Unable to save session.'); return false; } return true; }
function wppa_extend_session() { global $wpdb; $sessionid = wppa_get_session_id(); $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_SESSION . "` SET `timestamp` = %d WHERE `session` = %s", time(), $sessionid)); }