From 0703a75b3d53fd28f21f3dbabf2c1630da46bd2c Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Tue, 22 May 2007 09:49:07 +0000
Subject: feature: added link to game in final email, CC'ed people in final
 email

---
 db.php | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

(limited to 'db.php')

diff --git a/db.php b/db.php
index 98e7724..64a80b9 100644
--- a/db.php
+++ b/db.php
@@ -704,5 +704,32 @@ function DB_set_party_by_hash($hash,$party)
   return;
 }
 
+function DB_get_PREF($myid)
+{
+  global $PREF;
+
+    $result = mysql_query("SELECT value from User_Prefs".
+			  " WHERE user_id='$myid' AND pref_key='cardset'" );
+    $r = mysql_fetch_array($result,MYSQL_NUM);
+    if($r)
+      {
+	if($r[0]=="germancards" && (time()-strtotime( "2009-12-31 23:59:59")<0) ) /* licence only valid until then */
+	  $PREF["cardset"]="altenburg";
+      else
+	$PREF["cardset"]="english";
+      }
+    else
+      $PREF["cardset"]="english";
+
+    $result = mysql_query("SELECT value from User_Prefs".
+			  " WHERE user_id='$myid' AND pref_key='ccemail'" );
+    $r = mysql_fetch_array($result,MYSQL_NUM);
+    if($r)
+      $PREF["ccemail"]=$r[0];
+    else
+      $PREF["ccemail"]="no";
+
+    return;
+}
 
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-18-g5258