function au_blog_url($input = '', $header = false)
{
// Global the big $aulis
global $aulis, $setting;
// The input needs to be an array otherwise we will redirect to the blogindex
if (!(is_array($input) and $input != '')) {
return au_url($setting["enable_blog_url_rewriting"] == "1" ? 'blog' : '?', $header);
}
// If we are an array, we have to have the app value
if (!array_key_exists("app", $input)) {
return au_url($setting["enable_blog_url_rewriting"] == "1" ? 'blog' : '?', $header);
}
// Is blog rewriting enabled?
if ($setting["enable_blog_url_rewriting"] == "1") {
// entries/number/entry-name
if ($input['app'] == "blogentry") {
return au_url("entries/" . au_encrypt_blog_id($input['id']) . "/" . strtolower(str_replace(array(" ", "?", "!", "&"), array("-", "", "", ""), $input['title'])), $header);
} else {
if ($input['app'] == "blogindex" && array_key_exists('offset', $input)) {
if (array_key_exists('search', $input)) {
return au_url('blog/search/' . $input['search'] . '/offset/' . $input['offset'], $header);
} else {
if (array_key_exists('category', $input) && array_key_exists('category_name', $input)) {
return au_url('blog/category/' . $input['category'] . '/offset/' . $input['offset'] . '/' . au_string_clean($input['category_name'], '-'), $header);
} else {
return au_url('blog/offset/' . $input['offset'], $header);
}
}
} elseif ($input['app'] == 'blogindex' && array_key_exists('category', $input) && array_key_exists('category_name', $input)) {
return au_url('blog/category/' . $input['category'] . '/' . au_string_clean($input['category_name'], '-'), $header);
} elseif ($input['app'] == 'blogindex' && array_key_exists('search', $input)) {
return au_url('blog/search/' . au_string_clean($input['search']), $header);
} else {
if ($input['app'] == 'blogindex' && count($input) == 1) {
return au_url('blog', $header);
} else {
return au_url("?" . http_build_query($input), $header);
}
}
}
}
// Otherwise just a normal url
return au_url("?" . http_build_query($input), $header);
}
function au_show_blogindex()
{
// $aulis might come in handy here
global $aulis, $setting;
// Did our lovely user specify an offset?
if (isset($_GET['offset']) && is_numeric($_GET['offset'])) {
$offset = $_GET['offset'];
} else {
$offset = 0;
}
// Extra parameters, in case we need them
$extra_parameters = '';
// Are we searching?
if (isset($_REQUEST['search']) && !isset($_REQUEST['category'], $_REQUEST['tag'])) {
// Empty searches are not allowed
if (trim($_REQUEST['search']) == '') {
au_blog_url('', true);
}
// Do we maybe need to clean a search string before redirecting?
if (isset($_POST['search']) && $_POST['search'] != '') {
// Do we need to clean it or is urlencode enough?
if ($setting['enable_blog_url_rewriting'] == 1) {
$search_string = au_string_clean($_POST['search']);
} else {
$search_string = urlencode($_POST['search']);
}
// The cleaned string cannot be empty
if ($search_string != '') {
// Redirect to clean url if possible
if ($setting['enable_blog_url_rewriting'] == 1) {
au_url('blog/search/' . $search_string, true);
} else {
au_url('?app=blogindex&search=' . $search_string, true);
}
}
// Nothing more here for us now
die;
}
// Do we maybe need to unclean the search string?
if (isset($_GET['search']) && isset($_GET['rewrite'])) {
$aulis['blog_search'] = str_replace("+", " ", $_GET['search']);
$aulis['blog_search'] = str_replace("-plus-", "+", $aulis['blog_search']);
} else {
if (isset($_GET['search'])) {
$aulis['blog_search'] = urldecode($_GET['search']);
} else {
$aulis['blog_search'] = '';
}
}
// Time to form the extra parameters
$exploded_search = explode(' ', $aulis['blog_search']);
foreach ($exploded_search as $keyword) {
$regex = "REGEXP '[[:<:]]" . au_db_escape($keyword) . "[[:>:]]'";
$extra_parameters .= " AND (entries.blog_name {$regex} OR entries.blog_intro {$regex} OR entries.blog_content {$regex})";
}
}
// Do we have to add parameters for category or tag to the query?
if (isset($_GET['category']) && is_numeric($_GET['category']) && !isset($_GET['search'], $_GET['tag']) && ($aulis['blog_category'] = $_GET['category'])) {
$extra_parameters .= ' AND ' . (isset($_GET['category']) ? "entries.blog_category = {$_GET['category']}" : '');
}
// Let's build the query
$query = "SELECT entries.*, COUNT(comments.comment_id) AS comment_count, categories.category_name AS category_name\n\tFROM blog_entries AS entries \n\tLEFT JOIN blog_comments AS comments ON entries.entry_id = comments.blog_id \n\tLEFT JOIN blog_categories AS categories ON entries.blog_category = categories.category_id \n\tWHERE entries.blog_activated = 1 and entries.blog_in_queue = 0 {$extra_parameters} GROUP BY entries.entry_id ORDER BY entries.blog_date DESC;";
// We are building the simple version of the query now, because that's enough to get info from
$query_simple_parameters = "entries.blog_activated = 1 and entries.blog_in_queue = 0 {$extra_parameters}";
// We are getting the maximum offset and the initial row count right now
$query_info = au_get_max_blog_offset($query_simple_parameters);
// We need to check if our offset is, like, alright, otherwise we need to redirect
if (!au_check_offset($offset, THEME_BLOG_ENTRIES_PER_PAGE, $query_info['max_offset'])) {
$_GET['offset'] = au_validate_offset($offset, THEME_BLOG_ENTRIES_PER_PAGE, $query_info['max_offset']);
au_blog_url($_GET, true);
}
// Let's load all blog entries that are activated and are not in the queue (thus are published)
$entries = au_parse_pagination($query, true, $offset, THEME_BLOG_ENTRIES_PER_PAGE, $query_info['row_count']);
// For each blog item, we want to show its preview
while ($entry = $entries['paged']->fetchObject()) {
au_show_blog_preview($entry);
}
// We might want to transfer the information about the pagination, so that it can be used in the template
$aulis['blog_count'] = $query_info['row_count'];
$aulis['blog_current_offset'] = $offset;
$aulis['blog_next_offset'] = $entries['next_position'];
$aulis['blog_previous_offset'] = $entries['previous_position'];
$aulis['blog_max_offset'] = $query_info['max_offset'];
// This will load the wrapper! :)
return au_load_template('blog_index');
}
