connect_error) { die('\033[31mOh my goodness ... can\'t connect to mysql!\033[0m Error: (' . $connection->connect_errno . ') ' . $connection->connect_error); } // CLEAR TABLES AND RESET AUTO_INCREMENT foreach($tables as $table) { if(mysqli_query($connection,"TRUNCATE TABLE $table") == true) { mysqli_query($connection, "ALTER TABLE $table AUTO_INCREMENT = 1"); echo "\33[1;32m✓\033[0m - Cleared $table" . PHP_EOL; } else { echo "\33[1;31m×\033[0m - Cleared $table" . PHP_EOL; } } mysqli_close($connection); $distriFolder = '../../../fileadmin/distribution'; if(is_dir($distriFolder)) { system("rm -fr $distriFolder"); echo "\33[1;32m✓\033[0m - $distriFolder removed" . PHP_EOL; } echo 'Done!' . PHP_EOL . PHP_EOL . "Cheers," . PHP_EOL; echo 'Santa\'s Little Helper' . PHP_EOL;