Code Schnipsels
Codeschnipsel finden
|
Einen neuen Codeschnipsel einschicken
|
Schnipsel Paket erstellen
| upgrade data from mydownloads to PDdownloads | |||
| Beschreibung | |||
| Sie möchten von mydownloads auf PDdownloads wechseln? Dann ist dieser kleine Hack genau das richtige! Kopiere Ihn einfach in ein Unterverzeichnis, speichere ihn als php - Datei und rufe Ihn dann über die URL auf. Als Ergebnis sind alle vorhanden Daten von myddownloads nun in PDdownloads eingebunden :-D | |||
| Typ | Kategorie | Lizenz | Sprache |
| Hack | xoops | WebSite Only | PHP |
Versionen dieses Codeschnipsels:
| Version - Anklicken zur Ansicht | Packages | Veröffentlichungsdatum | ID # | Autor | |
| 1.0 | 31.10.2005 19:33:03 | 13 | admin | ||
|
Änderungen:
Erste gepostete Version |
|||||
Version: 1.0
<? // upgrade data from mydownloads to PDdownloads
include_once "../../../mainfile.php";
// table mydownloads_broken
$sql = "select * from ".$xoopsDB->prefix("mydownloads_broken");
$mydownloads_broken = $xoopsDB->query($sql);
while (list($reportid, $lid, $sender, $ip) = $xoopsDB -> fetchRow($mydownloads_broken)) {
$sql = "insert into ".$xoopsDB->prefix("PDdownloads_broken")."
set reportid = '$reportid', lid = '$lid', sender = '$sender', ip = '$ip'
";
if ($result = $xoopsDB->queryF($sql)) {
echo "mydownloads_broken insert successful<br>";
} else {
echo "mydownloads_broken insert abort<br>";
}
}
// table mydownloads_cat
$sql = "select * from ".$xoopsDB->prefix("mydownloads_cat");
$mydownloads_cat = $xoopsDB->query($sql);
while (list($cid, $pid, $title, $imgurl) = $xoopsDB -> fetchRow($mydownloads_cat)) {
$sql = "insert into ".$xoopsDB->prefix("PDdownloads_cat")."
set cid = '$cid', pid = '$pid', title = '$title', imgurl = '$imgurl'
";
if ($result = $xoopsDB->queryF($sql)) {
echo "mydownloads_cat insert successful<br>";
} else {
echo "mydownloads_cat insert abort<br>";
}
}
// table mydownloads_downloads
$sql = "select * from ".$xoopsDB->prefix("mydownloads_downloads");
$mydownloads_downloads = $xoopsDB->query($sql);
while (list($lid, $cid, $title, $url,
$homepage, $version, $size, $platform, $logourl, $submitter,
$status, $date, $hits,
$rating, $votes, $comments)
= $xoopsDB -> fetchRow($mydownloads_downloads)) {
$sql = "insert into ".$xoopsDB->prefix("PDdownloads_downloads")."
set lid = '$lid', cid = '$cid',
title = '$title', url = '$url', homepage = '$homepage', version = '$version',
size = '$size', platform = '$platform',
screenshot = '$logourl',
submitter = '$submitter',
status = '$status', date = '$date', hits = '$hits',
rating = '$rating', votes = '$votes', comments ='$comments'
";
if ($result = $xoopsDB->queryF($sql)) {
echo "mydownloads_downloads insert successful<br>";
} else {
echo "mydownloads_downloads insert abort<br>";
}
}
// table mydownloads_mod
$sql = "select * from ".$xoopsDB->prefix("mydownloads_mod");
$mydownloads_mod = $xoopsDB->query($sql);
while (list($requestid, $lid, $cid, $title, $url, $homepage,
$version, $size, $platform, $logourl,
$description, $modifysubmitter)
= $xoopsDB -> fetchRow($mydownloads_mod)) {
$sql = "insert into ".$xoopsDB->prefix("PDdownloads_mod")."
set requestid = '$requestid', lid = '$lid', cid = '$cid',
title = '$title', url = '$url',
homepage = '$homepage', version = '$version', size = '$size', platform = '$platform',
screenshot = '$logourl',
description='$description',
modifysubmitter = '$modifysubmitter'";
if ($result = $xoopsDB->queryF($sql)) {
echo "mydownloads_mod insert successful<br>";
} else {
echo "mydownloads_mod insert abort<br>";
}
}
// table mydownloads_text
$sql = "select * from ".$xoopsDB->prefix("mydownloads_text");
$mydownloads_text = $xoopsDB->query($sql);
while (list($lid, $description) = $xoopsDB -> fetchRow($mydownloads_text)) {
$sql = "update ".$xoopsDB->prefix("PDdownloads_downloads")."
set description = '$description' where lid = '$lid'";
if ($result = $xoopsDB->queryF($sql)) {
echo "mydownloads_text insert successful<br>";
} else {
echo "mydownloads_text insert abort<br>";
}
}
// table mydownloads_votedata
$sql = "select * from ".$xoopsDB->prefix("mydownloads_votedata");
$mydownloads_votedata = $xoopsDB->query($sql);
while (list($ratingid, $lid, $ratinguser, $rating, $ratinghostname, $ratingtimestamp) =
$xoopsDB -> fetchRow($mydownloads_votedata)) {
$sql = "insert into ".$xoopsDB->prefix("PDdownloads_votedata")."
set ratingid = '$ratingid', lid = '$lid', ratinguser = '$ratinguser',
rating ='$rating', ratinghostname ='$ratinghostname',
ratingtimestamp = '$ratingtimestamp'";
if ($result = $xoopsDB->queryF($sql)) {
echo "mydownloads_votedata insert successful<br>";
} else {
echo "mydownloads_votedata insert abort<br>";
}
} ?>