if($sessionid != null) {
						$purchase_log_data_city = $wpdb->get_var( "SELECT wp_wpsc_submited_form_data.value FROM wp_wpsc_submited_form_data LEFT JOIN wp_wpsc_checkout_forms ON wp_wpsc_checkout_forms.id = wp_wpsc_submited_form_data.form_id WHERE wp_wpsc_checkout_forms.type = 'city' AND log_id = '".$purchase_log['id']."'" );
						/* $purchase_log_data_state = $wpdb->get_var( "SELECT value FROM wp_wpsc_submited_form_data WHERE form_id = '10' AND log_id = '".$purchase_log['id']."'" ); */
						$purchase_log_data_country = $wpdb->get_var( "SELECT wp_wpsc_submited_form_data.value FROM wp_wpsc_submited_form_data LEFT JOIN wp_wpsc_checkout_forms ON wp_wpsc_checkout_forms.id = wp_wpsc_submited_form_data.form_id WHERE wp_wpsc_checkout_forms.type = 'country' AND log_id = '".$purchase_log['id']."'" );
?>
<script type="text/javascript">
	var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
	document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
	try {
		var pageTracker = _gat._getTracker("UA-########-#");
		pageTracker._trackPageview();
		pageTracker._addTrans(
			"<?php echo $purchase_log['id']; ?>",
			"<?php echo get_bloginfo('name'); ?>",
			"<?php echo nzshpcrt_currency_display($total,1,true,false,true); ?>",
			"0.00",
			"<?php echo nzshpcrt_currency_display($total_shipping,1,true,false,true); ?>",
			"<?php echo $purchase_log_data_city; ?>",
			"<?php /* echo $purchase_log_data_state; */ ?>",
			"<?php echo $purchase_log_data_country; ?>"
		);
<?php
						$purchase_log_data_items_sql = "SELECT * FROM wp_wpsc_cart_contents WHERE purchaseid = ".$purchase_log['id'];
						$purchase_log_data_items = $wpdb->get_results( $wpdb->prepare( $purchase_log_data_items_sql ) );
						foreach( $purchase_log_data_items as $purchase_log_data_item ) {
							$purchase_log_data_item_sku_sql = "SELECT meta_value FROM wp_wpsc_productmeta WHERE meta_key = 'sku' AND product_id = '".$purchase_log_data_item->prodid."' LIMIT 1";
							$purchase_log_data_item->sku = $wpdb->get_var( $purchase_log_data_item_sku_sql );
							$purchase_log_data_item_category_sql = "SELECT wp_wpsc_product_categories.name FROM wp_wpsc_product_categories LEFT JOIN wp_wpsc_item_category_assoc ON wp_wpsc_product_categories.id = wp_wpsc_item_category_assoc.category_id WHERE wp_wpsc_product_categories.group_id = '1' AND wp_wpsc_item_category_assoc.product_id = '".$purchase_log_data_item->prodid."'";
							$purchase_log_data_item->category = $wpdb->get_var( $purchase_log_data_item_category_sql );
?>
	pageTracker._addItem(
		"<?php echo $purchase_log['id']; ?>",
		"<?php echo $purchase_log_data_item->sku; ?>",
		"<?php echo $purchase_log_data_item->name; ?>",
		"<?php echo $purchase_log_data_item->category; ?>",
		"<?php echo $purchase_log_data_item->price; ?>",
		"<?php echo $purchase_log_data_item->quantity; ?>"
	);
<?php
						}
?>
	  pageTracker._trackTrans();
	} catch(err) {}</script>
</script>
<?php
						echo TXT_WPSC_THETRANSACTIONWASSUCCESSFUL."<br />";