//show_designs
//Zuletzt geaendert: 16.07.2016
//----------------------------------------------------------------------------------------
//Variablen
$mniz = 3; //maximum nummer in zeile
$th_width = 560;
$th_height = 760;
$img_width = "280px";
$img_height = "380px";
//Einstellungen & Funktionen
include('../scripts/adm_setup.php');
include('../scripts/adm_functions.php');
//Tabellen
$tbl_design_sets = $db_prefix."_hwdesign_sets";
//----------------------------------------------------------------------------------------
//Scripts
?>
//---------------------------------------------------------------------------------------------------------
//Tabs aus den Kategorien von designs-Domain
mysql_select_db($design_db, mysql_connect($design_server, $design_usr, $design_pw));
mysql_query("set names 'utf8';");
$sql = "SELECT * FROM $tbl_design_sets GROUP BY design_set_kat ORDER BY design_set_kat";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
echo "
"; $result = mysql_query($sql); $num = mysql_num_rows($result); for ($k=0; $k<$num; $k++) { $row = mysql_fetch_array($result); $t = $k +1; echo "
";
}
include("db_connect.php");
//----------------------------------------------------------------------------------------
?>
- ";
for ($i=0; $i<$num; $i++) {
$row = mysql_fetch_array($result);
$t = $i + 1;
echo "
- $row[design_set_kat] "; } echo "
"; $result = mysql_query($sql); $num = mysql_num_rows($result); for ($k=0; $k<$num; $k++) { $row = mysql_fetch_array($result); $t = $k +1; echo "
";
$sql = "SELECT * FROM $tbl_design_sets WHERE design_set_kat='$row[design_set_kat]' ORDER BY design_set_name";
$result_d = mysql_query($sql);
$num_d = mysql_num_rows($result_d);
for ($d=0; $d<$num_d; $d++) {
$row_d = mysql_fetch_array($result_d);
$design_set_id = $row_d['design_set_id'];
$design_set_img = $design_domain."/designs/".$row_d['design_set_folder']."/screenshot.jpg";
$img_html = "";
$img_html.= " ";
if ($row_d['design_set_desc']!="") { $design_set_desc = $row_d['design_set_desc']; } else { $design_set_desc = "ohne"; }
if (($d+1)%3==0) {
$lastUnit = "lastUnit pbottom10";
$size = "";
$br = "";
} else {
$lastUnit = "";
$size = "size33";
$br = "border-right:1px solid #aaa;";
}
echo "
";
if (($d+1)%3==0) {
echo "
$row_d[design_set_name]
$img_html
";
}
}
echo "