pkgfuncs.inc 20.3 KB
Newer Older
eric's avatar
eric committed
1
<?
2
include_once("pkgfuncs_po.inc");
eric's avatar
eric committed
3

4
5
6
7
8
# define variables used during pkgsearch
#
$pkgsearch_vars = array("O", "L", "C", "K", "SB", "PP", "do_MyPackages");


eric's avatar
eric committed
9
10
11
# print out the 'return to search results' link
#
function pkgsearch_results_link() {
12
	global $_REQUEST;
eric's avatar
eric committed
13
14
	global $pkgsearch_vars;

eric's avatar
eric committed
15
	$url_data = "<a href='/packages.php?do_Search=1";
eric's avatar
eric committed
16
	while (list($k, $var) = each($pkgsearch_vars)) {
17
		if ($var == "do_MyPackages" && $_REQUEST[$var]) {
eric's avatar
eric committed
18
19
20
21
22
23
24
25
			$url_data.="&".$var."=1";
		} else {
			$url_data.="&".$var."=".rawurlencode(stripslashes($_REQUEST[$var]));
		}
	}
	$url_data .= "'>";
	print __("Go back to %hsearch results%h.",
		array($url_data, "</a>"));
26
	print "\n<br />\n";
eric's avatar
eric committed
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

	return;
}


# see if this Users.ID can manage the package
#
function canManagePackage($uid=0,$AURMUID=0, $MUID=0, $SUID=0, $managed=0) {
	if (!$uid) {return 0;}

	# The uid of the TU/Dev that manages the package
	#
	if ($uid == $AURMUID) {return 1;}

	# If the package isn't maintained by a TU/Dev, is this the user-maintainer?
	#
	if ($uid == $MUID && !$managed) {return 1;}

	# If the package isn't maintained by a TU/Dev, is this the user-submitter?
	#
	if ($uid == $SUID && !$managed) {return 1;}

	# otherwise, no right to manage this package
	#
	return 0;
}

eric's avatar
eric committed
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
# grab the current list of PackageCategories
#
function pkgCategories() {
	$cats = array();
	$dbh = db_connect();
	$q = "SELECT * FROM PackageCategories ";
	$q.= "ORDER BY Category ASC";
	$result = db_query($q, $dbh);
	if ($result) {
		while ($row = mysql_fetch_row($result)) {
			$cats[$row[0]] = $row[1];
		}
	}
	return $cats;
}

# grab the current list of PackageLocations
#
function pkgLocations() {
	$locs = array();
	$dbh = db_connect();
	$q = "SELECT * FROM PackageLocations ";
	$q.= "ORDER BY Location ASC";
	$result = db_query($q, $dbh);
	if ($result) {
		while ($row = mysql_fetch_row($result)) {
			$locs[$row[0]] = $row[1];
		}
	}
	return $locs;
}

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
# grab package dependencies
#
function package_dependencies($pkgid=0) {
	$deps = array();
	if ($pkgid) {
		$dbh = db_connect();
		$q = "SELECT DepPkgID, Name FROM PackageDepends, Packages ";
		$q.= "WHERE PackageDepends.DepPkgID = Packages.ID ";
		$q.= "AND PackageDepends.PackageID = ".mysql_escape_string($pkgid);
		$q.= " ORDER BY Name";
		$result = db_query($q, $dbh);
		if (!$result) {return array();}
		while ($row = mysql_fetch_row($result)) {
			$deps[] = $row;
		}
	}
	return $deps;
}

# grab package sources
#
function package_sources($pkgid=0) {
	$sources = array();
	if ($pkgid) {
		$dbh = db_connect();
		$q = "SELECT Source FROM PackageSources ";
		$q.= "WHERE PackageID = ".mysql_escape_string($pkgid);
		$q.= " ORDER BY Source";
		$result = db_query($q, $dbh);
		if (!$result) {return array();}
		while ($row = mysql_fetch_row($result)) {
			$sources[] = $row[0];
		}
	}
	return $sources;
}

123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144

