// START Szenentracker
eval("\$profile = \"".$templates->get("member_profile")."\";");
$monthOpen = array(
'Januar' => 'Januar',
'Februar' => 'Februar',
'März' => 'Marz',
'April' => 'April',
'Mai' => 'Mai',
'Juni' => 'Juni',
'Juli' => 'Juli',
'August' => 'August',
'September' => 'September',
'Oktober ' => 'Oktober',
'November' => 'November',
'Dezember' => 'Dezember',
);
foreach($monthOpen as $monthName) {
$query = $db->query("
SELECT t.subject, t.description, t.tid, p.username, p.uid, p.pid, p.dateline, t.threadsolved
FROM ".TABLE_PREFIX."threads t
INNER JOIN ".TABLE_PREFIX."forums f ON t.fid=f.fid AND f.parentlist LIKE '2%' OR f.parentlist LIKE '3%'
INNER JOIN ".TABLE_PREFIX."posts p ON t.tid=p.tid
WHERE (p.uid='".$memprofile['uid']."') AND t.description LIKE '%$monthName%'
GROUP BY t.subject, p.username
ORDER BY t.description ASC
");
while($row = $db->fetch_array($query)) {
if (stristr($row['description'], '2014') !== false) {
$userid = $row['uid'];
$row['pid'] = $row['pid'];
$row['tid'] = $row['tid'];
$szenen_subject = "<a href=\"showthread.php?tid={$row['tid']}\">".htmlspecialchars_uni($row['subject'])."</a>";
$szenen_desc = "<br /><span class=\"tdesc\">{$row['description']}</span>";
$threadsolved = $threadsolved_button = "";
if($row['threadsolved'] == "1") {
$threadsolved = "<img src=\"images/solved.png\" border=\"0\" alt=\"\" style=\"vertical-align: middle;\" /> ";
}
eval("\$memprofile_szenen14_$monthName .= \"".$templates->get("member_profile_szenen_listbit")."\";");
eval("\$memprofile_szenen14 = \"".$templates->get("member_profile_szenen14")."\";");
}
if (stristr($row['description'], '2015') !== false) {
$userid = $row['uid'];
$row['pid'] = $row['pid'];
$row['tid'] = $row['tid'];
$szenen_subject = "<a href=\"showthread.php?tid={$row['tid']}\">".htmlspecialchars_uni($row['subject'])."</a>";
$szenen_desc = "<br /><span class=\"tdesc\">{$row['description']}</span>";
$threadsolved = $threadsolved_button = "";
if($row['threadsolved'] == "1") {
$threadsolved = "<img src=\"images/solved.png\" border=\"0\" alt=\"\" style=\"vertical-align: middle;\" /> ";
}
eval("\$memprofile_szenen15_$monthName .= \"".$templates->get("member_profile_szenen_listbit")."\";");
eval("\$memprofile_szenen15 = \"".$templates->get("member_profile_szenen15")."\";");
}
if (stristr($row['description'], '2016') !== false) {
$userid = $row['uid'];
$row['pid'] = $row['pid'];
$row['tid'] = $row['tid'];
$szenen_subject = "<a href=\"showthread.php?tid={$row['tid']}\">".htmlspecialchars_uni($row['subject'])."</a>";
$szenen_desc = "<br /><span class=\"tdesc\">{$row['description']}</span>";
$threadsolved = $threadsolved_button = "";
if($row['threadsolved'] == "1") {
$threadsolved = "<img src=\"images/solved.png\" border=\"0\" alt=\"\" style=\"vertical-align: middle;\" /> ";
}
eval("\$memprofile_szenen16_$monthName .= \"".$templates->get("member_profile_szenen_listbit")."\";");
eval("\$memprofile_szenen16 = \"".$templates->get("member_profile_szenen16")."\";");
}
}
if(!$memprofile_szenen14) $memprofile_szenen14 = "<center><h4>Jahr 2014</h4></center>Dieses Mitglied besitzt noch keine Szenen im Jahr 2014.";
if(!$memprofile_szenen15) $memprofile_szenen15 = "<center><h4>Jahr 2015</h4></center>Dieses Mitglied besitzt noch keine Szenen im Jahr 2015.";
if(!$memprofile_szenen16) $memprofile_szenen16 = "<center><h4>Jahr 2015</h4></center>Dieses Mitglied besitzt noch keine Szenen im Jahr 2016.";
}