function rotor_update_5101 in Rotor Banner 5

File

./rotor.install, line 73

Provides install and uninstall functions for rotor.

Code

function rotor_update_5101() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret = array();
      $result = db_fetch_object(db_query('SELECT * from {rotor_item} LIMIT 1'));
      if ($result->file_path) {
        $result = db_query('SELECT * from {rotor_item}');
        $ret[] = update_sql("ALTER TABLE {rotor_item} CHANGE file_path fid int(10) unsigned NOT NULL");
        while ($rotor_item = db_fetch_object($result)) {
          $filename = basename($rotor_item->file_path);
          $fid = db_next_id('{files}_fid');
          db_query("INSERT INTO {files} (fid, nid, filename, filepath, filemime, filesize)\n          \t\t  VALUES (%d, %d, '%s', '%s', '%s', %d)", $fid, $rotor_item->nid, $filename, $rotor_item->file_path, '', filesize($rotor_item->file_path));
          db_query('UPDATE {rotor_item} set fid = %d WHERE nid = %d', $fid, $rotor_item->nid);
        }
      }
      break;
  }
  return $ret;
}