MPOS/php-mpos

#!/usr/bin/php
<?php
    /* script to validate accounts */

    // Change to working directory
    chdir(dirname(__FILE__));

    // Include all settings and classes
    require_once('shared.inc.php');

  $options = getopt("d:n:ah");
    isset($options['d']) ? $timeLimitInDays = (int)$options['d'] : $timeLimitInDays = 90;
  isset($options['a']) ? $allUsers = true : $allUsers = false;
    isset($options['n']) ? $notifyStaleUsers = true : $notifyStaleUsers = false;
  if (isset($options['h'])) {
    echo "Usage " . basename($argv[0]) . " [-d #] [-a] [-n]:" . PHP_EOL;
    echo "  -h       :  Show this help" . PHP_EOL;
    echo "  -d #     :  Only show users inactive for more that # days" . PHP_EOL;
    echo "  -n       :  Notify stale accounts via e-mail [EXPERIMENTAL]" . PHP_EOL;
    echo "  -a       :  Show all pool users regardless of inactivity" . PHP_EOL;
    exit(0);
  }

    // Fetch all users
    $users = $user->getAllAssoc();

    $mask = "| %6s | %20s | %30s | %16s | %20s | %12.12s | %5s | %5s | %12s | %5s | \n";
    printf($mask, 'ID', 'Username', 'eMail', 'LoggedIP', 'Last Login','Days Since', 'Ever', 'Trans', 'Balance','Stale');

    $currentTime = time();
    $totalSavings = 0;

    foreach ($users as $user) {
        $id = $user['id'];
        $isAdmin = $user['is_admin'];
        $username = $user['username'];
        $loggedIp = $user['loggedIp'];
        $lastLogin  = $user['last_login'];
        $mailAddress = $user['email']; 

        $everLoggedIn = !empty($lastLogin);
        $timeDelta = $currentTime - $lastLogin;
        $lastLoginInDays = round(abs($timeDelta)/60/60/24, 0);

        if(!$allUsers && $lastLoginInDays < $timeLimitInDays)
            continue;

        // get transactions summary for the user
        $summary = $transaction->getTransactionSummary($id);
        $transactions_exists = !empty($summary);

        // get balances
        $balances = $transaction->getBalance($id);
        $confirmedBalance = $balances['confirmed'];
        $totalSavings += $confirmedBalance;

        $staleAccount = $everLoggedIn == false && $transactions_exists == false;

        if ($notifyStaleUsers) {
            $subject = "Account at " . $setting->getValue('website_name') . "!";
            $body = "Hi ". $username .",\n\nWe have discovered \
            your username as inactive. Your last login is older than 90 days, \
            please reactivate your Account if you want to mine again, \
            else it will be deleted in 30 days.\n\nBalance left: ".  $confirmedBalance . " " . $config['currency'] . "\n\nCheers";

            if (mail($mailAddress, $subject, $body)) {
                echo("Email successfully sent!");
            } else {
                echo("Email delivery failed...");
            }
        }

        printf($mask, $id, $username, $mailAddress,
                    $loggedIp, strftime("%Y-%m-%d %H:%M:%S", $lastLogin), $lastLoginInDays, $everLoggedIn ? 'yes' : 'no', 
                    $transactions_exists ? 'yes' : 'no', round($confirmedBalance,8),
                    $staleAccount ? 'yes' : 'no'    );
    }

    echo "Total balance of stale accounts: $totalSavings" . PHP_EOL;
?>