index.php 7.97 KB
Newer Older
1
<?php
pjmattal's avatar
pjmattal committed
2
3
4

set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');

5
# include("index_po.inc");
pjmattal's avatar
pjmattal committed
6
include("pkgfuncs_po.inc"); # Add to handle the i18n of My Packages
7
include("aur.inc");
eric's avatar
eric committed
8
set_lang();
eric's avatar
eric committed
9
check_sid();
10
html_header(__("Home"));
eric's avatar
eric committed
11

pjmattal's avatar
pjmattal committed
12
# Big Top Level Table (Table 1)
eliott's avatar
eliott committed
13
echo "<div class=\"pgbox\">\n";
14
echo "  <div class=\"pgboxtitle\"><span class=\"f3\">AUR ".__("Home")."</span></div>\n";
eliott's avatar
eliott committed
15
16
17
echo "  <div class=\"frontpgboxbody\">\n";
echo "<table border='0' cellpadding='0' cellspacing='3' width='90%'>\n";
echo "<tr>\n";
pjmattal's avatar
pjmattal committed
18

19
20
21
# MAIN: Top Left
print "<td class='boxSoft' valign='top'>";

swiergot's avatar
swiergot committed
22
print "<p>".__("Welcome to the AUR! Please read the %hAUR User Guidelines%h and %hAUR TU Guidelines%h for more information.", array('<a href="http://wiki.archlinux.org/index.php/AUR_User_Guidelines">', '</a>', '<a href="http://wiki.archlinux.org/index.php/AUR_Trusted_User_Guidelines">', '</a>'))."<br>";
pjmattal's avatar
pjmattal committed
23
print __("Contributed PKGBUILDs <b>must</b> conform to the %hArch Packaging Standards%h otherwise they will be deleted!", array('<a href="http://wiki.archlinux.org/index.php/Arch_Packaging_Standards">', '</a>'))."</p>";
pjmattal's avatar
pjmattal committed
24
25
print "<p>".__("Remember to vote for your favourite packages!")."<br>";
print __("The most popular packages will be provided as binary packages in [community].")."</p>";
simo's avatar
simo committed
26

27
28
29
30
31
32
33
34
35
36
37
38
39
# MAIN: Top Right
print "</td>";
print "<td class='boxSoft' valign='top'>";

# MAIN: Bottom Left
print "</td>";
print "</tr>";
print "<tr>";
print "<td class='boxSoft' valign='top'>";

#Hey, how about listing the newest pacakges? :D
$q = "SELECT * FROM Packages ";
$q.= "WHERE DummyPkg != 1 ";
40
$q.= "ORDER BY GREATEST(SubmittedTS,ModifiedTS) DESC ";
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
$q.= "LIMIT 0 , 10";
$result = db_query($q,$dbh);
# Table 2
print '<table class="boxSoft">';
print '<tr>';
print '<th colspan="2" class="boxSoftTitle" style="text-align: right">';
print ' <a href="/rss2.php"><img src="/images/rss.gif"></a> <span class="f3">'.__("Recent Updates").' <span class="f5"></span></span>';
print '</th>';
print '</tr>';

while ($row = mysql_fetch_assoc($result)) {
	print '<tr>';
        print '<td class="boxSoft">';

        print '<span class="f4"><span class="blue"><a href="/packages.php?do_Details=1&ID='.intval($row["ID"]).'">';
	print $row["Name"]." ".$row["Version"]."</a></span></span>";

        print '</td>';
	print '<td class="boxSoft" style="text-align: right">';

        # figure out the mod string
        $mod_int = intval($row["ModifiedTS"]);
        $sub_int = intval($row["SubmittedTS"]);
        if ($mod_int != 0) {
simo's avatar
simo committed
65
	  $modstring = gmdate("r", $mod_int);
66
67
        }
        elseif ($sub_int != 0) {
simo's avatar
simo committed
68
          $modstring = '<img src="/images/new.gif"/> '.gmdate("r", $sub_int);
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
        }
        else {
          $mod_string = "(unknown)";
        }
        print '<span class="f4">'.$modstring.'</span>';
        print '</td>';
	print '</tr>'."\n";
}
print "</td>";
print "</tr>";
print "</table>";
# End Table 2

# MAIN: Bottom Right
print "</td>";
print "<td class='boxSoft' valign='top'>";
85

86
# AUR STATISTICS 
pjmattal's avatar
pjmattal committed
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107

$q = "SELECT count(*) FROM Packages,PackageLocations WHERE Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$unsupported_count = $row[0];

$q = "SELECT count(*) FROM Packages,PackageLocations WHERE Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'community'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$community_count = $row[0];

$q = "SELECT count(*) from Users";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$user_count = $row[0];

$q = "SELECT count(*) from Users,AccountTypes WHERE Users.AccountTypeID = AccountTypes.ID AND AccountTypes.AccountType = 'Trusted User'";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$tu_count = $row[0];

