function fetch($user_id, $photoblog_preferences_default_values)
 {
     global $photoblog_preferences_default_values;
     $user_id = !empty($user_id) ? $user_id : $_SESSION['login']['id'];
     if (!is_numeric($user_id)) {
         throw new Exception('$user_id must be a numerical value');
     } elseif (!login_checklogin()) {
         throw new Exception('You must be logged in to load your photoblog preferences');
     }
     $photoblog_preferences_fetch_sql = 'SELECT * FROM photoblog_preferences WHERE userid = ' . $_SESSION['login']['id'] . ' LIMIT 1';
     $photoblog_preferences_fetch_result = mysql_query($photoblog_preferences_fetch_sql);
     if (mysql_num_rows($photoblog_preferences_fetch_result) == 0) {
         $sql = 'INSERT INTO photoblog_preferences SET';
         $photoblog_preferences_default_values_count = count($photoblog_preferences_default_values);
         $count = 0;
         foreach ($photoblog_preferences_default_values as $default_key => $default_val) {
             if (is_numeric($default_val)) {
                 $sql .= ' ' . $default_key . ' = ' . $default_val;
             } else {
                 $sql .= ' ' . $default_key . ' = "' . $default_val . '"';
             }
             $count++;
             if ($count != $photoblog_preferences_default_values_count) {
                 $sql .= ',';
             }
         }
         mysql_query($sql) or report_sql_error($sql, __FILE__, __LINE__);
         $photoblog_preferences_fetch_data = $photoblog_preferences_default_values;
     } else {
         $photoblog_preferences_fetch_data = mysql_fetch_assoc($photoblog_preferences_fetch_result);
     }
     return $photoblog_preferences_fetch_data;
 }

function profile_fetch($options)
{
    $options['viewer'] = isset($options['viewer']) ? $options['viewer'] : (login_checklogin() ? $_SESSION['login']['id'] : 0);
    //preint_r(array('viewer' => $options['viewer'], 'userblock_check' => userblock_check($options['user_id'], $options['viewer'])), 'Joel är en testare!');
    if ($options['viewer'] > 0 && userblock_check($options['user_id'], $options['viewer']) == 1) {
        $options['error_message'] = 'Användaren har blockerat dig.';
    } else {
        $query = 'SELECT l.username, l.lastaction, l.lastlogon, u.gender, u.birthday, u.image, u.user_status, u.profile_theme, u.gb_entries, z.spot, u.presentation_text, p.gb_anti_p12';
        $query .= ' FROM login AS l, userinfo AS u, zip_codes AS z, preferences AS p';
        $query .= ' WHERE l.id = "' . $options['user_id'] . '" AND u.userid = l.id AND z.zip_code = u.zip_code AND p.userid = l.id';
        if (!isset($options['show_removed_users']) || isset($options['show_removed_users']) && $options['show_removed_users'] == false) {
            $query .= ' AND l.username NOT LIKE "Borttagen"';
        }
        $query .= ' LIMIT 1';
        $result = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
        if (mysql_num_rows($result) > 0) {
            $data = mysql_fetch_assoc($result);
            if (strlen($data['presentation_text']) == 0) {
                $old_presentation_query = 'SELECT freetext AS presentation_text FROM traffa_freetext WHERE userid = "' . $options['user_id'] . '" LIMIT 1';
                $result = mysql_query($old_presentation_query) or report_sql_error($old_presentation_query);
                if (mysql_num_rows($old_presentation_result) > 0) {
                    $old_presentation = mysql_fetch_assoc($old_presentation_result);
                    $options['presentation_text'] = $old_presentation['presentation_text'];
                    profile_presentation_save($options);
                } else {
                    $options['presentation_text'] = 'Användaren har inte skapat någon presentation ännu.';
                }
            }
            $options = array_merge($options, $data);
        } else {
            $options['error_message'] = 'Den användaren hittade vi tyvärr inte.';
        }
    }
    return $options;
}

