function convToUtf8($str)

if( mb_detect_encoding($str,"UTF-8, ISO-8859-1, GBK")!="UTF-8" )

 

return  iconv("gbk","utf-8",$str);

 

return $str;

 

}

print_r($_POST );//здесь у меня отличный текст

foreach ($_POST as $key=>$value){

$value = convToUtf8($value);

$query = "INSERT INTO mailsender

$result = mysql_query($query) or die("Query failed : " . mysql_error());

 

 

 

$query = "INSERT INTO postsender ('discount_size','start_data','end_data','text')

 

$query = "INSERT INTO postsender (discount_size, start_data, end_data, text)

 

 

 

 

 

 

 

 

 

 

$default = new vamTemplate;

$default->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');

$default->assign('session', session_id());

$main_content = '';

 

 

$default->assign( 'product_name_tpl', $product_name_tpl );

$default->assign( 'products_category_tpl', $products_category_tpl_arr );

$default->assign( 'category_path_tpl', $category_path_tpl_arr );

 

 

require_once (DIR_FS_INC.'vam_customer_greeting.inc.php');

require_once (DIR_FS_INC.'vam_get_path.inc.php');

require_once (DIR_FS_INC.'vam_check_categories_status.inc.php');

 

  require_once (DIR_WS_FUNCTIONS . 'products_specifications.php');

 

if (PRODUCT_LIST_RECURSIVE == 'true') {

  if (isset ($_GET['cat']) && vam_not_null($_GET['cat'])) {

    $parent_query = "select c.parent_id, c.categories_id

       from ".TABLE_CATEGORIES." c where c.categories_id = '".$current_category_id."'";

    $parent_query = vamDBquery($parent_query);

 

    $parent = vam_db_fetch_array($parent_query, true);

      $category_depth = "products";

  }

 

 

if (vam_check_categories_status($current_category_id) >= 1) {

 

$error = CATEGORIE_NOT_FOUND;

include (DIR_WS_MODULES.FILENAME_ERROR_HANDLER);

 

} else {

 

if ($category_depth == 'nested') {

 

  if (GROUP_CHECK == 'true') {

  $group_check = "and c.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

  }

  $category_query = "select

                                     c.categories_image from ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd

                                     and cd.language_id = '".(int) $_SESSION['languages_id']."'";

 

  $category_query = vamDBquery($category_query);

 

  $category = vam_db_fetch_array($category_query, true);

 

 

  if (isset ($cPath) && preg_match('/_/', $cPath)) {

  // check to see if there are deeper categories within the current category

  $category_links = array_reverse($cPath_array);

 

 

  for ($i = 0, $n = sizeof($category_links); $i < $n; $i ++) {

    if (GROUP_CHECK == 'true') {

    $group_check = "and c.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

    }

    if (PRODUCT_LIST_RECURSIVE == 'true') {

    $recursive_check="and c.parent_id = '".$category_links[$i]."'";

    } else {

    $recursive_check="";

    }

 

    $categories_query = "select      cd.categories_description,

                                             c.parent_id from ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd

                                             and cd.language_id = '".(int) $_SESSION['languages_id']."'

 

    $categories_query = vamDBquery($categories_query);

 

    if (vam_db_num_rows($categories_query, true) < 1) {

    // do nothing, go through the loop

    } else {

    break; // we've found the deepest category the customer is in

    }

  }

  } else {

  if (GROUP_CHECK == 'true') {

    $group_check = "and c.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

  }

  if (PRODUCT_LIST_RECURSIVE == 'true') {

    $recursive_check="and c.parent_id = '".$current_category_id."'";

  } else {

    $recursive_check="";

  }

  $categories_query = "select      cd.categories_description,

                                         c.parent_id from ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd

                                         and cd.language_id = '".(int) $_SESSION['languages_id']."'

 

  $categories_query = vamDBquery($categories_query);

  }

 

  $rows = 0;

  while ($categories = vam_db_fetch_array($categories_query, true)) {

  $rows ++;

 

  $cPath_new = vam_category_link($categories['categories_id'],$categories['categories_name']);

 

  $width = (int) (100 / MAX_DISPLAY_CATEGORIES_PER_ROW).'%';

  $image = '';

 

if ($categories['categories_image'] != '')

               {

                    $image = DIR_WS_IMAGES.'categories/'.$categories['categories_image'];

               }

               else

               {

                    $image = DIR_WS_IMAGES.'product_images/noimage.gif';

               }

 

  $categories_content[] = array ('CATEGORIES_NAME' => $categories['categories_name'], 'CATEGORIES_HEADING_TITLE' => $categories['categories_heading_title'], 'CATEGORIES_IMAGE' => $image, 'CATEGORIES_LINK' => vam_href_link(FILENAME_DEFAULT, $cPath_new), 'CATEGORIES_DESCRIPTION' => $categories['categories_description']);

 

  }

  $new_products_category_id = $current_category_id;

  include (DIR_WS_MODULES.FILENAME_NEW_PRODUCTS);

 

  $featured_products_category_id = $current_category_id;

  include (DIR_WS_MODULES.FILENAME_FEATURED);

 

  $image = '';

  if ($category['categories_image'] != '') {

  $image = DIR_WS_IMAGES.'categories/'.$category['categories_image'];

  }

  $default->assign('CATEGORIES_NAME', $category['categories_name']);

  $default->assign('CATEGORIES_HEADING_TITLE', $category['categories_heading_title']);

 

  $default->assign('CATEGORIES_IMAGE', $image);

  $default->assign('CATEGORIES_DESCRIPTION', $category['categories_description']);

 

  $default->assign('language', $_SESSION['language']);

  $default->assign('module_content', $categories_content);

 

  // get default template

  if ($category['categories_template'] == '' or $category['categories_template'] == 'default') {

  $files = array ();

  if ($dir = opendir(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/categorie_listing/')) {

    while (($file = readdir($dir)) !== false) {

    if (is_file(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/categorie_listing/'.$file) and ($file != "index.html") and (substr($file, 0, 1) !=".")) {

      $files[] = array ('id' => $file, 'text' => $file);

    } //if

    } // while

    closedir($dir);

  }

  $category['categories_template'] = $files[0]['id'];

  }

 

  $default->caching = 0;

 

  $main_content = $default->fetch(CURRENT_TEMPLATE.'/module/categorie_listing/'.$category['categories_template']);

 

  $vamTemplate->assign('main_content', $main_content);

 

elseif ($category_depth == 'products' || $_GET['manufacturers_id']) {

  //fsk18 lock

  $fsk_lock = '';

  if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {

  $fsk_lock = ' and p.products_fsk18!=1';

  }

  // show the products of a specified manufacturer

  if (isset ($_GET['manufacturers_id'])) {

  if (isset ($_GET['filter_id']) && vam_not_null($_GET['filter_id'])) {

 

    // sorting query

    $sorting_query = vamDBquery("SELECT products_sorting,

                                               products_sorting2 FROM ".TABLE_CATEGORIES."

                                               where categories_id='".(int) $_GET['filter_id']."'");

    $sorting_data = vam_db_fetch_array($sorting_query,true);

    my_sorting_products($sorting_data);

    if (!$sorting_data['products_sorting'])

    $sorting_data['products_sorting'] = 'pd.products_name';

    $sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';

    // We are asked to show only a specific category

    if (GROUP_CHECK == 'true') {

    $group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

    }

    $listing_sql = "select DISTINCT p.products_fsk18,

                                 from ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_MANUFACTURERS." m, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c, ".TABLE_PRODUCTS." p left join ".TABLE_SPECIALS." s on p.products_id = s.products_id

                                 and m.manufacturers_id = '".(int) $_GET['manufacturers_id']."'

                                 and pd.language_id = '".(int) $_SESSION['languages_id']."'

                                 and p2c.categories_id = '".(int) $_GET['filter_id']."'".$sorting;

  } else {

    // We show them all

    if (GROUP_CHECK == 'true') {

    $group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

    }

    $listing_sql = "select p.products_fsk18,

                           from ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_MANUFACTURERS." m, ".TABLE_PRODUCTS." p left join ".TABLE_SPECIALS." s on p.products_id = s.products_id

                           and pd.language_id = '".(int) $_SESSION['languages_id']."'

                           and m.manufacturers_id = '".(int) $_GET['manufacturers_id']."'";

  }

  } else {

  // show the products in a given categorie

  if (isset ($_GET['filter_id']) && vam_not_null($_GET['filter_id'])) {

 

    // sorting query

    $sorting_query = vamDBquery("SELECT products_sorting,

                                               products_sorting2 FROM ".TABLE_CATEGORIES."

    $sorting_data = vam_db_fetch_array($sorting_query,true);

    my_sorting_products($sorting_data);

    if (!$sorting_data['products_sorting'])

    $sorting_data['products_sorting'] = 'pd.products_name';

    $sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';

    // We are asked to show only specific catgeory

    if (GROUP_CHECK == 'true') {

    $group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

    }

    if (PRODUCT_LIST_RECURSIVE == 'true') {

    $recursive_check= "and (p2c.categories_id = '".$current_category_id."' AND p2c.categories_id = c.categories_id OR p2c.categories_id = c.categories_id AND c.parent_id = '".$current_category_id."')";

    $recursive_table_categories=TABLE_CATEGORIES." c, ";

    } else {

    $recursive_check="and p2c.categories_id = '".$current_category_id."'";

    $recursive_table_categories="";

    }

    $listing_sql = "select p.products_fsk18,

                                 from  ".$recursive_table_categories.TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_MANUFACTURERS." m, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c, ".TABLE_PRODUCTS." p left join ".TABLE_SPECIALS." s on p.products_id = s.products_id

                                 and m.manufacturers_id = '".(int) $_GET['filter_id']."'

                                 and pd.language_id = '".(int) $_SESSION['languages_id']."' "

                                  .$recursive_check

                                  .$sorting;

  } else {

 

    // sorting query

    $sorting_query = vamDBquery("SELECT products_sorting,

                                               products_sorting2 FROM ".TABLE_CATEGORIES."

    $sorting_data = vam_db_fetch_array($sorting_query,true);

    my_sorting_products($sorting_data);

    if (!$sorting_data['products_sorting'])

    $sorting_data['products_sorting'] = 'pd.products_name';

    $sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';

    // We show them all

    if (GROUP_CHECK == 'true') {

    $group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

    }

    if (PRODUCT_LIST_RECURSIVE == 'true') {

    $recursive_check= "and (p2c.categories_id = '".$current_category_id."' AND p2c.categories_id = c.categories_id OR p2c.categories_id = c.categories_id AND c.parent_id = '".$current_category_id."')";

    $recursive_table_categories=TABLE_CATEGORIES." c, ";

    } else {

    $recursive_check="and p2c.categories_id = '".$current_category_id."'";

    $recursive_table_categories="";

    }

    $listing_sql = "select p.products_fsk18,

                                 from  ".$recursive_table_categories.TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c, ".TABLE_PRODUCTS." p left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id

                                 left join ".TABLE_SPECIALS." s on p.products_id = s.products_id

                                 and pd.language_id = '".(int) $_SESSION['languages_id']."' "

                                  .$recursive_check

                                  .$sorting;

  }

  }

  // optional Product List Filter

  // Get the right image for the top-right

  $image = DIR_WS_IMAGES.'table_background_list.gif';

  if (isset ($_GET['manufacturers_id'])) {

  $image = vamDBquery("select manufacturers_image from ".TABLE_MANUFACTURERS." where manufacturers_id = '".(int) $_GET['manufacturers_id']."'");

 

  $image = vam_db_fetch_array($image,true);

  $image = $image['manufacturers_image'];

  }

  elseif ($current_category_id) {

  $image = vamDBquery("select categories_image from ".TABLE_CATEGORIES." where categories_id = '".$current_category_id."'");

  $image = vam_db_fetch_array($image,true);

  $image = $image['categories_image'];

  }

 

  include (DIR_WS_MODULES.FILENAME_PRODUCT_LISTING);

 

} else { // default page

  if (GROUP_CHECK == 'true') {

  $group_check = "and group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

  }

  $shop_content_query = vamDBquery("SELECT

                     FROM ".TABLE_CONTENT_MANAGER."

  $shop_content_data = vam_db_fetch_array($shop_content_query,true);

 

        $default->assign('title', $shop_content_data['content_heading']);

  include (DIR_WS_INCLUDES.FILENAME_CENTER_MODULES);

 

  if ($shop_content_data['content_file'] != '') {

  ob_start();

  if (strpos($shop_content_data['content_file'], '.txt'))

    echo '<pre>';

  include (DIR_FS_CATALOG.'media/content/'.$shop_content_data['content_file']);

  if (strpos($shop_content_data['content_file'], '.txt'))

    echo '</pre>';

  $shop_content_data['content_text'] = ob_get_contents();

  ob_end_clean();

  }

 

 $default->assign('greeting', vam_customer_greeting());

  $default->assign('text', $shop_content_data['content_text']);

  $default->assign('language', $_SESSION['language']);

 

  // set cache ID

  if (!CacheCheck()) {

  $default->caching = 0;

  $main_content = $default->fetch(CURRENT_TEMPLATE.'/module/main_content.html');

  } else {

  $default->caching = 1;

  $default->cache_lifetime = CACHE_LIFETIME;

  $default->cache_modified_check = CACHE_CHECK;

  $cache_id = $_SESSION['language'].$_SESSION['currency'].$_SESSION['customer_id'];

  $main_content = $default->fetch(CURRENT_TEMPLATE.'/module/main_content.html', $cache_id);

  }

 

  $vamTemplate->assign('main_content', $main_content);