_appcake_dump.cli.php

<?php

if (PHP_SAPI != 'cli') {
    die('must be run from cli');
}

require_once 'init.php';

$trackids = $API->DB->query_return("SELECT trackid FROM apps ORDER BY added DESC");

$total = count($trackids);
print "Round 1 - starting to add links to {$total} apps..\n";
ob_flush();
$current = 0;
foreach ($trackids as $tid) {
    $current++;
    $percentage = round($current / $total, 5) * 100;

    $cake_links = json_decode(curl_request('https://dev.appaddict.org/assets/org_appaddict_imperator/api/?brickwallID=' . $tid['trackid']), true);
    //var_dump($cake_links);
    // dirty zorro fix
    $cake_links['links'] = $cake_links;
    if ($cake_links['links']) {
        $count = 0;

        $skipcount = 0;
        foreach ($cake_links['links'] as $l) {

            $count++;
            if (!preg_match('#(filepup|ul\.to|uploaded\.net|thefilebay\.com|mega\.co\.nz)#si', $l['url'])) {
                $skipcount++;
                continue;
            }
            $to_links['version'] = htmlspecialchars($l['version']);
            $to_links['cracker'] = htmlspecialchars($l['cracker']);
            if ($to_links['cracker'] == 'not_given') {
                $to_links['cracker'] = 'Unknown';
            }else if ($to_links['cracker'] == 'AppCakeBot') {
                $to_links['cracker'] = 'Unknown';
            }

            $to_links['link'] = $l['url'];
            $uploader_id = $API->DB->query_row("SELECT id FROM accounts ORDER BY RAND() LIMIT 1");
            $to_links['uploader_id'] = $uploader_id['id'];
            $added = $API->DB->query_row("SELECT added FROM links ORDER BY RAND() LIMIT 1");
            $to_links['added'] = $added['added'];
            $to_links['trackid'] = $tid['trackid'];
            $to_links['state'] = 'accepted';
            //die(var_dump($to_links));
            $API->DB->query("INSERT INTO links {$API->DB->build_insert_query($to_links)}");
        }
    }

    print "{$percentage}% {$tid['trackid']} : $count inserted, $skipcount skipped\n";
    ob_flush();
}

print "ROUND 2 - links checking...\n\n";
$links = $API->DB->query_return("SELECT id,link FROM links ORDER BY id DESC");
$total = count($links);
print "$total total links...\n";

ob_flush();

$current = 0;
foreach ($links as $l) {
    $current++;

    $percentage = round($current / $total, 5) * 100;

    if (!preg_match('#(filepup|ul\.to|uploaded\.net|thefilebay\.com|mega\.co\.nz|turbobit\.net)#si', $l['link'])) {
        print "{$percentage}% {$l['link']} {$l['id']} skippping\n";
        ob_flush();
        continue;
    }
    $check = curl_request('https://dev.appaddict.org/assets/org_appaddict_imperator/linksChecker/?link=' . urlencode($l['link']));

    if ($check == 'dead') {
        $API->DB->query("UPDATE links SET state='dead' WHERE id={$l['id']}");
        print "$percentage %, {$l['link']} {$l['id']} is $check\n";
    } else {
        print "$percentage %, {$l['link']} {$l['id']} is $check\n";
    }
    ob_flush();
}

print "DONE \n\n\n";