function photos_upload($options)
{
    if (!login_checklogin()) {
        return false;
    }
    $category = photos_get_categories(array('user' => $options['user'], 'name' => $options['category'], 'create_if_not_found' => true));
    $category = array_pop($category);
    $query = 'INSERT INTO user_photos (user, description, category, date)';
    $query .= ' VALUES("' . $options['user'] . '", "' . $options['description'] . '", "' . $category['id'] . '", "' . date('Y-m-d') . '")';
    mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    $id = mysql_insert_id();
    $folder = floor($id / 5000);
    $query = 'UPDATE user_photo_categories SET photo_count = photo_count + 1 WHERE id = "' . $category['id'] . '" LIMIT 1';
    mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    // Check if folders exists, otherwise, create it
    foreach (array('mini', 'thumb', 'full') as $format) {
        if (!is_dir(PHOTOS_PATH . $format . '/' . $folder)) {
            mkdir(PHOTOS_PATH . $format . '/' . $folder);
        }
    }
    $image_size = getimagesize($options['file']);
    $square = min($image_size[0], $image_size[1]);
    $width = round($square * 0.9);
    $height = $width / 4 * 3;
    $mini = 'convert ' . $options['file'] . ' -gravity center -crop ' . $width . 'x' . $height . '+0+0 -resize 50x38! ' . PHOTOS_PATH . 'mini/' . $folder . '/' . $id . '.jpg';
    $thumb = 'convert ' . $options['file'] . ' -gravity center -crop ' . $width . 'x' . $height . '+0+0 -resize 150x112! ' . PHOTOS_PATH . 'thumb/' . $folder . '/' . $id . '.jpg';
    $full = 'convert -resize "630x630>" ' . $options['file'] . ' ' . PHOTOS_PATH . 'full/' . $folder . '/' . $id . '.jpg';
    system($mini);
    system($thumb);
    system($full);
    return $id;
}

function digga_view_info($artist)
{
    $query = 'SELECT name, popularity FROM artists WHERE id = "' . $artist . '" LIMIT 1';
    $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    if (mysql_num_rows($result) != 1) {
        die('Artisten finns inte');
    }
    $data = mysql_fetch_assoc($result);
    $artist_name = $data['name'];
    echo '<h1>' . $artist_name . '</h1>';
    echo 'Uppskattas av ' . $data['popularity'] . ' hamsterpajare<br />' . "\n";
    if (login_checklogin()) {
        if ($artist_name == 'Kent') {
            treasure_item(27);
        }
        $query = 'SELECT user FROM user_artists WHERE user = "' . $_SESSION['login']['id'] . '" AND artist = "' . $artist . '" LIMIT 1';
        $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
        if (mysql_num_rows($result) == 1) {
            echo '<input type="button" class="button" value="Sluta digga!" onclick="window.location=\'?action=dislike&artist=' . $_GET['artist'] . '\';" />' . "\n";
        } else {
            echo '<input type="button" class="button" value="Börja digga!" onclick="window.location=\'?action=like&artist=' . $_GET['artist'] . '\';" />' . "\n";
        }
    }
    echo '<input type="button" value="Mer om ' . htmlentities($artist_name) . '" onclick="opener.window.location=\'digga.php?action=view_info&artist_id=' . $_GET['artist'] . '\'; window.close();" />' . "\n";
}

function movie_compability_form($movies, $options)
{
    rounded_corners_top(array('id' => 'movie_compability_review_list', 'color' => 'white'));
    echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post">' . "\n";
    if (isset($options['owner'])) {
        echo '<input type="hidden" name="owner" value="' . $options['owner'] . '" />' . "\n";
    }
    if (login_checklogin()) {
        $query = 'SELECT * FROM movie_tests WHERE owner = "' . $_SESSION['login']['id'] . '"';
        $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
        while ($data = mysql_fetch_assoc($result)) {
            $old_score[$data['movie_id']] = $data['score'];
        }
    }
    foreach ($movies as $movie_handle => $movie) {
        echo '<div class="movie">' . "\n";
        echo '<img src="' . IMAGE_URL . 'movie_compability/folders/' . $movie_handle . '.png" alt="' . $movie_handle . '" />' . "\n";
        echo '<div class="scoring">' . "\n";
        for ($i = 0; $i <= 5; $i++) {
            echo '<div>' . "\n";
            echo '<label for="movie_compability_' . $movie_handle . '_' . $i . '">' . $i . '</label>' . "\n";
            $checked = $old_score[$movie['id']] == $i && isset($old_score[$movie['id']]) ? ' checked="checked"' : '';
            echo '<input type="radio" name="movie_compability_' . $movie['id'] . '" value="' . $i . '" class="movie_compability_input_scroll" id="movie_compability_' . $movie_handle . '_' . $i . '"' . $checked . ' />' . "\n";
            echo '</div>' . "\n";
        }
        echo '<div class="movie_compability_vote_not_seen">' . "\n";
        echo '<input type="radio" name="movie_compability_' . $movie['id'] . '" value="not_seen" class="movie_compability_input_scroll" for="movie_compability_' . $movie_handle . '_not_seen" />' . "\n";
        echo '<label for="movie_compability_' . $movie_handle . '_not_seen">Ej sett</label>' . "\n";
        echo '</div>' . "\n";
        echo '<br style="clear: both;" />' . "\n";
        echo '</div>' . "\n";
        echo '<h3>' . $movie['title'] . '</h3>' . "\n";
        echo '<p>' . $movie['description'] . '</p>' . "\n";
        echo '</div>' . "\n";
    }
    rounded_corners_bottom(array('color' => 'white'));
    if (!login_checklogin()) {
        rounded_corners_top();
        echo '<h2>Fyll i ditt namn</h2>' . "\n";
        echo '<div class="first_name">' . "\n";
        echo '<h3>Förnamn</h3>' . "\n";
        echo '<input type="text" class="textbox" name="first_name" />' . "\n";
        echo '</div>' . "\n";
        echo '<div class="surname">' . "\n";
        echo '<h3>Efternamn</h3>' . "\n";
        echo '<input type="text" class="textbox" name="surname" />' . "\n";
        echo '</div>' . "\n";
        rounded_corners_bottom();
    }
    echo '<input type="submit" value="Skicka!" class="button" />' . "\n";
    echo '</form>' . "\n";
}

