Location: PHPKode > projects > Esvon Personals > esvon-personals/upgrades/v2_6_to_v3/upgrade260-270.php
<?php

// File to upgrade Esvon Classifieds from 2.6 to 2.7
// 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';
}
 
mysql_query("ALTER TABLE ".TBL_AD." ADD hw_weight tinyint(3) unsigned NOT NULL");
mysql_query("ALTER TABLE ".TBL_AD." ADD txn_id varchar(255) not null");
mysql_query("ALTER TABLE ".TBL_AD." ADD hw_pay_plan text NOT NULL");

mysql_query("UPDATE ".TBL_AD." SET hw_pay_plan='[FEE_FREE-0]' WHERE hw_pay_plan=''");

mysql_query("ALTER TABLE ".TBL_USER." ADD hw_ads_max smallint(5) unsigned NOT NULL");
mysql_query("ALTER TABLE ".TBL_USER." ADD txn_id varchar(255) not null");
mysql_query("ALTER TABLE ".TBL_USER." ADD hw_pay_plan text NOT NULL");

mysql_query("UPDATE ".TBL_USER." SET hw_pay_plan='[SUB_FREE-0]' WHERE hw_pay_plan=''");

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

?>
Return current item: Esvon Personals