ImpressCMS Core is an open source project powered by Assembla

Assembla offers free public and private SVN/Git repositories and project hosting with bug/issue tracking and collaboration tools.

impresscms

Commit 8815

User picture
  • Author: realtherplima
  • 2009-06-03 01:25 (almost 5 years ago)

merged lastest changes from trunk. from r8786 to r8812

Files Affected

 
88148815
237
     * @return  string  $ret
237
     * @return  string  $ret
238
     * @access protected
238
     * @access protected
239
     */
239
     */
240
    protected function dump( $mode = '' ) {
240
    public function dump( $mode = '' ) {
241
        include ICMS_ROOT_PATH . '/class/logger_render.php';
241
        include ICMS_ROOT_PATH . '/class/logger_render.php';
242
        return $ret;
242
        return $ret;
243
    }
243
    }
88148815
348
.strongPass span{
348
.strongPass span{
349
    background:url(images/green.png) no-repeat bottom right;
349
    background:url(images/green.png) no-repeat bottom right;
350
}
350
}
 
 
351
#icms_rating_container {}
 
 
352
#icms_rating_container .itemHead {
 
 
353
    font-weight: bold;
 
 
354
}
 
 
355
#icms_rating_container .item {
 
 
356
    width: 300px;
 
 
357
    margin: auto;
 
 
358
    margin-top: 5px;
 
 
359
    margin-bottom: 5px;
 
 
360
}
 
 
361
#icms_rating_container .odd {
 
 
362
    padding: 6px;
 
 
363
    height: auto;
 
 
364
}
 
 
365
 
88148815
497
.strongPass span{
497
.strongPass span{
498
    background:url(images/green.png) no-repeat top right;
498
    background:url(images/green.png) no-repeat top right;
499
}
499
}
 
 
500
#icms_rating_container {}
 
 
501
#icms_rating_container .itemHead {
 
 
502
    font-weight: bold;
 
 
503
}
 
 
504
#icms_rating_container .item {
 
 
505
    width: 300px;
 
 
506
    margin: auto;
 
 
507
    margin-top: 5px;
 
 
508
    margin-bottom: 5px;
 
 
509
}
 
 
510
#icms_rating_container .odd {
 
 
511
    padding: 6px;
 
 
512
    height: auto;
 
 
513
}
 
 
514
 
88148815
825
 
825
 
826
/*
826
/*
827
* Gets module handler
827
* Gets module handler
 
 
828
* For Backward Compatibility.
828
*
829
*
829
* @param    string  $name  The name of the module
830
* @param    string  $name  The name of the module
830
* @param    string    $module_dir        The module directory where to get the module class
831
* @param    string    $module_dir        The module directory where to get the module class
...
 
...
 
832
*/
833
*/
833
function &xoops_getmodulehandler($name = null, $module_dir = null, $optional = false)
834
function &xoops_getmodulehandler($name = null, $module_dir = null, $optional = false)
834
{
835
{
835
    static $handlers;
836
    return icms_getmodulehandler($name, $module_dir, $module_dir, $optional);
836
    // if $module_dir is not specified
 
 
837
    if(!isset($module_dir))
 
 
838
    {
 
 
839
        //if a module is loaded
 
 
840
        if(isset($GLOBALS['icmsModule']) && is_object($GLOBALS['icmsModule'])) {$module_dir = $GLOBALS['icmsModule']->getVar('dirname');}
 
 
841
        else {trigger_error(_CORE_NOMODULE, E_USER_ERROR);}
 
 
842
    }
 
 
843
    else {$module_dir = trim($module_dir);}
 
 
844
    $name = (!isset($name)) ? $module_dir : trim($name);
 
 
845
    if(!isset($handlers[$module_dir][$name]))
 
 
846
    {
 
 
847
        if($module_dir != 'system') {$hnd_file = ICMS_ROOT_PATH."/modules/{$module_dir}/class/{$name}.php";}
 
 
848
        else {$hnd_file = ICMS_ROOT_PATH."/modules/{$module_dir}/admin/{$name}/class/{$name}.php";}
 
 
849
        if(file_exists($hnd_file)) {include_once $hnd_file;}
 
 
850
        $class = ucfirst(strtolower($module_dir)).ucfirst($name).'Handler';
 
 
851
        if(class_exists($class)) {$handlers[$module_dir][$name] =& new $class($GLOBALS['xoopsDB']);}
 
 
852
    }
 
 
853
    if(!isset($handlers[$module_dir][$name]) && !$optional)
 
 
854
    {
 
 
855
        trigger_error(sprintf(_CORE_MODULEHANDLER_NOTAVAILABLE, $module_dir, $name), E_USER_ERROR);
 
 
856
    }
 
 
857
    if(isset($handlers[$module_dir][$name])) {return $handlers[$module_dir][$name];}
 
 
858
    $inst = false;
 
 
859
    return $inst;
 
 
860
}
837
}
861
 
838
 
862
/*
839
/*
...
 
...
 
1766
}
1743
}
1767
 
1744
 
1768
/**
1745
/**
 
 
1746
* Get URL of the page before the form to be able to redirect their after the form has been posted
 
 
1747
*
 
 
1748
* @param    array    $matches    Array of matches to sanitize
 
 
1749
* @return mixed The sanitized tag or empty string
 
 
1750
*/
 
 
1751
function icms_sanitizeAdsenses_callback($matches) {
 
 
1752
    global $icms_adsense_handler;
 
 
1753
    if (isset($icms_adsense_handler->objects[$matches[1]])){
 
 
1754
        $adsenseObj = $icms_adsense_handler->objects[$matches[1]];
 
 
1755
        $ret = $adsenseObj->render();
 
 
1756
        return $ret;
 
 
1757
    } else {
 
 
1758
        return '';
 
 
1759
    }
 
 
1760
}
 
 
1761
 
 
 
1762
/**
 
 
1763
* Sanitizes Adsense
 
 
1764
*
 
 
1765
* @param string $text    Purifies passed text
 
 
1766
* @return string    $text The purified text
 
 
1767
*/
 
 
1768
function icms_sanitizeAdsenses($text) {
 
 
1769
 
 
 
1770
    $patterns = array ();
 
 
1771
    $replacements = array ();
 
 
1772
 
 
 
1773
    $patterns[] = "/\[adsense](.*)\[\/adsense\]/sU";
 
 
1774
    $text = preg_replace_callback($patterns, 'icms_sanitizeAdsenses_callback', $text);
 
 
1775
    return $text;
 
 
1776
}
 
 
1777
 
 
 
1778
/**
1769
* Return a linked username or full name for a specific $userid
1779
* Return a linked username or full name for a specific $userid
1770
*
1780
*
1771
* @param integer $userid uid of the related user
1781
* @param integer $userid uid of the related user
...
 
...
 
2615
    if (!$withLink) {
2625
    if (!$withLink) {
2616
        return $icmsModule->getVar('name');
2626
        return $icmsModule->getVar('name');
2617
    } else {
2627
    } else {
2618
/*        $seoMode = icms_getModuleModeSEO($moduleName);
2628
        $seoMode = icms_getModuleModeSEO($moduleName);
2619
        if ($seoMode == 'rewrite') {
2629
        if ($seoMode == 'rewrite') {
2620
            $seoModuleName = icms_getModuleNameForSEO($moduleName);
2630
            $seoModuleName = icms_getModuleNameForSEO($moduleName);
2621
            $ret = ICMS_URL . '/' . $seoModuleName . '/';
2631
            $ret = ICMS_URL . '/' . $seoModuleName . '/';
...
 
...
 
2624
        } else {
2634
        } else {
2625
            $ret = ICMS_URL . '/modules/' . $moduleName . '/';
2635
            $ret = ICMS_URL . '/modules/' . $moduleName . '/';
2626
        }
2636
        }
2627
*/
 
 
2628
        $ret = ICMS_URL . '/modules/' . $moduleName . '/';
 
 
2629
        return '<a href="' . $ret . '">' . $icmsModule->getVar('name') . '</a>';
2637
        return '<a href="' . $ret . '">' . $icmsModule->getVar('name') . '</a>';
2630
    }
2638
    }
2631
}
2639
}
...
 
...
 
2708
    return $urls['full'];
2716
    return $urls['full'];
2709
}
2717
}
2710
 
2718
 
2711
/*function icms_getModuleName($withLink = true, $forBreadCrumb = false, $moduleName = false) {
 
 
2712
    if (!$moduleName) {
 
 
2713
        global $icmsModule;
 
 
2714
        $moduleName = $icmsModule->getVar('dirname');
 
 
2715
    }
 
 
2716
    $icmsModule = & icms_getModuleInfo($moduleName);
 
 
2717
    $icmsModuleConfig = & icms_getModuleConfig($moduleName);
 
 
2718
    if (!isset ($icmsModule)) {
 
 
2719
        return '';
 
 
2720
    }
 
 
2721
 
 
 
2722
    if ($forBreadCrumb && (isset ($icmsModuleConfig['show_mod_name_breadcrumb']) && !$icmsModuleConfig['show_mod_name_breadcrumb'])) {
 
 
2723
        return '';
 
 
2724
    }
 
 
2725
    if (!$withLink) {
 
 
2726
        return $icmsModule->getVar('name');
 
 
2727
    } else {
 
 
2728
        $seoMode = icms_getModuleModeSEO($moduleName);
 
 
2729
        if ($seoMode == 'rewrite') {
 
 
2730
            $seoModuleName = icms_getModuleNameForSEO($moduleName);
 
 
2731
            $ret = ICMS_URL . '/' . $seoModuleName . '/';
 
 
2732
        } elseif ($seoMode == 'pathinfo') {
 
 
2733
            $ret = ICMS_URL . '/modules/' . $moduleName . '/seo.php/' . $seoModuleName . '/';
 
 
2734
        } else {
 
 
2735
            $ret = ICMS_URL . '/modules/' . $moduleName . '/';
 
 
2736
        }
 
 
2737
 
 
 
2738
        return '<a href="' . $ret . '">' . $icmsModule->getVar('name') . '</a>';
 
 
2739
    }
 
 
2740
}*/
 
 
2741
 
 
 
2742
/**
2719
/**
2743
 * Gets module name in SEO format
2720
 * Gets module name in SEO format
2744
 *
2721
 *
...
 
...
 
3115
    icms_openclose_collapsable($name);
3092
    icms_openclose_collapsable($name);
3116
    echo "<br />";
3093
    echo "<br />";
3117
}
3094
}
 
 
3095
function icms_MakePrinterFriendly($content, $title=false, $description=false, $pagetitle=false, $width=680) {
 
 
3096
    require_once ICMS_ROOT_PATH . '/class/icmsprinterfriendly.php';
 
 
3097
    $PrintDataBuilder = new IcmsPrinterFriendly;
 
 
3098
    $PrintDataBuilder->IcmsPrinterFriendly($content, $title, $description);
 
 
3099
    $PrintDataBuilder->setPageTitle($pagetitle);
 
 
3100
    $PrintDataBuilder->setWidth($width);
 
 
3101
    $PrintDataBuilder->render();
 
 
3102
}
3118
?>
3103
?>
88148815
10
* @version        $Id$
10
* @version        $Id$
11
*/
11
*/
12
 
12
 
13
define('ICMS_VERSION_NAME','ImpressCMS 1.2 Alpha 1');
13
define('ICMS_VERSION_NAME','ImpressCMS 1.2 Alpha 2');
14
/**
14
/**
15
 * To developers:
15
 * To developers:
16
 * if you want to get the version number of the core, please use something like:
16
 * if you want to get the version number of the core, please use something like:
...
 
...
 
38
 *
38
 *
39
 * Every release has its own build number, incrementable by 1 everytime we make a release
39
 * Every release has its own build number, incrementable by 1 everytime we make a release
40
 */
40
 */
41
define('ICMS_VERSION_BUILD', 25);
41
define('ICMS_VERSION_BUILD', 26);
42
 
42
 
43
/**
43
/**
44
 * Latest dbversion of the System Module
44
 * Latest dbversion of the System Module
...
 
...
 
49
 * So, developers, everytime you add an upgrade block in system/include/update.php to upgrade something in the DB,
49
 * So, developers, everytime you add an upgrade block in system/include/update.php to upgrade something in the DB,
50
 * pease also change this constant
50
 * pease also change this constant
51
 */
51
 */
52
define('ICMS_SYSTEM_DBVERSION', 25);
52
define('ICMS_SYSTEM_DBVERSION', 26);
53
 
53
 
54
?>
54
?>
88148815
5
* See the enclosed file license.txt for licensing information.
5
* See the enclosed file license.txt for licensing information.
6
* If you did not receive this file, get it at http://www.fsf.org/copyleft/gpl.html
6
* If you did not receive this file, get it at http://www.fsf.org/copyleft/gpl.html
7
*
7
*
8
* @copyright    The ImpressCMS project http://www.impresscms.org/
8
* @copyright    The ImpressCMS project http://www.impresscms.org/
9
* @license      http://www.fsf.org/copyleft/gpl.html GNU General Public License (GPL)
9
* @license      http://www.fsf.org/copyleft/gpl.html GNU General Public License (GPL)
10
* @package        installer
10
* @package        installer
11
* @since        1.0
11
* @since        1.0
12
* @author        Kazumi Ono (AKA onokazu)
12
* @author        Kazumi Ono (AKA onokazu)
13
* @author        RpLima
13
* @author        RpLima
14
* @author        Martijn Hertog (AKA wtravel) <martin@efqconsultancy.com>
14
* @author        Martijn Hertog (AKA wtravel) <martin@efqconsultancy.com>
...
 
...
 
19
 */ 
19
 */ 
