Exemplo n.º 1
0
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");
    }
}
Exemplo n.º 2
0
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;
}