Sorting by facebook likes

duhol · 10-16-2011 08:58 PM

This is my code. Maybe it doesnt wise solution, but works. No facebook database errors, no my database errors, take about 8 minutes for 1000 threads.
So, I have to leave it that way and you dont want to tell me about other way.

PHP Code:

<?php

function task_top_fb($task)
{

	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))
	{
			$url = "http://api.facebook.com/restserver.php?method=links.getStats&urls=http://www.sentens.pl/showthread.php?tid=".$thread['tid'];
			$xml = file_get_contents($url);
			$xml = simplexml_load_string($xml);
			foreach( $xml -> link_stat as $l)
			{
				$l -> total_count;
				$total = $l -> total_count;
				$db->update_query("threads", array('likes' => "{$total}"), "tid='{$thread['tid']}'", 1, true);
			}
	}
	add_task_log($task, "Zadanie aktualizacji ilosci 'lubie to' zostalo wykonane. :P");
}
?>

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