60) { // max. 1 emal per minute
while (filemtime(MYSQL_PHP_TIMESTAMP) < $d) {
$fhandle = fopen(MYSQL_PHP_TIMESTAMP, "a");
fwrite($fhandle, " ");
fclose(($fhandle));
clearstatcache();
sleep(1);
}
//mail(ADMIN_EMAIL, 'Database Error', $serror, 'From: ' . ADMIN_EMAIL);
mime_versenden("", ADMIN_EMAIL, "", ADMIN_EMAIL, 'Database Error', $serror);
}
}
function mysql_error_check($request = "") {
global $db;
$e = mysql_error();
if ($e != "") {
if (DEVELOPMENT) {
mysql_error_log($e, $request);
echo "\nMSYQL ERROR: ";
echo $e, "
\n";
die();
} else {
mysql_error_log($e, $request);
}
}
}
function dolog($request, $remarks = "", $schluessel = "", $user = "") {
global $db;
if ($user == "" and ! empty($_SERVER["PHP_AUTH_USER"])) {
$user = $_SERVER["PHP_AUTH_USER"];
};
$user = mysql_escape_string($user);
$remarks = mysql_escape_string($remarks);
$file = mysql_escape_string($_SERVER["PHP_SELF"]);
$schluessel = mysql_escape_string($schluessel);
$request2 = mysql_escape_string($request);
$ip = ip2long($_SERVER["REMOTE_ADDR"]);
mysql_query2("insert into log (request, user, ip, file, schluessel, remarks) values ('$request2', '$user', $ip, '$file', '$schluessel', '$remarks')");
}
function debug() {
if (!DEVELOPMENT)
return;
$numParams = func_num_args();
$params = func_get_args();
$s = "";
for ($i = 0; $i < $numParams; $i++) {
if ($i == 0)
$s .= "";
else
$s .= "
";
}
//echo htmlspecialchars($s);
echo $s;
flush2();
//file_put_contents ( "/tmp/debugoutput.txt", $s, FILE_APPEND);
}
;
function debug_p() {
// for productive environment
$numParams = func_num_args();
$params = func_get_args();
for ($i = 0; $i < $numParams; $i++) {
if ($i == 0)
echo "";
else
echo "
";
}
flush2();
}
function debug_t() {
// for text/batch mode
if (!DEVELOPMENT)
return;
$numParams = func_num_args();
$params = func_get_args();
for ($i = 0; $i < $numParams; $i++) {
echo "$i: ", $params[$i], "\n";
if ($i + 1 == $numParams)
echo "\n";
}
}
function debug_m() {
// by Email
if (!DEVELOPMENT)
return;
$s = "";
$numParams = func_num_args();
$params = func_get_args();
for ($i = 0; $i < $numParams; $i++) {
$s .= "$i: " . $params[$i] . "\n";
if ($i + 1 == $numParams)
$s .= "\n";
}
mime_versenden("", ADMIN_EMAIL, "", ADMIN_EMAIL, 'Debug', $s);
}
function debug_tab() {
if (!DEVELOPMENT)
return;
$numParams = func_num_args();
$params = func_get_args();
for ($i = 0; $i < $numParams; $i++) {
echo '';
if ($i == 0)
echo "";
else
echo "
";
echo " ' . "\n||" . md5b($email) . "||\n";
if ($mailref > 0)
$body_add_html .= "
\n";
$email_mailing_id = $id;
$mailing_id = $mailref;
$email_md5 = md5b($email);
$search[] = '/\[%body_add_txt\]/i';
$search[] = '/\[%body_add_html\]/i';
$search[] = '/</';
$search[] = '/>/';
if (!$is_html) {
$search[] = '|<[A-Za-z0-9]+>|';
$search[] = '||';
}
$search[] = '/\[email\]/i';
$search[] = '/\[%listcharset\]/i';
$search[] = '/\[%id\]/i';
$search[] = '/\[%code\]/i';
$search[] = '/\[%mailref\]/i';
$search[] = '/\[name\]/i';
$search[] = <<id, $e, $code);
$r2 = mysql_query2("select * from mailings_links_emails_mailing where link=%s and email_mailing=%s", $row->id, $e);
$rows = mysql_numrows($r2);
}
$code = mysql_fetch_object($r2)->code;
$s .= $code;
}
return ($s);
}
function x2($params) {
global $coupon;
$description = $params[1];
$from_date = $params[2];
$to_date = $params[3];
$gb = $params[4];
mysql_query2("START TRANSACTION");
mysql_query2("insert into coupons (description, valid_from, valid_until, gb) values (%s, %s, %s, %s)", $description, $from_date, $to_date, $gb);
$nr = mysql_insert_id();
//$code = md5b ($nr);
$code = shortcode();
mysql_query2("update coupons set code=%s where nr=%s", $code, $nr);
mysql_query2("COMMIT");
$coupon = $code;
return ($code);
}
function telnum_blacklist($telnum, $telcode) {
$err = FALSE;
if ((substr($telcode . $telnum, 0, 4) == "+439") || // 0900 Mehrwert Nummer
(substr($telcode . $telnum, 0, 5) == "+4382") // SMS.at etc.
)
$err = TRUE;
return ($err);
}
function adresse_email($language) {
if ($language == "DE") {
$adresse = "aus Deutschland: " . ADMIN_PHONE_DE . NL . "(0,09 Euro pro Minute aus den deutschen Festnetz, ggf. abweichende Preise aus dem Mobilfunk)" . NL . "aus Österreich: " . ADMIN_PHONE_AT . NL . "aus anderen Ländern: " . ADMIN_PHONE;
} else {
$adresse = "Austria: " . ADMIN_PHONE;
}
return ($adresse);
}
function t_select($default, $prod_id, $with_blank = 0, $section = "", $lang = "DE") {
global $db, $language, $debug;
if ($lang == "")
$lang = $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
if ($section == "")
$r = mysql_query2("select id, schluessel from translations where language=%s and mandant=%s order by schluessel", $lang, MANDANT);
else
$r = mysql_query2("select id, schluessel from translations where sect=%s and language=%s and mandant=%s order by schluessel", $section, $lang, MANDANT);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", strip_tags($row->schluessel . " - " . substr(t2($row->id, $prod_id, 0), 0, 200)); //, "($row->id)";
echo " \n";
}
}
function parent_select($default, $prod_id, $with_blank = 0, $what = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
switch ($what) {
case 1:
$r = mysql_query2("select id, sku, nameTxt, active from products where parent is NULL and mandant=%s and active order by sku", MANDANT);
break;
case 2:
$r = mysql_query2("select id, sku, nameTxt, active from products where parent is NULL and mandant=%s and not active order by sku", MANDANT);
break;
case 0:
$r = mysql_query2("select id, sku, nameTxt, active from products where parent is NULL and mandant=%s order by sku", MANDANT);
break;
}
while ($row = mysql_fetch_object($r)) {
$t = t3($row->nameTxt, $row->id, 0, "", "", "", "", "", "DE", TRUE, TRUE);
echo "id, "\"";
if ($row->active)
echo ' style="background-color:#ffe49b;" ';
if ($default == $row->id)
echo ' selected="selected"';
//echo ">", $row->sku, " - ", $row->id, " - ", substr(t2($row->name, $row->id, 0), 0, 25);
//echo ">", $row->sku, " - ", $row->id, " - ", substr($row2->translation, 0, 25);
echo ">", $row->sku, " - ", $row->id, " - ", mb_substr($t, 0, 25);
echo " \n";
}
}
function subparent_select($default, $prod_id, $with_blank = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from subparents where parent=%s", $prod_id);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id) {
echo ' selected="selected"';
}
echo ">", $row->sku, " - ", $row->id;
echo " \n";
}
}
function color_select($default, $with_blank = 0, $ismap = FALSE, $product = FALSE) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
if ($ismap) {
$r = mysql_query2("select id, `$language_sort` from colors where is_map order by `$language_sort`");
} else {
if ($product->parent) {
if ($product->id) {
$r = mysql_query2("select c.id, c.`$language_sort` from colors c left join products p on p.parent=%s and p.id<>%s and p.color=c.id where p.id is null order by `$language_sort`", $product->parent, $product->id);
} else {
$r = mysql_query2("select c.id, c.`$language_sort` from colors c left join products p on p.parent=%s and p.color=c.id where p.id is null order by `$language_sort`", $product->parent);
}
} else {
$r = mysql_query2("select id, `$language_sort` from colors order by `$language_sort`");
}
// FIX - funktioniert so nicht :-(
$r = mysql_query2("select id, `$language_sort` from colors order by `$language_sort`");
}
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->$language_sort;
echo " \n";
}
}
function display_unit_select($default, $with_blank = 0, $typ = "") {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
if ($typ == "")
$r = mysql_query2("select id, `$language_sort` from units order by `$language_sort`");
else
$r = mysql_query2("select id, `$language_sort` from units where typ=%s order by `$language_sort`", $typ);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->$language_sort;
echo " \n";
}
}
function category_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select SQL_NO_CACHE id, name_DE from categories where mandant=%s order by `name_DE`", MANDANT);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name_DE;
echo " \n";
}
}
function outer_material_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from outer_materials order by `name_DE`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name_DE;
echo " \n";
}
}
function template_select($default, $with_blank = 0, $only_existing = FALSE) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo "\n";
}
if ($only_existing) {
$r = mysql_query2("select t.* from templates t, products p, browse_nodes b where (t.all_products or (p.mandant=%s and p.browse_node=b.id and b.template=t.id)) and t.active group by t.id order by t.id", MANDANT);
} else {
$r = mysql_query2("select * from templates where active order by id");
}
while ($row = mysql_fetch_object($r)) {
echo ' id)
echo " Selected";
echo ">", addslashes($row->$language_sort);
echo " \n";
}
}
function imagefiles($parent, $existing_images) {
$result = array();
$r = mysql_query2("select fname from photos p, photos_parents pp where pp.photo=p.id and pp.parent=%s", $parent);
while ($row = mysql_fetch_object($r)) {
$result[] = $row->fname;
}
$r = mysql_query2("select fname from photos p left join photos_parents pp on pp.photo=p.id where pp.id is null");
while ($row = mysql_fetch_object($r)) {
$result[] = $row->fname;
}
$result = array_merge($result, $existing_images);
$result = array_unique($result);
sort($result);
return ($result);
}
function image_select($default, $with_blank = 0, $imagefiles) {
global $db;
if ($with_blank) {
echo ' ";
echo " \n";
}
while (list(, $file) = each($imagefiles)) {
if (preg_match("/^[^.].*\.(gif|jpg|jpeg|png)$/i", $file)) {
echo "", htmlspecialchars($file);
echo " \n";
}
}
}
function xmlfiles() {
global $db;
return ($result);
}
function season_select($default, $with_blank = 0, $language) {
global $db;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from seasons where language=%s order by name", $language);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name;
echo " \n";
}
}
function special_size_select($default, $with_blank = 0, $language) {
global $db, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from special_sizes order by `$language_sort`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->$language_sort;
echo " \n";
}
}
function size_select($default, $with_blank = 0, $country = "DE", $is_map = FALSE) {
global $db;
if ($with_blank) {
echo ' ";
echo " \n";
}
if ($is_map)
$r = mysql_query2("select * from sizes where country=%s and is_map order by name", $country);
else
$r = mysql_query2("select * from sizes where country=%s order by name", $country);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name;
echo " \n";
}
}
function style_keyword_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, `$language_sort` from style_keywords order by `$language_sort`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->$language_sort;
echo " \n";
}
}
function clothing_type_select($default, $with_blank = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, name from clothing_types order by `name`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name;
echo " \n";
}
}
function style_name_select($default, $with_blank = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, name_DE from style_names order by `name_DE`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name_DE;
echo " \n";
}
}
function length_name_select($default, $with_blank = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, name_DE from length_names order by `name_DE`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name_DE;
echo " \n";
}
}
function apparel_closure_select($default, $with_blank = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, name_DE from apparel_closure_type order by `name_DE`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name_DE;
echo " \n";
}
}
function browse_node_select($default, $with_blank = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, name from browse_nodes where `active` order by `name`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name;
echo " \n";
}
}
function department_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, `$language_sort` from departments order by `$language_sort`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->$language_sort;
echo " \n";
}
}
function opacity_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from opacity order by `$language_sort`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->$language_sort;
echo " \n";
}
}
function pattern_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from patterns order by `$language_sort`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->$language_sort;
echo " \n";
}
}
function brand_select($default, $with_blank = 0) {
global $db, $language;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select id, name from brands where mandant=%s order by name", MANDANT);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", $row->name;
echo " \n";
}
}
function year_select($default, $with_blank = 0) {
if ($with_blank) {
echo ' ";
echo " \n";
}
$start = 2011;
$end = date("Y") + 3;
$i = $start;
while ($i <= $end) {
echo "", $i;
echo " \n";
$i++;
}
}
function country_select($default, $with_blank = 0, $export = FALSE) {
global $db, $language, $language_sort;
$language_sort = mysql_real_escape_string($language_sort);
if ($with_blank) {
echo ' ";
echo " \n";
}
if ($export)
$r = mysql_query2("select c.* from countries c, mandanten_countries m where m.mandant=%s and m.marketplace and m.country=c.id and c.export group by c.id order by `" . $language_sort . "`", MANDANT);
else
$r = mysql_query2("select * from countries order by `" . $language_sort . "`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", addslashes($row->$language_sort), " ";
echo "\n";
}
}
function mandant_select($default, $with_blank = 0) {
global $db;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from mandanten where active");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", addslashes($row->name);
echo "\n";
}
}
function lager_select($default, $with_blank = 0) {
global $db;
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select * from lager where active and mandant=%s order by kurzname, id", MANDANT);
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", addslashes($row->kurzname);
echo "\n";
}
}
function language_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
$language_sort = mysql_real_escape_string($language_sort);
if ($with_blank) {
echo ' ";
echo " \n";
}
$r = mysql_query2("select SQL_NO_CACHE * from languages order by `" . $language_sort . "`");
while ($row = mysql_fetch_object($r)) {
echo "id, "\"";
if ($default == $row->id)
echo ' selected="selected"';
echo ">", addslashes($row->$language_sort);
echo "\n";
}
}
function country_name($country, $language_sort_overwrite = "") {
global $db, $language_sort;
$ls = $language_sort_overwrite == "" ? $language_sort : $language_sort_overwrite;
$r = mysql_query2("select * from countries where iso=%s", $country);
if ($row = mysql_fetch_object($r)) {
return ($row->$ls);
} else
return ("");
}
function href($href = "", $ssl = -1, $arguments = "", $lang = "", $what = "", $echo = 1) {
global $language;
$ssl = 1; // immer SSL
if ($lang == "")
$lang = $language;
//if ($href == "") $href = "index";
$ret = "";
if ($ssl == 1)
$ret .= HOSTS;
if ($ssl == 0)
$ret .= HOST;
$ret .= HREF_START;
switch ($lang) {
case "EN":
$ret .= "english/";
break;
case "ES":
$ret .= "espanol/";
break;
case "FR":
$ret .= "francais/";
break;
case "IT":
$ret .= "italiano/";
break;
default:
$ret .= "deutsch/";
break;
}
if ($href <> "")
$ret .= $href . "/";
if ($what <> "")
$ret .= $what . "/";
if ($arguments <> "") {
$ret .= $arguments;
if (substr($arguments, 0, 1) <> '?')
$ret .= '/';
}
if ($echo)
echo $ret;
return ($ret);
}
function ahref($href = "", $ssl = -1, $arguments = "", $lang = "", $what = "", $echo = 1) {
$ret = "";
$ret .= '';
if ($echo)
echo $ret;
return ($ret);
}
function days_to_months($days) {
switch ($days) {
case 29:
case 30:
$months = 1;
break;
case 89:
case 90:
$months = 3;
break;
case 179:
case 180:
$months = 6;
break;
case 731:
$months = 24;
break;
case 1825:
case 1830:
$months = 60;
break;
default:
$months = round($days / 30, 0);
break;
}
return ($months);
}
function interval($days, $paymethod) {
switch ($paymethod) {
/*
case "P":
$i = days_to_months ($days) * 30 . " day";
break;
*/
default:
$i = days_to_months($days) . " month";
break;
}
return ($i);
}
function message_bar($html, $type = 0) {
echo '
';
}
function curr($amount, $from = "EUR", $to = "", $print = 1) {
global $language, $scurrency;
if ($to == "")
$to = $scurrency;
$r = mysql_query2("select * from currencies where iso=%s", $from);
$from_rate = mysql_fetch_object($r)->rate;
$r = mysql_query2("select * from currencies where iso=%s", $to);
$row = mysql_fetch_object($r);
$to_rate = $row->rate;
$result = $to_rate / $from_rate * $amount;
if ($print) {
$result = sprintf("%0.2f", $result);
if ($language == "DE") {
$result = str_replace(".", ",", $result);
};
$result = $row->html_symbol . $result;
};
return ($result);
}
;
function htmlentities2($str) {
return (htmlentities($str, ENT_COMPAT, "UTF-8"));
}
function geoip_country_code_by_addr($gip, $ip) {
// return $gip->lookupCountryCode ($ip);
$record = $gip->city($ip);
return $record->country->isoCode;
}
function detectLanguage($defaultlang = 'DE') {
global $gip;
$lang = "";
if (array_key_exists('HTTP_ACCEPT_LANGUAGE', $_SERVER)) {
$langlist = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);
// $lang = $defaultlang;
foreach ($langlist as $curLang) {
$curLang = explode(';', $curLang);
/* use regular expression for language detection */
if (preg_match('/(en|de)-?.*/', $curLang[0], $reg)) {
$lang = $reg[1];
break;
}
}
}
if ($lang == "") {
$country = geoip_country_code_by_addr($gip, $_SERVER["REMOTE_ADDR"]);
switch ($country) {
case "US":
case "CA":
case "UK":
case "AU":
case "NZ":
$lang = "EN";
break;
case "DE":
case "AT":
case "CH":
$lang = "DE";
break;
case "ES":
$lang = "ES";
break;
case "FR":
$lang = "FR";
break;
case "IT":
$lang = "IT";
break;
}
}
if ($lang == "") {
$lang = $defaultlang;
}
return strtoupper($lang);
}
;
function no_cache() {
header('Expires: Thu, 19 Nov 1981 08:52:00 GMT');
header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
header('Pragma: no-cache');
}
function check_captcha($captcha) {
global $err;
$captcha = strtoupper($captcha);
if (isset($_SESSION["captcha"])) {
if ($_SESSION["captcha"] != $captcha) {
$err[] = t("Zeichenfolge nicht korrekt", 0);
} else {
$_SESSION["captcha2"] = $captcha;
}
} else {
$err[] = t("Zeichenfolge nicht korrekt", 0);
}
}
function payflag($paymethod, $flag) {
$flag = mysql_real_escape_string($flag);
$r = mysql_query2("select `$flag` as flag from paymethods where id=%s", $paymethod);
$row = mysql_fetch_object($r);
return ($row->flag);
}
function check_call($telnum) {
$request = CHECK_CALL_URL . "?number=" . urlencode($telnum);
$ch = curl_init($request);
curl_setopt($ch, CURLOPT_HEADER, FALSE);
curl_setopt($ch, CURLOPT_FAILONERROR, TRUE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);
curl_setopt($ch, CURLOPT_VERBOSE, TRUE);
curl_setopt($ch, CURLOPT_TIMEOUT, 15);
$result = curl_exec($ch);
$errorMsg = curl_error($ch);
$errorNumber = curl_errno($ch);
curl_close($ch);
parse_str($result, $result_a);
if (intval($result_a["calls"]) == 0)
return (FALSE);
else
return (TRUE);
}
function paytext($paymethod, $long = 0) {
global $db, $language;
if (empty($language))
$lang = "DE";
else
$lang = $language;
if ($long)
$name = "longname_" . $lang;
else
$name = "name_" . $lang;
$r = mysql_query2("select * from paymethods where id=%s", $paymethod);
if ($row = mysql_fetch_object($r)) {
return ($row->$name);
} else {
return (FALSE);
}
}
function md5b($s) {
return (md5(MD5STR . strtolower($s)));
}
function md5cs($s) {
return (md5(MD5STR . $s));
}
$globalshortcodecount = 0;
function shortcode() {
global $globalshortcodecount;
$globalshortcodecount++;
$len = 8;
$base = 'ABCDEFGHKLMNOPQRSTWXYZabcdefghjkmnpqrstwxyz123456789';
$max = strlen($base) - 1;
$code = '';
while (strlen($code) < $len)
$code .= $base{mt_rand(0, $max)};
//if (DEVELOPMENT && ($globalshortcodecount < 5)) return (str_repeat("A", $len));
return ($code);
}
function title_select($default, $with_blank = 0) {
global $db, $language, $language_sort;
if ($with_blank) {
echo ' ";
echo "\n";
}
$r = mysql_query2("select * from titles order by order1");
while ($row = mysql_fetch_object($r)) {
if (($row->abbrev == "X") && (!$with_male_female))
continue;
echo ' id)
echo ' selected="selected"';
echo ">", addslashes($row->$language_sort);
echo "\n";
}
}
function title_translate($id, $language2 = "") {
global $db, $language;
$name = "";
if ($language2 == "")
$language2 = $language;
$language_sort = "name_" . $language2;
$r = mysql_query2("select * from titles where id=%s", $id);
if ($row = mysql_fetch_object($r)) {
if ($default == $row->id)
echo ' selected="selected"';
$name = $row->$language_sort;
}
return ($name);
}
function xml_start($gift_template = "") {
global $language;
$s = <<
EOT;
$s .= "$language \n";
$s .= "" . SITE . " \n";
$s .= <<y
n
" . href("", 0, GOOGLE_UTM, $language, "", 0) . " \n";
if ($gift_template != "")
$s .= "" . $gift_template . " ";
$s .= "\n";
return ($s);
}
function xml_end() {
global $language;
$s = <<
EOT;
return ($s);
}
function shortlink($url) {
$rows = 0;
while (!$rows) {
$code = shortcode();
mysql_query2("insert ignore into shortlinks (code, url) values (%s, %s)", $code, $url);
$r = mysql_query2("select * from shortlinks where url=%s", $url);
$rows = mysql_numrows($r);
}
return (mysql_fetch_object($r)->code);
}
class order {
public
$nr = "",
$title = "",
$firstname = "",
$lastname = "",
$company = "",
$address1 = "",
$address2 = "",
$zip = "",
$city = "",
$state = "",
$country = "",
$email = "",
$geoip_country = "",
$telnum = "",
$captcha1 = "",
$captcha2 = "",
$username = "",
$password = "",
$product = "",
$gb_max = "",
$rebills = "",
$customer = "",
$description = "",
$price1 = 0,
$days1 = 0,
$days2 = 0,
$paymethod = "",
$account = "",
$accountname = "",
$bankno = "",
$expiresm = "",
$expiresy = "",
$cvv = "",
$discountcode = "",
$hostname = "",
$referrersite = "",
$referrersite2 = "",
$kto_nicht_gepr = "",
$gb_base = "",
$language = "",
$srv1 = "",
$srv2 = "",
$srv3 = "",
$srv4 = "",
$srv5 = "",
$tokendays = "",
$affid = "",
$affprog = "",
$gift = "",
$gift_email = "",
$gift_template = "",
$gift_text = "",
$m_traffic = "",
$m_payment = "",
$m_laufzeit = "";
public function xml($isgift = FALSE) {
if ($isgift)
$xml = xml_start($this->gift_template);
else
$xml = xml_start();
$xml .= "";
if ($isgift)
$xml .= t("Herzlichen Glückwunsch!", 0);
else
$xml .= t("Herzlich willkommen!", 0);
$xml .= " ";
if ($isgift) {
$xml .= "";
if (strlen($this->firstname . $this->lastname) > 0) {
$giftname = $this->firstname . " " . $this->lastname;
} else {
$giftname = $this->email;
}
if ($this->gift_text == "")
$xml .= t("gift01", 0, $giftname) . ":";
else
$xml .= $this->gift_text;
$xml .= " " . t("An", 0) . NL . $this->firstname . " " . $this->lastname . NL .
$this->city . NL . country_name($this->country) . " " . t("txt50", 0, $this->nr) . " " . t("Sie haben folgende Leistung bestellt:", 0) . " " . t("product_descr", 0) . " " . $this->description . " ";
$xml .= "";
if ($isgift)
$xml .= t("Ein Geschenk", 0);
else
$xml .= "EUR " . money($this->price1);
$xml .= " " . t("gift02", 0, $this->gift_email) . " " . t("Ihre Zugangsdaten lauten wir folgt:", 0) . " ";
$xml .= "";
$xml .= '' . t("Benutzername", 0) . " " . full_username($this->username, $this->gb_max) . " ";
$xml .= '' . t("Passwort", 0) . " ";
if ($this->password != "")
$xml .= $this->password;
else
$xml .= t("unverändert", 0);
$xml .= " ";
$xml .= server_address_xml();
$xml .= " " . t("txt51b", 0) . " " . t("txt55", 0) . " " . t("txt59a", 0) . " " . t("txt51", 0) . " " . href("install", 1, GOOGLE_UTM, $this->language, "", 0) . " " . t("Technische Hilfe", 0) . " " . t("txt52a", 0) . " " . href("traffic", 0, GOOGLE_UTM, $this->language, "", 0) . " " . t("Kundenbereich", 0) . " " . t("txt52", 0) . " " . href("traffic", 0, GOOGLE_UTM, $this->language, "", 0) . " " . t("Kundenbereich", 0) . " " . t("test3", 0) . ": " . href("", 1, GOOGLE_UTM, $this->language, "", 0) . " " . t("Bestellen", 0) . " " . t("txt53", 0) . " " . t("txt54", 0) . " " . t("txt60", 0) . " " . t("txt61", 0) . " " . HOSTS . "/pp2/" . $this->nr . " " . t("txt58", 0) . " " . t("txt63", 0) . " " . t("txt64", 0) . " " . t("txt65", 0) . " " . t("txt66", 0) . " " . t("txt67", 0) . " " . t("Leistungsbeginn", 0) . ": " . date("Y-m-d") . " " . t("txt68", 0) . " " . t("Erfüllungsort", 0) . ": " . ADMIN_CITY . NL . t("txt70", 0) . NL . t("txt71", 0) . NL . t("txt72", 0) . " ";
$xml .= "" . href("agbs", 0, GOOGLE_UTM, $this->language, "", 0) . " " . t("AGBs", 0) . " " . t("txt73", 0) . " " . ADMIN_COMPANY . NL . ADMIN_STREET . NL . ADMIN_ZIP . " " . ADMIN_CITY . NL . "Tel.: " . ADMIN_PHONE;
if (URLAUB)
$xml .= " " . t("txt407", 0);
$xml .= NL . "Fax: " . ADMIN_FAX . NL . "E-Mail: " . SUPPORT_EMAIL . NL . "Web: http://www.simonconsulting.at" . NL .
t("Mitglied der Wirtschaftskammer Steiermark", 0) . NL . ADMIN_FN . NL . "UID: " . ADMIN_UID . NL .
t("Geschäftsführer", 0) . ": " . HERAUSGEBER . " COVID-19 Grafik Plattform Österreich - Main