'; //added to make the output more convenient when viewing the email not as text email but html
		$invoice .= $lang_photoshop_email_attach_header; //in the lang file we could define a header for the invoice
		$invoice .= photoshop_create_table($shop_array_photos, 'photo', 'text');
		$invoice .= photoshop_create_table($shop_array_cd, 'cd', 'text');
		$invoice .= photoshop_format_price($cd_price, $cd_counter, '', 'text');
		$invoice .= '

{$lang_photoshop['wire']}

{$lang_photoshop['bank']}	{$CONFIG['photo_shop_wire_bank']}
	{$CONFIG['photo_shop_wire_bank_address']}
{$lang_photoshop['routing']}	{$CONFIG['photo_shop_wire_routing']}
{$lang_photoshop['account']}	{$CONFIG['photo_shop_wire_account']}
{$lang_photoshop['swift']}	{$CONFIG['photo_shop_wire_swift']}

EOT; } //pay with paypal if ($CONFIG['photo_shop_paypal_enable'] && $order_price > 0) { $handling = $shipping_price-$discount; $paypal_items = ""; $cd_price_set = false; $counter = 0; foreach ($shop_array as $key => $item_id) { if ($SHOP_CONFIG[$item_id['id']]['price'] > 0 || $item_id['id']=="CD") { // if it's not a free item $pid = $item_id['pid']; $amount = $item_id['amount']; $counter++; if ($item_id['id']=="CD") { $size = "CD"; //$price = $cd_price[1]; if ($cd_price_set === false) { photoshop_add_field($form_fields, 'item_name_'.$counter, $cd_price[4]); photoshop_add_field($form_fields, 'amount_'.$counter, $cd_price[1]); photoshop_add_field($form_fields, 'quantity_'.$counter, $amount); } $cd_price_set = true; } else { $size = $SHOP_CONFIG[$item_id['id']]['name']; $price = $SHOP_CONFIG[$item_id['id']]['price']; //price override $results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP_PRICES']} WHERE aid={$item_id['aid']}"); while ($temp_data = mysql_fetch_array($results)) { if($temp_data['gid']==$SHOP_CONFIG[$item_id['id']]['id']) $price=$temp_data['price']; } //end while mysql_free_result($results); //to grab the image title from the db $query = cpg_db_query("SELECT title FROM {$CONFIG['TABLE_PICTURES']} WHERE pid={$item_id['pid']}"); $row = mysql_fetch_row($query); ($row[0]) ? $title= $row[0] : $title="No title"; mysql_free_result($row); $picture_total = ($picture_total+$price*$amount); photoshop_add_field($form_fields, 'item_name_'.$counter, "{$cd_price[4]} => Title: {$title} - ID: {$pid}"); photoshop_add_field($form_fields, 'amount_'.$counter, $price); photoshop_add_field($form_fields, 'quantity_'.$counter, $amount); }// end else }//end if amount >0 else //it's a free item { //code here } } // end foreach if ($CONFIG['photo_shop_paypal_use_ipn'] == '1') { photoshop_add_field($form_fields, 'notify_url', $CONFIG['photo_shop_paypal_ssl_adress'].$CONFIG['photo_shop_paypal_ipn_notify_url']); photoshop_add_field($form_fields, 'rm', '2'); if ($CONFIG['photo_shop_paypal_return_url'] != '') { photoshop_add_field($form_fields, 'return', $CONFIG['photo_shop_paypal_ssl_adress'].$CONFIG['photo_shop_paypal_return_url']); } if ($CONFIG['photo_shop_paypal_cancel_return_url'] != '') { photoshop_add_field($form_fields, 'cancel_return', $CONFIG['photo_shop_paypal_ssl_adress'].$CONFIG['photo_shop_paypal_cancel_return_url']); } else $paypal_cancel_return_url = ''; } if ($CONFIG['photo_shop_tax'] != '') { photoshop_add_field($form_fields, 'tax_cart', $CONFIG['photo_shop_tax']*$picture_total); } photoshop_add_field($form_fields, 'cmd', '_cart'); photoshop_add_field($form_fields, 'upload', '1'); photoshop_add_field($form_fields, 'invoice', $order_id); photoshop_add_field($form_fields, 'business', $CONFIG['photo_shop_paypal_email']); photoshop_add_field($form_fields, 'currency_code', $CONFIG['photo_shop_paypal_currency']); photoshop_add_field($form_fields, 'handling_cart', $handling); foreach ($form_fields as $name => $value) { $paypal_items .= "\n"; } $msg_box_txt .= <<
{$lang_photoshop['paypal']}