20
icms_loadLanguageFile('system', 'modulesadmin', true);
20
icms_loadLanguageFile('system', 'modulesadmin', true);
21
function xoops_module_install($dirname) {
21
function xoops_module_install($dirname) {
22
    global $xoopsUser, $xoopsConfig;
22
    global $xoopsUser, $xoopsConfig;
23
    $dirname = trim($dirname);
23
    $dirname = trim($dirname);
24
    $db =& Database::getInstance();
24
    $db =& Database::getInstance();
25
    $reservedTables = array('avatar', 'avatar_users_link', 'block_module_link', 'xoopscomments', 'config', 'configcategory', 'configoption', 'image', 'imagebody', 'imagecategory', 'imgset', 'imgset_tplset_link', 'imgsetimg', 'groups','groups_users_link','group_permission', 'online', 'bannerclient', 'banner', 'bannerfinish', 'priv_msgs', 'ranks', 'session', 'smiles', 'users', 'newblocks', 'modules', 'tplfile', 'tplset', 'tplsource', 'xoopsnotifications', 'banner', 'bannerclient', 'bannerfinish');
25
    $reservedTables = array('avatar', 'avatar_users_link', 'block_module_link', 'xoopscomments', 'config', 'configcategory', 'configoption', 'image', 'imagebody', 'imagecategory', 'imgset', 'imgset_tplset_link', 'imgsetimg', 'groups','groups_users_link','group_permission', 'online', 'bannerclient', 'banner', 'bannerfinish', 'priv_msgs', 'ranks', 'session', 'smiles', 'users', 'newblocks', 'modules', 'tplfile', 'tplset', 'tplsource', 'xoopsnotifications', 'banner', 'bannerclient', 'bannerfinish');
26
    $module_handler =& xoops_gethandler('module');
26
    $module_handler =& xoops_gethandler('module');
27
    if ($module_handler->getCount(new Criteria('dirname', $dirname)) == 0) {
27
    if ($module_handler->getCount(new Criteria('dirname', $dirname)) == 0) {
28
        $module =& $module_handler->create();
28
        $module =& $module_handler->create();
29
        $module->loadInfoAsVar($dirname);
29
        $module->loadInfoAsVar($dirname);
30
        $module->setVar('weight', 1);
30
        $module->setVar('weight', 1);
31
        $error = false;
31
        $error = false;
32
        $errs = array();
32
        $errs = array();
33
        $sqlfile =& $module->getInfo('sqlfile');
33
        $sqlfile =& $module->getInfo('sqlfile');
34
        $msgs = array();
34
        $msgs = array();
35
        $msgs[] = '<h4 style="text-align:'._GLOBAL_LEFT.';margin-bottom: 0px;border-bottom: dashed 1px #000000;">Installing '.$module->getInfo('name').'</h4>';
35
        $msgs[] = '<h4 style="text-align:'._GLOBAL_LEFT.';margin-bottom: 0px;border-bottom: dashed 1px #000000;">Installing '.$module->getInfo('name').'</h4>';
36
        if ($module->getInfo('image') != false && trim($module->getInfo('image')) != '') {
36
        if ($module->getInfo('image') != false && trim($module->getInfo('image')) != '') {
37
            $msgs[] ='<img src="'.XOOPS_URL.'/modules/'.$dirname.'/'.trim($module->getInfo('image')).'" alt="" />';
37
            $msgs[] ='<img src="'.XOOPS_URL.'/modules/'.$dirname.'/'.trim($module->getInfo('image')).'" alt="" />';
38
        }
38
        }
39
        $msgs[] ='<b>Version:</b> '.icms_conv_nr2local($module->getInfo('version'));
39
        $msgs[] ='<b>Version:</b> '.icms_conv_nr2local($module->getInfo('version'));
40
        if ($module->getInfo('author') != false && trim($module->getInfo('author')) != '') {
40
        if ($module->getInfo('author') != false && trim($module->getInfo('author')) != '') {
41
            $msgs[] ='<b>Author:</b> '.trim($module->getInfo('author'));
41
            $msgs[] ='<b>Author:</b> '.trim($module->getInfo('author'));
42
        }
42
        }
43
        $msgs[] = '';
43
        $msgs[] = '';
44
        $errs[] = '<h4 style="text-align:'._GLOBAL_LEFT.';margin-bottom: 0px;border-bottom: dashed 1px #000000;">Installing '.$module->getInfo('name').'</h4>';
44
        $errs[] = '<h4 style="text-align:'._GLOBAL_LEFT.';margin-bottom: 0px;border-bottom: dashed 1px #000000;">Installing '.$module->getInfo('name').'</h4>';
45
        if ($sqlfile != false && is_array($sqlfile)) {
45
        if ($sqlfile != false && is_array($sqlfile)) {
46
 
46
 
47
            $sql_file_path = XOOPS_ROOT_PATH."/modules/".$dirname."/".$sqlfile[XOOPS_DB_TYPE];
47
            $sql_file_path = XOOPS_ROOT_PATH."/modules/".$dirname."/".$sqlfile[XOOPS_DB_TYPE];
48
            if (!file_exists($sql_file_path)) {
48
            if (!file_exists($sql_file_path)) {
49
                $errs[] = "SQL file not found at <b>$sql_file_path</b>";
49
                $errs[] = "SQL file not found at <b>$sql_file_path</b>";
50
                $error = true;
50
                $error = true;
51
            } else {
51
            } else {
52
                $msgs[] = "SQL file found at <b>$sql_file_path</b>.<br  /> Creating tables...";
52
                $msgs[] = "SQL file found at <b>$sql_file_path</b>.<br  /> Creating tables...";
53
                include_once XOOPS_ROOT_PATH.'/class/database/drivers/'.XOOPS_DB_TYPE.'/sqlutility.php';
53
                include_once XOOPS_ROOT_PATH.'/class/database/drivers/'.XOOPS_DB_TYPE.'/sqlutility.php';
54
                $sql_query = fread(fopen($sql_file_path, 'r'), filesize($sql_file_path));
54
                $sql_query = fread(fopen($sql_file_path, 'r'), filesize($sql_file_path));
55
                $sql_query = trim($sql_query);
55
                $sql_query = trim($sql_query);
56
                SqlUtility::splitSqlFile($pieces, $sql_query);
56
                SqlUtility::splitSqlFile($pieces, $sql_query);
57
                $created_tables = array();
57
                $created_tables = array();
58
                foreach ($pieces as $piece) {
58
                foreach ($pieces as $piece) {
59
                    // [0] contains the prefixed query
59
                    // [0] contains the prefixed query
60
                    // [4] contains unprefixed table name
60
                    // [4] contains unprefixed table name
61
                    $prefixed_query = SqlUtility::prefixQuery($piece, $db->prefix());
61
                    $prefixed_query = SqlUtility::prefixQuery($piece, $db->prefix());
62
                    if (!$prefixed_query) {
62
                    if (!$prefixed_query) {
63
                        $errs[] = "<b>$piece</b> is not a valid SQL!";
63
                        $errs[] = "<b>$piece</b> is not a valid SQL!";
64
                        $error = true;
64
                        $error = true;
65
                        break;
65
                        break;
66
                    }
66
                    }
67
                    // check if the table name is reserved
67
                    // check if the table name is reserved
68
                    if (!in_array($prefixed_query[4], $reservedTables)) {
68
                    if (!in_array($prefixed_query[4], $reservedTables)) {
69
                        // not reserved, so try to create one
69
                        // not reserved, so try to create one
70
                        if (!$db->query($prefixed_query[0])) {
70
                        if (!$db->query($prefixed_query[0])) {
71
                            $errs[] = $db->error();
71
                            $errs[] = $db->error();
72
                            $error = true;
72
                            $error = true;
73
                            break;
73
                            break;
74
                        } else {
74
                        } else {
75
 
75
 
76
                            if (!in_array($prefixed_query[4], $created_tables)) {
76
                            if (!in_array($prefixed_query[4], $created_tables)) {
77
                                $msgs[] = '&nbsp;&nbsp;Table <b>'.$db->prefix($prefixed_query[4]).'</b> created.';
77
                                $msgs[] = '&nbsp;&nbsp;Table <b>'.$db->prefix($prefixed_query[4]).'</b> created.';
78
                                $created_tables[] = $prefixed_query[4];
78
                                $created_tables[] = $prefixed_query[4];
79
                            } else {
79
                            } else {
80
                                $msgs[] = '&nbsp;&nbsp;Data inserted to table <b>'.$db->prefix($prefixed_query[4]).'</b>.';
80
                                $msgs[] = '&nbsp;&nbsp;Data inserted to table <b>'.$db->prefix($prefixed_query[4]).'</b>.';
81
                            }
81
                            }
82
                        }
82
                        }
83
                    } else {
83
                    } else {
84
                        // the table name is reserved, so halt the installation
84
                        // the table name is reserved, so halt the installation
85
                        $errs[] = '<b>'.$prefixed_query[4]."</b> is a reserved table!";
85
                        $errs[] = '<b>'.$prefixed_query[4]."</b> is a reserved table!";
86
                        $error = true;
86
                        $error = true;
87
                        break;
87
                        break;
88
                    }
88
                    }
89
                }
89
                }
90
                // if there was an error, delete the tables created so far, so the next installation will not fail
90
                // if there was an error, delete the tables created so far, so the next installation will not fail
91
                if ($error == true) {
91
                if ($error == true) {
92
                    foreach ($created_tables as $ct) {
92
                    foreach ($created_tables as $ct) {
93
                        //echo $ct;
93
                        //echo $ct;
94
                        $db->query("DROP TABLE ".$db->prefix($ct));
94
                        $db->query("DROP TABLE ".$db->prefix($ct));
95
                    }
95
                    }
96
                }
96
                }
97
            }
97
            }
98
        }
98
        }
99
        // if no error, save the module info and blocks info associated with it
99
        // if no error, save the module info and blocks info associated with it
100
        if ($error == false) {
100
        if ($error == false) {
101
            if (!$module_handler->insert($module)) {
101
            if (!$module_handler->insert($module)) {
102
                $errs[] = 'Could not insert <b>'.$module->getVar('name').'</b> to database.';
102
                $errs[] = 'Could not insert <b>'.$module->getVar('name').'</b> to database.';
103
                foreach ($created_tables as $ct) {
103
                foreach ($created_tables as $ct) {
104
                    $db->query("DROP TABLE ".$db->prefix($ct));
104
                    $db->query("DROP TABLE ".$db->prefix($ct));
105
                }
105
                }
106
                $ret = "<p>".sprintf(_MD_AM_FAILINS, "<b>".$module->name()."</b>")."&nbsp;"._MD_AM_ERRORSC."<br />";
106
                $ret = "<p>".sprintf(_MD_AM_FAILINS, "<b>".$module->name()."</b>")."&nbsp;"._MD_AM_ERRORSC."<br />";
107
                foreach ( $errs as $err ) {
107
                foreach ( $errs as $err ) {
108
                    $ret .= " - ".$err."<br />";
108
                    $ret .= " - ".$err."<br />";
109
                }
109
                }
110
                $ret .= "</p>";
110
                $ret .= "</p>";
111
                unset($module);
111
                unset($module);
112
                unset($created_tables);
112
                unset($created_tables);
113
                unset($errs);
113
                unset($errs);
114
                unset($msgs);
114
                unset($msgs);
115
                return $ret;
115
                return $ret;
116
            } else {
116
            } else {
117
                $newmid = $module->getVar('mid');
117
                $newmid = $module->getVar('mid');
118
                unset($created_tables);
118
                unset($created_tables);
119
                $msgs[] = 'Module data inserted successfully. Module ID: <b>'.icms_conv_nr2local($newmid).'</b>';
119
                $msgs[] = 'Module data inserted successfully. Module ID: <b>'.icms_conv_nr2local($newmid).'</b>';
120
                $tplfile_handler =& xoops_gethandler('tplfile');
120
                $tplfile_handler =& xoops_gethandler('tplfile');
121
                $templates = $module->getInfo('templates');
121
                $templates = $module->getInfo('templates');
122
                if ($templates != false) {
122
                if ($templates != false) {
123
                    $msgs[] = 'Adding templates...';
123
                    $msgs[] = 'Adding templates...';
124
                    foreach ($templates as $tpl) {
124
                    foreach ($templates as $tpl) {
125
                        $tplfile =& $tplfile_handler->create();
125
                        $tplfile =& $tplfile_handler->create();
126
                        $tpldata =& xoops_module_gettemplate($dirname, $tpl['file']);
126
                        $tpldata =& xoops_module_gettemplate($dirname, $tpl['file']);
127
                        $tplfile->setVar('tpl_source', $tpldata, true);
127
                        $tplfile->setVar('tpl_source', $tpldata, true);
128
                        $tplfile->setVar('tpl_refid', $newmid);
128
                        $tplfile->setVar('tpl_refid', $newmid);
129
 
129
 
130
                        $tplfile->setVar('tpl_tplset', 'default');
130
                        $tplfile->setVar('tpl_tplset', 'default');
131
                        $tplfile->setVar('tpl_file', $tpl['file']);
131
                        $tplfile->setVar('tpl_file', $tpl['file']);
132
                        $tplfile->setVar('tpl_desc', $tpl['description'], true);
132
                        $tplfile->setVar('tpl_desc', $tpl['description'], true);
133
                        $tplfile->setVar('tpl_module', $dirname);
133
                        $tplfile->setVar('tpl_module', $dirname);
134
                        $tplfile->setVar('tpl_lastmodified', time());
134
                        $tplfile->setVar('tpl_lastmodified', time());
135
                        $tplfile->setVar('tpl_lastimported', 0);
135
                        $tplfile->setVar('tpl_lastimported', 0);
136
                        $tplfile->setVar('tpl_type', 'module');
136
                        $tplfile->setVar('tpl_type', 'module');
137
                        if (!$tplfile_handler->insert($tplfile)) {
137
                        if (!$tplfile_handler->insert($tplfile)) {
138
                            $msgs[] = sprintf('&nbsp;&nbsp;<span style="color:#ff0000;">'._MD_AM_FAILINSTEMPFILE.'</span>', $tpl['file']);
138
                            $msgs[] = sprintf('&nbsp;&nbsp;<span style="color:#ff0000;">'._MD_AM_FAILINSTEMPFILE.'</span>', $tpl['file']);
139
                        } else {
139
                        } else {
140
                            $newtplid = $tplfile->getVar('tpl_id');
140
                            $newtplid = $tplfile->getVar('tpl_id');
141
                            $msgs[] = sprintf('&nbsp;&nbsp;'._MD_AM_INSTEMPFILE, $tpl['file'], $newtplid);
141
                            $msgs[] = sprintf('&nbsp;&nbsp;'._MD_AM_INSTEMPFILE, $tpl['file'], $newtplid);
142
                            
142
                            
143
                            // generate compiled file
143
                            // generate compiled file
144
                            include_once XOOPS_ROOT_PATH.'/class/template.php';
144
                            include_once XOOPS_ROOT_PATH.'/class/template.php';
145
                            if (!xoops_template_touch($newtplid)) {
145
                            if (!xoops_template_touch($newtplid)) {
146
                                $msgs[] = sprintf('&nbsp;&nbsp;<span style="color:#ff0000;">'._MD_AM_FAILCOMPTEMPFILE.'</span>', $tpl['file']);
146
                                $msgs[] = sprintf('&nbsp;&nbsp;<span style="color:#ff0000;">'._MD_AM_FAILCOMPTEMPFILE.'</span>', $tpl['file']);
147
                            } else {
147
                            } else {
148
                                $msgs[] = sprintf('&nbsp;&nbsp;'._MD_AM_COMPTEMPFILE, $tpl['file']);
148
                                $msgs[] = sprintf('&nbsp;&nbsp;'._MD_AM_COMPTEMPFILE, $tpl['file']);
149
                            }
149
                            }
150
                        }
150
                        }
151
                        unset($tpldata);
151
                        unset($tpldata);
152
                    }
152
                    }
153
                }
153
                }
154
                include_once XOOPS_ROOT_PATH.'/class/template.php';
154
                include_once XOOPS_ROOT_PATH.'/class/template.php';
155
                xoops_template_clear_module_cache($newmid);
155
                xoops_template_clear_module_cache($newmid);
156
                $blocks = $module->getInfo('blocks');
156
                $blocks = $module->getInfo('blocks');
157
                if ($blocks != false) {
157
                if ($blocks != false) {
158
                    $msgs[] = 'Adding blocks...';
158
                    $msgs[] = 'Adding blocks...';
159
                    foreach ($blocks as $blockkey => $block) {
159
                    foreach ($blocks as $blockkey => $block) {
160
                        // break the loop if missing block config
160
                        // break the loop if missing block config
161
                        if (!isset($block['file']) || !isset($block['show_func'])) {
161
                        if (!isset($block['file']) || !isset($block['show_func'])) {
162
                            break;
162
                            break;
163
                        }
163
                        }
164
                        $options = '';
164
                        $options = '';
165
                        if (!empty($block['options'])) {
165
                        if (!empty($block['options'])) {
166
                            $options = trim($block['options']);
166
                            $options = trim($block['options']);
167
                        }
167
                        }
168
                        $newbid = $db->genId($db->prefix('newblocks').'_bid_seq');
168
                        $newbid = $db->genId($db->prefix('newblocks').'_bid_seq');
169
                        $edit_func = isset($block['edit_func']) ? trim($block['edit_func']) : '';
169
                        $edit_func = isset($block['edit_func']) ? trim($block['edit_func']) : '';
170
                        $template = '';
170
                        $template = '';
171
                        if ((isset($block['template']) && trim($block['template']) != '')) {
171
                        if ((isset($block['template']) && trim($block['template']) != '')) {
172
                            $content =& xoops_module_gettemplate($dirname, $block['template'], true);
172
                            $content =& xoops_module_gettemplate($dirname, $block['template'], true);
173
                        }
173
                        }
174
                        if (empty($content)) {
174
                        if (empty($content)) {
175
                            $content = '';
175
                            $content = '';
176
                        } else {
176
                        } else {
177
                            $template = trim($block['template']);
177
                            $template = trim($block['template']);
178
                        }
178
                        }
179
                        $block_name = addslashes(trim($block['name']));
179
                        $block_name = addslashes(trim($block['name']));
180
                        $sql = "INSERT INTO ".$db->prefix("newblocks")." (bid, mid, func_num, options, name, title, content, side, weight, visible, block_type, c_type, isactive, dirname, func_file, show_func, edit_func, template, bcachetime, last_modified) VALUES ('".intval($newbid)."', '".intval($newmid)."', '".intval($blockkey)."', '$options', '".$block_name."','".$block_name."', '', '1', '0', '0', 'M', 'H', '1', '".addslashes($dirname)."', '".addslashes(trim($block['file']))."', '".addslashes(trim($block['show_func']))."', '".addslashes($edit_func)."', '".$template."', '0', '".time()."')";
180
                        $sql = "INSERT INTO ".$db->prefix("newblocks")." (bid, mid, func_num, options, name, title, content, side, weight, visible, block_type, c_type, isactive, dirname, func_file, show_func, edit_func, template, bcachetime, last_modified) VALUES ('".intval($newbid)."', '".intval($newmid)."', '".intval($blockkey)."', '$options', '".$block_name."','".$block_name."', '', '1', '0', '0', 'M', 'H', '1', '".addslashes($dirname)."', '".addslashes(trim($block['file']))."', '".addslashes(trim($block['show_func']))."', '".addslashes($edit_func)."', '".$template."', '0', '".time()."')";
181
                        if (!$db->query($sql)) {
181
                        if (!$db->query($sql)) {
182
                            $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add block <b>'.$block['name'].'</b> to the database! Database error: <b>'.$db->error().'</b></span>';
182
                            $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add block <b>'.$block['name'].'</b> to the database! Database error: <b>'.$db->error().'</b></span>';
183
                        } else {
183
                        } else {
184
                            if (empty($newbid)) {
184
                            if (empty($newbid)) {
185
                                $newbid = $db->getInsertId();
185
                                $newbid = $db->getInsertId();
186
                            }
186
                            }
187
                            $msgs[] = '&nbsp;&nbsp;Block <b>'.$block['name'].'</b> added. Block ID: <b>'.icms_conv_nr2local($newbid).'</b>';
187
                            $msgs[] = '&nbsp;&nbsp;Block <b>'.$block['name'].'</b> added. Block ID: <b>'.icms_conv_nr2local($newbid).'</b>';
188
                            $sql = 'INSERT INTO '.$db->prefix('block_module_link').' (block_id, module_id,page_id) VALUES ('.intval($newbid).', 0,1)';
188
                            $sql = 'INSERT INTO '.$db->prefix('block_module_link').' (block_id, module_id,page_id) VALUES ('.intval($newbid).', 0,1)';
189
                            $db->query($sql);
189
                            $db->query($sql);
190
                            if ($template != '') {
190
                            if ($template != '') {
191
                                $tplfile =& $tplfile_handler->create();
191
                                $tplfile =& $tplfile_handler->create();
192
                                $tplfile->setVar('tpl_refid', $newbid);
192
                                $tplfile->setVar('tpl_refid', $newbid);
193
                                $tplfile->setVar('tpl_source', $content, true);
193
                                $tplfile->setVar('tpl_source', $content, true);
194
                                $tplfile->setVar('tpl_tplset', 'default');
194
                                $tplfile->setVar('tpl_tplset', 'default');
195
                                $tplfile->setVar('tpl_file', $block['template']);
195
                                $tplfile->setVar('tpl_file', $block['template']);
196
                                $tplfile->setVar('tpl_module', $dirname);
196
                                $tplfile->setVar('tpl_module', $dirname);
197
                                $tplfile->setVar('tpl_type', 'block');
197
                                $tplfile->setVar('tpl_type', 'block');
198
                                $tplfile->setVar('tpl_desc', $block['description'], true);
198
                                $tplfile->setVar('tpl_desc', $block['description'], true);
199
                                $tplfile->setVar('tpl_lastimported', 0);
199
                                $tplfile->setVar('tpl_lastimported', 0);
200
                                $tplfile->setVar('tpl_lastmodified', time());
200
                                $tplfile->setVar('tpl_lastmodified', time());
201
                                if (!$tplfile_handler->insert($tplfile)) {
201
                                if (!$tplfile_handler->insert($tplfile)) {
202
                                    $msgs[] = sprintf('&nbsp;&nbsp;<span style="color:#ff0000;">'._MD_AM_FAILINSTEMP.'</span>', $block['template']);
202
                                    $msgs[] = sprintf('&nbsp;&nbsp;<span style="color:#ff0000;">'._MD_AM_FAILINSTEMP.'</span>', $block['template']);
203
                                } else {
203
                                } else {
204
                                    $newtplid = $tplfile->getVar('tpl_id');
204
                                    $newtplid = $tplfile->getVar('tpl_id');
205
                                    $msgs[] = '&nbsp;&nbsp;Template <b>'.$block['template'].'</b> added to the database. (ID: <b>'.icms_conv_nr2local($newtplid).'</b>)';
205
                                    $msgs[] = '&nbsp;&nbsp;Template <b>'.$block['template'].'</b> added to the database. (ID: <b>'.icms_conv_nr2local($newtplid).'</b>)';
206
                                    // generate compiled file
206
                                    // generate compiled file
207
                                    include_once XOOPS_ROOT_PATH.'/class/template.php';
207
                                    include_once XOOPS_ROOT_PATH.'/class/template.php';
208
                                    if (!xoops_template_touch($newtplid)) {
208
                                    if (!xoops_template_touch($newtplid)) {
209
                                        $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Failed compiling template <b>'.$block['template'].'</b>.</span>';
209
                                        $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Failed compiling template <b>'.$block['template'].'</b>.</span>';
210
                                    } else {
210
                                    } else {
211
                                        $msgs[] = '&nbsp;&nbsp;Template <b>'.$block['template'].'</b> compiled.</span>';
211
                                        $msgs[] = '&nbsp;&nbsp;Template <b>'.$block['template'].'</b> compiled.</span>';
212
                                    }
212
                                    }
213
                                }
213
                                }
214
                            }
214
                            }
215
                        }
215
                        }
216
                        unset($content);
216
                        unset($content);
217
                    }
217
                    }
218
                    unset($blocks);
218
                    unset($blocks);
219
                }
219
                }
220
                $configs = $module->getInfo('config');
220
                $configs = $module->getInfo('config');
221
                if ($configs != false) {
221
                if ($configs != false) {
222
                    if ($module->getVar('hascomments') != 0) {
222
                    if ($module->getVar('hascomments') != 0) {
223
                        include_once(XOOPS_ROOT_PATH.'/include/comment_constants.php');
223
                        include_once(XOOPS_ROOT_PATH.'/include/comment_constants.php');
224
                        array_push($configs, array('name' => 'com_rule', 'title' => '_CM_COMRULES', 'description' => '', 'formtype' => 'select', 'valuetype' => 'int', 'default' => 1, 'options' => array('_CM_COMNOCOM' => XOOPS_COMMENT_APPROVENONE, '_CM_COMAPPROVEALL' => XOOPS_COMMENT_APPROVEALL, '_CM_COMAPPROVEUSER' => XOOPS_COMMENT_APPROVEUSER, '_CM_COMAPPROVEADMIN' => XOOPS_COMMENT_APPROVEADMIN)));
224
                        array_push($configs, array('name' => 'com_rule', 'title' => '_CM_COMRULES', 'description' => '', 'formtype' => 'select', 'valuetype' => 'int', 'default' => 1, 'options' => array('_CM_COMNOCOM' => XOOPS_COMMENT_APPROVENONE, '_CM_COMAPPROVEALL' => XOOPS_COMMENT_APPROVEALL, '_CM_COMAPPROVEUSER' => XOOPS_COMMENT_APPROVEUSER, '_CM_COMAPPROVEADMIN' => XOOPS_COMMENT_APPROVEADMIN)));
225
                        array_push($configs, array('name' => 'com_anonpost', 'title' => '_CM_COMANONPOST', 'description' => '', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 0));
225
                        array_push($configs, array('name' => 'com_anonpost', 'title' => '_CM_COMANONPOST', 'description' => '', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 0));
226
                    }
226
                    }
227
                } else {
227
                } else {
228
                    if ($module->getVar('hascomments') != 0) {
228
                    if ($module->getVar('hascomments') != 0) {
229
                        $configs = array();
229
                        $configs = array();
230
                        include_once(XOOPS_ROOT_PATH.'/include/comment_constants.php');
230
                        include_once(XOOPS_ROOT_PATH.'/include/comment_constants.php');
231
                        $configs[] = array('name' => 'com_rule', 'title' => '_CM_COMRULES', 'description' => '', 'formtype' => 'select', 'valuetype' => 'int', 'default' => 1, 'options' => array('_CM_COMNOCOM' => XOOPS_COMMENT_APPROVENONE, '_CM_COMAPPROVEALL' => XOOPS_COMMENT_APPROVEALL, '_CM_COMAPPROVEUSER' => XOOPS_COMMENT_APPROVEUSER, '_CM_COMAPPROVEADMIN' => XOOPS_COMMENT_APPROVEADMIN));
231
                        $configs[] = array('name' => 'com_rule', 'title' => '_CM_COMRULES', 'description' => '', 'formtype' => 'select', 'valuetype' => 'int', 'default' => 1, 'options' => array('_CM_COMNOCOM' => XOOPS_COMMENT_APPROVENONE, '_CM_COMAPPROVEALL' => XOOPS_COMMENT_APPROVEALL, '_CM_COMAPPROVEUSER' => XOOPS_COMMENT_APPROVEUSER, '_CM_COMAPPROVEADMIN' => XOOPS_COMMENT_APPROVEADMIN));
232
                        $configs[] = array('name' => 'com_anonpost', 'title' => '_CM_COMANONPOST', 'description' => '', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 0);
232
                        $configs[] = array('name' => 'com_anonpost', 'title' => '_CM_COMANONPOST', 'description' => '', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 0);
233
                    }
233
                    }
234
                }
234
                }
235
                // RMV-NOTIFY
235
                // RMV-NOTIFY
236
                if ($module->getVar('hasnotification') != 0) {
236
                if ($module->getVar('hasnotification') != 0) {
237
                    if (empty($configs)) {
237
                    if (empty($configs)) {
238
                        $configs = array();
238
                        $configs = array();
239
                    }
239
                    }
240
                    // Main notification options
240
                    // Main notification options
241
                    include_once XOOPS_ROOT_PATH . '/include/notification_constants.php';
241
                    include_once XOOPS_ROOT_PATH . '/include/notification_constants.php';
242
                    include_once XOOPS_ROOT_PATH . '/include/notification_functions.php';
242
                    include_once XOOPS_ROOT_PATH . '/include/notification_functions.php';
243
                    $options = array();
243
                    $options = array();
244
                    $options['_NOT_CONFIG_DISABLE'] = XOOPS_NOTIFICATION_DISABLE;
244
                    $options['_NOT_CONFIG_DISABLE'] = XOOPS_NOTIFICATION_DISABLE;
245
                    $options['_NOT_CONFIG_ENABLEBLOCK'] = XOOPS_NOTIFICATION_ENABLEBLOCK;
245
                    $options['_NOT_CONFIG_ENABLEBLOCK'] = XOOPS_NOTIFICATION_ENABLEBLOCK;
246
                    $options['_NOT_CONFIG_ENABLEINLINE'] = XOOPS_NOTIFICATION_ENABLEINLINE;
246
                    $options['_NOT_CONFIG_ENABLEINLINE'] = XOOPS_NOTIFICATION_ENABLEINLINE;
247
                    $options['_NOT_CONFIG_ENABLEBOTH'] = XOOPS_NOTIFICATION_ENABLEBOTH;
247
                    $options['_NOT_CONFIG_ENABLEBOTH'] = XOOPS_NOTIFICATION_ENABLEBOTH;
248
 
248
 
249
                    //$configs[] = array ('name' => 'notification_enabled', 'title' => '_NOT_CONFIG_ENABLED', 'description' => '_NOT_CONFIG_ENABLEDDSC', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 1);
249
                    //$configs[] = array ('name' => 'notification_enabled', 'title' => '_NOT_CONFIG_ENABLED', 'description' => '_NOT_CONFIG_ENABLEDDSC', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 1);
250
                    $configs[] = array ('name' => 'notification_enabled', 'title' => '_NOT_CONFIG_ENABLE', 'description' => '_NOT_CONFIG_ENABLEDSC', 'formtype' => 'select', 'valuetype' => 'int', 'default' => XOOPS_NOTIFICATION_ENABLEBOTH, 'options' => $options);
250
                    $configs[] = array ('name' => 'notification_enabled', 'title' => '_NOT_CONFIG_ENABLE', 'description' => '_NOT_CONFIG_ENABLEDSC', 'formtype' => 'select', 'valuetype' => 'int', 'default' => XOOPS_NOTIFICATION_ENABLEBOTH, 'options' => $options);
251
                    // Event-specific notification options
251
                    // Event-specific notification options
252
                    // FIXME: doesn't work when update module... can't read back the array of options properly...  " changing to &quot;
252
                    // FIXME: doesn't work when update module... can't read back the array of options properly...  " changing to &quot;
253
                    $options = array();
253
                    $options = array();
254
                    $categories =& notificationCategoryInfo('',$module->getVar('mid'));
254
                    $categories =& notificationCategoryInfo('',$module->getVar('mid'));
255
                    foreach ($categories as $category) {
255
                    foreach ($categories as $category) {
256
                        $events =& notificationEvents ($category['name'], false, $module->getVar('mid'));
256
                        $events =& notificationEvents ($category['name'], false, $module->getVar('mid'));
257
                        foreach ($events as $event) {
257
                        foreach ($events as $event) {
258
                            if (!empty($event['invisible'])) {
258
                            if (!empty($event['invisible'])) {
259
                                continue;
259
                                continue;
260
                            }
260
                            }
261
                            $option_name = $category['title'] . ' : ' . $event['title'];
261
                            $option_name = $category['title'] . ' : ' . $event['title'];
262
                            $option_value = $category['name'] . '-' . $event['name'];
262
                            $option_value = $category['name'] . '-' . $event['name'];
263
                            $options[$option_name] = $option_value;
263
                            $options[$option_name] = $option_value;
264
                        }
264
                        }
265
                    }
265
                    }
266
                    $configs[] = array ('name' => 'notification_events', 'title' => '_NOT_CONFIG_EVENTS', 'description' => '_NOT_CONFIG_EVENTSDSC', 'formtype' => 'select_multi', 'valuetype' => 'array', 'default' => array_values($options), 'options' => $options);
266
                    $configs[] = array ('name' => 'notification_events', 'title' => '_NOT_CONFIG_EVENTS', 'description' => '_NOT_CONFIG_EVENTSDSC', 'formtype' => 'select_multi', 'valuetype' => 'array', 'default' => array_values($options), 'options' => $options);
267
                }
267
                }
268
 
268
 
269
                if ($configs != false) {
269
                if ($configs != false) {
270
                    $msgs[] = 'Adding module config data...';
270
                    $msgs[] = 'Adding module config data...';
271
                    $config_handler =& xoops_gethandler('config');
271
                    $config_handler =& xoops_gethandler('config');
272
                    $order = 0;
272
                    $order = 0;
273
                    foreach ($configs as $config) {
273
                    foreach ($configs as $config) {
274
                        $confobj =& $config_handler->createConfig();
274
                        $confobj =& $config_handler->createConfig();
275
                        $confobj->setVar('conf_modid', $newmid);
275
                        $confobj->setVar('conf_modid', $newmid);
276
                        $confobj->setVar('conf_catid', 0);
276
                        $confobj->setVar('conf_catid', 0);
277
                        $confobj->setVar('conf_name', $config['name']);
277
                        $confobj->setVar('conf_name', $config['name']);
278
                        $confobj->setVar('conf_title', $config['title'], true);
278
                        $confobj->setVar('conf_title', $config['title'], true);
279
                        $confobj->setVar('conf_desc', $config['description'], true);
279
                        $confobj->setVar('conf_desc', $config['description'], true);
280
                        $confobj->setVar('conf_formtype', $config['formtype']);
280
                        $confobj->setVar('conf_formtype', $config['formtype']);
281
                        $confobj->setVar('conf_valuetype', $config['valuetype']);
281
                        $confobj->setVar('conf_valuetype', $config['valuetype']);
282
                        $confobj->setConfValueForInput($config['default'], true);
282
                        $confobj->setConfValueForInput($config['default'], true);
283
                        //$confobj->setVar('conf_value', $config['default'], true);
283
                        //$confobj->setVar('conf_value', $config['default'], true);
284
                        $confobj->setVar('conf_order', $order);
284
                        $confobj->setVar('conf_order', $order);
285
                        $confop_msgs = '';
285
                        $confop_msgs = '';
286
                        if (isset($config['options']) && is_array($config['options'])) {
286
                        if (isset($config['options']) && is_array($config['options'])) {
287
                            foreach ($config['options'] as $key => $value) {
287
                            foreach ($config['options'] as $key => $value) {
288
                                $confop =& $config_handler->createConfigOption();
288
                                $confop =& $config_handler->createConfigOption();
289
                                $confop->setVar('confop_name', $key, true);
289
                                $confop->setVar('confop_name', $key, true);
290
                                $confop->setVar('confop_value', $value, true);
290
                                $confop->setVar('confop_value', $value, true);
291
                                $confobj->setConfOptions($confop);
291
                                $confobj->setConfOptions($confop);
292
                                $confop_msgs .= '<br />&nbsp;&nbsp;&nbsp;&nbsp;Config option added. Name: <b>'.$key.'</b> Value: <b>'.$value.'</b>';
292
                                $confop_msgs .= '<br />&nbsp;&nbsp;&nbsp;&nbsp;Config option added. Name: <b>'.$key.'</b> Value: <b>'.$value.'</b>';
293
                                unset($confop);
293
                                unset($confop);
294
                            }
294
                            }
295
                        }
295
                        }
296
                        $order++;
296
                        $order++;
297
                        if ($config_handler->insertConfig($confobj) != false) {
297
                        if ($config_handler->insertConfig($confobj) != false) {
298
                            $msgs[] = '&nbsp;&nbsp;Config <b>'.$config['name'].'</b> added to the database.'.$confop_msgs;
298
                            $msgs[] = '&nbsp;&nbsp;Config <b>'.$config['name'].'</b> added to the database.'.$confop_msgs;
299
                        } else {
299
                        } else {
300
                            $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not insert config <b>'.$config['name'].'</b> to the database.</span>';
300
                            $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not insert config <b>'.$config['name'].'</b> to the database.</span>';
301
                        }
301
                        }
302
                        unset($confobj);
302
                        unset($confobj);
303
                    }
303
                    }
304
                    unset($configs);
304
                    unset($configs);
305
                }
305
                }
306
            }
306
            }
307
                if ($module->getInfo('hasMain')) {
307
                if ($module->getInfo('hasMain')) {
308
                    $groups = array(XOOPS_GROUP_ADMIN, XOOPS_GROUP_USERS, XOOPS_GROUP_ANONYMOUS);
308
                    $groups = array(XOOPS_GROUP_ADMIN, XOOPS_GROUP_USERS, XOOPS_GROUP_ANONYMOUS);
309
                } else {
309
                } else {
310
                    $groups = array(XOOPS_GROUP_ADMIN);
310
                    $groups = array(XOOPS_GROUP_ADMIN);
311
                }
311
                }
312
            // retrieve all block ids for this module
312
            // retrieve all block ids for this module
313
            $icms_block_handler = xoops_gethandler('block');
313
            $icms_block_handler = xoops_gethandler('block');
314
            $blocks = $icms_block_handler->getByModule($newmid, false);
314
            $blocks = $icms_block_handler->getByModule($newmid, false);
315
            $msgs[] = 'Setting group rights...';
315
            $msgs[] = 'Setting group rights...';
316
            $gperm_handler =& xoops_gethandler('groupperm');
316
            $gperm_handler =& xoops_gethandler('groupperm');
317
            foreach ($groups as $mygroup) {
317
            foreach ($groups as $mygroup) {
318
                if ($gperm_handler->checkRight('module_admin', 0, $mygroup)) {
318
                if ($gperm_handler->checkRight('module_admin', 0, $mygroup)) {
319
                    $mperm =& $gperm_handler->create();
319
                    $mperm =& $gperm_handler->create();
320
                    $mperm->setVar('gperm_groupid', $mygroup);
320
                    $mperm->setVar('gperm_groupid', $mygroup);
321
                    $mperm->setVar('gperm_itemid', $newmid);
321
                    $mperm->setVar('gperm_itemid', $newmid);
322
                    $mperm->setVar('gperm_name', 'module_admin');
322
                    $mperm->setVar('gperm_name', 'module_admin');
323
                    $mperm->setVar('gperm_modid', 1);
323
                    $mperm->setVar('gperm_modid', 1);
324
                    if (!$gperm_handler->insert($mperm)) {
324
                    if (!$gperm_handler->insert($mperm)) {
325
                        $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add admin access right for Group ID <b>'.icms_conv_nr2local($mygroup).'</b></span>';
325
                        $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add admin access right for Group ID <b>'.icms_conv_nr2local($mygroup).'</b></span>';
326
                    } else {
326
                    } else {
327
                        $msgs[] = '&nbsp;&nbsp;Added admin access right for Group ID <b>'.icms_conv_nr2local($mygroup).'</b>';
327
                        $msgs[] = '&nbsp;&nbsp;Added admin access right for Group ID <b>'.icms_conv_nr2local($mygroup).'</b>';
328
                    }
328
                    }
329
                    unset($mperm);
329
                    unset($mperm);
330
                }
330
                }
331
                $mperm =& $gperm_handler->create();
331
                $mperm =& $gperm_handler->create();
332
                $mperm->setVar('gperm_groupid', $mygroup);
332
                $mperm->setVar('gperm_groupid', $mygroup);
333
                $mperm->setVar('gperm_itemid', $newmid);
333
                $mperm->setVar('gperm_itemid', $newmid);
334
                $mperm->setVar('gperm_name', 'module_read');
334
                $mperm->setVar('gperm_name', 'module_read');
335
                $mperm->setVar('gperm_modid', 1);
335
                $mperm->setVar('gperm_modid', 1);
336
                if (!$gperm_handler->insert($mperm)) {
336
                if (!$gperm_handler->insert($mperm)) {
337
                    $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add user access right for Group ID: <b>'.icms_conv_nr2local($mygroup).'</b></span>';
337
                    $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add user access right for Group ID: <b>'.icms_conv_nr2local($mygroup).'</b></span>';
338
                } else {
338
                } else {
339
                    $msgs[] = '&nbsp;&nbsp;Added user access right for Group ID: <b>'.icms_conv_nr2local($mygroup).'</b>';
339
                    $msgs[] = '&nbsp;&nbsp;Added user access right for Group ID: <b>'.icms_conv_nr2local($mygroup).'</b>';
340
                }
340
                }
341
                unset($mperm);
341
                unset($mperm);
342
                foreach ($blocks as $blc) {
342
                foreach ($blocks as $blc) {
343
                    $bperm =& $gperm_handler->create();
343
                    $bperm =& $gperm_handler->create();
344
                    $bperm->setVar('gperm_groupid', $mygroup);
344
                    $bperm->setVar('gperm_groupid', $mygroup);
345
                    $bperm->setVar('gperm_itemid', $blc);
345
                    $bperm->setVar('gperm_itemid', $blc);
346
                    $bperm->setVar('gperm_name', 'block_read');
346
                    $bperm->setVar('gperm_name', 'block_read');
347
                    $bperm->setVar('gperm_modid', 1);
347
                    $bperm->setVar('gperm_modid', 1);
348
                    if (!$gperm_handler->insert($bperm)) {
348
                    if (!$gperm_handler->insert($bperm)) {
349
                        $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add block access right. Block ID: <b>'.icms_conv_nr2local($blc).'</b> Group ID: <b>'.icms_conv_nr2local($mygroup).'</b></span>';
349
                        $msgs[] = '&nbsp;&nbsp;<span style="color:#ff0000;">ERROR: Could not add block access right. Block ID: <b>'.icms_conv_nr2local($blc).'</b> Group ID: <b>'.icms_conv_nr2local($mygroup).'</b></span>';
350
                    } else {
350
                    } else {
351
                        $msgs[] = '&nbsp;&nbsp;Added block access right. Block ID: <b>'.icms_conv_nr2local($blc).'</b> Group ID: <b>'.icms_conv_nr2local($mygroup).'</b>';
351
                        $msgs[] = '&nbsp;&nbsp;Added block access right. Block ID: <b>'.icms_conv_nr2local($blc).'</b> Group ID: <b>'.icms_conv_nr2local($mygroup).'</b>';
352
                    }
352
                    }
353
                    unset($bperm);
353
                    unset($bperm);
354
                }
354
                }
355
            }
355
            }
356
            unset($blocks);
356
            unset($blocks);
357
            unset($groups);
357
            unset($groups);
358
 
358
 
359
            // execute module specific install script if any
359
            // execute module specific install script if any
360
            $install_script = $module->getInfo('onInstall');
360
            $install_script = $module->getInfo('onInstall');
361
            $ModName = $module->getInfo('modname');
361
            $ModName = $module->getInfo('modname');
362
            if (false != $install_script && trim($install_script) != '') {
362
            if (false != $install_script && trim($install_script) != '') {
363
                include_once XOOPS_ROOT_PATH.'/modules/'.$dirname.'/'.trim($install_script);
363
                include_once XOOPS_ROOT_PATH.'/modules/'.$dirname.'/'.trim($install_script);
364
                if (function_exists('xoops_module_install_'.$dirname)) {
364
                if (function_exists('xoops_module_install_'.$dirname)) {
365
                    $func = 'xoops_module_install_'.$dirname;
365
                    $func = 'xoops_module_install_'.$dirname;
366
                    if ( !( $lastmsg = $func($module) ) ) {
366
                    if ( !( $lastmsg = $func($module) ) ) {
367
                        $msgs[] = sprintf(_MD_AM_FAIL_EXEC, $func);
367
                        $msgs[] = sprintf(_MD_AM_FAIL_EXEC, $func);
368
                    } else {
368
                    } else {
369
                        $msgs[] = sprintf(_MD_AM_FUNCT_EXEC, $func);
369
                        $msgs[] = sprintf(_MD_AM_FUNCT_EXEC, $func);
370
                        if ( is_string( $lastmsg ) ) {
370
                        if ( is_string( $lastmsg ) ) {
371
                            $msgs[] = $lastmsg;
371
                            $msgs[] = $lastmsg;
372
                        }
372
                        }
373
                    }
373
                    }
374
                }elseif (function_exists('icms_module_install_'.$ModName)) {
374
                }elseif (function_exists('icms_module_install_'.$ModName)) {
375
                    $func = 'icms_module_install_'.$ModName;
375
                    $func = 'icms_module_install_'.$ModName;
376
                    if ( !( $lastmsg = $func($module) ) ) {
376
                    if ( !( $lastmsg = $func($module) ) ) {
377
                        $msgs[] = sprintf(_MD_AM_FAIL_EXEC, $func);
377
                        $msgs[] = sprintf(_MD_AM_FAIL_EXEC, $func);
378
                    } else {
378
                    } else {
379
                        $msgs[] = sprintf(_MD_AM_FUNCT_EXEC, $func);
379
                        $msgs[] = sprintf(_MD_AM_FUNCT_EXEC, $func);
380
                        if ( is_string( $lastmsg ) ) {
380
                        if ( is_string( $lastmsg ) ) {
381
                            $msgs[] = $lastmsg;
381
                            $msgs[] = $lastmsg;
382
                        }
382
                        }
383
                    }
383
                    }
384
                }
384
                }
385
            }
385
            }
386
 
386
 
387
            $ret = '<p><code>';
387
            $ret = '<p><code>';
388
            foreach ($msgs as $m) {
388
            foreach ($msgs as $m) {
389
                $ret .= $m.'<br />';
389
                $ret .= $m.'<br />';
390
            }
390
            }
391
            unset($msgs);
391
            unset($msgs);
392
            unset($errs);
392
            unset($errs);
393
            $ret .= '</code><br />'.sprintf(_MD_AM_OKINS, "<b>".$module->getVar('name')."</b>").'</p>';
393
            $ret .= '</code><br />'.sprintf(_MD_AM_OKINS, "<b>".$module->getVar('name')."</b>").'</p>';
394
            unset($module);
394
            unset($module);
395
            return $ret;
395
            return $ret;
396
        } else {
396
        } else {
397
            $ret = '<p>';
397
            $ret = '<p>';
398
            foreach ($errs as $er) {
398
            foreach ($errs as $er) {
399
                $ret .= '&nbsp;&nbsp;'.$er.'<br />';
399
                $ret .= '&nbsp;&nbsp;'.$er.'<br />';
400
            }
400
            }
401
            unset($msgs);
401
            unset($msgs);
402
            unset($errs);
402
            unset($errs);
403
            $ret .= '<br />'.sprintf(_MD_AM_FAILINS, '<b>'.$dirname.'</b>').'&nbsp;'._MD_AM_ERRORSC.'</p>';
403
            $ret .= '<br />'.sprintf(_MD_AM_FAILINS, '<b>'.$dirname.'</b>').'&nbsp;'._MD_AM_ERRORSC.'</p>';
404
            return $ret;
404
            return $ret;
405
        }
405
        }
406
    }
406
    }
407
    else {
407
    else {
408
        return "<p>".sprintf(_MD_AM_FAILINS, "<b>".$dirname."</b>")."&nbsp;"._MD_AM_ERRORSC."<br />&nbsp;&nbsp;".sprintf(_MD_AM_ALEXISTS, $dirname)."</p>";
408
        return "<p>".sprintf(_MD_AM_FAILINS, "<b>".$dirname."</b>")."&nbsp;"._MD_AM_ERRORSC."<br />&nbsp;&nbsp;".sprintf(_MD_AM_ALEXISTS, $dirname)."</p>";
409
    }
409
    }
410
}
410
}
411
 
