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 [];
