<?php

// File to upgrade Esvon Classifieds from 4.0.2 to 4.0.3
// After use this, you can delete it

//*********************************************

define('DB_UPGRADE', 1);

if(!defined('SITE_PATH')){
  if(!file_exists('./inc/application.php')) die("File Not Found: application.php");
  require_once './inc/application.php';
}

if(hwModGetState('Member_Website')){
  mysql_query("CREATE TABLE ".hwModTable('Member_Website','user_info')." (
   id mediumint(8) unsigned NOT NULL auto_increment,
   v_255_1 varchar(255) NOT NULL,
   PRIMARY KEY (id))");
}

if(hwModGetState('Auction')){
  mysql_query("ALTER TABLE ".TBL_AD." ADD hw_auct_enabled char(1) NOT NULL");
  mysql_query("ALTER TABLE ".TBL_AD." ADD hw_auct_res_price decimal(9,2) unsigned NOT NULL");
} 

if(hwModGetState('Reviews')){
  mysql_query("ALTER TABLE ".hwModTable('Reviews','data')." ADD writer_id mediumint(8) unsigned DEFAULT '0' NOT NULL");
}

mysql_query("CREATE TABLE ".TBL_FILE." (
  lid mediumint(8) unsigned DEFAULT '0' NOT NULL,
  fname varchar(255) NOT NULL default '',
  descr text NOT NULL,
  approved tinyint(3) unsigned DEFAULT '1' NOT NULL,
  PRIMARY KEY (lid,fname)
)");

if(hwModGetState('Form_to_Email')){
  $tbl = hwModTable('Form_to_Email','log');
  mysql_query("DROP TABLE $tbl");
  mysql_query("CREATE TABLE $tbl (
  ip int(11) unsigned NOT NULL,
  date_added datetime NOT NULL,
  PRIMARY KEY (ip))");
}

echo 'Esvon Classifieds Tables Updated, Ok.. ('.basename(__FILE__).')';

?>