");
define('_NGIMG',"
");
$b_back = '';
$b_reload = '';
$b_next = '';
// options for mainfile.php
$xoopsOption['nocommon'] = true;
define('XOOPS_INSTALL', 1);
if(!empty($_POST['op']))
$op = $_POST['op'];
elseif(!empty($_GET['op']))
$op = $_GET['op'];
else
$op = '';
///// main
switch ($op) {
default:
case "langselect":
$title = _INSTALL_L0;
if (!defined('_INSTALL_L128')) {
define('_INSTALL_L128', 'Choose language to be used for the installation process');
}
$content = ""._INSTALL_L128."
" .""; $b_next = array('start', _INSTALL_L80 ); include 'install_tpl.php'; break; case "start": $title = _INSTALL_L0; $content = "| \n"; include './language/'.$language.'/welcome.php'; $content .= " |
| \n";
$error = false;
foreach ($writeok as $wok) {
if (!is_dir("../".$wok)) {
if ( file_exists("../".$wok) ) {
@chmod("../".$wok, 0666);
if (! is_writeable("../".$wok)) {
$content .= _NGIMG.sprintf(_INSTALL_L83, $wok)." "; $error = true; }else{ $content .= _OKIMG.sprintf(_INSTALL_L84, $wok)." "; } } } else { @chmod("../".$wok, 0777); if (! is_writeable("../".$wok)) { $content .= _NGIMG.sprintf(_INSTALL_L85, $wok)." "; $error = true; }else{ $content .= _OKIMG.sprintf(_INSTALL_L86, $wok)." "; } } } $content .= " |
"._INSTALL_L87."
"; $b_next = array('dbform', _INSTALL_L89 ); }else{ $content .= ""._INSTALL_L46."
"; $b_reload = true; } include 'install_tpl.php'; break; case "dbform": include_once '../mainfile.php'; include_once 'class/settingmanager.php'; $sm = new setting_manager(); $sm->readConstant(); $content = $sm->editform(); $title = _INSTALL_L90; $b_next = array('dbconfirm',_INSTALL_L91); include 'install_tpl.php'; break; case "dbconfirm": include_once 'class/settingmanager.php'; $sm = new setting_manager(true); $content = $sm->checkData(); if (!empty($content)) { $content .= $sm->editform(); $b_next = array('dbconfirm',_INSTALL_L91); include 'install_tpl.php'; break; } $title = _INSTALL_L53; $content = $sm->confirmForm(); $b_next = array('dbsave',_INSTALL_L92 ); $b_back = array('', _INSTALL_L93 ); include 'install_tpl.php'; break; case "dbsave": include_once "./class/mainfilemanager.php"; $title = _INSTALL_L88; $mm = new mainfile_manager("../mainfile.php"); $ret = $mm->copyDistFile(); if(! $ret){ $content = _INSTALL_L60; include 'install_tpl.php'; exit(); } $mm->setRewrite('XOOPS_ROOT_PATH', trim($myts->stripSlashesGPC($_POST['root_path']))); $mm->setRewrite('XOOPS_URL', trim($myts->stripSlashesGPC($_POST['xoops_url']))); $mm->setRewrite('XOOPS_DB_TYPE', trim($myts->stripSlashesGPC($_POST['database']))); $mm->setRewrite('XOOPS_DB_PREFIX', trim($myts->stripSlashesGPC($_POST['prefix']))); $mm->setRewrite('XOOPS_DB_HOST', trim($myts->stripSlashesGPC($_POST['dbhost']))); $mm->setRewrite('XOOPS_DB_USER', trim($myts->stripSlashesGPC($_POST['dbuname']))); $mm->setRewrite('XOOPS_DB_PASS', trim($myts->stripSlashesGPC($_POST['dbpass']))); $mm->setRewrite('XOOPS_DB_NAME', trim($myts->stripSlashesGPC($_POST['dbname']))); $mm->setRewrite('XOOPS_DB_PCONNECT', intval($_POST['db_pconnect'])); $mm->setRewrite('XOOPS_GROUP_ADMIN', 1); $mm->setRewrite('XOOPS_GROUP_USERS', 2); $mm->setRewrite('XOOPS_GROUP_ANONYMOUS', 3); // Check if XOOPS_CHECK_PATH should be initially set or not $xoopsPathTrans = isset($_SERVER['PATH_TRANSLATED']) ? $_SERVER['PATH_TRANSLATED'] : $_SERVER['SCRIPT_FILENAME']; if ( DIRECTORY_SEPARATOR != '/' ) { // IIS6 doubles the \ chars $xoopsPathTrans = str_replace( strpos( $xoopsPathTrans, '\\\\', 2 ) ? '\\\\' : DIRECTORY_SEPARATOR, '/', $xoopsPathTrans); } $mm->setRewrite('XOOPS_CHECK_PATH', strcasecmp( substr($xoopsPathTrans, 0, strlen($myts->stripSlashesGPC($_POST['root_path']))), $_POST['root_path']) ? 0 : 1 ); $ret = $mm->doRewrite(); if(! $ret){ $content = _INSTALL_L60; include 'install_tpl.php'; exit(); } $content = $mm->report(); $content .= ""._INSTALL_L62."
\n"; $b_next = array('mainfile', _INSTALL_L94 ); include 'install_tpl.php'; break; case "mainfile": // checking XOOPS_ROOT_PATH and XOOPS_URL include_once "../mainfile.php"; $title = _INSTALL_L94; $content = "| \n";
$detected = str_replace("\\", "/", getcwd()); // "
$detected = str_replace("/install", "", $detected);
if ( substr($detected, -1) == "/" ) {
$detected = substr($detected, 0, -1);
}
if (empty($detected)){
$content .= _NGIMG._INSTALL_L95.' '; } elseif ( XOOPS_ROOT_PATH != $detected ) { $content .= _NGIMG.sprintf(_INSTALL_L96,$detected). ' '; }else { $content .= _OKIMG._INSTALL_L97.' '; } if(!is_dir(XOOPS_ROOT_PATH)){ $content .= _NGIMG._INSTALL_L99.' '; } if(preg_match('/^http[s]?:\/\/(.*)[^\/]+$/i',XOOPS_URL)){ $content .= _OKIMG._INSTALL_L100.' '; }else{ $content .= _NGIMG._INSTALL_L101.' '; } $content .= " |
| \n";
$content .= _INSTALL_L11."".XOOPS_ROOT_PATH." "; $content .= _INSTALL_L12."".XOOPS_URL." "; $content .= " |
"._INSTALL_L13."
\n"; $b_next = array('initial', _INSTALL_L102 ); $b_back = array('start', _INSTALL_L103 ); $b_reload = true; include 'install_tpl.php'; //mainfile_settings(); break; case "initial": // confirm database setting include_once "../mainfile.php"; $content = "";
$content .= "
\n"; $content .= " | ||||||||
| ";
$content .= _INSTALL_L13." \n"; $content .= " |
| \n";
if (! $dbm->isConnectable()) {
$content .= _NGIMG._INSTALL_L106." "; $content .= " "._INSTALL_L107; $content .= " |
"._INSTALL_L21."
"
."".XOOPS_DB_NAME."
"._INSTALL_L22."
"; $b_next = array('createDB', _INSTALL_L105); $b_back = array('start', _INSTALL_L103); $b_reload = true; }else{ if (!$dbm->tableExists('users')) { $content .= _OKIMG.sprintf(_INSTALL_L110, XOOPS_DB_NAME).""._INSTALL_L111."
"; $b_next = array('createTables', _INSTALL_L40); } else { $content .= _OKIMG.sprintf(_INSTALL_L110, XOOPS_DB_NAME).""._INSTALL_L130."
"; $b_next = array('updateTables', _INSTALL_L14); } else { $content .= _NGIMG._INSTALL_L131.""._INSTALL_L31."
"; $b_next = array('checkDB', _INSTALL_L104); $b_back = array('start', _INSTALL_L103); }else{ $content = "".sprintf(_INSTALL_L43, XOOPS_DB_NAME)."
"; $b_next = array('checkDB', _INSTALL_L104); } include 'install_tpl.php'; break; case "createTables": include_once "../mainfile.php"; include_once './class/dbmanager.php'; $dbm = new db_manager; //$content = "| \n";
$tables = array();
$result = $dbm->queryFromFile('./sql/'.XOOPS_DB_TYPE.'.structure.sql');
$content = $dbm->report();
if(! $result ){
//$deleted = $dbm->deleteTables($tables);
$content .= " "._INSTALL_L114." \n"; $b_back = array('start', _INSTALL_L103); }else{ $content .= ""._INSTALL_L115." \n"; $b_next = array('siteInit', _INSTALL_L112); } include 'install_tpl.php'; break; case 'updateTables': include_once "../mainfile.php"; include_once './class/dbmanager.php'; $db = new db_manager; $sql = 'SELECT * FROM '.$db->prefix('groups'); $result = $db->query($sql); $content = ''._INSTALL_L157.''; $content .= '
"._INSTALL_L135." \n"; $b_back = array(); } else { $content .= ""._INSTALL_L136." \n"; $b_next = array('updateConfig', _INSTALL_L14); } include 'install_tpl.php'; break; case 'updateConfig': $b_next = array('updateConfig_go', _INSTALL_L144); $content = ""._INSTALL_L143." \n"; include 'install_tpl.php'; break; case 'updateConfig_go': include_once "../mainfile.php"; $language = check_language($language); if ( file_exists("./language/".$language."/install2.php") ) { include_once "./language/".$language."/install2.php"; } elseif ( file_exists("./language/english/install2.php") ) { include_once "./language/english/install2.php"; $language = 'english'; } else { echo 'no language file (install2.php).'; exit(); } include_once './class/dbmanager.php'; $dbm = new db_manager; // default settings $xoopsConfig['sitename'] = 'XOOPS Site'; $xoopsConfig['slogan'] = 'Just use it!'; $xoopsConfig['adminmail'] = ''; $xoopsConfig['language'] = 'english'; $xoopsConfig['anonymous'] = 'Anonymous'; $xoopsConfig['minpass'] = 5; $xoopsConfig['anonpost'] = 0; $xoopsConfig['new_user_notify'] = 0; $xoopsConfig['new_user_notify_group'] = 1; $xoopsConfig['self_delete'] = 0; $xoopsConfig['gzip_compression'] = 0; $xoopsConfig['uname_test_level'] = 0; $xoopsConfig['usercookie'] = "xoops_user"; $xoopsConfig['sessioncookie'] = "xoops_session"; $xoopsConfig['sessionexpire'] = 4500; $xoopsConfig['server_TZ'] = 0; $xoopsConfig['default_TZ'] = 0; $xoopsConfig['banners'] = 1; $xoopsConfig['com_mode'] = "nest"; $xoopsConfig['com_order'] = 1; $xoopsConfig['my_ip'] = "127.0.0.1"; $xoopsConfig['avatar_allow_upload'] = 0; $xoopsConfig['avatar_width'] = 120; $xoopsConfig['avatar_height'] = 120; $xoopsConfig['avatar_maxsize'] = 15000; // override deafault with 1.3.x settings if any if (file_exists('../modules/system/cache/config.php')) { include_once('../modules/system/cache/config.php'); } $dbm->insert('config', " VALUES (1, 0, 1, 'sitename', '_MD_AM_SITENAME', '".addslashes($xoopsConfig['sitename'])."', '_MD_AM_SITENAMEDSC', 'textbox', 'text', 0)"); $dbm->insert('config', " VALUES (2, 0, 1, 'slogan', '_MD_AM_SLOGAN', '".addslashes($xoopsConfig['slogan'])."', '_MD_AM_SLOGANDSC', 'textbox', 'text', 2)"); $dbm->insert('config', " VALUES (3, 0, 1, 'language', '_MD_AM_LANGUAGE', '".$xoopsConfig['language']."', '_MD_AM_LANGUAGEDSC', 'language', 'other', 4)"); $dbm->insert('config', " VALUES (4, 0, 1, 'startpage', '_MD_AM_STARTPAGE', '--', '_MD_AM_STARTPAGEDSC', 'startpage', 'other', 6)"); $dbm->insert('config', " VALUES (5, 0, 1, 'server_TZ', '_MD_AM_SERVERTZ', '".addslashes($xoopsConfig['server_TZ'])."', '_MD_AM_SERVERTZDSC', 'timezone', 'float', 8)"); $dbm->insert('config', " VALUES (6, 0, 1, 'default_TZ', '_MD_AM_DEFAULTTZ', '".addslashes($xoopsConfig['default_TZ'])."', '_MD_AM_DEFAULTTZDSC', 'timezone', 'float', 10)"); $dbm->insert('config', " VALUES (7, 0, 1, 'theme_set', '_MD_AM_DTHEME', 'default', '_MD_AM_DTHEMEDSC', 'theme', 'other', 12)"); $dbm->insert('config', " VALUES (8, 0, 1, 'anonymous', '_MD_AM_ANONNAME', '".addslashes($xoopsConfig['anonymous'])."', '_MD_AM_ANONNAMEDSC', 'textbox', 'text', 15)"); $dbm->insert('config', " VALUES (9, 0, 1, 'gzip_compression', '_MD_AM_USEGZIP', '".intval($xoopsConfig['gzip_compression'])."', '_MD_AM_USEGZIPDSC', 'yesno', 'int', 16)"); $dbm->insert('config', " VALUES (10, 0, 1, 'usercookie', '_MD_AM_USERCOOKIE', '".addslashes($xoopsConfig['usercookie'])."', '_MD_AM_USERCOOKIEDSC', 'textbox', 'text', 18)"); $dbm->insert('config', " VALUES (11, 0, 1, 'session_expire', '_MD_AM_SESSEXPIRE', '15', '_MD_AM_SESSEXPIREDSC', 'textbox', 'int', 22)"); $dbm->insert('config', " VALUES (12, 0, 1, 'banners', '_MD_AM_BANNERS', '".intval($xoopsConfig['banners'])."', '_MD_AM_BANNERSDSC', 'yesno', 'int', 26)"); $dbm->insert('config', " VALUES (13, 0, 1, 'debug_mode', '_MD_AM_DEBUGMODE', '0', '_MD_AM_DEBUGMODEDSC', 'select', 'int', 24)"); $dbm->insert('config', " VALUES (14, 0, 1, 'my_ip', '_MD_AM_MYIP', '".addslashes($xoopsConfig['my_ip'])."', '_MD_AM_MYIPDSC', 'textbox', 'text', 29)"); $dbm->insert('config', " VALUES (15, 0, 1, 'use_ssl', '_MD_AM_USESSL', '0', '_MD_AM_USESSLDSC', 'yesno', 'int', 30)"); $dbm->insert('config', " VALUES (16, 0, 1, 'session_name', '_MD_AM_SESSNAME', 'xoops_session', '_MD_AM_SESSNAMEDSC', 'textbox', 'text', 20)"); $dbm->insert('config', " VALUES (17, 0, 2, 'minpass', '_MD_AM_MINPASS', '".intval($xoopsConfig['minpass'])."', '_MD_AM_MINPASSDSC', 'textbox', 'int', 1)"); $dbm->insert('config', " VALUES (18, 0, 2, 'minuname', '_MD_AM_MINUNAME', '5', '_MD_AM_MINUNAMEDSC', 'textbox', 'int', 2)"); $dbm->insert('config', " VALUES (19, 0, 2, 'new_user_notify', '_MD_AM_NEWUNOTIFY', '".intval($xoopsConfig['new_user_notify'])."', '_MD_AM_NEWUNOTIFYDSC', 'yesno', 'int', 4)"); $dbm->insert('config', " VALUES (20, 0, 2, 'new_user_notify_group', '_MD_AM_NOTIFYTO', ".intval($xoopsConfig['new_user_notify_group']).", '_MD_AM_NOTIFYTODSC', 'group', 'int', 6)"); $dbm->insert('config', " VALUES (21, 0, 2, 'activation_type', '_MD_AM_ACTVTYPE', '0', '_MD_AM_ACTVTYPEDSC', 'select', 'int', 8)"); $dbm->insert('config', " VALUES (22, 0, 2, 'activation_group', '_MD_AM_ACTVGROUP', ".XOOPS_GROUP_ADMIN.", '_MD_AM_ACTVGROUPDSC', 'group', 'int', 10)"); $dbm->insert('config', " VALUES (23, 0, 2, 'uname_test_level', '_MD_AM_UNAMELVL', '".intval($xoopsConfig['uname_test_level'])."', '_MD_AM_UNAMELVLDSC', 'select', 'int', 12)"); $dbm->insert('config', " VALUES (24, 0, 2, 'avatar_allow_upload', '_MD_AM_AVATARALLOW', '".intval($xoopsConfig['avatar_allow_upload'])."', '_MD_AM_AVATARALWDSC', 'yesno', 'int', 14)"); $dbm->insert('config', " VALUES (27, 0, 2, 'avatar_width', '_MD_AM_AVATARW', '".intval($xoopsConfig['avatar_width'])."', '_MD_AM_AVATARWDSC', 'textbox', 'int', 16)"); $dbm->insert('config', " VALUES (28, 0, 2, 'avatar_height', '_MD_AM_AVATARH', '".intval($xoopsConfig['avatar_height'])."', '_MD_AM_AVATARHDSC', 'textbox', 'int', 18)"); $dbm->insert('config', " VALUES (29, 0, 2, 'avatar_maxsize', '_MD_AM_AVATARMAX', '".intval($xoopsConfig['avatar_maxsize'])."', '_MD_AM_AVATARMAXDSC', 'textbox', 'int', 20)"); $dbm->insert('config', " VALUES (30, 0, 1, 'adminmail', '_MD_AM_ADMINML', '".addslashes($xoopsConfig['adminmail'])."', '_MD_AM_ADMINMLDSC', 'textbox', 'text', 3)"); $dbm->insert('config', " VALUES (31, 0, 2, 'self_delete', '_MD_AM_SELFDELETE', '".intval($xoopsConfig['self_delete'])."', '_MD_AM_SELFDELETEDSC', 'yesno', 'int', 22)"); $dbm->insert('config', " VALUES (32, 0, 1, 'com_mode', '_MD_AM_COMMODE', '".addslashes($xoopsConfig['com_mode'])."', '_MD_AM_COMMODEDSC', 'select', 'text', 34)"); $dbm->insert('config', " VALUES (33, 0, 1, 'com_order', '_MD_AM_COMORDER', '".intval($xoopsConfig['com_order'])."', '_MD_AM_COMORDERDSC', 'select', 'int', 36)"); $dbm->insert('config', " VALUES (34, 0, 2, 'bad_unames', '_MD_AM_BADUNAMES', '".addslashes(serialize(array('webmaster', '^xoops', '^admin')))."', '_MD_AM_BADUNAMESDSC', 'textarea', 'array', 24)"); $dbm->insert('config', " VALUES (35, 0, 2, 'bad_emails', '_MD_AM_BADEMAILS', '".addslashes(serialize(array('xoops.org$')))."', '_MD_AM_BADEMAILSDSC', 'textarea', 'array', 26)"); $dbm->insert('config', " VALUES (36, 0, 2, 'maxuname', '_MD_AM_MAXUNAME', '10', '_MD_AM_MAXUNAMEDSC', 'textbox', 'int', 3)"); $dbm->insert('config', " VALUES (37, 0, 1, 'bad_ips', '_MD_AM_BADIPS', '".addslashes(serialize(array('127.0.0.1')))."', '_MD_AM_BADIPSDSC', 'textarea', 'array', 42)"); $dbm->insert('config', " VALUES (38, 0, 3, 'meta_keywords', '_MD_AM_METAKEY', 'news, technology, headlines, xoops, xoop, nuke, myphpnuke, myphp-nuke, phpnuke, SE, geek, geeks, hacker, hackers, linux, software, download, downloads, free, community, mp3, forum, forums, bulletin, board, boards, bbs, php, survey, poll, polls, kernel, comment, comments, portal, odp, open, source, opensource, FreeSoftware, gnu, gpl, license, Unix, *nix, mysql, sql, database, databases, web site, weblog, guru, module, modules, theme, themes, cms, content management', '_MD_AM_METAKEYDSC', 'textarea', 'text', 0)"); $dbm->insert('config', " VALUES (39, 0, 3, 'footer', '_MD_AM_FOOTER', 'Powered by XOOPS 2.0 © 2001-" . date('Y', time()) . " The XOOPS Project', '_MD_AM_FOOTERDSC', 'textarea', 'text', 20)"); $dbm->insert('config', " VALUES (40, 0, 4, 'censor_enable', '_MD_AM_DOCENSOR', '0', '_MD_AM_DOCENSORDSC', 'yesno', 'int', 0)"); $dbm->insert('config', " VALUES (41, 0, 4, 'censor_words', '_MD_AM_CENSORWRD', '".addslashes(serialize(array('fuck', 'shit')))."', '_MD_AM_CENSORWRDDSC', 'textarea', 'array', 1)"); $dbm->insert('config', " VALUES (42, 0, 4, 'censor_replace', '_MD_AM_CENSORRPLC', '#OOPS#', '_MD_AM_CENSORRPLCDSC', 'textbox', 'text', 2)"); $dbm->insert('config', " VALUES (43, 0, 3, 'meta_robots', '_MD_AM_METAROBOTS', 'index,follow', '_MD_AM_METAROBOTSDSC', 'select', 'text', 2)"); $dbm->insert('config', " VALUES (44, 0, 5, 'enable_search', '_MD_AM_DOSEARCH', '1', '_MD_AM_DOSEARCHDSC', 'yesno', 'int', 0)"); $dbm->insert('config', " VALUES (45, 0, 5, 'keyword_min', '_MD_AM_MINSEARCH', '5', '_MD_AM_MINSEARCHDSC', 'textbox', 'int', 1)"); $dbm->insert('config', " VALUES (46, 0, 2, 'avatar_minposts', '_MD_AM_AVATARMP', '0', '_MD_AM_AVATARMPDSC', 'textbox', 'int', 15)"); $dbm->insert('config', " VALUES (47, 0, 1, 'enable_badips', '_MD_AM_DOBADIPS', '0', '_MD_AM_DOBADIPSDSC', 'yesno', 'int', 40)"); $dbm->insert('config', " VALUES (48, 0, 3, 'meta_rating', '_MD_AM_METARATING', 'general', '_MD_AM_METARATINGDSC', 'select', 'text', 4)"); $dbm->insert('config', " VALUES (49, 0, 3, 'meta_author', '_MD_AM_METAAUTHOR', 'XOOPS', '_MD_AM_METAAUTHORDSC', 'textbox', 'text', 6)"); $dbm->insert('config', " VALUES (50, 0, 3, 'meta_copyright', '_MD_AM_METACOPYR', 'Copyright © 2001-2003', '_MD_AM_METACOPYRDSC', 'textbox', 'text', 8)"); $dbm->insert('config', " VALUES (51, 0, 3, 'meta_description', '_MD_AM_METADESC', 'XOOPS is a dynamic Object Oriented based open source portal script written in PHP.', '_MD_AM_METADESCDSC', 'textarea', 'text', 1)"); $dbm->insert('config', " VALUES (52, 0, 2, 'allow_chgmail', '_MD_AM_ALLWCHGMAIL', '0', '_MD_AM_ALLWCHGMAILDSC', 'yesno', 'int', 3)"); $dbm->insert('config', " VALUES (53, 0, 1, 'use_mysession', '_MD_AM_USEMYSESS', '0', '_MD_AM_USEMYSESSDSC', 'yesno', 'int', 19)"); $dbm->insert('config', " VALUES (54, 0, 2, 'reg_dispdsclmr', '_MD_AM_DSPDSCLMR', 1, '_MD_AM_DSPDSCLMRDSC', 'yesno', 'int', 30)"); $dbm->insert('config', " VALUES (55, 0, 2, 'reg_disclaimer', '_MD_AM_REGDSCLMR', '".addslashes(_INSTALL_DISCLMR)."', '_MD_AM_REGDSCLMRDSC', 'textarea', 'text', 32)"); $dbm->insert('config', " VALUES (56, 0, 2, 'allow_register', '_MD_AM_ALLOWREG', 1, '_MD_AM_ALLOWREGDSC', 'yesno', 'int', 0)"); $dbm->insert('config', " VALUES (57, 0, 1, 'theme_fromfile', '_MD_AM_THEMEFILE', '0', '_MD_AM_THEMEFILEDSC', 'yesno', 'int', 13)"); $dbm->insert('config', " VALUES (58, 0, 1, 'closesite', '_MD_AM_CLOSESITE', '0', '_MD_AM_CLOSESITEDSC', 'yesno', 'int', 26)"); $dbm->insert('config', " VALUES (59, 0, 1, 'closesite_okgrp', '_MD_AM_CLOSESITEOK', '".addslashes(serialize(array('1')))."', '_MD_AM_CLOSESITEOKDSC', 'group_multi', 'array', 27)"); $dbm->insert('config', " VALUES (60, 0, 1, 'closesite_text', '_MD_AM_CLOSESITETXT', '"._INSTALL_L165."', '_MD_AM_CLOSESITETXTDSC', 'textarea', 'text', 28)"); $dbm->insert('config', " VALUES (61, 0, 1, 'sslpost_name', '_MD_AM_SSLPOST', 'xoops_ssl', '_MD_AM_SSLPOSTDSC', 'textbox', 'text', 31)"); $dbm->insert('config', " VALUES (62, 0, 1, 'module_cache', '_MD_AM_MODCACHE', '', '_MD_AM_MODCACHEDSC', 'module_cache', 'array', 50)"); $dbm->insert('config', " VALUES (63, 0, 1, 'template_set', '_MD_AM_DTPLSET', 'default', '_MD_AM_DTPLSETDSC', 'tplset', 'other', 14)"); $dbm->insert('config', " VALUES (64,0,6,'mailmethod','_MD_AM_MAILERMETHOD','mail','_MD_AM_MAILERMETHODDESC','select','text',4)"); $dbm->insert('config', " VALUES (65,0,6,'smtphost','_MD_AM_SMTPHOST','a:1:{i:0;s:0:\"\";}', '_MD_AM_SMTPHOSTDESC','textarea','array',6)"); $dbm->insert('config', " VALUES (66,0,6,'smtpuser','_MD_AM_SMTPUSER','','_MD_AM_SMTPUSERDESC','textbox','text',7)"); $dbm->insert('config', " VALUES (67,0,6,'smtppass','_MD_AM_SMTPPASS','','_MD_AM_SMTPPASSDESC','password','text',8)"); $dbm->insert('config', " VALUES (68,0,6,'sendmailpath','_MD_AM_SENDMAILPATH','/usr/sbin/sendmail','_MD_AM_SENDMAILPATHDESC','textbox','text',5)"); $dbm->insert('config', " VALUES (69,0,6,'from','_MD_AM_MAILFROM','','_MD_AM_MAILFROMDESC','textbox','text',1)"); $dbm->insert('config', " VALUES (70,0,6,'fromname','_MD_AM_MAILFROMNAME','','_MD_AM_MAILFROMNAMEDESC','textbox','text',2)"); $dbm->insert('config', " VALUES (71, 0, 1, 'sslloginlink', '_MD_AM_SSLLINK', 'https://', '_MD_AM_SSLLINKDSC', 'textbox', 'text', 33)"); $dbm->insert('config', " VALUES (72, 0, 1, 'theme_set_allowed', '_MD_AM_THEMEOK', '".serialize(array('default'))."', '_MD_AM_THEMEOKDSC', 'theme_multi', 'array', 13)"); $dbm->insert('config', " VALUES (73,0,6,'fromuid','_MD_AM_MAILFROMUID','1','_MD_AM_MAILFROMUIDDESC','user','int',3)"); $dbm->insert('config', " VALUES (74,0,7,'auth_method','_MD_AM_AUTHMETHOD','xoops','_MD_AM_AUTHMETHODDESC','select','text',1)"); $dbm->insert('config', " VALUES (75,0,7,'ldap_port','_MD_AM_LDAP_PORT','389','_MD_AM_LDAP_PORT','textbox','int',2)"); $dbm->insert('config', " VALUES (76,0,7,'ldap_server','_MD_AM_LDAP_SERVER','your directory server','_MD_AM_LDAP_SERVER_DESC','textbox','text',3)"); $dbm->insert('config', " VALUES (77,0,7,'ldap_base_dn','_MD_AM_LDAP_BASE_DN','dc=xoops,dc=org','_MD_AM_LDAP_BASE_DN_DESC','textbox','text',4)"); $dbm->insert('config', " VALUES (78,0,7,'ldap_manager_dn','_MD_AM_LDAP_MANAGER_DN','manager_dn','_MD_AM_LDAP_MANAGER_DN_DESC','textbox','text',5)"); $dbm->insert('config', " VALUES (79,0,7,'ldap_manager_pass','_MD_AM_LDAP_MANAGER_PASS','manager_pass','_MD_AM_LDAP_MANAGER_PASS_DESC','password','text',6)"); $dbm->insert('config', " VALUES (80,0,7,'ldap_version','_MD_AM_LDAP_VERSION','3','_MD_AM_LDAP_VERSION_DESC','textbox','text', 7)"); $dbm->insert('config', " VALUES (81,0,7,'ldap_users_bypass','_MD_AM_LDAP_USERS_BYPASS','".serialize(array('admin'))."','_MD_AM_LDAP_USERS_BYPASS_DESC','textarea','array',8)"); $dbm->insert('config', " VALUES (82,0,7,'ldap_loginname_asdn','_MD_AM_LDAP_LOGINNAME_ASDN','uid_asdn','_MD_AM_LDAP_LOGINNAME_ASDN_D','yesno','int',9)"); $dbm->insert('config', " VALUES (83,0,7,'ldap_loginldap_attr', '_MD_AM_LDAP_LOGINLDAP_ATTR', 'uid', '_MD_AM_LDAP_LOGINLDAP_ATTR_D', 'textbox', 'text', 10)"); $dbm->insert('config', " VALUES (84,0,7,'ldap_filter_person','_MD_AM_LDAP_FILTER_PERSON','','_MD_AM_LDAP_FILTER_PERSON_DESC','textbox','text',11)"); $dbm->insert('config', " VALUES (85,0,7,'ldap_domain_name','_MD_AM_LDAP_DOMAIN_NAME','mydomain','_MD_AM_LDAP_DOMAIN_NAME_DESC','textbox','text',12)"); $dbm->insert('config', " VALUES (86,0,7,'ldap_provisionning','_MD_AM_LDAP_PROVIS','0','_MD_AM_LDAP_PROVIS_DESC','yesno','int',13)"); $dbm->insert('config', " VALUES (87,0,7,'ldap_provisionning_group','_MD_AM_LDAP_PROVIS_GROUP','a:1:{i:0;s:1:\"2\";}','_MD_AM_LDAP_PROVIS_GROUP_DSC','group_multi','array',14)"); // default the default theme $time = time(); $dbm->insert('tplset', " VALUES (1, 'default', 'XOOPS Default Theme', '', ".$time.")"); // include_once './class/cachemanager.php'; // $cm = new cache_manager; // $skinfiles = array('1' => 'skin.html', '2' => 'style.css' // , '3' => 'styleNN.css','4' => 'styleMAC.css' // , '5' => 'skin_blockleft.html', '6' => 'skin_blockright.html' // , '7' => 'skin_blockcenter_l.html', '8' => 'skin_blockcenter_c.html' // , '9' => 'skin_blockcenter_r.html'); // foreach ($skinfiles as $key => $skinfile) { // if(preg_match('/\.css$/', $skinfile)) { // $type = 'css'; // }else{ // $type = 'skin'; // } // $dbm->insert('tplfile', " VALUES ($key, 0, '', 'default', '$skinfile', '', $time, $time, '$type')"); // $fp = fopen('./templates/default_skin/'.$skinfile, 'r'); // $skinsource = fread($fp, filesize('./templates/default_skin/'.$skinfile)); // fclose($fp); // $dbm->insert('tplsource', " (tpl_id, tpl_source) VALUES ($key, '".addslashes($skinsource)."')"); // if(preg_match('/\.css$/',$skinfile)) { // $cm->write($skinfile, $skinsource); // } // } $dbm->query("INSERT INTO ".$dbm->prefix('group_permission')." (gperm_groupid, gperm_itemid) SELECT groupid, block_id FROM ".$dbm->prefix('groups_blocks_link')); $dbm->query("UPDATE ".$dbm->prefix('group_permission')." SET gperm_name = 'block_read'"); $dbm->query("INSERT INTO ".$dbm->prefix('group_permission')." (gperm_groupid, gperm_itemid) SELECT groupid, mid FROM ".$dbm->prefix('groups_modules_link') ." WHERE type='A'"); $dbm->query("UPDATE ".$dbm->prefix('group_permission')." SET gperm_name = 'module_admin' WHERE gperm_name = ''"); $dbm->query("INSERT INTO ".$dbm->prefix('group_permission')." (gperm_groupid, gperm_itemid) SELECT groupid, mid FROM ".$dbm->prefix('groups_modules_link')." WHERE type='R'"); $dbm->query("UPDATE ".$dbm->prefix('group_permission')." SET gperm_name = 'module_read' WHERE gperm_name = ''"); $dbm->query("UPDATE ".$dbm->prefix('group_permission')." SET gperm_modid = 1"); $dbm->query('DROP TABLE '.$dbm->prefix('groups_blocks_link')); $dbm->query('DROP TABLE '.$dbm->prefix('groups_modules_link')); // insert some more data $result = $dbm->queryFromFile('./sql/'.XOOPS_DB_TYPE.'.data.sql'); $content = $dbm->report(); //$content .= $cm->report(); $b_next = array('updateModules', _INSTALL_L14); include 'install_tpl.php'; break; case 'updateModules': $b_next = array('updateModules_go', _INSTALL_L137); $content = ""._INSTALL_L141." \n"; include 'install_tpl.php'; break; case 'updateModules_go': unset($xoopsOption['nocommon']); include_once "../mainfile.php"; ?> smart and palo alta smart and palo alta of raymond carver careful raymond carver careful saw hogue fruita hogue fruita raise 3 killed middletown 301 3 killed middletown 301 build gerbers baby food history gerbers baby food history especially dickie nelson dickie nelson language allie lee norfolk virginia allie lee norfolk virginia want marilyn callahan marilyn callahan word clark tmt 250 clark tmt 250 suit manchester ny newspaper manchester ny newspaper number davis mountains bed breakfast davis mountains bed breakfast ever tompson center fire arms tompson center fire arms observe ocala womens center ocala womens center side raymond gabaldon history nm raymond gabaldon history nm idea victoria pub southport victoria pub southport enemy animal ark santuary rescue animal ark santuary rescue tie hr recruitment dublin hr recruitment dublin stretch ross anthony ross anthony give yoders amish canned beef yoders amish canned beef climb historical monuments of ireland historical monuments of ireland bank broadway realty sonoma ca broadway realty sonoma ca children fostoria family child center fostoria family child center between swiss holiday lodge shasta swiss holiday lodge shasta captain bezalel academy of art bezalel academy of art thank suncrest wellness center suncrest wellness center came leahy letter to gonzales leahy letter to gonzales neighbor sharon tanenhaus sharon tanenhaus truck brookfield house care brookfield house care hard doll house cheshire doll house cheshire continent climax coomunity tundra climax coomunity tundra describe susan clark chrietzberg susan clark chrietzberg scale university cleaning standards university cleaning standards seem revo hot air brush revo hot air brush opposite traktor hercules download free traktor hercules download free sand townplace suites denver co townplace suites denver co division helen mosca helen mosca still milford nh manicures milford nh manicures offer monterey avenue improvement monterey avenue improvement shore thomas frederick cumming ga thomas frederick cumming ga success boy s dinosaur underwear boy s dinosaur underwear matter black bear mounted buy black bear mounted buy star jesse gonzales 42 jesse gonzales 42 afraid townsend ga intracoastal homesite townsend ga intracoastal homesite basic racing hood pins racing hood pins decide miller model airplane starters miller model airplane starters travel madeline abduction venezualia madeline abduction venezualia lake trisha eckert trisha eckert town dennis and chloe danielson dennis and chloe danielson provide hospital in colorado springs hospital in colorado springs receive mineral wrap detox mineral wrap detox jump farmington victor kiwanis farmington victor kiwanis how rotating stone sphere fountain rotating stone sphere fountain story mrs ts dinosaur toes mrs ts dinosaur toes present dry flower center piece dry flower center piece collect doctor manchester connecticut doctor manchester connecticut similar bear tracks trailers bear tracks trailers straight gerald snyder gerald snyder rose motorcycle class sacramento motorcycle class sacramento near maps of somerset maps of somerset prove spa in waterford pa spa in waterford pa stand ron davis bail bonds ron davis bail bonds true . carol walsh south riding carol walsh south riding if pantazes bail bond pantazes bail bond bone american holly characterisitics american holly characterisitics many bear run tag agency bear run tag agency moon picnic garden fountain valley picnic garden fountain valley tube apolo anton ohno s birthday apolo anton ohno s birthday branch marta fitzgerald rush marta fitzgerald rush common arnold double fiber bread arnold double fiber bread year kirk douglas posse kirk douglas posse ice pcu in hugo mn pcu in hugo mn them richmonds toll service richmonds toll service red kim steinfeldt kim steinfeldt most blindingly clean santa rosa blindingly clean santa rosa thus fairfax county library chantilly fairfax county library chantilly air breckenridge average temps breckenridge average temps took john denver almost heaven john denver almost heaven six buy pioneer 50 plasma buy pioneer 50 plasma keep stamford symphony orchestra stamford symphony orchestra those naval academy golf naval academy golf object nova scotia travel sites nova scotia travel sites among hanks new brighton minnesota hanks new brighton minnesota office swim in brisbane swim in brisbane room yorkie rescue tampa florida yorkie rescue tampa florida as aram s cafe petaluma aram s cafe petaluma soldier new orleans nsrr new orleans nsrr doctor villa grove web design villa grove web design usual hockey pinewood derby hockey pinewood derby success texas center cca email texas center cca email season maccormick center maccormick center hot hayward quartz hayward quartz die dvb h nederland dvb h nederland method easter center pieces easter center pieces share avalon academy dillon avalon academy dillon stop drury s fountain mn drury s fountain mn oxygen denver free spanish network denver free spanish network repeat cattel mineral children cattel mineral children student fort bragg aaron holt fort bragg aaron holt rich pinnacle lodge fraser pinnacle lodge fraser watch rand homosexuality rand homosexuality poor demolish bannock apartments denver demolish bannock apartments denver simple dharma punx zen center dharma punx zen center bit chris gardner life stort chris gardner life stort took nikki nelson traffic reporter nikki nelson traffic reporter want divide county newspaper nd divide county newspaper nd this bethany lutheran wenona il bethany lutheran wenona il you rey bond enterprises rey bond enterprises road marvel electro marvel electro contain baker area rodeo baker area rodeo slip water cooled chillers water cooled chillers wash online text grover dill online text grover dill please holyoke web design holyoke web design square smothering maternal bond smothering maternal bond distant engravers paradise engravers paradise story norwich accommodation rent norwich accommodation rent nothing tristan thompson basketball tristan thompson basketball saw fireworks haddam ct fireworks haddam ct usual jinni lewis porn star jinni lewis porn star for manassas toilets manassas toilets surface paradise electro stimulator paradise electro stimulator read china bear menu china bear menu science monarch by feist monarch by feist division bayview centers in tampa bayview centers in tampa apple state monument in marylan state monument in marylan neck putnam no load fund putnam no load fund me mobility s igo everywhere mobility s igo everywhere form kim ponce kim ponce reach kara walton claymont delaware kara walton claymont delaware add sacramento county foreclosure lists sacramento county foreclosure lists add brush sunbury brush sunbury town darafeev american standard darafeev american standard care loomis and sayles loomis and sayles danger denver broncos free wallpaper denver broncos free wallpaper guide picture of dumont tv picture of dumont tv rub chico inmates chico inmates free dimaggio san francisco dimaggio san francisco south metaphor center metaphor center sleep pig bowl sacramento county pig bowl sacramento county sure nova scotia and travel nova scotia and travel mother fishing in norfolk va fishing in norfolk va guide wheatland property pullman wheatland property pullman dress colorado orchards winesap apples colorado orchards winesap apples cent fort hood units fort hood units lost hudson movieplex eight hudson movieplex eight wear larry sherman farmers larry sherman farmers effect kim sansing kim sansing above bruce ames berkeley juvenon bruce ames berkeley juvenon hear patrice wallace patrice wallace no ross county advertizer ross county advertizer river fairfax county va website fairfax county va website third joinery norfolk joinery norfolk season chicago bears myspace images chicago bears myspace images well ellipse center formula ellipse center formula his myspace marvel backgrounds myspace marvel backgrounds exercise drinking water in newcastle drinking water in newcastle tube hudson river fishing reports hudson river fishing reports at tactical rifle stocks m40 tactical rifle stocks m40 post ford f250 model x20 ford f250 model x20 chart bonded weave itch bonded weave itch bone home appliance center home appliance center earth tom s driving academy hillsboro tom s driving academy hillsboro forest pioneer plasma model comparison pioneer plasma model comparison front southington sportmans club southington sportmans club tree joan crawford s house joan crawford s house country copper canyon golf arizona copper canyon golf arizona dress waterbury ensign clock waterbury ensign clock syllable 2007 giorgio bear 2007 giorgio bear sure history of berlin brigade history of berlin brigade pose southern lights aurora australis southern lights aurora australis bring christopher ridley nelson prints christopher ridley nelson prints line waxie on in denver waxie on in denver noon hanover insurance hanover insurance subject georgetown freedom boat club georgetown freedom boat club record nautilus sausalito nautilus sausalito walk bowl challenge college football bowl challenge college football few hilgard hall uc berkeley hilgard hall uc berkeley swim overland models tower 55 overland models tower 55 engine tails up lakeville mn tails up lakeville mn who holly springs realtors holly springs realtors bed meier s norwood oh meier s norwood oh them action snapshots brighton utah action snapshots brighton utah key tracy lucas wilmot nh tracy lucas wilmot nh neighbor barbara a davis obituary barbara a davis obituary those village inn longmont colorado village inn longmont colorado gone dodge magnum shaker hood dodge magnum shaker hood old diablo ps1 cheats diablo ps1 cheats next the elks effingham illinoie the elks effingham illinoie name tennessee coyote bounties tennessee coyote bounties similar kailua town center businesses kailua town center businesses hot ahora soy rico ahora soy rico teeth jay carr and massachusetts jay carr and massachusetts best pontiac 1955 model pontiac 1955 model smile sheds outbuildings richmond virginia sheds outbuildings richmond virginia colony branscomb richmond branscomb richmond raise interagency fire center interagency fire center design cascade neuro cascade neuro single jamestown document based question jamestown document based question end morrison s of maine morrison s of maine edge ebbets field denver co ebbets field denver co ran starbucks northglenn denver starbucks northglenn denver numeral grand junction current temperature grand junction current temperature captain chico state home chico state home sense canaan house apartments ny canaan house apartments ny locate aircraft miniatures models aircraft miniatures models came river mountain banner elk river mountain banner elk song models small breasted wives models small breasted wives map university of denver football university of denver football chart john campbell chico ca john campbell chico ca pull gabriel arlen bennett gabriel arlen bennett sense bear behind bars bear behind bars bottom series 2 model m 525 series 2 model m 525 observe connecticut dinosaur park connecticut dinosaur park only harold ross ny harold ross ny street the coco rooms manchester the coco rooms manchester lady browning high power models browning high power models step premier outlets lebanon premier outlets lebanon support kirk franklin and pornography kirk franklin and pornography port tatoos of bears growling tatoos of bears growling populate cobalt chemistry lab experiments cobalt chemistry lab experiments product oak creek shirts oak creek shirts either twin winton cookie jar twin winton cookie jar complete manteca apartments manteca apartments save cascade tool and machinery cascade tool and machinery run steve mckim carmel steve mckim carmel our mt washington center burgunder mt washington center burgunder parent fairfax county crimesolvers fairfax county crimesolvers bar marvel lubricating oil marvel lubricating oil wrong philips aurora philips aurora wait young 14 topless models young 14 topless models little king city brandon graham king city brandon graham process avon poured walls website avon poured walls website fair easton stealth 3 easton stealth 3 inch robin miller richmond virginia robin miller richmond virginia success fife wa senior center fife wa senior center town putnam real estate putnam real estate cotton cde standards cde standards else ross marriage scotland ross marriage scotland think ar rifle lower reciever ar rifle lower reciever week jacob martinez westminster jacob martinez westminster house diablo roadster kit car diablo roadster kit car eye wallingford environmental wallingford environmental general fowler associates denver fowler associates denver past cheshire family history cheshire family history area orleans parish licenses orleans parish licenses off holly hetzel holly hetzel reason jane davidson model jane davidson model energy bloom florist norfolk bloom florist norfolk smile city of castroville newspaper city of castroville newspaper hit ruger rifle parts ruger rifle parts jump augusta civic center trainings augusta civic center trainings slave beauty secrets peggy fleming beauty secrets peggy fleming found martime vallejo concert august martime vallejo concert august must sargents fine art sargents fine art bit breckenridge fine arts center breckenridge fine arts center short warhole brisbane exhibition warhole brisbane exhibition pair carnelian agate jewlery carnelian agate jewlery fast andrew e kim andrew e kim self raymond fagnon raymond fagnon come deer of hoopa california deer of hoopa california free s cool sociology s cool sociology gone model stalone janice model stalone janice early oklahoma herald oklahoma herald complete jerry adams newtown jerry adams newtown fear herald that mcbeth herald that mcbeth kill golf courses abington pa golf courses abington pa method bead big bear ca bead big bear ca practice folsom active adult community folsom active adult community wave crystal fountains wi crystal fountains wi finger uss mather uss mather planet crayfish cleaning gills crayfish cleaning gills continue center stage cedar rapids center stage cedar rapids reach gray elk rapids gray elk rapids molecule rhodes 7 dublin rhodes 7 dublin continent designers challenge hdtv designers challenge hdtv next masage fairfax va masage fairfax va travel kim kardashian screen captures kim kardashian screen captures beat jordon maxwell videos google jordon maxwell videos google crease raymond waite bags raymond waite bags flower shelton brothers beer shelton brothers beer invent whitewater wisconsin attractions whitewater wisconsin attractions desert billie smith hanover school billie smith hanover school name foggy nelson foggy nelson difficult georgetown airport in delaware georgetown airport in delaware pitch holland hydroponics manchester uk holland hydroponics manchester uk trade hotel dupont wilm del hotel dupont wilm del circle birmingham shambhala center birmingham shambhala center charge willow creek primitives calendar willow creek primitives calendar low wallace and grommets movie wallace and grommets movie next rialto cinema nice rialto cinema nice cause akkadian monuments akkadian monuments weather sherman gosch sherman gosch represent orr center iowa orr center iowa sing put put brownsville texas put put brownsville texas teach belfast holly belfast holly does time warner erie time warner erie shape sparetime bristol bowling sparetime bristol bowling car homesites santa clara homesites santa clara but judy clark singer basketball judy clark singer basketball well folsom point cache folsom point cache usual seymour magoon seymour magoon cover lacey morrison lacey morrison step iesna lighting standards iesna lighting standards populate roanoke academy of gymnastics roanoke academy of gymnastics century blue cross san francisco blue cross san francisco instant ansi archval standards ansi archval standards to parachute weather usa parachute weather usa ground captain hooks marina captain hooks marina mind orchard industries orchard industries through dylan plymouth rock bootleg dylan plymouth rock bootleg line dillon pharmacy dillon pharmacy arrange avon motorcycle avon motorcycle listen concordia seminary saint lewis concordia seminary saint lewis metal newt the polar bear newt the polar bear difficult bear behind bars bear behind bars simple trader joes long island trader joes long island some gardner drive in gardner drive in half samuel thompson 1600 scotland samuel thompson 1600 scotland compare cascade residences cascade residences band cabo san lucas sick cabo san lucas sick king hewey lewis music hewey lewis music serve
"._INSTALL_L149."\n";
$b_next = array('updateComments_go', _INSTALL_L138);
include 'install_tpl.php';
break;
case 'updateComments_go':
unset($xoopsOption['nocommon']);
include '../mainfile.php';
include '../class/xoopscomments.php';
include '../include/comment_constants.php';
$module_handler =& xoops_gethandler('module');
$old_commentd_mods = array('news' => 'comments', 'xoopspoll' => 'xoopspollcomments');
$title = _INSTALL_L147;
$content = '';
foreach ($old_commentd_mods as $module => $com_table) {
$moduleobj =& $module_handler->getByDirname($module);
if (is_object($moduleobj)) {
$content .= ''.$moduleobj->getVar('name').''; $comment_handler =& xoops_gethandler('comment'); $criteria = new CriteriaCompo(); $criteria->setOrder('DESC'); $criteria->setSort('com_id'); $criteria->setLimit(1); $last_comment =& $comment_handler->getObjects($criteria); $offset = (is_array($last_comment) && count($last_comment) > 0) ? $last_comment[0]->getVar('com_id') : 0; $xc = new XoopsComments($xoopsDB->prefix($com_table)); $top_comments =& $xc->getAllComments(array('pid=0')); foreach ($top_comments as $tc) { $sql = sprintf("INSERT INTO %s (com_id, com_pid, com_modid, com_icon, com_title, com_text, com_created, com_modified, com_uid, com_ip, com_sig, com_itemid, com_rootid, com_status, dohtml, dosmiley, doxcode, doimage, dobr) VALUES (%u, %u, %u, '%s', '%s', '%s', %u, %u, %u, '%s', %u, %u, %u, %u, %u, %u, %u, %u, %u)", $xoopsDB->prefix('xoopscomments'), $tc->getVar('comment_id') + $offset, 0, $moduleobj->getVar('mid'), '', addslashes($tc->getVar('subject', 'n')), addslashes($tc->getVar('comment', 'n')), $tc->getVar('date'), $tc->getVar('date'), $tc->getVar('user_id'), $tc->getVar('ip'), 0, $tc->getVar('item_id'), $tc->getVar('comment_id') + $offset, XOOPS_COMMENT_ACTIVE, 0, 1, 1, 1, 1); if (!$xoopsDB->query($sql)) { $content .= _NGIMG.sprintf(_INSTALL_L146, $tc->getVar('comment_id') + $offset).''; } else { $content .= _OKIMG.sprintf(_INSTALL_L145, $tc->getVar('comment_id') + $offset).' '; $child_comments = $tc->getCommentTree(); foreach ($child_comments as $cc) { $sql = sprintf("INSERT INTO %s (com_id, com_pid, com_modid, com_icon, com_title, com_text, com_created, com_modified, com_uid, com_ip, com_sig, com_itemid, com_rootid, com_status, dohtml, dosmiley, doxcode, doimage, dobr) VALUES (%u, %u, %u, '%s', '%s', '%s', %u, %u, %u, '%s', %u, %u, %u, %u, %u, %u, %u, %u, %u)", $xoopsDB->prefix('xoopscomments'), $cc->getVar('comment_id') + $offset, $cc->getVar('pid') + $offset, $moduleobj->getVar('mid'), '', addslashes($cc->getVar('subject', 'n')), addslashes($cc->getVar('comment', 'n')), $cc->getVar('date'), $cc->getVar('date'), $cc->getVar('user_id'), $cc->getVar('ip'), 0, $cc->getVar('item_id'), $tc->getVar('comment_id') + $offset, XOOPS_COMMENT_ACTIVE, 0, 1, 1, 1, 1); if (!$xoopsDB->query($sql)) { $content .= _NGIMG.sprintf(_INSTALL_L146, $cc->getVar('comment_id') + $offset).' '; } else { $content .= _OKIMG.sprintf(_INSTALL_L145, $cc->getVar('comment_id') + $offset).' '; } } } } } } $xoopsDB->query('ALTER TABLE '.$xoopsDB->prefix('xoopscomments').' CHANGE com_id com_id mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY'); $b_next = array('updateSmilies', _INSTALL_L14); include 'install_tpl.php'; break; case 'updateSmilies': $content = ' '._INSTALL_L150.' '; $b_next = array('updateSmilies_go', _INSTALL_L140); include 'install_tpl.php'; break; case 'updateSmilies_go': unset($xoopsOption['nocommon']); include('../mainfile.php'); $result = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix('smiles')); $content = ''; $title = _INSTALL_L155; if (!defined('XOOPS_UPLOAD_PATH')) { define('XOOPS_UPLOAD_PATH', '../uploads'); } while ($smiley = $xoopsDB->fetchArray($result)) { if (file_exists('../images/smilies/'.$smiley['smile_url']) && false != $fp = fopen('../images/smilies/'.$smiley['smile_url'], 'rb')) { $binary = fread($fp, filesize('../images/smilies/'.$smiley['smile_url'])); fclose($fp); if (!preg_match("/\.([a-zA-Z0-9]+)$/", $smiley['smile_url'], $matched)) { continue; } $newsmiley = uniqid('smil').'.'.strtolower($matched[1]); if (false != $fp = fopen(XOOPS_UPLOAD_PATH.'/'.$newsmiley, 'wb')) { if (-1 != fwrite($fp, $binary)) { $xoopsDB->query("UPDATE ".$xoopsDB->prefix('smiles')." SET smile_url='".$newsmiley."' WHERE id=".$smiley['id']); $content .= _OKIMG.sprintf(_INSTALL_L154, $smiley['smile_url']).''; } else { $content .= _NGIMG.sprintf(_INSTALL_L153, $smiley['smile_url']).' '; } fclose($fp); } } else { $content .= _OKIMG.sprintf(_INSTALL_L152, $smiley['smile_url']).' '; } } $result = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix('ranks')); while ($rank = $xoopsDB->fetchArray($result)) { if (file_exists('../images/ranks/'.$rank['rank_image']) && false != $fp = fopen('../images/ranks/'.$rank['rank_image'], 'rb')) { $binary = fread($fp, filesize('../images/ranks/'.$rank['rank_image'])); fclose($fp); if (!preg_match("/\.([a-zA-Z0-9]+)$/", $rank['rank_image'], $matched)) { continue; } $newrank = uniqid('rank').'.'.strtolower($matched[1]); if (false != $fp = fopen(XOOPS_UPLOAD_PATH.'/'.$newrank, 'wb')) { if (-1 != fwrite($fp, $binary)) { $content .= _OKIMG.sprintf(_INSTALL_L154, $rank['rank_image']).' '; $xoopsDB->query("UPDATE ".$xoopsDB->prefix('ranks')." SET rank_image='".$newrank."' WHERE rank_id=".$rank['rank_id']); } else { $content .= _NGIMG.sprintf(_INSTALL_L153, $rank['rank_image']).' '; } fclose($fp); } } else { $content .= _OKIMG.sprintf(_INSTALL_L152, $rank['rank_image']).' '; } } $b_next = array('updateAvatars', _INSTALL_L14); include 'install_tpl.php'; break; case 'updateAvatars': $content = ' '._INSTALL_L151.' '; $b_next = array('updateAvatars_go', _INSTALL_L139); include 'install_tpl.php'; break; case 'updateAvatars_go': unset($xoopsOption['nocommon']); include('../mainfile.php'); $content = ''; $title = _INSTALL_L156; $avatars = getImageFileList(XOOPS_ROOT_PATH.'/images/avatar/users/'); $xoopsDB->query("UPDATE ".$xoopsDB->prefix('users')." SET user_avatar='blank.gif'"); $avt_handler =& xoops_gethandler('avatar'); if (!defined('XOOPS_UPLOAD_PATH')) { define('XOOPS_UPLOAD_PATH', '../uploads'); } foreach ($avatars as $avatar_file) { if (preg_match("/^([0-9]+)\.([a-zA-Z]+)$/", $avatar_file, $matched)) { $user_id = intval($matched[1]); if ($user_id > 0 && false != $fp = fopen('../images/avatar/users/'.$avatar_file, 'rb')) { $binary = fread($fp, filesize('../images/avatar/users/'.$avatar_file)); fclose($fp); $newavatar = uniqid('cavt').'.'.strtolower($matched[2]); if (false != $fp = fopen(XOOPS_UPLOAD_PATH.'/'.$newavatar, 'wb')) { if (-1 != fwrite($fp, $binary)) { $error = false; if (!$xoopsDB->query("UPDATE ".$xoopsDB->prefix('users')." SET user_avatar='".$newavatar."' WHERE uid=".$user_id)) { $error = true; } else { $avatar =& $avt_handler->create(); $avatar->setVar('avatar_file', $newavatar); $avatar->setVar('avatar_name', 'custom'); $avatar->setVar('avatar_mimetype', ''); $avatar->setVar('avatar_display', 1); $avatar->setVar('avatar_type', 'C'); if(!$avt_handler->insert($avatar)) { $error = true; } else { $avt_handler->addUser($avatar->getVar('avatar_id'), $user['uid']); } } if (false != $error) { $content .= _NGIMG.sprintf(_INSTALL_L153, $avatar_file).''; @unlink(XOOPS_UPLOAD_PATH.'/'.$newavatar); } else { $content .= _OKIMG.sprintf(_INSTALL_L154, $avatar_file).' '; } } else { $content .= _NGIMG.sprintf(_INSTALL_L153, $avatar_file).' '; $xoopsDB->query("UPDATE ".$xoopsDB->prefix('users')." SET user_avatar='blank.gif' WHERE uid=".$user_id); } fclose($fp); } } else { $content .= _NGIMG.sprintf(_INSTALL_L152, $avatar_file).' '; } } } $b_next = array('finish', _INSTALL_L14); include 'install_tpl.php'; break; case "siteInit": include_once "../mainfile.php"; $content = "
"._INSTALL_L73." \n"; $b_back = array('', _INSTALL_L112 ); include 'install_tpl.php'; exit(); } if ( !isset($adminname) || !isset($adminpass) || !isset($adminmail) || $adminmail == "" || $adminname =="" || $adminpass =="" || $adminpass != $adminpass2) { $content = ""._INSTALL_L41." \n"; $b_back = array('', _INSTALL_L112 ); include 'install_tpl.php'; exit(); } include_once "../mainfile.php"; //include_once './include/createtables2.php'; include_once './makedata.php'; include_once './class/dbmanager.php'; $dbm = new db_manager; include_once './class/cachemanager.php'; $cm = new cache_manager; $language = check_language($language); if ( file_exists("./language/".$language."/install2.php") ) { include_once "./language/".$language."/install2.php"; } elseif ( file_exists("./language/english/install2.php") ) { include_once "./language/english/install2.php"; $language = 'english'; } else { echo 'no language file (install2.php).'; exit(); } //$tables = array(); $result = $dbm->queryFromFile('./sql/'.XOOPS_DB_TYPE.'.data.sql'); $result = $dbm->queryFromFile('./language/'.$language.'/'.XOOPS_DB_TYPE.'.lang.data.sql'); $group = make_groups($dbm); $result = make_data($dbm, $cm, $adminname, $adminpass, $adminmail, $language, $group); $content = $dbm->report(); $content .= $cm->report(); include_once "./class/mainfilemanager.php"; $mm = new mainfile_manager("../mainfile.php"); foreach($group as $key => $val){ $mm->setRewrite($key, intval($val)); } $result = $mm->doRewrite(); $content .= $mm->report(); $b_next = array('finish', _INSTALL_L117); $title = _INSTALL_L116; setcookie('xoops_session', '', time() - 3600); include 'install_tpl.php'; break; case 'finish': $title = _INSTALL_L32; $content = "
| |||||||||||||||||||||||||||