Stripe.com payment integration module

[retched]

define('TABLE_STRIPE', DB_PREFIX . 'stripe');

$db-> execute("CREATE TABLE " . TABLE_STRIPE  . "(id INT(11) AUTO_INCREMENT PRIMARY KEY,customers_id INT(11),Stripe_Customers_id VARCHAR(32))"); 

the above is how it should be done then anyone can use it without having to change code.

Noted. I forgot that the TABLE_ constants are always accessible. Submitting now.

[OJ_SIMON]

can i ask what this upgrade version is fixing or dealing with?

[retched]

can i ask what this upgrade version is fixing or dealing with?

Just a bugfix for configurations that are using table prefixes.

The native code makes a call to a database table named `TABLE_STRIPE` but on the modules installation, it only makes a table named 'stripe' and ignores the prefix configuration. If this module is already working, you don't need to change anything (this means your ZenCart tables do not have prefixes and works fine with the table named just stripe). However, if someone just snags the module from the plugins directory and they do have table prefixes configured, they'll run into errors as the table is wrongly named and referred to incorrectly in the database define.

[OJ_SIMON]

Just a bugfix for configurations that are using table prefixes.

The native code makes a call to a database table named `TABLE_STRIPE` but on the modules installation, it only makes a table named 'stripe' and ignores the prefix configuration. If this module is already working, you don't need to change anything (this means your ZenCart tables do not have prefixes and works fine with the table named just stripe). However, if someone just snags the module from the plugins directory and they do have table prefixes configured, they'll run into errors as the table is wrongly named and referred to incorrectly in the database define.

Seem needed.

can i also ask if you have or could check if the amount sent to Stripe is the correct amount when using the following:
1. a coupon,
2. a product that has a offer price,

I only ask this because in my installation the only amount sent to stripe is the total before any discount is applied?

[retched]

I can check on the first in a few but can you explain the second? What do you mean by "offer price"?

[OJ_SIMON]

I can check on the first in a few but can you explain the second? What do you mean by "offer price"?

a offer made via SaleMaker in admin

[OJ_SIMON]

    $i = count($order_totals);
    $i -= 1;
    
 echo $order_totals[$i]['value'];

gets the full total amount to send to Stripe but I can only get it to work on index.php?main_page=checkout_confirmation page and need to get this to
includes/modules/payment/stripe.php

line 146

$amount_total=round($order->info['total']*$order->info['currency_value'],$decimal_places)*$multiplied_by; 

should be like

    $i = count($order_totals);    $i -= 1;
$order_value = $order_totals[$i]['value'];
        $amount_total = round($order_value * $order->info['currency_value'], $decimal_places) * $multiplied_by; 

[retched]

    $i = count($order_totals);
    $i -= 1;
    
 echo $order_totals[$i]['value'];

gets the full total amount to send to Stripe but I can only get it to work on index.php?main_page=checkout_confirmation page and need to get this to
includes/modules/payment/stripe.php

line 146

$amount_total=round($order->info['total']*$order->info['currency_value'],$decimal_places)*$multiplied_by; 

should be like

    $i = count($order_totals);    $i -= 1;
$order_value = $order_totals[$i]['value'];
        $amount_total = round($order_value * $order->info['currency_value'], $decimal_places) * $multiplied_by; 

I'll look into both of these but no promises as I have a bit of work ahead of me.

[OJ_SIMON]

I'll look into both of these but no promises as I have a bit of work ahead of me.

could I hire you (paid service) to help me make a new plugin from scratch for stripe

[Gozzandes]

Sorry for making you wait.
The previous module had a problem. Stripe ID generated twice for a single order, but I resolved it today and uploaded a new module. Please wait until it is published.