ich bins mal wieder
ich hab die suche benutzt aber leider nichts gefunden was mein problem betrifft
ich hab mir das benutzercenter mal runtergeladen und auch drauf gemacht
geht auch alles wunderbar (cooles teil) doch jetzt wollte ich den notiztext von jedem user auch in sein banner anzeigen lassen
angezeigt wird er auch und das eintragen klappt auch prima bis auf, das man keine bustaben übertragen kann
ich weiß einfach nicht worans liegt
ich hab in der datenbank bei user auch eine neue spalte mit notiztext angelegt und das als text gemacht
und wie gesagt zahlen kann man prima übertragen aber bustaben nicht
woran liegt das ?
hier mal meine benutzercenter.php
von zeile 161 bis 173
<?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['recht'] == 0) {
$row['recht'] = "Gast";
} elseif ($row['recht'] == -1) {
$row['recht'] = "User";
}
elseif ($row['recht'] == -2) {
$row['recht'] = "Superuser";
}
elseif ($row['recht'] == -3) {
$row['recht'] = "Trialmember";
}
elseif ($row['recht'] == -4) {
$row['recht'] = "Member";
}
elseif ($row['recht'] == -5) {
$row['recht'] = "VipMember";
}
elseif ($row['recht'] == -6) {
$row['recht'] = "Moderator";
}
elseif ($row['recht'] == -7) {
$row['recht'] = "SiteAdmin";
}
elseif ($row['recht'] == -8) {
$row['recht'] = "Coleader";
}
elseif ($row['recht'] == -9) {
$row['recht'] = "Clanleader";
}
if ($row['geschlecht'] == 1) {
$row['geschlecht'] = "Männlich";
}
elseif ($row['geschlecht'] == 0) {
$row['geschlecht'] = "Weiblich";
}
$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: ' . $row['geschlecht'];
$text7 = 'Wohnort: ' . $row['wohnort'];
$text4 = 'Rang: ' . $row['recht'];
$text10 = 'Notiz:' . $row['notiztext'];
$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, $fo, 20, 50, $text9, $schwarz);
imagestring ($im, $fo, 20, 60, $text10, $schwarz);
imagestring ($im, 1, 380, 2, 'STS-Clan', $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
$_POST['notiztext'] = escape($_POST['notiztext'],'string');
// $row['notiztext'] = escape($_POST['notiztext'], 'textarea');
db_query("UPDATE `prefix_user`
SET notiztext = ".$_POST['notiztext']."
WHERE id = " . $_SESSION['authid']);
//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) . '?benutzercenter-banner-' . $_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();
}
?>
verwendete ilchClan Version: 1.1
betroffene Homepage: web61.server101.rhs-it.de/
