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; } }