/nukeviet/admin/modules/language/main.php
PHP | 332 lines | 254 code | 64 blank | 14 comment | 26 complexity | 47ec3d45bb1c4cd1f20a265f235942cd MD5 | raw file
Possible License(s): BSD-3-Clause, LGPL-2.1, GPL-2.0
- <?php
- /**
- * @Project NUKEVIET 3.x
- * @Author VINADES.,JSC (contact@vinades.vn)
- * @Copyright (C) 2012 VINADES.,JSC. All rights reserved
- * @Createdate 2-2-2010 12:55
- */
- if( ! defined( 'NV_IS_FILE_LANG' ) ) die( 'Stop!!!' );
- $page_title = $lang_module['nv_lang_data'];
- $xtpl = new XTemplate( "main.tpl", NV_ROOTDIR . "/themes/" . $global_config['module_theme'] . "/modules/" . $module_file );
- $xtpl->assign( 'LANG', $lang_module );
- $xtpl->assign( 'GLANG', $lang_global );
- $sql = "SELECT `lang`, `setup` FROM `" . $db_config['prefix'] . "_setup_language`";
- $result = $db->sql_query( $sql );
- $array_lang_setup = array();
- while( $row = $db->sql_fetchrow( $result ) )
- {
- $array_lang_setup[$row['lang']] = intval( $row['setup'] );
- }
- $checksess = filter_text_input( 'checksess', 'get', '' );
- $keylang = filter_text_input( 'keylang', 'get', '', 1, 2 );
- $deletekeylang = filter_text_input( 'deletekeylang', 'get', '', 1, 2 );
- if( $nv_Request->isset_request( 'activelang', 'get' ) and $checksess == md5( "activelang_" . $keylang . session_id() ) )
- {
- $activelang = $nv_Request->get_int( 'activelang', 'get', 0 );
- $allow_sitelangs = $global_config['allow_sitelangs'];
-
- if( $activelang )
- {
- $allow_sitelangs[] = $keylang;
- }
- elseif( $keylang != $global_config['site_lang'] )
- {
- $allow_sitelangs = array_diff( $allow_sitelangs, array( $keylang ) );
- }
-
- $allow_sitelangs = array_unique( $allow_sitelangs );
- $query = "UPDATE `" . NV_CONFIG_GLOBALTABLE . "` SET `config_value` = " . $db->dbescape( implode( ",", $allow_sitelangs ) ) . " WHERE `lang`='sys' AND `module` = 'global' AND `config_name` = 'allow_sitelangs'";
- $result = $db->sql_query( $query );
- $temp = ( $activelang == 1 ) ? $lang_global['yes'] : $lang_global['no'];
- nv_insert_logs( NV_LANG_DATA, $module_name, $lang_module['nv_lang_slsite'], " langkey : " . $keylang . " [ " . $temp . " ]", $admin_info['userid'] );
- nv_save_file_config_global();
- $xtpl->assign( 'URL', NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op );
- $xtpl->parse( 'activelang' );
- $contents = $xtpl->text( 'activelang' );
-
- include ( NV_ROOTDIR . "/includes/header.php" );
- echo nv_admin_theme( $contents );
- include ( NV_ROOTDIR . "/includes/footer.php" );
- exit();
- }
- elseif( $checksess == md5( $keylang . session_id() ) and in_array( $keylang, $global_config['allow_adminlangs'] ) )
- {
- if( isset( $array_lang_setup[$keylang] ) and $array_lang_setup[$keylang] == 1 )
- {
- info_die( $lang_module['nv_data_setup'] );
- }
- else
- {
- nv_insert_logs( NV_LANG_DATA, $module_name, $lang_module['nv_setup_new'] . " " . $lang_module['nv_lang_data'], " langkey : " . $keylang, $admin_info['userid'] );
-
- list( $site_theme ) = $db->sql_fetchrow( $db->sql_query( "SELECT `config_value` FROM `" . NV_CONFIG_GLOBALTABLE . "` where `lang`='" . $global_config['site_lang'] . "' AND `module`='global' AND `config_name`='site_theme'" ) );
-
- $global_config['site_theme'] = $site_theme;
-
- require_once ( NV_ROOTDIR . '/includes/sqldata.php' );
-
- $sql_create_table = nv_create_table_sys( $keylang );
-
- foreach( $sql_create_table as $query )
- {
- $db->sql_query( $query );
- }
-
- $db->sql_query( "REPLACE INTO `" . $db_config['prefix'] . "_setup_language` (`lang`, `setup`) VALUES ('" . $keylang . "', '1')" );
- $db->sql_query( "UPDATE `" . $db_config['prefix'] . "_" . $keylang . "_modules` SET `act` = '0'" );
- if( defined( 'NV_MODULE_SETUP_DEFAULT' ) )
- {
- $lang_module['modules'] = "";
- $lang_module['vmodule_add'] = "";
- $lang_module['blocks'] = "";
- $lang_module['autoinstall'] = "";
- $lang_global['mod_modules'] = "";
-
- $module_name = "modules";
- require_once ( NV_ROOTDIR . "/" . NV_ADMINDIR . "/modules/modules/functions.php" );
- $module_name = "";
-
- $array_module_setup = explode( ",", NV_MODULE_SETUP_DEFAULT );
- $modules_exit = nv_scandir( NV_ROOTDIR . "/modules", $global_config['check_module'] );
- $modules_exit[] = 'global';
- foreach( $array_module_setup as $setmodule )
- {
- if( in_array( $setmodule, $modules_exit ) )
- {
- $sm = nv_setup_data_module( $keylang, $setmodule );
- if( $sm == "OK_" . $setmodule )
- {
- $db->sql_query( "UPDATE `" . $db_config['prefix'] . "_" . $keylang . "_modules` SET `act` = '1'WHERE `title`='" . $setmodule . "'" );
- }
- }
- }
- $db->sql_query( "DELETE FROM `" . $db_config['prefix'] . "_" . $keylang . "_modules` WHERE `act` = '0'" );
- //cai dat du lieu mau
- $filesavedata = "";
- $lang_data = $keylang;
- if( file_exists( NV_ROOTDIR . "/install/data_" . $keylang . ".php" ) )
- {
- $filesavedata = $keylang;
- }
- elseif( file_exists( NV_ROOTDIR . "/install/data_en.php" ) )
- {
- $filesavedata = "en";
- }
- if( ! empty( $filesavedata ) )
- {
- $sql_create_table = array();
- include_once ( NV_ROOTDIR . "/install/data_" . $filesavedata . ".php" );
- foreach( $sql_create_table as $query )
- {
- if( ! $db->sql_query( $query ) )
- {
- include ( NV_ROOTDIR . "/includes/header.php" );
- echo nv_admin_theme( "ERROR SETUP SQL: <br />" . $query );
- include ( NV_ROOTDIR . "/includes/footer.php" );
- exit();
- }
- }
- //xoa du lieu tai bang nv3_vi_blocks
- $sql = "DELETE FROM `" . $db_config['prefix'] . "_" . $lang_data . "_blocks_weight` WHERE `bid` in (SELECT `bid` FROM `" . $db_config['prefix'] . "_" . $lang_data . "_blocks_groups` WHERE `module` NOT IN ('" . implode( "', '", $modules_exit ) . "'))";
- $db->sql_query( $sql );
- //xoa du lieu tai bang nv3_vi_blocks_groups
- $sql = "DELETE FROM `" . $db_config['prefix'] . "_" . $lang_data . "_blocks_groups` WHERE `module` NOT IN ('" . implode( "', '", $modules_exit ) . "')";
- $db->sql_query( $sql );
- //xoa du lieu tai bang nv3_vi_modthemes
- $sql = "DELETE FROM `" . $db_config['prefix'] . "_" . $lang_data . "_modthemes` WHERE `func_id` in (SELECT `func_id` FROM `" . $db_config['prefix'] . "_" . $lang_data . "_modfuncs` WHERE `in_module` NOT IN ('" . implode( "', '", $modules_exit ) . "'))";
- $db->sql_query( $sql );
- //xoa du lieu tai bang nv3_vi_modfuncs
- $sql = "DELETE FROM `" . $db_config['prefix'] . "_" . $lang_data . "_modfuncs` WHERE `in_module` NOT IN ('" . implode( "', '", $modules_exit ) . "')";
- $db->sql_query( $sql );
- //xoa du lieu tai bang nv3_vi_modules
- $sql = "DELETE FROM `" . $db_config['prefix'] . "_" . $lang_data . "_modules` WHERE `title` NOT IN ('" . implode( "', '", $modules_exit ) . "')";
- $db->sql_query( $sql );
- //xoa du lieu tai bang nv3_setup_modules
- $sql = "DELETE FROM `" . $db_config['prefix'] . "_setup_modules` WHERE `title` NOT IN ('" . implode( "', '", $modules_exit ) . "')";
- $db->sql_query( $sql );
- ///xoa du lieu tai bang nv3_config
- $sql = "DELETE FROM `" . $db_config['prefix'] . "_config` WHERE `lang`=" . $db->dbescape( $lang_data ) . " AND `module` NOT IN ('" . implode( "', '", $modules_exit ) . "')";
- $db->sql_query( $sql );
- $sql = "SELECT * FROM `" . $db_config['prefix'] . "_" . $lang_data . "_modules` WHERE `title`='news'";
- $result = $db->sql_query( $sql );
- if( $db->sql_numrows( $result ) )
- {
- $result = $db->sql_query( "SELECT catid FROM `" . $db_config['prefix'] . "_" . $lang_data . "_news_cat` ORDER BY `order` ASC" );
- while( list( $catid_i ) = $db->sql_fetchrow( $result ) )
- {
- nv_create_table_news( $catid_i );
- }
- $db->sql_freeresult();
- $result = $db->sql_query( "SELECT id, listcatid FROM `" . $db_config['prefix'] . "_" . $lang_data . "_news_rows` ORDER BY `id` ASC" );
- while( list( $id, $listcatid ) = $db->sql_fetchrow( $result ) )
- {
- $arr_catid = explode( ",", $listcatid );
- foreach( $arr_catid as $catid )
- {
- $db->sql_query( "INSERT INTO `" . $db_config['prefix'] . "_" . $lang_data . "_news_" . $catid . "` SELECT * FROM `" . $db_config['prefix'] . "_" . $lang_data . "_news_rows` WHERE `id`=" . $id . "" );
- }
- }
- $db->sql_freeresult();
- }
- }
- }
- $nv_Request->set_Cookie( 'data_lang', $keylang, NV_LIVE_COOKIE_TIME );
- $xtpl->assign( 'URL', NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=settings&" . NV_OP_VARIABLE . "=main" );
- $xtpl->parse( 'contents_setup' );
- $contents = $xtpl->text( 'contents_setup' );
-
- include ( NV_ROOTDIR . "/includes/header.php" );
- echo nv_admin_theme( $contents );
- include ( NV_ROOTDIR . "/includes/footer.php" );
- exit();
- }
- }
- elseif( $checksess == md5( $deletekeylang . session_id() . "deletekeylang" ) and ! in_array( $deletekeylang, $global_config['allow_sitelangs'] ) )
- {
- define( 'NV_IS_FILE_MODULES', true );
- $lang = $deletekeylang;
- $sql = "SELECT `title`, `module_file`, `module_data` FROM `" . $db_config['prefix'] . "_" . $lang . "_modules` ORDER BY `weight` ASC";
- $result_del_module = $db->sql_query( $sql );
- while( list( $title, $module_file, $module_data ) = $db->sql_fetchrow( $result_del_module ) )
- {
- if( file_exists( NV_ROOTDIR . '/modules/' . $module_file . '/action.php' ) )
- {
- $sql_drop_module = array();
-
- include ( NV_ROOTDIR . '/modules/' . $module_file . '/action.php' );
-
- if( ! empty( $sql_drop_module ) )
- {
- foreach( $sql_drop_module as $sql )
- {
- $db->sql_query( $sql );
- }
- }
- }
- }
- require_once ( NV_ROOTDIR . '/includes/sqldata.php' );
- $sql_drop_table = nv_delete_table_sys( $deletekeylang );
- foreach( $sql_drop_table as $query )
- {
- $db->sql_query( $query );
- }
-
- $db->sql_query( "DELETE FROM `" . NV_CONFIG_GLOBALTABLE . "` WHERE `lang` = '" . $deletekeylang . "'" );
- $db->sql_query( "DELETE FROM `" . $db_config['prefix'] . "_setup_language` WHERE `lang` = '" . $deletekeylang . "'" );
- nv_delete_all_cache();
- nv_insert_logs( NV_LANG_DATA, $module_name, $lang_module['nv_setup_delete'], " langkey : " . $deletekeylang, $admin_info['userid'] );
- Header( 'Location: ' . NV_BASE_ADMINURL . 'index.php?' . NV_NAME_VARIABLE . '=' . $module_name . '&' . NV_OP_VARIABLE . '=' . $op . '&' . NV_LANG_VARIABLE . '=' . $global_config['site_lang'] . '&rand=' . nv_genpass() );
- exit();
- }
- $a = 0;
- foreach( $global_config['allow_adminlangs'] as $keylang )
- {
- $delete = "";
- $allow_sitelangs = "";
- $xtpl->assign( 'ROW', array(
- 'class' => ( ++ $a % 2 ) ? " class=\"second\"" : "",
- 'keylang' => $keylang,
- 'name' => $language_array[$keylang]['name'],
- ) );
-
- if( isset( $array_lang_setup[$keylang] ) and $array_lang_setup[$keylang] == 1 )
- {
- if( ! in_array( $keylang, $global_config['allow_sitelangs'] ) )
- {
- $xtpl->assign( 'DELETE', NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op . "&deletekeylang=" . $keylang . "&checksess=" . md5( $keylang . session_id() . "deletekeylang" ) );
-
- $xtpl->parse( 'main.loop.setup_delete' );
- }
- else
- {
- $xtpl->parse( 'main.loop.setup_note' );
- }
-
- if( $keylang != $global_config['site_lang'] )
- {
- $selected_yes = $selected_no = " ";
-
- if( in_array( $keylang, $global_config['allow_sitelangs'] ) )
- {
- $selected_yes = " selected=\"selected\"";
- }
- else
- {
- $selected_no = " selected=\"selected\"";
- }
-
- $xtpl->assign( 'ALLOW_SITELANGS', array(
- 'selected_yes' => $selected_yes,
- 'selected_no' => $selected_no,
- 'url_yes' => NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op . "&keylang=" . $keylang . "&activelang=1&checksess=" . md5( "activelang_" . $keylang . session_id() ),
- 'url_no' => NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op . "&keylang=" . $keylang . "&activelang=0&checksess=" . md5( "activelang_" . $keylang . session_id() )
- ) );
-
- $xtpl->parse( 'main.loop.allow_sitelangs' );
- }
- else
- {
- $xtpl->parse( 'main.loop.allow_sitelangs_note' );
- }
- }
- else
- {
- $xtpl->assign( 'INSTALL', NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op . "&keylang=" . $keylang . "&checksess=" . md5( $keylang . session_id() ) );
-
- $xtpl->parse( 'main.loop.setup_new' );
- }
-
- $xtpl->parse( 'main.loop' );
- }
- $contents .= " </table>\n";
- $contents .= "<div class=\"quote\" style=\"width:97.5%;\">\n";
- $contents .= "<blockquote><span>" . $lang_module['nv_data_note'] . "</span></blockquote>\n";
- $contents .= "</div>\n";
- $contents .= "<div class=\"clear\"></div>\n";
- $xtpl->parse( 'main' );
- $contents = $xtpl->text( 'main' );
- include ( NV_ROOTDIR . "/includes/header.php" );
- echo nv_admin_theme( $contents );
- include ( NV_ROOTDIR . "/includes/footer.php" );
- ?>