private function confirm_user()
{
$this->loadModel("User");
//get the persons profile
$user = $this->User->find("first", array("conditions" => array("User.id" => $this->Auth->User("id"))));
$profile = $this->User->ensure_user_profile($user['User']['id']);
$sql = "SELECT current_location FROM user where uid=me()";
//$sql = "SELECT hometown_location FROM user WHERE uid='1383222383'";
$location = FacebookApi::instance()->facebook->api(array("method" => "fql.query", "query" => $sql, "format" => "json"));
$loc = $location[0]['current_location'];
if (count($loc) <= 0) {
//return false;
}
//die(print_r($location));
//update the users profile location
$this->User->UserProfile->create();
$this->User->UserProfile->id = $profile['UserProfile']['id'];
$update = array();
if (isset($loc['country'])) {
$update['geo_country_name'] = $loc['country'];
}
if (isset($loc['city'])) {
$update['geo_city_name'] = $loc['city'];
}
if (isset($loc['state'])) {
$update['geo_region_name'] = $loc['state'];
}
return $this->User->UserProfile->save($update);
}
/**
* Return Singleton Instance
* @return FacebookApi
*/
public function instance()
{
if (!self::$instance) {
self::$instance = new self();
}
return self::$instance;
}
public function fb()
{
$fb = FacebookApi::instance();
$sql = "SELECT url, normalized_url, share_count, like_count, comment_count, total_count,\n\t\t\t\tcommentsbox_count, comments_fbid, click_count FROM link_stat WHERE url='http://theberrics.com/gen-ops/girl-chocolate-trailer.html'";
$q = $fb->facebook->api(array("method" => "fql.query", "query" => $sql, "format" => "json"));
$count = $q[0]['total_count'];
die($count);
}
public function update_facebook_likes($id)
{
$entry = $this->find("first", array("conditions" => array("BangyoselfEntry.id" => $id), "contain" => array("Dailyop" => array("DailyopSection"))));
$fb = FacebookApi::instance();
$sql = "SELECT url, normalized_url, share_count, like_count, comment_count, total_count,\n\t\t\t\tcommentsbox_count, comments_fbid, click_count FROM link_stat WHERE url='http://theberrics.com/{$entry['Dailyop']['DailyopSection']['uri']}/{$entry['Dailyop']['uri']}'";
$q = $fb->facebook->api(array("method" => "fql.query", "query" => $sql, "format" => "json"));
$count = $q[0]['total_count'];
$this->create();
$this->id = $id;
$this->save(array("like_count" => $count));
}
public function handle_facebook_callback($callback = false)
{
$fb = FacebookApi::instance();
//$fb_session = $fb->facebook->getSession();
$fb_user = $fb->facebook->api("/me");
$fb_data = array("facebook_account_num" => $fb_user['id'], "first_name" => $fb_user['first_name'], "last_name" => $fb_user['last_name'], "email" => $fb_user['email'], "profile_image_url" => "http://graph.facebook.com/" . $fb_user['id'] . "/picture");
if ($callback) {
$callback = base64_decode($callback);
}
if ($this->Session->check("here") && !$callback) {
$callback = $this->Session->read("here");
}
if (empty($callback) || !$callback) {
$callback = "/";
}
$this->userAccount = $this->User->locateLoginAccount($fb_data);
$this->authAccount();
return $this->redirect($callback);
}
