= Artikel zum Wholesale wird $lcCount = 1; //Anzahl <= Artikel zu "Last Copies" wird /** Function : dump() * Arguments : $data - the variable that must be displayed * Prints a array, an object or a scalar variable in an easy to view format. * * got this from: http://www.bin-co.com/php/scripts/dump/ */ function dump($data) { if(is_array($data)) { //If the given variable is an array, print using the print_r function. print "
-----------------------\n";
		print_r($data);
		print "-----------------------
"; } elseif (is_object($data)) { print "
==========================\n";
		var_dump($data);
		print "===========================
"; } else { print "=========> "; var_dump($data); print " <========="; } } /* **************************************************** * DB Functions **************************************************** */ /* open MySQL Socket */ function openSocket($dbHost, $dbUser, $dbPass) { $sock = mysql_connect($dbHost,$dbUser,$dbPass); return $sock; } /* close MySQL Socket */ function closeSocket($sock) { if($sock) { if(!mysql_close($sock)) { echo(mysql_error()); } } } /* check MySQL Socket */ function checkSocket($sock) { // global $sock; if(!$sock) { echo(mysql_error()); exit; } } /* open MySQL DB */ function openDB($sock, $dbName) { mysql_select_db($dbName,$sock); } /* check MySQL DB */ function checkDB($sock, $dbName) { if(!mysql_select_db($dbName,$sock)) { echo(mysql_error()); closeSocket($sock); exit; } } /* DB Abfrage mit 1 Ergebniss */ function getRowQuery($field, $table, $where, $order) { global $sock; if($order != ""){$order = " ORDER BY ".$order;} if($where != ""){$where = " WHERE ".$where;} $query = "SELECT ".$field." FROM ".$table.$where.$order.""; // echo $query; if(!($resource = mysql_query($query,$sock))) {echo(mysql_error()); mysql_close($sock); exit;} $queryRow = mysql_fetch_row($resource); $fieldArray = explode(",", $field); // printError($query,"","yellow","Query:"); // printForEach($fieldArray); $tz=0; while($tz < count($fieldArray)) { $result[$tz] = $queryRow[$tz]; // printError($result[$tz],"","#777777","Results:"); $tz++; } return $result; } /* DB Abfrage mit >1 Ergebnissen */ function getArrayQuery($field, $table, $where, $order) { global $sock; if($order != ""){$order = " ORDER BY ".$order;} if($where != ""){$where = " WHERE ".$where;} $query = "SELECT ".$field." FROM ".$table.$where.$order.""; if(!($resource = mysql_query($query,$sock))) {echo(mysql_error()); mysql_close($sock); exit;} $fieldArray = explode(",", $field); // printError($query,"","yellow"); // printForEach($fieldArray); $tx = 0; while ($queryRow = mysql_fetch_array($resource)) { $tz=0; while($tz < count($fieldArray)) { $fieldResult[$tx] = $queryRow[$fieldArray[$tz]]; $tz++; } $result[$tx] .= $fieldResult; $tx++; } return $result; } /* DB Abfrage universell * got this from: http://www.bin-co.com/php/scripts/query/ */ function getQuery($query) { if(!$query) return ""; $result = mysql_query($query) or die("MySQL Error : " . mysql_error() . "\n<br />In Query <code>$query</code>"); if(mysql_num_rows($result) == 1) { //If there is just one result, return it. $arr = mysql_fetch_assoc($result); if(count($arr) == 1) { //If there is just one result... $item = array_values($arr); return stripslashes($item[0]); // Creates the effect of 'getOne()' } else { foreach($arr as $key => $value) $arr[$key] = stripslashes($value); return $arr; // Makes the 'query()' effect } } else { $arr = array(); $primary_key = false; while ($all = mysql_fetch_row($result)) { if(count($all) == 1) array_push($arr,$all[0]); elseif(count($all) == 2) { if(!$primary_key) { //Happens only one time $meta = mysql_fetch_field($result,0); //If the first element is a primary key, make $primary_key = $meta->primary_key; // the result an associative array. } //Make it an Associative Array if there is a primary_key in the given data. if($primary_key) $arr[$all[0]] = $all[1]; else break; } else break; } if($arr) { //Do a stripslashes() on each element foreach($arr as $key => $value) $arr[$key] = stripslashes($value); return $arr; // For 'getAll()' } else { //If nothing matches... mysql_data_seek($result,0); //Reset the Query. return $result; // This results in 'getSqlHandle()' effect } } } /* open DB socket and database */ $sock = openSocket($dbHost, $dbUser, $dbPass); openDB($sock, $dbName); $lastUpdate = getRowQuery("max(updated)", "mo_zeug", "status < 2", ""); //$stuffArr = getQuery("SELECT bestNr, medium, band, title, priceSale, comment FROM mo_zeug WHERE status < 2"); $stuffQuery = "SELECT bestNr, medium, band, title, priceSale, comment, status, count FROM mo_zeug WHERE status < 2 AND count > 0 ORDER BY band ASC, title ASC"; if(!($resource = mysql_query($stuffQuery,$sock))) {echo(mysql_error()); mysql_close($sock); exit;} $row = mysql_fetch_array($resource); $tz = 0; while ($row = mysql_fetch_array ($resource)) { $bestNr[$tz] = $row[0]; $medium[$tz] = $row[1]; $band[$tz] = $row[2]; $title[$tz] = $row[3]; $priceSale[$tz] = $row[4]; $comment[$tz] = $row[5]; $status[$tz] = $row[6]; $count[$tz] = $row[7]; $priceSpecial[$tz] = number_format(round($priceSale[$tz]*(1-0.30),2), 2, ',',''); $tz++; } ?> Back To The Boots - Home Of Dirty Crunt'n'Punk - Recordlist \n"; echo "

