pkgfuncs.inc 25 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
# grab the current list of PackageCategories
#
function pkgCategories() {
	$cats = array();
	$dbh = db_connect();
59
	$q = "SELECT * FROM PackageCategories WHERE ID != 1 ";
eric's avatar
eric committed
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
	$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();
75
	$q = "SELECT * FROM PackageLocations WHERE ID != 1 ";
eric's avatar
eric committed
76
77
78
79
80
81
82
83
84
85
	$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
# check to see if the package name exists
#
function package_exists($name="") {
	if (!$name) {return NULL;}
	$dbh = db_connect();
	$q = "SELECT ID FROM Packages ";
	$q.= "WHERE Name = '".mysql_escape_string($name)."' ";
	$q.= "AND DummyPkg = 0";
	$result = db_query($q, $dbh);
	if (!$result) {return NULL;}
	$row = mysql_fetch_row($result);
	return $row[0];
}

100
101
102
103
104
105
# grab package dependencies
#
function package_dependencies($pkgid=0) {
	$deps = array();
	if ($pkgid) {
		$dbh = db_connect();
106
		$q = "SELECT DepPkgID, Name, DummyPkg FROM PackageDepends, Packages ";
107
108
109
110
111
112
113
114
115
116
117
118
		$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;
}

119
120
121
122
123
124
# create a dummy package and return it's Packages.ID  if it already exists,
# return the existing ID
#
function create_dummy($pname="", $sid="") {
	if ($pname && $sid) {
		$uid = uid_from_sid($sid);
jchu's avatar
jchu committed
125
		if (!$uid) {return NULL;}
126
127
128
129
		$dbh = db_connect();
		$q = "SELECT ID FROM Packages WHERE Name = '";
		$q.= mysql_escape_string($pname)."'";
		$result = db_query($q, $dbh);
jchu's avatar
jchu committed
130
		if (!mysql_num_rows($result)) {
131
132
			# Insert the dummy
			#
133
			$q = "INSERT INTO Packages (Name, Description, URL, SubmittedTS, ";
134
			$q.= "SubmitterUID, DummyPkg) VALUES ('";
135
			$q.= mysql_escape_string($pname)."', 'A dummy package', '/#', ";
136
			$q.= "UNIX_TIMESTAMP(), ".$uid.", 1)";
137
138
139
140
			$result = db_query($q, $dbh);
			if (!$result) {
				return NULL;
			}
jchu's avatar
jchu committed
141
			return mysql_insert_id($dbh);
142
143
		} else {
			$data = mysql_fetch_row($result);
jchu's avatar
jchu committed
144
			return $data[0];
145
146
147
148
149
150
		}
	}
	return NULL;

}

eric's avatar
eric committed
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
# grab package comments
#
function package_comments($pkgid=0) {
	$comments = array();
	if ($pkgid) {
		$dbh = db_connect();
		$q = "SELECT UserName, Comments, CommentTS ";
		$q.= "FROM PackageComments, Users ";
		$q.= "WHERE PackageComments.UsersID = Users.ID";
		$q.= " AND PackageID = ".mysql_escape_string($pkgid);
		$q.= " AND DelUsersID = 0"; # only display non-deleted comments
		$q.= " ORDER BY CommentTS ASC";
		$result = db_query($q, $dbh);
		if (!$result) {return array();}
		while ($row = mysql_fetch_assoc($result)) {
			$comments[] = $row;
		}
	}
	return $comments;
}

172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
# 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;
}

190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211

# 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
212
213
214
# display package details
#
function package_details($id=0) {
215
	global $_REQUEST;
eric's avatar
eric committed
216
	global $pkgsearch_vars;
jchu's avatar
jchu committed
217
	$q = "SELECT Packages.*,Location,Category ";
218
219
220
	$q.= "FROM Packages,PackageLocations,PackageCategories ";
 	$q.= "WHERE Packages.LocationID = PackageLocations.ID ";
	$q.= "AND Packages.CategoryID = PackageCategories.ID ";
221
	$q.= "AND Packages.ID = ".intval($_REQUEST["ID"]);
eric's avatar
eric committed
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
	$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'>";
eric's avatar
eric committed
241
			print "<span class='f3'>".__("Package Details")."</span></td>\n";
eric's avatar
eric committed
242
243
244
245
246
247
			print "</tr>\n";
			print "<tr>\n";
			print "  <td class='boxSoft'>\n";
			print "<center>\n";
			print "<table>\n";
			print "<tr>\n";
248
			print "  <td colspan='2'><span class='f2'>";
249
			print $row["Name"] . " " . $row["Version"]."</span></td>\n";
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
			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
268
			if ($row["AURMaintainerUID"]) {
269
				$maintainer = username_from_id($row["AURMaintainerUID"]);
eric's avatar
eric committed
270
			} elseif ($row["MaintainerUID"]) {
271
272
273
274
275
276
277
				$maintainer = username_from_id($row["MaintainerUID"]);
			} else {
				$maintainer = "None";
			}
			print $maintainer . "</span></td>";
			print "</tr>\n";
			print "<tr>\n";
jchu's avatar
jchu committed
278
279
280
281
			print "  <td colspan='2'><img src='/images/pad.gif' height='15'></td>";
			print "</tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'><span class='f3'>";
jchu's avatar
jchu committed
282
			print "<a href='".$row['URLPath']."'>Tarball</a> :: <a href='".dirname($row['URLPath'])."/".$row['Name']."'>Files</a></span></td>";
jchu's avatar
jchu committed
283
284
			print "</tr>\n";
			print "<tr>\n";
285
286
287
288
289
290
			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'>";
eric's avatar
eric committed
291
			print __("Dependencies")."</span></td></tr>\n";
292
			print "<tr><td class='boxSoft'>";
293
			$deps = package_dependencies($row["ID"]); # $deps[0] = array('id','name', 'dummy');
294
			while (list($k, $darr) = each($deps)) {
eric's avatar
eric committed
295
				$url = "<a href='/packages.php?do_Details=1&ID=".$darr[0];
eric's avatar
eric committed
296
				while(list($k, $var) = each($pkgsearch_vars)) {
297
298
299
300
301
					if ($var == "do_MyPackages" && $_REQUEST[$var]) {
						$url .= "&".$var."=1";
					} else {
						$url .= "&".$var."=".rawurlencode(stripslashes($_REQUEST[$var]));
					}
eric's avatar
eric committed
302
303
				}
				reset($pkgsearch_vars);
304
305
				if ($darr[2] == 0) print $url."'>".$darr[1]."</a><br />\n";
				else print "<a href='#'>".$darr[1]."</a><br />\n";
306
307
308
309
310
311
312
			}
			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'>";
eric's avatar
eric committed
313
			print __("Sources")."</span></td></tr>\n";
314
315
316
			print "<tr><td class='boxSoft'>";
			$sources = package_sources($row["ID"]); # $sources[0] = 'src';
			while (list($k, $src) = each($sources)) {
317
318
319
320
321
322
323
324
325
				$parsed_url = parse_url($src);
				if ($parsed_url['scheme'])
				{
					//It is an external source
					print "<a href='".$src."'>".$src."</a><br />\n";
				}
				else 
				{
					//It is presumably an internal source
eric's avatar
eric committed
326
327
					print "<a href='".dirname($row['URLPath'])."/".$row['Name'];
					print "/".$src."'>".$src."</a><br />\n";
328
				}
329
330
331
			}
			print "</td></tr>\n";
			print "</table></td>";
eric's avatar
eric committed
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
			print "</tr>\n";

			# Display package comments
			#
			$comments = package_comments($row["ID"]);
			if (!empty($comments)) {
				while (list($indx, $carr) = each($comments)) {
					print "<tr>\n";
					print "  <td colspan='2'>";
					print "<img src='/images/pad.gif' height='2'></td></tr>\n";

					print "<tr>\n";
					print "  <td valign='top' style='padding-right: 10' colspan='2'>";
					print "<table class='boxSoft' width='100%'>";
					print "<tr><td class='boxSoftTitle'><span class='f3'>";
					print __("Comment by: %h%s%h on %h%s%h",
							array("<b>",$carr["UserName"],"</b>",
							      "<i>",date("Ymd [H:i:s]",$carr["CommentTS"]),"</i>"));
					print "</span></td></tr>\n";
					print "<tr><td class='boxSoft'>";
					print "<pre>\n";
					print str_replace('"',"&quot;", stripslashes($carr["Comments"]));
					print "</pre>\n";
					print "</td></tr>\n";
					print "</table>\n";
					print "  </td>\n";
					print "</tr>\n";
				}
			}
361

eric's avatar
eric committed
362
363
364
365
366
367
368
369
370
371
372
			print "<tr>\n";
			print "  <td colspan='2'><img src='/images/pad.gif' height='2'>";
			print "</td></tr>\n";
			print "<tr>\n";
			print "  <td colspan='2'>";
			print "<form action='/pkgedit.php' method='post'>\n";
			print "<input type='hidden' name='ID' value='".$row["ID"]."'>\n";
			print "<input type='submit' class='button' name='add_Comment' value=\"";
			print __("Add Comment")."\">";
			print "</form>\n";
			print "  </td>";
eric's avatar
eric committed
373
374
375
376
377
378
379
380
381
382
383
384
385
386
			print "</tr>\n";

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

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


eric's avatar
eric committed
387
388
# display the search form in a boxSoft style
#
389
390
function pkg_search_page($SID="") {
	global $_REQUEST;
eric's avatar
eric committed
391
	global $pkgsearch_vars;
392
	# SID: session id cookie
eric's avatar
eric committed
393

eric's avatar
eric committed
394
395
	$locs = pkgLocations();
	$cats = pkgCategories();
396
397
398
	$devs = getDevelopers();
	$tus = getTrustedUsers();
	$dbh = db_connect();
eric's avatar
eric committed
399

400

401
402
	# determine paging variables
	#
eric's avatar
eric committed
403
	$_REQUEST["PP"] ? $PP = intval($_REQUEST["PP"]) : $PP = 25;
eric's avatar
eric committed
404
405
	if ($PP < 25) {$PP = 25;}
	if ($PP > 100) {$PP = 100;}
eric's avatar
eric committed
406
407
	$_REQUEST["O"] ? $O = intval($_REQUEST["O"]) : $O = 0;
	if ($_REQUEST["do_More"]) {
408
		$O += $PP;
eric's avatar
eric committed
409
	} elseif ($_REQUEST["do_Less"]) {
410
		$O -= $PP;
eric's avatar
eric committed
411
	}
412
413
	if ($O < 0) {
		$O = 0;
eric's avatar
eric committed
414
	}
415
416
	if ($_REQUEST["do_Search"] && $_REQUEST["do_Search"] != 1) {
		# reset the offset to zero if they hit Go
eric's avatar
eric committed
417
		#
eric's avatar
eric committed
418
		$_REQUEST["do_MyPackages"] = 0;
eric's avatar
eric committed
419
420
		$O = 0;
	}
421
	$_REQUEST["O"] = $O; # so that pkg_search_results() works
eric's avatar
eric committed
422

423

424
425
426
427
428
	# grab info for user if they're logged in
	#
	if ($SID) {
		$myuid = uid_from_sid($SID);
		$acct = account_from_sid($SID);
429
		$my_votes = pkgvotes_from_sid($SID);
430
431
432
433
	}

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

eric's avatar
eric committed
437
438
439
440
	print "<center>\n";
	print "<table cellspacing='3' class='boxSoft'>\n";
	print "<tr>\n";
	print "  <td class='boxSoftTitle' align='right'>\n";
441
	print "    <span class='f3'>".__("Search Criteria")."</span>\n";
eric's avatar
eric committed
442
443
444
445
446
447
448
449
450
	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");
451
	print "</span></span><br />\n";
eric's avatar
eric committed
452
453
454
	print "  <select name='L'>\n";
	print "  <option value=0> ".__("Any")."\n";
	while (list($id, $loc) = each($locs)) {
eric's avatar
eric committed
455
		if (intval($_REQUEST["L"]) == $id) {
eric's avatar
eric committed
456
457
458
459
460
461
462
463
464
465
			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");
466
	print "</span></span><br />\n";
eric's avatar
eric committed
467
468
469
	print "  <select name='C'>\n";
	print "  <option value=0> ".__("Any")."\n";
	while (list($id, $cat) = each($cats)) {
eric's avatar
eric committed
470
		if (intval($_REQUEST["C"]) == $id) {
eric's avatar
eric committed
471
472
473
474
475
476
477
478
479
480
			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");
481
	print "</span></span><br />\n";
eric's avatar
eric committed
482
	print "  <input type='text' name='K' size='35'";
eric's avatar
eric committed
483
484
	$K = str_replace("\"", "", $_REQUEST["K"]); # TODO better testing for
                                              # SQL trickery...
485
	print " value=\"".stripslashes($K)."\" maxlength='35'>\n";
eric's avatar
eric committed
486
487
488
489
	print "</td>\n";

	print "<td align='right'>\n";
	print "  <span class='f5'><span class='blue'>".__("Sort by");
490
	print "</span></span><br />\n";
eric's avatar
eric committed
491
	print "  <select name='SB'>\n";
492
	print "  <option value=n";
493
	$_REQUEST["SB"] == "n" ? print " selected> " : print "> ";
494
	print __("Name")."\n";
eric's avatar
eric committed
495
	print "  <option value=c";
496
	$_REQUEST["SB"] == "c" ? print " selected> " : print "> ";
eric's avatar
eric committed
497
498
	print __("Category")."\n";
	print "  <option value=l";
499
	$_REQUEST["SB"] == "l" ? print " selected> " : print "> ";
eric's avatar
eric committed
500
	print __("Location")."\n";
501
	print "  <option value=v";
502
	$_REQUEST["SB"] == "v" ? print " selected> " : print "> ";
503
	print __("Votes")."\n";
eric's avatar
eric committed
504
505
506
507
508
	print "  </select>\n";
	print "</td>\n";

	print "<td align='right'>\n";
	print "  <span class='f5'><span class='blue'>".__("Per page");
509
	print "</span></span><br />\n";
eric's avatar
eric committed
510
511
	print "  <select name='PP'>\n";
	print "  <option value=25";
512
	$PP == 25 ? print " selected> 25\n" : print "> 25\n";
eric's avatar
eric committed
513
	print "  <option value=50";
514
	$PP == 50 ? print " selected> 50\n" : print "> 50\n";
eric's avatar
eric committed
515
	print "  <option value=75";
516
	$PP == 75 ? print " selected> 75\n" : print "> 75\n";
eric's avatar
eric committed
517
	print "  <option value=100";
518
	$PP == 100 ? print " selected> 100\n" : print "> 100\n";
eric's avatar
eric committed
519
520
521
522
	print "  </select>\n";
	print "</td>\n";

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

527
528
	if ($SID) {
		print "<td align='right' valign='bottom'>&nbsp;\n";
529
		print "  <input type='submit' class='button' name='do_MyPackages'";
530
531
532
533
	 	print "	value='".__("My Packages")."'>\n";
		print "</td>\n";
	}

534
535
536
537
538
	print "<td align='right' valign='bottom'>&nbsp;\n";
	print "  <input type='submit' class='button' name='do_Orphans'";
	print " value='".__("Orphans")."'>\n";
	print "</td>\n";

eric's avatar
eric committed
539
540
	print "</tr>\n";
	print "</table>\n";
541
542
543
544
545
546
547
548
549

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

	# query to pull out package info
	#
550
551
552
553
#	$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 ";
554
555
556
	$q.= "WHERE DummyPkg != 1 ";
	$has_where = 1;

eric's avatar
eric committed
557
	if (intval($_REQUEST["L"])) {
pjmattal's avatar
pjmattal committed
558
559
560
561
562
		if (!$has_where) {
		  $q.= "WHERE LocationID = ".intval($_REQUEST["L"])." ";
		} else {
			$q .= "AND LocationID = ".intval($_REQUEST["L"])." ";
		}
563
564
		$has_where = 1;
	}
eric's avatar
eric committed
565
	if (intval($_REQUEST["C"])) {
566
		if (!$has_where) {
eric's avatar
eric committed
567
			$q.= "WHERE CategoryID = ".intval($_REQUEST["C"])." ";
568
569
			$has_where = 1;
		} else {
eric's avatar
eric committed
570
			$q.= "AND CategoryID = ".intval($_REQUEST["C"])." ";
571
572
573
574
575
576
577
578
579
580
581
582
		}
	}
	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
583
	if ($_REQUEST["do_MyPackages"] && $SID) {
eric's avatar
eric committed
584
585
586
		# list packages that the user is a AUR Maintainer of, or if it the
		# vistior is a registered user, if they are the Maintainer.
		#
587
588
		if ($myuid) {
			if (!$has_where) {
eric's avatar
eric committed
589
				$q.= "WHERE (AURMaintainerUID = ".$myuid." OR ";
eric's avatar
eric committed
590
				$q.= "MaintainerUID = ".$myuid." OR SubmitterUID = ".$myuid.") ";
591
592
				$has_where = 1;
			} else {
eric's avatar
eric committed
593
				$q.= "AND (AURMaintainerUID = ".$myuid." OR ";
eric's avatar
eric committed
594
				$q.= "MaintainerUID = ".$myuid." OR SubmitterUID = ".$myuid.") ";
595
596
597
			}
		}
	}
598
599
600
601
602
603
604
605
606
607
608
609
	if ($_REQUEST["do_Orphans"]) {
		# List packages that have neither a Maintainer nor AURMaintainer
		#
			if (!$has_where) {
				$q.= "WHERE (AURMaintainerUID = 0 AND ";
				$q.= "MaintainerUID = 0) ";
				$has_where = 1;
			} else {
				$q.= "AND (AURMaintainerUID = 0 AND ";
				$q.= "MaintainerUID = 0) ";
			}
	}
eric's avatar
eric committed
610
	switch ($_REQUEST["SB"]) {
611
		case 'c':
eric's avatar
eric committed
612
			$q.= "ORDER BY CategoryID DESC, Name ASC, LocationID ASC ";
613
614
			break;
		case 'l':
eric's avatar
eric committed
615
			$q.= "ORDER BY LocationID ASC, Name ASC, CategoryID DESC ";
616
			break;
617
		case 'v':
eric's avatar
eric committed
618
			$q.= "ORDER BY NumVotes DESC, Name ASC, CategoryID DESC ";
619
			break;
620
		default:
eric's avatar
eric committed
621
			$q.= "ORDER BY Name ASC, LocationID ASC, CategoryID DESC ";
622
623
			break;
	}
624
	$q.= "LIMIT ".$O.", ".$PP;
625

626
627
	$result = db_query($q, $dbh);
	if (!$result) {
628
		print __("Error retrieving package list.");
629

eric's avatar
eric committed
630
631
632
633
	} elseif (!mysql_num_rows($result)) {
		print __("No packages matched your search criteria.");

	} else {
634
635

		if ($SID) {
eric's avatar
eric committed
636
637
			# The 'Actions' table
			#
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
			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'>";
653
654
655
			print "<input type='submit' class='button' name='do_UnFlag'";
			print "	value='".__("Unflag Out-of-date")."'></td>\n";
			print "  <td align='center'>";
656
657
658
659
660
			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";
pjmattal's avatar
pjmattal committed
661
662
663
			print "  <td align='center'>";
			print "<input type='submit' class='button' name='do_Delete'";
			print "	value='".__("Delete Packages")."'></td>\n";
664
665
666
			print "  <td align='center'>";
			print "<input type='submit' class='button' name='do_Vote'";
			print "	value='".__("Vote")."'></td>\n";
667
668
669
			print "  <td align='center'>";
			print "<input type='submit' class='button' name='do_UnVote'";
			print "	value='".__("Un-Vote")."'></td>\n";
670
671
672
673
674
675
676
677
678
			print "</tr>\n";
			print "</table>\n";
			print "  </td>\n";
			print "</tr>\n";
			print "</table>\n";
			print "</center>\n";
			print "<br />\n";
		}

679
680
681
682
683
684
		# 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";
685
		print "    <span class='f3'>Package Listing</span>\n";
686
		print "  </td>\n";
687
688
		print "</tr>\n";
		print "<tr>\n";
689
		print "  <td class='boxSoft'>\n";
690
691
		print "<table width='100%' cellspacing='0' cellpadding='2'>\n";
		print "<tr>\n";
692
693
694
695
		if ($SID) {
			print "  <th style='border-bottom: #666 1px solid; vertical-align:";
			print " bottom'>&nbsp;</th>\n";
		}
696
697
698
699
700
701
702
703
		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";
704
705
706
707
		if ($SID) {
			print "  <th style='border-bottom: #666 1px solid; vertical-align:";
			print " bottom'><span class='f2'>".__("Vote")."</span></th>\n";
		}
708
709
710
711
		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";
712
713
714
715
716
# 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";
#		}
717
		print "</tr>\n";
718

719
720
721
		for ($i=0; $row = mysql_fetch_assoc($result); $i++) {
			(($i % 2) == 0) ? $c = "data1" : $c = "data2";
			print "<tr>\n";
722
723
724
725
726
			if ($SID) {
				print "  <td class='".$c."'>";
				if ($row["OutOfDate"]) {
					print "<span style='background-color: red'>";
				}
727
728
729
				if ($row["MaintainerUID"]==0 && $row["AURMaintainerUID"]==0) {
					print "<span style='background-color: cyan'>";
				}	
730
731
732
733
734
735
				print "<input type='checkbox' name='IDs[".$row["ID"]."]' value='1'>";
#				if ($i == 0) {
#					$all_ids = $row["ID"];
#				} else {
#					$all_ids .= ":".$row["ID"];
#				}
736
737
738
739
740
				if ($row["OutOfDate"]) {
					print "</span>";
				}
				print "</td>\n";
			}
741
742
743
744
			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";
745
			print "  <td class='".$c."'><span class='f4'>";
eric's avatar
eric committed
746
			$url = "<a href='/packages.php?";
eric's avatar
eric committed
747
748
			$url .= "do_Details=1&ID=";
			$url .= $row["ID"];
eric's avatar
eric committed
749
750
751
752
753
			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!
				#
754
755
756
757
758
				if ($var == "do_MyPackages" && $_REQUEST[$var]) {
					$url .= "&".$var."=1";
				} else {
					$url .= "&".$var."=".rawurlencode(stripslashes($_REQUEST[$var]));
				}
eric's avatar
eric committed
759
			}
eric's avatar
eric committed
760
761
			reset($pkgsearch_vars);
			$url.= "'><span class='black'>".$row["Name"];
762
			$url.= " ".$row["Version"]."</span></a>";
eric's avatar
eric committed
763
			print $url."</span></td>\n";
764
			print "  <td class='".$c."'><span class='f5'><span class='blue'>";
765
			print "&nbsp;&nbsp;&nbsp;".$row["NumVotes"]."</span></span></td>\n";
766
767
768
769
770
771
772
773
			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";
				}
			}
774
775
776
			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
777
778
779
780

			# print the package manager, also determine if it is managed
			#
			$managed = 1;
eric's avatar
eric committed
781
782
			if (isset($devs[$row["AURMaintainerUID"]])) {
				print $devs[$row["AURMaintainerUID"]]["Username"];
jchu's avatar
jchu committed
783
784
			} elseif (isset($tus[$row["MaintainerUID"]])) {
				print $tus[$row["MaintainerUID"]]["Username"];
785
786
			} else {
				print "None";
eric's avatar
eric committed
787
				$managed = 0;
788
789
			}
			print "</span></span></td>\n";
eric's avatar
eric committed
790

791
792
793
794
795
796
797
798
799
800
801
802
# 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";
#			}
803
804
805
806
807

			print "</tr>\n";

		}
		print "</table>\n";
eric's avatar
eric committed
808
809
810
		print "  </td>\n";
		print "</tr>\n";
		print "</table>\n";
811
#		print "<input type='hidden' name='All_IDs' value='".$all_ids."'>\n";
eric's avatar
eric committed
812
813
814
		if ($_REQUEST["do_MyPackages"]) {
			print "<input type='hidden' name='do_MyPackages' value='1'>\n";
		}
815

eric's avatar
eric committed
816
817
818
819
820
821
		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'>";
822
		print "    <input type='submit' class='button' name='do_Less'";
eric's avatar
eric committed
823
824
825
		print " value='&lt;-- ".__("Less")."'>\n";
		print "    </td>\n";
		print "    <td align='right'>";
826
		print "    <input type='submit' class='button' name='do_More'";
eric's avatar
eric committed
827
828
829
830
		print " value='".__("More")." --&gt;'>\n";
		print "    </td>\n";
		print "  </tr>\n";
		print "  </table>\n";
831
832
833
834
835
		print "  </td>\n";
		print "</tr>\n";
		print "</table>\n";
		print "</center>\n";
	}
836
	print "</form>\n";
837

eric's avatar
eric committed
838
839
840
841
842
	return;
}

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