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