install/schemas/upgrade/1.1.6-1.1.7.php
changeset 1259 49db7495f6b8
parent 1258 d972b1276d95
child 1260 cd72bcd83401
--- 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'];
-	}
-}
-