[Instructions]
[Go to player]
[Return]
');
}
// Login form
function showLoginPage() {
return '';
}
// Logout
function logoutRequest() {
setcookie('bytebeat_access', '', time() - 3600, '/');
unset($_COOKIE['atom_access']);
$_SESSION['bytebeat'] = '';
session_destroy();
die('');
}
// Management panel
function managementRequest() {
return '';
}
// Generating the form for adding/editing a song to the database
function addSongForm() {
return '';
}
// Generating the form to edit a song in the database
function editSongForm() {
$dbLink = getDBLink();
if (!isset($_GET['hash'])) {
return 'Song with hash = "" not found!';
}
$hash = $_GET['hash'];
// Get a song by hash from the database
$songs = mysqli_query($dbLink,
'SELECT * FROM `songs`
WHERE `hash` = "' . $hash . '" LIMIT 1;');
if (mysqli_num_rows($songs) === 0) {
return 'Song with hash = "' . $hash . '" not found!';
}
while ($song = mysqli_fetch_assoc($songs)) {
// Make URL fields
$urlStr = '';
$url = $song['url'];
if (isset($url) && str_starts_with($url, '["')) {
$urlArr = json_decode($url);
if (json_last_error() === JSON_ERROR_NONE && is_array($urlArr)) {
foreach ($urlArr as $url_) {
$urlStr .= '
';
}
}
} else {
$urlStr .= '
';
}
// Make tags fields
$tagsStr = '';
$tags = json_decode($song['tags']);
if (json_last_error() === JSON_ERROR_NONE && is_array($tags)) {
foreach ($tags as $tag) {
$tagsStr .= '
';
}
}
// Find if the song is a remix then get sources hashes
$remixStr = '';
$remixResult = mysqli_query($dbLink,
'SELECT * FROM `remixes`
WHERE `song` = "' . $hash . '";');
if (mysqli_num_rows($remixResult) !== 0) {
while ($remixSource = mysqli_fetch_assoc($remixResult)) {
$remixStr .= '
';
}
} else {
$remixStr = '
';
}
// Parsing the drawing mode
$drawing_mode = '';
if (isset($song['drawing'])) {
$drawing = json_decode($song['drawing']);
if (json_last_error() === JSON_ERROR_NONE) {
$drawing_mode = $drawing->mode;
$drawing_scale = $drawing->scale;
}
}
// Form generation
return '';
}
}
// Copy songs from library files into 'songs' and 'remixes' database tables
function decodeLibraryFile($dbLink, $libName) {
$songsPath = './data/songs/';
$libFileName = './data/library/' . $libName . '.gz';
// Check for a valid JSON string from GZIP file and get an array of songs
if (!file_exists($libFileName)) {
fancyDie('File "' . $libFileName . '" does not exist.');
}
$songssArr = json_decode(gzdecode(file_get_contents($libFileName)));
if (json_last_error() !== JSON_ERROR_NONE) {
fancyDie('File "' . $libFileName . '" has an error: ' . json_last_error_msg());
}
// Write each song into database
foreach ($songssArr as $authorObj) {
$author = $authorObj->author;
$songs = $authorObj->songs;
foreach ($songs as $song) {
$url = isset($song->url) ?
(is_array($song->url) ? '["' . implode('","', $song->url) . '"]' : $song->url) : NULL;
$codeOriginal = isset($song->code) ? $song->code : (isset($song->fileOrig) ?
file_get_contents($songsPath . 'original/' . $song->hash . '.js') : NULL);
$codeMinified = isset($song->codeMin) ? $song->codeMin : (isset($song->fileMin) ?
file_get_contents($songsPath . 'minified/' . $song->hash . '.js') : NULL);
$codeFormatted = isset($song->fileForm) ?
file_get_contents($songsPath . 'formatted/' . $song->hash . '.js') : NULL;
// Write each song into 'songs' database table
mysqli_query($dbLink, 'INSERT INTO `songs` (hash' .
($author !== '' ? ', author' : '') .
(isset($song->name) ? ', name' : '') .
(isset($song->description) ? ', description' : '') .
(isset($url) ? ', url' : '') .
(isset($song->date) ? ', date' : '') .
', mode, samplerate' .
(isset($song->stereo) ? ', stereo' : '') .
(isset($codeOriginal) ? ', code' : '') .
(isset($codeMinified) ? ', code_minified' : '') . '' .
(isset($codeFormatted) ? ', code_formatted' : '') .
(isset($song->coverName) ? ', cover_name' : '') .
(isset($song->coverUrl) ? ', cover_url' : '') .
(isset($song->drawing) ? ', drawing' : '') .
', tags' .
(isset($song->rating) ? ', rating' : '') .
# (isset($song->user_added) ? ', user_added' : '') .
(isset($song->date_added) ? ', date_added' : '') .
# (isset($song->user_edited) ? ', user_edited' : '') .
(isset($song->date_edited) ? ', date_edited' : '') .
') VALUES ("' . $song->hash . '"' .
($author !== '' ? ', "' . addslashes($author) . '"' : '') .
(isset($song->name) ? ', "' . addslashes($song->name) . '"' : '') .
(isset($song->description) ? ', "' . addslashes($song->description) . '"' : '') .
(isset($url) ? ', "' . addslashes($url) . '"' : '') .
(isset($song->date) ? ', "' . $song->date . '"' : '') .
', "' . (isset($song->mode) ? $song->mode : 'Bytebeat') . '"' .
', ' . (isset($song->sampleRate) ? $song->sampleRate : 8000) .
(isset($song->stereo) ? ', 1' : '') .
(isset($codeOriginal) ? ', "' . addslashes($codeOriginal) . '"' : '') .
(isset($codeMinified) ? ', "' . addslashes($codeMinified) . '"' : '') .
(isset($codeFormatted) ? ', "' . addslashes($codeFormatted) . '"' : '') .
(isset($song->coverName) ? ', "' . addslashes($song->coverName) . '"' : '') .
(isset($song->coverUrl) ? ', "' . $song->coverUrl . '"' : '') .
(isset($song->drawing) ? ', "{\"mode\": \"' . $song->drawing->mode . '\", \"scale\": ' .
$song->drawing->scale . '}"' : '') .
', "' . addslashes('["' . implode('","', $song->tags) . '"]') . '"' .
(isset($song->rating) ? ', ' . $song->rating : '') .
# (isset($song->user_added) ? ', "' . addslashes($song->user_added) . '"' : '') .
(isset($song->date_added) ? ', "' . $song->date_added . '"' : '') .
# (isset($song->user_edited) ? ', "' . addslashes($song->user_edited) . '"' : '') .
(isset($song->date_edited) ? ', "' . $song->date_edited . '"' : '') .
');');
// Find remixes of songs and write to 'remixes' database table
if (isset($song->remix)) {
$remixes = $song->remix;
foreach ($remixes as $remix) {
mysqli_query($dbLink,
'INSERT INTO `remixes` (song, source)
VALUES ("' . $song->hash . '", "' . $remix->hash . '");');
}
}
}
}
}
// Access to the database
function getDBLink() {
if (!function_exists('mysqli_connect')) {
fancyDie('MySQLi library is not installed');
}
$dbLink = @mysqli_connect(BYTEBEAT_DBHOST, BYTEBEAT_DBUSERNAME, BYTEBEAT_DBPASSWORD, BYTEBEAT_DBNAME);
if (!$dbLink) {
fancyDie('Could not connect to database: ' . (is_object($dbLink) ? mysqli_error($dbLink) :
(($dbLinkError = mysqli_connect_error()) ? $dbLinkError : '(unknown error)')));
}
return $dbLink;
}
// Copy songs from library files into the database
function filesToDatabase() {
$message = '';
$dbLink = getDBLink();
// Create new databsaes if not exist
if (mysqli_num_rows(mysqli_query($dbLink, 'SHOW TABLES LIKE "songs";')) === 0) {
mysqli_query($dbLink,
'CREATE TABLE songs (
`id` INT(10) UNSIGNED auto_increment NOT NULL,
`hash` CHAR(32) NULL,
`author` TEXT NULL,
`name` VARCHAR(255) NULL,
`description` TEXT NULL,
`url` TEXT NULL,
`date` VARCHAR(10) NULL,
`mode` VARCHAR(20) NULL,
`samplerate` DOUBLE NULL,
`stereo` BOOL NULL,
`code` MEDIUMTEXT NULL,
`code_minified` TEXT NULL,
`code_formatted` MEDIUMTEXT NULL,
`cover_name` VARCHAR(255) NULL,
`cover_url` TEXT NULL,
`drawing` VARCHAR(50) NULL,
`tags` VARCHAR(255) NULL,
`rating` CHAR NULL,
`user_added` VARCHAR(255) NULL,
`date_added` VARCHAR(10) NULL,
`user_edited` VARCHAR(255) NULL,
`date_edited` VARCHAR(10) NULL,
PRIMARY KEY (id),
KEY `hash` (hash)
)
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;');
mysqli_query($dbLink,
'CREATE TABLE remixes (
`id` INT(10) UNSIGNED auto_increment NOT NULL,
`song` CHAR(32) NOT NULL,
`source` CHAR(32) NOT NULL,
PRIMARY KEY (id)
)
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;');
$message .= 'Database tables `songs` and `remixes` created. ';
} else {
// Clear existed tables
mysqli_query($dbLink, 'TRUNCATE TABLE songs;');
mysqli_query($dbLink, 'TRUNCATE TABLE remixes;');
$message .= 'Database tables `songs` and `remixes` are cleared. ';
}
// Copy songs from library files into 'songs' and 'remixes' database tables
decodeLibraryFile($dbLink, 'all');
$message .= 'Libraries are copied into the `songs` and `remixes` database tables. ';
mysqli_close($dbLink);
return $message . 'Success!';
}
// Create gzipped JSON file on query from database
function makeLibraryFile($fileName, $songsByHash, $qResult) {
$songsArr = array();
// Group songs by authors into arrays
while ($song = mysqli_fetch_assoc($qResult)) {
if (isset($song['author'])) {
$songsArr[$song['author']][] = $song['hash'];
} else {
$songsArr[''][] = $song['hash'];
}
}
// Make JSON string
$outputStr = '';
foreach ($songsArr as $author => $hashes) {
$songsStr = '';
foreach ($hashes as $hash) {
$songsStr .= ($songsStr ? ',' : '') . $songsByHash[$hash];
}
// Making an object for author and all of his songs
$outputStr .= ($outputStr ? ',' : '') .
'{"author":' . json_encode($author) . ',"songs":[' . $songsStr . ']}';
}
// Compress the JSON string into the GZIP file
file_put_contents($fileName, gzencode('[' . $outputStr . ']'));
}
// Making gzipped JSON libraries and big-js songs files from database
function databaseToFiles() {
$message = '';
$dbLink = getDBLink();
$pathLibrary = './data/library/';
$pathOriginal = './data/songs/original/';
$pathMinified = './data/songs/minified/';
$pathFormatted = './data/songs/formatted/';
// Create/clear folders for large songs
if (!is_dir($pathOriginal)) {
mkdir($pathOriginal, 0755, true);
$message .= '"' . $pathOriginal . '" folder created. ';
} else {
array_map('unlink', glob($pathOriginal . '/*.*'));
}
if (!is_dir($pathMinified)) {
mkdir($pathMinified, 0755, true);
$message .= '"' . $pathMinified . '" folder created. ';
} else {
array_map('unlink', glob($pathMinified . '/*.*'));
}
if (!is_dir($pathFormatted)) {
mkdir($pathFormatted, 0755, true);
$message .= '"' . $pathFormatted . '" folder created. ';
} else {
array_map('unlink', glob($pathFormatted . '/*.*'));
}
// Get songs from database
$qResult = mysqli_query($dbLink,
'SELECT
`hash`,
`author`,
`name`,
`description`,
`url`,
`date`,
`mode`,
`samplerate`,
`stereo`,
`code`,
`code_minified`,
`code_formatted`,
`cover_name`,
`cover_url`,
`drawing`,
`tags`,
`rating`,
`user_added`,
`date_added`,
`user_edited`,
`date_edited`
FROM songs ORDER BY `author`, `date`, `id`;');
// Create a json string for each song and put it into an associative array by hash
$songsByHash = array();
while ($song = mysqli_fetch_assoc($qResult)) {
$fileMin = 0;
$fileOrig = 0;
$fileForm = 0;
if (isset($song['code_minified']) && mb_strlen($song['code_minified']) > 1024) {
// Save big minified code into file
file_put_contents($pathMinified . $song['hash'] . '.js', $song['code_minified']);
$fileMin = 1;
}
if (isset($song['code']) &&
(substr_count($song['code'], PHP_EOL) > 4 || mb_strlen($song['code']) > 1024)
) {
// Save big original code into file
file_put_contents($pathOriginal . $song['hash'] . '.js', $song['code']);
$fileOrig = 1;
}
if (isset($song['code_formatted'])) {
// Save formatted code into file
file_put_contents($pathFormatted . $song['hash'] . '.js', $song['code_formatted']);
$fileForm = 1;
}
// Finding remixes
$remixStr = '';
$sourcesArr = array();
$qSources = mysqli_query($dbLink,
'SELECT `source` FROM remixes
WHERE `song` = "' . $song['hash'] . '";');
if (mysqli_num_rows($qSources) !== 0) {
while ($source = mysqli_fetch_assoc($qSources)) {
$sourcesArr[] = $source['source'];
}
}
// Finding sources for remixes
foreach ($sourcesArr as $sourceHash) {
$qSource = mysqli_query($dbLink,
'SELECT `author`, `name`, `url` FROM songs
WHERE `hash` = "' . $sourceHash . '";');
if (mysqli_num_rows($qSource) !== 0) {
while ($source = mysqli_fetch_assoc($qSource)) {
$remixStr .= ($remixStr ? ',' : '') . '{"hash":"' . $sourceHash . '"' .
(isset($source['author']) ? ', "author":' . json_encode($source['author']) : '') .
(isset($source['name']) ? ', "name":' . json_encode($source['name']) : '') .
(isset($source['url']) ? ', "url":' . json_encode($source['url']) : '') . '}';
}
}
}
// Making a json string for a song
$songsByHash[$song['hash']] = '{"hash":"' . $song['hash'] . '"' .
(isset($song['name']) ? ',"name":' . json_encode($song['name']) : '') .
(isset($song['description']) ? ',"description":' . json_encode($song['description']) : '') .
(isset($song['url']) ? ',"url":' . (str_starts_with($song['url'], '[') ?
$song['url'] : '"' . $song['url'] . '"') : '') .
(isset($song['date']) ? ',"date":"' . $song['date'] . '"' : '') .
($song['mode'] !== 'Bytebeat' ? ',"mode":"' . $song['mode'] . '"' : '') .
',"sampleRate":' . $song['samplerate'] .
(isset($song['stereo']) ? ',"stereo":1' : '') .
($fileOrig ? ',"fileOrig":1' :
(isset($song['code']) ? ',"code":' . json_encode($song['code']) : '')) .
(isset($song['code']) ? ',"codeLen":' . strlen($song['code']) : '') .
($fileMin ? ',"fileMin":1' : (isset($song['code_minified']) ?
',"codeMin":' . json_encode($song['code_minified']) : '')) .
(isset($song['code_minified']) ? ',"codeMinLen":' . strlen($song['code_minified']): '') .
($fileForm ? ',"fileForm":1,"codeFormLen":' . strlen($song['code_formatted']) : '') .
($remixStr ? ',"remix":[' . $remixStr . ']' : '') .
(isset($song['cover_name']) ? ',"coverName":' . json_encode($song['cover_name']) : '') .
(isset($song['cover_url']) ? ',"coverUrl":"' . $song['cover_url'] . '"' : '') .
(isset($song['drawing']) ? ',"drawing":' . $song['drawing'] : '') .
(isset($song['tags']) ? ',"tags":' . $song['tags'] : '') .
(isset($song['rating']) ? ',"rating":' . $song['rating'] : '') .
# (isset($song['user_added']) ? ',"user_added": "' . $song['user_added'] . '"' : '') .
(isset($song['date_added']) ? ',"date_added": "' . $song['date_added'] . '"' : '') .
# (isset($song['user_edited']) ? ',"user_edited": "' . $song['user_edited'] . '"' : '') .
(isset($song['date_edited']) ? ',"date_edited": "' . $song['date_edited'] . '"' : '') .
'}';
}
// Create/clear folder for library files
if (!is_dir($pathLibrary)) {
mkdir($pathLibrary, 0755, true);
$message .= '"' . $pathLibrary . '" folder created. ';
} else {
array_map('unlink', glob($pathLibrary . '/*.*'));
}
// Library file with all songs sorted by authors
$fileName = $pathLibrary . 'all.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
'SELECT `hash`, `author` FROM songs
ORDER BY `author`, `date`, `id`;'));
// Library file with recently added songs sorted by authors
$fileName = $pathLibrary . 'recent.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
'SELECT `hash`, `author` FROM songs
WHERE `date_added` IS NOT NULL
ORDER BY `author`, `date`, `id`;'));
// Library file with c-compatible songs
$fileName = $pathLibrary . 'classic.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
"SELECT `hash`, `author` FROM songs
WHERE `tags` LIKE '%\"c\"%'
ORDER BY `date`, `author`, `id`;"));
// Library file with JS songs under 256b
$fileName = $pathLibrary . 'js-256.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
"SELECT `hash`, `author` FROM songs
WHERE (`mode` = 'Bytebeat' OR `mode` = 'Signed Bytebeat')
AND `tags` LIKE '%\"256\"%'
AND `tags` NOT LIKE '%\"c\"%'
ORDER BY `date`, `author`, `id`;"));
// Library file with JS songs under 1k
$fileName = $pathLibrary . 'js-1k.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
"SELECT `hash`, `author` FROM songs
WHERE (`mode` = 'Bytebeat' OR `mode` = 'Signed Bytebeat')
AND `tags` LIKE '%\"1k\"%'
AND `tags` NOT LIKE '%\"c\"%'
ORDER BY `date`, `author`, `id`;"));
// Library file with big JS songs
$fileName = $pathLibrary . 'js-big.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
"SELECT `hash`, `author` FROM songs
WHERE (`mode` = 'Bytebeat' OR `mode` = 'Signed Bytebeat')
AND `tags` NOT LIKE '%\"256\"%'
AND `tags` NOT LIKE '%\"1k\"%'
AND `tags` NOT LIKE '%\"c\"%'
ORDER BY `date`, `author`, `id`;"));
// Library file with Floatbeat mode songs
$fileName = $pathLibrary . 'floatbeat.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
"SELECT `hash`, `author` FROM songs
WHERE `mode` = 'Floatbeat'
AND `tags` NOT LIKE '%\"big\"%'
ORDER BY `date`, `author`, `id`;"));
// Library file with Floatbeat mode songs
$fileName = $pathLibrary . 'floatbeat-big.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
"SELECT `hash`, `author` FROM songs
WHERE `mode` = 'Floatbeat'
AND `tags` NOT LIKE '%\"256\"%'
AND `tags` NOT LIKE '%\"1k\"%'
ORDER BY `date`, `author`, `id`;"));
// Library file with Funcbeat mode songs
$fileName = $pathLibrary . 'funcbeat.gz';
makeLibraryFile($fileName, $songsByHash, mysqli_query($dbLink,
'SELECT `hash`, `author` FROM songs
WHERE `mode` = "Funcbeat"
ORDER BY `date`, `author`, `id`;'));
mysqli_close($dbLink);
return $message . '"' . $pathLibrary . '*.gz" files created. Success!';
}
// Request to add a song to the database
function addSong($isEdit) {
global $bytebeat_admins;
$dbLink = getDBLink();
$hash = $isEdit ? $_POST['hash'] : bin2hex(random_bytes(16));
$author = addslashes(trim($_POST['author']));
$name = addslashes(trim($_POST['name']));
$description = addslashes(trim($_POST['description']));
$url = array_filter($_POST['url']);
$ulrStr = $url && array_key_exists(0, $url) ?
addslashes(count($url) > 1 ? '["' . implode('","', $url) . '"]' : trim($url[0])) : NULL;
$date = trim($_POST['date']);
$mode = $_POST['mode'];
$sampleRate = trim($_POST['samplerate']);
$sampleRate = $sampleRate && is_numeric($sampleRate) ? $sampleRate : 8000;
$code = str_replace("\r", '', addslashes($_POST['code']));;
$codeMinified = str_replace("\r", '', addslashes($_POST['code_minified']));
$codeFormatted = str_replace("\r", '', addslashes($_POST['code_formatted']));
$coverName = addslashes(trim($_POST['cover_name']));
$coverUrl = addslashes(trim($_POST['cover_url']));
$rating = $_POST['rating'];
$user = addslashes(array_search($_SESSION['bytebeat'], $bytebeat_admins, true));
$dateEdited = date('Y-m-d');
// Drawing
$drawingMode = $_POST['drawing_mode'];
$drawingScale = trim($_POST['drawing_scale']);
$drawingScale = isset($drawingScale) && is_numeric($drawingScale) ? $drawingScale : NULL;
$drawing = $drawingMode || isset($drawingScale) ? addslashes('{' .
($drawingMode ? '"mode":"' . $drawingMode . '"' : '') .
(isset($drawingScale) ? ($drawingMode ? ',' : '') . '"scale":"' . $drawingScale . '"' : '') .
'}') : '';
// Set tags field
$tagsArr = array();
$codeLen = $_POST['code'] ? strlen($_POST['code']) :
($_POST['code_formatted'] ? strlen($_POST['code_formatted']) :
($_POST['code_minified'] ? strlen($_POST['code_minified']) : 0));
if ($codeLen) {
if ($codeLen <= 256) {
$tagsArr[] = '256';
} else if ($codeLen <= 1024) {
$tagsArr[] = '1k';
} else {
$tagsArr[] = 'big';
}
}
$tags = array_filter($_POST['tags']);
if ($tags) {
foreach ($tags as $tag) {
$tagsArr[] = $tag;
}
}
$tagsStr = addslashes('["' . implode('","', array_unique($tagsArr)) . '"]');
if ($isEdit) {
// Update existed song
mysqli_query($dbLink, 'UPDATE `songs` SET
`hash` = "' . $hash . '"' .
', `author` = ' . ($author ? '"' . $author . '"': 'NULL') .
', `name` = ' . ($name ? '"' . $name . '"' : 'NULL') .
', `description` = ' . ($description ? '"' . $description . '"' : 'NULL') .
', `url` = ' . ($ulrStr ? '"' . $ulrStr . '"' : 'NULL') .
', `date` = ' . ($date ? '"' . $date . '"' : 'NULL') .
', `mode` = "' . $mode . '"' .
', `sampleRate` = ' . $sampleRate .
', `stereo` = ' . (isset($_POST['stereo']) ? 1 : 'NULL') .
', `code` = ' . ($code ? '"' . $code . '"' : 'NULL') .
', `code_minified` = ' . ($codeMinified ? '"' . $codeMinified . '"' : 'NULL') .
', `code_formatted` = ' . ($codeFormatted ? '"' . $codeFormatted . '"' : 'NULL') .
', `cover_name` = ' . ($coverName ? '"' . $coverName . '"' : 'NULL') .
', `cover_url` = ' . ($coverUrl ? '"' . $coverUrl . '"' : 'NULL') .
', `drawing` = ' . ($drawing ? '"' . $drawing . '"' : 'NULL') .
', `tags` = "' . $tagsStr . '"' .
', `rating` = ' . ($rating ? $rating : 'NULL') .
', `user_edited` = "' . $user . '"' .
', `date_edited` = "' . $dateEdited . '"
WHERE `hash` = "' . $hash . '";');
} else {
// Adding a new song
mysqli_query($dbLink, 'INSERT INTO `songs` (' .
'`hash`' .
($author ? ', `author`' : '') .
($name ? ', `name`' : '') .
($description ? ', `description`' : '') .
($ulrStr ? ', `url`' : '') .
($date ? ', `date`' : '') .
', `mode`, `samplerate`' .
(isset($_POST['stereo']) ? ', `stereo`' : '') .
($code ? ', `code`' : '') .
($codeMinified ? ', `code_minified`' : '') . '' .
($codeFormatted ? ', `code_formatted`' : '') .
($coverName ? ', `cover_name`' : '') .
($coverUrl ? ', `cover_url`' : '') .
($drawing ? ', `drawing`' : '') .
', `tags`' .
($rating ? ', `rating`' : '') .
', `user_added`' .
', `date_added`
) VALUES ("' .
$hash . '"' .
($author ? ', "' . $author . '"' : '') .
($name ? ', "' . $name . '"' : '') .
($description ? ', "' . $description . '"' : '') .
($ulrStr ? ', "' . $ulrStr . '"' : '') .
($date ? ', "' . $date . '"' : '') .
', "' . $mode . '"' .
', ' . $sampleRate .
(isset($_POST['stereo']) ? ', 1' : '') .
($code ? ', "' . $code . '"' : '') .
($codeMinified ? ', "' . $codeMinified . '"' : '') .
($codeFormatted ? ', "' . $codeFormatted . '"' : '') .
($coverName ? ', "' . $coverName . '"' : '') .
($coverUrl ? ', "' . $coverUrl . '"' : '') .
($drawing ? ', "' . $drawing . '"' : '') .
', "' . $tagsStr . '"' .
($rating ? ', ' . $rating : '') .
', "' . $user . '"' .
', "' . $dateEdited . '");');
}
$sources = $_POST['remix'];
// Deleting old entries from `remixes` table
mysqli_query($dbLink,
'DELETE FROM `remixes`
WHERE `song` = "' . $hash . '";');
// Adding sources for remixes into `remixes` table
foreach ($sources as $source) {
if ($source) {
mysqli_query($dbLink,
'INSERT INTO `remixes` (song, source)
VALUES ("' . $hash . '", "' . $source . '");');
}
}
mysqli_close($dbLink);
return 'Song ' . ($isEdit ? 'added' : 'edited') . ' successfully!
' . managementRequest();
}
// Request to delete a song from the database
function deleteSong() {
$dbLink = getDBLink();
$hash = $_POST['hash'];
mysqli_query($dbLink,
'DELETE FROM `songs`
WHERE `hash` = "' . $hash . '";');
mysqli_query($dbLink,
'DELETE FROM `remixes`
WHERE `song` = "' . $hash . '";');
mysqli_close($dbLink);
return 'Song deleted!
' . managementRequest();
}
/* ==[ Main ]============================================================================================== */
// Settings initialization
if (!file_exists('settings.php')) {
fancyDie('Please copy the file settings.default.php to settings.php');
}
require 'settings.php';
if (BYTEBEAT_TIMEZONE != '') {
date_default_timezone_set(BYTEBEAT_TIMEZONE);
}
global $bytebeat_admins;
if (!isset($bytebeat_admins) || !is_array($bytebeat_admins) || !count($bytebeat_admins)) {
fancyDie('settings.php: $bytebeat_admins array must be configured.');
}
// Checking authorization when trying to login
if (isset($_POST['managepassword'])) {
$providedPassword = $_POST['managepassword'];
$providedName = array_search($providedPassword, $bytebeat_admins, true);
if ($providedName) {
setcookie('bytebeat_access', '1', time() + 2592000, '/'); // 30 days
$_SESSION['bytebeat'] = $bytebeat_admins[$providedName];
} else {
fancyDie('Login failed!');
}
}
// Show login form if not logined yet
if (!isset($_SESSION['bytebeat'])) {
fancyDie(showLoginPage());
}
// Management request
if (isset($_GET['manage'])) {
fancyDie(managementRequest());
}
// Logout request
if (isset($_GET['logout'])) {
logoutRequest();
}
// Request to copy songs from library files into the database
if (isset($_GET['files_to_db']) && BYTEBEAT_DBMAKE) {
fancyDie(filesToDatabase());
}
// Request to create library files from database
if (isset($_GET['db_to_files'])) {
fancyDie(databaseToFiles());
}
// Request to call the form to add a song
if (isset($_GET['addsong_request'])) {
fancyDie(addSongForm());
}
// Request to call the form to edit a song
if (isset($_GET['editsong_request'])) {
fancyDie(editSongForm());
}
// Request to add a song to the database
if (isset($_GET['addsong'])) {
fancyDie(addSong(false));
}
// Request to edit a song in the database
if (isset($_GET['editsong'])) {
fancyDie(addSong(true));
}
// Request to delete a song from the database
if (isset($_GET['deletesong'])) {
fancyDie(deleteSong());
}
// Redirection to Bytebeat Player page
header('Location: index.html', true, 307);
exit();