Menu
▾
▴
[xoops-svn] SF.net SVN: xoops-svn:[12128] XoopsModules/wfdownloads/trunk/wfdownloads/ admin/import.php
|
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`");
}
|
