62073918fc055ad5ebe1ed11fe9e4295fe343428
[mailer.git] / inc / libs / autopurge_functions.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 05/30/2004 *
4  * ===============                              Last change: 08/09/2004 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : autopurge_functions.php                          *
8  * -------------------------------------------------------------------- *
9  * Short description : Special functions                                *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Spezielle Funktionen                             *
12  * -------------------------------------------------------------------- *
13  *                                                                      *
14  * -------------------------------------------------------------------- *
15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
16  * For more information visit: http://www.mxchange.org                  *
17  *                                                                      *
18  * This program is free software; you can redistribute it and/or modify *
19  * it under the terms of the GNU General Public License as published by *
20  * the Free Software Foundation; either version 2 of the License, or    *
21  * (at your option) any later version.                                  *
22  *                                                                      *
23  * This program is distributed in the hope that it will be useful,      *
24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
26  * GNU General Public License for more details.                         *
27  *                                                                      *
28  * You should have received a copy of the GNU General Public License    *
29  * along with this program; if not, write to the Free Software          *
30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
31  * MA  02110-1301  USA                                                  *
32  ************************************************************************/
33
34 // Some security stuff...
35 if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
36 {
37         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
38         require($INC);
39 }
40
41 function AUTOPURGE_ADD_POINTS($uid, $points)
42 {
43         global $jackpot;
44         // Check if he has locked points or not
45         $result = SQL_QUERY_ESC("SELECT ref_payout FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
46          array(bigintval($uid)), __FILE__, __LINE__);
47         list($payout) = SQL_FETCHROW($result);
48         SQL_FREERESULT($result);
49         if (($payout > 0) && (!empty($payout)))
50         {
51                 // Yes, he has.
52                 $target = "locked_points";
53         }
54          elseif ($payout == "0")
55         {
56                 // No, he has not
57                 $target = "points";
58         }
59         // Add points...
60         if (empty($payout))
61         {
62                 // ... to jackpot account
63                 ADD_JACKPOT($points);
64                 if (empty($jackpot)) $jackpot = "0";
65                 $jackpot += $points;
66         }
67          else
68         {
69                 // .. to user's account
70                 $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET %s=%s+%s WHERE userid=%s AND ref_depth=0 LIMIT 1",
71                  array($target, $target, $points, bigintval($uid)), __FILE__, __LINE__);
72
73                 // Update mediadata as well
74                 if ((GET_EXT_VERSION("mediadata") >= "0.0.4") && ($target == "points"))
75                 {
76                         // Update database
77                         MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
78                 }
79
80                 // Send out mail to user
81                 $msg = LOAD_EMAIL_TEMPLATE("member_autopurge_points", TRANSLATE_COMMA($points), $uid);
82                 SEND_EMAIL($uid, AUTOPURGE_MEMBER_SUBJECT, $msg);
83         }
84 }
85
86 //
87 ?>