<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright © 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: user_newsletter_include.php
| Author: Terry Broullette (Grimloch)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
if ($profile_method == "input") {
$user_newsletter = isset($user_data['user_newsletter']) ? stripinput($user_data['user_newsletter']) : "";
if ($this->isError()) { $user_newsletter = isset($_POST['user_newsletter']) ? stripinput($_POST['user_newsletter']) : $user_newsletter; }
echo "<tr>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'><label for='user_newsletter'>".$locale['uf_user_newsletter'].$required."</label></td>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'>";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='1'".($user_newsletter == "1"?" checked='checked'":"")." />".$locale['uf_user_newsletter_yes']."</label> \n";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='0'".($user_newsletter == "0"?" checked='checked'":"")." />".$locale['uf_user_newsletter_no']."</label>\n";
echo "</td></tr>\n";
if ($required) { $this->setRequiredJavaScript("user_newsletter", $locale['uf_user_newsletter_error']); }
} elseif ($profile_method == "display") {
if ($user_data['user_newsletter'] == 1) {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub1']."</td>\n";
echo "</tr>\n";
} else {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub2']."</td>\n";
echo "</tr>\n";
}
} elseif ($profile_method == "validate_insert" || $profile_method == "validate_update") {
// Get input data
if (isset($_POST['user_newsletter']) && ($_POST['user_newsletter'] != "" || $this->_isNotRequired("user_newsletter"))) {
// Set update or insert user data
$this->_setDBValue("user_newsletter", stripinput(trim($_POST['user_newsletter'])));
}
include INFUSIONS."news_letter_panel/infusion_db.php";
$user = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='".$_GET['user']."'");
if (dbrows($user)) { $user_data = dbarray($user); }
if (isset($user_data['user_newsletter']) == 1) {
$result = dbquery("INSERT INTO ".DB_NEWS_LETTER_SUBS." VALUES('', '".$user_data['user_email']."','".$user_data['user_name']."','1','0','time()','1')");
} elseif (isset($user_data['user_newsletter']) == 0) {
$result = dbquery("DELETE FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_mail='".$user_data['user_email']."'");
} else { $this->_setError("user_newsletter", $locale['uf_user_newsletter_error'], true); }
}
?>
<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) PHPFusion Inc
| https://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: user_newsletter_include_var.php
| Author: Terry Broullette (Grimloch)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
// Version of the user fields api
$user_field_api_version = "1.01.00";
$user_field_name = $locale['uf_user_newsletter'];
$user_field_desc = $locale['uf_user_newsletter_desc'];
$user_field_dbname = "user_newsletter";
$user_field_group = 3;
$user_field_dbinfo = "TINYINT(1) NOT NULL DEFAULT '0'";
?>
$user = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='".$_GET['user']."'");
if (dbrows($user)) { $user_data = dbarray($user); }
if (!isnum($_GET['lookup'])) redirect(BASEDIR.'index.php');
$this_user_id = stripinput($_GET['lookup']);
$user = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='$this_user_id");
if (dbrows($user)) { $user_data = dbarray($user); }
$user = fusion_get_user($_GET['lookup']);
require_once INFUSIONS."news_letter_panel/infusion_db.php";
$this_user_id = stripinput($_GET['lookup']);
$user = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='$this_user_id'");
if (dbrows($user)) { $user_data = dbarray($user); }
if ($user_data['user_newsletter'] == 1) {
$result = dbquery("INSERT INTO ".DB_NEWS_LETTER_SUBS." VALUES('', '".$user_data['user_email']."','".$user_data['user_name']."','1','0','time()','1')");
} elseif ($user_data['user_newsletter'] == 0) {
$result = dbquery("DELETE FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_mail='".$user_data['user_email']."'");
}
public_html/maincore.php
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given Line: 273
user_fields/user_newsletter_include.php
Undefined variable: user_data Line: 57
user_fields/user_newsletter_include.php
Undefined variable: user_data Line: 56
user_fields/user_newsletter_include.php
Undefined variable: user_data Line: 54
user_fields/user_newsletter_include.php
Undefined index: lookup Line: 51
} elseif ($profile_method == "validate_insert" || $profile_method == "validate_update") {
// Get input data
if (isset($_POST['user_newsletter']) && ($_POST['user_newsletter'] != "" || $this->_isNotRequired("user_newsletter"))) {
// Set update or insert user data
$this->_setDBValue("user_newsletter", stripinput($_POST['user_newsletter']));
}
if (isset($_GET['lookup']) && isnum($_GET['lookup'])) {
$this_user_id = stripinput($_GET['lookup']);
$user = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='$this_user_id'");
if (dbrows($user)) { $user_data = dbarray($user); }
include INFUSIONS."news_letter_panel/infusion_db.php";
if ($user_data['user_newsletter'] == 1) {
$result = dbquery("INSERT INTO ".DB_NEWS_LETTER_SUBS." (nl_sub_mail, nl_sub_name, nl_sub_stat, nl_admin_add, nl_sub_date, nl_sub_who) VALUES('', '".$user_data['user_email']."','".$user_data['user_name']."','1','0','time()','1')");
} elseif ($user_data['user_newsletter'] == 0) {
$result = dbquery("DELETE FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_mail='".$user_data['user_email']."'");
}
}
}
<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright © 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: user_newsletter_include.php
| Author: Terry Broullette (Grimloch)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
if ($profile_method == "input") {
$user_newsletter = isset($user_data['user_newsletter']) ? stripinput($user_data['user_newsletter']) : "";
if ($this->isError()) { $user_newsletter = isset($_POST['user_newsletter']) ? stripinput($_POST['user_newsletter']) : $user_newsletter; }
echo "<tr>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'><label for='user_newsletter'>".$locale['uf_user_newsletter'].$required."</label></td>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'>";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='1'".($user_newsletter == "1"?" checked='checked'":"")." />".$locale['uf_user_newsletter_yes']."</label> \n";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='0'".($user_newsletter == "0"?" checked='checked'":"")." />".$locale['uf_user_newsletter_no']."</label>\n";
echo "</td></tr>\n";
if ($required) { $this->setRequiredJavaScript("user_newsletter", $locale['uf_user_newsletter_error']); }
} elseif ($profile_method == "display") {
if ($user_data['user_newsletter'] == 1) {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub1']."</td>\n";
echo "</tr>\n";
} else {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub2']."</td>\n";
echo "</tr>\n";
}
} elseif ($profile_method == "validate_insert" || $profile_method == "validate_update") {
// Get input data
if (isset($_POST['user_newsletter']) && ($_POST['user_newsletter'] != "" || $this->_isNotRequired("user_newsletter"))) {
// Set update or insert user data
$this->_setDBValue("user_newsletter", stripinput(trim($_POST['user_newsletter'])));
}
if (iMEMBER) {
require_once INFUSIONS."news_letter_panel/infusion_db.php";
if (!empty($_GET['lookup']) && ($user_data['user_id'] == $userdata['user_id'])){
if ($user_data['user_newsletter'] == 1) {
$result = dbquery("INSERT INTO ".DB_NEWS_LETTER_SUBS." VALUES('', '".$user_data['user_email']."', '".$user_data['user_name']."', '1', '0', '".time()."', '1')");
} elseif ($user_data['user_newsletter'] == 0) {
$result = dbquery("DELETE FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_mail='".$user_data['user_email']."'");
} else { $this->_setError("user_newsletter", $locale['uf_user_newsletter_error'], true); }
}
}
}
?>
<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright © 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: user_newsletter_include.php
| Author: Terry Broullette (Grimloch)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
if ($profile_method == "input") {
$user_newsletter = isset($user_data['user_newsletter']) ? stripinput($user_data['user_newsletter']) : "";
if ($this->isError()) { $user_newsletter = isset($_POST['user_newsletter']) ? stripinput($_POST['user_newsletter']) : $user_newsletter; }
echo "<tr>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'><label for='user_newsletter'>".$locale['uf_user_newsletter'].$required."</label></td>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'>";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='1'".($user_newsletter == "1"?" checked='checked'":"")." />".$locale['uf_user_newsletter_yes']."</label> \n";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='0'".($user_newsletter == "0"?" checked='checked'":"")." />".$locale['uf_user_newsletter_no']."</label>\n";
echo "</td></tr>\n";
if ($required) { $this->setRequiredJavaScript("user_newsletter", $locale['uf_user_newsletter_error']); }
} elseif ($profile_method == "display") {
if ($user_data['user_newsletter'] == 1) {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub1']."</td>\n";
echo "</tr>\n";
} else {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub2']."</td>\n";
echo "</tr>\n";
}
} elseif ($profile_method == "validate_insert" || $profile_method == "validate_update") {
// Get input data
if (isset($_POST['user_newsletter']) && ($_POST['user_newsletter'] != "" || $this->_isNotRequired("user_newsletter"))) {
// Set update or insert user data
$this->_setDBValue("user_newsletter", stripinput(trim($_POST['user_newsletter'])));
if (iMEMBER) {
require_once INFUSIONS."news_letter_panel/infusion_db.php";
if (!empty($_GET['lookup']) && ($user_data['user_id'] == $userdata['user_id'])){
if ($_POST['user_newsletter'] == 1 && $user_data['user_newsletter'] != 1) {
$result = dbquery("INSERT INTO ".DB_NEWS_LETTER_SUBS." VALUES('', '".$user_data['user_email']."', '".$user_data['user_name']."', '1', '0', '".time()."', '1')");
} elseif ($_POST['user_newsletter'] == 0) {
$result = dbquery("DELETE FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_mail='".$user_data['user_email']."'");
}
}
}
}
}
?>
<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright © 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: user_newsletter_include.php
| Author: Terry Broullette (Grimloch)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
if ($profile_method == "input") {
$user_newsletter = isset($user_data['user_newsletter']) ? stripinput($user_data['user_newsletter']) : "";
if ($this->isError()) { $user_newsletter = isset($_POST['user_newsletter']) ? stripinput($_POST['user_newsletter']) : $user_newsletter; }
echo "<tr>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'><label for='user_newsletter'>".$locale['uf_user_newsletter'].$required."</label></td>\n";
echo "<td class='tbl".$this->getErrorClass("user_newsletter")."'>";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='1'".($user_newsletter == "1"?" checked='checked'":"")." />".$locale['uf_user_newsletter_yes']."</label> \n";
echo "<label><input type='radio' id='user_newsletter' name='user_newsletter' value='0'".($user_newsletter == "0"?" checked='checked'":"")." />".$locale['uf_user_newsletter_no']."</label>\n";
echo "</td></tr>\n";
if ($required) { $this->setRequiredJavaScript("user_newsletter", $locale['uf_user_newsletter_error']); }
} elseif ($profile_method == "display") {
if ($user_data['user_newsletter'] == 1) {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub1']."</td>\n";
echo "</tr>\n";
} else {
echo "<tr>\n";
echo "<td class='tbl1'>".$locale['uf_user_newsletter_desc']."</td>\n";
echo "<td align='right' class='tbl1'>".$locale['uf_user_newsletter_sub2']."</td>\n";
echo "</tr>\n";
}
} elseif ($profile_method == "validate_insert" || $profile_method == "validate_update") {
// Get input data
if (isset($_POST['user_newsletter']) && ($_POST['user_newsletter'] != "" || $this->_isNotRequired("user_newsletter"))) {
// Set update or insert user data
$this->_setDBValue("user_newsletter", stripinput(trim($_POST['user_newsletter'])));
if (iMEMBER) {
require_once INFUSIONS."news_letter_panel/infusion_db.php";
$result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_name='".$_POST['user_name']."'");
if (dbrows($result)) { $user = dbarray($result); }
if ($_POST['user_newsletter'] == 1 && $user['user_newsletter'] != 1) {
dbquery("INSERT INTO ".DB_NEWS_LETTER_SUBS." VALUES('', '".$user['user_email']."', '".$user['user_name']."', '1', '0', '".time()."', '1')");
} elseif ($_POST['user_newsletter'] == 0) {
dbquery("DELETE FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_mail='".$user['user_email']."'");
}
}
}
}
?>
Category Forum
User Administration - 8Labels
None yet
Statistics
3 participants
Notifications
You are not receiving notifications from this thread.
Related Questions