Advertisement
Guest User

Untitled

a guest
Jan 21st, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.57 KB | None | 0 0
  1. if(isset($_POST['install'])) {
  2. $host = $_POST['host'];
  3. $user = $_POST['user'];
  4. $password = $_POST['password'];
  5. $db = $_POST['database'];
  6. $prefix = $_POST['prefix'];
  7.  
  8. if(!mysql_connect($host,$user,$password) or !mysql_select_db($db))
  9. {
  10. echo "<h1>Nie można wybrać bazy lub nie można nawiązać połączenia. Wypełnij ponownie formularz.</h1>";
  11. }else{
  12. $file = "config.php";
  13. $content = "<?php\n";
  14. $content = $content . '$host = '."'".$host."';\n";
  15. $content = $content . '$user = '."'".$user."';\n";
  16. $content = $content . '$password = '."'".$password."';\n";
  17. $content = $content . '$database = '."'".$db."';\n";
  18. $content = $content . '$prefix = '."'".$prefix."';\n";
  19. $content = $content . "?>";
  20. file_put_contents($file, $content, FILE_APPEND | LOCK_EX);
  21.  
  22. $sql = "CREATE TABLE `".$prefix."ogloszenia` (
  23. `oid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  24. `tresc` text NOT NULL,
  25. `wid` int(4) UNSIGNED NOT NULL,
  26. `data` datetime NOT NULL,
  27. PRIMARY KEY(`oid`)
  28. );";
  29. mysql_query($sql);
  30.  
  31. $sql = "CREATE TABLE `".$prefix."profile` (
  32. `pid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  33. `imie` varchar(32) NOT NULL,
  34. `nazwisko` varchar(32) NOT NULL,
  35. `e-mail` varchar(50) NOT NULL,
  36. `uid` int(4) UNSIGNED NOT NULL,
  37. PRIMARY KEY(`pid`)
  38. );";
  39. mysql_query($sql);
  40.  
  41. $sql = "CREATE TABLE `".$prefix."referaty` (
  42. `rid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  43. `temat` text NOT NULL,
  44. `uid` int(4) UNSIGNED NOT NULL,
  45. `wid` int(4) UNSIGNED NOT NULL,
  46. `zatwierdzone` enum('0','1') NOT NULL,
  47. `referat` varchar(64) NOT NULL,
  48. PRIMARY KEY(`rid`)
  49. );";
  50. mysql_query($sql);
  51.  
  52. $sql = "CREATE TABLE `".$prefix."uzytkownicy` (
  53. `uid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  54. `login` varchar(32) NOT NULL,
  55. `password` varchar(255) NOT NULL,
  56. `active` enum('0','1') NOT NULL,
  57. `is_admin` enum('0','1') NOT NULL,
  58. PRIMARY KEY(`uid`)
  59. );";
  60. mysql_query($sql);
  61.  
  62. $sql = "CREATE TABLE `".$prefix."wydarzenia` (
  63. `wid` int(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  64. `nazwa` varchar(150) NOT NULL,
  65. `opis` text NOT NULL,
  66. `data` date NOT NULL,
  67. `zdjecie_wydarzenia` varchar(64) NOT NULL,
  68. `zatwierdzone` enum('0','1') NOT NULL,
  69. `uid` int(4) NOT NULL,
  70. PRIMARY KEY(`wid`)
  71. );";
  72. mysql_query($sql);
  73.  
  74.  
  75. 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