SITE SIFT LISTINGS VERIONS 1.30 UPDGRADE INSTRUCTIONS
#############################################################
#############################################################

     BACKUP YOUR FILES AND DATABASE BEFORE PROCEEDING!!!

#############################################################
#############################################################

This file contains the names of files that have been modified 
since the release of Site Sift Listings v. 1.20. If you are 
upgrading a version older than 1.20, you will need to follow
the instructions sequentially by version in the *UPGRADE_INFO.txt
files.

If this is your first download of Site Sift Listings, you can
ignore this file.

To upgrade your existing version of Site Sift Listings v 1.20,
copy these files to the proper location on your server. Note 
that any changes you've made to your files will be erased when 
you overwrite them.

#############################################################

BACKUP ALL FILES AND DATABASE BEFORE DOING THIS UPGRADE!!!!!!

#############################################################
NOTE: CURL AND GD-ENABLED PHP ARE REQUIRED FOR VERSION 1.30
      CURL IS NECESSARY FOR THE LINK CHECKER
      GD IS NECESSARY FOR THE SECURITY IMAGE
#############################################################

/HELP.txt
/add_page.php
/paypal.php
/codeImage.php
/version_check.php
/v1.30_UPGRADE_INFO.txt
/success.php
/index.php
/pages.php
/spages.php
/install.php
/install2.php
/footer.php
/header.php
/htaccess.txt ** RENAME TO .htaccess AFTER UPLOADING
/home.php
/install3.php
/cat_results.php
/cat_result.php
/sitemap.xml ** CHMOD THIS FILE TO 777 UNIX SERVERS, MAKE WRITEABLE ON WINDOWS SERVERS
/2checkout.php

/include/myfunctions.ini.php
/include/classes.php

/admin/header.htm
/admin/login.php

/admin/settings/index.php

/admin/backup/.htaccess
/admin/backup/index.php
/admin/backup/db_functions.php

/admin/coupons/add.php
/admin/coupons/delete.php
/admin/coupons/edit.php
/admin/coupons/index.php

/admin/ban/add.php
/admin/ban/delete.php
/admin/ban/edit.php
/admin/ban/index.php

/admin/smp1/link/CURL.php
/admin/smp1/link/index.php
/admin/smp1/link/link_scan.php

/admin/smp1/mail/.htaccess
/admin/smp1/mail/index.php
/admin/smp1/mail/mail_replace.php
/admin/smp1/mail/subject_replace_a.php
/admin/smp1/mail/subject_replace_d.php
/admin/smp1/mail/subject_a.txt ** CHMOD THIS FILE TO 777 UNIX SERVERS, MAKE WRITEABLE ON WINDOWS SERVERS
/admin/smp1/mail/subject_d.txt ** CHMOD THIS FILE TO 777 UNIX SERVERS, MAKE WRITEABLE ON WINDOWS SERVERS

/admin/pages/.htaccess
/admin/pages/edit.php
/admin/pages/suspend.php
/admin/pages/pending.php
/admin/pages/delete.php
/admin/pages/detail.php
/admin/pages/index.php
/admin/pages/expsuspend.php
/admin/pages/pendingbulkprocess.php
/admin/pages/exbulkprocess.php
/admin/pages/expired.php
/admin/pages/declined.txt ** CHMOD THIS FILE TO 777 UNIX SERVERS, MAKE WRITEABLE ON WINDOWS SERVERS
/admin/pages/approved.txt ** CHMOD THIS FILE TO 777 UNIX SERVERS, MAKE WRITEABLE ON WINDOWS SERVERS

/db/table2.txt
/db/table3.txt
/db/table4.txt
/db/table5.txt
/db/table6.txt
/db/contents.txt


#############################################################
The database also needs to be updated. To do so, run the following
sql on your database. You can use a utility such as phpMyAdmin to 
do this.


ALTER TABLE `settings` ADD `securityImage` VARCHAR( 8 ) DEFAULT 'Yes' NOT NULL AFTER `preventDuplicates` ;
ALTER TABLE `pages` ADD `link_checked` INT DEFAULT '0' NOT NULL ,
ADD `link_status` INT DEFAULT '0' NOT NULL ;
CREATE TABLE `coupons` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`coupons_code` VARCHAR( 16 ) NOT NULL ,
`coupons_start` DATE NOT NULL ,
`coupons_end` DATE NOT NULL ,
`coupons_linktype` VARCHAR( 12 ) NOT NULL ,
`coupons_discountamount` DECIMAL( 9, 2 ) NOT NULL ,
`coupons_discounttype` VARCHAR( 12 ) NOT NULL ,
UNIQUE ( `coupons_code` ) 
) TYPE = MYISAM ;
ALTER TABLE `pages` ADD `coupon` VARCHAR( 16 ) default NULL AFTER `reciprocalCheckText` ;
DROP TABLE IF EXISTS `ban`;
CREATE TABLE `ban_domain` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`domain` VARCHAR( 255 ) NOT NULL ,
UNIQUE ( `domain` ) 
);
ALTER TABLE `settings` ADD `paidDays` INT( 11 ) NOT NULL DEFAULT '0' AFTER `paidPrice` ;
ALTER TABLE `pages` ADD `paymentProcessor` VARCHAR( 32 ) NULL AFTER `paymentData` ;
ALTER TABLE `settings` DROP `paypalAuthToken`; 

 
#############################################################
#############################################################

      UPGRADE COMPLETE

      SEE HELP.txt FOR ANSWERS TO COMMON QUESTIONS.      

      ENJOY SITE SIFT LISTINGS v1.30

#############################################################
#############################################################

If you do not understand the instructions in this file, please
install a fresh copy of Site Sift Listings included with this 
package.

#############################################################
END OF FILE