SITE SIFT LISTINGS VERIONS 1.11 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.11. If you are 
upgrading a version older than 1.11, 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, 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.

#############################################################
UPGRADE WARNING:
This upgrade will remove "credits", "members" and "accounting"
functionality from Site Sift Listings.
#############################################################

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

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

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

/include/myfunctions.ini.php

/admin/header.htm
/admin/index.php

/admin/settings/index.php

/admin/pages/edit.php
/admin/pages/suspend.php
/admin/pages/pending.php
/admin/pages/delete.php
/admin/pages/detail.php
/admin/pages/class.googleSitemap.php
/admin/pages/index.php
/admin/pages/google.php

/admin/categories/edit.php
/admin/categories/index.php
/admin/categories/subcat.php
/admin/categories/detail.php
/admin/categories/add.php
/admin/categories/delete.php

/db/table1.txt
/db/table2.txt
/db/table3.txt
/db/table4.txt
/db/table5.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 `categories` ADD `lastUpdate` DATE NOT NULL;
UPDATE `categories` SET `lastUpdate`=now();
ALTER TABLE `settings` ADD `descriptionMaxLength` MEDIUMINT( 4 ) DEFAULT '0' NOT NULL ,
ADD `descriptionMinLength` MEDIUMINT( 4 ) DEFAULT '0' NOT NULL ;
UPDATE `settings` SET `descriptionMaxLength` = '300',
`descriptionMinLength` = '100' WHERE `id` =1 LIMIT 1 ;
ALTER TABLE `settings` ADD `perPage` MEDIUMINT( 5 ) NOT NULL AFTER `perCollum` ;
UPDATE `settings` SET `perPage` = '20' WHERE `id` =1 LIMIT 1 ;
ALTER TABLE `settings` ADD `linkTypeFree` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `linkTypeSponsor` TINYINT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `settings` ADD `reciprocalCheck` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `reciprocalCheckText` TEXT NOT NULL ,
ADD `sponsorPrice` DECIMAL( 9, 2 ) NOT NULL ;
UPDATE `settings` SET `reciprocalCheck` = '1', 
`reciprocalCheckText` = 'href="http://www.yourdomain.com"', 
`sponsorPrice` = '10.00' WHERE `id` =1 LIMIT 1 ;
ALTER TABLE `pages` CHANGE `mid` `mid` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `pages` DROP `accounting_id` ;
ALTER TABLE `pages` ADD `reciprocalCheckText` TEXT NULL ;
ALTER TABLE `pages` CHANGE `description` `description` TEXT NOT NULL;
ALTER TABLE `settings` ADD `linkTypePaid` TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER `linkTypeFree` ;
ALTER TABLE `settings` ADD `paidPrice` DECIMAL( 9, 2 ) NOT NULL ;
UPDATE `settings` SET `paidPrice` = '5.00' WHERE `id` =1 LIMIT 1 ;
ALTER TABLE `settings` ADD `sponsorDays` INT( 11 ) DEFAULT '0' NOT NULL AFTER `sponsorPrice` ;
ALTER TABLE `settings` ADD `reciprocalDomain` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `reciprocalCheck` ;
ALTER TABLE `settings` DROP `payOnly` ;
ALTER TABLE `settings` ADD `usePaypal` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `paypalEmail` VARCHAR( 128 ) NOT NULL ,
ADD `paypalReturn` VARCHAR( 255 ) NOT NULL ,
ADD `paypalCurrency` VARCHAR( 16 ) NOT NULL ,
ADD `paypalLc` VARCHAR( 16 ) NOT NULL ,
ADD `paypalPaidItemName` VARCHAR( 255 ) NOT NULL ,
ADD `paypalPaidItemNumber` VARCHAR( 64 ) NOT NULL ,
ADD `paypalSponsorItemName` VARCHAR( 255 ) NOT NULL ,
ADD `paypalSponsorItemNumber` VARCHAR( 64 ) NOT NULL ,
ADD `use2co` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `2coSID` VARCHAR( 16 ) NOT NULL ,
ADD `2coPaidProductID` VARCHAR( 16 ) NOT NULL ,
ADD `2coPaidItemName` VARCHAR( 255 ) NOT NULL ,
ADD `2coPaidItemNumber` VARCHAR( 64 ) NOT NULL ,
ADD `2coSponsorProductID` VARCHAR( 16 ) NOT NULL ,
ADD `2coSponsorItemName` VARCHAR( 255 ) NOT NULL ,
ADD `2coSponsorItemNumber` VARCHAR( 64 ) NOT NULL ;
UPDATE `settings` SET `usePaypal` = '1', `paypalEmail` = 'you@yourdomain.com', `paypalReturn` = 'http://www.yourdomain.com/index.php?go=success', `paypalCurrency` = 'USD', `paypalLc` = 'US', `paypalPaidItemName` = 'Paid Link', `paypalPaidItemNumber` = 'paid', `paypalSponsorItemName` = 'Sponsor Link', `paypalSponsorItemNumber` = 'sponsor', `use2co` = 0, `2coSID` = '307785', `2coPaidProductID` = '1', `2coPaidItemName` = 'Paid Link', `2coPaidItemNumber` = 'paid', `2coSponsorProductID` = '2', `2coSponsorItemName` = 'Sponsor Link', `2coSponsorItemNumber` = 'sponsor' where `id` = '1' limit 1;
ALTER TABLE `settings` ADD `paypalNotify` VARCHAR( 255 ) NOT NULL AFTER `paypalEmail` ;
UPDATE `settings` SET `paypalNotify` = 'http://www.yourdomain.com/paypal.php' where `id` = '1' limit 1;
ALTER TABLE `settings` ADD `paypalAuthToken` VARCHAR( 255 ) NOT NULL AFTER `paypalEmail` ;
UPDATE `settings` SET `paypalAuthToken` = 'GX_sTf5bW3wxRfFEbgofs88nQxvMQ7nsI8m21rzNESnl_79ccFTWj2aPgQ0' where `id` = '1' limit 1;
ALTER TABLE `pages` ADD `completed` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `mid` ;
ALTER TABLE `pages` CHANGE `completed` `completed` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `pages` ADD `paymentData` TEXT NOT NULL ;

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

      UPGRADE COMPLETE

      SEE HELP.txt FOR ANSWERS TO COMMON QUESTIONS.      

      ENJOY SITE SIFT LISTINGS v1.20

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

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