| |
|
|
Just good Care! Welcome at Yachticon
Yachticon was established in 1982 and is today a leading company internationally which develops and markets innovative products for the care of yachts and caravans.
At the time it started up the main product was initially a solution for disinfecting water - Aqua Clean. The innovative product closed a genuine gap in the market and was the start of our success. Today we at Yachticon are the strong partner when it comes to care in water sports and the caravan market.
With more than 1000 products in our current catalogue we offer an answer to (almost) every challenge with regard to care. At our production site in Germany we develop and market products which are simple to use and highly effective. From anti-yellowing to decorative-strip polishing paste - we are, with our products, a reliable onboard partner and are one of the largest companies in the trade internationally.
In Germany our products are to be found in almost every specialist shop and Yachticon products are also being successfully marketed and used in more than 50 countries in Europe and overseas. At the same time the close contact that we have with our customers is very important to us - at the five major water sports trade fairs and on the telephone we are willing to talk to yacht owners and caravanners at any time.
I wish you many beautiful, relaxing hours on board
Yours
Oliver Nagel
News:
Grotamar 82 200 ml
Preservative for up-to-date B5** - B100** diesel fuel and heating oil. Fast bactericide and fungicide efficacy (inkl. sulphate-reducing bacteria). Enhances anti-corrosion and anti-oxidation properties. Provides exellent long-term protection against microbial material degradation. Contains no organically bound chlorine (acc. 19. Bundes-Immissionsschutzgesetz)* . Excellent soluble in biodiesel, diesel fuel and heating oil with biogenic compounds. Improves storage stability of B5** - B20** diesel blends. Keeps the tank system clean. (* German Law on the Prevention of Emissions) (** Biodiesel amount in % blended in mineral oil diesel). Dosage: 1000ml are good for 4000 litres preventiv treatment and for 1000 litres shock treatment.
25,95 EUR
incl. 19 % Tax excl. Shipping costs
Painting Precleaner & Degreaser 500 ml
11,95 EUR
incl. 19 % Tax excl. Shipping costs
Antifouling Remover 3 Litres
69,95 EUR
incl. 19 % Tax excl. Shipping costs
Chamois Leather 46 x 30 cm
9,95 EUR
incl. 19 % Tax excl. Shipping costs
Rope Coating 100 ml
9,95 EUR
incl. 19 % Tax excl. Shipping costs
Microcount Fuel - Diesel Bacteria Test Kit
39,95 EUR
incl. 19 % Tax excl. Shipping costs
Colour Restorer 500 ml
14,95 EUR
incl. 19 % Tax excl. Shipping costs
Plastic Colour Renewer 250 ml
11,95 EUR
incl. 19 % Tax excl. Shipping costs
Metal Polishing Paste Easy Shine 58 g
7,95 EUR
incl. 19 % Tax excl. Shipping costs
Colour Wax red 500 ml
15,95 EUR
incl. 19 % Tax excl. Shipping costs
Hullstripe Colour Paste red 250 g
20,95 EUR
incl. 19 % Tax excl. Shipping costs
Epoxy Light Filler white 300 g
21,95 EUR
incl. 19 % Tax excl. Shipping costs
Gelcoat Repair Filler white 70 g
7,95 EUR
incl. 19 % Tax excl. Shipping costs
Shopping Cart
You do not have any products in your shopping cart yet.
';
$line .= $split . replace_uml($art[$i]['categories_name_de']);
$line .= $split . replace_uml($art[$i]['categories_name_en']);
$line .= $split . replace_uml($art[$i]['sub_categories_name_de']);
$line .= $split . replace_uml($art[$i]['sub_categories_name_en']);
$line .= $split . replace_uml($art[$i]['products_name_de']);
$line .= $split . replace_uml($art[$i]['products_name_en']);
$line .= $split . $art[$i]['products_price'];
$line .= $split . $art[$i]['personal_offer'];
$line .= $split . replace_uml($art[$i]['size_de']);
$line .= $split . replace_uml($art[$i]['size_en']);
$line .= $split . replace_uml($art[$i]['vpe_de']);
$line .= $split . replace_uml($art[$i]['vpe_en']);
$line .= $split . replace_uml($art[$i]['base_price']);
$line .= $split . replace_uml($art[$i]['products_description_de']);
$line .= $split . replace_uml($art[$i]['products_description_en']);
$line .= $split;
$line .= $split . $art[$i]['products_image'];
$line = strip_wraps($line);
// neu - excel mach auf einmal stress bei ; und macht da einfach schluss sonst...
$line = html_entity_decode($line);
$line = str_replace(';', '.', $line);
fwrite($file, $line . "\n");
}
// nur excel - direkt als download ausgeben und ende
header('Content-Disposition: attachment; filename=' . basename($name));
echo file_get_contents($name);
exit();
}
function replace_uml($text)
{
$uml1 = array("ä" , "ö", "ü", "ß", "Ä", "Ö", "Ü");
$uml2 = array("ä" , "ö", "ü", "ß", "Ä", "Ö", "Ü");
// umlaute wiederherstellen
$text = str_replace("ä","ä",$text);
$text = str_replace("ö","ö",$text);
$text = str_replace("ü","ü",$text);
$text = str_replace("ß","ß",$text);
$text = str_replace("Ä","Ä",$text);
$text = str_replace("Ö","Ö",$text);
$text = str_replace("Ü","Ü",$text);
return $text;
}
function strip_wraps($in)
{
$in = str_replace("\r\n","",$in);
$in = str_replace("\n","",$in);
$in = str_replace("\r","",$in);
return $in;
}
function make_name($name)
{
$name = str_replace("+","_",$name);
$name = str_replace(" ","_",$name);
$name = str_replace("/","_",$name);
$name = str_replace("ä","ae",$name);
$name = str_replace("ö","oe",$name);
$name = str_replace("ü","ue",$name);
$name = str_replace("ß","ss",$name);
$name = str_replace("Ä","Ae",$name);
$name = str_replace("Ö","Oe",$name);
$name = str_replace("Ü","Ue",$name);
return $name;
}
// einen artikel aus der datenbank auslesen
function get_article($id)
{
$sql = "SELECT
products_model,
products_price,
base_price,
products_image,
products_tax_class_id
FROM
products
WHERE
products_id = " . $id . "
";
$res = mysql_query($sql);
$art = mysql_fetch_assoc($res);
if(!$art['products_model'])
return;
// EN descr auslesen
$sql = "SELECT
products_name,
products_description,
products_short_description,
vpe,
size
FROM
products_description
WHERE
language_id='1'
AND
products_id='" . $id . "'
";
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
$art['products_name_en'] = replace_uml($tmp['products_name']);
$art['products_description_en'] = replace_uml($tmp['products_description']);
$art['products_short_description_en'] = replace_uml($tmp['products_short_description']);
$art['vpe_en'] = $tmp['vpe'];
$art['size_en'] = $tmp['size'];
// DE descr auslesen
$sql = "SELECT
products_name,
products_description,
products_short_description,
vpe,
size
FROM
products_description
WHERE
language_id='2'
AND
products_id='" . $id . "'
";
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
$art['products_name_de'] = replace_uml($tmp['products_name']);
$art['products_description_de'] = replace_uml($tmp['products_description']);
$art['products_short_description_de'] = replace_uml($tmp['products_short_description']);
$art['vpe_de'] = $tmp['vpe'];
$art['size_de'] = $tmp['size'];
// EK netto
$sql = "SELECT
personal_offer
FROM
personal_offers_by_customers_status_3
WHERE
products_id='" . $id . "'
";
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
$art['personal_offer'] = $tmp['personal_offer'];
/*
* @ 20.10.2010
* mehrere ebenen von kategorien
*/
// order by categories_id => bei startseite anzeigen gibt es id = 0...
$sql = 'SELECT `categories_id` FROM `products_to_categories` WHERE `products_id` = ' . $id . ' ORDER BY `categories_id` DESC';
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
$art['categories_id'] = $tmp['categories_id'];
// erste ebene de name
$sql = 'SELECT `categories_name` FROM `categories_description` WHERE `categories_id` = ' . $art['categories_id'] . ' AND `language_id` = 2';
$res = mysql_query($sql);
$tmp1 = mysql_fetch_assoc($res);
$art['categories_name_de'] = $tmp1['categories_name'];
// erste ebene en name
$sql = 'SELECT `categories_name` FROM `categories_description` WHERE `categories_id` = ' . $art['categories_id'] . ' AND `language_id` = 1';
$res = mysql_query($sql);
$tmp1 = mysql_fetch_assoc($res);
$art['categories_name_en'] = $tmp1['categories_name'];
// gibt es eine parent cat ?
$sql = 'SELECT `parent_id` FROM `categories` WHERE `categories_id` = ' . $art['categories_id'];
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
if($tmp['parent_id'])
{
// gitb erste, bisherige erste auf zweite legen
$art['sub_categories_name_de'] = $art['categories_name_de'];
$art['sub_categories_name_en'] = $art['categories_name_en'];
$art['categories_name_de'] = '';
$art['categories_name_en'] = '';
// erste ebene de name
$sql = 'SELECT `categories_name` FROM `categories_description` WHERE `categories_id` = ' . $tmp['parent_id'] . ' AND `language_id` = 2';
$res = mysql_query($sql);
$tmp1 = mysql_fetch_assoc($res);
$art['categories_name_de'] = $tmp1['categories_name'];
// erste ebene en name
$sql = 'SELECT `categories_name` FROM `categories_description` WHERE `categories_id` = ' . $tmp['parent_id'] . ' AND `language_id` = 1';
$res = mysql_query($sql);
$tmp1 = mysql_fetch_assoc($res);
$art['categories_name_en'] = $tmp1['categories_name'];
}
/*
// kat id
$sql = "SELECT
categories_id
FROM
products_to_categories
WHERE
products_id='" . $id . "'
";
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
$art['categories_id'] = $tmp['categories_id'];
// kat name de
$sql = "SELECT
categories_name
FROM
categories_description
WHERE
categories_id='" . $art['categories_id'] . "'
AND
language_id='2'
";
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
$art['categories_name_de'] = $tmp['categories_name'];
// kat name en
$sql = "SELECT
categories_name
FROM
categories_description
WHERE
categories_id='" . $art['categories_id'] . "'
AND
language_id='1'
";
$res = mysql_query($sql);
$tmp = mysql_fetch_assoc($res);
$art['categories_name_en'] = $tmp['categories_name'];
*/
// leerzeichen am anfang der zeile entfernen
$art['products_short_description_de'] = preg_replace("|
\s|"," ",$art['products_short_description_de']);
$art['products_description_de'] = preg_replace("| \s|"," ",$art['products_description_de']);
$art['products_short_description_en'] = preg_replace("| \s|"," ",$art['products_short_description_en']);
$art['products_description_en'] = preg_replace("| \s|"," ",$art['products_description_en']);
// alle in | umwandeln
$art['products_short_description_de'] = preg_replace("||","|",$art['products_short_description_de']);
$art['products_description_de'] = preg_replace("||","|",$art['products_description_de']);
$art['products_short_description_en'] = preg_replace("||","|",$art['products_short_description_en']);
$art['products_description_en'] = preg_replace("||","|",$art['products_description_en']);
// rest html entfernen
$art['products_description_de'] = strip_tags($art['products_description_de']);
$art['products_description_en'] = strip_tags($art['products_description_en']);
$art['products_short_description_de'] = strip_tags($art['products_short_description_de']);
$art['products_short_description_en'] = strip_tags($art['products_short_description_en']);
// zeilenumbrüche entfernen
$art['products_description_de'] = strip_wraps($art['products_description_de']);
$art['products_description_en'] = strip_wraps($art['products_description_en']);
$art['products_short_description_de'] = strip_wraps($art['products_short_description_de']);
$art['products_short_description_en'] = strip_wraps($art['products_short_description_en']);
// leerzeichen entfernen
$art['products_description_de'] = trim($art['products_description_de']);
$art['products_description_en'] = trim($art['products_description_en']);
$art['products_short_description_de'] = trim($art['products_short_description_de']);
$art['products_short_description_en'] = trim($art['products_short_description_en']);
// zweier leerzeichen entfernen
$art['products_description_de'] = str_replace(" "," ",$art['products_description_de']);
$art['products_description_en'] = str_replace(" "," ",$art['products_description_en']);
$art['products_short_description_de'] = str_replace(" "," ",$art['products_short_description_de']);
$art['products_short_description_en'] = str_replace(" "," ",$art['products_short_description_en']);
// leerzeichen um die trennern entfernen
$art['products_description_de'] = str_replace(" |","|",$art['products_description_de']);
$art['products_description_en'] = str_replace(" |","|",$art['products_description_en']);
$art['products_short_description_de'] = str_replace(" |","|",$art['products_short_description_de']);
$art['products_short_description_en'] = str_replace(" |","|",$art['products_short_description_en']);
$art['products_description_de'] = str_replace("| ","|",$art['products_description_de']);
$art['products_description_en'] = str_replace("| ","|",$art['products_description_en']);
$art['products_short_description_de'] = str_replace("| ","|",$art['products_short_description_de']);
$art['products_short_description_en'] = str_replace("| ","|",$art['products_short_description_en']);
return $art;
}
?>