Beitrag zur Merkliste hinzufügen
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| [ Anmelden zum schreiben ] |
| Profilansicht Mod 1.2b erweitern? | |||
|---|---|---|---|
| IRvD Mitglied 
Posts: 210  |
Hey Ilch Community,
ich hab da ein kleines Problem. Ich habe versucht bei der "Profilansicht Modifizierung 1.2b" Proflfelder hinzufügen. Die userdetails.htm und die profil_edit.htm habe ich soweit abgeändert! In der profil_edit.php und auch user_details.php aus den include/contents/user Ordner habe ich auch editiert. Als ich dann mein Profilbearbeiten wollte stand 1. {photoshop} in den Feld wo man etwas eingibt und 2. ich konnte dort zwar etwas eintippen, doch wenn ich auf Speichern klicke kommt einen Fehlermeldung. Da es eine MySQl MEldung war dachte ich mir (oje bist du doof), ich ging in die Datenbank ic1_user auf Struktur und habe meione gewünschten 5 Felder hinzugefügt. Nun geht es leider immernoch nicht. Muss ich noch in irgendeiner Datei etwas ändern? Fehldermeldung: MySQL Error: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql = '5%', flash = '0%', ilch = '80%', cpu = 'AMD Phenom X4 Qu' at line 35 in Query: UPDATE `ic2_user` SET homepage = 'http://irvd-website.de', wohnort = 'Cuxhaven', icq = '', msn = '', yahoo = '', aim = '', staat = 'Germany.gif', game1 = '', game2 = '', game3 = '', game4 = '', game5 = '', geschlecht = '1', status = '1', opt_mail = '1', opt_pm = '1', opt_pm_popup = '1', gebdatum = '1990-12-22', game = '', spielerfahrungen = '', clan = '', map = '', waffe = '', essen = '80 %', trinken = '60%', film = '30%', musik = '5 %', sport = '20 %', photoshop = '40%', html = '60%', php = '35%', sql = '5%', flash = '0%', ilch = '80%', cpu = 'AMD Phenom X4 Quad Core Prozessor 9550 (2,2GHz, 4MB Cache)', mainboard = 'AMD AM2 AP480 - S / Chipsatz AMD RS780G, SB700', ram = '2x 2048MB DDR - 2 RAM Arbeitsspeicher', monitor = 'Schneider (CRT)', grafikkarte = 'NVIDIA GeForce 9600GT 512MB', soundkarte = '5.1 on board', festplatte = '700 GB', i_net_verbindung = '32.000 kb/sek Kabel Deutschland', tastatur = 'Microsoft Wireless Optical Desktop 2000', maus = 'Bazoo Laser Mouse', jappy = '', facebook = 'http://www.facebook.com/#!/profile.php?id=100000477095092', wkw = '', studivz = '', myspace = '', youtube = 'http://www.youtube.com/IRvDTutorrials', sig = '' WHERE id = 1 Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ profil_edit.php:189 -- db_query(...) @ user.php:26 -- require_once(...) @ index.php:39 -- require_once(...) Wäre cool wenn mir jemand helfen könnte 
lg IRVD betroffene Homepage: www.irvd-website.de artatis - Mein digitales Zuhause | Über mich |
||
| Sunshine Live Mitglied 
Posts: 913  |
ja die user_infos.php
Fürs photoshop wenn nit einfach die datein hier oder bei uns posten dann schaue ich es mir an da musste das einbauen if(!empty($row['photoshop'])){
$photoshop = "<a href=\"".$row['photoshop']."\" target=\"_blank\"><img src=\"include/images/userdetails/photoshop.png\" border=\"0\" /></a>";
} else {
$photoshop = "<img src=\"include/images/userdetails/no_photoshop.png\" border=\"0\" />";
}Meine Page Profilansicht 1.2b Profilansicht 1.2 |
||
| IRvD Mitglied
Posts: 210 |
Du hast den Code für Bilder genommen; )
Wenn ich jetzt nur etwas schreiben möchte, kann ich z.B dies hier if(!empty($row['essen'])){ $essen = $row['essen']; } else { $essen= ""; } einfach unten hinzufügen und essen durch photoshop ersetzten nech`? Ich möchte nämlich das man bei Photoshop die Prozentzahl angibt wie viel Kenntniss man hat
Zuletzt modifiziert von IRvD am 30.03.2011 - 04:18:24 artatis - Mein digitales Zuhause | Über mich |
||
| Sunshine Live Mitglied
Posts: 913 |
Genau dann aber das in jeder dateil
userdetails.php/htm profil edit.php/htm user_info.php/htm und das wird dann aber nit so aussehn ne [img] s1.directupload.net/images/110330/j58dedw3.jpg[/img] Das ist dann nur ein feld wo dann steht Photoshop: 20% Zuletzt modifiziert von Sunshine Live am 30.03.2011 - 11:14:04 Meine Page Profilansicht 1.2b Profilansicht 1.2 |
||
| IRvD Mitglied
Posts: 210 |
Ja klar das es nicht so wie bei DD aussieht weiss ich
^^
eine user_info.htm habe ich irgendwie nich. Hab auch alles geändert geht aber noch nicht. artatis - Mein digitales Zuhause | Über mich |
||
| Sunshine Live Mitglied
Posts: 913 |
ich nab gibs auch nit nur php xD
Meine Page Profilansicht 1.2b Profilansicht 1.2 |
||
| whazza Mitglied 
Posts: 1113  |
Schicke mir doch mal dein Code zu dann kann ich es mir mal anschauen.
--------------------------------------------------- Klein Neue Ansicht |
||
| IRvD Mitglied
Posts: 210 |
Also damit ich nicht das Thema hier in die Länge ziehe habe ich die
include/contents/forum/user_info.php include/contents/forum/user_details.php include/contents/forum/profil_edit.php include/templates/user/userdetails.htm include/templates/user/profil_edit.htm In eine .rar Datei gepackt
Hoffe jemand findet den Fehler
www.irvd-website.de/include/downs/IRvD_Profil.rar artatis - Mein digitales Zuhause | Über mich |
||
| whazza Mitglied
Posts: 1113 |
Du hast in der profil_edit.php unter $abf = 'SELECT photoshop vergessen bei zufügen
--------------------------------------------------- Klein Neue Ansicht |
||
| IRvD Mitglied
Posts: 210 |
Nachdem ich nun das auch bei $abf = 'SELECT hinzugefügt habe, bekomm ich schon ne Fehlermeldung wenn ich nur auf Profileditieren klicke.
Hier die Fehlermeldung: MySQL Error: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql,flash,ilch FROM `ic2_user` WHERE id = "1"' at line 1 in Query: SELECT email,wohnort,homepage,aim,msn,icq,yahoo,avatar,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,geschlecht,spezrank,game,spielerfahrungen,clan,map,waffe,essen,trinken,film,musik,sport,cpu,mainboard,ram,monitor,grafikkarte,soundkarte,festplatte,i_net_verbindung,tastatur,maus,jappy,facebook,wkw,studivz,myspace,youtube,game1,game2,game3,game4,game5,photoshop,html,php,sql,flash,ilch FROM `ic2_user` WHERE id = "1" Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ profil_edit.php:20 -- db_query(...) @ user.php:25 -- require_once(...) @ index.php:36 -- require_once(...) Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/htdocs/ks3520/html/IRvDWebsite/ilch/include/includes/func/db/mysql.php on line 71 artatis - Mein digitales Zuhause | Über mich |
||
| Sunshine Live Mitglied
Posts: 913 |
ansich eig alles richtig nimm ma die profil_edit.php
nur das du hier diesen teil vergesen hast email,wohnort,homepage,aim,msn,icq,yahoo,photoshop,avatar,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,geschlecht,spezrank,game,spielerfahrungen,clan,map,waffe,essen,trinken,film,musik,sport,cpu,mainboard,ram,monitor,grafikkarte,soundkarte,festplatte,i_net_verbindung,tastatur,maus,jappy,facebook,wkw,studivz,myspace,youtube,game1,game2,game3,game4,game5da photoshop einzutragen <?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Users :: Profil';
$hmenu = $extented_forum_menu.'<a class="smalfont" href="?user">Users</a><b> » </b> Profil'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
if ( $_SESSION['authright'] <= -1 ) {
if ( empty ($_POST['submit']) ) {
$design->header();
$abf = 'SELECT email,wohnort,homepage,aim,msn,icq,yahoo,photoshop,avatar,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,geschlecht,spezrank,game,spielerfahrungen,clan,map,waffe,essen,trinken,film,musik,sport,cpu,mainboard,ram,monitor,grafikkarte,soundkarte,festplatte,i_net_verbindung,tastatur,maus,jappy,facebook,wkw,studivz,myspace,youtube,game1,game2,game3,game4,game5 FROM `prefix_user` WHERE id = "'.$_SESSION['authid'].'"';
$erg = db_query($abf);
if ( db_num_rows($erg) > 0 ) {
$row = db_fetch_assoc($erg);
$tpl = new tpl ('user/profil_edit');
$row['staat'] = '<option></option>'.arliste ( $row['staat'] , get_nationality_array() , $tpl , 'staat' );
$row['game1'] = '<option></option>'.arliste ( $row['game1'] , get_nationality_array1() , $tpl , 'game1' );
$row['game2'] = '<option></option>'.arliste ( $row['game2'] , get_nationality_array2() , $tpl , 'game2' );
$row['game3'] = '<option></option>'.arliste ( $row['game3'] , get_nationality_array3() , $tpl , 'game3' );
$row['game4'] = '<option></option>'.arliste ( $row['game4'] , get_nationality_array2() , $tpl , 'game4' );
$row['game5'] = '<option></option>'.arliste ( $row['game5'] , get_nationality_array3() , $tpl , 'game5' );
$row['geschlecht0'] = ( $row['geschlecht'] < 1 ? 'checked' : '' );
$row['geschlecht1'] = ( $row['geschlecht'] == 1 ? 'checked' : '' );
$row['geschlecht2'] = ( $row['geschlecht'] == 2 ? 'checked' : '' );
if ( $row['status'] == 1 ) { $row['status1'] = 'checked'; $row['status0'] = ''; } else { $row['status1'] = ''; $row['status0'] = 'checked'; }
if ( $row['opt_mail'] == 1 ) { $row['opt_mail1'] = 'checked'; $row['opt_mail0'] = ''; } else { $row['opt_mail1'] = ''; $row['opt_mail0'] = 'checked'; }
if ( $row['opt_pm'] == 1 ) { $row['opt_pm1'] = 'checked'; $row['opt_pm0'] = ''; } else { $row['opt_pm1'] = ''; $row['opt_pm0'] = 'checked'; }
if ( $row['opt_pm_popup'] == 1 ) { $row['opt_pm_popup1'] = 'checked'; $row['opt_pm_popup0'] = ''; } else { $row['opt_pm_popup1'] = ''; $row['opt_pm_popup0'] = 'checked'; }
$row['avatarbild'] = ( file_exists ( $row['avatar'] ) ? '<img src="'.$row['avatar'].'" alt=""><br />' : '' );
$row['Fabreite'] = $allgAr['Fabreite'];
$row['Fahohe'] = $allgAr['Fahohe'];
$row['Fasize'] = $allgAr['Fasize'];
$row['forum_max_sig'] = $allgAr['forum_max_sig'];
$row['uid'] = $_SESSION['authid'];
$row['forum_usergallery'] = $allgAr['forum_usergallery'];
$tpl->set_ar_out($row,0);
if ($allgAr['forum_avatar_upload']) $tpl->out(1);
$tpl->set_ar_out($row,2);
profilefields_change ( $_SESSION['authid'] );
$tpl->out(3);
} else {
$tpl = new tpl ( 'user/login.htm' );
$tpl->set_out('WDLINK','index.php',0);
}
} else { # submit
# change poassword
if ( !empty($_POST['np1']) AND !empty($_POST['np2']) AND !empty($_POST['op'])) {
if ($_POST['np1'] == $_POST['np2']) {
$akpw = db_result(db_query("SELECT pass FROM prefix_user WHERE id = ".$_SESSION['authid']),0);
if ($akpw == md5($_POST['op'])) {
$newpw = md5($_POST['np1']);
db_query("UPDATE prefix_user SET pass = '".$newpw."' WHERE id = ".$_SESSION['authid']);
setcookie(session_und_cookie_name(), $_SESSION['authid'].'='.$newpw, time() + 31104000, "/" );
$fmsg = $lang['passwortchanged'];
} else {
$fmsg = $lang['passwortwrong'];
}
} else {
$fmsg = $lang['passwortnotequal'];
}
}
# avatar speichern START
$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 = '',";
}
# avatar speichern ENDE
# email aendern
if ($_POST['email'] != $_POST['aemail']) {
$id = $_SESSION['authid'].'||'.md5 (uniqid (rand()));
db_query("INSERT INTO prefix_usercheck (`check`,email,datime,ak)
VALUES ('".$id."','".escape($_POST['email'],'string')."',NOW(),3)");
$page = $_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"];
$text = $lang['changedthemail'] . sprintf ($lang['registconfirmlink'], $page, $id );
icmail ($_POST['email'], $lang['mail'].' '.$lang['changed'], $text );
$fmsg = $lang['pleaseconfirmmail'];
}
#
#remove account
if (isset($_POST['removeaccount'])) {
$id = $_SESSION['authid'].'-remove-'.md5 (uniqid (rand()));
db_query("INSERT INTO prefix_usercheck (`check`,email,datime,ak)
VALUES ('".$id."','".escape($_POST['email'],'string')."',NOW(),5)");
$page = $_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"];
$text = $lang['removeconfirm'] . sprintf ($lang['registconfirmlink'], $page, $id );
icmail ($_POST['email'], html_entity_decode($lang['removeaccount']), $text );
$fmsg = $lang['pleaseconfirmremove'];
}
#remove account
# statische felder speichern
db_query("UPDATE prefix_user
SET
homepage = '".get_homepage(escape($_POST['homepage'], 'string'))."',
wohnort = '".escape($_POST['wohnort'], 'string')."',
icq = '".escape($_POST['icq'], 'string')."',
msn = '".escape($_POST['msn'], 'string')."',
yahoo = '".escape($_POST['yahoo'], 'string')."',
".$avatar_sql_update."
aim = '".escape($_POST['aim'], 'string')."',
staat = '".escape($_POST['staat'], 'string')."',
game1 = '".escape($_POST['game1'], 'string')."',
game2 = '".escape($_POST['game2'], 'string')."',
game3 = '".escape($_POST['game3'], 'string')."',
game4 = '".escape($_POST['game4'], 'string')."',
game5 = '".escape($_POST['game5'], 'string')."',
geschlecht = '".escape($_POST['geschlecht'], 'string')."',
status = '".escape($_POST['status'], 'string')."',
opt_mail = '".escape($_POST['opt_mail'], 'string')."',
opt_pm = '".escape($_POST['opt_pm'], 'string')."',
opt_pm_popup = '".escape($_POST['opt_pm_popup'], 'string')."',
gebdatum = '".get_datum(escape($_POST['gebdatum'], 'string'))."',
game = '".escape($_POST['game'], 'string')."',
spielerfahrungen = '".escape($_POST['spielerfahrungen'], 'string')."',
clan = '".escape($_POST['clan'], 'string')."',
map = '".escape($_POST['map'], 'string')."',
waffe = '".escape($_POST['waffe'], 'string')."',
essen = '".escape($_POST['essen'], 'string')."',
photoshop = '".escape($_POST['photoshop'], 'string')."',
html = '".escape($_POST['html'], 'string')."',
php = '".escape($_POST['php'], 'string')."',
sql = '".escape($_POST['sql'], 'string')."',
flash = '".escape($_POST['flash'], 'string')."',
ilch = '".escape($_POST['ilch'], 'string')."',
trinken = '".escape($_POST['trinken'], 'string')."',
film = '".escape($_POST['film'], 'string')."',
musik = '".escape($_POST['musik'], 'string')."',
sport = '".escape($_POST['sport'], 'string')."',
cpu = '".escape($_POST['cpu'], 'string')."',
mainboard = '".escape($_POST['mainboard'], 'string')."',
ram = '".escape($_POST['ram'], 'string')."',
monitor = '".escape($_POST['monitor'], 'string')."',
grafikkarte = '".escape($_POST['grafikkarte'], 'string')."',
soundkarte = '".escape($_POST['soundkarte'], 'string')."',
festplatte = '".escape($_POST['festplatte'], 'string')."',
i_net_verbindung = '".escape($_POST['i_net_verbindung'], 'string')."',
tastatur = '".escape($_POST['tastatur'], 'string')."',
maus = '".escape($_POST['maus'], 'string')."',
jappy = '".get_homepage(escape($_POST['jappy'], 'string'))."',
facebook = '".get_homepage(escape($_POST['facebook'], 'string'))."',
wkw = '".get_homepage(escape($_POST['wkw'], 'string'))."',
studivz = '".get_homepage(escape($_POST['studivz'], 'string'))."',
myspace = '".get_homepage(escape($_POST['myspace'], 'string'))."',
youtube = '".get_homepage(escape($_POST['youtube'], 'string'))."',
sig = '".substr(escape($_POST['sig'], 'string'),0,$allgAr['forum_max_sig'])."'
WHERE id = ".$_SESSION['authid']
);
# change other profil fields
profilefields_change_save ( $_SESSION['authid'] );
$design->header();
# definie and print msg
$fmsg = ( isset($fmsg) ? $fmsg : $lang['changesuccessful'] );
wd('?user-8' , $fmsg , 3 );
}
} else {
$tpl = new tpl ( 'user/login' );
$tpl->set_out('WDLINK', '?user-8', 0);
}
$design->footer();
?>
Zuletzt modifiziert von Sunshine Live am 31.03.2011 - 22:13:05 Meine Page Profilansicht 1.2b Profilansicht 1.2 |
||
| IRvD Mitglied
Posts: 210 |
Hm. also Photoshop scheint zu funktionieren.
Nun habe ich aber noch 5 weitere Proflfelder wie z.B HTML, PHP, SQL, FLASh, ILCH Wenn ich diese einfach hinter den photoshop schreibe, bekomm ich aber wieder einen Fehlermeldung. Verstehe einfach nicht was ich falsch mache ey. Bin sonst nicht so schwer von begriff! artatis - Mein digitales Zuhause | Über mich |
||
| whazza Mitglied
Posts: 1113 |
Mache dir das nachher Fertig wenn Sunshine Live es dann nicht schon gemacht hat.
--------------------------------------------------- Klein Neue Ansicht |
||
| Sunshine Live Mitglied
Posts: 913 |
So habe es mal fertig gemacht...
so schaut es aus ne www.tkg-spielplatz.de/ilch/index.php?user-details-1 Du musst nur eins machen und zwar in deiner Datenbank in Tabelle ic1_user aus sql datenbank zu machen. Er macht probleme mit sql ich weiß auch nit warum. Aber troztdem hier die datein: profil_edit.php <?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Users :: Profil';
$hmenu = $extented_forum_menu.'<a class="smalfont" href="?user">Users</a><b> » </b> Profil'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
if ( $_SESSION['authright'] <= -1 ) {
if ( empty ($_POST['submit']) ) {
$design->header();
$abf = 'SELECT email,wohnort,homepage,aim,msn,icq,yahoo,avatar,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,datenbank,geschlecht,spezrank,game,spielerfahrungen,clan,map,waffe,essen,trinken,film,musik,sport,cpu,ilch,datenbank,flash,html,php,photoshop,mainboard,ram,monitor,grafikkarte,soundkarte,festplatte,i_net_verbindung,tastatur,maus,jappy,facebook,wkw,studivz,myspace,youtube,game1,game2,game3,game4,game5 FROM `prefix_user` WHERE id = "'.$_SESSION['authid'].'"';
$erg = db_query($abf);
if ( db_num_rows($erg) > 0 ) {
$row = db_fetch_assoc($erg);
$tpl = new tpl ('user/profil_edit');
$row['staat'] = '<option></option>'.arliste ( $row['staat'] , get_nationality_array() , $tpl , 'staat' );
$row['game1'] = '<option></option>'.arliste ( $row['game1'] , get_nationality_array1() , $tpl , 'game1' );
$row['game2'] = '<option></option>'.arliste ( $row['game2'] , get_nationality_array2() , $tpl , 'game2' );
$row['game3'] = '<option></option>'.arliste ( $row['game3'] , get_nationality_array3() , $tpl , 'game3' );
$row['game4'] = '<option></option>'.arliste ( $row['game4'] , get_nationality_array2() , $tpl , 'game4' );
$row['game5'] = '<option></option>'.arliste ( $row['game5'] , get_nationality_array3() , $tpl , 'game5' );
$row['geschlecht0'] = ( $row['geschlecht'] < 1 ? 'checked' : '' );
$row['geschlecht1'] = ( $row['geschlecht'] == 1 ? 'checked' : '' );
$row['geschlecht2'] = ( $row['geschlecht'] == 2 ? 'checked' : '' );
if ( $row['status'] == 1 ) { $row['status1'] = 'checked'; $row['status0'] = ''; } else { $row['status1'] = ''; $row['status0'] = 'checked'; }
if ( $row['opt_mail'] == 1 ) { $row['opt_mail1'] = 'checked'; $row['opt_mail0'] = ''; } else { $row['opt_mail1'] = ''; $row['opt_mail0'] = 'checked'; }
if ( $row['opt_pm'] == 1 ) { $row['opt_pm1'] = 'checked'; $row['opt_pm0'] = ''; } else { $row['opt_pm1'] = ''; $row['opt_pm0'] = 'checked'; }
if ( $row['opt_pm_popup'] == 1 ) { $row['opt_pm_popup1'] = 'checked'; $row['opt_pm_popup0'] = ''; } else { $row['opt_pm_popup1'] = ''; $row['opt_pm_popup0'] = 'checked'; }
$row['avatarbild'] = ( file_exists ( $row['avatar'] ) ? '<img src="'.$row['avatar'].'" alt=""><br />' : '' );
$row['Fabreite'] = $allgAr['Fabreite'];
$row['Fahohe'] = $allgAr['Fahohe'];
$row['Fasize'] = $allgAr['Fasize'];
$row['forum_max_sig'] = $allgAr['forum_max_sig'];
$row['uid'] = $_SESSION['authid'];
$row['forum_usergallery'] = $allgAr['forum_usergallery'];
$tpl->set_ar_out($row,0);
if ($allgAr['forum_avatar_upload']) $tpl->out(1);
$tpl->set_ar_out($row,2);
profilefields_change ( $_SESSION['authid'] );
$tpl->out(3);
} else {
$tpl = new tpl ( 'user/login.htm' );
$tpl->set_out('WDLINK','index.php',0);
}
} else { # submit
# change poassword
if ( !empty($_POST['np1']) AND !empty($_POST['np2']) AND !empty($_POST['op'])) {
if ($_POST['np1'] == $_POST['np2']) {
$akpw = db_result(db_query("SELECT pass FROM prefix_user WHERE id = ".$_SESSION['authid']),0);
if ($akpw == md5($_POST['op'])) {
$newpw = md5($_POST['np1']);
db_query("UPDATE prefix_user SET pass = '".$newpw."' WHERE id = ".$_SESSION['authid']);
setcookie(session_und_cookie_name(), $_SESSION['authid'].'='.$newpw, time() + 31104000, "/" );
$fmsg = $lang['passwortchanged'];
} else {
$fmsg = $lang['passwortwrong'];
}
} else {
$fmsg = $lang['passwortnotequal'];
}
}
# avatar speichern START
$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 = '',";
}
# avatar speichern ENDE
# email aendern
if ($_POST['email'] != $_POST['aemail']) {
$id = $_SESSION['authid'].'||'.md5 (uniqid (rand()));
db_query("INSERT INTO prefix_usercheck (`check`,email,datime,ak)
VALUES ('".$id."','".escape($_POST['email'],'string')."',NOW(),3)");
$page = $_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"];
$text = $lang['changedthemail'] . sprintf ($lang['registconfirmlink'], $page, $id );
icmail ($_POST['email'], $lang['mail'].' '.$lang['changed'], $text );
$fmsg = $lang['pleaseconfirmmail'];
}
#
#remove account
if (isset($_POST['removeaccount'])) {
$id = $_SESSION['authid'].'-remove-'.md5 (uniqid (rand()));
db_query("INSERT INTO prefix_usercheck (`check`,email,datime,ak)
VALUES ('".$id."','".escape($_POST['email'],'string')."',NOW(),5)");
$page = $_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"];
$text = $lang['removeconfirm'] . sprintf ($lang['registconfirmlink'], $page, $id );
icmail ($_POST['email'], html_entity_decode($lang['removeaccount']), $text );
$fmsg = $lang['pleaseconfirmremove'];
}
#remove account
# statische felder speichern
db_query("UPDATE prefix_user
SET
homepage = '".get_homepage(escape($_POST['homepage'], 'string'))."',
wohnort = '".escape($_POST['wohnort'], 'string')."',
icq = '".escape($_POST['icq'], 'string')."',
msn = '".escape($_POST['msn'], 'string')."',
yahoo = '".escape($_POST['yahoo'], 'string')."',
".$avatar_sql_update."
aim = '".escape($_POST['aim'], 'string')."',
staat = '".escape($_POST['staat'], 'string')."',
game1 = '".escape($_POST['game1'], 'string')."',
game2 = '".escape($_POST['game2'], 'string')."',
game3 = '".escape($_POST['game3'], 'string')."',
game4 = '".escape($_POST['game4'], 'string')."',
game5 = '".escape($_POST['game5'], 'string')."',
geschlecht = '".escape($_POST['geschlecht'], 'string')."',
status = '".escape($_POST['status'], 'string')."',
opt_mail = '".escape($_POST['opt_mail'], 'string')."',
opt_pm = '".escape($_POST['opt_pm'], 'string')."',
opt_pm_popup = '".escape($_POST['opt_pm_popup'], 'string')."',
gebdatum = '".get_datum(escape($_POST['gebdatum'], 'string'))."',
game = '".escape($_POST['game'], 'string')."',
spielerfahrungen = '".escape($_POST['spielerfahrungen'], 'string')."',
clan = '".escape($_POST['clan'], 'string')."',
map = '".escape($_POST['map'], 'string')."',
waffe = '".escape($_POST['waffe'], 'string')."',
essen = '".escape($_POST['essen'], 'string')."',
trinken = '".escape($_POST['trinken'], 'string')."',
photoshop = '".escape($_POST['photoshop'], 'string')."',
html = '".escape($_POST['html'], 'string')."',
php = '".escape($_POST['php'], 'string')."',
flash = '".escape($_POST['flash'], 'string')."',
ilch = '".escape($_POST['ilch'], 'string')."',
film = '".escape($_POST['film'], 'string')."',
musik = '".escape($_POST['musik'], 'string')."',
sport = '".escape($_POST['sport'], 'string')."',
cpu = '".escape($_POST['cpu'], 'string')."',
mainboard = '".escape($_POST['mainboard'], 'string')."',
ram = '".escape($_POST['ram'], 'string')."',
monitor = '".escape($_POST['monitor'], 'string')."',
grafikkarte = '".escape($_POST['grafikkarte'], 'string')."',
soundkarte = '".escape($_POST['soundkarte'], 'string')."',
datenbank = '".escape($_POST['datenbank'], 'string')."',
festplatte = '".escape($_POST['festplatte'], 'string')."',
i_net_verbindung = '".escape($_POST['i_net_verbindung'], 'string')."',
tastatur = '".escape($_POST['tastatur'], 'string')."',
maus = '".escape($_POST['maus'], 'string')."',
jappy = '".get_homepage(escape($_POST['jappy'], 'string'))."',
facebook = '".get_homepage(escape($_POST['facebook'], 'string'))."',
wkw = '".get_homepage(escape($_POST['wkw'], 'string'))."',
studivz = '".get_homepage(escape($_POST['studivz'], 'string'))."',
myspace = '".get_homepage(escape($_POST['myspace'], 'string'))."',
youtube = '".get_homepage(escape($_POST['youtube'], 'string'))."',
sig = '".substr(escape($_POST['sig'], 'string'),0,$allgAr['forum_max_sig'])."'
WHERE id = ".$_SESSION['authid']
);
# change other profil fields
profilefields_change_save ( $_SESSION['authid'] );
$design->header();
# definie and print msg
$fmsg = ( isset($fmsg) ? $fmsg : $lang['changesuccessful'] );
wd('?user-8' , $fmsg , 3 );
}
} else {
$tpl = new tpl ( 'user/login' );
$tpl->set_out('WDLINK', '?user-8', 0);
}
$design->footer();
?>
user_details.php <?php
# Copyright by: Manuel Staechele
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$uid = $menu->get(2);
#Award Ausgabe
$awards = ''; $ax = 0;
$sqlA = db_query("SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = ".$uid." ORDER BY `time` ASC");
while($rowA = db_fetch_assoc($sqlA))
{
$ax++; if ($ax == 8) {$awards .= "<br>"; $ax = 0;}
$awards .= (!empty($rowA['bild']) ? '<img style="padding:1px;border:0px;" src="'.$rowA['bild'].'" alt="'.$rowA['wofur'].'" title="'.$rowA['wofur'].'"/>' : $rowA['wofur']);
}
$awards = '<b><b><br><div style="text-align:center;">'.$awards.'</div>';
$lastbes_anz = 5; //Bei höhere Anzahl muss ggf. in der Datenbank die Größe der Felder bzw der Typ geändert werden
if ($_SESSION['authid'] != $uid AND $_SESSION['authid'] != 0) {
$lb = db_fetch_object(db_query('SELECT last_bes, last_user_time FROM prefix_user WHERE id = '.$uid));
$lba = explode('#',$lb->last_bes);
$lbt = explode('#',$lb->last_user_time);
$i = array_search($_SESSION['authid'],$lba);
if ($i !== false) {
unset($lba[$i]); unset($lbt[$i]);
} elseif (count($lba) >= $lastbes_anz) {
$lba = array_slice($lba,0,$lastbes_anz-1);
$lbt = array_slice($lbt,0,$lastbes_anz-1);
}
array_unshift($lba,$_SESSION['authid']);
array_unshift($lbt,time());
$i_lb = implode('#',$lba);
$i_lbt = implode('#',$lbt);
db_query("UPDATE prefix_user SET last_bes = '$i_lb', last_user_time = '$i_lbt' WHERE id = $uid");
}
include('user_infos.php');
$abf8 = "SELECT * FROM prefix_online WHERE uid = '".$uid."'";
$erg8 = db_query($abf8);
$row8 = db_fetch_assoc($erg8);
if(isset($row8['uid'])){
$online = '<img src="include/images/icons/uonline.gif" alt="online" border="0"/>';
}else{
$online = '<img src="include/images/icons/uoffline.gif" alt="offline" border="0" />';
}
$ar = array (
'UID' => $uid,
'NAME' => $row['name'],
'JOINED' => date('d.m.Y',$row['regist']),
'LASTAK' => date('d.m.Y - H:i',$row['llogin']),
'POSTS' => $row['posts'],
'postpday' => $postpday,
'RANG' => userrang ($row['posts'],$uid),
'AVATA' => $avatar,
'LASTUSER' => last_user($uid),
'STATUS2' => $online,
'USERTITEL' => $usertitel,
'EMAIL' => $email,
'HOMEPAGE' => $homepage,
'GESCHLECHT' => $geschlecht,
'GEBDATUM' => $gebdatum,
'ALTER' => $alter,
'WOHNORT' => $wohnort,
'FORUMTOPICS' => $row4['forumtopics'],
'NEWSTOPICS' => $row5['newstopics'],
'NEWSPOSTS' => $row6['newsposts'],
'FORUMPOSTS' => $row7['forumposts'],
'SIGNATUR' => bbcode($row['sig']),
'STAAT' => $staat,
'GAME1' => $game1,
'GAME2' => $game2,
'GAME3' => $game3,
'GAME4' => $game4,
'GAME5' => $game5,
'UID' => $uid,
'STERNZEICHEN' => $sternzeichen,
'GB_EINTRAEGE' => $gb_eintraege,
'GALLERIE_EINTRAEGE' => $gallery_eintraege,
'ICQ' => $icq,
'GAME' => $game,
'SPIELERFAHRUNG' => $spielerfahrungen,
'CLAN' => $clan,
'MAP' => $map,
'WAFFE' => $waffe,
'ESSEN' => $essen,
'PHOTOSHOP' => $photoshop,
'HTML' => $html,
'PHP' => $php,
'DATENBANK' => $datenbank,
'FLASH' => $flash,
'ILCH' => $ilch,
'TRINKEN' => $trinken,
'FILM' => $film,
'MUSIK' => $musik,
'SPORT' => $sport,
'CPU' => $cpu,
'MAINBOARD' => $mainboard,
'RAM' => $ram,
'MONITOR' => $monitor,
'GRAFIKKARTE' => $grafikkarte,
'SOUNDKARTE' => $soundkarte,
'FESTPLATTE' => $festplatte,
'I_NET_VERBINDUNG' => $i_net_verbindung,
'TASTATUR' => $tastatur,
'MAUS' => $maus,
'JAPPY' => $jappy,
'FACEBOOK' => $facebook,
'WKW' => $wkw,
'STUDIVZ' => $studivz,
'MYSPACE' => $myspace,
'YOUTUBE' => $youtube,
'AWARDS' => $awards,
);
$title = $allgAr['title'].' :: Users :: Details von '.$row['name'];
$hmenu = $extented_forum_menu.'<a class="smalfont" href="?user">Users</a><b> » </b> <a href=index.php?user-details-'.$uid.'>Details von '.$row['name']."</a>".$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
$tpl = new tpl ( 'user/userdetails' );
$l = profilefields_show ( $uid );
$ar['rowspan'] = 4 + substr_count($l, '<tr><td class="');
$ar['profilefields'] = $l;
$tpl->set_ar_out($ar,0);
$design->footer();
?>
user_infos.php <?php
$abf = 'SELECT * FROM prefix_user WHERE id = "'.$uid.'"';
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
$user_name = $row['name'];
$abf2 = "SELECT * FROM prefix_online";
$erg2 = db_query($abf2);
$row2 = db_fetch_assoc($erg2);
$recht = $row['recht'];
$abf3 = "SELECT * FROM prefix_grundrechte WHERE id = ".$recht."";
$erg3 = db_query($abf3);
$row3 = db_fetch_assoc($erg3);
$abf4 = "SELECT COUNT(*) AS forumtopics FROM prefix_topics WHERE erst = '$user_name'";
$erg4 = db_query($abf4);
$row4 = db_fetch_assoc($erg4);
$abf5 = "SELECT COUNT(*) AS newstopics FROM prefix_news WHERE user_id = ".$uid."";
$erg5 = db_query($abf5);
$row5 = db_fetch_assoc($erg5);
$abf6 = "SELECT COUNT(*) AS newsposts FROM prefix_koms WHERE name = '$user_name'";
$erg6 = db_query($abf6);
$row6 = db_fetch_assoc($erg6);
$abf7 = "SELECT COUNT(*) AS newsposts FROM prefix_koms WHERE name = '$user_name'";
$erg7 = db_query($abf7);
$row7 = db_fetch_assoc($erg7);
if(file_exists("include/contents/user/user_gb.php")){
$abf8 = "SELECT COUNT(*) AS gb_eintraege FROM prefix_usergb WHERE uid = ".$uid."";
$erg8 = db_query($abf8);
$row8 = db_fetch_assoc($erg8);
if($row8['gb_eintraege'] == 0 ){
$gb_eintraege = "keine Einträge (<a href=\"index.php?user-usergb-view-".$uid."\">eintragen</a>)";
}elseif($row8['gb_eintraege'] == 1 ){
$gb_eintraege = "1 Eintrag (<a href=\"index.php?user-usergb-view-".$uid."\">eintragen</a>)";
}else{
$gb_eintraege = $row8['gb_eintraege']." Einträge";
}
} else {
$gb_eintraege = "Kein Gästebuch vorhanden";
}
$abf9 = "SELECT COUNT(*) AS gallery_eintraege FROM prefix_usergallery WHERE uid = ".$uid."";
$erg9 = db_query($abf9);
$row9 = db_fetch_assoc($erg9);
if(!empty($row['icq'])){
$icq = "<a href=\"http://www.icq.com/people/".$row['icq']."\" target=\"_blank\"><img src=\"http://status.icq.com/online.gif?icq=".$row['icq']."&img=5\" border=\"0\"></a>";
}else{
$icq = "keine Angabe";
}
if($row9['gallery_eintraege'] == 0){
$gallery_eintraege = "keine Bilder";
}elseif($row9['gallery_eintraege'] == 1){
$gallery_eintraege = "1 Bild vorhanden";
} else {
$gallery_eintraege = $row9['gallery_eintraege']." Bilder";
}
if(!empty($row['email']) && $row['opt_mail'] == 1){
$email = "<a href=\"mailto:".$row['email']."\"><img src=\"include/images/icons/email_icon.png\" border=\"0\" /></a>";
}elseif(!empty($row['email']) && $row['opt_mail'] == 0){
$email = "<img src=\"include/images/icons/email_icon.png\" border=\"0\" /></a>";
} else {
$email = "<img src=\"include/images/icons/no_email_icon.png\" border=\"0\" />";
}
if(!empty($row['homepage'])){
$homepage = "<a href=\"".$row['homepage']."\" target=\"_blank\"><img src=\"include/images/icons/website_icon.png\" border=\"0\" /></a>";
} else {
$homepage = "<img src=\"include/images/icons/no_website_icon.png\" border=\"0\" />";
}
if(!empty($row['jappy'])){
$jappy = "<a href=\"".$row['jappy']."\" target=\"_blank\"><img src=\"include/images/userdetails/jappy.png\" border=\"0\" /></a>";
} else {
$jappy = "<img src=\"include/images/userdetails/no_jappy.png\" border=\"0\" />";
}
if(!empty($row['facebook'])){
$facebook = "<a href=\"".$row['facebook']."\" target=\"_blank\"><img src=\"include/images/userdetails/facebook.png\" border=\"0\" /></a>";
} else {
$facebook = "<img src=\"include/images/userdetails/no_facebook.png\" border=\"0\" />";
}
if(!empty($row['wkw'])){
$wkw = "<a href=\"".$row['wkw']."\" target=\"_blank\"><img src=\"include/images/userdetails/wkw.png\" border=\"0\" /></a>";
} else {
$wkw = "<img src=\"include/images/userdetails/no_wkw.png\" border=\"0\" />";
}
if(!empty($row['studivz'])){
$studivz = "<a href=\"".$row['studivz']."\" target=\"_blank\"><img src=\"include/images/userdetails/studivz.png\" border=\"0\" /></a>";
} else {
$studivz = "<img src=\"include/images/userdetails/no_studivz.png\" border=\"0\" />";
}
if(!empty($row['myspace'])){
$myspace = "<a href=\"".$row['myspace']."\" target=\"_blank\"><img src=\"include/images/userdetails/myspace.png\" border=\"0\" /></a>";
} else {
$myspace = "<img src=\"include/images/userdetails/no_myspace.png\" border=\"0\" />";
}
if(!empty($row['youtube'])){
$youtube = "<a href=\"".$row['youtube']."\" target=\"_blank\"><img src=\"include/images/userdetails/youtube.png\" border=\"0\" /></a>";
} else {
$youtube = "<img src=\"include/images/userdetails/no_youtube.png\" border=\"0\" />";
}
if(!empty($row['staat'])){
$staat = "<img src=\"include/images/flags/".$row['staat']."\" border=\"0\" />";
} else {
$staat = "";
}
if(!empty($row['game1'])){
$game1 = "<img src=\"include/images/game_icon/".$row['game1']."\" border=\"0\" />";
} else {
$game1 = "";
}
if(!empty($row['game2'])){
$game2 = "<img src=\"include/images/game_icon/".$row['game2']."\" border=\"0\" />";
} else {
$game2 = "";
}
if(!empty($row['game3'])){
$game3 = "<img src=\"include/images/game_icon/".$row['game3']."\" border=\"0\" />";
} else {
$game3 = "";
}
if(!empty($row['game4'])){
$game4 = "<img src=\"include/images/game_icon/".$row['game4']."\" border=\"0\" />";
} else {
$game4 = "";
}
if(!empty($row['game5'])){
$game5 = "<img src=\"include/images/game_icon/".$row['game5']."\" border=\"0\" />";
} else {
$game5 = "";
}
$avatar = '';
if (file_exists($row['avatar'])) {
$avatar = '<img src="'.$row['avatar'].'" align="center" border="0">';
} elseif ($row['avatar'] == "" && $row['geschlecht'] == "1") {
$avatar = '<img src="include/images/avatars/male.png" align="center" border="0">';
} elseif ($row['avatar'] == "" && $row['geschlecht'] == "2") {
$avatar = '<img src="include/images/avatars/female.png" align="center" border="0">';
} else {
$avatar = '<img src="include/images/avatars/wurstegal.png" align="center" border="0">';
}
$regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') ) - $row['regist'];
$regday = round($regsek / 86400);
$postpday = ( $regday == 0 ? 0 : round($row['posts'] / $regday, 2 ) );
$usertitel = $row3['name'];
if($row2['uid'] == $uid){
$online = "<b>online</b>";
}else{
$online = "<b>offline</b>";
}
if($row['geschlecht'] == 1){
$geschlecht = "männlich";
}elseif($row['geschlecht'] == 2){
$geschlecht = "weiblich";
}else{
$geschlecht = "unentschlossen";
}
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 = "Kein Datum angegeben";
$alter = "";
}
function Sternzeichen($t,$m,$j) {
$tag = date("d",mktime(0,0,0,$m,$t,$j));
$monat = date("n",mktime(0,0,0,$m,$t,$j));
if ($tag > 20 && $monat == 3 || $tag < 21 && $monat == 4) {
$zeichen = "Widder";
}
if ($tag > 20 && $monat == 4 || $tag < 21 && $monat == 5) {
$zeichen = "Stier";
}
if ($tag > 20 && $monat == 5 || $tag < 22 && $monat == 6) {
$zeichen = "Zwillige";
}
if ($tag > 21 && $monat == 6 || $tag < 23 && $monat == 7) {
$zeichen = "Krebs)";
}
if ($tag > 22 && $monat == 7 || $tag < 24 && $monat == 8) {
$zeichen = "Löwe";
}
if ($tag > 23 && $monat == 8 || $tag < 24 && $monat == 9) {
$zeichen = "Jungfrau";
}
if ($tag > 23 && $monat == 9 || $tag < 24 && $monat == 10) {
$zeichen = "Waage";
}
if ($tag > 23 && $monat == 10 || $tag < 23 && $monat == 11) {
$zeichen = "Skorpion";
}
if ($tag > 22 && $monat == 11 || $tag < 22 && $monat == 12) {
$zeichen = "Schütze";
}
if ($tag > 21 && $monat == 12 || $tag < 21 && $monat == 1) {
$zeichen = "Steinbock";
}
if ($tag > 20 && $monat == 1 || $tag < 20 && $monat == 2) {
$zeichen = "Wassermann";
}
if ($tag > 19 && $monat == 2 || $tag < 21 && $monat == 3) {
$zeichen = "Fische";
}
return "$zeichen";
}
if($row['gebdatum'] !== "0000-00-00"){
$sternzeichen = Sternzeichen($tag,$monat,$jahr);
} else {
$sternzeichen = "Unbekannt";
}
if(!empty($row['wohnort'])){
$wohnort = $row['wohnort'];
} else {
$wohnort = "Keine Angabe";
}
if(!empty($row['game'])){
$game = $row['game'];
} else {
$game= "";
}
if(!empty($row['spielerfahrungen'])){
$spielerfahrungen = $row['spielerfahrungen'];
} else {
$spielerfahrungen= "";
}
if(!empty($row['clan'])){
$clan = $row['clan'];
} else {
$clan= "";
}
if(!empty($row['map'])){
$map = $row['map'];
} else {
$map= "";
}
if(!empty($row['waffe'])){
$waffe = $row['waffe'];
} else {
$waffe= "";
}
if(!empty($row['essen'])){
$essen = $row['essen'];
} else {
$essen= "";
}
if(!empty($row['trinken'])){
$trinken = $row['trinken'];
} else {
$trinken= "";
}
if(!empty($row['film'])){
$film = $row['film'];
} else {
$film= "";
}
if(!empty($row['musik'])){
$musik = $row['musik'];
} else {
$musik= "";
}
if(!empty($row['sport'])){
$sport = $row['sport'];
} else {
$sport= "";
}
if(!empty($row['cpu'])){
$cpu = $row['cpu'];
} else {
$cpu= "";
}
if(!empty($row['mainboard'])){
$mainboard = $row['mainboard'];
} else {
$mainboard= "";
}
if(!empty($row['ram'])){
$ram = $row['ram'];
} else {
$ram= "";
}
if(!empty($row['monitor'])){
$monitor = $row['monitor'];
} else {
$monitor= "";
}
if(!empty($row['grafikkarte'])){
$grafikkarte = $row['grafikkarte'];
} else {
$grafikkarte= "";
}
if(!empty($row['soundkarte'])){
$soundkarte = $row['soundkarte'];
} else {
$soundkarte= "";
}
if(!empty($row['festplatte'])){
$festplatte = $row['festplatte'];
} else {
$festplatte= "";
}
if(!empty($row['i_net_verbindung'])){
$i_net_verbindung = $row['i_net_verbindung'];
} else {
$i_net_verbindung= "";
}
if(!empty($row['tastatur'])){
$tastatur = $row['tastatur'];
} else {
$tastatur= "";
}
if(!empty($row['maus'])){
$maus = $row['maus'];
} else {
$maus= "";
}
if(!empty($row['photoshop'])){
$photoshop = $row['photoshop'];
} else {
$photoshop= "";
}
if(!empty($row['html'])){
$html = $row['html'];
} else {
$html= "";
}
if(!empty($row['php'])){
$php = $row['php'];
} else {
$php= "";
}
if(!empty($row['datenbank'])){
$datenbank = $row['datenbank'];
} else {
$datenbank= "";
}
if(!empty($row['flash'])){
$flash = $row['flash'];
} else {
$flash= "";
}
if(!empty($row['ilch'])){
$ilch = $row['ilch'];
} else {
$ilch= "";
}
?>
profil_edit.htm <form action="index.php?user-profil" method="POST" enctype="multipart/form-data">
<fieldset>
<legend>Persönliche Daten ändern</legend>
<br />
<label style="float:left; width:35%;">{_lang_mail}</label><input style="margin-bottom:2px;" name="email" value="{email}" /><input type="hidden" name="aemail" value="{email}" /><font class="smalfont">{_lang_mustbeentered}</font><br />
<label style="float:left; width:35%;">{_lang_homepage}</label><input style="margin-bottom:2px;" name="homepage" value="{homepage}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_hometown}</label><input style="margin-bottom:2px;" name="wohnort" value="{wohnort}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_icq}</label><input style="margin-bottom:2px;" name="icq" value="{icq}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_msn}</label><input style="margin-bottom:2px;" name="msn" value="{msn}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_birthday}</label><input style="margin-bottom:2px;" name="gebdatum" value="{gebdatum}" /><font class="smalfont">{_lang_dateformat}</font><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_state}</label><select style="margin-bottom:2px;" name="staat">{_list_staat@<option%1 value="%2">%3</option>}</select><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_sex}</label><input style="margin-bottom:2px;" type="radio" value="1" id="geschlecht1" name="geschlecht" {geschlecht1} /><label for="geschlecht1"> {_lang_male}</label>, <input id="geschlecht2" type="radio" value="2" name="geschlecht" {geschlecht2} /><label for="geschlecht2"> {_lang_female}</label>, <input id="geschlecht0" type="radio" value="0" name="geschlecht" {geschlecht0} /><label for="geschlecht0"> {_lang_itdoesntmatter}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_status}</label><input id="status_aktiv" type="radio" value="1" name="status" {status1} /><label for="status_aktiv"> {_lang_active}</label>, <input id="status_inaktiv" type="radio" value="0" name="status" {status0} /><label for="status_inaktiv"> {_lang_inactive}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_mails}<span class="smalfont"> {_lang_fromotherusers}?</span></label><input id="opt_mail1" type="radio" value="1" name="opt_mail" {opt_mail1} /><label for="opt_mail1"> {_lang_yes}</label>, <input id="opt_mail0" type="radio" value="0" name="opt_mail" {opt_mail0} /><label for="opt_mail0"> {_lang_no}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_privatemessages}<span class="smalfont"> {_lang_fromotherusers}?</span></label><input id="opt_pm1" type="radio" value="1" name="opt_pm" {opt_pm1} /><label for="opt_pm1"> {_lang_yes}</label>, <input id="opt_pm0" type="radio" value="0" name="opt_pm" {opt_pm0} /><label for="opt_pm0"> {_lang_no}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_privatemessages}<span class="smalfont"> {_lang_popupbynewmsg}?</span></label><input id="opt_pm_popup1" type="radio" value="1" name="opt_pm_popup" {opt_pm_popup1} /><label for="opt_pm_popup1"> {_lang_yes}</label>, <input id="opt_pm_popup0" type="radio" value="0" name="opt_pm_popup" {opt_pm_popup0} /><label for="opt_pm_popup0"> {_lang_no}</label>
<br>
<br style="clear:both;" />
<label style="float:left; width:35%;">Photoshop (in %)</label><input name="photoshop" style="margin-bottom:2px;" value="{photoshop}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">HTML (in %)</label><input name="html" style="margin-bottom:2px;" value="{html}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">PHP (in %)</label><input name="php" style="margin-bottom:2px;" value="{php}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">SQl (in %)</label><input name="datenbank" style="margin-bottom:2px;" value="{datenbank}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Flash (in %)</label><input name="flash" style="margin-bottom:2px;" value="{flash}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Ilch CMS (in %)</label><input name="ilch" style="margin-bottom:2px;" value="{ilch}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Essen</label><input name="essen" style="margin-bottom:2px;" value="{essen}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Trinken</label><input name="trinken" style="margin-bottom:2px;" value="{trinken}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Film</label><input name="film" style="margin-bottom:2px;" value="{film}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Musik</label><input name="musik" style="margin-bottom:2px;" value="{musik}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Sport</label><input name="sport" style="margin-bottom:2px;" value="{sport}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">CPU</label><input name="cpu" style="margin-bottom:2px;" value="{cpu}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Mainboard</label><input name="mainboard" style="margin-bottom:2px;" value="{mainboard}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">RAM</label><input name="ram" style="margin-bottom:2px;" value="{ram}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Monitor</label><input name="monitor" style="margin-bottom:2px;" value="{monitor}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Grafikkarte</label><input name="grafikkarte" style="margin-bottom:2px;" value="{grafikkarte}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Soundkarte</label><input name="soundkarte" style="margin-bottom:2px;" value="{soundkarte}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Festplatte</label><input name="festplatte" style="margin-bottom:2px;" value="{festplatte}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">INet Verbindung</label><input name="i_net_verbindung" style="margin-bottom:2px;" value="{i_net_verbindung}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Tastatur</label><input name="tastatur" style="margin-bottom:2px;" value="{tastatur}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Maus</label><input name="maus" style="margin-bottom:2px;" value="{maus}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Facebook</label><input name="facebook" style="margin-bottom:2px;" value="{facebook}" size="50" />
<br style="clear:both;" />
<label style="float:left; width:35%;">Youtube</label><input name="youtube" style="margin-bottom:2px;" value="{youtube}" size="50" />
<br style="clear:both;" />
{_if_{forum_usergallery}=='1'}<div align="center">
<a href="index.php?user-usergallery-{uid}">Usergallery</a> <a href="index.php?user-remove"/></a>
</div>{/_endif}<br />
{EXPLODE}
<fieldset>
<legend>{_lang_removeaccount}</legend>
<label style="float:left; width:35%;"> </label><input type="checkbox" value="yes" name="removeaccount" /> {_lang_delete}? <font class="smalfont">{_lang_mustbeentered}</font>
</fieldset>
<fieldset>
<legend>{_lang_avatar}</legend>
<label style="float:left; width:35%;"> </label>{avatarbild}<input type="checkbox" value="yes" name="avatarloeschen" /> {_lang_delete}?<br /><br />
<label style="float:left; width:35%;"> </label><input style="margin-bottom:2px;" type="file" name="avatarfile" /><br /><font class="smalfont"><br />{_lang_criterions}: {_lang_maxwidth} {Fabreite}px, {_lang_maxheight} {Fahohe}px {_lang_and} max size {Fasize} bytes. {_lang_otherwisenoaction}.</font><br />
</fieldset>
<br />
<fieldset>
<legend>{_lang_editpassword}</legend>
<br />
<label style="float:left; width:35%;">{_lang_current}</label><input style="margin-bottom:2px;" type="password" name="op" maxlength="20"><br />
<label style="float:left; width:35%;">{_lang_new}</label><input style="margin-bottom:2px;" type="password" name="np1" maxlength="20"><br />
<label style="float:left; width:35%;">{_lang_repeat}</label><input style="margin-bottom:2px;" type="password" name="np2" maxlength="20"><br />
</fieldset>
<br />
<fieldset>
<br />
{EXPLODE}
</fieldset>
<br />
<div align="center">
<input style="margin-bottom:2px;" type="submit" value="{_lang_send2}" name="submit">
</div>
</fieldset>
</form>
userdetails.htm <br />
<script language="javascript" type="text/javascript">
function details()
{
if(document.getElementById('more_details').style.display=='block'){
document.getElementById('more_details').style.display='none';
}else{
document.getElementById('more_details').style.display='block';
}
}
</script>
<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tbody>
<tr>
<td valign="top" width="60%"><table border="0" cellpadding="2" cellspacing="0" width="100%" class="Cnorm">
<tbody>
<tr>
<td colspan="2" style="border:1px solid #424242;" class="Chead"><b> • <u>Persönliche Informationen</u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td width="25%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/user.png" border="0" height="16" width="16" /> Nickname:</td>
<td width="75%" style="border:1px solid #424242;" class="Cnorm"><strong> {NAME}</strong></td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/titel.png" border="0" height="16" width="16"> Benutzertitel:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {USERTITEL}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/email.png" border="0" height="16" width="16"> Kontakt:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {EMAIL}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/homepage.png" border="0" height="16" width="16"> Homepage:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {HOMEPAGE}</td>
</tr>
<tr>
<td width="30%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/pm.png" border="0" height="16" width="16"> Private Mail:</td>
<td width="70%" style="border:1px solid #424242;"class="Cnorm"> <a href="index.php?forum-privmsg-new=0&empfid={UID}">schreiben</a></td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/icq.png" border="0" height="16" width="16"> ICQ:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {ICQ}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/sex.png" border="0" height="16" width="16"> Geschlecht:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {GESCHLECHT}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/gebdatum.png" border="0" height="16" width="16" />Geburstag:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {GEBDATUM} {ALTER}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/land.png" border="0" height="16" width="16"> Land:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {WOHNORT} {STAAT}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/reg.png" border="0" height="16" width="16"> Dabei seit:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {JOINED}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/letzteakt.png" border="0" height="16" width="16"> Letzte Aktivität:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {LASTAK} Uhr</td>
</tr>
<tr>
<td width="30%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/ugallery.png" border="0" height="16" width="16"> Usergallerie:</td>
<td width="70%" style="border:1px solid #424242;" class="Cnorm">{GALLERIE_EINTRAEGE} (<a href="index.php?user-usergallery-{UID}">ansehen)</a></td>
</tr>
</tbody>
</table>
<br>
<table border="0" cellpadding="2" cellspacing="0" width="100%" class="Cnorm">
<tbody>
<tr>
<td colspan="2" style="border:1px solid #424242;" class="Chead"><b> • <u>Homepage Kenntnisse in % </u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td width="25%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/photosop.png" border="0" height="16" width="16" /> Photoshop:</td>
<td width="75%" style="border:1px solid #424242;" class="Cnorm"> {PHOTOSHOP}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/flash.png" border="0" height="16" width="16"> Flash:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {FLASH}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/sql.png" border="0" height="16" width="16"> SQL :</td>
<td style="border:1px solid #424242;" class="Cnorm"> {DATENBANK}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/php.png" border="0" height="16" width="16"> PHP:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {PHP}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/html.png" border="0" height="16" width="16"> HTML:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {HTML}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/ilch.png" border="0" height="16" width="16"> Ilch CMS:</td>
<td style="border:1px solid #424242;" class="Cnorm"> {ILCH}</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="100%" class="Cnorm">
<tbody>
<tr>
<td colspan="2" style="border:1px solid #424242;" class="Chead"><b> • <u>Favorites</u></b></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td width="25%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/essen.png" border="0" height="16" width="16"> Essen:</td>
<td width="75%" style="border:1px solid #424242;" class="Cnorm"> {ESSEN}</td>
</tr>
<tr>
<td width="25%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/trinken.png" border="0" height="16" width="16"> Trinken:</td>
<td width="75%" style="border:1px solid #424242;" class="Cnorm"> {TRINKEN}</td>
</tr>
<tr>
<td width="25%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/film.png" border="0" height="16" width="16"> Film:</td>
<td width="75%" style="border:1px solid #424242;" class="Cnorm"> {FILM}</td>
</tr>
<tr>
<td width="25%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/musik.png" border="0" height="16" width="16"> Musik:</td>
<td width="75%" style="border:1px solid #424242;" class="Cnorm"> {MUSIK}</td>
</tr>
<tr>
<td width="25%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/sport.png" border="0" height="16" width="16"> Sport:</td>
<td width="75%" style="border:1px solid #424242;" class="Cnorm"> {SPORT}</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="100%" class="Cnorm">
<tbody>
<tr>
</tr>
</tbody>
</table></td>
<td width="0%"> </td>
<td valign="top" width="40%"><table cellpadding="2" cellspacing="0" width="100%" style="border:1px solid #424242;" class="Cnorm">
<tbody>
<tr>
<td style="border:1px solid #424242;" class="Chead"><b> • <u>Benutzerbild:</u></b></td>
</tr>
<tr>
<td></td>
</tr>
<tr class="Cnorm">
<td align="center" height="160" class="gradualfader">{AVATA}</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="100%" class="Cnorm">
<tbody>
<tr>
<td colspan="2" style="border:1px solid #424242;" class="Chead"><b> • <u>Specials</u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td width="30%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/forum/ord.png" border="0" height="16" width="16"> Forumtopics:</td>
<td width="70%" style="border:1px solid #424242;"class="Cnorm"> {FORUMTOPICS}</td>
</tr>
<tr>
<td width="30%" style="border:1px solid #424242;" class="Cmite"><img src="include/images/forum/ord.png" border="0" height="16" width="16"> Forumposts:</td>
<td width="70%" style="border:1px solid #424242;" class="Cnorm"> {POSTS}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/facebook.png" border="0" height="16" width="16"> Facebook:</td>
<td style="border:1px solid #424242;"class="Cnorm"> {FACEBOOK}</td>
</tr>
<tr>
<td style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/youtube.png" border="0" height="16" width="16"> YouTube:</td>
<td style="border:1px solid #424242;"class="Cnorm"> {YOUTUBE}</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="100%" class="Cnorm">
<tbody>
<tr>
<td colspan="2" style="border:1px solid #424242;" class="Chead"><b> • <u>Specials</u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td width="30%" height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/cpu.png" alt="cpu" width="16" height="16" border="0" /> Cpu:</td>
<td width="70%" height="30" style="border:1px solid #424242;" class="Cnorm"> {CPU}</td>
</tr>
<tr>
<td width="30%" height="30" style="border:1px solid #424242;" class="Cmite">;<img src="include/images/userdetails/mainboard.png" alt="maiborad" width="16" height="16" border="0" /> Mainboard:</td>
<td width="70%" height="30" style="border:1px solid #424242;"class="Cnorm"> {MAINBOARD}</td>
</tr>
<tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/arbeitsspeicher.png" alt="ram" width="16" height="16" border="0" /> Ram:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {RAM}</td>
</tr>
<tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/monitor.png" alt="Monitor" width="16" height="16" border="0" /> Monitor:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {MONITOR}</td>
</tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/grafik.png" alt="graka" width="16" height="16" border="0" /> Grafikkarte:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {GRAFIKKARTE}</td>
</tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/soundkarte.png" alt="sound" width="16" height="16" border="0" /> Soundkarte:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {SOUNDKARTE}</td>
</tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/festplatte.png" alt="festplatte" width="16" height="16" border="0" /> Festplatte:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {FESTPLATTE}</td>
</tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/modem.png" alt="inet" width="16" height="16" border="0" />Verbindung:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {I_NET_VERBINDUNG}</td>
</tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/tastatur.png" alt="tastatur" width="16" height="16" border="0" /> Tastatur:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {TASTATUR}</td>
</tr>
<td height="30" style="border:1px solid #424242;" class="Cmite"><img src="include/images/userdetails/maus.png" alt="maus" width="16" height="16" border="0" /> Maus:</td>
<td height="30" style="border:1px solid #424242;"class="Cnorm"> {MAUS}</td>
</tr>
</table>
<br>
</tr>
</tbody>
</table>
<br />
<br />
<a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a>
Zuletzt modifiziert von Sunshine Live am 01.04.2011 - 14:34:02 Meine Page Profilansicht 1.2b Profilansicht 1.2 |
||
| IRvD Mitglied
Posts: 210 |
Super. Nun Funktioniert es endlich
.. Dankeeee ^^artatis - Mein digitales Zuhause | Über mich |
||
| esv Mitglied
Posts: 6 |
was los ich jetzt machen ????
MySQL Error: 1054 : Unknown column 'datenbank' in 'field list' in Query: SELECT email,wohnort,homepage,aim,msn,icq,yahoo,avatar,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,datenbank,geschlecht,spezrank,game,spielerfahrungen,clan,map,waffe,essen,trinken,film,musik,sport,cpu,ilch,datenbank,flash,html,php,photoshop,mainboard,ram,monitor,grafikkarte,soundkarte,festplatte,i_net_verbindung,tastatur,maus,jappy,facebook,wkw,studivz,myspace,youtube,game1,game2,game3,game4,game5 FROM `ic1_user` WHERE id = "1" Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ profil_edit.php:20 -- db_query(...) @ user.php:25 -- require_once(...) @ index.php:36 -- require_once(...) Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/clients/client323/web1502/web/usr_web/esv_clan/include/includes/func/db/mysql.php on line 71 ANMERKUNG von CHAPTER Code bitte immer in CODE-TAGS posten. das betrifft auch lange Fehlermeldungen, da sonst das forum zerrissen werden kann. Zuletzt modifiziert von esv am 16.10.2011 - 15:18:04 |
||
| Lord|Schirmer Administrator 
Posts: 4603  |
Zitat geschrieben von esv
Unknown column 'datenbank' in 'field list'
Das Feld datenbank existiert nicht in ic1_user! Also entweder aus der Afrage entfernen oder Feld anlegen! SELECT * FROM `ic1_user` würde es auch tun ^^ "In mir schlummert ein Genie, leider wacht es nicht auf!" my portfolio | my community | important link |
||
| esv Mitglied
Posts: 6 |
Wie kann ich bei der DB Feld anlegen ??? Könnst du mir bitte helfen ???
|
||
| Sunshine Live Mitglied
Posts: 913 |
Wenn nit hier die anleitung:
öffne ma dein phpmyadmin und sucht ic1_user 
aus dann gehste auf Struktur dann srcollste ganz nach unten dann siehste das 
Dann klickste da auf okay und dann sieht es so aus 
und genau so eintragen wie du es auf den bild sieht Aber statt user USERPIC trägste dann datenbank ein. Und dann speichern. Zuletzt modifiziert von Sunshine Live am 16.10.2011 - 14:33:16 Meine Page Profilansicht 1.2b Profilansicht 1.2 |
||
| esv Mitglied
Posts: 6 |
Danke schon mal
|
||
| esv Mitglied
Posts: 6 |
Wie kann ich was jetzt machen, das ist unsere clanpage www.esv-clanpage.de
MySQL Error: 1054 : Unknown column 'datenbank' in 'field list' in Query: SELECT email,wohnort,homepage,aim,msn,icq,yahoo,avatar,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,datenbank,geschlecht,spezrank,game,spielerfahrungen,clan,map,waffe,essen,trinken,film,musik,sport,cpu,ilch,datenbank,flash,html,php,photoshop,mainboard,ram,monitor,grafikkarte,soundkarte,festplatte,i_net_verbindung,tastatur,maus,jappy,facebook,wkw,studivz,myspace,youtube,game1,game2,game3,game4,game5 FROM `ic1_user` WHERE id = "1" Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ profil_edit.php:20 -- db_query(...) @ user.php:25 -- require_once(...) @ index.php:36 -- require_once(...) Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/clients/client323/web1502/web/usr_web/esv_clan/include/includes/func/db/mysql.php on line 71 Zuletzt modifiziert von esv am 16.10.2011 - 15:26:26 |
||
| Sunshine Live Mitglied
Posts: 913 |
Haste Teamviewer das ich dir helfen kann?
Meine Page Profilansicht 1.2b Profilansicht 1.2 |
||
| whazza Mitglied
Posts: 1113 |
esv ich Frage mich mal wieder wieso man das Copyright aus den Design entfernt???
Zuletzt modifiziert von whazza am 16.10.2011 - 16:15:52 --------------------------------------------------- Klein Neue Ansicht |
||
| 0rsn1p3*dlx* Mitglied
Posts: 404  |
@whazza
Weils immer das selbe ist. Nix bekommen se hin aber klaun könn se wie de raben. Nich mal selber was machen können, wegen jedem misst fragen aber wenn man schon was "verschenkt" dann muss man eben noch den namen raus nehmen ... @esv Ich bitte darum das daß Copyright wieder eingesetzt wird auf: www.esv-clanpage.de/ Ich sehe zwar das Logo von DD aber weder einen Link noch das komplette CR ... Schau mich nicht in diesem Ton an, ich hab nen Tinnitus im Auge, ich seh nur Pfeifen. |
||
| esv Mitglied
Posts: 6 |
@sunshine live ja
@orsn1p3 hallo das ist ok, kann ich das logo co. nur machen aber das größer?? Bei Allianz mach ich das Logo auch ok Zuletzt modifiziert von esv am 05.11.2011 - 18:14:13 |
||
| esv Mitglied
Posts: 6 |
Ich mach das am Wochenende ok weil ich keine zeit hab
|
||
| bigani Mitglied
Posts: 104 |
Zitat geschrieben von Sunshine Live
Wenn nit hier die anleitung: öffne ma dein phpmyadmin und sucht ic1_user
aus dann gehste auf Struktur dann srcollste ganz nach unten dann siehste das
Dann klickste da auf okay und dann sieht es so aus
und genau so eintragen wie du es auf den bild sieht Aber statt user USERPIC trägste dann datenbank ein. Und dann speichern. Zuletzt modifiziert von Sunshine Live am 16.10.2011 - 14:33:16 Mus man an den typ Einstellungen was ändern damit das mit den Skill Abfragen leuft? |
||
| [ Anmelden zum schreiben ] |