function rank_input_draw($item_id, $item_type, $options)
{
    $previous = isset($options['previous']) ? $options['previous'] : 0;
    $output = '';
    $output = '<div class="rank_input_container">' . "\n";
    $output .= '<div id="rank_input" class="rank_input"' . (login_checklogin() ? '' : ' onclick="javascript: tiny_reg_form_show();"') . '>' . "\n";
    for ($i = 0; $i <= 10; $i++) {
        $output .= '<div class="rank_input_part" id="rank_input_part_' . $i . '"></div>';
    }
    $output .= '<input type="hidden" id="rank_previous" value="' . $previous . '" />' . "\n";
    $output .= '<input type="hidden" id="rank_item_id" value="' . $item_id . '" />' . "\n";
    $output .= '<input type="hidden" id="rank_item_type" value="' . $item_type . '" />' . "\n";
    $output .= '</div>' . "\n";
    $output .= '<br style="clear: both;" /><div id="rank_input_message">Tack för din röst!</div>' . "\n";
    $output .= '</div>' . "\n";
    return $output;
}

function irl_update_attending($content)
{
    if (!is_numeric($_GET['irl'])) {
        throw new Exception('ID is not numeric');
    }
    if (!login_checklogin()) {
        throw new Exception('You must be loged in');
    }
    $query = 'SELECT user_id FROM irl_attendings WHERE user_id = ' . $_SESSION['login']['id'] . ' AND irl_id = ' . $_GET['irl'] . ' LIMIT 1';
    $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    if (mysql_num_rows($result) == 1) {
        $query = 'UPDATE irl_attendings SET attending = "' . $content['attending'] . '", has_beds = "' . $content['has_beds'] . '", needs_beds = "' . $content['needs_beds'] . '"';
        $query .= ' WHERE user_id = "' . $_SESSION['login']['id'] . '" AND irl_id = ' . $_GET['irl'] . ' LIMIT 1';
        mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    } else {
        $query = 'INSERT INTO irl_attendings (irl_id, user_id, attending, has_beds, needs_beds) ';
        $query .= 'VALUES(' . $_GET['irl'] . ', "' . $_SESSION['login']['id'] . '", "' . $content['attending'] . '", "' . $content['has_beds'] . '", "' . $content['needs_beds'] . '")';
        mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    }
}

function photos_upload($options)
{
    if (!login_checklogin()) {
        return false;
    }
    $category = photos_get_categories(array('user' => $options['user'], 'name' => $options['category'], 'create_if_not_found' => true));
    $category = array_pop($category);
    $query = 'INSERT INTO user_photos (user, description, category, date)';
    $query .= ' VALUES("' . $options['user'] . '", "' . $options['description'] . '", "' . $category['id'] . '", "' . date('Y-m-d') . '")';
    mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    $id = mysql_insert_id();
    $folder = floor($id / 5000);
    $query = 'UPDATE user_photo_categories SET photo_count = photo_count + 1 WHERE id = "' . $category['id'] . '" LIMIT 1';
    mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    // Check if folders exists, otherwise, create it
    foreach (array('mini', 'thumb', 'full') as $format) {
        if (!is_dir(PHOTOS_PATH . $format . '/' . $folder)) {
            mkdir(PHOTOS_PATH . $format . '/' . $folder);
        }
    }
    if (!($image_size = getimagesize($options['file']))) {
        throw new Exception('Är du säker på att det var en bild du laddade upp?');
    }
    $dimensions = array($image_size[0], $image_size[1]);
    foreach ($dimensions as $width_or_height) {
        if ($width_or_height > 4000) {
            throw new Exception('Whoa! Har du fotograferat en långtradare eller varför är bilden så stor?<br />Maxdimensionerna är 4000 x 4000 pixlar.');
        }
    }
    $square = min($image_size[0], $image_size[1]);
    $width = round($square * 0.9);
    $height = $width / 4 * 3;
    $mini = 'convert ' . $options['file'] . ' -gravity center -crop ' . $width . 'x' . $height . '+0+0 -resize 50x38! ' . PHOTOS_PATH . 'mini/' . $folder . '/' . $id . '.jpg';
    $thumb = 'convert ' . $options['file'] . ' -gravity center -crop ' . $width . 'x' . $height . '+0+0 -resize 150x112! ' . PHOTOS_PATH . 'thumb/' . $folder . '/' . $id . '.jpg';
    $full = 'convert -resize "630x630>" ' . $options['file'] . ' ' . PHOTOS_PATH . 'full/' . $folder . '/' . $id . '.jpg';
    system($mini);
    system($thumb);
    system($full);
    return $id;
}

