Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_POST['install'])) {
- $host = $_POST['host'];
- $user = $_POST['user'];
- $password = $_POST['password'];
- $db = $_POST['database'];
- $prefix = $_POST['prefix'];
- if(!mysql_connect($host,$user,$password) or !mysql_select_db($db))
- {
- echo "<h1>Nie można wybrać bazy lub nie można nawiązać połączenia. Wypełnij ponownie formularz.</h1>";
- }else{
- $file = "config.php";
- $content = "<?php\n";
- $content = $content . '$host = '."'".$host."';\n";
- $content = $content . '$user = '."'".$user."';\n";
- $content = $content . '$password = '."'".$password."';\n";
- $content = $content . '$database = '."'".$db."';\n";
- $content = $content . '$prefix = '."'".$prefix."';\n";
- $content = $content . "?>";
- file_put_contents($file, $content, FILE_APPEND | LOCK_EX);
- $sql = "CREATE TABLE `".$prefix."ogloszenia` (
- `oid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
- `tresc` text NOT NULL,
- `wid` int(4) UNSIGNED NOT NULL,
- `data` datetime NOT NULL,
- PRIMARY KEY(`oid`)
- );";
- mysql_query($sql);
- $sql = "CREATE TABLE `".$prefix."profile` (
- `pid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
- `imie` varchar(32) NOT NULL,
- `nazwisko` varchar(32) NOT NULL,
- `e-mail` varchar(50) NOT NULL,
- `uid` int(4) UNSIGNED NOT NULL,
- PRIMARY KEY(`pid`)
- );";
- mysql_query($sql);
- $sql = "CREATE TABLE `".$prefix."referaty` (
- `rid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
- `temat` text NOT NULL,
- `uid` int(4) UNSIGNED NOT NULL,
- `wid` int(4) UNSIGNED NOT NULL,
- `zatwierdzone` enum('0','1') NOT NULL,
- `referat` varchar(64) NOT NULL,
- PRIMARY KEY(`rid`)
- );";
- mysql_query($sql);
- $sql = "CREATE TABLE `".$prefix."uzytkownicy` (
- `uid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
- `login` varchar(32) NOT NULL,
- `password` varchar(255) NOT NULL,
- `active` enum('0','1') NOT NULL,
- `is_admin` enum('0','1') NOT NULL,
- PRIMARY KEY(`uid`)
- );";
- mysql_query($sql);
- $sql = "CREATE TABLE `".$prefix."wydarzenia` (
- `wid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
- `nazwa` varchar(150) NOT NULL,
- `opis` text NOT NULL,
- `data` date NOT NULL,
- `zdjecie_wydarzenia` varchar(64) NOT NULL,
- `zatwierdzone` enum('0','1') NOT NULL,
- `uid` int(4) NOT NULL,
- PRIMARY KEY(`wid`)
- );";
- mysql_query($sql);
- echo "Pomyślnie skonfigurowano config.php oraz utworzono strukturę tabel. Możesz teraz usunąć plik install.php i zmienić prawa dostępu do config.php. Użyj poniższego formularza, aby zarejestrować użytkownika z prawami administratora.";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement