-
Notifications
You must be signed in to change notification settings - Fork 5
Expand file tree
/
Copy pathadmin_aktif.php
More file actions
70 lines (67 loc) · 4.36 KB
/
admin_aktif.php
File metadata and controls
70 lines (67 loc) · 4.36 KB
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
68
69
70
<?
require( "label.php" );
if( !verifyAdmin() ) header( "Location: admin.php" );
dbConnect();
$halaman = "20" ;
$status="nonaktif";
$result = mysql_query( "SELECT * FROM member WHERE stat='$status' ORDER BY user_id DESC" ) or error( mysql_error() );
$memnum = mysql_num_rows( $result );
$jmlhalaman = ceil(mysql_num_rows($result) / $halaman);
if(!isset($page))
{
$page = 0;
}
$offset = $page * $halaman;
$resul = mysql_query( "SELECT * FROM member where stat='$status' ORDER BY user_id DESC LIMIT $offset, $halaman" ) or error( mysql_error() );
displayHeader( "Admin > Member List" );
echo " <p align=\"center\"> Tampilan Member yang belum aktif (non aktif). Untuk Mengaktifkan klik menu <b>'Aktifkan'</b></p> \n";
echo "<p align=\"center\"><font size=\"4\">Total member yang belum aktif = $memnum </font></p>\n";
if( $memnum != 0 )
{
echo "<div align=\"left\"><small>\n";
echo " <center>\n";
echo " <table border=\"0\" cellspacing=\"0\" width=\"760\" cellpadding=\"3\">\n";
echo " <tr class=\"frame\">\n";
echo " <td width=\"8%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>Username</b></font></small></td>\n";
echo " <td width=\"15%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>Nama</b></font></small></td>\n";
echo " <td width=\"15%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>email</b></font></small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>Kota</b></font></small></td>\n";
echo " <td width=\"8%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>Sponsor</b></font></small></td>\n";
echo " <td width=\"14%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>Nama Sponsor</b></font></small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>ID Sponsor </b></font></small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>Tanggal Join</b></font></small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\"><small><font color=\"#FFFFFF\"><b>Aktifkan ?</b></font></small></td>\n";
echo " </tr>\n";
$i = 1;
while( $row = mysql_fetch_array( $resul ) )
{
$i % 2 == 0 ? $bgColor = "#FFFFFF" : $bgColor = "#E6E6E6";
//$adsnum = mysql_num_rows( mysql_query( "SELECT user_name FROM member WHERE user_name={$row['user_name']}" ) );
echo " <tr>\n";
echo " <td width=\"8%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>{$row['username']}</small></td>\n";
echo " <td width=\"15%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>{$row['nama']}</small></td>\n";
echo " <td width=\"15%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>{$row['email']}</small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>{$row['kota']}</small></td>\n";
echo " <td width=\"8%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>{$row['username_sponsor']}</small></td>\n";
echo " <td width=\"14%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>{$row['nama_sponsor']}</small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>{$row['id_sponsor']}</small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><small>" . date( "d-m-y", $row['tanggal_join'] ) . "</small></td>\n";
echo " <td width=\"10%\" height=\"25\" align=\"left\" bgcolor=\"$bgColor\"><font face=\"verdana\" size=\"1\" color=\"#000080\"><a href='admin_aktif2.php?user={$row['username']}'>Aktifkan<font size=\"1\"></td>\n";
echo " </tr>\n";
$i++;
}
echo "<b>Halaman :</b>\n";
for($a=0;$a<$jmlhalaman;$a++)
{
echo" [<a href='admin_aktif.php?page=$a'>$a</a>]\n";
}
echo " <tr>\n";
echo " <td width=\"100%\" height=\"1\" bgcolor=\"#808080\" colspan=\"15\"></td>\n";
echo " </td>\n";
echo " </table>\n";
echo " </center>\n";
echo "</div></small>\n";
}
echo "<p align=\"center\"><a href=\"admin_menu.php\"><b>Back to Admin</b></a></p>\n";
displayFooter();
?>