public function submit()
{
// @todo search indexer on posts (reindex all in case the topic_access level has changed))
$this->topic_subject_clean = titania_url::url_slug($this->topic_subject);
parent::submit();
// Hooks
titania::$hook->call_hook_ref(array(__CLASS__, __FUNCTION__), $this);
}
public function submit()
{
$this->attention_url = titania_url::unbuild_url($this->attention_url);
// Subscriptions
if (!$this->attention_id) {
$email_vars = array('NAME' => $this->attention_title, 'U_VIEW' => titania_url::build_url('manage/attention', array('type' => $this->attention_type, 'id' => $this->attention_object_id)));
titania_subscriptions::send_notifications(TITANIA_ATTENTION, 0, 'subscribe_notify.txt', $email_vars, $this->attention_poster_id);
}
parent::submit();
}
/**
* Add a Rating for an item
*
* @param mixed $rating The rating
*/
public function add_rating($rating)
{
if ($this->cannot_rate || !phpbb::$user->data['is_registered'] || !phpbb::$auth->acl_get('u_titania_rate')) {
return false;
}
if ($rating < 0 || $rating > titania::$config->max_rating || $this->rating_id) {
return false;
}
$this->rating_value = $rating;
parent::submit();
// This is accurate enough as long as we have at least 2 decimal places
$sql = "UPDATE {$this->cache_table} SET\n\t\t\t{$this->cache_rating} = ({$this->cache_rating} * {$this->rating_count} + {$this->rating_value}) / ({$this->rating_count} + 1),\n\t\t\t{$this->cache_rating_count} = {$this->cache_rating_count} + 1\n\t\t\tWHERE {$this->object_column} = {$this->rating_object_id}";
phpbb::$db->sql_query($sql);
return true;
}
/**
* Update/create the queue entry for this revision
*/
public function update_queue()
{
// Create the queue entry if required, else update it
if (titania::$config->use_queue && titania_types::$types[$this->contrib->contrib_type]->use_queue) {
$queue = $this->get_queue();
// Only create the queue for revisions set as new
if ($queue === false && $this->revision_status == TITANIA_REVISION_NEW) {
$queue = new titania_queue();
}
// If we have to create or update one...
if ($queue !== false) {
$queue->__set_array(array('revision_id' => $this->revision_id, 'contrib_id' => $this->contrib_id, 'contrib_name_clean' => $this->contrib->contrib_name_clean));
// Set the queue status to new if it's submitted and the queue status is set to hide it
if ($this->revision_submitted && $queue->queue_status == TITANIA_QUEUE_HIDE) {
// Only set the queue as new if there are not any newer revisions in the queue
$sql = 'SELECT queue_id FROM ' . TITANIA_QUEUE_TABLE . '
WHERE contrib_id = ' . (int) $this->contrib_id . '
AND revision_id > ' . $this->revision_id;
$result = phpbb::$db->sql_query($sql);
if (!($row = phpbb::$db->sql_fetchrow($result))) {
$queue->queue_status = TITANIA_QUEUE_NEW;
}
}
$queue->submit();
// Set the revision queue id
$this->revision_queue_id = $queue->queue_id;
parent::submit();
if ($this->revision_submitted) {
// Change the status on any old revisions that were in the queue and marked as New to repacked
$sql = 'SELECT * FROM ' . TITANIA_QUEUE_TABLE . '
WHERE contrib_id = ' . (int) $this->contrib_id . '
AND revision_id < ' . $this->revision_id . '
AND queue_status = ' . TITANIA_QUEUE_NEW;
$result = phpbb::$db->sql_query($sql);
while ($row = phpbb::$db->sql_fetchrow($result)) {
$queue = new titania_queue();
$queue->__set_array($row);
$queue->close(TITANIA_REVISION_RESUBMITTED);
unset($queue);
}
phpbb::$db->sql_freeresult($result);
}
}
}
}
/**
* Upload any files we attempted to attach
*
* @param bool|int $max_thumbnail_width The maximum thumbnail width (if we create one)
*/
public function upload($max_thumbnail_width = false)
{
// First, we shall handle the items already attached
$attached_ids = request_var($this->form_name . '_attachments', array(0));
// Query the ones we must
$to_query = array_diff($attached_ids, array_keys($this->attachments));
if (sizeof($to_query)) {
$sql = 'SELECT * FROM ' . $this->sql_table . '
WHERE ' . phpbb::$db->sql_in_set('attachment_id', array_map('intval', $to_query)) . '
AND object_type = ' . (int) $this->object_type . '
AND object_id = ' . (int) $this->object_id;
// Don't let them be messin with us
$result = phpbb::$db->sql_query($sql);
while ($row = phpbb::$db->sql_fetchrow($result)) {
$this->attachments[$row['attachment_id']] = $row;
}
phpbb::$db->sql_freeresult($result);
}
// Next, delete those requested
$delete = request_var('delete_file', array(0));
foreach ($delete as $attach_id => $null) {
$this->delete($attach_id);
$this->deleted = true;
// Sometime I'll look into this again; having it setup to only delete attachments after the form is submitted
/*if (isset($this->attachments[$attach_id]))
{
$this->attachments[$attach_id]['deleted'] = true;
}*/
}
// And undelete any
/*$undelete = request_var('undelete_file', array(0));
foreach ($delete as $attach_id => $null)
{
if (isset($this->attachments[$attach_id]))
{
$this->attachments[$attach_id]['deleted'] = false;
}
}*/
if (isset($_FILES[$this->form_name])) {
// In order to save ourselves from rewriting the phpBB uploader to support multi-uploads, we have to do some hacking
$uploaded_files = array();
if (is_array($_FILES[$this->form_name]['name'])) {
// Store the files in our own data array
foreach ($_FILES[$this->form_name]['name'] as $id => $name) {
$uploaded_files[] = array('name' => $name, 'type' => $_FILES[$this->form_name]['type'][$id], 'tmp_name' => $_FILES[$this->form_name]['tmp_name'][$id], 'error' => $_FILES[$this->form_name]['error'][$id], 'size' => $_FILES[$this->form_name]['size'][$id]);
}
} else {
// Compatibility with non-multi-upload forms
$uploaded_files[] = $_FILES[$this->form_name];
}
// Finally upload new items if required
foreach ($uploaded_files as $uploaded_file) {
// Hack time
$_FILES[$this->form_name] = $uploaded_file;
if ($_FILES[$this->form_name]['name'] != 'none' && trim($_FILES[$this->form_name]['name'])) {
// Setup uploader tool.
$this->uploader = new titania_uploader($this->form_name, $this->object_type);
// Try uploading the file.
$this->uploader->upload_file();
// Store for easier access
$this->error = array_merge($this->error, $this->uploader->filedata['error']);
// If we had no problems we can submit the data to the database.
if (!sizeof($this->uploader->filedata['error'])) {
// Create thumbnail
$has_thumbnail = false;
if ($this->uploader->filedata['is_image']) {
phpbb::_include('functions_posting', 'create_thumbnail');
$src = titania::$config->upload_path . utf8_basename($this->uploader->filedata['attachment_directory']) . '/' . utf8_basename($this->uploader->filedata['physical_filename']);
$dst = titania::$config->upload_path . utf8_basename($this->uploader->filedata['attachment_directory']) . '/thumb_' . utf8_basename($this->uploader->filedata['physical_filename']);
$has_thumbnail = $this->create_thumbnail($src, $dst, $this->uploader->filedata['mimetype'], $max_thumbnail_width, $max_thumbnail_width === false ? false : 0);
}
$this->__set_array(array('attachment_id' => 0, 'physical_filename' => $this->uploader->filedata['physical_filename'], 'attachment_directory' => $this->uploader->filedata['attachment_directory'], 'real_filename' => $this->uploader->filedata['real_filename'], 'extension' => $this->uploader->filedata['extension'], 'mimetype' => $this->uploader->filedata['mimetype'], 'filesize' => $this->uploader->filedata['filesize'], 'filetime' => $this->uploader->filedata['filetime'], 'hash' => $this->uploader->filedata['md5_checksum'], 'thumbnail' => $has_thumbnail, 'attachment_comment' => utf8_normalize_nfc(request_var('filecomment', '', true))));
parent::submit();
// Store in $this->attachments[]
$this->attachments[$this->attachment_id] = $this->__get_array();
// Additional fields
foreach ($this->additional_fields as $output_key => $row_key) {
$this->attachments[$this->attachment_id][$row_key] = utf8_normalize_nfc(request_var($row_key, '', true));
}
}
$this->uploaded = true;
}
}
// We do not want to upload it again if this function is called again.
unset($_FILES[$this->form_name]);
}
}
