2 /************************************************************************
\r
3 * MXChange v0.2.1 Start: 01/28/2004 *
\r
4 * ================ Last change: 12/13/2004 *
\r
6 * -------------------------------------------------------------------- *
\r
7 * File : what-list_links.php *
\r
8 * -------------------------------------------------------------------- *
\r
9 * Short description : List unconfirmed mails of a member *
\r
10 * -------------------------------------------------------------------- *
\r
11 * Kurzbeschreibung : Unbestaetigte Mails eines Mitgliedes auflisten *
\r
12 * -------------------------------------------------------------------- *
\r
14 * -------------------------------------------------------------------- *
\r
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
\r
16 * For more information visit: http://www.mxchange.org *
\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
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
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
34 // Some security stuff...
\r
35 if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
\r
37 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
\r
41 // Add description as navigation point
\r
42 ADD_DESCR("admin", basename(__FILE__));
\r
44 if (empty($_GET['del'])) $_GET['del'] = "";
\r
46 OPEN_TABLE("100%", "admin_content admin_content_align", "");
\r
47 if (!empty($_GET['u_id']))
\r
49 // Check if the user already exists
\r
50 $result = SQL_QUERY_ESC("SELECT surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
\r
51 array(bigintval($_GET['u_id'])), __FILE__, __LINE__);
\r
52 if (SQL_NUMROWS($result) == 1)
\r
54 // Loads surname, family's name and the email address
\r
55 list($sname, $fname, $email) = SQL_FETCHROW($result);
\r
56 SQL_FREERESULT($result);
\r
58 // Grab user's all unconfirmed mails
\r
59 if (EXT_IS_ACTIVE("bonus"))
\r
62 $result = SQL_QUERY_ESC("SELECT stats_id, bonus_id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE userid=%d ORDER BY id",
\r
63 array(bigintval($_GET['u_id'])), __FILE__, __LINE__);
\r
67 // Load stats ID (2nd will be ignored later! But it is needed for the same fetchrow command)
\r
68 $result = SQL_QUERY_ESC("SELECT stats_id, stats_id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE userid=%d ORDER BY id",
\r
69 array(bigintval($_GET['u_id'])), __FILE__, __LINE__);
\r
72 $nums = bigintval(SQL_NUMROWS($result));
\r
75 // Some unconfirmed mails left
\r
76 if ($_GET['del'] == "all")
\r
78 // Delete all unconfirmed mails by this user
\r
79 $result_del = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE userid=%d LIMIT %s",
\r
80 array(bigintval($_GET['u_id']), $nums), __FILE__, __LINE__);
\r
82 // Prepare mail and send it away
\r
83 $msg = LOAD_EMAIL_TEMPLATE("admin-del_links", $nums, bigintval($_GET['u_id']));
\r
84 SEND_EMAIL($email, ADMIN_DEL_LINK_SUBJ, $msg);
\r
87 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_LINKS_DELETED);
\r
91 // List all unconfirmed mails
\r
93 while (list($id, $id2, $type) = SQL_FETCHROW($result))
\r
95 // Load data from stats table...
\r
100 $result_data = SQL_QUERY_ESC("SELECT subject, timestamp_ordered, cat_id FROM "._MYSQL_PREFIX."_user_stats WHERE id=%d LIMIT 1",
\r
101 array(bigintval($id)), __FILE__, __LINE__);
\r
102 $TYPE = "mailid"; $DATA = $id; $PROBLEM = NORMAL_MAIL_PROBLEM;
\r
103 $LINK = "<A href=\"".URL."/mailid.php?uid=".$_GET['u_id']."&mailid=".$id."\" target=\"_blank\">".$id."</A>";
\r
107 $result_data = SQL_QUERY_ESC("SELECT subject, timestamp, cat_id FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1",
\r
108 array(bigintval($id2)), __FILE__, __LINE__);
\r
109 $TYPE = "bonusid"; $DATA = $id2; $PROBLEM = BONUS_MAIL_PROBLEM;
\r
110 $LINK = "<A href=\"".URL."/mailid.php?uid=".$_GET['u_id']."&bonusid=".$id2."\" target=\"_blank\">".$id2."</A>";
\r
114 if (SQL_NUMROWS($result_data) == 1)
\r
117 list($subject, $timestamp, $cat) = SQL_FETCHROW($result_data);
\r
118 SQL_FREERESULT($result_data);
\r
119 if (empty($subject)) $subject = DEFAULT_SUBJECT_LINE;
\r
121 // Prepare data for the row template
\r
125 'subj' => $subject,
\r
126 'stamp' => MAKE_DATETIME($timestamp, "0"),
\r
127 'cat' => GET_CATEGORY($cat),
\r
130 // Load row template
\r
131 $OUT .= LOAD_TEMPLATE("admin_list_links_row", true, $content);
\r
136 <TD align=\"center\" class=\"switch_sw".$SW." bottom2\" colspan=\"4\">
\r
137 <STRONG class=\"member_failed large\">".$PROBLEM.":</STRONG> ".$DATA."
\r
145 SQL_FREERESULT($result);
\r
147 // Remember list in constant for the template
\r
148 define('__SNAME_VALUE', $sname);
\r
149 define('__FNAME_VALUE', $fname);
\r
150 define('__EMAIL_VALUE', "<A href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$email."</A>");
\r
151 define('__EMAIL_LIST' , $OUT);
\r
152 define('__NUMS_VALUE' , $nums);
\r
153 define('__UID_VALUE' , $_GET['u_id']);
\r
155 // Load final template
\r
156 LOAD_TEMPLATE("admin_list_links");
\r
161 // No mails left to confirm
\r
162 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_LINKS_1.$_GET['u_id'].ADMIN_MEMBER_LINKS_2);
\r
168 LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2);
\r
173 // Output selection form with all confirmed user accounts listed
\r
174 ADD_MEMBER_SELECTION_BOX();
\r