caching = false;
$smarty->compile_dir=DIR_FS_CATALOG.'templates_c';
$smarty->template_dir=DIR_FS_CATALOG.'templates';
$smarty->assign('tpl_path','templates/'.CURRENT_TEMPLATE.'/');
$smarty->assign('TITLE',$data["ebay_titel"]);
$PICPATH = (EXTERN_EBAYPICTURE_SERVER == 1) ? EXTERN_EBAYPICTURE_SERVER_PICURL : EBAY_PICPATH_WEBSERVER;
if(!isset($_SESSION['languages_id'])) $_SESSION['languages_id'] = '2';
if($data['select_set'] == '1'){
$collies = xtc_get_product_collies($data['products_id']);
$set_table = '';
$set_table .= '';
for($i=0;$i';
if($model != '')
$set_table .= '
'.xtc_db_prepare_input($model).'';
$set_table .= '';
if(($i+1)%4 == 0 and $i>0)
$set_table .= '
';
}
$set_table .= '
';
$smarty->assign('SET',$set_table);
}
// $pic_query = xtc_db_query("SELECT products_image FROM products WHERE products_id='".$data['products_id']."'");
$pic_query = xtc_db_query("SELECT products_image,products_ean,products_model,manufacturers_id FROM products WHERE products_id='".$data['products_id']."'");
$firstpic = xtc_db_fetch_array($pic_query);
if($firstpic['manufacturers_id']){
$manufacturer_query = xtc_db_query(sprintf(
"SELECT manufacturers_name,manufacturers_image FROM %s WHERE manufacturers_id='%s'",
TABLE_MANUFACTURERS,$firstpic['manufacturers_id']
));
$manufacturer = xtc_db_fetch_array($manufacturer_query);
$smarty->assign(array(
'MANUFACTURERS_IMAGE'=>$manufacturer['manufacturers_image'],
'MANUFACTURERS_NAME'=>$manufacturer['manufacturers_name']
));
}
$smarty->assign(array(
'PRODUCTS_EAN'=>$firstpic['products_ean'],
'PRODUCTS_MODEL'=>$firstpic['products_model']
));
$img_template = 1;
$q = xtc_db_query("SELECT id FROM ebay_template_excludes WHERE ebay_products_id='".$data['id']."' && pic='".$firstpic['products_image']."'");
if(xtc_db_num_rows($q) < 1){
$smarty->assign('BILD'.$img_template,$PICPATH.$firstpic['products_image']);
$smarty->assign('BILD'.$img_template.'_file',$firstpic['products_image']);
$img_template++;
}
$smarty->assign('EBAYBILD',HTTP_SERVER.'images/product_images/ebaycategory_images/'.$data["ebay_bild"]);
$pic_double = array();
$pic_query = xtc_db_query("SELECT image_name FROM products_images WHERE products_id='".$data['products_id']."' order by image_nr");
while($pics = xtc_db_fetch_array($pic_query)){
if(!in_array($pics["image_name"],$pic_double) ){
$q = xtc_db_query("SELECT id FROM ebay_template_excludes WHERE ebay_products_id='".$data['id']."' && pic='".$pics["image_name"]."'");
if(xtc_db_num_rows($q) < 1){
$smarty->assign('BILD'.$img_template,$PICPATH.$pics["image_name"]);
$smarty->assign('BILD'.$img_template.'_file',$pics["image_name"]);
$img_template++;
}
$pic_double[] = $pics["image_name"];
}
}
$smarty->assign('STORE_NAME_ADDRESS',STORE_NAME_ADDRESS);
$cID = xtc_get_site_country_id($data['ebay_site']);
$lID = xtc_is_language_installed($cID);
if(!$lID){
$lID = '2';
}
// ENGLISCHE VARIABLEN
if($lID != 3){
$languages = xtc_get_languages();
for ($li = 0, $n = sizeof($languages); $li < $n; $li++) {
if($languages[$li]['name']=='English'){
$english = true;
$english_id = $languages[$li]['id'];
$pQE = xtc_db_query("SELECT products_extra_text,products_short_description,products_description FROM products_description WHERE products_id='".$data['products_id']."' and language_id='".$english_id."'");
$pE = xtc_db_fetch_array($pQE);
$smarty->assign('EXTRATEXT_EN',$pE['products_extra_text']);
$smarty->assign('KURZBESCHREIBUNG_EN',$pE['products_short_description']);
$smarty->assign('BESCHREIBUNG_EN',$pE['products_description']);
}
}
}
// ENDE ENGLISCHE VARS
$pQ = xtc_db_query("SELECT products_name,products_extra_text,products_short_description FROM products_description WHERE products_id='".$data['products_id']."' and language_id='".$lID."'");
$p =xtc_db_fetch_array($pQ);
$smarty->assign('EXTRATEXT',$p['products_extra_text']);
$smarty->assign('KURZBESCHREIBUNG',$p['products_short_description']);
$smarty->assign('PRODUCTS_NAME',$p['products_name']);
$smarty->assign('AUCTION_PRICE',number_format($data['ebay_preis'],2,',','.'));
if(!$stack_processing){
$gh = new group_handler($lID);
}
$groups = xtc_get_product_groups($data['products_id']);
$products_characteristics_data = array();
for($i=0;$igetVisible() == 1){
for($gi=0;$gigetCharacteristics());$gi++){
$gc = $group->getCharacteristics($gi);
if($gc->getVisible() == 1){
$gcDesc = $gc->getDescription($lID);
$title = $gcDesc->getTitle();
$value = $gh->getProductSetValue($data['products_id'],$group->getId(),$gc->getId(),$lID);
if($value != '')
$products_characteristics_data[] = array('title'=>$title,'value'=>$value,'no_sets'=>$gc->getNoSets(),'description'=>$gcDesc->getDescription());
}
}
}
}
if(sizeOf($products_characteristics_data)>0){
$smarty->assign('CHARACTERISTICS',$products_characteristics_data);
}
// BOF - VARIATIONPIC
$variations_query = xtc_db_query(sprintf(
"SELECT ebay_variations_sets_id FROM ebay_variations_sets WHERE ebay_products_id='%s'",
$data['id']
));
if(xtc_db_num_rows($variations_query)){
$variations_rec = xtc_db_fetch_array($variations_query);
$variations_products_query = xtc_db_query(sprintf(
"SELECT products_id FROM ebay_variations WHERE ebay_variations_sets_id='%s'",
$variations_rec['ebay_variations_sets_id']
));
$variations_products = array();
$variations_pictures = array();
while($variations_product = xtc_db_fetch_array($variations_products_query)){
$variations_products[] = $variations_product['products_id'];
}
foreach($variations_products as $vpID){
if($vpID == $data['products_id']) continue;
$vpic_query = xtc_db_query(sprintf(
"SELECT products_image FROM %s WHERE products_id='%s'",
TABLE_PRODUCTS,$vpID
));
$vpic = xtc_db_fetch_array($vpic_query);
if($vpic['products_image'] != ''){
$variations_pictures[] = $PICPATH.$vpic['products_image'];
}
}
$smarty->assign('VARIATION_PICTURES',$variations_pictures);
}
// EOF - VARIATIONPIC
require_once(DIR_FS_INC.'xtc_get_tax_class_id.inc.php');
$smarty->assign('TAX_RATE',xtc_get_tax_rate(xtc_get_tax_class_id($data['products_id'],STORE_COUNTRY)));
$smarty->assign('BESCHREIBUNG',xtc_db_prepare_input($data["ebay_beschreibung"]));
$smarty->assign('HERSTELLER',$ebay_hersteller);
$EBAYAPI = new ebayApi();
if($data['ebay_beschreibung_system'] == 'y'){
$wrap1 = $data['ebay_beschreibung'];
}else{
$wrap1 = $smarty->fetch(CURRENT_TEMPLATE . '/admin/ebay_templates/'.$data['ebay_template']);
}
require('includes/yes_footer.php');
$wrap1 .= $YESFOOTER;
?>