Ok lets start from scratch. Friday 11pm I downloaded from
http://www.zen-cart.com/downloads.php?do=file&id=704
The folder called reward_point_full_suite_2.1b
I renamed the admin folders in the following directory
reward_point_full_suite_2.1b/reward_point_full_suite_2.1b/zen_1.5.0/new_installation
I then used filezilla to upload them to my site 3/28/14 at 11:45pm. And have already posted the rest of that adventure at 3/29/14 12:05am.
Now I just finished using cpanel to check every one of those files to make sure they made it to my site. Each one is there and was last modified 3/28/14 at 11:45pm. So I am good there.
So let me follow Diva Vocals post line by line.
1) if you followed the steps in this post. Done now and verified.(I had done this but overwritten it with my ftp upload) ☹
2) By my own admission this file does not exist. That was at 4:45 pm. My last post at 12:05 am explained that the upgrade folder for v1.5.0 doesn’t have that folder and that was an initial error.. I did not explain that at 5pm I had found the “missing folder” uploaded it and made the changes in step one before giving up. My mistake as you surely wouldn’t know this you just thought I didn’t do it still. But my 11:45 upload overwrote it. It’s fixed now.
3) Same link. I just verified that the changes were there just to be sure. ☺ I searched for the whole addition as one big piece and have 1 match. So we are good there.
4) I don't have anything here: \admin\includes\functions\extra_functions\reward_points_functions.php. Again going back before the complete reinstall that happened before giving up at 5 and then reuploading everything at 11:45
Here is a pic of cpanel showing the file in
this post
Attachment 13927
Just to make sure I place the code from "this post" In the right spot I am including the code just before and formatting the beginning of the added code in red.
Code:
/*
function SetRewardPointDiscountTypeFunction($value,$key='')
{
require('includes/javascript/reward_points.js');
$content='<br />';
$content.='<strong>'.TEXT_NEW_ACCOUNT_AWARD_PROMPT.'</strong> '.zen_draw_checkbox_field('allow_award','',$value!=0,0,'onchange="UpdateAward()"');
$content.=zen_draw_input_field('award_points',($value==0?'':abs($value)),'onchange="UpdateAward()"').' '.zen_draw_pull_down_menu('award_id',array(array('id'=>'0','text'=>TEXT_NEW_ACCOUNT_PENDING_AWARD),array('id'=>'1','text'=>TEXT_NEW_ACCOUNT_EARNED_AWARD)),($value<0?'0':$value>0?'1':''),'onchange="UpdateAward()"').'<br />';
$content.=zen_draw_hidden_field('configuration_value',$value);
return $content;
}
function GetRewardPoints($products)
{
$reward_points=0;
if(REWARD_POINT_MODE=='0')
{
foreach($products as $product)
if(isset($product['qty']))
$reward_points+=GetProductRewardPoints($product['id'],$product['attributes'])*$product['qty'];
else
if(isset($product['quantity']))
$reward_points+=GetProductRewardPoints($product['id'],$product['attributes'])*$product['quantity'];
else
if(isset($product['quantityField']))
$reward_points+=GetProductRewardPoints($product['id'],$product['attributes'])*$product['quantityField'];
else
$reward_points="RP Error";
}
blah blah blah here is the end of the file to make sure I didn't screw up the ending.
//print_r($GLOBALS[$module]->output);
//$output_backup=$GLOBALS[$module]->output;
//$order_info_backup=$order->info;
//if(sizeof($GLOBALS[$module]->output)==0)
//$GLOBALS[$module]->process();
for($loop=0;$loop<sizeof($GLOBALS[$module]->output);$loop++)
if(zen_not_null($GLOBALS[$module]->output[$loop]['value']))
$value+=$GLOBALS[$module]->output[$loop]['value'];
//$GLOBALS[$module]->output=$output_backup;
//$order->info=$order_info_backup;
}
return $value;
}
*/
?>
So with all of this done.
If it has been done right.
I go into reward points admin. Transfer 35 points from pending to earned.
I generate this log:
[29-Mar-2014 12:33:00] PHP Fatal 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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1 :: SELECT rewards_id, orders_id, date, reward_points, status FROM zen_reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12; in /home4/w57dsjmm/public_html/order/includes/classes/db/mysql/query_factory.php on line 120
Now I know I'm not the most computer literate person. But I downloaded a fresh version yesterday. So if my copy was bad I had the newest version available. I have confirmed files located in the correct spot. Made and confirmed the change to the function file. Yet I'm still getting this error. If someone is willing to look at my actual files and confirm I'm not crazy please let me know. I know you all are frustrated and I am as well.
Thank you for all your help Diva Vocals. I didn't mind the caps or bold text or anything else you throw my way if it fixes the problem! I'm a big boy and can take a few capitalized words. :)
