'; $show_search_result .= $permissions; if($action=='list' || !$friendsearch){ $result = mysql_query("SELECT * FROM chat_notify where Nick='$nick' order by Friend",$db_handle); $num=mysql_num_rows($result); $search_for_chatter = $MSG_FRIENDS_ADD_TITLE.':
'; $search_for_chatter .= nl.''.nl.''.nl.''; if($num > 15){ $count_left = round($num / 2)-1; $i=0; while($i<=$count_left && $num>$i){ $friend=mysql_result($result,$i,"Friend"); $lastlogin = mysql_query("SELECT DATE_FORMAT(Zeit, '%d.%m.%Y - %H:%i') as Zeit FROM chat_data where Nick='$friend'",$db_handle); $row_login = mysqli_fetch_object($lastlogin); $showtime = $row_login->Zeit; $table_left .= ''.$friend.''; $online_status = mysql_query("SELECT Nick FROM chat where Nick='$friend'",$db_handle); if(mysql_num_rows($online_status)>0){ $table_left .= '  Online'; }else{ $table_left .= '  Offline'; } $table_left .= ''.$showtime.''; if($ENABLE_SESSION){ $table_left .= ''.$WRITE_MAIL.''; $table_left .= ''.$DELETE.''; }else{ $table_left .= ''.$WRITE_MAIL.''; $table_left .= ''.$DELETE.''; } $i++; } while($i<$num){ $friend=mysql_result($result,$i,"Friend"); $lastlogin = mysql_query("SELECT DATE_FORMAT(Zeit, '%d.%m.%Y - %H:%i') as Zeit FROM chat_data where Nick='$friend'",$db_handle); $row_login = mysqli_fetch_object($lastlogin); $showtime = $row_login->Zeit; $table_right .= ''.$friend.''; $online_status = mysql_query("SELECT Nick FROM chat where Nick='$friend'",$db_handle); if(mysql_num_rows($online_status)>0){ $table_right .= '  Online'; }else{ $table_right .= '  Offline'; } $table_right .= ''.$showtime.''; if($ENABLE_SESSION){ $table_right .= ''.$WRITE_MAIL.''; $table_right .= ''.$DELETE.''; }else{ $table_right .= ''.$WRITE_MAIL.''; $table_right .= ''.$DELETE.''; } $i++; } $select_of_friends = '
'; $table_header = ''; $select_of_friends .= $table_header.''.$table_left.'
'.$MSG_FRIENDS_FRIEND.':'.$MSG_FRIENDS_LAST_SEEN.':
 '.$table_header.''.$table_right.'
'; }else{ $select_of_friends = '
'; while($row=mysqli_fetch_object($result)){ $friend = $row->Friend; $lastlogin = mysql_query("SELECT DATE_FORMAT(Zeit, '%d.%m.%Y - %H:%i') as Zeit FROM chat_data where Nick='$friend'",$db_handle); $row_login = mysql_fetch_array($lastlogin); $showtime = $row_login['Zeit']; $select_of_friends .= ''; $online_status = mysql_query("SELECT Nick FROM chat where Nick='$friend'",$db_handle); if(mysql_num_rows($online_status)>0){ $select_of_friends .= ''; }else{ $select_of_friends .= ''; } $select_of_friends .= ''; if($ENABLE_SESSION){ $select_of_friends .= ''; $select_of_friends .= ''; }else{ $select_of_friends .= ''; $select_of_friends .= ''; } } $select_of_friends .= '
'.$MSG_FRIENDS_FRIEND.':'.$MSG_FRIENDS_LAST_SEEN.':
'.$friend.'  Online  Offline'.$showtime.''.$WRITE_MAIL.''.$DELETE.''.$WRITE_MAIL.''.$DELETE.'

'; } unset($friend); mysql_free_result($result); } if($action=='delete'){ $friend_to_delete = $_GET['friend']; $result = mysql_query("delete from chat_notify where Friend='$friend_to_delete' && Nick='$nick'",$db_handle); header("location: friends.$FILE_EXTENSION?action=list&nick=".rawurlencode($nick)."&pruef=$pruef&".SID); } if($friendsearch){ $friendsearch=addslashes($friendsearch); $result = mysql_query("select Nick from chat_data where Nick like '$friendsearch%' AND Nick !='$nick' order by Nick",$db_handle); if(mysql_num_rows($result)>0){ $show_search_result = $CHOOSE_NICK.':

'; $show_search_result .= $permissions; $show_search_result .= ' '; $search_for_chatter .= nl.''.nl.''.nl.''; } if(mysql_num_rows($result)==1){ while($a=mysql_fetch_array($result)){ $show_search_result .= "