main.php | searchcode

/NukeViet3.2/admin/modules/language/main.php

http://nuke-viet.googlecode.com/
PHP | 297 lines | 257 code | 26 blank | 14 comment | 30 complexity | 292c2949dc8c6842b582a59e83022e07 MD5 | raw file
Possible License(s): BSD-3-Clause, LGPL-2.1, GPL-2.0

<?php

/**
 * @Project NUKEVIET 3.0
 * @Author VINADES.,JSC (contact@vinades.vn)
 * @Copyright (C) 2010 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'];
$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();
    
    $contents = "<br /><br /><br /><p align=\"center\">" . $lang_module['nv_setting_save'] . "</p>";
    $contents .= "<meta http-equiv=\"Refresh\" content=\"1;URL=" . NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=" . $op . "\" />";
    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 );
        $contents_setup = "<br /><br /><center><br /><b>" . $lang_module['nv_data_setup_ok'] . "</b></center>";
        $contents_setup .= "<meta http-equiv=\"Refresh\" content=\"5;URL=" . NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=settings&" . NV_OP_VARIABLE . "=main\" />";
        
        include ( NV_ROOTDIR . "/includes/header.php" );
        echo nv_admin_theme( $contents_setup );
        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_save_file_config_global();
    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();

}

$contents .= "<table summary=\"\" class=\"tab1\">\n";
$contents .= "  <thead>\n";
$contents .= "  <tr>";
$contents .= "      <td>" . $lang_module['nv_lang_key'] . "</td>";
$contents .= "      <td>" . $lang_module['nv_lang_name'] . "</td>";
$contents .= "      <td style=\"width: 120px\">" . $lang_module['nv_lang_slsite'] . "</td>";
$contents .= "      <td></td>";
$contents .= "  </tr>";
$contents .= "  </thead>\n";

$a = 0;
foreach ( $global_config['allow_adminlangs'] as $keylang )
{
    $delete = "";
    $allow_sitelangs = "";
    if ( isset( $array_lang_setup[$keylang] ) and $array_lang_setup[$keylang] == 1 )
    {
        if ( ! in_array( $keylang, $global_config['allow_sitelangs'] ) )
        {
            $setup = "<span class=\"delete_icon\"><a onclick=\"return confirm(nv_is_del_confirm[0])\" href=\"" . NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&amp;" . NV_OP_VARIABLE . "=" . $op . "&amp;deletekeylang=" . $keylang . "&amp;checksess=" . md5( $keylang . session_id() . "deletekeylang" ) . "\">" . $lang_module['nv_setup_delete'] . "</a></span>";
        }
        else
        {
            $setup = $lang_module['nv_setup'];
        }
        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\"";
            }
            
            $allow_sitelangs = "<select onchange=\"top.location.href=this.options[this.selectedIndex].value;return;\">
                        <option " . $selected_yes . " value=\"" . NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&amp;" . NV_OP_VARIABLE . "=" . $op . "&amp;keylang=" . $keylang . "&amp;activelang=1&amp;checksess=" . md5( "activelang_" . $keylang . session_id() ) . "\">" . $lang_global['yes'] . "</option>
                        <option " . $selected_no . " value=\"" . NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&amp;" . NV_OP_VARIABLE . "=" . $op . "&amp;keylang=" . $keylang . "&amp;activelang=0&amp;checksess=" . md5( "activelang_" . $keylang . session_id() ) . "\">" . $lang_global['no'] . "</option>
                      </select>";
        }
        else
        {
            $allow_sitelangs = $lang_module['site_lang'];
        }
    }
    else
    {
        $setup = "<span class=\"default_icon\"><a href=\"" . NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&amp;" . NV_OP_VARIABLE . "=" . $op . "&amp;keylang=" . $keylang . "&amp;checksess=" . md5( $keylang . session_id() ) . "\">" . $lang_module['nv_setup_new'] . "</a></span>";
    }
    $class = ( $a % 2 ) ? " class=\"second\"" : "";
    $contents .= "<tbody" . $class . ">\n";
    $contents .= "  <tr>";
    $contents .= "      <td>" . $keylang . "</td>";
    $contents .= "      <td>" . $language_array[$keylang]['name'] . "</td>";
    $contents .= "      <td style=\"text-align: center;\">" . $allow_sitelangs . "</td>";
    $contents .= "      <td>" . $setup . "</td>";
    $contents .= "  </tr>";
    $contents .= "  </tbody>\n";
    $a ++;
}
$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";

include ( NV_ROOTDIR . "/includes/header.php" );
echo nv_admin_theme( $contents );
include ( NV_ROOTDIR . "/includes/footer.php" );

?>