|
// ab hier die Bildertags und alles andere per Zufall reinstellen
// Daten holen
$FIELDCOLS = 10;
$FIELDSCOUNT = $FIELDCOLS * $FIELDLINES; // Anzahl der Felder
$abfrage="select titel, bildname1 from inhalte where kat1 = '1' AND region$region='1'";
$ergebnis = mysql_db_query ($database,$abfrage) or die (mysql_error());
$anzahl = mysql_num_rows ( $ergebnis );
$redfields = 7;
$whitefields = 9;
srand(microtime()*1000000);
for ( $i = 1; $i < $FIELDSCOUNT + 1; $i++ ) {
$feld[$i] = '';
}
for ( $i = 1; $i < $anzahl+1; $i++ ) {
$ok = 0;
do {
$zufall = rand(1,$FIELDSCOUNT);
if ($feld[$zufall] == '') {
$row = mysql_fetch_array ( $ergebnis );
$feld[$zufall] = $row["bildname1"];
$names[$zufall] = $row["titel"];
$modname = preg_replace("/(.+) (\w+)/i","$2 $1",$row["titel"]);
$alpha["$modname"] = $row["bildname1"];
// print $modname . " + " . $row["bildname1"] . " ";
//$alpha[$row["bildname1"]] = preg_replace("/(.+) (\w+)/i","$2 $1",$row["titel"]);
$ok = 1;
}
} while ( $ok == 0 );
}
for ( $i = 1; $i < $redfields+1; $i++ ) {
$ok = 0;
do {
$zufall = rand(1,$FIELDSCOUNT);
if ($feld[$zufall] == '') {
$feld[$zufall] = "region$region.gif";
$ok = 1;
}
} while ( $ok == 0 );
}
for ( $i = 1; $i < $whitefields+1; $i++ ) {
$ok = 0;
do {
$zufall = rand(1,$FIELDSCOUNT);
if ($feld[$zufall] == '') {
$feld[$zufall] = 'white.gif';
$ok = 1;
}
} while ( $ok == 0 );
}
$content = '' . "\n";
for ( $i = 0; $i < $FIELDLINES; $i++ ) {
$content .= "\n";
for ( $j = 0; $j < $FIELDCOLS; $j++ ) {
if ( $feld[$j+($i*$FIELDCOLS)+1] != '' ) {
if ( $feld[$j+($i*10)+1] == "region$region.gif" || $feld[$j+($i*$FIELDCOLS)+1] == 'white.gif' ) {
$content .= '+1] .') | ';
} else {
$vari = $j+($i*$FIELDCOLS)+1;
$content .=
"![\"".$names[$vari]."\" \"".$names[$vari]."\"](\"/daten/images/bw/".$feld[$vari]."\") | ";
}
} else {
$content .= " | \n";
}
}
$content .= " \n";
}
$content .= ' ';
print $content;
?>
|
include('container.php');?>