PHP Colorizer_VtUtils::checkColumnの例

コード例 #1

ファイル: checkDB.php プロジェクト: Wasage/werpa

    ${${"GLOBALS"}["juxvldty"]} = $adb->query_result(${${"GLOBALS"}["mosecxr"]}, 0, "collation");
    $bsxaogsunwh = "collation";
    if (${$bsxaogsunwh} != ${${"GLOBALS"}["juxvldty"]}) {
        ${"GLOBALS"}["vshetmcv"] = "refcollation";
        ${"GLOBALS"}["ytwkimp"] = "refcollation";
        ${${"GLOBALS"}["ibxeqksvn"]} = explode("_", ${${"GLOBALS"}["ytwkimp"]});
        $adb->pquery("ALTER TABLE  `vtiger_colorizer` CONVERT TO CHARACTER SET " . ${${"GLOBALS"}["ibxeqksvn"]}[0] . " COLLATE " . ${${"GLOBALS"}["vshetmcv"]});
    }
}
${${"GLOBALS"}["mbppeiwxnu"]} = PearDatabase::getInstance();
${$owvpsnerpoa} = "DELETE FROM vtiger_links WHERE linklabel = \"Colorizer\"";
$adb->pquery(${${"GLOBALS"}["hoecflxt"]});
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "summaryview", "TINYINT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "detailview", "TINYINT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "listview", "TINYINT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "editview", "TINYINT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "condition", "TEXT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "tabid", "int(11)");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "block", "varchar(50)");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "field", "varchar(50)");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "priority", "tinyint(4)");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "settings", "TEXT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "labelSettings", "TEXT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "actions", "TEXT");
\Colorizer_VtUtils::checkColumn("vtiger_colorizer", "additional", "TEXT");
if (!\Colorizer_VtUtils::existTable("vtiger_colorizer_config")) {
    echo "Create table vtiger_colorizer_config ... ok<br>";
    $adb->pquery("CREATE TABLE IF NOT EXISTS `vtiger_colorizer_config` (\n    \t\t\t\t\t  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,\n    \t\t\t\t\t  `version` float NOT NULL,\n    \t\t\t\t\t  `license` varchar(64) NOT NULL DEFAULT 'demo',\n    \t\t\t\t\t  `license_for` varchar(64) NOT NULL,\n    \t\t\t\t\t  `last_hash` varchar(64) NOT NULL DEFAULT 'demo',\n    \t\t\t\t\t  `config` blob NOT NULL,\n    \t\t\t\t\t  `modify` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n    \t\t\t\t\t  PRIMARY KEY (`id`)\n    \t\t\t\t\t) ENGINE=InnoDB;");
}
Colorizer_checkCollation("vtiger_colorizer", "vtiger_tab");
Colorizer_checkCollation("vtiger_colorizer_config", "vtiger_tab");