📄 rss2sql.php
字号:
$_POST["ItemGuid"] = $config["ItemGuid"]; } $_POST["ItemAuthor"] = "ItemAuthor"; if (isset($config["ItemAuthor"])) { $_POST["ItemAuthor"] = $config["ItemAuthor"]; } $_POST["ItemComments"] = "ItemComments"; if (isset($config["ItemComments"])) { $_POST["ItemComments"] = $config["ItemComments"]; } $_POST["ItemSource"] = "ItemSource"; if (isset($config["ItemSource"])) { $_POST["ItemSource"] = $config["ItemSource"]; } $_POST["ItemSourceUrl"] = "ItemSourceUrl"; if (isset($config["ItemSourceUrl"])) { $_POST["ItemSourceUrl"] = $config["ItemSourceUrl"]; } $_POST["ItemCategory"] = "ItemCategory"; if (isset($config["ItemCategory"])) { $_POST["ItemCategory"] = $config["ItemCategory"]; } $_POST["ItemCategoryDomain"] = "ItemCategoryDomain"; if (isset($config["ItemCategoryDomain"])) { $_POST["ItemCategoryDomain"] = $config["ItemCategoryDomain"]; } $_POST["ItemCreativeCommons"] = "ItemCreativeCommons"; if (isset($config["ItemCreativeCommons"])) { $_POST["ItemCreativeCommons"] = $config["ItemCreativeCommons"]; } if (FeedForAll_parseExtensions() === TRUE) { FeedForAll_parseExtensions_rss2sql_buildConfig($config, $_POST, 1); } ob_start(); @require_once($ConfigFilename); ob_end_clean(); } if (!headers_sent()) { // Send the Content-Type to force UTF-8 header("Content-Type: text/html; charset=UTF-8"); } if (!isset($_REQUEST["TEST"])) { echo "<html><head><title>rss2sql.php Configuration tool</title></head><body bgcolor=\"#EEEEFF\">\n"; } if (($_SERVER["REQUEST_METHOD"] == "POST") || (isset($_REQUEST["TEST"]) && ($_REQUEST["TEST"] == "Testing"))) { if ($_POST["DBconfigFile"] == "") { echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "DBconfigFile" must have a values</div><br>\n"; } else { if (!isset($_REQUEST["TEST"])) { if ($_POST["feedInfo"] == "") { $_POST["feedInfo"] = "feedInfo"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "feedInfo" must have a value, default used</div><br>\n"; } if ($_POST["feedURL"] == "") { $_POST["feedURL"] = "feedURL"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "feedURL" must have a value, default used</div><br>\n"; } if ($_POST["ItemTable"] == "") { $_POST["ItemTable"] = "feedItems"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "ItemTable" must have a value, default used</div><br>\n"; } if ($_POST["feedID"] == "") { $_POST["feedID"] = "feedID"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "feedID" must have a value, default used</div><br>\n"; } if ($_POST["feedID"] == "") { $_POST["feedID"] = "feedID"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "feedID" must have a value, default used</div><br>\n"; } if ($_POST["feedActive"] == "") { $_POST["feedActive"] = "feedActive"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "feedActive" must have a value, default used</div><br>\n"; } if ($_POST["updateInterval"] == "") { $_POST["updateInterval"] = "updateInterval"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "updateInterval" must have a value, default used</div><br>\n"; } if ($_POST["lastUpdate"] == "") { $_POST["lastUpdate"] = "lastUpdate"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "lastUpdate" must have a value, default used</div><br>\n"; } if ($_POST["nextUpdate"] == "") { $_POST["nextUpdate"] = "nextUpdate"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "nextUpdate" must have a value, default used</div><br>\n"; } if ($_POST["updateStatus"] == "") { $_POST["updateStatus"] = "updateStatus"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "updateStatus" must have a value, default used</div><br>\n"; } if ($_POST["updateStatusCount"] == "") { $_POST["updateStatusCount"] = "updateStatusCount"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "updateStatusCount" must have a value, default used</div><br>\n"; } if ($_POST["itemID"] == "") { $_POST["itemID"] = "itemID"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "itemID" must have a value, default used</div><br>\n"; } if ($_POST["UniqueItemID"] == "") { $_POST["UniqueItemID"] = "CreatedUniqueID"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "UniqueItemID" must have a value, default used</div><br>\n"; } if ($_POST["ItemAddedTime"] == "") { $_POST["ItemAddedTime"] = "ItemAddedTime"; echo "<div style=\"color: red; font-weight: 150%;\">ERROR: "ItemAddedTime" must have a value, default used</div><br>\n"; } echo "Copy between the dividers below and save as the configuration file<br>\n"; echo "<br>================= Start of file =================\n"; echo "<pre>\n"; echo "<?PHP\n\n"; echo "\$config[\"DBconfigFile\"] = \"$_POST[DBconfigFile]\";\n\n"; echo "\$config[\"feedInfo\"] = \"$_POST[feedInfo]\";\n"; echo "\$config[\"feedID\"] = \"$_POST[feedID]\";\n"; echo "\$config[\"feedActive\"] = \"$_POST[feedActive]\";\n"; echo "\$config[\"feedURL\"] = \"$_POST[feedURL]\";\n"; echo "\$config[\"updateInterval\"] = \"$_POST[updateInterval]\";\n"; echo "\$config[\"lastUpdate\"] = \"$_POST[lastUpdate]\";\n"; echo "\$config[\"nextUpdate\"] = \"$_POST[nextUpdate]\";\n"; echo "\$config[\"updateStatus\"] = \"$_POST[updateStatus]\";\n"; echo "\$config[\"updateStatusCount\"] = \"$_POST[updateStatusCount]\";\n\n"; echo "\$config[\"ItemTable\"] = \"$_POST[ItemTable]\";\n"; echo "\$config[\"itemID\"] = \"$_POST[itemID]\";\n"; echo "\$config[\"UniqueItemID\"] = \"$_POST[UniqueItemID]\";\n"; echo "\$config[\"ItemAddedTime\"] = \"$_POST[ItemAddedTime]\";\n"; if ($_POST["ItemTitle"] != "") { echo "\$config[\"ItemTitle\"] = \"$_POST[ItemTitle]\";\n"; } if ($_POST["ItemDescription"] != "") { echo "\$config[\"ItemDescription\"] = \"$_POST[ItemDescription]\";\n"; } if ($_POST["ItemContentEncoded"] != "") { echo "\$config[\"ItemContentEncoded\"] = \"$_POST[ItemContentEncoded]\";\n"; } if ($_POST["ItemLink"] != "") { echo "\$config[\"ItemLink\"] = \"$_POST[ItemLink]\";\n"; } if ($_POST["ItemPubDate"] != "") { echo "\$config[\"ItemPubDate\"] = \"$_POST[ItemPubDate]\";\n"; } if ($_POST["ItemPubDate_t"] != "") { echo "\$config[\"ItemPubDate_t\"] = \"$_POST[ItemPubDate_t]\";\n"; } if ($_POST["ItemEnclosureUrl"] != "") { echo "\$config[\"ItemEnclosureUrl\"] = \"$_POST[ItemEnclosureUrl]\";\n"; } if ($_POST["ItemEnclosureType"] != "") { echo "\$config[\"ItemEnclosureType\"] = \"$_POST[ItemEnclosureType]\";\n"; } if ($_POST["ItemEnclosureLength"] != "") { echo "\$config[\"ItemEnclosureLength\"] = \"$_POST[ItemEnclosureLength]\";\n"; } if ($_POST["ItemGuid"] != "") { echo "\$config[\"ItemGuid\"] = \"$_POST[ItemGuid]\";\n"; } if ($_POST["ItemAuthor"] != "") { echo "\$config[\"ItemAuthor\"] = \"$_POST[ItemAuthor]\";\n"; } if ($_POST["ItemComments"] != "") { echo "\$config[\"ItemComments\"] = \"$_POST[ItemComments]\";\n"; } if ($_POST["ItemSource"] != "") { echo "\$config[\"ItemSource\"] = \"$_POST[ItemSource]\";\n"; } if ($_POST["ItemSourceUrl"] != "") { echo "\$config[\"ItemSourceUrl\"] = \"$_POST[ItemSourceUrl]\";\n"; } if ($_POST["ItemCategory"] != "") { echo "\$config[\"ItemCategory\"] = \"$_POST[ItemCategory]\";\n"; } if ($_POST["ItemCategoryDomain"] != "") { echo "\$config[\"ItemCategoryDomain\"] = \"$_POST[ItemCategoryDomain]\";\n"; } if ($_POST["ItemCreativeCommons"] != "") { echo "\$config[\"ItemCreativeCommons\"] = \"$_POST[ItemCreativeCommons]\";\n"; } if (FeedForAll_parseExtensions() === TRUE) { FeedForAll_parseExtensions_rss2sql_buildConfig($config, $_POST, 2); } echo "\n"; echo "?>\n"; echo "</pre>\n"; echo "================== End of file ==================<br><br>\n"; echo "Copy between the dividers below to use as a starting point create your database tables, if you need to.<br>\n"; echo "<br>================= Start of file =================\n"; echo "<pre>\n"; } // if (!isset($_REQUEST["TEST"])) { echo "CREATE TABLE $_POST[feedInfo] (\n"; echo " $_POST[feedID] INT AUTO_INCREMENT,\n"; echo " $_POST[feedActive] TINYINT NOT NULL DEFAULT \"1\",\n"; echo " $_POST[feedURL] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; echo " $_POST[updateInterval] INT NOT NULL default \"86400\",\n"; echo " $_POST[lastUpdate] DATETIME NOT NULL default \"0000-00-00 00:00:00\",\n"; echo " $_POST[nextUpdate] DATETIME NOT NULL default \"0000-00-00 00:00:00\",\n"; echo " $_POST[updateStatus] VARCHAR(32) NOT NULL default \"\",\n"; echo " $_POST[updateStatusCount] TINYINT NOT NULL default \"0\",\n"; echo " PRIMARY KEY($_POST[feedID])\n"; echo ") CHARSET=utf8;\n"; echo "\n"; echo "CREATE TABLE $_POST[ItemTable] (\n"; echo " $_POST[itemID] INT AUTO_INCREMENT,\n"; echo " $_POST[feedID] INT NOT NULL DEFAULT \"0\",\n"; echo " $_POST[UniqueItemID] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; echo " $_POST[ItemAddedTime] DATETIME NOT NULL default \"0000-00-00 00:00:00\",\n"; if ($_POST["ItemTitle"] != "") { echo " $_POST[ItemTitle] TEXT NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemDescription"] != "") { echo " $_POST[ItemDescription] MEDIUMTEXT NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemContentEncoded"] != "") { echo " $_POST[ItemContentEncoded] MEDIUMTEXT NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemLink"] != "") { echo " $_POST[ItemLink] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemPubDate"] != "") { echo " $_POST[ItemPubDate] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemPubDate_t"] != "") { echo " $_POST[ItemPubDate_t] DATETIME NOT NULL default \"0000-00-00 00:00:00\",\n"; } if ($_POST["ItemEnclosureUrl"] != "") { echo " $_POST[ItemEnclosureUrl] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemEnclosureType"] != "") { echo " $_POST[ItemEnclosureType] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemEnclosureLength"] != "") { echo " $_POST[ItemEnclosureLength] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemGuid"] != "") { echo " $_POST[ItemGuid] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemAuthor"] != "") { echo " $_POST[ItemAuthor] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemComments"] != "") { echo " $_POST[ItemComments] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemSource"] != "") { echo " $_POST[ItemSource] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemSourceUrl"] != "") { echo " $_POST[ItemSourceUrl] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemCategory"] != "") { echo " $_POST[ItemCategory] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemCategoryDomain"] != "") { echo " $_POST[ItemCategoryDomain] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if ($_POST["ItemCreativeCommons"] != "") { echo " $_POST[ItemCreativeCommons] VARCHAR(250) NOT NULL DEFAULT \"\",\n"; } if (FeedForAll_parseExtensions() === TRUE) { FeedForAll_parseExtensions_rss2sql_buildConfig($config, $_POST, 3); } echo " PRIMARY KEY($_POST[itemID]),\n"; echo " INDEX ($_POST[UniqueItemID])\n"; echo ") CHARSET=utf8;\n"; if (!isset($_REQUEST["TEST"])) { echo "</pre>\n"; echo "================== End of file ==================<br><br>\n"; } } } if (!isset($_REQUEST["TEST"])) { echo "<form method=\"POST\">\n"; echo "<table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\">\n"; echo "<tr><th valign=\"top\" align=\"left\">DBconfigFile</th><td><input type=\"text\" name=\"DBconfigFile\" value=\"$_POST[DBconfigFile]\" size=\"64\"><br>The configuration file created with the help of rss2sql_install.php.</td></tr>\n"; echo "<tr><td colspan=\"2\"><hr></td></tr>\n"; echo "<tr><th valign=\"top\" align=\"left\">feedInfo</th><td><input type=\"text\" name=\"feedInfo\" value=\"$_POST[feedInfo]\" size=\"32\"><br>The name of the table where feed's information is stored<br></td></tr>\n"; echo "<tr><th valign=\"top\" align=\"left\">feedID</th><td><input type=\"text\" name=\"feedID\" value=\"$_POST[feedID]\" size=\"32\"><br><b>feedID</b> is in both the feed's and item's table and is used to link the two together</td></tr>\n"; echo "<tr><th valign=\"top\" align=\"left\">feedActive</th><td><input type=\"text\" name=\"feedActive\" value=\"$_POST[feedActive]\" size=\"32\"><br>Is used to control if a feed is updated or not</td></tr>\n"; echo "<tr><th valign=\"top\" align=\"left\">feedURL</th><td><input type=\"text\" name=\"feedURL\" value=\"$_POST[feedURL]\" size=\"32\"><br>The name of the field to store the URL to the feed</td></tr>\n";⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -