adding an extra insert

[kireol]

I am creating a website.

I'm using Zen-cart to allow users to pay for a membership to the site with paypal. (no, it's not ######## actually! hahaha)


I have everything all set up with the exception of 1 thing.

My website has it's own SQL tables.
On a successful purchase "/index.php?main_page=checkout_success" I would like insert into my own table that the customer paid. I'm passing the "user id" from my own code, to zen-cart already, and storing that in a session variable.

I just need to know where zencarts code is where the code resides for a "checkout_success" where it inserts into the *cart_orders table.

I could then add my own code to do a SQL update on my own table that they did in fact pay, and I'd be all done.

thanks!

[kireol]

For those in the future that want to do this, I figured out a way to do this.

well, I'm not sure if it was the "correct" way or not, but I just used the define pages editor(under tools in the zen-cart admin menu) and went to "define_checkout_success" and added

<?php

$lmasql = "my custom sql here";
//echo $lmasql;
$db->Execute($lmasql);
?>

and it worked.