<div class="ipsWidget_inner">
    <img src="images/lastactivity.png" style="border: 1px solid rgb(233, 233, 233); width: 100%; margin-bottom: 8px;">
	<ul class="ipsDataList ipsDataList_reducedSpacing">
	<?php
	include('conf_global.php');
	date_default_timezone_set('Europe/Riga');
	$db = mysqli_connect($INFO['sql_host'], $INFO['sql_user'], $INFO['sql_pass'], $INFO['sql_database']);
	mysqli_query($db, "SET NAMES utf8");
	$query = mysqli_query($db, "SELECT * FROM forums_forums LEFT JOIN forums_topics ON forums_forums.id=forums_topics.forum_id RIGHT JOIN core_members ON forums_topics.starter_id=core_members.member_id ORDER BY tid DESC LIMIT 5");
	while($row = mysqli_fetch_array($query)){
	$replies = $row['posts'] - 1;
	if($row['pp_thumb_photo'] == 'NULL'){
	     $image = 'http://esrp.lv/forums/uploads/set_resources_22/84c1e40ea0e759e3f1505eb1788ddf3c_default_photo.png';
	}
	else {
	     $image = 'http://esrp.lv/forums/uploads/'.$row['pp_thumb_photo'];
	}
        if($row['state'] == 'open'){
             $state = 'Atvērts';
        }
        else {
             $state = 'Aizvērts';
        }
	$date = date('j. M, H:i', $row['start_date']);
	$fulldate = date('Y.m.d. H:i', $row['start_date']);
	$forum = str_replace('-', ' ', $row['name_seo']);
	?>
		<li class="ipsDataItem topics" topicid="<?php echo $row['tid']; ?>" class="ipsClearfix ipsDataItem ipsDataItem">
			<div class="ipsDataItem_icon ipsPos_top">
				<a href="http://esrp.lv/forums/index.php?/profile/<?php echo $row['starter_id']; ?>-<?php echo $row['starter_name']; ?>/" data-ipshover="" data-ipshover-target="http://esrp.lv/forums/index.php?/profile/<?php echo $row['starter_id']; ?>-<?php echo $row['starter_name']; ?>/&do=hovercard" class="ipsUserPhoto ipsUserPhoto_tiny" title="Doties uz <?php echo $row['starter_name']; ?> profilu">
		        <img src="<?php echo $image; ?>" alt="<?php echo $row['starter_name']; ?>" itemprop="image">
		        </a>
		    </div>
			<div class="ipsDataItem_main cWidgetComments">
				<div class="ipsCommentCount ipsPos_right " data-ipstooltip="" title="<?php echo $replies; ?> reply"><?php echo $replies; ?></div>
				<div class="ipsType_break ipsContained">
					<a class="ipsDataItem_title" href="http://esrp.lv/forums/index.php?/topic/<?php echo $row['tid']; ?>-<?php echo $row['title_seo']; ?>/&do=getLastComment" title="View the topic <?php echo $row['title']; ?> " data-ipshover="" data-ipshover-target="http://esrp.lv/forums/index.php?/topic/<?php echo $row['tid']; ?>-<?php echo $row['title_seo']; ?>/&preview=1" data-ipshover-timeout="0.5" id="ips_uid_693_19">
						<span itemprop="name" id="topic_title <?php echo $row['tid'] ?>"><?php echo $row['title']; ?></span>
					</a>
		        </div>
				<p class="ipsType_reset ipsType_medium">
					<span class="ipsType_light"><span class="cat">Sadaļa:<span></span> <a href="http://esrp.lv/forums/index.php?/forum/<?php echo $row['id']; ?>-<?php echo $row['name_seo']; ?>/"><?php echo $forum; ?></a>
				</p>
				<p class="ipsType_reset ipsType_medium ipsType_blendLinks">
					<span class="ipsType_light tdb-NoWrap">
						<span class="cat">Datums: <time title="<?php echo $fulldate; ?>"><?php echo $date; ?></time></span>
					</span>
				</p>
			</div>
		</li>
                <div class="postinfo" topicid="<?php echo $row['tid']; ?>">
                         <div class="lastposter">Pēdējā atbilde no <span><?php echo $row['last_poster_name']; ?></span></div>
                         <div class="state">Tēmas statuss: <?php echo $state; ?></div>
                </div>
	<?php
	}
	?>
	</ul>
</div>