registration.php

<?php

class Registration {
	
	private $params;
	private $salt = "typearandomsalt";
	private $devhouse_edition = 5;

	public $status = "init";
	public $message = "";
	public $verified_user;
	public $users;
	
	private $db_link = null;
	private $db_host = "localhost";
	private $db_user = "";
	private $db_password = "";
	private $db_name = "guadalajaradevhouse";
	private $db_table = "users";

	function __construct($params) {
		$this->params = $params;
		$this->verified_user = array();
		$this->users = array();
		$this->init_registration();
	}
	
	private function init_registration() {
		$this->fetch_all_users();

		// twitter 1
		if (!empty($this->params['oauth_token']) && !empty($this->params['oauth_verifier'])) {
			$this->verify_twitter();
		}
		// twitter 2
		else if( !empty($this->params['form_key']) && !empty($this->params['social_id']) &&
		 		 $this->params['form_key'] == md5($this->salt.$this->params['social_id']) ) {

			if (!$this->verify_form())
				return;

			$this->register_user();
		}
		// facebook 1
		else if (!empty($this->params["first_name"]) && !empty($this->params["last_name"])) {
			$this->verified_user['name'] = $this->params['name'];
			$this->verified_user['social_web'] = "facebook";
			$this->verified_user['social_id'] = $this->params['id'];
			$this->verified_user['social_username'] = $this->params['first_name'];
			$this->verified_user['social_url'] = $this->params['link'];
			$this->verified_user['social_avatar_url'] = "https://graph.facebook.com/{$this->verified_user['social_id']}/picture";
			$this->status = "facebook_form";
		}
		// facebook 2
		else if (!empty($this->params['social_web']) && $this->params['social_web'] == "facebook" &&
				 !empty($this->params['form_key']) && $this->params['form_key'] == md5($this->salt.$this->params['social_id']) ) {

			if (!$this->verify_form())
				return;

			$this->register_user();
		}
	}
	
	private function verify_form() {
		if (empty($this->params['name']) || empty($this->params['activity'])) {
			$this->verified_user['name'] = $this->params['name'];
			$this->verified_user['social_web'] = $this->params['social_web'];
			$this->verified_user['social_id'] = $this->params['social_id'];
			$this->verified_user['social_username'] = $this->params['social_username'];
			$this->verified_user['social_url'] = $this->params['social_url'];
			$this->verified_user['social_avatar_url'] = $this->params['social_avatar_url'];

			$this->status = "form_error";
			$this->message = "Sería mejor si nos dijeras tu nombre y tu plan para el día.";
			return false;
		}
		
		return true;
	}
	
	private function verify_twitter() {
		require_once('twitter/twitteroauth.php');
		require_once('twitter/config.php');

		$connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, $_SESSION['oauth_token'], $_SESSION['oauth_token_secret']);
		$access_token = $connection->getAccessToken($_REQUEST['oauth_verifier']);

		unset($_SESSION['oauth_token']);
		unset($_SESSION['oauth_token_secret']);

		if (200 == $connection->http_code) {
			$connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, $access_token['oauth_token'], $access_token['oauth_token_secret']);
			$content = $connection->get('account/verify_credentials');
			
			$this->verified_user['name'] = $content->name;
			$this->verified_user['social_web'] = "twitter";
			$this->verified_user['social_id'] = $content->id;
			$this->verified_user['social_username'] = $content->screen_name;
			$this->verified_user['social_url'] = "http://www.twitter.com/{$this->verified_user['social_username']}";
			$this->verified_user['social_avatar_url'] = $content->profile_image_url;
			$this->status = 'twitter_verified';
		}
		else {
			$this->status = "twitter_error";
		}
	}
	
	private function fetch_all_users() {
		if ($this->db_link == null) {
			$this->mysql_create();
		}
		
		$query = "SELECT * FROM users WHERE devhouse_edition = {$this->devhouse_edition}";
		$result = @mysql_query($query);

		$i = 0;
		while ($row = @mysql_fetch_assoc($result)) {
			$this->users[$i]['name'] = $row['name'];
			$this->users[$i]['activity'] = $row['activity'];
			$this->users[$i]['social_web'] = $row['social_web'];
			$this->users[$i]['social_id'] = $row['social_id'];
			$this->users[$i]['social_username'] = $row['social_username'];
			$this->users[$i]['social_url'] = $row['social_url'];
			$this->users[$i]['social_avatar_url'] = $row['social_avatar_url'];
			$i++;
		}

		@mysql_close($this->db_link);
		$this->db_link = null;
	}
	
	public function verified_is_registered() {
		if (empty($this->verified_user)) {
			return false;
		}
		
		foreach ($this->users as $value) {
			if ($value['social_web'] == $this->verified_user['social_web'] && $value['social_id'] == $this->verified_user['social_id']) {
				return true;
			}
		}
		
		return false;
	}
	
	private function register_user() {
		foreach ($this->users as $value) {
			if ($value['social_web'] == $this->params['social_web'] && $value['social_id'] == $this->params['social_id']) {
				$this->status = "user_already_registered";
				$this->message = "Ya estas registrado con este usuario, si tienes alguna duda contactanos.";
				return;
			}
		}

		if ($this->db_link == null) {
			$this->mysql_create();
		}

		$name = mysql_escape_string($this->params['name']);
		$activity = mysql_escape_string($this->params['activity']);
		$social_web = mysql_escape_string($this->params['social_web']);
		$social_id = mysql_escape_string($this->params['social_id']);
		$social_username = mysql_escape_string($this->params['social_username']);
		$social_url = mysql_escape_string($this->params['social_url']);
		$social_avatar_url = mysql_escape_string($this->params['social_avatar_url']);
		
		$query  = "INSERT INTO `{$this->db_table}` VALUES (NULL, '{$name}', '{$activity}', '{$social_web}', '{$social_id}'";
		$query .= ", '{$social_username}', '{$social_url}', '{$social_avatar_url}', {$this->devhouse_edition}, NOW())";
		@mysql_query($query);
		@mysql_close($this->db_link);
		$this->db_link = null;
		
		end($this->users);
		$last_key = key($this->users) + 1;
		
		$this->users[$last_key]['name'] = $this->params['name'];
		$this->users[$last_key]['activity'] = $this->params['activity'];
		$this->users[$last_key]['social_web'] = $this->params['social_web'];
		$this->users[$last_key]['social_id'] = $this->params['social_id'];
		$this->users[$last_key]['social_username'] = $this->params['social_username'];
		$this->users[$last_key]['social_url'] = $this->params['social_url'];
		$this->users[$last_key]['social_avatar_url'] = $this->params['social_avatar_url'];
		
		$this->status = "user_registered";
		$this->message = "Gracias por confirmar tu asistencia, te hemos agregado en el listado al final de esta página.";
	}
	
	private function mysql_create() {
		$this->db_link = @mysql_connect($this->db_host, $this->db_user, $this->db_password);
		
		if (!$this->db_link)
			die("Can't connect to database");

		if (!@mysql_select_db($this->db_name))
			die("Can't select database");
	}
}

?>