411
 
412
function &xoops_module_gettemplate($dirname, $template, $block=false) {
412
function &xoops_module_gettemplate($dirname, $template, $block=false) {
413
    global $xoopsConfig;
413
    global $xoopsConfig;
414
    $ret = '';
414
    $ret = '';
415
    if ($block) {
415
    if ($block) {
416
        $path = XOOPS_ROOT_PATH.'/modules/'.$dirname.'/templates/blocks/'.$template;
416
        $path = XOOPS_ROOT_PATH.'/modules/'.$dirname.'/templates/blocks/'.$template;
417
    } else {
417
    } else {
418
        $path = XOOPS_ROOT_PATH.'/modules/'.$dirname.'/templates/'.$template;
418
        $path = XOOPS_ROOT_PATH.'/modules/'.$dirname.'/templates/'.$template;
419
    }
419
    }
420
    if (!file_exists($path)) {
420
    if (!file_exists($path)) {
421
        return $ret;
421
        return $ret;
422
    } else {
422
    } else {
423
        $lines = file($path);
423
        $lines = file($path);
424
    }
424
    }
425
    if (!$lines) {
425
    if (!$lines) {
426
        return $ret;
426
        return $ret;
427
    }
427
    }
428
    $count = count($lines);
428
    $count = count($lines);
429
    for ($i = 0; $i < $count; $i++) {
429
    for ($i = 0; $i < $count; $i++) {
430
        $ret .= str_replace("\n", "\r\n", str_replace("\r\n", "\n", $lines[$i]));
430
        $ret .= str_replace("\n", "\r\n", str_replace("\r\n", "\n", $lines[$i]));
431
    }
431
    }
432
    return $ret;
432
    return $ret;
433
}
433
}
434
 
