Subversion Repositories Applications.papyrus

Rev

Rev 1372 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
448 ddelon 1
<?php
2
/*
3
install.php
4
Copyright (c) 2002, Hendrik Mans <hendrik@mans.de>
5
Copyright 2002, 2003 David DELON
6
Copyright 2002, 2003 Patrick PAUL
7
Copyright  2003  Eric FELDSTEIN
8
All rights reserved.
9
Redistribution and use in source and binary forms, with or without
10
modification, are permitted provided that the following conditions
11
are met:
12
1. Redistributions of source code must retain the above copyright
13
notice, this list of conditions and the following disclaimer.
14
2. Redistributions in binary form must reproduce the above copyright
15
notice, this list of conditions and the following disclaimer in the
16
documentation and/or other materials provided with the distribution.
17
3. The name of the author may not be used to endorse or promote products
18
derived from this software without specific prior written permission.
19
 
20
THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR
21
IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
22
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
23
IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT,
24
INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
25
NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
26
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
27
THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
28
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
29
THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
30
*/
31
 
32
// fetch configuration
33
$config = $_POST["config"];
34
 
35
// test configuration
36
echo "<b>Test de la configuration</b><br>\n";
37
test("Test connexion MySQL ...", $dblink = @mysql_connect($config["mysql_host"], $config["mysql_user"], $config["mysql_password"]));
38
test("Recherche base de donn&eacute;es ...", @mysql_select_db($config["mysql_database"], $dblink), "La base de donn&eacute;es que vous avez choisie n'existe pas, vous devez la cr&eacute;er avant d'installer WikiNi !");
39
echo "<br>\n" ;
40
 
