/**
* constructor
*
* @param string $renderer_type Classname of the renderer to use
*/
public function __construct($renderer_type = 'diff_renderer_unified')
{
$this->renderer_type = $renderer_type;
$this->ext_root_path = \titania::$root_path;
phpbb::_include('diff/diff', false, 'diff');
phpbb::_include('diff/engine', false, 'diff');
phpbb::_include('diff/renderer', false, 'diff');
phpbb::_include('functions_compress', false, 'compress');
}
/**
* Static Constructor.
*/
public static function initialise()
{
global $auth, $config, $db, $template, $user, $cache, $request;
global $phpbb_container, $phpbb_dispatcher, $phpbb_root_path;
self::$auth =& $auth;
self::$config =& $config;
self::$db =& $db;
self::$template =& $template;
self::$user =& $user;
self::$cache =& $cache;
self::$request =& $request;
self::$container =& $phpbb_container;
self::$dispatcher =& $phpbb_dispatcher;
self::$root_path = $phpbb_root_path;
self::$php_ext = self::$container->getParameter('core.php_ext');
}
/**
* Generate text for display
* Returns the result of generate_text_for_display() from phpBB's functions_content.php file, but has hacks in place to let us use our own bbcode.html file
*
* @param mixed $text
* @param mixed $uid
* @param mixed $bitfield
* @param mixed $flags
* @return mixed
*/
function titania_generate_text_for_display($text, $uid, $bitfield, $flags)
{
if (titania::$hook->call_hook(__FUNCTION__, $text, $uid, $bitfield, $flags)) {
if (titania::$hook->hook_return(__FUNCTION__)) {
return titania::$hook->hook_return_result(__FUNCTION__);
}
}
global $phpbb_root_path;
phpbb::_include('bbcode', false, 'bbcode');
// HAX
$phpbb_root_path = TITANIA_ROOT;
$return = generate_text_for_display($text, $uid, $bitfield, $flags);
// UnHAX
$phpbb_root_path = PHPBB_ROOT_PATH;
return $return;
}
/**
* Static Constructor.
*/
public static function initialise()
{
global $auth, $config, $db, $template, $user, $cache;
self::$auth =& $auth;
self::$config =& $config;
self::$db =& $db;
self::$template =& $template;
self::$user =& $user;
self::$cache =& $cache;
// Start session management
if (!defined('PHPBB_INCLUDED')) {
self::$user->session_begin();
self::$auth->acl(self::$user->data);
self::$user->setup();
}
self::$theme_data = self::$user->theme;
}
function main($id, $mode)
{
global $phpbb_root_path;
define('PHPBB_INCLUDED', true);
define('USE_PHPBB_TEMPLATE', true);
define('IN_TITANIA', true);
if (!defined('PHP_EXT')) {
define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
}
require TITANIA_ROOT . 'common.' . PHP_EXT;
// Need a few hacks to be used from within phpBB
titania_url::decode_url(titania::$config->phpbb_script_path);
titania::$hook->register(array('titania_url', 'build_url'), 'titania_outside_build_url', 'standalone');
titania::$hook->register(array('titania_url', 'append_url'), 'titania_outside_build_url', 'standalone');
titania::$hook->register(array('titania', 'page_header'), 'titania_outside_page_header', 'standalone');
titania::$hook->register(array('titania', 'page_footer'), 'titania_outside_page_footer', 'standalone');
titania::$hook->register('titania_generate_text_for_display', 'titania_outside_generate_text_for_display', 'standalone');
titania::add_lang('manage');
$this->p_master->assign_tpl_vars(phpbb::append_sid('mcp'));
phpbb::$template->assign_vars(array('L_TITLE' => phpbb::$user->lang['ATTENTION'], 'L_EXPLAIN' => ''));
include TITANIA_ROOT . 'manage/attention.' . PHP_EXT;
}
/**
*
* @package Titania
* @version $Id$
* @copyright (c) 2008 phpBB Customisation Database Team
* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License
*
*/
/**
* @ignore
*/
if (!defined('IN_TITANIA')) {
exit;
}
phpbb::_include('functions_upload', false, 'fileupload');
/**
* Handles uploading attachments for Titania.
*/
class titania_uploader extends fileupload
{
/**
* Some vars we need
*
* @var mix
*/
public $form_name = '';
public $ext_group = '';
/**
* Array of data holding informatiom about the file being uploaded.
*
/**
* Set the options in the template
*/
public function set_in_template()
{
// Assign some variables to the template parser
phpbb::$template->assign_vars(array('S_BBCODE_CHECKED' => $this->enable_bbcode ? '' : ' checked="checked"', 'S_SMILIES_CHECKED' => $this->enable_smilies ? '' : ' checked="checked"', 'S_MAGIC_URL_CHECKED' => $this->enable_magic_url ? '' : ' checked="checked"', 'BBCODE_STATUS' => sprintf(phpbb::$user->lang[$this->bbcode_status ? 'BBCODE_IS_ON' : 'BBCODE_IS_OFF'], '<a href="' . phpbb::append_sid('faq', 'mode=bbcode') . '">', '</a>'), 'IMG_STATUS' => $this->img_status ? phpbb::$user->lang['IMAGES_ARE_ON'] : phpbb::$user->lang['IMAGES_ARE_OFF'], 'FLASH_STATUS' => $this->flash_status ? phpbb::$user->lang['FLASH_IS_ON'] : phpbb::$user->lang['FLASH_IS_OFF'], 'SMILIES_STATUS' => $this->smilies_status ? phpbb::$user->lang['SMILIES_ARE_ON'] : phpbb::$user->lang['SMILIES_ARE_OFF'], 'URL_STATUS' => $this->url_status ? phpbb::$user->lang['URL_IS_ON'] : phpbb::$user->lang['URL_IS_OFF'], 'S_BBCODE_ALLOWED' => $this->bbcode_status, 'S_SMILIES_ALLOWED' => $this->smilies_status, 'S_LINKS_ALLOWED' => $this->url_status, 'S_BBCODE_IMG' => $this->img_status, 'S_BBCODE_URL' => $this->url_status, 'S_BBCODE_FLASH' => $this->flash_status, 'S_BBCODE_QUOTE' => true));
}
/**
* Hard delete a post
*/
public function hard_delete()
{
if (!$this->topic->topic_posts) {
if (!$this->topic->load($this->topic_id)) {
return false;
}
}
// Update the postcount for the topic
$this->update_topic_postcount(true);
// Set the visibility appropriately if no posts are visibile to the public/authors
$flags = titania_count::get_flags(TITANIA_ACCESS_PUBLIC);
if (titania_count::from_db($this->topic->topic_posts, $flags) <= 0) {
// There are no posts visible to the public, change it to authors level access
$this->topic->topic_access = TITANIA_ACCESS_AUTHORS;
$flags = titania_count::get_flags(TITANIA_ACCESS_AUTHORS);
if (titania_count::from_db($this->topic->topic_posts, $flags) <= 0) {
// There are no posts visible to authors, change it to teams level access
$this->topic->topic_access = TITANIA_ACCESS_TEAMS;
}
}
// Sync the first topic post if required
if ($this->post_id == $this->topic->topic_first_post_id) {
$this->topic->sync_first_post($this->post_id);
}
// Sync the last topic post if required
if ($this->post_id == $this->topic->topic_last_post_id) {
$this->topic->sync_last_post($this->post_id);
}
// Submit the topic to store the updated information
$this->topic->submit();
// Remove from the search index
titania_search::delete($this->post_type, $this->post_id);
// @todo remove attachments and other things
// Remove any attention items
$sql = 'DELETE FROM ' . TITANIA_ATTENTION_TABLE . '
WHERE attention_object_type = ' . TITANIA_POST . '
AND attention_object_id = ' . $this->post_id;
phpbb::$db->sql_query($sql);
// Decrement the user's postcount if we must
if (!$this->post_deleted && $this->post_approved && in_array($this->post_type, titania::$config->increment_postcount)) {
phpbb::update_user_postcount($this->post_user_id, '-');
}
// Hooks
titania::$hook->call_hook_ref(array(__CLASS__, __FUNCTION__), $this);
// Initiate self-destruct mode
parent::delete();
// Check if the topic is empty
$flags = titania_count::get_flags(TITANIA_ACCESS_TEAMS, true, true);
if (titania_count::from_db($this->topic->topic_posts, $flags) <= 0) {
// Remove any subscriptions to this topic
$sql = 'DELETE FROM ' . TITANIA_WATCH_TABLE . '
WHERE watch_object_type = ' . TITANIA_TOPIC . '
AND watch_object_id = ' . $this->topic->topic_id;
phpbb::$db->sql_query($sql);
// Remove any tracking for this topic
titania_tracking::clear_item(TITANIA_TOPIC, $this->topic->topic_id);
// Delete the now empty topic
$sql = 'DELETE FROM ' . TITANIA_TOPICS_TABLE . '
WHERE topic_id = ' . $this->topic->topic_id;
phpbb::$db->sql_query($sql);
}
}
/**
* Assign details
*
* A little different from those in other classes, this one only returns the info ready for output
*/
public function assign_details()
{
// Tracking check
$last_read_mark = $this->tracking->get_track(TITANIA_TOPIC, $this->topic_id, true);
$last_read_mark = max($last_read_mark, $this->tracking->find_last_read_mark($this->additional_unread_fields, $this->topic_type, $this->parent_id));
$this->unread = $this->topic_last_post_time > $last_read_mark ? true : false;
$folder_img = $folder_alt = '';
$this->topic_folder_img($folder_img, $folder_alt);
// To find out if we have any posts that need approval
$approved = count::from_db($this->topic_posts, count::get_flags(access::PUBLIC_LEVEL, false, false));
$total = count::from_db($this->topic_posts, count::get_flags(access::PUBLIC_LEVEL, false, true));
$u_new_post = '';
if ($this->unread) {
$u_new_post = $this->get_url(false, array('view' => 'unread', '#' => 'unread'));
}
$details = array('TOPIC_ID' => $this->topic_id, 'TOPIC_TYPE' => $this->topic_type, 'TOPIC_ACCESS' => $this->topic_access, 'TOPIC_STATUS' => $this->topic_status, 'TOPIC_STICKY' => $this->topic_sticky, 'TOPIC_LOCKED' => $this->topic_locked, 'POSTS_APPROVED' => phpbb::$auth->acl_get('u_titania_mod_post_mod') && $total > $approved ? false : true, 'TOPIC_APPROVED' => phpbb::$auth->acl_get('u_titania_mod_post_mod') ? $this->topic_approved : true, 'TOPIC_REPORTED' => phpbb::$auth->acl_get('u_titania_mod_post_mod') ? $this->topic_reported : false, 'TOPIC_ASSIGNED' => $this->topic_assigned, 'TOPIC_REPLIES' => $this->get_postcount() - 1, 'TOPIC_VIEWS' => $this->topic_views, 'TOPIC_SUBJECT' => censor_text($this->topic_subject), 'TOPIC_FIRST_POST_ID' => $this->topic_first_post_id, 'TOPIC_FIRST_POST_USER_ID' => $this->topic_first_post_user_id, 'TOPIC_FIRST_POST_USER_COLOUR' => $this->topic_first_post_user_colour, 'TOPIC_FIRST_POST_USER_FULL' => get_username_string('full', $this->topic_first_post_user_id, $this->topic_first_post_username, $this->topic_first_post_user_colour, false, phpbb::append_sid('memberlist', 'mode=viewprofile')), 'TOPIC_FIRST_POST_TIME' => phpbb::$user->format_date($this->topic_first_post_time), 'TOPIC_LAST_POST_ID' => $this->topic_last_post_id, 'TOPIC_LAST_POST_USER_ID' => $this->topic_last_post_user_id, 'TOPIC_LAST_POST_USER_COLOUR' => $this->topic_last_post_user_colour, 'TOPIC_LAST_POST_USER_FULL' => get_username_string('full', $this->topic_last_post_user_id, $this->topic_last_post_username, $this->topic_last_post_user_colour, false, phpbb::append_sid('memberlist', 'mode=viewprofile')), 'TOPIC_LAST_POST_TIME' => phpbb::$user->format_date($this->topic_last_post_time), 'TOPIC_LAST_POST_SUBJECT' => censor_text($this->topic_last_post_subject), 'U_NEWEST_POST' => $u_new_post, 'U_VIEW_TOPIC' => $this->get_url(), 'U_VIEW_LAST_POST' => $this->get_url(false, array('p' => $this->topic_last_post_id, '#' => 'p' . $this->topic_last_post_id)), 'S_UNREAD_TOPIC' => $this->unread ? true : false, 'S_ACCESS_TEAMS' => $this->topic_access == access::TEAM_LEVEL ? true : false, 'S_ACCESS_AUTHORS' => $this->topic_access == access::AUTHOR_LEVEL ? true : false, 'FOLDER_STYLE' => $folder_img, 'FOLDER_IMG' => phpbb::$user->img($folder_img, $folder_alt), 'FOLDER_IMG_SRC' => phpbb::$user->img($folder_img, $folder_alt, false, '', 'src'), 'FOLDER_IMG_ALT' => phpbb::$user->lang[$folder_alt], 'FOLDER_IMG_WIDTH' => phpbb::$user->img($folder_img, '', false, '', 'width'), 'FOLDER_IMG_HEIGHT' => phpbb::$user->img($folder_img, '', false, '', 'height'));
// Hooks
titania::$hook->call_hook_ref(array(__CLASS__, __FUNCTION__), $details, $this);
return $details;
}
/**
* 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]);
}
}
/**
* Ignore this for now!
* Moving it to the side for later...
*/
public function email_friend()
{
phpbb::$user->add_lang('memberlist');
if (!phpbb::$config['email_enable']) {
titania::error_box('ERROR', 'EMAIL_DISABLED', TITANIA_ERROR, HEADER_SERVICE_UNAVAILABLE);
return false;
}
if (!phpbb::$user->data['is_registered'] || phpbb::$user->data['is_bot'] || !phpbb::$auth->acl_get('u_sendemail')) {
if (phpbb::$user->data['user_id'] == ANONYMOUS) {
login_box(titania::$page, phpbb::$user->lang['ERROR_CONTRIB_EMAIL_FRIEND']);
}
titania::error_box('ERROR', 'ERROR_CONTRIB_EMAIL_FRIEND', TITANIA_ERROR, HEADER_FORBIDDEN);
return false;
}
// Are we trying to abuse the facility?
if (titania::$time - phpbb::$user->data['user_emailtime'] < phpbb::$config['flood_interval']) {
trigger_error('FLOOD_EMAIL_LIMIT', E_USER_NOTICE);
}
$name = utf8_normalize_nfc(request_var('name', '', true));
$email = request_var('email', '');
$email_lang = request_var('lang', phpbb::$config['default_lang']);
$message = utf8_normalize_nfc(request_var('message', '', true));
$cc = isset($_POST['cc_email']) ? true : false;
$submit = isset($_POST['submit']) ? true : false;
add_form_key('contrib_email');
phpbb::$template->assign_vars(array('S_LANG_OPTIONS' => language_select($email_lang), 'S_POST_ACTION' => phpbb::append_sid(titania::$page, array('id' => 'email', 'contrib_id' => $this->contrib_id))));
$error = array();
if ($submit) {
if (!check_form_key('contrib_email')) {
$error[] = 'FORM_INVALID';
}
if (!$email || !preg_match('/^' . get_preg_expression('email') . '$/i', $email)) {
$error[] = 'EMPTY_ADDRESS_EMAIL';
}
if (!$name) {
$error[] = 'EMPTY_NAME_EMAIL';
}
if (!empty($error)) {
titania::error_box('ERROR', $error, TITANIA_ERROR);
return false;
}
phpbb::_include('functions_messenger', false, 'messenger');
$sql = 'UPDATE ' . USERS_TABLE . '
SET user_emailtime = ' . titania::$time . '
WHERE user_id = ' . (int) phpbb::$user->data['user_id'];
$result = phpbb::$db->sql_query($sql);
$mail_to_users = array();
$mail_to_users[] = array('email_lang' => $email_lang, 'email' => $email, 'name' => $name);
// Ok, now the same email if CC specified, but without exposing the users email address
if ($cc) {
$mail_to_users[] = array('email_lang' => phpbb::$user->data['user_lang'], 'email' => phpbb::$user->data['user_email'], 'name' => phpbb::$user->data['username']);
}
$lang_path = phpbb::$user->lang_path;
phpbb::$user->set_custom_lang_path(titania::$config->language_path);
$messenger = new messenger(false);
foreach ($mail_to_users as $row) {
$messenger->template('contrib_recommend', $row['email_lang']);
$messenger->replyto(phpbb::$user->data['user_email']);
$messenger->to($row['email'], $row['name']);
$messenger->headers('X-AntiAbuse: Board servername - ' . phpbb::$config['server_name']);
$messenger->headers('X-AntiAbuse: User_id - ' . (int) phpbb::$user->data['user_id']);
$messenger->headers('X-AntiAbuse: Username - ' . phpbb::$user->data['username']);
$messenger->headers('X-AntiAbuse: User IP - ' . phpbb::$user->ip);
$messenger->assign_vars(array('BOARD_CONTACT' => phpbb::$config['board_contact'], 'TO_USERNAME' => htmlspecialchars_decode($name), 'FROM_USERNAME' => htmlspecialchars_decode(phpbb::$user->data['username']), 'MESSAGE' => htmlspecialchars_decode($message), 'CONTRIB_NAME' => htmlspecialchars_decode($this->contrib_name), 'U_CONTRIB' => phpbb::append_sid(titania::$page, array('contrib_id' => $this->contrib_id, 'id' => 'details'), true, '')));
$messenger->send(NOTIFY_EMAIL);
}
phpbb::$user->set_custom_lang_path($lang_path);
titania::error_box('SUCCESS', 'EMAIL_SENT', TITANIA_SUCCESS);
return true;
}
return false;
}
if (!defined('TITANIA_ROOT')) {
define('TITANIA_ROOT', './');
}
if (!defined('PHP_EXT')) {
define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
}
require TITANIA_ROOT . 'common.' . PHP_EXT;
titania::add_lang('manage');
// Give founders access to run this
if (phpbb::$user->data['user_type'] != USER_FOUNDER) {
titania::needs_auth();
}
// Hopefully this helps
@set_time_limit(0);
if (!isset(phpbb::$config['titania_hook_phpbb_com'])) {
phpbb::_include('../umil/umil', false, 'umil');
$umil = new umil(true, phpbb::$db);
$umil->run_actions('update', array('1.0.0' => array('table_column_add' => array(array(TITANIA_TOPICS_TABLE, 'phpbb_topic_id', array('UINT', 0))))), 'titania_hook_phpbb_com');
unset($umil);
}
// Hack for local
phpbb::$config['site_upload_dir'] = !isset(phpbb::$config['site_upload_dir']) ? '../phpBB3_titania/files/contribdb' : '../../' . phpbb::$config['site_upload_dir'];
$screenshots_dir = phpbb::$config['site_upload_dir'] . '/demo/';
// Table prefix
$ariel_prefix = 'community_site_';
$limit = 1000;
$mod_validation_trash_forum = 28;
$style_validation_trash_forum = 83;
$step = request_var('step', 0);
$start = request_var('start', 0);
// Populated later
/**
* Display topic section for support/tracker/etc
*
* @param object $topic The topic object
* @param titania_sort $sort The sort object (includes/tools/sort.php)
*/
public static function display_topic($topic, $sort = false)
{
if ($sort === false) {
// Setup the sort tool
$sort = self::build_sort();
}
$sort->request();
$sql_ary = array('SELECT' => 'p.*', 'FROM' => array(TITANIA_POSTS_TABLE => 'p'), 'WHERE' => 'p.topic_id = ' . (int) $topic->topic_id . self::sql_permissions('p.'), 'ORDER_BY' => $sort->get_order_by());
// Main SQL Query
$sql = phpbb::$db->sql_build_query('SELECT', $sql_ary);
// Handle pagination
if (!$sort->sql_count($sql_ary, 'p.post_id')) {
// No results...no need to query more...
return;
}
$sort->build_pagination($topic->get_url());
// Get the data
$post_ids = $user_ids = array();
$last_post_time = 0;
// tracking
$result = phpbb::$db->sql_query_limit($sql, $sort->limit, $sort->start);
while ($row = phpbb::$db->sql_fetchrow($result)) {
self::$posts[$row['post_id']] = $row;
self::$posts[$row['post_id']]['attachments'] = array();
$post_ids[] = $row['post_id'];
$user_ids[] = $row['post_user_id'];
$user_ids[] = $row['post_edit_user'];
$user_ids[] = $row['post_delete_user'];
$last_post_time = $row['post_time'];
// to set tracking
}
phpbb::$db->sql_freeresult($result);
// Grab the tracking data
$last_mark_time = titania_tracking::get_track(TITANIA_TOPIC, $topic->topic_id);
// Store tracking data
titania_tracking::track(TITANIA_TOPIC, $topic->topic_id, $last_post_time);
// load the user data
users_overlord::load($user_ids);
phpbb::_include('functions_profile_fields', false, 'custom_profile');
$cp = new custom_profile();
$post = new titania_post($topic->topic_type, $topic);
$attachments = new titania_attachment($topic->topic_type, false);
// Grab all attachments
$attachments_set = $attachments->load_attachments_set($post_ids);
// Loop de loop
$prev_post_time = 0;
foreach ($post_ids as $post_id) {
$post->__set_array(self::$posts[$post_id]);
$attachments->clear_attachments();
if (isset($attachments_set[$post_id])) {
$attachments->store_attachments($attachments_set[$post_id]);
}
// Parse attachments before outputting the message
$message = $post->generate_text_for_display();
$parsed_attachments = $attachments->parse_attachments($message);
// Prepare message text for use in javascript
$message_decoded = censor_text($post->post_text);
titania_decode_message($message_decoded, $post->post_text_uid);
$message_decoded = bbcode_nl2br($message_decoded);
// Build CP Fields
$cp_row = array();
if (isset(users_overlord::$cp_fields[$post->post_user_id])) {
$cp_row = $cp->generate_profile_fields_template('show', false, users_overlord::$cp_fields[$post->post_user_id]);
}
$cp_row['row'] = isset($cp_row['row']) && sizeof($cp_row['row']) ? $cp_row['row'] : array();
// Display edit info
$display_username = get_username_string('full', $post->post_user_id, users_overlord::get_user($post->post_user_id, 'username'), users_overlord::get_user($post->post_user_id, 'user_colour'), false, phpbb::append_sid('memberlist', 'mode=viewprofile'));
$l_edited_by = $post->post_edit_time ? sprintf(phpbb::$user->lang['EDITED_MESSAGE'], $display_username, phpbb::$user->format_date($post->post_edit_time)) : '';
phpbb::$template->assign_block_vars('posts', array_merge($post->assign_details(false), users_overlord::assign_details($post->post_user_id), $cp_row['row'], array('POST_TEXT' => $message, 'POST_TEXT_DECODED' => $message_decoded, 'EDITED_MESSAGE' => $l_edited_by, 'U_MINI_POST' => titania_url::append_url($topic->get_url(), array('p' => $post_id, '#p' => $post_id)), 'MINI_POST_IMG' => $post->post_time > $last_mark_time ? phpbb::$user->img('icon_post_target_unread', 'NEW_POST') : phpbb::$user->img('icon_post_target', 'POST'), 'S_FIRST_UNREAD' => $post->post_time > $last_mark_time && $prev_post_time <= $last_mark_time ? true : false)));
// Output CP Fields
if (!empty($cp_row['blockrow'])) {
foreach ($cp_row['blockrow'] as $field_data) {
phpbb::$template->assign_block_vars('posts.custom_fields', $field_data);
}
}
//S_IGNORE_POST
//POST_ICON_IMG
//MINI_POST_IMG
foreach ($parsed_attachments as $attachment) {
phpbb::$template->assign_block_vars('posts.attachment', array('DISPLAY_ATTACHMENT' => $attachment));
}
$prev_post_time = $post->post_time;
}
unset($post, $attachments);
// Increment the topic view count
$sql = 'UPDATE ' . TITANIA_TOPICS_TABLE . '
SET topic_views = topic_views + 1
WHERE topic_id = ' . (int) $topic->topic_id;
phpbb::$db->sql_query($sql);
}
* @package Titania
* @version $Id$
* @copyright (c) 2008 phpBB Customisation Database Team
* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License
*
*/
/**
* @ignore
*/
if (!defined('IN_TITANIA')) {
exit;
}
phpbb::_include('diff/diff', false, 'diff');
phpbb::_include('diff/engine', false, 'diff');
phpbb::_include('diff/renderer', false, 'diff');
phpbb::_include('functions_compress', false, 'compress');
/**
* Class to create diffs for updated versions
* @package Titania
*/
class titania_diff
{
/**
* Classname of the diff renderer to use
*
* @var string
*/
private $renderer_type;
/**
* Identification for old and new
* This is used by from_dir to add an identification to the diff file
/**
* Allow to create a new topic, to reply to a topic, to edit a post or the first_post of a topic in database
* @param $mode post/reply/edit/edit_first_post/edit_last_post
* @param $options array Array with post data, see our documentation for exact required items
* @param $poll array Array with poll options.
*
* @return mixed false if there was an error, else topic_id when $mode is post, post_id when $mode is reply, true when mode is edit
*/
function phpbb_posting($mode, &$options, $poll = array())
{
if (!in_array($mode, array('post', 'reply', 'edit', 'edit_first_post', 'edit_last_post'))) {
return false;
}
phpbb::_include('bbcode', false, 'bbcode');
phpbb::_include('message_parser', false, 'parse_message');
phpbb::_include('functions_posting', 'submit_post', false);
// Set some defaults
$options = array_merge($options, array('enable_bbcode' => true, 'enable_urls' => true, 'enable_smilies' => true, 'topic_type' => POST_NORMAL));
$message_parser = new parse_message($options['post_text']);
// Get the data we need
if ($mode == 'reply') {
$sql = 'SELECT f.*, t.*
FROM ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t
WHERE t.topic_id = ' . (int) $options['topic_id'] . '
AND f.forum_id = t.forum_id';
$result = phpbb::$db->sql_query($sql);
$post_data = phpbb::$db->sql_fetchrow($result);
phpbb::$db->sql_freeresult($result);
} else {
if ($mode == 'edit') {
$sql = 'SELECT f.*, t.*, p.*
FROM ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p
WHERE p.post_id = ' . (int) $options['post_id'] . '
AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id';
$result = phpbb::$db->sql_query($sql);
$post_data = phpbb::$db->sql_fetchrow($result);
phpbb::$db->sql_freeresult($result);
} else {
if ($mode == 'edit_first_post') {
$sql = 'SELECT f.*, t.*, p.*
FROM ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p
WHERE t.topic_id = ' . (int) $options['topic_id'] . '
AND p.post_id = t.topic_first_post_id
AND f.forum_id = t.forum_id';
$result = phpbb::$db->sql_query($sql);
$post_data = phpbb::$db->sql_fetchrow($result);
phpbb::$db->sql_freeresult($result);
//http://tracker.phpbb.com/browse/PHPBB3-9644
$mode = 'edit';
} else {
if ($mode == 'edit_last_post') {
$sql = 'SELECT f.*, t.*, p.*
FROM ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p
WHERE t.topic_id = ' . (int) $options['topic_id'] . '
AND p.post_id = t.topic_last_post_id
AND f.forum_id = t.forum_id';
$result = phpbb::$db->sql_query($sql);
$post_data = phpbb::$db->sql_fetchrow($result);
phpbb::$db->sql_freeresult($result);
//http://tracker.phpbb.com/browse/PHPBB3-9644
$mode = 'edit';
} else {
$sql = 'SELECT *
FROM ' . FORUMS_TABLE . '
WHERE forum_id = ' . (int) $options['forum_id'];
$result = phpbb::$db->sql_query($sql);
$post_data = phpbb::$db->sql_fetchrow($result);
phpbb::$db->sql_freeresult($result);
}
}
}
}
if (!$post_data) {
return false;
}
// If we need to post the message as a different user other than the one logged in
if (isset($options['poster_id']) && $options['poster_id']) {
// Some data for the ugly fix below :P
$sql = 'SELECT username, user_colour, user_permissions, user_type
FROM ' . USERS_TABLE . '
WHERE user_id = ' . (int) $options['poster_id'];
$result = phpbb::$db->sql_query($sql);
$user_data = phpbb::$db->sql_fetchrow($result);
phpbb::$db->sql_freeresult($result);
if (!$user_data) {
return false;
}
// Ugly fix, to be sure it is posted for the right user ;)
$old_user_data = phpbb::$user->data;
phpbb::$user->data['user_id'] = $options['poster_id'];
phpbb::$user->data['username'] = $user_data['username'];
phpbb::$user->data['user_colour'] = $user_data['user_colour'];
phpbb::$user->data['user_permissions'] = $user_data['user_permissions'];
phpbb::$user->data['user_type'] = $user_data['user_type'];
// Same for auth, be sure its posted with correct permissions :)
$old_auth = phpbb::$auth;
phpbb::$auth = new auth();
phpbb::$auth->acl(phpbb::$user->data);
}
// When editing a post, submit post does not update the bbcode uid, we have to specify the old one.
if (in_array($mode, array('edit', 'edit_first_post', 'edit_last_post'))) {
$message_parser->bbcode_uid = $post_data['bbcode_uid'];
}
// Parse the BBCode
if ($options['enable_bbcode']) {
$message_parser->parse($options['enable_bbcode'], $options['enable_urls'], $options['enable_smilies'], (bool) phpbb::$auth->acl_get('f_img', $post_data['forum_id']), (bool) phpbb::$auth->acl_get('f_flash', $post_data['forum_id']), true, phpbb::$config['allow_post_links']);
}
// Setup the settings we need to send to submit_post
$data = array('topic_title' => $options['topic_title'], 'enable_bbcode' => (bool) $options['enable_bbcode'], 'enable_smilies' => (bool) $options['enable_smilies'], 'enable_urls' => (bool) $options['enable_urls'], 'message_md5' => (string) md5($message_parser->message), 'bbcode_bitfield' => $message_parser->bbcode_bitfield, 'bbcode_uid' => $message_parser->bbcode_uid, 'message' => $message_parser->message, 'force_approved_state' => true, 'post_time' => time(), 'notify_set' => false, 'notify' => false);
switch ($mode) {
case 'post':
$data = array_merge(array('icon_id' => isset($options['icon_id']) ? $options['icon_id'] : 0, 'poster_id' => isset($options['poster_id']) && $options['poster_id'] ? (int) $options['poster_id'] : phpbb::$user->data['user_id'], 'enable_sig' => isset($options['enable_sig']) ? (bool) $options['enable_sig'] : true, 'post_edit_locked' => isset($options['post_edit_locked']) ? $options['post_edit_locked'] : false), $data);
break;
case 'reply':
$data = array_merge(array('poster_id' => isset($options['poster_id']) && $options['poster_id'] ? (int) $options['poster_id'] : phpbb::$user->data['user_id'], 'enable_sig' => isset($options['enable_sig']) ? (bool) $options['enable_sig'] : true, 'post_edit_locked' => isset($options['post_edit_locked']) ? $options['post_edit_locked'] : false), $data);
break;
}
// Merge the data we grabbed from the forums/topics/posts tables
$data = array_merge($data, $post_data);
// Aaaand, submit it.
switch ($mode) {
case 'post':
case 'reply':
submit_post($mode, $options['topic_title'], isset($options['poster_id']) && $options['poster_id'] ? $user_data['username'] : phpbb::$user->data['username'], $options['topic_type'], $poll, $data);
break;
default:
submit_post($mode, $options['topic_title'], phpbb::$user->data['username'], $options['topic_type'], $poll, $data);
break;
}
// Change the status? submit_post does not support setting this
if (isset($options['topic_status'])) {
$sql = 'UPDATE ' . TOPICS_TABLE . '
SET topic_status = ' . (int) $options['topic_status'] . '
WHERE topic_id = ' . $data['topic_id'] . '
AND topic_moved_id = 0';
phpbb::$db->sql_query($sql);
}
// Restore the user data
if (isset($options['poster_id']) && $options['poster_id']) {
phpbb::$user->data = $old_user_data;
$auth = $old_auth;
}
// Add the new data to the options (to grab post/topic id/etc if we want it later)
$options = array_merge($data, $options);
if ($mode == 'post') {
return $data['topic_id'];
} else {
if ($mode == 'reply') {
return $data['post_id'];
}
}
return true;
}
/**
* Hard delete a post
*/
public function hard_delete()
{
if (!$this->topic->topic_posts) {
if (!$this->topic->load($this->topic_id)) {
return false;
}
}
// Update the postcount for the topic
$this->update_topic_postcount(true);
// Set the visibility appropriately if no posts are visibile to the public/authors
$flags = count::get_flags(access::PUBLIC_LEVEL);
if (count::from_db($this->topic->topic_posts, $flags) <= 0) {
// There are no posts visible to the public, change it to authors level access
$this->topic->topic_access = access::AUTHOR_LEVEL;
$flags = count::get_flags(access::AUTHOR_LEVEL);
if (count::from_db($this->topic->topic_posts, $flags) <= 0) {
// There are no posts visible to authors, change it to teams level access
$this->topic->topic_access = access::TEAM_LEVEL;
}
}
// Sync the first topic post if required
if ($this->post_id == $this->topic->topic_first_post_id) {
$this->topic->sync_first_post($this->post_id);
}
// Sync the last topic post if required
if ($this->post_id == $this->topic->topic_last_post_id) {
$this->topic->sync_last_post($this->post_id);
}
// Submit the topic to store the updated information
$this->topic->submit();
// Remove from the search index
$this->search_manager->delete($this->post_type, $this->post_id);
// @todo remove attachments and other things
// Remove any attention items
$sql = 'DELETE FROM ' . TITANIA_ATTENTION_TABLE . '
WHERE attention_object_type = ' . TITANIA_POST . '
AND attention_object_id = ' . $this->post_id;
phpbb::$db->sql_query($sql);
// Decrement the user's postcount if we must
if (!$this->post_deleted && $this->post_approved && in_array($this->post_type, titania::$config->increment_postcount)) {
phpbb::update_user_postcount($this->post_user_id, '-');
}
// Hooks
titania::$hook->call_hook_ref(array(__CLASS__, __FUNCTION__), $this);
// Initiate self-destruct mode
parent::delete();
// Update topics posted table
$this->topic->update_posted_status('remove', $this->post_user_id);
// Check if the topic is empty
$flags = count::get_flags(access::TEAM_LEVEL, true, true);
if (count::from_db($this->topic->topic_posts, $flags) <= 0) {
$this->topic->delete();
}
}
private function addUserToPhpbb($forum_group_id = 0, $user_id = 0)
{
// Initial checks
if (!$forum_group_id > 0 || !$user_id > 0) {
return false;
}
// Setup the phpBB-class
$phpbb_class = JPATH_ADMINISTRATOR . '/components/com_ssrrn_msc/phpbb/phpbb.php';
if (!file_exists($phpbb_class)) {
return false;
}
require_once $phpbb_class;
$phpbb = new phpbb();
// Fetch the right php_bbuser_id from JFusion
$query = 'SELECT `userid` FROM `#__jfusion_users_plugin` WHERE `id`="' . (int) $user_id . '" AND `jname`="phpbb3"';
$db = JFactory::getDBO();
$db->setQuery($query);
$forum_user_id = $db->loadResult();
// Connect to phpBB
$check = $phpbb->connect_phpbb();
if ($check == '0') {
return false;
}
// If we are connected and we have proper IDs
if ($forum_user_id > 0 && $forum_group_id > 0) {
try {
$query = 'SELECT * FROM `#__user_group` WHERE `group_id`="' . $forum_group_id . '" AND `user_id`="' . $forum_user_id . '"';
$phpbb->setQuery($query);
$result = $phpbb->loadObjectList();
} catch (Exception $e) {
}
if (empty($result)) {
try {
$query = 'INSERT INTO `#__user_group` SET `group_id`="' . $forum_group_id . '", `user_id`="' . $forum_user_id . '",
`user_pending`="0"';
$phpbb->setQuery($query);
$phpbb->query();
} catch (Exception $e) {
}
}
}
}
*
* This file is part of the phpBB Customisation Database package.
*
* @copyright (c) phpBB Limited <https://www.phpbb.com>
* @license GNU General Public License, version 2 (GPL-2.0)
*
* For full copyright and license information, please see
* the docs/CREDITS.txt file.
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB')) {
exit;
}
global $phpbb_container;
$ext_root_path = $phpbb_container->getParameter('phpbb.titania.root_path');
$php_ext = $phpbb_container->getParameter('core.php_ext');
// Include core classes
require $ext_root_path . 'includes/core/phpbb.' . $php_ext;
require $ext_root_path . 'includes/core/titania.' . $php_ext;
titania::configure($phpbb_container->get('phpbb.titania.config'), $ext_root_path, $php_ext);
// Set up our auto-loader
spl_autoload_register(array('titania', 'autoload'));
// Include the dynamic constants (after reading the Titania config file, but before loading the phpBB common file)
titania::_include('dynamic_constants');
// Initialise phpBB
phpbb::initialise();
// Initialise Titania
titania::initialise();
/**
* Trigger author change confirmation.
*
* @param string $username New author's username.
* @param int $user_id New author's user id.
*
* @return null
*/
protected function confirm_author_change($username, $user_id)
{
$s_hidden_fields = array('submit' => true, 'change_owner_id' => $user_id);
$author_profile = '<a href="' . \phpbb::append_sid('memberlist', 'mode=viewprofile&u=' . $user_id) . '">' . $username . '</a>';
confirm_box(false, $this->user->lang('CONTRIB_CONFIRM_OWNER_CHANGE', $author_profile), build_hidden_fields($s_hidden_fields));
}
titania::$contrib->change_permalink($permalink);
}
}
// Submit the changes
titania::$contrib->submit();
// Set the coauthors
titania::$contrib->set_coauthors($active_coauthors_list, $nonactive_coauthors_list, true);
// Create relations
titania::$contrib->put_contrib_in_categories($contrib_categories);
// Update the release topic
titania::$contrib->update_release_topic();
if ($change_owner == '') {
redirect(titania::$contrib->get_url());
} else {
$s_hidden_fields = array('submit' => true, 'change_owner' => $change_owner, 'change_owner_id' => $change_owner_id);
titania::confirm_box(false, sprintf(phpbb::$user->lang['CONTRIB_CONFIRM_OWNER_CHANGE'], '<a href="' . phpbb::append_sid('memberlist', 'mode=viewprofile&u=' . $change_owner_id) . '">' . $change_owner . '</a>'), titania_url::append_url(titania_url::$current_page), $s_hidden_fields);
}
}
} else {
$sql = 'SELECT category_id
FROM ' . TITANIA_CONTRIB_IN_CATEGORIES_TABLE . '
WHERE contrib_id = ' . titania::$contrib->contrib_id;
$result = phpbb::$db->sql_query($sql);
while ($row = phpbb::$db->sql_fetchrow($result)) {
$contrib_categories[] = $row['category_id'];
}
phpbb::$db->sql_freeresult($result);
$active_coauthors = $nonactive_coauthors = array();
foreach (titania::$contrib->coauthors as $row) {
// User does not exist anymore...
if (users_overlord::get_user($row['user_id'], 'user_id') != $row['user_id']) {
/**
* Send the approve/deny notification
*/
private function send_approve_deny_notification($approve = true)
{
$this->user->add_lang_ext('phpbb/titania', 'manage');
phpbb::_include('functions_privmsgs', 'submit_pm');
// Need some stuff
$contrib = new titania_contribution();
$contrib->load((int) $this->contrib_id);
$revision = new titania_revision($contrib, $this->revision_id);
$revision->load();
// Generate the authors list to send it to
$authors = array($contrib->contrib_user_id => 'to');
$sql = 'SELECT user_id FROM ' . TITANIA_CONTRIB_COAUTHORS_TABLE . '
WHERE contrib_id = ' . (int) $this->contrib_id . '
AND active = 1';
$result = phpbb::$db->sql_query($sql);
while ($row = phpbb::$db->sql_fetchrow($result)) {
$authors[$row['user_id']] = 'to';
}
phpbb::$db->sql_freeresult($result);
// Subject
$subject = sprintf(phpbb::$user->lang[$contrib->type->validation_subject], $contrib->contrib_name, $revision->revision_version);
// Message
$notes = $this->validation_notes;
message::decode($notes, $this->validation_notes_uid);
if ($approve) {
$message = $contrib->type->validation_message_approve;
} else {
$message = $contrib->type->validation_message_deny;
}
$message = sprintf(phpbb::$user->lang[$message], $notes);
// Replace empty quotes if there are no notes
if (!$notes) {
$message = str_replace('[quote][/quote]', phpbb::$user->lang['NO_NOTES'], $message);
}
// Parse the message
$message_uid = $message_bitfield = $message_options = false;
generate_text_for_storage($message, $message_uid, $message_bitfield, $message_options, true, true, true);
$data = array('address_list' => array('u' => $authors), 'from_user_id' => phpbb::$user->data['user_id'], 'from_username' => phpbb::$user->data['username'], 'icon_id' => 0, 'from_user_ip' => phpbb::$user->ip, 'enable_bbcode' => true, 'enable_smilies' => true, 'enable_urls' => true, 'enable_sig' => true, 'message' => $message, 'bbcode_bitfield' => $message_bitfield, 'bbcode_uid' => $message_uid);
// Hooks
titania::$hook->call_hook_ref(array(__CLASS__, __FUNCTION__), $data, $this);
// Submit Plz
submit_pm('post', $subject, $data, true);
}
continue;
}
$type = explode(':', $vars['type']);
$l_explain = '';
if ($vars['explain'] && isset($vars['lang_explain'])) {
$l_explain = isset(phpbb::$user->lang[$vars['lang_explain']]) ? phpbb::$user->lang[$vars['lang_explain']] : $vars['lang_explain'];
} else {
if ($vars['explain']) {
$l_explain = isset(phpbb::$user->lang[$vars['lang'] . '_EXPLAIN']) ? phpbb::$user->lang[$vars['lang'] . '_EXPLAIN'] : '';
}
}
$content = build_cfg_template($type, $name, $vars);
if (empty($content)) {
continue;
}
phpbb::$template->assign_block_vars('options', array('KEY' => $name, 'TITLE' => isset(phpbb::$user->lang[$vars['lang']]) ? phpbb::$user->lang[$vars['lang']] : $vars['lang'], 'S_EXPLAIN' => $vars['explain'], 'TITLE_EXPLAIN' => $l_explain, 'CONTENT' => $content['tpl'], 'S_FIND_USER' => isset($content['find_user']) ? true : false, 'U_FIND_USER' => isset($content['find_user']) ? phpbb::append_sid('memberlist', array('mode' => 'searchuser', 'form' => 'select_user', 'field' => 'username', 'select_single' => 'true', 'form' => 'stk', 'field' => $content['find_user_field'])) : ''));
}
titania::page_footer(true, 'manage/tool_options.html');
} else {
if (is_string($options)) {
if (titania::confirm_box(true) || isset($_GET['submit']) && check_link_hash(request_var('hash', ''), 'manage')) {
$tool->run_tool();
} else {
titania::confirm_box(false, $options, titania_url::build_url('manage/administration', array('t' => $plugin->tool_id)));
}
} else {
// The page should have been setup by the tool. We will exit to prevent the redirect from below.
exit;
}
}
}
/**
* Get phpBB profile url
*
* @return string
*/
public function get_phpbb_profile_url()
{
if ($this->user_id) {
return phpbb::append_sid('memberlist', 'mode=viewprofile&u=' . $this->user_id);
}
return '';
}
* This file is part of the phpBB Customisation Database package.
*
* @copyright (c) phpBB Limited <https://www.phpbb.com>
* @license GNU General Public License, version 2 (GPL-2.0)
*
* For full copyright and license information, please see
* the docs/CREDITS.txt file.
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB')) {
exit;
}
phpbb::_include('hooks/index', false, 'phpbb_hook');
/**
* Titania Hook Class
*
* Same as phpBB's hook class, but not requiring the hooks to be registered at class construction time
*/
class titania_hook extends phpbb_hook
{
/**
* Initialize hook class.
*/
public function titania_hook()
{
if (function_exists('phpbb_hook_register')) {
phpbb_hook_register($this);
}
function phpbb_com_move_queue_topic($queue_object)
{
$sql = 'SELECT phpbb_topic_id, topic_category FROM ' . TITANIA_TOPICS_TABLE . '
WHERE topic_id = ' . (int) $queue_object->queue_topic_id;
$result = phpbb::$db->sql_query($sql);
$row = phpbb::$db->sql_fetchrow($result);
phpbb::$db->sql_freeresult($result);
if (!$row['phpbb_topic_id']) {
return;
}
phpbb::_include('functions_admin', 'move_topics');
move_topics($row['phpbb_topic_id'], phpbb_com_forum_id($row['topic_category'], 'trash'));
}
/**
* Send Notifications
*
* Using this function:
* Call this function when you know the Object type, object id, and the email
* template name.
* Sample usage:
*
* <code>
*
* $object_type = SOME_OBJECT_CONSTANT_TYPE;
* $obhect)id = 242974;
*
* titania_subscriptions::send_notifications($object_type, $object_id, 'mod_subscribe', array(
* 'OBJECT_NAME' => 'Some MOD',
* ));
*
* </code>
*
* The vars parameter will be used in the messanger assign vars, which will act
* as the common vars when sending out the notifications. Data such as the MOD's
* or Style's name should go here, what action was taken, etc. The usernaeme and
* emails of the recepiants will be personalised by the function. Ensure the
* email template has the {USERNAME} var present.
*
* @param $exclude_user User_id of the one who posted the item to exclude them from the sending
*
*/
public static function send_notifications($object_type, $object_id, $email_tpl, $vars, $exclude_user = false)
{
$sql = 'SELECT w.watch_user_id, w.watch_type, u.user_id, u.username, u.user_email
FROM ' . TITANIA_WATCH_TABLE . ' w, ' . USERS_TABLE . ' u
WHERE w.watch_user_id = u.user_id ';
if (is_array($object_type) || is_array($object_id)) {
// Both needs to be arrays if one is and they need to have the same number of elements.
if (!is_array($object_type) || !is_array($object_id) || sizeof($object_type) != sizeof($object_id)) {
return;
}
$sql_objects = '';
foreach ($object_type as $key => $value) {
$sql_objects .= ($sql_objects == '' ? '' : ' OR ') . '(w.watch_object_type = ' . (int) $value . '
AND w.watch_object_id = ' . (int) $object_id[$key] . ')';
}
$sql .= 'AND (' . $sql_objects . ')';
unset($sql_objects);
} else {
$sql .= 'AND w.watch_object_type = ' . (int) $object_type . '
AND w.watch_object_id = ' . (int) $object_id;
}
$sql .= $exclude_user ? ' AND w.watch_user_id <> ' . (int) $exclude_user : '';
$result = phpbb::$db->sql_query($sql);
// Throw everything here
$user_data = array();
while ($row = phpbb::$db->sql_fetchrow($result)) {
// Use user_id for the keys to not send duplicates.
$user_data[$row['user_id']] = array('username' => $row['username'], 'user_email' => $row['user_email'], 'watch_type' => $row['watch_type']);
}
// No one subscribed? We're done.
if (!sizeof($user_data)) {
return;
}
// You wanted the email template parsed? Well here you go.
$template = file_get_contents(TITANIA_ROOT . 'language/en/email/' . $email_tpl);
foreach ($vars as $var => $replace) {
if (strtoupper($var) == 'SUBJECT') {
continue;
}
$template = str_replace('{' . strtoupper($var) . '}', $replace, $template);
}
// Steal the subject if it exists
$subject = '';
if (($subject_start = strpos($template, 'Subject:')) !== false) {
$subject_length = strpos($template, "\n", $subject_start) - $subject_start;
$subject = substr($template, $subject_start, $subject_length);
$template = substr($template, 0, $subject_start) . substr($template, $subject_start + $subject_length);
}
$subject = isset($vars['SUBJECT']) ? $vars['SUBJECT'] : $subject;
$subject = $subject ? $subject : phpbb::$user->lang['SUBSCRIPTION_NOTIFICATION'];
// Send to each user
// Add a new case statment for each subscription type
foreach ($user_data as $data) {
// Generic messages that will be sent to each module individually
$message = str_replace('{USERNAME}', $data['username'], $template);
/*
* Switch between the types.
* ------------------------------------------
* When adding a type, the final message will
* be stored in $message, and the subject is
* stored in $vars['SUBJECT'].
*/
switch ($data['watch_type']) {
case SUBSCRIPTION_EMAIL:
// Only make the object if we need it
phpbb::_include('functions_messenger', false, 'messenger');
$messenger = new messenger();
$messenger->headers('X-AntiAbuse: Board servername - ' . phpbb::$config['server_name']);
$messenger->headers('X-AntiAbuse: User_id - ' . phpbb::$user->data['user_id']);
$messenger->headers('X-AntiAbuse: Username - ' . phpbb::$user->data['username']);
// HAX
$user_lang_path = phpbb::$user->lang_path;
phpbb::$user->lang_path = TITANIA_ROOT . 'language/';
$messenger->template('subscribe_generic');
// Reverse HAX
phpbb::$user->lang_path = $user_lang_path;
$messenger->to($data['user_email'], $data['username']);
$messenger->assign_vars(array_merge($vars, array('SUBJECT' => $subject, 'MESSAGE' => $message)));
$messenger->send();
$messenger->save_queue();
break;
}
}
return;
}
/**
* Install a style on the demo board.
*
* @param string $phpbb_root_path
* @param mixed contrib object
*/
public function install_demo_style($phpbb_root_path, $contrib)
{
phpbb::$user->add_lang('acp/styles');
if ($phpbb_root_path[strlen($phpbb_root_path) - 1] != '/') {
$phpbb_root_path .= '/';
}
if (!is_dir($phpbb_root_path) || !file_exists($phpbb_root_path . 'config.' . PHP_EXT)) {
$this->error[] = 'PATH_INVALID';
return false;
}
include $phpbb_root_path . 'config.' . PHP_EXT;
$sql_db = !empty($dbms) ? 'dbal_' . basename($dbms) : 'dbal';
// Is this DBAL loaded?
phpbb::_include('db/' . $dbms, false, $sql_db);
// Instantiate DBAL class
$db = new $sql_db();
// Connect to demo board DB
$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport);
// We do not need this any longer, unset for safety purposes
unset($dbpasswd);
if (empty($this->unzip_dir)) {
// Extract zip.
$this->unzip_dir = titania::$config->contrib_temp_path . basename($this->original_zip, 'zip') . '/';
// Clear out old stuff if there is anything here...
$this->rmdir_recursive($this->unzip_dir);
// Unzip to our temp directory
$this->extract($this->original_zip, $this->unzip_dir);
}
$package_root = $this->find_root(false, 'style.cfg');
$stylecfg = parse_cfg_file($this->unzip_dir . $package_root . '/style.cfg');
$style_root = $phpbb_root_path . 'styles/' . $contrib->contrib_id . '/';
$this->mvdir_recursive($this->unzip_dir . $package_root, $style_root, false);
$this->rmdir_recursive($this->unzip_dir);
$variables = array('db', 'phpbb_root_path');
// Let's get lazy.
foreach ($variables as $variable) {
${'_' . $variable} = $GLOBALS[$variable];
$GLOBALS[$variable] = ${$variable};
}
// Get the acp_styles class.
phpbb::_include('acp/acp_styles', false, 'acp_styles');
if (!defined('TEMPLATE_BITFIELD')) {
// Hardcoded template bitfield to add for new templates
$bitfield = new bitfield();
$bitfield->set(0);
$bitfield->set(1);
$bitfield->set(2);
$bitfield->set(3);
$bitfield->set(4);
$bitfield->set(8);
$bitfield->set(9);
$bitfield->set(11);
$bitfield->set(12);
define('TEMPLATE_BITFIELD', $bitfield->get_base64());
unset($bitfield);
}
$styles = new acp_styles();
// Fill the configuration variables
$styles->style_cfg = $styles->template_cfg = $styles->theme_cfg = $styles->imageset_cfg = '
#
# phpBB {MODE} configuration file
#
# @package phpBB3
# @copyright (c) 2005 phpBB Group
# @license http://opensource.org/licenses/gpl-license.php GNU Public License
#
#
# At the left is the name, please do not change this
# At the right the value is entered
# For on/off options the valid values are on, off, 1, 0, true and false
#
# Values get trimmed, if you want to add a space in front or at the end of
# the value, then enclose the value with single or double quotes.
# Single and double quotes do not need to be escaped.
#
#
# General Information about this {MODE}
name = {NAME}
copyright = {COPYRIGHT}
version = {VERSION}
';
$styles->theme_cfg .= '
# Some configuration options
#
# You have to turn this option on if you want to use the
# path template variables ({T_IMAGESET_PATH} for example) within
# your css file.
# This is mostly the case if you want to use language specific
# images within your css file.
#
parse_css_file = {PARSE_CSS_FILE}
';
$styles->template_cfg .= '
# Some configuration options
#
# You can use this function to inherit templates from another template.
# The template of the given name has to be installed.
# Templates cannot inherit from inheriting templates.
#';
$styles->imageset_keys = array('logos' => array('site_logo'), 'buttons' => array('icon_back_top', 'icon_contact_aim', 'icon_contact_email', 'icon_contact_icq', 'icon_contact_jabber', 'icon_contact_msnm', 'icon_contact_pm', 'icon_contact_yahoo', 'icon_contact_www', 'icon_post_delete', 'icon_post_edit', 'icon_post_info', 'icon_post_quote', 'icon_post_report', 'icon_user_online', 'icon_user_offline', 'icon_user_profile', 'icon_user_search', 'icon_user_warn', 'button_pm_forward', 'button_pm_new', 'button_pm_reply', 'button_topic_locked', 'button_topic_new', 'button_topic_reply'), 'icons' => array('icon_post_target', 'icon_post_target_unread', 'icon_topic_attach', 'icon_topic_latest', 'icon_topic_newest', 'icon_topic_reported', 'icon_topic_unapproved', 'icon_friend', 'icon_foe'), 'forums' => array('forum_link', 'forum_read', 'forum_read_locked', 'forum_read_subforum', 'forum_unread', 'forum_unread_locked', 'forum_unread_subforum', 'subforum_read', 'subforum_unread'), 'folders' => array('topic_moved', 'topic_read', 'topic_read_mine', 'topic_read_hot', 'topic_read_hot_mine', 'topic_read_locked', 'topic_read_locked_mine', 'topic_unread', 'topic_unread_mine', 'topic_unread_hot', 'topic_unread_hot_mine', 'topic_unread_locked', 'topic_unread_locked_mine', 'sticky_read', 'sticky_read_mine', 'sticky_read_locked', 'sticky_read_locked_mine', 'sticky_unread', 'sticky_unread_mine', 'sticky_unread_locked', 'sticky_unread_locked_mine', 'announce_read', 'announce_read_mine', 'announce_read_locked', 'announce_read_locked_mine', 'announce_unread', 'announce_unread_mine', 'announce_unread_locked', 'announce_unread_locked_mine', 'global_read', 'global_read_mine', 'global_read_locked', 'global_read_locked_mine', 'global_unread', 'global_unread_mine', 'global_unread_locked', 'global_unread_locked_mine', 'pm_read', 'pm_unread'), 'polls' => array('poll_left', 'poll_center', 'poll_right'), 'ui' => array('upload_bar'), 'user' => array('user_icon1', 'user_icon2', 'user_icon3', 'user_icon4', 'user_icon5', 'user_icon6', 'user_icon7', 'user_icon8', 'user_icon9', 'user_icon10'));
// Define references.
$error = array();
$style_id = 0;
$style_row = array('install_name' => $stylecfg['name'], 'install_copyright' => $stylecfg['copyright'], 'template_id' => 0, 'template_name' => $stylecfg['name'], 'template_copyright' => $stylecfg['copyright'], 'theme_id' => 0, 'theme_name' => $stylecfg['name'], 'theme_copyright' => $stylecfg['copyright'], 'imageset_id' => 0, 'imageset_name' => $stylecfg['name'], 'imageset_copyright' => $stylecfg['copyright'], 'store_db' => 0, 'style_active' => 1, 'style_default' => 0);
// Install the style.
// (&$error, $action, $root_path, &$id, $name, $path, $copyright, $active, $default, &$style_row, $template_root_path = false, $template_path = false, $theme_root_path = false, $theme_path = false, $imageset_root_path = false, $imageset_path = false)
if (!$styles->install_style($error, 'install', $style_root, $style_id, $stylecfg['name'], $contrib->contrib_id, $stylecfg['copyright'], true, false, $style_row)) {
if ($error != array(phpbb::$user->lang['STYLE_ERR_NAME_EXIST'])) {
$this->error = array_merge($this->error, $error);
} else {
$sql = 'SELECT style_id
FROM ' . STYLES_TABLE . "\n\t\t\t\t\tWHERE style_name = '" . $db->sql_escape(basename($stylecfg['name'])) . "'";
$db->sql_query($sql);
$style_id = $db->sql_fetchfield('style_id');
$db->sql_freeresult();
}
}
// Have UMIL refresh the template, theme, imageset
phpbb::_include('../umil/umil', false, 'umil');
$umil = new umil(true, $db);
$umil->cache_purge('template', $style_id);
$umil->cache_purge('theme', $style_id);
$umil->cache_purge('imageset', $style_id);
foreach ($variables as $variable) {
$GLOBALS[$variable] = ${'_' . $variable};
}
return $style_id;
}
/**
* Private function strings have to pass before entering the database.
* Ensures string length et cetera.
*
* @param string $value The string we want to validate
* @param array $config The configuration array we're validating against
*
* @return string The validated string
*/
private function validate_string($value, $config)
{
if (empty($value)) {
return '';
}
// Check if multibyte characters are disallowed
if (isset($config['multibyte']) && $config['multibyte'] === false) {
// No multibyte, only allow ASCII (0-127)
$value = preg_replace('/[\\x80-\\xFF]/', '', $value);
} else {
// Make sure multibyte characters are wellformed
if (!preg_match('/^./u', $value)) {
return '';
}
}
// Truncate to the maximum length
if (isset($config['max']) && $config['max']) {
phpbb::_include('functions_content', 'truncate_string');
truncate_string($value, $config['max']);
}
return $value;
}
function main($id, $mode)
{
global $phpbb_root_path;
define('PHPBB_INCLUDED', true);
define('USE_PHPBB_TEMPLATE', true);
define('IN_TITANIA', true);
if (!defined('PHP_EXT')) {
define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
}
require TITANIA_ROOT . 'common.' . PHP_EXT;
// Need a few hacks to be used from within phpBB
titania_url::decode_url(titania::$config->phpbb_script_path);
titania::$hook->register(array('titania_url', 'build_url'), 'titania_outside_build_url', 'standalone');
titania::$hook->register(array('titania_url', 'append_url'), 'titania_outside_build_url', 'standalone');
titania::$hook->register(array('titania', 'page_header'), 'titania_outside_page_header', 'standalone');
titania::$hook->register(array('titania', 'page_footer'), 'titania_outside_page_footer', 'standalone');
$this->p_master->assign_tpl_vars(phpbb::append_sid('ucp'));
// Include some files
titania::_include('functions_display', 'titania_topic_folder_img');
// Setup the sort tool
$sort = new titania_sort();
$sort->default_limit = phpbb::$config['topics_per_page'];
$sort->request();
// Start initial var setup
$url = $this->u_action;
add_form_key('ucp_front_subscription');
// User wants to unsubscribe?
if (isset($_POST['unsubscribe'])) {
if (check_form_key('ucp_front_subscription')) {
$sections = request_var('sections', array(0 => array(0 => 0)));
$items = request_var('items', array(0 => array(0 => 0)));
$subscriptions = $sections + $items;
if (sizeof($subscriptions)) {
foreach ($subscriptions as $type => $type_id) {
$object_ids = array_keys($type_id);
foreach ($object_ids as $object_id) {
$sql = 'DELETE FROM ' . TITANIA_WATCH_TABLE . '
WHERE watch_user_id = ' . phpbb::$user->data['user_id'] . '
AND watch_object_type = ' . $type . '
AND watch_object_id = ' . $object_id;
phpbb::$db->sql_query($sql);
}
}
} else {
$msg = phpbb::$user->lang['NO_SUBSCRIPTIONS_SELECTED'];
}
} else {
$msg = phpbb::$user->lang['FORM_INVALID'];
}
if (isset($msg)) {
meta_refresh(3, $url);
$message = $msg . '<br /><br />' . sprintf(phpbb::$user->lang['RETURN_UCP'], '<a href="' . $url . '">', '</a>');
trigger_error($message);
}
}
switch ($mode) {
case 'subscription_items':
$array_items = array(TITANIA_CONTRIB, TITANIA_TOPIC);
// We prepare pagination stuff
$sql = 'SELECT COUNT(*) AS subscription_count
FROM ' . TITANIA_WATCH_TABLE . '
WHERE ' . phpbb::$db->sql_in_set('watch_object_type', $array_items) . '
AND watch_user_id = ' . phpbb::$user->data['user_id'];
phpbb::$db->sql_query($sql);
$subscription_count = phpbb::$db->sql_fetchfield('subscription_count');
phpbb::$db->sql_freeresult();
$sort->total = $subscription_count;
$sort->build_pagination($url);
$sql_ary = array('SELECT' => '*,
CASE w.watch_object_type
WHEN ' . TITANIA_CONTRIB . ' THEN c.contrib_last_update
WHEN ' . TITANIA_TOPIC . ' THEN t.topic_last_post_time
END AS time', 'FROM' => array(TITANIA_WATCH_TABLE => 'w'), 'LEFT_JOIN' => array(array('FROM' => array(TITANIA_CONTRIBS_TABLE => 'c'), 'ON' => '(w.watch_object_type = ' . TITANIA_CONTRIB . ')
AND c.contrib_id = w.watch_object_id'), array('FROM' => array(TITANIA_TOPICS_TABLE => 't'), 'ON' => 'w.watch_object_type = ' . TITANIA_TOPIC . '
AND t.topic_id = w.watch_object_id')), 'WHERE' => 'w.watch_user_id = ' . phpbb::$user->data['user_id'] . '
AND ' . phpbb::$db->sql_in_set('watch_object_type', $array_items), 'ORDER_BY' => 'time DESC');
// Additional tracking for support topics
titania_tracking::get_track_sql($sql_ary, TITANIA_TOPIC, 't.topic_id');
titania_tracking::get_track_sql($sql_ary, TITANIA_SUPPORT, 0, 'tsa');
titania_tracking::get_track_sql($sql_ary, TITANIA_SUPPORT, 't.parent_id', 'tsc');
titania_tracking::get_track_sql($sql_ary, TITANIA_QUEUE_DISCUSSION, 0, 'tqt');
// Tracking for contributions
titania_tracking::get_track_sql($sql_ary, TITANIA_CONTRIB, 'c.contrib_id', 'tc');
$sql = phpbb::$db->sql_build_query('SELECT', $sql_ary);
// Get the data
$result = phpbb::$db->sql_query_limit($sql, $sort->limit, $sort->start);
$user_ids = $rows = array();
while ($row = phpbb::$db->sql_fetchrow($result)) {
$rows[] = $row;
titania_tracking::store_from_db($row);
if ($row['watch_object_type'] == TITANIA_TOPIC) {
$user_ids[] = $row['topic_first_post_user_id'];
$user_ids[] = $row['topic_last_post_user_id'];
} else {
if ($row['watch_object_type'] == TITANIA_CONTRIB) {
$user_ids[] = $row['contrib_user_id'];
}
}
}
phpbb::$db->sql_freeresult($result);
// Get user data
users_overlord::load_users($user_ids);
foreach ($rows as $row) {
$folder_img = $folder_alt = '';
if ($row['watch_object_type'] == TITANIA_TOPIC) {
if (!$row['topic_id']) {
// Topic was deleted
$sql = 'DELETE FROM ' . TITANIA_WATCH_TABLE . '
WHERE watch_object_type = ' . (int) $row['watch_object_type'] . '
AND watch_object_id = ' . (int) $row['watch_object_id'];
phpbb::$db->sql_query($sql);
continue;
}
$topic = new titania_topic();
$topic->__set_array($row);
$topic->additional_unread_fields[] = array('type' => TITANIA_SUPPORT, 'id' => 0);
$topic->additional_unread_fields[] = array('type' => TITANIA_SUPPORT, 'parent_match' => true);
$topic->additional_unread_fields[] = array('type' => TITANIA_QUEUE_DISCUSSION, 'id' => 0, 'type_match' => true);
$tpl_block = 'items';
$subscription_target = '';
if ($row['topic_type'] == TITANIA_QUEUE_DISCUSSION) {
$subscription_target = phpbb::$user->lang['SUBSCRIPTION_QUEUE_VALIDATION'];
}
if ($row['topic_type'] == TITANIA_QUEUE) {
$subscription_target = phpbb::$user->lang['SUBSCRIPTION_QUEUE'];
}
if ($row['topic_type'] == TITANIA_SUPPORT) {
$subscription_target = phpbb::$user->lang['SUBSCRIPTION_SUPPORT_TOPIC'];
}
// Tracking check
$last_read_mark = titania_tracking::get_track(TITANIA_TOPIC, $topic->topic_id, true);
$last_read_mark = max($last_read_mark, titania_tracking::find_last_read_mark($topic->additional_unread_fields, $topic->topic_type, $topic->parent_id));
$topic->unread = $topic->topic_last_post_time > $last_read_mark ? true : false;
// Get the folder image
$topic->topic_folder_img($folder_img, $folder_alt);
$vars = array('LAST_POST_IMG' => phpbb::$user->img('icon_topic_latest', 'VIEW_LATEST_POST'), 'SUBSCRIPTION_AUTHOR_FULL' => users_overlord::get_user($row['topic_first_post_user_id'], '_full'), 'SUBSCRIPTION_ID' => $row['topic_id'], 'SUBSCRIPTION_LAST_AUTHOR_FULL' => users_overlord::get_user($row['topic_last_post_user_id'], '_full'), 'SUBSCRIPTION_LAST_TIME' => phpbb::$user->format_date($row['topic_last_post_time']), 'SUBSCRIPTION_TIME' => phpbb::$user->format_date($row['topic_time']), 'SUBSCRIPTION_TARGET' => $subscription_target, 'SUBSCRIPTION_TITLE' => censor_text($row['topic_subject']), 'SUBSCRIPTION_TYPE' => $row['watch_object_type'], 'U_VIEW_SUBSCRIPTION' => $topic->get_url(), 'U_VIEW_LAST_POST' => titania_url::append_url($topic->get_url(), array('p' => $topic->topic_last_post_id, '#p' => $topic->topic_last_post_id)), 'S_ACCESS_TEAMS' => $row['topic_access'] == TITANIA_ACCESS_TEAMS || $row['topic_type'] == TITANIA_QUEUE ? true : false, 'S_ACCESS_AUTHORS' => $row['topic_access'] == TITANIA_ACCESS_AUTHORS ? true : false, 'S_TOPIC' => true);
} else {
if ($row['watch_object_type'] == TITANIA_CONTRIB) {
$tpl_block = 'items';
$contrib = new titania_contribution();
$contrib->__set_array($row);
titania_topic_folder_img($folder_img, $folder_alt, 0, titania_tracking::is_unread(TITANIA_CONTRIB, $contrib->contrib_id, $contrib->contrib_last_update));
$vars = array('SUBSCRIPTION_AUTHOR_FULL' => users_overlord::get_user($row['contrib_user_id'], '_full'), 'SUBSCRIPTION_CONTRIB_TYPE' => titania_types::$types[$contrib->contrib_type]->lang, 'SUBSCRIPTION_DOWNLOADS' => $row['contrib_downloads'], 'SUBSCRIPTION_ID' => $row['contrib_id'], 'SUBSCRIPTION_TARGET' => phpbb::$user->lang['SUBSCRIPTION_CONTRIB'], 'SUBSCRIPTION_TIME' => phpbb::$user->format_date($row['contrib_last_update']), 'SUBSCRIPTION_TITLE' => $row['contrib_name'], 'SUBSCRIPTION_TYPE' => $row['watch_object_type'], 'SUBSCRIPTION_VIEWS' => $row['contrib_views'], 'U_VIEW_SUBSCRIPTION' => $contrib->get_url(), 'S_CONTRIB' => true);
}
}
phpbb::$template->assign_block_vars($tpl_block, array_merge($vars, array('FOLDER_IMG' => phpbb::$user->img($folder_img, $folder_alt), 'FOLDER_IMG_SRC' => phpbb::$user->img($folder_img, $folder_alt, false, '', 'src'), 'FOLDER_IMG_ALT' => phpbb::$user->lang[$folder_alt], 'FOLDER_IMG_WIDTH' => phpbb::$user->img($folder_img, '', false, '', 'width'), 'FOLDER_IMG_HEIGHT' => phpbb::$user->img($folder_img, '', false, '', 'height'))));
}
break;
case 'subscription_sections':
$array_items = array(TITANIA_SUPPORT, TITANIA_QUEUE, TITANIA_ATTENTION);
// We prepare pagination stuff
$sql = 'SELECT COUNT(*) AS subscription_count
FROM ' . TITANIA_WATCH_TABLE . '
WHERE ' . phpbb::$db->sql_in_set('watch_object_type', $array_items) . '
AND watch_user_id = ' . phpbb::$user->data['user_id'];
phpbb::$db->sql_query($sql);
$subscription_count = phpbb::$db->sql_fetchfield('subscription_count');
phpbb::$db->sql_freeresult();
$sort->total = $subscription_count;
$sort->build_pagination($url);
$sql_ary = array('SELECT' => '*,
CASE w.watch_object_type
WHEN ' . TITANIA_SUPPORT . ' THEN c.contrib_last_update
END AS time', 'FROM' => array(TITANIA_WATCH_TABLE => 'w'), 'LEFT_JOIN' => array(array('FROM' => array(TITANIA_CONTRIBS_TABLE => 'c'), 'ON' => '(w.watch_object_type = ' . TITANIA_SUPPORT . ')
AND c.contrib_id = w.watch_object_id')), 'WHERE' => 'w.watch_user_id = ' . phpbb::$user->data['user_id'] . '
AND ' . phpbb::$db->sql_in_set('watch_object_type', $array_items), 'ORDER_BY' => 'time DESC');
$sql = phpbb::$db->sql_build_query('SELECT', $sql_ary);
// Get the data
$result = phpbb::$db->sql_query_limit($sql, $sort->limit, $sort->start);
$user_ids = array();
while ($row = phpbb::$db->sql_fetchrow($result)) {
$rows[] = $row;
$user_ids[] = $row['contrib_user_id'];
}
phpbb::$db->sql_freeresult($result);
// Get user data
users_overlord::load_users($user_ids);
if (isset($rows)) {
foreach ($rows as $row) {
if ($row['watch_object_type'] == TITANIA_SUPPORT) {
$tpl_block = 'sections';
$contrib = new titania_contribution();
$contrib->__set_array($row);
$vars = array('SUBSCRIPTION_AUTHOR_FULL' => users_overlord::get_user($row['contrib_user_id'], '_full'), 'SUBSCRIPTION_ID' => $row['watch_object_id'], 'SUBSCRIPTION_TARGET' => phpbb::$user->lang['SUBSCRIPTION_SUPPORT'], 'SUBSCRIPTION_TIME' => phpbb::$user->format_date($row['contrib_last_update']), 'SUBSCRIPTION_TITLE' => $row['contrib_name'], 'SUBSCRIPTION_TYPE' => $row['watch_object_type'], 'U_VIEW_SUBSCRIPTION' => $contrib->get_url('support'));
} else {
if ($row['watch_object_type'] == TITANIA_ATTENTION) {
$tpl_block = 'sections';
$vars = array('SUBSCRIPTION_ID' => $row['watch_object_id'], 'SUBSCRIPTION_TIME' => phpbb::$user->format_date($row['watch_mark_time']), 'SUBSCRIPTION_TITLE' => phpbb::$user->lang['SUBSCRIPTION_ATTENTION'], 'SUBSCRIPTION_TYPE' => $row['watch_object_type'], 'S_ATTENTION' => true, 'S_ACCESS_TEAMS' => true, 'U_VIEW_SUBSCRIPTION' => titania_url::build_url('manage/attention'));
} else {
if ($row['watch_object_type'] == TITANIA_QUEUE) {
$tpl_block = 'sections';
$queue_id = $row['watch_object_id'];
// Setup the base url we will use
$base_url = titania_url::build_url('manage/queue');
$vars = array('SUBSCRIPTION_ID' => $queue_id, 'SUBSCRIPTION_TARGET' => titania_types::$types[$queue_id]->lang, 'SUBSCRIPTION_TIME' => phpbb::$user->format_date($row['watch_mark_time']), 'SUBSCRIPTION_TITLE' => phpbb::$user->lang['SUBSCRIPTION_QUEUE'], 'SUBSCRIPTION_TYPE' => $row['watch_object_type'], 'S_QUEUE' => true, 'S_ACCESS_TEAMS' => true, 'U_VIEW_SUBSCRIPTION' => titania_url::append_url($base_url, array('queue' => titania_types::$types[$queue_id]->url)));
}
}
}
phpbb::$template->assign_block_vars($tpl_block, $vars);
}
}
break;
}
phpbb::$template->assign_vars(array('S_ACTION' => $url, 'TITANIA_THEME_PATH' => titania::$absolute_path . 'styles/' . titania::$config->style . '/theme/'));
titania::page_header(phpbb::$user->lang['SUBSCRIPTION_TITANIA']);
titania::page_footer(true, 'manage/' . $mode . '.html');
}
phpbb::update_user_postcount($post->post_user_id);
}
$post->submit();
// Load z topic
$post->topic->topic_id = $post->topic_id;
$post->topic->load();
// Update first/last post?
if ($post->topic->topic_first_post_time > $post->post_time) {
$post->topic->sync_first_post();
}
if ($post->topic->topic_last_post_time < $post->post_time) {
$post->topic->sync_last_post();
}
// Subscriptions?
if ($post->topic->topic_last_post_id == $post->post_id) {
phpbb::_include('functions_messenger', false, 'messenger');
$email_vars = array('NAME' => $post->topic->topic_subject, 'U_VIEW' => titania_url::append_url($post->topic->get_url(), array('view' => 'unread', '#' => 'unread')));
titania_subscriptions::send_notifications(TITANIA_TOPIC, $post->topic_id, 'subscribe_notify.txt', $email_vars, $post->post_user_id);
}
$sql = 'SELECT COUNT(post_id) AS cnt FROM ' . TITANIA_POSTS_TABLE . '
WHERE topic_id = ' . $post->topic_id . '
AND post_approved = 0';
phpbb::$db->sql_query($sql);
$cnt = phpbb::$db->sql_fetchfield('cnt');
if (!$cnt) {
$sql = 'UPDATE ' . TITANIA_TOPICS_TABLE . '
SET topic_approved = 1
WHERE topic_id = ' . $post->topic_id;
phpbb::$db->sql_query($sql);
// Subscriptions
if ($post->topic->topic_last_post_id == $post->post_id) {
