This repository has been archived by the owner on May 15, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 20
/
long.php
136 lines (114 loc) · 3.46 KB
/
long.php
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1"/>
<meta name="description" content="description"/>
<meta name="keywords" content="keywords"/>
<meta name="author" content="author"/>
<link rel="stylesheet" type="text/css" href="default.css" media="screen"/>
<title>Codechef Ranking System</title>
</head>
<body>
<?php include_once "connect.php"; ?>
<div class="top">
<div class="header">
<div class="left">
Codechef Rankings
</div>
<div class="right">
<?php include "files/top-right.php"; ?>
</div>
</div>
</div>
<div class="container">
<?php include "files/nav.php";?>
<div class="main">
<div class="content">
<h2>Ranking According to Long Contest</h2><br />
<h4><a href="add.php">(To add new student codechef username go to Add menu)</a></h4><br />
<?php
if($value==0)
{
include "files/select-on-page.php";
}
else
{
//include "config.php";
$sno=1;
$result = mysql_query("SELECT * FROM detail WHERE rank1>0 AND college=".$value." ORDER BY rank1");
echo "<table>
<tr>
<th>Sno.</th>
<th>Username</th>
<th>Name</th>
<th>Country</th>
<th>Global Rank (Long)</th>
<th>Country Rank (Long)</th>
<th>Change Global (Long)</th>
</tr>";
$change=0;
$url="http://www.codechef.com/users/";
while($row = mysql_fetch_array($result))
{
$star=0;
if($row['old_rank1']==0)
{
$star=1;
$change=0;
}
else
$change= $row['old_rank1']-$row['rank1'] ;
echo "<tr>";
echo "<td>" . $sno++. "</td>";
echo "<td><a href='".$url . $row['handle'] ."' target=_blank>".$row['handle'] . "</a></td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['country'] . "</td>";
echo "<td>" . $row['rank1'] . "</td>";
echo "<td>" . $row['rank2'] . "</td>";
if($star==1)
echo "<td>" . $change . "</td><td><img src='img/star.png' style='width:20px;height:20px;'/></td>";
else if($change>0)
echo "<td>" . $change . "</td><td><img src='img/up.png' style='width:20px;height:20px;'/></td>";
else
echo "<td>" . $change*-1 . "</td><td><img src='img/down.png' style='width:20px;height:20px;' /></td>";
echo "</tr>";
}
echo "</table>";
echo "<br/><h2>Inactive users</h2><br /><br />";
$sno=1;
$result = mysql_query("SELECT * FROM detail WHERE rank1=0 AND college=".$value." ORDER BY handle");
echo "<table>
<tr>
<th>Sno.</th>
<th>Username</th>
<th>Name</th>
<th>Country</th>
<th>Global Rank (Long)</th>
<th>Country Rank (Long)</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $sno++. "</td>";
echo "<td><a href='".$url . $row['handle'] ."' target=_blank>".$row['handle'] . "</a></td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['country'] . "</td>";
echo "<td>" . $row['rank1'] . "</td>";
echo "<td>" . $row['rank2'] . "</td>";
echo "</tr>";
}
echo "</table>";
}
?>
</div>
<div class="sidenav">
<?php include "files/sidenav.php";?>
</div>
<div class="clearer"><span></span></div>
</div>
<div class="footer">© 2013 <a href="http://www.shivamkhandelwal.in/" target="_blank">Shivam Khandelwal</a> | Designed and Developed by Shivam Khandelwal
</div>
</div>
</body>
</html>