From 3833ab7e3588b4f5c05f440713f5cdf30b9029ae Mon Sep 17 00:00:00 2001
From: root
Date: Sun, 5 Oct 2014 21:15:08 +0200
Subject: Improved caching methods.

---
 action.php | 30 +++++++++++++++++-------------
 1 file changed, 17 insertions(+), 13 deletions(-)

(limited to 'action.php')

diff --git a/action.php b/action.php
index 86129ae..1e70b21 100644
--- a/action.php
+++ b/action.php
@@ -259,23 +259,27 @@ JG Adlershof";
 			$suffix = ".csv";
 		}
 		lredirect("download;type=".$type);
-		$res = $db->doQuery("SELECT * FROM " . DBPREFIX . "member;");
-		$content .= "\n";
-		$count = 1;
-		while ($row = $res->fetch_array() ){
+		if ( $c->exists(CACHEPREFIX . "adressliste".$suffix) ){
+			$content = $c->getValue(CACHEPREFIX . "adressliste".$suffix);
+		} else {
+			$res = $db->doQuery("SELECT * FROM " . DBPREFIX . "member;");
+			$content .= "\n";
+			$count = 1;
+			while ($row = $res->fetch_array() ){
 
-			if ( $type == "plain" ){
-				$content .= $count . " | " . $row["name"] . " | " . $row["adresse"] . " | " . $row["telefonnummer"] . " | " . $row["handynummer"] . " | " . $row["email"] . " | " . $row["geburtstag"] . "\n";
-			} else {
-				$content .= $count;
-				for ( $i=1;$i<7;$i++){
-					$content .= ';' . $row[$i];
+				if ( $type == "plain" ){
+					$content .= $count . " | " . $row["name"] . " | " . $row["adresse"] . " | " . $row["telefonnummer"] . " | " . $row["handynummer"] . " | " . $row["email"] . " | " . $row["geburtstag"] . "\n";
+				} else {
+					$content .= $count;
+					for ( $i=1;$i<7;$i++){
+						$content .= ';' . $row[$i];
+					}
+					$content .= "\n";
 				}
-				$content .= "\n";
+				$count++;
 			}
-			$count++;
+			$c->setKey(CACHEPREFIX . "adressliste".$suffix, $content);
 		}
-		
 		ob_clean();
 		header("Content-Type: text/".$type."; Charset=UTF-8");
 		header("Content-Disposition: attachment; filename=\"JG Adressliste ".date("j.n.Y", time()).$suffix."\"");
-- 
cgit v1.2.3