<?php

/*
converts YALD 1.x database to 2.3.1 database.

The 2.3.1 config file must be used to this to run properly. This file also must be placed in the YALD root folder.
*/


require('inc/config.php');
require('inc/functions.php');

mysql_connect($mysql['host'],$mysql['username'],$mysql['password']);
mysql_select_db($mysql['db']);

$query = 'SELECT id,UNIX_TIMESTAMP(`date`) FROM `'.$settings['links_table'].'`';
$result = mysql_query($query);
while($row=mysql_fetch_array($result)){
	$dates[] = array('id'=>$row['id'],'date'=>$row['date']);
}

mysql_query('ALTER TABLE `'.$settings['links_table'].'` CHANGE `date` `date` INT( 21 ) NOT NULL') or die('Failed to update the "date" field. Upgrade failed. Restore previous database.');

for($i=0;$i<count($dates);$i++){
	mysql_query('UPDATE `'.$settings['links_table'].'` SET `date`="'.$dates[$i]['date'].'" WHERE id="'.$dates[$i]['id'].'"') or die('Failed to convert date format. Upgrade failed. Restore previous database.');
}

$queries[] = 'ALTER TABLE `'.$settings['links_table'].'` ADD `dateapproved` INT( 21 ) NULL ;';

$queries[] = 'ALTER TABLE `'.$settings['categories_table'].'` ADD `date` INT(21) NOT NULL DEFAULT \'0\', ADD `disp_subs` ENUM(\'true\',\'false\') NOT NULL DEFAULT \'false\', ADD `link_count` INT(10) NOT NULL, ADD `count_last_upd` INT(20) NOT NULL;';

$queries[] = 'CREATE TABLE `'.$settings['log_table'].'` (
  `id` int(21) NOT NULL auto_increment,
  `type` varchar(10) NOT NULL,
  `date` int(21) NOT NULL,
  `userid` int(10) default NULL,
  `movefrom` int(10) default NULL,
  `moveto` int(10) default NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;';

$i=1;
foreach($queries as $q){
	mysql_query($q) or die('Alter table query '.$i.' failed. Mysql said: '.mysql_error());
	$i++;
}

print "All queries ran. The upgrade seems to have been successful! Now, overwrite your old files with the files from version 2.3.1.";

?>