MATE Functions

    mysql_query( "SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'" );
// UTF-8 support in MATE

    function deleteFile($info)
    {
        // code to delete file
        if(@unlink($this->dataDir.$info['uploadName']))
        {
            $query = "update emp_upload_dir set file_name = '' where id = '".$this->escapeData($info['id'])."' limit 1";
            $result = $this->Editor->doQuery($query);
            if($result)
            {
                return true;
            }
        }
        $this->Editor->warnings[] = 'There was an error deleting the file.';
        return false;
    }

function updateSqlFilters($name)
{
    //ajaxUrl = '<?php echo $_SERVER['PHP_SELF']; ?name='+$name;
    $this->Editor->toAjaxTableEditor('update_html','');
}

// Join Table
        $tableColumns['cyl_num']= array(
            'display_text' => 'Cyl Num Brand',
            'perms' => 'AVCXTQSHOF',
            'join' => array(
               'table' => 'rasstore_cylinders',
               'column' => 'cyl_num',
               'display_mask' => "concat(rasstore_cylinders.cyl_num,' ',rasstore_cylinders.cyl_brand)",
               'type' => 'left'
            )
        );