<?php
require 'app/sequencer.php';
$autoplay = 0;
if (isset($_GET['random'])) {
$id = db_result(db_query('SELECT id FROM sequences WHERE deleted=0 AND scale>=0 AND LENGTH(data) > 500 ORDER BY RAND() LIMIT 1'), 0);
$autoplay = 1;
}
if ($id != 0) {
$result = db_query('SELECT * FROM sequences WHERE deleted=0 AND id="' . e_mysql($id) . '" LIMIT 1');
if (mysqli_num_rows($result) == 0) {
output_message('Error', 'Unknown sequence: ' . e_html($id));
exit;
}
$row = mysqli_fetch_array($result);
$title = formatSequenceTitle($row);
$nav_right = formatSequenceInfo($row);
}
if ($id != 0) {
$cname = $id;
}
if ($id == 0) {
$showFeatured = true;
}
output_header($id == 0 ? 'Make music online' : $title, false, $id);
?>
<style type="text/css">
#main {
bottom: 0;
}
</style>
mod("form");
$gp = pager_init(66);
$searchform = form_create('Search', 'inline', null, 'get');
form_add_param($searchform, 'Value', 'search', 'string', '', 100, 12);
$search = p_string('search');
$basedon = p_int('basedon', 0);
$sort = p_string('sort', 1);
$date = p_string('date', empty($search) ? 1 : 4);
if (isset($_GET['deleted'])) {
$where = ' WHERE deleted=1 ';
} else {
if ($basedon) {
$where = ' WHERE basedon="' . $basedon . '" ';
} else {
if (!empty($_GET["search"])) {
$where = ' WHERE deleted=0 AND MATCH(title) AGAINST("%' . e_mysql($search) . '%") ';
} else {
$where = ' WHERE deleted=0 ';
}
}
}
switch ($sort) {
case 2:
$order = "accesscount DESC";
break;
case 4:
$order = "RAND()";
break;
case 3:
$order = "datalength DESC";
break;
