--- a/install/schemas/upgrade/1.1.6-1.1.7.php Thu Jul 01 18:25:04 2010 -0400
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,35 +0,0 @@
-<?php
-
-// Migrate usernames in the logs table
-
-global $db, $session, $paths, $template, $plugins; // Common objects
-
-$q = $db->sql_query('SELECT user_id, username FROM ' . table_prefix . 'users;');
-if ( !$q )
- $db->_die();
-
-$map = array();
-while($row = $db->fetchrow())
-{
- $map[ $row['username'] ] = $row['user_id'];
-}
-$db->free_result();
-
-$q = $db->sql_query('SELECT author FROM ' . table_prefix . 'logs WHERE author_uid = 1;');
-if ( !$q )
- $db->_die();
-
-$updated = array();
-
-while ( $row = $db->fetchrow($q) )
-{
- if ( isset($map[ $row['author'] ]) && !is_valid_ip($row['author']) && !in_array($row['author'], $updated) )
- {
- $author = $db->escape($row['author']);
- $sql = "UPDATE " . table_prefix . "logs SET author_uid = {$map[ $row['author'] ]} WHERE author = '$author';";
- if ( !$db->sql_query($sql) )
- $db->_die();
- $updated[] = $row['author'];
- }
-}
-