$db->execute("INSERT INTO `Role` VALUES('user')", "Role", null); $ra += $db->affected_rows(); if ($ra == 2) { echo "<p>INSERTED ROLES</p>"; } else { $db->display_error("Install.php"); } // DEBUG $db->execute("INSERT INTO `User` VALUES(1, 'ioesisto', '*****@*****.**', sha1('ciccia'), 'Io', 'Esisto', 'm', NULL, NULL, NULL, NULL, NULL, NULL, 'admin', '2010-08-27 11:49:28', 1, 1)", "User", null); if ($db->affected_rows() == 1) { echo "<p>INSERTED FAKE USER</p>"; } $db->execute("INSERT INTO `MailDirectory` VALUES(1, '" . TRASH . "', 1)", "MailDirectory", null); $ra = $db->affected_rows(); $db->execute("INSERT INTO `MailDirectory` VALUES(2, '" . MAILBOX . "', 1)", "MailDirectory", null); $ra += $db->affected_rows(); $db->execute("INSERT INTO `MailDirectory` VALUES(3, '" . SPAM . "', 1)", "MailDirectory", null); $ra += $db->affected_rows(); if ($ra == 3) { echo "<p>INSERTED FAKE MAIL DIRECTORIES</p>"; } // END DEBUG $cat = array("Novità" => array(), "Cronaca" => array(), "Politica" => array(), "Finanza" => array("Economia", "Borsa e finanza"), "Scienza" => array("Tecnologia", "Medicina"), "Sport" => array("Calcio" => array("Serie A", "Serie B", "Mercato"), "Basket", "Pallavolo", "Nuoto", "Tennis", "Golf", "Rugby", "Football americano", "Motociclismo", "Automobilismo", "Atletica", "Altri sport"), "Spettacoli" => array("Musica", "Cinema", "TV", "Teatro"), "Cultura e tendenza" => array("Libri", "Moda", "Arte", "Fotografia", "Religione", "Gossip", "Web"), "Motori" => array("Auto", "Moto", "Altro"), "Tempo libero" => array("Viaggi", "Cucina", "Casa", "Animali")); require_once 'post/PostCommon.php'; $count = CategoryManager::createCategoriesFromArray($cat); echo "<p>INSERTED CATEGORIES</p>"; ?> </body> </html>
if ($db->affected_rows() == 1) { echo "<p>INSERTED FAKE USER</p>"; } $db->execute("INSERT INTO `" . DB::TABLE_MAIL_DIRECTORY . "` VALUES(1, '" . TRASH . "', 1)", "MailDirectory", null); $ra = $db->affected_rows(); $db->execute("INSERT INTO `" . DB::TABLE_MAIL_DIRECTORY . "` VALUES(2, '" . MAILBOX . "', 1)", "MailDirectory", null); $ra += $db->affected_rows(); $db->execute("INSERT INTO `" . DB::TABLE_MAIL_DIRECTORY . "` VALUES(3, '" . SPAM . "', 1)", "MailDirectory", null); $ra += $db->affected_rows(); if ($ra == 3) { echo "<p>INSERTED FAKE MAIL DIRECTORIES</p>"; } // END DEBUG $cat = array("Novità" => array(), "Cronaca" => array(), "Politica" => array(), "Finanza" => array("Economia", "Borsa e finanza"), "Scienza" => array("Tecnologia", "Medicina"), "Sport" => array("Calcio" => array("Serie A", "Serie B", "Mercato"), "Basket", "Pallavolo", "Nuoto", "Tennis", "Golf", "Rugby", "Football americano", "Motociclismo", "Automobilismo", "Atletica", "Altri sport"), "Spettacoli" => array("Musica", "Cinema", "TV", "Teatro"), "Cultura e tendenza" => array("Libri", "Moda", "Arte", "Fotografia", "Religione", "Gossip", "Web"), "Motori" => array("Auto", "Moto", "Altro"), "Tempo libero" => array("Viaggi", "Cucina", "Casa", "Animali")); require_once 'manager/CategoryManager.php'; CategoryManager::createCategoriesFromArray($cat, 1); echo "<p>INSERTED CATEGORIES</p>"; //creo le cartelle uploads e log if (!file_exists($_SERVER["DOCUMENT_ROOT"] . "/IoEsisto/v04/uploads")) { mkdir($_SERVER["DOCUMENT_ROOT"] . "/IoEsisto/v04/uploads", 0700); echo "<p>DIRECTORY UPLOADS CREATED</p>"; } else { echo "<p>DIRECTORY UPLOADS ALREADY EXIST</p>"; } if (!file_exists($_SERVER["DOCUMENT_ROOT"] . "/IoEsisto/v04/log")) { mkdir($_SERVER["DOCUMENT_ROOT"] . "/IoEsisto/v04/log", 0700); echo "<p>DIRECTORY LOG CREATED</p>"; } else { echo "<p>DIRECTORY LOG ALREADY EXIST</p>"; } ?>