Stripe.com payment integration module

Quote:

---

Originally Posted by OJ_SIMON

Code:

---

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

---

PHP Code:

---

$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.

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

Quote:

---

Originally Posted by OJ_SIMON

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.

Quote:

---

Originally Posted by retched

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?

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

Quote:

---

Originally Posted by retched

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

Code:

---

    $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

PHP Code:

---

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


---

should be like

PHP Code:

---

    $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; 


---

Quote:

---

Originally Posted by OJ_SIMON

Code:

---

    $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

PHP Code:

---

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


---

should be like

PHP Code:

---

    $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.

Quote:

---

Originally Posted by retched

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

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.:smile: