Need help following mod instructions

[jjensen]

I'm trying to set up a cart for a local symphony and I need products (tickets) to expire. I found a mod someone wrote here:

http://www.zen-cart.com/showthread.p...page2&p=793533

The problem is I'm new to PHP and SQL, so I'm having problems following the instructions:

Run these 3 sql queries:
ALTER TABLE `products` ADD `products_date_expire` DATETIME AFTER `products_date_available` ;

UPDATE products SET products_date_expire = '2099-12-31';

INSERT INTO configuration VALUES ("", "Use product expire date featured", "PRODUCT_EXP_DATE", "true", "Automatically disable product after expire date", 8, 100, NULL, "2008-09-22 07:55:24", NULL, "zen_cfg_select_option(array(""true"", ""false""), ")

What SQL queries am I running? I can find in phpMyAdmin (version 3.5.8.1) where to run queries, but I am lost following the instructions. I've been searching, but haven't turned anything up and am running out of time. Can anyone provide handholding to a zc newbie?

-Running v. 1.5.1 and Sheffield Blue template.-

[stevesh]

Easiest way would be to paste the SQL (I would do them one at a time) into the box in Admin - Tools - Install SQL Patches and click on Send. The third one doesn't seem to be complete.

Looking at that thread, I'd guess that the mod isn't really ready for primetime. I hope you're installing it on a test site and not your live store. If it weren't for your time constraints someone (maybe me) could check it out on Zencart version 1.5.1.

[jjensen]

Thanks for responding. My site is kind of live but still in testing. (We aren't hooked up to any payment module, etc., but it's visible to the public.) How long would it take to get something like this to work? Are we talking 2 weeks, or over a month? I've already missed the arbitrary deadline they gave, but can also argue that they didn't lessen any of my workload, so that deadline wasn't going to work anyway. If I can't have the products expire, I think we'll have to give up on zc and look at other options. Honestly, I've seen a number of people looking for this mod, so if we can get it worked out it might help others. I'm willing to do some work on it with someone (you?) and try and figure this out if it's doable.