From 71f2efd7af4b32eb514c134769fc969e5e64bd2b Mon Sep 17 00:00:00 2001
From: canyonknight <canyonknight@gmail.com>
Date: Wed, 23 May 2012 15:25:23 -0400
Subject: account_search_results.php: Pull out DB code

* Move DB code from account_search_results.php to already existing function
in acctfuncs.inc.php
* Centralization of DB code important in a future transition to PDO interface

Signed-off-by: canyonknight <canyonknight@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
---
 web/lib/acctfuncs.inc.php               | 6 ++++++
 web/template/account_search_results.php | 3 +--
 2 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php
index bb1f6e8..7a18f76 100644
--- a/web/lib/acctfuncs.inc.php
+++ b/web/lib/acctfuncs.inc.php
@@ -323,6 +323,12 @@ function search_results_page($UTYPE,$O=0,$SB="",$U="",$T="",
 	$dbh = db_connect();
 
 	$result = db_query($q, $dbh);
+	$num_rows = mysql_num_rows($result);
+
+	while ($row = mysql_fetch_assoc($result)) {
+		$userinfo[] = $row;
+	}
+
 	include("account_search_results.php");
 	return;
 }
diff --git a/web/template/account_search_results.php b/web/template/account_search_results.php
index 88d6bb6..f2ed62e 100644
--- a/web/template/account_search_results.php
+++ b/web/template/account_search_results.php
@@ -2,7 +2,6 @@
 if (!$result):
 	print __("No results matched your search criteria.");
 else:
-	$num_rows = mysql_num_rows($result);
 	if ($num_rows):
 ?>
 		<table class="results">
@@ -20,7 +19,7 @@ else:
 			</thead>
 			<?php
 			$i = 0;
-			while ($row = mysql_fetch_assoc($result)):
+			while (list($indx, $row) = each($userinfo)):
 				if ($i % 2):
 					$c = "even";
 				else:
-- 
cgit v1.2.3-70-g09d2