434
 
435
/*
435
/*
88148815
105
 
105
 
106
 
106
 
107
#
107
#
108
# Dumping data for table `system_mimetypes`
108
# Dumping data for table `system_mimetype`
109
#
109
#
110
 
110
 
111
INSERT INTO system_mimetypes VALUES (1, 'bin', 'application/octet-stream', 'Binary File/Linux Executable', 0, 0);
111
INSERT INTO system_mimetype VALUES (1, 'bin', 'application/octet-stream', 'Binary File/Linux Executable');
112
INSERT INTO system_mimetypes VALUES (2, 'dms', 'application/octet-stream', 'Amiga DISKMASHER Compressed Archive', 0, 0);
112
INSERT INTO system_mimetype VALUES (2, 'dms', 'application/octet-stream', 'Amiga DISKMASHER Compressed Archive');
113
INSERT INTO system_mimetypes VALUES (3, 'class', 'application/octet-stream', 'Java Bytecode', 0, 0);
113
INSERT INTO system_mimetype VALUES (3, 'class', 'application/octet-stream', 'Java Bytecode');
114
INSERT INTO system_mimetypes VALUES (4, 'so', 'application/octet-stream', 'UNIX Shared Library Function', 0, 0);
114
INSERT INTO system_mimetype VALUES (4, 'so', 'application/octet-stream', 'UNIX Shared Library Function');
115
INSERT INTO system_mimetypes VALUES (5, 'dll', 'application/octet-stream', 'Dynamic Link Library', 0, 0);
115
INSERT INTO system_mimetype VALUES (5, 'dll', 'application/octet-stream', 'Dynamic Link Library');
116
INSERT INTO system_mimetypes VALUES (6, 'hqx', 'application/binhex application/mac-binhex application/mac-binhex40', 'Macintosh BinHex 4 Compressed Archive', 0, 0);
116
INSERT INTO system_mimetype VALUES (6, 'hqx', 'application/binhex application/mac-binhex application/mac-binhex40', 'Macintosh BinHex 4 Compressed Archive');
117
INSERT INTO system_mimetypes VALUES (7, 'cpt', 'application/mac-compactpro application/compact_pro', 'Compact Pro Archive', 0, 0);
117
INSERT INTO system_mimetype VALUES (7, 'cpt', 'application/mac-compactpro application/compact_pro', 'Compact Pro Archive');
118
INSERT INTO system_mimetypes VALUES (8, 'lha', 'application/lha application/x-lha application/octet-stream application/x-compress application/x-compressed application/maclha', 'Compressed Archive File', 0, 0);
118
INSERT INTO system_mimetype VALUES (8, 'lha', 'application/lha application/x-lha application/octet-stream application/x-compress application/x-compressed application/maclha', 'Compressed Archive File');
119
INSERT INTO system_mimetypes VALUES (9, 'lzh', 'application/lzh application/x-lzh application/x-lha application/x-compress application/x-compressed application/x-lzh-archive zz-application/zz-winassoc-lzh application/maclha application/octet-stream', 'Compressed Archive File', 0, 0);
119
INSERT INTO system_mimetype VALUES (9, 'lzh', 'application/lzh application/x-lzh application/x-lha application/x-compress application/x-compressed application/x-lzh-archive zz-application/zz-winassoc-lzh application/maclha application/octet-stream', 'Compressed Archive File');
120
INSERT INTO system_mimetypes VALUES (10, 'sh', 'application/x-shar', 'UNIX shar Archive File', 0, 0);
120
INSERT INTO system_mimetype VALUES (10, 'sh', 'application/x-shar', 'UNIX shar Archive File');
121
INSERT INTO system_mimetypes VALUES (11, 'shar', 'application/x-shar', 'UNIX shar Archive File', 0, 0);
121
INSERT INTO system_mimetype VALUES (11, 'shar', 'application/x-shar', 'UNIX shar Archive File');
122
INSERT INTO system_mimetypes VALUES (12, 'tar', 'application/tar application/x-tar applicaton/x-gtar multipart/x-tar application/x-compress application/x-compressed', 'Tape Archive File', 0, 0);
122
INSERT INTO system_mimetype VALUES (12, 'tar', 'application/tar application/x-tar applicaton/x-gtar multipart/x-tar application/x-compress application/x-compressed', 'Tape Archive File');
123
INSERT INTO system_mimetypes VALUES (13, 'gtar', 'application/x-gtar', 'GNU tar Compressed File Archive', 0, 0);
123
INSERT INTO system_mimetype VALUES (13, 'gtar', 'application/x-gtar', 'GNU tar Compressed File Archive');
124
INSERT INTO system_mimetypes VALUES (14, 'ustar', 'application/x-ustar multipart/x-ustar', 'POSIX tar Compressed Archive', 0, 0);
124
INSERT INTO system_mimetype VALUES (14, 'ustar', 'application/x-ustar multipart/x-ustar', 'POSIX tar Compressed Archive');
125
INSERT INTO system_mimetypes VALUES (15, 'zip', 'application/zip application/x-zip application/x-zip-compressed application/octet-stream application/x-compress application/x-compressed multipart/x-zip', 'Compressed Archive File', 0, 0);
125
INSERT INTO system_mimetype VALUES (15, 'zip', 'application/zip application/x-zip application/x-zip-compressed application/octet-stream application/x-compress application/x-compressed multipart/x-zip', 'Compressed Archive File');
126
INSERT INTO system_mimetypes VALUES (16, 'exe', 'application/exe application/x-exe application/dos-exe application/x-winexe application/msdos-windows application/x-msdos-program', 'Executable File', 0, 0);
126
INSERT INTO system_mimetype VALUES (16, 'exe', 'application/exe application/x-exe application/dos-exe application/x-winexe application/msdos-windows application/x-msdos-program', 'Executable File');
127
INSERT INTO system_mimetypes VALUES (17, 'wmz', 'application/x-ms-wmz', 'Windows Media Compressed Skin File', 0, 0);
127
INSERT INTO system_mimetype VALUES (17, 'wmz', 'application/x-ms-wmz', 'Windows Media Compressed Skin File');
128
INSERT INTO system_mimetypes VALUES (18, 'wmd', 'application/x-ms-wmd', 'Windows Media Download File', 0, 0);
128
INSERT INTO system_mimetype VALUES (18, 'wmd', 'application/x-ms-wmd', 'Windows Media Download File');
129
INSERT INTO system_mimetypes VALUES (19, 'doc', 'application/msword application/doc appl/text application/vnd.msword application/vnd.ms-word application/winword application/word application/x-msw6 application/x-msword', 'Word Document', 1, 1);
129
INSERT INTO system_mimetype VALUES (19, 'doc', 'application/msword application/doc appl/text application/vnd.msword application/vnd.ms-word application/winword application/word application/x-msw6 application/x-msword', 'Word Document');
130
INSERT INTO system_mimetypes VALUES (20, 'pdf', 'application/pdf application/acrobat application/x-pdf applications/vnd.pdf text/pdf', 'Acrobat Portable Document Format', 1, 1);
130
INSERT INTO system_mimetype VALUES (20, 'pdf', 'application/pdf application/acrobat application/x-pdf applications/vnd.pdf text/pdf', 'Acrobat Portable Document Format');
131
INSERT INTO system_mimetypes VALUES (21, 'eps', 'application/eps application/postscript application/x-eps image/eps image/x-eps', 'Encapsulated PostScript', 0, 0);
131
INSERT INTO system_mimetype VALUES (21, 'eps', 'application/eps application/postscript application/x-eps image/eps image/x-eps', 'Encapsulated PostScript');
132
INSERT INTO system_mimetypes VALUES (22, 'ps', 'application/postscript application/ps application/x-postscript application/x-ps text/postscript', 'PostScript', 0, 0);
132
INSERT INTO system_mimetype VALUES (22, 'ps', 'application/postscript application/ps application/x-postscript application/x-ps text/postscript', 'PostScript');
133
INSERT INTO system_mimetypes VALUES (23, 'smi', 'application/smil', 'SMIL Multimedia', 0, 0);
133
INSERT INTO system_mimetype VALUES (23, 'smi', 'application/smil', 'SMIL Multimedia');
134
INSERT INTO system_mimetypes VALUES (24, 'smil', 'application/smil', 'Synchronized Multimedia Integration Language', 0, 0);
134
INSERT INTO system_mimetype VALUES (24, 'smil', 'application/smil', 'Synchronized Multimedia Integration Language');
135
INSERT INTO system_mimetypes VALUES (25, 'wmlc', 'application/vnd.wap.wmlc ', 'Compiled WML Document', 0, 0);
135
INSERT INTO system_mimetype VALUES (25, 'wmlc', 'application/vnd.wap.wmlc ', 'Compiled WML Document');
136
INSERT INTO system_mimetypes VALUES (26, 'wmlsc', 'application/vnd.wap.wmlscriptc', 'Compiled WML Script', 0, 0);
136
INSERT INTO system_mimetype VALUES (26, 'wmlsc', 'application/vnd.wap.wmlscriptc', 'Compiled WML Script');
137
INSERT INTO system_mimetypes VALUES (27, 'vcd', 'application/x-cdlink', 'Virtual CD-ROM CD Image File', 0, 0);
137
INSERT INTO system_mimetype VALUES (27, 'vcd', 'application/x-cdlink', 'Virtual CD-ROM CD Image File');
138
INSERT INTO system_mimetypes VALUES (28, 'pgn', 'application/formstore', 'Picatinny Arsenal Electronic Formstore Form in TIFF Format', 0, 0);
138
INSERT INTO system_mimetype VALUES (28, 'pgn', 'application/formstore', 'Picatinny Arsenal Electronic Formstore Form in TIFF Format');
139
INSERT INTO system_mimetypes VALUES (29, 'cpio', 'application/x-cpio', 'UNIX CPIO Archive', 0, 0);
139
INSERT INTO system_mimetype VALUES (29, 'cpio', 'application/x-cpio', 'UNIX CPIO Archive');
140
INSERT INTO system_mimetypes VALUES (30, 'csh', 'application/x-csh', 'Csh Script', 0, 0);
140
INSERT INTO system_mimetype VALUES (30, 'csh', 'application/x-csh', 'Csh Script');
141
INSERT INTO system_mimetypes VALUES (31, 'dcr', 'application/x-director', 'Shockwave Movie', 0, 0);
141
INSERT INTO system_mimetype VALUES (31, 'dcr', 'application/x-director', 'Shockwave Movie');
142
INSERT INTO system_mimetypes VALUES (32, 'dir', 'application/x-director', 'Macromedia Director Movie', 0, 0);
142
INSERT INTO system_mimetype VALUES (32, 'dir', 'application/x-director', 'Macromedia Director Movie');
143
INSERT INTO system_mimetypes VALUES (33, 'dxr', 'application/x-director application/vnd.dxr', 'Macromedia Director Protected Movie File', 0, 0);
143
INSERT INTO system_mimetype VALUES (33, 'dxr', 'application/x-director application/vnd.dxr', 'Macromedia Director Protected Movie File');
144
INSERT INTO system_mimetypes VALUES (34, 'dvi', 'application/x-dvi', 'TeX Device Independent Document', 0, 0);
144
INSERT INTO system_mimetype VALUES (34, 'dvi', 'application/x-dvi', 'TeX Device Independent Document');
145
INSERT INTO system_mimetypes VALUES (35, 'spl', 'application/x-futuresplash', 'Macromedia FutureSplash File', 0, 0);
145
INSERT INTO system_mimetype VALUES (35, 'spl', 'application/x-futuresplash', 'Macromedia FutureSplash File');
146
INSERT INTO system_mimetypes VALUES (36, 'hdf', 'application/x-hdf', 'Hierarchical Data Format File', 0, 0);
146
INSERT INTO system_mimetype VALUES (36, 'hdf', 'application/x-hdf', 'Hierarchical Data Format File');
147
INSERT INTO system_mimetypes VALUES (37, 'js', 'application/x-javascript text/javascript', 'JavaScript Source Code', 0, 0);
147
INSERT INTO system_mimetype VALUES (37, 'js', 'application/x-javascript text/javascript', 'JavaScript Source Code');
148
INSERT INTO system_mimetypes VALUES (38, 'skp', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Play File', 0, 0);
148
INSERT INTO system_mimetype VALUES (38, 'skp', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Play File');
149
INSERT INTO system_mimetypes VALUES (39, 'skd', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Design File', 0, 0);
149
INSERT INTO system_mimetype VALUES (39, 'skd', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Design File');
150
INSERT INTO system_mimetypes VALUES (40, 'skt', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Template File', 0, 0);
150
INSERT INTO system_mimetype VALUES (40, 'skt', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Template File');
151
INSERT INTO system_mimetypes VALUES (41, 'skm', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Mix File', 0, 0);
151
INSERT INTO system_mimetype VALUES (41, 'skm', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Mix File');
152
INSERT INTO system_mimetypes VALUES (42, 'latex', 'application/x-latex text/x-latex', 'LaTeX Source Document', 0, 0);
152
INSERT INTO system_mimetype VALUES (42, 'latex', 'application/x-latex text/x-latex', 'LaTeX Source Document');
153
INSERT INTO system_mimetypes VALUES (43, 'nc', 'application/x-netcdf text/x-cdf', 'Unidata netCDF Graphics', 0, 0);
153
INSERT INTO system_mimetype VALUES (43, 'nc', 'application/x-netcdf text/x-cdf', 'Unidata netCDF Graphics');
154
INSERT INTO system_mimetypes VALUES (44, 'cdf', 'application/cdf application/x-cdf application/netcdf application/x-netcdf text/cdf text/x-cdf', 'Channel Definition Format', 0, 0);
154
INSERT INTO system_mimetype VALUES (44, 'cdf', 'application/cdf application/x-cdf application/netcdf application/x-netcdf text/cdf text/x-cdf', 'Channel Definition Format');
155
INSERT INTO system_mimetypes VALUES (45, 'swf', 'application/x-shockwave-flash application/x-shockwave-flash2-preview application/futuresplash image/vnd.rn-realflash', 'Macromedia Flash Format File', 0, 0);
155
INSERT INTO system_mimetype VALUES (45, 'swf', 'application/x-shockwave-flash application/x-shockwave-flash2-preview application/futuresplash image/vnd.rn-realflash', 'Macromedia Flash Format File');
156
INSERT INTO system_mimetypes VALUES (46, 'sit', 'application/stuffit application/x-stuffit application/x-sit', 'StuffIt Compressed Archive File', 0, 0);
156
INSERT INTO system_mimetype VALUES (46, 'sit', 'application/stuffit application/x-stuffit application/x-sit', 'StuffIt Compressed Archive File');
157
INSERT INTO system_mimetypes VALUES (47, 'tcl', 'application/x-tcl', 'TCL/TK Language Script', 0, 0);
157
INSERT INTO system_mimetype VALUES (47, 'tcl', 'application/x-tcl', 'TCL/TK Language Script');
158
INSERT INTO system_mimetypes VALUES (48, 'tex', 'application/x-tex', 'LaTeX Source', 0, 0);
158
INSERT INTO system_mimetype VALUES (48, 'tex', 'application/x-tex', 'LaTeX Source');
159
INSERT INTO system_mimetypes VALUES (49, 'texinfo', 'application/x-texinfo', 'TeX', 0, 0);
159
INSERT INTO system_mimetype VALUES (49, 'texinfo', 'application/x-texinfo', 'TeX');
160
INSERT INTO system_mimetypes VALUES (50, 'texi', 'application/x-texinfo', 'TeX', 0, 0);
160
INSERT INTO system_mimetype VALUES (50, 'texi', 'application/x-texinfo', 'TeX');
161
INSERT INTO system_mimetypes VALUES (51, 't', 'application/x-troff', 'TAR Tape Archive Without Compression', 0, 0);
161
INSERT INTO system_mimetype VALUES (51, 't', 'application/x-troff', 'TAR Tape Archive Without Compression');
162
INSERT INTO system_mimetypes VALUES (52, 'tr', 'application/x-troff', 'Unix Tape Archive = TAR without compression (tar)', 0, 0);
162
INSERT INTO system_mimetype VALUES (52, 'tr', 'application/x-troff', 'Unix Tape Archive = TAR without compression (tar)');
163
INSERT INTO system_mimetypes VALUES (53, 'src', 'application/x-wais-source', 'Sourcecode', 0, 0);
163
INSERT INTO system_mimetype VALUES (53, 'src', 'application/x-wais-source', 'Sourcecode');
164
INSERT INTO system_mimetypes VALUES (54, 'xhtml', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0);
164
INSERT INTO system_mimetype VALUES (54, 'xhtml', 'application/xhtml+xml', 'Extensible HyperText Markup Language File');
165
INSERT INTO system_mimetypes VALUES (55, 'xht', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0);
165
INSERT INTO system_mimetype VALUES (55, 'xht', 'application/xhtml+xml', 'Extensible HyperText Markup Language File');
166
INSERT INTO system_mimetypes VALUES (56, 'au', 'audio/basic audio/x-basic audio/au audio/x-au audio/x-pn-au audio/rmf audio/x-rmf audio/x-ulaw audio/vnd.qcelp audio/x-gsm audio/snd', 'ULaw/AU Audio File', 0, 0);
166
INSERT INTO system_mimetype VALUES (56, 'au', 'audio/basic audio/x-basic audio/au audio/x-au audio/x-pn-au audio/rmf audio/x-rmf audio/x-ulaw audio/vnd.qcelp audio/x-gsm audio/snd', 'ULaw/AU Audio File');
167
INSERT INTO system_mimetypes VALUES (57, 'XM', 'audio/xm audio/x-xm audio/module-xm audio/mod audio/x-mod', 'Fast Tracker 2 Extended Module', 0, 0);
167
INSERT INTO system_mimetype VALUES (57, 'XM', 'audio/xm audio/x-xm audio/module-xm audio/mod audio/x-mod', 'Fast Tracker 2 Extended Module');
168
INSERT INTO system_mimetypes VALUES (58, 'snd', 'audio/basic', 'Macintosh Sound Resource', 0, 0);
168
INSERT INTO system_mimetype VALUES (58, 'snd', 'audio/basic', 'Macintosh Sound Resource');
169
INSERT INTO system_mimetypes VALUES (59, 'mid', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi audio/soundtrack', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0);
169
INSERT INTO system_mimetype VALUES (59, 'mid', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi audio/soundtrack', 'Musical Instrument Digital Interface MIDI-sequention Sound');
170
INSERT INTO system_mimetypes VALUES (60, 'midi', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0);
170
INSERT INTO system_mimetype VALUES (60, 'midi', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi', 'Musical Instrument Digital Interface MIDI-sequention Sound');
171
INSERT INTO system_mimetypes VALUES (61, 'kar', 'audio/midi audio/x-midi audio/mid x-music/x-midi', 'Karaoke MIDI File', 0, 0);
171
INSERT INTO system_mimetype VALUES (61, 'kar', 'audio/midi audio/x-midi audio/mid x-music/x-midi', 'Karaoke MIDI File');
172
INSERT INTO system_mimetypes VALUES (62, 'mpga', 'audio/mpeg audio/mp3 audio/mgp audio/m-mpeg audio/x-mp3 audio/x-mpeg audio/x-mpg video/mpeg', 'Mpeg-1 Layer3 Audio Stream', 0, 0);
172
INSERT INTO system_mimetype VALUES (62, 'mpga', 'audio/mpeg audio/mp3 audio/mgp audio/m-mpeg audio/x-mp3 audio/x-mpeg audio/x-mpg video/mpeg', 'Mpeg-1 Layer3 Audio Stream');
173
INSERT INTO system_mimetypes VALUES (63, 'mp2', 'video/mpeg audio/mpeg', 'MPEG Audio Stream, Layer II', 0, 0);
173
INSERT INTO system_mimetype VALUES (63, 'mp2', 'video/mpeg audio/mpeg', 'MPEG Audio Stream, Layer II');
174
INSERT INTO system_mimetypes VALUES (64, 'mp3', 'audio/mpeg audio/x-mpeg audio/mp3 audio/x-mp3 audio/mpeg3 audio/x-mpeg3 audio/mpg audio/x-mpg audio/x-mpegaudio', 'MPEG Audio Stream, Layer III', 0, 0);
174
INSERT INTO system_mimetype VALUES (64, 'mp3', 'audio/mpeg audio/x-mpeg audio/mp3 audio/x-mp3 audio/mpeg3 audio/x-mpeg3 audio/mpg audio/x-mpg audio/x-mpegaudio', 'MPEG Audio Stream, Layer III');
175
INSERT INTO system_mimetypes VALUES (65, 'aif', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0);
175
INSERT INTO system_mimetype VALUES (65, 'aif', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/vnd.qcelp', 'Audio Interchange File');
176
INSERT INTO system_mimetypes VALUES (66, 'aiff', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/mid audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0);
176
INSERT INTO system_mimetype VALUES (66, 'aiff', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/mid audio/x-midi audio/vnd.qcelp', 'Audio Interchange File');
177
INSERT INTO system_mimetypes VALUES (67, 'aifc', 'audio/aiff audio/x-aiff audio/x-aifc sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/mid audio/vnd.qcelp', 'Audio Interchange File', 0, 0);
177
INSERT INTO system_mimetype VALUES (67, 'aifc', 'audio/aiff audio/x-aiff audio/x-aifc sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/mid audio/vnd.qcelp', 'Audio Interchange File');
178
INSERT INTO system_mimetypes VALUES (68, 'm3u', 'audio/x-mpegurl audio/mpeg-url application/x-winamp-playlist audio/scpls audio/x-scpls', 'MP3 Playlist File', 0, 0);
178
INSERT INTO system_mimetype VALUES (68, 'm3u', 'audio/x-mpegurl audio/mpeg-url application/x-winamp-playlist audio/scpls audio/x-scpls', 'MP3 Playlist File');
179
INSERT INTO system_mimetypes VALUES (69, 'ram', 'audio/x-pn-realaudio audio/vnd.rn-realaudio audio/x-pm-realaudio-plugin audio/x-pn-realvideo audio/x-realaudio video/x-pn-realvideo text/plain', 'RealMedia Metafile', 0, 0);
179
INSERT INTO system_mimetype VALUES (69, 'ram', 'audio/x-pn-realaudio audio/vnd.rn-realaudio audio/x-pm-realaudio-plugin audio/x-pn-realvideo audio/x-realaudio video/x-pn-realvideo text/plain', 'RealMedia Metafile');
180
INSERT INTO system_mimetypes VALUES (70, 'rm', 'application/vnd.rn-realmedia audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin', 'RealMedia Streaming Media', 0, 0);
180
INSERT INTO system_mimetype VALUES (70, 'rm', 'application/vnd.rn-realmedia audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin', 'RealMedia Streaming Media');
181
INSERT INTO system_mimetypes VALUES (71, 'rpm', 'audio/x-pn-realaudio audio/x-pn-realaudio-plugin audio/x-pnrealaudio-plugin video/x-pn-realvideo-plugin audio/x-mpegurl application/octet-stream', 'RealMedia Player Plug-in', 0, 0);
181
INSERT INTO system_mimetype VALUES (71, 'rpm', 'audio/x-pn-realaudio audio/x-pn-realaudio-plugin audio/x-pnrealaudio-plugin video/x-pn-realvideo-plugin audio/x-mpegurl application/octet-stream', 'RealMedia Player Plug-in');
182
INSERT INTO system_mimetypes VALUES (72, 'ra', 'audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin video/x-pn-realvideo', 'RealMedia Streaming Media', 0, 0);
182
INSERT INTO system_mimetype VALUES (72, 'ra', 'audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin video/x-pn-realvideo', 'RealMedia Streaming Media');
183
INSERT INTO system_mimetypes VALUES (73, 'wav', 'audio/wav audio/x-wav audio/wave audio/x-pn-wav', 'Waveform Audio', 0, 0);
183
INSERT INTO system_mimetype VALUES (73, 'wav', 'audio/wav audio/x-wav audio/wave audio/x-pn-wav', 'Waveform Audio');
184
INSERT INTO system_mimetypes VALUES (74, 'wax', ' audio/x-ms-wax', 'Windows Media Audio Redirector', 0, 0);
184
INSERT INTO system_mimetype VALUES (74, 'wax', ' audio/x-ms-wax', 'Windows Media Audio Redirector');
185
INSERT INTO system_mimetypes VALUES (75, 'wma', 'audio/x-ms-wma video/x-ms-asf', 'Windows Media Audio File', 0, 0);
185
INSERT INTO system_mimetype VALUES (75, 'wma', 'audio/x-ms-wma video/x-ms-asf', 'Windows Media Audio File');
186
INSERT INTO system_mimetypes VALUES (76, 'bmp', 'image/bmp image/x-bmp image/x-bitmap image/x-xbitmap image/x-win-bitmap image/x-windows-bmp image/ms-bmp image/x-ms-bmp application/bmp application/x-bmp application/x-win-bitmap application/preview', 'Windows OS/2 Bitmap Graphics', 1, 1);
186
INSERT INTO system_mimetype VALUES (76, 'bmp', 'image/bmp image/x-bmp image/x-bitmap image/x-xbitmap image/x-win-bitmap image/x-windows-bmp image/ms-bmp image/x-ms-bmp application/bmp application/x-bmp application/x-win-bitmap application/preview', 'Windows OS/2 Bitmap Graphics');
187
INSERT INTO system_mimetypes VALUES (77, 'gif', 'image/gif image/x-xbitmap image/gi_', 'Graphic Interchange Format', 1, 1);
187
INSERT INTO system_mimetype VALUES (77, 'gif', 'image/gif image/x-xbitmap image/gi_', 'Graphic Interchange Format');
188
INSERT INTO system_mimetypes VALUES (78, 'ief', 'image/ief', 'Image File - Bitmap graphics', 0, 0);
188
INSERT INTO system_mimetype VALUES (78, 'ief', 'image/ief', 'Image File - Bitmap graphics');
189
INSERT INTO system_mimetypes VALUES (79, 'jpeg', 'image/jpeg image/jpg image/jpe_ image/pjpeg image/vnd.swiftview-jpeg', 'JPEG/JIFF Image', 1, 1);
189
INSERT INTO system_mimetype VALUES (79, 'jpeg', 'image/jpeg image/jpg image/jpe_ image/pjpeg image/vnd.swiftview-jpeg', 'JPEG/JIFF Image');
190
INSERT INTO system_mimetypes VALUES (80, 'jpg', 'image/jpeg image/jpg image/jp_ application/jpg application/x-jpg image/pjpeg image/pipeg image/vnd.swiftview-jpeg image/x-xbitmap', 'JPEG/JIFF Image', 1, 1);
190
INSERT INTO system_mimetype VALUES (80, 'jpg', 'image/jpeg image/jpg image/jp_ application/jpg application/x-jpg image/pjpeg image/pipeg image/vnd.swiftview-jpeg image/x-xbitmap', 'JPEG/JIFF Image');
191
INSERT INTO system_mimetypes VALUES (81, 'jpe', 'image/jpeg', 'JPEG/JIFF Image', 1, 1);
191
INSERT INTO system_mimetype VALUES (81, 'jpe', 'image/jpeg', 'JPEG/JIFF Image');
192
INSERT INTO system_mimetypes VALUES (82, 'png', 'image/png application/png application/x-png', 'Portable (Public) Network Graphic', 1, 1);
192
INSERT INTO system_mimetype VALUES (82, 'png', 'image/png application/png application/x-png', 'Portable (Public) Network Graphic');
193
INSERT INTO system_mimetypes VALUES (83, 'tiff', 'image/tiff', 'Tagged Image Format File', 1, 1);
193
INSERT INTO system_mimetype VALUES (83, 'tiff', 'image/tiff', 'Tagged Image Format File');
194
INSERT INTO system_mimetypes VALUES (84, 'tif', 'image/tif image/x-tif image/tiff image/x-tiff application/tif application/x-tif application/tiff application/x-tiff', 'Tagged Image Format File', 1, 1);
194
INSERT INTO system_mimetype VALUES (84, 'tif', 'image/tif image/x-tif image/tiff image/x-tiff application/tif application/x-tif application/tiff application/x-tiff', 'Tagged Image Format File');
195
INSERT INTO system_mimetypes VALUES (85, 'ico', 'image/ico image/x-icon application/ico application/x-ico application/x-win-bitmap image/x-win-bitmap application/octet-stream', 'Windows Icon', 0, 0);
195
INSERT INTO system_mimetype VALUES (85, 'ico', 'image/ico image/x-icon application/ico application/x-ico application/x-win-bitmap image/x-win-bitmap application/octet-stream', 'Windows Icon');
196
INSERT INTO system_mimetypes VALUES (86, 'wbmp', 'image/vnd.wap.wbmp', 'Wireless Bitmap File Format', 0, 0);
196
INSERT INTO system_mimetype VALUES (86, 'wbmp', 'image/vnd.wap.wbmp', 'Wireless Bitmap File Format');
197
INSERT INTO system_mimetypes VALUES (87, 'ras', 'application/ras application/x-ras image/ras', 'Sun Raster Graphic', 0, 0);
197
INSERT INTO system_mimetype VALUES (87, 'ras', 'application/ras application/x-ras image/ras', 'Sun Raster Graphic');
198
INSERT INTO system_mimetypes VALUES (88, 'pnm', 'image/x-portable-anymap', 'PBM Portable Any Map Graphic Bitmap', 0, 0);
198
INSERT INTO system_mimetype VALUES (88, 'pnm', 'image/x-portable-anymap', 'PBM Portable Any Map Graphic Bitmap');
199
INSERT INTO system_mimetypes VALUES (89, 'pbm', 'image/portable bitmap image/x-portable-bitmap image/pbm image/x-pbm', 'UNIX Portable Bitmap Graphic', 0, 0);
199
INSERT INTO system_mimetype VALUES (89, 'pbm', 'image/portable bitmap image/x-portable-bitmap image/pbm image/x-pbm', 'UNIX Portable Bitmap Graphic');
200
INSERT INTO system_mimetypes VALUES (90, 'pgm', 'image/x-portable-graymap image/x-pgm', 'Portable Graymap Graphic', 0, 0);
200
INSERT INTO system_mimetype VALUES (90, 'pgm', 'image/x-portable-graymap image/x-pgm', 'Portable Graymap Graphic');
201
INSERT INTO system_mimetypes VALUES (91, 'ppm', 'image/x-portable-pixmap application/ppm application/x-ppm image/x-p image/x-ppm', 'PBM Portable Pixelmap Graphic', 0, 0);
201
INSERT INTO system_mimetype VALUES (91, 'ppm', 'image/x-portable-pixmap application/ppm application/x-ppm image/x-p image/x-ppm', 'PBM Portable Pixelmap Graphic');
202
INSERT INTO system_mimetypes VALUES (92, 'rgb', 'image/rgb image/x-rgb', 'Silicon Graphics RGB Bitmap', 0, 0);
202
INSERT INTO system_mimetype VALUES (92, 'rgb', 'image/rgb image/x-rgb', 'Silicon Graphics RGB Bitmap');
203
INSERT INTO system_mimetypes VALUES (93, 'xbm', 'image/x-xpixmap image/x-xbitmap image/xpm image/x-xpm', 'X Bitmap Graphic', 0, 0);
203
INSERT INTO system_mimetype VALUES (93, 'xbm', 'image/x-xpixmap image/x-xbitmap image/xpm image/x-xpm', 'X Bitmap Graphic');
204
INSERT INTO system_mimetypes VALUES (94, 'xpm', 'image/x-xpixmap', 'BMC Software Patrol UNIX Icon File', 0, 0);
204
INSERT INTO system_mimetype VALUES (94, 'xpm', 'image/x-xpixmap', 'BMC Software Patrol UNIX Icon File');
205
INSERT INTO system_mimetypes VALUES (95, 'xwd', 'image/x-xwindowdump image/xwd image/x-xwd application/xwd application/x-xwd', 'X Windows Dump', 0, 0);
205
INSERT INTO system_mimetype VALUES (95, 'xwd', 'image/x-xwindowdump image/xwd image/x-xwd application/xwd application/x-xwd', 'X Windows Dump');
206
INSERT INTO system_mimetypes VALUES (96, 'igs', 'model/iges application/iges application/x-iges application/igs application/x-igs drawing/x-igs image/x-igs', 'Initial Graphics Exchange Specification Format', 0, 0);
206
INSERT INTO system_mimetype VALUES (96, 'igs', 'model/iges application/iges application/x-iges application/igs application/x-igs drawing/x-igs image/x-igs', 'Initial Graphics Exchange Specification Format');
207
INSERT INTO system_mimetypes VALUES (97, 'css', 'application/css-stylesheet text/css', 'Hypertext Cascading Style Sheet', 0, 0);
207
INSERT INTO system_mimetype VALUES (97, 'css', 'application/css-stylesheet text/css', 'Hypertext Cascading Style Sheet');
208
INSERT INTO system_mimetypes VALUES (98, 'html', 'text/html text/plain', 'Hypertext Markup Language', 0, 0);
208
INSERT INTO system_mimetype VALUES (98, 'html', 'text/html text/plain', 'Hypertext Markup Language');
209
INSERT INTO system_mimetypes VALUES (99, 'htm', 'text/html', 'Hypertext Markup Language', 0, 0);
209
INSERT INTO system_mimetype VALUES (99, 'htm', 'text/html', 'Hypertext Markup Language');
210
INSERT INTO system_mimetypes VALUES (100, 'txt', 'text/plain application/txt browser/internal', 'Text File', 1, 1);
210
INSERT INTO system_mimetype VALUES (100, 'txt', 'text/plain application/txt browser/internal', 'Text File');
211
INSERT INTO system_mimetypes VALUES (101, 'rtf', 'application/rtf application/x-rtf text/rtf text/richtext application/msword application/doc application/x-soffice', 'Rich Text Format File', 1, 1);
211
INSERT INTO system_mimetype VALUES (101, 'rtf', 'application/rtf application/x-rtf text/rtf text/richtext application/msword application/doc application/x-soffice', 'Rich Text Format File');
212
INSERT INTO system_mimetypes VALUES (102, 'wml', 'text/vnd.wap.wml text/wml', 'Website META Language File', 0, 0);
212
INSERT INTO system_mimetype VALUES (102, 'wml', 'text/vnd.wap.wml text/wml', 'Website META Language File');
213
INSERT INTO system_mimetypes VALUES (103, 'wmls', 'text/vnd.wap.wmlscript', 'WML Script', 0, 0);
213
INSERT INTO system_mimetype VALUES (103, 'wmls', 'text/vnd.wap.wmlscript', 'WML Script');
214
INSERT INTO system_mimetypes VALUES (104, 'etx', 'text/x-setext', 'SetText Structure Enhanced Text', 0, 0);
214
INSERT INTO system_mimetype VALUES (104, 'etx', 'text/x-setext', 'SetText Structure Enhanced Text');
215
INSERT INTO system_mimetypes VALUES (105, 'xml', 'text/xml application/xml application/x-xml', 'Extensible Markup Language File', 0, 0);
215
INSERT INTO system_mimetype VALUES (105, 'xml', 'text/xml application/xml application/x-xml', 'Extensible Markup Language File');
216
INSERT INTO system_mimetypes VALUES (106, 'xsl', 'text/xml', 'XML Stylesheet', 0, 0);
216
INSERT INTO system_mimetype VALUES (106, 'xsl', 'text/xml', 'XML Stylesheet');
217
INSERT INTO system_mimetypes VALUES (107, 'php', 'text/php application/x-httpd-php application/php magnus-internal/shellcgi application/x-php', 'PHP Script', 0, 0);
217
INSERT INTO system_mimetype VALUES (107, 'php', 'text/php application/x-httpd-php application/php magnus-internal/shellcgi application/x-php', 'PHP Script');
218
INSERT INTO system_mimetypes VALUES (108, 'php3', 'text/php3 application/x-httpd-php', 'PHP Script', 0, 0);
218
INSERT INTO system_mimetype VALUES (108, 'php3', 'text/php3 application/x-httpd-php', 'PHP Script');
219
INSERT INTO system_mimetypes VALUES (109, 'mpeg', 'video/mpeg', 'MPEG Movie', 0, 0);
219
INSERT INTO system_mimetype VALUES (109, 'mpeg', 'video/mpeg', 'MPEG Movie');
220
INSERT INTO system_mimetypes VALUES (110, 'mpg', 'video/mpeg video/mpg video/x-mpg video/mpeg2 application/x-pn-mpg video/x-mpeg video/x-mpeg2a audio/mpeg audio/x-mpeg image/mpg', 'MPEG 1 System Stream', 0, 0);
220
INSERT INTO system_mimetype VALUES (110, 'mpg', 'video/mpeg video/mpg video/x-mpg video/mpeg2 application/x-pn-mpg video/x-mpeg video/x-mpeg2a audio/mpeg audio/x-mpeg image/mpg', 'MPEG 1 System Stream');
221
INSERT INTO system_mimetypes VALUES (111, 'mpe', 'video/mpeg', 'MPEG Movie Clip', 0, 0);
221
INSERT INTO system_mimetype VALUES (111, 'mpe', 'video/mpeg', 'MPEG Movie Clip');
222
INSERT INTO system_mimetypes VALUES (112, 'qt', 'video/quicktime audio/aiff audio/x-wav video/flc', 'QuickTime Movie', 0, 0);
222
INSERT INTO system_mimetype VALUES (112, 'qt', 'video/quicktime audio/aiff audio/x-wav video/flc', 'QuickTime Movie');
223
INSERT INTO system_mimetypes VALUES (113, 'mov', 'video/quicktime video/x-quicktime image/mov audio/aiff audio/x-midi audio/x-wav video/avi', 'QuickTime Video Clip', 0, 0);
223
INSERT INTO system_mimetype VALUES (113, 'mov', 'video/quicktime video/x-quicktime image/mov audio/aiff audio/x-midi audio/x-wav video/avi', 'QuickTime Video Clip');
224
INSERT INTO system_mimetypes VALUES (114, 'avi', 'video/avi video/msvideo video/x-msvideo image/avi video/xmpg2 application/x-troff-msvideo audio/aiff audio/avi', 'Audio Video Interleave File', 0, 0);
224
INSERT INTO system_mimetype VALUES (114, 'avi', 'video/avi video/msvideo video/x-msvideo image/avi video/xmpg2 application/x-troff-msvideo audio/aiff audio/avi', 'Audio Video Interleave File');
225
INSERT INTO system_mimetypes VALUES (115, 'movie', 'video/sgi-movie video/x-sgi-movie', 'QuickTime Movie', 0, 0);
225
INSERT INTO system_mimetype VALUES (115, 'movie', 'video/sgi-movie video/x-sgi-movie', 'QuickTime Movie');
226
INSERT INTO system_mimetypes VALUES (116, 'asf', 'audio/asf application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx', 'Advanced Streaming Format', 0, 0);
226
INSERT INTO system_mimetype VALUES (116, 'asf', 'audio/asf application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx', 'Advanced Streaming Format');
227
INSERT INTO system_mimetypes VALUES (117, 'asx', 'video/asx application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx video/x-la-asf', 'Advanced Stream Redirector File', 0, 0);
227
INSERT INTO system_mimetype VALUES (117, 'asx', 'video/asx application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx video/x-la-asf', 'Advanced Stream Redirector File');
228
INSERT INTO system_mimetypes VALUES (118, 'wmv', 'video/x-ms-wmv', 'Windows Media File', 0, 0);
228
INSERT INTO system_mimetype VALUES (118, 'wmv', 'video/x-ms-wmv', 'Windows Media File');
229
INSERT INTO system_mimetypes VALUES (119, 'wvx', 'video/x-ms-wvx', 'Windows Media Redirector', 0, 0);
229
INSERT INTO system_mimetype VALUES (119, 'wvx', 'video/x-ms-wvx', 'Windows Media Redirector');
230
INSERT INTO system_mimetypes VALUES (120, 'wm', 'video/x-ms-wm', 'Windows Media A/V File', 0, 0);
230
INSERT INTO system_mimetype VALUES (120, 'wm', 'video/x-ms-wm', 'Windows Media A/V File');
231
INSERT INTO system_mimetypes VALUES (121, 'wmx', 'video/x-ms-wmx', 'Windows Media Player A/V Shortcut', 0, 0);
231
INSERT INTO system_mimetype VALUES (121, 'wmx', 'video/x-ms-wmx', 'Windows Media Player A/V Shortcut');
232
INSERT INTO system_mimetypes VALUES (122, 'ice', 'x-conference-xcooltalk', 'Cooltalk Audio', 0, 0);
232
INSERT INTO system_mimetype VALUES (122, 'ice', 'x-conference-xcooltalk', 'Cooltalk Audio');
233
INSERT INTO system_mimetypes VALUES (123, 'rar', 'application/octet-stream', 'WinRAR Compressed Archive', 0, 0);
233
INSERT INTO system_mimetype VALUES (123, 'rar', 'application/octet-stream', 'WinRAR Compressed Archive');
 
 
234
INSERT INTO `group_permission` (`gperm_id`, `gperm_groupid`, `gperm_itemid`, `gperm_modid`, `gperm_name`) VALUES
 
 
235
(NULL, 2, 20, 1, 'use_extension'),
 
 
236
(NULL, 1, 20, 1, 'use_extension'),
 
 
237
(NULL, 2, 19, 1, 'use_extension'),
 
 
238
(NULL, 1, 19, 1, 'use_extension'),
 
 
239
(NULL, 2, 76, 1, 'use_extension'),
 
 
240
(NULL, 1, 76, 1, 'use_extension'),
 
 
241
(NULL, 2, 77, 1, 'use_extension'),
 
 
242
(NULL, 1, 77, 1, 'use_extension'),
 
 
243
(NULL, 2, 82, 1, 'use_extension'),
 
 
244
(NULL, 1, 82, 1, 'use_extension'),
 
 
245
(NULL, 2, 79, 1, 'use_extension'),
 
 
246
(NULL, 1, 79, 1, 'use_extension'),
 
 
247
(NULL, 2, 80, 1, 'use_extension'),
 
 
248
(NULL, 1, 80, 1, 'use_extension'),
 
 
249
(NULL, 2, 81, 1, 'use_extension'),
 
 
250
(NULL, 1, 81, 1, 'use_extension'),
 
 
251
(NULL, 2, 83, 1, 'use_extension'),
 
 
252
(NULL, 1, 83, 1, 'use_extension'),
 
 
253
(NULL, 2, 84, 1, 'use_extension'),
 
 
254
(NULL, 1, 84, 1, 'use_extension'),
 
 
255
(NULL, 2, 100, 1, 'use_extension'),
 
 
256
(NULL, 1, 100, 1, 'use_extension'),
 
 
257
(NULL, 2, 101, 1, 'use_extension'),
 
 
258
(NULL, 1, 101, 1, 'use_extension');
88148815
665
) TYPE=MyISAM;
665
) TYPE=MyISAM;
666
 
666
 
667
#
667
#
668
# Table structure for table `system_mimetypes`
668
# Table structure for table `system_mimetype`
669
#
669
#
670
 
670
 
671
CREATE TABLE system_mimetypes (
671
CREATE TABLE system_mimetype (
672
  mime_id int(11) NOT NULL auto_increment,
672
  mimetypeid int(11) NOT NULL auto_increment,
673
  mime_name varchar(255) NOT NULL default '',
673
  extension varchar(60) NOT NULL default '',
674
  mime_ext varchar(60) NOT NULL default '',
674
  types text NOT NULL,
675
  mime_text varchar(60) NOT NULL default '',
675
  name varchar(255) NOT NULL default '',
676
  mime_admin int(1) NOT NULL default '1',
676
  KEY mimetypeid (mimetypeid)
677
  mime_user int(1) NOT NULL default '0',
 
 
678
  KEY mime_id (mime_id)
 
 
679
) TYPE=MyISAM;
677
) TYPE=MyISAM;
 
 
678
 
 
 
679
#
 
 
680
# Table structure for table `system_adsense`
 
 
681
#
 
 
682
 
 
 
683
CREATE TABLE system_adsense (
 
 
684
  adsenseid int(11) NOT NULL auto_increment,
 
 
685
  format VARCHAR(100) NOT NULL,
 
 
686
  description TEXT NOT NULL,
 
 
687
  style TEXT NOT NULL,
 
 
688
  border_color varchar(6) NOT NULL default '',
 
 
689
  background_color varchar(6) NOT NULL default '',
 
 
690
  link_color varchar(6) NOT NULL default '',
 
 
691
  url_color varchar(6) NOT NULL default '',
 
 
692
  text_color varchar(6) NOT NULL default '',
 
 
693
  client_id varchar(100) NOT NULL default '',
 
 
694
  tag varchar(50) NOT NULL default '',
 
 
695
  PRIMARY KEY  (`adsenseid`)
 
 
696
) TYPE=MyISAM;
 
 
697
 
 
 
698
#
 
 
699
# Table structure for table `system_rating`
 
 
700
#
 
 
701
 
 
 
702
CREATE TABLE system_rating (
 
 
703
  ratingid int(11) NOT NULL auto_increment,
 
 
704
  dirname VARCHAR(255) NOT NULL,
 
 
705
  item VARCHAR(255) NOT NULL,
 
 
706
  itemid int(11) NOT NULL,
 
 
707
  uid int(11) NOT NULL,
 
 
708
  rate int(1) NOT NULL,
 
 
709
  date int(11) NOT NULL,
 
 
710
  PRIMARY KEY  (`ratingid`)
 
 
711
) TYPE=MyISAM;
88148815
97
 
97
 
98
 
98
 
99
#
99
#
100
# Dumping data for table `system_mimetypes`
100
# Dumping data for table `system_mimetype`
101
#
101
#
102
 
102
 
103
INSERT INTO system_mimetypes VALUES (1, 'bin', 'application/octet-stream', 'Binary File/Linux Executable', 0, 0);
103
INSERT INTO system_mimetype VALUES (1, 'bin', 'application/octet-stream', 'Binary File/Linux Executable');
104
INSERT INTO system_mimetypes VALUES (2, 'dms', 'application/octet-stream', 'Amiga DISKMASHER Compressed Archive', 0, 0);
104
INSERT INTO system_mimetype VALUES (2, 'dms', 'application/octet-stream', 'Amiga DISKMASHER Compressed Archive');
105
INSERT INTO system_mimetypes VALUES (3, 'class', 'application/octet-stream', 'Java Bytecode', 0, 0);
105
INSERT INTO system_mimetype VALUES (3, 'class', 'application/octet-stream', 'Java Bytecode');
106
INSERT INTO system_mimetypes VALUES (4, 'so', 'application/octet-stream', 'UNIX Shared Library Function', 0, 0);
106
INSERT INTO system_mimetype VALUES (4, 'so', 'application/octet-stream', 'UNIX Shared Library Function');
107
INSERT INTO system_mimetypes VALUES (5, 'dll', 'application/octet-stream', 'Dynamic Link Library', 0, 0);
107
INSERT INTO system_mimetype VALUES (5, 'dll', 'application/octet-stream', 'Dynamic Link Library');
108
INSERT INTO system_mimetypes VALUES (6, 'hqx', 'application/binhex application/mac-binhex application/mac-binhex40', 'Macintosh BinHex 4 Compressed Archive', 0, 0);
108
INSERT INTO system_mimetype VALUES (6, 'hqx', 'application/binhex application/mac-binhex application/mac-binhex40', 'Macintosh BinHex 4 Compressed Archive');
109
INSERT INTO system_mimetypes VALUES (7, 'cpt', 'application/mac-compactpro application/compact_pro', 'Compact Pro Archive', 0, 0);
109
INSERT INTO system_mimetype VALUES (7, 'cpt', 'application/mac-compactpro application/compact_pro', 'Compact Pro Archive');
110
INSERT INTO system_mimetypes VALUES (8, 'lha', 'application/lha application/x-lha application/octet-stream application/x-compress application/x-compressed application/maclha', 'Compressed Archive File', 0, 0);
110
INSERT INTO system_mimetype VALUES (8, 'lha', 'application/lha application/x-lha application/octet-stream application/x-compress application/x-compressed application/maclha', 'Compressed Archive File');
111
INSERT INTO system_mimetypes VALUES (9, 'lzh', 'application/lzh application/x-lzh application/x-lha application/x-compress application/x-compressed application/x-lzh-archive zz-application/zz-winassoc-lzh application/maclha application/octet-stream', 'Compressed Archive File', 0, 0);
111
INSERT INTO system_mimetype VALUES (9, 'lzh', 'application/lzh application/x-lzh application/x-lha application/x-compress application/x-compressed application/x-lzh-archive zz-application/zz-winassoc-lzh application/maclha application/octet-stream', 'Compressed Archive File');
112
INSERT INTO system_mimetypes VALUES (10, 'sh', 'application/x-shar', 'UNIX shar Archive File', 0, 0);
112
INSERT INTO system_mimetype VALUES (10, 'sh', 'application/x-shar', 'UNIX shar Archive File');
113
INSERT INTO system_mimetypes VALUES (11, 'shar', 'application/x-shar', 'UNIX shar Archive File', 0, 0);
113
INSERT INTO system_mimetype VALUES (11, 'shar', 'application/x-shar', 'UNIX shar Archive File');
114
INSERT INTO system_mimetypes VALUES (12, 'tar', 'application/tar application/x-tar applicaton/x-gtar multipart/x-tar application/x-compress application/x-compressed', 'Tape Archive File', 0, 0);
114
INSERT INTO system_mimetype VALUES (12, 'tar', 'application/tar application/x-tar applicaton/x-gtar multipart/x-tar application/x-compress application/x-compressed', 'Tape Archive File');
115
INSERT INTO system_mimetypes VALUES (13, 'gtar', 'application/x-gtar', 'GNU tar Compressed File Archive', 0, 0);
115
INSERT INTO system_mimetype VALUES (13, 'gtar', 'application/x-gtar', 'GNU tar Compressed File Archive');
116
INSERT INTO system_mimetypes VALUES (14, 'ustar', 'application/x-ustar multipart/x-ustar', 'POSIX tar Compressed Archive', 0, 0);
116
INSERT INTO system_mimetype VALUES (14, 'ustar', 'application/x-ustar multipart/x-ustar', 'POSIX tar Compressed Archive');
117
INSERT INTO system_mimetypes VALUES (15, 'zip', 'application/zip application/x-zip application/x-zip-compressed application/octet-stream application/x-compress application/x-compressed multipart/x-zip', 'Compressed Archive File', 0, 0);
117
INSERT INTO system_mimetype VALUES (15, 'zip', 'application/zip application/x-zip application/x-zip-compressed application/octet-stream application/x-compress application/x-compressed multipart/x-zip', 'Compressed Archive File');
118
INSERT INTO system_mimetypes VALUES (16, 'exe', 'application/exe application/x-exe application/dos-exe application/x-winexe application/msdos-windows application/x-msdos-program', 'Executable File', 0, 0);
118
INSERT INTO system_mimetype VALUES (16, 'exe', 'application/exe application/x-exe application/dos-exe application/x-winexe application/msdos-windows application/x-msdos-program', 'Executable File');
119
INSERT INTO system_mimetypes VALUES (17, 'wmz', 'application/x-ms-wmz', 'Windows Media Compressed Skin File', 0, 0);
119
INSERT INTO system_mimetype VALUES (17, 'wmz', 'application/x-ms-wmz', 'Windows Media Compressed Skin File');
120
INSERT INTO system_mimetypes VALUES (18, 'wmd', 'application/x-ms-wmd', 'Windows Media Download File', 0, 0);
120
INSERT INTO system_mimetype VALUES (18, 'wmd', 'application/x-ms-wmd', 'Windows Media Download File');
121
INSERT INTO system_mimetypes VALUES (19, 'doc', 'application/msword application/doc appl/text application/vnd.msword application/vnd.ms-word application/winword application/word application/x-msw6 application/x-msword', 'Word Document', 1, 1);
121
INSERT INTO system_mimetype VALUES (19, 'doc', 'application/msword application/doc appl/text application/vnd.msword application/vnd.ms-word application/winword application/word application/x-msw6 application/x-msword', 'Word Document');
122
INSERT INTO system_mimetypes VALUES (20, 'pdf', 'application/pdf application/acrobat application/x-pdf applications/vnd.pdf text/pdf', 'Acrobat Portable Document Format', 1, 1);
122
INSERT INTO system_mimetype VALUES (20, 'pdf', 'application/pdf application/acrobat application/x-pdf applications/vnd.pdf text/pdf', 'Acrobat Portable Document Format');
123
INSERT INTO system_mimetypes VALUES (21, 'eps', 'application/eps application/postscript application/x-eps image/eps image/x-eps', 'Encapsulated PostScript', 0, 0);
123
INSERT INTO system_mimetype VALUES (21, 'eps', 'application/eps application/postscript application/x-eps image/eps image/x-eps', 'Encapsulated PostScript');
124
INSERT INTO system_mimetypes VALUES (22, 'ps', 'application/postscript application/ps application/x-postscript application/x-ps text/postscript', 'PostScript', 0, 0);
124
INSERT INTO system_mimetype VALUES (22, 'ps', 'application/postscript application/ps application/x-postscript application/x-ps text/postscript', 'PostScript');
125
INSERT INTO system_mimetypes VALUES (23, 'smi', 'application/smil', 'SMIL Multimedia', 0, 0);
125
INSERT INTO system_mimetype VALUES (23, 'smi', 'application/smil', 'SMIL Multimedia');
126
INSERT INTO system_mimetypes VALUES (24, 'smil', 'application/smil', 'Synchronized Multimedia Integration Language', 0, 0);
126
INSERT INTO system_mimetype VALUES (24, 'smil', 'application/smil', 'Synchronized Multimedia Integration Language');
127
INSERT INTO system_mimetypes VALUES (25, 'wmlc', 'application/vnd.wap.wmlc ', 'Compiled WML Document', 0, 0);
127
INSERT INTO system_mimetype VALUES (25, 'wmlc', 'application/vnd.wap.wmlc ', 'Compiled WML Document');
128
INSERT INTO system_mimetypes VALUES (26, 'wmlsc', 'application/vnd.wap.wmlscriptc', 'Compiled WML Script', 0, 0);
128
INSERT INTO system_mimetype VALUES (26, 'wmlsc', 'application/vnd.wap.wmlscriptc', 'Compiled WML Script');
129
INSERT INTO system_mimetypes VALUES (27, 'vcd', 'application/x-cdlink', 'Virtual CD-ROM CD Image File', 0, 0);
129
INSERT INTO system_mimetype VALUES (27, 'vcd', 'application/x-cdlink', 'Virtual CD-ROM CD Image File');
130
INSERT INTO system_mimetypes VALUES (28, 'pgn', 'application/formstore', 'Picatinny Arsenal Electronic Formstore Form in TIFF Format', 0, 0);
130
INSERT INTO system_mimetype VALUES (28, 'pgn', 'application/formstore', 'Picatinny Arsenal Electronic Formstore Form in TIFF Format');
131
INSERT INTO system_mimetypes VALUES (29, 'cpio', 'application/x-cpio', 'UNIX CPIO Archive', 0, 0);
131
INSERT INTO system_mimetype VALUES (29, 'cpio', 'application/x-cpio', 'UNIX CPIO Archive');
132
INSERT INTO system_mimetypes VALUES (30, 'csh', 'application/x-csh', 'Csh Script', 0, 0);
132
INSERT INTO system_mimetype VALUES (30, 'csh', 'application/x-csh', 'Csh Script');
133
INSERT INTO system_mimetypes VALUES (31, 'dcr', 'application/x-director', 'Shockwave Movie', 0, 0);
133
INSERT INTO system_mimetype VALUES (31, 'dcr', 'application/x-director', 'Shockwave Movie');
134
INSERT INTO system_mimetypes VALUES (32, 'dir', 'application/x-director', 'Macromedia Director Movie', 0, 0);
134
INSERT INTO system_mimetype VALUES (32, 'dir', 'application/x-director', 'Macromedia Director Movie');
135
INSERT INTO system_mimetypes VALUES (33, 'dxr', 'application/x-director application/vnd.dxr', 'Macromedia Director Protected Movie File', 0, 0);
135
INSERT INTO system_mimetype VALUES (33, 'dxr', 'application/x-director application/vnd.dxr', 'Macromedia Director Protected Movie File');
136
INSERT INTO system_mimetypes VALUES (34, 'dvi', 'application/x-dvi', 'TeX Device Independent Document', 0, 0);
136
INSERT INTO system_mimetype VALUES (34, 'dvi', 'application/x-dvi', 'TeX Device Independent Document');
137
INSERT INTO system_mimetypes VALUES (35, 'spl', 'application/x-futuresplash', 'Macromedia FutureSplash File', 0, 0);
137
INSERT INTO system_mimetype VALUES (35, 'spl', 'application/x-futuresplash', 'Macromedia FutureSplash File');
138
INSERT INTO system_mimetypes VALUES (36, 'hdf', 'application/x-hdf', 'Hierarchical Data Format File', 0, 0);
138
INSERT INTO system_mimetype VALUES (36, 'hdf', 'application/x-hdf', 'Hierarchical Data Format File');
139
INSERT INTO system_mimetypes VALUES (37, 'js', 'application/x-javascript text/javascript', 'JavaScript Source Code', 0, 0);
139
INSERT INTO system_mimetype VALUES (37, 'js', 'application/x-javascript text/javascript', 'JavaScript Source Code');
140
INSERT INTO system_mimetypes VALUES (38, 'skp', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Play File', 0, 0);
140
INSERT INTO system_mimetype VALUES (38, 'skp', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Play File');
141
INSERT INTO system_mimetypes VALUES (39, 'skd', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Design File', 0, 0);
141
INSERT INTO system_mimetype VALUES (39, 'skd', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Design File');
142
INSERT INTO system_mimetypes VALUES (40, 'skt', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Template File', 0, 0);
142
INSERT INTO system_mimetype VALUES (40, 'skt', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Template File');
143
INSERT INTO system_mimetypes VALUES (41, 'skm', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Mix File', 0, 0);
143
INSERT INTO system_mimetype VALUES (41, 'skm', 'application/x-koan application/vnd-koan koan/x-skm application/vnd.koan', 'SSEYO Koan Mix File');
144
INSERT INTO system_mimetypes VALUES (42, 'latex', 'application/x-latex text/x-latex', 'LaTeX Source Document', 0, 0);
144
INSERT INTO system_mimetype VALUES (42, 'latex', 'application/x-latex text/x-latex', 'LaTeX Source Document');
145
INSERT INTO system_mimetypes VALUES (43, 'nc', 'application/x-netcdf text/x-cdf', 'Unidata netCDF Graphics', 0, 0);
145
INSERT INTO system_mimetype VALUES (43, 'nc', 'application/x-netcdf text/x-cdf', 'Unidata netCDF Graphics');
146
INSERT INTO system_mimetypes VALUES (44, 'cdf', 'application/cdf application/x-cdf application/netcdf application/x-netcdf text/cdf text/x-cdf', 'Channel Definition Format', 0, 0);
146
INSERT INTO system_mimetype VALUES (44, 'cdf', 'application/cdf application/x-cdf application/netcdf application/x-netcdf text/cdf text/x-cdf', 'Channel Definition Format');
147
INSERT INTO system_mimetypes VALUES (45, 'swf', 'application/x-shockwave-flash application/x-shockwave-flash2-preview application/futuresplash image/vnd.rn-realflash', 'Macromedia Flash Format File', 0, 0);
147
INSERT INTO system_mimetype VALUES (45, 'swf', 'application/x-shockwave-flash application/x-shockwave-flash2-preview application/futuresplash image/vnd.rn-realflash', 'Macromedia Flash Format File');
148
INSERT INTO system_mimetypes VALUES (46, 'sit', 'application/stuffit application/x-stuffit application/x-sit', 'StuffIt Compressed Archive File', 0, 0);
148
INSERT INTO system_mimetype VALUES (46, 'sit', 'application/stuffit application/x-stuffit application/x-sit', 'StuffIt Compressed Archive File');
149
INSERT INTO system_mimetypes VALUES (47, 'tcl', 'application/x-tcl', 'TCL/TK Language Script', 0, 0);
149
INSERT INTO system_mimetype VALUES (47, 'tcl', 'application/x-tcl', 'TCL/TK Language Script');
150
INSERT INTO system_mimetypes VALUES (48, 'tex', 'application/x-tex', 'LaTeX Source', 0, 0);
150
INSERT INTO system_mimetype VALUES (48, 'tex', 'application/x-tex', 'LaTeX Source');
151
INSERT INTO system_mimetypes VALUES (49, 'texinfo', 'application/x-texinfo', 'TeX', 0, 0);
151
INSERT INTO system_mimetype VALUES (49, 'texinfo', 'application/x-texinfo', 'TeX');
152
INSERT INTO system_mimetypes VALUES (50, 'texi', 'application/x-texinfo', 'TeX', 0, 0);
152
INSERT INTO system_mimetype VALUES (50, 'texi', 'application/x-texinfo', 'TeX');
153
INSERT INTO system_mimetypes VALUES (51, 't', 'application/x-troff', 'TAR Tape Archive Without Compression', 0, 0);
153
INSERT INTO system_mimetype VALUES (51, 't', 'application/x-troff', 'TAR Tape Archive Without Compression');
154
INSERT INTO system_mimetypes VALUES (52, 'tr', 'application/x-troff', 'Unix Tape Archive = TAR without compression (tar)', 0, 0);
154
INSERT INTO system_mimetype VALUES (52, 'tr', 'application/x-troff', 'Unix Tape Archive = TAR without compression (tar)');
155
INSERT INTO system_mimetypes VALUES (53, 'src', 'application/x-wais-source', 'Sourcecode', 0, 0);
155
INSERT INTO system_mimetype VALUES (53, 'src', 'application/x-wais-source', 'Sourcecode');
156
INSERT INTO system_mimetypes VALUES (54, 'xhtml', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0);
156
INSERT INTO system_mimetype VALUES (54, 'xhtml', 'application/xhtml+xml', 'Extensible HyperText Markup Language File');
157
INSERT INTO system_mimetypes VALUES (55, 'xht', 'application/xhtml+xml', 'Extensible HyperText Markup Language File', 0, 0);
157
INSERT INTO system_mimetype VALUES (55, 'xht', 'application/xhtml+xml', 'Extensible HyperText Markup Language File');
158
INSERT INTO system_mimetypes VALUES (56, 'au', 'audio/basic audio/x-basic audio/au audio/x-au audio/x-pn-au audio/rmf audio/x-rmf audio/x-ulaw audio/vnd.qcelp audio/x-gsm audio/snd', 'ULaw/AU Audio File', 0, 0);
158
INSERT INTO system_mimetype VALUES (56, 'au', 'audio/basic audio/x-basic audio/au audio/x-au audio/x-pn-au audio/rmf audio/x-rmf audio/x-ulaw audio/vnd.qcelp audio/x-gsm audio/snd', 'ULaw/AU Audio File');
159
INSERT INTO system_mimetypes VALUES (57, 'XM', 'audio/xm audio/x-xm audio/module-xm audio/mod audio/x-mod', 'Fast Tracker 2 Extended Module', 0, 0);
159
INSERT INTO system_mimetype VALUES (57, 'XM', 'audio/xm audio/x-xm audio/module-xm audio/mod audio/x-mod', 'Fast Tracker 2 Extended Module');
160
INSERT INTO system_mimetypes VALUES (58, 'snd', 'audio/basic', 'Macintosh Sound Resource', 0, 0);
160
INSERT INTO system_mimetype VALUES (58, 'snd', 'audio/basic', 'Macintosh Sound Resource');
161
INSERT INTO system_mimetypes VALUES (59, 'mid', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi audio/soundtrack', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0);
161
INSERT INTO system_mimetype VALUES (59, 'mid', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi audio/soundtrack', 'Musical Instrument Digital Interface MIDI-sequention Sound');
162
INSERT INTO system_mimetypes VALUES (60, 'midi', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi', 'Musical Instrument Digital Interface MIDI-sequention Sound', 0, 0);
162
INSERT INTO system_mimetype VALUES (60, 'midi', 'audio/mid audio/m audio/midi audio/x-midi application/x-midi', 'Musical Instrument Digital Interface MIDI-sequention Sound');
163
INSERT INTO system_mimetypes VALUES (61, 'kar', 'audio/midi audio/x-midi audio/mid x-music/x-midi', 'Karaoke MIDI File', 0, 0);
163
INSERT INTO system_mimetype VALUES (61, 'kar', 'audio/midi audio/x-midi audio/mid x-music/x-midi', 'Karaoke MIDI File');
164
INSERT INTO system_mimetypes VALUES (62, 'mpga', 'audio/mpeg audio/mp3 audio/mgp audio/m-mpeg audio/x-mp3 audio/x-mpeg audio/x-mpg video/mpeg', 'Mpeg-1 Layer3 Audio Stream', 0, 0);
164
INSERT INTO system_mimetype VALUES (62, 'mpga', 'audio/mpeg audio/mp3 audio/mgp audio/m-mpeg audio/x-mp3 audio/x-mpeg audio/x-mpg video/mpeg', 'Mpeg-1 Layer3 Audio Stream');
165
INSERT INTO system_mimetypes VALUES (63, 'mp2', 'video/mpeg audio/mpeg', 'MPEG Audio Stream, Layer II', 0, 0);
165
INSERT INTO system_mimetype VALUES (63, 'mp2', 'video/mpeg audio/mpeg', 'MPEG Audio Stream, Layer II');
166
INSERT INTO system_mimetypes VALUES (64, 'mp3', 'audio/mpeg audio/x-mpeg audio/mp3 audio/x-mp3 audio/mpeg3 audio/x-mpeg3 audio/mpg audio/x-mpg audio/x-mpegaudio', 'MPEG Audio Stream, Layer III', 0, 0);
166
INSERT INTO system_mimetype VALUES (64, 'mp3', 'audio/mpeg audio/x-mpeg audio/mp3 audio/x-mp3 audio/mpeg3 audio/x-mpeg3 audio/mpg audio/x-mpg audio/x-mpegaudio', 'MPEG Audio Stream, Layer III');
167
INSERT INTO system_mimetypes VALUES (65, 'aif', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0);
167
INSERT INTO system_mimetype VALUES (65, 'aif', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/vnd.qcelp', 'Audio Interchange File');
168
INSERT INTO system_mimetypes VALUES (66, 'aiff', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/mid audio/x-midi audio/vnd.qcelp', 'Audio Interchange File', 0, 0);
168
INSERT INTO system_mimetype VALUES (66, 'aiff', 'audio/aiff audio/x-aiff sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/mid audio/x-midi audio/vnd.qcelp', 'Audio Interchange File');
169
INSERT INTO system_mimetypes VALUES (67, 'aifc', 'audio/aiff audio/x-aiff audio/x-aifc sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/mid audio/vnd.qcelp', 'Audio Interchange File', 0, 0);
169
INSERT INTO system_mimetype VALUES (67, 'aifc', 'audio/aiff audio/x-aiff audio/x-aifc sound/aiff audio/rmf audio/x-rmf audio/x-pn-aiff audio/x-gsm audio/x-midi audio/mid audio/vnd.qcelp', 'Audio Interchange File');
170
INSERT INTO system_mimetypes VALUES (68, 'm3u', 'audio/x-mpegurl audio/mpeg-url application/x-winamp-playlist audio/scpls audio/x-scpls', 'MP3 Playlist File', 0, 0);
170
INSERT INTO system_mimetype VALUES (68, 'm3u', 'audio/x-mpegurl audio/mpeg-url application/x-winamp-playlist audio/scpls audio/x-scpls', 'MP3 Playlist File');
171
INSERT INTO system_mimetypes VALUES (69, 'ram', 'audio/x-pn-realaudio audio/vnd.rn-realaudio audio/x-pm-realaudio-plugin audio/x-pn-realvideo audio/x-realaudio video/x-pn-realvideo text/plain', 'RealMedia Metafile', 0, 0);
171
INSERT INTO system_mimetype VALUES (69, 'ram', 'audio/x-pn-realaudio audio/vnd.rn-realaudio audio/x-pm-realaudio-plugin audio/x-pn-realvideo audio/x-realaudio video/x-pn-realvideo text/plain', 'RealMedia Metafile');
172
INSERT INTO system_mimetypes VALUES (70, 'rm', 'application/vnd.rn-realmedia audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin', 'RealMedia Streaming Media', 0, 0);
172
INSERT INTO system_mimetype VALUES (70, 'rm', 'application/vnd.rn-realmedia audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin', 'RealMedia Streaming Media');
173
INSERT INTO system_mimetypes VALUES (71, 'rpm', 'audio/x-pn-realaudio audio/x-pn-realaudio-plugin audio/x-pnrealaudio-plugin video/x-pn-realvideo-plugin audio/x-mpegurl application/octet-stream', 'RealMedia Player Plug-in', 0, 0);
173
INSERT INTO system_mimetype VALUES (71, 'rpm', 'audio/x-pn-realaudio audio/x-pn-realaudio-plugin audio/x-pnrealaudio-plugin video/x-pn-realvideo-plugin audio/x-mpegurl application/octet-stream', 'RealMedia Player Plug-in');
174
INSERT INTO system_mimetypes VALUES (72, 'ra', 'audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin video/x-pn-realvideo', 'RealMedia Streaming Media', 0, 0);
174
INSERT INTO system_mimetype VALUES (72, 'ra', 'audio/vnd.rn-realaudio audio/x-pn-realaudio audio/x-realaudio audio/x-pm-realaudio-plugin video/x-pn-realvideo', 'RealMedia Streaming Media');
175
INSERT INTO system_mimetypes VALUES (73, 'wav', 'audio/wav audio/x-wav audio/wave audio/x-pn-wav', 'Waveform Audio', 0, 0);
175
INSERT INTO system_mimetype VALUES (73, 'wav', 'audio/wav audio/x-wav audio/wave audio/x-pn-wav', 'Waveform Audio');
176
INSERT INTO system_mimetypes VALUES (74, 'wax', ' audio/x-ms-wax', 'Windows Media Audio Redirector', 0, 0);
176
INSERT INTO system_mimetype VALUES (74, 'wax', ' audio/x-ms-wax', 'Windows Media Audio Redirector');
177
INSERT INTO system_mimetypes VALUES (75, 'wma', 'audio/x-ms-wma video/x-ms-asf', 'Windows Media Audio File', 0, 0);
177
INSERT INTO system_mimetype VALUES (75, 'wma', 'audio/x-ms-wma video/x-ms-asf', 'Windows Media Audio File');
178
INSERT INTO system_mimetypes VALUES (76, 'bmp', 'image/bmp image/x-bmp image/x-bitmap image/x-xbitmap image/x-win-bitmap image/x-windows-bmp image/ms-bmp image/x-ms-bmp application/bmp application/x-bmp application/x-win-bitmap application/preview', 'Windows OS/2 Bitmap Graphics', 1, 1);
178
INSERT INTO system_mimetype VALUES (76, 'bmp', 'image/bmp image/x-bmp image/x-bitmap image/x-xbitmap image/x-win-bitmap image/x-windows-bmp image/ms-bmp image/x-ms-bmp application/bmp application/x-bmp application/x-win-bitmap application/preview', 'Windows OS/2 Bitmap Graphics');
179
INSERT INTO system_mimetypes VALUES (77, 'gif', 'image/gif image/x-xbitmap image/gi_', 'Graphic Interchange Format', 1, 1);
179
INSERT INTO system_mimetype VALUES (77, 'gif', 'image/gif image/x-xbitmap image/gi_', 'Graphic Interchange Format');
180
INSERT INTO system_mimetypes VALUES (78, 'ief', 'image/ief', 'Image File - Bitmap graphics', 0, 0);
180
INSERT INTO system_mimetype VALUES (78, 'ief', 'image/ief', 'Image File - Bitmap graphics');
181
INSERT INTO system_mimetypes VALUES (79, 'jpeg', 'image/jpeg image/jpg image/jpe_ image/pjpeg image/vnd.swiftview-jpeg', 'JPEG/JIFF Image', 1, 1);
181
INSERT INTO system_mimetype VALUES (79, 'jpeg', 'image/jpeg image/jpg image/jpe_ image/pjpeg image/vnd.swiftview-jpeg', 'JPEG/JIFF Image');
182
INSERT INTO system_mimetypes VALUES (80, 'jpg', 'image/jpeg image/jpg image/jp_ application/jpg application/x-jpg image/pjpeg image/pipeg image/vnd.swiftview-jpeg image/x-xbitmap', 'JPEG/JIFF Image', 1, 1);
182
INSERT INTO system_mimetype VALUES (80, 'jpg', 'image/jpeg image/jpg image/jp_ application/jpg application/x-jpg image/pjpeg image/pipeg image/vnd.swiftview-jpeg image/x-xbitmap', 'JPEG/JIFF Image');
183
INSERT INTO system_mimetypes VALUES (81, 'jpe', 'image/jpeg', 'JPEG/JIFF Image', 1, 1);
183
INSERT INTO system_mimetype VALUES (81, 'jpe', 'image/jpeg', 'JPEG/JIFF Image');
184
INSERT INTO system_mimetypes VALUES (82, 'png', 'image/png application/png application/x-png', 'Portable (Public) Network Graphic', 1, 1);
184
INSERT INTO system_mimetype VALUES (82, 'png', 'image/png application/png application/x-png', 'Portable (Public) Network Graphic');
185
INSERT INTO system_mimetypes VALUES (83, 'tiff', 'image/tiff', 'Tagged Image Format File', 1, 1);
185
INSERT INTO system_mimetype VALUES (83, 'tiff', 'image/tiff', 'Tagged Image Format File');
186
INSERT INTO system_mimetypes VALUES (84, 'tif', 'image/tif image/x-tif image/tiff image/x-tiff application/tif application/x-tif application/tiff application/x-tiff', 'Tagged Image Format File', 1, 1);
186
INSERT INTO system_mimetype VALUES (84, 'tif', 'image/tif image/x-tif image/tiff image/x-tiff application/tif application/x-tif application/tiff application/x-tiff', 'Tagged Image Format File');
187
INSERT INTO system_mimetypes VALUES (85, 'ico', 'image/ico image/x-icon application/ico application/x-ico application/x-win-bitmap image/x-win-bitmap application/octet-stream', 'Windows Icon', 0, 0);
187
INSERT INTO system_mimetype VALUES (85, 'ico', 'image/ico image/x-icon application/ico application/x-ico application/x-win-bitmap image/x-win-bitmap application/octet-stream', 'Windows Icon');
188
INSERT INTO system_mimetypes VALUES (86, 'wbmp', 'image/vnd.wap.wbmp', 'Wireless Bitmap File Format', 0, 0);
188
INSERT INTO system_mimetype VALUES (86, 'wbmp', 'image/vnd.wap.wbmp', 'Wireless Bitmap File Format');
189
INSERT INTO system_mimetypes VALUES (87, 'ras', 'application/ras application/x-ras image/ras', 'Sun Raster Graphic', 0, 0);
189
INSERT INTO system_mimetype VALUES (87, 'ras', 'application/ras application/x-ras image/ras', 'Sun Raster Graphic');
190
INSERT INTO system_mimetypes VALUES (88, 'pnm', 'image/x-portable-anymap', 'PBM Portable Any Map Graphic Bitmap', 0, 0);
190
INSERT INTO system_mimetype VALUES (88, 'pnm', 'image/x-portable-anymap', 'PBM Portable Any Map Graphic Bitmap');
191
INSERT INTO system_mimetypes VALUES (89, 'pbm', 'image/portable bitmap image/x-portable-bitmap image/pbm image/x-pbm', 'UNIX Portable Bitmap Graphic', 0, 0);
191
INSERT INTO system_mimetype VALUES (89, 'pbm', 'image/portable bitmap image/x-portable-bitmap image/pbm image/x-pbm', 'UNIX Portable Bitmap Graphic');
192
INSERT INTO system_mimetypes VALUES (90, 'pgm', 'image/x-portable-graymap image/x-pgm', 'Portable Graymap Graphic', 0, 0);
192
INSERT INTO system_mimetype VALUES (90, 'pgm', 'image/x-portable-graymap image/x-pgm', 'Portable Graymap Graphic');
193
INSERT INTO system_mimetypes VALUES (91, 'ppm', 'image/x-portable-pixmap application/ppm application/x-ppm image/x-p image/x-ppm', 'PBM Portable Pixelmap Graphic', 0, 0);
193
INSERT INTO system_mimetype VALUES (91, 'ppm', 'image/x-portable-pixmap application/ppm application/x-ppm image/x-p image/x-ppm', 'PBM Portable Pixelmap Graphic');
194
INSERT INTO system_mimetypes VALUES (92, 'rgb', 'image/rgb image/x-rgb', 'Silicon Graphics RGB Bitmap', 0, 0);
194
INSERT INTO system_mimetype VALUES (92, 'rgb', 'image/rgb image/x-rgb', 'Silicon Graphics RGB Bitmap');
195
INSERT INTO system_mimetypes VALUES (93, 'xbm', 'image/x-xpixmap image/x-xbitmap image/xpm image/x-xpm', 'X Bitmap Graphic', 0, 0);
195
INSERT INTO system_mimetype VALUES (93, 'xbm', 'image/x-xpixmap image/x-xbitmap image/xpm image/x-xpm', 'X Bitmap Graphic');
196
INSERT INTO system_mimetypes VALUES (94, 'xpm', 'image/x-xpixmap', 'BMC Software Patrol UNIX Icon File', 0, 0);
196
INSERT INTO system_mimetype VALUES (94, 'xpm', 'image/x-xpixmap', 'BMC Software Patrol UNIX Icon File');
197
INSERT INTO system_mimetypes VALUES (95, 'xwd', 'image/x-xwindowdump image/xwd image/x-xwd application/xwd application/x-xwd', 'X Windows Dump', 0, 0);
197
INSERT INTO system_mimetype VALUES (95, 'xwd', 'image/x-xwindowdump image/xwd image/x-xwd application/xwd application/x-xwd', 'X Windows Dump');
198
INSERT INTO system_mimetypes VALUES (96, 'igs', 'model/iges application/iges application/x-iges application/igs application/x-igs drawing/x-igs image/x-igs', 'Initial Graphics Exchange Specification Format', 0, 0);
198
INSERT INTO system_mimetype VALUES (96, 'igs', 'model/iges application/iges application/x-iges application/igs application/x-igs drawing/x-igs image/x-igs', 'Initial Graphics Exchange Specification Format');
199
INSERT INTO system_mimetypes VALUES (97, 'css', 'application/css-stylesheet text/css', 'Hypertext Cascading Style Sheet', 0, 0);
199
INSERT INTO system_mimetype VALUES (97, 'css', 'application/css-stylesheet text/css', 'Hypertext Cascading Style Sheet');
200
INSERT INTO system_mimetypes VALUES (98, 'html', 'text/html text/plain', 'Hypertext Markup Language', 0, 0);
200
INSERT INTO system_mimetype VALUES (98, 'html', 'text/html text/plain', 'Hypertext Markup Language');
201
INSERT INTO system_mimetypes VALUES (99, 'htm', 'text/html', 'Hypertext Markup Language', 0, 0);
201
INSERT INTO system_mimetype VALUES (99, 'htm', 'text/html', 'Hypertext Markup Language');
202
INSERT INTO system_mimetypes VALUES (100, 'txt', 'text/plain application/txt browser/internal', 'Text File', 1, 1);
202
INSERT INTO system_mimetype VALUES (100, 'txt', 'text/plain application/txt browser/internal', 'Text File');
203
INSERT INTO system_mimetypes VALUES (101, 'rtf', 'application/rtf application/x-rtf text/rtf text/richtext application/msword application/doc application/x-soffice', 'Rich Text Format File', 1, 1);
203
INSERT INTO system_mimetype VALUES (101, 'rtf', 'application/rtf application/x-rtf text/rtf text/richtext application/msword application/doc application/x-soffice', 'Rich Text Format File');
204
INSERT INTO system_mimetypes VALUES (102, 'wml', 'text/vnd.wap.wml text/wml', 'Website META Language File', 0, 0);
204
INSERT INTO system_mimetype VALUES (102, 'wml', 'text/vnd.wap.wml text/wml', 'Website META Language File');
205
INSERT INTO system_mimetypes VALUES (103, 'wmls', 'text/vnd.wap.wmlscript', 'WML Script', 0, 0);
205
INSERT INTO system_mimetype VALUES (103, 'wmls', 'text/vnd.wap.wmlscript', 'WML Script');
206
INSERT INTO system_mimetypes VALUES (104, 'etx', 'text/x-setext', 'SetText Structure Enhanced Text', 0, 0);
206
INSERT INTO system_mimetype VALUES (104, 'etx', 'text/x-setext', 'SetText Structure Enhanced Text');
207
INSERT INTO system_mimetypes VALUES (105, 'xml', 'text/xml application/xml application/x-xml', 'Extensible Markup Language File', 0, 0);
207
INSERT INTO system_mimetype VALUES (105, 'xml', 'text/xml application/xml application/x-xml', 'Extensible Markup Language File');
208
INSERT INTO system_mimetypes VALUES (106, 'xsl', 'text/xml', 'XML Stylesheet', 0, 0);
208
INSERT INTO system_mimetype VALUES (106, 'xsl', 'text/xml', 'XML Stylesheet');
209
INSERT INTO system_mimetypes VALUES (107, 'php', 'text/php application/x-httpd-php application/php magnus-internal/shellcgi application/x-php', 'PHP Script', 0, 0);
209
INSERT INTO system_mimetype VALUES (107, 'php', 'text/php application/x-httpd-php application/php magnus-internal/shellcgi application/x-php', 'PHP Script');
210
INSERT INTO system_mimetypes VALUES (108, 'php3', 'text/php3 application/x-httpd-php', 'PHP Script', 0, 0);
210
INSERT INTO system_mimetype VALUES (108, 'php3', 'text/php3 application/x-httpd-php', 'PHP Script');
211
INSERT INTO system_mimetypes VALUES (109, 'mpeg', 'video/mpeg', 'MPEG Movie', 0, 0);
211
INSERT INTO system_mimetype VALUES (109, 'mpeg', 'video/mpeg', 'MPEG Movie');
212
INSERT INTO system_mimetypes VALUES (110, 'mpg', 'video/mpeg video/mpg video/x-mpg video/mpeg2 application/x-pn-mpg video/x-mpeg video/x-mpeg2a audio/mpeg audio/x-mpeg image/mpg', 'MPEG 1 System Stream', 0, 0);
212
INSERT INTO system_mimetype VALUES (110, 'mpg', 'video/mpeg video/mpg video/x-mpg video/mpeg2 application/x-pn-mpg video/x-mpeg video/x-mpeg2a audio/mpeg audio/x-mpeg image/mpg', 'MPEG 1 System Stream');
213
INSERT INTO system_mimetypes VALUES (111, 'mpe', 'video/mpeg', 'MPEG Movie Clip', 0, 0);
213
INSERT INTO system_mimetype VALUES (111, 'mpe', 'video/mpeg', 'MPEG Movie Clip');
214
INSERT INTO system_mimetypes VALUES (112, 'qt', 'video/quicktime audio/aiff audio/x-wav video/flc', 'QuickTime Movie', 0, 0);
214
INSERT INTO system_mimetype VALUES (112, 'qt', 'video/quicktime audio/aiff audio/x-wav video/flc', 'QuickTime Movie');
215
INSERT INTO system_mimetypes VALUES (113, 'mov', 'video/quicktime video/x-quicktime image/mov audio/aiff audio/x-midi audio/x-wav video/avi', 'QuickTime Video Clip', 0, 0);
215
INSERT INTO system_mimetype VALUES (113, 'mov', 'video/quicktime video/x-quicktime image/mov audio/aiff audio/x-midi audio/x-wav video/avi', 'QuickTime Video Clip');
216
INSERT INTO system_mimetypes VALUES (114, 'avi', 'video/avi video/msvideo video/x-msvideo image/avi video/xmpg2 application/x-troff-msvideo audio/aiff audio/avi', 'Audio Video Interleave File', 0, 0);
216
INSERT INTO system_mimetype VALUES (114, 'avi', 'video/avi video/msvideo video/x-msvideo image/avi video/xmpg2 application/x-troff-msvideo audio/aiff audio/avi', 'Audio Video Interleave File');
217
INSERT INTO system_mimetypes VALUES (115, 'movie', 'video/sgi-movie video/x-sgi-movie', 'QuickTime Movie', 0, 0);
217
INSERT INTO system_mimetype VALUES (115, 'movie', 'video/sgi-movie video/x-sgi-movie', 'QuickTime Movie');
218
INSERT INTO system_mimetypes VALUES (116, 'asf', 'audio/asf application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx', 'Advanced Streaming Format', 0, 0);
218
INSERT INTO system_mimetype VALUES (116, 'asf', 'audio/asf application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx', 'Advanced Streaming Format');
219
INSERT INTO system_mimetypes VALUES (117, 'asx', 'video/asx application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx video/x-la-asf', 'Advanced Stream Redirector File', 0, 0);
219
INSERT INTO system_mimetype VALUES (117, 'asx', 'video/asx application/asx video/x-ms-asf-plugin application/x-mplayer2 video/x-ms-asf application/vnd.ms-asf video/x-ms-asf-plugin video/x-ms-wm video/x-ms-wmx video/x-la-asf', 'Advanced Stream Redirector File');
220
INSERT INTO system_mimetypes VALUES (118, 'wmv', 'video/x-ms-wmv', 'Windows Media File', 0, 0);
220
INSERT INTO system_mimetype VALUES (118, 'wmv', 'video/x-ms-wmv', 'Windows Media File');
221
INSERT INTO system_mimetypes VALUES (119, 'wvx', 'video/x-ms-wvx', 'Windows Media Redirector', 0, 0);
221
INSERT INTO system_mimetype VALUES (119, 'wvx', 'video/x-ms-wvx', 'Windows Media Redirector');
222
INSERT INTO system_mimetypes VALUES (120, 'wm', 'video/x-ms-wm', 'Windows Media A/V File', 0, 0);
222
INSERT INTO system_mimetype VALUES (120, 'wm', 'video/x-ms-wm', 'Windows Media A/V File');
223
INSERT INTO system_mimetypes VALUES (121, 'wmx', 'video/x-ms-wmx', 'Windows Media Player A/V Shortcut', 0, 0);
223
INSERT INTO system_mimetype VALUES (121, 'wmx', 'video/x-ms-wmx', 'Windows Media Player A/V Shortcut');
224
INSERT INTO system_mimetypes VALUES (122, 'ice', 'x-conference-xcooltalk', 'Cooltalk Audio', 0, 0);
224
INSERT INTO system_mimetype VALUES (122, 'ice', 'x-conference-xcooltalk', 'Cooltalk Audio');
225
INSERT INTO system_mimetypes VALUES (123, 'rar', 'application/octet-stream', 'WinRAR Compressed Archive', 0, 0);
225
INSERT INTO system_mimetype VALUES (123, 'rar', 'application/octet-stream', 'WinRAR Compressed Archive');
 
 
226
INSERT INTO `group_permission` (`gperm_id`, `gperm_groupid`, `gperm_itemid`, `gperm_modid`, `gperm_name`) VALUES
 
 
227
(NULL, 2, 20, 1, 'use_extension'),
 
 
228
(NULL, 1, 20, 1, 'use_extension'),
 
 
229
(NULL, 2, 19, 1, 'use_extension'),
 
 
230
(NULL, 1, 19, 1, 'use_extension'),
 
 
231
(NULL, 2, 76, 1, 'use_extension'),
 
 
232
(NULL, 1, 76, 1, 'use_extension'),
 
 
233
(NULL, 2, 77, 1, 'use_extension'),
 
 
234
(NULL, 1, 77, 1, 'use_extension'),
 
 
235
(NULL, 2, 82, 1, 'use_extension'),
 
 
236
(NULL, 1, 82, 1, 'use_extension'),
 
 
237
(NULL, 2, 79, 1, 'use_extension'),
 
 
238
(NULL, 1, 79, 1, 'use_extension'),
 
 
239
(NULL, 2, 80, 1, 'use_extension'),
 
 
240
(NULL, 1, 80, 1, 'use_extension'),
 
 
241
(NULL, 2, 81, 1, 'use_extension'),
 
 
242
(NULL, 1, 81, 1, 'use_extension'),
 
 
243
(NULL, 2, 83, 1, 'use_extension'),
 
 
244
(NULL, 1, 83, 1, 'use_extension'),
 
 
245
(NULL, 2, 84, 1, 'use_extension'),
 
 
246
(NULL, 1, 84, 1, 'use_extension'),
 
 
247
(NULL, 2, 100, 1, 'use_extension'),
 
 
248
(NULL, 1, 100, 1, 'use_extension'),
 
 
249
(NULL, 2, 101, 1, 'use_extension'),
 
 
250
(NULL, 1, 101, 1, 'use_extension');
88148815
665
) TYPE=MyISAM;
665
) TYPE=MyISAM;
666
 
666
 
667
#
667
#
668
# Table structure for table `system_mimetypes`
668
# Table structure for table `system_mimetype`
669
#
669
#
670
 
670
 
671
CREATE TABLE system_mimetypes (
671
CREATE TABLE system_mimetype (
672
  mime_id int(11) NOT NULL auto_increment,
672
  mimetypeid int(11) NOT NULL auto_increment,
673
  mime_name varchar(255) NOT NULL default '',
673
  extension varchar(60) NOT NULL default '',
674
  mime_ext varchar(60) NOT NULL default '',
674
  types text NOT NULL,
675
  mime_text varchar(60) NOT NULL default '',
675
  name varchar(255) NOT NULL default '',
676
  mime_admin int(1) NOT NULL default '1',
676
  KEY mimetypeid (mimetypeid)
677
  mime_user int(1) NOT NULL default '0',
 
 
678
  KEY mime_id (mime_id)
 
 
679
) TYPE=MyISAM;
677
) TYPE=MyISAM;
 
 
678
 
 
 
679
#
 
 
680
# Table structure for table `system_adsense`
 
 
681
#
 
 
682
 
 
 
683
CREATE TABLE system_adsense (
 
 
684
  adsenseid int(11) NOT NULL auto_increment,
 
 
685
  format VARCHAR(100) NOT NULL,
 
 
686
  description TEXT NOT NULL,
 
 
687
  style TEXT NOT NULL,
 
 
688
  border_color varchar(6) NOT NULL default '',
 
 
689
  background_color varchar(6) NOT NULL default '',
 
 
690
  link_color varchar(6) NOT NULL default '',
 
 
691
  url_color varchar(6) NOT NULL default '',
 
 
692
  text_color varchar(6) NOT NULL default '',
 
 
693
  client_id varchar(100) NOT NULL default '',
 
 
694
  tag varchar(50) NOT NULL default '',
 
 
695
  PRIMARY KEY  (`adsenseid`)
 
 
696
) TYPE=MyISAM;
 
 
697
 
 
 
698
#
 
 
699
# Table structure for table `system_rating`
 
 
700
#
 
 
701
 
 
 
702
CREATE TABLE system_rating (
 
 
703
  ratingid int(11) NOT NULL auto_increment,
 
 
704
  dirname VARCHAR(255) NOT NULL,
 
 
705
  item VARCHAR(255) NOT NULL,
 
 
706
  itemid int(11) NOT NULL,
 
 
707
  uid int(11) NOT NULL,
 
 
708
  rate int(1) NOT NULL,
 
 
709
  date int(11) NOT NULL,
 
 
710
  PRIMARY KEY  (`ratingid`)
 
 
711
) TYPE=MyISAM;
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff
File was changed - ok, show the diff