/data/install.php
PHP | 156 lines | 96 code | 55 blank | 5 comment | 7 complexity | c9bb71d9ab01e6cc857a0384dbe223c6 MD5 | raw file
Possible License(s): LGPL-2.1
- <?php
- session_start();
- require('conn.php');
-
-
-
- $sql0="create database if not exists melthalion_tomo";
-
- mysql_query($sql0) or die(mysql_error());
- //$sql1="drop table user";
-
- //mysql_query($sql1) or die(mysql_error());
-
- $sql2="create table if not exists users(
-
- id int(11) NOT NULL auto_increment,
-
- login varchar(50) NOT NULL,
-
- stopien varchar(15) NOT NULL,
-
- imie varchar(50) NOT NULL,
-
- nazwisko varchar(50) NOT NULL,
-
- uczelnia text NOT NULL,
-
- mail varchar(100) NOT NULL,
-
- password varchar(40) NOT NULL,
-
- prawa varchar(50) NOT NULL,
-
- PRIMARY KEY (id))";
-
- $sql3="create table if not exists czat(
-
- id int(10) NOT NULL auto_increment,
-
- nazwa varchar(100) NOT NULL,
-
- tresc text NOT NULL,
-
- date varchar(45) NOT NULL,
-
- time varchar(45) NOT NULL,
-
- PRIMARY KEY (id))";
-
-
- $sql4="create table if not exists archiwum(
- id int(10) NOT NULL auto_increment,
-
- nazwa varchar(20) NOT NULL,
-
- opis_pl text NOT NULL,
-
- opis_eu text NOT NULL,
-
- date datetime NOT NULL,
-
- PRIMARY KEY (id))";
-
- $sql5="create table if not exists file(
- id int(10) NOT NULL auto_increment,
-
- id_exp int(10) NOT NULL,
-
- file_description_pl text NOT NULL,
-
- file_description_eu text NOT NULL,
-
- path varchar(45) NOT NULL,
-
- extension varchar(5) NOT NULL,
-
- PRIMARY KEY (id))";
-
-
- $sql6="create table if not exists info(
-
- id int(10) NOT NULL auto_increment,
-
- nazwa varchar(100) NOT NULL,
-
- tresc text NOT NULL,
-
- date varchar(45) NOT NULL,
-
- time varchar(45) NOT NULL,
-
- PRIMARY KEY (id))";
-
- $sql7="create table if not exists config ( id int(10) NOT NULL auto_increment,
- zmienna varchar(20) NOT NULL,
- wartosc varchar(20) NOT NULL,
- PRIMARY KEY (id))";
-
- mysql_query($sql2) or die(mysql_error());
- mysql_query($sql3) or die(mysql_error());
- mysql_query($sql4) or die(mysql_error());
- mysql_query($sql5) or die(mysql_error());
- mysql_query($sql6) or die(mysql_error());
- mysql_query($sql7) or die(mysql_error());
-
- //ustawienia pocz?tkowe - nie usuwa?
- $sql8="INSERT INTO config (zmienna, wartosc) VALUES ('cam_0_ip','0.0.0.0'),
- ('cam_1_ip','0.0.0.0'),
- ('cam_0_on','0'),
- ('cam_1_on','0')";
-
- mysql_query($sql8) or die(mysql_error());
- //testowe wstawienie filmów do archiwum
- $sql6="INSERT INTO archiwum (nazwa,opis_pl,opis_eu,date) VALUES ('experyment_nr_1','pilka gole najlepsze','ball scores the best',sysdate()),
- ('experyment_nr_2','sem','sem',sysdate()),
- ('experyment_nr_3','nawet nie wiem co to jest','i dont know what it is',sysdate())";
-
- $sql7="INSERT INTO file (id_exp,file_description_pl,file_description_eu,path,extension) VALUES ('1','plik a','file a','/file/film1.mp4','mp4'),
- ('2','plik b','file b','/file/film2.mp4','mp4'),
- ('3','plik c','file c','/file/film3.mp4','mp4'),
- ('3','plik d','file d','/file/film3.mp4','mp4'),
- ('3','plik e','file e','/file/film3.mp4','mp4'),
- ('3','plik f','file f','/file/film3.mp4','mp4'),
- ('3','plik g','file g','/file/film3.mp4','mp4'),
- ('3','plik h','file h','/file/film3.pdf','pdf'),
- ('1','plik i','file i','/file/film3.pdf','pdf'),
- ('2','plik j','file j','/file/film3.pdf','pdf'),
- ('1','plik k','file k','/file/film3.pdf','pdf'),
- ('1','plik l','file l','/file/film3.mp4','mp4'),
- ('1','plik m','file m','/file/film3.mp4','mp4'),
- ('1','plik n','file n','/file/film3.mp4','mp4'),
- ('1','plik o','file o','/file/film3.txt','txt'),
- ('2','plik p','file p','/file/film3.txt','txt'),
- ('2','plik q','file q','/file/film3.txt','txt'),
- ('2','plik r','file r','/file/film3.txt','txt'),
- ('2','plik s','file s','/file/film3.mp4','mp4'),
- ('2','plik t','file t','/file/film3.pdf','pdf'),
- ('2','plik u','file u','/file/film3.pdf','pdf'),
- ('2','plik w','file w','/file/film3.pdf','pdf'),
- ('2','plik y','file y','/file/film3.pdf','pdf'),
- ('2','plik z','file z','/file/film3.txt','txt')";
- mysql_query($sql6) or die(mysql_error());
- mysql_query($sql7) or die(mysql_error());
- //wstawienie do nowej bazy konta administartora
- $password = sha1(md5(mysql_real_escape_string (trim('nimda'))));
- $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')";
-
- mysql_query($dodajUsera) or die("Wystapil blad przy tworzeniu konta administratora" );
-
- $_SESSION['komunikat']='<span class="naglowek_message">Baza danych utworzona poprawnie.</span>';
- header("Location: ../index.php");
- exit;
-
- ?>