41
// do installation stuff
42
if (!$version = trim($wakkaConfig["wikini_version"])) $version = "0";
43
switch ($version)
44
{
45
// new installation
46
case "0":
47
	echo "<b>Installation</b><br>\n";
48
	test("Creation table page...",
49
		@mysql_query(
50
			"CREATE TABLE ".$config["table_prefix"]."pages (".
51
  			"id int(10) unsigned NOT NULL auto_increment,".
52
  			"tag varchar(50) NOT NULL default '',".
53
  			"time datetime NOT NULL default '0000-00-00 00:00:00',".
54
  			"body text NOT NULL,".
55
  			"body_r text NOT NULL,".
56
  			"owner varchar(50) NOT NULL default '',".
57
  			"user varchar(50) NOT NULL default '',".
58
  			"latest enum('Y','N') NOT NULL default 'N',".
59
  			"handler varchar(30) NOT NULL default 'page',".
60
  			"comment_on varchar(50) NOT NULL default '',".
61
  			"PRIMARY KEY  (id),".
62
  			"FULLTEXT KEY tag (tag,body),".
63
  			"KEY idx_tag (tag),".
64
  			"KEY idx_time (time),".
65
  			"KEY idx_latest (latest),".
66
  			"KEY idx_comment_on (comment_on)".
67
			") TYPE=MyISAM;", $dblink), "D&eacute;j&agrave; cr&eacute;&eacute;e ?", 0);
68
	test("Creation table ACL ...",
69
		@mysql_query(
70
			"CREATE TABLE ".$config["table_prefix"]."acls (".
71
  			"page_tag varchar(50) NOT NULL default '',".
72
			"privilege varchar(20) NOT NULL default '',".
73
  			"list text NOT NULL,".
74
 			"PRIMARY KEY  (page_tag,privilege)".
75
			") TYPE=MyISAM", $dblink), "D&eacute;j&agrave; cr&eacute;&eacute;e ?", 0);
76
	test("Creation table link ...",
77
		@mysql_query(
78
			"CREATE TABLE ".$config["table_prefix"]."links (".
79
			"from_tag char(50) NOT NULL default '',".
80
  			"to_tag char(50) NOT NULL default '',".
81
  			"UNIQUE KEY from_tag (from_tag,to_tag),".
82
  			"KEY idx_from (from_tag),".
83
  			"KEY idx_to (to_tag)".
84
			") TYPE=MyISAM", $dblink), "D&eacute;j&agrave; cr&eacute;&eacute;e ?", 0);
85
	test("Creation table referrer ...",
86
		@mysql_query(
87
			"CREATE TABLE ".$config["table_prefix"]."referrers (".
88
  			"page_tag char(50) NOT NULL default '',".
89
  			"referrer char(150) NOT NULL default '',".
90
  			"time datetime NOT NULL default '0000-00-00 00:00:00',".
91
  			"KEY idx_page_tag (page_tag),".
92
  			"KEY idx_time (time)".
93
			") TYPE=MyISAM", $dblink), "D&eacute;j&agrave; cr&eacute;&eacute;e ?", 0);
94
	test("Creation table user ...",
95
		@mysql_query(
96
			"CREATE TABLE ".$config["table_prefix"]."users (".
97
  			"name varchar(80) NOT NULL default '',".
98
  			"password varchar(32) NOT NULL default '',".
99
  			"email varchar(50) NOT NULL default '',".
100
  			"motto text NOT NULL,".
101
  			"revisioncount int(10) unsigned NOT NULL default '20',".
102
  			"changescount int(10) unsigned NOT NULL default '50',".
103
  			"doubleclickedit enum('Y','N') NOT NULL default 'Y',".
104
  			"signuptime datetime NOT NULL default '0000-00-00 00:00:00',".
105
  			"show_comments enum('Y','N') NOT NULL default 'N',".
106
  			"PRIMARY KEY  (name),".
107
  			"KEY idx_name (name),".
108
  			"KEY idx_signuptime (signuptime)".
109
			") TYPE=MyISAM", $dblink), "D&eacute;j&agrave; cr&eacute;&eacute;e ?", 0);
110
	//insertion des pages de documentation et des pages standards
111
	$d = dir("setup/doc/");
112
	while ($doc = $d->read()){
113
		if ($doc != "." && $doc != ".." && !is_dir($doc)){
114
			$pagecontent = implode ('', file("setup/doc/$doc"));
115
			if ($doc=='_root_page.txt'){
116
				$pagename = $config["root_page"];
117
			}else{
118
				$pagename = substr($doc,0,strpos($doc,'.txt'));
119
			}
120
 
121
			$sql = "Select tag from ".$config["table_prefix"]."pages where tag='$pagename'";
122
 
123
			// Insert documentation page if not present (a previous failed installation ?)
124
			if (($r=@mysql_query($sql, $dblink)) && (mysql_num_rows($r)==0)) {
125
 
126
				$sql = "Insert into ".$config["table_prefix"]."pages ".
127
				"set tag = '$pagename', ".
128
				"body = '".mysql_escape_string($pagecontent)."', ".
129
				"user = 'WikiNiInstaller', ".
130
				"time = now(), ".
131
				"latest = 'Y'";
132
 
133
				test("Insertion de la page $pagename ...", @mysql_query($sql, $dblink),"?",0);
134
 
135
				// update table_links
136
				$wiki = new Wiki($config);
137
				$wiki->SetPage($wiki->LoadPage($pagename,"",0));
138
				$wiki->ClearLinkTable();
139
				$wiki->StartLinkTracking();
140
				$wiki->TrackLinkTo($pagename);
141
				$dummy = $wiki->Header();
142
				$dummy .= $wiki->Format($pagecontent);
143
				$dummy .= $wiki->Footer();
144
				$wiki->StopLinkTracking();
145
				$wiki->WriteLinkTable();
146
				$wiki->ClearLinkTable();
147
			}
148
			else
149
			{
150
				test("Insertion de la page $pagename ...", 0 ,"Existe d&eacute;j&agrave;.",0);
151
			}
152
 
153
		}
154
	}
155
	break;
156
 
157
	// The funny upgrading stuff. Make sure these are in order! //
158
case "0.1":
159
	echo "<b>En cours de mise &agrave; jour de WikiNi 0.1</b><br>\n";
160
	test("Just very slightly altering the pages table...",
161
		@mysql_query("alter table ".$config["table_prefix"]."pages add body_r text not null default '' after body", $dblink), "Already done? Hmm!", 0);
162
	test("Claiming all your base...", 1);
163
}
164
 
165
?>
166
 
167
<p>
168
A l'&eacute;tape suivante, le programme d'installation va essayer
169
d'&eacute;crire le fichier de configuration <tt><?php echo  $wakkaConfigLocation ?></tt>.
170
Assurez vous que le serveur web a bien le droit d'&eacute;crire dans ce fichier, sinon vous devrez le modifier manuellement.  </p>
171
 
172
<form action="<?php echo  myLocation(); ?>?installAction=writeconfig" method="POST">
173
<input type="hidden" name="config" value="<?php echo  htmlentities(serialize($config)) ?>">
174
<input type="submit" value="Continuer">
175
</form>