Changeset 1971

Timestamp:

12/17/2004 07:27:35 PM (22 years ago)

Author:

saxmatt

Message:

Change dateYMDhour to be something more sane, bugfix on edit.php.

Location:

trunk

Files:

• wp-admin/edit.php (modified) (1 diff)
• wp-admin/upgrade-functions.php (modified) (1 diff)
• wp-admin/upgrade-schema.php (modified) (1 diff)
• wp-admin/user-edit.php (modified) (1 diff)
• wp-admin/users.php (modified) (1 diff)
• wp-register.php (modified) (1 diff)

trunk/wp-admin/edit.php

@@ -65 +65 @@
 <h2>
 <?php
-if ( isset( $_GET['m'] ) ) {
+if ( $_GET['m'] ) {
         echo $month[substr( $_GET['m'], 4, 2 )] . ' ' . substr( $_GET['m'], 0, 4 );
 } elseif ( isset( $_GET['s'] ) ) {

trunk/wp-admin/upgrade-functions.php

@@ -130 +130 @@
                 $wpdb->query("UPDATE $wpdb->posts SET post_modified_gmt = DATE_ADD(post_modified, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE) WHERE post_modified != '0000-00-00 00:00:00'");
                 $wpdb->query("UPDATE $wpdb->comments SET comment_date_gmt = DATE_ADD(comment_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)");
-                $wpdb->query("UPDATE $wpdb->users SET dateYMDhour = DATE_ADD(dateYMDhour, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)");
+                $wpdb->query("UPDATE $wpdb->users SET user_registered = DATE_ADD(dateYMDhour, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)");
         }
 

trunk/wp-admin/upgrade-schema.php

@@ -136 +136 @@
   user_domain varchar(200) NOT NULL default '',
   user_browser varchar(200) NOT NULL default '',
-  dateYMDhour datetime NOT NULL default '0000-00-00 00:00:00',
+  user_registered datetime NOT NULL default '0000-00-00 00:00:00',
   user_level int(2) unsigned NOT NULL default '0',
   user_aim varchar(50) NOT NULL default '',

trunk/wp-admin/user-edit.php

@@ -110 +110 @@
                 <td><?php echo get_usernumposts($edituser->ID); ?></td>
         </tr>
+<?php if ( '0000-00-00 00:00:00' != $edituser->user_registered ) { ?>
+        <tr>
+                <th scope="row"><?php _e('Registered on:') ?></th>
+                <td><?php echo substr($edituser->user_registered, 0, 11); ?></td>
+        </tr>
+<?php } ?>
         <tr>
                 <th scope="row"><?php _e('First name:') ?></th>

trunk/wp-admin/users.php

@@ -72 +72 @@
 
         $result = $wpdb->query("INSERT INTO $wpdb->users 
-                (user_login, user_pass, user_nickname, user_email, user_ip, user_domain, user_browser, dateYMDhour, user_level, user_idmode, user_firstname, user_lastname, user_nicename, user_url)
+                (user_login, user_pass, user_nickname, user_email, user_ip, user_domain, user_browser, user_registered, user_level, user_idmode, user_firstname, user_lastname, user_nicename, user_url)
         VALUES 
                 ('$user_login', MD5('$pass1'), '$user_nickname', '$user_email', '$user_ip', '$user_domain', '$user_browser', '$now', '$new_users_can_blog', 'nickname', '$user_firstname', '$user_lastname', '$user_nicename', '$user_uri')");

trunk/wp-register.php

@@ -72 +72 @@
 
         $result = $wpdb->query("INSERT INTO $wpdb->users 
-                (user_login, user_pass, user_nickname, user_email, user_ip, user_browser, dateYMDhour, user_level, user_idmode, user_nicename)
+                (user_login, user_pass, user_nickname, user_email, user_ip, user_browser, user_registered, user_level, user_idmode, user_nicename)
         VALUES 
                 ('$user_login', MD5('$pass1'), '$user_nickname', '$user_email', '$user_ip', '$user_browser', '$now', '$user_level', 'nickname', '$user_nicename')");