<?php

    echo '<div class="content_left">
    <div id="breadcrumb">
        <ul class="crumbs">
            <li class="first"><a href="index.php" style="z-index:9;"><span></span>' . $lang['index'] . '</a></li>
            <li><a href="accounts.php" style="z-index:8;">' . $lang['member_list'] . '</a></li>
        </ul>
    </div>
    </div>

    <div class="content_right">';

        include('modules/search.inc.php');
    echo '</div>

    <div class="clear_long"></div>';

    $ret = 1;

    echo '<div class="main_menu">';

        $ret = include 'framework/templates/'.$main_content['menu'];
    echo '<div id="line"></div>';

        $ret = include 'framework/templates/'.$main_content['infos'];
    echo '</div>';

    echo '<div class="main_content">';

    echo '<h1 class="p_space">' . $lang['member_list'] . '</h1>';

    if(isset($_POST['submit'])) {
	$error = FALSE;

	if(empty($_POST['search'])) {
	$error = TRUE;

    echo '<p class="false">' . $lang['enter_search_term'] . ' - <a href="javascript:history.back();" class="false_link">' . $lang['back'] . '</a></p>';
	}

	if(!$error) {

	$text = htmlentities($_POST['search']);

	$query = "SELECT
				  id,
				  name,
				  email
			  FROM
				  members
			  WHERE
				  name LIKE '%$text%' OR id LIKE '%$text%' OR email LIKE '%$text%'
			  ORDER BY
				  id DESC";

	$result = mysql_query($query) OR die(mysql_error());

	if($result) {

	echo '<p><small><u>' . intval(mysql_num_rows($result)) . '</u> ' . $lang['matches'] . '</small></p>';

	while($row = mysql_fetch_assoc($result)) {

		echo '<p>&raquo; <a href="member.php?id=' . (int)$row['id'] . '">' . htmlentities($row['name'], ENT_QUOTES) . '</a></p>';
		      }

		echo '<p>[ <a href="accounts.php">' . $lang['search_again'] . '?</a> ]</p>';

			}else{

			echo '<p class="false">' . $lang['no_matches'] . ' - <a href="javascript:history.back();" class="false_link">' . $lang['back'] . '</a></p>';
			}
		}

	}else{

	echo '<form id="search" action="accounts.php?search" method="post">
	<input type="text" name="search" size="30" placeholder="' . $lang['search_for_members'] . '" class="searchfield">
	<input type="submit" name="submit" value="' . $lang['search'] . '" alt="' . $lang['search'] . '" class="buttons">
	</form>';

    echo '<div class="clear_long"></div>';

	$inquiry = mysql_query("SELECT id FROM members");
	$total = intval(mysql_num_rows($inquiry));

	echo '<p><u>' . $total . '</u> ' . $lang['registered_members'] . '</p>';
	}

	echo '<table width="100%" class="tables">
    <tr>
    <td width="10%"><span class="blue_span">ID</span></td>
    <td width="40%"><span class="blue_span">' . $lang['re_name'] . '</span></td>
    <td width="5%" align="center"><span class="blue_span">' . $lang['to_chat'] . '</span></td>
    <td width="25%" align="right"><span class="blue_span">' . $lang['last_signin'] . '</span></td>
    <td width="20%" align="right"><span class="blue_span">' . $lang['date_of_register'] . '</span></td>
    </tr>';

	$path  = $_SERVER["PHP_SELF"];
	$query = mysql_query("SELECT id FROM members");
	$total = mysql_num_rows($query);
	$allsites = ceil($total / $entries);

	include('framework/functions/pagination.php');

	$sql = "SELECT id, name, date, status FROM members ORDER BY date DESC LIMIT $start,$entries";
	$members = mysql_query($sql) OR die(mysql_error());

	if(!$members) {

	echo '<p class="false">' . $lang['no_members'] . '</p>' . mysql_error();

	   }else{

		if(intval(mysql_num_rows($members)) == 0) {

		echo '<p class="false">' . $lang['no_members'] . '</p>' . mysql_error();

    }else{

	while($row = mysql_fetch_assoc($members)) {

        $memID = (int)$row['id'];

		echo '<tr>
	    <td width="10%">' . (int)$row['id'] . '</td>
		<td width="40%"><a href="member.php?id=' . (int)$row['id'] . '">' . htmlentities($row['name'], ENT_QUOTES) . '</a></td>
		<td width="5%" align="center"><a href="talk.php"><img src="style/icons/notification.png" border="0" alt="Chat"></a></td>
        <td width="25%" align="right"><small>'; if($row['status'] > 0) { echo date('d.m.Y', strtotime($row['status'])); }else{ echo $lang['no_signins']; }

		echo '</small></td><td width="20%" align="right"><small>' . date('d.m.Y - H:i', strtotime($row['date'])) . '</small></td></tr>';
		}

	echo '</table>';

    echo '<div class="spacer"></div>';

	echo '<span class="pages">Seite ' . $page . ' von ' . $allsites . '</span>';
	echo $link_string;

	echo '<div class="clear_pagination"></div>';
	}
	}

?>