| post_user_ip | varchar(16) | YES | | NULL | |
| is_reply | int(1) | YES | | NULL | |
| action | int(3) | YES | | NULL | |
| metatitle | varchar(201) | YES | | NULL | |
| page_id | int(11) | YES | | NULL | |
| parent_page_id | int(11) | YES | | NULL | |
| event_date | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| reason | varchar(100) | YES | | NULL | |
| revision_id | int(11) | YES | | NULL | |
| deleted_or_removed | int(1) | YES | | 0 | |
| post_ns | int(11) | YES | | 1200 | |
| migrated | int(1) | YES | MUL | 0 | |
+--------------------+--------------+------+-----+-------------------+------------------------------
*/
$history = new WallHistory();
$dbw = $history->getDatawareDB();
$res = $dbw->select('wall_history', array('post_user_id', 'post_user_ip', 'is_reply', 'post_ns', 'page_id', 'parent_page_id', 'metatitle', 'deleted_or_removed', 'event_date', 'reason', 'action', 'revision_id', 'deleted_or_removed'), array('migrated' => 0, 'wiki_id' => $wgCityId), __METHOD__);
$in = array();
$db = $history->getDB(DB_MASTER);
$dir = dirname(__FILE__);
if (!$db->tableExists('wall_history')) {
echo "Try to create table\\'n";
$db->sourceFile($IP . "/extensions/wikia/Wall/sql/wall_history_local.sql");
}
while ($row = $dbw->fetchRow($res)) {
if ($row['action'] == WH_NEW || $row['action'] == WH_EDIT) {
$pagesRow = $db->selectRow('revision', array('rev_timestamp'), array('rev_id' => $row['revision_id']));
$row['event_date'] = wfTimestamp(TS_DB, $pagesRow->rev_timestamp);
}
$mw = WallMessage::newFromId($row['page_id']);
if (empty($mw)) {
