[Sommaire] [Imprimer]

   1  <?php
   2  if(!defined("PHORUM_ADMIN")) return;
   3  
   4  $cid=phorum_db_mysql_connect();
   5  
   6  // converting the custom-fields
   7  $res=mysql_query("SELECT user_id,user_data FROM {$PHORUM['user_table']}",$cid);
   8  
   9  while($row=mysql_fetch_assoc($res)) {
  10      $userdata=array('user_id'=>$row['user_id']);
  11      $user_data_new=array();
  12      $user_data_old=unserialize($row['user_data']);
  13      
  14      // converting meta-data to fields
  15      if(isset($user_data_old['show_signature']) && !empty($user_data_old['show_signature']))
  16          $userdata['show_signature']=$user_data_old['show_signature'];
  17              
  18      if(isset($user_data_old['email_notify']) && !empty($user_data_old['email_notify']))
  19          $userdata['email_notify']=$user_data_old['email_notify'];
  20          
  21      if(isset($user_data_old['tz_offset']) && !empty($user_data_old['tz_offset']))
  22          $userdata['tz_offset']=$user_data_old['tz_offset'];        
  23          
  24      if(isset($user_data_old['is_dst']) && !empty($user_data_old['is_dst']))
  25          $userdata['is_dst']=$user_data_old['is_dst'];
  26  
  27      if(isset($user_data_old['user_language']) && !empty($user_data_old['user_language']))
  28          $userdata['user_language']=$user_data_old['user_language'];
  29  
  30      if(isset($user_data_old['user_template']) && !empty($user_data_old['user_template']))
  31          $userdata['user_template']=$user_data_old['user_template'];    
  32          
  33      unset($user_data_old['user_template']);
  34      unset($user_data_old['user_language']);
  35      unset($user_data_old['is_dst']);
  36      unset($user_data_old['tz_offset']);
  37      unset($user_data_old['email_notify']);
  38      unset($user_data_old['show_signature']);
  39      
  40      // converting custom-fields now    
  41      if(is_array($user_data_old) && count($user_data_old)) {
  42          foreach($user_data_old as $old_key => $old_val) {
  43              $type=-1;
  44              // find out which ID that custom-field has
  45              foreach($PHORUM['PROFILE_FIELDS'] as $ctype => $cdata) {
  46                  if($cdata['name'] == $old_key) {
  47                      $type=$ctype;
  48                      break;
  49                  }
  50              }
  51  
  52              if($type != -1) { // store it only if we found it
  53                  if( $old_val!=="" ) {
  54                      if(!is_array($old_val)) {
  55                          $user_data_new[$type] = substr($old_val,0,$PHORUM['PROFILE_FIELDS'][$type]['length']);
  56                      } else {
  57                          $user_data_new[$type] = $old_val;
  58                      }
  59                  }
  60              }
  61          }
  62      }
  63      
  64      $userdata['user_data']=$user_data_new;
  65      phorum_user_save($userdata);
  66  }
  67  // remove old column
  68  //mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} DROP newflags",$cid);
  69  
  70  ?>