PageRenderTime 54ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/install/index.php

https://bitbucket.org/rafalwolak/cms2u
PHP | 959 lines | 744 code | 188 blank | 27 comment | 84 complexity | bedfb2dd8e78f758ebc66ddbddba7549 MD5 | raw file
Possible License(s): AGPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /**

    3. 

  3.  * @link    http://www.cms2u.pl/ www.cms2u.pl

    4. 

  4.  * @author  Rafal Wolak <kontakt@rafalwolak.pl>

    5. 

  5.  * @license http://creativecommons.org/licenses/by/3.0/

    6. 

  6.  *          Creative Commons License: Attribution 3.0 Unported

    7. 

  7.  * @package cms2u

    8. 

  8.  */

    9. 

  9. 

    10. 

  10. /**

    11. 

  11.  * @ignore

    12. 

  12.  */

    13. 

  13. define('IN_SITE', true);

    14. 

  14. $phpEx = substr(strrchr(__FILE__, '.'), 1);

    15. 

  15. 

    16. 

  16. function chmodr($path, $filemode) {

    17. 

  17.     if (!is_dir($path))

    18. 

  18.         return @chmod($path, $filemode);

    19. 

  19.     $dh = opendir($path);

    20. 

  20.     while (($file = readdir($dh)) !== false) {

    21. 

  21.         if ($file != '.' && $file != '..') {

    22. 

  22.             $fullpath = $path.'/'.$file;

    23. 

  23.             if (is_link($fullpath))

    24. 

  24.                 return false;

    25. 

  25.             else if (!is_dir($fullpath) && !@chmod($fullpath, $filemode))

    26. 

  26.                 return false;

    27. 

  27.             else if (!chmodr($fullpath, $filemode))

    28. 

  28.                 return false;

    29. 

  29.         }

    30. 

  30.     }

    31. 

  31.     closedir($dh);

    32. 

  32.     if (@chmod($path, $filemode))

    33. 

  33.         return true;

    34. 

  34.     else

    35. 

  35.         return false;

    36. 

  36. }

    37. 

  37. 

    38. 

  38. if (!defined('IS_INSTALLED')) {

    39. 

  39.     chmodr(str_replace('install/index.php', '', $_SERVER['SCRIPT_FILENAME']) . 'template_c/', 0777);

    40. 

  40.     chmodr(str_replace('install/index.php', '', $_SERVER['SCRIPT_FILENAME']) . 'inc/', 0777);

    41. 

  41.     chmodr(str_replace('install/index.php', '', $_SERVER['SCRIPT_FILENAME']) . 'cache/', 0777);

    42. 

  42.     chmodr(str_replace('install/index.php', '', $_SERVER['SCRIPT_FILENAME']) . 'img/upload/', 0777);

    43. 

  43.     @setcookie("componentcheck", "", time() - 60*60);

    44. 

  44.     @setcookie("modulecheck", "", time() - 60*60);

    45. 

  45.     @setcookie("langcheck", "", time() - 60*60);

    46. 

  46. 

    47. 

  47.     if (isset($_GET['step'])) {

    48. 

  48.         $step = (int) $_GET['step'];

    49. 

  49. 

    50. 

  50.         switch ($step) {

    51. 

  51.             case 1:

    52. 

  52. 

    53. 

  53.                 include '../inc/init.' . $phpEx;

    54. 

  54. 

    55. 

  55.                 if (request_var('go', 'false') == 'true') {

    56. 

  56.                     $_error = false;

    57. 

  57.                     $sqlhost = request_var('sqlhost', '');

    58. 

  58.                     $sqlport = request_var('sqlport', '');

    59. 

  59.                     $sqlname = request_var('sqlname', '');

    60. 

  60.                     $sqllogin = request_var('sqllogin', '');

    61. 

  61.                     $sqlpassword = request_var('sqlpass', '');

    62. 

  62.                     $prefix = request_var('prefix', '');

    63. 

  63.                     $absolute_path = request_var('absolute_path', '');

    64. 

  64.                     $site_url = request_var('site_url', '');

    65. 

  65.                     $username = request_var('username', '');

    66. 

  66.                     $email = request_var('email', '');

    67. 

  67.                     $email_re = request_var('email-re', '');

    68. 

  68.                     $password = request_var('password', '');

    69. 

  69.                     $password_re = request_var('password-re', '');

    70. 

  70.                     $question = request_var('question', '');

    71. 

  71.                     $answer = request_var('answer', '');

    72. 

  72.                     $lang = request_var('lang', 'en');

    73. 

  73. 

    74. 

  74.                     if ($sqlhost == '' || $sqlname == '' || $sqllogin == '' || $sqlpassword == '' || $prefix == '' || $absolute_path == '' || $site_url == '' || $username == '' || $email == '' || $email_re == '' || $password == '' || $password_re == '' || $question == '' || $answer == '') {

    75. 

  75.                         $msg = lang('INSTALL: FILL IN ALL FIELDS');

    76. 

  76.                         $_error = true;

    77. 

  77.                     }

    78. 

  78.                     else if ($password != $password_re) {

    79. 

  79.                         $msg = lang('INSTALL: ENTERED PASSWORDS ARE DIFFERENT');

    80. 

  80.                         $_error = true;

    81. 

  81.                     }

    82. 

  82.                     else if (!eregi("^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,6})$", $email)) {

    83. 

  83.                         $msg = lang('INSTALL: PLEASE ENTER A VALID E-MAIL ADDRESS');

    84. 

  84.                         $_error = true;

    85. 

  85.                     }

    86. 

  86.                     else if ($email != $email_re) {

    87. 

  87.                         $msg = lang('INSTALL: ENTERED EMAIL ADDRESSES ARE DIFFERENT');

    88. 

  88.                         $_error = true;

    89. 

  89.                     }

    90. 

  90.                     else if (strlen($prefix) < 2 || strlen($prefix) > 7 || !eregi("[a-z]", $prefix)) {

    91. 

  91.                         $msg = lang('INSTALL: THE CORRECT PREFIX MUST CONSIST SOLELY OF 2 TO 7 SMALL LETTERS');

    92. 

  92.                         $_error = true;

    93. 

  93.                     }

    94. 

  94. 

    95. 

  95.                     if ($_error) {

    96. 

  96.                         $smarty->assign('msg', $msg);

    97. 

  97.                     }

    98. 

  98.                     else if (!$_error) {

    99. 

  99.                         $filename = '../inc/config.php';

    100. 

  100. 

    101. 

  101.                         if (strrpos($site_url, '/') != (strlen($site_url)-1))

    102. 

  102.                             $site_url .= '/';

    103. 

  103. 

    104. 

  104.                         if (strrpos($absolute_path, '/') != (strlen($absolute_path)-1))

    105. 

  105.                             $absolute_path .= '/';

    106. 

  106. 

    107. 

  107.                         if ($fp = @fopen($filename, 'w')) {

    108. 

  108.                             @flock($fp, LOCK_EX);

    109. 

  109.                             $file = "<?php\n";

    110. 

  110.                             $file .= "if (!defined('IN_SITE'))\n{\n header(\"Location: " . $site_url . "\");\nexit;\n}\n";

    111. 

  111.                             $file .= "\n/* ----------------------- */\n";

    112. 

  112.                             $file .= "\$sql_host = '" . $sqlhost . "';\n";

    113. 

  113.                             $file .= "\$sql_port = '" . $sqlport . "';\n";

    114. 

  114.                             $file .= "\$sql_login = '" . $sqllogin . "';\n";

    115. 

  115.                             $file .= "\$sql_password = '" . $sqlpassword . "';\n";

    116. 

  116.                             $file .= "\$sql_name = '" . $sqlname . "';\n";

    117. 

  117.                             $file .= "\$sql_prefix = '" . $prefix . "';\n";

    118. 

  118.                             $file .= "\n/* ----------------------- */\n";

    119. 

  119.                             $file .= "\$prefix = '" . $prefix . "';\n";

    120. 

  120.                             $file .= "\n/* ----------------------- */\n";

    121. 

  121.                             $file .= "\$absolute_path = '" . $absolute_path . "';\n";

    122. 

  122.                             $file .= "\$site_url = '" . $site_url . "';\n";

    123. 

  123.                             $file .= "\$lang = '" . $lang . "';\n";

    124. 

  124.                             $file .= "\n/* ----------------------- */\n";

    125. 

  125.                             $file .= "\$admin_name = '" . $username . "';\n";

    126. 

  126.                             $file .= "\$admin_pass = '" . md5($password) . "';\n";

    127. 

  127.                             $file .= "\$admin_email = '" . $email . "';\n";

    128. 

  128.                             $file .= "\$admin_question = '" . $question . "';\n";

    129. 

  129.                             $file .= "\$admin_answer = '" . $answer . "';\n";

    130. 

  130.                             $file .= "\n?>";

    131. 

  131.                             @fwrite($fp, $file);

    132. 

  132.                             @flock($fp, LOCK_UN);

    133. 

  133.                             @fclose($fp);

    134. 

  134.                             @chmod($filename, 0666);

    135. 

  135. 

    136. 

  136.                             header('Location: index.' . $phpEx . ((isset($_GET['lang'])) ? '?lang=' . request_var('lang', 'en') . '&' : '?') . 'step=2');

    137. 

  137.                             exit;

    138. 

  138.                         }

    139. 

  139.                     }

    140. 

  140.                 }

    141. 

  141. 

    142. 

  142.                 break;

    143. 

  143. 

    144. 

  144.             case 2:

    145. 

  145. 

    146. 

  146.                 include '../inc/init.' . $phpEx;

    147. 

  147. 

    148. 

  148.                 if (require_once '../inc/config.' . $phpEx) {

    149. 

  149.                     $sql_host = $sql_host . (($sql_port) ? ':' . $sql_port : '');

    150. 

  150.                     $db = @mysql_pconnect($sql_host, $sql_login, $sql_password);

    151. 

  151. 

    152. 

  152.                     if ($db && $sql_name != '') {

    153. 

  153.                         if (mysql_select_db($sql_name, $db)) {

    154. 

  154.                             mysql_query('SET NAMES "utf8"', $db);

    155. 

  155. 

    156. 

  156.                             $_error = 0;

    157. 

  157.                             $msg = '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_config</dt><dd>';

    158. 

  158. 

    159. 

  159.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_config';

    160. 

  160.                             $result = mysql_query($sql);

    161. 

  161. 

    162. 

  162.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    163. 

  163.                             $result ? $_error = $_error : $_error = $_error + 1;

    164. 

  164. 

    165. 

  165.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_config</dt><dd>';

    166. 

  166. 

    167. 

  167.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_config (

    168. 

  168.                                 `config_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    169. 

  169. 								`config_meta_title` varchar(255) NULL DEFAULT NULL,

    170. 

  170. 								`config_meta_description` varchar(255) NULL DEFAULT NULL,

    171. 

  171. 								`config_meta_keywords` varchar(255) NULL DEFAULT NULL,

    172. 

  172. 								`config_active` tinyint(1) NULL DEFAULT '0',

    173. 

  173. 								`config_name` varchar(255) NULL DEFAULT NULL,

    174. 

  174. 								`config_email` varchar(50) NULL DEFAULT NULL,

    175. 

  175. 								`config_tpl_dir` varchar(50) NULL DEFAULT NULL,

    176. 

  176. 								`config_sql_cache` tinyint(1) NULL DEFAULT '0',

    177. 

  177. 								`config_smarty_cache` tinyint(1) NULL DEFAULT '0',

    178. 

  178. 								`config_smarty_cache_lifetime` int(10) NULL DEFAULT '0',

    179. 

  179. 								`config_google_analytics` varchar(30) NULL DEFAULT NULL, 

    180. 

  180. 								`config_lang` char(2) NULL DEFAULT 'en', 

    181. 

  181. 								`config_lang_admin` char(2) NULL DEFAULT 'en', 

    182. 

  182. 								`config_register` tinyint(1) NULL DEFAULT '0',

    183. 

  183. 								PRIMARY KEY (`config_id`)

    184. 

  184. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=2;";

    185. 

  185.                             $result = mysql_query($sql);

    186. 

  186. 

    187. 

  187.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    188. 

  188.                             $result ? $_error = $_error : $_error = $_error + 1;

    189. 

  189. 

    190. 

  190. 

    191. 

  191.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_config</dt><dd>';

    192. 

  192. 

    193. 

  193.                             $sql = "INSERT

    194. 

  194.                                 INTO " . $prefix . "_config

    195. 

  195.                                     (config_id, config_meta_title, config_meta_description, config_meta_keywords, config_active, config_name, config_email, config_tpl_dir, config_lang, config_lang_admin, config_register)

    196. 

  196.                                 VALUES

    197. 

  197.                                     (1, 'cms2u', 'Content Management System', 'cms, content management system', 1, 'cms2u', '" . $admin_email . "', 'default', '" . $lang . "', '" . $lang . "', 1);";

    198. 

  198.                             $result = mysql_query($sql);

    199. 

  199. 

    200. 

  200.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    201. 

  201.                             $result ? $_error = $_error : $_error = $_error + 1;

    202. 

  202. 

    203. 

  203. 

    204. 

  204.                             // LOCALIZATION

    205. 

  205.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_continent</dt><dd>';

    206. 

  206. 

    207. 

  207.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_continent';

    208. 

  208.                             $result = mysql_query($sql);

    209. 

  209. 

    210. 

  210.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    211. 

  211.                             $result ? $_error = $_error : $_error = $_error + 1;

    212. 

  212. 

    213. 

  213.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_continent</dt><dd>';

    214. 

  214. 

    215. 

  215.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_continent (

    216. 

  216. 			    			    `continent_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    217. 

  217. 								`continent_name` varchar(255) NULL DEFAULT NULL,

    218. 

  218. 								`continent_logo` varchar(255) NULL DEFAULT NULL,

    219. 

  219. 								`continent_active` tinyint(1) NULL DEFAULT '0', 

    220. 

  220. 								PRIMARY KEY (`continent_id`)

    221. 

  221. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    222. 

  222.                             $result = mysql_query($sql);

    223. 

  223. 

    224. 

  224.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    225. 

  225.                             $result ? $_error = $_error : $_error = $_error + 1;

    226. 

  226. 

    227. 

  227.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_country</dt><dd>';

    228. 

  228. 

    229. 

  229.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_country';

    230. 

  230.                             $result = mysql_query($sql);

    231. 

  231. 

    232. 

  232.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    233. 

  233.                             $result ? $_error = $_error : $_error = $_error + 1;

    234. 

  234. 

    235. 

  235.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_country</dt><dd>';

    236. 

  236. 

    237. 

  237.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_country (

    238. 

  238. 			        			`country_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    239. 

  239. 								`country_continentid` int(10) NULL DEFAULT '0',

    240. 

  240. 								`country_name` varchar(255) NULL DEFAULT NULL,

    241. 

  241. 								`country_logo` varchar(255) NULL DEFAULT NULL,

    242. 

  242. 								`country_active` tinyint(1) NULL DEFAULT '0', 

    243. 

  243. 								PRIMARY KEY (`country_id`)

    244. 

  244. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    245. 

  245.                             $result = mysql_query($sql);

    246. 

  246. 

    247. 

  247.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    248. 

  248.                             $result ? $_error = $_error : $_error = $_error + 1;

    249. 

  249. 

    250. 

  250. 

    251. 

  251.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_region</dt><dd>';

    252. 

  252. 

    253. 

  253.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_region';

    254. 

  254.                             $result = mysql_query($sql);

    255. 

  255. 

    256. 

  256.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    257. 

  257.                             $result ? $_error = $_error : $_error = $_error + 1;

    258. 

  258. 

    259. 

  259.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_region</dt><dd>';

    260. 

  260. 

    261. 

  261.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_region (

    262. 

  262. 			        			`region_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    263. 

  263. 								`region_countryid` int(10) NULL DEFAULT '0',

    264. 

  264. 								`region_continentid` int(10) NULL DEFAULT '0',

    265. 

  265. 								`region_name` varchar(255) NULL DEFAULT NULL,

    266. 

  266. 								`region_logo` varchar(255) NULL DEFAULT NULL,

    267. 

  267. 								`region_active` tinyint(1) NULL DEFAULT '0', 

    268. 

  268. 								PRIMARY KEY (`region_id`)

    269. 

  269. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    270. 

  270.                             $result = mysql_query($sql);

    271. 

  271. 

    272. 

  272.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    273. 

  273.                             $result ? $_error = $_error : $_error = $_error + 1;

    274. 

  274. 

    275. 

  275.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_city</dt><dd>';

    276. 

  276. 

    277. 

  277.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_city';

    278. 

  278.                             $result = mysql_query($sql);

    279. 

  279. 

    280. 

  280.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    281. 

  281.                             $result ? $_error = $_error : $_error = $_error + 1;

    282. 

  282. 

    283. 

  283.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_city</dt><dd>';

    284. 

  284. 

    285. 

  285.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_city (

    286. 

  286. 			        			`city_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    287. 

  287. 								`city_regionid` int(10) NULL DEFAULT '0',

    288. 

  288. 								`city_countryid` int(10) NULL DEFAULT '0',

    289. 

  289. 								`city_continentid` int(10) NULL DEFAULT '0',

    290. 

  290. 								`city_geo` tinyint(1) NULL DEFAULT '0',

    291. 

  291. 								`city_localization` varchar(255) NULL DEFAULT '19,52',

    292. 

  292. 								`city_name` varchar(255) NULL DEFAULT NULL,

    293. 

  293. 								`city_logo` varchar(255) NULL DEFAULT NULL,

    294. 

  294. 								`city_active` tinyint(1) NULL DEFAULT '0', 

    295. 

  295. 								PRIMARY KEY (`city_id`)

    296. 

  296. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    297. 

  297.                             $result = mysql_query($sql);

    298. 

  298. 

    299. 

  299.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    300. 

  300.                             $result ? $_error = $_error : $_error = $_error + 1;

    301. 

  301. 

    302. 

  302. 

    303. 

  303.                             // LANG

    304. 

  304.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_lang</dt><dd>';

    305. 

  305. 

    306. 

  306.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_lang';

    307. 

  307.                             $result = mysql_query($sql);

    308. 

  308. 

    309. 

  309.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    310. 

  310.                             $result ? $_error = $_error : $_error = $_error + 1;

    311. 

  311. 

    312. 

  312.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_lang</dt><dd>';

    313. 

  313. 

    314. 

  314.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_lang (

    315. 

  315. 			    			    `lang_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    316. 

  316. 								`lang_name` varchar(255) NULL DEFAULT '',

    317. 

  317. 								`lang_identify` char(2) NULL DEFAULT '',

    318. 

  318. 								`lang_logo` varchar(255) NULL DEFAULT '',

    319. 

  319. 								`lang_charset` char(20) NULL DEFAULT 'utf-8',

    320. 

  320. 								`lang_currency` tinyint(2) NULL DEFAULT '0',

    321. 

  321. 								`lang_active` tinyint(1) NULL DEFAULT '0',

    322. 

  322. 								`lang_delate` tinyint(1) NULL DEFAULT '1',

    323. 

  323. 								PRIMARY KEY (`lang_id`)

    324. 

  324. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=3;";

    325. 

  325.                             $result = mysql_query($sql);

    326. 

  326. 

    327. 

  327.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    328. 

  328.                             $result ? $_error = $_error : $_error = $_error + 1;

    329. 

  329. 

    330. 

  330.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_lang</dt><dd>';

    331. 

  331. 

    332. 

  332.                             $sql = "INSERT

    333. 

  333.                                 INTO " . $prefix . "_lang

    334. 

  334.                                     (lang_id, lang_name, lang_identify, lang_logo, lang_charset, lang_currency, lang_active, lang_delate)

    335. 

  335.                                 VALUES

    336. 

  336. 				    				(1, 'English (English)', 'en', 'img/lang/en.gif', 'utf-8', 1, 1, 0),

    337. 

  337. 								    (2, 'Polish (Polski)', 'pl', 'img/lang/pl.gif', 'utf-8', 2, 1, 1);";

    338. 

  338.                             $result = mysql_query($sql);

    339. 

  339. 

    340. 

  340.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    341. 

  341.                             $result ? $_error = $_error : $_error = $_error + 1;

    342. 

  342. 							

    343. 

  343. 							// CURRENCY

    344. 

  344.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_currency</dt><dd>';

    345. 

  345. 

    346. 

  346.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_currency';

    347. 

  347.                             $result = mysql_query($sql);

    348. 

  348. 

    349. 

  349.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    350. 

  350.                             $result ? $_error = $_error : $_error = $_error + 1;

    351. 

  351. 

    352. 

  352.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_currency</dt><dd>';

    353. 

  353. 

    354. 

  354.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_currency (

    355. 

  355. 			    			    `currency_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    356. 

  356. 								`currency_name` varchar(255) NULL DEFAULT '',

    357. 

  357. 								`currency_symbol` char(20) NULL DEFAULT '',

    358. 

  358. 								`currency_show` varchar(255) NULL DEFAULT '',

    359. 

  359. 								`currency_rate` char(20) NULL DEFAULT '1',

    360. 

  360. 								`currency_position` tinyint(2) NULL DEFAULT '0',

    361. 

  361. 								`currency_default` tinyint(1) NULL DEFAULT '0',

    362. 

  362. 								`currency_active` tinyint(1) NULL DEFAULT '0',

    363. 

  363. 								`currency_delate` tinyint(1) NULL DEFAULT '1',

    364. 

  364. 								PRIMARY KEY (`currency_id`)

    365. 

  365. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=3;";

    366. 

  366.                             $result = mysql_query($sql);

    367. 

  367. 

    368. 

  368.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    369. 

  369.                             $result ? $_error = $_error : $_error = $_error + 1;

    370. 

  370. 

    371. 

  371.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_currency</dt><dd>';

    372. 

  372. 

    373. 

  373.                             $sql = "INSERT

    374. 

  374.                                 INTO " . $prefix . "_currency

    375. 

  375.                                     (currency_id, currency_name, currency_symbol, currency_show, currency_rate, currency_position, currency_default, currency_active, currency_delate)

    376. 

  376.                                 VALUES

    377. 

  377. 				    				(1, 'USD', 'USD', '$', '1', 1, 1, 1, 0),

    378. 

  378. 								    (2, 'PLN', 'PLN', 'z?', '1', 2, 0, 1, 1);";

    379. 

  379.                             $result = mysql_query($sql);

    380. 

  380. 

    381. 

  381.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    382. 

  382.                             $result ? $_error = $_error : $_error = $_error + 1;

    383. 

  383. 

    384. 

  384. 

    385. 

  385.                             // LOG

    386. 

  386.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_log</dt><dd>';

    387. 

  387. 

    388. 

  388.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_log';

    389. 

  389.                             $result = mysql_query($sql);

    390. 

  390. 

    391. 

  391.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    392. 

  392.                             $result ? $_error = $_error : $_error = $_error + 1;

    393. 

  393. 

    394. 

  394.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_log</dt><dd>';

    395. 

  395. 

    396. 

  396.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_log (

    397. 

  397. 			        			`log_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    398. 

  398. 								`log_userid` int(10) NULL DEFAULT '0', 

    399. 

  399. 						        `log_ip` varchar(50) NULL DEFAULT NULL,

    400. 

  400. 								`log_adddate` int(10) NULL DEFAULT '0', 

    401. 

  401. 								`log_description` text NULL DEFAULT NULL, 

    402. 

  402. 								`log_options` text NULL DEFAULT NULL, 

    403. 

  403. 								PRIMARY KEY (`log_id`) 

    404. 

  404. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    405. 

  405.                             $result = mysql_query($sql);

    406. 

  406. 

    407. 

  407.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    408. 

  408.                             $result ? $_error = $_error : $_error = $_error + 1;

    409. 

  409. 

    410. 

  410. 

    411. 

  411.                             // GROUP

    412. 

  412.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_group</dt><dd>';

    413. 

  413. 

    414. 

  414.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_group';

    415. 

  415.                             $result = mysql_query($sql);

    416. 

  416. 

    417. 

  417.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    418. 

  418.                             $result ? $_error = $_error : $_error = $_error + 1;

    419. 

  419. 

    420. 

  420.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_group</dt><dd>';

    421. 

  421. 

    422. 

  422.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_group (

    423. 

  423. 			    			    `group_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    424. 

  424. 								`group_name` varchar(255) NULL DEFAULT NULL,

    425. 

  425. 								`group_identify` varchar(32) NULL DEFAULT NULL,

    426. 

  426. 								`group_description` longtext NULL DEFAULT NULL,

    427. 

  427. 								`group_permissions` text NULL DEFAULT NULL,

    428. 

  428. 								`group_delate` tinyint(1) NULL DEFAULT '1', 

    429. 

  429. 								PRIMARY KEY (`group_id`)

    430. 

  430. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=6;";

    431. 

  431.                             $result = mysql_query($sql);

    432. 

  432. 

    433. 

  433.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    434. 

  434.                             $result ? $_error = $_error : $_error = $_error + 1;

    435. 

  435. 

    436. 

  436.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_group</dt><dd>';

    437. 

  437. 

    438. 

  438.                             $sql = "INSERT

    439. 

  439. 			        			INTO " . $prefix . "_group

    440. 

  440. 							    	(group_id, group_name, group_identify, group_description, group_delate)

    441. 

  441. 								VALUES 

    442. 

  442. 								    (1, '" .lang('INSTALL: USER') . "', 'user', '" . lang('INSTALL: CAN LOG ON TO THE SITE, COMMENT ON AND RATE') . "', 0),

    443. 

  443. 								    (2, '" .lang('INSTALL: ADMIN') . "', 'admin', '" . lang('INSTALL: IT HAS ALL THE PRIVILEGES') . "', 0),

    444. 

  444. 								    (3, '" .lang('INSTALL: DEMO USER') . "', 'demo', '" . lang('INSTALL: DEMO USER') . "', 1),

    445. 

  445. 								    (4, '" .lang('INSTALL: EDITOR') . "', 'news', '" . lang('INSTALL: CAN ADD, EDIT AND DELETE NEWS') . "', 1),

    446. 

  446. 								    (5, '" .lang('INSTALL: GALLERY EDITOR') . "', 'gallery', '" . lang('INSTALL: CAN ADD, EDIT AND DELETE GALLERY') . "', 1);";

    447. 

  447.                             $result = mysql_query($sql);

    448. 

  448. 

    449. 

  449.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    450. 

  450.                             $result ? $_error = $_error : $_error = $_error + 1;

    451. 

  451. 

    452. 

  452. 

    453. 

  453.                             // CONTENT

    454. 

  454.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_content</dt><dd>';

    455. 

  455. 

    456. 

  456.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_content';

    457. 

  457.                             $result = mysql_query($sql);

    458. 

  458. 

    459. 

  459.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    460. 

  460.                             $result ? $_error = $_error : $_error = $_error + 1;

    461. 

  461. 

    462. 

  462.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_content</dt><dd>';

    463. 

  463. 

    464. 

  464.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_content (

    465. 

  465. 			        			`content_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    466. 

  466. 								`content_type` tinyint(2) NULL DEFAULT '0',

    467. 

  467. 								`content_title` varchar(255) NULL DEFAULT NULL,

    468. 

  468. 								`content_metatitle` varchar(255) NULL DEFAULT NULL,

    469. 

  469. 								`content_metadescription` text NULL DEFAULT NULL,

    470. 

  470. 								`content_metakeywords` varchar(255) NULL DEFAULT NULL,

    471. 

  471. 								`content_modidentify` varchar(32) NULL DEFAULT NULL,

    472. 

  472. 								`content_modoptions` text NULL DEFAULT NULL,

    473. 

  473. 								`content_text` text NULL DEFAULT NULL,

    474. 

  474. 								`content_url` varchar(255) NULL DEFAULT NULL,

    475. 

  475. 								`content_tpl` varchar(255) NULL DEFAULT NULL,

    476. 

  476. 								`content_active` tinyint(1) NULL DEFAULT '1',

    477. 

  477. 								`content_position` tinyint(4) NULL DEFAULT '0',

    478. 

  478. 								`content_permission` varchar(255) NULL DEFAULT NULL,

    479. 

  479. 								`content_delate` tinyint(1) NULL DEFAULT '0',

    480. 

  480. 								`content_start` tinyint(1) NULL DEFAULT '0', 

    481. 

  481. 								PRIMARY KEY (`content_id`), 

    482. 

  482. 								FULLTEXT `content_title` (`content_title`,`content_metatitle`,`content_metadescription`,`content_metakeywords`,`content_text`)

    483. 

  483. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    484. 

  484.                             $result = mysql_query($sql);

    485. 

  485. 

    486. 

  486.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    487. 

  487.                             $result ? $_error = $_error : $_error = $_error + 1;

    488. 

  488. 

    489. 

  489.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_content</dt><dd>';

    490. 

  490. 

    491. 

  491.                             $sql = "INSERT

    492. 

  492. 			        			INTO " . $prefix . "_content

    493. 

  493. 			                         (content_id, content_type, content_title, content_modidentify, content_position, content_start)

    494. 

  494. 								VALUES

    495. 

  495. 			                		(1, 1, 'Front site', 'frontsite', 1, 1),

    496. 

  496. 								    (2, 1, 'Register', 'register', 2, 0),

    497. 

  497. 								    (3, 1, 'Login', 'login', 3, 0),

    498. 

  498. 								    (4, 1, 'Error', 'content', 4, 0),

    499. 

  499. 								    (5, 1, 'Localization', 'content', 5, 0);";

    500. 

  500.                             $result = mysql_query($sql);

    501. 

  501. 

    502. 

  502.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    503. 

  503.                             $result ? $_error = $_error : $_error = $_error + 1;

    504. 

  504. 

    505. 

  505.                             // MODULE

    506. 

  506.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_module</dt><dd>';

    507. 

  507. 

    508. 

  508.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_module';

    509. 

  509.                             $result = mysql_query($sql);

    510. 

  510. 

    511. 

  511.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    512. 

  512.                             $result ? $_error = $_error : $_error = $_error + 1;

    513. 

  513. 

    514. 

  514.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_module</dt><dd>';

    515. 

  515. 

    516. 

  516.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_module (

    517. 

  517. 			       				`module_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    518. 

  518. 								`module_name` varchar(100) NULL DEFAULT NULL,

    519. 

  519. 								`module_description` text NULL DEFAULT NULL,

    520. 

  520. 								`module_identify` varchar(30) NULL DEFAULT NULL,

    521. 

  521. 								`module_ver` float(3,2) NULL DEFAULT '0.00',

    522. 

  522. 								`module_adddate` int(10) NULL DEFAULT '0',

    523. 

  523. 								`module_moddate` int(10) NULL DEFAULT '0',

    524. 

  524. 								`module_active` tinyint(1) NULL DEFAULT '0',

    525. 

  525. 								`module_delate` tinyint(1) NULL DEFAULT '0', 

    526. 

  526. 								PRIMARY KEY (`module_id`), 

    527. 

  527. 								UNIQUE `module_identify` (`module_identify`)

    528. 

  528. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=7;";

    529. 

  529.                             $result = mysql_query($sql);

    530. 

  530. 

    531. 

  531.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    532. 

  532.                             $result ? $_error = $_error : $_error = $_error + 1;

    533. 

  533. 

    534. 

  534. 

    535. 

  535.                             // COMPONENT

    536. 

  536.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_component</dt><dd>';

    537. 

  537. 

    538. 

  538.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_component';

    539. 

  539.                             $result = mysql_query($sql);

    540. 

  540. 

    541. 

  541.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    542. 

  542.                             $result ? $_error = $_error : $_error = $_error + 1;

    543. 

  543. 

    544. 

  544.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_component</dt><dd>';

    545. 

  545. 

    546. 

  546.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_component (

    547. 

  547. 			    				`component_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    548. 

  548. 								`component_name` varchar(100) NULL DEFAULT NULL,

    549. 

  549. 								`component_description` text NULL DEFAULT NULL,

    550. 

  550. 								`component_identify` varchar(32) NULL DEFAULT NULL,

    551. 

  551. 								`component_ver` float(3,2) NULL DEFAULT '0.00',

    552. 

  552. 								`component_modrequire` varchar(255) NULL DEFAULT NULL,

    553. 

  553. 								`component_adddate` int(10) NULL DEFAULT '0',

    554. 

  554. 								`component_moddate` int(10) NULL DEFAULT '0',

    555. 

  555. 								`component_options` text NULL DEFAULT NULL,

    556. 

  556. 								`component_active` tinyint(1) NULL DEFAULT '0',

    557. 

  557. 								`component_delate` tinyint(1) NULL DEFAULT '0', 

    558. 

  558. 								PRIMARY KEY (`component_id`), 

    559. 

  559. 								UNIQUE `component_identify` (`component_identify`)

    560. 

  560. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    561. 

  561.                             $result = mysql_query($sql);

    562. 

  562. 

    563. 

  563.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    564. 

  564.                             $result ? $_error = $_error : $_error = $_error + 1;

    565. 

  565. 

    566. 

  566. 

    567. 

  567.                             // BLOCK

    568. 

  568.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_block</dt><dd>';

    569. 

  569. 

    570. 

  570.                             $sql = 'DROP TABLE IF EXISTS ' . $prefix . '_block';

    571. 

  571.                             $result = mysql_query($sql);

    572. 

  572. 

    573. 

  573.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    574. 

  574.                             $result ? $_error = $_error : $_error = $_error + 1;

    575. 

  575. 

    576. 

  576.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_block</dt><dd>';

    577. 

  577. 

    578. 

  578.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_block (

    579. 

  579. 			    				`block_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    580. 

  580. 								`block_name` varchar(100) NULL DEFAULT NULL,

    581. 

  581. 								`block_identify` varchar(100) NULL DEFAULT NULL,

    582. 

  582. 								`block_description` text NULL DEFAULT NULL,

    583. 

  583. 								`block_type` tinyint(1) NULL DEFAULT '0',

    584. 

  584. 								`block_code` text NULL DEFAULT NULL,

    585. 

  585. 								`block_text` text NULL DEFAULT NULL,

    586. 

  586. 								`block_comidentify` varchar(100) NULL DEFAULT NULL,

    587. 

  587. 								`block_options` text NULL DEFAULT NULL,

    588. 

  588. 								`block_permission` varchar(255) NULL DEFAULT NULL,

    589. 

  589. 								`block_active` tinyint(1) NULL DEFAULT '0',

    590. 

  590. 								`block_position` tinyint(4) NULL DEFAULT '0', 

    591. 

  591. 								PRIMARY KEY (`block_id`)

    592. 

  592. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    593. 

  593.                             $result = mysql_query($sql);

    594. 

  594. 

    595. 

  595.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    596. 

  596.                             $result ? $_error = $_error : $_error = $_error + 1;

    597. 

  597. 

    598. 

  598. 

    599. 

  599.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_block</dt><dd>';

    600. 

  600. 

    601. 

  601.                             $sql = "INSERT

    602. 

  602.                                 INTO " . $prefix . "_block

    603. 

  603.                                     (block_id, block_name, block_identify, block_description, block_type, block_comidentify, block_options, block_active, block_position)

    604. 

  604.                                 VALUES

    605. 

  605. 				    				(1, '" . lang('INSTALL: BASIC LINKS') . "', 'header', '" . lang('INSTALL: BASIC LINKS') . "', 3, 'primary_links', '{\"menu_id\":\"navbarMenu\",\"menu_class\":\"navbarMenu\",\"menu_show_title\":\"0\",\"menu_title\":\"Menu\"}', 1, 1),

    606. 

  606. 								    (2, '" . lang('INSTALL: ADMIN LINKS') . "', 'admin_links', '" . lang('INSTALL: ADMIN LINKS INFO') . "', 3, 'admin_links', '{\"menu_id\":\"\",\"menu_class\":\"\",\"menu_show_title\":\"1\",\"menu_title\":\"Menu\"}', 1, 1),

    607. 

  607. 								    (3, '" . lang('INSTALL: ADMIN MODULES') . "', 'admin_modules', '" . lang('INSTALL: ADMIN MODULES INFO') . "', 3, 'admin_modules', '{\"menu_id\":\"\",\"menu_class\":\"\",\"menu_show_title\":\"1\",\"menu_title\":\"Menu\"}', 1, 1);";

    608. 

  608.                             $result = mysql_query($sql);

    609. 

  609. 

    610. 

  610.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    611. 

  611.                             $result ? $_error = $_error : $_error = $_error + 1;

    612. 

  612. 

    613. 

  613.                             // MENU

    614. 

  614.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_menu</dt><dd>';

    615. 

  615. 

    616. 

  616.                             $sql = "DROP TABLE IF EXISTS " . $prefix . "_menu";

    617. 

  617.                             $result = mysql_query($sql);

    618. 

  618. 

    619. 

  619.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    620. 

  620.                             $result ? $_error = $_error : $_error = $_error + 1;

    621. 

  621. 

    622. 

  622.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_menu</dt><dd>';

    623. 

  623. 

    624. 

  624.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_menu (

    625. 

  625. 			    				`menu_id` int(11) NULL DEFAULT NULL AUTO_INCREMENT,

    626. 

  626. 								`menu_identify` varchar(32) NULL DEFAULT NULL,

    627. 

  627. 								`menu_name` varchar(32) NULL DEFAULT NULL,

    628. 

  628. 								`menu_description` text NULL DEFAULT NULL,

    629. 

  629. 								`menu_active` tinyint(1) NULL DEFAULT '0',

    630. 

  630. 								`menu_delate` tinyint(1) NULL DEFAULT '1', 

    631. 

  631. 								PRIMARY KEY (`menu_id`)

    632. 

  632. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";

    633. 

  633.                             $result = mysql_query($sql);

    634. 

  634. 

    635. 

  635.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    636. 

  636.                             $result ? $_error = $_error : $_error = $_error + 1;

    637. 

  637. 

    638. 

  638. 

    639. 

  639.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_menu</dt><dd>';

    640. 

  640. 

    641. 

  641.                             $sql = "INSERT

    642. 

  642.                                 INTO " . $prefix . "_menu

    643. 

  643.                                     (menu_id, menu_identify, menu_name, menu_description, menu_active, menu_delate)

    644. 

  644.                                 VALUES

    645. 

  645. 				    				(1, 'primary_links', '" . lang('INSTALL: BASIC LINKS') . "', '" . lang('INSTALL: BASIC LINKS') . "', 1, 0),

    646. 

  646. 								    (2, 'secendary_links', '" . lang('INSTALL: ADDITIONAL LINKS') . "', '" . lang('INSTALL: ADDITIONAL LINKS INFO') . "', 1, 0),

    647. 

  647. 								    (3, 'navigation', '" . lang('INSTALL: NAVIGATION') . "', '" . lang('INSTALL: NAVIGATION INFO') . "', 1, 0),

    648. 

  648. 								    (4, 'admin_links', '" . lang('INSTALL: ADMIN LINKS') . "', '" . lang('INSTALL: ADMIN LINKS INFO') . "', 1, 0),

    649. 

  649. 								    (5, 'admin_modules', '" . lang('INSTALL: ADMIN MODULES') . "', '" . lang('INSTALL: ADMIN MODULES INFO') . "', 1, 0),

    650. 

  650. 								    (6, 'admin_components', '" . lang('INSTALL: ADMIN COMPONENTS') . "', '" . lang('INSTALL: ADMIN COMPONENTS INFO') . "', 1, 0);";

    651. 

  651.                             $result = mysql_query($sql);

    652. 

  652. 

    653. 

  653.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    654. 

  654.                             $result ? $_error = $_error : $_error = $_error + 1;

    655. 

  655. 

    656. 

  656. 

    657. 

  657.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_menuelements</dt><dd>';

    658. 

  658. 

    659. 

  659.                             $sql = "DROP TABLE IF EXISTS " . $prefix . "_menuelements";

    660. 

  660.                             $result = mysql_query($sql);

    661. 

  661. 

    662. 

  662.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    663. 

  663.                             $result ? $_error = $_error : $_error = $_error + 1;

    664. 

  664. 

    665. 

  665.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_menuelements</dt><dd>';

    666. 

  666. 

    667. 

  667.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_menuelements (

    668. 

  668. 			        			`element_id` int(11) NULL DEFAULT NULL AUTO_INCREMENT,

    669. 

  669. 								`element_menu` varchar(32) NULL DEFAULT NULL,

    670. 

  670. 								`element_parentid` int(10) NULL DEFAULT '0',

    671. 

  671. 								`element_patch` varchar(255) NULL DEFAULT NULL,

    672. 

  672. 								`element_seolink` varchar(255) NULL DEFAULT NULL,

    673. 

  673. 								`element_name` varchar(255) NULL DEFAULT NULL,

    674. 

  674. 								`element_title` varchar(255) NULL DEFAULT NULL,

    675. 

  675. 								`element_options` text NULL DEFAULT NULL,

    676. 

  676. 								`element_module` varchar(255) NULL DEFAULT NULL,

    677. 

  677. 								`element_include` varchar(255) NULL DEFAULT NULL,

    678. 

  678. 								`element_active` tinyint(1) NULL DEFAULT '0',

    679. 

  679. 								`element_notlink` tinyint(1) NULL DEFAULT '0',

    680. 

  680. 								`element_notmenu` tinyint(1) NULL DEFAULT '0',

    681. 

  681. 								`element_external` tinyint(1) NULL DEFAULT '0',

    682. 

  682. 								`element_expanded` tinyint(1) NULL DEFAULT '0',

    683. 

  683. 								`element_position` tinyint(4) NULL DEFAULT '0',

    684. 

  684. 								`element_depht` tinyint(4) NULL DEFAULT '0',

    685. 

  685. 								`element_p1` int(10) NULL DEFAULT '0',

    686. 

  686. 								`element_p2` int(10) NULL DEFAULT '0',

    687. 

  687. 								`element_p3` int(10) NULL DEFAULT '0',

    688. 

  688. 								`element_p4` int(10) NULL DEFAULT '0',

    689. 

  689. 							    `element_p5` int(10) NULL DEFAULT '0',

    690. 

  690. 								`element_p6` int(10) NULL DEFAULT '0',

    691. 

  691. 								`element_p7` int(10) NULL DEFAULT '0',

    692. 

  692. 								`element_p8` int(10) NULL DEFAULT '0',

    693. 

  693. 							    `element_p9` int(10) NULL DEFAULT '0',

    694. 

  694. 								`element_delate` tinyint(1) NULL DEFAULT '0',

    695. 

  695. 								`element_clone` int(10) NULL DEFAULT '0',

    696. 

  696. 								`element_cache` int(10) NULL DEFAULT '0',

    697. 

  697. 								`element_permission` varchar(255) NULL DEFAULT NULL, 

    698. 

  698. 								PRIMARY KEY (`element_id`)

    699. 

  699. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=8;";

    700. 

  700.                             $result = mysql_query($sql);

    701. 

  701. 

    702. 

  702.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    703. 

  703.                             $result ? $_error = $_error : $_error = $_error + 1;

    704. 

  704. 

    705. 

  705. 

    706. 

  706.                             $msg .= '<dl><dt>' . lang('INSTALL: I PUT A DATA IN AN ARRAY') . ' ' . $prefix . '_menuelements</dt><dd>';

    707. 

  707. 

    708. 

  708.                             $sql = "INSERT

    709. 

  709.                                 INTO " . $prefix . "_menuelements

    710. 

  710.                                     (element_id, element_menu, element_patch, element_seolink, element_name, element_title, element_module, element_include, element_active, element_position, element_depht, element_p1, element_permission)

    711. 

  711.                                 VALUES

    712. 

  712. 			            			(1, 'primary_links', 'node/1', '<front>', 'Front site', 'Front site', 'frontsite', 'module/frontsite/frontsite.display.php', 1, 1, 1, 1, ''),

    713. 

  713. 					    			(2, 'navigation', 'node/2', 'register', 'Register', 'Register', 'register', 'module/register/register.display.php', 1, 2, 1, 2, ''),

    714. 

  714. 								    (3, 'navigation', 'node/3', 'login', 'Login', 'Login', 'login', 'module/login/login.display.php', 1, 1, 1, 3, ''),

    715. 

  715. 								    (4, 'navigation', 'node/4', 'error', 'Error', 'Error', 'content', 'module/content/content.display.php', 1, 1, 1, 4, ''),

    716. 

  716. 								    (5, 'navigation', 'node/5', 'localization', 'Localization', 'Localization', 'content', 'module/content/content.display.php', 1, 1, 1, 5, ''),

    717. 

  717. 								    (6, 'admin_links', 'admin/settings', 'admin/settings', 'Ustawienia serwisu', 'Ustawienia serwisu', 'admin', 'module/admin/admin.display.php', 1, 1, 1, 6, 'admin,demo'),

    718. 

  718. 								    (7, 'admin_links', 'admin/group', 'admin/group', 'Grupy u?ytkowników', 'Grupy u?ytkowników', 'admin', 'module/admin/admin.display.php', 1, 2, 1, 7, 'admin,demo'),

    719. 

  719. 								    (8, 'admin_links', 'admin/user', 'admin/user', 'U?ytkownicy', 'U?ytkownicy', 'admin', 'module/admin/admin.display.php', 1, 3, 1, 8, 'admin,demo'),

    720. 

  720. 								    (9, 'admin_links', 'admin/module', 'admin/module', 'Modu?y', 'Modu?y', 'admin', 'module/admin/admin.display.php', 1, 4, 1, 9, 'admin,demo'),

    721. 

  721. 								    (10, 'admin_links', 'admin/component', 'admin/component', 'Komponenty', 'Komponenty', 'admin', 'module/admin/admin.display.php', 1, 5, 1, 10, 'admin,demo'),

    722. 

  722. 								    (11, 'admin_links', 'admin/content', 'admin/content', 'Zawarto??', 'Zawarto??', 'admin', 'module/admin/admin.display.php', 1, 6, 1, 11, 'admin,demo'),

    723. 

  723. 								    (12, 'admin_links', 'admin/menubuilder', 'admin/menubuilder', 'Menu', 'Menu', 'admin', 'module/admin/admin.display.php', 1, 7, 1, 12, 'admin,demo'),

    724. 

  724. 								    (13, 'admin_links', 'admin/block', 'admin/block', 'Bloki', 'Bloki', 'admin', 'module/admin/admin.display.php', 1, 8, 1, 13, 'admin,demo'),

    725. 

  725. 								    (14, 'admin_links', 'admin/lang', 'admin/lang', 'J?zyk', 'J?zyk', 'admin', 'module/admin/admin.display.php', 1, 9, 1, 14, 'admin,demo'),

    726. 

  726. 								    (15, 'admin_links', 'admin/ban', 'admin/ban', 'Bany', 'Bany', 'admin', 'module/admin/admin.display.php', 1, 10, 1, 15, 'admin,demo');";

    727. 

  727.                             $result = mysql_query($sql);

    728. 

  728. 

    729. 

  729.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    730. 

  730.                             $result ? $_error = $_error : $_error = $_error + 1;

    731. 

  731. 

    732. 

  732. 

    733. 

  733.                             // USERS

    734. 

  734.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_user</dt><dd>';

    735. 

  735. 

    736. 

  736.                             $sql = "DROP TABLE IF EXISTS " . $prefix . "_user";

    737. 

  737.                             $result = mysql_query($sql);

    738. 

  738. 

    739. 

  739.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    740. 

  740.                             $result ? $_error = $_error : $_error = $_error + 1;

    741. 

  741. 

    742. 

  742.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_user</dt><dd>';

    743. 

  743. 

    744. 

  744.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_user (

    745. 

  745. 			        			`user_id` mediumint(8) NULL DEFAULT NULL AUTO_INCREMENT,

    746. 

  746. 								`username` varchar(255) NULL DEFAULT NULL,

    747. 

  747. 								`user_email` varchar(100) NULL DEFAULT NULL,

    748. 

  748. 								`user_password` varchar(40) NULL DEFAULT NULL,

    749. 

  749. 								`user_lastchanges` int(11) NULL DEFAULT '0',

    750. 

  750. 								`user_regdate` int(11) NULL DEFAULT '0',

    751. 

  751. 								`user_lastvisit` int(11) NULL DEFAULT '0',

    752. 

  752. 						        `user_online` tinyint(1) NULL DEFAULT '0',

    753. 

  753. 								`user_actkey` varchar(32) NULL DEFAULT NULL,

    754. 

  754. 								`user_ip` varchar(40) NULL DEFAULT NULL,

    755. 

  755. 								`user_question` varchar(255) NULL DEFAULT NULL,

    756. 

  756. 								`user_answer` varchar(255) NULL DEFAULT NULL,

    757. 

  757. 								`user_permissions` varchar(255) NULL DEFAULT '0',

    758. 

  758. 								`user_lastpage` text NULL DEFAULT NULL,

    759. 

  759. 								`user_style` varchar(255) NULL DEFAULT '0',

    760. 

  760. 								`user_birthday` int(10) NULL DEFAULT '0',

    761. 

  761. 								`user_name` varchar(100) NULL DEFAULT NULL,

    762. 

  762. 								`user_name_show` tinyint(1) NULL DEFAULT '0',

    763. 

  763. 								`user_surname` varchar(100) NULL DEFAULT NULL,

    764. 

  764. 								`user_surname_show` tinyint(1) NULL DEFAULT '0',

    765. 

  765. 								`user_sex` tinyint(1) NULL DEFAULT '0',

    766. 

  766. 								`user_city_name` varchar(100) NULL DEFAULT NULL,

    767. 

  767. 								`user_ads` tinyint(1) NULL DEFAULT '0',

    768. 

  768. 								`user_status` tinyint(1) NULL DEFAULT '0', 

    769. 

  769. 								PRIMARY KEY (`user_id`), 

    770. 

  770. 								UNIQUE `user_email` (`user_email`), 

    771. 

  771. 								UNIQUE `username` (`username`)

    772. 

  772. 							    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=2;";

    773. 

  773.                             $result = mysql_query($sql);

    774. 

  774. 

    775. 

  775.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    776. 

  776.                             $result ? $_error = $_error : $_error = $_error + 1;

    777. 

  777. 

    778. 

  778. 

    779. 

  779.                             // BANLIST

    780. 

  780.                             $msg .= '<dl><dt>' . lang('INSTALL: ERASE ARRAY') . ' ' . $prefix . '_banlist</dt><dd>';

    781. 

  781. 

    782. 

  782.                             $sql = "DROP TABLE IF EXISTS " . $prefix . "_banlist";

    783. 

  783.                             $result = mysql_query($sql);

    784. 

  784. 

    785. 

  785.                             $msg .= ($result ? '<span class="green">' . lang('INSTALL: SUCCESS') . '</span>' : '<span class="red">' . lang('INSTALL: FAILURE') . '</span>') . '</dd></dl>';

    786. 

  786.                             $result ? $_error = $_error : $_error = $_error + 1;

    787. 

  787. 

    788. 

  788.                             $msg .= '<dl><dt>' . lang('INSTALL: I ASSUME AN ARRAY') . ' ' . $prefix . '_banlist</dt><dd>';

    789. 

  789. 

    790. 

  790.                             $sql = "CREATE TABLE IF NOT EXISTS " . $prefix . "_banlist (

    791. 

  791. 			     				`ban_id` int(10) NULL DEFAULT NULL AUTO_INCREMENT,

    792. 

  792. 								`ban_userid` int(10) NULL DEFAULT '0',

    793. 

  793. 								`ban_ip` varchar(255) NULL DEFAULT NULL,

    794. 

  794. 								`ban_email` varchar(255) NULL DEFAULT NULL,

    795. 

  795. 								`ban_start` int(10) NULL DEFAULT '0',

    796. 

  796. 								`ban_end` int(10) NULL DEFAULT '0',

    797. 

  797. 								`ban_rea…
    798.

Large files files are truncated, but you can click here to view the full file