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); }