rmf('../includes/currencies.php');
rmf('../includes/email_auction_confirmation.php');
rmf('../includes/email_endauction_cumulative.php');
rmf('../includes/email_endauction_nowinner.php');
rmf('../includes/email_endauction_winner.php');
rmf('../includes/email_endauction_youwin.php');
rmf('../includes/email_endauction_youwin_nodutch.php');
rmf('../includes/email_outbid.php');
rmf('../includes/email_user_approved.php');
rmf('../includes/email_user_confirmation.php');
rmf('../includes/email_user_needapproval.php');
rmf('../includes/htmLawed.php');
rmf('../includes/template.php');
rmf('../includes/useragent.inc.php');
rmf('../js/calendar.php');
rmf('../js/google_converter.js');
rmf('../js/jquery.dimensions.js');
rmf('../captcha.php');
rmf('../captcha_play.php');
rmf('../converter.php');
rmf('../loader.php');
rrmdir('../fck');
rrmdir('../ckeditor');
rrmdir('../inc/captcha');
rrmdir('../includes/captcha');
rrmdir('../inc/checks');
rrmdir('../inc/flags');
rrmdir('../includes/flags');
rrmdir('../inc/plupload');
rrmdir('../themes/admin');
rrmdir('../themes/default');
$query = "UPDATE `" . $DBPrefix . "users` dest, (SELECT * FROM `" . $DBPrefix . "temp_install` WHERE table = '" . $DBPrefix . "users' AND table_colomn = 'reg_date') src SET dest.reg_date = src.new_value where dest.id = src.table_id;";
$db->direct_query($query);
$query = "ALTER TABLE `" . $DBPrefix . "users` MODIFY `reg_date` datetime default CURRENT_TIMESTAMP;";
$db->direct_query($query);
// users.lastlogin date("Y-m-d H:i:s")
$query = "INSERT INTO `" . $DBPrefix . "temp_install` (`table`, `table_colomn`, `table_id`, `old_value`, `new_value`)\n VALUES (SELECT '" . $DBPrefix . "users', 'lastlogin', id, lastlogin, STR_TO_DATE(lastlogin, '%Y-%m-%d %H:%i:%s') FROM `" . $DBPrefix . "users`);";
$db->direct_query($query);
$query = "UPDATE `" . $DBPrefix . "users` dest, (SELECT * FROM `" . $DBPrefix . "temp_install` WHERE table = '" . $DBPrefix . "users' AND table_colomn = 'lastlogin') src SET dest.lastlogin = src.new_value where dest.id = src.table_id;";
$db->direct_query($query);
$query = "ALTER TABLE `" . $DBPrefix . "users` MODIFY `lastlogin` datetime default CURRENT_TIMESTAMP;";
$db->direct_query($query);
// useraccounts.date time()
$query = "INSERT INTO `" . $DBPrefix . "temp_install` (`table`, `table_colomn`, `table_id`, `old_value`, `new_value`)\n VALUES (SELECT '" . $DBPrefix . "useraccounts', 'date', id, `date`, FROM_UNIXTIME(`date`) FROM `" . $DBPrefix . "useraccounts`);";
$db->direct_query($query);
$query = "UPDATE `" . $DBPrefix . "useraccounts` dest, (SELECT * FROM `" . $DBPrefix . "temp_install` WHERE table = '" . $DBPrefix . "useraccounts' AND table_colomn = 'date') src SET dest.`date` = src.new_value where dest.id = src.table_id;";
$db->direct_query($query);
$query = "ALTER TABLE `" . $DBPrefix . "useraccounts` MODIFY `date` datetime default CURRENT_TIMESTAMP;";
$db->direct_query($query);
// winners.closingdate time()
$query = "INSERT INTO `" . $DBPrefix . "temp_install` (`table`, `table_colomn`, `table_id`, `old_value`, `new_value`)\n VALUES (SELECT '" . $DBPrefix . "winners', 'closingdate', id, closingdate, FROM_UNIXTIME(closingdate) FROM `" . $DBPrefix . "winners`);";
$db->direct_query($query);
$query = "UPDATE `" . $DBPrefix . "winners` dest, (SELECT * FROM `" . $DBPrefix . "temp_install` WHERE table = '" . $DBPrefix . "winners' AND table_colomn = 'closingdate') src SET dest.closingdate = src.new_value where dest.id = src.table_id;";
$db->direct_query($query);
$query = "ALTER TABLE `" . $DBPrefix . "winners` MODIFY `closingdate` datetime default CURRENT_TIMESTAMP;";
$db->direct_query($query);
$query = "DROP TABLE IF EXISTS `" . $DBPrefix . "temp_install`;";
$db->direct_query($query);
// remove unused files and folders from previous versions
rmf('../includes/functions_rebuild.php');
rmf('../includes/membertypes.inc.php');
