<?php if($this->check_install_data()){ $query[0]="CREATE TABLE IF NOT EXISTS `ADMIN` ("; $query[0].="`PASSWORD` VARCHAR(32) NOT NULL PRIMARY KEY)"; $query[2]="CREATE TABLE IF NOT EXISTS `SUBSCRIPTION_HISTORY` ("; $query[2].="`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, "; $query[2].="`CONTENT` TEXT NOT NULL,"; $query[2].="`SEND` DATETIME NOT NULL)"; $query[3]="CREATE TABLE IF NOT EXISTS `SUBSCRIPTION_DRAFTS` ("; $query[3].="`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, "; $query[3].="`CONTENT` TEXT NOT NULL,"; $query[3].="`DATE` DATETIME NOT NULL)"; $query[4]="CREATE TABLE IF NOT EXISTS `NEWS` ("; $query[4].="`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, "; $query[4].="`CONTENT` TEXT NOT NULL,"; $query[4].="`DATE` DATETIME NOT NULL)"; $query[5]="CREATE TABLE IF NOT EXISTS `NEWS_DRAFTS` ("; $query[5].="`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, "; $query[5].="`CONTENT` TEXT NOT NULL,"; $query[5].="`DATE` DATETIME NOT NULL)"; $query[6]="CREATE TABLE IF NOT EXISTS `SUBSCRIBERS` ("; $query[6].="`EMAIL` VARCHAR(50) NOT NULL PRIMARY KEY, "; $query[6].="`HASH` VARCHAR(32) NOT NULL, "; $query[6].="`NAME` VARCHAR(50) NOT NULL, "; $query[6].="`ADD_DATE` DATETIME NOT NULL, "; $query[6].="`ACTIVATED` TINYINT(1) NOT NULL, "; $query[6].="INDEX (`HASH`, `ADD_DATE`, `ACTIVATED`))"; $i=0; while($i<count($query)){ if(!$this->send_query($query[$i])){ echo '<div class="mod_admin_panel_error">Instalacja nie powiodła się podczas wysyłania zapytania numer '.$i.'.</div><br />'; $this->show_install_form(); break; }; $i++; }; }else{ $this->show_install_form(); }; ?>
i teraz widze cos takiego na ekranie:
Kod
0
1
2
3
4
5
6
7
1
2
3
4
5
6
7
eee skad mi sie tam ta 7 wziela??
aha $this->send_query() wysyla zapytanie podane w parametrze