abfackeln's music directory

0) && ($f > 0)) { $query = "SELECT format_id, abbr, label FROM format"; $result = mysql_query($query, $mconn); if($result > 0) { $nr = MYSQL_numrows($result); } else { $nr = 0; } while ($nr > 0) { $nr --; $num = MYSQL_result($result, $nr, "format_id"); $format[$num] = MYSQL_result($result, $nr, "abbr"); $formatlong[$num] = MYSQL_result($result, $nr, "label"); } $query = "SELECT * FROM album WHERE album_id=$i AND format_id=$f"; $result = mysql_query($query, $mconn); if($result > 0) { $nr = MYSQL_numrows($result); } else { $nr = 0; } while ($nr > 0) { $nr --; $counter = 0; $fieldcount = MYSQL_numfields($result); while ($counter < $fieldcount) { $tmp = MYSQL_fieldname($result, $counter); ${$tmp} = MYSQL_result($result, $nr, $tmp); $counter ++; } $index = $format[$format_id] . "-" . strval($album_id); $tagdef = "width=300 bgcolor=b0d0f0"; printf("

%s\n", $index); printf("%s\n", $formatlong[$format_id]); printf("%s\n", $label); printf("%s\n", $serial); printf("

%s\n", $artist); printf("%s\n", $title); printf("(%s)\n", $year); $tracklist = ereg_replace("\n", "
\n", $tracklist); $comment = ereg_replace("\n", "
\n", $comment); $inventory = ereg_replace("\n", "
\n", $inventory); printf("

\n", $tracklist); printf("
%s%s
\n", $comment); printf("
%s\n
\n", $inventory); print("

If the information displayed here is incorrect or incomplete, please contact me by sending email to dalek242 @ranch.org

\n"); printf("

Click here to edit this item

\n", $format_id, $album_id); print("

Click here to go back

\n"); } } else { ?>

This is a personal collection and items are not available for trade.

0) { $nr = MYSQL_numrows($result); } else { $nr = 0; } while ($nr > 0) { $nr --; $num = MYSQL_result($result, $nr, "format_id"); $format[$num] = MYSQL_result($result, $nr, "abbr"); } if ($order == "numeric") $sortby = "format_id DESC, album_id DESC"; else $sortby = "artist DESC, year DESC, title DESC"; if ($showonly == "CD") { $formatstr = "(format_id = 2 OR format_id = 5) AND "; $buttons = "

CDs Only - Cassettes Only - Vinyl Only - Show All

"; } else if ($showonly == "CASS") { $formatstr = "(format_id = 4 OR format_id = 12) AND "; $buttons = "

CDs Only - Cassettes Only - Vinyl Only - Show All

"; } else if ($showonly == "VINYL") { $formatstr = "(format_id = 6 OR format_id = 7 OR format_id = 8 OR format_id = 11) AND "; $buttons = "

CDs Only - Cassettes Only - Vinyl Only - Show All

"; } else { $formatstr = ""; $buttons = "

CDs Only - Cassettes Only - Vinyl Only - Show All

"; } echo $buttons; $query = "SELECT * FROM album WHERE ".$formatstr. "format_id <> 3 AND status_id <= 1 ORDER BY ".$sortby; $result = mysql_query($query, $mconn); if($result > 0) { $nr = MYSQL_numrows($result); } else { $nr = 0; } while ($nr > 0) { $nr --; $counter = 0; $fieldcount = MYSQL_numfields($result); while ($counter < $fieldcount) { $tmp = MYSQL_fieldname($result, $counter); ${$tmp} = MYSQL_result($result, $nr, $tmp); $counter ++; } $index = $format[$format_id] . "-" . strval($album_id); if ($status_id > 1) { print "* "; } if ($year > 0) { $year = "(" . $year . ")"; } print "$index - "; print "$artist - $title $year
\n"; } /*** now, print the copied ones ***/ if (($formatstr == "") || ($formatstr == "CASS")) { echo "

Unlisted items

"; $query = "SELECT * FROM album WHERE format_id = 3 ORDER BY ".$sortby; $result = mysql_query($query, $mconn); if($result > 0) { $nr = MYSQL_numrows($result); } else { $nr = 0; } while ($nr > 0) { $nr --; $counter = 0; $fieldcount = MYSQL_numfields($result); while ($counter < $fieldcount) { $tmp = MYSQL_fieldname($result, $counter); ${$tmp} = MYSQL_result($result, $nr, $tmp); $counter ++; } $index = $format[$format_id] . "-" . strval($album_id); if ($status_id > 1) { print "* "; } if ($year > 0) { $year = "(" . $year . ")"; } print "$index - "; print "$artist - $title $year
\n"; } } /*** now, print the missing and copied ones ***/ if ($formatstr == "") ## only do this if we didnt specify something else { echo "

Missing and otherwise unlisted items

* DENOTES THAT THE ITEM IS MISSING

"; $query = "SELECT * FROM album WHERE status_id > 1 ORDER BY ".$sortby; $result = mysql_query($query, $mconn); if($result > 0) { $nr = MYSQL_numrows($result); } else { $nr = 0; } while ($nr > 0) { $nr --; $counter = 0; $fieldcount = MYSQL_numfields($result); while ($counter < $fieldcount) { $tmp = MYSQL_fieldname($result, $counter); ${$tmp} = MYSQL_result($result, $nr, $tmp); $counter ++; } $index = $format[$format_id] . "-" . strval($album_id); if ($status_id > 1) { print "* "; } if ($year > 0) { $year = "(" . $year . ")"; } print "$index - "; print "$artist - $title $year
\n"; } } } ?>
Tape Traders Network

*/ ?>