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] |
09 Aug 2002 16:12:14 | postnuke_official/tests | import8.php,1.12,1.13 | Mike |
import article/section/topic/cat counters + add optimize table |
Update of /home/cvsroot/postnuke_official/tests In directory ns7.hostnuke.net:/tmp/cvs-serv22170 Modified Files: import8.php Log Message: import article/section/topic/cat counters + add optimize table Index: import8.php =================================================================== RCS file: /home/cvsroot/postnuke_official/tests/import8.php,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** import8.php 5 Aug 2002 01:49:56 -0000 1.12 --- import8.php 9 Aug 2002 16:12:12 -0000 1.13 *************** *** 129,132 **** --- 129,133 ---- if ($reset && $startnum == 0) { $dbconn->Execute("DELETE FROM " . $pntable['users'] . " WHERE pn_uid > 2"); + $dbconn->Execute('FLUSH TABLE ' . $pntable['users']); } $num = 1; *************** *** 172,179 **** if ($resetcat) { $dbconn->Execute("DELETE FROM " . $pntable['categories']); } if ($reset) { - $regid = pnModGetIDFromName('articles'); $dbconn->Execute("DELETE FROM " . $pntable['categories_linkage'] . " WHERE pn_modid=$regid"); } echo "Creating root for old news topics<br>\n"; --- 173,190 ---- if ($resetcat) { $dbconn->Execute("DELETE FROM " . $pntable['categories']); + $dbconn->Execute('FLUSH TABLE ' . $pntable['categories']); } + $regid = pnModGetIDFromName('articles'); if ($reset) { $dbconn->Execute("DELETE FROM " . $pntable['categories_linkage'] . " WHERE pn_modid=$regid"); + $dbconn->Execute('FLUSH TABLE ' . $pntable['categories_linkage']); + } + if (pnModAvailable('hitcount') && pnModAPILoad('hitcount','user')) { + if ($reset) { + $regid2 = pnModGetIDFromName('categories'); + $dbconn->Execute("DELETE FROM " . $pntable['hitcount'] . " WHERE pn_moduleid = " . $regid2); + $dbconn->Execute('FLUSH TABLE ' . $pntable['hitcount']); + } + $docounter = 1; } echo "Creating root for old news topics<br>\n"; *************** *** 200,204 **** 'parent_id' => $categories)); ! $query = 'SELECT pn_topicid, pn_topicname, pn_topictext, pn_topicimage FROM ' . $oldprefix . '_topics ORDER BY pn_topicid ASC'; --- 211,215 ---- 'parent_id' => $categories)); ! $query = 'SELECT pn_topicid, pn_topicname, pn_topictext, pn_topicimage, pn_counter FROM ' . $oldprefix . '_topics ORDER BY pn_topicid ASC'; *************** *** 208,212 **** } while (!$result->EOF) { ! list($id, $name, $text, $image) = $result->fields; $topicid[$id] = pnModAPIFunc('categories', 'admin', 'create', array( 'name' => $text, --- 219,223 ---- } while (!$result->EOF) { ! list($id, $name, $text, $image, $counter) = $result->fields; $topicid[$id] = pnModAPIFunc('categories', 'admin', 'create', array( 'name' => $text, *************** *** 215,223 **** 'parent_id' => $topics)); echo "Creating topic ($id) $text - $name [$image]<br>\n"; $result->MoveNext(); } $result->Close(); ! $query = 'SELECT pn_catid, pn_title FROM ' . $oldprefix . '_stories_cat ORDER BY pn_catid ASC'; --- 226,244 ---- 'parent_id' => $topics)); echo "Creating topic ($id) $text - $name [$image]<br>\n"; + if (!empty($docounter)) { + $counter--; + $hits = pnModAPIFunc('hitcount','user','hit',array('modname' => 'categories', + 'objectid' => $topicid[$id], + 'hits' => $counter)); + $counter++; + if ($hits != $counter) { + echo "Hits $hits don't match counter $counter for topic $topicid[$id] $text<br>\n"; + } + } $result->MoveNext(); } $result->Close(); ! $query = 'SELECT pn_catid, pn_title, pn_counter FROM ' . $oldprefix . '_stories_cat ORDER BY pn_catid ASC'; *************** *** 227,231 **** } while (!$result->EOF) { ! list($id, $title) = $result->fields; $catid[$id] = pnModAPIFunc('categories', 'admin', 'create', array( 'name' => $title, --- 248,252 ---- } while (!$result->EOF) { ! list($id, $title, $counter) = $result->fields; $catid[$id] = pnModAPIFunc('categories', 'admin', 'create', array( 'name' => $title, *************** *** 233,236 **** --- 254,267 ---- 'parent_id' => $categories)); echo "Creating category ($id) $title - $title<br>\n"; + if (!empty($docounter)) { + $counter--; + $hits = pnModAPIFunc('hitcount','user','hit',array('modname' => 'categories', + 'objectid' => $catid[$id], + 'hits' => $counter)); + $counter++; + if ($hits != $counter) { + echo "Hits $hits don't match counter $counter for category $catid[$id] $title<br>\n"; + } + } $result->MoveNext(); } *************** *** 261,265 **** $query = 'SELECT pn_sid, pn_title, pn_hometext, pn_bodytext, pn_aid, UNIX_TIMESTAMP(pn_time), pn_language, pn_catid, pn_topic, ! pn_notes, pn_ihome FROM ' . $oldprefix . '_stories ORDER BY pn_sid ASC'; --- 292,296 ---- $query = 'SELECT pn_sid, pn_title, pn_hometext, pn_bodytext, pn_aid, UNIX_TIMESTAMP(pn_time), pn_language, pn_catid, pn_topic, ! pn_notes, pn_ihome, pn_counter FROM ' . $oldprefix . '_stories ORDER BY pn_sid ASC'; *************** *** 278,286 **** if ($reset && $startnum == 0) { $dbconn->Execute("DELETE FROM " . $pntable['articles']); } $num = 1; while (!$result->EOF) { list($aid, $title, $summary, $body, $authorid, $pubdate, $language, ! $cat, $topic, $notes, $ihome) = $result->fields; if (empty($ihome)) { $status = 3; --- 309,325 ---- if ($reset && $startnum == 0) { $dbconn->Execute("DELETE FROM " . $pntable['articles']); + $dbconn->Execute('FLUSH TABLE ' . $pntable['articles']); + } + if (pnModAvailable('hitcount') && pnModAPILoad('hitcount','user')) { + if ($reset && $startnum == 0) { + $dbconn->Execute("DELETE FROM " . $pntable['hitcount'] . " WHERE pn_moduleid = " . $regid); + $dbconn->Execute('FLUSH TABLE ' . $pntable['hitcount']); + } + $docounter = 1; } $num = 1; while (!$result->EOF) { list($aid, $title, $summary, $body, $authorid, $pubdate, $language, ! $cat, $topic, $notes, $ihome, $counter) = $result->fields; if (empty($ihome)) { $status = 3; *************** *** 314,317 **** --- 353,366 ---- } $num++; + if (!empty($docounter)) { + $counter--; + $hits = pnModAPIFunc('hitcount','user','hit',array('modname' => 'articles', + 'objectid' => $aid, + 'hits' => $counter)); + $counter++; + if ($hits != $counter) { + echo "Hits $hits don't match counter $counter for article $aid $title<br>\n"; + } + } $cids = array(); if (isset($topicid[$topic])) { *************** *** 472,476 **** $sectionid = unserialize(pnModGetVar('import','sectionid')); echo "<strong>6. Importing section content</strong><br>\n"; ! $query = 'SELECT pn_artid, pn_secid, pn_title, pn_content, pn_language FROM ' . $oldprefix . '_seccont ORDER BY pn_artid ASC'; --- 521,525 ---- $sectionid = unserialize(pnModGetVar('import','sectionid')); echo "<strong>6. Importing section content</strong><br>\n"; ! $query = 'SELECT pn_artid, pn_secid, pn_title, pn_content, pn_language, pn_counter FROM ' . $oldprefix . '_seccont ORDER BY pn_artid ASC'; *************** *** 479,484 **** die("Oops, select section content failed : " . $dbconn->ErrorMsg()); } while (!$result->EOF) { ! list($artid, $secid, $title, $content, $language) = $result->fields; $nextId = $dbconn->GenId($pntable['articles']); $insert = 'INSERT INTO ' . $pntable['articles'] . ' --- 528,536 ---- die("Oops, select section content failed : " . $dbconn->ErrorMsg()); } + if (pnModAvailable('hitcount') && pnModAPILoad('hitcount','user')) { + $docounter = 1; + } while (!$result->EOF) { ! list($artid, $secid, $title, $content, $language, $counter) = $result->fields; $nextId = $dbconn->GenId($pntable['articles']); $insert = 'INSERT INTO ' . $pntable['articles'] . ' *************** *** 503,506 **** --- 555,570 ---- echo "Inserted section content ($artid) $title<br>\n"; } + // Get aid to return + $aid = $dbconn->PO_Insert_ID($pntable['articles'], 'pn_aid'); + if (!empty($docounter)) { + $counter--; + $hits = pnModAPIFunc('hitcount','user','hit',array('modname' => 'articles', + 'objectid' => $aid, + 'hits' => $counter)); + $counter++; + if ($hits != $counter) { + echo "Hits $hits don't match counter $counter for article $aid $title<br>\n"; + } + } $cids = array(); // TODO: check if we want to add articles to the Sections root too or not *************** *** 512,517 **** $cids[] = $sections; } - // Get aid to return - $aid = $dbconn->PO_Insert_ID($pntable['articles'], 'pn_aid'); pnModAPIFunc('categories', 'admin', 'linkcat', array( 'cids' => $cids, --- 576,579 ---- *************** *** 629,635 **** 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>'; ! // } echo "<strong>TODO : import the rest...</strong><br><br>\n"; --- 691,710 ---- 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>'; ! } ! ! if ($step == 9) { ! echo "<strong>9. Optimizing database tables</strong><br>\n"; ! $dbconn->Execute('OPTIMIZE TABLE ' . $pntable['users']); ! if ($dbconn->ErrorNo() != 0) { ! echo $dbconn->ErrorMsg(); ! } ! $dbconn->Execute('OPTIMIZE TABLE ' . $pntable['categories']); ! $dbconn->Execute('OPTIMIZE TABLE ' . $pntable['articles']); ! $dbconn->Execute('OPTIMIZE TABLE ' . $pntable['categories_linkage']); ! if (pnModAvailable('hitcount') && pnModAPILoad('hitcount','user')) { ! $dbconn->Execute('OPTIMIZE TABLE ' . $pntable['hitcount']); ! } 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 |