@@verze
3
@@sql
CREATE TABLE `adminucet` ( `id` int(11) NOT NULL auto_increment, `username` text, `heslo` text, `prava` text, `naposled` int(11) default '0', `email` text, `jmeno` text, `funkce` text, `telefon` text, `ostatni` text, `poznamka` text, PRIMARY KEY (`id`) )
CREATE TABLE `browser` ( `nazev` text, `pocet` int(11) default '0' ) 
CREATE TABLE `statistika` ( `kdy` date default NULL, `pocet` int(11) default '0',roboti int default 0 ) 
CREATE TABLE `statistika_cas` ( `kdy` tinyint(4) default NULL, `pocet` int(11) default '0' )
create table statistika_referrer (referrer text, pocet int)
create table statistika_keywords (keywords text, pocet int)
create table statistika_jazyk (jazyk text, pocet int)
CREATE TABLE `zmenheslo` ( `id` int(11) NOT NULL auto_increment, `ucet` int(11) default NULL, `kdy` int(11) default NULL, `kod` text, PRIMARY KEY (`id`) ) 
CREATE TABLE `kamnahrat` ( `id` int(11) NOT NULL auto_increment, `pripona` text, `slozka` int(11) default NULL, PRIMARY KEY (`id`) )
CREATE TABLE `obsah` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `jazyk` int(11) default NULL, `slova` text, `priorita` int(11) default NULL, `typ` int(11) default NULL, `detail` text, `popis` text, `umisteni` text, PRIMARY KEY (`id`) ) 
CREATE TABLE `slozka` ( `id` int(11) NOT NULL auto_increment, `nazev` text, `master` int(11) default NULL, prava tinyint default 2, users text, PRIMARY KEY (`id`) )
CREATE TABLE `soubor` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `kdy` int(11) default NULL, `user` int(11) default NULL, `nazev` text, `cesta` text, `autor` text, `klicovaslova` text, `filesize` int(11) default NULL, PRIMARY KEY (`id`), key master (master) )
CREATE TABLE `stranka` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `url` text, `priorita` smallint(6) default NULL, `typmenu` int(11) default '1', `typgrafiky` int(11) default '1', `viditelne` tinyint(4) default '1', vlastnik int, individual text, zmena text, norobots tinyint, PRIMARY KEY (`id`) ) 
CREATE TABLE `stranka_detail` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `jazyk` tinyint(4) default NULL, `nadpis` text, `description` text, `keywords` text, `title` text, `h1` text, `podnadpis` text, `poznamka` text, `aktivni` bool default 1, `pocetzobrazeni` int default 0, PRIMARY KEY (`id`), KEY `master` (`master`,`jazyk`)  ) 
CREATE TABLE `styl` ( `id` int(11) NOT NULL auto_increment, `nazev` text, `popis` text, `family` text, `bold` tinyint(4) default NULL, `italic` tinyint(4) default NULL, `velikost` int(11) default NULL, `barva` text, `odsazeni` int(11) default NULL, `odsazenistrana` text, `pozadi` text, `ramecektyp` text, `ramecektloustka` int(11) default NULL, `ramecekstrana` text, `ramecekbarva` text, `kapitalky` tinyint(4) default NULL, `podtrzene` tinyint(4) default NULL, `nadtrzene` tinyint(4) default NULL, `preskrtnute` tinyint(4) default NULL, `velke` text, `proklad` tinyint(4) default NULL, `lineheight` double default NULL, `typ` tinyint(4) default NULL, `pouziti` text, PRIMARY KEY (`id`) ) 
CREATE TABLE `prolink` ( `id` int(11) NOT NULL auto_increment, `stranka` int(11) default NULL, `prvek` int(11) default NULL, `typ` tinyint(4) default NULL, `starytext` text, PRIMARY KEY (`id`) )
CREATE TABLE `odkaz` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `nazev` text, `url` text, `vlastnik` int(11) default NULL, kdy int, PRIMARY KEY (`id`) )
CREATE TABLE `odkaz_slozka` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `nazev` text, `vlastnik` int(11) default NULL, PRIMARY KEY (`id`) )
CREATE TABLE `danovy_kalendar` ( `id` int(11) NOT NULL auto_increment, `kdy` int(11) default NULL, `typ` text, `slova` text, PRIMARY KEY (`id`) )
CREATE TABLE `diar` ( `id` int(11) NOT NULL auto_increment, `user` int(11) default NULL, `odkdy` int(11) default NULL, `dokdy` int(11) default NULL, `opakovani` tinyint(4) default NULL, `typ` tinyint(4) default NULL, `nadpis` text, `slova` text, `barva` text, `upozorneni` int(11) default NULL, `upozorneni_email` text, `zobrazeni` tinyint(4) default NULL, `users` text, `specialni` text, PRIMARY KEY (`id`) ) 
CREATE TABLE `reklama` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `start` date default NULL, `stop` date default NULL, `nazev` text, `slova` text, `detail` text, `barva` text, `umisteni` text, `zacileni` text, PRIMARY KEY (`id`) )
CREATE TABLE `reklama_typ` ( `id` int(11) NOT NULL auto_increment, `master` int(11) default NULL, `nazev` text, `barva` text, PRIMARY KEY (`id`) )
CREATE TABLE `sablonka` ( `id` int(11) NOT NULL AUTO_INCREMENT,  `nazev` text,  PRIMARY KEY (`id`))
CREATE TABLE `sablonka_obsah` (`idsablonka` int(11) NOT NULL DEFAULT '0', `priorita` int(11) NOT NULL DEFAULT '0',  `slova` text, `typ` int(11) DEFAULT NULL, `detail` text,  `popis` text,  `umisteni` text,  oldid int, PRIMARY KEY (`idsablonka`,`priorita`))
insert into adminucet values (null,'admin','33c8d97d3a7feb30187cb87f03f9d0a5','ucty*m*sm*pm*zal*arch*kc',0,'info@animato.cz','Administrátor','','','','');
insert into stranka values (null,-2,'',0,1,2,1,1,'','',1);
update stranka set id = 0
insert into stranka values (1,0,'obsahova-stranka',1,1,1,1,1,'','',1);
insert into stranka_detail values (null,0,1,'Domovská stránka','','','',1,0)
insert into stranka_detail values (null,1,1,'Obsahová stránka','','','',1,0)
insert into odkaz_slozka values (null,-1,'Oblíbené odkazy',1);
insert into odkaz values (null,1,'Animato.cz - internetové stránky, multimédia, animace, webhosting','http://www.animato.cz/',1,1111111111)
insert into odkaz values (null,1,'Systém Animáto - komplexní řešení internetové prezentace','http://www.systemanimato.cz/',1,1111111111)
update odkaz_slozka set id = 1
insert into slozka values (1,'Obrázky',0,2,'')
insert into slozka values (2,'Zvuky',0,2,'')
insert into slozka values (3,'Animace',0,2,'')
insert into slozka values (4,'Videa',0,2,'')
insert into slozka values (5,'Dokumenty',0,2,'')
insert into slozka values (6,'Ostatní',0,2,'')
INSERT INTO kamnahrat VALUES (1, '*', 6);
INSERT INTO kamnahrat VALUES (2, 'jpg', 1);
INSERT INTO kamnahrat VALUES (3, 'jpeg', 1);
INSERT INTO kamnahrat VALUES (4, 'gif', 1);
INSERT INTO kamnahrat VALUES (5, 'png', 1);
INSERT INTO kamnahrat VALUES (6, 'tif', 1);
INSERT INTO kamnahrat VALUES (7, 'bmp', 1);
INSERT INTO kamnahrat VALUES (8, 'swf', 3);
INSERT INTO kamnahrat VALUES (9, 'avi', 4);
INSERT INTO kamnahrat VALUES (10, 'mov', 4);
INSERT INTO kamnahrat VALUES (11, 'mpg', 4);
INSERT INTO kamnahrat VALUES (12, 'mpeg', 4);
INSERT INTO kamnahrat VALUES (13, 'wav', 2);
INSERT INTO kamnahrat VALUES (14, 'mp3', 2);
INSERT INTO kamnahrat VALUES (15, 'doc', 5);
INSERT INTO kamnahrat VALUES (16, 'xls', 5);
INSERT INTO kamnahrat VALUES (17, 'pdf', 5);
INSERT INTO kamnahrat VALUES (18, 'txt', 5);
CREATE TABLE `testomat_check` ( `id` varchar(40)  NOT NULL, `kdo` varchar(40)  NOT NULL, `kdy` int(11) NOT NULL, `checked` tinyint(4) NOT NULL DEFAULT '1', `poznamka` text  NOT NULL, PRIMARY KEY (`id`) )
CREATE TABLE `testomat_custom_check` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nazev` text  NOT NULL, `popis` text NOT NULL, `adresa` text NOT NULL, `role` int(11) NOT NULL, `faze` int(11) NOT NULL, `grupa` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `grupa` (`grupa`) )
CREATE TABLE `testomat_custom_grupa` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nazev` varchar(100) NOT NULL, PRIMARY KEY (`id`) )
@@files
obrazky
obrazky/nahled
zvuky
zvuky/nahled
animace
animace/nahled
videa
videa/nahled
dokumenty
dokumenty/nahled
ostatni
ostatni/nahled
@@reflection
global $db_name;
$u=mysql_query("show tables");
if (!$u) return "nelze";
while ($r=mysql_fetch_row($u)) {
	if ($r[0]=="adminucet") return "ano";
}
return "ne";