data.php | searchcode

/01.Source/01.CORE/admincp/modules/language/data.php

http://creative-portal.googlecode.com/
PHP | 247 lines | 221 code | 19 blank | 7 comment | 27 complexity | 7d722749f4f85e5689629171b43e1eb7 MD5 | raw file
Possible License(s): BSD-3-Clause

<?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 );

    

    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

    {

        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'] = "";

            

            require_once ( NV_ROOTDIR . "/" . NV_ADMINDIR . "/modules/modules/functions.php" );

            

            $array_module_setup = explode( ",", NV_MODULE_SETUP_DEFAULT );

            foreach ( $array_module_setup as $setmodule )

            {

                $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 = $keylang;

            $lang_data = $keylang;

            if ( ! file_exists( NV_ROOTDIR . "/install/data_" . $keylang . ".php" ) )

            {

                $filesavedata = "en";

            }

            include_once ( NV_ROOTDIR . "/install/data_" . $filesavedata . ".php" );

            if ( ! file_exists( NV_ROOTDIR . "/install/data_" . $lang_data . ".php" ) )

            {

                $filesavedata = "en";

            }

            include_once ( NV_ROOTDIR . "/install/data_" . $filesavedata . ".php" );

            foreach ( $sql_create_table as $query )

            {

                if ( ! $db->sql_query( $query ) )

                {

                    die( $query );

                }

            }

            

            $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" );

        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();

    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 .= "  </thead>\n";

$contents .= "  </tr>";

$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 . "&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 . "&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" );



?>