function avatar_selection_update_4 in Avatar Selection 5.2

Updates the avatar entry so it's just a filename, rather than a path + filename.

Return value

Array to which query results will be added.

File

./avatar_selection.install, line 186

The Avatar Selection module install file.

Code

function avatar_selection_update_4() {
  $ret = array();
  $result = db_query("SELECT avatar FROM {avatar_selection}");
  while ($avatar_info = db_fetch_object($result)) {
    $avatar = $avatar_info->avatar;
    $path_info = pathinfo($avatar);
    $ret[] = update_sql("UPDATE {avatar_selection} SET avatar = '" . $path_info['basename'] . "' WHERE avatar = '" . $avatar . "'");
  }
  return $ret;
}