Sorting by facebook likes

duhol · 10-15-2011 07:34 PM

I change task

PHP Code:

<?php
    global $mybb, $db, $lang;
    $threads = array();
    // Update thread likes
    $query = $db->query("
        SELECT tid
        FROM ".TABLE_PREFIX."threads
        GROUP BY tid
    ");
    while($thread = $db->fetch_array($query))
    {
            $source_url[] = "http://www.sentens.pl/showthread.php?tid=".$thread['tid'];
            $url = "http://api.facebook.com/restserver.php?method=links.getStats&urls=".implode( ',', $source_url );
            $xml = file_get_contents($url);
            $xml = simplexml_load_string($xml);

    }

            foreach( $xml -> link_stat as $l)
            {
                $s = $l -> url;
                $out = preg_replace("#[^0-9]*#" ,"", $s);
                $l -> total_count;
                $total = $l -> total_count;
                $db->update_query("threads", array('likes' => "{$total}"), "tid='{$out}'", 1, true);

            }

?>

but the problem is that facebook restserver has trouble with 1000 threads at once. My task ask him about all and then write data to DB.

Can you help me to change a task in way that it ask about first thread, then write data to table, ask about second thread and write data to table, ask about third thread and write data to table, etc.

Thanks

Threaded Mode \| Linear Mode Standard Tools
Forum Jump: View a Printable Version Send this Thread to a Friend Subscribe to this thread