1 <?php

     2 

     3 // Migrate usernames in the logs table

     4 

     5 global $db, $session, $paths, $template, $plugins; // Common objects

     6 

     7 $q = $db->sql_query('SELECT user_id, username FROM ' . table_prefix . 'users;');

     8 if ( !$q )

     9 	$db->_die();

    10 

    11 $map = array();

    12 while($row = $db->fetchrow())

    13 {

    14 	$map[ $row['username'] ] = $row['user_id'];

    15 }

    16 $db->free_result();

    17 

    18 $q = $db->sql_query('SELECT author FROM ' . table_prefix . 'logs WHERE author_uid = 1;');

    19 if ( !$q )

    20 	$db->_die();

    21 

    22 $updated = array();

    23 

    24 while ( $row = $db->fetchrow($q) )

    25 {

    26 	if ( isset($map[ $row['author'] ]) && !is_valid_ip($row['author']) && !in_array($row['author'], $updated) )

    27 	{

    28 		$author = $db->escape($row['author']);

    29 		$sql = "UPDATE " . table_prefix . "logs SET author_uid = {$map[ $row['author'] ]} WHERE author = '$author';";

    30 		if ( !$db->sql_query($sql) )

    31 			$db->_die();

    32 		$updated[] = $row['author'];

    33 	}

    34 }

    35