# 
# 
# patch "www/index.php"
#  from [ff2443327d098e2a8ecfc1ce4755e8fea3a41746]
#    to [9c415a134ece496a7a2015c8fb3e2e6e7f9d58a9]
# 
============================================================
--- www/index.php	ff2443327d098e2a8ecfc1ce4755e8fea3a41746
+++ www/index.php	9c415a134ece496a7a2015c8fb3e2e6e7f9d58a9
@@ -38,27 +38,27 @@
 # First, display those maintained by the logged in user, if any
 if ($validuser) {
 #	$query = "SELECT name, directory FROM projects WHERE name IN (SELECT project FROM permissions WHERE username = '%s')";
-	$query = "SELECT name FROM projects WHERE name IN (SELECT project FROM permissions WHERE username = '%s')";
-	$result = pg_exec($db, sprintf($query,$safeuser));
+	$query= "SELECT name FROM projects WHERE name IN (SELECT project FROM permissions WHERE username=?)";
+	$result = $db->Execute($query, array($username));
 	if (!$result) {printf("ERROR"); }
-	$rows = pg_numrows($result);
+	$rows = $result->RecordCount();
 	if ($rows > 0) {
 		printf("<p><b>Projects you help maintain:</b></p>");
-		for($i = 0; $i < $rows; ++$i) {
-			$row = pg_fetch_row ($result,$i);
+		while (!$result->EOF) {
+			$row =  $result->FetchRow();
 			display_project_summary($row, 1);
 		}
 	}
 }
 #$query = "SELECT name, directory FROM projects WHERE name NOT IN (SELECT project FROM permissions WHERE username = '%s')";
-$query = "SELECT name FROM projects WHERE name NOT IN (SELECT project FROM permissions WHERE username = '%s')";
-$result = pg_exec($db, sprintf($query,$safeuser));
+$query = "SELECT name FROM projects WHERE name NOT IN (SELECT project FROM permissions WHERE username=?)";
+$result = $db->Execute($query, array($username));
 if (!$result) {printf("ERROR"); }
-$rows = pg_numrows($result);
+$rows = $result->RecordCount();
 if ($rows > 0) {
 	printf("<p><b>Projects you don't help maintain:</b></p>");
-	for($i = 0; $i < $rows; ++$i) {
-		$row = pg_fetch_row ($result,$i);
+	while (!$result->EOF) {
+		$row =  $result->FetchRow();
 		display_project_summary($row, 0);
 	}
 }