install.php 86 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596
  1. <?php
  2. /**
  3. * Simple Machines Forum (SMF)
  4. *
  5. * @package SMF
  6. * @author Simple Machines http://www.simplemachines.org
  7. * @copyright 2011 Simple Machines
  8. * @license http://www.simplemachines.org/about/smf/license.php BSD
  9. *
  10. * @version 2.1 Alpha 1
  11. */
  12. $GLOBALS['current_smf_version'] = '2.1 Alpha 1';
  13. $GLOBALS['db_script_version'] = '2-1';
  14. $GLOBALS['required_php_version'] = '5.1.0';
  15. // Don't have PHP support, do you?
  16. // ><html dir="ltr"><head><title>Error!</title></head><body>Sorry, this installer requires PHP!<div style="display: none;">
  17. // Database info.
  18. $databases = array(
  19. 'mysql' => array(
  20. 'name' => 'MySQL',
  21. 'version' => '4.0.18',
  22. 'version_check' => 'return min(mysql_get_server_info(), mysql_get_client_info());',
  23. 'supported' => function_exists('mysql_connect'),
  24. 'default_user' => 'mysql.default_user',
  25. 'default_password' => 'mysql.default_password',
  26. 'default_host' => 'mysql.default_host',
  27. 'default_port' => 'mysql.default_port',
  28. 'utf8_support' => true,
  29. 'utf8_version' => '4.1.0',
  30. 'utf8_version_check' => 'return mysql_get_server_info();',
  31. 'utf8_default' => false,
  32. 'utf8_required' => false,
  33. 'alter_support' => true,
  34. 'validate_prefix' => create_function('&$value', '
  35. $value = preg_replace(\'~[^A-Za-z0-9_\$]~\', \'\', $value);
  36. return true;
  37. '),
  38. ),
  39. 'postgresql' => array(
  40. 'name' => 'PostgreSQL',
  41. 'version' => '8.0',
  42. 'function_check' => 'pg_connect',
  43. 'version_check' => '$request = pg_query(\'SELECT version()\'); list ($version) = pg_fetch_row($request); list($pgl, $version) = explode(" ", $version); return $version;',
  44. 'supported' => function_exists('pg_connect'),
  45. 'always_has_db' => true,
  46. 'utf8_default' => true,
  47. 'utf8_required' => true,
  48. 'utf8_support' => true,
  49. 'utf8_version' => '8.0',
  50. 'utf8_version_check' => '$request = pg_query(\'SELECT version()\'); list ($version) = pg_fetch_row($request); list($pgl, $version) = explode(" ", $version); return $version;',
  51. 'validate_prefix' => create_function('&$value', '
  52. $value = preg_replace(\'~[^A-Za-z0-9_\$]~\', \'\', $value);
  53. // Is it reserved?
  54. if ($value == \'pg_\')
  55. return $txt[\'error_db_prefix_reserved\'];
  56. // Is the prefix numeric?
  57. if (preg_match(\'~^\d~\', $value))
  58. return $txt[\'error_db_prefix_numeric\'];
  59. return true;
  60. '),
  61. ),
  62. 'sqlite' => array(
  63. 'name' => 'SQLite',
  64. 'version' => '1',
  65. 'function_check' => 'sqlite_open',
  66. 'version_check' => 'return 1;',
  67. 'supported' => function_exists('sqlite_open'),
  68. 'always_has_db' => true,
  69. 'utf8_default' => true,
  70. 'utf8_required' => true,
  71. 'validate_prefix' => create_function('&$value', '
  72. global $incontext, $txt;
  73. $value = preg_replace(\'~[^A-Za-z0-9_\$]~\', \'\', $value);
  74. // Is it reserved?
  75. if ($value == \'sqlite_\')
  76. return $txt[\'error_db_prefix_reserved\'];
  77. // Is the prefix numeric?
  78. if (preg_match(\'~^\d~\', $value))
  79. return $txt[\'error_db_prefix_numeric\'];
  80. return true;
  81. '),
  82. ),
  83. );
  84. // Initialize everything and load the language files.
  85. initialize_inputs();
  86. load_lang_file();
  87. // This is what we are.
  88. $installurl = $_SERVER['PHP_SELF'];
  89. // This is where SMF is.
  90. $smfsite = 'http://www.simplemachines.org/smf';
  91. // All the steps in detail.
  92. // Number,Name,Function,Progress Weight.
  93. $incontext['steps'] = array(
  94. 0 => array(1, $txt['install_step_welcome'], 'Welcome', 0),
  95. 1 => array(2, $txt['install_step_writable'], 'CheckFilesWritable', 10),
  96. 2 => array(3, $txt['install_step_databaseset'], 'DatabaseSettings', 15),
  97. 3 => array(4, $txt['install_step_forum'], 'ForumSettings', 40),
  98. 4 => array(5, $txt['install_step_databasechange'], 'DatabasePopulation', 15),
  99. 5 => array(6, $txt['install_step_admin'], 'AdminAccount', 20),
  100. 6 => array(7, $txt['install_step_delete'], 'DeleteInstall', 0),
  101. );
  102. // Default title...
  103. $incontext['page_title'] = $txt['smf_installer'];
  104. // What step are we on?
  105. $incontext['current_step'] = isset($_GET['step']) ? (int) $_GET['step'] : 0;
  106. // Loop through all the steps doing each one as required.
  107. $incontext['overall_percent'] = 0;
  108. foreach ($incontext['steps'] as $num => $step)
  109. {
  110. if ($num >= $incontext['current_step'])
  111. {
  112. // The current weight of this step in terms of overall progress.
  113. $incontext['step_weight'] = $step[3];
  114. // Make sure we reset the skip button.
  115. $incontext['skip'] = false;
  116. // Call the step and if it returns false that means pause!
  117. if (function_exists($step[2]) && $step[2]() === false)
  118. break;
  119. elseif (function_exists($step[2]))
  120. $incontext['current_step']++;
  121. // No warnings pass on.
  122. $incontext['warning'] = '';
  123. }
  124. $incontext['overall_percent'] += $step[3];
  125. }
  126. // Actually do the template stuff.
  127. installExit();
  128. function initialize_inputs()
  129. {
  130. global $databases, $incontext;
  131. // Just so people using older versions of PHP aren't left in the cold.
  132. if (!isset($_SERVER['PHP_SELF']))
  133. $_SERVER['PHP_SELF'] = isset($GLOBALS['HTTP_SERVER_VARS']['PHP_SELF']) ? $GLOBALS['HTTP_SERVER_VARS']['PHP_SELF'] : 'install.php';
  134. // Turn off magic quotes runtime and enable error reporting.
  135. if (function_exists('set_magic_quotes_runtime'))
  136. @set_magic_quotes_runtime(0);
  137. error_reporting(E_ALL);
  138. // Fun. Low PHP version...
  139. if (!isset($_GET))
  140. {
  141. $GLOBALS['_GET']['step'] = 0;
  142. return;
  143. }
  144. if (!isset($_GET['obgz']))
  145. {
  146. ob_start();
  147. if (ini_get('session.save_handler') == 'user')
  148. @ini_set('session.save_handler', 'files');
  149. if (function_exists('session_start'))
  150. @session_start();
  151. }
  152. else
  153. {
  154. ob_start('ob_gzhandler');
  155. if (ini_get('session.save_handler') == 'user')
  156. @ini_set('session.save_handler', 'files');
  157. session_start();
  158. if (!headers_sent())
  159. echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  160. <html xmlns="http://www.w3.org/1999/xhtml">
  161. <head>
  162. <title>', htmlspecialchars($_GET['pass_string']), '</title>
  163. </head>
  164. <body style="background-color: #d4d4d4; margin-top: 16%; text-align: center; font-size: 16pt;">
  165. <strong>', htmlspecialchars($_GET['pass_string']), '</strong>
  166. </body>
  167. </html>';
  168. exit;
  169. }
  170. // Are we calling the backup css file?
  171. if (isset($_GET['infile_css']))
  172. {
  173. header('Content-Type: text/css');
  174. template_css();
  175. exit;
  176. }
  177. // Anybody home?
  178. if (!isset($_GET['xml']))
  179. {
  180. $incontext['remote_files_available'] = false;
  181. $test = @fsockopen('www.simplemachines.org', 80, $errno, $errstr, 1);
  182. if ($test)
  183. $incontext['remote_files_available'] = true;
  184. @fclose($test);
  185. }
  186. // Add slashes, as long as they aren't already being added.
  187. if (!function_exists('get_magic_quotes_gpc') || @get_magic_quotes_gpc() == 0)
  188. foreach ($_POST as $k => $v)
  189. if (strpos($k, 'password') === false)
  190. $_POST[$k] = addslashes($v);
  191. // This is really quite simple; if ?delete is on the URL, delete the installer...
  192. if (isset($_GET['delete']))
  193. {
  194. if (isset($_SESSION['installer_temp_ftp']))
  195. {
  196. $ftp = new ftp_connection($_SESSION['installer_temp_ftp']['server'], $_SESSION['installer_temp_ftp']['port'], $_SESSION['installer_temp_ftp']['username'], $_SESSION['installer_temp_ftp']['password']);
  197. $ftp->chdir($_SESSION['installer_temp_ftp']['path']);
  198. $ftp->unlink('install.php');
  199. $ftp->unlink('webinstall.php');
  200. foreach ($databases as $key => $dummy)
  201. $ftp->unlink('install_' . $GLOBALS['db_script_version'] . '_' . $key . '.sql');
  202. $ftp->close();
  203. unset($_SESSION['installer_temp_ftp']);
  204. }
  205. else
  206. {
  207. @unlink(__FILE__);
  208. @unlink(dirname(__FILE__) . '/webinstall.php');
  209. foreach ($databases as $key => $dummy)
  210. @unlink(dirname(__FILE__) . '/install_' . $GLOBALS['db_script_version'] . '_' . $key . '.sql');
  211. }
  212. // Now just redirect to a blank.png...
  213. header('Location: http://' . (isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME'] . ':' . $_SERVER['SERVER_PORT']) . dirname($_SERVER['PHP_SELF']) . '/Themes/default/images/blank.png');
  214. exit;
  215. }
  216. // PHP 5 might cry if we don't do this now.
  217. if (function_exists('date_default_timezone_set'))
  218. {
  219. $server_offset = @mktime(0, 0, 0, 1, 1, 1970);
  220. date_default_timezone_set('Etc/GMT' . ($server_offset > 0 ? '+' : '') . ($server_offset / 3600));
  221. }
  222. // Force an integer step, defaulting to 0.
  223. $_GET['step'] = (int) @$_GET['step'];
  224. }
  225. // Load the list of language files, and the current language file.
  226. function load_lang_file()
  227. {
  228. global $txt, $incontext;
  229. $incontext['detected_languages'] = array();
  230. // Make sure the languages directory actually exists.
  231. if (file_exists(dirname(__FILE__) . '/Themes/default/languages'))
  232. {
  233. // Find all the "Install" language files in the directory.
  234. $dir = dir(dirname(__FILE__) . '/Themes/default/languages');
  235. while ($entry = $dir->read())
  236. {
  237. if (substr($entry, 0, 8) == 'Install.' && substr($entry, -4) == '.php')
  238. $incontext['detected_languages'][$entry] = ucfirst(substr($entry, 8, strlen($entry) - 12));
  239. }
  240. $dir->close();
  241. }
  242. // Didn't find any, show an error message!
  243. if (empty($incontext['detected_languages']))
  244. {
  245. // Let's not cache this message, eh?
  246. header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
  247. header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
  248. header('Cache-Control: no-cache');
  249. echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  250. <html xmlns="http://www.w3.org/1999/xhtml">
  251. <head>
  252. <title>SMF Installer: Error!</title>
  253. </head>
  254. <body style="font-family: sans-serif;"><div style="width: 600px;">
  255. <h1 style="font-size: 14pt;">A critical error has occurred.</h1>
  256. <p>This installer was unable to find the installer\'s language file or files. They should be found under:</p>
  257. <div style="margin: 1ex; font-family: monospace; font-weight: bold;">', dirname($_SERVER['PHP_SELF']) != '/' ? dirname($_SERVER['PHP_SELF']) : '', '/Themes/default/languages</div>
  258. <p>In some cases, FTP clients do not properly upload files with this many folders. Please double check to make sure you <span style="font-weight: 600;">have uploaded all the files in the distribution</span>.</p>
  259. <p>If that doesn\'t help, please make sure this install.php file is in the same place as the Themes folder.</p>
  260. <p>If you continue to get this error message, feel free to <a href="http://support.simplemachines.org/">look to us for support</a>.</p>
  261. </div></body>
  262. </html>';
  263. die;
  264. }
  265. // Override the language file?
  266. if (isset($_GET['lang_file']))
  267. $_SESSION['installer_temp_lang'] = $_GET['lang_file'];
  268. elseif (isset($GLOBALS['HTTP_GET_VARS']['lang_file']))
  269. $_SESSION['installer_temp_lang'] = $GLOBALS['HTTP_GET_VARS']['lang_file'];
  270. // Make sure it exists, if it doesn't reset it.
  271. if (!isset($_SESSION['installer_temp_lang']) || preg_match('~[^\\w_\\-.]~', $_SESSION['installer_temp_lang']) === 1 || !file_exists(dirname(__FILE__) . '/Themes/default/languages/' . $_SESSION['installer_temp_lang']))
  272. {
  273. // Use the first one...
  274. list ($_SESSION['installer_temp_lang']) = array_keys($incontext['detected_languages']);
  275. // If we have english and some other language, use the other language. We Americans hate english :P.
  276. if ($_SESSION['installer_temp_lang'] == 'Install.english.php' && count($incontext['detected_languages']) > 1)
  277. list (, $_SESSION['installer_temp_lang']) = array_keys($incontext['detected_languages']);
  278. }
  279. // And now include the actual language file itself.
  280. require_once(dirname(__FILE__) . '/Themes/default/languages/' . $_SESSION['installer_temp_lang']);
  281. }
  282. // This handy function loads some settings and the like.
  283. function load_database()
  284. {
  285. global $db_prefix, $db_connection, $db_character_set, $sourcedir, $language;
  286. global $smcFunc, $mbname, $scripturl, $boardurl, $modSettings, $db_type, $db_name, $db_user;
  287. if (empty($sourcedir))
  288. $sourcedir = dirname(__FILE__) . '/Sources';
  289. // Need this to check whether we need the database password.
  290. require(dirname(__FILE__) . '/Settings.php');
  291. if (!defined('SMF'))
  292. define('SMF', 1);
  293. if (empty($smcFunc))
  294. $smcFunc = array();
  295. $modSettings['disableQueryCheck'] = true;
  296. // Connect the database.
  297. if (!$db_connection)
  298. {
  299. require_once($sourcedir . '/Subs-Db-' . $db_type . '.php');
  300. if (version_compare(PHP_VERSION, '5', '<'))
  301. require_once($sourcedir . '/Subs-Compat.php');
  302. if (!$db_connection)
  303. $db_connection = smf_db_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, array('persist' => $db_persist));
  304. }
  305. }
  306. // This is called upon exiting the installer, for template etc.
  307. function installExit($fallThrough = false)
  308. {
  309. global $incontext, $installurl, $txt;
  310. // Send character set.
  311. header('Content-Type: text/html; charset=' . (isset($txt['lang_character_set']) ? $txt['lang_character_set'] : 'ISO-8859-1'));
  312. // We usually dump our templates out.
  313. if (!$fallThrough)
  314. {
  315. // The top install bit.
  316. template_install_above();
  317. // Call the template.
  318. if (isset($incontext['sub_template']))
  319. {
  320. $incontext['form_url'] = $installurl . '?step=' . $incontext['current_step'];
  321. call_user_func('template_' . $incontext['sub_template']);
  322. }
  323. // @todo REMOVE THIS!!
  324. else
  325. {
  326. if (function_exists('doStep' . $_GET['step']))
  327. call_user_func('doStep' . $_GET['step']);
  328. }
  329. // Show the footer.
  330. template_install_below();
  331. }
  332. // Bang - gone!
  333. die();
  334. }
  335. function Welcome()
  336. {
  337. global $incontext, $txt, $databases, $installurl;
  338. $incontext['page_title'] = $txt['install_welcome'];
  339. $incontext['sub_template'] = 'welcome_message';
  340. // Done the submission?
  341. if (isset($_POST['contbutt']))
  342. return true;
  343. // Check the PHP version.
  344. if ((!function_exists('version_compare') || version_compare($GLOBALS['required_php_version'], PHP_VERSION, '>')))
  345. {
  346. $incontext['warning'] = $txt['error_php_too_low'];
  347. }
  348. // See if we think they have already installed it?
  349. if (is_readable(dirname(__FILE__) . '/Settings.php'))
  350. {
  351. $probably_installed = 0;
  352. foreach (file(dirname(__FILE__) . '/Settings.php') as $line)
  353. {
  354. if (preg_match('~^\$db_passwd\s=\s\'([^\']+)\';$~', $line))
  355. $probably_installed++;
  356. if (preg_match('~^\$boardurl\s=\s\'([^\']+)\';~', $line) && !preg_match('~^\$boardurl\s=\s\'http://127\.0\.0\.1/smf\';~', $line))
  357. $probably_installed++;
  358. }
  359. if ($probably_installed == 2)
  360. $incontext['warning'] = $txt['error_already_installed'];
  361. }
  362. // Is some database support even compiled in?
  363. $incontext['supported_databases'] = array();
  364. foreach ($databases as $key => $db)
  365. {
  366. if ($db['supported'])
  367. {
  368. if (!file_exists(dirname(__FILE__) . '/install_' . $GLOBALS['db_script_version'] . '_' . $key . '.sql'))
  369. {
  370. $databases[$key]['supported'] = false;
  371. $notFoundSQLFile = true;
  372. $txt['error_db_script_missing'] = sprintf($txt['error_db_script_missing'], 'install_' . $GLOBALS['db_script_version'] . '_' . $key . '.sql');
  373. }
  374. else
  375. {
  376. $db_type = $key;
  377. $incontext['supported_databases'][] = $db;
  378. }
  379. }
  380. }
  381. if (empty($incontext['supported_databases']))
  382. $error = empty($notFoundSQLFile) ? 'error_db_missing' : 'error_db_script_missing';
  383. // How about session support? Some crazy sysadmin remove it?
  384. elseif (!function_exists('session_start'))
  385. $error = 'error_session_missing';
  386. // Make sure they uploaded all the files.
  387. elseif (!file_exists(dirname(__FILE__) . '/index.php'))
  388. $error = 'error_missing_files';
  389. // Very simple check on the session.save_path for Windows.
  390. // @todo Move this down later if they don't use database-driven sessions?
  391. elseif (@ini_get('session.save_path') == '/tmp' && substr(__FILE__, 1, 2) == ':\\')
  392. $error = 'error_session_save_path';
  393. // Since each of the three messages would look the same, anyway...
  394. if (isset($error))
  395. $incontext['error'] = $txt[$error];
  396. // Mod_security blocks everything that smells funny. Let SMF handle security.
  397. if (!fixModSecurity() && !isset($_GET['overmodsecurity']))
  398. $incontext['error'] = $txt['error_mod_security'] . '<br /><br /><a href="' . $installurl . '?overmodsecurity=true">' . $txt['error_message_click'] . '</a> ' . $txt['error_message_bad_try_again'];
  399. return false;
  400. }
  401. function CheckFilesWritable()
  402. {
  403. global $txt, $incontext;
  404. $incontext['page_title'] = $txt['ftp_checking_writable'];
  405. $incontext['sub_template'] = 'chmod_files';
  406. $writable_files = array(
  407. 'attachments',
  408. 'avatars',
  409. 'cache',
  410. 'Packages',
  411. 'Packages/installed.list',
  412. 'Smileys',
  413. 'Themes',
  414. 'agreement.txt',
  415. 'Settings.php',
  416. 'Settings_bak.php'
  417. );
  418. $extra_files = array(
  419. 'Themes/classic/index.template.php',
  420. 'Themes/classic/style.css'
  421. );
  422. foreach ($incontext['detected_languages'] as $lang => $temp)
  423. $extra_files[] = 'Themes/default/languages/' . $lang;
  424. // With mod_security installed, we could attempt to fix it with .htaccess.
  425. if (function_exists('apache_get_modules') && in_array('mod_security', apache_get_modules()))
  426. $writable_files[] = file_exists(dirname(__FILE__) . '/.htaccess') ? '.htaccess' : '.';
  427. $failed_files = array();
  428. // On linux, it's easy - just use is_writable!
  429. if (substr(__FILE__, 1, 2) != ':\\')
  430. {
  431. foreach ($writable_files as $file)
  432. {
  433. if (!is_writable(dirname(__FILE__) . '/' . $file))
  434. {
  435. @chmod(dirname(__FILE__) . '/' . $file, 0755);
  436. // Well, 755 hopefully worked... if not, try 777.
  437. if (!is_writable(dirname(__FILE__) . '/' . $file) && !@chmod(dirname(__FILE__) . '/' . $file, 0777))
  438. $failed_files[] = $file;
  439. }
  440. }
  441. foreach ($extra_files as $file)
  442. @chmod(dirname(__FILE__) . (empty($file) ? '' : '/' . $file), 0777);
  443. }
  444. // Windows is trickier. Let's try opening for r+...
  445. else
  446. {
  447. foreach ($writable_files as $file)
  448. {
  449. // Folders can't be opened for write... but the index.php in them can ;)
  450. if (is_dir(dirname(__FILE__) . '/' . $file))
  451. $file .= '/index.php';
  452. // Funny enough, chmod actually does do something on windows - it removes the read only attribute.
  453. @chmod(dirname(__FILE__) . '/' . $file, 0777);
  454. $fp = @fopen(dirname(__FILE__) . '/' . $file, 'r+');
  455. // Hmm, okay, try just for write in that case...
  456. if (!is_resource($fp))
  457. $fp = @fopen(dirname(__FILE__) . '/' . $file, 'w');
  458. if (!is_resource($fp))
  459. $failed_files[] = $file;
  460. @fclose($fp);
  461. }
  462. foreach ($extra_files as $file)
  463. @chmod(dirname(__FILE__) . (empty($file) ? '' : '/' . $file), 0777);
  464. }
  465. $failure = count($failed_files) >= 1;
  466. if (!isset($_SERVER))
  467. return !$failure;
  468. // Put the list into context.
  469. $incontext['failed_files'] = $failed_files;
  470. // It's not going to be possible to use FTP on windows to solve the problem...
  471. if ($failure && substr(__FILE__, 1, 2) == ':\\')
  472. {
  473. $incontext['error'] = $txt['error_windows_chmod'] . '
  474. <ul style="margin: 2.5ex; font-family: monospace;">
  475. <li>' . implode('</li>
  476. <li>', $failed_files) . '</li>
  477. </ul>';
  478. return false;
  479. }
  480. // We're going to have to use... FTP!
  481. elseif ($failure)
  482. {
  483. // Load any session data we might have...
  484. if (!isset($_POST['ftp_username']) && isset($_SESSION['installer_temp_ftp']))
  485. {
  486. $_POST['ftp_server'] = $_SESSION['installer_temp_ftp']['server'];
  487. $_POST['ftp_port'] = $_SESSION['installer_temp_ftp']['port'];
  488. $_POST['ftp_username'] = $_SESSION['installer_temp_ftp']['username'];
  489. $_POST['ftp_password'] = $_SESSION['installer_temp_ftp']['password'];
  490. $_POST['ftp_path'] = $_SESSION['installer_temp_ftp']['path'];
  491. }
  492. $incontext['ftp_errors'] = array();
  493. if (isset($_POST['ftp_username']))
  494. {
  495. $ftp = new ftp_connection($_POST['ftp_server'], $_POST['ftp_port'], $_POST['ftp_username'], $_POST['ftp_password']);
  496. if ($ftp->error === false)
  497. {
  498. // Try it without /home/abc just in case they messed up.
  499. if (!$ftp->chdir($_POST['ftp_path']))
  500. {
  501. $incontext['ftp_errors'][] = $ftp->last_message;
  502. $ftp->chdir(preg_replace('~^/home[2]?/[^/]+?~', '', $_POST['ftp_path']));
  503. }
  504. }
  505. }
  506. if (!isset($ftp) || $ftp->error !== false)
  507. {
  508. if (!isset($ftp))
  509. $ftp = new ftp_connection(null);
  510. // Save the error so we can mess with listing...
  511. elseif ($ftp->error !== false && empty($incontext['ftp_errors']) && !empty($ftp->last_message))
  512. $incontext['ftp_errors'][] = $ftp->last_message;
  513. list ($username, $detect_path, $found_path) = $ftp->detect_path(dirname(__FILE__));
  514. if (empty($_POST['ftp_path']) && $found_path)
  515. $_POST['ftp_path'] = $detect_path;
  516. if (!isset($_POST['ftp_username']))
  517. $_POST['ftp_username'] = $username;
  518. // Set the username etc, into context.
  519. $incontext['ftp'] = array(
  520. 'server' => isset($_POST['ftp_server']) ? $_POST['ftp_server'] : 'localhost',
  521. 'port' => isset($_POST['ftp_port']) ? $_POST['ftp_port'] : '21',
  522. 'username' => isset($_POST['ftp_username']) ? $_POST['ftp_username'] : '',
  523. 'path' => isset($_POST['ftp_path']) ? $_POST['ftp_path'] : '/',
  524. 'path_msg' => !empty($found_path) ? $txt['ftp_path_found_info'] : $txt['ftp_path_info'],
  525. );
  526. return false;
  527. }
  528. else
  529. {
  530. $_SESSION['installer_temp_ftp'] = array(
  531. 'server' => $_POST['ftp_server'],
  532. 'port' => $_POST['ftp_port'],
  533. 'username' => $_POST['ftp_username'],
  534. 'password' => $_POST['ftp_password'],
  535. 'path' => $_POST['ftp_path']
  536. );
  537. $failed_files_updated = array();
  538. foreach ($failed_files as $file)
  539. {
  540. if (!is_writable(dirname(__FILE__) . '/' . $file))
  541. $ftp->chmod($file, 0755);
  542. if (!is_writable(dirname(__FILE__) . '/' . $file))
  543. $ftp->chmod($file, 0777);
  544. if (!is_writable(dirname(__FILE__) . '/' . $file))
  545. {
  546. $failed_files_updated[] = $file;
  547. $incontext['ftp_errors'][] = rtrim($ftp->last_message) . ' -> ' . $file . "\n";
  548. }
  549. }
  550. $ftp->close();
  551. // Are there any errors left?
  552. if (count($failed_files_updated) >= 1)
  553. {
  554. // Guess there are...
  555. $incontext['failed_files'] = $failed_files_updated;
  556. // Set the username etc, into context.
  557. $incontext['ftp'] = $_SESSION['installer_temp_ftp'] += array(
  558. 'path_msg' => $txt['ftp_path_info'],
  559. );
  560. return false;
  561. }
  562. }
  563. }
  564. return true;
  565. }
  566. function DatabaseSettings()
  567. {
  568. global $txt, $databases, $incontext, $smcFunc, $sourcedir;
  569. $incontext['sub_template'] = 'database_settings';
  570. $incontext['page_title'] = $txt['db_settings'];
  571. $incontext['continue'] = 1;
  572. // Set up the defaults.
  573. $incontext['db']['server'] = 'localhost';
  574. $incontext['db']['user'] = '';
  575. $incontext['db']['name'] = '';
  576. $incontext['db']['pass'] = '';
  577. $incontext['db']['type'] = '';
  578. $incontext['supported_databases'] = array();
  579. $foundOne = false;
  580. foreach ($databases as $key => $db)
  581. {
  582. // Override with the defaults for this DB if appropriate.
  583. if ($db['supported'])
  584. {
  585. $incontext['supported_databases'][$key] = $db;
  586. if (!$foundOne)
  587. {
  588. if (isset($db['default_host']))
  589. $incontext['db']['server'] = ini_get($db['default_host']) or $incontext['db']['server'] = 'localhost';
  590. if (isset($db['default_user']))
  591. {
  592. $incontext['db']['user'] = ini_get($db['default_user']);
  593. $incontext['db']['name'] = ini_get($db['default_user']);
  594. }
  595. if (isset($db['default_password']))
  596. $incontext['db']['pass'] = ini_get($db['default_password']);
  597. if (isset($db['default_port']))
  598. $db_port = ini_get($db['default_port']);
  599. $incontext['db']['type'] = $key;
  600. $foundOne = true;
  601. }
  602. }
  603. }
  604. // Override for repost.
  605. if (isset($_POST['db_user']))
  606. {
  607. $incontext['db']['user'] = $_POST['db_user'];
  608. $incontext['db']['name'] = $_POST['db_type'] == 'sqlite' && isset($_POST['db_filename']) ? $_POST['db_filename'] : $_POST['db_name'];
  609. $incontext['db']['server'] = $_POST['db_server'];
  610. $incontext['db']['prefix'] = $_POST['db_prefix'];
  611. }
  612. else
  613. {
  614. $incontext['db']['prefix'] = 'smf_';
  615. // Should we use a non standard port?
  616. if (!empty($db_port))
  617. $incontext['db']['server'] .= ':' . $db_port;
  618. }
  619. // Are we submitting?
  620. if (isset($_POST['db_type']))
  621. {
  622. if (isset($_POST['db_filename']))
  623. {
  624. // You better enter enter a database name for SQLite.
  625. if (trim($_POST['db_filename']) == '')
  626. {
  627. $incontext['error'] = $txt['error_db_filename'];
  628. return false;
  629. }
  630. // Duplicate name in the same dir? Can't do that with SQLite. Weird things happen.
  631. if (file_exists($_POST['db_filename'] . (substr($_POST['db_filename'], -3) != '.db' ? '.db' : '')))
  632. {
  633. $incontext['error'] = $txt['error_db_filename_exists'];
  634. return false;
  635. }
  636. }
  637. // What type are they trying?
  638. $db_type = preg_replace('~[^A-Za-z0-9]~', '', $_POST['db_type']);
  639. $db_prefix = $_POST['db_prefix'];
  640. // Validate the prefix.
  641. $valid_prefix = $databases[$db_type]['validate_prefix']($db_prefix);
  642. if ($valid_prefix !== true)
  643. {
  644. $incontext['error'] = $valid_prefix;
  645. return false;
  646. }
  647. // Take care of these variables...
  648. $vars = array(
  649. 'db_type' => $db_type,
  650. 'db_name' => $_POST['db_type'] == 'sqlite' && isset($_POST['db_filename']) ? $_POST['db_filename'] : $_POST['db_name'],
  651. 'db_user' => $_POST['db_user'],
  652. 'db_passwd' => isset($_POST['db_passwd']) ? $_POST['db_passwd'] : '',
  653. 'db_server' => $_POST['db_server'],
  654. 'db_prefix' => $db_prefix,
  655. // The cookiename is special; we want it to be the same if it ever needs to be reinstalled with the same info.
  656. 'cookiename' => 'SMFCookie' . abs(crc32($_POST['db_name'] . preg_replace('~[^A-Za-z0-9_$]~', '', $_POST['db_prefix'])) % 1000),
  657. );
  658. // God I hope it saved!
  659. if (!updateSettingsFile($vars) && substr(__FILE__, 1, 2) == ':\\')
  660. {
  661. $incontext['error'] = $txt['error_windows_chmod'];
  662. return false;
  663. }
  664. // Make sure it works.
  665. require(dirname(__FILE__) . '/Settings.php');
  666. if (empty($sourcedir))
  667. $sourcedir = dirname(__FILE__) . '/Sources';
  668. // Better find the database file!
  669. if (!file_exists($sourcedir . '/Subs-Db-' . $db_type . '.php'))
  670. {
  671. $incontext['error'] = sprintf($txt['error_db_file'], 'Subs-Db-' . $db_type . '.php');
  672. return false;
  673. }
  674. // Now include it for database functions!
  675. define('SMF', 1);
  676. $modSettings['disableQueryCheck'] = true;
  677. if (empty($smcFunc))
  678. $smcFunc = array();
  679. require_once($sourcedir . '/Subs-Db-' . $db_type . '.php');
  680. // What - running PHP4? The shame!
  681. if (version_compare(PHP_VERSION, '5', '<'))
  682. require_once($sourcedir . '/Subs-Compat.php');
  683. // Attempt a connection.
  684. $needsDB = !empty($databases[$db_type]['always_has_db']);
  685. $db_connection = smf_db_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, array('non_fatal' => true, 'dont_select_db' => !$needsDB));
  686. // No dice? Let's try adding the prefix they specified, just in case they misread the instructions ;)
  687. if ($db_connection == null)
  688. {
  689. $db_error = @$smcFunc['db_error']();
  690. $db_connection = smf_db_initiate($db_server, $db_name, $_POST['db_prefix'] . $db_user, $db_passwd, $db_prefix, array('non_fatal' => true, 'dont_select_db' => !$needsDB));
  691. if ($db_connection != null)
  692. {
  693. $db_user = $_POST['db_prefix'] . $db_user;
  694. updateSettingsFile(array('db_user' => $db_user));
  695. }
  696. }
  697. // Still no connection? Big fat error message :P.
  698. if (!$db_connection)
  699. {
  700. $incontext['error'] = $txt['error_db_connect'] . '<div style="margin: 2.5ex; font-family: monospace;"><strong>' . $db_error . '</strong></div>';
  701. return false;
  702. }
  703. // Do they meet the install requirements?
  704. // @todo Old client, new server?
  705. if (version_compare($databases[$db_type]['version'], preg_replace('~^\D*|\-.+?$~', '', eval($databases[$db_type]['version_check']))) > 0)
  706. {
  707. $incontext['error'] = $txt['error_db_too_low'];
  708. return false;
  709. }
  710. // Let's try that database on for size... assuming we haven't already lost the opportunity.
  711. if ($db_name != '' && !$needsDB)
  712. {
  713. $smcFunc['db_query']('', "
  714. CREATE DATABASE IF NOT EXISTS `$db_name`",
  715. array(
  716. 'security_override' => true,
  717. 'db_error_skip' => true,
  718. ),
  719. $db_connection
  720. );
  721. // Okay, let's try the prefix if it didn't work...
  722. if (!$smcFunc['db_select_db']($db_name, $db_connection) && $db_name != '')
  723. {
  724. $smcFunc['db_query']('', "
  725. CREATE DATABASE IF NOT EXISTS `$_POST[db_prefix]$db_name`",
  726. array(
  727. 'security_override' => true,
  728. 'db_error_skip' => true,
  729. ),
  730. $db_connection
  731. );
  732. if ($smcFunc['db_select_db']($_POST['db_prefix'] . $db_name, $db_connection))
  733. {
  734. $db_name = $_POST['db_prefix'] . $db_name;
  735. updateSettingsFile(array('db_name' => $db_name));
  736. }
  737. }
  738. // Okay, now let's try to connect...
  739. if (!$smcFunc['db_select_db']($db_name, $db_connection))
  740. {
  741. $incontext['error'] = sprintf($txt['error_db_database'], $db_name);
  742. return false;
  743. }
  744. }
  745. return true;
  746. }
  747. return false;
  748. }
  749. // Let's start with basic forum type settings.
  750. function ForumSettings()
  751. {
  752. global $txt, $incontext, $databases, $smcFunc, $db_connection, $db_type;
  753. $incontext['sub_template'] = 'forum_settings';
  754. $incontext['page_title'] = $txt['install_settings'];
  755. // Let's see if we got the database type correct.
  756. if (isset($_POST['db_type'], $databases[$_POST['db_type']]))
  757. $db_type = $_POST['db_type'];
  758. // Else we'd better be able to get the connection.
  759. else
  760. load_database();
  761. $db_type = isset($_POST['db_type']) ? $_POST['db_type'] : $db_type;
  762. // What host and port are we on?
  763. $host = empty($_SERVER['HTTP_HOST']) ? $_SERVER['SERVER_NAME'] . (empty($_SERVER['SERVER_PORT']) || $_SERVER['SERVER_PORT'] == '80' ? '' : ':' . $_SERVER['SERVER_PORT']) : $_SERVER['HTTP_HOST'];
  764. // Now, to put what we've learned together... and add a path.
  765. $incontext['detected_url'] = 'http' . (!empty($_SERVER['HTTPS']) && strtolower($_SERVER['HTTPS']) == 'on' ? 's' : '') . '://' . $host . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/'));
  766. // Check if the database sessions will even work.
  767. $incontext['test_dbsession'] = ini_get('session.auto_start') != 1;
  768. $incontext['utf8_should_work'] = stripos(PHP_OS, 'win') === false;
  769. $incontext['utf8_default'] = $databases[$db_type]['utf8_default'];
  770. $incontext['utf8_required'] = $databases[$db_type]['utf8_required'];
  771. $incontext['continue'] = 1;
  772. // Submitting?
  773. if (isset($_POST['boardurl']))
  774. {
  775. if (substr($_POST['boardurl'], -10) == '/index.php')
  776. $_POST['boardurl'] = substr($_POST['boardurl'], 0, -10);
  777. elseif (substr($_POST['boardurl'], -1) == '/')
  778. $_POST['boardurl'] = substr($_POST['boardurl'], 0, -1);
  779. if (substr($_POST['boardurl'], 0, 7) != 'http://' && substr($_POST['boardurl'], 0, 7) != 'file://' && substr($_POST['boardurl'], 0, 8) != 'https://')
  780. $_POST['boardurl'] = 'http://' . $_POST['boardurl'];
  781. // Save these variables.
  782. $vars = array(
  783. 'boardurl' => $_POST['boardurl'],
  784. 'boarddir' => addslashes(dirname(__FILE__)),
  785. 'sourcedir' => addslashes(dirname(__FILE__)) . '/Sources',
  786. 'cachedir' => addslashes(dirname(__FILE__)) . '/cache',
  787. 'mbname' => strtr($_POST['mbname'], array('\"' => '"')),
  788. 'language' => substr($_SESSION['installer_temp_lang'], 8, -4),
  789. );
  790. // Must save!
  791. if (!updateSettingsFile($vars) && substr(__FILE__, 1, 2) == ':\\')
  792. {
  793. $incontext['error'] = $txt['error_windows_chmod'];
  794. return false;
  795. }
  796. // Make sure it works.
  797. require(dirname(__FILE__) . '/Settings.php');
  798. // UTF-8 requires a setting to override the language charset.
  799. if (isset($_POST['utf8']) && !empty($databases[$db_type]['utf8_support']))
  800. {
  801. if (version_compare($databases[$db_type]['utf8_version'], preg_replace('~\-.+?$~', '', eval($databases[$db_type]['utf8_version_check'])), '>'))
  802. {
  803. $incontext['error'] = sprintf($txt['error_utf8_version'], $databases[$db_type]['utf8_version']);
  804. return false;
  805. }
  806. else
  807. // Set the character set here.
  808. updateSettingsFile(array('db_character_set' => 'utf8'));
  809. }
  810. // Good, skip on.
  811. return true;
  812. }
  813. return false;
  814. }
  815. // Step one: Do the SQL thang.
  816. function DatabasePopulation()
  817. {
  818. global $db_character_set, $txt, $db_connection, $smcFunc, $databases, $modSettings, $db_type, $sourcedir, $db_prefix, $incontext, $db_name, $boardurl;
  819. $incontext['sub_template'] = 'populate_database';
  820. $incontext['page_title'] = $txt['db_populate'];
  821. $incontext['continue'] = 1;
  822. // Already done?
  823. if (isset($_POST['pop_done']))
  824. return true;
  825. // Reload settings.
  826. require(dirname(__FILE__) . '/Settings.php');
  827. load_database();
  828. // Before running any of the queries, let's make sure another version isn't already installed.
  829. $result = $smcFunc['db_query']('', '
  830. SELECT variable, value
  831. FROM {db_prefix}settings',
  832. array(
  833. 'db_error_skip' => true,
  834. )
  835. );
  836. $modSettings = array();
  837. if ($result !== false)
  838. {
  839. while ($row = $smcFunc['db_fetch_assoc']($result))
  840. $modSettings[$row['variable']] = $row['value'];
  841. $smcFunc['db_free_result']($result);
  842. // Do they match? If so, this is just a refresh so charge on!
  843. if (!isset($modSettings['smfVersion']) || $modSettings['smfVersion'] != $GLOBALS['current_smf_version'])
  844. {
  845. $incontext['error'] = $txt['error_versions_do_not_match'];
  846. return false;
  847. }
  848. }
  849. $modSettings['disableQueryCheck'] = true;
  850. // If doing UTF8, select it. PostgreSQL requires passing it as a string...
  851. if (!empty($db_character_set) && $db_character_set == 'utf8' && !empty($databases[$db_type]['utf8_support']))
  852. $smcFunc['db_query']('', '
  853. SET NAMES {'. ($db_type == 'postgresql' ? 'string' : 'raw') . ':utf8}',
  854. array(
  855. 'db_error_skip' => true,
  856. 'utf8' => 'utf8',
  857. )
  858. );
  859. $replaces = array(
  860. '{$db_prefix}' => $db_prefix,
  861. '{$boarddir}' => $smcFunc['db_escape_string'](dirname(__FILE__)),
  862. '{$boardurl}' => $boardurl,
  863. '{$enableCompressedOutput}' => isset($_POST['compress']) ? '1' : '0',
  864. '{$databaseSession_enable}' => isset($_POST['dbsession']) ? '1' : '0',
  865. '{$smf_version}' => $GLOBALS['current_smf_version'],
  866. '{$current_time}' => time(),
  867. '{$sched_task_offset}' => 82800 + mt_rand(0, 86399),
  868. );
  869. foreach ($txt as $key => $value)
  870. {
  871. if (substr($key, 0, 8) == 'default_')
  872. $replaces['{$' . $key . '}'] = $smcFunc['db_escape_string']($value);
  873. }
  874. $replaces['{$default_reserved_names}'] = strtr($replaces['{$default_reserved_names}'], array('\\\\n' => '\\n'));
  875. // If the UTF-8 setting was enabled, add it to the table definitions.
  876. // @todo Very MySQL specific still
  877. if ($db_type == 'mysql' && isset($_POST['utf8']) && !empty($databases[$db_type]['utf8_support']))
  878. $replaces[') ENGINE=MyISAM;'] = ') ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;';
  879. // Read in the SQL. Turn this on and that off... internationalize... etc.
  880. $sql_lines = explode("\n", strtr(implode(' ', file(dirname(__FILE__) . '/install_' . $GLOBALS['db_script_version'] . '_' . $db_type . '.sql')), $replaces));
  881. // Execute the SQL.
  882. $current_statement = '';
  883. $exists = array();
  884. $incontext['failures'] = array();
  885. $incontext['sql_results'] = array(
  886. 'tables' => 0,
  887. 'inserts' => 0,
  888. 'table_dups' => 0,
  889. 'insert_dups' => 0,
  890. );
  891. foreach ($sql_lines as $count => $line)
  892. {
  893. // No comments allowed!
  894. if (substr(trim($line), 0, 1) != '#')
  895. $current_statement .= "\n" . rtrim($line);
  896. // Is this the end of the query string?
  897. if (empty($current_statement) || (preg_match('~;[\s]*$~s', $line) == 0 && $count != count($sql_lines)))
  898. continue;
  899. // Does this table already exist? If so, don't insert more data into it!
  900. if (preg_match('~^\s*INSERT INTO ([^\s\n\r]+?)~', $current_statement, $match) != 0 && in_array($match[1], $exists))
  901. {
  902. $incontext['sql_results']['insert_dups']++;
  903. $current_statement = '';
  904. continue;
  905. }
  906. if ($smcFunc['db_query']('', $current_statement, array('security_override' => true, 'db_error_skip' => true), $db_connection) === false)
  907. {
  908. // Error 1050: Table already exists!
  909. // @todo Needs to be made better!
  910. if (($db_type != 'mysql' || mysql_errno($db_connection) === 1050) && preg_match('~^\s*CREATE TABLE ([^\s\n\r]+?)~', $current_statement, $match) == 1)
  911. {
  912. $exists[] = $match[1];
  913. $incontext['sql_results']['table_dups']++;
  914. }
  915. // Don't error on duplicate indexes (or duplicate operators in PostgreSQL.)
  916. elseif (!preg_match('~^\s*CREATE( UNIQUE)? INDEX ([^\n\r]+?)~', $current_statement, $match) && !($db_type == 'postgresql' && preg_match('~^\s*CREATE OPERATOR (^\n\r]+?)~', $current_statement, $match)))
  917. {
  918. $incontext['failures'][$count] = $smcFunc['db_error']();
  919. }
  920. }
  921. else
  922. {
  923. if (preg_match('~^\s*CREATE TABLE ([^\s\n\r]+?)~', $current_statement, $match) == 1)
  924. $incontext['sql_results']['tables']++;
  925. else
  926. {
  927. preg_match_all('~\)[,;]~', $current_statement, $matches);
  928. if (!empty($matches[0]))
  929. $incontext['sql_results']['inserts'] += count($matches[0]);
  930. else
  931. $incontext['sql_results']['inserts']++;
  932. }
  933. }
  934. $current_statement = '';
  935. }
  936. // Sort out the context for the SQL.
  937. foreach ($incontext['sql_results'] as $key => $number)
  938. {
  939. if ($number == 0)
  940. unset($incontext['sql_results'][$key]);
  941. else
  942. $incontext['sql_results'][$key] = sprintf($txt['db_populate_' . $key], $number);
  943. }
  944. // Make sure UTF will be used globally.
  945. if (isset($_POST['utf8']) && !empty($databases[$db_type]['utf8_support']))
  946. $smcFunc['db_insert']('replace',
  947. $db_prefix . 'settings',
  948. array(
  949. 'variable' => 'string-255', 'value' => 'string-65534',
  950. ),
  951. array(
  952. 'global_character_set', 'UTF-8',
  953. ),
  954. array('variable')
  955. );
  956. // Maybe we can auto-detect better cookie settings?
  957. preg_match('~^http[s]?://([^\.]+?)([^/]*?)(/.*)?$~', $boardurl, $matches);
  958. if (!empty($matches))
  959. {
  960. // Default = both off.
  961. $localCookies = false;
  962. $globalCookies = false;
  963. // Okay... let's see. Using a subdomain other than www.? (not a perfect check.)
  964. if ($matches[2] != '' && (strpos(substr($matches[2], 1), '.') === false || in_array($matches[1], array('forum', 'board', 'community', 'forums', 'support', 'chat', 'help', 'talk', 'boards', 'www'))))
  965. $globalCookies = true;
  966. // If there's a / in the middle of the path, or it starts with ~... we want local.
  967. if (isset($matches[3]) && strlen($matches[3]) > 3 && (substr($matches[3], 0, 2) == '/~' || strpos(substr($matches[3], 1), '/') !== false))
  968. $localCookies = true;
  969. if ($globalCookies)
  970. $rows[] = array('globalCookies', '1');
  971. if ($localCookies)
  972. $rows[] = array('localCookies', '1');
  973. if (!empty($rows))
  974. {
  975. $smcFunc['db_insert']('replace',
  976. $db_prefix . 'settings',
  977. array('variable' => 'string-255', 'value' => 'string-65534'),
  978. $rows,
  979. array('variable')
  980. );
  981. }
  982. }
  983. // Are we allowing stat collection?
  984. if (isset($_POST['stats']) && strpos($_POST['boardurl'], 'http://localhost') !== 0)
  985. {
  986. // Attempt to register the site etc.
  987. $fp = @fsockopen("www.simplemachines.org", 80, $errno, $errstr);
  988. if ($fp)
  989. {
  990. $out = "GET /smf/stats/register_stats.php?site=" . base64_encode($_POST['boardurl']) . " HTTP/1.1\r\n";
  991. $out .= "Host: www.simplemachines.org\r\n";
  992. $out .= "Connection: Close\r\n\r\n";
  993. fwrite($fp, $out);
  994. $return_data = '';
  995. while (!feof($fp))
  996. $return_data .= fgets($fp, 128);
  997. fclose($fp);
  998. // Get the unique site ID.
  999. preg_match('~SITE-ID:\s(\w{10})~', $return_data, $ID);
  1000. if (!empty($ID[1]))
  1001. $smcFunc['db_insert']('',
  1002. $db_prefix . 'settings',
  1003. array(
  1004. 'variable' => 'string-255', 'value' => 'string-65534',
  1005. ),
  1006. array(
  1007. 'allow_sm_stats', $ID[1],
  1008. ),
  1009. array('variable')
  1010. );
  1011. }
  1012. }
  1013. // As of PHP 5.1, setting a timezone is required.
  1014. if (!isset($modSettings['default_timezone']) && function_exists('date_default_timezone_set'))
  1015. {
  1016. $server_offset = mktime(0, 0, 0, 1, 1, 1970);
  1017. $timezone_id = 'Etc/GMT' . ($server_offset > 0 ? '+' : '') . ($server_offset / 3600);
  1018. if (date_default_timezone_set($timezone_id))
  1019. $smcFunc['db_insert']('',
  1020. $db_prefix . 'settings',
  1021. array(
  1022. 'variable' => 'string-255', 'value' => 'string-65534',
  1023. ),
  1024. array(
  1025. 'default_timezone', $timezone_id,
  1026. ),
  1027. array('variable')
  1028. );
  1029. }
  1030. // Let's optimize those new tables.
  1031. db_extend();
  1032. $tables = $smcFunc['db_list_tables']($db_name, $db_prefix . '%');
  1033. foreach ($tables as $table)
  1034. {
  1035. $smcFunc['db_optimize_table']($table) != -1 or $db_messed = true;
  1036. // Optimizing one sqlite table, optimizes them all
  1037. if($db_type == 'sqlite')
  1038. break;
  1039. if (!empty($db_messed))
  1040. {
  1041. $incontext['failures'][-1] = $smcFunc['db_error']();
  1042. break;
  1043. }
  1044. }
  1045. // Check for the ALTER privilege.
  1046. if (!empty($databases[$db_type]['alter_support']) && $smcFunc['db_query']('', "ALTER TABLE {$db_prefix}boards ORDER BY id_board", array('security_override' => true, 'db_error_skip' => true)) === false)
  1047. {
  1048. $incontext['error'] = $txt['error_db_alter_priv'];
  1049. return false;
  1050. }
  1051. if (!empty($exists))
  1052. {
  1053. $incontext['page_title'] = $txt['user_refresh_install'];
  1054. $incontext['was_refresh'] = true;
  1055. }
  1056. return false;
  1057. }
  1058. // Ask for the administrator login information.
  1059. function AdminAccount()
  1060. {
  1061. global $txt, $db_type, $db_connection, $databases, $smcFunc, $incontext, $db_prefix, $db_passwd, $sourcedir;
  1062. $incontext['sub_template'] = 'admin_account';
  1063. $incontext['page_title'] = $txt['user_settings'];
  1064. $incontext['continue'] = 1;
  1065. // Skipping?
  1066. if (!empty($_POST['skip']))
  1067. return true;
  1068. // Need this to check whether we need the database password.
  1069. require(dirname(__FILE__) . '/Settings.php');
  1070. load_database();
  1071. // Define the sha1 function, if it doesn't exist.
  1072. if (!function_exists('sha1') || version_compare(PHP_VERSION, '5', '<'))
  1073. require_once($sourcedir . '/Subs-Compat.php');
  1074. if (!isset($_POST['username']))
  1075. $_POST['username'] = '';
  1076. if (!isset($_POST['email']))
  1077. $_POST['email'] = '';
  1078. $incontext['username'] = htmlspecialchars(stripslashes($_POST['username']));
  1079. $incontext['email'] = htmlspecialchars(stripslashes($_POST['email']));
  1080. $incontext['require_db_confirm'] = empty($db_type) || $db_type != 'sqlite';
  1081. // Only allow skipping if we think they already have an account setup.
  1082. $request = $smcFunc['db_query']('', '
  1083. SELECT id_member
  1084. FROM {db_prefix}members
  1085. WHERE id_group = {int:admin_group} OR FIND_IN_SET({int:admin_group}, additional_groups) != 0
  1086. LIMIT 1',
  1087. array(
  1088. 'db_error_skip' => true,
  1089. 'admin_group' => 1,
  1090. )
  1091. );
  1092. if ($smcFunc['db_num_rows']($request) != 0)
  1093. $incontext['skip'] = 1;
  1094. $smcFunc['db_free_result']($request);
  1095. // Trying to create an account?
  1096. if (isset($_POST['password1']) && !empty($_POST['contbutt']))
  1097. {
  1098. // Wrong password?
  1099. print_r($_POST['password3']) . '<br />';
  1100. print_r($db_passwd) . '<br />';
  1101. if ($incontext['require_db_confirm'] && $_POST['password3'] != $db_passwd)
  1102. {
  1103. $incontext['error'] = $txt['error_db_connect'];
  1104. return false;
  1105. }
  1106. // Not matching passwords?
  1107. if ($_POST['password1'] != $_POST['password2'])
  1108. {
  1109. $incontext['error'] = $txt['error_user_settings_again_match'];
  1110. return false;
  1111. }
  1112. // No password?
  1113. if (strlen($_POST['password1']) < 4)
  1114. {
  1115. $incontext['error'] = $txt['error_user_settings_no_password'];
  1116. return false;
  1117. }
  1118. if (!file_exists($sourcedir . '/Subs.php'))
  1119. {
  1120. $incontext['error'] = $txt['error_subs_missing'];
  1121. return false;
  1122. }
  1123. // Update the main contact email?
  1124. if (!empty($_POST['email']) && (empty($webmaster_email) || $webmaster_email == 'noreply@myserver.com'))
  1125. updateSettingsFile(array('webmaster_email' => $_POST['email']));
  1126. // Work out whether we're going to have dodgy characters and remove them.
  1127. $invalid_characters = preg_match('~[<>&"\'=\\\]~', $_POST['username']) != 0;
  1128. $_POST['username'] = preg_replace('~[<>&"\'=\\\]~', '', $_POST['username']);
  1129. $result = $smcFunc['db_query']('', '
  1130. SELECT id_member, password_salt
  1131. FROM {db_prefix}members
  1132. WHERE member_name = {string:username} OR email_address = {string:email}
  1133. LIMIT 1',
  1134. array(
  1135. 'username' => stripslashes($_POST['username']),
  1136. 'email' => stripslashes($_POST['email']),
  1137. 'db_error_skip' => true,
  1138. )
  1139. );
  1140. if ($smcFunc['db_num_rows']($result) != 0)
  1141. {
  1142. list ($incontext['member_id'], $incontext['member_salt']) = $smcFunc['db_fetch_row']($result);
  1143. $smcFunc['db_free_result']($result);
  1144. $incontext['account_existed'] = $txt['error_user_settings_taken'];
  1145. }
  1146. elseif ($_POST['username'] == '' || strlen($_POST['username']) > 25)
  1147. {
  1148. // Try the previous step again.
  1149. $incontext['error'] = $_POST['username'] == '' ? $txt['error_username_left_empty'] : $txt['error_username_too_long'];
  1150. return false;
  1151. }
  1152. elseif ($invalid_characters || $_POST['username'] == '_' || $_POST['username'] == '|' || strpos($_POST['username'], '[code') !== false || strpos($_POST['username'], '[/code') !== false)
  1153. {
  1154. // Try the previous step again.
  1155. $incontext['error'] = $txt['error_invalid_characters_username'];
  1156. return false;
  1157. }
  1158. elseif (empty($_POST['email']) || preg_match('~^[0-9A-Za-z=_+\-/][0-9A-Za-z=_\'+\-/\.]*@[\w\-]+(\.[\w\-]+)*(\.[\w]{2,6})$~', stripslashes($_POST['email'])) === 0 || strlen(stripslashes($_POST['email'])) > 255)
  1159. {
  1160. // One step back, this time fill out a proper email address.
  1161. $incontext['error'] = sprintf($txt['error_valid_email_needed'], $_POST['username']);
  1162. return false;
  1163. }
  1164. elseif ($_POST['username'] != '')
  1165. {
  1166. $incontext['member_salt'] = substr(md5(mt_rand()), 0, 4);
  1167. // Format the username properly.
  1168. $_POST['username'] = preg_replace('~[\t\n\r\x0B\0\xA0]+~', ' ', $_POST['username']);
  1169. $ip = isset($_SERVER['REMOTE_ADDR']) ? substr($_SERVER['REMOTE_ADDR'], 0, 255) : '';
  1170. $request = $smcFunc['db_insert']('',
  1171. $db_prefix . 'members',
  1172. array(
  1173. 'member_name' => 'string-25', 'real_name' => 'string-25', 'passwd' => 'string', 'email_address' => 'string',
  1174. 'id_group' => 'int', 'posts' => 'int', 'date_registered' => 'int', 'hide_email' => 'int',
  1175. 'password_salt' => 'string', 'lngfile' => 'string', 'personal_text' => 'string', 'avatar' => 'string',
  1176. 'member_ip' => 'string', 'member_ip2' => 'string', 'buddy_list' => 'string', 'pm_ignore_list' => 'string',
  1177. 'message_labels' => 'string', 'website_title' => 'string', 'website_url' => 'string', 'location' => 'string',
  1178. 'aim' => 'string', 'icq' => 'string', 'msn' => 'string', 'signature' => 'string', 'usertitle' => 'string', 'secret_question' => 'string',
  1179. 'additional_groups' => 'string', 'ignore_boards' => 'string', 'openid_uri' => 'string',
  1180. ),
  1181. array(
  1182. stripslashes($_POST['username']), stripslashes($_POST['username']), sha1(strtolower(stripslashes($_POST['username'])) . stripslashes($_POST['password1'])), stripslashes($_POST['email']),
  1183. 1, 0, time(), 0,
  1184. $incontext['member_salt'], '', '', '',
  1185. $ip, $ip, '', '',
  1186. '', '', '', '',
  1187. '', '', '', '', '', '',
  1188. '', '', '',
  1189. ),
  1190. array('id_member')
  1191. );
  1192. // Awww, crud!
  1193. if ($request === false)
  1194. {
  1195. $incontext['error'] = $txt['error_user_settings_query'] . '<br />
  1196. <div style="margin: 2ex;">' . nl2br(htmlspecialchars($smcFunc['db_error']($db_connection))) . '</div>';
  1197. return false;
  1198. }
  1199. $incontext['member_id'] = $smcFunc['db_insert_id']("{$db_prefix}members", 'id_member');
  1200. }
  1201. // If we're here we're good.
  1202. return true;
  1203. }
  1204. return false;
  1205. }
  1206. // Final step, clean up and a complete message!
  1207. function DeleteInstall()
  1208. {
  1209. global $txt, $db_prefix, $db_connection, $HTTP_SESSION_VARS, $cookiename, $incontext;
  1210. global $smcFunc, $db_character_set, $mbname, $context, $scripturl, $boardurl;
  1211. global $current_smf_version, $databases, $sourcedir, $forum_version, $modSettings, $user_info, $language, $db_type;
  1212. $incontext['page_title'] = $txt['congratulations'];
  1213. $incontext['sub_template'] = 'delete_install';
  1214. $incontext['continue'] = 0;
  1215. require(dirname(__FILE__) . '/Settings.php');
  1216. load_database();
  1217. chdir(dirname(__FILE__));
  1218. require_once($sourcedir . '/Errors.php');
  1219. require_once($sourcedir . '/Logging.php');
  1220. require_once($sourcedir . '/Subs.php');
  1221. require_once($sourcedir . '/Load.php');
  1222. require_once($sourcedir . '/Security.php');
  1223. require_once($sourcedir . '/Subs-Auth.php');
  1224. // Bring a warning over.
  1225. if (!empty($incontext['account_existed']))
  1226. $incontext['warning'] = $incontext['account_existed'];
  1227. if (!empty($db_character_set) && !empty($databases[$db_type]['utf8_support']))
  1228. $smcFunc['db_query']('', '
  1229. SET NAMES {raw:db_character_set}',
  1230. array(
  1231. 'db_character_set' => $db_character_set,
  1232. 'db_error_skip' => true,
  1233. )
  1234. );
  1235. // As track stats is by default enabled let's add some activity.
  1236. $smcFunc['db_insert']('ignore',
  1237. '{db_prefix}log_activity',
  1238. array('date' => 'date', 'topics' => 'int', 'posts' => 'int', 'registers' => 'int'),
  1239. array(strftime('%Y-%m-%d', time()), 1, 1, (!empty($incontext['member_id']) ? 1 : 0)),
  1240. array('date')
  1241. );
  1242. // We're going to want our lovely $modSettings now.
  1243. $request = $smcFunc['db_query']('', '
  1244. SELECT variable, value
  1245. FROM {db_prefix}settings',
  1246. array(
  1247. 'db_error_skip' => true,
  1248. )
  1249. );
  1250. // Only proceed if we can load the data.
  1251. if ($request)
  1252. {
  1253. while ($row = $smcFunc['db_fetch_row']($request))
  1254. $modSettings[$row[0]] = $row[1];
  1255. $smcFunc['db_free_result']($request);
  1256. }
  1257. // Automatically log them in ;)
  1258. if (isset($incontext['member_id']) && isset($incontext['member_salt']))
  1259. setLoginCookie(3153600 * 60, $incontext['member_id'], sha1(sha1(strtolower($_POST['username']) . $_POST['password1']) . $incontext['member_salt']));
  1260. $result = $smcFunc['db_query']('', '
  1261. SELECT value
  1262. FROM {db_prefix}settings
  1263. WHERE variable = {string:db_sessions}',
  1264. array(
  1265. 'db_sessions' => 'databaseSession_enable',
  1266. 'db_error_skip' => true,
  1267. )
  1268. );
  1269. if ($smcFunc['db_num_rows']($result) != 0)
  1270. list ($db_sessions) = $smcFunc['db_fetch_row']($result);
  1271. $smcFunc['db_free_result']($result);
  1272. if (empty($db_sessions))
  1273. $_SESSION['admin_time'] = time();
  1274. else
  1275. {
  1276. $_SERVER['HTTP_USER_AGENT'] = substr($_SERVER['HTTP_USER_AGENT'], 0, 211);
  1277. $smcFunc['db_insert']('replace',
  1278. '{db_prefix}sessions',
  1279. array(
  1280. 'session_id' => 'string', 'last_update' => 'int', 'data' => 'string',
  1281. ),
  1282. array(
  1283. session_id(), time(), 'USER_AGENT|s:' . strlen($_SERVER['HTTP_USER_AGENT']) . ':"' . $_SERVER['HTTP_USER_AGENT'] . '";admin_time|i:' . time() . ';',
  1284. ),
  1285. array('session_id')
  1286. );
  1287. }
  1288. updateStats('member');
  1289. updateStats('message');
  1290. updateStats('topic');
  1291. // This function is needed to do the updateStats('subject') call.
  1292. $smcFunc['strtolower'] = $db_character_set === 'utf8' || $txt['lang_character_set'] === 'UTF-8' ? create_function('$string', '
  1293. return $string;') : 'strtolower';
  1294. $request = $smcFunc['db_query']('', '
  1295. SELECT id_msg
  1296. FROM {db_prefix}messages
  1297. WHERE id_msg = 1
  1298. AND modified_time = 0
  1299. LIMIT 1',
  1300. array(
  1301. 'db_error_skip' => true,
  1302. )
  1303. );
  1304. if ($smcFunc['db_num_rows']($request) > 0)
  1305. updateStats('subject', 1, htmlspecialchars($txt['default_topic_subject']));
  1306. $smcFunc['db_free_result']($request);
  1307. // Now is the perfect time to fetch the SM files.
  1308. require_once($sourcedir . '/ScheduledTasks.php');
  1309. // Sanity check that they loaded earlier!
  1310. if (isset($modSettings['recycle_board']))
  1311. {
  1312. $forum_version = $current_smf_version; // The variable is usually defined in index.php so lets just use our variable to do it for us.
  1313. scheduled_fetchSMfiles(); // Now go get those files!
  1314. // We've just installed!
  1315. $user_info['ip'] = $_SERVER['REMOTE_ADDR'];
  1316. $user_info['id'] = isset($incontext['member_id']) ? $incontext['member_id'] : 0;
  1317. logAction('install', array('version' => $forum_version), 'admin');
  1318. }
  1319. // Check if we need some stupid MySQL fix.
  1320. $server_version = $smcFunc['db_server_info']();
  1321. if ($db_type == 'mysql' && in_array(substr($server_version, 0, 6), array('5.0.50', '5.0.51')))
  1322. updateSettings(array('db_mysql_group_by_fix' => '1'));
  1323. // Some final context for the template.
  1324. $incontext['dir_still_writable'] = is_writable(dirname(__FILE__)) && substr(__FILE__, 1, 2) != ':\\';
  1325. $incontext['probably_delete_install'] = isset($_SESSION['installer_temp_ftp']) || is_writable(dirname(__FILE__)) || is_writable(__FILE__);
  1326. return false;
  1327. }
  1328. // http://www.faqs.org/rfcs/rfc959.html
  1329. class ftp_connection
  1330. {
  1331. var $connection = 'no_connection', $error = false, $last_message, $pasv = array();
  1332. // Create a new FTP connection...
  1333. function ftp_connection($ftp_server, $ftp_port = 21, $ftp_user = 'anonymous', $ftp_pass = 'ftpclient@simplemachines.org')
  1334. {
  1335. if ($ftp_server !== null)
  1336. $this->connect($ftp_server, $ftp_port, $ftp_user, $ftp_pass);
  1337. }
  1338. function connect($ftp_server, $ftp_port = 21, $ftp_user = 'anonymous', $ftp_pass = 'ftpclient@simplemachines.org')
  1339. {
  1340. if (substr($ftp_server, 0, 6) == 'ftp://')
  1341. $ftp_server = substr($ftp_server, 6);
  1342. elseif (substr($ftp_server, 0, 7) == 'ftps://')
  1343. $ftp_server = 'ssl://' . substr($ftp_server, 7);
  1344. if (substr($ftp_server, 0, 7) == 'http://')
  1345. $ftp_server = substr($ftp_server, 7);
  1346. $ftp_server = strtr($ftp_server, array('/' => '', ':' => '', '@' => ''));
  1347. // Connect to the FTP server.
  1348. $this->connection = @fsockopen($ftp_server, $ftp_port, $err, $err, 5);
  1349. if (!$this->connection)
  1350. {
  1351. $this->error = 'bad_server';
  1352. return;
  1353. }
  1354. // Get the welcome message...
  1355. if (!$this->check_response(220))
  1356. {
  1357. $this->error = 'bad_response';
  1358. return;
  1359. }
  1360. // Send the username, it should ask for a password.
  1361. fwrite($this->connection, 'USER ' . $ftp_user . "\r\n");
  1362. if (!$this->check_response(331))
  1363. {
  1364. $this->error = 'bad_username';
  1365. return;
  1366. }
  1367. // Now send the password... and hope it goes okay.
  1368. fwrite($this->connection, 'PASS ' . $ftp_pass . "\r\n");
  1369. if (!$this->check_response(230))
  1370. {
  1371. $this->error = 'bad_password';
  1372. return;
  1373. }
  1374. }
  1375. function chdir($ftp_path)
  1376. {
  1377. if (!is_resource($this->connection))
  1378. return false;
  1379. // No slash on the end, please...
  1380. if (substr($ftp_path, -1) == '/')
  1381. $ftp_path = substr($ftp_path, 0, -1);
  1382. fwrite($this->connection, 'CWD ' . $ftp_path . "\r\n");
  1383. if (!$this->check_response(250))
  1384. {
  1385. $this->error = 'bad_path';
  1386. return false;
  1387. }
  1388. return true;
  1389. }
  1390. function chmod($ftp_file, $chmod)
  1391. {
  1392. if (!is_resource($this->connection))
  1393. return false;
  1394. // Convert the chmod value from octal (0777) to text ("777")
  1395. fwrite($this->connection, 'SITE CHMOD ' . decoct($chmod) . ' ' . $ftp_file . "\r\n");
  1396. if (!$this->check_response(200))
  1397. {
  1398. $this->error = 'bad_file';
  1399. return false;
  1400. }
  1401. return true;
  1402. }
  1403. function unlink($ftp_file)
  1404. {
  1405. // We are actually connected, right?
  1406. if (!is_resource($this->connection))
  1407. return false;
  1408. // Delete file X.
  1409. fwrite($this->connection, 'DELE ' . $ftp_file . "\r\n");
  1410. if (!$this->check_response(250))
  1411. {
  1412. fwrite($this->connection, 'RMD ' . $ftp_file . "\r\n");
  1413. // Still no love?
  1414. if (!$this->check_response(250))
  1415. {
  1416. $this->error = 'bad_file';
  1417. return false;
  1418. }
  1419. }
  1420. return true;
  1421. }
  1422. function check_response($desired)
  1423. {
  1424. // Wait for a response that isn't continued with -, but don't wait too long.
  1425. $time = time();
  1426. do
  1427. $this->last_message = fgets($this->connection, 1024);
  1428. while (substr($this->last_message, 3, 1) != ' ' && time() - $time < 5);
  1429. // Was the desired response returned?
  1430. return is_array($desired) ? in_array(substr($this->last_message, 0, 3), $desired) : substr($this->last_message, 0, 3) == $desired;
  1431. }
  1432. function passive()
  1433. {
  1434. // We can't create a passive data connection without a primary one first being there.
  1435. if (!is_resource($this->connection))
  1436. return false;
  1437. // Request a passive connection - this means, we'll talk to you, you don't talk to us.
  1438. @fwrite($this->connection, "PASV\r\n");
  1439. $time = time();
  1440. do
  1441. $response = fgets($this->connection, 1024);
  1442. while (substr($response, 3, 1) != ' ' && time() - $time < 5);
  1443. // If it's not 227, we weren't given an IP and port, which means it failed.
  1444. if (substr($response, 0, 4) != '227 ')
  1445. {
  1446. $this->error = 'bad_response';
  1447. return false;
  1448. }
  1449. // Snatch the IP and port information, or die horribly trying...
  1450. if (preg_match('~\((\d+),\s*(\d+),\s*(\d+),\s*(\d+),\s*(\d+)(?:,\s*(\d+))\)~', $response, $match) == 0)
  1451. {
  1452. $this->error = 'bad_response';
  1453. return false;
  1454. }
  1455. // This is pretty simple - store it for later use ;)
  1456. $this->pasv = array('ip' => $match[1] . '.' . $match[2] . '.' . $match[3] . '.' . $match[4], 'port' => $match[5] * 256 + $match[6]);
  1457. return true;
  1458. }
  1459. function create_file($ftp_file)
  1460. {
  1461. // First, we have to be connected... very important.
  1462. if (!is_resource($this->connection))
  1463. return false;
  1464. // I'd like one passive mode, please!
  1465. if (!$this->passive())
  1466. return false;
  1467. // Seems logical enough, so far...
  1468. fwrite($this->connection, 'STOR ' . $ftp_file . "\r\n");
  1469. // Okay, now we connect to the data port. If it doesn't work out, it's probably "file already exists", etc.
  1470. $fp = @fsockopen($this->pasv['ip'], $this->pasv['port'], $err, $err, 5);
  1471. if (!$fp || !$this->check_response(150))
  1472. {
  1473. $this->error = 'bad_file';
  1474. @fclose($fp);
  1475. return false;
  1476. }
  1477. // This may look strange, but we're just closing it to indicate a zero-byte upload.
  1478. fclose($fp);
  1479. if (!$this->check_response(226))
  1480. {
  1481. $this->error = 'bad_response';
  1482. return false;
  1483. }
  1484. return true;
  1485. }
  1486. function list_dir($ftp_path = '', $search = false)
  1487. {
  1488. // Are we even connected...?
  1489. if (!is_resource($this->connection))
  1490. return false;
  1491. // Passive... non-agressive...
  1492. if (!$this->passive())
  1493. return false;
  1494. // Get the listing!
  1495. fwrite($this->connection, 'LIST -1' . ($search ? 'R' : '') . ($ftp_path == '' ? '' : ' ' . $ftp_path) . "\r\n");
  1496. // Connect, assuming we've got a connection.
  1497. $fp = @fsockopen($this->pasv['ip'], $this->pasv['port'], $err, $err, 5);
  1498. if (!$fp || !$this->check_response(array(150, 125)))
  1499. {
  1500. $this->error = 'bad_response';
  1501. @fclose($fp);
  1502. return false;
  1503. }
  1504. // Read in the file listing.
  1505. $data = '';
  1506. while (!feof($fp))
  1507. $data .= fread($fp, 4096);
  1508. fclose($fp);
  1509. // Everything go okay?
  1510. if (!$this->check_response(226))
  1511. {
  1512. $this->error = 'bad_response';
  1513. return false;
  1514. }
  1515. return $data;
  1516. }
  1517. function locate($file, $listing = null)
  1518. {
  1519. if ($listing === null)
  1520. $listing = $this->list_dir('', true);
  1521. $listing = explode("\n", $listing);
  1522. @fwrite($this->connection, "PWD\r\n");
  1523. $time = time();
  1524. do
  1525. $response = fgets($this->connection, 1024);
  1526. while (substr($response, 3, 1) != ' ' && time() - $time < 5);
  1527. // Check for 257!
  1528. if (preg_match('~^257 "(.+?)" ~', $response, $match) != 0)
  1529. $current_dir = strtr($match[1], array('""' => '"'));
  1530. else
  1531. $current_dir = '';
  1532. for ($i = 0, $n = count($listing); $i < $n; $i++)
  1533. {
  1534. if (trim($listing[$i]) == '' && isset($listing[$i + 1]))
  1535. {
  1536. $current_dir = substr(trim($listing[++$i]), 0, -1);
  1537. $i++;
  1538. }
  1539. // Okay, this file's name is:
  1540. $listing[$i] = $current_dir . '/' . trim(strlen($listing[$i]) > 30 ? strrchr($listing[$i], ' ') : $listing[$i]);
  1541. if (substr($file, 0, 1) == '*' && substr($listing[$i], -(strlen($file) - 1)) == substr($file, 1))
  1542. return $listing[$i];
  1543. if (substr($file, -1) == '*' && substr($listing[$i], 0, strlen($file) - 1) == substr($file, 0, -1))
  1544. return $listing[$i];
  1545. if (basename($listing[$i]) == $file || $listing[$i] == $file)
  1546. return $listing[$i];
  1547. }
  1548. return false;
  1549. }
  1550. function create_dir($ftp_dir)
  1551. {
  1552. // We must be connected to the server to do something.
  1553. if (!is_resource($this->connection))
  1554. return false;
  1555. // Make this new beautiful directory!
  1556. fwrite($this->connection, 'MKD ' . $ftp_dir . "\r\n");
  1557. if (!$this->check_response(257))
  1558. {
  1559. $this->error = 'bad_file';
  1560. return false;
  1561. }
  1562. return true;
  1563. }
  1564. function detect_path($filesystem_path, $lookup_file = null)
  1565. {
  1566. $username = '';
  1567. if (isset($_SERVER['DOCUMENT_ROOT']))
  1568. {
  1569. if (preg_match('~^/home[2]?/([^/]+?)/public_html~', $_SERVER['DOCUMENT_ROOT'], $match))
  1570. {
  1571. $username = $match[1];
  1572. $path = strtr($_SERVER['DOCUMENT_ROOT'], array('/home/' . $match[1] . '/' => '', '/home2/' . $match[1] . '/' => ''));
  1573. if (substr($path, -1) == '/')
  1574. $path = substr($path, 0, -1);
  1575. if (strlen(dirname($_SERVER['PHP_SELF'])) > 1)
  1576. $path .= dirname($_SERVER['PHP_SELF']);
  1577. }
  1578. elseif (substr($filesystem_path, 0, 9) == '/var/www/')
  1579. $path = substr($filesystem_path, 8);
  1580. else
  1581. $path = strtr(strtr($filesystem_path, array('\\' => '/')), array($_SERVER['DOCUMENT_ROOT'] => ''));
  1582. }
  1583. else
  1584. $path = '';
  1585. if (is_resource($this->connection) && $this->list_dir($path) == '')
  1586. {
  1587. $data = $this->list_dir('', true);
  1588. if ($lookup_file === null)
  1589. $lookup_file = $_SERVER['PHP_SELF'];
  1590. $found_path = dirname($this->locate('*' . basename(dirname($lookup_file)) . '/' . basename($lookup_file), $data));
  1591. if ($found_path == false)
  1592. $found_path = dirname($this->locate(basename($lookup_file)));
  1593. if ($found_path != false)
  1594. $path = $found_path;
  1595. }
  1596. elseif (is_resource($this->connection))
  1597. $found_path = true;
  1598. return array($username, $path, isset($found_path));
  1599. }
  1600. function close()
  1601. {
  1602. // Goodbye!
  1603. fwrite($this->connection, "QUIT\r\n");
  1604. fclose($this->connection);
  1605. return true;
  1606. }
  1607. }
  1608. function updateSettingsFile($vars)
  1609. {
  1610. // Modify Settings.php.
  1611. $settingsArray = file(dirname(__FILE__) . '/Settings.php');
  1612. // @todo Do we just want to read the file in clean, and split it this way always?
  1613. if (count($settingsArray) == 1)
  1614. $settingsArray = preg_split('~[\r\n]~', $settingsArray[0]);
  1615. for ($i = 0, $n = count($settingsArray); $i < $n; $i++)
  1616. {
  1617. // Remove the redirect...
  1618. if (trim($settingsArray[$i]) == 'if (file_exists(dirname(__FILE__) . \'/install.php\'))' && trim($settingsArray[$i + 1]) == '{' && trim($settingsArray[$i + 3]) == '}')
  1619. {
  1620. // Get the four lines to nothing.
  1621. $settingsArray[$i] = '';
  1622. $settingsArray[++$i] = '';
  1623. $settingsArray[++$i] = '';
  1624. $settingsArray[++$i] = '';
  1625. continue;
  1626. }
  1627. if (trim($settingsArray[$i]) == '?' . '>')
  1628. $settingsArray[$i] = '';
  1629. // Don't trim or bother with it if it's not a variable.
  1630. if (substr($settingsArray[$i], 0, 1) != '$')
  1631. continue;
  1632. $settingsArray[$i] = rtrim($settingsArray[$i]) . "\n";
  1633. foreach ($vars as $var => $val)
  1634. if (strncasecmp($settingsArray[$i], '$' . $var, 1 + strlen($var)) == 0)
  1635. {
  1636. $comment = strstr($settingsArray[$i], '#');
  1637. $settingsArray[$i] = '$' . $var . ' = \'' . $val . '\';' . ($comment != '' ? "\t\t" . $comment : "\n");
  1638. unset($vars[$var]);
  1639. }
  1640. }
  1641. // Uh oh... the file wasn't empty... was it?
  1642. if (!empty($vars))
  1643. {
  1644. $settingsArray[$i++] = '';
  1645. foreach ($vars as $var => $val)
  1646. $settingsArray[$i++] = '$' . $var . ' = \'' . $val . '\';' . "\n";
  1647. }
  1648. // Blank out the file - done to fix a oddity with some servers.
  1649. $fp = @fopen(dirname(__FILE__) . '/Settings.php', 'w');
  1650. if (!$fp)
  1651. return false;
  1652. fclose($fp);
  1653. $fp = fopen(dirname(__FILE__) . '/Settings.php', 'r+');
  1654. // Gotta have one of these ;)
  1655. if (trim($settingsArray[0]) != '<?php')
  1656. fwrite($fp, "<?php\n");
  1657. $lines = count($settingsArray);
  1658. for ($i = 0; $i < $lines - 1; $i++)
  1659. {
  1660. // Don't just write a bunch of blank lines.
  1661. if ($settingsArray[$i] != '' || @$settingsArray[$i - 1] != '')
  1662. fwrite($fp, strtr($settingsArray[$i], "\r", ''));
  1663. }
  1664. fwrite($fp, $settingsArray[$i] . '?' . '>');
  1665. fclose($fp);
  1666. return true;
  1667. }
  1668. function updateDbLastError()
  1669. {
  1670. // Write out the db_last_error file with the error timestamp
  1671. file_put_contents(dirname(__FILE__) . '/db_last_error.php', '<' . '?' . "php\n" . '$db_last_error = 0;' . "\n" . '?' . '>');
  1672. return true;
  1673. }
  1674. // Create an .htaccess file to prevent mod_security. SMF has filtering built-in.
  1675. function fixModSecurity()
  1676. {
  1677. $htaccess_addition = '
  1678. <IfModule mod_security.c>
  1679. # Turn off mod_security filtering. SMF is a big boy, it doesn\'t need its hands held.
  1680. SecFilterEngine Off
  1681. # The below probably isn\'t needed, but better safe than sorry.
  1682. SecFilterScanPOST Off
  1683. </IfModule>';
  1684. if (!function_exists('apache_get_modules') || !in_array('mod_security', apache_get_modules()))
  1685. return true;
  1686. elseif (file_exists(dirname(__FILE__) . '/.htaccess') && is_writable(dirname(__FILE__) . '/.htaccess'))
  1687. {
  1688. $current_htaccess = implode('', file(dirname(__FILE__) . '/.htaccess'));
  1689. // Only change something if mod_security hasn't been addressed yet.
  1690. if (strpos($current_htaccess, '<IfModule mod_security.c>') === false)
  1691. {
  1692. if ($ht_handle = fopen(dirname(__FILE__) . '/.htaccess', 'a'))
  1693. {
  1694. fwrite($ht_handle, $htaccess_addition);
  1695. fclose($ht_handle);
  1696. return true;
  1697. }
  1698. else
  1699. return false;
  1700. }
  1701. else
  1702. return true;
  1703. }
  1704. elseif (file_exists(dirname(__FILE__) . '/.htaccess'))
  1705. return strpos(implode('', file(dirname(__FILE__) . '/.htaccess')), '<IfModule mod_security.c>') !== false;
  1706. elseif (is_writable(dirname(__FILE__)))
  1707. {
  1708. if ($ht_handle = fopen(dirname(__FILE__) . '/.htaccess', 'w'))
  1709. {
  1710. fwrite($ht_handle, $htaccess_addition);
  1711. fclose($ht_handle);
  1712. return true;
  1713. }
  1714. else
  1715. return false;
  1716. }
  1717. else
  1718. return false;
  1719. }
  1720. function template_install_above()
  1721. {
  1722. global $incontext, $txt, $smfsite, $installurl;
  1723. echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  1724. <html xmlns="http://www.w3.org/1999/xhtml"', !empty($txt['lang_rtl']) ? ' dir="rtl"' : '', '>
  1725. <head>
  1726. <meta http-equiv="Content-Type" content="text/html; charset=', isset($txt['lang_character_set']) ? $txt['lang_character_set'] : 'ISO-8859-1', '" />
  1727. <meta name="robots" content="noindex" />
  1728. <title>', $txt['smf_installer'], '</title>
  1729. <link rel="stylesheet" type="text/css" href="Themes/default/css/index.css?alp21" />
  1730. <link rel="stylesheet" type="text/css" href="Themes/default/css/install.css?alp21" />
  1731. <script type="text/javascript" src="Themes/default/scripts/script.js"></script>
  1732. </head>
  1733. <body>
  1734. <div id="header"><div class="frame">
  1735. <div id="top_section">
  1736. <h1 class="forumtitle">', $txt['smf_installer'], '</h1>
  1737. <img id="smflogo" src="Themes/default/images/smflogo.png" alt="Simple Machines Forum" title="Simple Machines Forum" />
  1738. </div>
  1739. <div id="upper_section" class="middletext flow_hidden">
  1740. <div class="user"></div>
  1741. <div class="news normaltext">';
  1742. // Have we got a language drop down - if so do it on the first step only.
  1743. if (!empty($incontext['detected_languages']) && count($incontext['detected_languages']) > 1 && $incontext['current_step'] == 0)
  1744. {
  1745. echo '
  1746. <div class="righttext">
  1747. <form action="', $installurl, '" method="get">
  1748. <label for="installer_language">', $txt['installer_language'], ':</label> <select id="installer_language" name="lang_file" onchange="location.href = \'', $installurl, '?lang_file=\' + this.options[this.selectedIndex].value;">';
  1749. foreach ($incontext['detected_languages'] as $lang => $name)
  1750. echo '
  1751. <option', isset($_SESSION['installer_temp_lang']) && $_SESSION['installer_temp_lang'] == $lang ? ' selected="selected"' : '', ' value="', $lang, '">', $name, '</option>';
  1752. echo '
  1753. </select>
  1754. <noscript><input type="submit" value="', $txt['installer_language_set'], '" class="button_submit" /></noscript>
  1755. </form>
  1756. </div>';
  1757. }
  1758. echo '
  1759. </div>
  1760. </div>
  1761. </div></div>
  1762. <div id="content_section"><div class="frame">
  1763. <div id="main_content_section">
  1764. <div id="main-steps">
  1765. <h2>', $txt['upgrade_progress'], '</h2>
  1766. <ul>';
  1767. foreach ($incontext['steps'] as $num => $step)
  1768. echo '
  1769. <li class="', $num < $incontext['current_step'] ? 'stepdone' : ($num == $incontext['current_step'] ? 'stepcurrent' : 'stepwaiting'), '">', $txt['upgrade_step'], ' ', $step[0], ': ', $step[1], '</li>';
  1770. echo '
  1771. </ul>
  1772. </div>
  1773. <div style="font-size: 12pt; height: 25pt; border: 1px solid black; background: white; float: left; margin-left: 12%; width: 25%;">
  1774. <div id="overall_text" style="padding-top: 8pt; z-index: 2; color: black; margin-left: -4em; position: absolute; text-align: center; font-weight: bold;">', $incontext['overall_percent'], '%</div>
  1775. <div id="overall_progress" style="width: ', $incontext['overall_percent'], '%; height: 25pt; z-index: 1; background-color: lime;">&nbsp;</div>
  1776. <div class="overall_progress">', $txt['upgrade_overall_progress'], '</div>
  1777. </div>
  1778. <div id="main_screen" class="clear">
  1779. <h2>', $incontext['page_title'], '</h2>
  1780. <div class="panel">
  1781. <div style="max-height: 560px; overflow: auto;">';
  1782. }
  1783. function template_install_below()
  1784. {
  1785. global $incontext, $txt;
  1786. if (!empty($incontext['continue']) || !empty($incontext['skip']))
  1787. {
  1788. echo '
  1789. <div class="righttext" style="margin: 1ex;">';
  1790. if (!empty($incontext['continue']))
  1791. echo '
  1792. <input type="submit" id="contbutt" name="contbutt" value="', $txt['upgrade_continue'], '" onclick="return submitThisOnce(this);" class="button_submit" />';
  1793. if (!empty($incontext['skip']))
  1794. echo '
  1795. <input type="submit" id="skip" name="skip" value="', $txt['upgrade_skip'], '" onclick="return submitThisOnce(this);" class="button_submit" />';
  1796. echo '
  1797. </div>';
  1798. }
  1799. // Show the closing form tag and other data only if not in the last step
  1800. if (count($incontext['steps']) - 1 !== (int) $incontext['current_step'])
  1801. echo '
  1802. </form>';
  1803. echo '
  1804. </div>
  1805. </div>
  1806. </div>
  1807. </div>
  1808. </div></div>
  1809. <div id="footer_section"><div class="frame" style="height: 40px;">
  1810. <div class="smalltext"><a href="http://www.simplemachines.org/" title="Simple Machines Forum" target="_blank" class="new_win">SMF &copy; 2011, Simple Machines</a></div>
  1811. </div></div>
  1812. </body>
  1813. </html>';
  1814. }
  1815. // Welcome them to the wonderful world of SMF!
  1816. function template_welcome_message()
  1817. {
  1818. global $incontext, $installurl, $txt;
  1819. echo '
  1820. <script type="text/javascript" src="http://www.simplemachines.org/smf/current-version.js?version=' . $GLOBALS['current_smf_version'] . '"></script>
  1821. <form action="', $incontext['form_url'], '" method="post">
  1822. <p>', sprintf($txt['install_welcome_desc'], $GLOBALS['current_smf_version']), '</p>
  1823. <div id="version_warning" style="margin: 2ex; padding: 2ex; border: 2px dashed #a92174; color: black; background-color: #fbbbe2; display: none;">
  1824. <div style="float: left; width: 2ex; font-size: 2em; color: red;">!!</div>
  1825. <strong style="text-decoration: underline;">', $txt['error_warning_notice'], '</strong><br />
  1826. <div style="padding-left: 6ex;">
  1827. ', sprintf($txt['error_script_outdated'], '<em id="smfVersion" style="white-space: nowrap;">??</em>', '<em id="yourVersion" style="white-space: nowrap;">' . $GLOBALS['current_smf_version'] . '</em>'), '
  1828. </div>
  1829. </div>';
  1830. // Show the warnings, or not.
  1831. if (template_warning_divs())
  1832. echo '
  1833. <h3>', $txt['install_all_lovely'], '</h3>';
  1834. echo '
  1835. <div style="height: 100px;"></div>';
  1836. // Say we want the continue button!
  1837. if (empty($incontext['error']))
  1838. $incontext['continue'] = 1;
  1839. // For the latest version stuff.
  1840. echo '
  1841. <script type="text/javascript"><!-- // --><![CDATA[
  1842. // Latest version?
  1843. function smfCurrentVersion()
  1844. {
  1845. var smfVer, yourVer;
  1846. if (!(\'smfVersion\' in window))
  1847. return;
  1848. window.smfVersion = window.smfVersion.replace(/SMF\s?/g, \'\');
  1849. smfVer = document.getElementById("smfVersion");
  1850. yourVer = document.getElementById("yourVersion");
  1851. setInnerHTML(smfVer, window.smfVersion);
  1852. var currentVersion = getInnerHTML(yourVer);
  1853. if (currentVersion < window.smfVersion)
  1854. document.getElementById(\'version_warning\').style.display = \'\';
  1855. }
  1856. addLoadEvent(smfCurrentVersion);
  1857. // ]]></script>';
  1858. }
  1859. // A shortcut for any warning stuff.
  1860. function template_warning_divs()
  1861. {
  1862. global $txt, $incontext;
  1863. // Errors are very serious..
  1864. if (!empty($incontext['error']))
  1865. echo '
  1866. <div style="margin: 2ex; padding: 2ex; border: 2px dashed #cc3344; color: black; background-color: #ffe4e9;">
  1867. <div style="float: left; width: 2ex; font-size: 2em; color: red;">!!</div>
  1868. <strong style="text-decoration: underline;">', $txt['upgrade_critical_error'], '</strong><br />
  1869. <div style="padding-left: 6ex;">
  1870. ', $incontext['error'], '
  1871. </div>
  1872. </div>';
  1873. // A warning message?
  1874. elseif (!empty($incontext['warning']))
  1875. echo '
  1876. <div style="margin: 2ex; padding: 2ex; border: 2px dashed #cc3344; color: black; background-color: #ffe4e9;">
  1877. <div style="float: left; width: 2ex; font-size: 2em; color: red;">!!</div>
  1878. <strong style="text-decoration: underline;">', $txt['upgrade_warning'], '</strong><br />
  1879. <div style="padding-left: 6ex;">
  1880. ', $incontext['warning'], '
  1881. </div>
  1882. </div>';
  1883. return empty($incontext['error']) && empty($incontext['warning']);
  1884. }
  1885. function template_chmod_files()
  1886. {
  1887. global $txt, $incontext;
  1888. echo '
  1889. <p>', $txt['ftp_setup_why_info'], '</p>
  1890. <ul style="margin: 2.5ex; font-family: monospace;">
  1891. <li>', implode('</li>
  1892. <li>', $incontext['failed_files']), '</li>
  1893. </ul>';
  1894. // This is serious!
  1895. if (!template_warning_divs())
  1896. return;
  1897. echo '
  1898. <hr />
  1899. <p>', $txt['ftp_setup_info'], '</p>';
  1900. if (!empty($incontext['ftp_errors']))
  1901. echo '
  1902. <div class="error_message">
  1903. <div style="color: red;">
  1904. ', $txt['error_ftp_no_connect'], '<br />
  1905. <br />
  1906. <code>', implode('<br />', $incontext['ftp_errors']), '</code>
  1907. </div>
  1908. </div>
  1909. <br />';
  1910. echo '
  1911. <form action="', $incontext['form_url'], '" method="post">
  1912. <table width="520" cellspacing="0" cellpadding="0" border="0" align="center" style="margin: 1em 0;">
  1913. <tr>
  1914. <td width="26%" valign="top" class="textbox"><label for="ftp_server">', $txt['ftp_server'], ':</label></td>
  1915. <td>
  1916. <div style="float: ', empty($txt['lang_rtl']) ? 'right' : 'left', '; margin-', empty($txt['lang_rtl']) ? 'right' : 'left', ': 1px;"><label for="ftp_port" class="textbox"><strong>', $txt['ftp_port'], ':&nbsp;</strong></label> <input type="text" size="3" name="ftp_port" id="ftp_port" value="', $incontext['ftp']['port'], '" class="input_text" /></div>
  1917. <input type="text" size="30" name="ftp_server" id="ftp_server" value="', $incontext['ftp']['server'], '" style="width: 70%;" class="input_text" />
  1918. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['ftp_server_info'], '</div>
  1919. </td>
  1920. </tr><tr>
  1921. <td width="26%" valign="top" class="textbox"><label for="ftp_username">', $txt['ftp_username'], ':</label></td>
  1922. <td>
  1923. <input type="text" size="50" name="ftp_username" id="ftp_username" value="', $incontext['ftp']['username'], '" style="width: 99%;" class="input_text" />
  1924. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['ftp_username_info'], '</div>
  1925. </td>
  1926. </tr><tr>
  1927. <td width="26%" valign="top" class="textbox"><label for="ftp_password">', $txt['ftp_password'], ':</label></td>
  1928. <td>
  1929. <input type="password" size="50" name="ftp_password" id="ftp_password" style="width: 99%;" class="input_password" />
  1930. <div style="font-size: smaller; margin-bottom: 3ex;">', $txt['ftp_password_info'], '</div>
  1931. </td>
  1932. </tr><tr>
  1933. <td width="26%" valign="top" class="textbox"><label for="ftp_path">', $txt['ftp_path'], ':</label></td>
  1934. <td style="padding-bottom: 1ex;">
  1935. <input type="text" size="50" name="ftp_path" id="ftp_path" value="', $incontext['ftp']['path'], '" style="width: 99%;" class="input_text" />
  1936. <div style="font-size: smaller; margin-bottom: 2ex;">', $incontext['ftp']['path_msg'], '</div>
  1937. </td>
  1938. </tr>
  1939. </table>
  1940. <div style="margin: 1ex; margin-top: 1ex; text-align: ', empty($txt['lang_rtl']) ? 'right' : 'left', ';"><input type="submit" value="', $txt['ftp_connect'], '" onclick="return submitThisOnce(this);" class="button_submit" /></div>
  1941. </form>
  1942. <a href="', $incontext['form_url'], '">', $txt['error_message_click'], '</a> ', $txt['ftp_setup_again'];
  1943. }
  1944. // Get the database settings prepared.
  1945. function template_database_settings()
  1946. {
  1947. global $incontext, $installurl, $txt;
  1948. echo '
  1949. <form action="', $incontext['form_url'], '" method="post">
  1950. <p>', $txt['db_settings_info'], '</p>';
  1951. template_warning_divs();
  1952. echo '
  1953. <table width="100%" cellpadding="0" cellspacing="0" border="0" style="margin: 1em 0;">';
  1954. // More than one database type?
  1955. if (count($incontext['supported_databases']) > 1)
  1956. {
  1957. echo '
  1958. <tr>
  1959. <td width="20%" valign="top" class="textbox"><label for="db_type_input">', $txt['db_settings_type'], ':</label></td>
  1960. <td>
  1961. <select name="db_type" id="db_type_input" onchange="toggleDBInput();">';
  1962. foreach ($incontext['supported_databases'] as $key => $db)
  1963. echo '
  1964. <option value="', $key, '"', isset($_POST['db_type']) && $_POST['db_type'] == $key ? ' selected="selected"' : '', '>', $db['name'], '</option>';
  1965. echo '
  1966. </select><div id="db_sqlite_warning" style="color: blue; display: none;" class="smalltext">', $txt['db_sqlite_warning'], '</div>
  1967. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_type_info'], '</div>
  1968. </td>
  1969. </tr>';
  1970. }
  1971. else
  1972. {
  1973. echo '
  1974. <tr style="display: none;">
  1975. <td>
  1976. <input type="hidden" name="db_type" value="', $incontext['db']['type'], '" />
  1977. </td>
  1978. </tr>';
  1979. }
  1980. echo '
  1981. <tr id="db_server_contain">
  1982. <td width="20%" valign="top" class="textbox"><label for="db_server_input">', $txt['db_settings_server'], ':</label></td>
  1983. <td>
  1984. <input type="text" name="db_server" id="db_server_input" value="', $incontext['db']['server'], '" size="30" class="input_text" /><br />
  1985. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_server_info'], '</div>
  1986. </td>
  1987. </tr><tr id="db_user_contain">
  1988. <td valign="top" class="textbox"><label for="db_user_input">', $txt['db_settings_username'], ':</label></td>
  1989. <td>
  1990. <input type="text" name="db_user" id="db_user_input" value="', $incontext['db']['user'], '" size="30" class="input_text" /><br />
  1991. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_username_info'], '</div>
  1992. </td>
  1993. </tr><tr id="db_passwd_contain">
  1994. <td valign="top" class="textbox"><label for="db_passwd_input">', $txt['db_settings_password'], ':</label></td>
  1995. <td>
  1996. <input type="password" name="db_passwd" id="db_passwd_input" value="', $incontext['db']['pass'], '" size="30" class="input_password" /><br />
  1997. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_password_info'], '</div>
  1998. </td>
  1999. </tr><tr id="db_name_contain">
  2000. <td valign="top" class="textbox"><label for="db_name_input">', $txt['db_settings_database'], ':</label></td>
  2001. <td>
  2002. <input type="text" name="db_name" id="db_name_input" value="', empty($incontext['db']['name']) ? 'smf' : $incontext['db']['name'], '" size="30" class="input_text" /><br />
  2003. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_database_info'], '
  2004. <span id="db_name_info_warning">', $txt['db_settings_database_info_note'], '</span></div>
  2005. </td>
  2006. </tr><tr id="db_filename_contain" style="display: none;">
  2007. <td valign="top" class="textbox"><label for="db_filename_input">', $txt['db_settings_database_file'], ':</label></td>
  2008. <td>
  2009. <input type="text" name="db_filename" id="db_filename_input" value="', empty($incontext['db']['name']) ? dirname(__FILE__) . '/smf_' . substr(md5(microtime()), 0, 10) : stripslashes($incontext['db']['name']), '" size="30" class="input_text" /><br />
  2010. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_database_file_info'], '</div>
  2011. </td>
  2012. </tr><tr>
  2013. <td valign="top" class="textbox"><label for="db_prefix_input">', $txt['db_settings_prefix'], ':</label></td>
  2014. <td>
  2015. <input type="text" name="db_prefix" id="db_prefix_input" value="', $incontext['db']['prefix'], '" size="30" class="input_text" /><br />
  2016. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['db_settings_prefix_info'], '</div>
  2017. </td>
  2018. </tr>
  2019. </table>';
  2020. // Allow the toggling of input boxes for SQLite etc.
  2021. echo '
  2022. <script type="text/javascript"><!-- // --><![CDATA[
  2023. function toggleDBInput()
  2024. {
  2025. // What state is it?';
  2026. if (!isset($incontext['supported_databases']['sqlite']))
  2027. echo '
  2028. var showAll = true;';
  2029. elseif (count($incontext['supported_databases']) < 2)
  2030. echo '
  2031. var showAll = false;';
  2032. // If we have more than one DB including SQLite, what should we be doing?
  2033. else
  2034. echo '
  2035. var showAll = document.getElementById(\'db_type_input\').value == \'sqlite\' ? false : true;';
  2036. echo '
  2037. document.getElementById(\'db_passwd_contain\').style.display = showAll ? \'\' : \'none\';
  2038. document.getElementById(\'db_server_contain\').style.display = showAll ? \'\' : \'none\';
  2039. document.getElementById(\'db_user_contain\').style.display = showAll ? \'\' : \'none\';
  2040. document.getElementById(\'db_name_contain\').style.display = showAll ? \'\' : \'none\';
  2041. document.getElementById(\'db_filename_contain\').style.display = !showAll ? \'\' : \'none\';
  2042. document.getElementById(\'db_sqlite_warning\').style.display = !showAll ? \'\' : \'none\';
  2043. if (document.getElementById(\'db_type_input\').value == \'postgresql\')
  2044. document.getElementById(\'db_name_info_warning\').style.display = \'none\';
  2045. else
  2046. document.getElementById(\'db_name_info_warning\').style.display = \'\';
  2047. }
  2048. toggleDBInput();
  2049. // ]]></script>';
  2050. }
  2051. // Stick in their forum settings.
  2052. function template_forum_settings()
  2053. {
  2054. global $incontext, $installurl, $txt;
  2055. echo '
  2056. <form action="', $incontext['form_url'], '" method="post">
  2057. <h3>', $txt['install_settings_info'], '</h3>';
  2058. template_warning_divs();
  2059. echo '
  2060. <table width="100%" cellpadding="0" cellspacing="0" border="0" style="margin: 1em 0;">
  2061. <tr>
  2062. <td width="20%" valign="top" class="textbox"><label for="mbname_input">', $txt['install_settings_name'], ':</label></td>
  2063. <td>
  2064. <input type="text" name="mbname" id="mbname_input" value="', $txt['install_settings_name_default'], '" size="65" class="input_text" />
  2065. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['install_settings_name_info'], '</div>
  2066. </td>
  2067. </tr><tr>
  2068. <td valign="top" class="textbox"><label for="boardurl_input">', $txt['install_settings_url'], ':</label></td>
  2069. <td>
  2070. <input type="text" name="boardurl" id="boardurl_input" value="', $incontext['detected_url'], '" size="65" class="input_text" /><br />
  2071. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['install_settings_url_info'], '</div>
  2072. </td>
  2073. </tr><tr>
  2074. <td valign="top" class="textbox">', $txt['install_settings_compress'], ':</td>
  2075. <td>
  2076. <input type="checkbox" name="compress" id="compress_check" checked="checked" class="input_check" /> <label for="compress_check">', $txt['install_settings_compress_title'], '</label><br />
  2077. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['install_settings_compress_info'], '</div>
  2078. </td>
  2079. </tr><tr>
  2080. <td valign="top" class="textbox">', $txt['install_settings_dbsession'], ':</td>
  2081. <td>
  2082. <input type="checkbox" name="dbsession" id="dbsession_check" checked="checked" class="input_check" /> <label for="dbsession_check">', $txt['install_settings_dbsession_title'], '</label><br />
  2083. <div style="font-size: smaller; margin-bottom: 2ex;">', $incontext['test_dbsession'] ? $txt['install_settings_dbsession_info1'] : $txt['install_settings_dbsession_info2'], '</div>
  2084. </td>
  2085. </tr>';
  2086. if ($incontext['utf8_should_work'])
  2087. echo '
  2088. <tr>
  2089. <td valign="top" class="textbox">', $txt['install_settings_utf8'], ':</td>
  2090. <td>
  2091. <input type="checkbox" name="utf8" id="utf8_check"', $incontext['utf8_default'] ? ' checked="checked"' : '', ' class="input_check"', $incontext['utf8_required'] ? ' disabled="disabled"' : '', ' /> <label for="utf8_check">', $txt['install_settings_utf8_title'], '</label><br />
  2092. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['install_settings_utf8_info'], '</div>
  2093. </td>
  2094. </tr>';
  2095. echo '
  2096. <tr>
  2097. <td valign="top" class="textbox">', $txt['install_settings_stats'], ':</td>
  2098. <td>
  2099. <input type="checkbox" name="stats" id="stats_check" class="input_check" /> <label for="stats_check">', $txt['install_settings_stats_title'], '</label><br />
  2100. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['install_settings_stats_info'], '</div>
  2101. </td>
  2102. </tr>
  2103. </table>';
  2104. }
  2105. // Show results of the database population.
  2106. function template_populate_database()
  2107. {
  2108. global $incontext, $installurl, $txt;
  2109. echo '
  2110. <form action="', $incontext['form_url'], '" method="post">
  2111. <p>', !empty($incontext['was_refresh']) ? $txt['user_refresh_install_desc'] : $txt['db_populate_info'], '</p>';
  2112. if (!empty($incontext['sql_results']))
  2113. {
  2114. echo '
  2115. <ul>
  2116. <li>', implode('</li><li>', $incontext['sql_results']), '</li>
  2117. </ul>';
  2118. }
  2119. if (!empty($incontext['failures']))
  2120. {
  2121. echo '
  2122. <div style="color: red;">', $txt['error_db_queries'], '</div>
  2123. <ul>';
  2124. foreach ($incontext['failures'] as $line => $fail)
  2125. echo '
  2126. <li><strong>', $txt['error_db_queries_line'], $line + 1, ':</strong> ', nl2br(htmlspecialchars($fail)), '</li>';
  2127. echo '
  2128. </ul>';
  2129. }
  2130. echo '
  2131. <p>', $txt['db_populate_info2'], '</p>';
  2132. template_warning_divs();
  2133. echo '
  2134. <input type="hidden" name="pop_done" value="1" />';
  2135. }
  2136. // Create the admin account.
  2137. function template_admin_account()
  2138. {
  2139. global $incontext, $installurl, $txt;
  2140. echo '
  2141. <form action="', $incontext['form_url'], '" method="post">
  2142. <p>', $txt['user_settings_info'], '</p>';
  2143. template_warning_divs();
  2144. echo '
  2145. <table width="100%" cellspacing="0" cellpadding="0" border="0" style="margin: 2em 0;">
  2146. <tr>
  2147. <td width="18%" valign="top" class="textbox"><label for="username">', $txt['user_settings_username'], ':</label></td>
  2148. <td>
  2149. <input type="text" name="username" id="username" value="', $incontext['username'], '" size="40" class="input_text" />
  2150. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['user_settings_username_info'], '</div>
  2151. </td>
  2152. </tr><tr>
  2153. <td valign="top" class="textbox"><label for="password1">', $txt['user_settings_password'], ':</label></td>
  2154. <td>
  2155. <input type="password" name="password1" id="password1" size="40" class="input_password" />
  2156. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['user_settings_password_info'], '</div>
  2157. </td>
  2158. </tr><tr>
  2159. <td valign="top" class="textbox"><label for="password2">', $txt['user_settings_again'], ':</label></td>
  2160. <td>
  2161. <input type="password" name="password2" id="password2" size="40" class="input_password" />
  2162. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['user_settings_again_info'], '</div>
  2163. </td>
  2164. </tr><tr>
  2165. <td valign="top" class="textbox"><label for="email">', $txt['user_settings_email'], ':</label></td>
  2166. <td>
  2167. <input type="text" name="email" id="email" value="', $incontext['email'], '" size="40" class="input_text" />
  2168. <div style="font-size: smaller; margin-bottom: 2ex;">', $txt['user_settings_email_info'], '</div>
  2169. </td>
  2170. </tr>
  2171. </table>';
  2172. if ($incontext['require_db_confirm'])
  2173. echo '
  2174. <h2>', $txt['user_settings_database'], '</h2>
  2175. <p>', $txt['user_settings_database_info'], '</p>
  2176. <div style="margin-bottom: 2ex; padding-', empty($txt['lang_rtl']) ? 'left' : 'right', ': 50px;">
  2177. <input type="password" name="password3" size="30" class="input_password" />
  2178. </div>';
  2179. }
  2180. // Tell them it's done, and to delete.
  2181. function template_delete_install()
  2182. {
  2183. global $incontext, $installurl, $txt, $boardurl;
  2184. echo '
  2185. <p>', $txt['congratulations_help'], '</p>';
  2186. template_warning_divs();
  2187. // Install directory still writable?
  2188. if ($incontext['dir_still_writable'])
  2189. echo '
  2190. <em>', $txt['still_writable'], '</em><br />
  2191. <br />';
  2192. // Don't show the box if it's like 99% sure it won't work :P.
  2193. if ($incontext['probably_delete_install'])
  2194. echo '
  2195. <div style="margin: 1ex; font-weight: bold;">
  2196. <label for="delete_self"><input type="checkbox" id="delete_self" onclick="doTheDelete();" class="input_check" /> ', $txt['delete_installer'], !isset($_SESSION['installer_temp_ftp']) ? ' ' . $txt['delete_installer_maybe'] : '', '</label>
  2197. </div>
  2198. <script type="text/javascript"><!-- // --><![CDATA[
  2199. function doTheDelete()
  2200. {
  2201. var theCheck = document.getElementById ? document.getElementById("delete_self") : document.all.delete_self;
  2202. var tempImage = new Image();
  2203. tempImage.src = "', $installurl, '?delete=1&ts_" + (new Date().getTime());
  2204. tempImage.width = 0;
  2205. theCheck.disabled = true;
  2206. }
  2207. // ]]></script>
  2208. <br />';
  2209. echo '
  2210. ', sprintf($txt['go_to_your_forum'], $boardurl . '/index.php'), '<br />
  2211. <br />
  2212. ', $txt['good_luck'];
  2213. }
  2214. ?>