Menu
▾
▴
xoops-svn
|
From: <luc...@us...> - 2013-10-04 16:59:28
|
Revision: 12128
http://sourceforge.net/p/xoops/svn/12128
Author: luciorota
Date: 2013-10-04 16:59:25 +0000 (Fri, 04 Oct 2013)
Log Message:
-----------
fixed bugs but still in progress... import procedure doesn't copy files on filesystem... import procedure doesn't import permissions too ... lot of improvements to do... :-(
Modified Paths:
--------------
XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php
Modified: XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php
===================================================================
--- XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php 2013-10-04 16:53:05 UTC (rev 12127)
+++ XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php 2013-10-04 16:59:25 UTC (rev 12128)
@@ -21,6 +21,23 @@
$currentFile = basename(__FILE__);
include_once dirname(__FILE__) . '/admin_header.php';
+if (!is_dir($wfdownloads->getConfig('uploaddir'))) {
+ redirect_header('index.php', 4, _AM_WFDOWNLOADS_ERROR_UPLOADDIRNOTEXISTS);
+ exit();
+}
+if (!is_dir(XOOPS_ROOT_PATH . '/' . $wfdownloads->getConfig('mainimagedir'))) {
+ redirect_header('index.php', 4, _AM_WFDOWNLOADS_ERROR_MAINIMAGEDIRNOTEXISTS);
+ exit();
+}
+if (!is_dir(XOOPS_ROOT_PATH . '/' . $wfdownloads->getConfig('screenshots'))) {
+ redirect_header('index.php', 4, _AM_WFDOWNLOADS_ERROR_SCREENSHOTSDIRNOTEXISTS);
+ exit();
+}
+if (!is_dir(XOOPS_ROOT_PATH . '/' . $wfdownloads->getConfig('catimage'))) {
+ redirect_header('index.php', 4, _AM_WFDOWNLOADS_ERROR_CATIMAGEDIRNOTEXISTS);
+ exit();
+}
+
include_once(WFDOWNLOADS_ROOT_PATH . "/include/module.php");
$op = WfdownloadsRequest::getString('op', 'import.menu');
@@ -28,10 +45,6 @@
case "import.MyDownloads" :
$ok = WfdownloadsRequest::getBool('ok', false, 'POST');
if ($ok == true) {
- // Make sure that nohtml is properly changed to dohtml
- invert_nohtm_dohtml_values();
- // Ensure that the proper tables are present
- update_tables_to_300();
// Import data from MyDownloads
import_mydownloads_to_wfdownloads();
// Downloads imported
@@ -47,10 +60,6 @@
case "import.PD-Downloads" :
$ok = WfdownloadsRequest::getBool('ok', false, 'POST');
if ($ok == true) {
- // Make sure that nohtml is properly changed to dohtml
- invert_nohtm_dohtml_values();
- // Ensure that the proper tables are present
- update_tables_to_300();
// Import data from PD-Downloads
import_pddownloads_to_wfdownloads();
// Downloads imported
@@ -66,10 +75,6 @@
case "import.wmpownloads" :
$ok = WfdownloadsRequest::getBool('ok', false, 'POST');
if ($ok == true) {
- // Make sure that nohtml is properly changed to dohtml
- invert_nohtm_dohtml_values();
- // Ensure that the proper tables are present
- update_tables_to_300();
// Import data from wmpownloads
import_wmpdownloads_to_wfdownloads();
// Downloads imported
@@ -85,18 +90,16 @@
case "import.wfd322" :
$ok = WfdownloadsRequest::getBool('ok', false, 'POST');
if ($ok == true) {
- // Make sure that nohtml is properly changed to dohtml
- invert_nohtm_dohtml_values();
- // Ensure that the proper tables are present
- update_tables_to_300();
- // Import data from wmpownloads
+ // Import data from wfd322
+ wfdownloads_xoops_cp_header();
import_wfd_to_wfdownloads();
+ xoops_cp_footer();
// Downloads imported
- redirect_header($currentFile, 1, _AM_WFDOWNLOADS_IMPORT_IMPORT_OK);
+ //redirect_header($currentFile, 1, _AM_WFDOWNLOADS_IMPORT_IMPORT_OK);
exit();
} else {
wfdownloads_xoops_cp_header();
- xoops_confirm(array('op' => 'import.wfdownloads', 'ok' => true), $currentFile, _AM_WFDOWNLOADS_IMPORT_RUSURE);
+ xoops_confirm(array('op' => 'import.wfd322', 'ok' => true), $currentFile, _AM_WFDOWNLOADS_IMPORT_RUSURE);
xoops_cp_footer();
}
break;
@@ -111,56 +114,61 @@
include XOOPS_ROOT_PATH . "/class/xoopsformloader.php";
$form = new XoopsThemeForm(_AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "form", $_SERVER['REQUEST_URI']);
-
// Avoid module to import form itself
- //Is wfdownloads installed?
+ // Is wf-downloads installed?
if ($wfdownloads->getModule()->dirname() != "wf"."downloads") {
$got_options = false;
if (wfdownloads_checkModule('wf'.'downloads')) {
$moduleVersion = round(wfdownloads_checkModule('wf'.'downloads') / 100, 2);
- $wfdButton = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_WFD . '<br />' . $moduleVersion, "wmp_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
- $wfdButton->setExtra("onclick='document.forms.form.op.value=\"import.wfd322\"'");
- $form->addElement($wfdButton);
+ $button = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_WFD . '<br />' . $moduleVersion, "wmp_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
+ $button->setExtra("onclick='document.forms.form.op.value=\"import.wfd322\"'");
+ $form->addElement($button);
+ unset($button);
} else {
- $wfdLabel = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_WFD, _AM_WFDOWNLOADS_IMPORT_WFD_NOTFOUND);
- $form->addElement($wfdLabel);
+ $label = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_WFD, _AM_WFDOWNLOADS_IMPORT_WFD_NOTFOUND);
+ $form->addElement($label);
+ unset($label);
}
}
-
//Is MyDownloads installed?
$got_options = false;
if (wfdownloads_checkModule('mydownloads')) {
$moduleVersion = round(wfdownloads_checkModule('mydownloads') / 100, 2);
- $sourceButton = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_MYDOWNLOADS . '<br />' . $moduleVersion, "myd_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
- $sourceButton->setExtra("onclick='document.forms.form.op.value=\"import.MyDownloads\"'");
- $form->addElement($sourceButton);
+ $button = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_MYDOWNLOADS . '<br />' . $moduleVersion, "myd_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
+ $button->setExtra("onclick='document.forms.form.op.value=\"import.MyDownloads\"'");
+ $form->addElement($button);
+ unset($button);
} else {
- $sourceLabel = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_MYDOWNLOADS, _AM_WFDOWNLOADS_IMPORT_MYDOWNLOADS_NOTFOUND);
- $form->addElement($sourceLabel);
+ $label = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_MYDOWNLOADS, _AM_WFDOWNLOADS_IMPORT_MYDOWNLOADS_NOTFOUND);
+ $form->addElement($label);
+ unset($label);
}
//Is PD-Downloads installed?
$got_options = false;
if (wfdownloads_checkModule('PDdownloads')) {
$moduleVersion = round(wfdownloads_checkModule('PDdownloads') / 100, 2);
- $sourceButton = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_PDDOWNLOADS . '<br />' . $moduleVersion, "pd_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
- $sourceButton->setExtra("onclick='document.forms.form.op.value=\"import.PD-Downloads\"'");
- $form->addElement($sourceButton);
+ $button = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_PDDOWNLOADS . '<br />' . $moduleVersion, "pd_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
+ $button->setExtra("onclick='document.forms.form.op.value=\"import.PD-Downloads\"'");
+ $form->addElement($button);
+ unset($button);
} else {
- $sourceLabel = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_PDDOWNLOADS, _AM_WFDOWNLOADS_IMPORT_PDDOWNLOADS_NOTFOUND);
- $form->addElement($sourceLabel);
+ $label = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_PDDOWNLOADS, _AM_WFDOWNLOADS_IMPORT_PDDOWNLOADS_NOTFOUND);
+ $form->addElement($label);
+ unset($label);
}
-
//Is wmpownloads installed?
$got_options = false;
if (wfdownloads_checkModule('wmpdownloads')) {
$moduleVersion = round(wfdownloads_checkModule('wmpdownloads') / 100, 2);
- $sourceButton = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_WMPOWNLOADS . '<br />' . $moduleVersion, "wmp_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
- $sourceButton->setExtra("onclick='document.forms.form.op.value=\"import.wmpownloads\"'");
- $form->addElement($sourceButton);
+ $button = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_WMPOWNLOADS . '<br />' . $moduleVersion, "wmp_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
+ $button->setExtra("onclick='document.forms.form.op.value=\"import.wmpownloads\"'");
+ $form->addElement($button);
+ unset($button);
} else {
- $sourceLabel = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_WMPOWNLOADS, _AM_WFDOWNLOADS_IMPORT_WMPOWNLOADS_NOTFOUND);
- $form->addElement($sourceLabel);
+ $label = new XoopsFormLabel(_AM_WFDOWNLOADS_IMPORT_WMPOWNLOADS, _AM_WFDOWNLOADS_IMPORT_WMPOWNLOADS_NOTFOUND);
+ $form->addElement($label);
+ unset($label);
}
$form->addElement(new XoopsFormHidden('op', 0));
@@ -191,16 +199,6 @@
// function import_wmpdownloads_to_wfdownloads
// This one is needed to import data from wmpdownloads
//
-// function update_tables_to_300
-// This function will convert any WF-Downloads 2.x format to 3.00 format
-//
-// function invert_nohtm_dohtml_values
-// In WF-Downloads 3.00 some fieldnames have been changed and the namechange
-// comes along with a change of logic (0=yes;1=no --> 0=no;1=yes)
-// So the values need to be changed accordingly which is what this
-// function is doing. It needs to be run before "convert_tables_2x_to_300"
-// since it is based on the old fieldnamessince
-
// =========================================================================================
// This function imports data from WF-Downloads
// =========================================================================================
@@ -210,83 +208,103 @@
echo "<br /><b>Importing Data</b><br />";
$destination = array(
- "cat" => $xoopsDB -> prefix("wfdownloads_cat"),
- "downloads" => $xoopsDB -> prefix("wfdownloads_downloads"),
- "broken" => $xoopsDB -> prefix("wfdownloads_broken"),
- "mod" => $xoopsDB -> prefix("wfdownloads_mod"),
- "votes" => $xoopsDB -> prefix("wfdownloads_votedata"));
+ "cat" => $xoopsDB->prefix("wfdownloads_cat"),
+ "downloads" => $xoopsDB->prefix("wfdownloads_downloads"),
+ "broken" => $xoopsDB->prefix("wfdownloads_broken"),
+ "mod" => $xoopsDB->prefix("wfdownloads_mod"),
+ "votes" => $xoopsDB->prefix("wfdownloads_votedata"));
$source = array(
- "cat" => $xoopsDB -> prefix("wmpdownloads_cat"),
- "downloads" => $xoopsDB -> prefix("wmpdownloads_downloads"),
- "broken" => $xoopsDB -> prefix("wmpdownloads_broken"),
- "mod" => $xoopsDB -> prefix("wmpdownloads_mod"),
- "votes" => $xoopsDB -> prefix("wmpdownloads_votedata"),
- "text" => $xoopsDB -> prefix("wmpdownloads_text"));
+ "cat" => $xoopsDB ->prefix("wf"."downloads_cat"),
+ "downloads" => $xoopsDB->prefix("wf"."downloads_downloads"),
+ "broken" => $xoopsDB->prefix("wf"."downloads_broken"),
+ "mod" => $xoopsDB->prefix("wf"."downloads_mod"),
+ "votes" => $xoopsDB->prefix("wf"."downloads_votedata"));
//Add temporary field to category table
- $xoopsDB->query("ALTER TABLE ".$destination['cat']." ADD `old_cid` int NOT NULL default 0");
- $xoopsDB->query("ALTER TABLE ".$destination['cat']." ADD `old_pid` int NOT NULL default 0");
+ $xoopsDB->query("ALTER TABLE " . $destination['cat'] . " ADD `old_cid` int NOT NULL default 0");
+ $xoopsDB->query("ALTER TABLE " . $destination['cat'] . " ADD `old_pid` int NOT NULL default 0");
//Add temporary fields to downloads table
- $xoopsDB->query("ALTER TABLE ".$destination['downloads']." ADD `old_lid` int NOT NULL default 0,
- ADD `old_cid` int NOT NULL default 0");
+ $xoopsDB->query("ALTER TABLE " . $destination['downloads'] . " ADD `old_lid` int NOT NULL default 0");
+ $xoopsDB->query("ALTER TABLE " . $destination['downloads'] . " ADD `old_cid` int NOT NULL default 0");
//Get latest mod request ID to determine which records will need an updated lid value afterwards
- $result = $xoopsDB->query("SELECT MAX(requestid) FROM ".$destination['mod']);
+ $result = $xoopsDB->query("SELECT MAX(requestid) FROM " . $destination['mod']);
list($max_requestid) = $xoopsDB->fetchRow($result);
//Get latest report ID to determine, which records will need an updated lid value afterwards
- $result = $xoopsDB->query("SELECT MAX(reportid) FROM ".$destination['broken']);
+ $result = $xoopsDB->query("SELECT MAX(reportid) FROM " . $destination['broken']);
list($max_reportid) = $xoopsDB->fetchRow($result);
//Get latest vote ID to determine which records will need an updated lid value afterwards
- $result = $xoopsDB->query("SELECT MAX(ratingid) FROM ".$destination['votes']);
+ $result = $xoopsDB->query("SELECT MAX(ratingid) FROM " . $destination['votes']);
list($max_ratingid) = $xoopsDB->fetchRow($result);
//Import data into category table
- $xoopsDB->query("INSERT INTO ".$destination['cat']." (`old_cid`, `old_pid`, `title`, `imgurl`, `summary`) SELECT `cid`, `pid`, `title`, `imgurl`, '' FROM ".$source['cat']);
- echo "Imported ".$xoopsDB->getAffectedRows()." categories into ".$destination['cat']."<br />";
+ $sql = "INSERT INTO " . $destination['cat'] . " (";
+ $sql.= "`old_cid`, `old_pid`, `title`, `imgurl`, `summary`";
+ $sql.= ") SELECT ";
+ $sql.= "`cid`, `pid`, `title`, `imgurl`, `summary`";
+ $sql.= "FROM " . $source['cat'];
+ $xoopsDB->query($sql);
+ echo "Imported " . $xoopsDB->getAffectedRows() . " categories into " . $destination['cat'] . "<br />";
//Import data into downloads table
- $xoopsDB->query("INSERT INTO ".$destination['downloads']." (`cid`, `old_lid`, `old_cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `submitter`, `status`, `published`, `hits`, `rating`, `votes`, `comments`, `features`, `requirements`, `dhistory`, `summary`, `description`)
- SELECT 0,`lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `logourl`, `submitter`, `status`, `date`, `hits`, `rating`, `votes`, `comments`, '', '','','', '' FROM ".$source['downloads']);
- echo "Imported ".$xoopsDB->getAffectedRows()." downloads into ".$destination['downloads']."<br />";
+ $xoopsDB->query("
+ INSERT INTO " . $destination['downloads'] . " (
+ `cid`, `old_lid`, `old_cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `screenshot2`, `screenshot3`, `screenshot4`, `submitter`, `status`, `published`, `hits`, `rating`, `votes`, `comments`, `features`, `requirements`, `dhistory`, `summary`, `description`)
+ SELECT
+ 0, `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `screenshot2`, `screenshot3`, `screenshot4`, `submitter`, `status`, `published`, `hits`, `rating`, `votes`, `comments`, `features`, `requirements`, `dhistory`, `summary`, `description`
+ FROM " . $source['downloads']);
+ echo "Imported " . $xoopsDB->getAffectedRows() . " downloads into " . $destination['downloads'] . "<br />";
//Import data into brokens table
- $xoopsDB->query("INSERT INTO ".$destination['broken']." (`lid`, `sender`, `ip`)
- SELECT `lid`, `sender`, `ip` FROM ".$source['broken']);
- echo "Imported ".$xoopsDB->getAffectedRows()." broken reports into ".$destination['broken']."<br />";
+ $xoopsDB->query("
+ INSERT INTO " . $destination['broken'] . " (
+ `lid`, `sender`, `ip`)
+ SELECT
+ `lid`, `sender`, `ip`
+ FROM " . $source['broken']);
+ echo "Imported " . $xoopsDB->getAffectedRows()." broken reports into " . $destination['broken'] . "<br />";
//Import data into votedata table
- $xoopsDB->query("INSERT INTO ".$destination['votes']." (`lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp`)
- SELECT `lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp` FROM ".$source['votes']);
- echo "Imported ".$xoopsDB->getAffectedRows()." votes into ".$destination['votes']."<br />";
+ $xoopsDB->query("
+ INSERT INTO " . $destination['votes'] . " (
+ `lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp`)
+ SELECT
+ `lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp`
+ FROM " . $source['votes']);
+ echo "Imported " . $xoopsDB->getAffectedRows()." votes into " . $destination['votes'] . "<br />";
//Import data into mod request table
- $xoopsDB->query("INSERT INTO ".$destination['mod']." (`lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `description`, `modifysubmitter`,`features`, `requirements`, `publisher`, `dhistory`, `summary`)
- SELECT `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `logourl`, `description`, `modifysubmitter`,'','','','','' FROM ".$source['mod']);
- echo "Imported ".$xoopsDB->getAffectedRows()." modification requests into ".$destination['mod']."<br />";
+ $xoopsDB->query("
+ INSERT INTO " . $destination['mod'] . " (
+ `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `description`, `modifysubmitter`, `features`, `requirements`, `publisher`, `dhistory`, `summary`)
+ SELECT
+ `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `description`, `modifysubmitter`, `features`, `requirements`, `publisher`, `dhistory`, `summary`
+ FROM " . $source['mod']);
+ echo "Imported " . $xoopsDB->getAffectedRows() . " modification requests into " . $destination['mod'] . "<br />";
//Update category ID to new value
- $xoopsDB->query("UPDATE ".$destination['downloads']." d, ".$destination['cat']." c SET d.cid=c.cid WHERE d.old_cid=c.old_cid AND d.old_cid != 0");
- $xoopsDB->query("UPDATE ".$destination['cat']." c1, ".$destination['cat']." c2 SET c1.pid=c2.cid WHERE c1.old_pid=c2.old_cid AND c1.old_pid != 0");
+ $xoopsDB->query("UPDATE " . $destination['downloads'] . " d, " . $destination['cat'] . " c SET d.cid=c.cid WHERE d.old_cid=c.old_cid AND d.old_cid != 0");
+ $xoopsDB->query("UPDATE " . $destination['cat'] . " c1, " . $destination['cat'] . " c2 SET c1.pid=c2.cid WHERE c1.old_pid=c2.old_cid AND c1.old_pid != 0");
if ($max_requestid) {
- $xoopsDB->query("UPDATE ".$destination['mod']." m, ".$destination['cat']." c SET m.cid=c.cid WHERE m.requestid > ".$max_requestid." AND c.old_cid=m.cid");
+ $xoopsDB->query("UPDATE " . $destination['mod'] . " m, " . $destination['cat'] . " c SET m.cid=c.cid WHERE m.requestid > " . $max_requestid . " AND c.old_cid=m.cid");
//Update lid values in mod table
- $xoopsDB->query("UPDATE ".$destination['mod']." m, ".$destination['downloads']." d SET m.lid=d.lid WHERE m.requestid > ".$max_requestid." AND m.lid=d.old_lid");
+ $xoopsDB->query("UPDATE " . $destination['mod'] . " m, " . $destination['downloads'] . " d SET m.lid=d.lid WHERE m.requestid > " . $max_requestid . " AND m.lid=d.old_lid");
}
if ($max_ratingid) {
//Update lid values in votedata table
- $xoopsDB->query("UPDATE ".$destination['votes']." v, ".$destination['downloads']." d SET v.lid=d.lid WHERE v.ratingid > ".$max_ratingid." AND v.lid=d.old_lid");
+ $xoopsDB->query("UPDATE " . $destination['votes'] . " v, " . $destination['downloads'] . " d SET v.lid=d.lid WHERE v.ratingid > " . $max_ratingid . " AND v.lid=d.old_lid");
}
if ($max_reportid) {
//Update lid values in brokens table
- $xoopsDB->query("UPDATE ".$destination['broken']." b, ".$destination['downloads']." d SET b.lid=d.lid WHERE b.reportid > ".$max_reportid." AND b.lid=d.old_lid");
+ $xoopsDB->query("UPDATE " . $destination['broken'] . " b, " . $destination['downloads'] . " d SET b.lid=d.lid WHERE b.reportid > " . $max_reportid . " AND b.lid=d.old_lid");
}
//Update description
- $xoopsDB->query("UPDATE ".$destination['downloads']." d, ".$source['text']." t SET d.description=t.description WHERE t.lid=d.old_lid");
+ //$xoopsDB->query("UPDATE " . $destination['downloads'] . " d, " . $source['text'] . " t SET d.description=t.description WHERE t.lid=d.old_lid");
//Remove temporary fields
- $xoopsDB->query("ALTER TABLE .".$destination['cat']." DROP `old_cid`");
- $xoopsDB->query("ALTER TABLE .".$destination['cat']." DROP `old_pid`");
- $xoopsDB->query("ALTER TABLE .".$destination['downloads']." DROP `old_cid`");
- $xoopsDB->query("ALTER TABLE .".$destination['downloads']." DROP `old_lid`");
+ $xoopsDB->query("ALTER TABLE ." . $destination['cat'] . " DROP `old_cid`");
+ $xoopsDB->query("ALTER TABLE ." . $destination['cat'] . " DROP `old_pid`");
+ $xoopsDB->query("ALTER TABLE ." . $destination['downloads'] . " DROP `old_cid`");
+ $xoopsDB->query("ALTER TABLE ." . $destination['downloads'] . " DROP `old_lid`");
}
|
|
From: <luc...@us...> - 2013-10-05 16:39:42
|
Revision: 12136
http://sourceforge.net/p/xoops/svn/12136
Author: luciorota
Date: 2013-10-05 16:39:39 +0000 (Sat, 05 Oct 2013)
Log Message:
-----------
created import procedure from original wfdownloads 3.23 module to cloned module
Modified Paths:
--------------
XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php
Modified: XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php
===================================================================
--- XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php 2013-10-05 13:47:28 UTC (rev 12135)
+++ XoopsModules/wfdownloads/trunk/wfdownloads/admin/import.php 2013-10-05 16:39:39 UTC (rev 12136)
@@ -118,8 +118,8 @@
// Is wf-downloads installed?
if ($wfdownloads->getModule()->dirname() != "wf"."downloads") {
$got_options = false;
- if (wfdownloads_checkModule('wf'.'downloads')) {
- $moduleVersion = round(wfdownloads_checkModule('wf'.'downloads') / 100, 2);
+ if (wfdownloads_checkModule('wf'.'downloads')) { // don't modify, is for cloning
+ $moduleVersion = round(wfdownloads_checkModule('wf'.'downloads') / 100, 2); // don't modify, is for cloning
$button = new XoopsFormButton(_AM_WFDOWNLOADS_IMPORT_WFD . '<br />' . $moduleVersion, "wmp_button", _AM_WFDOWNLOADS_IMPORT_BUTTON_IMPORT, "submit");
$button->setExtra("onclick='document.forms.form.op.value=\"import.wfd322\"'");
$form->addElement($button);
@@ -205,100 +205,162 @@
function import_wfd_to_wfdownloads()
{
global $xoopsDB;
+ $module_handler =& xoops_gethandler('module');
+ // Get source module/config
+ $wfdDirname = 'wf'.'downloads'; // don't modify, is for cloning
+ $wfdModule = $module_handler->getByDirname($wfdDirname);
+ if (empty($wfdModuleConfig)) {
+ $config_handler = xoops_gethandler("config");
+ $wfdModuleConfig = $config_handler->getConfigsByCat(0, $wfdModule->mid());
+ }
+ $wfdCategoriesHandler = xoops_getModuleHandler('category', $wfdDirname);
+ $wfdDownloadsHandler = xoops_getModuleHandler('download', $wfdDirname);
+ // Get destination module/handlers/configs
+ $wfdownloads = WfdownloadsWfdownloads::getInstance();
+
+ echo "<br /><b>Copying Files</b><br />";
+ // Copy categories images/thumbnails
+ if (!wfdownloads_copyDir(XOOPS_ROOT_PATH . '/' . $wfdModuleConfig['catimage'], XOOPS_ROOT_PATH . '/' . $wfdownloads->getConfig('catimage'))) {
+ return false;
+ }
+ echo "Copied categories images and thumbnails<br />";
+ // Copy screenshots images/thumbnails
+ if (!wfdownloads_copyDir(XOOPS_ROOT_PATH . '/' . $wfdModuleConfig['screenshots'], XOOPS_ROOT_PATH . '/' . $wfdownloads->getConfig('screenshots'))) {
+ return false;
+ }
+ echo "Copied downloads screenshots and thumbnails<br />";
+ // Copy files
+ if (!wfdownloads_copyDir($wfdModuleConfig['uploaddir'], $wfdownloads->getConfig('uploaddir'))) {
+ return false;
+ }
+ echo "Copied files<br />";
+
echo "<br /><b>Importing Data</b><br />";
$destination = array(
"cat" => $xoopsDB->prefix("wfdownloads_cat"),
"downloads" => $xoopsDB->prefix("wfdownloads_downloads"),
+ "mirrors" => $xoopsDB->prefix("wfdownloads_mirrors"),
+ "reviews" => $xoopsDB->prefix("wfdownloads_reviews"),
"broken" => $xoopsDB->prefix("wfdownloads_broken"),
"mod" => $xoopsDB->prefix("wfdownloads_mod"),
"votes" => $xoopsDB->prefix("wfdownloads_votedata"));
$source = array(
- "cat" => $xoopsDB ->prefix("wf"."downloads_cat"),
- "downloads" => $xoopsDB->prefix("wf"."downloads_downloads"),
- "broken" => $xoopsDB->prefix("wf"."downloads_broken"),
- "mod" => $xoopsDB->prefix("wf"."downloads_mod"),
- "votes" => $xoopsDB->prefix("wf"."downloads_votedata"));
+ "cat" => $xoopsDB ->prefix("wf"."downloads_cat"), // don't modify, is for cloning
+ "downloads" => $xoopsDB->prefix("wf"."downloads_downloads"), // don't modify, is for cloning
+ "mirrors" => $xoopsDB->prefix("wf"."downloads_mirrors"), // don't modify, is for cloning
+ "reviews" => $xoopsDB->prefix("wf"."downloads_reviews"), // don't modify, is for cloning
+ "broken" => $xoopsDB->prefix("wf"."downloads_broken"), // don't modify, is for cloning
+ "mod" => $xoopsDB->prefix("wf"."downloads_mod"), // don't modify, is for cloning
+ "votes" => $xoopsDB->prefix("wf"."downloads_votedata")); // don't modify, is for cloning
//Add temporary field to category table
- $xoopsDB->query("ALTER TABLE " . $destination['cat'] . " ADD `old_cid` int NOT NULL default 0");
- $xoopsDB->query("ALTER TABLE " . $destination['cat'] . " ADD `old_pid` int NOT NULL default 0");
-
+ $xoopsDB->query("ALTER TABLE {$destination['cat']} ADD `old_cid` int NOT NULL default 0");
+ $xoopsDB->query("ALTER TABLE {$destination['cat']} ADD `old_pid` int NOT NULL default 0");
//Add temporary fields to downloads table
- $xoopsDB->query("ALTER TABLE " . $destination['downloads'] . " ADD `old_lid` int NOT NULL default 0");
- $xoopsDB->query("ALTER TABLE " . $destination['downloads'] . " ADD `old_cid` int NOT NULL default 0");
+ $xoopsDB->query("ALTER TABLE {$destination['downloads']} ADD `old_lid` int NOT NULL default 0");
+ $xoopsDB->query("ALTER TABLE {$destination['downloads']} ADD `old_cid` int NOT NULL default 0");
+ //Get latest mirror ID to determine which records will need an updated lid value afterwards
+ $result = $xoopsDB->query("SELECT MAX(mirror_id) FROM {$destination['mirrors']}");
+ list($max_mirrorid) = $xoopsDB->fetchRow($result);
+ //Get latest review ID to determine which records will need an updated lid value afterwards
+ $result = $xoopsDB->query("SELECT MAX(review_id) FROM {$destination['reviews']}");
+ list($max_reviewid) = $xoopsDB->fetchRow($result);
//Get latest mod request ID to determine which records will need an updated lid value afterwards
- $result = $xoopsDB->query("SELECT MAX(requestid) FROM " . $destination['mod']);
+ $result = $xoopsDB->query("SELECT MAX(requestid) FROM {$destination['mod']}");
list($max_requestid) = $xoopsDB->fetchRow($result);
//Get latest report ID to determine, which records will need an updated lid value afterwards
- $result = $xoopsDB->query("SELECT MAX(reportid) FROM " . $destination['broken']);
+ $result = $xoopsDB->query("SELECT MAX(reportid) FROM {$destination['broken']}");
list($max_reportid) = $xoopsDB->fetchRow($result);
//Get latest vote ID to determine which records will need an updated lid value afterwards
- $result = $xoopsDB->query("SELECT MAX(ratingid) FROM " . $destination['votes']);
+ $result = $xoopsDB->query("SELECT MAX(ratingid) FROM {$destination['votes']}");
list($max_ratingid) = $xoopsDB->fetchRow($result);
//Import data into category table
- $sql = "INSERT INTO " . $destination['cat'] . " (";
- $sql.= "`old_cid`, `old_pid`, `title`, `imgurl`, `summary`";
- $sql.= ") SELECT ";
- $sql.= "`cid`, `pid`, `title`, `imgurl`, `summary`";
- $sql.= "FROM " . $source['cat'];
+ $sql = "INSERT INTO {$destination['cat']} (";
+ $sql.= " `old_cid`, `old_pid`, `title`, `imgurl`, `description`, `total`, `summary`, `spotlighttop`, `spotlighthis`, `dohtml`, `dosmiley`, `doxcode`, `doimage`, `dobr`, `weight`, `formulize_fid`";
+ $sql.= " ) SELECT ";
+ $sql.= " `cid`, `pid`, `title`, `imgurl`, `description`, `total`, `summary`, `spotlighttop`, `spotlighthis`, `dohtml`, `dosmiley`, `doxcode`, `doimage`, `dobr`, `weight`, `formulize_fid`";
+ $sql.= " FROM {$source['cat']}";
$xoopsDB->query($sql);
- echo "Imported " . $xoopsDB->getAffectedRows() . " categories into " . $destination['cat'] . "<br />";
+ echo "Imported {$xoopsDB->getAffectedRows()} categories into {$destination['cat']}<br />";
//Import data into downloads table
- $xoopsDB->query("
- INSERT INTO " . $destination['downloads'] . " (
- `cid`, `old_lid`, `old_cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `screenshot2`, `screenshot3`, `screenshot4`, `submitter`, `status`, `published`, `hits`, `rating`, `votes`, `comments`, `features`, `requirements`, `dhistory`, `summary`, `description`)
- SELECT
- 0, `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `screenshot2`, `screenshot3`, `screenshot4`, `submitter`, `status`, `published`, `hits`, `rating`, `votes`, `comments`, `features`, `requirements`, `dhistory`, `summary`, `description`
- FROM " . $source['downloads']);
- echo "Imported " . $xoopsDB->getAffectedRows() . " downloads into " . $destination['downloads'] . "<br />";
+ $sql = "INSERT INTO {$destination['downloads']} (";
+ $sql.= " `cid`, `old_lid`, `old_cid`, `title`, `url`, `filename`, `filetype`, `homepage`, `version`, `size`, `platform`, `screenshot`, `screenshot2`, `screenshot3`, `screenshot4`, `submitter`, `publisher`, `status`, `date`, `hits`, `rating`, `votes`, `comments`, `license`, `mirror`, `price`, `paypalemail`, `features`, `requirements`, `homepagetitle`, `forumid`, `limitations`, `versiontypes`, `dhistory`, `published`, `expired`, `updated`, `offline`, `summary`, `description`, `ipaddress`, `notifypub`, `formulize_idreq`";
+ $sql.= " ) SELECT ";
+ $sql.= " 0, `lid`, `cid`, `title`, `url`, `filename`, `filetype`, `homepage`, `version`, `size`, `platform`, `screenshot`, `screenshot2`, `screenshot3`, `screenshot4`, `submitter`, `publisher`, `status`, `date`, `hits`, `rating`, `votes`, `comments`, `license`, `mirror`, `price`, `paypalemail`, `features`, `requirements`, `homepagetitle`, `forumid`, `limitations`, `versiontypes`, `dhistory`, `published`, `expired`, `updated`, `offline`, `summary`, `description`, `ipaddress`, `notifypub`, `formulize_idreq`";
+ $sql.= " FROM {$source['downloads']}";
+ $xoopsDB->query($sql);
+ echo "Imported {$xoopsDB->getAffectedRows()} downloads into {$destination['downloads']}<br />";
+
+ //Import data into mirrors table
+ $sql = "INSERT INTO {$destination['mirrors']} (";
+ $sql.= " `lid`, `title`, `homeurl`, `location`, `continent`, `downurl`, `submit`, `date`, `uid`";
+ $sql.= " ) SELECT";
+ $sql.= " `lid`, `title`, `homeurl`, `location`, `continent`, `downurl`, `submit`, `date`, `uid`";
+ $sql.= " FROM {$source['mirrors']}";
+ $xoopsDB->query($sql);
+ echo "Imported {$xoopsDB->getAffectedRows()} mirrors into {$destination['mirrors']}<br />";
+ //Import data into reviews table
+ $sql = "INSERT INTO {$destination['reviews']} (";
+ $sql.= " `lid`, `title`, `review`, `submit`, `date`, `uid`, `rate`";
+ $sql.= " ) SELECT";
+ $sql.= " `lid`, `title`, `review`, `submit`, `date`, `uid`, `rate`";
+ $sql.= " FROM {$source['reviews']}";
+ $xoopsDB->query($sql);
+ echo "Imported {$xoopsDB->getAffectedRows()} reviews into {$destination['reviews']}<br />";
//Import data into brokens table
- $xoopsDB->query("
- INSERT INTO " . $destination['broken'] . " (
- `lid`, `sender`, `ip`)
- SELECT
- `lid`, `sender`, `ip`
- FROM " . $source['broken']);
- echo "Imported " . $xoopsDB->getAffectedRows()." broken reports into " . $destination['broken'] . "<br />";
+ $sql = "INSERT INTO {$destination['broken']} (";
+ $sql.= " `lid`, `sender`, `ip`";
+ $sql.= " ) SELECT";
+ $sql.= " `lid`, `sender`, `ip`";
+ $sql.= " FROM {$source['broken']}";
+ $xoopsDB->query($sql);
+ echo "Imported {$xoopsDB->getAffectedRows()} broken reports into {$destination['broken']}<br />";
//Import data into votedata table
- $xoopsDB->query("
- INSERT INTO " . $destination['votes'] . " (
- `lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp`)
- SELECT
- `lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp`
- FROM " . $source['votes']);
- echo "Imported " . $xoopsDB->getAffectedRows()." votes into " . $destination['votes'] . "<br />";
+ $sql = "INSERT INTO {$destination['votes']} (";
+ $sql.= " `lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp`";
+ $sql.= " ) SELECT";
+ $sql.= " `lid`, `ratinguser`, `rating`, `ratinghostname`, `ratingtimestamp`";
+ $sql.= " FROM {$source['votes']}";
+ $xoopsDB->query($sql);
+ echo "Imported {$xoopsDB->getAffectedRows()} votes into {$destination['votes']}<br />";
//Import data into mod request table
- $xoopsDB->query("
- INSERT INTO " . $destination['mod'] . " (
- `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `description`, `modifysubmitter`, `features`, `requirements`, `publisher`, `dhistory`, `summary`)
- SELECT
- `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `description`, `modifysubmitter`, `features`, `requirements`, `publisher`, `dhistory`, `summary`
- FROM " . $source['mod']);
- echo "Imported " . $xoopsDB->getAffectedRows() . " modification requests into " . $destination['mod'] . "<br />";
+ $sql = "INSERT INTO {$destination['mod']} (";
+ $sql.= " `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `description`, `modifysubmitter`, `features`, `requirements`, `publisher`, `dhistory`, `summary`)";
+ $sql.= " SELECT";
+ $sql.= " `lid`, `cid`, `title`, `url`, `homepage`, `version`, `size`, `platform`, `screenshot`, `description`, `modifysubmitter`, `features`, `requirements`, `publisher`, `dhistory`, `summary`";
+ $sql.= " FROM {$source['mod']}";
+ $xoopsDB->query($sql);
+ echo "Imported {$xoopsDB->getAffectedRows()} modification requests into {$destination['mod']}<br />";
- //Update category ID to new value
- $xoopsDB->query("UPDATE " . $destination['downloads'] . " d, " . $destination['cat'] . " c SET d.cid=c.cid WHERE d.old_cid=c.old_cid AND d.old_cid != 0");
- $xoopsDB->query("UPDATE " . $destination['cat'] . " c1, " . $destination['cat'] . " c2 SET c1.pid=c2.cid WHERE c1.old_pid=c2.old_cid AND c1.old_pid != 0");
+ // Update category ID to new value
+ $xoopsDB->query("UPDATE {$destination['downloads']} d, {$destination['cat']} c SET d.cid=c.cid WHERE d.old_cid=c.old_cid AND d.old_cid != 0");
+ $xoopsDB->query("UPDATE {$destination['cat']} c1, {$destination['cat']} c2 SET c1.pid=c2.cid WHERE c1.old_pid=c2.old_cid AND c1.old_pid != 0");
+ // Update lid values in mod table
if ($max_requestid) {
- $xoopsDB->query("UPDATE " . $destination['mod'] . " m, " . $destination['cat'] . " c SET m.cid=c.cid WHERE m.requestid > " . $max_requestid . " AND c.old_cid=m.cid");
- //Update lid values in mod table
- $xoopsDB->query("UPDATE " . $destination['mod'] . " m, " . $destination['downloads'] . " d SET m.lid=d.lid WHERE m.requestid > " . $max_requestid . " AND m.lid=d.old_lid");
+ $xoopsDB->query("UPDATE {$destination['mod']} m, {$destination['cat']} c SET m.cid=c.cid WHERE m.requestid > {$max_requestid} AND c.old_cid=m.cid");
+ $xoopsDB->query("UPDATE {$destination['mod']} m, {$destination['downloads']} d SET m.lid=d.lid WHERE m.requestid > {$max_requestid} AND m.lid=d.old_lid");
}
+ // Update lid values in mirrors table
+ if ($max_mirrorid) {
+ $xoopsDB->query("UPDATE {$destination['mirrors']} v, {$destination['downloads']} d SET v.lid=d.lid WHERE v.mirror_id > {$max_mirrorid} AND v.lid=d.old_lid");
+ }
+ // Update lid values in reviews table
+ if ($max_reviewid) {
+ $xoopsDB->query("UPDATE {$destination['reviews']} v, {$destination['downloads']} d SET v.lid=d.lid WHERE v.review_id > {$max_reviewid} AND v.lid=d.old_lid");
+ }
+ // Update lid values in votedata table
if ($max_ratingid) {
- //Update lid values in votedata table
- $xoopsDB->query("UPDATE " . $destination['votes'] . " v, " . $destination['downloads'] . " d SET v.lid=d.lid WHERE v.ratingid > " . $max_ratingid . " AND v.lid=d.old_lid");
+ $xoopsDB->query("UPDATE {$destination['votes']} v, {$destination['downloads']} d SET v.lid=d.lid WHERE v.ratingid > {$max_ratingid} AND v.lid=d.old_lid");
}
+ // Update lid values in broken table
if ($max_reportid) {
- //Update lid values in brokens table
- $xoopsDB->query("UPDATE " . $destination['broken'] . " b, " . $destination['downloads'] . " d SET b.lid=d.lid WHERE b.reportid > " . $max_reportid . " AND b.lid=d.old_lid");
+ $xoopsDB->query("UPDATE {$destination['broken']} b, {$destination['downloads']} d SET b.lid=d.lid WHERE b.reportid > {$max_reportid} AND b.lid=d.old_lid");
}
- //Update description
- //$xoopsDB->query("UPDATE " . $destination['downloads'] . " d, " . $source['text'] . " t SET d.description=t.description WHERE t.lid=d.old_lid");
//Remove temporary fields
$xoopsDB->query("ALTER TABLE ." . $destination['cat'] . " DROP `old_cid`");
|
Thanks for helping keep SourceForge clean.
X