function userblock_checkblock($object_id)
{
    // PREVENT SQL QUERY ERROR DUE TO MISSING OBJECT ID
    if (strlen($object_id) == 0) {
        return false;
    } elseif (!is_numeric($object_id)) {
        return false;
    } elseif (!login_checklogin()) {
        return false;
    }
    $sql = 'SELECT * FROM userblocks WHERE ownerid = ' . $object_id . ' AND blockedid = ' . $_SESSION['login']['id'] . ' LIMIT 1';
    $result = mysql_query($sql) or report_sql_error($sql, __FILE__, __LINE__);
    $data = mysql_fetch_assoc($result);
    if ($data['blockedid'] === $_SESSION['login']['id'] && !is_privilegied('igotgodmode') && !is_privilegied('ip_ban_admin')) {
        return true;
    } elseif ($data['blockedid'] === $_SESSION['login']['id'] && is_privilegied('igotgodmode') && !is_privilegied('ip_ban_admin')) {
        echo '<p class="error"><strong>Den h&auml;r anv&auml;ndaren har blockerat dig!</strong><br />' . "\n";
        echo 'Men eftersom du &auml;r 1337 h4xx0r s&aring; kan du se personens presentation i alla fall :)</p>' . "\n";
    } else {
        return false;
    }
}

function poll_fetch($options)
{
    $options['limit'] = is_numeric($options['limit']) ? $options['limit'] : 1;
    $query = 'SELECT poll.*';
    $query .= login_checklogin() ? ', poll_answers.answer_id' : '';
    $query .= ' FROM poll';
    $query .= login_checklogin() ? ' LEFT OUTER JOIN poll_answers ON poll.id = poll_answers.poll_id AND poll_answers.user_id = "' . $_SESSION['login']['id'] . '"' : '';
    $query .= ' WHERE 1';
    $query .= isset($options['id']) && is_numeric($options['id']) ? ' AND poll.id = "' . $options['id'] . '"' : '';
    $query .= isset($options['author']) ? ' AND poll.author = "' . $options['author'] . '"' : '';
    $query .= isset($options['handle']) ? ' AND poll.handle = "' . $options['handle'] . '"' : '';
    $query .= isset($options['type']) ? ' AND poll.type = "' . $options['type'] . '"' : '';
    $query .= ' ORDER BY poll.id DESC';
    $query .= ' LIMIT ' . $options['limit'];
    //if(!login_checklogin())
    if (false) {
        $poll = query_cache(array('query' => $query, 'type' => 'poll'));
    } else {
        $result = mysql_query($query) or report_sql_error($query);
        while ($data = mysql_fetch_assoc($result)) {
            $poll[] = $data;
        }
    }
    foreach ($poll as $id => $current) {
        if (login_checklogin()) {
            $poll[$id]['can_answer'] = $current['answer_id'] > 0 ? false : true;
        } elseif ($current['force_logon'] == 0) {
            if ($_COOKIE['poll_' . $current['id']] == true) {
                $poll[$id]['can_answer'] = false;
            } else {
                $poll[$id]['can_answer'] = true;
            }
        } else {
            $poll[$id]['can_answer'] = false;
        }
    }
    return $poll;
}

