diff -r d972b1276d95 -r 49db7495f6b8 install/schemas/upgrade/1.1.6-1.1.7.php --- 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 @@ -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']; - } -} -