<?php

$fb_user_id = $user_profile['id']; //unique key
$fb_name = $user_profile['name'];


$dbc = mysql_connect('mysql.greekius.com', 'tdiepiv', 'stopit');
mysql_select_db('greekius_db');

$query = "INSERT INTO user_table (userid, name) VALUES
	('$fb_user_id', '$fb_name')";

@mysql_query($query, $dbc);

mysql_close($dbc);


if ($_SERVER['REQUEST_METHOD'] == 'POST'){ //handle the form
	$dbc = mysql_connect('mysql.greekius.com', 'tdiepiv', 'stopit');
	mysql_select_db('greekius_db');




	//validate the form data:
	$problem = FALSE;
	if (!empty($_POST['greek_name'])) {
		$greek_name = trim(strip_tags($_POST['greek_name']));

	}
	//if the entry is improper
	else {
		print '<p style="color: red;">Please enter a valid name and greek organization.</p>';
		$problem = TRUE;
	}
	if (!$problem){
		//define the query:
		$query = "UPDATE user_table SET greek_org = '$greek_name' WHERE userid = '$fb_user_id'";

		//execute the query now:
		if (mysql_query($query, $dbc)){
			print '<p>Welcome. You\'ve been listed. However, we need your friends to verify!' . '</p>';
		}
		else {
			print '<p style="color: red;">Sorry, you were not listed because:<br />'
			. mysql_error($dbc) . '.</p><p>The query being run was: ' . $query . '</p>';
		}
	} //THERE WERE NO FUCKING PROBLEMS.

	mysql_close($dbc);
}

	?>