function comments_remove($id)
{
    $query = 'SELECT user_id, item_type, item_id FROM user_comments WHERE id = ' . $id . ' LIMIT 1';
    $result = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    if (mysql_num_rows($result) > 0) {
        $data = mysql_fetch_assoc($result);
        if ($data['item_type'] == 'photos') {
            $photos = photos_fetch(array('id' => $data['item_id'], 'limit' => 1));
            $photo_owner = $photos[0]['user'];
            if (login_checklogin() && ($_SESSION['login']['id'] == $data['user_id'] || $_SESSION['login']['id'] == $photo_owner || is_privilegied('comments_admin'))) {
                $query = 'UPDATE user_comments SET removed=1 WHERE id = ' . $id . ' LIMIT 1';
                mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
            } else {
                die('FEL @ ' . __FILE__ . ' #' . __LINE__);
            }
        } else {
            if (login_checklogin() && ($_SESSION['login']['id'] == $data['user_id'] || is_privilegied('comments_admin'))) {
                $query = 'UPDATE user_comments SET removed=1 WHERE id = ' . $id . ' LIMIT 1';
                mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
            }
        }
    }
}

    $message .= '-----' . "\n";
    $message .= '%CONTENT%' . "\n";
    $message .= '-----' . "\n\n";
    $message .= 'Har du några frågor så ta det med någon ordningsvakt, du hittar sådana i modulen "Inloggade Ordningsvakter" till höger.' . "\n";
    $message .= 'Detta är inte hela världen, men det är kanske bäst att du chillar lite extra i framtiden.' . "\n\n";
    $message .= '/Webmaster';
    $guestbook_message = array('sender' => 2348, 'recipient' => intval($post['author']), 'message' => mysql_real_escape_string(str_replace(array('%TITLE%', '%CONTENT%', '%REMOVAL_COMMENT%', '%REMOVERS_USERNAME%'), array($post['title'], $post['content'], $_GET['removal_comment'], $_SESSION['login']['username']), $message)));
    preint_r($guestbook_message);
    guestbook_insert($guestbook_message);
    log_admin_event('post removed', $post['removal_comment'], $_SESSION['login']['id'], $post['author'], $_GET['post_id']);
    admin_action_count($_SESSION['login']['id'], 'post_removed');
}
if ($_GET['action'] == 'unremove_post' && forum_security(array('action' => 'unremove_post', 'post_id' => $_GET['post_id']))) {
    discussion_forum_remove_post(array('post_id' => $_GET['post_id'], 'mode' => 'unremove'));
}
if ($_GET['action'] == 'vote' && login_checklogin() && is_numeric($_GET['thread_id'])) {
    $query = 'UPDATE forum_read_posts SET has_voted = 1 WHERE thread_id = "' . $_GET['thread_id'] . '" AND user_id = "' . $_SESSION['login']['id'] . '" AND has_voted = 0';
    mysql_query($query);
    if (mysql_affected_rows() == 1) {
        $operand = $_GET['vote'] == 'positive' ? '+' : '-';
        $query = 'UPDATE forum_posts SET score = score ' . $operand . ' 1 WHERE id = "' . $_GET['thread_id'] . '"';
        mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    }
}
/* Thread subscriptions */
if ($_GET['action'] == 'add_thread_subscription') {
    $query = 'UPDATE forum_read_posts SET subscribing = "true" WHERE user_id = "' . $_SESSION['login']['id'] . '" AND thread_id = "' . $_GET['thread_id'] . '" LIMIT 1';
    mysql_query($query);
    $thread = array_pop(discussion_forum_post_fetch(array('post_id' => $_GET['thread_id'])));
    $_SESSION['forum']['subscriptions'][$_GET['thread_id']] = $thread;
}