108
109
110
111
112
113
$targstamp = intval(strtotime("-7 days"));
$q = "SELECT count(*) from Packages WHERE (Packages.SubmittedTS >= $targstamp OR Packages.ModifiedTS >= $targstamp)";
$result = db_query($q, $dbh);
$row = mysql_fetch_row($result);
$update_count = $row[0];

114
115
116
117
118
# Added the user statistcs.
# Added by: dsa <dsandrade@gmail.com>
$user = username_from_sid($_COOKIE["AURSID"]);

if (!empty($user)) {
119
    $q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported' AND Users.Username='".mysql_real_escape_string($user)."'";
120
121
122
123
    $result = db_query($q, $dbh);
    $row = mysql_fetch_row($result);
    $maintainer_unsupported_count = $row[0];
    
124
    $q = "SELECT count(*) FROM Packages,Users WHERE Packages.OutOfDate = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
125
126
127
128
129
130
131
132
    $result = db_query($q, $dbh);
    $row = mysql_fetch_row($result);
    $flagged_outdated = $row[0];
    
    print "<table class='boxSoft'>";
    
    print "<tr>";
    print "<th colspan='2' class='boxSoftTitle' style='text-align: right'>";
133
    print "<span class='f3'>".__("My Statistics")."</span>";
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
    print "</th>";
    print "</tr>";
    
    # Number of packages in unsupported
    print "<tr>";
    print "<td class='boxSoft'>";
    print "<span class='f4'>".__("Packages in unsupported")."</span>";
    print "</td>";
    print "<td class='boxSoft'><span class='f4'>$maintainer_unsupported_count</span></td>";
    print "</tr>";
    
    # If the user is a TU calculate the number of the packages
    $atype = account_from_sid($_COOKIE["AURSID"]);
    
    if ($atype == 'Trusted User') {    
149
        $q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'community' AND Users.Username='".mysql_real_escape_string($user)."'";
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
        $result = db_query($q, $dbh);
        $row = mysql_fetch_row($result);
        $maintainer_community_count = $row[0];
        
        print "<tr>";
        print "<td class='boxSoft'>";
        print "<span class='f4'>".__("Packages in [community]")."</span>";
        print "</td>";
        print "<td class='boxSoft'><span class='f4'>$maintainer_community_count</span></td>";
        print "</tr>";
    }
    
    # Number of outdated packages    
    print "<tr>";
    print "<td class='boxSoft'>";
    print "<span class='f4'>".__("Out-of-date")."</span>";
    print "</td>";
    print "<td class='boxSoft'><span class='f4'>$flagged_outdated</span></td>";
    print "</tr>";    
        
    print "</table><br />";
}

pjmattal's avatar
pjmattal committed
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
print "<table class='boxSoft'>";

print "<tr>";
print "<th colspan='2' class='boxSoftTitle' style='text-align: right'>";
print "<span class='f3'>".__("Statistics")."</span>";
print "</th>";
print "</tr>";

print "<tr>";
print "<td class='boxSoft'>";
print "<span class='f4'>".__("Packages in unsupported")."</span>";
print "</td>";
print "<td class='boxSoft'><span class='f4'>$unsupported_count</span></td>";
print "</tr>";

print "<tr>";
print "<td class='boxSoft'>";
print "<span class='f4'>".__("Packages in [community]")."</span>";
print "</td>";
print "<td class='boxSoft'><span class='f4'>$community_count</span></td>";
print "</tr>";

print "<tr>";
print "<td class='boxSoft'>";
197
print "<span class='f4'>".__("Packages added or updated in the past 7 days")."</span>";
pjmattal's avatar
pjmattal committed
198
print "</td>";
199
print "<td class='boxSoft'><span class='f4'>$update_count</span></td>";
pjmattal's avatar
pjmattal committed
200
201
202
203
print "</tr>";

print "<tr>";
print "<td class='boxSoft'>";
204
print "<span class='blue'><span class='f4'>".__("Registered Users")."</span></span>";
pjmattal's avatar
pjmattal committed
205
print "</td>";
206
print "<td class='boxSoft'><span class='f4'>$user_count</span></td>";
pjmattal's avatar
pjmattal committed
207
208
print "</tr>";

209
210
print "<tr>";
print "<td class='boxSoft'>";
211
print "<span class='f4'>".__("Trusted Users")."</span>";
212
print "</td>";
213
print "<td class='boxSoft'><span class='f4'>$tu_count</span></td>";
214
215
print "</tr>";

pjmattal's avatar
pjmattal committed
216
217
218
print "</table>";

# Close out the right column
eric's avatar
eric committed
219
220
221
print "  </td>";
print "</tr>\n";
print "</table>\n";
pjmattal's avatar
pjmattal committed
222
# End Table 1
eliott's avatar
eliott committed
223
echo "<br /><span class='important'>".__("DISCLAIMER")."</span>";
eliott's avatar
eliott committed
224
225
echo "  </div>";
echo "</div>";
tardo's avatar
tardo committed
226
html_footer(AUR_VERSION);
227
# vim: ts=2 sw=2 noet ft=php
eric's avatar
eric committed
228
?>