function get_fb_friends($param) { $graph_url = $param->graph_url . '/' . $param->fbid . '/' . $param->connection . '?access_token=' . $param->token; $fb = get_graphapi_data($graph_url); $fbdata = $fb->data; $cdate = date('Y-n-j H:i:s'); echo "inside get_fb_friends"; if ($fbdata) { logme('updating friends if any'); } $sql_insert = "INSERT INTO friends_raw_data(facebook_id,friends_fbid,friends_name,friend_location_name,fbdata,created_date) VALUES "; $sql = ''; foreach ($fbdata as $data) { $sql_select = sprintf("SELECT friends_fbid FROM friends_raw_data WHERE facebook_id='%s' AND friends_fbid='%s'", mysql_real_escape_string($param->fbid), mysql_real_escape_string($data->id)); $result = mysql_query($sql_select); if (mysql_num_rows($result) == 0) { $graph_url_of_friend = $param->graph_url . '/' . $data->id . '?access_token=' . $param->token; $fb = get_graphapi_data($graph_url_of_friend); $data_temp = serialize($data); $sql .= sprintf(", ('%s','%s','%s','%s','%s','%s')", mysql_real_escape_string($param->fbid), mysql_real_escape_string($data->id), mysql_real_escape_string($data->name), mysql_real_escape_string(@$fb->location->name), mysql_real_escape_string($data_temp), $cdate); } echo "\n\nplease wait....{$data->id}\n\n"; } if ($sql) { $sql = substr($sql, 1); $query = $sql_insert . $sql; mysql_query($query); } //echo '<br/><br/>'.$query; if (mysql_errno()) { echo "error encoutered..."; logme(mysql_error() . '==' . $query); die(mysql_errno() . ': ' . mysql_error() . '; ' . $query . "\n"); } }
function create_from_obj($param, $fromid) { $graph_url = 'https://graph.facebook.com/fql?access_token=' . $param->token . '&q=' . urlencode('select first_name, last_name from user where uid=') . $fromid; $fb = get_graphapi_data($graph_url); $user = $fb->data; $from = new stdclass(); $from->name = $user[0]->first_name . ' ' . $user[0]->last_name; $from->id = $fromid; return $from; }