PageRenderTime 52ms CodeModel.GetById 27ms RepoModel.GetById 0ms app.codeStats 0ms

/data/install.php

https://bitbucket.org/agus/projekt
PHP | 156 lines | 96 code | 55 blank | 5 comment | 7 complexity | c9bb71d9ab01e6cc857a0384dbe223c6 MD5 | raw file
Possible License(s): LGPL-2.1
  1. <?php
  2. session_start();
  3. require('conn.php');
  4. $sql0="create database if not exists melthalion_tomo";
  5. mysql_query($sql0) or die(mysql_error());
  6. //$sql1="drop table user";
  7. //mysql_query($sql1) or die(mysql_error());
  8. $sql2="create table if not exists users(
  9. id int(11) NOT NULL auto_increment,
  10. login varchar(50) NOT NULL,
  11. stopien varchar(15) NOT NULL,
  12. imie varchar(50) NOT NULL,
  13. nazwisko varchar(50) NOT NULL,
  14. uczelnia text NOT NULL,
  15. mail varchar(100) NOT NULL,
  16. password varchar(40) NOT NULL,
  17. prawa varchar(50) NOT NULL,
  18. PRIMARY KEY (id))";
  19. $sql3="create table if not exists czat(
  20. id int(10) NOT NULL auto_increment,
  21. nazwa varchar(100) NOT NULL,
  22. tresc text NOT NULL,
  23. date varchar(45) NOT NULL,
  24. time varchar(45) NOT NULL,
  25. PRIMARY KEY (id))";
  26. $sql4="create table if not exists archiwum(
  27. id int(10) NOT NULL auto_increment,
  28. nazwa varchar(20) NOT NULL,
  29. opis_pl text NOT NULL,
  30. opis_eu text NOT NULL,
  31. date datetime NOT NULL,
  32. PRIMARY KEY (id))";
  33. $sql5="create table if not exists file(
  34. id int(10) NOT NULL auto_increment,
  35. id_exp int(10) NOT NULL,
  36. file_description_pl text NOT NULL,
  37. file_description_eu text NOT NULL,
  38. path varchar(45) NOT NULL,
  39. extension varchar(5) NOT NULL,
  40. PRIMARY KEY (id))";
  41. $sql6="create table if not exists info(
  42. id int(10) NOT NULL auto_increment,
  43. nazwa varchar(100) NOT NULL,
  44. tresc text NOT NULL,
  45. date varchar(45) NOT NULL,
  46. time varchar(45) NOT NULL,
  47. PRIMARY KEY (id))";
  48. $sql7="create table if not exists config ( id int(10) NOT NULL auto_increment,
  49. zmienna varchar(20) NOT NULL,
  50. wartosc varchar(20) NOT NULL,
  51. PRIMARY KEY (id))";
  52. mysql_query($sql2) or die(mysql_error());
  53. mysql_query($sql3) or die(mysql_error());
  54. mysql_query($sql4) or die(mysql_error());
  55. mysql_query($sql5) or die(mysql_error());
  56. mysql_query($sql6) or die(mysql_error());
  57. mysql_query($sql7) or die(mysql_error());
  58. //ustawienia pocz?tkowe - nie usuwa?
  59. $sql8="INSERT INTO config (zmienna, wartosc) VALUES ('cam_0_ip','0.0.0.0'),
  60. ('cam_1_ip','0.0.0.0'),
  61. ('cam_0_on','0'),
  62. ('cam_1_on','0')";
  63. mysql_query($sql8) or die(mysql_error());
  64. //testowe wstawienie filmów do archiwum
  65. $sql6="INSERT INTO archiwum (nazwa,opis_pl,opis_eu,date) VALUES ('experyment_nr_1','pilka gole najlepsze','ball scores the best',sysdate()),
  66. ('experyment_nr_2','sem','sem',sysdate()),
  67. ('experyment_nr_3','nawet nie wiem co to jest','i dont know what it is',sysdate())";
  68. $sql7="INSERT INTO file (id_exp,file_description_pl,file_description_eu,path,extension) VALUES ('1','plik a','file a','/file/film1.mp4','mp4'),
  69. ('2','plik b','file b','/file/film2.mp4','mp4'),
  70. ('3','plik c','file c','/file/film3.mp4','mp4'),
  71. ('3','plik d','file d','/file/film3.mp4','mp4'),
  72. ('3','plik e','file e','/file/film3.mp4','mp4'),
  73. ('3','plik f','file f','/file/film3.mp4','mp4'),
  74. ('3','plik g','file g','/file/film3.mp4','mp4'),
  75. ('3','plik h','file h','/file/film3.pdf','pdf'),
  76. ('1','plik i','file i','/file/film3.pdf','pdf'),
  77. ('2','plik j','file j','/file/film3.pdf','pdf'),
  78. ('1','plik k','file k','/file/film3.pdf','pdf'),
  79. ('1','plik l','file l','/file/film3.mp4','mp4'),
  80. ('1','plik m','file m','/file/film3.mp4','mp4'),
  81. ('1','plik n','file n','/file/film3.mp4','mp4'),
  82. ('1','plik o','file o','/file/film3.txt','txt'),
  83. ('2','plik p','file p','/file/film3.txt','txt'),
  84. ('2','plik q','file q','/file/film3.txt','txt'),
  85. ('2','plik r','file r','/file/film3.txt','txt'),
  86. ('2','plik s','file s','/file/film3.mp4','mp4'),
  87. ('2','plik t','file t','/file/film3.pdf','pdf'),
  88. ('2','plik u','file u','/file/film3.pdf','pdf'),
  89. ('2','plik w','file w','/file/film3.pdf','pdf'),
  90. ('2','plik y','file y','/file/film3.pdf','pdf'),
  91. ('2','plik z','file z','/file/film3.txt','txt')";
  92. mysql_query($sql6) or die(mysql_error());
  93. mysql_query($sql7) or die(mysql_error());
  94. //wstawienie do nowej bazy konta administartora
  95. $password = sha1(md5(mysql_real_escape_string (trim('nimda'))));
  96. $dodajUsera="INSERT INTO users (login,stopien,imie,nazwisko,uczelnia,mail,password,prawa) VALUES('admin','administrator','Admin','Administrator','PL','adres@admin.kis.p.lodz.pl','$password','15')";
  97. mysql_query($dodajUsera) or die("Wystapil blad przy tworzeniu konta administratora" );
  98. $_SESSION['komunikat']='<span class="naglowek_message">Baza danych utworzona poprawnie.</span>';
  99. header("Location: ../index.php");
  100. exit;
  101. ?>