<?php
include "mlpsecure/config/classes.inc";
$db = new MySQL_Access();
$name = $urlID;
$db->Query("DELETE FROM urlmanager WHERE userID='{$_SESSION['aauserID']}' AND name='{$name}'");
$db->Query("DELETE FROM urldata WHERE userID='{$_SESSION['aauserID']}' AND name='{$name}'");
$notValid = urlencode("URL tracker removed.");
header("Location: main.php?option=urltrackers¬Valid={$notValid}");
exit;
<?php
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/config/classes.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/config/config.inc';
$db = new MySQL_Access();
if ($mode == "all") {
$db->Query("SELECT ipaddress FROM urldata WHERE userID='{$uID}' AND name='{$tracker}' ORDER BY ipaddress");
} else {
if ($mode == "year") {
$db->Query("SELECT ipaddress FROM urldata WHERE userID='{$uID}' AND name='{$tracker}' AND ({$mletime} - 29030400) <= UNIX_TIMESTAMP(hitdate) ORDER BY ipaddress");
}
if ($mode == "month") {
$db->Query("SELECT ipaddress FROM urldata WHERE userID='{$uID}' AND name='{$tracker}' AND ({$mletime} - 2419200) <= UNIX_TIMESTAMP(hitdate) ORDER BY ipaddress");
}
if ($mode == "week") {
$db->Query("SELECT ipaddress FROM urldata WHERE userID='{$uID}' AND name='{$tracker}' AND ({$mletime} - 604800) <= UNIX_TIMESTAMP(hitdate) ORDER BY ipaddress");
}
if ($mode == "day") {
$db->Query("SELECT ipaddress FROM urldata WHERE userID='{$uID}' AND name='{$tracker}' AND ({$mletime} - 86400) <= UNIX_TIMESTAMP(hitdate) ORDER BY ipaddress");
}
if ($mode == "hour") {
$db->Query("SELECT ipaddress FROM urldata WHERE userID='{$uID}' AND name='{$tracker}' AND ({$mletime} - 3600) <= UNIX_TIMESTAMP(hitdate) ORDER BY ipaddress");
}
}
$ipprev = "";
$unique = 0;
$total = $db->rows;
while (list($ipaddress) = $db->FetchRow()) {
if ($ipaddress != $ipprev) {
$unique++;
}
if ($_POST['submitted'] == 'reply') {
$subject = trim($_POST['subject']);
$message = trim($_POST['message']);
$number = trim($_POST['n']);
$email = urldecode(trim($_POST['e']));
if ($message == '') {
$notValid = 'ERROR: Missing Required Fields.';
} else {
if (strlen($message) > $max_chars) {
$notValid = 'ERROR: Message Exceeds ' . $max_chars . ' Characters.';
} else {
if (!ctype_alnum($number)) {
$notValid = "ERROR: Ticket Number is Invalid.";
} else {
$message = $db->EscStr($message);
$db->Query("INSERT INTO tickets VALUES('','{$number}','{$email}','{$subject}','{$message}','1',NOW())");
$date = date('F j, Y, g:i a');
$host = get_ticket_host($subject);
$headers = "From: {$host} <*****@*****.**>";
$subject = "{$host} request received.";
$message = "We received your request for support on: {$date}\n\n";
$message .= "Your Ticket history: http://planetxmail.com/clientreply.php?n={$number}\n\n";
$message .= "We will respond to your question as soon as we can.\n\n";
$message .= "Thank you,\n";
$message .= "{$host} Team";
@mail($email, $subject, $message, $headers);
$html = rawurlencode('<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>Client Reply to Ticket</title>
http://freeadplanet.com/policies.php
--------------------------------------
This Email Alert was turned on by you.
If you wish to turn future alerts like
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) {
<?php
include "../mlpsecure/config/classes.inc";
$db = new MySQL_Access();
// get all banners
$db->Query("SELECT banner FROM banners WHERE 1 ORDER BY banner");
while (list($banner) = $db->FetchRow()) {
list($tmp, $banners[]) = explode("/", $banner);
}
// get all ads
$db->Query("SELECT adimage FROM ads WHERE adimage!='none' ORDER BY adimage");
while (list($banner) = $db->FetchRow()) {
list($tmp, $banners[]) = explode("/", $banner);
}
if ($dir = opendir("_signs")) {
while ($file = readdir($dir)) {
if ($file != "." && $file != "..") {
$files[] = $file;
}
}
closedir($dir);
}
sort($files);
for ($i = 0; $i < count($files); $i++) {
for ($j = 0, $found = 0; $j < count($banners); $j++) {
if (stristr($banners[$j], $files[$i])) {
$found = 1;
break;
}
}
if (!$found) {
<?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/classes.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/validationfunctions.php';
$unmixup = unmixup($c);
$e = makehash($unmixup . $h);
$db = new MySQL_Access('mle');
$url = '';
if (!$db->Query("SELECT link FROM earnedlinks WHERE link='{$c}' LIMIT 1")) {
if ($db->Query("SELECT id, crediturl, datemailed FROM soloads WHERE receipt != '' AND crediturl != '' AND datemailed > DATE_SUB(NOW(), INTERVAL 5 DAY) ORDER BY MD5(RAND()) LIMIT 1")) {
list($soloadID, $urlID, $datemailed) = $db->FetchRow();
if ($db->Query("SELECT url FROM userlinks WHERE id='{$urlID}' LIMIT 1")) {
list($url) = $db->FetchRow();
$db->Query("INSERT INTO iframe_stats (soloadID, urlID, counter, url, datemailed, lastupdate) VALUES ('{$soloadID}','{$urlID}','1','{$url}','{$datemailed}',NOW())\n ON DUPLICATE KEY UPDATE counter=counter+1, lastupdate=NOW()");
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>Planet X Mail - Credit Earner</title>
<script>
function bt(){setTimeout('ri()', 10000);}
function ri(){location.href="http://planetxmail.com/earn.php?c=<?php
echo $c;
?>
&h=<?php
echo $h;
?>
$colformat = 8;
$total_all = $curr_year = 0;
$str_years = '';
if (count($argv) > 1) {
foreach ($argv as $y) {
if (!in_array($y, $allowed_years)) {
continue;
}
$str_years .= $y . ' ';
$months = array_merge($months, get_months($y));
}
} else {
$str_years = date('y');
$months = array_merge(get_months(date('y')));
}
$db->Query("SELECT DISTINCT product FROM transactions WHERE 1");
while (list($p) = $db->FetchRow()) {
$p2 = $p;
switch ($p) {
case 'cb_referral':
$p2 = 'CB REF';
break;
case 'directad':
$p2 = 'DirAD';
break;
case 'digipanel_license':
$p2 = 'DP';
break;
case 'elp_mem_monthly':
$p2 = 'ELP R';
break;
$type = substr($raw, strlen($raw) - 1);
// if ($affid != '11187448') exit("We are doing upgrades... try again later.");
// exit("Maintenance Mode... stand by: un=$un seed=$seed affid=$affid urlID=$urlID type=$type raw=$raw");
$allowed_types = array(0, 1, 2, 3, 4, 5, 9);
if (!in_array($type, $allowed_types)) {
$header = 'Type AD check failed. Make sure you copy and paste the link properly. <u>Do not try to tamper with links.</u>' . $h2;
} else {
if (!is_numeric($urlID)) {
$header = 'urlID check failed. Make sure you copy and paste the link properly. <u>Do not try to tamper with links.</u>' . $h2;
} else {
$db = new MySQL_Access('fap');
$hash_failed = $urlID_failed = 0;
if ($h != make_hash($un)) {
$hash_failed = 1;
} else {
if ($type == 0 and !$db->Query("SELECT url, affid FROM urls WHERE id='{$urlID}' LIMIT 1")) {
$urlID_failed = 1;
} else {
if ($type == 1 and !$db->Query("SELECT url, affid FROM ad_spotlights WHERE id='{$urlID}' LIMIT 1")) {
$urlID_failed = 1;
} else {
if ($type == 2 and !$db->Query("SELECT url, affid FROM ad_billboards WHERE id='{$urlID}' LIMIT 1")) {
$urlID_failed = 1;
} else {
if ($type == 3 and !$db->Query("SELECT url, affid FROM ad_targeted WHERE id='{$urlID}' LIMIT 1")) {
$urlID_failed = 1;
} else {
if ($type == 4 and !$db->Query("SELECT url, affid FROM ad_banners WHERE id='{$urlID}' LIMIT 1")) {
$urlID_failed = 1;
} else {
if ($type == 5 and !$db->Query("SELECT url, affid FROM ad_exits WHERE id='{$urlID}' LIMIT 1")) {
{
$yr = strval(substr($dt, 0, 4));
$mo = strval(substr($dt, 4, 2));
$da = strval(substr($dt, 6, 2));
$hr = strval(substr($dt, 8, 2));
$mi = strval(substr($dt, 10, 2));
$se = strval(substr($dt, 12, 2));
return date("Y-m-d H:i:s", mktime($hr, $mi, $se, $mo, $da, $yr));
}
$day = date('d');
$onehour = 3600;
$oneday = 86400;
$midnight = mktime(0, 0, -1, date('m'), date('d'), date('y'));
$midnight = timestamp_to_mysql_timestamp($midnight);
$db = new MySQL_Access('pxm');
if ($db->Query("SELECT lastmailed FROM system WHERE lastmailed < DATE_SUB(NOW(), INTERVAL 1 DAY)")) {
$db->Query("UPDATE system SET lastmailed='{$midnight}' LIMIT 1");
$currentdate = mysql_timestamp_to_humandatetime1(timestamp_to_mysql_timestamp(time()));
list($cyear, $cmonth, $cday, $ctime) = preg_split('/[- ]/', $currentdate);
$today = getdate();
$senddate = $today['month'] . '/' . $today['mday'] . '/' . $today['year'] . ' ' . $today['hours'] . ':' . $today['minutes'] . ' - ' . $today['weekday'];
// reset all to paid=no
$db->Query("SELECT datesubmitted, id FROM orders WHERE verified='yes' AND paid != 'no' AND listname != 'bulklist' AND listownername != 'PlanetXMail'");
$orders = $db->result;
while (list($datelastbilled, $oid) = mysqli_fetch_row($orders)) {
$months = DateDiff(mysql_datetime_to_timestamp($datelastbilled), time(), 'm');
if ($months > 0) {
$db->Query("UPDATE orders SET paid='no' WHERE id='{$oid}'");
}
}
// Extended - reset all to paid=no
require_once '/home/nulled/www/targetedadplanet.com/secure/params.inc';
require_once '/home/nulled/www/targetedadplanet.com/secure/functions.inc';
require_once '/home/nulled/www/targetedadplanet.com/secure/classes.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/validationfunctions.php';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/datefunctions.inc';
$dayOfWeek = date('D');
// Mon through Sun
$dayNumWeek = date('N');
// 1 (for Monday) through 7 (for Sunday)
$onehour = 3600;
$oneday = $onehour * 24;
$midnight = mktime(0, 0, -1, date('m'), date('d'), date('y'));
$midnight = timestamp_to_mysql_timestamp($midnight);
$headers = 'From: ' . $site_name . ' <do_not_reply@' . $domain_name . '.com>';
$db = new MySQL_Access('tap');
if ($db->Query("SELECT lastreset FROM admin WHERE lastreset < DATE_SUB(NOW(), INTERVAL 1 DAY)")) {
$db->Query("UPDATE admin SET lastreset='{$midnight}' LIMIT 1");
echo "Begin new {$site_abbr} Billing day midnight={$midnight}\n";
$renew_notice = file_get_contents('/home/nulled/www/' . $domain_name . '.com/messages/renew_notice.txt');
$validate_account = file_get_contents('/home/nulled/www/' . $domain_name . '.com/messages/validate_account.txt');
$zero_credits_message = file_get_contents('/home/nulled/www/' . $domain_name . '.com/messages/zero_credits_notice.txt');
$drain_credits_message = file_get_contents('/home/nulled/www/' . $domain_name . '.com/messages/drain_credits_notice.txt');
$down_grade_notice = file_get_contents('/home/nulled/www/' . $domain_name . '.com/messages/down_grade_notice.txt');
// 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);
<?php
include "/home/nulled/www/planetxmail.com/mle/mlpsecure/config/classes.inc";
$db = new MySQL_Access("mle");
$listownerID = "1019244831";
$listname = "THEMUSTARDSEED";
# list to merge to
$listname_to_move = "SharedProfitClub";
# list to move and merger
exit;
$db->Query("SELECT userID, username FROM users WHERE listownerID='{$listownerID}' ORDER BY username");
$i = 0;
while (list($uID, $u) = $db->FetchRow()) {
$users[$i][0] = $uID;
$users[$i][1] = strtolower($u);
$i++;
}
// collect duplicate userIDs
for ($i = 0; $i < count($users); $i++) {
if ($prevuser == $users[$i][1]) {
$dupuserIDs[] = $users[$i][0];
continue;
}
$prevuser = $users[$i][1];
}
echo "<pre>";
echo "Will delete these userIDs\n";
for ($i = 0; $i < count($dupuserIDs); $i++) {
echo "{$dupuserIDs[$i]}\n";
}
echo "\nTotal: " . count($dupuserIDs) . "\n\n";
<?php
exit;
include "../mle/mlpsecure/config/classes.inc";
$db = new MySQL_Access();
echo "<pre>";
if ($mode == "userID") {
// check form duplicate userIDs
$db->Query("SELECT userID FROM users WHERE 1 ORDER BY userID");
while (list($userID) = $db->FetchRow()) {
$uIDs[] = $userID;
//echo $userID."\n";
}
for ($i = 0; $i < count($uIDs); $i++) {
if ($uIDs[$i] == $prev) {
$dups[] = $uIDs[$i];
continue;
}
$prev = $uIDs[$i];
}
for ($i = 0; $i < count($dups); $i++) {
echo $dups[$i] . "\n";
}
}
// check form duplicate username, listownerID, listname
if ($mode == "userID|listownerID|listname") {
$db->Query("SELECT username, listownerID, listname FROM users WHERE 1 ORDER BY listownerID, listname, username");
while (list($username, $listownerID, $listname) = $db->FetchRow()) {
$usernames[] = strtolower($username);
$listownerIDs[] = $listownerID;
$listnames[] = strtolower($listname);
<?php
require_once '/home/nulled/config.inc';
$db = new MySQL_Access('mle');
$db->Query("SELECT listname, listhash FROM listurls WHERE 1 ORDER BY listname");
$lists = array();
while (list($listname, $listhash) = $db->FetchRow()) {
$lists[$listhash] = $listname;
}
if ($notValid = trim($_GET['notValid'])) {
$notValid = urldecode($notValid);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>Planet X Mail - Request Safelist List</title>
<style>
a:link { color: #000; text-decoration: none; }
a:visited { color: #000; text-decoration: none; }
a:hover { color: #FF0000; text-decoration: underline; }
a:active { color: #000; text-decoration: none; }
* {
margin: 0;
padding: 0;
font: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
<?php
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/sessionsecure.inc';
require_once '/home/nulled/www/planetxmail.com/mle/aftermail.php';
require_once '/home/nulled/config.inc';
$db = new MySQL_Access('mle');
$seconds_to_wait = 7;
if ($db->Query("SELECT crediturl FROM soloads WHERE receipt != '' AND crediturl != '' AND datemailed > DATE_SUB(NOW(), INTERVAL 5 DAY) ORDER BY MD5(RAND()) LIMIT 2")) {
list($urlID1) = $db->FetchRow();
list($urlID2) = $db->FetchRow();
if ($db->Query("SELECT url FROM userlinks WHERE id='{$urlID1}' LIMIT 1")) {
list($url1) = $db->FetchRow();
}
if ($db->Query("SELECT url FROM userlinks WHERE id='{$urlID2}' LIMIT 1")) {
list($url2) = $db->FetchRow();
}
}
$header = $div . '
Thank You for Submitting your AD ... Please Wait ' . $seconds_to_wait . ' seconds so you can move on to mail on ...
</div>
';
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>Planet X Mail - After Mail Earn Credits</title>
<script type="text/javascript" src="http://freeadplanet.com/jsm.js"></script>
<script>
function uh(){if(jsm.ajax.connection.readyState==4){if(jsm.ajax.connection.status==200){jsm.byId('header').innerHTML=jsm.ajax.connection.responseText;}else{jsm.byId('header').innerHTML='<b>ERROR: Loading website failed.</b>';}}}
<?php
include "../mle/mlpsecure/config/classes.inc";
$db = new MySQL_Access("mle");
$db->Query("SELECT listownerID FROM listowner WHERE 1");
$listowners = $db->result;
echo "<pre>";
while (list($listownerID) = mysqli_fetch_row($listowners)) {
$db->Query("SELECT listname FROM listmanager WHERE listownerID='{$listownerID}' AND created=1");
$listnames = $db->result;
while (list($listname) = mysqli_fetch_row($listnames)) {
$listhash = substr(md5($listownerID . $listname . microtime()), 0, 5);
$db->Query("INSERT INTO listurls VALUES('{$listownerID}','{$listname}','{$listhash}')");
echo "{$listhash} - {$listownerID} - {$listname}\n";
}
}
echo "</pre>";
<?php
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/config/classes.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/validationfunctions.php';
$db = new MySQL_Access('mle');
$credits_mem_to_pro = 20000;
$headers = 'From: Planet X Mail <*****@*****.**>';
$h1 = '<table width="100%" height="100%"><tr><td height="100%" width="100%" bgcolor="yellow"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b><font color="#FF0000"> <font face="Courier New, Courier, mono"> <b>';
$_h1 = '</b> <a href="http://planetxmail.com/soloads.php?list=cred" target="_blank">Send a SOLO AD to 135,000+</a></font></font></td></tr></table>';
$_h2 = '</b> <a href="http://targetedadplanet.com" target="_blank">New! Launch! Earn Cash/Advertise YOUR Offerings - Click Here</a></font></font></td></tr></table>';
$h2 = mt_rand() % 2 ? $_h1 : $_h2;
// we have this here for the tor effect
if (!ctype_alnum($c . $h)) {
exit($h1 . 'Parameters not alpha numeric' . $h2);
}
if ($e and $t and $db->Query("SELECT link FROM earnedlinks WHERE link='{$c}' LIMIT 1")) {
exit($h1 . 'This credit link was already earned.' . $h2);
}
$unmixup = unmixup($c);
$seed = substr($unmixup, 0, 10);
$userID = substr($unmixup, 10, 10);
$raw = substr($unmixup, 20);
$urlID = substr($raw, 0, strlen($raw) - 1);
$type = substr($raw, strlen($raw) - 1);
$f = 0;
if ($h != makehash($unmixup)) {
$f = 1;
$userlink = 'http://planetxmail.com/soloads.php?list=cred';
} else {
if ($db->Query("SELECT url FROM userlinks WHERE id='{$urlID}' LIMIT 1")) {
list($userlink) = $db->FetchRow();
<?php
exit;
require_once '/home/nulled/www/planetxmail.com/phpsecure/classes.inc';
require_once '/home/nulled/www/freeadplanet.com/secure/functions.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/validationfunctions.php';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/datefunctions.inc';
$db = new MySQL_Access('fap');
if ($db->Query("SELECT affid FROM users WHERE 1")) {
$result = $db->result;
while (list($affid) = mysqli_fetch_row($result)) {
delete_user($affid, $db);
}
}
$db->Query("DELETE FROM commissions");
$db->Query("DELETE FROM commissions_paid");
$db->Query("DELETE FROM earnedurls");
$db->Query("DELETE FROM pastaffs");
$db->Query("DELETE FROM receipts");
$db->Query("DELETE FROM urls");
$db->Query("DELETE FROM ad_purchased");
$db->Query("INSERT INTO ad_purchased (id) VALUES('')");
echo "done...\n";
<?php
include "/home/nulled/www/planetxmail.com/phpsecure/classes.inc";
set_time_limit(0);
$db = new MySQL_Access("mle");
$i = 1;
$listownerID = "";
$listname = "";
$whichemail = "listemail";
// should be email or listemail
if (!$db->Query("SELECT {$whichemail} FROM users WHERE {$whichemail}!='' AND listownerID='{$listownerID}' AND listname='{$listname}' ORDER BY {$whichemail}")) {
echo "List or Owner not found. Or number emails found is 0";
exit;
}
$emails = $db->result;
echo "<pre>";
while (list($email) = mysqli_fetch_row($emails)) {
$db->Query("SELECT COUNT(*) FROM users WHERE {$whichemail}='{$email}' AND {$whichemail}!='' AND {$listownerID}='{$listownerID}' AND listname='{$listname}'");
list($count) = $db->FetchRow();
if ($count > 1) {
$db->Query("DELETE FROM users WHERE {$whichemail}='{$email}' AND {$whichemail}!='' AND listownerID='{$listownerID}' AND listname='{$listname}' LIMIT 1");
echo "\n{$whichemail}='{$email}' : LIMIT {$i}, -1\n";
$db->Query("SELECT {$whichemail} FROM users WHERE {$whichemail}!='' AND listownerID='{$listownerID}' AND listname='{$listname}' ORDER BY {$whichemail} LIMIT {$i}, -1");
$emails = $db->result;
$i -= 2;
flush();
continue;
} else {
echo ".";
}
$i++;
#!/usr/bin/php -q
<?php
set_time_limit(0);
$_SKIP_FORCED_REGISTER_GLOBALS = 1;
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/config/classes.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/validationfunctions.php';
$today = date('F j, Y');
$onehour = 3600;
$oneday = 86400;
$email_debug = '*****@*****.**';
echo "Start date: {$today}\n\n";
$db = new MySQL_Access('mle');
// check if system needs cleaning
$midnight = mktime(0, 0, -1, date('m'), date('d'), date('y'));
$midnight = timestamp_to_mysql_timestamp($midnight);
if ($db->Query("SELECT datelastreset FROM resetdate WHERE datelastreset < DATE_SUB(NOW(), INTERVAL 1 DAY)")) {
$db->Query("UPDATE resetdate SET datelastreset='{$midnight}' WHERE 1");
echo "Starting pxm_resetlists.php: Updated mle.resetdate.datelastreset:{$midnight}\n";
// turn vacation switch OFF, after set time period, to avoid 'vacation cheating'
// (vacationing in order to not receive mail, then turn off in order to mail, this is a cheat)
$db->Query("UPDATE users SET lastvacation='0000-00-00 00:00:00', vacation='0' WHERE lastvacation != '0000-00-00 00:00:00' AND vacation != '1' AND lastvacation < DATE_SUB(NOW(), INTERVAL 12 HOUR)");
// reset mail week limits
$db->Query("UPDATE users SET mailweek='0', mailcreditsweek='0', lastmailweek='{$midnight}' WHERE verified='yes' AND lastmailweek < DATE_SUB(NOW(), INTERVAL 7 DAY)");
// reset mailing settings per user
$db->Query("UPDATE users SET mailtoday='0', mailcreditstoday='0' WHERE verified='yes'");
// delete unverified users after 3 days
$db->Query("DELETE FROM users WHERE verified='no' AND datesignedup < DATE_SUB(NOW(), INTERVAL 3 DAY)");
$db->Query("SELECT listownerID, username, email FROM listowner WHERE username != 'demoit' ORDER BY username");
$result_owners = $db->result;
while (list($listownerID, $listowner_username, $listowneremail_1) = mysqli_fetch_row($result_owners)) {
echo "Working with listowner_username:{$listowner_username} listownerID:{$listownerID}\n";
<?php
set_time_limit(0);
die;
$numRecords = $dupUsernames = 0;
$IDs = array();
$usernames = array();
$db_connect = 1;
$sql_file = "list.txt";
$uid = "AZ";
$listname = "GlobalBusinessList";
$listownerID = "1458613339";
include "/home/nulled/www/planetxmail.com/mle/mlpsecure/config/classes.inc";
$db = new MySQL_Access();
// check if uid is taken
$db->Query("SELECT COUNT(*) FROM users WHERE RIGHT(userID, 2)='{$uid}' LIMIT 1");
list($uid_taken) = $db->FetchRow();
if ($uid_taken) {
echo "uid = {$uid} ... which is already taken!";
exit;
}
$fp = fopen($sql_file, "r");
$index = 0;
echo "<pre>";
while (!feof($fp)) {
$parts = array();
$fields = array();
$line = trim(fgets($fp, 4096));
if (!$line) {
continue;
}
<?php
include "mlpsecure/config/classes.inc";
$db = new MySQL_Access();
if (!$db->Query("SELECT listname FROM listmanager WHERE listname='{$list}' AND listownerID='{$id}'")) {
if ($db->Query("SELECT listname FROM deletedlists WHERE listname='{$list}' AND listownerID='{$id}'")) {
header("Location: listdiscontinued.php");
} else {
header("Location: logininvalid.php");
}
exit;
}
echo $_COOKIE["{$id}{$list}"];
<?php
include "../mle/mlpsecure/config/classes.inc";
$db = new MySQL_Access("elp");
$db->Query("SELECT amount FROM elpownertrans WHERE 1");
while (list($amount) = $db->FetchRow()) {
$total += $amount;
}
echo $total;
#!/usr/bin/php -q
<?php
set_time_limit(0);
$_SKIP_FORCED_REGISTER_GLOBALS = 1;
require_once '/home/nulled/config.inc';
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/validationfunctions.php';
die;
// $test = true;
$today = date('Y-m-d');
$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');
<?php
include "/home/nulled/www/planetxmail.com/phpsecure/classes.inc";
$db = new MySQL_Access("pxm");
$db->Query("SELECT product, amount, mop, receipt, dateofsale FROM transactions WHERE product!='cb_referral' AND mop='clickbank' AND dateofsale LIKE '2003-%' ORDER BY dateofsale");
echo "<pre>";
$totalamount = 0;
while (list($product, $amount, $mop, $receipt, $dateofsale) = $db->FetchRow()) {
$totalamount += $amount;
echo "{$product}, {$amount}, {$mop}, {$receipt}, {$dateofsale}\n";
}
echo "\n\nTotal Amount: {$totalamount}</pre>";
<?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);
<?php
require_once '/home/nulled/www/planetxmail.com/mle/mlpsecure/config/classes.inc';
$db = new MySQL_Access('mle');
$vhash = substr(sha1('fK#4_b87HwZOOOg!gDDuw' . $_GET['id']), 0, 5);
if (isset($_GET['h']) and $vhash == trim($_GET['h'])) {
$db->Query("SELECT link FROM links WHERE id='{$id}' LIMIT 1");
list($link) = $db->FetchRow();
$_link = urlencode($link);
$hash = substr(sha1('fK#4_b87HwZOOOg!gDDuw' . $link), 0, 5);
header('Location: showlink.php?link=' . $_link . '&h=' . $hash);
exit;
}
$db->Query("SELECT id, description, link FROM links ORDER BY id DESC");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>FREE LINK EXCHANGE! Fast and Easy Exposure!</title>
<link rel="stylesheet" type="text/css" href="x.css" />
<script>
// we do not like frame breaking, but for this we need it in order for it to work.
// this page is not ment to be shared in framed earn pages anyhow ...
if (top.location != location) top.location.href = document.location.href;
</script>
<style>
a {
font-size: 14px;
text-decoration: none;
}
function send_activated_listemail_mail($id, $list, $listemail, $uID)
{
$classloaded_MySQL_Access = 1;
include "mlpsecure/config/config.inc";
include "mlpsecure/validationfunctions.php";
$db = new MySQL_Access();
$db->Query("SELECT username, fname, lname FROM users WHERE userID='{$uID}'");
list($usernamelink, $fname, $lname) = $db->FetchRow();
$db->Query("SELECT fromname, fromemail, adminemail FROM listmanager WHERE listname='{$list}' AND listownerID='{$id}'");
list($fromname, $fromemail, $adminemail) = $db->FetchRow();
$db->Query("SELECT subsuccess FROM listmanager WHERE listname='{$list}' AND listownerID='{$id}'");
list($message) = $db->FetchRow();
$db->Query("SELECT listhash FROM listurls WHERE listownerID='{$id}' AND listname='{$list}'");
list($listhash) = $db->FetchRow();
$subject = "{$list} - List Address ACTIVATION successful.";
$message = wordwrap($message, $email_wordwrap_length);
$validator = strrev(substr(md5($uID), 0, 5));
$usr = strrev($uID);
$unsublink = "http://planetxmail.com/mle/rl.php?u={$usr}&v={$validator}";
$loginlink = "http://planetxmail.com/mle/login.php?l={$listhash}";
$message = str_replace("[unsubscribe_link]", "{$unsublink}\n", $message);
$message = str_replace("[list_name]", $list, $message);
$message = str_replace("[program_name]", $program_name, $message);
$message = str_replace("[admin_email_address]", $adminemail, $message);
$message = str_replace("[login_link]", $loginlink, $message);
$message = str_replace("[user_name]", $usernamelink, $message);
$message = str_replace("[first_name]", $fname, $message);
$message = str_replace("[last_name]", $lname, $message);
$db->Query("UPDATE users SET listemail='{$listemail}' WHERE userID='{$uID}'");
@mail($listemail, $subject, $message, "From: {$fromname} <*****@*****.**>");
return true;
}
}
}
}
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
if (stristr($contents, 'full') or stristr($contents, 'quota')) {
$bounced_col = 'mailboxfull';
$reason = $reason ? "Mailbox is Over Quota!\n" . $reason : 'Mailbox is Over Quota.';
} else {
$bounced_col = 'count';
$reason = $reason ? "Mailbox is Bouncing!\n" . $reason : 'Mailbox is Bouncing!';
<?php
include "/home/nulled/www/planetxmail.com/mle/mlpsecure/config/classes.inc";
// Note:
// Need to update pxm DB
// Need to delete the listowner from mle.listowner if no more remaing lists
$listownerID = "1019244831";
// id to move list to
$listname_to_move = "SharedProfitClub";
// list to move
$move_from_id = "4394402383";
// id to move from
exit;
$db = new MySQL_Access("mle");
$db->Query("UPDATE users SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE upgrade SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE system SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE listurls SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE listmanager SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE listconfig SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE banners SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE ads SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
$db->Query("UPDATE banneddomains SET listownerID='{$listownerID}' WHERE listname='{$listname_to_move}' AND listownerID='{$move_from_id}'");
echo "Done";