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 |