function getGallerContentsExec($name)
{
$galleries = getGalleries();
$result = FALSE;
$contents = FALSE;
foreach ($galleries as $k => $v) {
if ($v['name'] == $name) {
$contents = getDirectoryContents(GALLERIES_DIR . $name);
break;
}
}
if ($contents) {
foreach ($contents as $k => $v) {
if ($v['kind'] == 'file') {
$extension = strtolower($v['extension']);
if ($extension == 'jpg' || $extension == 'jpeg' || $extension == 'gif' || $extension == 'png') {
$result[] = $v;
}
}
}
}
return $result;
}
$SETUP = array('DROP TABLE IF EXISTS `comments`;', 'CREATE TABLE `comments` (`id` INT NOT NULL, `on` INT NOT NULL, `author` INT NOT NULL, `created` DATETIME NOT NULL, `comment` LONGTEXT NOT NULL);', 'INSERT INTO `comments` (`id`) VALUES (0);', 'DROP TABLE IF EXISTS `meta`;', 'CREATE TABLE `meta` (`installed` DATETIME NOT NULL);', 'INSERT INTO `meta` (`installed`) VALUES (FROM_UNIXTIME(' . time() . '));', 'DROP TABLE IF EXISTS `torrents`;', 'CREATE TABLE `torrents` (`id` INT NOT NULL, `filename` VARCHAR(64) NOT NULL, `torrentname` VARCHAR(100) NOT NULL, `uploader` INT NOT NULL, `created` DATETIME NOT NULL, `downloads` INT NOT NULL);', 'INSERT INTO `torrents` (`id`) VALUES (0);', 'DROP TABLE IF EXISTS `users`;', 'CREATE TABLE `users` (`id` INT NOT NULL, `administrator` INT NOT NULL, `colour` VARCHAR(32) NOT NULL, `username` varchar(32) NOT NULL, `email` varchar(128) NOT NULL, `password` varchar(256) NOT NULL, `uploads` MEDIUMTEXT NOT NULL, `lastactive` DATETIME NOT NULL, `created` DATETIME NOT NULL);', 'INSERT INTO `users` (`id`, `administrator`, `colour`, `username`, `email`, `password`, `uploads`, `lastactive`, `created`) VALUES (0, 1, \'' . mysqli_real_escape_string($link, unserialize(_CONFIG)['general']['colours'][0]) . '\', \'admin\', \'admin@localhost\', \'' . getPasswordHash('password') . '\', \'' . mysqli_real_escape_string($link, serialize(array())) . '\', FROM_UNIXTIME(' . time() . '), FROM_UNIXTIME(' . time() . '));');
echo '<textarea class="materialize-textarea" id="textarea1">';
foreach ($SETUP as $query) {
$result = mysqli_query($link, $query);
echo (array_search($query, $SETUP) != 0 ? PHP_EOL : '') . $query . '... ';
if (!$result) {
echo 'Failure! | MySQL error! | ' . mysqli_error($link) . PHP_EOL;
$failure = true;
break;
}
echo 'Success!';
}
echo '</textarea><label for="textarea1">Running MySQL quries</label><br><br><br><textarea class="materialize-textarea" id="textarea2">';
foreach ($_DIRECTORIES as $directory) {
echo $directory . '...';
$directoryArray = getDirectoryContents($directory);
if (empty($directoryArray)) {
echo 'The directory was empty.' . PHP_EOL;
} else {
foreach ($directoryArray as $file) {
$file = $directory . DIRECTORY_SEPARATOR . $file;
echo PHP_EOL . $file . '... ';
unlink($file);
if (file_exists($file)) {
echo 'Failure!' . PHP_EOL . 'Check the file\'s permissions.';
$failure = true;
break;
} else {
echo 'Success!' . PHP_EOL;
}
}
