Free PHP Voucher Code Framework

[lowndsy]

Oops - added some extra bug checking to the code and left the old line in too.
Easy peasy to fix - just find this in newcode.php:

PHP Code:

$perform_insert=mysql_query($sql);
$perform_insert = mysql_query($sql) or die("<b>Data could not be entered</b>.\nQuery: " . $query . "\nError: (" . mysql_errno() . ") " . mysql_error()); 


and delete this line:

PHP Code:

$perform_insert=mysql_query($sql); 


The zip file download has been updated with the fixed version.

[ChristopherB]

Another issue is, i added a discount code for the merchant dixons (created the merchant also.) however under D it's not working and it's not entering anything in the DB for the firstletter.

[Richard101]

Great framework, should create a number of diverse sites, as intended.

I have played around with some of the sql to change when a code is expired. At the moment the function is referencing now() to determine which codes are expired and hence indicating codes that expire today are expired.

I have tried using (DATE_ADD(now(),INTERVAL 1 DAY)) to no avail, any suggestions?

Thanks again

[lowndsy]

Christopher: I'm afraid I can't replicate that - can you try with the latest code from the zip file?
newcode.php is the file which controls this and it has had a bit of work done on it recently.


Richard: yeah - it has been noticed. I'm looking for an acceptable fix to it, but to be honest I won't be deploying the fix on my own system - I have noticed that not all merchants agree on whether the voucher code expires at the end or start of the day they define, and since I'm trying to keep my own data uber clean and accurate I'd rather present it as expired rather than have users make a decision to buy from a particular merchant based on codes which might not work. It's not ideal, but that's what I'm doing at the moment.
I'll publish the fix and let people decide which one to use - perhaps by flicking a switch in the config file.


Everyone: As ever, I have tidied the functions file up again - it is looking much neater now and tightens up a lot of the sql statements. If you are already using the thumbnail version you can just drop the new functions file into your sites without breaking anything. It should work in previous versions too (no promises), but I urge you to update to the latest one - lots of minor things have been smartened up, especially in the admin.

[ash]

Dragging up an slightly old thread but whats happened to the wiki? Did it get hacked?