Changeset 667

Show
Ignore:
Timestamp:
07/12/06 18:52:21 (2 years ago)
Author:
donncha
Message:

Log registrations (#77)

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/wp-admin/upgrade-schema.php

    r658 r667  
    165165  KEY lang_id (lang_id) 
    166166); 
    167 CREATE TABLE wp_blog_versions ( 
     167CREATE TABLE $wpdb->blog_versions ( 
    168168  blog_id bigint(20) NOT NULL default '0', 
    169169  db_version varchar(20) NOT NULL default '', 
     
    172172  KEY db_version (db_version) 
    173173); 
    174 CREATE TABLE wp_registration_log ( 
     174CREATE TABLE $wpdb->registration_log ( 
    175175  ID bigint(20) NOT NULL auto_increment, 
    176176  email varchar(255) NOT NULL default '', 
  • trunk/wp-content/mu-plugins/misc.php

    r599 r667  
    126126add_action('wp_set_comment_status', 'update_pages_last_updated'); 
    127127 
     128function wpmu_log_new_registrations( $blog_id, $user_id ) { 
     129        global $wpdb; 
     130        $user = new WP_User($user_id); 
     131        $email = $wpdb->escape($user->user_email); 
     132        $IP = preg_replace( '/[^0-9., ]/', '',$_SERVER['REMOTE_ADDR'] ); 
     133        $wpdb->query( "INSERT INTO {$wpdb->registration_log} ( email , IP , blog_id, t ) VALUES ( '{$email}', '{$IP}', '{$blog_id}', NOW( ))" ); 
     134} 
     135 
     136add_action( "wpmu_new_blog" ,"wpmu_log_new_registrations", 10, 2 ); 
    128137 
    129138?> 
  • trunk/wp-settings.php

    r663 r667  
    8383$wpdb->sitecategories   = $table_prefix . 'sitecategories'; 
    8484$wpdb->signups          = $table_prefix . 'signups'; 
     85$wpdb->registration_log = $table_prefix . 'registration_log'; 
     86$wpdb->blog_versions    = $table_prefix . 'blog_versions'; 
    8587 
    8688require_once ( ABSPATH . 'wpmu-settings.php' );