85 lines
1.9 KiB
PHP
85 lines
1.9 KiB
PHP
|
<?php
|
||
|
|
/**
|
||
|
|
* Database conversion script for DB v10
|
||
|
|
*
|
||
|
|
* Handles saving of the various config options.
|
||
|
|
*
|
||
|
|
* @package Setup
|
||
|
|
* @author Andreas Goetz <cpuidle@gmx.net>
|
||
|
|
* @version $Id: upgrade_v10.php,v 1.1 2007/01/04 16:14:16 andig2 Exp $
|
||
|
|
*/
|
||
|
|
|
||
|
|
|
||
|
|
/*
|
||
|
|
* userseen table upgrade
|
||
|
|
*/
|
||
|
|
|
||
|
|
$sql = 'SELECT video_id, user, users.id AS user_id
|
||
|
|
FROM userseen
|
||
|
|
LEFT JOIN users ON userseen.user = users.name';
|
||
|
|
$set = runSQL($sql, $dbh, true);
|
||
|
|
if ($set === false) return(false);
|
||
|
|
|
||
|
|
foreach ($set as $row)
|
||
|
|
{
|
||
|
|
// don't convert fishy data
|
||
|
|
if (!empty($row['user_id']))
|
||
|
|
{
|
||
|
|
$sql = "UPDATE userseen SET user_id = ".$row['user_id']." ".
|
||
|
|
"WHERE video_id = ".$row['video_id']." AND user = '".$row['user']."'";
|
||
|
|
|
||
|
|
if (runSQL($sql, $dbh) === false) return(false);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
/*
|
||
|
|
* userconfig table upgrade
|
||
|
|
*/
|
||
|
|
|
||
|
|
$sql = 'SELECT user, opt, users.id AS user_id
|
||
|
|
FROM userconfig
|
||
|
|
LEFT JOIN users ON userconfig.user = users.name';
|
||
|
|
$set = runSQL($sql, $dbh);
|
||
|
|
if ($set === false) return(false);
|
||
|
|
|
||
|
|
foreach ($set as $row)
|
||
|
|
{
|
||
|
|
// don't convert fishy data
|
||
|
|
if (!empty($row['user_id']))
|
||
|
|
{
|
||
|
|
$sql = "UPDATE userconfig SET user_id = ".$row['user_id']." ".
|
||
|
|
"WHERE opt = '".$row['opt']."' AND user = '".$row['user']."'";
|
||
|
|
|
||
|
|
if (runSQL($sql, $dbh) === false) return(false);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
/*
|
||
|
|
* videodata table upgrade
|
||
|
|
*/
|
||
|
|
|
||
|
|
$sql = 'SELECT videodata.id AS id, owner, users.id AS owner_id
|
||
|
|
FROM videodata
|
||
|
|
LEFT JOIN users ON videodata.owner = users.name';
|
||
|
|
$set = runSQL($sql, $dbh);
|
||
|
|
if ($set === false) return(false);
|
||
|
|
|
||
|
|
foreach ($set as $row)
|
||
|
|
{
|
||
|
|
// don't convert fishy data
|
||
|
|
if (!empty($row['owner_id']))
|
||
|
|
{
|
||
|
|
$sql = "UPDATE videodata SET owner_id = ".$row['owner_id']." ".
|
||
|
|
"WHERE id = ".$row['id'];
|
||
|
|
|
||
|
|
if (runSQL($sql, $dbh) === false) return(false);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// signal success
|
||
|
|
return true;
|
||
|
|
|
||
|
|
?>
|