Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites
View Statistics - Next Notice - Previous NoticeDirectory filter : [ all ] / postnuke_official / tests [ view in CVS ]
| Date | Directory [filter] | File(s) [view] | Author [filter] |
| 12 Aug 2002 17:51:06 | postnuke_official/tests | import8.php,1.14,1.15 | Mike |
| import article comments | |||
Update of /home/cvsroot/postnuke_official/tests
In directory ns7.hostnuke.net:/tmp/cvs-serv29294
Modified Files:
import8.php
Log Message:
import article comments
Index: import8.php
===================================================================
RCS file: /home/cvsroot/postnuke_official/tests/import8.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** import8.php 11 Aug 2002 14:58:47 -0000 1.14
--- import8.php 12 Aug 2002 17:51:04 -0000 1.15
***************
*** 94,97 ****
--- 94,100 ----
die("Unable to load the articles admin API");
}
+ if (!pnModAPILoad('comments','admin')) {
+ die("Unable to load the comments admin API");
+ }
if (!isset($reset)) {
***************
*** 134,139 ****
while (!$result->EOF) {
list($uid,$name,$uname,$email,$pass,$url) = $result->fields;
! // $insert = 'INSERT INTO ' . $pntable['users'] . '
! $insert = 'INSERT DELAYED INTO ' . $pntable['users'] . '
(pn_uid, pn_name, pn_uname, pn_email, pn_pass, pn_url,
pn_auth_module)
--- 137,142 ----
while (!$result->EOF) {
list($uid,$name,$uname,$email,$pass,$url) = $result->fields;
! // $insert = 'INSERT DELAYED INTO ' . $pntable['users'] . '
! $insert = 'INSERT INTO ' . $pntable['users'] . '
(pn_uid, pn_name, pn_uname, pn_email, pn_pass, pn_url,
pn_auth_module)
***************
*** 371,375 ****
}
$result->Close();
! echo "<strong>TODO : add comments etc.</strong><br><br>\n";
echo '<a href="import8.php">Return to start</a> ';
if ($count > $numitems && $startnum + $numitems < $count) {
--- 374,378 ----
}
$result->Close();
! //echo "<strong>TODO : add comments etc.</strong><br><br>\n";
echo '<a href="import8.php">Return to start</a> ';
if ($count > $numitems && $startnum + $numitems < $count) {
***************
*** 462,466 ****
}
$result->Close();
! echo "<strong>TODO : add comments etc.</strong><br><br>\n";
echo '<a href="import8.php">Return to start</a> ';
if ($count > $numitems && $startnum + $numitems < $count) {
--- 465,469 ----
}
$result->Close();
! //echo "<strong>TODO : add comments etc.</strong><br><br>\n";
echo '<a href="import8.php">Return to start</a> ';
if ($count > $numitems && $startnum + $numitems < $count) {
***************
*** 682,686 ****
$result->Close();
echo "<strong>TODO : do something with FAQ display</strong><br><br>\n";
- // the end - for now...
echo '<a href="import8.php">Return to start</a>
<a href="import8.php?step=' . ($step+1) . '">Go to step ' . ($step+1) . '</a><br>';
--- 685,688 ----
***************
*** 688,692 ****
if ($step == 9) {
! echo "<strong>9. Optimizing database tables</strong><br>\n";
$dbconn->Execute('OPTIMIZE TABLE ' . $pntable['users']);
if ($dbconn->ErrorNo() != 0) {
--- 690,767 ----
if ($step == 9) {
! $regid = pnModGetIDFromName('articles');
! echo "<strong>9. Importing comments</strong><br>\n";
! $query = 'SELECT COUNT(*) FROM ' . $oldprefix . '_comments';
! $result = $dbconn->Execute($query);
! if ($dbconn->ErrorNo() != 0) {
! die("Oops, count comments failed : " . $dbconn->ErrorMsg());
! }
! $count = $result->fields[0];
! $result->Close();
! $query = 'SELECT pn_tid, pn_sid, pn_pid, pn_date, pn_uname, pn_uid,
! pn_host_name, pn_subject, pn_comment
! FROM ' . $oldprefix . '_comments
! LEFT JOIN ' . $oldprefix . '_users
! ON ' . $oldprefix . '_users.pn_uname = ' . $oldprefix . '_comments.pn_name
! ORDER BY pn_tid ASC';
! $numitems = 2000;
! if (!isset($startnum)) {
! $startnum = 0;
! }
! if ($count > $numitems) {
! $result = $dbconn->SelectLimit($query, $numitems, $startnum);
! } else {
! $result = $dbconn->Execute($query);
! }
! if ($dbconn->ErrorNo() != 0) {
! die("Oops, select comments failed : " . $dbconn->ErrorMsg());
! }
! if ($reset && $startnum == 0) {
! $dbconn->Execute("DELETE FROM " . $pntable['comments']);
! }
! $num = 1;
! include_once('modules/comments/backend/backend.php');
! while (!$result->EOF) {
! list($tid,$sid,$pid,$date,$uname,$uid,$hostname,$subject,$comment) = $result->fields;
!
! if (empty($uid)) {
! $uid = 0;
! }
! $data['modid'] = $regid;
! $data['itemid'] = $sid;
! $data['pid'] = $pid;
! $data['author'] = $uid;
! $data['title'] = pnVarPrepForStore($subject);
! $data['comment'] = pnVarPrepForStore($comment);
! $data['hostname'] = pnVarPrepForStore($hostname);
! $data['cid'] = $tid;
! $data['date'] = $date;
!
! if (!pnComments_Add($data)) {
! echo "Failed inserting comment ($sid $pid) $uname - $subject<br>\n";
! } elseif ($count < 200) {
! echo "Inserted comment ($sid $pid) $uname - $subject<br>\n";
! } elseif ($num % 100 == 0) {
! echo "Inserted comment " . ($num + $startnum) . "<br>\n";
! flush();
! }
! $num++;
! $result->MoveNext();
! }
! $result->Close();
! echo "<strong>TODO : import other comments</strong><br><br>\n";
! echo '<a href="import8.php">Return to start</a> ';
! if ($count > $numitems && $startnum + $numitems < $count) {
! $startnum += $numitems;
! echo '<a href="import8.php?step=' . $step . '&startnum=' . $startnum . '">Go to step ' . $step . ' - comments ' . $startnum . '+ of ' . $count . '</a><br>';
! } else {
! echo '<a href="import8.php?step=' . ($step+1) . '">Go to step ' . ($step+1) . '</a><br>';
! }
! }
!
! // TODO: add the rest :-)
!
! if ($step == 10) {
! echo "<strong>10. Optimizing database tables</strong><br>\n";
$dbconn->Execute('OPTIMIZE TABLE ' . $pntable['users']);
if ($dbconn->ErrorNo() != 0) {
***************
*** 699,702 ****
--- 774,778 ----
$dbconn->Execute('OPTIMIZE TABLE ' . $pntable['hitcount']);
}
+ $dbconn->Execute('OPTIMIZE TABLE ' . $pntable['comments']);
echo "<strong>TODO : import the rest...</strong><br><br>\n";
View Statistics - Next Notice - Previous Notice
| Visit Developer Site - Browse CVS Repository |
Syndicate via backend.rss (max. once per hour please) | Powered by CVSNotice 0.1.3 |