weiß jemand warum die Notiz im Benutzercenter nicht abgespeichert wird bzw wie muss man das machen das es gespeichert wird ?
Wäre sehr dankbar
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||




<?php
if($_SESSION['authid'] == 0)
{
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Benutzercenter';
$hmenu = 'Benutzercenter';
$design = new design ( $title , $hmenu );
$design->header();
echo 'Bitte Logge dich ein oder Registriere dich!!!';
$design->footer();}else{
if($_GET['bannner'] == 0)
{
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Benutzercenter';
$hmenu = 'Benutzercenter';
$design = new design ( $title , $hmenu );
$design->header();
$uid = $_SESSION['authid'];
$abf = 'SELECT * FROM prefix_user WHERE id = "'.$uid.'"';
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
if ( file_exists($row['avatar'])) {
$avatart = '<b>Mein Avatar:</b><br /><img src="'.$row['avatar'].'" border="0">';
}
$avatart = '';
if (isset($_POST['notiz_sub'])) {
$notiz = escape($_POST['notiz_text'],'textarea');
if (db_count_query("SELECT COUNT(notizuid) FROM `prefix_benutzercenter` WHERE notizuid = ".$_SESSION['authid']) == 1) {
db_query("UPDATE `prefix_benutzercenter` SET notiztext = '$notiz' WHERE notizuid = ".$_SESSION['authid']);
} else {
db_query("INSERT INTO `prefix_benutzercenter` (notizuid, notiztext) VALUES ({$_SESSION['authid']}, '$notiz')");
}
} else {
$notiz = @db_count_query("SELECT notiztext FROM `prefix_benutzercenter` WHERE notizuid = ".$_SESSION['authid']);
}
if ( $row['status'] == 1 ) { $status1 = 'checked'; $status0 = ''; } else { $status1 = ''; $status0 = 'checked'; }
if($_POST['statusa'])
{
db_query("UPDATE prefix_user SET status = '".escape($_POST['status'], 'string')."' WHERE id = ".$_SESSION['authid']);
}
if ( $row['opt_pm'] == 1 ) { $msg1 = 'checked'; $msg0 = ''; } else { $msg1 = ''; $msg0 = 'checked'; }
if($_POST['msga'])
{
db_query("UPDATE prefix_user SET opt_pm = '".escape($_POST['msg'], 'string')."' WHERE id = ".$_SESSION['authid']);
}
if ( $row['opt_mail'] == 1 ) { $mails1 = 'checked'; $mails0 = ''; } else { $mails1 = ''; $mails0 = 'checked'; }
if($_POST['mailsa'])
{
db_query("UPDATE prefix_user SET opt_mail = '".escape($_POST['mails'], 'string')."' WHERE id = ".$_SESSION['authid']);
}
# avatar speichern START
if($_POST['avatar'])
{
$avatar_sql_update = '';
if ( !empty ( $_FILES['avatarfile']['name'] ) AND $allgAr['forum_avatar_upload'] ) {
$file_tmpe = $_FILES['avatarfile']['tmp_name'];
$rile_type = ic_mime_type ($_FILES['avatarfile']['tmp_name']);
$file_type = $_FILES['avatarfile']['type'];
$file_size = $_FILES['avatarfile']['size'];
$fmsg = $lang['avatarisnopicture'];
$size = @getimagesize ($file_tmpe);
$endar = array (1 => 'gif', 2 => 'jpg', 3 => 'png');
if ( ($size[2] == 1 OR $size[2] == 2 OR $size[2] == 3) AND $size[0] > 10 AND $size[1] > 10 AND substr ( $file_type , 0 , 6 ) == 'image/' AND substr ( $rile_type , 0 , 6 ) == 'image/' ) {
$endung = $endar[$size[2]];
$breite = $size[0];
$hoehe = $size[1];
$fmsg = $lang['avatarcannotupload'];
if ( $file_size <= $allgAr['Fasize'] AND $breite <= $allgAr['Fabreite'] AND $hoehe <= $allgAr['Fahohe'] ) {
$neuer_name = 'include/images/avatars/'.$_SESSION['authid'].'.'.$endung;
@unlink (db_result(db_query("SELECT avatar FROM prefix_user WHERE id = ".$_SESSION['authid']),0));
move_uploaded_file ( $file_tmpe , $neuer_name );
@chmod($neuer_name, 0777);
$avatar_sql_update = "avatar = '".$neuer_name."'";
$fmsg = $lang['pictureuploaded'];
}
}
} elseif ( isset($_POST['avatarloeschen']) ) {
$fmsg = $lang['picturedelete'];
@unlink (db_result(db_query("SELECT avatar FROM prefix_user WHERE id = ".$_SESSION['authid']),0));
$avatar_sql_update = "avatar = ''";
}
db_query("UPDATE prefix_user SET ".$avatar_sql_update." WHERE id = ".$_SESSION['authid']);
}
# avatar speichern ENDE
$erg = db_query("SELECT COUNT(id) FROM `prefix_pm` WHERE gelesen = 0 AND status < 1 AND eid = ".$_SESSION['authid']);
$check_pm = db_result($erg,0);
?>
<style type="text/css">
<!--
.ueberschrift {
font-size: 24px;
font-weight: bold;
}
.cat {
font-size: 16px;
font-weight: bold;
background-color:#0099FF;
color:#FFFFCC;
border:dashed;
border-color:#0033FF;
border-width:thin;
}
.untercat {
font-size: 13px;
font-weight: normal;
border:dashed;
border-color:#999999;
border-width:thin;
}
.button
{
color: #000000;
font: 10px Verdana;
border-color: #000000;
border-width: 1px;
border-style: solid;
font-weight: none;
text-decoration: none;
background-color: #FFFFFF;
}
.style3 {
font-size: 12px;
font-family: Arial, Helvetica, sans-serif;
}
-->
</style>
<table width="769" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5"><div align="center" class="ueberschrift">Benutzer-Center</div></td>
</tr>
<tr>
<td colspan="4"><strong>Hallo <?php echo $_SESSION['authname']; ?>! Willkommen auf <?php echo $allgAr['title']; ?></strong></td>
</tr>
<tr>
<td colspan="4" class="cat"><div align="center">Account Verwalten </div></td>
</tr>
<tr>
<td valign="top" width="154" class="untercat"><div align="center"><img src="include/images/usercenter/user.png" alt="user" width="48" height="48" /><br />
<strong>Profil</strong><br />
<a href="index.php?user-8">Bearbeiten</a> / <a href="index.php?user-details-<?php echo $_SESSION['authid']; ?>">Ansehen</a></div></td>
<td width="142" class="untercat" valign="top"><div align="center"><img src="include/images/usercenter/mail.png" alt="user" width="48" height="48" /><br />
<strong>Nachrichten (<?php echo $check_pm; ?>)</strong><br />
<a href="index.php?forum-privmsg">Ansehen</a> / <a href="index.php?forum-privmsg-new">Schreiben</a></div></td>
<td width="125" class="untercat" valign="top"><div align="center"><img src="include/images/usercenter/gallery.png" alt="user" width="48" height="48" /><br />
<strong>Usergallery</strong><br />
<a href="index.php?user-usergallery-<?php echo $_SESSION['authid']; ?>">Ansehen</a></div></td>
<td width="348" class="untercat" valign="top"><form name="status" method="post" action="">
<strong>Profil-Status ändern:</strong>
<input type="radio" name="status" <?php echo $status1; ?> value="1" />
Aktiv
<input type="radio" name="status" <?php echo $status0; ?> value="0" />
Inaktiv <br />
<input type="submit" name="statusa" value="Ändern" />
</form>
<form name="nachrichten" method="post" action="">
<strong>Nachrichten Service:</strong>
<input type="radio" name="msg" <?php echo $msg1; ?> value="1" />
Aktiv
<input type="radio" name="msg" <?php echo $msg0; ?> value="0" />
Inaktiv <br />
<input type="submit" name="msga" value="Ändern" />
</form>
<form name="mails" method="post" action="">
<strong>Mails von Benutzern: </strong>
<input type="radio" name="mails" <?php echo $mails1; ?> value="1" />
Ja
<input type="radio" name="mails" <?php echo $mails0; ?> value="0" />
Nein <br />
<input type="submit" name="mailsa" value="Ändern" />
</form></td>
</tr>
<tr>
<td colspan="4" class="cat"><div align="center">Forum</div></td>
</tr>
<tr>
<td valign="top" width="154" class="untercat"><div align="center"><img src="include/images/usercenter/forum.png" alt="user" width="48" height="48" /><br />
<strong>Beiträge seit dem letztem Besuch </strong><br />
<a href="index.php?forum-augt">Ansehen</a></div></td>
<td valign="top" width="142" class="untercat"><div align="center"><img src="include/images/usercenter/forum.png" alt="user" width="48" height="48" /><br />
<strong>Unbeantwortete Themen </strong><br />
<a href="index.php?forum-aubt">Ansehen</a></div></td>
<td valign="top" width="125" class="untercat"><div align="center"><img src="include/images/usercenter/forum.png" alt="user" width="48" height="48" /><br />
<strong>Eigene Beiträge </strong><br />
<a href="index.php?forum-aeit">Ansehen</a></div></td>
<td colspan="4" class="untercat" valign="top"><strong>Letze Beiträge: </strong><br />
<?php
# Copyright by: Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time
FROM prefix_topics a
LEFT JOIN prefix_forums b ON b.id = a.fid
LEFT JOIN prefix_posts c ON c.id = a.last_post_id
LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = b.view
LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = b.reply
LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = b.start
WHERE ((".$_SESSION['authright']." <= b.view AND b.view < 1)
OR (".$_SESSION['authright']." <= b.reply AND b.reply < 1)
OR (".$_SESSION['authright']." <= b.start AND b.start < 1)
OR vg.fid IS NOT NULL
OR rg.fid IS NOT NULL
OR sg.fid IS NOT NULL
OR -9 >= ".$_SESSION['authright'].")
ORDER BY c.time DESC
LIMIT 0,3";
echo '<table>';
$resultID = db_query($query);
while ($row = db_fetch_assoc($resultID)) {
$row['date'] = date('d.m.y - H:i',$row['time']);
$row['page'] = ceil ( ($row['rep']+1) / $allgAr['Fpanz'] );
echo '<tr><td valign="top"><b> » </b></td><td><a href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['date'].'">'.((strlen($row['name'])<60) ? $row['name'] : substr($row['name'],0,60).'...').'<br /><span class="smalfont"> von '.$row['last'].'</span></a></td></tr>';
}
echo '</table>';
?></td>
</tr>
<tr>
<td colspan="4" class="cat"><div align="center">Benutzer</div></td>
</tr>
<tr>
<td colspan="3" valign="top" class="untercat"><div align="center"><strong>Dein Userbanner: <br />
<img src="index.php?benutzercenter&bannner=1&id=<?php echo $_SESSION['authid']; ?>" /><br />
</strong></div>
<strong>
<label> </label>
<div align="center"><strong>Dein Banner als Html und BB-Code <br />
<textarea name="textarea" cols="25" rows="3"><a href="http://<?php echo $_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME']; ?>?user-details-<?php echo $_SESSION['authid']; ?>"><img src="http://<?php echo $_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME']; ?>?benutzercenter&bannner=1&id=<?php echo $_SESSION['authid']; ?>" /></a></textarea>
<textarea name="textarea2" cols="25" rows="3">[url=http://<?php echo $_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME']; ?>?user-details-<?php echo $_SESSION['authid']; ?>][img]http://<?php echo $_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME']; ?>?benutzercenter&bannner=1&id=<?php echo $_SESSION['authid']; ?>[/img][/url]</textarea>
</strong></div>
<strong>
<div align="center"><br />
</div>
</strong></strong></td>
<td colspan="4" class="untercat" valign="top"><div align="center"><b>Meine Notiz </b> </div>
<form action="<?php echo substr($_SERVER[REQUEST_URI],1); ?>" method="post">
<div align="center">
<textarea cols="40" rows="5" name="notiz_text"><?php echo $notiz; ?></textarea>
<br />
<input type="submit" name="notiz_sub" value="ändern" />
</div>
</form></td>
</tr>
</table>
<br />
<span class="style3"><a href="http://ilch-mods.de">© by Ilch-Mods.de @ Hassmann </a></span><br />
<?php $design->footer();
}
function userrangpic ($post,$uid) {
global $global_user_rang_array;
if (!isset($global_user_rang_array[$uid])) {
if (!isset($global_user_rang_array)) {
$global_user_rang_array = array();
}
if ( empty($uid) ) {
$rRang = 'Gast';
} else {
$rRang = @db_result(db_query("SELECT bez FROM prefix_user LEFT JOIN prefix_ranks ON prefix_ranks.id = prefix_user.spezrank WHERE prefix_user.id = ".$uid),0);
}
if ( empty($rRang) ) {
$post = ( $post == 0 ? 1 : $post );
$rRang = @db_result(db_query("SELECT bez FROM `prefix_ranks` WHERE spez = 0 AND min <= ".$post." ORDER BY min DESC LIMIT 1"),0);
} elseif ( $rRang != 'Gast' ) {
$rRang = ''.$rRang.'';
}
$global_user_rang_array[$uid] = $rRang;
}
return ($global_user_rang_array[$uid]);
}
if($_GET['bannner'] == 1)
{
define ( 'main' , TRUE );
require_once ('include/includes/config.php');
require_once ('include/includes/loader.php');
$uid = $_GET['id'];
$abf = 'SELECT * FROM prefix_user WHERE id = "'.$uid.'"';
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
$rang = userrangpic($row['posts'],$uid);
$banner = 'include/images/usercenter/banner.png';
if($row['gebdatum'] !== "0000-00-00"){
$gebdatum = date('d.m.Y',strtotime($row['gebdatum']));
$tag = date('d',strtotime($row['gebdatum']));
$monat = date('m',strtotime($row['gebdatum']));
$jahr = date('Y',strtotime($row['gebdatum']));
$jetzt = mktime(0,0,0,date("m"),date("d"),date("Y"));
$geburtstag = mktime(0,0,0,$monat,$tag,$jahr);
$alter = "(".intval(($jetzt - $geburtstag) / (3600 * 24 * 365)).")";
} else {
$gebdatum = "n/a";
$alter = "";
}
if(!empty($row['wohnort'])){
$wohnort = $row['wohnort'];
} else {
$wohnort = "n/a";
}
if($row['geschlecht'] == 1){
$geschlecht = "Männlich";
}elseif($row['geschlecht'] == 2){
$geschlecht = "Weiblich";
}else{
$geschlecht = "n/a";
}
$abf2 = "SELECT * FROM prefix_online";
$erg2 = db_query($abf2);
$row2 = db_fetch_assoc($erg2);
if($row2['uid'] == $_GET['id']){
$online = "Online";
}else{
$online = "Offline";
}
$j = date('d M Y',$row['regist']);
$ll = date('d M Y',$row['llogin']);
header("Content-type: image/png");
$im = ImageCreateFromPNG($banner);
$text1 = 'Name: '.$row['name'];
$text2 = 'Posts: '.$row['posts'];
$text3 = 'Dabei seit: '.$j;
$text5 = 'Letzer Login: '.$ll;
$text8 = 'Geschlecht: '.$geschlecht;
$text7 = 'Wohnort: '.$wohnort;
$text4 = 'Rang: '.$rang;
$text9 = $row['name'].' ist grade '.$online;
$text6 = 'Geburtsdatum: '.$gebdatum.' '.$alter;
$fo = 2;
$schwarz = ImageColorAllocate($im, 0, 0, 0);
imagestring ($im, $fo, 20, 10, $text1, $schwarz);
imagestring ($im, $fo, 20, 20, $text2, $schwarz);
imagestring ($im, $fo, 20, 30, $text3, $schwarz);
imagestring ($im, $fo, 20, 40, $text4, $schwarz);
imagestring ($im, $fo, 170, 10, $text5, $schwarz);
imagestring ($im, $fo, 170, 20, $text6, $schwarz);
imagestring ($im, $fo, 170, 30, $text8, $schwarz);
imagestring ($im, $fo, 170, 40, $text7, $schwarz);
imagestring ($im, 1, 380, 2, '(c) Ilch-Mods.de', $schwarz);
ImagePNG($im);
}
}
?>

<?php
defined('main') or die('no direct access');
$onlinetime = 600;
if (!function_exists('arrayToDb')) {
function arrayToDb($table, $ar, $where = '', $ar2 = array()) {
$mode = empty($where) ? 'INSERT INTO' : 'UPDATE';
$fields = '';
foreach ($ar as $k => $v) {
if (in_array($k, $ar2)) {
continue;
}
$fields .= ", `$k` = " . (is_null($v) ? 'NULL' : "'$v'");
}
$fields = substr($fields, 2);
$query = "$mode $table SET $fields $where;";
if (db_query($query)) {
return true;
} else {
return false;
}
}
}
if ($menu->get(1) == 'banner') {
// Banner anzeigen
$uid = intval($menu->get(2));
$abf = "SELECT u.*, IF(u.spezrank>0,r.bez,r2.bez) AS rang, IF(o.uid=u.id,'Online','Offline') AS online
FROM prefix_user u
LEFT JOIN `prefix_ranks` r ON u.spezrank = r.id AND r.spez = 1
LEFT JOIN `prefix_ranks` r2 ON IF(u.posts=0,1,u.posts) >= r2.min AND r2.spez = 0
LEFT JOIN `prefix_online` o ON u.id = o.uid AND o.uptime > '".date('Y-m-d H:m:i', time() - $onlinetime)."'
WHERE u.id = {$uid}";
$qry = db_query($abf);
if (db_num_rows($qry) == 0) {
$fehler = 'Benutzer nicht gefunden';
} elseif ($row = db_fetch_assoc($qry) and $row['recht'] > $allgAr['userbannerrecht']) {
$fehler = 'Banner für diesen User nicht erlaubt';
} elseif (!file_exists($allgAr['userbannerlink'])) {
$fehler = 'Bannervorlagenbild nicht gefunden';
} elseif ($tmp = getimagesize($allgAr['userbannerlink']) and $tmp[2] != 3) {
$fehler = 'Bannervorlagenbild kein PNG';
} else {
$banner = $allgAr['userbannerlink'];
if ($row['gebdatum'] !== "0000-00-00") {
list($y, $m, $d) = explode('-', $row['gebdatum']);
$gebdatum = "$d.$m.$y";
$alter = '('.((date('Y') - $y) - ((date('m') < $m or (date('m') == $m and date('d') < $d)) ? 1 : 0)).')';
} else {
$gebdatum = "n/a";
$alter = "";
}
if (empty($row['wohnort'])) {
$row['wohnort'] = 'n/a';
}
if ($row['geschlecht'] == 1) {
$geschlecht = "Männlich";
} elseif ($row['geschlecht'] == 2) {
$geschlecht = "Weiblich";
} else {
$geschlecht = "n/a";
}
$j = date('d.m.Y', $row['regist']);
$ll = date('d.m.Y', $row['llogin']);
$im = ImageCreateFromPNG($banner);
$text1 = 'Name: ' . $row['name'];
$text2 = 'Posts: ' . $row['posts'];
$text3 = 'Dabei seit: ' . $j;
$text5 = 'Letzer Login: ' . $ll;
$text8 = 'Geschlecht: ' . $geschlecht;
$text7 = 'Wohnort: ' . $row['wohnort'];
$text4 = 'Rang: ' . $row['rang'];
$text9 = $row['name'] . ' ist grade ' . $row['online'];
$text6 = 'Geburtsdatum: ' . $gebdatum . ' ' . $alter;
$fo = 2;
$schwarz = ImageColorAllocate($im, 0, 0, 0);
imagestring ($im, $fo, 20, 10, $text1, $schwarz);
imagestring ($im, $fo, 20, 20, $text2, $schwarz);
imagestring ($im, $fo, 20, 30, $text3, $schwarz);
imagestring ($im, $fo, 20, 40, $text4, $schwarz);
imagestring ($im, $fo, 170, 10, $text5, $schwarz);
imagestring ($im, $fo, 170, 20, $text6, $schwarz);
imagestring ($im, $fo, 170, 30, $text8, $schwarz);
imagestring ($im, $fo, 170, 40, $text7, $schwarz);
imagestring ($im, 1, 380, 2, '(c) Ilch-Mods.de', $schwarz);
}
if (!empty($fehler)) {
$im = imagecreate(strlen($fehler)*7, 18);
$color = imagecolorallocate($im, 0, 0, 0);
$color = imagecolorallocate($im, 255, 255, 255);
imagestring($im, 2, 4, 2, $fehler, $color);
}
header("Content-type: image/png");
ImagePNG($im);
exit();
} else {
//Benutzercenter anzeigen
$title = $allgAr['title'] . ' :: Benutzercenter';
$hmenu = 'Benutzercenter';
$design = new design ($title , $hmenu);
if ($_SESSION['authid'] == 0) {
$design->header();
echo 'Bitte logge dich ein!!!';
} else {
$tpl = new tpl('benutzercenter');
$design->addheader($tpl->get(0));
$design->header();
$row = db_fetch_assoc(db_query('SELECT u.*, b.* FROM prefix_user u LEFT JOIN prefix_benutzercenter b ON u.id = b.notizuid WHERE u.id = ' . $_SESSION['authid']));
if (isset($_POST['submit'])) {
//Notiztext updaten
$update = !is_null($row['notiztext']);
$row['notiztext'] = escape($_POST['notiztext'], 'textarea');
if ($update) {
db_query("UPDATE `prefix_benutzercenter` SET notiztext = '{$_row['notiztext']}' WHERE notizuid = " . $_SESSION['authid']);
} else {
db_query("INSERT INTO `prefix_benutzercenter` (notizuid, notiztext) VALUES ({$_SESSION['authid']}, '{$_row['notiztext']}')");
}
//Usertabelle updaten
$updateUser = array();
if ($row['status'] != $_POST['status']) {
$row['status'] = $updateUser['status'] = escape($_POST['status'], 'integer');
}
if ($row['opt_pm'] != $_POST['msg']) {
$row['opt_pm'] = $updateUser['opt_pm'] = escape($_POST['msg'], 'integer');
}
if ($row['opt_mail'] != $_POST['mails']) {
$row['opt_mail'] = $updateUser['opt_mail'] = escape($_POST['mails'], 'integer');
}
if (!empty($updateUser)) {
arrayToDb('prefix_user', $updateUser, 'WHERE id = '.$_SESSION['authid']);
}
}
$erg = db_query("SELECT COUNT(id) FROM `prefix_pm` WHERE gelesen = 0 AND status < 1 AND eid = " . $_SESSION['authid']);
$row['check_pm'] = db_result($erg, 0);
$scriptlink = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME'];
$row['profillink'] = $scriptlink . '?user-details-' . $_SESSION['authid'];
if ($allgAr['userhtaccess'] == 1) {
$row['imgsrc'] = dirname($scriptlink) . '/stats-' . $_SESSION['authid'] . '.png';
} else {
$row['imgsrc'] = $scriptlink . '?benutzercenter-banner-' . $_SESSION['authid'];
}
$row['sitename'] = $allgAr['title'];
$row['showNotiz'] = $allgAr['usernotiz'];
$row['showBanner'] = $allgAr['userbanner'];
if ($row['showBanner'] and $row['recht'] > $allgAr['userbannerrecht']) {
$row['showBanner'] = 0;
}
$row['colspan'] = $row['showBanner'] ? 1 : 3;
$anzahl = intval($allgAr['userlastforum']);
$query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time
FROM prefix_topics a
LEFT JOIN prefix_forums b ON b.id = a.fid
LEFT JOIN prefix_posts c ON c.id = a.last_post_id
LEFT JOIN prefix_groupusers vg ON vg.uid = " . $_SESSION['authid'] . " AND vg.gid = b.view
LEFT JOIN prefix_groupusers rg ON rg.uid = " . $_SESSION['authid'] . " AND rg.gid = b.reply
LEFT JOIN prefix_groupusers sg ON sg.uid = " . $_SESSION['authid'] . " AND sg.gid = b.start
WHERE ((" . $_SESSION['authright'] . " <= b.view AND b.view < 1)
OR (" . $_SESSION['authright'] . " <= b.reply AND b.reply < 1)
OR (" . $_SESSION['authright'] . " <= b.start AND b.start < 1)
OR vg.fid IS NOT NULL
OR rg.fid IS NOT NULL
OR sg.fid IS NOT NULL
OR -9 >= " . $_SESSION['authright'] . ")
ORDER BY c.time DESC
LIMIT 0,$anzahl";
$row['last_forum'] = '<table>';
$resultID = db_query($query);
while ($r = db_fetch_assoc($resultID)) {
$r['date'] = date('d.m.y - H:i', $r['time']);
$r['page'] = ceil (($r['rep'] + 1) / $allgAr['Fpanz']);
$row['last_forum'] .= '<tr><td valign="top"><b> » </b></td><td><a href="?forum-showposts-' . $r['id'] . '-p' . $r['page'] . '#' . $r['pid'] . '" title="' . $r['date'] . '">' . ((strlen($r['name']) < 60) ? $r['name'] : substr($r['name'], 0, 60) . '...') . '<br /><span class="smalfont"> von ' . $r['last'] . '</span></a></td></tr>';
}
$row['last_forum'] .= '</table>';
$tpl->set_ar_out($row, 1);
}
$design->footer();
}
?>

| Geschlossen | ||
![]() |
Zurück zu Module und Modifikationen | |