Home Explore Help
Sign In
richard
/
sorbetcms
Watch 1
Star 0
Fork 1
Code Issues 0 Pull Requests 0 Commits 72 Releases 0 Wiki

A tumblelog CMS built on AJAX, PHP and MySQL.

Tree: a998e1a4de
Branches Tags
sorbetcms/install.php

install.php 15KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384 
  1. <?php

  2. /* ===========================

  3. 

  4.   gelato CMS - A PHP based tumblelog CMS

  5.   development version

  6.   http://www.gelatocms.com/

  7. 

  8.   gelato CMS is a free software licensed under the GPL 2.0

  9.   Copyright (C) 2007 by Pedro Santana <pecesama at gmail dot com>

  10. 

  11.   =========================== */

  12. ?>

  13. <?php

  14. 

  15. $configFile = dirname(__FILE__).DIRECTORY_SEPARATOR."config.php";

  16. 	

  17. if (!file_exists($configFile)) {

  18. 	$mensaje = "

  19. 			<h3 class=\"important\">Error reading configuration file</h3>			

  20. 			<p>There doesn't seem to be a <code>config.php</code> file. I need this before we can get started.</p>

  21. 			<p>This either means that you did not rename the <code>config-sample.php</code> file to <code>config.php</code>.</p>";

  22. 	die($mensaje);

  23. } else {

  24. 	require(dirname(__FILE__).DIRECTORY_SEPARATOR."config.php");

  25. 	$showForm = true;

  26. }

  27. 

  28. 

  29. include("classes/functions.php");

  30.  

  31. $errors_d=array();

  32. $errors_d[1]="The login field cannot be empty";

  33. $errors_d[2]="The password field cannot be empty";

  34. $errors_d[3]="Password does not match the confirm password";

  35. $errors_d[4]="The e-mail field cannot be empty";

  36. $errors_d[5]="The installation URL field cannot be empty";

  37. $errors_d[6]="Error establishing a database connection";

  38. 

  39. $action="";

  40. $errors="";

  41. 

  42. if (isset($_POST['action'])){

  43. 	$action=$_POST['action'];

  44. }

  45. 

  46. if ($action=="config" && !is_db_installed()) {

  47. 	

  48. 	$sep_err="";

  49. 	

  50. 	if (!$_POST['login']) {

  51. 		$errors=$errors.$sep_err."1";

  52. 		$sep_err="|";

  53. 	}

  54. 	if (!$_POST['password']) {

  55. 		$errors=$errors.$sep_err."2";

  56. 		$sep_err="|";

  57. 	}

  58. 	if (!$_POST['email']) {

  59. 		$errors=$errors.$sep_err."4";

  60. 		$sep_err="|";

  61. 	}

  62. 	if (!$_POST['url_installation']) {

  63. 		$errors=$errors.$sep_err."5";

  64. 		$sep_err="|";

  65. 	}

  66. 	if ($_POST['password']!=$_POST['password2']) {

  67. 		$errors=$errors.$sep_err."3";

  68. 		$sep_err="|";

  69. 	}

  70. 	$off_r= split("," , $_POST['time_offsets']);

  71. 	$_POST['offset_time'] = $off_r[0];

  72. 	$_POST['offset_city'] = $off_r[1];

  73. 	unset($_POST['time_offsets']);

  74. 	

  75. 	if (!$errors) {		

  76. 		if (install_db($_POST['login'], $_POST['password'], $_POST['email'], $_POST['title'], $_POST['description'], $_POST['url_installation'], $_POST['posts_limit'], $_POST['lang'], $_POST['template'], $_POST['website'], $_POST['about'], $_POST['offset_city'], $_POST['offset_time'])) {

  77. 			$showForm=false;

  78. 		} else {

  79. 			$errors=$errors.$sep_err."6";

  80. 			$sep_err="|";

  81. 			$showForm=true;

  82. 		}		

  83. 	} else {

  84. 		$showForm=true;

  85. 	}

  86. }

  87. 	

  88. 	

  89. 	$showForm = (!is_db_installed());

  90. 

  91. ?>

  92. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

  93. <html xmlns="http://www.w3.org/1999/xhtml">

  94. <head>

  95. 	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

  96. 	<meta name="generator" content="gelato cms <?php echo version();?>" />

  97. 	<title>gelato :: installation</title>	

  98. 	<link rel="shortcut icon" href="images/favicon.ico" />

  99. 	<style type="text/css" media="screen">	

  100. 		@import "admin/css/style.css";		

  101. 	</style>		

  102. </head>

  103. <body>

  104. <div id="cont">

  105. 	<div id="head">

  106. 		<h1><a href="index.php" title="gelato :: home">gelato cms</a></h1>

  107. 	</div>

  108. 	

  109. 	<div id="main">

  110. 	

  111. <?

  112. 

  113. 	if ($showForm) {

  114. ?>

  115. 	

  116. 	<div class="box">

  117. 		<ul class="menu manage">

  118. 		<h3>gelato :: installation</h3>

  119. 

  120. 		<li class="selected"><a>Install</a></li>

  121. 		</ul>

  122. 	

  123. 		<div class="tabla">

  124. 			<form action="install.php" method="post" id="config_form" autocomplete="off" class="newpost">

  125. 				<fieldset>

  126. 					<legend class="install">Admin user</legend>

  127. 					<ul>

  128. 						<li><label for="login">User:</label>

  129. 							<input type="text" name="login" id="login" value="" class="txt"/><?php echo mostrarerror($errors,$errors_d,"1")?></li>

  130. 						<li><label for="password">Password:</label>

  131. 							<input type="password" name="password" id="password" value="" class="txt"/><?php echo mostrarerror($errors,$errors_d,"2")?></li>

  132. 						<li><label for="password2">Re-type password:</label>

  133. 							<input type="password" name="password2" id="password2" value="" class="txt"/><?php echo mostrarerror($errors,$errors_d,"3")?></li>						

  134. 						<li><label for="email">E-mail:</label>

  135. 							<input type="text" name="email" id="email" value="" class="txt"/><?php echo mostrarerror($errors,$errors_d,"4")?></li>						

  136. 					</ul>

  137. 				</fieldset><br  />

  138. 				<fieldset>

  139. 					<legend class="install">Tumblelog configuration</legend>

  140. 					<ul>							

  141. 						<li><label for="title">Title:</label>

  142. 							<input type="text" name="title" id="title" value="" class="txt"/></li>

  143. 						<li><label for="description">Description:</label>

  144. 							<input type="text" name="description" id="description" value="" class="txt"/></li>

  145. 						<li><label for="url_installation">Installation URL</label>

  146. 							<input type="text" name="url_installation" id="url_installation" value="" class="txt"/><?php echo mostrarerror($errors,$errors_d,"5")?></li>

  147. 						<li><label for="posts_limit">Post limit:</label>

  148. 							<input type="text" name="posts_limit" id="posts_limit" value="10" class="txt"/></li>

  149. 						<li><label for="lang">Language:</label>

  150. 							<select id="lang" name="lang">

  151. 								<option value="en" selected="selected">english</option>

  152. 							</select>

  153. 						</li>

  154. 						<li><label for="template">Template:</label>

  155. 							<select id="template" name="template">

  156. <?php

  157. 							$themes = getThemes();

  158. 							foreach ($themes as $theme) {									

  159. 								echo "<option value=\"".$theme."\" selected=\"true\">".$theme."</option>\n";

  160. 								

  161. 							}

  162. ?>							</select>

  163. 						<li>

  164. 						<li><label for="time_offsets">Time Offset:</label>

  165. 							<select id="time_offsets" name="time_offsets">

  166. 								<option value="-12,Pacific/Kwajalein">(GMT -12:00) International Date Line West</option>

  167. 								<option value="-11,Pacific/Samoa">(GMT -11:00) Midway Island, Samoa</option>

  168. 								<option value="-10,Pacific/Honolulu">(GMT -10:00) Hawaii</option>

  169. 								<option value="-9,US/Alaska">(GMT -9:00) Alaska</option>

  170. 								<option value="-8,US/Pacific">(GMT -8:00) Pacific Time (US &amp; Canada); Tijuana</option>

  171. 								<option value="-7,US/Mountain">(GMT -7:00) Mountain Time (US &amp; Canada)</option>

  172. 								<option value="-7,US/Arizona">(GMT -7:00) Arizona</option>

  173. 								<option value="-7,Mexico/BajaNorte">(GMT -7:00) Chihuahua, La Paz, Mazatlan</option>

  174. 								<option value="-6,US/Central">(GMT -6:00) Central Time (US &amp; Canada)</option>

  175. 								<option value="-6,America/Costa_Rica">(GMT -6:00) Central America</option>

  176. 								<option value="-6,Mexico/General" selected="selected">(GMT -6:00) Guadalajara, Mexico City, Monterrey</option>

  177. 								<option value="-6,Canada/Saskatchewan">(GMT -6:00) Saskatchewan</option>

  178. 								<option value="-5,US/Eastern">(GMT -5:00) Eastern Time (US &amp; Canada)</option>

  179. 								<option value="-5,America/Bogota">(GMT -5:00) Bogota, Lima, Quito</option>

  180. 								<option value="-5,US/East-Indiana">(GMT -5:00) Indiana (East)</option>

  181. 								<option value="-4,Canada/Eastern">(GMT -4:00) Atlantic Time (Canada)</option>

  182. 								<option value="-4,America/Caracas">(GMT -4:00) Caracas, La Paz</option>

  183. 								<option value="-4,America/Santiago">(GMT -4:00) Santiago</option>

  184. 								<option value="-3.50,Canada/Newfoundland">(GMT -3:30) Newfoundland</option>

  185. 								<option value="-3,Canada/Atlantic">(GMT -3:00) Brasilia, Greenland</option>

  186. 								<option value="-3,America/Buenos_Aires">(GMT -3:00) Buenos Aires, Georgetown</option>

  187. 								<option value="-1,Atlantic/Cape_Verde">(GMT -1:00) Cape Verde Is.</option>

  188. 								<option value="-1,Atlantic/Azores">(GMT -1:00) Azores</option>

  189. 								<option value="0,Africa/Casablanca">(GMT) Casablanca, Monrovia</option>

  190. 								<option value="0,Europe/Dublin">(GMT) Greenwich Mean Time : Dublin, Edinburgh, London</option>

  191. 								<option value="1,Europe/Amsterdam">(GMT +1:00) Amsterdam, Berlin, Rome, Stockholm, Vienna</option>

  192. 								<option value="1,Europe/Prague">(GMT +1:00) Belgrade, Bratislava, Budapest, Prague</option>

  193. 								<option value="1,Europe/Paris">(GMT +1:00) Brussels, Copenhagen, Madrid, Paris</option>

  194. 								<option value="1,Europe/Warsaw">(GMT +1:00) Sarajevo, Skopje, Warsaw, Zagreb</option>

  195. 								<option value="1,Africa/Bangui">(GMT +1:00) West Central Africa</option>

  196. 								<option value="2,Europe/Istanbul">(GMT +2:00) Athens, Beirut, Bucharest, Cairo, Istanbul	</option>

  197. 								<option value="2,Asia/Jerusalem">(GMT +2:00) Harare, Jerusalem, Pretoria</option>

  198. 								<option value="2,Europe/Kiev">(GMT +2:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius</option>

  199. 								<option value="3,Asia/Riyadh">(GMT +3:00) Kuwait, Nairobi, Riyadh</option>

  200. 								<option value="3,Europe/Moscow">(GMT +3:00) Baghdad, Moscow, St. Petersburg, Volgograd</option>

  201. 								<option value="3.50,Asia/Tehran">(GMT +3:30) Tehran</option>

  202. 								<option value="4,Asia/Muscat">(GMT +4:00) Abu Dhabi, Muscat</option>

  203. 								<option value="4,Asia/Baku">(GMT +4:00) Baku, Tbilsi, Yerevan</option>

  204. 								<option value="4.50,Asia/Kabul">(GMT +4:30) Kabul</option>

  205. 								<option value="5,Asia/Yekaterinburg">(GMT +5:00) Yekaterinburg</option>

  206. 								<option value="5,Asia/Karachi">(GMT +5:00) Islamabad, Karachi, Tashkent</option>

  207. 								<option value="5.50,Asia/Calcutta">(GMT +5:30) Chennai, Calcutta, Mumbai, New Delhi</option>

  208. 								<option value="5.75,Asia/Katmandu">(GMT +5:45) Katmandu</option>

  209. 								<option value="6,Asia/Almaty">(GMT +6:00) Almaty, Novosibirsk</option>

  210. 								<option value="6,Asia/Dhaka">(GMT +6:00) Astana, Dhaka, Sri Jayawardenepura</option>

  211. 								<option value="6.50,Asia/Rangoon">(GMT +6:30) Rangoon</option>

  212. 								<option value="7,Asia/Bangkok">(GMT +7:00) Bangkok, Hanoi, Jakarta</option>

  213. 								<option value="7,Asia/Krasnoyarsk">(GMT +7:00) Krasnoyarsk</option>

  214. 								<option value="8,Asia/Hong_Kong">(GMT +8:00) Beijing, Chongqing, Hong Kong, Urumqi</option>

  215. 								<option value="8,Asia/Irkutsk">(GMT +8:00) Irkutsk, Ulaan Bataar</option>

  216. 								<option value="8,Asia/Singapore">(GMT +8:00) Kuala Lumpar, Perth, Singapore, Taipei</option>

  217. 								<option value="9,Asia/Tokyo">(GMT +9:00) Osaka, Sapporo, Tokyo</option>

  218. 								<option value="9,Asia/Seoul">(GMT +9:00) Seoul</option>

  219. 								<option value="9,Asia/Yakutsk">(GMT +9:00) Yakutsk</option>

  220. 								<option value="9.50,Australia/Adelaide">(GMT +9:30) Adelaide</option>

  221. 								<option value="9.50Australia/Darwin">(GMT +9:30) Darwin</option>

  222. 								<option value="10,Australia/Brisbane">(GMT +10:00) Brisbane, Guam, Port Moresby</option>

  223. 								<option value="10,Australia/Canberra">(GMT +10:00) Canberra, Hobart, Melbourne, Sydney, Vladivostok</option>

  224. 								<option value="11,Asia/Magadan">(GMT +11:00) Magadan, Soloman Is., New Caledonia</option>

  225. 								<option value="12,Pacific/Auckland">(GMT +12:00) Auckland, Wellington</option>

  226. 								<option value="12,Pacific/Fiji">(GMT +12:00) Fiji, Kamchatka, Marshall Is.</option>

  227. 							</select>

  228. 						</li>

  229. 					</ul>

  230. 				</fieldset>

  231. 				<p>	

  232. 					<input type="hidden" name="website" id="website" value="" />

  233. 					<input type="hidden" name="about" id="about" value="" />

  234. 					<input type="hidden" name="action" id="action" value="config" />

  235. 					<input type="submit" name="btnsubmit" id="btnsubmit" value="<< Install >>" class="submit"/>

  236. 				</p>

  237. 			</form>		

  238. 		</div>

  239. 		<div class="footer-box">&nbsp;</div>

  240. 	</div>

  241. 	

  242. <?php

  243. 	} else {

  244. 		echo "<p><em>Finished!</em></p>";

  245. 		echo "<p>Now you can <a href=\"login.php\" class=\"inslnl\">log in</a> with your <strong>username</strong> and <strong>password</strong></p>";

  246. 	}

  247. 

  248. ?>

  249. 	</div>

  250. 	<div id="foot">

  251. 		<a href="http://www.gelatocms.com/" title="gelato CMS">gelato CMS</a> :: PHP/MySQL Tumblelog Content Management System.

  252. 	</div>

  253. 	

  254. </div>

  255. </body>

  256. </html>

  257. 

  258. <?php

  259. function install_db($login, $password, $email, $title, $description, $url_installation, $posts_limit, $lang, $template, $website, $about, $offset_city, $offset_time){

  260. 

  261. 		$db = new Conexion_Mysql(DB_name, DB_Server, DB_User, DB_Password);		

  262. 		

  263. 		$sqlStr = "CREATE TABLE `".Table_prefix."data` (

  264. 			  `id_post` int(11) NOT NULL auto_increment,

  265. 			  `title` text NULL,

  266. 			  `url` varchar(250)  default NULL,

  267. 			  `description` text NULL,

  268. 			  `type` tinyint(4) NOT NULL default '1',

  269. 			  `date` datetime NOT NULL,

  270. 			  `id_user` int(10) NOT NULL,

  271. 			  PRIMARY KEY  (`id_post`)

  272. 			) ENGINE = MYISAM ;";

  273. 		

  274. 		$db->ejecutarConsulta($sqlStr);

  275. 		

  276. 		$sqlStr = "CREATE TABLE `".Table_prefix."users` (

  277. 			  `id_user` int(10) unsigned NOT NULL auto_increment,

  278. 			  `name` varchar(100) default NULL,

  279. 			  `login` varchar(100) NOT NULL default '',

  280. 			  `password` varchar(64) NOT NULL default '',

  281. 			  `email` varchar(100) default NULL,

  282. 			  `website` varchar(150) default NULL,

  283. 			  `about` text,

  284. 			  PRIMARY KEY  (`id_user`)

  285. 			) ENGINE = MYISAM;";

  286. 		

  287. 		$db->ejecutarConsulta($sqlStr);

  288. 			

  289. 		$sqlStr = "CREATE TABLE `".Table_prefix."config` (

  290. 			  `posts_limit` int(3) NOT NULL,

  291. 			  `title` varchar(250) NOT NULL,

  292. 			  `description` text NOT NULL,

  293. 			  `lang` varchar(10) NOT NULL,

  294. 			  `template` varchar(100) NOT NULL,

  295. 			  `url_installation` varchar(250) NOT NULL,

  296. 			  PRIMARY KEY  (`title`)

  297. 			) ENGINE = MYISAM ;";

  298. 			

  299. 		$db->ejecutarConsulta($sqlStr);

  300. 		

  301. 		$sqlStr = "CREATE TABLE `".Table_prefix."options` (

  302. 		  `name` varchar(100) NOT NULL,

  303. 		  `val` varchar(255) NOT NULL,

  304. 		  PRIMARY KEY  (`name`)

  305. 		) ENGINE = MYISAM ;";

  306. 		

  307. 		$db->ejecutarConsulta($sqlStr);

  308. 		

  309. 		$sqlStr = "CREATE TABLE `".Table_prefix."comments` (

  310. 		  `id_comment` int(11) NOT NULL auto_increment,

  311. 		  `id_post` int(11) NOT NULL,

  312. 		  `username` varchar(50) NOT NULL,

  313. 		  `email` varchar(100) NOT NULL,

  314. 		  `web` varchar(250) default NULL,

  315. 		  `content` text NOT NULL,

  316. 		  `ip_user` varchar(50) NOT NULL,

  317. 		  `comment_date` datetime NOT NULL,

  318. 		  `spam` tinyint(4) NOT NULL,

  319. 		  PRIMARY KEY  (`id_comment`)

  320. 		) ENGINE = MYISAM ;";

  321. 		

  322. 		$db->ejecutarConsulta($sqlStr);

  323. 				

  324. 		$url_installation = (endsWith($url_installation, "/")) ? substr($url_installation, 0, strlen($url_installation)-1) : $url_installation ;

  325. 		

  326. 		$sqlStr = "INSERT INTO `".Table_prefix."config` VALUES (".$posts_limit.", '".$title."', '".$description."', '".$lang."', '".$template."', '".$url_installation."');";		

  327. 			

  328. 		$db->ejecutarConsulta($sqlStr);

  329. 		

  330. 		$sqlStr = "INSERT INTO `".Table_prefix."users` VALUES ('', '', '".$login."', '".md5($password)."', '".$email."', '".$website."', '".$about."');";

  331. 			

  332. 		$db->ejecutarConsulta($sqlStr);

  333. 		

  334. 		$sqlStr = "INSERT INTO `".Table_prefix."options` VALUES ('url_friendly', '1');";

  335. 		

  336. 		$db->ejecutarConsulta($sqlStr);

  337. 		

  338. 		$sqlStr = "INSERT INTO `".Table_prefix."options` VALUES ('rich_text', '0');";

  339. 		

  340. 		$db->ejecutarConsulta($sqlStr);

  341. 		

  342. 		$sqlStr = "INSERT INTO `".Table_prefix."options` VALUES ('allow_comments', '0');";

  343. 		

  344. 		$db->ejecutarConsulta($sqlStr);

  345. 		

  346. 		$sqlStr = "INSERT INTO `".Table_prefix."options` VALUES ('offset_city', '".$offset_city."');";

  347. 		

  348. 		$db->ejecutarConsulta($sqlStr);

  349. 		

  350. 		$sqlStr = "INSERT INTO `".Table_prefix."options` VALUES ('offset_time', '".$offset_time."');";

  351. 		

  352. 		$db->ejecutarConsulta($sqlStr);

  353. 

  354. 		$db->cierraConexion();

  355. 		return true;

  356. }

  357. 

  358. function inerrors($errors,$n) {

  359. 	if (strpos($errors,$n)===false) {

  360. 		return false;

  361. 	} else {

  362. 		return true;

  363. 	}

  364. }

  365. 

  366. function mostrarerror($errors,$errors_d,$n) {

  367. 	if (inerrors($errors,$n)) {

  368. 		return '<span class="error">'.$errors_d[$n].'</span>';

  369. 	} else {

  370. 		return "";

  371. 	}

  372. }

  373. 

  374. function is_db_installed(){

  375. 

  376. 		$db = new Conexion_Mysql(DB_name, DB_Server, DB_User, DB_Password);		

  377. 		

  378. 		$sqlStr = "SELECT * FROM `".Table_prefix."config`";	

  379. 		

  380. 		$db->ejecutarConsulta($sqlStr);

  381. 

  382. 		return ($db->contarRegistros() > 0);

  383. }

  384. ?>