/**
* Updates the forum favorite database. It calls count_forum_favorites to get the group by count,
* and then stores the result in another table for easy access later.
* Run after updating a users favorites
* Takes one argument, the categories to refresh, if nothing is passed, refreshes everything.
*/
function refresh_forum_favorites($catid)
{
global $db;
$favfunct = new favorite_functions();
if (!$catid) {
$categories = $favfunct->get_favorites_categories(1);
foreach ($categories as $cat) {
$favfunct->refresh_forum_favorites($cat['category_id']);
}
return;
}
$catid = intval($catid);
$data = $favfunct->count_forum_favorites(array('category_id' => $catid));
$i = 1;
foreach ($data as $item) {
$where_fields = array('type' => 0, 'category_id' => $catid, 'listitem_id' => $i);
$sql_ary = array('listitem_text' => $item['listitem_text'], 'listitem_url' => $item['listitem_url'] ? $item['listitem_url'] : '', 'listitem_count' => $item['listitem_count']);
$i++;
$favfunct->update_insert(FAVORITES_SPECIAL_TABLE, $sql_ary, $where_fields);
}
//Delete any leftover old values from table
$sql = 'DELETE FROM ' . FAVORITES_SPECIAL_TABLE . " WHERE\n\t\ttype = 0 AND category_id = {$catid} AND listitem_id >= {$i}";
//catid intval'd earlier so safe here
$db->sql_query($sql);
}
function main($id, $mode)
{
global $config, $db, $user, $auth, $template, $phpbb_root_path, $phpEx;
$favfunct = new favorite_functions();
$preview = isset($_POST['preview']) ? true : false;
$submit = isset($_POST['submit']) ? true : false;
$error = $data = array();
$s_hidden_fields = '';
$uid = $user->data['user_id'];
switch ($mode) {
case 'edit':
$favorites_listitems = $favorites_listitem_text = array();
//get the favorites list for this user
$favorites_listitems = $favfunct->get_user_favorites((int) $user->data['user_id']);
$box_text = array();
//setup how the boxes will be displayed. if there's a URL then show it
foreach ($favorites_listitems as $catid => $cat) {
$temp_ary = array();
foreach ($cat as $row) {
$temp_ary[] = $row['listitem_url'] ? implode(", ", $row) : $row['listitem_text'];
}
$box_text[$catid] = $temp_ary ? implode("\n", $temp_ary) : ' ';
}
unset($favorites_listitems);
//pull category names from database here
//store them in $favorites_categories
$favorites_categories = $favfunct->get_favorites_categories();
foreach ($favorites_categories as $cat) {
$text_to_show = "";
if (isset($box_text[$cat['category_id']])) {
$text_to_show = $box_text[$cat['category_id']] ? $box_text[$cat['category_id']] : "";
}
$data[] = array('favorites_box' => utf8_normalize_nfc(request_var('favorites_box_' . $cat['category_id'], $text_to_show, true)), 'category_name' => utf8_normalize_nfc($cat['category_name']), 'category_id' => (int) $cat['category_id']);
}
if ($submit) {
//get the text from the box, and split it up into a two dimensional array
//first is row/item number, second has [0]=text, [1]=url (optional)
foreach ($data as $cat) {
$favorites_listitems = $unique_check = array();
//Set to blank if doesn't exist
if (!array_key_exists($cat['category_id'], $box_text)) {
$box_text[$cat['category_id']] = '';
}
//Don't bother if nothing changed
if (strcmp($cat['favorites_box'], $box_text[$cat['category_id']]) == 0) {
continue;
}
//Check for duplicate entries and compile the new list
if ($cat['favorites_box']) {
$favoriteslist = explode("\n", trim($cat['favorites_box']));
foreach ($favoriteslist as $line) {
$linearray = explode(",", trim($line));
array_walk($linearray, 'trim_value');
if (!isset($unique_check[strtoupper($linearray[0])])) {
$unique_check[strtoupper($linearray[0])] = true;
$favorites_listitems[] = array($linearray[0], isset($linearray[1]) ? $linearray[1] : '');
} else {
$error[] = sprintf($user->lang['FAVORITES_DUP_DELETE_ERROR'], $linearray[0]);
}
}
}
$i = 1;
foreach ($favorites_listitems as $item) {
$where_fields = array('user_id' => $uid, 'category_id' => $cat['category_id'], 'listitem_id' => $i);
$sql_ary = array('listitem_text' => $item[0], 'listitem_url' => $item[1] ? $item[1] : '');
$i++;
$favfunct->update_insert(FAVORITES_USER_TABLE, $sql_ary, $where_fields);
}
$sql = 'DELETE FROM ' . FAVORITES_USER_TABLE . ' WHERE
user_id = ' . intval($uid) . ' AND category_id = ' . intval($cat['category_id']) . " AND listitem_id >= {$i}";
$db->sql_query($sql);
$favfunct->refresh_forum_favorites($cat['category_id']);
unset($i);
}
//display confirmation message to the user
$message = $user->lang['FAVORITES_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $this->u_action . '">', '</a>');
//if there are errors, display them and don't auto-redirect
if (sizeof($error) == 0) {
meta_refresh(3, $this->u_action);
trigger_error($message);
} else {
trigger_error(implode('<br />', $error) . '<br /><br />' . $message);
}
}
$template->assign_vars(array('ERROR' => sizeof($error) ? implode('<br />', $error) : ''));
foreach ($data as $cat) {
$template->assign_block_vars('favorites_boxes', array('ID' => 'favorites_box_' . $cat['category_id'], 'FAVORITES_BOX' => $cat['favorites_box'], 'L_CATEGORY_NAME' => $user->lang['FAVORITES_CAT_PREFIX'] . $cat['category_name']));
}
break;
case 'view_list':
//Add the image graphics
$template->assign_vars(array('IMG_ADD_BUTTON' => $user->img('icon_ffavorites_add', '', '', '', 'src'), 'IMG_SEARCH_BUTTON' => $user->img('icon_ffavorites_search', '', '', '', 'src')));
//pull category names from database here
//store them in order in $favorites_categories
$favorites_categories = $favfunct->get_favorites_categories();
//Check to make sure categories have been set
if (sizeof($favorites_categories) == 0) {
// //If no categories, display an error message.
$template->assign_vars(array('MESSAGE' => $user->lang['FAVORITES_NOCATS_ERROR'], 'ERROR' => 1));
break;
}
//get the category to view
$catid = request_var('catid', 0);
//If none is set, use the first active one
if ($catid == 0) {
$catid = $favorites_categories[0]['category_id'];
}
//Load all the categories to the template variable, and figure out the name of the current one
foreach ($favorites_categories as $cat) {
$template->assign_block_vars('categories', array('NAME' => $cat['category_name'], 'ID' => $cat['category_id']));
if ($cat['category_id'] == $catid) {
$template->assign_vars(array('CURRENT_CAT_NAME' => $cat['category_name']));
}
}
$button_before = $button_after = $button_col = false;
$button_pos = $config['favorites_add_button_pos'];
switch ($button_pos) {
case 1:
default:
$button_before = true;
break;
case 2:
$button_after = true;
break;
case 3:
$button_col = true;
break;
}
$template->assign_vars(array('CURRENT_CAT' => $catid, 'S_BUTTON_BEFORE' => $button_before, 'S_BUTTON_AFTER' => $button_after, 'S_BUTTON_COL' => $button_col));
$message = '';
//Add favorite item to user's list if requested
$add_item = request_var('add_item', 'null');
if ($add_item != 'null') {
$add_text = utf8_normalize_nfc(request_var('text', '', true));
$add_url = utf8_normalize_nfc(request_var('url', '', true));
$result = $favfunct->add_favorite_user(array('user_id' => $uid, 'category_id' => $catid, 'listitem_text' => $add_text, 'listitem_url' => $add_url));
switch ((int) $result) {
case FAVORITES_SUCCESS:
$message = sprintf($user->lang['FAVORITES_ADD_SUCCESS'], $add_text);
break;
case FAVORITES_ERR_INVALID_UID:
$message = $user->lang['FAVORITES_UID_ERROR'];
break;
case FAVORITES_ERR_INVALID_CATID:
$message = $user->lang['FAVORITES_CATID_ERROR'];
break;
case FAVORITES_ERR_INVALID_TEXT:
$message = $user->lang['FAVORITES_TEXT_ERROR'];
break;
case FAVORITES_ERR_ITEM_EXISTS:
$message = $user->lang['FAVORITES_DUP_ITEM_ERROR'];
break;
default:
$message = $user->lang['FAVORITES_GENERIC_ERROR'];
break;
}
$template->assign_vars(array('MESSAGE' => $message));
}
//Display list of users with selected favorite if requested
$view_users = request_var('view_users', 'null');
if ($view_users != 'null') {
if ($message) {
$message .= '<br /><br />';
}
$text = utf8_normalize_nfc(request_var('text', '', true));
if (!$text) {
$message .= $user->lang['FAVORITES_TEXT_ERROR'];
} else {
$result = $favfunct->get_favorite_users(array('category_id' => $catid, 'listitem_text' => $text));
$message .= sprintf($user->lang['FAVORITES_SEARCH_RESULTS'], sizeof($result), $text) . '<br /><br />';
foreach ($result as $row) {
$message .= '<a href="' . append_sid("{$phpbb_root_path}memberlist.{$phpEx}?mode=viewprofile&u=" . intval($row['user_id'])) . '">' . $row['username'] . '</a>, ';
}
$message = substr($message, 0, -2);
}
$template->assign_vars(array('MESSAGE' => $message));
}
//Get list of forum favorites from the database
$fav_list_ary = $favfunct->get_forum_favorites($catid);
for ($i = 0, $size = sizeof($fav_list_ary); $i < $size; $i++) {
$template->assign_block_vars('fav_list', array('COUNT' => $fav_list_ary[$i]['listitem_count'], 'TEXT' => $fav_list_ary[$i]['listitem_text'], 'URL' => $fav_list_ary[$i]['listitem_url']));
}
break;
}
$template->assign_vars(array('L_TITLE' => $user->lang['UCP_FAVORITES_' . strtoupper($mode)], 'S_HIDDEN_FIELDS' => $s_hidden_fields, 'S_UCP_ACTION' => $this->u_action));
// Set desired template
$this->tpl_name = 'ucp_favorites_' . $mode;
$this->page_title = 'UCP_FAVORITES_' . strtoupper($mode);
}