# grab array of Package.IDs that I've voted for: $pkgs[1234] = 1, ...
#
function pkgvotes_from_sid($sid="") {
	$pkgs = array();
	if (!$sid) {return $pkgs;}
	$dbh = db_connect();
	$q = "SELECT PackageID ";
	$q.= "FROM PackageVotes, Users, Sessions ";
	$q.= "WHERE Users.ID = Sessions.UsersID ";
	$q.= "AND Users.ID = PackageVotes.UsersID ";
	$q.= "AND Sessions.SessionID = '".mysql_escape_string($sid)."'";
	$result = db_query($q, $dbh);
	if ($result) {
		while ($row = mysql_fetch_row($result)) {
			$pkgs[$row[0]] = 1;
		}
	}
	return $pkgs;
}


eric's avatar
eric committed
145
146
147
# display package details
#
function package_details($id=0) {
148
	global $_REQUEST;
eric's avatar
eric committed
149
	global $pkgsearch_vars;
150
151
152
153
154
	$q = "SELECT *,Location,Category ";
	$q.= "FROM Packages,PackageLocations,PackageCategories ";
 	$q.= "WHERE Packages.LocationID = PackageLocations.ID ";
	$q.= "AND Packages.CategoryID = PackageCategories.ID ";
	$q.= "ANd Packages.ID = ".intval($_REQUEST["ID"]);
eric's avatar
eric committed
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
	$dbh = db_connect();
	$results = db_query($q, $dbh);
	if (!$results) {
		print __("Error retrieving package details.")."<br />\n";

	} else {
		$row = mysql_fetch_assoc($results);
		if (empty($row)) {
			print __("Package details could not be found.")."<br />\n";

		} else {

			# print out package details
			#
			print "<br />\n";
			print "<center>\n";
			print "<table cellspacing='3' class='boxSoft'>\n";
			print "<tr>\n";
			print "  <td class='boxSoftTitle' align='right'>";
			print "<span class='f3'>Package Details</span></td>\n";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td class='boxSoft'>\n";
			print "<center>\n";
			print "<table>\n";
			print "<tr>\n";
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
			print "  <td colspan='2'><span class='f2'>";
			print $row["Name"] . "-" . $row["Version"]."</span></td>\n";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'><span class='f3'>";
			print "<a href='".$row["URL"]."'>".$row["URL"]."</a></span></td>\n";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'><span class='f3'>".$row["Description"];
			print "</a></span></td>\n";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'><img src='/images/pad.gif' height='30'></td>";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'><span class='f3'>";
			print $row["Location"]." :: ".$row["Category"]."</span></td>";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'><span class='f3'>".__("Maintainer").": ";
eric's avatar
eric committed
201
			if ($row["AURMaintainerUID"]) {
202
				$maintainer = username_from_id($row["AURMaintainerUID"]);
eric's avatar
eric committed
203
			} elseif ($row["MaintainerUID"]) {
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
				$maintainer = username_from_id($row["MaintainerUID"]);
			} else {
				$maintainer = "None";
			}
			print $maintainer . "</span></td>";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'><img src='/images/pad.gif' height='30'></td>";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td valign='top' style='padding-right: 10'>";
			print "<table class='boxSoft' style='width: 200px'>";
			print "<tr><td class='boxSoftTitle'><span class='f3'>";
			print "Dependencies</span></td></tr>\n";
			print "<tr><td class='boxSoft'>";
			$deps = package_dependencies($row["ID"]); # $deps[0] = array('id','name');
			while (list($k, $darr) = each($deps)) {
eric's avatar
eric committed
221
				$url = "<a href='/packages.php?do_Details=1&ID=".$darr[0];
eric's avatar
eric committed
222
				while(list($k, $var) = each($pkgsearch_vars)) {
223
224
225
226
227
					if ($var == "do_MyPackages" && $_REQUEST[$var]) {
						$url .= "&".$var."=1";
					} else {
						$url .= "&".$var."=".rawurlencode(stripslashes($_REQUEST[$var]));
					}
eric's avatar
eric committed
228
229
230
				}
				reset($pkgsearch_vars);
				print $url."'>".$darr[1]."</a><br />\n";
231
232
233
234
235
236
237
238
239
240
241
			}
			print "</td></tr>\n";
			print "</table></td>";

			print "  <td valign='top'>";
			print "<table class='boxSoft' style='width: 200px'>";
			print "<tr><td class='boxSoftTitle'><span class='f3'>";
			print "Sources</span></td></tr>\n";
			print "<tr><td class='boxSoft'>";
			$sources = package_sources($row["ID"]); # $sources[0] = 'src';
			while (list($k, $src) = each($sources)) {
eric's avatar
eric committed
242
				print "<a href='".$src."'>".$src."</a><br />\n";
243
244
245
246
			}
			print "</td></tr>\n";
			print "</table></td>";

eric's avatar
eric committed
247
248
249
250
251
252
253
254
255
256
257
258
259
260
			print "</tr>\n";

			print "</table>\n";
			print "</center>\n";
			print "  </td>\n";
			print "</tr>\n";

			print "</table>\n";
		}
	}
	return;
}


