I want to change some text on the tpl_checkout_success_default.php page

[boinkit]

I need to add some code to the tpl_checkout_success_default.php page. Where can I find this page, and where should I save it to (i.e. should it be under my override directory somewhere) ?

[fairestcape]

The original core file is in:

includes/templates/template_default/templates/

FTP a copy to your hard drive - edit this copy.

When the edit is done, ftp to:-

includes/templates/YOUR_TEMPLATE/templates/

(You may need to create the last "templates" folder if your over-ride (YOUR_TEMPLATE) does not have one.)

[boinkit]

Thanks for your reply. I have finally had a go at what you said, but while the checkout success page displays in HTML it has the following error at the very bottom of the page:
1146 Table 'boinkit_mndb.zen_orders_total' doesn't exist
in:
[select value FROM zen_orders_total WHERE class='ot_subtotal' AND orders_id = 1024]

And if I view the source code for that page, there appears to be no mention of the tracking code that I put into it.
As soon as I remove the tracking code again, the error message disappears again.

Can you give any thoughts as to why this is happening?

[boinkit]

It may help if I show you the code (and install instructions) I am trying to add:

Open the page tpl_checkout_success_default.php

Look for this line:

<tr>
<td align="center"><h3><?php echo TEXT_THANKS_FOR_SHOPPING; ?></h3></td>
</tr>

Add after it:

<?php

$gv_query1= "select value FROM zen_orders_total WHERE class='ot_subtotal' AND orders_id = " . (int)$orders->fields['orders_id'] ;

$gv_result1 = $db->Execute($gv_query1);

if (!$gv_result1->EOF) {

if ($gv_result1->fields['value'] > 0) {

?>

<img src="https://www.clixGalore.com/AdvTransaction.aspx?AdID=8580&SV=<?php echo $gv_result1->fields['value']; ?>&OID=<?php echo (int)$orders->fields['orders_id']; ?>" height="0" width="0" border="0">

<?php
}
}
?>

[boinkit]

Doh!
I have figured out the problem. The code I was trying to use assumed I was using the 'zen_' prefix for my database, which I am not. So I have removed that and now the tracking code works fine!
Thank you for your help though.

[FedGovt_Slacker]

Thanks boinkit, you are a savior!!!

I had the exact same clixgalore code problem that you had over the weekend, but could not figure out the prob.

You saved me before my head caved in with frustration (coding is not my strong point).

Your post is the only one I came across regarding this problem on the whole of google and these forums (that I can see).

No doubt other people will find this post useful also.

Hopefully Google will pick up the following keywords, so other people will find this post when searching.

Cheers mate.

clixgalore+code+zen cart+tpl_checkout_success