<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// PROVID
	// LEGALNAME
	// LEGALADDRESS
	// OFFICENUM
	// MOBILNUM
	// FAXNUM
	// EMAIL
	// WEBURL
	// GSTREETNUM
	// GSTREET
	// GCITY
	// GCODE
	// GCOUNTRY
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- format the date
	$creation_date = date("Y-m-d H:i:s");

	if ($PROVID == "-1")
	{
		$query = "INSERT INTO companies (COMP_NAME, COMP_ADDRESS, COMP_PHONE, COMP_MOBILE, COMP_FAX, COMP_EMAIL, COMP_URL, COMP_GSTREETNUM, COMP_GSTREET, COMP_GCITY, COMP_GCODE, COMP_GCOUNTRY, COMP_REGDATE)";
		$query.= " VALUES (\"".addslashes(utf8_decode($LEGALNAME))."\", \"".addslashes(utf8_decode($LEGALADDRESS))."\", \"".addslashes(utf8_decode($OFFICENUM))."\", \"".addslashes(utf8_decode($MOBILNUM))."\", \"".addslashes(utf8_decode($FAXNUM))."\"";
		$query.= ", \"".addslashes(utf8_decode($EMAIL))."\", \"".addslashes(utf8_decode($WEBURL))."\", \"".addslashes(utf8_decode($GSTREETNUM))."\", \"".addslashes(utf8_decode($GSTREET))."\"";
		$query.= ", \"".addslashes(utf8_decode($GCITY))."\", \"".addslashes(utf8_decode($GCODE))."\", \"".addslashes(utf8_decode($GCOUNTRY))."\", \"$creation_date\")";
		$conn->query($query);

		//---- get new providerID
		$query = "SELECT LAST_INSERT_ID() AS MYID";
		$conn->query($query);
		if ($conn->next_record())
			$PROVID = $conn->field_value("MYID");
	}
	else
	{	$query = "UPDATE companies SET COMP_NAME=\"".addslashes(utf8_decode($LEGALNAME))."\", COMP_ADDRESS=\"".addslashes(utf8_decode($LEGALADDRESS))."\", COMP_PHONE=\"".addslashes(utf8_decode($OFFICENUM))."\"";
		$query.= ", COMP_MOBILE=\"".addslashes(utf8_decode($MOBILNUM))."\", COMP_FAX=\"".addslashes(utf8_decode($FAXNUM))."\", COMP_EMAIL=\"".addslashes(utf8_decode($EMAIL))."\", COMP_URL=\"".addslashes(utf8_decode($WEBURL))."\"";
		$query.= ", COMP_GSTREETNUM=\"".addslashes(utf8_decode($GSTREETNUM))."\", COMP_GSTREET=\"".addslashes(utf8_decode($GSTREET))."\", COMP_GCITY=\"".addslashes(utf8_decode($GCITY))."\", COMP_GCODE=\"".addslashes(utf8_decode($GCODE))."\"";
		$query.= ", COMP_GCOUNTRY=\"".addslashes(utf8_decode($GCOUNTRY))."\", COMP_REGDATE=\"$creation_date\"";
		$query.= " WHERE COMP_ID='".$PROVID."'";
		$conn->query($query);
	}

	print "RESULT=done&PROVID=".$PROVID;
?>