+
+function DB_get_number_of_tricks($gameid,$position)
+{
+ $r = DB_query_array("SELECT COUNT(winner) FROM Trick Where game_id='$gameid' and winner='$position'");
+ return $r[0];
+}
+
+function DB_digest_insert_email($To,$message,$type,$gameid)
+{
+ if($type == GAME_YOUR_TURN)
+ DB_query("INSERT INTO digest_email VALUES (NULL,".DB_quote_smart($To).",NULL,'your_turn',$gameid,".DB_quote_smart($message).")");
+ else
+ DB_query("INSERT INTO digest_email VALUES (NULL,".DB_quote_smart($To).",NULL,'misc',NULL,".DB_quote_smart($message).")");
+ return;
+}
+
+function DB_get_digest_users()
+{
+ $users = array();
+
+ $result = DB_query("SELECT user_id FROM User_Prefs WHERE pref_key='digest' and value <> 'digest-off'");
+ while($r = DB_fetch_array($result))
+ $users[]=$r[0];
+
+ return $users;
+}
+
+function DB_get_digest_message_by_email($email)
+{
+ $messages = array();
+
+ $result = DB_query("SELECT id,content,type,game_id FROM digest_email Where email='$email'");
+ while($r = DB_fetch_array($result))
+ $messages[]=$r;
+
+ return $messages;
+}
+
+function DB_digest_delete_message($id)
+{
+ DB_query("Delete from digest_email where id='$id'");
+}
+