<?
/* K-Rate
(C) Rinalds Uzkalns, 2003-2004. All Rights Reserved
http://turn-k.net

Version: 1.00 (22.09.04)
*/
?>
 <?
//delete function
        function delete_record($id) {
                global $en;
                $en['deleted_language'] = true;
                }

//save function
        function save_data() {
                global $en, $langtable;
            //change default language
                foreach ($_POST['edit'] as $id => $arr)
                        if ($arr['l_default'] == 1) {
                                sql_query("UPDATE $langtable SET l_default=0");
                                sql_query("UPDATE $langtable SET l_default=1 WHERE l_id=$id");
                                }
                }

//set default sorting variables
if (!$en['sort1']) {
        $en['sort1'] = 'l_active';
        $en['type1'] = 'DESC';
        $en['sort2'] = 'l_name';
        $en['type2'] = 'ASC';
        $en['show_0'] = 'ON';
        $en['show_1'] = 'ON';
        $en['per_page'] = 20;
        }

//set operating table
        $table = $langtable;

//define main fields
        $rid =   'l_id';       //index field
        $status ='l_active';   //status field

//status field values
        $statfield = array('Inactive', 'Active');

//editable fields
        $editable = array('l_abbr','l_name',$status,'l_default');
        $evals = array('l_file' => 'echo " <a href=\"index.php?req=file_edit&id=languages/".$line[l_file]."\">$line[l_file]</a>";',
                       'l_admin_file' => 'echo " <a href=\"index.php?req=file_edit&id=languages/admin/".$line[l_admin_file]."\">$line[l_admin_file]</a>";'
                        );

//file upload methods
        $upload = array('l_file' => array('dir' => '../languages','method' => 'upload_just_move("l_file")'),
                  'l_admin_file' => array('dir' => '../languages/admin','method' => 'upload_just_move("l_admin_file")'),
                        );

//other tables will be joined?
        //$joins = "LEFT JOIN $catstable ON $linktable.l_cat=$catstable.c_id LEFT JOIN $membtable ON $linktable.l_member=$membtable.m_id LEFT JOIN $admtable ON $linktable.l_approvedby=$admtable.a_id";
        $joins = '';

//other important data...
        $subj = 'Languages';
        $SUBJ = 'Language';
        $_req = 'lang';

//fields to be used in searching/sorting
        $srcfields = array('l_id','l_code','l_abbr','l_name','l_active');

//code to evaluate...
        $bottom = '';
        $rightside = '../modules/languages/admin/manage_right_menu.php';
        
//top menu
        $manage_menu = '<b><big><a href="index.php?req=add_lang">Add New Language</a> | <a href="index.php?req=lang_opts">Options</a></big></b><br><br>';

//define includes
        $loop_include = array(); //include at start of each loop
        $topmenu_right = ''; //extra controls at search/sort menu's right side - for example, categories

//options
    //show approve/decline buttons
        $show_approve = false;

//show content, process saving, etc
        include '../kernel/manage_data/show.php';

//language deleted?
        if ($en['deleted_language'])
                upgrade_all_tables();

//check whether default language is set
        $res = sql_query("SELECT * FROM $langtable WHERE l_default=1");
        if (sql_num_rows($res) == 0)
                sql_query("UPDATE $langtable SET l_default=1 WHERE l_active=1 LIMIT 1");

?>