'; if( isset($_GET['os']) ) { $OS = $_GET['os']; } else { $OS = 0; } $max = 50; //rein $msg_result_count = $this->Query('SELECT id FROM comments WHERE ok = 1'); $Count = mysql_num_rows($msg_result_count); echo ''; $PrevOS = $OS - $max; $NextOS = $OS + $max; if( $OS != 0 ) { echo '

---

'; } //rein $comments = $this->Query('SELECT user_id,comment,ok,insert_time FROM comments WHERE comment != "" ORDER BY insert_time DESC LIMIT '.$OS.' , '.$max); while($entrys = mysql_fetch_array($comments, MYSQL_ASSOC)) { if($entrys['ok'] == 1) { $uinfo = $this->Query('SELECT id,name,password FROM user_registered WHERE id = '.$entrys[user_id]); $uinfo_sql = mysql_fetch_array($uinfo, MYSQL_ASSOC); if($uinfo_sql[password] != "xh6t9ge4p7sk" && $uinfo_sql[password] != "xh6t9ge4p7skdel") { echo '

'; $sql = $this->Query('SELECT id_registered,geschlecht,jahrgang,privat_foto FROM user_profile WHERE id_registered = '.$entrys[user_id]); $fields5 = mysql_fetch_assoc($sql); if($fields5['geschlecht'] == 'maennlich') { echo ''; } else { echo ' '; } echo ' Alter: '.$fields5['jahrgang'].'

schrieb am '.date("d.m.Y", $entrys[insert_time]).'-'.date("H:i", $entrys[insert_time]).' Uhr :

'.$entrys[comment].'

---

'; mysql_free_result($uinfo); mysql_free_result($sql); } } } mysql_free_result($comments); if( $Count >= $NextOS ) { echo '

---

'; } } else if($this->User->IsProfileOk() == 1) { echo' '; if( isset($_GET['os']) ) { $OS = $_GET['os']; } else { $OS = 0; } $max = 50; $msg_result_count = $this->Query('SELECT id FROM comments WHERE ok = 1'); $Count = mysql_num_rows($msg_result_count); echo ''; $PrevOS = $OS - $max; $NextOS = $OS + $max; if( $OS != 0 ) { echo '

---

'; } $comments = $this->Query('SELECT user_id,comment,ok,insert_time FROM comments WHERE comment != "" ORDER BY insert_time DESC LIMIT '.$OS.' , '.$max); while($entrys = mysql_fetch_array($comments, MYSQL_ASSOC)) { if($entrys['ok'] == 1) { $uinfo = $this->Query('SELECT id,name,password FROM user_registered WHERE id = '.$entrys[user_id]); $uinfo_sql = mysql_fetch_array($uinfo, MYSQL_ASSOC); if($uinfo_sql[password] != "xh6t9ge4p7sk" && $uinfo_sql[password] != "xh6t9ge4p7skdel") { echo '

'.$uinfo_sql['name'].' '; $sql = $this->Query('SELECT id_registered,geschlecht,privat_foto FROM user_profile WHERE id_registered = '.$entrys[user_id]); $fields5 = mysql_fetch_assoc($sql); if($fields5['geschlecht'] == 'maennlich') { echo ''; } else { echo ' '; } echo '

'; $sql = $this->Query('SELECT foto,foto_checked FROM user_foto WHERE id_registered = '.$entrys[user_id].' ORDER BY id ASC'); $rows = mysql_num_rows($sql); $fields6 = mysql_fetch_assoc($sql); if($rows < 1) { if($fields5['geschlecht'] == 'maennlich') { $foto = ' '; } else { $foto = ' '; } } if($fields6[foto_checked] < 2 && $rows >= 1) { $foto = ' '; } elseif($fields6[foto_checked] == 2) { if($fields5['privat_foto'] == 'freund') { $GetIdRegistered = $this->User->GetIdRegistered(); $a = $this->Query('SELECT id_freund FROM user_relation WHERE id_registered = \''.$fields5[id_registered].'\''); $b = mysql_fetch_array($a); $e = strtok($b[0], ';'); while($e) { if($e == 'a') { } elseif($e == '0') { } elseif($e == $GetIdRegistered) { $vorhanden_privat_foto = 1; } else { //$vorhanden_1 = 1; } $e = strtok(';'); } mysql_free_result($a); if($vorhanden_privat_foto) { $foto = ' '; } else { $foto = ' '; } } if($fields5['privat_foto'] == 'jeder') { $foto = ' '; } } echo ' '.$foto.' '; echo '

schrieb am '.date("d.m.Y", $entrys[insert_time]).'-'.date("H:i", $entrys[insert_time]).' Uhr :

'.$entrys[comment].'

---

'; mysql_free_result($uinfo); mysql_free_result($sql); } } } mysql_free_result($comments); if( $Count >= $NextOS ) { echo '

---

'; } }//profile ok } //view if($view_type == 'forum_save') { echo '
'; } /* $comments = $this->Query('SELECT user_id,comment,ok,insert_time FROM comments WHERE comment != "" ORDER BY insert_time DESC'); while($entrys = mysql_fetch_array($comments, MYSQL_ASSOC)) { if($entrys['ok'] == 1) { $uinfo_sql = $this->Query('SELECT id,name FROM user_registered WHERE id = '.$entrys[user_id]); $uinfo = mysql_fetch_array($uinfo_sql, MYSQL_ASSOC); $sql = $this->Query('SELECT foto,foto_checked FROM user_foto WHERE id_registered = '.$entrys[user_id].' ORDER BY id ASC'); $rows = mysql_num_rows($sql); $fields6 = mysql_fetch_assoc($sql); if($rows < 1) { $foto = ' '; } if($fields6[foto_checked] < 2 && $rows >= 1) { $foto = ' '; } elseif($fields6[foto_checked] == 2) { $foto = ' '; } echo ' '; echo '

'.$uinfo['name'].'

schrieb am: '.date("d.m.Y", $entrys[insert_time]).' '.date("G:i:s", $entrys[insert_time]).'

Kommentar: '.$entrys[comment].'

---

'; mysql_free_result($uinfo_sql); mysql_free_result($sql); } } mysql_free_result($comments); } */ ?>