PHP Topic::GetDatabase方法代碼示例

    /**
     * Unassociates all PeopleAsRead
     * @return void
     */
    public function UnassociateAllPeopleAsRead()
    {
        if (is_null($this->intId)) {
            throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAllPersonAsReadArray on this unsaved Topic.');
        }
        // Get the Database Object for this Class
        $objDatabase = Topic::GetDatabase();
        // Perform the SQL Query
        $objDatabase->NonQuery('
				DELETE FROM
					`read_topic_person_assn`
				WHERE
					`topic_id` = ' . $objDatabase->SqlVariable($this->intId) . '
			');
    }

 /**
  * Given a Topic and the number of items in a "page", this will
  * return the page number that the topic shows up in
  * when listing all topics for the Topic's forum, assuming
  * the list of topics is ordered by reverse last_post_date
  * @param Topic $objTopic the topic to search for
  * @param integer $intItemsPerPage
  * @param Zend_Search_Lucene_Search_QueryHit[] $objQueryHitArray a predefined set of topics to search through
  * @return unknown_type
  */
 public function GetPageNumber(Topic $objTopic, $intItemsPerPage, $objQueryHitArray = null)
 {
     if (is_null($objQueryHitArray)) {
         $objResult = Topic::GetDatabase()->Query('SELECT id FROM topic WHERE topic_link_id=' . $objTopic->TopicLinkId . ' ORDER BY last_post_date DESC');
         $intRecordNumber = 0;
         while ($objRow = $objResult->GetNextRow()) {
             $intRecordNumber++;
             if ($objRow->GetColumn('id') == $objTopic->Id) {
                 break;
             }
         }
     } else {
         $intRecordNumber = 0;
         foreach ($objQueryHitArray as $objHit) {
             $intRecordNumber++;
             if ($objHit->db_id == $objTopic->Id) {
                 break;
             }
         }
     }
     $intPageNumber = floor($intRecordNumber / $intItemsPerPage);
     if ($intRecordNumber % $intItemsPerPage) {
         $intPageNumber++;
     }
     return $intPageNumber;
 }

 /**
  * Searches using the search index for applicable topics, and returns topics as an array
  * Note that this will return ALL topics for the search.  No limit / pagination can be applied.
  * @param string $strSearchQuery
  * @return Topic[]
  */
 public static function LoadArrayBySearch($strSearchQuery)
 {
     // open the index
     $objIndex = new Zend_Search_Lucene(__SEARCH_INDEXES__ . '/topics');
     $intIdArray = array();
     $objHits = $objIndex->find($strSearchQuery);
     if (!count($objHits)) {
         return array();
     }
     foreach ($objHits as $objHit) {
         $intIdArray[] = $objHit->db_id;
         // note: do we want to do anything with $objHit->score (?)
     }
     $objResult = Topic::GetDatabase()->Query('SELECT * FROM topic WHERE id IN(' . implode(',', $intIdArray) . ');');
     while ($objRow = $objResult->GetNextRow()) {
         $objTopic = Topic::InstantiateDbRow($objRow);
         $objTopicArrayById[$objTopic->Id] = $objTopic;
     }
     $objTopicArray = array();
     foreach ($objHits as $objHit) {
         $objTopicArray[] = $objTopicArrayById[intval($objHit->db_id)];
     }
     return $objTopicArray;
 }

$objWikiPage->CompileHtml();
$objWikiItem->CreateNewVersion('Downloads from Old Qcodo.com Website', $objWikiPage, 'Save', array(), Person::Load(1), null);
print "Done.\r\n";
QDataGen::DisplayForEachTaskStart($strTitle = 'Refreshing Topic Stats', Topic::CountAll());
foreach (Topic::LoadAll() as $objTopic) {
    QDataGen::DisplayForEachTaskNext($strTitle);
    $objTopic->RefreshStats();
}
QDataGen::DisplayForEachTaskEnd($strTitle);
QDataGen::DisplayForEachTaskStart($strTitle = 'Refreshing TopicLink Stats', TopicLink::CountAll());
foreach (TopicLink::LoadAll() as $objTopicLink) {
    QDataGen::DisplayForEachTaskNext($strTitle);
    $objTopicLink->RefreshStats();
}
QDataGen::DisplayForEachTaskEnd($strTitle);
$objResult = $objDb->query('SELECT * FROM email_topic_person_assn');
while (QDataGen::DisplayWhileTask('Migrating email_topic_person_assn', $objResult->num_rows)) {
    $objRow = $objResult->fetch_array();
    try {
        Topic::GetDatabase()->NonQuery('INSERT INTO email_topic_person_assn(topic_id, person_id) VALUES (' . $objRow['topic_id'] . ',' . $objRow['person_id'] . ');');
    } catch (QMySqliDatabaseException $objExc) {
    }
}
$objResult = $objDb->query('SELECT * FROM read_topic_person_assn');
while (QDataGen::DisplayWhileTask('Migrating read_topic_person_assn', $objResult->num_rows)) {
    $objRow = $objResult->fetch_array();
    try {
        Topic::GetDatabase()->NonQuery('INSERT INTO read_topic_person_assn(topic_id, person_id) VALUES (' . $objRow['topic_id'] . ',' . $objRow['person_id'] . ');');
    } catch (QMySqliDatabaseException $objExc) {
    }
}

    /**
     * Unassociates all PeopleAsRead
     * @return void
     */
    public function UnassociateAllPeopleAsRead()
    {
        if (is_null($this->intId)) {
            throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAllPersonAsReadArray on this unsaved Topic.');
        }
        // Get the Database Object for this Class
        $objDatabase = Topic::GetDatabase();
        // Journaling (if applicable)
        if ($objDatabase->JournalingDatabase) {
            $objResult = $objDatabase->Query('SELECT `person_id` AS associated_id FROM `read_topic_person_assn` WHERE `topic_id` = ' . $objDatabase->SqlVariable($this->intId));
            while ($objRow = $objResult->GetNextRow()) {
                $this->JournalPersonAsReadAssociation($objRow->GetColumn('associated_id'), 'DELETE');
            }
        }
        // Perform the SQL Query
        $objDatabase->NonQuery('
				DELETE FROM
					`read_topic_person_assn`
				WHERE
					`topic_id` = ' . $objDatabase->SqlVariable($this->intId) . '
			');
    }