{$paypal_items}

EOT; } if ($CONFIG['photo_shop_google_enable'] && $order_price > 0) { $msg_box_txt .= <<
{$lang_photoshop['google']}

EOT; } $msg_box_txt .= '


'; //if there's a free item in the basket and downloads enabled if ($free_item === true){ //there's a free item in the cart //if ($order_price == 0){ //mark items of the current order paid /* $result2 = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP']} WHERE oid=".$order_id.";"); while($i=mysql_fetch_array($result2)) { $id = $i['id']; $status = $i['status'] | 2; cpg_db_query("UPDATE {$CONFIG['TABLE_SHOP']} SET status=$status WHERE id ='".$i['id']."';"); } mysql_free_result($result2); */ if ($CONFIG['photo_shop_download_enable']=='1') { //first check if we have items to download, if yes, create down dir, send passwords etc if (photo_shop_ipn_download_check(USER_ID, $order_id)) { $CONFIG['photo_shop_download_passwd_mail']=='1' ? $send_admin_mail = true : $send_admin_mail = false; //create download folder, htaccess, htpasswd, resize images and copy them to download folder if(photo_shop_ipn_download(USER_ID, $order_id, $send_admin_mail, true)) { //success, email admin cpg_mail('admin', $lang_photoshop_ipn['ipn_email_admin_ipn_download_success']." [$date]", nl2br(make_clickable($error. $body)), 'text/plain', $CONFIG['gallery_name'], $CONFIG['gallery_admin_email'], $body); } else { cpg_mail('admin', $lang_photoshop_ipn['ipn_email_admin_ipn_download_problem']." [$date]", nl2br(make_clickable($error. $body)), 'text/plain', $CONFIG['gallery_name'], $CONFIG['gallery_admin_email'], $body); } } } } msg_box('', $msg_box_txt, $lang_continue, $CONFIG['ecards_more_pic_target'].'index.php'); //comment out if you don't want the orders to appeare on the order confirmed page starttable('100%', $lang_photoshop['myorders'], 1); echo photoshop_create_table($shop_array_photos, 'photo', 'html'); echo photoshop_create_table($shop_array_cd, 'cd', 'html'); echo photoshop_format_price($cd_price, $cd_counter, '', 'html'); endtable(); //now we just need to clear the cookie/ session and done setcookie($CONFIG['cookie_name'] . '_cart', '', time() + 86400 * 30, $CONFIG['cookie_path']); unset ($_SESSION['photoshop']['cart']); } pagefooter(); ob_end_flush(); exit; // we're done here } else { //something went wrong } } else { //show the cart contents and price, submit button echo "

"; photoshop_prep_data($shop_array_cd, $shop_array_photos); echo photoshop_create_table($shop_array_photos, 'photo', 'html'); echo photoshop_create_table($shop_array_cd, 'cd', 'html'); echo photoshop_format_price($cd_price, $cd_counter, '', 'html'); echo << EOT; } endtable(); echo ""; //printing a pricelist photoshop_pricelist(); pagefooter(); ob_end_flush(); //functioons function photoshop_prep_data(&$shop_array_cd, &$shop_array_photos){ $shop_array_photos = array(); //temp array for easier use $shop_array_cd = array(); //temp array for easier use foreach ($_SESSION['photoshop']['cart'] as $key => $item_id) { if ($item_id['id'] == 'CD') { $shop_array_cd[] = $_SESSION['photoshop']['cart'][$key]; } else { $shop_array_photos[] = $_SESSION['photoshop']['cart'][$key]; } } } function photoshop_create_table($shop_array_photos, $type, $template){ //we create two basic templates html and text global $SHOP_CONFIG, $CONFIG, $lang_photoshop, $cd_price; $out = array(); $out['html'] = ''; $out['text'] = sprintf("%s\n\n", ''); if ($type == 'photo') { $out['html'].= << EOT; $out['text'].= sprintf("%10.10s\t", $lang_photoshop['item_id_checkout']). sprintf("%30.30s\t", $lang_photoshop['item_name_checkout']). sprintf("%15.15s\t",$lang_photoshop['type_chckout']). sprintf("%10.10s\t",$lang_photoshop['amount_checkout']). sprintf("%15.15s\n",$lang_photoshop['total_checkout']); } elseif(($type == 'cd') && (photoshop_in_array_multi("CD", $shop_array_photos))) { $out['html'].= << EOT; $out['text'].= sprintf("%10.10s\t", $lang_photoshop['item_id_checkout']).sprintf("%15.15s\n",$lang_photoshop['type_chckout']); } foreach ($shop_array_photos as $key => $item_id) { $select_columns = 'filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, title, aid'; $result = cpg_db_query("SELECT $select_columns from {$CONFIG['TABLE_PICTURES']} WHERE pid='{$item_id['pid']}' LIMIT 1"); $row = mysql_fetch_array($result); $price = $SHOP_CONFIG[$item_id['id']]['price']; //price override $results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP_PRICES']} WHERE aid={$row['aid']}"); while ($temp_data = mysql_fetch_array($results)) { if($temp_data['gid']==$SHOP_CONFIG[$item_id['id']]['id']) $price=$temp_data['price']; } mysql_free_result($results); //here we check if the price is set to -1 (that's a free item, and we set price for display reasons back to 0.00) //do the same in cart and calc total an in function item_price, pricelist, photoshop_add_data if ($price < 0) { $price = "0.00"; } //html resize thumb if ($CONFIG['enable_mini_thumbs'] == '1') { // if you use the modpack and have enabled mini thumbs -> these get used instead of html resized thumbs $thumb_url = get_pic_url($row, 'mini'); $destWidth = $CONFIG['mini_thumb_width']; $destHeight = $CONFIG['mini_thumb_height']; } else { $thumb_url = get_pic_url($row, 'thumb'); $new_size = 60; $ratio = max($row['pwidth'], $row['pheight']) / $new_size; $ratio = max($ratio, 1.0); $destWidth = (int)($row['pwidth'] / $ratio); $destHeight = (int)($row['pheight'] / $ratio); } if ($item_id['id'] == 'CD') { $out['html'].= << EOT; $out['text'].= sprintf("%10.10s\t", $item_id['pid']).sprintf("%15.15s\n",$item_id['id']); } else { $price = number_format($price*$item_id['amount'],2); $out['html'].= << EOT; $out['text'].= sprintf("%10.10s\t", $item_id['pid']). sprintf("%30.30s\t",$row['filename']). sprintf("%15.15s\t", $SHOP_CONFIG[$item_id['id']]['name']). sprintf("%10.10s\t", $item_id['amount']). sprintf("%15.15s\n",$CONFIG['photo_shop_currency'].' '.$price); } } $out['html'] .= "

