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;