public function notattend_event($event_id = 0) { global $wpdb; if ($event_id && !empty($event_id)) { $current_user = get_current_user_info(); $wpdb->query("DELETE FROM " . WORDTOUR_ATTENDING . " WHERE rsvp_event_id={$event_id} AND rsvp_user="******"UPDATE " . WORDTOUR_EVENTS . " SET rsvp_count=rsvp_count-1 WHERE event_id=" . $event_id); return $wpdb->result; } } } return 0; }
public function get_by_event($event_id = 0, $query = "") { if ($event_id) { global $wpdb, $_wt_options; $current_user = get_current_user_info(); $comments = $this->query("comment_event_id={$event_id}&comment_approved=1"); $is_login = is_user_logged_in(); foreach ((array) $comments as $i => $comment) { $comments[$i] = $this->template($comment); } $captcha = ""; if (!$_wt_options->options("comment_registration") && $_wt_options->options("comment_captcha") == 1 && !$is_login) { $public_key = (string) $_wt_options->options("captcha_public_key"); $private_key = (string) $_wt_options->options("captcha_public_key"); if (!empty($public_key) && !empty($private_key)) { require_once WT_PLUGIN_PATH . 'recaptcha/recaptchalib.php'; $captcha = recaptcha_get_html($public_key); } } return array("is_login" => $is_login, "captcha" => $captcha, "allow_comment" => $_wt_options->options("comment_registration") == 1 ? 0 : 1, "nickname" => $current_user->user_nicename, "total" => count($comments), "nonce" => wp_create_nonce(WT_Comment::NONCE_INSERT), "event_id" => $event_id, "author" => $current_user->user_nicename, "comments" => $comments); } }
if (is_dir($f) == false) { $info = stat("{$preview_directory}/{$f}"); $age_in_seconds = time() - $info['mtime']; $age_in_minutes = $age_in_seconds / 60; if ($age_in_minutes > $preview_timeout) { unlink("{$preview_directory}/{$f}"); } } } if (is_dir($upload_directory) == false) { mkdir($upload_directory) or show_error_die("Unable to create upload directory '{$upload_directory}'"); } if (is_dir($preview_directory) == false) { mkdir($preview_directory) or show_error_die("Unable to create preview directory '{$preview_directory}'"); } $me = get_current_user_info(get_db_read()); # Makes sure the username is made up of letters and numbers, and is between 3 and 14 characters long function validate_username($username) { if (isset($username) == false) { return false; } if (ereg('^([a-zA-Z0-9])*$', $username) == false) { return false; } if (strlen($username) < 3 || strlen($username) > 14) { return false; } return true; } # Makes sure the password isn't an unreasonable length
<?php session_start(); $db = start_database(); $logged_in = is_logged_in(); //will be an empty array if not logged in $user_info = get_current_user_info($db); function start_database() { $host = '128.95.103.44'; $dbname = 'em42'; $dsn = "mysql:dbname={$dbname};host={$host};charset=utf8"; $username = '******'; $password = '******'; //mysql_pconnect was not working in my dev environment so I used PDO $db = new PDO($dsn, $username, $password); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return $db; } function is_logged_in() { return !empty($_SESSION['userId']); } function get_current_user_info($db) { if (is_logged_in()) { $id = $db->quote($_SESSION['userId']); $query = "SELECT userId, userName, themeId FROM user\n\t\t\t\tWHERE userId = {$id}"; return $db->query($query)->fetchAll(PDO::FETCH_ASSOC)[0]; } else { return [];