TestingGround/members.php at master · IvanPuntev/TestingGround · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?php
session_start();
include 'system.php';
page_header();

db_init();
date_default_timezone_set('Europe/Sofia');
$sql = 'SELECT id, username, name, surname, email, gender, secret_question, secret_answer, profile_picture, type, active, join_date, last_login, last_ip, status FROM users';
$retval = run_mysql_query( $sql );
if(! $retval )
{
  die('Could not get data: ' . mysql_error());
}
echo '<div id="main_content_body">
<div id="main_content_title">Members</div>
<table class="list">
<tr>
		<!--<th><strong class="display_color">ID</strong></th>-->
		<th><strong class="display_color">Username</strong></th>
		<th><strong class="display_color">Name</strong></th>
		<th><strong class="display_color">Surname</strong></th>
		<th><strong class="display_color">Email</strong></th>
		<th><strong class="display_color">Gender</strong></th>
		<!--<th><strong class="display_color">Secret question</strong></th>-->
		<!--<th><strong class="display_color">Secret answer</strong></th>-->
                <th><strong class="display_color">Profile Picture</strong></th>
		<th><strong class="display_color">Type</strong></th>
		<th><strong class="display_color">Active</strong></th>
		<th><strong class="display_color">Date registered</strong></th>
		<th><strong class="display_color">Last login</strong></th>
		<!--<th><strong class="display_color">Last ip</strong></th>-->
                <th><strong class="display_color">Profile Status</strong></th>
	</tr>


';
while($userData = mysql_fetch_array($retval, MYSQL_ASSOC))
{
    if($userData['status']==="offline"){$errorArray['status']='<img src="img/system/offline.png" />'; }else{$errorArray['status']='<img src="img/system/online.png" />';}

    echo '
	<tr>
		<!--<td>'.$userData['id']. '</td>-->
		<td>' .$userData['username']. '</td>
		<td>' .$userData['name']. '</td>
		<td>' .$userData['surname']. '</td>
		<!--<td>' .$userData['email']. '</td>-->
                    <td>*************</td>
		<td>' .$userData['gender']. '</td>
		<!--<td>' .$userData['secret_question']. '</td>-->
		<!--<td>' .$userData['secret_answer']. '</td>-->
                    <td><img src="' .$userData['profile_picture']. '" width="64" height="64" alt="" /></td>
		<td>' .$userData['type']. '</td>
		<td>' .$userData['active']. '</td>
		<td>' .date('d-m-Y | G:i', $userData['join_date']). '</td>
		<td>' .date('d-m-Y | G:i', $userData['last_login']). '</td>
		<!--<td>' .$userData['last_ip']. '</td>-->
                <td>' .$errorArray['status']. '</td>

	</tr>
	';
}
echo '</table></div>';
//echo "<br /><img src='img/button_ok.png' width='16' heigh='16' />&nbsp;<span style='bottom:4px; position:relative;'>Data taken successfully!</span><br /><br /><a href='admin.php'>Back</a>";
mysql_close();

page_footer();