diff -r de56132c008d -r bdac73ed481e install/schemas/upgrade/1.1.6-1.1.7.php --- a/install/schemas/upgrade/1.1.6-1.1.7.php Sun Mar 28 21:49:26 2010 -0400 +++ b/install/schemas/upgrade/1.1.6-1.1.7.php Sun Mar 28 23:10:46 2010 -0400 @@ -6,30 +6,30 @@ $q = $db->sql_query('SELECT user_id, username FROM ' . table_prefix . 'users;'); if ( !$q ) - $db->_die(); + $db->_die(); $map = array(); while($row = $db->fetchrow()) { - $map[ $row['username'] ] = $row['user_id']; + $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(); + $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']; - } + 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']; + } }