⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 mydownloads_update.php

📁 在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.
💻 PHP
📖 第 1 页 / 共 3 页
字号:
🔍
123 
    } 

    /**
     * Update broken downloads
     */
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_broken") . " ADD date varchar(11) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_broken") . " ADD confirmed enum('0', '1') NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_broken") . " ADD acknowledged enum('0', '1') NOT null default '0'");
    /**
     * Update category
     */
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD description text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD summary text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD spotlighttop int(1) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD spotlighthis int(11) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD nohtml int(1) NOT null default '1'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD nosmiley int(1) NOT null default '1'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD noxcodes int(1) NOT null default '1'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD noimages int(1) NOT null default '1'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD nobreak int(1) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_cat") . " ADD weight int(11) NOT null default '0'");

    /**
     * Update downloads database
     */
    /**
     */
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " CHANGE url url varchar(255) NOT NULL default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " CHANGE logourl screenshot varchar(255) NOT NULL default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " CHANGE homepage homepage varchar(255) NOT NULL default ''");
    /**
     * Add new fields
     */
    $time = time();
	$result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD screenshot varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD publisher varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD license varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD mirror varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD price varchar(10) NOT null default 'Free'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD paypalemail varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD features text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD requirements text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD homepagetitle varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD forumid int(11) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD limitations varchar(255) NOT null default '30 day trial'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD dhistory text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD published int(10) NOT null default '$time'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD expired int(10) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD updated int(11) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD offline tinyint(1) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD description text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD ipaddress varchar(120) NOT NULL default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_downloads") . " ADD notifypub int(1) NOT NULL default '0'");

    /**
     * Downloads modified
     */
    /**
     * Change some fields
     */
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " CHANGE title title varchar(255) NOT NULL default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " CHANGE url url varchar(255) NOT NULL default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " CHANGE logourl screenshot varchar(255) NOT NULL default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " CHANGE homepage homepage varchar(255) NOT NULL default ''"); 
    // Add new fields
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD screenshot varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD publisher varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD license varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD mirror varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD price varchar(10) NOT null default 'Free'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD paypalemail varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD features text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD requirements text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD homepagetitle varchar(255) NOT null default ''");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD forumid int(11) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD limitations varchar(255) NOT null default '30 day trial'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD dhistory text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD published int(10) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD expired int(10) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD updated int(11) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD offline tinyint(1) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD description text NOT null");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD modifysubmitter int(11) NOT null default '0'");
    $result = $xoopsDB -> queryF("ALTER TABLE " . $xoopsDB -> prefix("wfdownloads_mod") . " ADD requestdate int(11) NOT null default '0'");
    /**
     * Update decription fields by moving them to the download database table
     */
    $sql = "SELECT * FROM " . $xoopsDB -> prefix('mydownloads_text') . "" ;
    $result2 = $xoopsDB -> query($sql);
    while ($arr = $xoopsDB -> fetchArray($result2))
    {
        $xoopsDB -> queryF("UPDATE " . $xoopsDB -> prefix("wfdownloads_downloads") . " SET description = '" . $arr['description'] . "' WHERE lid = " . $arr['lid'] . "");
    } 
	$result = $xoopsDB->queryF("DROP TABLE ".$xoopsDB->prefix("mydownloads_text")." ");
    /**
     * Update comments
     */
    $modhandler = & xoops_gethandler('module');
    $wfdownloadModule = & $modhandler -> getByDirname("wfdownloads");
    $wf_id = $wfdownloadModule -> getVar('mid');

    $modhandler = & xoops_gethandler('module');
    $downloadModule = & $modhandler -> getByDirname("mydownloads");
    $my_id = $downloadModule -> getVar('mid');
    echo $my_id;
    $sql = "UPDATE " . $xoopsDB -> prefix("xoopscomments") . " SET com_modid = $wf_id WHERE com_modid = $my_id";
    $result2 = $xoopsDB -> queryF($sql);

    echo "<p>...Updating</p>\n";
    if (count($error))
    {
        foreach($error as $err)
        {
            echo $err . "<br>";
        } 
    } 
    if (count($output))
    {
        echo "<p><span style='color:#0000FF;font-weight:bold'>There where updates made to your database. <br />Any questions? Please contact the support team at the <br><h4><a href='http://wfsections.xoops2.com'>WF-Section website</a></h4></span></p>\n";
        foreach($output as $nonerr)
        {
            echo $nonerr . "<br>";
        } 
    } 
    echo "<p><span><a href=''>Finish updating Module</a></span></p>\n";

?>
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -