Jump to content

blackerutuf

New Members
 View Profile  See their activity

  • Posts

    6

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

blackerutuf's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. blackerutuf
    Thanks everyone Iwill give it a go
  2. blackerutuf
    Can anyone help me to include graphics in my php emails, currently I can only submit text, I would also like to be able to choose a text rather than just Time New Roman. The current script is: $headers = "MIME-Version: 1.0\n";                                 $headers .= "Content-type: text/html; charset=iso-8859-1\n"; $headers .= "Content-Transfer-Encoding: 8bit\n"; $headers .= "From: $from\n"; $headers .= "X-Priority: 1\n"; $headers .= "X-MSMail-Priority: High\n"; $headers .= "X-Mailer: PHP/" . phpversion()."\n"; mail($to, $subject, $message, $headers); Thanks in advance to anyone who can help
  3. blackerutuf
    Hello Oio Yes, I hope it is not too long: [code]     <table border="0" width="100%" cellspacing="0" cellpadding="<?php echo CELLPADDING_SUB; ?>"> <?php // BOF: Lango Added for template MOD if (SHOW_HEADING_TITLE_ORIGINAL == 'yes') { $header_text = '&nbsp;' //EOF: Lango Added for template MOD ?>       <tr>         <td><table border="0" width="100%" cellspacing="0" cellpadding="0">           <tr>             <td class="pageHeading"><?php echo HEADING_TITLE_2; ?></td>             <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_browse.gif', HEADING_TITLE_2, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>           </tr>         </table></td>       </tr>       <tr>         <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>       </tr> <?php }else{ $header_text = HEADING_TITLE_2; } ?> <?php // BOF: Lango Added for template MOD if (MAIN_TABLE_BORDER == 'yes'){ table_image_border_top(false, false, $header_text); } // EOF: Lango Added for template MOD ?>       <tr>         <td> <?php // create column list   $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,                       'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,                       'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,                       'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,                       'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,                       'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,                       'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,                       'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);   asort($define_list);   $column_list = array();   reset($define_list);   while (list($key, $value) = each($define_list)) {     if ($value > 0) $column_list[] = $key;   } // Eversun mod for sppp   if(!tep_session_is_registered('sppc_customer_group_id')) {     $customer_group_id = '0';   } else {     $customer_group_id = $sppc_customer_group_id;   } // Eversun mod end for sppp   $select_column_list = '';   for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {     switch ($column_list[$i]) {       case 'PRODUCT_LIST_MODEL':         $select_column_list .= 'p.products_model, ';         break;       case 'PRODUCT_LIST_MANUFACTURER':         $select_column_list .= 'm.manufacturers_name, ';         break;       case 'PRODUCT_LIST_QUANTITY':         $select_column_list .= 'p.products_quantity, ';         break;       case 'PRODUCT_LIST_IMAGE':         $select_column_list .= 'p.products_image, ';         break;       case 'PRODUCT_LIST_WEIGHT':         $select_column_list .= 'p.products_weight, ';         break;     }   } // Eversun mod for sppp /*   $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price ";   if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {     $select_str .= ", SUM(tr.tax_rate) as tax_rate ";   }   $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";  */   $status_tmp_product_prices_table = false;   $status_need_to_get_prices = false;   // find out if sorting by price has been requested   if ( (isset($HTTP_GET_VARS['sort'])) && (ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) && (substr($HTTP_GET_VARS['sort'], 0, 1) <= sizeof($column_list)) ){     $_sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);     if ($column_list[$_sort_col-1] == 'PRODUCT_LIST_PRICE') {       $status_need_to_get_prices = true;       }   }   if ((tep_not_null($pfrom) || tep_not_null($pto) || $status_need_to_get_prices == true) && $customer_group_id != '0') {   $product_prices_table = TABLE_PRODUCTS_GROUP_PRICES.$customer_group_id;   // the table with product prices for a particular customer group is re-built only a number of times per hour   // (setting in /includes/database_tables.php called MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE, in minutes)   // to trigger the update the next function is called (new function that should have been   // added to includes/functions/database.php)   tep_db_check_age_products_group_prices_cg_table($customer_group_id);   $status_tmp_product_prices_table = true;   } elseif ((tep_not_null($pfrom) || tep_not_null($pto) || $status_need_to_get_prices == true) && $customer_group_id == '0') {   // to be able to sort on retail prices we *need* to get the special prices instead of leaving them   // NULL and do product_listing the job of getting the special price   // first make sure that table exists and needs no updating   tep_db_check_age_specials_retail_table();   $status_tmp_special_prices_table = true;   } // end elseif ((tep_not_null($pfrom) || (tep_not_null($pfrom)) && ....   if ($status_tmp_product_prices_table == true) {   $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, tmp_pp.products_price, p.products_tax_class_id, if(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price ";   } elseif ($status_tmp_special_prices_table == true) {   // Eversun mod for SPPP Qty Price Break Enhancement //    $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price "; //$select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price "; $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price "; // Eversun mod end for SPPP Qty Price Break Enhancement       } else {   // Eversun mod  for SPPP Qty Price Break Enhancement     //$select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, NULL as final_price ";   $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_tax_class_id, NULL as specials_new_products_price, NULL as final_price ";   // Eversun mod end for SPPP Qty Price Break Enhancement   }   // next line original select query   // $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price ";   if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {     $select_str .= ", SUM(tr.tax_rate) as tax_rate ";   }       if ($status_tmp_product_prices_table == true) {   $from_str = "from " . TABLE_PRODUCTS . " p               left join " . $product_prices_table . " as tmp_pp using(products_id) ";             } elseif ($status_tmp_special_prices_table == true) {   $from_str = "from " . TABLE_PRODUCTS . " p               left join " . TABLE_SPECIALS_RETAIL_PRICES . " s using(products_id) ";             } else {   $from_str = "from " . TABLE_PRODUCTS . " p               left join " . TABLE_SPECIALS . " s using(products_id) ";       } // Eversun mod end for sppp   if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {     if (!tep_session_is_registered('customer_country_id')) {       $customer_country_id = STORE_COUNTRY;       $customer_zone_id = STORE_ZONE;     }     $from_str .= " left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_TAX_RATES . " tr on p.products_tax_class_id = tr.tax_class_id left join " . TABLE_ZONES_TO_GEO_ZONES . " gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')";   } else {     $from_str .= " left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), ";   }     // modified for mysql 5 support - add tables after the left join tables   $from_str .= " . TABLE_PRODUCTS_DESCRIPTION . " pd,               " . TABLE_CATEGORIES . " c,               " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";     $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id ";   if (isset($HTTP_GET_VARS['categories_id']) && tep_not_null($HTTP_GET_VARS['categories_id'])) {     if (isset($HTTP_GET_VARS['inc_subcat']) && ($HTTP_GET_VARS['inc_subcat'] == '1')) {       $subcategories_array = array();       tep_get_subcategories($subcategories_array, $HTTP_GET_VARS['categories_id']);       $where_str .= " and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '" . (int)$HTTP_GET_VARS['categories_id'] . "'";       for ($i=0, $n=sizeof($subcategories_array); $i<$n; $i++ ) {         $where_str .= " or p2c.categories_id = '" . (int)$subcategories_array[$i] . "'";       }       $where_str .= ")";     } else {       $where_str .= " and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['categories_id'] . "'";     }   }   if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) {     $where_str .= " and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";   }   if (isset($search_keywords) && (sizeof($search_keywords) > 0)) {     $where_str .= " and (";     for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) {       switch ($search_keywords[$i]) {         case '(':         case ')':         case 'and':         case 'or':           $where_str .= " " . $search_keywords[$i] . " ";           break;         default:           $keyword = tep_db_prepare_input($search_keywords[$i]);           $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'";           if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'";           $where_str .= ')';           break;       }     }     $where_str .= " )";   }   if (tep_not_null($dfrom)) {     $where_str .= " and p.products_date_added >= '" . tep_date_raw($dfrom) . "'";   }   if (tep_not_null($dto)) {     $where_str .= " and p.products_date_added <= '" . tep_date_raw($dto) . "'";   }   if (tep_not_null($pfrom)) {     if ($currencies->is_set($currency)) {       $rate = $currencies->get_value($currency);       $pfrom = $pfrom / $rate;     }   }   if (tep_not_null($pto)) {     if (isset($rate)) {       $pto = $pto / $rate;     }   } // Eversun mod for sppp /*   if (DISPLAY_PRICE_WITH_TAX == 'true') {     if ($pfrom > 0) $where_str .= " and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= " . (double)$pfrom . ")";     if ($pto > 0) $where_str .= " and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= " . (double)$pto . ")";   } else {     if ($pfrom > 0) $where_str .= " and (IF(s.status, s.specials_new_products_price, p.products_price) >= " . (double)$pfrom . ")";     if ($pto > 0) $where_str .= " and (IF(s.status, s.specials_new_products_price, p.products_price) <= " . (double)$pto . ")";   }  */   if ($status_tmp_product_prices_table == true) {     if (DISPLAY_PRICE_WITH_TAX == 'true') {       if ($pfrom > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= " . (double)$pfrom . ")";       if ($pto > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= " . (double)$pto . ")";     } else {       if ($pfrom > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) >= " . (double)$pfrom . ")";       if ($pto > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) <= " . (double)$pto . ")";     }   } else { // $status_tmp_product_prices_table is not true: uses p.products_price instead of cg_products_price   // because in the where clause for the case $status_tmp_special_prices is true, the table   // specials_retail_prices is abbreviated with "s" also we can use the same code for "true" and for "false" if (DISPLAY_PRICE_WITH_TAX == 'true') {       if ($pfrom > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= " . (double)$pfrom . ")";       if ($pto > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= " . (double)$pto . ")";     } else {       if ($pfrom > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) >= " . (double)$pfrom . ")";       if ($pto > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) <= " . (double)$pto . ")";     }   } // Eversun mod end for sppp   if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {     $where_str .= " group by p.products_id, tr.tax_priority";   }   if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {     for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {       if ($column_list[$i] == 'PRODUCT_LIST_NAME') {         $HTTP_GET_VARS['sort'] = $i+1 . 'a';         $order_str = ' order by pd.products_name';         break;       }     }   } else {     $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);     $sort_order = substr($HTTP_GET_VARS['sort'], 1);     $order_str = ' order by ';     switch ($column_list[$sort_col-1]) {       case 'PRODUCT_LIST_MODEL':         $order_str .= "p.products_model " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";         break;       case 'PRODUCT_LIST_NAME':         $order_str .= "pd.products_name " . ($sort_order == 'd' ? "desc" : "");         break;       case 'PRODUCT_LIST_MANUFACTURER':         $order_str .= "m.manufacturers_name " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";         break;       case 'PRODUCT_LIST_QUANTITY':         $order_str .= "p.products_quantity " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";         break;       case 'PRODUCT_LIST_IMAGE':         $order_str .= "pd.products_name";         break;       case 'PRODUCT_LIST_WEIGHT':         $order_str .= "p.products_weight " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";         break;       case 'PRODUCT_LIST_PRICE':         $order_str .= "final_price " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";         break;     }   }   $listing_sql = $select_str . $from_str . $where_str . $order_str;   require(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?>         </td>       </tr> <?php // BOF: Lango Added for template MOD if (MAIN_TABLE_BORDER == 'yes'){ table_image_border_bottom(); } // EOF: Lango Added for template MOD ?>           <tr>             <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>           </tr>       <tr>         <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>       </tr>       <tr>         <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_ADVANCED_SEARCH, tep_get_all_get_params(array('sort', 'page')), 'NONSSL', true, false) . '">' . tep_template_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td>       </tr>     </table>[/code] Regards Blackerutuf Mod edit: Please use code tags
  4. blackerutuf
    Hello Can any one help me I have an error message: Parse error: parse error, unexpected T_STRING in /home/virtual/site72/fst/var/www/html/shop/templates/content/advanced_search_result.tpl.php on line 166 This is the part of the script to which it refers: 166  $from_str .= " . TABLE_PRODUCTS_DESCRIPTION . " pd,                           " . TABLE_CATEGORIES . " c,                           " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; If any one can help I would be most obliged
  5. blackerutuf
    [!--quoteo(post=388643:date=Jun 27 2006, 09:58 PM:name=nogray)--][div class=\'quotetop\']QUOTE(nogray @ Jun 27 2006, 09:58 PM) [snapback]388643[/snapback][/div][div class=\'quotemain\'][!--quotec--] change this line $headers .= "Content-type: text/plain; charset=iso-8859-1\n"; to $headers .= "Content-type: text/html; charset=iso-8859-1\n"; and your message should show html [/quote] Dear Nogray That was most helpful and very simple, I am just trying to get to grips with php and help from you guys is most appreciated. The mod worked fine just what I wanted. Thanks and best regards Mike Dear Nogray That was most helpful and very simple, I am just trying to get to grips with php and help from you guys is most appreciated. The mod worked fine just what I wanted. Thanks and best regards Mike
  6. blackerutuf
    Can any one help me with adding html to my text only script? The current script is as follows: $headers = "MIME-Version: 1.0\n"; $headers .= "Content-type: text/plain; charset=iso-8859-1\n"; $headers .= "Content-Transfer-Encoding: 8bit\n"; $headers .= "From: $from\n"; $headers .= "X-Priority: 1\n"; $headers .= "X-MSMail-Priority: High\n"; $headers .= "X-Mailer: PHP/" . phpversion()."\n"; mail($to, $subject, $message, $headers); Thanks in advance to anyone who can help. Regards Mike
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.