The new contribution you posted Nov. 26, 2005 POINTS AND REWARDS MODULE V1.00 at http://www.oscommerce.com/community/contributions,3220 is excellent. Your instructions were easy to follow and everything is working great.
There is only one place I found the need for a change aside from regular customizations.
I got this error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customers_id = 2' at line 1
update customers set customers_shopping_points = customers_shopping_points + 1where customers_id = 2
So I updated line 38 of catalog/admin/customers_points_pending.php and added a space between $customer_points['points_pending'] . ' and the word 'where' in the query.
That was it, the rest was just right.
Thanks for sharing all your hard work and for taking the time to write thorough helpful instructions.