function get_statuses($param)
{
$since_dt = get_date_range($param);
$offset = $param->offset;
$graph_url = $param->graph_url . $param->connection . '?access_token=' . $param->token . "&since={$since_t->since}&limit={$param->limit}&offset={$offset}";
$fb = get_graphapi_data($graph_url);
$fbdata = $fb->data;
$cdate = date('Y-n-j H:i:s');
if ($fbdata) {
logme('updating status');
}
echo "\nstart...";
print_r($fbdata);
$sql_insert = "INSERT INTO {$param->table_name}(facebook_id,connection,fb_dataid,fbdata,fbdata_postedtime,created_date) VALUES ";
while ($fbdata) {
$sql = '';
$counter = 0;
foreach ($fbdata as $data) {
$counter++;
echo "\nplease wait..processing for... {$counter}";
//check for duplicate, just in case
$sql_select = "SELECT facebook_id FROM {$param->table_name} WHERE facebook_id='{$param->fbid}' and fb_dataid='{$data->id}'";
$result = mysql_query($sql_select);
if (mysql_num_rows($result) == 0) {
$data_temp = serialize($data);
$dt = new DateTime($data->updated_time);
$fbdata_postedtime = $dt->format('Y-n-j H:i:s');
$sql .= sprintf(", ('%s','%s','%s','%s','%s','%s')", mysql_real_escape_string($param->fbid), $param->connection, $data->id, mysql_real_escape_string($data_temp), $fbdata_postedtime, $cdate);
}
}
if ($sql) {
$sql = substr($sql, 1);
$query = $sql_insert . $sql;
mysql_query($query);
if (mysql_errno()) {
logme(mysql_error() . '==' . $query);
die(mysql_errno() . ': ' . mysql_error() . '; ' . $query . "\n");
}
}
$fbdata = '';
if ($counter >= $param->limit) {
//navigate to next page of the graph explorer
$offset += 25;
$graph_url = $param->graph_url . $param->connection . '?access_token=' . $param->token . "&since={$since_dt->since}&limit={$param->limit}&offset={$offset}";
$fb = get_graphapi_data($graph_url);
$fbdata = $fb->data;
}
}
mysql_free_result($result);
save_comments_likes($param);
}
function get_album_photos($param, $album_ids)
{
$arr_albums_ids = explode(';', $album_ids);
foreach ($arr_albums_ids as $id) {
$graph_url = $param->graph_url . $id . '/' . $param->connection . '?access_token=' . $param->token;
$fb = @json_decode(file_get_contents($graph_url));
$fbdata = $fb->data;
$cdate = date('Y-n-j H:i:s');
$sql_insert = "INSERT INTO {$param->table_name}(facebook_id,connection,album_id,fb_dataid,fbdata,width,height,hd,medium,small,fbdata_postedtime,created_date) VALUES ";
while ($fbdata) {
$sql = '';
foreach ($fbdata as $data) {
//check first if there is a previous data
$sql_select = sprintf("SELECT album_id FROM {$param->table_name} WHERE facebook_id='%s' AND fb_dataid='%s'", mysql_real_escape_string($param->fbid), mysql_real_escape_string($data->id));
$result = mysql_query($sql_select);
if (mysql_num_rows($result) == 0) {
$data->original_image = $data->source;
$data_temp = serialize($data);
$dt = new DateTime($data->updated_time);
$fbdata_postedtime = $dt->format('Y-n-j H:i:s');
$hd = $data->images[0]->source;
$medium = $data->images[3]->source;
$small = $data->images[7]->source;
$sql .= sprintf(", ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", mysql_real_escape_string($param->fbid), 'album_photos', $id, mysql_real_escape_string($data->id), mysql_real_escape_string($data_temp), $data->width, $data->height, $hd, $medium, $small, $fbdata_postedtime, $cdate);
}
mysql_free_result($result);
}
if ($sql) {
$sql = substr($sql, 1);
$query = $sql_insert . $sql;
mysql_query($query);
if (mysql_errno()) {
logme(mysql_error() . '==' . $query);
die(mysql_errno() . ': ' . mysql_error() . '; ' . $query . "\n");
}
}
//navigate to next page of the graph explorer
$fbpaging = $fb->paging;
$fb = @json_decode(file_get_contents($fbpaging->next));
$fbdata = $fb->data;
}
}
save_comments_likes($param);
}
