<?php

    echo '<div class="content_left">
    <div id="breadcrumb">
        <ul class="crumbs">
            <li class="first"><a href="index.php" style="z-index:9;"><span></span>' . $lang['index'] . '</a></li>
            <li><a href="pinboard.php" style="z-index:8;">' . $lang['pinboard'] . '</a></li>
        </ul>
    </div>
    </div>

    <div class="content_right">';

        include('modules/search.inc.php');
    echo '</div>

    <div class="clear_long"></div>';

    $ret = 1;

    echo '<div class="main_menu">';

        $ret = include 'framework/templates/'.$main_content['menu'];
    echo '<div id="line"></div>';

        $ret = include 'framework/templates/'.$main_content['infos'];
    echo '</div>';

    echo '<div class="main_content">';

    echo '<h1 class="p_space">' . $lang['pinboard'] . '</h1>';

    if((isset($_GET['id'])) && (is_numeric($_GET['id']))) {

	$id = mysql_real_escape_string($_GET['id']);
	$id = intval($_GET['id']);
	$pb = FALSE;

		}else{

		$id = (int)$_SESSION['id'];
		$pb = TRUE;
		}

    echo '<div class="right"><a href="framework/feeds/users.php?id=' . $id . '" target="_blank" title="' . $lang['my_pinboard_feeds'] . '"><img src="style/buttons/rss.png" border="0" width="16" height="16" alt="RSS Feeds"></a></div>';

    echo '<div class="clear"></div>';

    if($pb == TRUE) {
    
        require('comment.php');
        echo '<div class="clear_long"></div>';
        }

	$sql = "SELECT
			    pinboard.id,
			    pinboard.id2,
			    pinboard.post,
			    pinboard.date AS postDATE,
			    members.id AS memID,
			    members.name,
			    members.avatar
		    FROM
			    pinboard
		    LEFT JOIN
			    members
		    ON
			    pinboard.id2 = members.id
		    WHERE
			    pinboard.id2 = '" . $id . "'
		    ORDER BY
                id DESC";

    $result = mysql_query($sql) OR die(mysql_error());

    if(intval(mysql_num_rows($result)) == 0) {

    echo '<p class="false">' . $lang['no_pb_entries'] . '</p>';

    	}else{

    	while($row = mysql_fetch_assoc($result)) {

            include_once('framework/filter.php');
            include_once('framework/functions/badwords.php');
            include_once('framework/functions/smileys.php');

            echo '<ul id="conversationPosts" class="postList">
            <li>
            <div class="post hasControls">
            <div class="avatar"><a href="member.php?id=' . (int)$row['memID'] . '"><img src="' . htmlentities($row['avatar']) . '" class="Avatar" border="0" alt="Avatar"></a></div>
            <div class="postContent thing">
            <div class="postHeader">
            <div class="info">
            <a href="member.php?id=' . (int)$row['memID'] . '">' . htmlentities($row['name'], ENT_QUOTES) . '</a>&nbsp;&nbsp;&nbsp;<small>' . date('d.m.Y - H:i', strtotime($row['postDATE'])) . ' ' . $lang['o_clock'] . '</small>
            </div>
            <div class="controls"></div>
            </div>
            <div class="postBody">
            <p>' . mysql_filter(filter_html(badwords(smileys(stripslashes(nl2br($row['post'])))))) . '</p>
            </div>
            </div>
            </div></li>
            </ul>';
            }
        }

?>