eric's avatar
eric committed
261
262
# display the search form in a boxSoft style
#
263
264
function pkg_search_page($SID="") {
	global $_REQUEST;
eric's avatar
eric committed
265
	global $pkgsearch_vars;
266
	# SID: session id cookie
eric's avatar
eric committed
267

eric's avatar
eric committed
268
269
	$locs = pkgLocations();
	$cats = pkgCategories();
270
271
272
	$devs = getDevelopers();
	$tus = getTrustedUsers();
	$dbh = db_connect();
eric's avatar
eric committed
273

274

275
276
	# determine paging variables
	#
eric's avatar
eric committed
277
	$_REQUEST["PP"] ? $PP = intval($_REQUEST["PP"]) : $PP = 25;
eric's avatar
eric committed
278
279
	if ($PP < 25) {$PP = 25;}
	if ($PP > 100) {$PP = 100;}
eric's avatar
eric committed
280
281
	$_REQUEST["O"] ? $O = intval($_REQUEST["O"]) : $O = 0;
	if ($_REQUEST["do_More"]) {
282
		$O += $PP;
eric's avatar
eric committed
283
	} elseif ($_REQUEST["do_Less"]) {
284
		$O -= $PP;
eric's avatar
eric committed
285
	}
286
287
	if ($O < 0) {
		$O = 0;
eric's avatar
eric committed
288
	}
289
290
	if ($_REQUEST["do_Search"] && $_REQUEST["do_Search"] != 1) {
		# reset the offset to zero if they hit Go
eric's avatar
eric committed
291
		#
eric's avatar
eric committed
292
		$_REQUEST["do_MyPackages"] = 0;
eric's avatar
eric committed
293
294
		$O = 0;
	}
295
	$_REQUEST["O"] = $O; # so that pkg_search_results() works
eric's avatar
eric committed
296

297

298
299
300
301
302
	# grab info for user if they're logged in
	#
	if ($SID) {
		$myuid = uid_from_sid($SID);
		$acct = account_from_sid($SID);
303
		$my_votes = pkgvotes_from_sid($SID);
304
305
306
307
	}

	# The search form
	#
eric's avatar
eric committed
308
	print "<form action='/packages.php' method='post'>\n";
309
	print "<input type='hidden' name='O' value='".$O."'>\n";
310

eric's avatar
eric committed
311
312
313
314
	print "<center>\n";
	print "<table cellspacing='3' class='boxSoft'>\n";
	print "<tr>\n";
	print "  <td class='boxSoftTitle' align='right'>\n";
315
	print "    <span class='f3'>".__("Search Criteria")."</span>\n";
eric's avatar
eric committed
316
317
318
319
320
321
322
323
324
	print "  </td>\n";
	print "</tr>\n";
	print "<tr>\n";
	print "  <td class='boxSoft'>\n";
	print "<table style='width: 100%' align='center'>\n";

	print "<tr>\n";
	print "<td align='right'>\n";
	print "  <span class='f5'><span class='blue'>".__("Location");
325
	print "</span></span><br />\n";
eric's avatar
eric committed
326
327
328
	print "  <select name='L'>\n";
	print "  <option value=0> ".__("Any")."\n";
	while (list($id, $loc) = each($locs)) {
eric's avatar
eric committed
329
		if (intval($_REQUEST["L"]) == $id) {
eric's avatar
eric committed
330
331
332
333
334
335
336
337
338
339
			print "  <option value=".$id." selected> ".$loc."\n";
		} else {
			print "  <option value=".$id."> ".$loc."\n";
		}
	}
	print "  </select>\n";
	print "</td>\n";

	print "<td align='right'>\n";
	print "  <span class='f5'><span class='blue'>".__("Category");
340
	print "</span></span><br />\n";
eric's avatar
eric committed
341
342
343
	print "  <select name='C'>\n";
	print "  <option value=0> ".__("Any")."\n";
	while (list($id, $cat) = each($cats)) {
eric's avatar
eric committed
344
		if (intval($_REQUEST["C"]) == $id) {
eric's avatar
eric committed
345
346
347
348
349
350
351
352
353
354
			print "  <option value=".$id." selected> ".$cat."\n";
		} else {
			print "  <option value=".$id."> ".$cat."\n";
		}
	}
	print "  </select>\n";
	print "</td>\n";

	print "<td align='right'>\n";
	print "  <span class='f5'><span class='blue'>".__("Keywords");
355
	print "</span></span><br />\n";
eric's avatar
eric committed
356
	print "  <input type='text' name='K' size='35'";
eric's avatar
eric committed
357
358
	$K = str_replace("\"", "", $_REQUEST["K"]); # TODO better testing for
                                              # SQL trickery...
359
	print " value=\"".stripslashes($K)."\" maxlength='35'>\n";
eric's avatar
eric committed
360
361
362
363
	print "</td>\n";

	print "<td align='right'>\n";
	print "  <span class='f5'><span class='blue'>".__("Sort by");
364
	print "</span></span><br />\n";
eric's avatar
eric committed
365
	print "  <select name='SB'>\n";
366
	print "  <option value=n";
367
	$_REQUEST["SB"] == "n" ? print " selected> " : print "> ";
368
	print __("Name")."\n";
eric's avatar
eric committed
369
	print "  <option value=c";
370
	$_REQUEST["SB"] == "c" ? print " selected> " : print "> ";
eric's avatar
eric committed
371
372
	print __("Category")."\n";
	print "  <option value=l";
373
	$_REQUEST["SB"] == "l" ? print " selected> " : print "> ";
eric's avatar
eric committed
374
	print __("Location")."\n";
375
	print "  <option value=v";
376
	$_REQUEST["SB"] == "v" ? print " selected> " : print "> ";
377
	print __("Votes")."\n";
eric's avatar
eric committed
378
379
380
381
382
	print "  </select>\n";
	print "</td>\n";

	print "<td align='right'>\n";
	print "  <span class='f5'><span class='blue'>".__("Per page");
383
	print "</span></span><br />\n";
eric's avatar
eric committed
384
385
	print "  <select name='PP'>\n";
	print "  <option value=25";
386
	$PP == 25 ? print " selected> 25\n" : print "> 25\n";
eric's avatar
eric committed
387
	print "  <option value=50";
388
	$PP == 50 ? print " selected> 50\n" : print "> 50\n";
eric's avatar
eric committed
389
	print "  <option value=75";
390
	$PP == 75 ? print " selected> 75\n" : print "> 75\n";
eric's avatar
eric committed
391
	print "  <option value=100";
392
	$PP == 100 ? print " selected> 100\n" : print "> 100\n";
eric's avatar
eric committed
393
394
395
396
	print "  </select>\n";
	print "</td>\n";

	print "<td align='right' valign='bottom'>&nbsp;\n";
397
398
	print "  <input type='submit' class='button' name='do_Search'";
	print " value='".__("Go")."'>\n";
eric's avatar
eric committed
399
400
	print "</td>\n";

401
402
	if ($SID) {
		print "<td align='right' valign='bottom'>&nbsp;\n";
403
		print "  <input type='submit' class='button' name='do_MyPackages'";
404
405
406
407
	 	print "	value='".__("My Packages")."'>\n";
		print "</td>\n";
	}

eric's avatar
eric committed
408
409
	print "</tr>\n";
	print "</table>\n";
410
411
412
413
414
415
416
417
418

	print "  </td>\n";
	print "</tr>\n";
	print "</table>\n";
	print "</center>\n";
	print "<br />\n";

	# query to pull out package info
	#
419
420
421
422
#	$q = "SELECT Packages.*, IF(ISNULL(PackageID), 0, COUNT(*)) AS Votes ";
#	$q.= "FROM Packages LEFT JOIN PackageVotes ";
#	$q.= "ON Packages.ID = PackageVotes.PackageID ";
	$q = "SELECT * FROM Packages ";
423
	$has_where = 0;
eric's avatar
eric committed
424
	if (intval($_REQUEST["L"])) {
eric's avatar
eric committed
425
		$q.= "WHERE LocationID = ".intval($_REQUEST["L"])." ";
426
427
		$has_where = 1;
	}
eric's avatar
eric committed
428
	if (intval($_REQUEST["C"])) {
429
		if (!$has_where) {
eric's avatar
eric committed
430
			$q.= "WHERE CategoryID = ".intval($_REQUEST["C"])." ";
431
432
			$has_where = 1;
		} else {
eric's avatar
eric committed
433
			$q.= "AND CategoryID = ".intval($_REQUEST["C"])." ";
434
435
436
437
438
439
440
441
442
443
444
445
		}
	}
	if ($K) {
		if (!$has_where) {
			$q.= "WHERE (Name LIKE '".mysql_escape_string($K)."%' OR ";
			$q.= "Description LIKE '%".mysql_escape_string($K)."%') ";
			$has_where = 1;
		} else {
			$q.= "AND (Name LIKE '".mysql_escape_string($K)."%' OR ";
			$q.= "Description LIKE '%".mysql_escape_string($K)."%') ";
		}
	}
eric's avatar
eric committed
446
	if ($_REQUEST["do_MyPackages"] && $SID) {
eric's avatar
eric committed
447
448
449
		# list packages that the user is a AUR Maintainer of, or if it the
		# vistior is a registered user, if they are the Maintainer.
		#
450
451
		if ($myuid) {
			if (!$has_where) {
eric's avatar
eric committed
452
				$q.= "WHERE (AURMaintainerUID = ".$myuid." OR ";
eric's avatar
eric committed
453
				$q.= "MaintainerUID = ".$myuid." OR SubmitterUID = ".$myuid.") ";
454
455
				$has_where = 1;
			} else {
eric's avatar
eric committed
456
				$q.= "AND (AURMaintainerUID = ".$myuid." OR ";
eric's avatar
eric committed
457
				$q.= "MaintainerUID = ".$myuid." OR SubmitterUID = ".$myuid.") ";
458
459
460
			}
		}
	}
461

eric's avatar
eric committed
462
	switch ($_REQUEST["SB"]) {
463
		case 'c':
eric's avatar
eric committed
464
			$q.= "ORDER BY CategoryID DESC, Name ASC, LocationID ASC ";
465
466
			break;
		case 'l':
eric's avatar
eric committed
467
			$q.= "ORDER BY LocationID ASC, Name ASC, CategoryID DESC ";
468
			break;
469
		case 'v':
eric's avatar
eric committed
470
			$q.= "ORDER BY NumVotes DESC, Name ASC, CategoryID DESC ";
471
			break;
472
		default:
eric's avatar
eric committed
473
			$q.= "ORDER BY Name ASC, LocationID ASC, CategoryID DESC ";
474
475
			break;
	}
476
	$q.= "LIMIT ".$O.", ".$PP;
477

478
479
	$result = db_query($q, $dbh);
	if (!$result) {
480
		print __("Error retrieving package list.");
481

eric's avatar
eric committed
482
483
484
485
	} elseif (!mysql_num_rows($result)) {
		print __("No packages matched your search criteria.");

	} else {
486
487

		if ($SID) {
eric's avatar
eric committed
488
489
			# The 'Actions' table
			#
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
			print "<center>\n";
			print "<table cellspacing='3' class='boxSoft'>\n";
			print "<tr>\n";
			print "  <td class='boxSoftTitle' align='right'>\n";
			print "    <span class='f3'>".__("Actions")."</span>\n";
			print "  </td>\n";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td class='boxSoft'>\n";
			print "<table style='width: 100%' align='center'>\n";
			print "<tr>\n";
			print "  <td align='center'>";
			print "<input type='submit' class='button' name='do_Flag'";
			print "	value='".__("Flag Out-of-date")."'></td>\n";
			print "  <td align='center'>";
505
506
507
			print "<input type='submit' class='button' name='do_UnFlag'";
			print "	value='".__("Unflag Out-of-date")."'></td>\n";
			print "  <td align='center'>";
508
509
510
511
512
513
514
515
			print "<input type='submit' class='button' name='do_Adopt'";
			print "	value='".__("Adopt Packages")."'></td>\n";
			print "  <td align='center'>";
			print "<input type='submit' class='button' name='do_Disown'";
			print "	value='".__("Disown Packages")."'></td>\n";
			print "  <td align='center'>";
			print "<input type='submit' class='button' name='do_Vote'";
			print "	value='".__("Vote")."'></td>\n";
516
517
518
			print "  <td align='center'>";
			print "<input type='submit' class='button' name='do_UnVote'";
			print "	value='".__("Un-Vote")."'></td>\n";
519
520
521
522
523
524
525
526
527
			print "</tr>\n";
			print "</table>\n";
			print "  </td>\n";
			print "</tr>\n";
			print "</table>\n";
			print "</center>\n";
			print "<br />\n";
		}

528
529
530
531
532
533
		# print out package search results
		#
		print "<center>\n";
		print "<table cellspacing='3' class='boxSoft'>\n";
		print "<tr>\n";
		print "  <td class='boxSoftTitle' align='right'>\n";
534
		print "    <span class='f3'>Package Listing</span>\n";
535
		print "  </td>\n";
536
537
		print "</tr>\n";
		print "<tr>\n";
538
		print "  <td class='boxSoft'>\n";
539
540
		print "<table width='100%' cellspacing='0' cellpadding='2'>\n";
		print "<tr>\n";
541
542
543
544
		if ($SID) {
			print "  <th style='border-bottom: #666 1px solid; vertical-align:";
			print " bottom'>&nbsp;</th>\n";
		}
545
546
547
548
549
550
551
552
		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";
553
554
555
556
		if ($SID) {
			print "  <th style='border-bottom: #666 1px solid; vertical-align:";
			print " bottom'><span class='f2'>".__("Vote")."</span></th>\n";
		}
557
558
559
560
		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";
561
562
563
564
565
# REMOVED LINK TO 'pkgmgmnt.php'
#		if ($SID) {
#			print "  <th style='border-bottom: #666 1px solid; vertical-align:";
#			print " bottom'><span class='f2'>".__("Manage")."</span></th>\n";
#		}
566
		print "</tr>\n";
567

568
569
570
		for ($i=0; $row = mysql_fetch_assoc($result); $i++) {
			(($i % 2) == 0) ? $c = "data1" : $c = "data2";
			print "<tr>\n";
571
572
573
574
575
			if ($SID) {
				print "  <td class='".$c."'>";
				if ($row["OutOfDate"]) {
					print "<span style='background-color: red'>";
				}
576
577
578
579
580
581
				print "<input type='checkbox' name='IDs[".$row["ID"]."]' value='1'>";
#				if ($i == 0) {
#					$all_ids = $row["ID"];
#				} else {
#					$all_ids .= ":".$row["ID"];
#				}
582
583
584
585
586
				if ($row["OutOfDate"]) {
					print "</span>";
				}
				print "</td>\n";
			}
587
588
589
590
			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";
591
			print "  <td class='".$c."'><span class='f4'>";
eric's avatar
eric committed
592
			$url = "<a href='/packages.php?";
eric's avatar
eric committed
593
594
			$url .= "do_Details=1&ID=";
			$url .= $row["ID"];
eric's avatar
eric committed
595
596
597
598
599
			while (list($k, $var) = each($pkgsearch_vars)) {
				# I'm never convinced how to do this encoding/decoding properly.
				# php.net recommends htmlentities(urlencode(data)), but that
				# doesn't work!
				#
600
601
602
603
604
				if ($var == "do_MyPackages" && $_REQUEST[$var]) {
					$url .= "&".$var."=1";
				} else {
					$url .= "&".$var."=".rawurlencode(stripslashes($_REQUEST[$var]));
				}
eric's avatar
eric committed
605
			}
eric's avatar
eric committed
606
607
608
609
			reset($pkgsearch_vars);
			$url.= "'><span class='black'>".$row["Name"];
			$url.= "-".$row["Version"]."</span></a>";
			print $url."</span></td>\n";
610
			print "  <td class='".$c."'><span class='f5'><span class='blue'>";
611
			print "&nbsp;&nbsp;&nbsp;".$row["NumVotes"]."</span></span></td>\n";
612
613
614
615
616
617
618
619
			if ($SID) {
				print "  <td class='".$c."'><span class='f5'><span class='blue'>";
				if (isset($my_votes[$row["ID"]])) {
					print "&nbsp;&nbsp;".__("Yes")."</span></td>\n";
				} else {
					print "&nbsp;</span></td>\n";
				}
			}
620
621
622
			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'>";
eric's avatar
eric committed
623
624
625
626

			# print the package manager, also determine if it is managed
			#
			$managed = 1;
eric's avatar
eric committed
627
628
629
630
			if (isset($devs[$row["AURMaintainerUID"]])) {
				print $devs[$row["AURMaintainerUID"]]["Username"];
			} elseif (isset($tus[$row["AURMaintainerUID"]])) {
				print $tus[$row["AURMaintainerUID"]]["Username"];
631
632
			} else {
				print "None";
eric's avatar
eric committed
633
				$managed = 0;
634
635
			}
			print "</span></span></td>\n";
eric's avatar
eric committed
636

637
638
639
640
641
642
643
644
645
646
647
648
# REMOVED LINK TO 'pkgmgmnt.php'
#			# print the managed link if applicable
#			#
#			if (canManagePackage($myuid, $row["AURMaintainerUID"],
#					$row["MaintainerUID"], $row["SubmitterUID"], $managed)) {
#				$manage_url = "<a href='/pkgmgmnt.php?ID=";
#				$manage_url.= $row["ID"]."'><span class='black'>Manage</span></a>";
#				print "  <td class='".$c."'><span class='f4'>";
#				print $manage_url."</span></td>\n";
#			} else {
#				print "<td class='".$c."'><span class='f4'>&nbsp;</span></td>\n";
#			}
649
650
651
652
653

			print "</tr>\n";

		}
		print "</table>\n";
eric's avatar
eric committed
654
655
656
		print "  </td>\n";
		print "</tr>\n";
		print "</table>\n";
657
#		print "<input type='hidden' name='All_IDs' value='".$all_ids."'>\n";
eric's avatar
eric committed
658
659
660
		if ($_REQUEST["do_MyPackages"]) {
			print "<input type='hidden' name='do_MyPackages' value='1'>\n";
		}
661

eric's avatar
eric committed
662
663
664
665
666
667
		print "<table width='90%' cellspacing='0' cellpadding='2'>\n";
		print "<tr>\n";
		print "  <td>\n";
		print "  <table border='0' cellpadding='0' cellspacing='0' width='100%'>\n";
		print "  <tr>\n";
		print "    <td align='left'>";
668
		print "    <input type='submit' class='button' name='do_Less'";
eric's avatar
eric committed
669
670
671
		print " value='&lt;-- ".__("Less")."'>\n";
		print "    </td>\n";
		print "    <td align='right'>";
672
		print "    <input type='submit' class='button' name='do_More'";
eric's avatar
eric committed
673
674
675
676
		print " value='".__("More")." --&gt;'>\n";
		print "    </td>\n";
		print "  </tr>\n";
		print "  </table>\n";
677
678
679
680
681
		print "  </td>\n";
		print "</tr>\n";
		print "</table>\n";
		print "</center>\n";
	}
682
	print "</form>\n";
683

eric's avatar
eric committed
684
685
686
687
688
	return;
}

# vim: ts=2 sw=2 noet ft=php
?>