install/schemas/upgrade/1.1.6-1.1.7.php
author Dan
Wed, 02 Jun 2010 21:58:26 -0400
changeset 1252 e34c23a35dc9
parent 1227 bdac73ed481e
permissions -rw-r--r--
Rewrote category editor. This breaks the JSON API. Also fixed a few bugs with how Wiki Mode is set in $paths. (Hopefully that doesn't cause infinite loops, heh). Fixes issue 20.

<?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'];
	}
}