';
        //print_r($fields);
        //exit;  
        require_once('templates/grid_table_settings.php');
    }



    function grid_adjust($table) {
        global $db, $table_fields, $table_config, $cfg, $_url;
        
        if($_POST['action']=='adjust') {
            $grid=null;
            foreach($_POST['field'] as $key=>$item) {
                if(in_array($item, $_POST['show'])) {
                    $grid[$item]['show']=1;
                } else {
                    $grid[$item]['show']=0;
                }        
                $grid[$item]['color']=$_POST['color'][$key];                    
            }
            _mysqli_query($db, "REPLACE INTO grid (griAdmin_admId, griTable, griFields) VALUES ('".$_SESSION['admin']['admId']."', '".$_POST['table']."', '".json_encode($grid)."')");
        }        
        
        
        
        
        $r=mysqli_query($db, "SELECT * FROM customFields WHERE cfiTable='$table' ORDER BY cfiSequence ASC");
        
        $grid_data=mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM grid WHERE griTable='$table' AND griAdmin_admId='".$_SESSION['admin']['admId']."'"));
        $grid_data=json_decode($grid_data['griFields'],true);

        $cfields=null;

        while($row=mysqli_fetch_assoc($r)) { 
            $row['type']=$row['cfiType'];    
            $row['title']=$row['cfiTitle@'.$cfg['admin']['language']];              
            $table_fields[table2prefix($table).'#'.$row['cfiName']]=$row;
        }
        
        foreach($table_fields as $key=>$item) {
            if(!$item['title']) $table_fields[$key]['title']=_t($key);
        } 
        
        //$grid_data=(array)json_decode($grid_data['griTable'],true);
        
        foreach((array)$grid_data as $key=>$item) {
            if(!$table_fields[$key]) {
                unset($grid_data[$key]);
            }
        }
        
       
        foreach($table_fields as $key=>$item) {
            if(!$grid_data[$key]) {
                $grid_data[$key]=array('show'=>0, 'color'=>'');
            }                                    
        }
     







        

        require_once('_backend/templates/header.php');
        print_header();
        require_once('_backend/templates/grid_adjust.php');

        require_once('_backend/templates/footer.php');
    }

    function grid_structure($table) {
        global $db, $table_fields, $table_config, $cfg, $_url; 
        perm_check_exit($table, 'structure');
        
        $params=array('cfiLength', 'cfiSize', 'cfiRelationToTable', 'cfiRelationField', 'cfiOptions', 'cfiValues', 'cfiLabels', 'cfiEditor', 'cfiHeight', 'cfiFields', 'cfiModuleAction', 'cfiColor', 'cfiFormula', 'cfiModule', 'cfiLink', 'cfiDisabledOnNew', 'cfiScript');    
        $table_info=mysqli_fetch_assoc(mysqli_query($db, "SELECT * FROM tables WHERE tabName='".$table."'"));
        $table_info['tabDefaultShowFields']=json_decode($table_info['tabDefaultShowFields']);

        if($_POST['action']=='cfi_add' || $_POST['action']=='cfi_save') {
            //ALTER TABLE `tables` CHANGE `tabStatus` `tabStatuses` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
            
            $paramTable='';
            foreach($_POST as $key=>$item) {
                if(in_array($key, $params)) {

                    $paramTable[strtolower(substr($key,3))]=$item;
                }  
            }              

            
            if(!$_POST['cfiLanguage']) $_POST['cfiLanguage']=0;
            if($_POST['action']=='cfi_save') {
                $current_cfi=mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM customFields WHERE cfiId='$_POST[id]'"));
                _mysqli_query($db, "UPDATE customFields SET cfiArrayField='' WHERE cfiArrayField='".$_POST['cfiName']."'");
                $sql="UPDATE customFields SET cfiName='$_POST[cfiName]', ";              
                foreach($cfg['languages'] as $key=>$item) {
                    $sql.='`cfiTitle@'.$key."`='".$_POST['cfiTitle@'.$key]."', ";
                } 
                $sql.="cfiType='".$_POST['cfiType']."', cfiParameters='".addslashes(json_encode($paramTable))."', cfiLanguage='".$_POST['cfiLanguage']."' WHERE cfiId='".$_POST['id']."'";
                //echo $sql;
                //exit;
                _mysqli_query($db, $sql);
                
            } else { 
                $lastSequence=mysqli_fetch_assoc(_mysqli_query($db, "SELECT cfiSequence FROM customFields WHERE cfiTable='$table' ORDER BY cfiSequence DESC"));
                _mysqli_query($db, "INSERT INTO customFields (cfiTable, cfiName, `cfiTitle@pl`, `cfiTitle@en`, cfiType, cfiDefaultValue, cfiParameters, cfiLanguage, cfiSequence) VALUES ('$table', '$_POST[cfiName]', '".$_POST['cfiTitle@pl']."', '".$_POST['cfiTitle@en']."', '$_POST[cfiType]', '', '".addslashes(json_encode($paramTable))."', '$_POST[cfiLanguage]', '".($lastSequence['cfiSequence']+1)."')");
                
            }

            if($_POST['cfiType']=='array_fields') {
                foreach((array)$_POST['cfiFields'] as $key=>$item) {
                    _mysqli_query($db, "UPDATE customFields SET cfiArrayField='".$_POST['cfiName']."' WHERE cfiName='".$item."' AND cfiTable='$table'");
                }
            }
            

            
            $default=" DEFAULT '' NOT NULL";
            switch(strtolower($_POST['cfiType'])) {
                case 'text': 
                    if($_POST['cfiLength']) $length=$_POST['cfiLength']; else $length=255;
                    $mysql_type='VARCHAR('.$length.')';
                break;
                case 'date':
                    $default='';
                    $mysql_type='DATE';                    
                break;
                case 'datetime':
                    $default='';
                    $mysql_type='DATETIME';                    
                break;
                case 'time':
                    $default='';
                    $mysql_type='TIME';                    
                break;
                case 'int':
                    $default='';
                    $mysql_type='INT(11)';
                break;  
                case 'float':
                    $default='';
                    $mysql_type='FLOAT';
                break;
                case 'htmlarea': case 'array_fields':
                    $default='';
                    $mysql_type='TEXT';                
                break;
                                                    
                default: $mysql_type='VARCHAR(255)'; 
            }            
            
            //echo $mysql_type;
            //exit;
            
            if($_POST['action']=='cfi_add' || ($_POST['action']=='cfi_save' && $current_cfi['cfiType']=='tab')) {
                if(strtolower($_POST['cfiType']!='tab')) {
    
                    if($_POST['cfiLanguage']==1) {
                        foreach($cfg['languages'] as $key=>$item) {            
                            _mysqli_query($db, "ALTER TABLE $table ADD `".table2prefix($table).'#'.$_POST['cfiName']."@".$key."` ".$mysql_type.$default  ); 
                        } 
                    } else {
                        _mysqli_query($db, "ALTER TABLE $table ADD `".table2prefix($table).'#'.$_POST['cfiName']."` ".$mysql_type.$default  );           
                    }
                }
            } else {
                //if()
                //echo '
';
                //print_r($_POST);
                //print_r($current_cfi);
                if($current_cfi['cfiType']!='tab' && $_POST['cfiType']=='tab') {
                    if($current_cfi['cfiLanguage']==1) {
                        foreach($cfg['languages'] as $key=>$item) {            
                            _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."@".$key."`" ); 
                        } 
                    } else {
                        _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."`" );           
                    }
                    // sprawdzic GRIDA
                    $grid=mysqli_fetch_assoc(_mysqli_query($db,"SELECT * FROM grid WHERE griTable='".$current_cfi['cfiTable']."'"));
                    $fields=json_decode($grid['griFields'],true);
                    unset($fields[table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']]);
                    //.'#'.$cfi['cfiName']);
                    //echo table2prefix($cfi['cfiTable']);
                    if($_SESSION['sorting'][$current_cfi['cfiTable']]['field']==table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']) {
                        unset($_SESSION['sorting'][$current_cfi['cfiTable']]);
                    }
                    _mysqli_query($db,"UPDATE grid SET griFields='".json_encode($fields)."' WHERE griTable='".$current_cfi['cfiTable']."'");  
                    _mysqli_query($db,"UPDATE customFields SET cfiLanguage='0' WHERE cfiId='".$current_cfi['cfiId']."'");                  
                }
                
                if(!$current_cfi['cfiLanguage'] && !$_POST['cfiLanguage']) {
                    _mysqli_query($db, "ALTER TABLE $table CHANGE `".table2prefix($table).'#'.$current_cfi['cfiName']."` `".table2prefix($table).'#'.$_POST['cfiName']."` ".$mysql_type.$default);
                }
                
                if($current_cfi['cfiLanguage'] && !$_POST['cfiLanguage']) {
                    _mysqli_query($db, "ALTER TABLE $table CHANGE `".table2prefix($table).'#'.$current_cfi['cfiName']."@".$_POST['keepLanguage']."` `".table2prefix($table).'#'.$_POST['cfiName']."` ".$mysql_type.$default);
                    foreach($cfg['languages'] as $key=>$item) {  
                        if($key!=$_POST['keepLanguage']) {          
                            _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."@".$key."`");
                        } 
                    }                     
                }
                
                if(!$current_cfi['cfiLanguage'] && $_POST['cfiLanguage']) {
                    foreach($cfg['languages'] as $key=>$item) {            
                        _mysqli_query($db, "ALTER TABLE $table ADD `".table2prefix($table).'#'.$_POST['cfiName']."@".$key."` ".$mysql_type.$default  );
                        if($_POST['moveLanguage']=='_duplicate' || $key==$_POST['moveLanguage']) {
                            _mysqli_query($db, "UPDATE $table SET `".table2prefix($table).'#'.$_POST['cfiName']."@".$key."`=`".table2prefix($table).'#'.$current_cfi['cfiName']."`");
                        } 
                    }  
                    _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."`");                  
                } 
                
                if(!$_POST['tab'] && ($_POST['cfiName']!=$current_cfi['cfiName'])) {
                    $grid=mysqli_fetch_assoc(_mysqli_query($db,"SELECT * FROM grid WHERE griTable='".$current_cfi['cfiTable']."'"));
                    $fields=json_decode($grid['griFields'],true);
                    $fields[table2prefix($current_cfi['cfiTable']).'#'.$_POST['cfiName']]=$fields[table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']];
                    unset($fields[table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']]);
                    if($_SESSION['sorting'][$current_cfi['cfiTable']]['field']==table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']) {
                        unset($_SESSION['sorting'][$current_cfi['cfiTable']]);
                    }
                    _mysqli_query($db,"UPDATE grid SET griFields='".json_encode($fields)."' WHERE griTable='".$current_cfi['cfiTable']."'");                  
                }
                // waurnek kiedy nie zaklada i inna nazwa niz poprzednio do zmiany w gridzie
                
                
                
                //exit;
            }
            
            
        }        
        
        $r=mysqli_query($db, "SELECT * FROM customFields WHERE cfiTable='$table' ORDER BY cfiSequence ASC");
        $cfields=null;
        while($row=mysqli_fetch_assoc($r)) {
            $tr_class='';
            switch(strtolower($row['cfiType'])) {
                case 'tab': $tr_class='warning'; break;
            }
            $row['tr_class']=$tr_class;
                    
            $cfields[$row['cfiName']]=$row;
        } 

                      
        require_once('_backend/templates/header.php');      
        print_header(); 
        
        require_once('_backend/templates/grid_structure.php');
        require_once('_backend/templates/footer.php');          
    }



    function grid_structure_old($table) {
        global $db, $table_fields, $table_config, $cfg, $_url;    
        perm_check_exit($table, 'structure');
        $params=array('cfiLength', 'cfiSize', 'cfiRelationToTable', 'cfiRelationField', 'cfiOptions', 'cfiValues', 'cfiLabels', 'cfiEditor', 'cfiHeight', 'cfiFields', 'cfiModuleAction', 'cfiColor', 'cfiFormula', 'cfiModule', 'cfiLink', 'cfiDisabledOnNew', 'cfiScript');    

        if($_POST['action']=='cfi_add' || $_POST['action']=='cfi_save') {
            //ALTER TABLE `tables` CHANGE `tabStatus` `tabStatuses` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
            
            $paramTable='';
            foreach($_POST as $key=>$item) {
                if(in_array($key, $params)) {

                    $paramTable[strtolower(substr($key,3))]=$item;
                }  
            }              



            
            if(!$_POST['cfiLanguage']) $_POST['cfiLanguage']=0;
            if($_POST['action']=='cfi_save') {
                $current_cfi=mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM customFields WHERE cfiId='$_POST[id]'"));
                _mysqli_query($db, "UPDATE customFields SET cfiArrayField='' WHERE cfiArrayField='".$_POST['cfiName']."'");
                $sql="UPDATE customFields SET cfiName='$_POST[cfiName]', ";              
                foreach($cfg['languages'] as $key=>$item) {
                    $sql.='`cfiTitle@'.$key."`='".$_POST['cfiTitle@'.$key]."', ";
                } 
                $sql.="cfiType='".$_POST['cfiType']."', cfiParameters='".addslashes(json_encode($paramTable))."', cfiLanguage='".$_POST['cfiLanguage']."' WHERE cfiId='".$_POST['id']."'";
                //echo $sql;
                //exit;
                _mysqli_query($db, $sql);
                
            } else { 
                $lastSequence=mysqli_fetch_assoc(_mysqli_query($db, "SELECT cfiSequence FROM customFields WHERE cfiTable='$table' ORDER BY cfiSequence DESC"));
                _mysqli_query($db, "INSERT INTO customFields (cfiTable, cfiName, `cfiTitle@pl`, `cfiTitle@en`, cfiType, cfiDefaultValue, cfiParameters, cfiLanguage, cfiSequence) VALUES ('$table', '$_POST[cfiName]', '".$_POST['cfiTitle@pl']."', '".$_POST['cfiTitle@en']."', '$_POST[cfiType]', '', '".addslashes(json_encode($paramTable))."', '$_POST[cfiLanguage]', '".($lastSequence['cfiSequence']+1)."')");
                
            }
            //echo '
';
            //print_R($_POST);
            //exit;
            if($_POST['cfiType']=='array_fields') {
                foreach((array)$_POST['cfiFields'] as $key=>$item) {
                    _mysqli_query($db, "UPDATE customFields SET cfiArrayField='".$_POST['cfiName']."' WHERE cfiName='".$item."' AND cfiTable='$table'");
                }
            }
            
            //print_r($current_cfi);
            //exit;
                                 

            
            //if($_POST['action')
            
            $default=" DEFAULT '' NOT NULL";
            switch(strtolower($_POST['cfiType'])) {
                case 'text': 
                    if($_POST['cfiLength']) $length=$_POST['cfiLength']; else $length=255;
                    $mysql_type='VARCHAR('.$length.')';
                break;
                case 'date':
                    $default='';
                    $mysql_type='DATE';                    
                break;
                case 'datetime':
                    $default='';
                    $mysql_type='DATETIME';                    
                break;
                case 'time':
                    $default='';
                    $mysql_type='TIME';                    
                break;
                case 'int':
                    $default='';
                    $mysql_type='INT(11)';
                break;  
                case 'float':
                    $default='';
                    $mysql_type='FLOAT';
                break;
                case 'htmlarea': case 'array_fields':
                    $default='';
                    $mysql_type='TEXT';                
                break;
                                                    
                default: $mysql_type='VARCHAR(255)'; 
            }            
            
            //echo $mysql_type;
            //exit;
            
            if($_POST['action']=='cfi_add' || ($_POST['action']=='cfi_save' && $current_cfi['cfiType']=='tab')) {
                if(strtolower($_POST['cfiType']!='tab')) {
    
                    if($_POST['cfiLanguage']==1) {
                        foreach($cfg['languages'] as $key=>$item) {            
                            _mysqli_query($db, "ALTER TABLE $table ADD `".table2prefix($table).'#'.$_POST['cfiName']."@".$key."` ".$mysql_type.$default  ); 
                        } 
                    } else {
                        _mysqli_query($db, "ALTER TABLE $table ADD `".table2prefix($table).'#'.$_POST['cfiName']."` ".$mysql_type.$default  );           
                    }
                }
            } else {
                //if()
                //echo '
';
                //print_r($_POST);
                //print_r($current_cfi);
                if($current_cfi['cfiType']!='tab' && $_POST['cfiType']=='tab') {
                    if($current_cfi['cfiLanguage']==1) {
                        foreach($cfg['languages'] as $key=>$item) {            
                            _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."@".$key."`" ); 
                        } 
                    } else {
                        _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."`" );           
                    }
                    // sprawdzic GRIDA
                    $grid=mysqli_fetch_assoc(_mysqli_query($db,"SELECT * FROM grid WHERE griTable='".$current_cfi['cfiTable']."'"));
                    $fields=json_decode($grid['griFields'],true);
                    unset($fields[table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']]);
                    //.'#'.$cfi['cfiName']);
                    //echo table2prefix($cfi['cfiTable']);
                    if($_SESSION['sorting'][$current_cfi['cfiTable']]['field']==table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']) {
                        unset($_SESSION['sorting'][$current_cfi['cfiTable']]);
                    }
                    _mysqli_query($db,"UPDATE grid SET griFields='".json_encode($fields)."' WHERE griTable='".$current_cfi['cfiTable']."'");  
                    _mysqli_query($db,"UPDATE customFields SET cfiLanguage='0' WHERE cfiId='".$current_cfi['cfiId']."'");                  
                }
                
                if(!$current_cfi['cfiLanguage'] && !$_POST['cfiLanguage']) {
                    _mysqli_query($db, "ALTER TABLE $table CHANGE `".table2prefix($table).'#'.$current_cfi['cfiName']."` `".table2prefix($table).'#'.$_POST['cfiName']."` ".$mysql_type.$default);
                }
                
                if($current_cfi['cfiLanguage'] && !$_POST['cfiLanguage']) {
                    _mysqli_query($db, "ALTER TABLE $table CHANGE `".table2prefix($table).'#'.$current_cfi['cfiName']."@".$_POST['keepLanguage']."` `".table2prefix($table).'#'.$_POST['cfiName']."` ".$mysql_type.$default);
                    foreach($cfg['languages'] as $key=>$item) {  
                        if($key!=$_POST['keepLanguage']) {          
                            _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."@".$key."`");
                        } 
                    }                     
                }
                
                if(!$current_cfi['cfiLanguage'] && $_POST['cfiLanguage']) {
                    foreach($cfg['languages'] as $key=>$item) {            
                        _mysqli_query($db, "ALTER TABLE $table ADD `".table2prefix($table).'#'.$_POST['cfiName']."@".$key."` ".$mysql_type.$default  );
                        if($_POST['moveLanguage']=='_duplicate' || $key==$_POST['moveLanguage']) {
                            _mysqli_query($db, "UPDATE $table SET `".table2prefix($table).'#'.$_POST['cfiName']."@".$key."`=`".table2prefix($table).'#'.$current_cfi['cfiName']."`");
                        } 
                    }  
                    _mysqli_query($db, "ALTER TABLE $table DROP `".table2prefix($table).'#'.$current_cfi['cfiName']."`");                  
                } 
                
                if(!$_POST['tab'] && ($_POST['cfiName']!=$current_cfi['cfiName'])) {
                    $grid=mysqli_fetch_assoc(_mysqli_query($db,"SELECT * FROM grid WHERE griTable='".$current_cfi['cfiTable']."'"));
                    $fields=json_decode($grid['griFields'],true);
                    $fields[table2prefix($current_cfi['cfiTable']).'#'.$_POST['cfiName']]=$fields[table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']];
                    unset($fields[table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']]);
                    if($_SESSION['sorting'][$current_cfi['cfiTable']]['field']==table2prefix($current_cfi['cfiTable']).'#'.$current_cfi['cfiName']) {
                        unset($_SESSION['sorting'][$current_cfi['cfiTable']]);
                    }
                    _mysqli_query($db,"UPDATE grid SET griFields='".json_encode($fields)."' WHERE griTable='".$current_cfi['cfiTable']."'");                  
                }
                // waurnek kiedy nie zaklada i inna nazwa niz poprzednio do zmiany w gridzie
                
                
                
                //exit;
            }
            
            
        }
    
        require_once('_backend/templates/header.php');      
        print_header(); 
        

         /*
        $columns=mysqli_fetch_assoc(_mysqli_query($db,"SELECT * FROM grid WHERE griAdmin_admId='".$_SESSION['admin']['admId']."' AND griTable='$table'"));
        //print_r($columns);
        if(!$columns) {
            foreach($table_fields as $key=>$item) {
                if($item['default_list']) {
                    $columns[$key]['showOnList']=1;
                }
            }
        } else {
            $columns=json_decode($columns['griFields'], true);        
        }*/
          
           
        

                        
        $sql="SELECT * FROM customFields WHERE cfiTable='$table' ORDER BY cfiSequence";
        $res=_mysqli_query($db, $sql);  

        echo '
';
        echo '';   
        foreach($table_fields as $key=>$item) {
            if($columns[$key]['showOnList']) $show=' checked="checked"'; else $show='';
                  
            echo '';            
        }         

        $r=mysqli_query($db, "SELECT * FROM customFields ORDER BY cfiSequence ASC");
        $cfields=null;
        while($row=mysqli_fetch_assoc($r)) {


            
            $cfields[$row['cfiName']]=$row;                        
        }  
        

        $prefix=table2prefix($table);      
        while($row=mysqli_fetch_assoc($res)) {
            $tr_class='';
            switch(strtolower($row['cfiType'])) {
                case 'tab': $tr_class=' class="warning"';
            }
            echo '';
            if(strtolower($row['cfiType'])!='tab' && strtolower($row['cfiType'])!='array_fields' && !$row['cfiArrayField']) {
                if($columns[$prefix.'#'.$row['cfiName']]['showOnList']) $show=' checked="checked"'; else $show='';                        
                echo '';
            } elseif($row['cfiArrayField']) {
                echo '';                
            } else {
               echo '';
            }
            echo '';            
            echo '';
        }   
        echo '
 
            
'._t('cfiSequence').'
'._t('cfiType').'
'._t('cfiName').'
'._t('cfiTitle').'
'._t('showOnList').'
 
                             
        
 
'._t('cfiType_tab').'
_basic
'._t('_basic').'
 
'._t('cfiType_'.strtolower($item['type'])).'
'.$key.'
'._t($key).'
 '.$row['cfiSequence'].'
'._t('cfiType_'.strtolower($row['cfiType'])).'
            
'.$prefix.'#'.$row['cfiName'].'
'.$row['cfiTitle@'.$cfg['admin']['language']].'
@'.$cfields[$row['cfiArrayField']]['cfiTitle@'.$cfg['admin']['language']].'

           '._t('edit').'
           '._t('duplicate').'
           '._t('remove').'          
        
';
        echo '
 '._t('cfiNewField').'
';
        require_once('_backend/templates/footer.php');  
    }



    function grid_view($table, $xtra_where=null, $xtra_buttons=null) {
        global $db, $table_fields, $table_config, $cfg, $_url;
        //perm_check_exit($table, 'view');        
           //echo $table;
        //echo '
';
        
        //print_r($_SESSION);
        
        $table_info=mysqli_fetch_assoc(mysqli_query($db, "SELECT * FROM tables WHERE tabName='".$table."'"));
        $table_info['tabConditionColor']=json_decode($table_info['tabConditionColor'], true);
        $table_info['tabDefaultShowFields']=json_decode($table_info['tabDefaultShowFields'], true);

        //print_r($table_info);
        
        
        //print_r($table_info);
                
        // SQL QUERY BUILDER ******************************************************************************************************************************//
        $res=_mysqli_query($db, "SELECT * FROM customFields WHERE cfiTable='$table' AND cfiType!='tab' ORDER BY cfiSequence ASC");
        //echo "SELECT * FROM customFields WHERE cfiTable='$table' AND cfiType!='tab' ORDER BY cfiSequence ASC";
        //$table_fields = [];
        while($row=mysqli_fetch_assoc($res)) {
            $name=table2prefix($table).'#'.$row['cfiName'];
            if($row['cfiLanguage']) {
                //$name.='@'.$_SESSION['edit_language'];                                
            }
            
            $table_fields[$name]=json_decode($row['cfiParameters'], true);
            if ($row['cfiParameters'] == '""') $table_fields[$name] = [];         
            //print_r($row);
            $table_fields[$name]['type']=$row['cfiType'];
            $table_fields[$name]['customField']=true;
            $table_fields[$name]['language']=$row['cfiLanguage'];
            //$table_fields[$name]['type']=$row['cfiType'];
            $table_fields[$name]['title']=$row['cfiTitle@'.$cfg['admin']['language']];                               


            
        } 
        
        $search='andrzej pajda';
        $slevels=$_SESSION['search'][$table];
                
        $rel_tabs=null;
        $alias_pointer=66;
        foreach($table_fields as $key=>$item) {
            if($item['type']=='rel_one2many') {
                $r=_mysqli_query($db, "SELECT * FROM customFields WHERE cfiTable='".$item['relationtotable']."'");
                //print_r($table_info);
                $tab_fields=null;
                while($fld=mysqli_fetch_assoc($r)) {
                    $tab_fields[]=$fld;                                    
                }
                $rel_tabs[]=array(
                    'table'=>$item['relationtotable'],
                    'alias'=>chr($alias_pointer),
                    'fields'=>$tab_fields,
                    'relation_field'=>$key
                );
                $alias_pointer++;                               
            }
        }

                 
        $sql="SELECT A.*";
        foreach((array)$rel_tabs as $key=>$item) {
            $sql.=', '.$item['alias'].'.*';                
        }
        $sql.=" FROM ".$table." AS A";
        foreach((array)$rel_tabs as $key=>$item) {
            $sql.=' LEFT JOIN '.$item['table'].' AS '.$item['alias'].' ON '.$item['alias'].'.'.table2prefix($item['table']).'Id=A.`'.$item['relation_field'].'`';
        }
        $sql.=' WHERE 1=1';
        
        if($slevels) {
            
            foreach($slevels as $sl=>$search) {
                $ssubs=null;
                $sql.=' AND (';                  
                $search=str_replace(' ', '%', $search);
                foreach($table_fields as $key=>$item) {
                    if(!$item['language']) {
                        $ssubs[]='`'.$key."` LIKE '%".$search."%'";
                    } else {
                        foreach($cfg['languages'] as $ls=>$lang) {                        
                            $ssubs[]='`'.$key."@".$ls."` LIKE '%".$search."%'";
                        }                
                    }
                }
                foreach((array)$rel_tabs as $key=>$item) {
                           
                    foreach($item['fields'] as $k=>$i) {
                        if($i['cfiType']!='tab') {
                            if(!$i['cfiLanguage']) {                    
                                $ssubs[]=$item['alias'].'.`'.table2prefix($i['cfiTable']).'#'.$i['cfiName']."` LIKE '%".$search."%'";
                            } else {
                                foreach($cfg['languages'] as $ls=>$lang) {
                                    $ssubs[]=$item['alias'].'.`'.table2prefix($i['cfiTable']).'#'.$i['cfiName']."@".$ls."` LIKE '%".$search."%'";
                                }
                            }
                        }                    
                    }
                }
                $sql.=implode(' OR ', $ssubs);
                $sql.=')';                 
            }
           
        }
        
        
        //$table_data=mysqli_fetch_assoc(mysqli_query($db, "SELECT * FROM tables WHERE tabName='$table'"));
        $filters=json_decode($table_info['tabFilters'],true);
        if($_SESSION['filters'][$table]) {
            $where.=' AND (';
            foreach($_SESSION['filters'][$table] as $key=>$item) {
                $where.='`'.$filters[$item]['tab#filter_field'].'` '.str_replace(array('eq', 'neq', 'gt', 'lt', 'like'), array('=', '!=', '>', '<', 'LIKE'),$filters[$item]['tab#filter_operator'])." '".$filters[$item]['tab#filter_value']."' OR ";
            }
            $sql.=$where=substr($where,0,-4).') ';
        }   

        
        //echo $sql;
        //echo '
';
        //print_r($_SESSION);
        //exit;
           // echo $_SESSION['sorting'][$table]['field'];
           // exit;
    
        //echo $_SESSION['sorting'][$table]['field'];
        if(!$_SESSION['sorting'][$table]['field']) {
            $_SESSION['sorting'][$table]=array(
                'field'=>$table_config['idField'],
                'direction'=>'ascending'
            );
        }
     

		//$_SESSION['sorting']['table_orders']['field'] = 'ordId';
		//$_SESSION['sorting']['table_orders']['direction'] = 'descending';

        if($_SESSION['sorting'][$table]['direction']=='ascending') {
            $sql.=' ORDER BY A.`'.$_SESSION['sorting'][$table]['field'].'` ASC';
        } else {
            $sql.=' ORDER BY A.`'.$_SESSION['sorting'][$table]['field'].'` DESC';        
        }
        

     
        $_total=mysqli_num_rows(_mysqli_query($db, $sql));
        
       // $dir2mysql=array('ascending'=>'ASC', 'descending'=>'DESC');
        if($_SESSION['grid_limit']) $grid_limit=$_SESSION['grid_limit']; else $grid_limit=40;
        if($_GET['page']) $page=$_GET['page']-1; else $page=0;
        if($_POST['action']=='add_search' || $_POST['action']=='remove_search') $page=0;
        //echo $page;
        
        $sql.= " LIMIT ".$page*$grid_limit.",".$grid_limit;        
        
        //print_r($table_info);
        //exit;
        //echo $sql;
        //exit;
        //echo $sql;
        //exit;           

        //echo $_total;        
        // ******************* QUERY BUILDER END ***************************************************************************************************************//


        $grid_data=mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM grid WHERE griTable='$table' AND griAdmin_admId='".$_SESSION['admin']['admId']."'"));
        $grid_data=json_decode($grid_data['griFields'],true);
        

        if(!$grid_data) {
            $ndata=null;
            foreach((array)$table_info['tabDefaultShowFields'] as $key=>$item) {
                $ndata[$item]=array('color'=>'', 'show'=>1);
            }
            $grid_data=$ndata;
            _mysqli_query($db, "REPLACE INTO grid (griAdmin_admId, griTable, griFields) VALUES ('".$_SESSION['admin']['admId']."', '".$table."', '".json_encode($ndata)."')");

        }
        
        $res=_mysqli_query($db, $sql);
        while($drow=mysqli_fetch_assoc($res)) {
            $data[]=$drow;
        }
        //print_r($data);

        require_once('_backend/templates/header.php');  
        print_header();
        foreach((array)$_GET as $key=>$item) {
            echo '';
        }        

        
        //echo '
';
        //print_r($table_fields);
        //print_r($grid_data);   
        //echo '
';     
                
        require_once('_backend/templates/grid_view.php');
                
        require_once('_backend/templates/footer.php');
        
        
                   
        //echo $sql.'
';
        
        
        
        
        
        
        
        
        
        
        //print_r($table_fields);
        //exit; 

        
        
        
                           
        exit;
        if(!$_GET['get_data']) {
            if($_GET['modal_view']) {
                echo '
';         
                echo '
';            
            } else {
                require_once('_backend/templates/header.php');        
            }     
            print_header();
            
            foreach((array)$_GET as $key=>$item) {
                echo '';
            }
    
            echo '';             
            echo '
';            
        }
    

        
        $dir2mysql=array('ascending'=>'ASC', 'descending'=>'DESC');
        if($_SESSION['grid_limit']) $grid_limit=$_SESSION['grid_limit']; else $grid_limit=40;
        if($_GET['page']) $page=$_GET['page']-1; else $page=0;
        $limit = " LIMIT ".$page*$grid_limit.",".$grid_limit;
        $where = " WHERE 1";
    

      

        // doladowanie custom fields'ow
        $res=_mysqli_query($db, "SELECT * FROM customFields WHERE cfiTable='$table' AND cfiType!='tab' ORDER BY cfiSequence ASC");
        while($row=mysqli_fetch_assoc($res)) {
            $name=table2prefix($table).'#'.$row['cfiName'];
            if($row['cfiLanguage']) {
                //$name.='@'.$_SESSION['edit_language'];                                
            }
            $table_fields[$name]=json_decode($row['cfiParameters'], true);
            $table_fields[$name]['type']=$row['cfiType'];
            $table_fields[$name]['customField']=true;
            $table_fields[$name]['language']=$row['cfiLanguage'];
            $table_fields[$name]['title']=$row['cfiTitle@'.$cfg['admin']['language']];                               
            
        }  
        
 
        
        // TODO
        $fields_array=null;        
        $columns=mysqli_fetch_assoc(_mysqli_query($db,"SELECT * FROM grid WHERE griAdmin_admId='".$_SESSION['admin']['admId']."' AND griTable='$table'"));
        $headers=null;
        $grid_fields=null;
        
        if(!$columns) {
            //echo 'xx';  
            //print_r($table_fields);                    
            foreach((array)$table_fields as $key=>$item) {
                                
                if($item['default_list']) {
                    $headers[$key]['field']=$key;
                    if($item['language']) $headers[$key]['field']=$key.'@'.$_SESSION['edit_language'];
                    $fields.='`'.$headers[$key]['field'].'`,';
                    $fields_array[]=$headers[$key]['field'];                    
                }
                if($item['default_list']) $grid_fields[$key]['showOnList']=1; else $grid_fields[$key]['showOnList']=0;                

                //echo $key.'
';

            }
            //echo $fields;
            //exit;
            $fields=substr($fields,0,-1);
            //print_r($grid_fields);
        //_mysqli_query($db, "DELETE FROM grid WHERE griTable='$table' AND griAdmin_admiId='".$_SESSION['admin']['admId']."'");
            _mysqli_query($db, "INSERT INTO grid (griAdmin_admId, griTable, griFields) VALUES ('".$_SESSION['admin']['admId']."', '".$table."', '".json_encode($grid_fields)."')");
            
                        
        } else {
            $columns['griFields']=json_decode($columns['griFields'],true);        
            foreach((array)$columns['griFields'] as $key=>$item) {
                                
                if($item['showOnList']) {
                    $headers[$key]['field']=$key;
                    if($table_fields[$key]['language']) $headers[$key]['field']=$key.'@'.$_SESSION['edit_language'];
                    $fields.='`'.$headers[$key]['field'].'`,';
                    $fields_array[]=$headers[$key]['field'];                    
                }
                              

                //echo $key.'
';

            }
            $fields=substr($fields,0,-1);        

        }
        $langadd='';
        if($table_fields[$_SESSION['sorting'][$table]['field']]['language']) $langadd='@'.$_SESSION['edit_language'];
        
        if($_SESSION['search'][$table]['phrase']) {
            $where.=' AND (';
            foreach($fields_array as $key=>$item) {
                $where.="`".$item."` LIKE '%".str_replace(' ','%',$_SESSION['search'][$table]['phrase'])."%' OR ";            
            }
            $where=substr($where,0,-4).') ';
            //exit;            
        }        
        
        //echo $where;
        $table_data=mysqli_fetch_assoc(mysqli_query($db, "SELECT * FROM tables WHERE tabName='$table'"));
        $filters=json_decode($table_data['tabFilters'],true);
        if($_SESSION['filters'][$table]) {
            $where.=' AND (';
            foreach($_SESSION['filters'][$table] as $key=>$item) {
                $where.='`'.$filters[$item]['tab#filter_field'].'` '.str_replace(array('eq', 'neq', 'gt', 'lt', 'like'), array('=', '!=', '>', '<', 'LIKE'),$filters[$item]['tab#filter_operator'])." '".$filters[$item]['tab#filter_value']."' OR ";
            }
            $where=substr($where,0,-4).') ';
        }
        
        if($table_config['sequence']) $fields.=", `".table2prefix($table).'Sequence'."`";
        //echo $fields;
        //exit;
 
        $sql="SELECT $fields FROM $table".$where." ".$xtra_where." ORDER BY `".$_SESSION['sorting'][$table]['field']."$langadd` ".$dir2mysql[$_SESSION['sorting'][$table]['direction']].$limit;
        //echo $sql;
        //exit;
        $_total=mysqli_fetch_assoc(_mysqli_query($db, "SELECT COUNT(*) AS total FROM $table".$where." ".$xtra_where." ORDER BY `".$_SESSION['sorting'][$table]['field']."$langadd` ".$dir2mysql[$_SESSION['sorting'][$table]['direction']]));
        $res=_mysqli_query($db, $sql);
        //echo $sql;
          
                

        
        //if($_GET['get_data']) {
            echo '';
            $field=split(',',$fields);                                                                                                
            if($table_config['multiSelect']) echo '';          
            $fields=null;
            foreach($field as $key=>$item) {
                $field[$key]=str_replace('`', '', $field[$key]);
                $tmp=explode('@', $field[$key]);
                //echo $tmp[0];
                $slang=$tmp[0];
                $fields[$field[$key]]=$slang;
                $islang='';
                if($table_fields[$slang]['language']) {
                    $islang=' ';
                }
                if($table_fields[$slang]['customField']) {
                    //$slang=$table_fields[$slang]['title'];
                    echo '';
                } else {            
                    echo '';
                }            
            }

                          // print_R($_SESSION);
                         //echo $sql;
                         //exit;
            echo '';
            while($row=mysqli_fetch_assoc($res)) {
               // print_r($row);
                 echo '';
                if($table_config['multiSelect']) echo '';            
                foreach($fields as $key=>$item) {  
    
                    $field_name=explode('@', $key);
                    $field_name=$field_name[0];   
                    
                    //print_r($table_fields);  
                    //echo $table_fields[$key]['type'];
                    
                    switch($table_fields[$item]['type']) {
                        case 'text': echo ''; break;
                        case 'htmlarea': echo ''; break;
                        case 'rel_one2many':
                            $field=$table_fields[$key];
                            $value=mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM ".$field['relationtotable']." WHERE ".table2prefix($field['relationtotable'])."Id='".$row[$key]."'"));
                            if($value[$field['relationfield'].'@'.$_SESSION['edit_language']]) {
                                $value=$value[$field['relationfield'].'@'.$_SESSION['edit_language']];
                            } else {
                                $value=$value[$field['relationfield']];                        
                            }                    
                            echo '';
                        break; 
                        case 'checkboxes': 
                            echo ''; 
                        break;
                        case 'select':
                            $field=$table_fields[$key];                    
                            echo '';
                    
                        break;
                        case 'link_button':
                            echo '';
                        
                        break;                        
                        default: echo '';
                    }                
    
                }
                
                switch($_GET['mode']) {
                    case 'select_relation':
                        echo '';                
                    break;
                    default:
             
                        echo '';
                    break;
                }
           
                echo '';
            }   
            echo '
'.$table_fields[$slang]['title'].$islang.'
'._t($slang).$islang.'
 
'.$row[$key].'
'.substr(strip_tags($row[$key]),0,200).'
'.$value.'
';
                            $field=$table_fields[$key];     
                            $vls=null;
                            /*
                            if($row[$key]!='[""]' && $row[$key]!='') {                      
                                $vls=
                            }
                            */

                            //echo "

".$row[$key].'

';
                            if($row[$key]) {
                                $vls=explode(';;',substr($row[$key],1,-1));
                            }
                            $out='';
                            foreach((array)$vls as $k=>$it) {
                                $out.=$field['labels'][array_search($it, $field['values'])].', ';                         
                                       
                            }                        
                            echo substr($out,0,-2).'
'.$field['labels'][array_search($row[$key], $field['values'])].'
';
                            $field=$table_fields[$key]; 
                            echo ''.$field['title'].'
'.$row[$key].'

                       wybierz
';
                        foreach((array)$xtra_buttons as $k=>$button) {
                            //print_r($button);
                            $url=str_replace(array('{id}'), array($row[$table_config['idField']]), $button['url']);
                            if($table=='tables') { $tabl=$row['tabName']; } else { $tabl=$table; }
                            echo ' '.$button['label'].'';
                        }                 
                        echo ' edytuj
                       duplikuj
                       usuń          
                    
';
        
        //}
                  echo '
';  
        
if(!$_GET['get_data']) {        
        echo '
'; 
        
        
        //echo '
Zapisz
'; 
        echo '

        
«
...
»
     
        
Rekordy ... - ... z '.$_total['total'].'
     

     
'; 
   
     echo '';
     echo '';
        
        if($_GET['modal_view']) {
            echo '
';
        } else {                    
            require_once('_backend/templates/footer.php');
        }
}
           
    }


    function grid_record($table, $edit=false, $xtra_data = null) {
    
        global $table_fields, $table_config, $db, $cfg, $_POST, $_cat_tree, $_url, $alert, $_admin;
  
        if($_url[1]=='modules' && $_url[2]=='settings') {
            perm_check_exit('modules', 'edit');
        } else {
            if($edit) {
                perm_check_exit($table, 'edit');
            } else {
                perm_check_exit($table, 'add');        
            }
        }
        //print_r($table_fields);
        //print_r($table_config);
        //exit;

        require_once('_backend/templates/header.php');     
      
        echo '';
        /************************ zaladowanie custom fields *************************/
        $res=_mysqli_query($db, "SELECT * FROM customFields WHERE cfiTable='$table' ORDER BY cfiSequence ASC");
    
        while($row=mysqli_fetch_assoc($res)) {
            $name=table2prefix($table).'#'.$row['cfiName'];
            if($row['cfiLanguage']) {
                $name.='@'.$_SESSION['edit_language'];                                
            }
            $table_fields[$name]=json_decode($row['cfiParameters'], true);
            $table_fields[$name]['type']=$row['cfiType'];
            $table_fields[$name]['customField']=true;
            $table_fields[$name]['arrayField']=$row['cfiArrayField'];
            $table_fields[$name]['title']=$row['cfiTitle@'.$cfg['admin']['language']];                               

        }   

        if($edit) {
            $record = mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM ".$table." WHERE $table_config[idField]='$_GET[id]'"));
        } else {
            $record[$table_config['idField']]='(auto)';
        }



      
        print_header();
        
        echo '

        
Podstawowe
';
        foreach($table_fields as $key=>$field) {
            if(strtolower($field['type'])=='tab') {
                echo '
'.$field['title'].'
';
            }
        }
        echo '

';
        

        if($table_config['status']) {
          echo '
 Status rekordu
';
          //echo table2prefix($table);
          //print_r($record);
          $xtra_0=' display: none;'; $xtra_1='';
          
          // default_val;
          if(!$edit) $record[table2prefix($table).'Status']=1;                     
          
          if($record[table2prefix($table).'Status']) {
              $xtra_1=' display: none;'; $xtra_0='';       
          } 
          echo 'Włączony';
          echo 'Wyłączony';       
          echo '
';
        }
     
        
        if($table_config['languages']) {
          echo '
 Pokazuj w językach
';
          echo '
 (we wszystkich)
';
          echo '
';          
          foreach($cfg['languages'] as $key=>$item) { 
              echo '
 '.$item['title'].'
';
          }            
          echo '
';        
        }
        
        if($table_config['categories']) {
          echo '
 Pokazuj w kategoriach
';
          echo '
 (we wszystkich)
';
          echo '
'.catTreeList($_cat_tree).'
';        
          echo '
';
        }
                    
        
        
        
        echo '
';  
      
     

        
        echo '
';
        //print_r($table_fields);
        foreach($table_fields as $key=>$field) {
            if(strtolower($field['type'])!='tab') {
                $af=''; $afb='';
                if($field['arrayField']) {
                    $af=' arrayField="'.table2prefix($table).'#'.$field['arrayField'].'"';
                    $afb=' arrayField="'.table2prefix($table).$field['arrayField'].'"'; 
                }
  
                if($field['customField']) echo '';
            } else {
                //$currentTab=;
                echo '
'.(strtolower($field['type'])=='module_button' || strtolower($field['type'])=='script_button'?'':$field['title']).'
'; else echo '
'._t($key).'
';
                if($field['legend']) echo '
'.$field['legend'].'
';

                if($field['language']) $key.='@'.$_SESSION['edit_language'];                
                switch(strtolower($field['type'])) {
                    case 'text': echo ''; break;
                    case 'htmlarea':
                        $style='';
                        if($field['height']) $style='style="height: '.$field['height'].'px;"';
                        if($field['arrayField']) { $class='class="ckeditor_loader" uclass="ckeditor_'.$field['editor'].'"'; } else {
                            $class='class="ckeditor_'.$field['editor'].'"';
                        }
                        $b64='';
                        if($field['base64']) $b64=' base64="true"';
                        //print_r($field);
                        //exit;
                        echo ''.$record[$key].'';
                    break;
                    case 'textarea':
                        if($field['height']) $style='style="height: '.$field['height'].'px;"';
                        echo ''.$record[$key].'';
                    break;
                    case 'select_modules': echo '';
                        $mm=get_modules_menu();
                        foreach($mm as $k=>$mod) {
                            echo ''.$mod['title'].'';
                        }
                        echo '';
                    break;
                    case 'select_templates': echo '';

                        $mm=get_templates();                    
                        print_r($mm);
                        
                        foreach($mm as $k=>$mod) {
                            if($mod['title']) $tit=$mod['title']; else $tit=$k;
                            echo ''.$tit.'';
                        }
                        echo '';
                    break;                    
                    case 'float': echo ''; break;     
                    case 'date': echo '
'; break;
                    case 'time': echo '
'; break;
                    case 'datetime': echo '
'; break;                                                                
                    case 'id': echo ''; break;
                    case 'image':                    
                        echo '
';
                    break;                      
                    case 'rel_one2many':
          
          
                        if(substr($field['relationtotable'],0,6)=='table_') {
                            $internal=0;
                
                            $table_description = mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM tables WHERE tabName='".$field['relationtotable']."'"));
                            $link='/'.$_url[0].'/table/view/?tid='.$table_description['tabId'].'&modal_view=1&mode=select_relation&field='.$field['relationfield'];
                           
                        } else {
                            $internal=1;
                            //$value=mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM ".$field['relationtotable']." WHERE ".table2prefix($field['relationtotable'])."Id='".$record[$key]."'"));
                        
                            $link='/'.$_url[0].'/'.$field['relationtotable'].'/view?modal_view=1&mode=select_relation&field='.$key;
                        }
                        $value=mysqli_fetch_assoc(_mysqli_query($db, "SELECT * FROM ".$field['relationtotable']." WHERE ".table2prefix($field['relationtotable'])."Id='".$record[$key]."'"));
                        if($value[$field['relationfield'].'@'.$_SESSION['edit_language']]) {
                            $value=$value[$field['relationfield'].'@'.$_SESSION['edit_language']];
                        } else {
                            $value=$value[$field['relationfield']];                        
                        }
                        
                        //echo $field['relationfield'].'
'.$value[$field['relationfield']].'
';
                        //echo "SELECT * FROM ".$field['relationtotable']." WHERE ".table2prefix($field['relationtotable'])."Id='".$record[$key]."'";
                        //exit;
                        //print_R($_SESSION);
                        if($_GET['tid'] == 31):
                        $stylwybieraka = 'style="width: 400px;"'; 
                        else:
                        $stylwybieraka = 'style="width: 250px;"';
                        endif;

                        echo '
';
                    break;  
                    case 'password':
                        if($record[$key]) $mask_pass='?????';
                        echo ''; break;
                    break;  
                    case 'select':                
                        echo '';
                        foreach($field['values'] as $k2=>$i2) {
                            if($edit) {
                                $sel="";                     
                                if($i2==$record[$key]) $sel=' selected="selected"';
                            }
                            echo ''.$field['labels'][$k2].'';
                        }
                        echo '';
                    break;   
                    case 'checkbox':
                        $chk='';
                        if($record[$key]=='1') $chk=' checked="checked"';
                        echo '
';
                    break;
                    case 'checkboxes':
                        $checked=explode(';;',substr($record[$key],1,-1));
                        foreach($field['values'] as $k2=>$i2) {
                            //echo ''.$field['labels'][$k2].'';
                            if($edit) {
                                $chk="";                            
                                if(in_array($i2, (array)$checked)) $chk=' checked="checked"';
                            }
                                                        
                            echo '
 '.$field['labels'][$k2].'
';
                        }                        
                        
                                                
                        echo '';
                    break;   
                    case 'table':
                        echo '(wybierz)';
                        $r=_mysqli_query($db, "SELECT * FROM tables WHERE tabInternal!='1'");
                        while($rek=mysqli_fetch_assoc($r)) {
                            $sel="";
                            $tname=$rek['tabName'];                            
                            if($tname==$record[$key]) $sel=' selected="selected"';                             
                            echo ''.$rek['tabTitle@'.$cfg['admin']['language']].'';
                            
                        }
                        echo '';                    
                    break;  
                    case 'table_field':
                        echo '(wybierz)';                      
                    break; 
                    case 'array_fields':
                        if($record[$key]) {
                            echo '
'.$record[$key].'
';
                        }
                        echo '
';
                        if(!$field['customField']) {
                            echo '';
                        }
                    break;   
                    case 'module_button':
                        echo ''.$field['title'].'';
                    break;
                    case 'link_button':
                        echo ''.$field['title'].'';
                    
                    break;
                    case 'int': echo ''; break;
                    case 'keyvalue_ro': if($edit) {
                            echo '';
                        } else {
                            echo '';  
                        }

                    break;
                    case 'script_button':
                        echo ''.$field['title'].'';
                    break;                    
                        
                    default: echo ''; break;
                    
                }
                echo '
';
            }
        }
        echo '';
        echo '';   
        if($table_config['status']) { 
            // domyslna wartosc na 1
            if(!$edit) $record[table2prefix($table).'Status']='1';            
            echo '';
        }
        if($table_config['categories']) {
            echo '';
        }  
        if($table_config['languages']) {
            echo '';
        }              
        if(!$edit) {
            echo '';        
        } else {
            echo '';   
            echo '';                       
        }      
        foreach((array)$xtra_data as $key=>$item) {
            echo '';
        }
        echo '
';
        
        
        echo '
Zapisz
'; 
        require_once('_backend/templates/footer.php');  
    }



?>