wfdownloads_v2.0.2.php

在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.

<?php
if (!defined('IS_UPDATE_FILE')) {
	echo "Cannot access this file directly!";
	exit();
}

/**
 * $Id: wfdownload_v2.0.2.php v 1.00 06 july 2004 Catwolf Exp $
 * Module: WF-Downloads
 * Version: v2.0.5
 * Release Date: 25 july 2004
 * Author: WF-Sections
 * Licence: GNU
 */
    $error = array();
    $output = array(); 
    // $Ndelete_table = "could not delete table $table_arr as it does not exist!";
    // $delete_table = "Table $table_arr was deleted succsefully\"\"";
    // Delete new installed tbales for WF-Downloads
    $table_array = array("wfdownloads_broken",
        "wfdownloads_cat",
        "wfdownloads_downloads",
        "wfdownloads_mimetypes",
        "wfdownloads_mod",
        "wfdownloads_reviews",
        "wfdownloads_votedata",
        "wfdownloads_indexpage"
        );

    foreach ($table_array as $table_arr)
    {
        $result = $xoopsDB -> queryF("DROP TABLE " . $xoopsDB -> prefix($table_arr) . " ");
        if (!$result)
        {
            $error[] = "<b>Error:</b> Could <span style='color:#ff0000;font-weight:bold'>not delete</span> table <b>$table_arr</b> as it does not exist!";
        } 
        else
        {
            $output[] = "<b>Success:</b> Table <b>$table_arr</b> was <span style='color:#FF0000;font-weight:bold'>delete</span> Successfully";
        } 
    } 

    $table = "wfdownloads_mimetypes";
    $result = $xoopsDB -> queryF("CREATE TABLE `" . $xoopsDB -> prefix("wfdownloads_mimetypes") . "` (
  	mime_id int(11) NOT NULL auto_increment,
  	mime_ext varchar(60) NOT NULL default '',
  	mime_types text NOT NULL,
  	mime_name varchar(255) NOT NULL default '',
 	mime_admin int(1) NOT NULL default '1',
  	mime_user int(1) NOT NULL default '0',
  	KEY mime_id (mime_id)
	)");
    if (!$result)
    {
        $error[] = "<b>Error:</b> Could <span style='color:#ff0000;font-weight:bold'>not create</span> new table <b>$table</b>!";
    } 
    else
    {
        $output[] = "<b>Success:</b> Table <b>$table</b> was <span style='color:#FF0000;font-weight:bold'>created</span> Successfully";
    } 
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (1, 'bin', 'application/octet-stream', 'Binary File/Linux Executable', 0, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (2, 'dms', 'application/octet-stream', 'Amiga DISKMASHER Compressed Archive', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (3, 'class', 'application/octet-stream', 'Java Bytecode', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (4, 'so', 'application/octet-stream', 'UNIX Shared Library Function', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (5, 'dll', 'application/octet-stream', 'Dynamic Link Library', 0, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (6, 'hqx', 'application/binhex application/mac-binhex application/mac-binhex40', 'Macintosh BinHex 4 Compressed Archive', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (7, 'cpt', 'application/mac-compactpro application/compact_pro', 'Compact Pro Archive', 0, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (8, 'lha', 'application/lha application/x-lha application/octet-stream application/x-compress application/x-compressed application/maclha', 'Compressed Archive File', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_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', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (10, 'sh', 'application/x-shar', 'UNIX shar Archive File', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (11, 'shar', 'application/x-shar', 'UNIX shar Archive File', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (12, 'tar', 'application/tar application/x-tar applicaton/x-gtar multipart/x-tar application/x-compress application/x-compressed', 'Tape Archive File', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (13, 'gtar', 'application/x-gtar', 'GNU tar Compressed File Archive', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (14, 'ustar', 'application/x-ustar multipart/x-ustar', 'POSIX tar Compressed Archive', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_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', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_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)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (17, 'wmz', 'application/x-ms-wmz', 'Windows Media Compressed Skin File', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (18, 'wmd', 'application/x-ms-wmd', 'Windows Media Download File', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_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, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (20, 'pdf', 'application/pdf application/acrobat application/x-pdf applications/vnd.pdf text/pdf', 'Acrobat Portable Document Format', 0, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (21, 'eps', 'application/eps application/postscript application/x-eps image/eps image/x-eps', 'Encapsulated PostScript', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (22, 'ps', 'application/postscript application/ps application/x-postscript application/x-ps text/postscript', 'PostScript', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (23, 'smi', 'application/smil', 'SMIL Multimedia', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (24, 'smil', 'application/smil', 'Synchronized Multimedia Integration Language', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (25, 'wmlc', 'application/vnd.wap.wmlc ', 'Compiled WML Document', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (26, 'wmlsc', 'application/vnd.wap.wmlscriptc', 'Compiled WML Script', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (27, 'vcd', 'application/x-cdlink', 'Virtual CD-ROM CD Image File', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (28, 'pgn', 'application/formstore', 'Picatinny Arsenal Electronic Formstore Form in TIFF Format', 1, 0)");
    $xoopsDB -> query("INSERT INTO " . $xoopsDB -> prefix("wfdownloads_mimetypes") . " VALUES (29, 'cpio', 'application/x-cpio', 'UNIX CPIO Archive', 1, 0)");