Code: Select all
<?php
/******************************************************************************
* Author: Thorsten Rinne ~ thorsten@rinne.info
* Date: 2002-08-20
* Last Update: 2004-03-02
* Copyright: (c) 2001-2004 Thorsten Rinne
*
* The contents of this file are subject to the Mozilla Public License
* Version 1.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.mozilla.org/MPL/
*
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
*/
$VERSION = "1.3.11 RC3";
$COPYRIGHT = "© 2001-2004 <a href=\"http://www.phpmyfaq.de/\" target=\"_blank\">phpMyFAQ-Team</a> | All rights reserved.";
function version_check ($ist = "", $soll = "", $err_msg = "") {
if (empty($ist) OR empty($soll)) {
return FALSE;
}
$ist = explode(".", $ist);
$soll = explode(".", $soll);
for ($i = 0; $i < count($soll); $i++) {
if ($ist[$i] < $soll[$i]) {
return FALSE;
}
if ($ist[$i] == $soll[$i]) {
continue;
}
if ($ist[$i] >= $soll[$i]) {
return TRUE;
}
}
return TRUE;
}
function php_check($version) {
return version_check (phpversion(), $version);
}
function uninstall() {
global $uninst, $conn_id;
while ($each_query = each($uninst)) {
$result = mysql_query($each_query[1]);
}
}
function HTMLFooter() {
print "<p align=\"center\">© 2001 - 2003 <a href=\"http://www.phpmyfaq.de/\" target=\"_blank\">phpMyFAQ-Team</a> | All rights reserved.</p>\n</body>\n</html>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>phpMyFAQ <?php print $VERSION; ?> Installation</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body { background-color: #999999; }
p, div, td { color: #000000; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 11px; }
.button { background-color: #778899; border: 1px solid #000000; color: #ffffff; }
.big { color: #000000; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 18px; }
.middle { color: #000000; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 14px; }
.input { background-color: #ffffff; border: 1px solid #000000; color: #000000; }
.help { cursor: help; border-bottom: 1px dotted Black; font-size: 14px; font-weight: bold; }
-->
</style>
</head>
<body>
<?php
if (!is_writeable("../inc/data.php")) {
print "<p align=\"center\">The file ../inc/data.php or the directory ../inc is not writeable.</p>";
HTMLFooter();
die();
}
if (!is_writeable("../inc/config.php")) {
print "<p align=\"center\">The file ../inc/config.php is not writeable.</p>";
HTMLFooter();
die();
}
if (!is_dir("../attachments")) {
if (!mkdir ("../attachments", 0755)) {
print "<p class=\"center\">The directory ../attachments could not be created.</p>";
HTMLFooter();
die();
}
}
if (!is_dir("../pdf")) {
if (!mkdir ("../pdf", 0755)) {
print "<p class=\"center\">The directory ../pdf could not be created.</p>";
HTMLFooter();
die();
}
}
if (!is_writeable("../attachments")) {
print "<p align=\"center\">The directory ../attachments is not writeable.</p>";
HTMLFooter();
die();
}
if (!is_writeable("../data")) {
print "<p align=\"center\">The directory ../data is not writeable.</p>";
HTMLFooter();
die();
}
if (!is_writeable("../pdf")) {
print "<p align=\"center\">The directory ../pdf is not writeable.</p>";
HTMLFooter();
die();
}
if (!is_writeable("../xml")) {
print "<p align=\"center\">The directory ../xml is not writeable.</p>";
HTMLFooter();
die();
}
if (php_check("4.1.0") == FALSE) {
print "<p align=\"center\">You need PHP Version 4.1.0 or higher!</p>";
HTMLFooter();
die();
}
if (!isset($_POST["mysql_server"]) AND !isset($_POST["mysql_user"]) AND !isset($_POST["mysql_db"])) {
?>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center" style="border: 2px solid black; background-color: #b0c4de;">
<tr>
<td align="center">
<img src="../images/header.jpg" width="750" height="60" alt="" border="0">
<h1>phpMyFAQ <?php print $VERSION; ?> Installation</h1>
<p>Your PHP version: <b><?php print phpversion(); ?></b> / Your MySQL client version: <b><?php print mysql_get_client_info(); ?></b></p>
<p>You should read the documentation carefully before installing phpMyFAQ.</p>
</td>
</tr>
<tr>
<td align="center">
<form action="<?php print $_SERVER["PHP_SELF"]; ?>" method="post">
<fieldset style="border: 1px solid black; width: 500px;">
<legend style="border: 1px solid black; background-color: #cccccc; padding: 4px 4px 4px 4px;"><b>MySQL access information</b></legend>
<table cellspacing="2" cellpadding="2" border="0" width="500" align="center">
<tr>
<td align="right" width="150">MySQL server: </td>
<td><input class="input" style="width: 200px;" type="text" name="mysql_server" value="localhost"> <span class="help" title="Please enter the host of your MySQL server here.">?</span></td>
</tr>
<tr>
<td align="right" width="150">MySQL username: </td>
<td><input class="input" style="width: 200px;" type="text" name="mysql_user" value="root"> <span class="help" title="Please enter your MySQL username here.">?</span></td>
</tr>
<tr>
<td align="right" width="150">MySQL password: </td>
<td><input class="input" style="width: 200px;" name="mysql_passwort" type="PASSWORD"> <span class="help" title="Please enter your MySQL password here.">?</span></td>
</tr>
<tr>
<td align="right" width="150">MySQL database: </td>
<td><input class="input" style="width: 200px;" type="text" name="mysql_db" value="faq"> <span class="help" title="Please enter your MySQL database here.">?</span></td>
</tr>
<tr>
<td align="right" width="150">Table prefix: </td>
<td><input class="input" style="width: 200px;" type="text" name="sqltblpre" value=""> <span class="help" title="Please enter a table prefix here if you want to install more phpMyFAQ installations on one database.">?</span></td>
</tr>
</table>
</fieldset>
<br> <br>
<fieldset style="border: 1px solid black; width: 500px;">
<legend style="border: 1px solid black; background-color: #cccccc; padding: 4px 4px 4px 4px;"><b>phpMyFAQ options</b></legend>
<table cellspacing="2" cellpadding="2" border="0" width="500" align="center">
<tr>
<td align="right" width="150">Default language: </td>
<td><select class="input" style="width: 200px;" name="language" size="1">
<?php
if ($dir = @opendir("../lang")) {
while ($dat = @readdir($dir)) {
if (substr($dat, -4) == ".php") {
print "\t\t<option value=\"".$dat."\"";
if ($dat == "english.php") {
print " selected";
}
print ">".str_replace(".php", "", $dat)."</option>\n";
}
}
}
else {
print "\t\t<option>english</option>";
}
?>
</select> <span class="help" title="Please select your default language.">?</span></td>
</tr>
<tr>
<td align="right" width="150">Admins real name: </td>
<td><input class="input" style="width: 200px;" type="text" name="realname"> <span class="help" title="Please enter your real name here.">?</span></td>
</tr>
<tr>
<td align="right" width="150">Admin email adress: </td>
<td><input class="input" style="width: 200px;" type="text" name="email"> <span class="help" title="Please enter your email adress here.">?</span></td>
</tr>
<tr>
<td align="right" width="150">Admin password: </td>
<td><input class="input" style="width: 200px;" type="password" name="password"> <span class="help" title="Please enter your password for the admin area.">?</span></td>
</tr>
<tr>
<td align="right" width="150">Retype password: </td>
<td><input class="input" style="width: 200px;" type="password" name="password_retyped"> <span class="help" title="Please retype your password for checkup.">?</span></td>
</tr>
</table>
</fieldset>
<br>
<table cellspacing="2" cellpadding="2" border="0" width="500" align="center">
<tr>
<td colspan="2" align="center" height="30"><p class="middle" align="center"><b>Do not use if you're already running a version of phpMyFAQ!</b></p></td>
</tr>
<tr>
<td colspan="2" align="center" height="40"><input type="submit" value="Install phpMyFAQ" class="button"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<?php
}
else {
?>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center" style="border: 1px solid black; background-color: #b0c4de;">
<tr>
<td colspan="2" align="center"><img src="../images/header.jpg" width="750" height="60" alt="" border="0"></td>
</tr>
<tr>
<?php
$password = $_REQUEST["password"];
$password_retyped = $_REQUEST["password_retyped"];
if ($password == "" || $password_retyped == "") {
print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>Your password or retyped password are empty. Please set your password and your retyped password.\n</td>\n";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
die();
}
if (strlen($password) < 7 || strlen($password_retyped) < 7) {
print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>Your password and retyped password are too short. Please set your password and your retyped password with a minimum of 6 characters.\n</td>\n";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
die();
}
if ($password != $password_retyped) {
print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>Your password and retyped password are not equal. Please check your password and your retyped password.\n</td>\n";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
die();
}
$mysql_server = $_REQUEST["mysql_server"];
$mysql_user = $_REQUEST["mysql_user"];
$mysql_passwort = $_REQUEST["mysql_passwort"];
$mysql_db = $_REQUEST["mysql_db"];
if (!($conn_id = @mysql_connect($mysql_server, $mysql_user, $mysql_passwort))) {
print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>No connection to the MySQL server could be created. Please check your input for:</p>\n<ul>\n<li>MySQL Server</li>\n<li>MySQL username</li>\n<li>MySQL password</li>\n</ul>\n</td>\n";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
die();
}
if (!@mysql_select_db($mysql_db)) {
print "<td>\n<p style=\"color: #ff0000;\"><b>Error:</b></p>\n<p>No connection to the database <i>".$mysql_db."</i> could be created. Please check your input for:</p>\n<ul>\n<li>MySQL database</li>\n</ul>\n<p>MySQL error: ".mysql_error()."</p>\n</td>\n";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
die();
}
$sqltblpre = $_REQUEST["sqltblpre"];
$language = $_REQUEST["language"];
/* Tabellenstruktur für das Logging im Adminbereich */
$query[] = "CREATE TABLE ".$sqltblpre."faqadminlog (
id int(11) NOT NULL auto_increment,
time int(11) NOT NULL,
user int(11) NOT NULL,
text text NOT NULL,
ip text NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqadminlog";
/* Tabellenstruktur für die Sessions im Adminbereich */
$query[] = "CREATE TABLE ".$sqltblpre."faqadminsessions (
uin varchar(50) BINARY NOT NULL,
user tinytext NOT NULL,
pass varchar(64) BINARY NOT NULL,
ip text NOT NULL,
time int(11) NOT NULL)";
$uninst[] = "DROP TABLE ".$sqltblpre."faqadminsessions";
/* Tabellenstruktur für das Logging der Änderungen der Artikel */
$query[] = "CREATE TABLE ".$sqltblpre."faqchanges (
id int(11) NOT NULL auto_increment,
beitrag int(11) NOT NULL,
lang varchar(5) NOT NULL,
user int(11) NOT NULL,
datum int(11) NOT NULL,
what text NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqchanges";
/* Tabellenstruktur für die Kommentare */
$query[] = "CREATE TABLE ".$sqltblpre."faqcomments (
id_comment int(11) NOT NULL auto_increment,
id int(11) NOT NULL,
user varchar(255) NOT NULL,
email varchar(255) NOT NULL,
comment text NOT NULL,
datum int(15) NOT NULL,
helped text NOT NULL,
PRIMARY KEY (id_comment))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqcomments";
/* Tabellenstruktur für die offenen Fragen */
$query[] = "CREATE TABLE ".$sqltblpre."faqfragen (
id int(11) unsigned NOT NULL auto_increment,
ask_username varchar(100) NOT NULL,
ask_usermail varchar(100) NOT NULL,
ask_rubrik varchar(100) NOT NULL,
ask_content text NOT NULL,
ask_date varchar(20) NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqfragen";
/* Tabellenstruktur für die News in der FAQ */
$query[] = "CREATE TABLE ".$sqltblpre."faqnews (
id int(11) NOT NULL auto_increment,
header varchar(255) NOT NULL,
artikel text NOT NULL,
datum varchar(14) NOT NULL,
link varchar(255) NOT NULL,
linktitel varchar(255) NOT NULL,
target varchar(255) NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqnews";
/* Tabellenstruktur für die Rubriken der FAQ */
$query[] = "CREATE TABLE ".$sqltblpre."faqrubrik (
id int(11) unsigned NOT NULL auto_increment,
rubrik text NOT NULL,
titel char(255) NOT NULL,
datum char(20) NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqrubrik";
/* Tabellenstruktur für die Votings der Artikel */
$query[] = "CREATE TABLE ".$sqltblpre."faqvoting (
id int(11) unsigned NOT NULL auto_increment,
artikel int(11) unsigned NOT NULL,
vote int(11) unsigned NOT NULL,
user int(11) unsigned NOT NULL,
datum varchar(20) NOT NULL default '',
ip varchar(15) NOT NULL default '',
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqvoting";
/* Tabellenstruktur für die Rechtevergabe im Adminbereich */
$query[] = "CREATE TABLE ".$sqltblpre."faqrights (
id int(11) NOT NULL auto_increment,
short text NOT NULL,
name text NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqrights";
/* Tabellenstruktur für die User-Sessions */
$query[] = "CREATE TABLE ".$sqltblpre."faqsessions (
sid int(11) NOT NULL auto_increment,
ip text NOT NULL,
time int(11) NOT NULL,
PRIMARY KEY sid (sid))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqsessions";
/* Tabellenstruktur für die Statistik */
$query[] = "CREATE TABLE ".$sqltblpre."faqstatistik (
id int(2) NOT NULL auto_increment,
shortn text NOT NULL,
longn text NOT NULL,
param text NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqstatistik";
/* Tabellenstruktur für die Artikeldaten */
$query[] = "CREATE TABLE ".$sqltblpre."faqdata (
id int(11) NOT NULL auto_increment,
lang varchar(5) NOT NULL,
active char(3) NOT NULL,
rubrik text NOT NULL,
keywords text NOT NULL,
thema text NOT NULL,
content text NOT NULL,
author varchar(255) NOT NULL,
email varchar(255) NOT NULL,
comment enum('y','n') NOT NULL default 'y',
datum varchar(15) NOT NULL,
FULLTEXT (keywords,thema,content),
PRIMARY KEY (id, lang))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqdata";
/* Tabellenstruktur für die Visits der einzelnen Artikel */
$query[] = "CREATE TABLE ".$sqltblpre."faqvisits (
id int(11) NOT NULL auto_increment,
lang varchar(5) NOT NULL,
visits int(11) NOT NULL,
last_visit int(15) NOT NULL,
PRIMARY KEY (id, lang))";
$uninst[] = "DROP TABLE ".$sqltblpre."faqvisits";
/* Tabellenstruktur für die User im Adminbereich */
$query[] = "CREATE TABLE ".$sqltblpre."faquser (
id int(2) NOT NULL auto_increment,
name text NOT NULL,
pass varchar(64) BINARY NOT NULL,
realname varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
rights text NOT NULL,
PRIMARY KEY (id))";
$uninst[] = "DROP TABLE ".$sqltblpre."faquser";
/* Tabelleninhalte für die Rechtevergabe und die Statistik */
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (1,'adduser','Benutzer hinzufügen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (2,'edituser','Benutzer editieren')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (3,'deluser','Benutzer löschen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (4,'addbt','Beitrag hinzufügen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (5,'editbt','Beitrag editieren')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (6,'delbt','Beitrag löschen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (7,'viewlog','Log ansehen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (8,'adminlog','Adminlog einsehen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (9,'delcomment','Kommentar löschen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (10,'addnews','News hinzufügen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (11,'editnews','News editieren')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (12,'delnews','News löschen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (13,'addcateg','Kategorie hinzufügen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (14,'editcateg','Kategorie editeren')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (15,'delcateg','Kategorie löschen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (16,'passwd','Kennwort ändern')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (17,'editconfig','Konfiguration editieren')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (18,'addatt','Attachments anfügen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (19,'delatt','Attachment löschen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (20,'backup','Sicherung erstellen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (21,'restore','Sicherung wiederherstellen')";
$query[] = "INSERT INTO ".$sqltblpre."faqrights (id, short, name) VALUES (22,'delquestion','Offene Fragen löschen')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (1,'mainpage','Hauptseite','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (2,'overview','Rubrikübersicht','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (3,'rubrikview','Rubrikanzeige','Rubrik')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (4,'artikelview','Artikelanzeige','Artikel')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (5,'searchpage','Suchseite','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (6,'searchresult','Suchergebnis','Suchbegriffe')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (7,'savenewentry','Eintrag speichern','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (8,'entrypflichfeldfehler','Eintrag Pflichfeldfehler','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (9,'commentpage','Kommentarseite','Artikel')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (10,'commentsave','Kommantarspeicherung','Artikel')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (11,'commentpflichtfeldfehler','Kommentarspeicherung Pflichtfeldfehler','Artikel')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (12,'newentrypage','Eintrageseite','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (13,'faqhelp','Faq Hilfeseite','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (14,'contact','Faq Kontaktseite','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (16,'savevoting','Bewertung abgegeben','Artikel')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (17,'savevotingerror','Votingabgabe verhindert','Artikel')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (18,'oldSession','Alte Session, aber neue IP','Session-ID')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (19,'frage','Seite zum Fragestellen','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (20,'xml','XML-Ausgabe erstellt','XML-Output')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (21,'antworten','Antwortseite','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (22,'frageabsenden','Frage absenden','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (23,'sendmail','FAQ Kontaktseite','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (24,'fragen','Frage stellen Formular','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (25,'NewSession','Neue Session','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik (id, shortn, longn, param) VALUES (26,'send2friend','FAQ weiterempfohlen','')";
$query[] = "INSERT INTO ".$sqltblpre."faqstatistik VALUES (27, 's2fmail', 'FAQ Empfehlung versendet', '')";
$realname = $_REQUEST["realname"];
$email = $_REQUEST["email"];
$query[] = "INSERT INTO ".$sqltblpre."faquser (id, name, pass, realname, email, rights) VALUES (1, 'admin', MD5('".$password."'), '".$realname."', '".$email."', '1111111111111111111111')";
print "<td>";
flush();
print "<p align=\"center\"><b>";
while ($each_query = each($query)) {
$result = @mysql_query($each_query[1]);
print "|";
flush();
if (!$result) {
print "<!-- ".$each_query[1]." --><br><h3 style=\"color: red;\">Attention!</h3><p>An error occured! Please install your version of phpMyFAQ once again or send us a <a href=\"http://www.phpmyfaq.de/bugtraq.php\" target=\"_blank\">bug report</a>.</p>";
print "<p>Error: ".mysql_error()."</p>";
print "</td>";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
uninstall();
die();
}
}
print "</b></p>\n";
print "<p align=\"center\">All tables were created and filled with the data.</p>\n";
print "<h3 align=\"center\">The SQL tables were created successfully.</h3>\n";
print "<p align=\"center\">Now the configuration will be written ...</p>\n";
if($fp = @fopen("../inc/data.php","w")) {
fputs($fp,"<?php\n\$mysql_server = '".$mysql_server."';\n\$mysql_user = '".$mysql_user."';\n\$mysql_passwort = '".$mysql_passwort."';\n\$mysql_db = '".$mysql_db."';\n?>");
fclose ($fp);
}
else {
print "<p>Cannot write to data.php.</p></td>";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
uninstall();
die();
}
if ($fp = @fopen("../inc/config.php","r")) {
$anz = 0;
while($dat = fgets($fp,1024)) {
$anz++;
$inp[$anz] = $dat;
}
@fclose($fp);
for ($h = 1; $h <= $anz; $h++) {
if (str_replace("\$sprache = \"english.php\";", "", $inp[$h]) != $inp[$h]) {
$inp[$h] = "\$sprache = \"".$language."\";\n";
}
if (str_replace("\$sqltblpre", "", $inp[$h]) != $inp[$h]) {
$inp[$h] = "\$sqltblpre = \"$sqltblpre\";\n";
}
}
if ($fp = @fopen("../inc/config.php","w")) {
for ($h = 1; $h <= $anz; $h++) {
fputs($fp,$inp[$h]);
}
@fclose($fp);
print "<h1 align=\"center\">Installation successful!</h1>\n";
print "<p align=\"center\"><a href=\"../index.php\">Go to your phpMyFAQ</a></p>\n";
}
else {
print "<p>Cannot write to config.php.</p></td>";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
uninstall();
die();
}
}
else {
print "<p>Cannot read config.php.</p></td>";
print "</tr>\n</table>\n</td>\n</tr>\n</table>\n<p align=\"center\">".$COPYRIGHT."</p>\n</body>\n</html>";
uninstall();
die();
}
}
HTMLFooter();
?>