ilch.de :: Forum :: Ilch Clan 1.1 :: Fehlersuche und Probleme

es lag an der profil_edit.php die ich mir hier aus dem forum rausgesucht habe:
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
<?php 
#   Copyright by: Manuel
#   Support: www.ilch.de
$ubreit = 240;
$uhoehe = 180;
$usize = pow( 1024, 3);
 
 
defined ('main') or die ( 'no direct access' );
 
 
$title = $allgAr['title'].' :: Users :: Profil';
$hmenu  = $extented_forum_menu.'<a class="smalfont" href="index.php?user">Users</a><b> &raquo; </b> Profil'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu);
 
 
 
if ( $_SESSION['authright'] <= -1 ) {  
 
if ( empty ($_POST['submit']) ) {
  $design->header();
        $abf = 'SELECT email,wohnort,homepage,aim,msn,icq,yahoo,avatar,userpict,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,geschlecht,spezrank 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['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'; }
    /*Script change by Nero Start */
    $row['userbild'] = ( file_exists ( $row['userpict'] ) ? '<img src="'.$row['userpict'].'" alt=""><br />' : '' );
    /*Script change by Nero Ende */
    $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['ubreit'] = $ubreit;
    $row['uhoehe'] = $uhoehe;
    $row['usize'] = $usize;
     
    $tpl->set_ar_out($row,0);
 
                profilefields_change ( $_SESSION['authid'] );
                $tpl->out(1);
                 
  } 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'] ) ) {
                                $file_tmpe = $_FILES['avatarfile']['tmp_name'];
                                $file_type = $_FILES['avatarfile']['type'];
                                $file_size = $_FILES['avatarfile']['size'];
                                $file_name = $_FILES['avatarfile']['name'];
        $fmsg = $lang['avatarisnopicture']; 
                                if ( substr ( $file_type , 0 , 6 ) == 'image/' ) {
                                  $endung = preg_replace("/.*\.([^\.]+)/", "\\1", $file_name);
                                  $size   = getimagesize($file_tmpe);
          $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 );
            $avatar_sql_update = "avatar = '".$neuer_name."',";
            $fmsg = $lang['pictureupload']; 
                                        }
                                }
                        } 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
   
  /*Script change by Nero Start */
  # userpict speichern START
                        $userpict_sql_update = '';
      if ( !empty ( $_FILES['userpictfile']['name'] ) ) {
                                $file_tmpe = $_FILES['userpictfile']['tmp_name'];
                                $file_type = $_FILES['userpictfile']['type'];
                                $file_size = $_FILES['userpictfile']['size'];
                                $file_name = $_FILES['userpictfile']['name'];
        $fmsg = $lang['userpictisnopicture'];
                                if ( substr ( $file_type , 0 , 6 ) == 'image/' ) {
                                  $endung = preg_replace("/.*\.([^\.]+)/", "\\1", $file_name);
                                  $size   = getimagesize($file_tmpe);
          $breite = $size[0];
          $hoehe  = $size[1];
          
          $fmsg   = $lang['userpictcannotupload'];
                                  if ( $file_size <= $usize AND $breite <= $ubreit AND $hoehe <=  $uhoehe ) {
                                          $neuer_name = 'include/images/userpicts/'.$_SESSION['authid'].'.'.$endung;
                                                @unlink (db_result(db_query("SELECT userpict FROM prefix_user WHERE id = ".$_SESSION['authid']),0));
            move_uploaded_file ( $file_tmpe , $neuer_name );
            $userpict_sql_update = "userpict = '".$neuer_name."',";
            $fmsg = $lang['pictureupload'];
                                        }
                                }
                        } elseif ( isset($_POST['userpictloeschen']) ) {
        $fmsg = $lang['picturedelete'];
        @unlink (db_result(db_query("SELECT userpict FROM prefix_user WHERE id = ".$_SESSION['authid']),0));
        $userpict_sql_update = "userpict = '',";
      }
 
  # userpict speichern ENDE
  /*Script change by Nero 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'];
  }
  #
   
   
  # 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."
          ".$userpict_sql_update."
          aim = '".escape($_POST['aim'], 'string')."',
          staat = '".escape($_POST['staat'], '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'))."',
          sig = '".substr(escape($_POST['sig'], 'string'),0,$allgAr['forum_max_sig'])."'
                                WHERE id = ".$_SESSION['authid']
      )OR die('datenbankprob.');
         
   
        # 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();
?>
jetzt habe ich die alte wieder raufgespielt und es funzt
Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » MYSQL Problem
