witam mam takie cos:
<?php
if($this->check_install_data()){
$query[0]="CREATE TABLE IF NOT EXISTS `ADMIN` (";
$query[0].="`PASSWORD` VARCHAR(32) NOT NULL PRIMARY KEY)";
$query[1]="INSERT INTO `ADMIN` VALUES('".md5($this->password1)."')";
$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
eee skad mi sie tam ta 7 wziela??
aha $this->send_query() wysyla zapytanie podane w parametrze
Ten post edytował piotrekkr 23.06.2006, 14:34:13