/**
* Truncate counter table
* @return void
*/
public static function Truncate()
{
// Get the Database Object for this Class
$objDatabase = Counter::GetDatabase();
// Perform the Query
$objDatabase->NonQuery('
TRUNCATE `counter`');
}
$objMessage->Save();
if ($objMessage->Id != $objRow['id']) {
Message::GetDatabase()->NonQuery('UPDATE message SET id=' . $objRow['id'] . ' WHERE id=' . $objMessage->Id);
Message::GetDatabase()->NonQuery('ALTER TABLE message AUTO_INCREMENT=' . ($objMessage->Id + 1));
}
}
$objResult = $objDb->query('SELECT * FROM counter ORDER BY id');
while (QDataGen::DisplayWhileTask('Migrating Counters', $objResult->num_rows)) {
$objRow = $objResult->fetch_array();
$objCounter = new Counter();
$objCounter->Filename = $objRow['filename'];
$objCounter->Token = $objRow['token'];
$objCounter->Counter = $objRow['counter'];
$objCounter->Save();
if ($objCounter->Id != $objRow['id']) {
Counter::GetDatabase()->NonQuery('UPDATE Counter SET id=' . $objRow['id'] . ' WHERE id=' . $objCounter->Id);
}
}
$objResult = $objDb->query('SELECT * FROM article ORDER BY id');
while (QDataGen::DisplayWhileTask('Migrating Articles', $objResult->num_rows)) {
$objRow = $objResult->fetch_array();
switch ($objRow['article_section_id']) {
case 1:
$strPath = '/article/getting_started/';
break;
case 2:
$strPath = '/article/harnessing/';
break;
case 3:
$strPath = '/article/background/';
break;
/**
* Gets the historical journal for an object from the log database.
* Objects will have VirtualAttributes available to lookup login, date, and action information from the journal object.
* @param integer intId
* @return Counter[]
*/
public static function GetJournalForId($intId)
{
$objDatabase = Counter::GetDatabase()->JournalingDatabase;
$objResult = $objDatabase->Query('SELECT * FROM counter WHERE id = ' . $objDatabase->SqlVariable($intId) . ' ORDER BY __sys_date');
return Counter::InstantiateDbResult($objResult);
}
