A 6460 Imst'; $wbc_firma_vertreter = ''; $wbc_firma_telefon = '0043/(0)5412/63315'; $wbc_firma_telefax = '0043/(0)5412/65211'; $wbc_firma_email = 'office@canal-keramik.com'; $wbc_firma_ustid = 'ATU32514801'; $wbc_firma_stnr = '021/6600'; $wbc_firma_hrb = 'Fn22425d'; $wbc_firma_www = 'canal-keramik.com'; $wbc_superuser = '24a6590933e889e407a347f45c392a27'; $wbc_rundungsum = 0; $wbc_sess_check = 1; $wbc_sess_loadpage = 0; $wbc_sess_timeout = 6; $wbc_vatids = Array("#2" => 20,"#3" => 10); $wbc_lc_start = 1; $wbc_cu_start = 4; $wbc_lang = Array("#1" => Array("",4,'')); $wbc_currency = Array("#4" => Array("EUR",1,1,'€',',','.'),"#72" => Array("deuro",0.5581,1,'€',',','.')); $wbc_medien = Array("Datenblatt" => Array(13,'file'),"Vorschaubild" => Array(10,'img'),"Normalbild" => Array(11,'img'),"Symbol" => Array(12,'img'),"Hersteller Logo" => Array(32,'img'),"www-Verweis" => Array(14,'urlf'),"Hersteller Link" => Array(41,'urlf')); $wbc_peh = Array("#9" => 1); $wbc_meh = Array("#35" => Array("Rolle","Rl"),"#8" => Array("Stück","STCK"),"#42" => Array("Set","Set"),"#34" => Array("Verpackungseinheit","VE")); $wbc_anrede = Array("#47" => Array("Firma","Sehr geehrte Damen und Herren"),"#17" => Array("Frau","Sehr geehrte Frau "),"#16" => Array("Herr","Sehr geehrter Herr ")); $wbc_prop_items = Array("Hersteller" => Array(18,'inf'),"Farbe" => Array(19,'sel'),"Angebot der Woche" => Array(20,'tf')); $wbc_prop_users = Array("Neukunde durch ..." => Array(22,'sel'),"Bonuskunde" => Array(21,'tf')); $wbc_prop_sales = Array(); $wbc_prop_mk = Array('ITEM' => 'MKIT','USER' => 'MKUS','SALE' => 'MKSA','SPOS' => 'MKSP'); $wbc_related_items = Array("Zubehör" => 30,"Cross-Selling" => 31); $wbc_linkgruppen = Array("Konto" => 3,"Info" => 1,"Service" => 2); $wbc_pages = Array("produktdetail.html","produktliste.html","news.html","inhalt.html","kontakt.html","pgruppen.html","nosession.html","start.html"); $wbc_sslpages = Array('willkommen.html','badresse.html','bzahlung.html','bversand.html','bkontrolle.html','bdanke.html','login.html','kontoneu.html','konto.html','kontoneudanke.html','kontodaten.html','merkliste.html','merklisteleer.html','bestelldruck.html'); ?> connID = 0; } function connect($host, $user, $passwd, $keepAlive = true, $addPara = 0){ if($keepAlive) $this->connID = mysql_pconnect($host, $user, $passwd); else $this->connID = mysql_connect($host, $user, $passwd); if( !$this->connID){ $this->setError(); return 0; } else { $this->resetError(); return 1; } } function open( $dbname ){ $ret = mysql_select_db( $dbname, $this->connID); if(!$ret){ $this->setError(); return 0; } else { $this->name = $dbname; $this->resetError(); return 1; } } function create( $dbname ){ $ret = mysql_create_db ($dbname, $this->connID); if(!$ret){ $this->setError(); return 0; } else { $this->resetError(); return 1; } } function query( $sqlquery ){ $ret = mysql_query( $sqlquery, $this->connID); if(!$ret){ $this->setError(); return 0; } else { $this->resetError(); return $ret; } } function record($query, $typ = MYSQL_ASSOC){ $aret = mysql_fetch_array ($query,$typ); return $aret; } function value($query){ $aret = mysql_fetch_row($query); if( count($aret)>0) return $aret[0]; else return 0; } function recordcount($query){ $aret = mysql_num_rows ($query); return $aret; } function rowcount(){ $aret = mysql_affected_rows(); return $aret; } function go($query, $record){ return @mysql_data_seek($query, $record); } function clearquery($query){ mysql_free_result ($query); } function escape_string( $val ){ return mysql_escape_string( $val ); } function getTables(){ $tables = array(); $ret = mysql_list_tables( $this->name, $this->connID); if(!$ret){ $this->setError(); } else { $this->resetError(); $i = 0; while ($i < mysql_num_rows ($ret)) { $tables[$i] = mysql_tablename ($ret, $i); $i++; } } return $tables; } function getFields($tblname){ $fields = array(); $ret = mysql_list_fields( $this->name, $tblname, $this->connID); if(!$ret){ $this->setError(); } else { $this->resetError(); $i = 0; while ($i < mysql_num_fields ($ret)) { $fields[mysql_field_name($ret, $i)] = Array("type" => strtolower(mysql_field_type($ret, $i)), "len" => mysql_field_len($ret, $i),"flags" => mysql_field_flags($ret, $i)); $i++; } } return $fields; } function getIndexes($tblname){ $indexes = array(); $ret = mysql_query( "SHOW INDEX from " . $tblname, $this->connID); if(!$ret){ $this->setError(); } else { $this->resetError(); while ($row = mysql_fetch_array ($ret)) { if( $indexes[$row["Key_name"]] ) { $indexes[$row["Key_name"]][$row["Column_name"]] = array("columnpos" => $row["Seq_in_index"], "order" => $row["Collation"],"len" => $row["Sub_part"]); } else { $indexes[$row["Key_name"]] = array($row["Column_name"] => array("columnpos" => $row["Seq_in_index"], "order" => $row["Collation"],"len" => $row["Sub_part"])); } } mysql_free_result ($ret); } return $indexes; } function addTable($tblname, $aFields){ $strQuery = "CREATE TABLE " . $tblname . " ("; $bFirstEntry = true; while (list($fldname, $flddef) = each($aFields)){ if(!$bFirstEntry) $strQuery .= ", " ; else $bFirstEntry = false; $strQuery .= $fldname . " " . $flddef; } $strQuery .= ")"; return $this->query( $strQuery ); } function convDate($cdate, $cformat){ $ret = $this->query("SELECT DATE_FORMAT('" . $cdate . "', '" . mysql_escape_string($cformat) . "')"); $res = mysql_result($ret,0); return $res; } function deleteTable( $tblname ){ $strQuery = "DROP TABLE " . $tblname; return $this->query( $strQuery ); } function lastInsertID(){ return mysql_insert_id($this->connID); } function timestamp(){ return "now()+0"; } function lastError(){ if( !$this->errNo ) return ""; else return "DB Error: [" . $this->errNo . "] " . $this->errInfo; } function setError(){ $this->errNo = mysql_errno(); $this->errInfo = mysql_error(); } function resetError(){ $this->errNo = 0; $this->errInfo = ""; } function genSQLUpdate($bNew, $adef = Array(), $fp){ $queryFields = ""; $queryValues = ""; reset($fp); reset($adef); while (list($tag, $val) = each($adef)){ if(!array_key_exists($tag,$fp)) $fp[$tag] = $val; } $i = 0; reset($fp); while (list($tag, $val) = each($fp)){ $bQuote = 1; $afld = explode(":",$tag); if( count($afld) > 1 ){ switch( $afld[1] ){ case "nohtml": $tag = $afld[0]; break; case "int": $bQuote = 0; $tag = $afld[0]; $val = (int) $val; break; case "num": $bQuote = 0; $tag = $afld[0]; $val = (double) $val; break; case "sql": $bQuote = 0; $tag = $afld[0]; break; case "wrg": $bQuote = 0; $tag = $afld[0]; $val = (double) $val; break; case "datum": $tag = $afld[0]; $val = ereg_replace("([0-9]+)\.([0-9]+)\.([0-9]+)","\\3\\2\\1",$val); } } if( $i ){ $queryFields .= ", "; $queryValues .= ", "; } if( $bNew ){ $queryFields .= $tag; $queryValues .= ($bQuote) ? "'" . mysql_escape_string( $val ). "'" : $val; } else { $queryFields .= $tag."="; $queryFields .= ($bQuote) ? "'" . mysql_escape_string( $val ) . "'" : $val; } $i ++; } if( $bNew ) return "(".$queryFields.") values(".$queryValues.")"; else return $queryFields; } } ?>