diff options
Diffstat (limited to 'web/lib')
| -rw-r--r-- | web/lib/aur.inc | 4 | ||||
| -rw-r--r-- | web/lib/pkgs.inc | 71 |
2 files changed, 49 insertions, 26 deletions
diff --git a/web/lib/aur.inc b/web/lib/aur.inc index 39c5c92..def41c6 100644 --- a/web/lib/aur.inc +++ b/web/lib/aur.inc @@ -33,7 +33,7 @@ function getTrustedUsers() { $result = db_query($q, $dbh); if ($result) { while ($row = mysql_fetch_assoc($result)) { - $tus[] = $row; + $tus[$row["ID"]] = $row; } } return $tus; @@ -50,7 +50,7 @@ function getDevelopers() { $result = db_query($q, $dbh); if ($result) { while ($row = mysql_fetch_assoc($result)) { - $devs[] = $row; + $devs[$row["ID"]] = $row; } } return $devs; diff --git a/web/lib/pkgs.inc b/web/lib/pkgs.inc index bd63ee2..b9d061e 100644 --- a/web/lib/pkgs.inc +++ b/web/lib/pkgs.inc @@ -114,7 +114,7 @@ function pkg_search_page($L="",$C="",$K="",$SB="",$O=0,$PP=25) { print __("Location")."\n"; print " <option value=p"; $SB == "p" ? print "selected> " : print "> "; - print __("Popularity")."\n"; + print __("Votes")."\n"; print " </select>\n"; print "</td>\n"; @@ -147,17 +147,9 @@ function pkg_search_page($L="",$C="",$K="",$SB="",$O=0,$PP=25) { print "</center>\n"; print "<br />\n"; - print "<center>\n"; - print "<table cellspacing='3' class='boxSoft'>\n"; - print "<tr>\n"; - print " <td class='boxSoftTitle' align='right'>\n"; - print " <span class='f3'Package Listing</span>\n"; - print " </td>\n"; - print " <td class='boxSoft'>\n"; - # query to pull out package info # - $q = "SELECT Packages.*, IF(ISNULL(PackageID), 0, COUNT(*)) AS Popularity "; + $q = "SELECT Packages.*, IF(ISNULL(PackageID), 0, COUNT(*)) AS Votes "; $q.= "FROM Packages LEFT JOIN PackageVotes "; $q.= "ON Packages.ID = PackageVotes.PackageID "; $has_where = 0; @@ -209,18 +201,54 @@ function pkg_search_page($L="",$C="",$K="",$SB="",$O=0,$PP=25) { print "<table cellspacing='3' class='boxSoft'>\n"; print "<tr>\n"; print " <td class='boxSoftTitle' align='right'>\n"; - print " <span class='f3'Package Listing</span>\n"; + print " <span class='f3'>Package Listing</span>\n"; print " </td>\n"; + print "</tr>\n"; + print "<tr>\n"; print " <td class='boxSoft'>\n"; + print "<table width='100%' cellspacing='0' cellpadding='2'>\n"; + print "<tr>\n"; + print " <th style='border-bottom: #666 1px solid; vertical-align:"; + print " bottom'><span class='f2'>".__("Location")."</span></th>\n"; + print " <th style='border-bottom: #666 1px solid; vertical-align:"; + print " bottom'><span class='f2'>".__("Category")."</span></th>\n"; + print " <th style='border-bottom: #666 1px solid; vertical-align:"; + print " bottom'><span class='f2'>".__("Name")."</span></th>\n"; + print " <th style='border-bottom: #666 1px solid; vertical-align:"; + print " bottom'><span class='f2'>".__("Votes")."</span></th>\n"; + print " <th style='border-bottom: #666 1px solid; vertical-align:"; + print " bottom'><span class='f2'>".__("Description")."</span></th>\n"; + print " <th style='border-bottom: #666 1px solid; vertical-align:"; + print " bottom'><span class='f2'>".__("Maintainer")."</span></th>\n"; + print "</tr>\n"; -# for ($i=0; $row = mysql_fetch_assoc($result); $i++) { -# (($i % 2) == 0) ? $c = "data1" : $c = "data2"; -# print "<tr>\n"; -# print "<td "; -# print "</tr>\n"; -# -# } - print "Yippie! You found some packages!"; + for ($i=0; $row = mysql_fetch_assoc($result); $i++) { + (($i % 2) == 0) ? $c = "data1" : $c = "data2"; + print "<tr>\n"; + print " <td class='".$c."'><span class='f5'><span class='blue'>"; + print $locs[$row["LocationID"]]."</span></span></td>\n"; + print " <td class='".$c."'><span class='f5'><span class='blue'>"; + print $cats[$row["CategoryID"]]."</span></span></td>\n"; + print " <td class='".$c."'><span class='f4'><span class='blue'>"; + print $row["Name"]."-".$row["Version"]."</span></span></td>\n"; + print " <td class='".$c."'><span class='f5'><span class='blue'>"; + print " ".$row["Votes"]."</span></span></td>\n"; + print " <td class='".$c."'><span class='f4'><span class='blue'>"; + print $row["Description"]."</span></span></td>\n"; + print " <td class='".$c."'><span class='f5'><span class='blue'>"; + if (isset($devs[$row["MaintainerUID"]])) { + print $devs[$row["MaintainerUID"]]["Username"]; + } elseif (isset($tus[$row["MaintainerUID"]])) { + print $tus[$row["MaintainerUID"]]["Username"]; + } else { + print "None"; + } + print "</span></span></td>\n"; + + print "</tr>\n"; + + } + print "</table>\n"; print " </td>\n"; print "</tr>\n"; @@ -228,11 +256,6 @@ function pkg_search_page($L="",$C="",$K="",$SB="",$O=0,$PP=25) { print "</center>\n"; } - - print " </td>\n"; - print "</tr>\n"; - print "</table>\n"; - print "</center>\n"; return; } |