public function update()
{
!is_array($this->params()->implications) && ($this->params()->implications = []);
$ids = array_keys($this->params()->implications);
switch ($this->params()->commit) {
case "Delete":
$can_delete = true;
# iTODO:
# 'creator_id' column isn't, apparently, filled when creating implications or aliases.
foreach ($ids as $x) {
$ti = TagImplication::find($x);
$can_delete = $ti->is_pending && $ti->creator_id == current_user()->id;
$tis[] = $ti;
}
if (current_user()->is_mod_or_higher() || $can_delete) {
foreach ($tis as $ti) {
$ti->destroy_and_notify(current_user(), $this->params()->reason);
}
$this->notice("Tag implications deleted");
$this->redirectTo("#index");
} else {
$this->access_denied();
}
break;
case "Approve":
if (current_user()->is_mod_or_higher()) {
foreach ($ids as $x) {
if (CONFIG()->is_job_task_active('approve_tag_implication')) {
JobTask::create(['task_type' => "approve_tag_implication", 'status' => "pending", 'data' => ["id" => $x, "updater_id" => current_user()->id, "updater_ip_addr" => $this->request()->remoteIp()]]);
} else {
$ti = TagImplication::find($x);
$ti->approve(current_user(), $this->request()->remoteIp());
}
}
$this->notice("Tag implication approval jobs created");
$this->redirectTo('job_task#index');
} else {
$this->access_denied();
}
break;
default:
$this->access_denied();
break;
}
}
$ti = TagImplication::find($x);
// $can_delete = ($ti->is_pending && $ti->creator_id == User::$current->id);
$tis[] = $ti;
}
if (User::is('>=40') && $can_delete) {
foreach ($tis as $ti) {
$ti->destroy_and_notify(User::$current, Request::$params->reason);
}
notice("Tag implications deleted");
redirect_to("#index");
} else {
access_denied();
}
break;
case "Approve":
if (User::is('>=40')) {
foreach ($ids as $x) {
if (CONFIG::enable_asynchronous_tasks) {
// JobTask.create(:task_type => "approve_tag_implication", :status => "pending", :data => {"id" => x, "updater_id" => @current_user.id, "updater_ip_addr" => request.remote_ip})
} else {
$ti = TagImplication::find($x);
$ti->approve(User::$current, Request::$remote_ip);
}
}
notice("Tag implication approval jobs created");
redirect_to('job_task#index');
} else {
access_denied();
}
break;
}
<?php
auto_set_params(array('commit', 'query'));
set_title("Tag Implications");
create_page_params();
if (Request::$params->commit == "Search Aliases") {
redirect_to("tag_alias#index", array('query' => Request::$params->query));
}
if (Request::$params->query) {
$name = "%" . Request::$params->query . "%";
$implications = TagImplication::find_all(array('calc_rows', 'order' => "is_pending DESC, (SELECT name FROM tags WHERE id = tag_implications.predicate_id), (SELECT name FROM tags WHERE id = tag_implications.consequent_id)", 'per_page' => 20, 'conditions' => array("predicate_id IN (SELECT id FROM tags WHERE name LIKE ?) OR consequent_id IN (SELECT id FROM tags WHERE name LIKE ?)", $name, $name), 'page' => Request::$params->page));
} else {
$implications = TagImplication::find_all(array('calc_rows', 'order' => "is_pending DESC, (SELECT name FROM tags WHERE id = tag_implications.predicate_id), (SELECT name FROM tags WHERE id = tag_implications.consequent_id)", 'per_page' => 20, 'page' => Request::$params->page));
}
calc_pages();
respond_to_list("implications");
public function execute_approve_tag_implication()
{
$ti = TagImplication::find($this->data->id);
$updater_id = $this->data->updater_id;
$updater_ip_addr = $this->data->updater_ip_addr;
$ti->approve($updater_id, $updater_ip_addr);
}
function commit_tags()
{
if ($this->is_empty_model()) {
return;
}
$this->tags = array_filter(explode(' ', str_replace(array("\r", "\n"), '', $this->tags)));
$this->current_tags = array_keys($this->parsed_cached_tags);
if (empty($this->old_tags)) {
$this->old_tags = $this->tags;
} elseif (!is_array($this->old_tags)) {
$this->old_tags = array_filter(explode(' ', $this->old_tags));
}
$this->commit_metatags();
foreach ($this->tags as $k => $tag) {
if (!preg_match('~^(-pool|pool|rating|parent|child):|^[qse]$~', $tag)) {
continue;
}
if (in_array($tag, array('q', 's', 'e'))) {
$tag = "rating:{$tag}";
}
$subparam = explode(':', $tag);
$metatag = array_shift($subparam);
$param = array_shift($subparam);
$subparam = empty($subparam) ? null : array_shift($subparam);
switch ($metatag) {
case 'rating':
# Change rating. This will override rating selected on radio buttons.
if (in_array($param, array('q', 's', 'e'))) {
$this->rating = $param;
}
unset($this->tags[$k]);
break;
case 'pool':
try {
$name = $param;
$seq = $subparam;
# Workaround: I don't understand how can the pool be found when finding_by_name
# using the id.
if (ctype_digit($name)) {
$pool = Pool::find_by_id($name);
} else {
$pool = Pool::find_by_name($name);
}
# Set :ignore_already_exists, so pool:1:2 can be used to change the sequence number
# of a post that already exists in the pool.
$options = array('user' => User::find($this->updater_user_id), 'ignore_already_exists' => true);
if ($seq) {
$options['sequence'] = $seq;
}
if (!$pool and !ctype_digit($name)) {
$pool = Pool::create(array('name' => $name, 'is_public' => false, 'user_id' => $this->updater_user_id));
}
if (!$pool) {
continue;
}
if (!$pool->can_change(User::$current, null)) {
continue;
}
$pool->add_post($this->id, $options);
} catch (PostAlreadyExistsError $e) {
} catch (AccessDeniedError $e) {
}
unset($this->tags[$k]);
break;
case '-pool':
unset($this->tags[$k]);
$name = $param;
$cmd = $subparam;
$pool = Pool::find_by_name($name);
if (!$pool->can_change(User::$current, null)) {
break;
}
if ($cmd == "parent") {
# If we have a parent, remove ourself from the pool and add our parent in
# our place. If we have no parent, do nothing and leave us in the pool.
if (!empty($this->parent_id)) {
$pool->transfer_post_to_parent($this->id, $this->parent_id);
break;
}
}
$pool && $pool->remove_post($id);
break;
case 'source':
$this->source = $param;
unset($this->tags[$k]);
break;
case 'parent':
if (is_numeric($param)) {
$this->parent_id = (int) $param;
}
unset($this->tags[$k]);
break;
case 'child':
unset($this->tags[$k]);
break;
default:
unset($this->tags[$k]);
break;
}
}
$new_tags = array_diff($this->tags, $this->old_tags);
$new_tags = array_merge($new_tags, TagAlias::to_aliased($new_tags));
$new_tags = array_merge($new_tags, TagImplication::with_implied($new_tags));
$new_tags = array_values(array_unique($new_tags));
$old_tags = array_diff($this->old_tags, $this->tags);
if (empty($new_tags) && $old_tags == $this->current_tags) {
if (!in_array('tagme', $new_tags)) {
$new_tags[] = 'tagme';
}
if (in_array('tagme', $old_tags)) {
unset($old_tags[array_search('tagme', $old_tags)]);
}
}
foreach ($old_tags as $tag) {
if (array_key_exists($tag, $this->parsed_cached_tags)) {
unset($this->parsed_cached_tags[$tag]);
}
$tag = Tag::find_by_name($tag);
if ($tag) {
DB::delete('posts_tags WHERE post_id = ? AND tag_id = ?', $this->id, $tag->id);
}
}
foreach ($new_tags as $tag) {
$tag = Tag::find_or_create_by_name($tag);
$this->parsed_cached_tags[$tag->name] = $tag->type_name;
DB::insert_ignore('posts_tags VALUES (?, ?)', $this->id, $tag->id);
}
$this->tags = $this->tag_names();
$this->generate_cached_tags();
}
/**
* It's strange how actions like changing pool's sequence, that updates the post via
* update_batch and sends only one metatag: 'pool:$id:$seq' and doesn't send old_tags, don't
* mess up the rest of the tags (because that metatag is discarted, and the post is left without
* old_tags or any tag).
* So we're gonna do a workaround for that: if the new tags only contain metatags, we won't
* take any further action but commit such metatags.
* We'll use $had_metatags for that.
*/
protected function commit_tags()
{
if ($this->isNewRecord() || !$this->new_tags) {
return;
}
if ($this->old_tags) {
# If someone else committed changes to this post before we did,
# then try to merge the tag changes together.
$current_tags = explode(' ', $this->cached_tags);
$this->old_tags = Tag::scan_tags($this->old_tags);
$this->new_tags = array_filter(array_merge(array_diff(array_merge($current_tags, $this->new_tags), $this->old_tags), array_intersect($current_tags, $this->new_tags)));
}
$this->commit_metatags();
$meta_tags = ['-pool:', 'pool:', 'rating:', 'parent:', 'child:', 'source:'];
$ratings = ['q', 's', 'e'];
$had_metatags = false;
foreach ($this->new_tags as $k => $tag) {
# To avoid preg_match.
$is_mt = false;
foreach ($meta_tags as $mt) {
if (strpos($tag, $mt) === 0 || in_array($tag, $ratings)) {
$is_mt = true;
break;
}
}
if (!$is_mt) {
continue;
}
$had_metatags = true;
unset($this->new_tags[$k]);
if (in_array($tag, $ratings)) {
$tag = 'rating:' . $tag;
}
$subparam = explode(':', $tag, 3);
$metatag = array_shift($subparam);
$param = array_shift($subparam);
$subparam = empty($subparam) ? null : array_shift($subparam);
switch ($metatag) {
case 'rating':
# Change rating. This will override rating selected on radio buttons.
if (in_array($param, $ratings)) {
$this->rating = $param;
}
break;
case 'pool':
try {
$name = $param;
$seq = $subparam;
# Workaround: I don't understand how can the pool be found when finding_by_name
# using the id.
if (ctype_digit($name)) {
$pool = Pool::where(['id' => $name])->first();
} else {
$pool = Pool::where(['name' => $name])->first();
}
# Set :ignore_already_exists, so pool:1:2 can be used to change the sequence number
# of a post that already exists in the pool.
$options = array('user' => User::where('id = ?', $this->updater_user_id)->first(), 'ignore_already_exists' => true);
if ($seq) {
$options['sequence'] = $seq;
}
if (!$pool and !ctype_digit($name)) {
$pool = Pool::create(array('name' => $name, 'is_public' => false, 'user_id' => $this->updater_user_id));
}
if (!$pool || !$pool->can_change(current_user(), null)) {
continue;
}
$pool->add_post($this->id, $options);
} catch (Pool_PostAlreadyExistsError $e) {
} catch (Pool_AccessDeniedError $e) {
}
break;
case '-pool':
$name = $param;
$cmd = $subparam;
$pool = Pool::where(['name' => $name])->first();
if (!$pool->can_change(current_user(), null)) {
break;
}
if ($cmd == "parent") {
# If we have a parent, remove ourself from the pool and add our parent in
# our place. If we have no parent, do nothing and leave us in the pool.
if (!empty($this->parent_id)) {
$pool->transfer_post_to_parent($this->id, $this->parent_id);
break;
}
}
$pool && $pool->remove_post($id);
break;
case 'source':
$this->source = $param;
break;
case 'parent':
if (is_numeric($param)) {
$this->parent_id = (int) $param;
}
break;
case 'child':
unset($this->new_tags[$k]);
break;
}
}
if (!$this->new_tags) {
if ($had_metatags) {
return;
}
$this->new_tags[] = "tagme";
}
// $this->tags = implode(' ', array_unique(TagImplication::with_implied(TagAlias::to_aliased($this->new_tags))));
$this->new_tags = TagAlias::to_aliased($this->new_tags);
$this->new_tags = array_unique(TagImplication::with_implied($this->new_tags));
sort($this->new_tags);
// $this->tags = implode(' ', $this->tags());
# TODO: be more selective in deleting from the join table
self::connection()->executeSql("DELETE FROM posts_tags WHERE post_id = ?", $this->id);
$new_tags_ids = [];
$new_tags_names = [];
$this->new_tags = array_map(function ($x) use(&$new_tags_ids, &$new_tags_names) {
$tag = Tag::find_or_create_by_name($x);
if (!in_array($tag->id, $new_tags_ids)) {
$new_tags_ids[] = $tag->id;
$new_tags_names[] = $tag->name;
return $tag;
}
}, $this->new_tags);
unset($new_tags_ids);
$this->new_tags = array_filter($this->new_tags);
# If any tags are newly active, expire the tag cache.
if ($this->new_tags) {
$any_new_tags = false;
$previous_tags = explode(' ', $this->cached_tags);
foreach ($this->new_tags as $tag) {
# If this tag is in old_tags, then it's already active and we just removed it
# in the above DELETE, so it's not really a newly activated tag. (This isn't
# self.old_tags; that's the tags the user saw before he edited, not the data
# we're replacing.)
if ($tag->post_count == 0 and !in_array($tag->name, $previous_tags)) {
$any_new_tags = true;
break;
}
}
if ($any_new_tags) {
Moebooru\CacheHelper::expire_tag_version();
}
}
# Sort
sort($new_tags_names);
sort($this->new_tags);
$tag_set = implode(", ", array_map(function ($x) {
return "(" . $this->id . ", " . $x->id . ")";
}, $this->new_tags));
$this->cached_tags = implode(' ', $new_tags_names);
$sql = "INSERT INTO posts_tags (post_id, tag_id) VALUES " . $tag_set;
self::connection()->executeSql($sql);
# Store the old cached_tags, so we can expire them.
$this->old_cached_tags = $this->cached_tags;
// Commenting the following line; it will cause cached_tags to not to be updated.
// They're set above.
// $this->cached_tags = self::connection()->selectValue("SELECT cached_tags FROM posts WHERE id = " . $this->id);
$this->new_tags = null;
}
<?php
required_params('tag_implication');
$ti = TagImplication::blank(array_merge(Request::$params->tag_implication, array('is_pending' => true)));
if ($ti->save()) {
notice("Tag implication created");
} else {
notice("Error: " . implode(', ', $ti->record_errors->full_messages()));
}
redirect_to("#index");
