Reward Points Module for ZC v13x

[hem]

I think there is a problem with the update.sql in 1.21beta. You first line is

CREATE TABLE `reward_master`

. I am not sure why we are creating a table that already exists.

This is the only database changes in the upgrade:

REPLACE INTO `configuration` 
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Limit maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);

Can you please provide instruction how to update the database with the above changes?

Thanks!

The CREATE TABLE is there for completeness. Also if you upgrade from a version prior to v1.03a then it's a requirement. Unfortunately MySQL does not have a IF TABLE NOT EXIST directive. Don't worry about it, it will fail gracefully.

To just apply the single change for this version copy and paste the following into Admin->Tools->SQL Patch. Note: This applies for this release only.

SET @group_id = '';
SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';

REPLACE INTO `configuration` 
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Limit maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);