committers/committertools/cq_post.php - gerrit/websites/dev.eclipse.org - Git at Google

 <?php

 	require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_ipzilla_rw.class.php");
 	require_once("/home/data/httpd/eclipse-php-classes/system/app.class.php");
 	require_once("/home/data/httpd/eclipse-php-classes/people/ldapperson.class.php");
 	require_once("/home/data/httpd/eclipse-php-classes/menu/menu.class.php");

 	#*****************************************************************************
 	#
 	# cq_post.php
 	#
 	# Author: 		Denis Roy and others
 	# Date:			2005-01-21
 	#
 	# Description: Process to store contribution questionnaires and e-mail EMO
 	#
 	# HISTORY:
 	#
 	#****************************************************************************


 	$App 	= new App();
 	$App->runStdWebAppCacheable();
 	$ErrorMessage = "";

 	$LDAPPerson = new LDAPPerson();
 	$LDAPPerson = $LDAPPerson->redirectIfNotLoggedIn();

 	$IPZillaHome		= "https://dev.eclipse.org/ipzilla";
 	$FoundationDBHome	= "https://foundation.eclipse.org";

 	$disablemail		= false;

 	# Connect to the IPZilla database
 	$dbc    = new DBConnectionIPZillaRW();
 	$dbh    = $dbc->connect();


 	$MasterIPZillaEntry = new IPZillaEntry();

 	$SubmitterProfile = new Profile();
 	$SubmitterProfile->selectProfileFromExternID($LDAPPerson->getUid());

 	if($_POST['c'] == "") {

 		# new (Master) contribution for IPZilla

 		# Split product|component from the POST
 		$pc = explode("|", $_POST['component_id']);
 		$product_id = $pc[0]; $component_id = $pc[1];

 		$CommitterProfile = new Profile();
 		$CommitterProfile->selectProfileFromUserID($_POST['committer_id']);

 		$ProjectLeadProfile = new Profile();
 		$ProjectLeadProfile->selectProfileFromUserID($_POST['projectlead_id']);

 		$bug_id = $MasterIPZillaEntry->insertEntry(
 					$product_id,
 					$component_id,
 					$SubmitterProfile,
 					$_POST['contributionName'] . " Version: " . $_POST['contributionVersion'],
 					"container",
 					0,
 					$_POST['cqtype']
 		);

 		# Create directory to hold attachments > 20MB
 		mkdir("/home/data/common/ip/ipzilla-" . $bug_id, 0770);

 		# Send e-mail

 		$message = $SubmitterProfile->realname . " submitted a Contribution Questionnaire to IPZilla:\n\n";
 		$message .= "    " . $_POST['contributionName'] . " Version: " . $_POST['contributionVersion'] . "\n\n";
 		$message .= "    You can view the details at the following address:\n    " . $IPZillaHome . "/show_bug.cgi?id=" . $bug_id . "\n\n";

 		$message .= "    ** You're not done yet! **";
 		$message .= "    You need to attach the source code (not binary) for all the packages in this contribution.\n\n";
 		$message .= "    If the file size is 20MB or less, log in to IPZilla (using your bugs.eclipse.org committer account) and use the attachment feature.\n";
 		$message .= "    If the file size exceeds 20MB, please use an SFTP or SCP client to transfer the file to the correct ipzilla subdirectory of dev.eclipse.org:/home/data/common/ip, according the the IP Bug number. Log into IPZilla and submit the file name in a comment.\n\n";
 		$message .= "    Once the source is attached or transferred, your PMC must approve this package by having one representative of the PMC vote +1 on the IPZilla entry. The Eclipse IP team will NOT review your contribution until this is done.\n\n";


 		$message .= "-------------\nThe raw entry is as follows:\n\n" . $MasterIPZillaEntry->comment0;

 		$watchlist = selectWatchlist($MasterIPZillaEntry->initialowner);

 		# include PMC
 		if(!is_numeric(array_search($ProjectLeadProfile->login_name, $watchlist))) {
 			$watchlist[count($watchlist)] = $ProjectLeadProfile->login_name;
 		}

 		# include the submitter
 		if(!is_numeric(array_search($SubmitterProfile->login_name, $watchlist))) {
 			$watchlist[count($watchlist)] = $SubmitterProfile->login_name;
 		}
 		foreach ($watchlist as $watcher) {
 			if(! $disablemail) {
 				mail($watcher, "[IPZilla CQ: " . $bug_id . "]: " . $_POST['contributionName'] . " " . $_POST['contributionVersion'], $message, "From: IPZilla <emo-ip-team@eclipse.org>");
 			}
 		}
 		# End: send e-mail


 		if($_POST['preExistPkgList'] != "") {
 			# count this and send as param: $_POST['preExistPkgList']
 			setcookie("preExistPkgList", $_POST['preExistPkgList']);
 			setcookie("bug_id", $bug_id);
 			setcookie("projectlead_id", $_POST['projectlead_id']);
 			header("Location: cq_part2.php?i=" . $bug_id);
 		}
 		else {
 			header("Location: cq_out.php?bug_ids=" . $bug_id );
 		}
 	}
 	else {


 		# existing contribution
 		# get number of packages and save this info.

 		if($_POST['c'] != $_COOKIE['bug_id']) {
 			die("An internal error has occurred. Your questionaire may not be complete. Please contact webmaster@eclipse.org.");
 		}
 		$MasterIPZillaEntry->selectEntry($_COOKIE['bug_id']);

 		if($_POST['projectlead_id'] == "") {
 			die("An internal error has occurred while attempting to locate the PMC record for this questionnaire. Your questionaire may not be complete. Please contact webmaster@eclipse.org.");
 		}

 		$ProjectLeadProfile = new Profile();
 		$ProjectLeadProfile->selectProfileFromUserID($_POST['projectlead_id']);

 		$preExistPkgList = $_COOKIE['preExistPkgList'];

 		$pkgList = split("\n", $preExistPkgList);

 		$relatedPackages = "";
 		$relatedIPZillaBugIDs = "";

 		for($i = 0; $i < count($pkgList); $i++) {
 			if($pkgList[$i] != "") {

 				$IPZillaEntry = new IPZillaEntry();
 				$bug_id = $IPZillaEntry->insertEntry($MasterIPZillaEntry->product_id,
 									$MasterIPZillaEntry->component_id,
 									$SubmitterProfile,
 									$_POST['pkgName' . $i] . " Version: " . $_POST['pkgVersion' . $i],
 									"child",
 									$i,
 									$_POST['cqtype']
 				);

 				if($relatedIPZillaBugIDs != "") {
 					$relatedIPZillaBugIDs .= ",";
 				}
 				$relatedIPZillaBugIDs .= $bug_id;


 				# Once it's done, make it depend on MasterIPZillaEntry->bug_id
 				$sql = "INSERT INTO dependencies
 							(blocked, dependson)
 						VALUES (
 							" . $MasterIPZillaEntry->bug_id . ",
 							" . $bug_id . "
 						)";
 				mysql_query($sql, $dbh);

 				$relatedPackages .= "        " . $_POST['pkgName' . $i] . "\n";
 				$relatedPackages .= "        -> " . $IPZillaHome . "/show_bug.cgi?id=" . $bug_id . "\n\n";

 				# Send the e-mail
 				$message = $SubmitterProfile->realname . " submitted a Contribution Questionnaire to IPZilla, with third party packages.\n\n";
 				$message .= $_POST['pkgName' . $i] . " Version: " . $_POST['pkgVersion' . $i] . "\n\n";

 				$message .= "    You can view the details at the following address:\n    " . $IPZillaHome . "/show_bug.cgi?id=" . $bug_id . "\n\n";

 				$message .= "    ** You're not done yet! **";
 				$message .= "    You need to attach the source code (not binary) to all packages in this contribution.\n\n";
 				$message .= "    If the file size is 20MB or less, log in to IPZilla (using your bugs.eclipse.org committer account) and use the attachment feature.\n";
 				$message .= "    If the file size exceeds 20MB, please use an SFTP or SCP client to transfer the file to the correct ipzilla subdirectory of dev.eclipse.org:/home/data/common/ip, according the the IP Bug number. Log into IPZilla and submit the file name in a comment.\n\n";
 				$message .= "    Once the source is attached or transferred, your PMC must approve this package by voting +1 to the IPZilla entry. The Eclipse IP team will NOT review your contribution until this is done.\n\n";

 				$message .= "-------------\nThe raw entry is as follows:\n\n" . $IPZillaEntry->comment0;

 				$watchlist = selectWatchlist($MasterIPZillaEntry->initialowner);
 				if(!is_numeric(array_search($ProjectLeadProfile->login_name, $watchlist))) {
 					$watchlist[count($watchlist)] = $ProjectLeadProfile->login_name;
 				}

 				# include the submitter
 				if(!is_numeric(array_search($SubmitterProfile->login_name, $watchlist))) {
 					$watchlist[count($watchlist)] = $SubmitterProfile->login_name;
 				}
 				foreach ($watchlist as $watcher) {
 					if(! $disablemail) {
 						mail($watcher, "[IPZilla CQ: " . $bug_id . "]: " . $_POST['pkgName' . $i] . " Version: " . $_POST['pkgVersion' . $i], $message, "From: IPZilla <emo-ip-team@eclipse.org>");
 					}
 				}
 			}
 		}

 		header("Location: cq_out.php?bug_ids=" . $relatedIPZillaBugIDs);

 	}

 	$dbc->disconnect();


 	class Profile {

 		var $userid;
 		var $realname;
 		var $login_name;
 		var $extern_id;


 		function selectProfileFromUserID($_userid) {
        		global $App;
 			global $dbc, $dbh;
 			global $_POST;

 			# get submitter bugzilla id
 			$sql = "SELECT
 						PRF.userid,
 						PRF.realname,
 						PRF.login_name,
 						PRF.extern_id
 					FROM profiles AS PRF
 					WHERE PRF.userid = " . $_userid;
 			$rs = mysql_query($sql,$dbh);
 			$row = mysql_fetch_assoc($rs);

 			$this->userid = $_userid;
 			$this->realname = $row['realname'];
 			$this->login_name = $row['login_name'];
 			$this->extern_id = $row['extern_id'];
 		}

 		function selectProfileFromEMail($_email) {
        		global $App;
 			global $dbc, $dbh;
 			global $_POST;

 			# get submitter bugzilla id
 			$sql = "SELECT
 						PRF.userid,
 						PRF.realname,
 						PRF.login_name,
 						PRF.extern_id
 					FROM profiles AS PRF
 					WHERE PRF.login_name = " . $App->returnQuotedString($_email);
 			$rs = mysql_query($sql,$dbh);
 			$row = mysql_fetch_assoc($rs);

 			$this->userid = $row['userid'];
 			$this->realname = $row['realname'];
 			$this->login_name = $row['login_name'];
 			$this->extern_id = $row['extern_id'];
 		}


 		function selectProfileFromExternID($_extern_id) {
        		global $App;
 			global $dbc, $dbh;
 			global $_POST;

 			# get submitter bugzilla id
 			$sql = "SELECT
 						PRF.userid,
 						PRF.realname,
 						PRF.login_name,
 						PRF.extern_id
 					FROM profiles AS PRF
 					WHERE PRF.extern_id = " . $App->returnQuotedString($_extern_id);
 			$rs = mysql_query($sql,$dbh);
 			$row = mysql_fetch_assoc($rs);

 			$this->userid = $row['userid'];
 			$this->realname = $row['realname'];
 			$this->login_name = $row['login_name'];
 			$this->extern_id = $row['extern_id'];
 		}
 	}


 	class IPZillaEntry {

 		var $bug_id			= 0;
 		var $reporter		= 0;
 		var $product_id 	= 0;
 		var $component_id	= 0;
 		var $initialowner	= 0;
 		var $component_name	= "";
 		var $short_desc		= "";
 		var $comment0		= "";

 		function insertEntry($_product_id, $_component_id, $_SubmitterProfile, $_short_desc, $_type, $_iteration, $_cqtype) {
        		global $App;
 			global $dbc, $dbh;
 			global $_POST;
 			global $ProjectLeadProfile;

 			$this->reporter		= $_SubmitterProfile->userid;
 			$this->product_id 	= $_product_id;
 			$this->component_id = $_component_id;
 			$this->short_desc	= $_short_desc;


 			# Get initial owner and name
 			$sql = "SELECT
 						CMP.initialowner,
 						CMP.name
 					FROM components AS CMP
 					WHERE CMP.id = " . $_component_id;
 			$rs 	= mysql_query($sql,$dbh);
 			$row 	= mysql_fetch_assoc($rs);
 			$this->initialowner 	= $row['initialowner'];
 			$this->component_name 	= $row['name'];

 			#if($_SubmitterProfile->userid == "" || $this->initialowner == "") {
 			#	die("Internal error - cannot get your IPZilla ID. Please contact webmaster@eclipse.org.");
 			#}

 			# To protect the integrity of the data, the reporter is obfuscated (with Bugzilla, the reporter can
 			# essentially change all the bugs)

 			$EMOProfile = new Profile();
 			$EMOProfile->selectProfileFromEMail("emo-ip-team@eclipse.org");

 			$sql = "INSERT INTO bugs (
 					bug_id,
 					assigned_to,
 					bug_severity,
 					bug_status,
 					creation_ts,
 					delta_ts,
 					lastdiffed,
 					short_desc,
 					op_sys,
 					priority,
 					product_id,
 					rep_platform,
 					reporter,
 					version,
 					everconfirmed,
 					component_id
 				)
 				VALUES (
 					NULL,
 					$this->initialowner,
 					'new',
 					'NEW',
 					NOW(),
 					NOW(),
 					NOW(),
 					" . $App->returnQuotedString($this->short_desc) . ",
 					'Windows',
 					'P3',
 					$this->product_id,
 					'PC',
 					'" . $EMOProfile->userid . "',
 					'unspecified',
 					1,
 					$this->component_id
 				);
 			";

 			mysql_query($sql, $dbh);
 			$this->bug_id = mysql_insert_id($dbh);

 			$this->comment0 = generateComment0($this, $_type, $_iteration);

 			# insert comment 0, which is a dump
 			$sql = "INSERT INTO longdescs (
 					bug_id,
 					who,
 					bug_when,
 					thetext
 					)
 					VALUES (
 					$this->bug_id,
 					" . $this->reporter . ",
 					NOW(),
 					" . $App->returnQuotedString($this->comment0) . "
 			)";
 			mysql_query($sql, $dbh);

 			# insert keywords
 			$keywordCache = "";
 			if($_POST['crypto'] == "yes") {
 				$this->addKeyword("cryptography");
 			}
 			if($_cqtype == "epl" || $_cqtype == "nonepl") {
 				$this->addKeyword($_cqtype);
 			}


 			# Add Reporter, PMC and EMO-IP-RECORDS@ as CC's to this bug
 			$sql = "INSERT INTO cc (bug_id, who)
 					SELECT " . $this->bug_id . ", userid FROM profiles
 							WHERE login_name ='emo-ip-team@eclipse.org'
 								OR userid = " . $this->reporter . "
 								OR userid = " . $ProjectLeadProfile->userid . "
 								OR userid = " . $this->initialowner;
 			mysql_query($sql, $dbh);

 			return $this->bug_id;
 		}

 		function addKeyword($_keyword){
 			global $dbc, $dbh;
 			global $_POST;

 			$sql = "SELECT id FROM keyworddefs WHERE name = '$_keyword'";
 			$rs = mysql_query($sql, $dbh);
 			$row = mysql_fetch_assoc($rs);
 			$keyword_id = $row['id'];

 			if($keyword_id != "" && $this->bug_id != "") {
 				$sql = "INSERT INTO keywords
 							(bug_id, keywordid)
 						VALUES (
 							" . $this->bug_id . ",
 							" . $keyword_id . ")";
 				mysql_query($sql, $dbh);
 			}

 			# rebuild Keyword Cache
 			$sql = "SELECT keywords.bug_id, keyworddefs.name " .
         			"FROM keywords " .
         			"INNER JOIN keyworddefs " .
         			"   ON keyworddefs.id = keywords.keywordid " .
         			" WHERE keywords.bug_id = " . $this->bug_id .
         			" ORDER BY keywords.bug_id, keyworddefs.name";

         	$str_kwc = "";
         	$rs_kwc	= mysql_query($sql,$dbh);

 			while($row_kwc 	= mysql_fetch_assoc($rs_kwc)) {
 				if($str_kwc != "") {
 					$str_kwc .= ", ";
 				}
 				$str_kwc .= $row_kwc['name'];
 			}

 			if($str_kwc != "") {
 				$sql = "UPDATE bugs SET keywords = '" . $str_kwc . "' WHERE bug_id = " . $this->bug_id;
 				mysql_query($sql,$dbh);
 			}

 		}

 		function selectEntry($_bug_id){
        		global $App;
 			global $dbc, $dbh;
 			global $_POST;

 			$this->bug_id = $_bug_id;

 			$sql = "SELECT
 					bug_id,
 					assigned_to,
 					bug_severity,
 					bug_status,
 					creation_ts,
 					delta_ts,
 					short_desc,
 					op_sys,
 					priority,
 					product_id,
 					rep_platform,
 					reporter,
 					version,
 					component_id
 					FROM bugs WHERE bug_id = " . $this->bug_id;
 			$rs = mysql_query($sql,$dbh);
 			$row = mysql_fetch_assoc($rs);
 			$this->reporter		= $row['reporter'];
 			$this->product_id 	= $row['product_id'];
 			$this->component_id = $row['component_id'];
 			$this->short_desc 	= $row['short_desc'];

 			# Get initial owner and name
 			$sql = "SELECT
 						CMP.initialowner,
 						CMP.name
 					FROM components AS CMP
 					WHERE CMP.id = " . $this->component_id;
 			$rs 	= mysql_query($sql,$dbh);
 			$row 	= mysql_fetch_assoc($rs);
 			$this->initialowner 	= $row['initialowner'];
 			$this->component_name 	= $row['name'];
 		}
 	}


 	function selectWatchlist($_initialowner) {
        	global $App;

 		global $dbc;
 		global $dbh;
 		global $_POST;

 		# get mail addresses for the watchlist for initialowner
 		$sql = "SELECT
 					PRF.login_name
 				FROM profiles AS PRF
 					INNER JOIN watch AS WAT ON WAT.watcher = PRF.userid
 				WHERE WAT.watched = $_initialowner";
 		$rs = mysql_query($sql,$dbh);
 		$watchlist = array();
 		while($row = mysql_fetch_assoc($rs)) {
 			$watchlist[count($watchlist)] = $row['login_name'];
 		}

 		# Add static entries here
 		$watchlist[count($watchlist)] = "mike.milinkovich@eclipse.org";
 		$watchlist[count($watchlist)] = "bjorn.freeman-benson@eclipse.org";

 		return $watchlist;
 	}

 	function generateComment0($_IPZillaEntry, $_type, $_iteration) {
        	global $App;

 		global $dbc;
 		global $dbh;
 		global $_POST;
 		global $SubmitterProfile, $CommitterProfile, $ProjectLeadProfile;
 		global $bug_id;
 		global $_cqtype;

 		if ($_type == "container") {
 			$mailStr = "

 Submitter:          " . $SubmitterProfile->realname . "  " . $SubmitterProfile->login_name . "
                     https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $SubmitterProfile->extern_id . "


 Committer:          " . $CommitterProfile->realname . "  " . $CommitterProfile->login_name . "
                     https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $CommitterProfile->extern_id . "


 To be Approved by

 PMC:                " . $ProjectLeadProfile->realname . " " . $ProjectLeadProfile->login_name . "
                     https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $ProjectLeadProfile->extern_id . "


 Contribution

 Project:            " .  $_IPZillaEntry->component_name . "
                     http://foundation.eclipse.org/projects/projects_edit.php?ProjectID=" . $_IPZillaEntry->component_name . "

 Component:          " . $_POST['component'] . "

 Name:               " . $_POST['contributionName'] . "
 Version:            " . $_POST['contributionVersion'] . "
 Size:               " . $_POST['contributionSize'] . "
 Description:        " . $_POST['contributionDescription'] . "

 Pre-existing Packages: " . $_POST['preExistPkgs'] . "

 Support Info:       " . $_POST['contributionSupportInfo'] . "

 Requirement is:     " . $_POST['requirement'];

 			if($_cqtype == "nonepl") {
 				$mailStr .= "
 Contributor

 Submitter wrote 100% of the code: " .  $_POST['allMyCode'] . "
 Name:               " . $_POST['contributorName'] . "
 Organization:       " . $_POST['contributorOrganization'] . "
 Phone:              " . $_POST['contributorPhone'] . "
 E-Mail:             " . $_POST['contributorEmail'] . "

 Contribution Percentage: " . $_POST['contributorPercentage'] . "
 Other Contributors: " . $_POST['otherContributors'];
 			}

 $mailStr .= "

 Cryptography involved: " .  $_POST['crypto'] . "
 Cryptography:       " . $_POST['cryptography'] . "
 Algorithm:          " . $_POST['cryptographyAlgorithm'] . "

 ";

 		}
 		else {

 			$committer = explode("|", $_POST['committer_id' . $_iteration]);

 			$mailStr = "
 Pre-existing Packages

 Package:                 " . $_POST['pkgName' . $_iteration] . "
 Version:                 " . $_POST['pkgVersion' . $_iteration] . "
 Source:                  " . $_POST['pkgSource' . $_iteration] . "

 License:                 " . $_POST['pkgLicense' . $_iteration] . "
 License Type:            " . $_POST['pkgLicenseType' . $_iteration] . "

 Other authors:           " . $_POST['otherAuthors' . $_iteration] . "

 Committer Name:          " . $committer[1] . "
                          https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $committer[0];
 		}
 	return $mailStr;

 	}

 ?>
	<?php

	require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_ipzilla_rw.class.php");
	require_once("/home/data/httpd/eclipse-php-classes/system/app.class.php");
	require_once("/home/data/httpd/eclipse-php-classes/people/ldapperson.class.php");
	require_once("/home/data/httpd/eclipse-php-classes/menu/menu.class.php");

	#*****************************************************************************
	#
	# cq_post.php
	#
	# Author: Denis Roy and others
	# Date: 2005-01-21
	#
	# Description: Process to store contribution questionnaires and e-mail EMO
	#
	# HISTORY:
	#
	#****************************************************************************


	$App = new App();
	$App->runStdWebAppCacheable();
	$ErrorMessage = "";

	$LDAPPerson = new LDAPPerson();
	$LDAPPerson = $LDAPPerson->redirectIfNotLoggedIn();

	$IPZillaHome = "https://dev.eclipse.org/ipzilla";
	$FoundationDBHome = "https://foundation.eclipse.org";

	$disablemail = false;

	# Connect to the IPZilla database
	$dbc = new DBConnectionIPZillaRW();
	$dbh = $dbc->connect();



	$MasterIPZillaEntry = new IPZillaEntry();

	$SubmitterProfile = new Profile();
	$SubmitterProfile->selectProfileFromExternID($LDAPPerson->getUid());

	if($_POST['c'] == "") {

	# new (Master) contribution for IPZilla

	# Split product\|component from the POST
	$pc = explode("\|", $_POST['component_id']);
	$product_id = $pc[0]; $component_id = $pc[1];

	$CommitterProfile = new Profile();
	$CommitterProfile->selectProfileFromUserID($_POST['committer_id']);

	$ProjectLeadProfile = new Profile();
	$ProjectLeadProfile->selectProfileFromUserID($_POST['projectlead_id']);

	$bug_id = $MasterIPZillaEntry->insertEntry(
	$product_id,
	$component_id,
	$SubmitterProfile,
	$_POST['contributionName'] . " Version: " . $_POST['contributionVersion'],
	"container",
	0,
	$_POST['cqtype']
	);

	# Create directory to hold attachments > 20MB
	mkdir("/home/data/common/ip/ipzilla-" . $bug_id, 0770);

	# Send e-mail

	$message = $SubmitterProfile->realname . " submitted a Contribution Questionnaire to IPZilla:\n\n";
	$message .= " " . $_POST['contributionName'] . " Version: " . $_POST['contributionVersion'] . "\n\n";
	$message .= " You can view the details at the following address:\n " . $IPZillaHome . "/show_bug.cgi?id=" . $bug_id . "\n\n";

	$message .= " You're not done yet! ";
	$message .= " You need to attach the source code (not binary) for all the packages in this contribution.\n\n";
	$message .= " If the file size is 20MB or less, log in to IPZilla (using your bugs.eclipse.org committer account) and use the attachment feature.\n";
	$message .= " If the file size exceeds 20MB, please use an SFTP or SCP client to transfer the file to the correct ipzilla subdirectory of dev.eclipse.org:/home/data/common/ip, according the the IP Bug number. Log into IPZilla and submit the file name in a comment.\n\n";
	$message .= " Once the source is attached or transferred, your PMC must approve this package by having one representative of the PMC vote +1 on the IPZilla entry. The Eclipse IP team will NOT review your contribution until this is done.\n\n";


	$message .= "-------------\nThe raw entry is as follows:\n\n" . $MasterIPZillaEntry->comment0;

	$watchlist = selectWatchlist($MasterIPZillaEntry->initialowner);

	# include PMC
	if(!is_numeric(array_search($ProjectLeadProfile->login_name, $watchlist))) {
	$watchlist[count($watchlist)] = $ProjectLeadProfile->login_name;
	}

	# include the submitter
	if(!is_numeric(array_search($SubmitterProfile->login_name, $watchlist))) {
	$watchlist[count($watchlist)] = $SubmitterProfile->login_name;
	}
	foreach ($watchlist as $watcher) {
	if(! $disablemail) {
	mail($watcher, "[IPZilla CQ: " . $bug_id . "]: " . $_POST['contributionName'] . " " . $_POST['contributionVersion'], $message, "From: IPZilla <emo-ip-team@eclipse.org>");
	}
	}
	# End: send e-mail


	if($_POST['preExistPkgList'] != "") {
	# count this and send as param: $_POST['preExistPkgList']
	setcookie("preExistPkgList", $_POST['preExistPkgList']);
	setcookie("bug_id", $bug_id);
	setcookie("projectlead_id", $_POST['projectlead_id']);
	header("Location: cq_part2.php?i=" . $bug_id);
	}
	else {
	header("Location: cq_out.php?bug_ids=" . $bug_id );
	}
	}
	else {


	# existing contribution
	# get number of packages and save this info.

	if($_POST['c'] != $_COOKIE['bug_id']) {
	die("An internal error has occurred. Your questionaire may not be complete. Please contact webmaster@eclipse.org.");
	}
	$MasterIPZillaEntry->selectEntry($_COOKIE['bug_id']);

	if($_POST['projectlead_id'] == "") {
	die("An internal error has occurred while attempting to locate the PMC record for this questionnaire. Your questionaire may not be complete. Please contact webmaster@eclipse.org.");
	}

	$ProjectLeadProfile = new Profile();
	$ProjectLeadProfile->selectProfileFromUserID($_POST['projectlead_id']);

	$preExistPkgList = $_COOKIE['preExistPkgList'];

	$pkgList = split("\n", $preExistPkgList);

	$relatedPackages = "";
	$relatedIPZillaBugIDs = "";

	for($i = 0; $i < count($pkgList); $i++) {
	if($pkgList[$i] != "") {

	$IPZillaEntry = new IPZillaEntry();
	$bug_id = $IPZillaEntry->insertEntry($MasterIPZillaEntry->product_id,
	$MasterIPZillaEntry->component_id,
	$SubmitterProfile,
	$_POST['pkgName' . $i] . " Version: " . $_POST['pkgVersion' . $i],
	"child",
	$i,
	$_POST['cqtype']
	);

	if($relatedIPZillaBugIDs != "") {
	$relatedIPZillaBugIDs .= ",";
	}
	$relatedIPZillaBugIDs .= $bug_id;


	# Once it's done, make it depend on MasterIPZillaEntry->bug_id
	$sql = "INSERT INTO dependencies
	(blocked, dependson)
	VALUES (
	" . $MasterIPZillaEntry->bug_id . ",
	" . $bug_id . "
	)";
	mysql_query($sql, $dbh);

	$relatedPackages .= " " . $_POST['pkgName' . $i] . "\n";
	$relatedPackages .= " -> " . $IPZillaHome . "/show_bug.cgi?id=" . $bug_id . "\n\n";

	# Send the e-mail
	$message = $SubmitterProfile->realname . " submitted a Contribution Questionnaire to IPZilla, with third party packages.\n\n";
	$message .= $_POST['pkgName' . $i] . " Version: " . $_POST['pkgVersion' . $i] . "\n\n";

	$message .= " You can view the details at the following address:\n " . $IPZillaHome . "/show_bug.cgi?id=" . $bug_id . "\n\n";

	$message .= " You're not done yet! ";
	$message .= " You need to attach the source code (not binary) to all packages in this contribution.\n\n";
	$message .= " If the file size is 20MB or less, log in to IPZilla (using your bugs.eclipse.org committer account) and use the attachment feature.\n";
	$message .= " If the file size exceeds 20MB, please use an SFTP or SCP client to transfer the file to the correct ipzilla subdirectory of dev.eclipse.org:/home/data/common/ip, according the the IP Bug number. Log into IPZilla and submit the file name in a comment.\n\n";
	$message .= " Once the source is attached or transferred, your PMC must approve this package by voting +1 to the IPZilla entry. The Eclipse IP team will NOT review your contribution until this is done.\n\n";

	$message .= "-------------\nThe raw entry is as follows:\n\n" . $IPZillaEntry->comment0;

	$watchlist = selectWatchlist($MasterIPZillaEntry->initialowner);
	if(!is_numeric(array_search($ProjectLeadProfile->login_name, $watchlist))) {
	$watchlist[count($watchlist)] = $ProjectLeadProfile->login_name;
	}

	# include the submitter
	if(!is_numeric(array_search($SubmitterProfile->login_name, $watchlist))) {
	$watchlist[count($watchlist)] = $SubmitterProfile->login_name;
	}
	foreach ($watchlist as $watcher) {
	if(! $disablemail) {
	mail($watcher, "[IPZilla CQ: " . $bug_id . "]: " . $_POST['pkgName' . $i] . " Version: " . $_POST['pkgVersion' . $i], $message, "From: IPZilla <emo-ip-team@eclipse.org>");
	}
	}
	}
	}

	header("Location: cq_out.php?bug_ids=" . $relatedIPZillaBugIDs);

	}

	$dbc->disconnect();


	class Profile {

	var $userid;
	var $realname;
	var $login_name;
	var $extern_id;


	function selectProfileFromUserID($_userid) {
	global $App;
	global $dbc, $dbh;
	global $_POST;

	# get submitter bugzilla id
	$sql = "SELECT
	PRF.userid,
	PRF.realname,
	PRF.login_name,
	PRF.extern_id
	FROM profiles AS PRF
	WHERE PRF.userid = " . $_userid;
	$rs = mysql_query($sql,$dbh);
	$row = mysql_fetch_assoc($rs);

	$this->userid = $_userid;
	$this->realname = $row['realname'];
	$this->login_name = $row['login_name'];
	$this->extern_id = $row['extern_id'];
	}

	function selectProfileFromEMail($_email) {
	global $App;
	global $dbc, $dbh;
	global $_POST;

	# get submitter bugzilla id
	$sql = "SELECT
	PRF.userid,
	PRF.realname,
	PRF.login_name,
	PRF.extern_id
	FROM profiles AS PRF
	WHERE PRF.login_name = " . $App->returnQuotedString($_email);
	$rs = mysql_query($sql,$dbh);
	$row = mysql_fetch_assoc($rs);

	$this->userid = $row['userid'];
	$this->realname = $row['realname'];
	$this->login_name = $row['login_name'];
	$this->extern_id = $row['extern_id'];
	}


	function selectProfileFromExternID($_extern_id) {
	global $App;
	global $dbc, $dbh;
	global $_POST;

	# get submitter bugzilla id
	$sql = "SELECT
	PRF.userid,
	PRF.realname,
	PRF.login_name,
	PRF.extern_id
	FROM profiles AS PRF
	WHERE PRF.extern_id = " . $App->returnQuotedString($_extern_id);
	$rs = mysql_query($sql,$dbh);
	$row = mysql_fetch_assoc($rs);

	$this->userid = $row['userid'];
	$this->realname = $row['realname'];
	$this->login_name = $row['login_name'];
	$this->extern_id = $row['extern_id'];
	}
	}





	class IPZillaEntry {

	var $bug_id = 0;
	var $reporter = 0;
	var $product_id = 0;
	var $component_id = 0;
	var $initialowner = 0;
	var $component_name = "";
	var $short_desc = "";
	var $comment0 = "";

	function insertEntry($_product_id, $_component_id, $_SubmitterProfile, $_short_desc, $_type, $_iteration, $_cqtype) {
	global $App;
	global $dbc, $dbh;
	global $_POST;
	global $ProjectLeadProfile;

	$this->reporter = $_SubmitterProfile->userid;
	$this->product_id = $_product_id;
	$this->component_id = $_component_id;
	$this->short_desc = $_short_desc;


	# Get initial owner and name
	$sql = "SELECT
	CMP.initialowner,
	CMP.name
	FROM components AS CMP
	WHERE CMP.id = " . $_component_id;
	$rs = mysql_query($sql,$dbh);
	$row = mysql_fetch_assoc($rs);
	$this->initialowner = $row['initialowner'];
	$this->component_name = $row['name'];

	#if($_SubmitterProfile->userid == "" \|\| $this->initialowner == "") {
	# die("Internal error - cannot get your IPZilla ID. Please contact webmaster@eclipse.org.");
	#}

	# To protect the integrity of the data, the reporter is obfuscated (with Bugzilla, the reporter can
	# essentially change all the bugs)

	$EMOProfile = new Profile();
	$EMOProfile->selectProfileFromEMail("emo-ip-team@eclipse.org");

	$sql = "INSERT INTO bugs (
	bug_id,
	assigned_to,
	bug_severity,
	bug_status,
	creation_ts,
	delta_ts,
	lastdiffed,
	short_desc,
	op_sys,
	priority,
	product_id,
	rep_platform,
	reporter,
	version,
	everconfirmed,
	component_id
	)
	VALUES (
	NULL,
	$this->initialowner,
	'new',
	'NEW',
	NOW(),
	NOW(),
	NOW(),
	" . $App->returnQuotedString($this->short_desc) . ",
	'Windows',
	'P3',
	$this->product_id,
	'PC',
	'" . $EMOProfile->userid . "',
	'unspecified',
	1,
	$this->component_id
	);
	";

	mysql_query($sql, $dbh);
	$this->bug_id = mysql_insert_id($dbh);

	$this->comment0 = generateComment0($this, $_type, $_iteration);

	# insert comment 0, which is a dump
	$sql = "INSERT INTO longdescs (
	bug_id,
	who,
	bug_when,
	thetext
	)
	VALUES (
	$this->bug_id,
	" . $this->reporter . ",
	NOW(),
	" . $App->returnQuotedString($this->comment0) . "
	)";
	mysql_query($sql, $dbh);

	# insert keywords
	$keywordCache = "";
	if($_POST['crypto'] == "yes") {
	$this->addKeyword("cryptography");
	}
	if($_cqtype == "epl" \|\| $_cqtype == "nonepl") {
	$this->addKeyword($_cqtype);
	}



	# Add Reporter, PMC and EMO-IP-RECORDS@ as CC's to this bug
	$sql = "INSERT INTO cc (bug_id, who)
	SELECT " . $this->bug_id . ", userid FROM profiles
	WHERE login_name ='emo-ip-team@eclipse.org'
	OR userid = " . $this->reporter . "
	OR userid = " . $ProjectLeadProfile->userid . "
	OR userid = " . $this->initialowner;
	mysql_query($sql, $dbh);

	return $this->bug_id;
	}

	function addKeyword($_keyword){
	global $dbc, $dbh;
	global $_POST;

	$sql = "SELECT id FROM keyworddefs WHERE name = '$_keyword'";
	$rs = mysql_query($sql, $dbh);
	$row = mysql_fetch_assoc($rs);
	$keyword_id = $row['id'];

	if($keyword_id != "" && $this->bug_id != "") {
	$sql = "INSERT INTO keywords
	(bug_id, keywordid)
	VALUES (
	" . $this->bug_id . ",
	" . $keyword_id . ")";
	mysql_query($sql, $dbh);
	}

	# rebuild Keyword Cache
	$sql = "SELECT keywords.bug_id, keyworddefs.name " .
	"FROM keywords " .
	"INNER JOIN keyworddefs " .
	" ON keyworddefs.id = keywords.keywordid " .
	" WHERE keywords.bug_id = " . $this->bug_id .
	" ORDER BY keywords.bug_id, keyworddefs.name";

	$str_kwc = "";
	$rs_kwc = mysql_query($sql,$dbh);

	while($row_kwc = mysql_fetch_assoc($rs_kwc)) {
	if($str_kwc != "") {
	$str_kwc .= ", ";
	}
	$str_kwc .= $row_kwc['name'];
	}

	if($str_kwc != "") {
	$sql = "UPDATE bugs SET keywords = '" . $str_kwc . "' WHERE bug_id = " . $this->bug_id;
	mysql_query($sql,$dbh);
	}

	}

	function selectEntry($_bug_id){
	global $App;
	global $dbc, $dbh;
	global $_POST;

	$this->bug_id = $_bug_id;

	$sql = "SELECT
	bug_id,
	assigned_to,
	bug_severity,
	bug_status,
	creation_ts,
	delta_ts,
	short_desc,
	op_sys,
	priority,
	product_id,
	rep_platform,
	reporter,
	version,
	component_id
	FROM bugs WHERE bug_id = " . $this->bug_id;
	$rs = mysql_query($sql,$dbh);
	$row = mysql_fetch_assoc($rs);
	$this->reporter = $row['reporter'];
	$this->product_id = $row['product_id'];
	$this->component_id = $row['component_id'];
	$this->short_desc = $row['short_desc'];

	# Get initial owner and name
	$sql = "SELECT
	CMP.initialowner,
	CMP.name
	FROM components AS CMP
	WHERE CMP.id = " . $this->component_id;
	$rs = mysql_query($sql,$dbh);
	$row = mysql_fetch_assoc($rs);
	$this->initialowner = $row['initialowner'];
	$this->component_name = $row['name'];
	}
	}


	function selectWatchlist($_initialowner) {
	global $App;

	global $dbc;
	global $dbh;
	global $_POST;

	# get mail addresses for the watchlist for initialowner
	$sql = "SELECT
	PRF.login_name
	FROM profiles AS PRF
	INNER JOIN watch AS WAT ON WAT.watcher = PRF.userid
	WHERE WAT.watched = $_initialowner";
	$rs = mysql_query($sql,$dbh);
	$watchlist = array();
	while($row = mysql_fetch_assoc($rs)) {
	$watchlist[count($watchlist)] = $row['login_name'];
	}

	# Add static entries here
	$watchlist[count($watchlist)] = "mike.milinkovich@eclipse.org";
	$watchlist[count($watchlist)] = "bjorn.freeman-benson@eclipse.org";

	return $watchlist;
	}

	function generateComment0($_IPZillaEntry, $_type, $_iteration) {
	global $App;

	global $dbc;
	global $dbh;
	global $_POST;
	global $SubmitterProfile, $CommitterProfile, $ProjectLeadProfile;
	global $bug_id;
	global $_cqtype;

	if ($_type == "container") {
	$mailStr = "

	Submitter: " . $SubmitterProfile->realname . " " . $SubmitterProfile->login_name . "
	https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $SubmitterProfile->extern_id . "


	Committer: " . $CommitterProfile->realname . " " . $CommitterProfile->login_name . "
	https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $CommitterProfile->extern_id . "


	To be Approved by

	PMC: " . $ProjectLeadProfile->realname . " " . $ProjectLeadProfile->login_name . "
	https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $ProjectLeadProfile->extern_id . "


	Contribution

	Project: " . $_IPZillaEntry->component_name . "
	http://foundation.eclipse.org/projects/projects_edit.php?ProjectID=" . $_IPZillaEntry->component_name . "

	Component: " . $_POST['component'] . "

	Name: " . $_POST['contributionName'] . "
	Version: " . $_POST['contributionVersion'] . "
	Size: " . $_POST['contributionSize'] . "
	Description: " . $_POST['contributionDescription'] . "

	Pre-existing Packages: " . $_POST['preExistPkgs'] . "

	Support Info: " . $_POST['contributionSupportInfo'] . "

	Requirement is: " . $_POST['requirement'];

	if($_cqtype == "nonepl") {
	$mailStr .= "
	Contributor

	Submitter wrote 100% of the code: " . $_POST['allMyCode'] . "
	Name: " . $_POST['contributorName'] . "
	Organization: " . $_POST['contributorOrganization'] . "
	Phone: " . $_POST['contributorPhone'] . "
	E-Mail: " . $_POST['contributorEmail'] . "

	Contribution Percentage: " . $_POST['contributorPercentage'] . "
	Other Contributors: " . $_POST['otherContributors'];
	}

	$mailStr .= "

	Cryptography involved: " . $_POST['crypto'] . "
	Cryptography: " . $_POST['cryptography'] . "
	Algorithm: " . $_POST['cryptographyAlgorithm'] . "

	";

	}
	else {

	$committer = explode("\|", $_POST['committer_id' . $_iteration]);

	$mailStr = "
	Pre-existing Packages

	Package: " . $_POST['pkgName' . $_iteration] . "
	Version: " . $_POST['pkgVersion' . $_iteration] . "
	Source: " . $_POST['pkgSource' . $_iteration] . "

	License: " . $_POST['pkgLicense' . $_iteration] . "
	License Type: " . $_POST['pkgLicenseType' . $_iteration] . "

	Other authors: " . $_POST['otherAuthors' . $_iteration] . "

	Committer Name: " . $committer[1] . "
	https://foundation.eclipse.org/people/people_edit.php?PersonID=" . $committer[0];
	}
	return $mailStr;

	}

	?>