Back To The Boots - Mailorderlist

\n"; //echo "

This List was last Updated: $lastUpdate[0]

\n"; echo "

SUPER SONDER SPEZIAL TOTAL AUSVERKAUF!!!

\n"; echo "

Ja, bin ich denn total bescheuert?! Ne, aber total blank!
Deswegen löse ich meinen Mailorder auf und ihr könnt an meinem Elend profitieren :)

"; echo "

SATTE 30% RABATT AUF ALLES!

"; echo "

Alle Preise natlich inkl MwSt und zuzüglich Versandkosten!

"; echo "

ACHTUNG DIE SUPER SONDER RABATTAKTION IST ZU ENDE, ES GELTEN WIEDER DIE NORMALEN PREISE!!!

"; //echo "

ACHTUNG AASGEIER UND WHOLESALER:

"; //echo "

Wer viel kauft (100 und mehr Teile) bekommt nochmal extra Rabatt!

"; //echo "

Wer ALLES kauft is n gemachter Mann/Frau!!!

"; echo "

Schreibt mir ne Mail für weitere Details und/oder zum bestellen an: order@bttb.de

"; echo "

Bezahlung und Spenden per Paypal an paypal@bttb.de

"; echo "

Von den Artikeln mit GRÜNEM HINTERGRUND gibts noch reichlich.

\n"; echo "

Von Artikeln mit ROTEM HINTERGRUND nur noch wenige - wer zuerst kommt...

\n"; echo "

Von den grauen irgendwas dazwischen ;)

"; ?> \n";} if($count[$tz] >= $wsCount) {echo " \n";} elseif($count[$tz] <= $lcCount) {echo " \n";} else { if($tz % 2){echo " \n";} else {echo " \n";} } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; //echo " \n"; echo " \n"; echo " \n"; $tz++; } ?>
No Band Title Medium Price Comment
$bestNr[$tz]$band[$tz]$title[$tz]$medium[$tz]$priceSale[$tz]€$priceSpecial[$tz]€$comment[$tz]
\n"; ?>