function newFileFromRow($row)
{
if (isset($row->img_name)) {
return LocalFile::newFromRow($row, $this);
} elseif (isset($row->oi_name)) {
return OldLocalFile::newFromRow($row, $this);
} else {
throw new MWException(__METHOD__ . ': invalid row');
}
}
/** purgeEverything inherited */
function getHistory($limit = null, $start = null, $end = null, $inc = true)
{
$dbr = $this->repo->getSlaveDB();
$tables = array('oldimage');
$fields = OldLocalFile::selectFields();
$conds = $opts = $join_conds = array();
$eq = $inc ? '=' : '';
$conds[] = "oi_name = " . $dbr->addQuotes($this->title->getDBkey());
if ($start) {
$conds[] = "oi_timestamp <{$eq} " . $dbr->addQuotes($dbr->timestamp($start));
}
if ($end) {
$conds[] = "oi_timestamp >{$eq} " . $dbr->addQuotes($dbr->timestamp($end));
}
if ($limit) {
$opts['LIMIT'] = $limit;
}
// Search backwards for time > x queries
$order = !$start && $end !== null ? 'ASC' : 'DESC';
$opts['ORDER BY'] = "oi_timestamp {$order}";
$opts['USE INDEX'] = array('oldimage' => 'oi_name_timestamp');
wfRunHooks('LocalFile::getHistory', array(&$this, &$tables, &$fields, &$conds, &$opts, &$join_conds));
$res = $dbr->select($tables, $fields, $conds, __METHOD__, $opts, $join_conds);
$r = array();
foreach ($res as $row) {
if ($this->repo->oldFileFromRowFactory) {
$r[] = call_user_func($this->repo->oldFileFromRowFactory, $row, $this->repo);
} else {
$r[] = OldLocalFile::newFromRow($row, $this->repo);
}
}
if ($order == 'ASC') {
$r = array_reverse($r);
// make sure it ends up descending
}
return $r;
}
/** purgeEverything inherited */
function getHistory($limit = null, $start = null, $end = null)
{
$dbr = $this->repo->getSlaveDB();
$conds = $opts = array();
$conds[] = "oi_name = " . $dbr->addQuotes($this->title->getDBKey());
if ($start !== null) {
$conds[] = "oi_timestamp <= " . $dbr->addQuotes($dbr->timestamp($start));
}
if ($end !== null) {
$conds[] = "oi_timestamp >= " . $dbr->addQuotes($dbr->timestamp($end));
}
if ($limit) {
$opts['LIMIT'] = $limit;
}
$opts['ORDER BY'] = 'oi_timestamp DESC';
$res = $dbr->select('oldimage', '*', $conds, __METHOD__, $opts);
$r = array();
while ($row = $dbr->fetchObject($res)) {
$r[] = OldLocalFile::newFromRow($row, $this->repo);
}
return $r;
}
function deletePermanently($title)
{
global $wgOut;
$ns = $title->getNamespace();
$t = $title->getDBkey();
$id = $title->getArticleID();
$cats = $title->getParentCategories();
$dbw = wfGetDB(DB_MASTER);
$dbw->begin();
####
## First delete entries, which are in direct relation with the page:
####
# delete redirect...
$dbw->delete('redirect', array('rd_from' => $id), __METHOD__);
# delete external link...
$dbw->delete('externallinks', array('el_from' => $id), __METHOD__);
# delete language link...
$dbw->delete('langlinks', array('ll_from' => $id), __METHOD__);
# delete search index...
$dbw->delete('searchindex', array('si_page' => $id), __METHOD__);
# Delete restrictions for the page
$dbw->delete('page_restrictions', array('pr_page' => $id), __METHOD__);
# Delete page Links
$dbw->delete('pagelinks', array('pl_from' => $id), __METHOD__);
# delete category links
$dbw->delete('categorylinks', array('cl_from' => $id), __METHOD__);
# delete template links
$dbw->delete('templatelinks', array('tl_from' => $id), __METHOD__);
# read text entries for all revisions and delete them.
$res = $dbw->select('revision', 'rev_text_id', "rev_page={$id}");
while ($row = $dbw->fetchObject($res)) {
$value = $row->rev_text_id;
$dbw->delete('text', array('old_id' => $value), __METHOD__);
}
# In the table 'revision' : Delete all the revision of the page where 'rev_page' = $id
$dbw->delete('revision', array('rev_page' => $id), __METHOD__);
# delete image links
$dbw->delete('imagelinks', array('il_from' => $id), __METHOD__);
####
## then delete entries which are not in direct relation with the page:
####
# Clean up recentchanges entries...
$dbw->delete('recentchanges', array('rc_namespace' => $ns, 'rc_title' => $t), __METHOD__);
# read text entries for all archived pages and delete them.
$res = $dbw->select('archive', 'ar_text_id', array('ar_namespace' => $ns, 'ar_title' => $t));
while ($row = $dbw->fetchObject($res)) {
$value = $row->ar_text_id;
$dbw->delete('text', array('old_id' => $value), __METHOD__);
}
# Clean archive entries...
$dbw->delete('archive', array('ar_namespace' => $ns, 'ar_title' => $t), __METHOD__);
# Clean up log entries...
$dbw->delete('logging', array('log_namespace' => $ns, 'log_title' => $t), __METHOD__);
# Clean up watchlist...
$dbw->delete('watchlist', array('wl_namespace' => $ns, 'wl_title' => $t), __METHOD__);
# In the table 'page' : Delete the page entry
$dbw->delete('page', array('page_id' => $id), __METHOD__);
####
## If the article belongs to a category, update category counts
####
if (!empty($cats)) {
foreach ($cats as $parentcat => $currentarticle) {
$catname = split(':', $parentcat, 2);
$cat = Category::newFromName($catname[1]);
$cat->refreshCounts();
}
}
####
## If an image is beeing deleted, some extra work needs to be done
####
if ($ns == NS_IMAGE) {
$file = wfFindFile($t);
if ($file) {
# Get all filenames of old versions:
$fields = OldLocalFile::selectFields();
$res = $dbw->select('oldimage', $fields, array('oi_name' => $t));
while ($row = $dbw->fetchObject($res)) {
$oldLocalFile = OldLocalFile::newFromRow($row, $file->repo);
$path = $oldLocalFile->getArchivePath() . '/' . $oldLocalFile->getArchiveName();
try {
# Using the FileStore to delete the file
$transaction = FileStore::deleteFile($path);
$transaction->commit();
} catch (Exception $e) {
$wgOut->addHTML($e->getMessage());
}
}
$path = $file->getPath();
try {
# Using the FileStore to delete the file itself
$transaction = FileStore::deleteFile($path);
$transaction->commit();
} catch (Exception $e) {
$wgOut->addHTML($e->getMessage());
}
}
# clean the filearchive for the given filename:
$fa_archive_name = array();
$res = $dbw->select('filearchive', 'fa_storage_key', array('fa_name' => $t));
while ($row = $dbw->fetchObject($res)) {
$key = $row->fa_storage_key;
# Using the FileStore to delete the file
$store = FileStore::get('deleted');
$transaction = $store->delete($key);
$transaction->commit();
}
# Delete old db entries of the image:
$dbw->delete('oldimage', array('oi_name' => $t), __METHOD__);
# Delete archive entries of the image:
$dbw->delete('filearchive', array('fa_name' => $t), __METHOD__);
# Delete image entry:
$dbw->delete('image', array('img_name' => $t), __METHOD__);
$dbw->commit();
$linkCache = LinkCache::singleton();
$linkCache->clear();
}
}
function purgeOldImagesSQL($whereSQL)
{
# Purge files of old version of any images uploaded by this user
# lance.gatlin@gmail.com: tested good 16Jul11
// MW is not adding the JOIN properly
// $oldImagesByUser_rows = $this->dbw->select('oldimage', array('oldimage.*'), array('img_user' => $this->user_id),'DatabaseBase::select',array(),array('image'=> array('LEFT JOIN','oi_name=img_name')));
$oldImages_rows = $this->dbw->query("SELECT * FROM {$this->oldimageTable} JOIN {$this->imageTable} ON oi_name=img_name WHERE {$whereSQL}");
if ($oldImages_rows->numRows() == 0) {
return;
}
foreach ($oldImages_rows as $row) {
# Images that are old versions of an existing image use OldLocalFile path => $IP/images/archive
$oldFile = OldLocalFile::newFromRow($row, $this->repo);
# Purge thumbnails and purge cache for pages using this image
$oldFile->purgeEverything();
# Purge thumbnail directories
// TODO: Mediawiki does not purge the directories used to store thumbnails
$path = $oldFile->getPath();
if ($path !== false && file_exists($path)) {
unlink($path);
}
}
# Purge old version of any images created by this user
# lance.gatlin@gmail.com: tested good 9Jul11
$this->dbw->deleteJoin('oldimage', 'image', 'oi_name', 'img_name', array($whereSQL));
}