function dl_index()
{
    global $DL_CATEGORIES;
    foreach ($DL_CATEGORIES as $category) {
        $sum_count += $category['count'];
        $sum_completed += $category['completed'];
    }
    ?>
	<h1>Gratis teoriprogram på nätet</h1>
	
	<p>
		Här hittar du <strong><?php 
    echo $sum_count;
    ?>
 frågor</strong> att träna på inför teoriprovet för vanligt B-körkort. Systemet håller koll
		på vilka frågor du kan och vilka du behöver öva mer på - även om du loggar ut och tar en paus eller byter dator.<br />
		Det kostar ingenting att använda teoriprogrammet men du måste vara inloggad för att det skall fungera!
	</p>
<?php 
    echo '<h2><a href="?action=practice">Plugga på allt</a> ';
    echo login_checklogin() ? '(' . round($sum_completed / $sum_count * 100) . '% klart)' : '';
    echo '</h2>' . "\n";
    echo '<img src="http://images.hamsterpaj.net/drivers-license/dl_teaser.png" style="float: right; margin-left: 10px;" />' . "\n";
    /*
    
    echo'<ul class="dl_category_list">' . "\n";
    foreach($DL_CATEGORIES AS $handle => $category)
    {
    	echo '<li><a href="?action=practice&category=' . $handle . '">' . $category['label'] . '</a> ';
    	if($category['completed'] == 0)
    	{
    		$status = 'inte påbörjad';
    	}
    	elseif($category['completed'] < $category['count'])
    	{
    		$status = round(($category['completed'] / $category['count']) * 100 ) . '% klar';
    	}
    	else
    	{
    		$status = 'klar';
    	}
    	echo '(' . $category['count'] . ' frågor, ' . $status . ')</li>' . "\n";
    }	
    echo '</ul>' . "\n";
    
    echo '<h2>Rensa ämnen du har klarat av</h2>' . "\n";
    echo '<p>Om du vill kan du nollställa dina poäng, antingen för alla frågor eller efter ämne. Klicka bara på en länk här nedanför så nollställer vi dina poäng.</p>' . "\n";
    echo '<h3><a href="?action=clear_all">Nollställ poängen i alla ämnen</a></h3>' . "\n";
    	
    foreach($DL_CATEGORIES AS $handle => $category)
    {
    	echo '<a href="?action=clear_category&category=' . $handle . '">' . $category['label'] . '</a>, ';
    */
    echo '<table class="dl_category_index">' . "\n";
    echo '<tr><th>&nbsp;</th><th class="label">&nbsp;</th><th class="question_count">Frågor</th><th class="percentage_done">Avklarat</th></tr>' . "\n";
    foreach ($DL_CATEGORIES as $handle => $category) {
        echo '<tr>' . "\n";
        echo '<td>' . ($category['completed'] == $category['count'] ? '<img src="http://images.hamsterpaj.net/drivers-license/complete.png" alt="Alla frågor avklarade" />' : '&nbsp;') . '</td>';
        echo '<td><a href="?action=practice&category=' . $handle . '">' . $category['label'] . '</a></td>' . "\n";
        echo '<td>' . $category['count'] . '</td>' . "\n";
        echo '<td>' . round($category['completed'] / $category['count'] * 100) . '%</td>' . "\n";
        echo '<td><a href="?action=clear_category&category=' . $handle . '" class="category_clear" title="Rensa kategorin ' . strtolower($category['label']) . '"><img src="http://images.hamsterpaj.net/drivers-license/clear.png" alt="Rensa ' . $category['label'] . '" /></a></td>' . "\n";
        echo '</tr>' . "\n\n";
    }
    echo '</table>';
}

    }
    /* Check zip_code */
    if (!is_numeric($info['zip_code'])) {
        $return['zip_code'] = 'error';
    }
    $query = 'SELECT spot FROM zip_codes WHERE zip_code = "' . $info['zip_code'] . '" LIMIT 1';
    $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    if (mysql_num_rows($result) != 1) {
        $return['zip_code'] = 'error';
    }
    if (count($return) > 0) {
        return $return;
    }
    return true;
}
if (!login_checklogin()) {
    echo 'Nu gick något fel, du loggades inte in...';
    trace('register_error', 'register.php acsessed by not logged on user...');
} else {
    if (isset($_POST['submit_button'])) {
        $check = regform_check($_POST);
        if ($check === true) {
            unset($data);
            $data['userinfo']['gender'] = $_POST['gender'];
            $data['userinfo']['zip_code'] = $_POST['zip_code'];
            $data['userinfo']['birthday'] = $_POST['birth_year'] . '-' . $_POST['birth_month'] . '-' . $_POST['birth_day'];
            login_save_user_data($_SESSION['login']['id'], $data);
            session_merge($data);
            /*$alert = 'Tackar! Nu skickar vi dig till en introduktionssida som berättar mer om Hamsterpaj,\\n';
            		$alert .= 'vad man gör här och hur sidan fungerar, du måste inte läsa den om du inte vill.';
            		jscript_alert($alert);

        echo '<h1>' . $abuse_headers[$_GET['report_type']] . '</h1>';
        echo $abuse_info[$_GET['report_type']];
        echo '<form method="post" action="' . $_SERVER['PHP_SELF'] . '">' . "\n";
        echo '<input type="hidden" name="report_type" value="' . $_GET['report_type'] . '" />' . "\n";
        echo '<input type="hidden" name="reference_id" value="' . $_GET['reference_id'] . '" />' . "\n";
        foreach ($abuse_alternatives_by_type[$_GET['report_type']] as $handle) {
            echo '<input type="radio" name="abuse_type" class="abuse_radio" value="' . $handle . '" id="abuse_' . $handle . '" />' . "\n";
            echo '<label for="abuse_' . $handle . '">' . $abuse_types[$handle]['label'] . '</label>' . "\n";
            echo '<p>' . $abuse_types[$handle]['description'] . '</p>' . "\n";
        }
        echo '<label for="abuse_freetext">Fritextbeskrivning</label>' . "\n";
        echo '<textarea name="freetext" id="abuse_freetext"></textarea>' . "\n";
        echo '<input type="submit" class="button_70" value="Nästa &raquo;" />' . "\n";
        echo '</form>' . "\n";
    }
} elseif (login_checklogin() && isset($_POST['reference_id']) && is_numeric($_POST['reference_id'])) {
    $query = 'INSERT INTO abuse (timestamp, reporter, report_type, reference_id, abuse_type, freetext)';
    $query .= ' VALUES("' . time() . '", "' . $_SESSION['login']['id'] . '", "' . $_POST['report_type'] . '", "' . $_POST['reference_id'] . '", "' . $_POST['abuse_type'] . '", "' . $_POST['freetext'] . '")';
    mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    $url = forum_get_url_by_post($_POST['reference_id']);
    echo '<h1>Din rapport har sparats</h1>' . "\n";
    echo '<p>Vi kommer att granska din rapport och återkomma till dig med ett personligt svar inom 24 timmar.</p>' . "\n";
    echo '<h2>Ärende-id: #' . mysql_insert_id() . '</h2>' . "\n";
    echo '<br /> <a href="' . $url . '">Gå tillbaka till forumet</a>';
    if ($_POST['report_type'] == 'guestbook_entry') {
        $query = 'UPDATE traffa_guestbooks SET is_private = 0, deleted = 0 WHERE id = "' . $_POST['reference_id'] . '" AND recipient = "' . $_SESSION['login']['id'] . '" LIMIT 1';
        mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
        echo '<h1>OBS! Viktigt om rapporterade gästboksinlägg</h1>' . "\n";
        echo '<p>För att våra ordningsvakter ska kunna granska ett inlägg får det inte vara privat eller borttaget. Privatisera inte och ta inte bort inlägget!</p>' . "\n";
    }
} else {

function guestbook_list($entries)
{
    $out .= '<ul class="guestbook_entries">' . "\n";
    foreach ($entries as $entry) {
        $out .= "\n\n";
        $out .= '<!-- Post #' . cute_number($entry['id']) . ' by ' . $entry['username'] . ' at ' . date('Y-m-d H:i:s', $entry['timestamp']) . '-->' . "\n";
        /*
        $class = ($entry['read'] == 0) ? ' class="unread"': '';
        $out .= '<li' . $class . '>' . "\n";
        if($entry['image'] == 1 || $entry['image'] == 2)
        {
        	$out .= '<img src="http://images.hamsterpaj.net/images/users/thumb/' . $entry['sender'] . '.jpg" class="user_avatar" id="entry_' . $entry['id'] . '_photo" />' . "\n";
        }
        else
        {
        	$out .= '<img src="http://images.hamsterpaj.net/images/users/no_image_mini.png" class="user_avatar" id="entry_' . $entry['id'] . '_photo" />' . "\n";
        }
        
        $out .= '<div class="container">' . "\n";
        $out .= '<div class="top_bg">' . "\n";
        $out .= '<div class="bottom_bg">' . "\n";
        */
        $options['user_id'] = $entry['sender'];
        $options['type'] = $entry['read'] == 0 ? 'unread' : 'standard';
        $out .= message_top($options);
        $out .= '<div id="guestbook_entry_' . $entry['id'] . '">' . "\n";
        $out .= '<span class="timestamp">' . fix_time($entry['timestamp']) . '</span>' . "\n";
        $out .= '<a href="/traffa/profile.php?id=' . $entry['sender'] . '">' . $entry['username'] . '</a> ' . "\n";
        $genders = array('f' => 'F', 'm' => 'P');
        $out .= $genders[$entry['gender']];
        $out .= date_get_age($entry['birthday']) > 0 ? date_get_age($entry['birthday']) : '';
        $out .= '<span class="unanswered" id="unanswered_label_' . $entry['id'] . '"' . $style . '>' . "\n";
        $out .= $entry['answered'] != 'Y' ? '(Obesvarat)' : '';
        $out .= '</span>' . "\n";
        $style = $entry['is_private'] == 0 ? ' style="display: none;"' : '';
        $out .= '<span class="private" id="private_label_' . $entry['id'] . '"' . $style . '>(Privat)</span>' . "\n";
        $out .= '<p>' . setSmilies(nl2br($entry['message'])) . '</p>' . "\n";
        $out .= '<p class="gb_entry_controls">' . "\n";
        $out .= login_checklogin() && $entry['recipient'] == $_SESSION['login']['id'] && $entry['sender'] != $_SESSION['login']['id'] ? '<a href="/traffa/guestbook.php?view=' . $entry['sender'] . '" class="gb_reply_control" id="reply_control_' . $entry['id'] . '">Svara</a>' . "\n" : '';
        $out .= '<a href="/traffa/guestbook.php?view=' . $entry['sender'] . '&history=' . $entry['recipient'] . '">Historik</a>' . "\n";
        $out .= '<a href="/traffa/guestbook.php?view=' . $entry['sender'] . '">Gå till</a>' . "\n";
        $out .= $entry['recipient'] == $_SESSION['login']['id'] ? '<a href="/installningar/userblock.php?action=block&username=' . $entry['username'] . '" class="gb_block_control">Blockera</a>' . "\n" : '';
        if (login_checklogin() && $entry['recipient'] == $_SESSION['login']['id'] && $entry['sender'] != $_SESSION['login']['id']) {
            $out .= '<a href="/traffa/guestbook.php?view=' . $entry['sender'] . '" class="gb_delete_control" id="delete_control_' . $entry['id'] . '">Ta bort</a>' . "\n";
        }
        if (login_checklogin() && $entry['recipient'] == $_SESSION['login']['id'] && $entry['sender'] != $_SESSION['login']['id']) {
            $private_style = $entry['is_private'] == 1 ? ' style="display: none;"' : '';
            $unprivate_style = $entry['is_private'] == 0 ? ' style="display: none;"' : '';
            $out .= '<a href="/traffa/guestbook.php?view=' . $entry['sender'] . '" class="gb_private_control" id="private_control_' . $entry['id'] . '"' . $private_style . '>';
            $out .= 'Gör privat</a>' . "\n";
            $out .= '<a href="/traffa/guestbook.php?view=' . $entry['sender'] . '" class="gb_unprivate_control" id="unprivate_control_' . $entry['id'] . '"' . $unprivate_style . '>';
            $out .= 'Gör offentligt</a>' . "\n";
            $out .= '<a href="/hamsterpaj/abuse.php?report_type=guestbook_entry&reference_id=' . $entry['id'] . '" class="abuse_button"><img src="http://images.hamsterpaj.net/abuse.png" /></a>' . "\n";
        }
        $out .= '</p>' . "\n";
        $out .= guestbook_form(array('recipient' => $entry['sender'], 'reply-to' => $entry['id'], 'form_id' => 'gb_reply_form_' . $entry['id']));
        $out .= '</div>' . "\n";
        $out .= message_bottom();
        /*
        $out .= '</div>' . "\n";
        $out .= '</div>' . "\n";
        $out .= '</div>' . "\n";
        
        $out .= '</li>' . "\n";
        */
    }
    $out .= '</ul>' . "\n";
    return $out;
}

//$data_array = query_cache(array('query' => $query, 'max_delay' => 60));
$result = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
while ($data = mysql_fetch_assoc($result)) {
    $data_array[] = $data;
}
$user_votes = array();
if (login_checklogin()) {
    $query = 'SELECT ascii_art_id FROM ascii_art_votes WHERE userid = ' . $_SESSION['login']['id'];
    $result = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    while ($vote = mysql_fetch_assoc($query)) {
        $user_votes[] = $vote['ascii_art_id'];
    }
}
foreach ($data_array as $data) {
    $allow_voting = false;
    if (login_checklogin() && !in_array($data['id'], $user_votes)) {
        $allow_voting = true;
    }
    echo '<a name="ascii_art_link_' . $data['id'] . '"></a>';
    echo '<div class="ascii_art_div">';
    echo '<div class="resources">';
    echo '<h2>' . $data['title'] . '</h2>' . "\n";
    echo ' <a href="#ascii_art_link_' . $data['id'] . '" id="ascii_art_direct_link_show_' . $data['id'] . '">(Direktlänk)</a>';
    echo '<input type="text" id="ascii_art_direct_link_input_' . $data['id'] . '" class="ascii_art_direct_link_input" value="http://www.hamsterpaj.net/mattan/ascii_art.php#ascii_art_link_' . $data['id'] . '" />' . "\n";
    if (is_privilegied('ascii_art_admin')) {
        echo ' <a href="?delete=' . $data['id'] . '" onclick="return confirm(\\"Sure?\\")">(X)</a>';
    }
    // Avoid division-by-zero-errors...
    $voters = (int) $data['voters'] == 0 ? 1 : (int) $data['voters'];
    echo '<div class="ascii_art_vote" style="background-position: 0px ' . (75 - (round((int) $data['votes'] / $voters) - 1) * 15) . 'px"' . ($allow_voting ? ' id="ascii_art_vote_' . $data['id'] . '_' . round((int) $data['votes'] / $voters) . '"' : '') . ' />&nbsp;</div>';
    echo '</div>';

function discussions_head($discussion,