Subversion-Projekte lars-tiefland.ci

Revision

Revision 1396 | Revision 1425 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1396 Revision 1424
Zeile 1307... Zeile 1307...
1307 
function getBestelllaender()
 1307 
function getBestelllaender()
1308 
{
 1308 
{
1309 
	$laender[0] = "alle";
 1309 
	$laender[0] = "alle";
1310 
	$laender[1] = "Ausland";
 1310 
	$laender[1] = "Ausland";
Zeile 1311... Zeile -...
1311 
 
 - 
 
1312 
	if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["bestellung"]["adressbuch"]))
 - 
 
1313 
	{
 - 
 
1314 
 
 1311 
 
1315 
		$countryTable = "countries co";
 - 
 
1316 
 
 - 
 
1317 
		if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
 - 
 
1318 
		{
 - 
 
1319 
			$coFeld = "co.`name-en` AS liefer_Land";
 - 
 
1320 
		}
 - 
 
1321 
		else
 - 
 
1322 
		{
 - 
 
1323 
			$coFeld = "co.`name-ger` AS liefer_Land";
 - 
 
1324 
		}
 - 
 
1325 
		$query = "SELECT
- 
 
1326 
				".$coFeld."
 - 
 
1327 
    		FROM
 - 
 
1328 
				".$countryTable."
 - 
 
1329 
    	";
 - 
 
Zeile 1330... Zeile 1312...
1330 
		$result = $GLOBALS["db_red"]->query($query);
 1312 
	$countryTable = "countries co";
1331 
 
 1313 
 
1332 
		while ($row = $result->unbuffered_row('array'))
 1314 
	if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
1333 
		{
 - 
 
1334 
			$laender[] = $row["liefer_Land"];
 1315 
	{
1335 
		}
 1316 
		$coFeld = "co.`name-en` AS liefer_Land";
1336 
	}
 1317 
	}
1337 
	else
 - 
 
1338 
	{
 - 
 
1339 
		$Laender = array(
 - 
 
1340 
			"Deutschland",
 - 
 
1341 
			"Niederlande",
 - 
 
1342 
			"Österreich",
 - 
 
1343 
			"Belgien",
 - 
 
1344 
			"Luxemburg",
 - 
 
1345 
			"Dänemark",
 - 
 
1346 
			"Schweiz",
 - 
 
1347 
			"Frankreich",
 - 
 
1348 
			"Großbritannien",
 - 
 
1349 
			"Italien",
 - 
 
1350 
			"Spanien",
 - 
 
1351 
			"Portugal",
 - 
 
1352 
			"Schweden",
 - 
 
1353 
			"Finnland",
 - 
 
1354 
			"Norwegen",
 - 
 
1355 
			"Irland",
 - 
 
1356 
			"Griechenland",
 - 
 
1357 
			"Estland",
 - 
 
1358 
			"Lettland",
 - 
 
1359 
			"Malta",
 - 
 
1360 
			"Litauen",
 - 
 
1361 
			"Polen",
 - 
 
1362 
			"Slowenien",
 - 
 
1363 
			"Slowakei",
 - 
 
1364 
			"Tschechien",
 - 
 
1365 
			"Türkei",
 - 
 
1366 
			"Ungarn",
 - 
 
1367 
			"Zypern",
 - 
 
1368 
			"Kanada",
 - 
 
1369 
			"USA",
 - 
 
1370 
			"Kroatien",
 - 
 
1371 
			"Bulgarien",
 - 
 
1372 
			"Rumänien",
 - 
 
1373 
			"Südafrika",
 - 
 
1374 
			"Japan",
 - 
 
1375 
			"China",
 - 
 
1376 
			"Singapur",
 - 
 
1377 
			"Dubai (VAE)",
 1318 
	else
1378 
			);
 1319 
	{
- 
 
 1320 
		$coFeld = "co.`name-ger` AS liefer_Land";
- 
 
 1321 
	}
- 
 
 1322 
	$query = "SELECT
- 
 
 1323 
			".$coFeld.",
- 
 
 1324 
			con.name_de kontinent
- 
 
 1325 
		FROM
- 
 
 1326 
			".$countryTable."
- 
 
 1327 
		JOIN
- 
 
 1328 
			continents con
- 
 
 1329 
		ON
- 
 
 1330 
			con.id=co.continent
Zeile -... Zeile 1331...
- 
 
 1331 
	";
- 
 
 1332 
	$result = $GLOBALS["db_red"]->query($query);
- 
 
 1333 
 
- 
 
 1334 
	while ($row = $result->unbuffered_row('array'))
1379 
		$laender = array_merge($laender, $Laender);
 1335 
	{
1380 
	}
 1336 
		$laender[$row["kontinent"]][] = $row["liefer_Land"];
Zeile 1381... Zeile 1337...
1381 
 
 1337 
	}
1382 
	return $laender;
 1338 
	return $laender;