Attachment #77503 for bug #201946

Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

View | Details | Raw Unified | Return to bug 201946
Collapse All | Expand All




<style>
a.info{
    position:relative; /*this is the key*/
    z-index:24;
    text-decoration:none}

a.info:hover{z-index:25; background-color:#ccc}


<?php /* ------------------ R E V I E W S -------------------- */ ?>
<div class="homeitem3col">
<h3><a href="/projects/reviews-rss.php"><img src="images/rss.gif" align="right"
        border="0"></a>Project Reviews</h3>
<div align="center" style="margin-top: 10px;">
<?php include("fragments/processes-page-table.php") ?>

</tr>
</table>
<p>Reviews are held on a conference call. Members and committers are directed to the
      <a href="http://portal.eclipse.org/"> MyFoundation portal </a>for the call-in information. If you do not have access to the
      portal, send <a href="mailto:emo@eclipse.org?Subject=Review Call Information">email to EMO</a> to request the call information.</p>
</div><!-- homeitem3col -->


	while( $row = mysql_fetch_assoc($result) ) {
		// ---- Exclude internal and archived projects ----
		if( !$row['IsActive'] ) continue;
		if( $row['ProjectID'] == "foundation-internal"
		 || $row['ParentProjectID'] == 'foundation-internal' ) continue;
		if( $row['ProjectPhase'] == 'Archive'
		 || strpos( $row['Name'], "[archived]")

		if( $row['Level'] == 0 ) continue;
		$border = '';
		if( $row['Level'] == 1 ) $border = ' style="border-top: 2px solid #444;"';

		// ---- Project name and Home page ----
		$spacer = '';
		if( $row['Level'] == 2 ) $spacer = '&nbsp;&nbsp;&nbsp;&nbsp;';
		?><tr><td <?= $border ?>><?= $spacer ?> <a href="<?= $row['UrlIndex'] ?>"><?= $row['Name'] ?></a><?php
		?></td><?php

		// ---- Phase ----
		if( $row['ProjectPhase'] == 'Regular' ) {
			?><td <?= $border ?>><a href="explain/projects-table-phase.php"><img src="/projects/images/ok.gif" align="middle" border="0"></a></td><?php

		} else {
			?><td <?= $border ?>>&nbsp;</td><?php
		}

		// ---- CONNECT TO ProjectInfo ----
		require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_projectinfo_ro.class.php");
		$_dbcpi = new DBConnectionProjectInfo();
		$_dbhpi = $_dbcpi->connect();

			{
				if(eregi("eclipse.org", $url))
				{
					$sites = array("http://eclipse.org", "http://www.eclipse.org");
					$oldurl = $url;
					$url = str_replace($sites, $_SERVER['DOCUMENT_ROOT'], $url);		
				}
			}
			$buffer = @file_get_contents( $url );
			if( $buffer ) {
				try {
					$xml = @new SimpleXMLElement($buffer);
				} catch( Exception $x ) {
					$xml = null;
				}
			}
		}
		
		// ---- Newsgroup ----
		$newsurl = getProjInfValue($row['ProjectID'], 'newsgroup', 'name', $_dbhpi);
		if($newsurl !== NULL) {
			if(!preg_match('/www.eclipse.org/', $mailurl)) {
				$newsurl = 'http://www.eclipse.org/newsportal/thread.php?group=' . $newsurl;
			if( $t2 ) {
				$newsurl = $t2['url'];
			}
			if( !$newsurl ) {
				$t3 = $t2->newsgroup[0];
				if( $t3 ) {
					# $newsurl = 'http://dev.eclipse.org/newslists/news.' . $t3['name'] . '/maillist.html';
					$newsurl = 'http://www.eclipse.org/newsportal/thread.php?group=' . $t3['name'];
				}
			}
		}
		if( $newsurl && $newsurl != '' ) {
			?><td <?= $border ?>><a href="<?= $newsurl ?>"><img src="/home/categories/images/newsgroups.gif" border="0"></a></td><?php
		} else {
			?><td <?= $border ?>>&nbsp;</td><?php
		}


		// ---- Mailing List ----
		$mailurl = getProjInfValue($row['ProjectID'], 'mailinglist', 'name', $_dbhpi);
		if($mailurl !== NULL) {
			if(!preg_match('/dev.eclipse.org/', $mailurl)) {
				$mailurl = 'https://dev.eclipse.org/mailman/listinfo/' . $mailurl;
			if( $t2 ) {
				$mailurl = $t2['url'];
			}
			if( !$mailurl ) {
				$t3 = $t2->list[0];
				if( $t3 ) {
					$mailurl = 'https://dev.eclipse.org/mailman/listinfo/' . $t3['name'];
				}
			}
		}
		if( $mailurl && $mailurl != '' ) {
			?><td <?= $border ?>><a href="<?= $mailurl ?>"><img src="/home/categories/images/mailinglist.gif" border="0"></a></td><?php
		} else {
			?><td <?= $border ?>>&nbsp;</td><?php
		}


		// ---- Wiki ----
		$wikiurl = getProjInfValue($row['ProjectID'], 'wikiurl', NULL, $_dbhpi);
		if($wikiurl !== NULL) {
			if(!preg_match('/wiki.eclipse.org/', $wikiurl)) {
				$wikiurl = "http://wiki.eclipse.org/$wikiurl";
				$wikiurl = $t2['url'];
			}
		}
		if( $wikiurl && $wikiurl != '' ) {
			?><td <?= $border ?>><a href="<?= $wikiurl ?>"><img src="/home/categories/images/wiki.gif" border="0"></a></td><?php
		} else {
			?><td <?= $border ?>>&nbsp;</td><?php
		}


		// ---- IP Log ----
		$logurl = getProjInfValue($row['ProjectID'], 'iplogurl', NULL, $_dbhpi);
		if($logurl !== NULL) {
			$t1 = 'ip-log';
			$t2 = $xml->$t1;
			if( $t2 ) {
				$logurl = $t2['url'];
			}
		}
		if( $logurl && $logurl != '' ) {
			?><td <?= $border ?>><a href="<?= $logurl ?>"><img src="/home/categories/images/docs.gif" border="0"></a></td><?php
		} else {
			?><td <?= $border ?>>&nbsp;</td><?php
		}

		// ---- Downloads ----
		$downloadsurl = getProjInfValue($row['ProjectID'], 'downloadsurl', NULL, $_dbhpi);
		if($downloadsurl !== NULL) {
			?><td <?= $border ?>><a href="<?= $downloadsurl ?>"><img border="0" src="/home/categories/images/download.gif"></a></td><?php
		} else {
			?><td <?= $border ?>>&nbsp;</td><?php
		}


</div><!-- maincontent -->
<?php
	# Paste your HTML content between the EOHTML markers!
	$html = ob_get_contents();
	ob_end_clean();

	# Generate the web page
	$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);

# Return the requested ProjectInfoValue
function getProjInfValue($ProjectID, $MainKey, $SubKey, $dbh) {
		if($SubKey != NULL) {
			$SubKey = "AND SubKey = '$SubKey'";
		}
		$query = "SELECT Value FROM ProjectInfo as PI, ProjectInfoValues as PIV " .
			"WHERE PI.ProjectInfoID = PIV.ProjectInfoID " .
			"AND MainKey = '$MainKey' $SubKey " .
			"AND ProjectID = '$ProjectID'";
		$result = mysql_query($query, $dbh);
		$row = mysql_fetch_assoc($result);

		return $row['Value'];
}
?>

Return to bug 201946

Lines 14-20 Link Here

(-)index.php (-78 / +48 lines)
14	<style>	14	<style>
15	a.info{	15	a.info{
16	position:relative; /this is the key/	16	position:relative; /this is the key/
17	z-index:24;	17	z-index:24;
18	text-decoration:none}	18	text-decoration:none}
19		19
20	a.info:hover{z-index:25; background-color:#ccc}	20	a.info:hover{z-index:25; background-color:#ccc}
Lines 34-40 Link Here
34		34
35	<?php /* ------------------ R E V I E W S -------------------- */ ?>	35	<?php /* ------------------ R E V I E W S -------------------- */ ?>
36	<div class="homeitem3col">	36	<div class="homeitem3col">
37	<h3><a href="/projects/reviews-rss.php"><img src="images/rss.gif" align="right"	37	<h3><a href="/projects/reviews-rss.php"><img src="images/rss.gif" align="right"
38	border="0"></a>Project Reviews</h3>	38	border="0"></a>Project Reviews</h3>
39	<div align="center" style="margin-top: 10px;">	39	<div align="center" style="margin-top: 10px;">
40	<?php include("fragments/processes-page-table.php") ?>	40	<?php include("fragments/processes-page-table.php") ?>
Lines 45-51 Link Here
45	</tr>	45	</tr>
46	</table>	46	</table>
47	<p>Reviews are held on a conference call. Members and committers are directed to the	47	<p>Reviews are held on a conference call. Members and committers are directed to the
48	<a href="http://portal.eclipse.org/"> MyFoundation portal </a>for the call-in information. If you do not have access to the	48	<a href="http://portal.eclipse.org/"> MyFoundation portal </a>for the call-in information. If you do not have access to the
49	portal, send <a href="mailto:emo@eclipse.org?Subject=Review Call Information">email to EMO</a> to request the call information.</p>	49	portal, send <a href="mailto:emo@eclipse.org?Subject=Review Call Information">email to EMO</a> to request the call information.</p>
50	</div><!-- homeitem3col -->	50	</div><!-- homeitem3col -->
51		51
Lines 74-80 Link Here
74	while( $row = mysql_fetch_assoc($result) ) {	74	while( $row = mysql_fetch_assoc($result) ) {
75	// ---- Exclude internal and archived projects ----	75	// ---- Exclude internal and archived projects ----
76	if( !$row['IsActive'] ) continue;	76	if( !$row['IsActive'] ) continue;
77	if( $row['ProjectID'] == "foundation-internal"	77	if( $row['ProjectID'] == "foundation-internal"
78	\|\| $row['ParentProjectID'] == 'foundation-internal' ) continue;	78	\|\| $row['ParentProjectID'] == 'foundation-internal' ) continue;
79	if( $row['ProjectPhase'] == 'Archive'	79	if( $row['ProjectPhase'] == 'Archive'
80	\|\| strpos( $row['Name'], "[archived]")	80	\|\| strpos( $row['Name'], "[archived]")
Lines 82-94 Link Here
82	if( $row['Level'] == 0 ) continue;	82	if( $row['Level'] == 0 ) continue;
83	$border = '';	83	$border = '';
84	if( $row['Level'] == 1 ) $border = ' style="border-top: 2px solid #444;"';	84	if( $row['Level'] == 1 ) $border = ' style="border-top: 2px solid #444;"';
85		85
86	// ---- Project name and Home page ----	86	// ---- Project name and Home page ----
87	$spacer = '';	87	$spacer = '';
88	if( $row['Level'] == 2 ) $spacer = '    ';	88	if( $row['Level'] == 2 ) $spacer = '    ';
89	?><tr><td <?= $border ?>><?= $spacer ?> <a href="<?= $row['UrlIndex'] ?>"><?= $row['Name'] ?></a><?php	89	?><tr><td <?= $border ?>><?= $spacer ?> <a href="<?= $row['UrlIndex'] ?>"><?= $row['Name'] ?></a><?php
90	?></td><?php	90	?></td><?php
91		91
92	// ---- Phase ----	92	// ---- Phase ----
93	if( $row['ProjectPhase'] == 'Regular' ) {	93	if( $row['ProjectPhase'] == 'Regular' ) {
94	?><td <?= $border ?>><a href="explain/projects-table-phase.php"><img src="/projects/images/ok.gif" align="middle" border="0"></a></td><?php	94	?><td <?= $border ?>><a href="explain/projects-table-phase.php"><img src="/projects/images/ok.gif" align="middle" border="0"></a></td><?php
Lines 99-203 Link Here
99	} else {	99	} else {
100	?><td <?= $border ?>> </td><?php	100	?><td <?= $border ?>> </td><?php
101	}	101	}
102		102
103	$xml = null;	103	// ---- CONNECT TO ProjectInfo ----
104	if( $row['UrlIndex'] ) {	104	require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_projectinfo_ro.class.php");
105	$url = $row['UrlIndex'] . "/project-info/project-info.xml";	105	$_dbcpi = new DBConnectionProjectInfo();
106	/* if on eclipse */	106	$_dbhpi = $_dbcpi->connect();
107	if(eregi("eclipse.org", $_SERVER['SERVER_NAME']))	107
108	{
109	if(eregi("eclipse.org", $url))
110	{
111	$sites = array("http://eclipse.org", "http://www.eclipse.org");
112	$oldurl = $url;
113	$url = str_replace($sites, $_SERVER['DOCUMENT_ROOT'], $url);
114	}
115	}
116	$buffer = @file_get_contents( $url );
117	if( $buffer ) {
118	try {
119	$xml = @new SimpleXMLElement($buffer);
120	} catch( Exception $x ) {
121	$xml = null;
122	}
123	}
124	}
125
126	// ---- Newsgroup ----	108	// ---- Newsgroup ----
127	$newsurl = '';	109	$newsurl = getProjInfValue($row['ProjectID'], 'newsgroup', 'name', $_dbhpi);
128	if( $xml ) {	110	if($newsurl !== NULL) {
129	$t1 = 'newsgroups';	111	if(!preg_match('/www.eclipse.org/', $mailurl)) {
130	$t2 = $xml->$t1;	112	$newsurl = 'http://www.eclipse.org/newsportal/thread.php?group=' . $newsurl;
131	if( $t2 ) {
132	$newsurl = $t2['url'];
133	}
134	if( !$newsurl ) {
135	$t3 = $t2->newsgroup[0];
136	if( $t3 ) {
137	# $newsurl = 'http://dev.eclipse.org/newslists/news.' . $t3['name'] . '/maillist.html';
138	$newsurl = 'http://www.eclipse.org/newsportal/thread.php?group=' . $t3['name'];
139	}
140	}	113	}
141	}
142	if( $newsurl && $newsurl != '' ) {
143	?><td <?= $border ?>><a href="<?= $newsurl ?>"><img src="/home/categories/images/newsgroups.gif" border="0"></a></td><?php	114	?><td <?= $border ?>><a href="<?= $newsurl ?>"><img src="/home/categories/images/newsgroups.gif" border="0"></a></td><?php
144	} else {	115	} else {
145	?><td <?= $border ?>> </td><?php	116	?><td <?= $border ?>> </td><?php
146	}	117	}
147		118
		119
148	// ---- Mailing List ----	120	// ---- Mailing List ----
149	$mailurl = '';	121	$mailurl = getProjInfValue($row['ProjectID'], 'mailinglist', 'name', $_dbhpi);
150	if( $xml ) {	122	if($mailurl !== NULL) {
151	$t1 = 'mailing-lists';	123	if(!preg_match('/dev.eclipse.org/', $mailurl)) {
152	$t2 = $xml->$t1;	124	$mailurl = 'https://dev.eclipse.org/mailman/listinfo/' . $mailurl;
153	if( $t2 ) {
154	$mailurl = $t2['url'];
155	}	125	}
156	if( !$mailurl ) {
157	$t3 = $t2->list[0];
158	if( $t3 ) {
159	$mailurl = 'https://dev.eclipse.org/mailman/listinfo/' . $t3['name'];
160	}
161	}
162	}
163	if( $mailurl && $mailurl != '' ) {
164	?><td <?= $border ?>><a href="<?= $mailurl ?>"><img src="/home/categories/images/mailinglist.gif" border="0"></a></td><?php	126	?><td <?= $border ?>><a href="<?= $mailurl ?>"><img src="/home/categories/images/mailinglist.gif" border="0"></a></td><?php
165	} else {	127	} else {
166	?><td <?= $border ?>> </td><?php	128	?><td <?= $border ?>> </td><?php
167	}	129	}
168		130
		131
169	// ---- Wiki ----	132	// ---- Wiki ----
170	$wikiurl = '';	133	$wikiurl = getProjInfValue($row['ProjectID'], 'wikiurl', NULL, $_dbhpi);
171	if( $xml ) {	134	if($wikiurl !== NULL) {
172	$t2 = $xml->wiki;	135	if(!preg_match('/wiki.eclipse.org/', $wikiurl)) {
173	if( $t2 ) {	136	$wikiurl = "http://wiki.eclipse.org/$wikiurl";
174	$wikiurl = $t2['url'];
175	}	137	}
176	}
177	if( $wikiurl && $wikiurl != '' ) {
178	?><td <?= $border ?>><a href="<?= $wikiurl ?>"><img src="/home/categories/images/wiki.gif" border="0"></a></td><?php	138	?><td <?= $border ?>><a href="<?= $wikiurl ?>"><img src="/home/categories/images/wiki.gif" border="0"></a></td><?php
179	} else {	139	} else {
180	?><td <?= $border ?>> </td><?php	140	?><td <?= $border ?>> </td><?php
181	}	141	}
182		142
		143
183	// ---- IP Log ----	144	// ---- IP Log ----
184	$logurl = '';	145	$logurl = getProjInfValue($row['ProjectID'], 'iplogurl', NULL, $_dbhpi);
185	if( $xml ) {	146	if($logurl !== NULL) {
186	$t1 = 'ip-log';
187	$t2 = $xml->$t1;
188	if( $t2 ) {
189	$logurl = $t2['url'];
190	}
191	}
192	if( $logurl && $logurl != '' ) {
193	?><td <?= $border ?>><a href="<?= $logurl ?>"><img src="/home/categories/images/docs.gif" border="0"></a></td><?php	147	?><td <?= $border ?>><a href="<?= $logurl ?>"><img src="/home/categories/images/docs.gif" border="0"></a></td><?php
194	} else {	148	} else {
195	?><td <?= $border ?>> </td><?php	149	?><td <?= $border ?>> </td><?php
196	}	150	}
197		151
198	// ---- Downloads ----	152	// ---- Downloads ----
199	if( $row['UrlDownload'] ) {	153	$downloadsurl = getProjInfValue($row['ProjectID'], 'downloadsurl', NULL, $_dbhpi);
200	?><td <?= $border ?>><a href="<?= $row['UrlDownload'] ?>"><img border="0" src="/home/categories/images/download.gif"></a></td><?php	154	if($downloadsurl !== NULL) {
		155	?><td <?= $border ?>><a href="<?= $downloadsurl ?>"><img border="0" src="/home/categories/images/download.gif"></a></td><?php
201	} else {	156	} else {
202	?><td <?= $border ?>> </td><?php	157	?><td <?= $border ?>> </td><?php
203	}	158	}
Lines 244-253 Link Here
244		199
245	</div><!-- maincontent -->	200	</div><!-- maincontent -->
246	<?php	201	<?php
247	# Paste your HTML content between the EOHTML markers!	202	# Paste your HTML content between the EOHTML markers!
248	$html = ob_get_contents();	203	$html = ob_get_contents();
249	ob_end_clean();	204	ob_end_clean();
250		205
251	# Generate the web page	206	# Generate the web page
252	$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);	207	$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);
		208
		209	# Return the requested ProjectInfoValue
		210	function getProjInfValue($ProjectID, $MainKey, $SubKey, $dbh) {
		211	if($SubKey != NULL) {
		212	$SubKey = "AND SubKey = '$SubKey'";
		213	}
		214	$query = "SELECT Value FROM ProjectInfo as PI, ProjectInfoValues as PIV " .
		215	"WHERE PI.ProjectInfoID = PIV.ProjectInfoID " .
		216	"AND MainKey = '$MainKey' $SubKey " .
		217	"AND ProjectID = '$ProjectID'";
		218	$result = mysql_query($query, $dbh);
		219	$row = mysql_fetch_assoc($result);
		220
		221	return $row['Value'];
		222	}
253	?>	223	?>