{$lang_photoshop['item_id_checkout']}	{$lang_photoshop['type_chckout']}	{$lang_photoshop['amount_checkout']}	{$lang_photoshop['total_checkout']}
{$lang_photoshop['item_id_checkout']}	{$lang_photoshop['type_chckout']}
	{$item_id['id']} text
	{$SHOP_CONFIG[$item_id['id']]['name']}	{$item_id['amount']}	{$price} {$CONFIG['photo_shop_currency']}

"; return $out[$template]; } function photoshop_add_data($shop_data, $order_id, &$free_item){ global $CONFIG, $SHOP_CONFIG, $cd_price, $cd_counter, $discount_calc, $shipping_price_calc; $otime = localised_timestamp(); $picture_total = 0; foreach ($shop_data as $key => $item_id) { $pid = $item_id['pid']; $amount = $item_id['amount']; $size2 = $SHOP_CONFIG[$item_id['id']]['size']; if ($item_id['id']=="CD") { $size = "CD"; $price = $cd_price[1]; $free_order = false; // this is not a free order // without paid status $sql = "INSERT INTO `{$CONFIG['TABLE_SHOP']}` (`oid`, `uid`, `pid`, `quantity`, `size`, `size2`, `price`, `otime`) VALUES ('$order_id', '".USER_ID."', '$pid', '$amount', '$size', '$size2','$price', '$otime')"; } else { $size = $SHOP_CONFIG[$item_id['id']]['name']; $price = $SHOP_CONFIG[$item_id['id']]['price']; //price override $results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP_PRICES']} WHERE aid={$item_id['aid']}"); while ($temp_data = mysql_fetch_array($results)) { if($temp_data['gid']==$SHOP_CONFIG[$item_id['id']]['id']) $price=$temp_data['price']; } mysql_free_result($results); //here we check if the price is set to -1 (that's a free item, and we set price for display reasons back to 0.00) //do the same in cart and calc total an in function item_price, pricelist, photoshop_add_data if ($price == -1) { $price = "0.00"; if(!isset($free_order)) $free_order = true; //this is a free order, only set if there hasn't been a paid item before $free_item = true; // always set // add status paid to sql $sql = "INSERT INTO `{$CONFIG['TABLE_SHOP']}` (`oid`, `uid`, `pid`, `quantity`, `size`, `size2`, `price`, `otime`, `status`) VALUES ('$order_id', '".USER_ID."', '$pid', '$amount', '$size', '$size2','$price', '$otime', '2')"; } else { // without status set to paod -> no free item $sql = "INSERT INTO `{$CONFIG['TABLE_SHOP']}` (`oid`, `uid`, `pid`, `quantity`, `size`, `size2`, `price`, `otime`) VALUES ('$order_id', '".USER_ID."', '$pid', '$amount', '$size', '$size2','$price', '$otime')"; $free_order = false; //this is not a free order } $picture_total = ($picture_total+$price*$amount); } //add single item $results = cpg_db_query ($sql); } //add order total if ($free_order === true) { //this is a free order, the total order is set paid $sql2 = "INSERT INTO `{$CONFIG['TABLE_SHOP']}` (`oid`, `uid`, `cd`, `quantity`, `price`, `otime`, `status`) VALUES ('$order_id', '".USER_ID."', '1', '".($cd_counter['cd']+$cd_counter['photo'])."', '".($picture_total+$cd_price[1]+$shipping_price_calc-$discount_calc)."', '$otime', '2')"; } else //this is a paid order, status unpaid { $sql2 = "INSERT INTO `{$CONFIG['TABLE_SHOP']}` (`oid`, `uid`, `cd`, `quantity`, `price`, `otime`) VALUES ('$order_id', '".USER_ID."', '1', '".($cd_counter['cd']+$cd_counter['photo'])."', '".($picture_total+$cd_price[1]+$shipping_price_calc-$discount_calc)."', '$otime')"; } $results2 = cpg_db_query ($sql2); return $results2; } function photoshop_email_the_user($message, $subject, $admin = '') { global $CONFIG, $SHOP_CONFIG, $lang_photoshop, $cd_price, $order_id, $discount, $shipping_price; $user_info = photoshop_user_details(USER_ID); $email = $user_info['user_email']; if ($admin) { $user_info['user_email']='admin'; } $template_vars = array( '{ORDER_ID}' => $order_id, '{SITE_NAME}' => $CONFIG['gallery_name'], '{PRICE}' => number_format(($cd_price[0]+$cd_price[1]+$shipping_price-$discount),2), '{USER_NAME}' => (USER_NAME), '{USER_EMAIL}' => $email, '{ADMIN}' => $CONFIG['gallery_name'], '{LINK}' => $CONFIG['ecards_more_pic_target'], '{USER_PROFILE1}' => $user_info['user_profile1'], '{USER_PROFILE2}' => $user_info['user_profile2'], '{USER_PROFILE3}' => $user_info['user_profile3'], '{USER_PROFILE4}' => $user_info['user_profile4'], '{USER_PROFILE5}' => $user_info['user_profile5'], '{USER_PROFILE6}' => $user_info['user_profile6'], ); $mail_body=nl2br(strtr($message, $template_vars)); if(cpg_mail($user_info['user_email'], $subject, $mail_body, 'text/plain', $CONFIG['gallery_name'], $CONFIG['gallery_admin_email'] )) { return true; } return false; } function photoshop_add_field(&$form_fields, $field, $value) { $form_fields["$field"] = $value; } ?>