WordPress.org
Get WordPress

Plugin Directory

Changeset 184832


Ignore:
Timestamp:
12/19/2009 05:49:40 PM (16 years ago)
Author:
dlo
Message:

Bug in date management

File:
1 edited

Legend:

Unmodified
Added
Removed

  • sabre/tags/1.0.0/classes/sabre_class.php

    r180030 r184832  
    122122
    123123    $curdate = current_time('timestamp', 1);
    124     @$wpdb->query("INSERT INTO `" . SABRE_TABLE . "` SET `user_IP` = '" . $_SERVER['REMOTE_ADDR'] . "', `first_mod` = FROM_UNIXTIME($curdate), `last_mod` = FROM_UNIXTIME($curdate)" . (isset($password) ? ", `captcha` = '" . $password . "'" : "") . (isset($mathcode) ? ", `math` = " . $mathcode : "") . (isset($t_letter) ? ", `letter` = '" . $t_letter . "'" : ""));
     124    $stordate = date("Y-m-d H:i:s", $curdate);
     125   
     126    @$wpdb->query("INSERT INTO `" . SABRE_TABLE . "` SET `user_IP` = '" . $_SERVER['REMOTE_ADDR'] . "', `first_mod` = '" . $stordate . "', `last_mod` = '" . $stordate . "'" . (isset($password) ? ", `captcha` = '" . $password . "'" : "") . (isset($mathcode) ? ", `math` = " . $mathcode : "") . (isset($t_letter) ? ", `letter` = '" . $t_letter . "'" : ""));
    125127    $id = $wpdb->insert_id;
    126128
    … …  
    268270   
    269271    $curdate = current_time('timestamp', 1);
     272    $stordate = date("Y-m-d H:i:s", $curdate);
    270273
    271274    if (empty($result->id)) {
    … …  
    422425
    423426    if (!empty($sabre_errors)) {
    424         @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `user` = %s, `email` = %s, `msg` = '" . maybe_serialize($sabre_errors) . "', `invite` = %s, `last_mod` = FROM_UNIXTIME($curdate), `status` = 'ko' WHERE `id` = %d", $_POST['user_login'], $_POST['user_email'], $_POST['invite_code'], (int)$_POST['sabre_id']));
     427        @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `user` = %s, `email` = %s, `msg` = '" . maybe_serialize($sabre_errors) . "', `invite` = %s, `last_mod` = '" . $stordate ."', `status` = 'ko' WHERE `id` = %d", $_POST['user_login'], $_POST['user_email'], $_POST['invite_code'], (int)$_POST['sabre_id']));
    425428        $sabre_opt['total_stopped'] += 1;
    426429    }
    427430    elseif ($enable_confirm != 'none') {
    428         @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `user` = %s, `email` = %s,  `invite` = %s, `msg` = '', `last_mod` = FROM_UNIXTIME($curdate), `status` = 'to confirm' WHERE `id` = %d", $_POST['user_login'], $_POST['user_email'], $_POST['invite_code'], (int)$_POST['sabre_id']));
     431        @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `user` = %s, `email` = %s,  `invite` = %s, `msg` = '', `last_mod` = '" . $stordate ."', `status` = 'to confirm' WHERE `id` = %d", $_POST['user_login'], $_POST['user_email'], $_POST['invite_code'], (int)$_POST['sabre_id']));
    429432        }
    430433    else {
    431         @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `user` = %s, `email` = %s, `invite` = %s, `msg` = '', `last_mod` = FROM_UNIXTIME($curdate), `status` = 'ok' WHERE `id` = %d", $_POST['user_login'], $_POST['user_email'], $_POST['invite_code'], (int)$_POST['sabre_id']));
     434        @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `user` = %s, `email` = %s, `invite` = %s, `msg` = '', `last_mod` = '" . $stordate ."', `status` = 'ok' WHERE `id` = %d", $_POST['user_login'], $_POST['user_email'], $_POST['invite_code'], (int)$_POST['sabre_id']));
    432435        $sabre_opt['total_accepted'] += 1;
    433436        do_action('sabre_accepted_registration');
    … …  
    452455
    453456    $curdate = current_time('timestamp', 1);
     457    $stordate = date("Y-m-d H:i:s", $curdate);
    454458
    455459    if (isset($_REQUEST['sabre_confirm']) && !empty($_REQUEST['sabre_confirm'])) {
    … …  
    458462            if ((strtotime($result->last_mod) + (int)$period*24*60*60 >= $curdate) && ('to confirm' == $result->status)) {
    459463                $error = __('Registration confirmed. You can now use your credentials to enter in this site.', 'sabre');
    460                 @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `last_mod` = FROM_UNIXTIME($curdate), `status` = 'ok' WHERE `md5_id` = %s", $_REQUEST['sabre_confirm']));
     464                @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `last_mod` = '" . $stordate ."', `status` = 'ok' WHERE `md5_id` = %s", $_REQUEST['sabre_confirm']));
    461465                $sabre_opt['total_accepted'] += 1;
    462466                update_option('sabre_opt', $sabre_opt);
    … …  
    471475                    $error = $error_head_text . $error_msg_text;
    472476                    $sabre_errors['sabre_confirm'] = $error_msg_text;
    473                     @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `msg` = '" . maybe_serialize($sabre_errors) . "', `last_mod` = FROM_UNIXTIME($curdate), `status` = 'ko' WHERE `md5_id` = %s", $_REQUEST['sabre_confirm']));
     477                    @$wpdb->query($wpdb->prepare("UPDATE `" . SABRE_TABLE . "` SET `msg` = '" . maybe_serialize($sabre_errors) . "', `last_mod` = '" . $stordate ."', `status` = 'ko' WHERE `md5_id` = %s", $_REQUEST['sabre_confirm']));
    474478                    $sabre_opt['total_stopped'] += 1;
    475479                    update_option('sabre_opt', $sabre_opt);
    … …  
    493497
    494498        $curdate = current_time('timestamp', 1);
     499        $stordate = date("Y-m-d H:i:s", $curdate);
    495500
    496501        if ($enable_confirm != 'none') {
    … …  
    507512                                $error_msg_text = __('Exceeded period for confirmation of registration.', 'sabre');
    508513                                $sabre_errors['sabre_login'] = $error_msg_text;
    509                                 @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `msg` = '" . maybe_serialize($sabre_errors) . "', `last_mod` = FROM_UNIXTIME($curdate), `status` = 'ko' WHERE `id` = " . (int)$result->id);
     514                                @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `msg` = '" . maybe_serialize($sabre_errors) . "', `last_mod` = '" . $stordate ."', `status` = 'ko' WHERE `id` = " . (int)$result->id);
    510515                                $sabre_opt['total_stopped'] += 1;
    511516                                update_option('sabre_opt', $sabre_opt);
    … …  
    635640
    636641    $curdate = current_time('timestamp', 1);
     642    $stordate = date("Y-m-d H:i:s", $curdate);
    637643
    638644    $user_info = new WP_User($reguser);
    … …  
    640646        if (!$user_info->has_cap('edit_users')) {
    641647            if (!$wpdb->get_var("SELECT COUNT(*) FROM `" . SABRE_TABLE . "` WHERE `status` in ('ok', 'to confirm') AND `user_id` = '" . $user_info->ID . "'")) {
    642                 @$wpdb->query("INSERT INTO `" . SABRE_TABLE . "` SET `user_IP` = 'none', `first_mod` = FROM_UNIXTIME($curdate), `last_mod` = FROM_UNIXTIME($curdate), `status` = 'ok', `user` = '" . $user_info->user_login . "', `email` = '" . $user_info->user_email . "', `user_id` = '" . $user_info->ID . "'");
     648                @$wpdb->query("INSERT INTO `" . SABRE_TABLE . "` SET `user_IP` = 'none', `first_mod` = '" . $stordate ."', `last_mod` = '" . $stordate ."', `status` = 'ok', `user` = '" . $user_info->user_login . "', `email` = '" . $user_info->user_email . "', `user_id` = '" . $user_info->ID . "'");
    643649                if (!mysql_error()) {
    644650                    $id = $wpdb->insert_id;
    … …  
    692698
    693699    $curdate = current_time('timestamp', 1);
     700    $stordate = date("Y-m-d H:i:s", $curdate);
    694701
    695702    $error[0] = __("Manually unregistered", 'sabre');
    … …  
    701708            if (isset($user)) wp_delete_user($user);
    702709            }
    703         $removed += @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ko', `last_mod` = FROM_UNIXTIME($curdate), `user_id` = NULL, `msg` = '" . maybe_serialize($error) . "' WHERE `id` = " . (int)$delid);
     710        $removed += @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ko', `last_mod` = '" . $stordate ."', `user_id` = NULL, `msg` = '" . maybe_serialize($error) . "' WHERE `id` = " . (int)$delid);
    704711        do_action('sabre_cancelled_registration');
    705712        }
    … …  
    720727
    721728    $curdate = current_time('timestamp', 1);
    722 
    723     $removed = @$wpdb->query("DELETE FROM `" . SABRE_TABLE . "` WHERE `status` = 'ko' AND `last_mod` < DATE_SUB(FROM_UNIXTIME($curdate), INTERVAL $days DAY)");
     729    $compdate = date("Y-m-d", $curdate);
     730
     731    $removed = $wpdb->query("DELETE FROM `" . SABRE_TABLE . "` WHERE `status` = 'ko' AND `last_mod` < DATE_SUB($compdate, INTERVAL $days DAY)");
    724732    if (!mysql_error())
    725733        return sprintf(__ngettext('%s record deleted.', '%s records deleted.', $removed, 'sabre'), $removed);
    … …  
    738746
    739747    $curdate = current_time('timestamp', 1);
     748    $stordate = date("Y-m-d H:i:s", $curdate);
    740749
    741750    $error[0] = __("Registration refused by admin", 'sabre');
    … …  
    747756            if (isset($user)) wp_delete_user($user);
    748757            }
    749         $removed += @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ko', `last_mod` = FROM_UNIXTIME($curdate), `user_id` = NULL, `msg` = '" . maybe_serialize($error) . "' WHERE `id` = " . (int)$delid);
     758        $removed += @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ko', `last_mod` = '" . $stordate ."', `user_id` = NULL, `msg` = '" . maybe_serialize($error) . "' WHERE `id` = " . (int)$delid);
    750759        }
    751760    if (!mysql_error()) {
    … …  
    768777
    769778    $curdate = current_time('timestamp', 1);
     779    $stordate = date("Y-m-d H:i:s", $curdate);
    770780
    771781    $error[0] = __("Registration confirmed by admin", 'sabre');
    … …  
    775785        $user = $wpdb->get_var("SELECT `user_id` FROM `" . SABRE_TABLE . "` WHERE `id` = " . (int)$delid);
    776786        if (isset($user)) $this->new_admin_confirmation($user);
    777         $confirmed += @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ok', `last_mod` = FROM_UNIXTIME($curdate), `msg` = '" . maybe_serialize($error) . "' WHERE `id` = " . (int)$delid);
     787        $confirmed += @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ok', `last_mod` = '" . $stordate ."', `msg` = '" . maybe_serialize($error) . "' WHERE `id` = " . (int)$delid);
    778788        do_action('sabre_accepted_registration');
    779789        }
    … …  
    964974
    965975    $curdate = current_time('timestamp', 1);
     976    $stordate = date("Y-m-d H:i:s", $curdate);
     977    $compdate = date("Y-m-d", $curdate);
    966978
    967979    if ($enable_confirm == 'user') {
    … …  
    969981        $days = (int)$period;
    970982        if ($delete_user == 'true') {
    971             $users = $wpdb->get_results("SELECT `user_id` FROM `" . SABRE_TABLE . "` WHERE `status` = 'to confirm' AND `last_mod` < DATE_SUB(FROM_UNIXTIME($curdate), INTERVAL $days DAY)");
     983            $users = $wpdb->get_results("SELECT `user_id` FROM `" . SABRE_TABLE . "` WHERE `status` = 'to confirm' AND `last_mod` < DATE_SUB($compdate, INTERVAL $days DAY)");
    972984            if ($users) {
    973985                foreach ($users as $user) {
    … …  
    977989            }
    978990
    979         @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ko', `last_mod` = FROM_UNIXTIME($curdate), `user_id` = NULL, `msg` = '" . maybe_serialize($error) . "' WHERE `status` = 'to confirm' AND `last_mod` < DATE_SUB(FROM_UNIXTIME($curdate), INTERVAL $days DAY)");
     991        @$wpdb->query("UPDATE `" . SABRE_TABLE . "` SET `status` = 'ko', `last_mod` = '" . $stordate ."', `user_id` = NULL, `msg` = '" . maybe_serialize($error) . "' WHERE `status` = 'to confirm' AND `last_mod` < DATE_SUB($compdate, INTERVAL $days DAY)");
    980992    }
    981993
    … …  
    983995    $purge = (int)$purge_days;
    984996    if ($purge > 0) {
    985         $query = "DELETE FROM `" . SABRE_TABLE . "` WHERE `last_mod` < DATE_SUB(FROM_UNIXTIME($curdate), INTERVAL $purge DAY) AND `status` not in ('ok','to confirm')";
     997        $query = "DELETE FROM `" . SABRE_TABLE . "` WHERE `last_mod` < DATE_SUB($compdate, INTERVAL $purge DAY) AND `status` not in ('ok','to confirm')";
    986998        $removed = $wpdb->query($query);
    987999    }
Note: See TracChangeset for help on using the changeset viewer.