this off, log into your Profile and
uncheck the appropriate Email Alert
checkbox then save your Profile Settings.
Thank You,
http://freeadplanet.com Staff
Open a Ticket: http://freeadplanet.com/openticket.php
';
$db = new MySQL_Access('mle');
$bademails = array();
if ($db->Query("SELECT bademail FROM bounced WHERE 1 ORDER BY bademail")) {
while (list($b) = $db->FetchRow()) {
$bademails[] = $b;
}
}
$db->SelectDB('fap');
if ($db->Query("SELECT datelastreset FROM reset WHERE datelastreset < DATE_SUB(NOW(), INTERVAL 1 DAY)")) {
$db->Query("UPDATE reset SET datelastreset='{$midnight}' LIMIT 1");
echo "Begin new fap_billing day midnight={$midnight}\n";
// downgrade after grace period - or mail bill
$db->Query("SELECT email, fname, lname, username, pass, affid, datelastbilled FROM users WHERE status='2'");
$users = $db->result;
while (list($email, $fname, $lname, $username, $password, $affid, $datelastbilled) = mysqli_fetch_row($users)) {
$num_days = DateDiff(mysql_datetime_to_timestamp($datelastbilled), time(), 'd');
$num_days = round($num_days);
if ($num_days >= $days_grace_period) {
downgrade_member($email, $fname, $lname, $username, $password, $affid, $datelastbilled, $headers, $db);
} else {
// mail bill every 3rd day
if ($day % 3) {
continue;
if ($_col == 'X') {
$col = 'email';
} else {
break;
}
}
}
}
}
if ($dbug) {
echo "col -> {$col}\n";
}
// determine column and DB based on first letter in userID
if ($_col == 'C' or $_col == 'L') {
$user_col = 'userID';
$db->SelectDB('mle');
} else {
$user_col = 'affid';
$db->SelectDB('fap');
}
// extract email from mle or fap if exists, if not exist abort, move on to next file
if ($db->Query("SELECT {$col} FROM users WHERE {$user_col} = '{$userID}' AND {$col} != '' LIMIT 1")) {
list($email) = $db->FetchRow();
} else {
break;
}
if ($dbug) {
echo "email -> {$email} :: DB -> {$db->GetDBName()}\n";
}
$reason = get_reason($filename);
// determine if this is a quota bounce or not, and set db column to update in mle.bounced table
<?php
require_once 'config.inc';
exit;
/*
To move a list to Planet X Mail control,
simply change 'howheard' field in pxm database to 'cluster'
then run this script.
*/
$db = new MySQL_Access('pxm');
$listownerID = '4032668343';
$listownername = 'PlanetXMail';
$db->Query("SELECT listname, listownername FROM orders WHERE howheard='cluster' ORDER BY listname");
$result = $db->result;
while (list($listname, $_listownername) = mysqli_fetch_row($result)) {
$db->SelectDB('pxm');
$db->Query("UPDATE clients SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
$db->Query("UPDATE orders SET listownername='{$listownername}' WHERE listownername='{$_listownername}'");
$db->SelectDB('mle');
$db->Query("UPDATE listconfig SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
$db->Query("UPDATE listmanager SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
$db->Query("UPDATE listurls SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
$db->Query("UPDATE banners SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
$db->Query("UPDATE banneddomains SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
$db->Query("UPDATE ads SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
$db->Query("UPDATE users SET listownerID='{$listownerID}' WHERE listname='{$listname}'");
if ($_listownername != $listownername) {
$db->Query("DELETE FROM listowner WHERE username='******'");
}
}
<?php
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/config/config.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/validationfunctions.php';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/mailfunctions.php';
if (!@mysqli_ping($db->link)) {
$db = new MySQL_Access('mle');
} else {
$db->SelectDB('mle');
}
if (!$resending) {
$i = 0;
while (true) {
$i++;
if ($i > 3000) {
mail_debug_backtrace_exit();
}
$uID = generateID(10);
if ($db->Query("SELECT userID FROM users WHERE userID='{$uID}' LIMIT 1")) {
continue;
} else {
break;
}
}
$email = $email1 = strtolower(trim($email1));
}
$referercookie = $referer ? $_COOKIE["{$listhash}"] : 0;
$notValid = send_signup_mail($list, $id, $resending, $pass1, $email, $username, $uID, $fname, $lname, $email1, $status, 'sendvalidationmail.php', $referercookie);
$db = new MySQL_Access('mle');
$bademails = array();
$db->Query("SELECT bademail, reason FROM bounced WHERE count > 0 AND reason LIKE '%Name service error%' ORDER BY reason");
while (list($e, $r) = $db->FetchRow()) {
$bademails[$e] = $r;
}
foreach ($bademails as $email => $reason) {
if ($notValid = EmailFormat($email)) {
echo "{$email} - {$notValid}\n";
}
$db->Query("UPDATE users SET email='' WHERE email='{$email}'");
$db->Query("UPDATE users SET listemail='' WHERE listemail='{$email}'");
$db->Query("UPDATE listmanager SET adminemail='' WHERE adminemail='{$email}'");
$db->Query("UPDATE listowner SET email='' WHERE email='{$email}'");
$db->Query("UPDATE listconfig SET adminemailaddress='' WHERE adminemailaddress='{$email}'");
$db->SelectDB('pxm');
$db->Query("UPDATE orders SET email='' WHERE email='{$email}'");
$db->SelectDB('fap');
$db->Query("UPDATE users SET email='' WHERE email='{$email}' LIMIT 1");
$db->SelectDB('tap');
$db->Query("UPDATE users SET email='' WHERE email='{$email}' LIMIT 1");
$db->SelectDB('mle');
echo "{$email}\n";
//usleep(600000);
}
die;
/*
$listowneremail = '*****@*****.**';
$headers = "From: [listname] <{$listowneremail}>";
$subject = "[listname] - Final Delete Notice - Act Soon";
#!/usr/bin/php -q
<?php
require_once '/home/nulled/config.inc';
$db = new MySQL_Access('mle');
calc_total_mail(1);
// since this is run from CRON every hour, might as well OptimizeTables ...
$db->OptimizeTables(1);
$db->SelectDB('fap');
$db->OptimizeTables(1);
$db->SelectDB('tap');
$db->OptimizeTables(1);
$db->SelectDB('pxm');
$db->OptimizeTables(1);
$db->SelectDB('webmail');
$db->OptimizeTables(1);
$db->SelectDB('blogblast');
$db->OptimizeTables(1);
$db->SelectDB('elp');
$db->OptimizeTables(1);
$db->Close();
<?php
require_once '/home/nulled/www/planetxmail.com/phpsecure/classes.inc';
$ids = $ex_ids = array();
$db = new MySQL_Access("mle");
$db->Query("SELECT listownerID, username FROM listowner WHERE username != 'demoit' ORDER BY username");
$result = $db->result;
while (list($listownerID, $listownername) = mysqli_fetch_row($result)) {
$db->SelectDB("mle");
if (!$db->Query("SELECT listname FROM listconfig WHERE listownerID='{$listownerID}'")) {
exit("ERROR: listownerID={$listownerID} NOT FOUND\n");
}
$result2 = $db->result;
while (list($listname) = mysqli_fetch_row($result2)) {
$db->SelectDB("pxm");
if ($db->Query("SELECT id FROM orders WHERE listname='{$listname}' AND listownername='{$listownername}'")) {
if ($db->rows > 1) {
echo "------> DUP FOUND: {$listname}, {$listownername}\n";
} else {
list($ids[]) = $db->FetchRow();
echo "OK: {$listname}, {$listownername}\n";
}
} else {
if ($db->Query("SELECT id FROM extended WHERE listname='{$listname}' AND listownername='{$listownername}'")) {
list($ex_ids[]) = $db->FetchRow();
echo "OK EX: {$listname}, {$listownername}\n";
} else {
echo "-------------------------> NOT FOUND: {$listname}, {$listownername}\n";
}
}
}
