diff options
| author | Robert Treat | 2003-05-30 22:22:40 +0000 |
|---|---|---|
| committer | Robert Treat | 2003-05-30 22:22:40 +0000 |
| commit | cf6068f418fd97e9bb0d3d58ff8d9e1a9df567b7 (patch) | |
| tree | dcbc532619e47134186172efde5ed2e37ba5fe82 | |
initial import of advocacy code merging all the directories into one packageadvocacy
git-svn-id: file:///Users/dpage/pgweb/svn-repo/branches/a1@61 8f5c7a92-453e-0410-a47f-ad33c8a6b003
95 files changed, 5030 insertions, 0 deletions
diff --git a/advocacy/about/index.php b/advocacy/about/index.php new file mode 100644 index 00000000..0ce528b2 --- /dev/null +++ b/advocacy/about/index.php @@ -0,0 +1,192 @@ +<?php include_once("../shared/global.php"); +include_once("../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($abouttxtarray) == FALSE) +{ + $abouttxtarray = get_page_text('about', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/snow001top.jpg" width="600" height="80" border="0"></td> +</tr></table></td></tr></table></td></tr> +<tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<br> +<div align="center"><b><font size="+1"><?php echo rawurldecode($abouttxtarray['aboutus']) ?></font></b></div> +<ul> +<li><font size="-1"><?php echo rawurldecode($abouttxtarray['ashort']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($abouttxtarray['indivmemb']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($abouttxtarray['reccorp']) ?></font></li> +</ul> +<br> +<div align="center"><a name="history"></a><strong><?php echo rawurldecode($abouttxtarray['history']) ?></strong></div> +<br> +<font size="-1"><?php echo rawurldecode($abouttxtarray['thepgdg']) ?><br> +<br> +<?php echo rawurldecode($abouttxtarray['pgitself']) ?></font><br> +<br> +<br> +<div align="center"><img src="/images/gif/aboutmap.gif" width="482" height="242"><br> +<br> +<a name="individuals"></a><strong><?php echo rawurldecode($abouttxtarray['members']) ?></strong></div> +<br> +<table width="90%" border="0" align="center" cellpadding="10" cellspacing="0"> +<tr> +<td width="50%" align="left" valign="top"><font size="-1"><u><?php echo rawurldecode($abouttxtarray['steering']) ?></u><br> +<br> +Marc Fournier<br> +Tom Lane<br> +Vadim Mikheev<br> +Bruce Momjian<br> +Jan Wieck</font> +<font size="-1"><br> +<br> +<u><?php echo rawurldecode($abouttxtarray['website']) ?></u><br> +<br> +Devrim Gunduz<br> +Dave Page<br> +Chris Ryan<br> +Robert Treat<br> +</font></td> +<td width="50%" align="left" valign="top"><font size="-1"><u><?php echo rawurldecode($abouttxtarray['advocacy']) ?></u><br> +<br> +<a href="mailto:press@postgresql.org">Josh Berkus<br> +<a href="mailto:pgman@candle.pha.pa.us">Bruce Momjian</a><br> +<a href="mailto:press@postgresql.org">Robert Treat</a><br> +<br> +<a href="mailto:diogo@ikono.com.br">Diogo Biazus</a> <em>(Brazilian Portuguese language contact)</em><br> +<a href="mailto:filhocf@openoffice.org">Claudio Ferreira</a> <em>(Brazilian Portuguese language contact)</em><br> +<a href="mailto:dba@paragraf.ch">François Suter</a> <em>(French language contact)</em><br> +<a href="mailto:c@pgsql.info">Cornelia Boenigk</a> <em>(German language contact)</em><br> +<a href="mailto:mpaesold@gmx.at">Michael Paesold</a> <em>(German language contact)</em><br> +<a href="mailto:sreksten@sdb.it">Stefano Reksten</a> <em>(Italian language contact)</em><br> +<a href="mailto:chris@vanten.com">Chris Phelan</a> <em>(Japanese language contact)</em><br> +<a href="mailto:ckuroki@dbas.com.ar">Christian Kuroki</a> <em>(Spanish language contact)</em><br> +<a href="mailto:devrim@gunduz.org">Devrim GÜNDÜZ</a> <em>(Turkish language contact)</em><br> +<br> +<u><?php echo rawurldecode($abouttxtarray['developer']) ?></u><br> +<br> +Oleg Bartunov<br> +D'Arcy Cain<br> +Peter Eisentraut<br> +Oliver Elphick<br> +Daniel Horak<br> +Hiroshi Inoue<br> +Tatsuo Ishii<br> +Christopher Kings-Lynne<br> +Thomas Lockhart<br> +Michael Meskes<br> +Peter Mount<br> +Lamar Owen<br> +Dave Page<br> +Stephan Szabo<br> +Constantin Teodorescu<br> +</font></td> +</tr> +</table> +<br> +<br> +<div align="center"><a name="corporate"></a><strong><?php echo rawurldecode($abouttxtarray['recognise']) ?></strong><br> +<font size="-1"><em><?php echo rawurldecode($abouttxtarray['pleasenote']) ?></em></font></div> +<br> +<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0"> +<tr> +<td width="50%" align="left" valign="top"> +<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5"> +<tr> +<td width="70" align="center" valign="middle"> </td> +<td width="156" align="left" valign="top"><font size="-1"><u>Australia</u></font></td> +</tr> +<tr valign="middle"> +<td width="70" align="center"><a href="http://www.digitaldistribution.com" target="_blank"><img src="/images/gif/ddgfslogo4.gif" alt="DDGFS logo" width="70" height="18" border="0"></a></td> +<td width="156" align="left"><font size="-1"><a href="http://www.digitaldistribution.com" target="_blank">Digital Distribution Global Financial Services Pty. Ltd.</a></font></td> +</tr> +</table> +</td> +<td width="50%" align="left" valign="top"> +<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5"> +<tr> +<td width="70" align="center" valign="middle"> </td> +<td width="156" align="left" valign="top"><font size="-1"> +<u>Ireland</u></font></td> +</tr> +<tr valign="middle"> +<td width="70" align="center"><a href="http://www.afilias.com" target="_blank"><img src="/images/gif/afiliaslogo.gif" alt="Afilias logo" width="70" height="35" border="0"></a></td> +<td width="156" align="left"><font size="-1"><a href="http://www.afilias.com" target="_blank">Afilias Limited</a></font></td> +</tr> +</table> +</td> +</tr> +<tr> +<td align="left" valign="top"> +<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5"> +<tr> +<td width="70" align="center" valign="middle"> </td> +<td width="156" align="left" valign="top"><font size="-1"><u>Canada</u></font></td> +</tr> +<tr valign="top"> +<td width="70" align="center"><a href="http://www.hub.org" target="_blank"><img src="/images/gif/huborg.gif" alt="Hub.org logo" width="70" height="20" border="0"></a></td> +<td width="156" align="left"><font size="-1"><a href="http://www.hub.org" target="_blank">Hub.org</a></font></td> +</tr> +<tr valign="top"> +<td width="70" align="center"><a href="http://www.pgsql.com" target="_blank"><img src="/images/gif/pgsqlicon3.gif" alt="PostgreSQL logo" width="39" height="40" border="0"></a></td> +<td width="156" align="left"><font size="-1"><a href="http://www.pgsql.com" target="_blank">PostgreSQL, Inc.</a></font></td> +</tr> +</table> +</td> +<td align="left" valign="top"> +<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5"> +<tr> +<td width="70" align="center" valign="middle"> </td> +<td width="156" align="left" valign="top"><font size="-1"><u>Japan</u></font></td> +</tr> +<tr valign="middle"> +<td width="70" align="center"><a href="http://www.sra.co.jp/index-en.html" target="_blank"><img src="/images/gif/sralogo.gif" alt="SRA logo" width="54" height="18" border="0"></a></td> +<td width="156" align="left"><font size="-1"><a href="http://www.sra.co.jp/index-en.html" target="_blank">Software Research Associates of Japan.</a></font></td> +</tr></table> +<br> +<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5"> +<tr><td width="70" align="center" valign="middle"><font size="-1"><br> +</font></td><td width="156" align="left" valign="top"><font size="-1"> +<u>United States</u></font></td> +</tr> +<tr valign="middle"> +<td width="70" align="center"><a href="http://www.redhat.com" target="_blank"><img src="/images/gif/rhlogo.gif" alt="Red Hat logo" width="70" height="22" border="0"></a></td> +<td width="156" align="left"><font size="-1"><a href="http://www.redhat.com" target="_blank">Red Hat, Inc.</a></font></td> +</tr></table></td></tr></table></td></tr></table> +<br> +</td></tr></table></td></tr></table></td></tr> +<tr><td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/snow001bottom.jpg" width="600" height="80" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html> diff --git a/advocacy/advantages/index.php b/advocacy/advantages/index.php new file mode 100644 index 00000000..eb98514d --- /dev/null +++ b/advocacy/advantages/index.php @@ -0,0 +1,124 @@ +<?php include_once("../shared/global.php"); +include_once("../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the headers, footers, etc. +if (isset($advtxtarray) == FALSE) +{ + $advtxtarray = get_page_text('advantages', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<p><br> +<div align="center"><b><font size="+1"><?php echo rawurldecode($advtxtarray['theadvan']) ?></font></b></div> +<br> +<font size="-1"><?php echo rawurldecode($advtxtarray['pgsqloffers']) ?><br> +<br> +<br> +<a name="immunity"></a><strong><?php echo rawurldecode($advtxtarray['immunity']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['overdep']) ?><br> +<br> +<?php echo rawurldecode($advtxtarray['thishas']) ?> +</font> +<ul> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['moreprofit']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['noaudit']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['flexibility']) ?></font><br></li> +</ul> +<br> +<a name="support"></a><font size="-1"><strong><?php echo rawurldecode($advtxtarray['bettersupport']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['bettersupporttxt']) ?></font><br> +<br> +<br> +<a name="staffsavings"></a><font size="-1"><strong><?php echo rawurldecode($advtxtarray['savings']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['savingstxta']) ?> +<br> +<br> +<?php echo rawurldecode($advtxtarray['savingstxtb']) ?><br> +<br> +<br> +<a name="reliability"></a><strong><?php echo rawurldecode($advtxtarray['reliability']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['reliabilitytxt']) ?><br> +<br> +<br> +<a name="extensible"></a><strong><?php echo rawurldecode($advtxtarray['extensible']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['extensibletxt']) ?><br> +<br> +<br> +<a name="crossplat"></a><strong><?php echo rawurldecode($advtxtarray['crossplat']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['crossplattxt']) ?><br> +<br> +<br> +<a name="highvolume"></a><strong><?php echo rawurldecode($advtxtarray['highvolume']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['highvolumetxt']) ?><br> +</font><font size="-1"> +<br> +<br> +<a name="gui"></a><strong><?php echo rawurldecode($advtxtarray['guitools']) ?></strong><br> +<?php echo rawurldecode($advtxtarray['guitoolstxt']) ?><br> +<br> +<br> +<strong><?php echo rawurldecode($advtxtarray['apointlist']) ?></strong></font><strong><font size="-1">:</font></strong> +<ul> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['acid']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['ansisql']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['refint']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['replic']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['interfaces']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['rules']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['views']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['triggers']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['unicode']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['sequences']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['inherit']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['outerjoin']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['subselect']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['openapi']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['storedproc']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['ssl']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['procedlang']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['hotback']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['betterthanrow']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['funcindexes']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['kerberos']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['union']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['loadableext']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['toolsfor']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['datatypes']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($advtxtarray['compatfunc']) ?></font><br> +<br> +</li> +</ul> +</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center></body></html>
\ No newline at end of file diff --git a/advocacy/casestudies/index.php b/advocacy/casestudies/index.php new file mode 100644 index 00000000..8628d6f1 --- /dev/null +++ b/advocacy/casestudies/index.php @@ -0,0 +1,69 @@ +<?php include_once("../shared/global.php"); +include_once("../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($casetxtarray) == FALSE) +{ + $casetxtarray = get_page_text('casestudies', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"><tr><td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"><tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/watch001top.jpg" width="600" height="79" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="80%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<br> +<div align="center"><b><font size="+1"><?php echo rawurldecode($casetxtarray['casestudies']) ?></font></b></div> +<br> +<font size="-1"><em><?php echo rawurldecode($casetxtarray['howdoes']) ?></em><br> +<br> +<?php echo rawurldecode($casetxtarray['thesecase']) ?><br> +<br> +<blockquote> +<!-- +<a href="/casestudies/monsterlabs<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><strong><?php echo rawurldecode($casetxtarray['monsterlabs']) ?></strong></a><br> +<br> +--> +<a href="/casestudies/shannonmedical<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><strong><?php echo rawurldecode($casetxtarray['shannonmed']) ?></strong></a><br> +<br> +<a href="/casestudies/mohawk<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><strong>Mohawk Software</strong></a><br> +<br> +<a href="/casestudies/vanten<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><strong>Vanten Inc.</strong></a><br> +<br> +<a href="/casestudies/wcgcasestudyonpostgresqlv1.2.pdf"><strong>BASF</strong></a> <?php echo rawurldecode($casetxtarray['pdfformat']) ?><br> +<br> +<a href="http://www.pgsql.com/pdf/OpenSourceSoftware_Dravis_.pdf"><strong>The Dravis Group OSS Report</strong></a> <?php echo rawurldecode($casetxtarray['pdfformat']) ?><br> +<br> +<br> +</blockquote> +</font> +</td></tr></table></td></tr></table></td></tr></table></td></tr> +<tr><td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/watch001bottom.jpg" width="600" height="79" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html> diff --git a/advocacy/casestudies/mohawk/index.php b/advocacy/casestudies/mohawk/index.php new file mode 100644 index 00000000..98445f25 --- /dev/null +++ b/advocacy/casestudies/mohawk/index.php @@ -0,0 +1,81 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($casetxtarray) == FALSE) +{ + $casetxtarray = get_page_text('casestudies', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/sunset001top.jpg" width="600" height="66" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr> +<td valign="middle" align="left"> +<br> +<div align="center"><b><font size="+1"><a href="http://www.mohawksoft.com" target="_blank">Mohawk Software</a></font></b><br> +<font size="-1">Milton, Massachusetts<br> +United States</font></div> +<br> +<br> +<font size="-1"><em><?php echo rawurldecode($casetxtarray['compback']) ?></em><br> +<br> +<?php echo rawurldecode($casetxtarray['mohawksoft']) ?> +<br><br><br> +<em><?php echo rawurldecode($casetxtarray['challenge']) ?></em> +<br><br> +<?php echo rawurldecode($casetxtarray['formany']) ?> +<br><br> +<?php echo rawurldecode($casetxtarray['beforeopen']) ?> +<br><br><br> +<em><?php echo rawurldecode($casetxtarray['implement']) ?></em> +<br><br> +<?php echo rawurldecode($casetxtarray['byusing']) ?> +<br><br> +<?php echo rawurldecode($casetxtarray['handles']) ?> +<br><br> +<?php echo rawurldecode($casetxtarray['anyresp']) ?> +<br> +<br> +</font> +<table width="100%" border="0" cellspacing="0" cellpadding="0"> +<tr><td width="59%"><font size="-1"> <a href="/casestudies/shannonmedical<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['prev']) ?></a></font></td> +<td width="41%"><div align="right"><font size="-1"><a href="/casestudies/vanten<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['next']) ?></a> </font></div></td> +</tr></table><br> +</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/sunset001botton.jpg" width="600" height="63" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/casestudies/monsterlabs/index.php b/advocacy/casestudies/monsterlabs/index.php new file mode 100644 index 00000000..ddba3cf9 --- /dev/null +++ b/advocacy/casestudies/monsterlabs/index.php @@ -0,0 +1,93 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($casetxtarray) == FALSE) +{ + $casetxtarray = get_page_text('casestudies', $final_lang); +} +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td> +</tr> +<tr> +<td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr> +<td valign="middle" align="left"> +<br> +<div align="center"><b><a href="http://www.monsterlabs.com" target="_blank"><font color="#000000" size="+1">Monster Labs, Inc.<br> +</font></a></b><font size="-1">Nashville, Tennessee<br> +United States</font></div> +<br> + + +<?php echo rawurldecode($casetxtarray['monsterlabs']) ?> + +<br> +<table width="100%" border="0" cellspacing="0" cellpadding="0"> +<tr> +<td width="59%"><font size="-1"> <a href="/casestudies/mohawk<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['prev']) ?></a></font></td> +<td width="41%"> +<div align="right"><font size="-1"><a href="/vanten<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['next']) ?></a> </font></div> +</td> +</tr> +</table> +<br> +</div> +</td> +</tr> +</table> +</td></tr></table> +</td></tr></table> +</td> +</tr> +<tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html> diff --git a/advocacy/casestudies/monsterlabs/static.index.php b/advocacy/casestudies/monsterlabs/static.index.php new file mode 100644 index 00000000..c4238020 --- /dev/null +++ b/advocacy/casestudies/monsterlabs/static.index.php @@ -0,0 +1,189 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($casetxtarray) == FALSE) +{ + $casetxtarray = get_page_text('casestudies', $final_lang); +} +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td> +</tr> +<tr> +<td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr> +<td valign="middle" align="left"> +<br> +<div align="center"><b><a href="http://www.monsterlabs.org" target="_blank"><font color="#000000" size="+1">Monster Labs, Inc.<br> +</font></a></b><font size="-1">Nashville, Tennessee<br> +United States</font></div> +<br> +<div align="left"><u><em><strong>About the Company</strong></em></u><font size="-1"><br> +<br> +Monster Labs, Inc. (MLI) is a privately-held web applications and hosting business, specializing in script-hosting services and shared web hosting. The Nashville-based company was formed in September 1999, and is the creation of veteran Internet entrepreneurs Tim Moses, Thomas Conner and Andrew Webber. +<br> +<br> +Through its SiteMason division, MLI provides customers with a complete web site Content Management System and an array of remotely hosted tools that enhance websites. SiteMason's services are the ideal solution for small- to mid-sized businesses seeking to strengthen their web presence. These tools, including a SiteBuilder, PageBuilder, poll, news publishing system, custom form and others, help business owners communicate more effectively with their customers. +<br> +<br> +Through moses.com, MLI provides shared web hosting service providing economically priced web site hosting on robust servers with redundant accessibility. We have added solid management to ensure excellent customer service and support. +<br> +<br> +PostgreSQL is currently the primary O-RDBMS system we use as a backend +for our web-based content management system and application service +provider, SiteMason (http://www.sitemason.com/). We use it as an SQL +database against which we run complex queries in both development and +production web environments. We have several Apache web servers that use +mod_perl and DBI (with DBD::Pg) to connect to our PostgreSQL +installations. Everything that comes out of the database gets wrapped up in XML before being turned into html output. +<br> +<br> +</font><u><em><strong>Strategic Advantages of Selecting PostgreSQL</strong></em></u><font size="-1"><br> +<br> +PostgreSQL supported the primary enterprise requirements we had when +evaluating RDBMSes: transactions, full referential integrity, +subqueries. We needed an ACID-compliant database, and PostgreSQL met +this requirement. The fact that PostgreSQL has some object-relational +features was a bonus. +<br> +<br> +Additionally, our company supports the concept of Open Source, and our +IT staff is very comfortable communicating directly with developers and +receiving the kind of support that only the Open Source community is +able to provide. +<br> +<br> +We had experience with Oracle, and it was resource intensive in terms of +both hardware and people required to maintain it. After experimenting +with PostgreSQL, we determined that it was robust and reliable enough to +meet our needs in a live commercial environment. The price tag is +attractive but comes second to the fact that PostgreSQL has met all our +requirements for an RDBMS. +<br> +<br> +</font><strong><u><em>Implementing PostgreSQL</em></u></strong><font size="-1"><br> +<br> +<strong>Data Storage Needs</strong> +<br> +<br> +We store two types of data: 1) internal data used to control the web +applications we provide and 2) user data collected from the web, mostly +on behalf of customers using our products. The majority of the data is +numeric or ASCII, although we do have Unicode support. We have enabled +multibyte support in our PostgreSQL installations. +<br> +<br> +In our local production environment, we host approximately 450 MB. This +figure has grown fairly consistently over the course of the past year. +<br> +<br> +We also offer an appliance version of our system that is usually +installed remotely. The largest of these installations is currently +hosting approximately 200 MB, but we expect this to more than double +over the course of 2003. +<br> +<br> +<strong>Support Needs</strong> +<br> +<br> +We have 1 DBA (myself) and 1 sysadmin who are responsible for +maintaining the PostgreSQL installations and 3 other developers whose +work often involves querying the database(s). +<br> +Our local architecture consists of a layer of load-balanced front-end +web servers running Apache. These serve up cached or static pages. Any +processing requests are sent to a layer of Apache mod_perl servers that +have direct connections to our database layer. We currently have a +monolithic setup for PostgreSQL while we wait for replication to be +avialable. There is a failover setup that receives periodic snapshots of +our PostgreSQL installation and is ready to go live in the event of a +primary database server failure. All machines are GNU/Linux systems +connected by 100 Mb Ethernet. +<br> +<br> +</font><em><strong><u>Strengths, Weaknesses, Opportunity & Threats of selecting PostgreSQL</u></strong></em><u><strong><em> - (SWOT Analysis)</em></strong></u><font size="-1"><br> +<br> +<strong>Strengths</strong><br> +<br> +Reliability. Even when we've had faulty hardware, PostgreSQL has been +surprisingly robust. When a system fails for external reasons, +PostgreSQL's recoveries have been surprisingly fast and complete. +<br> +<br> +<strong>Weaknesses</strong><br> +<br> +I have done a fair amount of performance tuning, but there are still a +few queries I run that seem like they could stand to be a bit faster. +<br> +<br> +<br> +</font> +<br> +<table width="100%" border="0" cellspacing="0" cellpadding="0"> +<tr> +<td width="59%"><font size="-1"> <a href="/casestudies/mohawk<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['prev']) ?></a></font></td> +<td width="41%"> +<div align="right"><font size="-1"><a href="/vanten<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['next']) ?></a> </font></div> +</td> +</tr> +</table> +<br> +</div> +</td> +</tr> +</table> +</td></tr></table> +</td></tr></table> +</td> +</tr> +<tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html> diff --git a/advocacy/casestudies/salesorg/index.php b/advocacy/casestudies/salesorg/index.php new file mode 100644 index 00000000..d4f0cabc --- /dev/null +++ b/advocacy/casestudies/salesorg/index.php @@ -0,0 +1,240 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($casetxtarray) == FALSE) +{ + $casetxtarray = get_page_text('casestudies', $final_lang); +} +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td> +</tr> +<tr> +<td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr> +<td valign="middle" align="left"> +<br> +<div align="center"><b><a href="http://www.sales.org" target="_blank"><font color="#000000" size="+1">Sales.Org<br> +</font></a></b><font size="-1">Mississauga, Ontario<br> +Canada</font></div> +<br> +<div align="left"><font size="-1"><em>About the Company</em></font><font size="-1"><br> +<br> +Sales.org Inc. is a leading provider of Sales, Learning & Organizational Effectiveness competency testing and training for recruiting, selection, and development of the best people for the best companies.<br> +<br> +Our flagship product line of Skills & Capabilities Assessments were developed to help client companies and organizations find the most competent people, and to identify targeted learning opportunities directly linked to job performance, supported by the most advanced learning and decision making methods and tools.<br> +<br> +Our learning, decision-making and competencies programs are used in university Human Resource Development curricula "Managing Performance through Training & Development", Nelson Press, and are featured in leading Training & Development trade publications including "Best Practices: Training and Development", Carswell Publications.<br> +<br> +PostgreSQL provides the Object Relational Database Management System necessary to capture and report the level of details required to drive our competency testing tools, and at a cost that ensures these programs are easily accessible and affordable for any business or individual committed to achieving top performance.<br> + +<br> +<br> +<br> +</font><u><em><strong>Strategic Advantages of Selecting PostgreSQL</strong></em></u><font size="-1"><br> + +<br> +<em>Operational Excellence</em><br> +<br> +Open Source software eliminated the initial software license costs for development, and any need to charge sales.orgs clients a license fee based on the number of locations, systems, processors or seats. This PostgreSQL deployment also provided the lowest cost for delivery of the assessments online, reduced costs of customization for corporate clients, and full 24/7/365 access to the assessments, reports, and data.<br> +<br> +<br> +<em>Product Leadership</em><br> +<br> +PostgreSQL enabled sales.org to create truly object-relational assessments of the skills and capabilities of individuals. By establishing a uniform database model, sales.org is able to rapidly develop and deploy customized assessments for specific roles and responsibilities, reducing deployment time to as little as two weeks from the more traditional three to six months for development.<br> +<br> +<br> +<em>Customer Intimacy</em><br> +<br> +PostgreSQL powers an online, real-time suite of competency assessments that provide the individual participant with immediate results and an Action Plan for performance improvement. At the same time, the PostgreSQL application is collecting the information necessary to understand the overall competency of the organization and the opportunity to more effectively target organizational plans for training, development, and performance improvement.<br> + +<br> +<br> +<br> +</font><strong><u><em>Tactical Advantage of selecting PostgreSQL</em></u></strong><font size="-1"><br> +<br> +sales.org Inc. was able to convert Strategic Advantages into real returns on our investment by applying the same principles to this IT decision as we do for all decisions, separating our tactical objectives into seven Risk-Rated Return On Investment categories: +<ul> +<li><a href="#addval">Add Value (qualitative) to the Customer</a></li> +<li><a href="#addcust">Add New Customers</a></li> +<li><a href="#retexist">Retain Existing Customers</a></li> +<li><a href="#impprofit">Improve Profitability</a></li> +<li><a href="#redcrisk">Reduce or Avoid Placing Customers at Unnecessary Risk</a></li> +<li><a href="#redprisk">Reduce or Avoid Placing Personnel or the Company at Unnecessary Risk</a></li> +<li><a href="#excreq">Meet or Exceed Regulatory, Compliance; and, Market or Industry Requirements (Governance)</a></li> +</ul> +<br> +<em><a name="addval"></a>Add Value (qualitative) to the Customer</em><br> +<br> +Skills & Capabilities Assessments provide our customers with a better understanding of how their personnel compare to the industry.<br> +<br> +<br> +<em><a name="addcust"></a>Add New Customers</em><br> +<br> +The availability of Skills & Capabilities Assessments as a Web-based tool results in new customers coming to the Website daily to test their own competencies, and to seek out this level of competency measurement for their own companies.<br> +<br> +<br> +<em><a name="retexist"></a>Retain Existing Customers</em><br> +<br> +The Skills & Capabilities Assessments create a benchmark of competencies, along with performance improvement SMART Action Plans – encouraging customers to continuously revisit and reassess their skills & capabilities to ensure a competitive lead is achieved and sustained.<br> +<br> +<br> +<em><a name="impprofit"></a>Improve Profitability</em><br> +<br> +PostgreSQL and other Open Source solutions are the equivalent to Recycling for sales.org, enabling us to reuse code, reduce licensing, programming and systems admin costs, and eliminate 90% of the costs and wastage associated with paper-based testing and reporting. PostgreSQL provided sales.org with a solution that was $70,000 less expensive to create, and over 70% lower in cost to operate and maintain than any of the commercial DBMS offerings we looked at.<br> +<br> +<br> +<em><a name="redcrisk" id="redcrisk"></a>Reduce or Avoid Placing Customers at Unnecessary Risk</em><br> +<br> +PostgreSQL makes the cost of testing for competency easily within the means of any company, an essential consideration when it is understood that the costs of hiring the wrong person range from $5,000 to $500,000. For the management of existing personnel, the use of the assessment has been directly tied to helping clients reduce losses, and improve risk management decisions.<br> +<br> +<br> +<em><a name="redprisk"></a>Reduce or Avoid Placing Personnel or the Company at Unnecessary Risk</em><br> +<br> +PostgreSQL provides a rigorous, high availability mission critical product solution for our customers, with extensive security and control capabilities essential for the personal and personnel data and results collected.<br> +<br> +<br> +<em><a name="excreq"></a>Meet or Exceed Regulatory, Compliance; and, Market or Industry Requirements (Governance)</em><br> +<br> +Without the information gained from the use of these assessments it wasn’t possible to identify individuals who were likely to be making poor decisions based on a lack of knowledge or understanding of the full extent of their fiduciary responsibilities to the customer, the company, and their own interests. Our role specific assessments for managers, financial advisers and programmers all help to measure and predict judgment risks that candidates or personnel will be prone to make — as well as a SMART Action Plan to help avoid those errors in judgment.<br> + +<br> +<br> +<br> +</font><em><strong><u>Strengths, Weaknesses, Opportunity & Threats of selecting PostgreSQL</u></strong></em><u><strong><em> - (SWOT Analysis)</em></strong></u><font size="-1"><br> + +<br> +<strong>Strengths</strong> (Internal Advantages)<br> +<br> +PostgreSQL gives sales.org Inc. total access and control over the Source Code, a comprehensive set of application interfaces, extensive development tools, and ease of meeting business requirements with internal developers after a short learning curve.<br> +<br> +<br> +<strong>Strengths</strong> (External Advantages)<br> +<br> +PostgreSQL also ensures the highest level of interoperability with HR and other systems of our clients through it’s comprehensive support of SQL standards, Unicode, a large and growing community of developers available online, scalability and adaptability. PostgreSQL now enjoys a high level of awareness and acceptance in many senior IT circles.<br> +<br> +<br> +<strong>Weaknesses</strong> (Internal Disadvantages)<br> +<br> +When sales.org Inc. selected PostgreSQL (1997) there was limited commercial support, little internal experience with PostgreSQL or other advanced ORDBMSs, and it was difficult to sell to senior management of our clients based on limited information on the acceptance and use of PostgreSQL by other companies. These misperceptions have diminished, but are still prevalent within companies whose usual IT decisions have been to rely on ‘big names’ and ‘big ticket’ solutions. <br> +<br> + +<br> +<strong>Weaknesses</strong> (External Disadvantages)<br> +<br> +PostgreSQL and the entire Open Source movement continue to face heavy pressure & dis-information from media and commercial DBMS vendors, often suggesting limitations that do not exist in PostgreSQLs durability, extensibility, scalability, and capabilities. Even leading, and purportedly independent research companies such as Gartner continue to promote doubt and uncertainty over PostgreSQLs capabilities in favor of recommending companies with whom they are not at arms length.<br> +<br> +<br> +<strong>Opportunities</strong> (Internal Opportunities)<br> +<br> +PostgreSQL offers sales.org Inc. and all our partners the opportunity for greatly reduced costs of prototyping and development, and ease of integration with other information and database applications.<br> +<br> +<br> +<strong>Opportunities</strong> (External Opportunities)<br> +<br> +Zero cost for adding new systems, users, customers, and locations makes the sale of PostgreSQL based applications far more appealing to enlightened companies and organizations. Strong portability across multiple Operating Systems, and Rapid Application Development easily built onto the pre-existing work – without the traditional version control issues of many legacy or commercial alternatives.<br> +<br> +<br> +<strong>Threats</strong> (Internal Risks)<br> +<br> +At the time of the initial implementation, sales.org Inc. faced unknown deployment and sustainment costs, and questions about PostgreSQLs performance, stability, durability, scalability, extensibility, security & controls, capabilities, system requirements.<br> +<br> +<br> +<strong>Threats</strong> (External Risks)<br> +<br> +Unknown level of compatibility with industry standards, interaction with other applications, or competency of the open source and commercial support offered. Strong pressure from existing commercial vendors to stay with their applications entirely or risk it all and not get support on their product if the believe the problem was with PostgreSQL. Although all of these elements are true for any new, large-scale, mission critical application, these seem to be held against the Open Source community disproportionately, and generally without any reference to total cost savings over commercial licenses, with or without the cost overruns often associated with those.<br> +<br> +<br> +<br> +</font><u><em><strong>Epilogue</strong></em></u><font size="-1"><br> +<br> +Most PostgreSQL users have been able to build on the Strengths & Opportunities, and address the Weaknesses & Threats either during the selection process, or following the release of the application they have developed.<br> +<br> +The advantages that PostgreSQL provided sales.org Inc. with included a mature, stable, extremely well supported ORDBMS that enabled us to create products and services with built-ins sustainable competitive advantages more than capable of running and growing our mission critical applications and allowing us to provide our customers with information and direction that is otherwise unavailable.<br> +<br> +The greatest disadvantage sales.org Inc. faced in selecting PostgreSQL was the fear of the unknown. Despite 16 years of development and use, PostgreSQL is a relatively unknown quantity to CIO and CTO audiences, and often draws strong negative feedback from commercial competitors. The lack of certified training or other indications of competency makes recruiting architects and developers more difficult, and the current user interfaces lack some of the ease and polish that the high costs for licensing have helped fund for commercial databases.<br> +<br> +sales.org Inc. continues to be active in the PostgreSQL Open Source community and regularly draws upon the following resources:<br> +<ul> +<li>PostgreSQL Websites (www.postgresql.org, techdocs.postgresql.org, gborg.postgresql.org)</li> +<li>PostgreSQL mailing lists (pgsql-docs, pgsql-hackers, pgsql-patches, etc.)</li> +<li>Replication (eRServer)</li> +<li>Contractors/Consultants (Database Architect, Developer, Software Engineer, or Systems Admin)</li> +<li>PostgreSQL, Inc. Support Contract</li> +</ul> +sales.org Inc.s initial choice for PostgreSQL was one of the most effective decisions the company has ever made on software. In over 5 years of continuous use and ongoing development, this database has never required a costly conversion from past versions, has proven itself extremely stable and scalable, and has yet to fail to offer any critical business capability added to the mix. sales.org has saved tens of thousands of dollars in purchasing costs for licenses, development costs for the applications, and avoided thousands of dollars in flow through charges for licensing versions for the internal use of our clients.<br> +<br> +In short, and to confirm the statements and fears of many commercial database vendors, PostgreSQL has proven to be everything that those applications have not been, and to do everything that we would expect those databases to do, with far less cost and overhead. This has allowed sales.org Inc. to be a Service company with IT based solutions, without requiring sales.org Inc. to become an IT company developing and sustaining applications to support it’s sale and support of Products and Services.<br> +<br> +<br> +Copyright © 1996 - 2002 sales.org Inc. — All rights reserved, reprinted by permission.<br> +</font> +<br> +<table width="100%" border="0" cellspacing="0" cellpadding="0"> +<tr> +<td width="59%"><font size="-1"> <a href="/casestudies/mohawk<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['prev']) ?></a></font></td> +<td width="41%"> +<div align="right"><font size="-1"><a href="/vanten<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['next']) ?></a> </font></div> +</td> +</tr> +</table> +<br> +</div> +</td> +</tr> +</table> +</td></tr></table> +</td></tr></table> +</td> +</tr> +<tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/casestudies/shannonmedical/index.php b/advocacy/casestudies/shannonmedical/index.php new file mode 100644 index 00000000..b2dded26 --- /dev/null +++ b/advocacy/casestudies/shannonmedical/index.php @@ -0,0 +1,67 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($casetxtarray) == FALSE) +{ + $casetxtarray = get_page_text('casestudies', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"><tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/stoneglade001top.jpg" width="600" height="74" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"><table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<br> +<div align="center"> +<p><b><font size="+1"><?php echo rawurldecode($casetxtarray['shannonmed']) ?><br> +</font></b><font size="-1"> +San Angelo, Texas<br> +United States</font></div> +<br> +<em><font size="-1"><?php echo rawurldecode($casetxtarray['compback']) ?></font></em><font size="-1"></p> +<p><?php echo rawurldecode($casetxtarray['shperforms']) ?></p> +<p><?php echo rawurldecode($casetxtarray['shintheir']) ?></p> +<br> +<em><?php echo rawurldecode($casetxtarray['shflexib']) ?></em><br> +<br> +<?php echo rawurldecode($casetxtarray['shrecent']) ?> +<p><?php echo rawurldecode($casetxtarray['shinstead']) ?></p> +<br> +<em><?php echo rawurldecode($casetxtarray['shsolves']) ?></em><br> +<br> +<?php echo rawurldecode($casetxtarray['shthanks']) ?></font><br> +<br><br> +<table width="100%" border="0" cellspacing="0" cellpadding="0"> +<tr><td width="59%"><font size="-1"> <a href="/casestudies<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['menu']) ?></a></font></td> +<td width="41%"><div align="right"><font size="-1"><a href="/casestudies/mohawk<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['next']) ?></a> </font></div></td></tr></table> +<br> +</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/stoneglade001bottom.jpg" width="600" height="76" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/casestudies/vanten/index.php b/advocacy/casestudies/vanten/index.php new file mode 100644 index 00000000..74d945d4 --- /dev/null +++ b/advocacy/casestudies/vanten/index.php @@ -0,0 +1,78 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($casetxtarray) == FALSE) +{ + $casetxtarray = get_page_text('casestudies', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr></table></td></tr></table></td></tr><tr> +<td colspan="2"><table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<br> +<div align="center"><b><a href="http://www.vanten.com" target="_blank"><font color="#000000" size="+1">Vanten Inc.</font></a></b></div> +<div align="center"><font size="-1">Taito-ku, Tokyo<br> +Japan</font></div> +<font size="-1"><br> +<br> +<em><?php echo rawurldecode($casetxtarray['compback']) ?></em> +<br> +<br> +<?php echo rawurldecode($casetxtarray['vndevelop']) ?><br> +<br> +<br> +<em><?php echo rawurldecode($casetxtarray['vnfind']) ?></em> +<br> +<br> +<?php echo rawurldecode($casetxtarray['vnina']) ?> +<br> +<br> +<br> +<em><?php echo rawurldecode($casetxtarray['vnscales']) ?></em><br> +<br> +<?php echo rawurldecode($casetxtarray['vnselect']) ?><br> +<br> +<?php echo rawurldecode($casetxtarray['vnintegr']) ?> +<br> +<br> +<?php echo rawurldecode($casetxtarray['vnaccording']) ?><br> +</font><br> +<br> +<table width="100%" border="0" cellspacing="0" cellpadding="0"> +<tr><td width="59%"><font size="-1"> <a href="/casestudies/mohawk<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['prev']) ?></a></font></td> +<td width="41%"><div align="right"><font size="-1"><a href="/casestudies<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($casetxtarray['menu']) ?></a> </font></div></td></tr></table> +<br> +</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/casestudies/wcgcasestudyonpostgresqlv1.2.pdf b/advocacy/casestudies/wcgcasestudyonpostgresqlv1.2.pdf Binary files differnew file mode 100644 index 00000000..625df8f5 --- /dev/null +++ b/advocacy/casestudies/wcgcasestudyonpostgresqlv1.2.pdf diff --git a/advocacy/changes/73/index.html b/advocacy/changes/73/index.html new file mode 100644 index 00000000..adb7115b --- /dev/null +++ b/advocacy/changes/73/index.html @@ -0,0 +1,520 @@ +<pre> + Release Notes + + PostgreSQL Version 7.3 + + Release date: 2002-11-27 + _________________________________________________________________ + +Overview + + Major changes in this release: + + Schemas + Schemas allow users to create objects in their own namespace so + two people or applications can have tables with the same name. + There is also a public schema for shared tables. Table/index + creation can be restricted by removing permissions on the + public schema. + + Drop Column + PostgreSQL now supports the ALTER TABLE ... DROP COLUMN + functionality. + + Table Functions + Functions returning multiple rows and/or multiple columns are + now much easier to use than before. You can call such a "table + function" in the SELECT FROM clause, treating its output like a + table. Also, PL/pgSQL functions can now return sets. + + Prepared Queries + PostgreSQL now supports prepared queries, for improved + performance. + + Dependency Tracking + PostgreSQL now records object dependencies, which allows + improvements in many areas. "DROP" statements now take either + CASCADE or RESTRICT to control whether dependent objects are + also dropped. + + Privileges + Functions and procedural languages now have privileges, and + functions can be defined to run with the privileges of their + creator. + + Internationalization + Both multibyte and locale support are now always enabled. + + Logging + A variety of logging options have been enhanced. + + Interfaces + A large number of interfaces have been moved to + <a href="http://gborg.postgresql.org">http://gborg.postgresql.org</a> where they can be developed and + released independently. + + Functions/Identifiers + By default, functions can now take up to 32 parameters, and + identifiers can be up to 63 bytes long. + _________________________________________________________________ + +Migration to version 7.3 + + A dump/restore using pg_dump is required for those wishing to migrate + data from any previous release. If your application examines the + system catalogs, additional changes will be required due to the + introduction of schemas in 7.3; for more information, see: + <a href="http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3">http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3.</a> + + Observe the following incompatibilities: + + * Pre-6.3 clients are no longer supported. + * "pg_hba.conf" now has a column for the user name and additional + features. Existing files need to be adjusted. + * Several "postgresql.conf" logging parameters have been renamed and + improved. + * LIMIT #,# has been disabled; use LIMIT # OFFSET #. + * "INSERT" statements with column lists must specify all values; + e.g., INSERT INTO tab (col1, col2) VALUES ('val1') is now invalid. + * An index is now not automatically created for serial columns. + * A "SET" command inside an aborted transaction is now rolled back. + * "COPY" no longer considers missing trailing columns to be null. + All columns need to be specified. + * The data type timestamp is now equivalent to timestamp without + timezone, instead of timestamp with timezone. + * Pre-7.3 databases loaded into 7.3 will not have the new object + dependencies for serial columns, unique constraints, and foreign + keys. See the directory "contrib/adddepend/" for a detailed + description and a script that will add such dependencies. + _________________________________________________________________ + +Changes + +Server Operation + + Add pg_locks view to show locks (Neil) + Security fixes for password negotiation memory allocation (Neil) + Remove support for version 0 FE/BE protocol (PostgreSQL 6.2 and + earlier) (Tom) + Reserve the last few backend slots for superusers, add parameter + superuser_reserved_connections to control this (Nigel J. Andrews) + _________________________________________________________________ + +Performance + + Improve startup by calling localtime() only once (Tom) + Cache system catalog information in flat files for faster startup + (Tom) + Improve caching of index information (Tom) + Optimizer improvements (Tom, Fernando Nasser) + Catalog caches now store failed lookups (Tom) + Hash function improvements (Neil) + Improve performance of query tokenization and network handling (Peter) + Speed improvement for large object restore (Mario Weilguni) + Mark expired index entries on first lookup, saving later heap fetches + (Tom) + Eliminate NULL bitmap padding when not required (Manfred) + Add BSD-licensed qsort() for Solaris, for performance (Bruce) + Reduce per-row overhead by four bytes (Manfred Koizar) + Fix GEQO optimizer bug (Neil Conway) + Make WITHOUT OID actually save four bytes per row (Manfred Koizar) + Add default_statistics_target variable to specify ANALYZE buckets + (Neil) + Use local buffer cache for temporary tables so no WAL overhead (Tom) + Improve free space map performance on large tables (Stephen Marshall, + Tom) + Improved WAL write concurrency (Tom) + _________________________________________________________________ + +Privileges + + Add privileges on functions and procedural languages (Peter) + Add OWNER to CREATE DATABASE so superusers can create databases + on behalf of unprivileged users. (Gavin Sherry, Tom) + Add new object permission bits EXECUTE and USAGE (Tom) + Add SET SESSION AUTHORIZATION DEFAULT and RESET SESSION AUTHORIZATION + (Tom) + Allow functions to be executed with the privilege of the function + owner (Peter) + _________________________________________________________________ + +Server Configuration + + Server log messages now tagged with LOG, not DEBUG (Bruce) + Add user column to pg_hba.conf (Bruce) + Have log_connections output two lines in log file (Tom) + Remove debug_level from postgresql.conf, now server_min_messages + (Bruce) + New ALTER DATABASE/USER ... SET command for per-user/database + initialization (Peter) + New parameters server_min_messages and client_min_messages to + control which messages are sent to the server logs or client + applications (Bruce) + Allow pg_hba.conf to specify lists of users/databases separated by + commas, group names prepended with +, and file names prepended + with @ (Bruce) + Remove secondary password file capability and pg_password utility + (Bruce) + Add variable db_user_namespace for database-local user names (Bruce) + SSL improvements (Bear Giles) + Make encryption of stored passwords the default (Bruce) + Allow pg_statistics to be reset by calling pg_stat_reset() + (Christopher) + Add log_duration parameter (Bruce) + Rename debug_print_query to log_statement (Bruce) + Rename show_query_stats to show_statement_stats (Bruce) + Add param log_min_error_statement to print commands to logs on error + (Gavin) + _________________________________________________________________ + +Queries + + Make cursors insensitive, meaning their contents do not change (Tom) + Disable LIMIT #,# syntax; now only LIMIT # OFFSET # supported (Bruce) + Increase identifier length to 63 (Neil, Bruce) + UNION fixes for merging >= 3 columns of different lengths (Tom) + Add DEFAULT keyword to INSERT, e.g., INSERT ... (..., DEFAULT, ) + (Rod) + Allow views to have default values using ALTER COLUMN ... SET DEFAULT + (Neil) + Fail on INSERTs with column lists that don't supply all column + values, e.g., INSERT INTO tab (col1, col2) VALUES ('val1'); (Rod) + Fix for join aliases (Tom) + Fix for FULL OUTER JOINs (Tom) + Improve reporting of invalid identifier and location (Tom, Gavin) + Fix OPEN cursor(args) (Tom) + Allow 'ctid' to be used in a view and currtid(viewname) (Hiroshi) + Fix for CREATE TABLE AS with UNION (Tom) + SQL99 syntax improvements (Thomas) + Add statement_timeout variable to cancel queries (Bruce) + Allow prepared queries with PREPARE/EXECUTE (Neil) + Allow FOR UPDATE to appear after LIMIT/OFFSET (Bruce) + Add variable autocommit (Tom, David Van Wie) + _________________________________________________________________ + +Object Manipulation + + Make equals signs optional in CREATE DATABASE (Gavin Sherry) + Make ALTER TABLE OWNER to change index ownership (Neil) + New ALTER TABLE tabname ALTER COLUMN colname SET STORAGE controls + TOAST storage, compression (John Gray) + Add schema support, CREATE/DROP SCHEMA (Tom) + Create schema for temporary tables (Tom) + Add variable search_path for schema search (Tom) + Add ALTER TABLE SET/DROP NOT NULL (Christopher) + New CREATE FUNCTION volatility levels (Tom) + Make rule names unique only per table (Tom) + Add 'ON tablename' clause to DROP RULE and COMMENT ON RULE (Tom) + Add ALTER TRIGGER RENAME (Joe) + New current_schema() and current_schemas() inquiry functions (Tom) + Allow functions to return multiple rows (table functions) (Joe) + Make WITH optional in CREATE DATABASE, for consistency (Bruce) + Add object dependency tracking (Rod, Tom) + Add RESTRICT/CASCADE to DROP commands (Rod) + Add ALTER TABLE DROP for non-CHECK CONSTRAINT (Rod) + Autodestroy sequence on DROP of table with SERIAL (Rod) + Prevent column dropping if column is used by foreign key (Rod) + Automatically drop constraints/functions when object is dropped (Rod) + Add CREATE/DROP OPERATOR CLASS (Bill Studenmund, Tom) + Add ALTER TABLE DROP COLUMN (Christopher, Tom, Hiroshi) + Prevent inherited columns from being removed or renamed (Alvaro + Herrera) + Fix foreign key constraints to not error on intermediate database + states (Stephan) + Propagate column or table renaming to foreign key constraints + Add CREATE OR REPLACE VIEW (Gavin, Neil, Tom) + Add CREATE OR REPLACE RULE (Gavin, Neil, Tom) + Have rules execute alphabetically, returning more predictable values + (Tom) + Triggers are now fired in alphabetical order (Tom) + Add /contrib/adddepend to handle pre-7.3 object dependencies (Rod) + Allow better casting when inserting/updating values (Tom) + _________________________________________________________________ + +Utility Commands + + Have COPY TO output embedded carriage returns and newlines as \r and + \n (Tom) + Allow DELIMITER in COPY FROM to be 8-bit clean (Tatsuo) + Make pg_dump use ALTER TABLE ADD PRIMARY KEY, for performance (Neil) + Disable brackets in multistatement rules (Bruce) + Disable VACUUM from being called inside a function (Bruce) + Allow dropdb and other scripts to use identifiers with spaces (Bruce) + Restrict database comment changes to the current database + Allow comments on operators, independent of the underlying function + (Rod) + Rollback SET commands in aborted transactions (Tom) + EXPLAIN now outputs as a query (Tom) + Display sort keys in EXPLAIN (Tom) + Add 'SET LOCAL var = value' to set configuration variables for a + single transaction (Tom) + Allow ANALYZE to run in a transaction (Bruce) + Improve COPY syntax using new WITH clauses, keep backward + compatibility (Bruce) + Fix pg_dump to consistently output tags in non-ASCII dumps (Bruce) + Make foreign key constraints clearer in dump file (Rod) + Add COMMENT ON CONSTRAINT (Rod) + Allow COPY TO/FROM to specify column names (Brent Verner) + Dump UNIQUE and PRIMARY KEY contraints as ALTER TABLE (Rod) + Have SHOW output a query result (Joe) + Generate failure on short COPY lines rather than pad NULLs (Neil) + Fix CLUSTER to preserve all table attributes (Alvaro Herrera) + New pg_settings table to view/modify GUC settings (Joe) + Add smart quoting, portability improvements to pg_dump output (Peter) + Dump serial columns out as SERIAL (Tom) + Enable large file support, >2G for pg_dump (Peter, Philip Warner, + Bruce) + Disallow TRUNCATE on tables that are involved in referential + constraints (Rod) + Have TRUNCATE also auto-truncate the toast table of the relation (Tom) + Add clusterdb utility that will auto-cluster an entire database + based on previous CLUSTER operations (Alvaro Herrera) + Overhaul pg_dumpall (Peter) + Allow REINDEX of TOAST tables (Tom) + Implemented START TRANSACTION, per SQL99 (Neil) + Fix rare index corruption when a page split affects bulk delete (Tom) + Fix ALTER TABLE ... ADD COLUMN for inheritance (Alvaro Herrera) + _________________________________________________________________ + +Data Types and Functions + Fix factorial(0) to return 1 (Bruce) + Date/time/timezone improvements (Thomas) + Fix for array slice extraction (Tom) + Fix extract/date_part to report proper microseconds for timestamp + (Tatsuo) + Allow text_substr() and bytea_substr() to read TOAST values more + efficiently (John Gray) + Add domain support (Rod) + Make WITHOUT TIME ZONE the default for TIMESTAMP and TIME data types + (Thomas) + Allow alternate storage scheme of 64-bit integers for date/time types + using --enable-integer-datetimes in configure (Thomas) + Make timezone(timestamptz) return timestamp rather than a string + (Thomas) + Allow fractional seconds in date/time types for dates prior to 1BC + (Thomas) + Limit timestamp data types to 6 decimal places of precision (Thomas) + Change timezone conversion functions from timetz() to timezone() + (Thomas) + Add configuration variables datestyle and timezone (Tom) + Add OVERLAY(), which allows substitution of a substring in a string + (Thomas) + Add SIMILAR TO (Thomas, Tom) + Add regular expression SUBSTRING(string FROM pat FOR escape) (Thomas) + Add LOCALTIME and LOCALTIMESTAMP functions (Thomas) + Add named composite types using CREATE TYPE typename AS (column) + (Joe) + Allow composite type definition in the table alias clause (Joe) + Add new API to simplify creation of C language table functions (Joe) + Remove ODBC-compatible empty parentheses from calls to SQL99 + functions for which these parentheses do not match the standard + (Thomas) + Allow macaddr data type to accept 12 hex digits with no separators + (Mike Wyer) + Add CREATE/DROP CAST (Peter) + Add IS DISTINCT FROM operator (Thomas) + Add SQL99 TREAT() function, synonym for CAST() (Thomas) + Add pg_backend_pid() to output backend pid (Bruce) + Add IS OF / IS NOT OF type predicate (Thomas) + Allow bit string constants without fully-specified length (Thomas) + Allow conversion between 8-byte integers and bit strings (Thomas) + Implement hex literal conversion to bit string literal (Thomas) + Allow table functions to appear in the FROM clause (Joe) + Increase maximum number of function parameters to 32 (Bruce) + No longer automatically create index for SERIAL column (Tom) + Add current_database() (Rod) + Fix cash_words() to not overflow buffer (Tom) + Add functions replace(), split_part(), to_hex() (Joe) + Fix LIKE for bytea as a right-hand argument (Joe) + Prevent crashes caused by SELECT cash_out(2) (Tom) + Fix to_char(1,'FM999.99') to return a period (Karel) + Fix trigger/type/language functions returning OPAQUE to return + proper type (Tom) + _________________________________________________________________ + +Internationalization + + Add additional encodings (Korean (JOHAB), Thai (WIN874), Vietnamese + (TCVN), Arabic (WIN1256), Simplified Chinese (GBK), Korean (UHC) + (Eiji Tokuya) + Enable locale support by default (Peter) + Add locale variables (Peter) + Escape byes >= 0x7f for multibyte in PQescapeBytea/PQunescapeBytea + (Tatsuo) + Add locale awareness to regular expression character classes + Enable multibyte support by default (Tatso) + Add GB18030 multibyte support (Bill Huang) + Add CREATE/DROP CONVERSION, allowing loadable encodings (Tatsuo, + Kaori) + Add pg_conversion table (Tatsuo) + Add SQL99 CONVERT() function (Tatsuo) + pg_dumpall, pg_controldata, and pg_resetxlog now national-language + aware (Peter) + New and updated translations + _________________________________________________________________ + +Server-side Languages + + Allow recursive SQL function (Peter) + Change PL/Tcl build to use configured compiler and Makefile.shlib + (Peter) + Overhaul the PL/pgSQL FOUND variable to be more Oracle-compatible + (Tom, Neil) + Allow PL/pgSQL to handle quoted identifiers (Tom) + Allow set-returning PL/pgSQL functions (Neil) + Make PL/pgSQL schema-aware (Joe) + Remove some memory leaks (Nigel J. Andrews, Tom) + _________________________________________________________________ + +Psql + + Don't lowercase psql \connect database name for 7.2.0 compatibility + (Tom) + Add psql \timing to time user queries (Greg Sabino Mullane) + Have psql \d show index information (Greg Sabino Mullane) + New psql \dD shows domains (Jonathan Eisler) + Allow psql to show rules on views (Paul ?) + Fix for psql variable substitution (Tom) + Allow psql \d to show temporary table structure (Tom) + Allow psql \d to show foreign keys (Rod) + Fix \? to honor \pset pager (Bruce) + Have psql reports its version number on startup (Tom) + Allow \copy to specify column names (Tom) + _________________________________________________________________ + +Libpq + + Add $HOME/.pgpass to store host/user password combinations (Alvaro + Herrera) + Add PQunescapeBytea() function to libpq (Patrick Welche) + Fix for sending large queries over non-blocking connections + (Bernhard Herzog) + Fix for libpq using timers on Win9X (David Ford) + Allow libpq notify to handle servers with different-length + identifiers (Tom) + Add libpq PQescapeString() and PQescapeBytea() to Win32 (Bruce) + Fix for SSL with non-blocking connections (Jack Bates) + Add libpq connection timeout parameter (Denis A Ustimenko) + _________________________________________________________________ + +JDBC + + Allow JDBC to compile with JDK 1.4 (Dave) + Add JDBC 3 support (Barry) + Allows JDBC to set loglevel by adding ?loglevel=X to the connection + URL (Barry) + Add Driver.info() message that prints out the version number (Barry) + Add updateable result sets (Raghu Nidagal, Dave) + Add support for callable statements (Paul Bethe) + Add query cancel capability + Add refresh row (Dave) + Fix MD5 encryption handling for multibyte servers (Jun Kawai) + Add support for prepared statements (Barry) + _________________________________________________________________ + +Miscellaneous Interfaces + + Fixed ECPG bug concerning octal numbers in single quotes (Michael) + Move src/interfaces/libpgeasy to <a href="http://gborg.postgresql.org">http://gborg.postgresql.org</a> (Marc, + Bruce) + Improve Python interface (Elliot Lee, Andrew Johnson, Greg Copeland) + Add libpgtcl connection close event (Gerhard Hintermayer) + Move src/interfaces/libpq++ to <a href="http://gborg.postgresql.org">http://gborg.postgresql.org</a> (Marc, + Bruce) + Move src/interfaces/odbc to <a href="http://gborg.postgresql.org">http://gborg.postgresql.org</a> (Marc) + Move src/interfaces/libpgeasy to <a href="http://gborg.postgresql.org">http://gborg.postgresql.org</a> (Marc, + Bruce) + Move src/interfaces/perl5 to <a href="http://gborg.postgresql.org">http://gborg.postgresql.org</a> (Marc, + Bruce) + Remove src/bin/pgaccess from main tree, now at + <a href="http://www.pgaccess.org">http://www.pgaccess.org</a> (Bruce) + Add pg_on_connection_loss command to libpgtcl (Gerhard Hintermayer, + Tom) + _________________________________________________________________ + +Source Code + + Fix for parallel make (Peter) + AIX fixes for linking Tcl (Andreas Zeugswetter) + Allow PL/Perl to build under Cygwin (Jason Tishler) + Improve MIPS compiles (Peter, Oliver Elphick) + Require Autoconf version 2.53 (Peter) + Require readline and zlib by default in configure (Peter) + Allow Solaris to use Intimate Shared Memory (ISM), for performance + (Scott Brunza, P.J. Josh Rovero) + Always enable syslog in compile, remove --enable-syslog option + (Tatsuo) + Always enable multibyte in compile, remove --enable-multibyte option + (Tatsuo) + Always enable locale in compile, remove --enable-locale option + (Peter) + Fix for Win9x DLL creation (Magnus Naeslund) + Fix for link() usage by WAL code on Win32, BeOS (Jason Tishler) + Add sys/types.h to c.h, remove from main files (Peter, Bruce) + Fix AIX hang on SMP machines (Tomoyuki Niijima) + AIX SMP hang fix (Tomoyuki Niijima) + Fix pre-1970 date handling on newer glibc libraries (Tom) + Fix PowerPC SMP locking (Tom) + Prevent gcc -ffast-math from being used (Peter, Tom) + Bison >= 1.50 now required for developer builds + Kerberos 5 support now builds with Heimdal (Peter) + Add appendix in the User's Guide which lists SQL features (Thomas) + Improve loadable module linking to use RTLD_NOW (Tom) + New error levels WARNING, INFO, LOG, DEBUG[1-5] (Bruce) + New src/port directory holds replaced libc functions (Peter, Bruce) + New pg_namespace system catalog for schemas (Tom) + Add pg_class.relnamespace for schemas (Tom) + Add pg_type.typnamespace for schemas (Tom) + Add pg_proc.pronamespace for schemas (Tom) + Restructure aggregates to have pg_proc entries (Tom) + System relations now have their own namespace, pg_* test not required + (Fernando Nasser) + Rename TOAST index names to be *_index rather than *_idx (Neil) + Add namespaces for operators, opclasses (Tom) + Add additional checks to server control file (Thomas) + New Polish FAQ (Marcin Mazurek) + Add Posix semaphore support (Tom) + Document need for reindex (Bruce) + Rename some internal identifiers to simplify Win32 compile (Jan, + Katherine Ward) + Add documentation on computing disk space (Bruce) + Remove KSQO from GUC (Bruce) + Fix memory leak in rtree (Kenneth Been) + Modify a few error messages for consistency (Bruce) + Remove unused system table columns (Peter) + Make system columns NOT NULL where appropriate (Tom) + Clean up use of sprintf in favor of snprintf() (Neil, Jukka Holappa) + Remove OPAQUE and create specific subtypes (Tom) + Cleanups in array internal handling (Joe, Tom) + Disallow pg_atoi('') (Bruce) + Remove parameter wal_files because WAL files are now recycled (Bruce) + Add version numbers to heap pages (Tom) + _________________________________________________________________ + +Contrib + + Allow inet arrays in /contrib/array (Neil) + Gist fixes (Teodor Sigaev, Neil) + Upgrade /contrib/mysql + Add /contrib/dbsize which shows table sizes without vacuum (Peter) + Add /contrib/intagg, integer aggregator routines (mlw) + Improve /contrib/oid2name (Neil, Bruce) + Improve /contrib/tsearch (Oleg, Teodor Sigaev) + Cleanups of /contrib/rserver (Alexey V. Borzov) + Update /contrib/oracle conversion utility (Gilles Darold) + Update /contrib/dblink (Joe) + Improve options supported by /contrib/vacuumlo (Mario Weilguni) + Improvements to /contrib/intarray (Oleg, Teodor Sigaev, Andrey + Oktyabrski) + Add /contrib/reindexdb utility (Shaun Thomas) + Add indexing to /contrib/isbn_issn (Dan Weston) + Add /contrib/dbmirror (Steven Singer) + Improve /contrib/pgbench (Neil) + Add /contrib/tablefunc table function examples (Joe) + Add /contrib/ltree data type for tree structures (Teodor Sigaev, + Oleg Bartunov) + Move /contrib/pg_controldata into main tree (Bruce) + Fixes to /contrib/cube (Bruno Wolff) + Improve /contrib/fulltextindex (Christopher) + _________________________________________________________________ + diff --git a/advocacy/download/index.php b/advocacy/download/index.php new file mode 100644 index 00000000..d1abedac --- /dev/null +++ b/advocacy/download/index.php @@ -0,0 +1,60 @@ +<?php include_once("../shared/global.php"); +include_once("../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($downtxtarray) == FALSE) +{ + $downtxtarray = get_page_text('download', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<br> +<div align="center"><b><font size="+1"><?php echo rawurldecode($downtxtarray['download']) ?></font></b></div> +<div align="left"><br> +<font size="-1"><?php echo rawurldecode($downtxtarray['dnyoucan']) ?><br> +<ul> +<li><?php echo rawurldecode($downtxtarray['dnsrccode']) ?> (<a href="http://www.ca.postgresql.org/ftpsite/source/v7.3.2/postgresql-7.3.2.tar.gz">http</a>, <a href="ftp://ftp.postgresql.org/pub/source/v7.3.2/postgresql-7.3.2.tar.gz">ftp</a>)</li> +<li><?php echo rawurldecode($downtxtarray['dnrpm']) ?> (Red Hat 8.0: <a href="http://www.ca.postgresql.org/ftpsite/binary/v7.3.1/RPMS/redhat-8.0/postgresql-7.3.1-1PGDG.i386.rpm">http</a>, <a href="ftp://ftp.postgresql.org/pub/binary/v7.3.1/RPMS/redhat-8.0/postgresql-7.3.1-1PGDG.i386.rpm">ftp</a>)</li> +<li><?php echo rawurldecode($downtxtarray['dnrpm']) ?> (Red Hat 7.3: <a href="http://www.ca.postgresql.org/ftpsite/binary/v7.3.1/RPMS/redhat-7.3/postgresql-7.3.1-1PGDG.i386.rpm">http</a>, <a href="ftp://ftp.postgresql.org/pub/binary/v7.3.1/RPMS/redhat-7.3/postgresql-7.3.1-1PGDG.i386.rpm">ftp</a>)</li> +<li><?php echo rawurldecode($downtxtarray['dnrpm']) ?> (Red Hat 6.2: <a href="http://www.ca.postgresql.org/ftpsite/binary/v7.3.1/RPMS/redhat-6.2/postgresql-7.3.1-1PGDG.i386.rpm">http</a>, <a href="ftp://ftp.postgresql.org/pub/binary/v7.3.1/RPMS/redhat-6.2/postgresql-7.3.1-1PGDG.i386.rpm">ftp</a>)</li> +<li><?php echo rawurldecode($downtxtarray['dnsrpm']) ?> (<a href="http://www.ca.postgresql.org/ftpsite/binary/v7.3.1/RPMS/SRPMS/postgresql-7.3.1-1PGDG.src.rpm">http</a>, <a href="ftp://ftp.postgresql.org/pub/binary/v7.3.1/RPMS/SRPMS/postgresql-7.3.1-1PGDG.src.rpm">ftp</a>)</li> +<li>Solaris 8 INTEL (<a href="http://www.ca.postgresql.org/ftpsite/binary/v7.3.1/Solaris/8/Intel/PSQLpgsql-i686-7.3.1-1.pkg.bz2">http</a>, <a href="ftp://ftp.postgresql.org/pub/binary/v7.3.1/Solaris/8/Intel/PSQLpgsql-i686-7.3.1-1.pkg.bz2">ftp</a>)</li> +</ul> +<br> +<?php echo rawurldecode($downtxtarray['dnifdown']) ?> +<br><br> +<a href="http://store.pgsql.com/shopping/index.php?id=101" target="_blank">http://store.pgsql.com</a><br><br></font></div> +</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html> diff --git a/advocacy/favicon.ico b/advocacy/favicon.ico Binary files differnew file mode 100644 index 00000000..0ca66b95 --- /dev/null +++ b/advocacy/favicon.ico diff --git a/advocacy/images/gif/1pixelwhite.gif b/advocacy/images/gif/1pixelwhite.gif Binary files differnew file mode 100644 index 00000000..2799b45c --- /dev/null +++ b/advocacy/images/gif/1pixelwhite.gif diff --git a/advocacy/images/gif/aboutmap.gif b/advocacy/images/gif/aboutmap.gif Binary files differnew file mode 100644 index 00000000..73eedda7 --- /dev/null +++ b/advocacy/images/gif/aboutmap.gif diff --git a/advocacy/images/gif/afiliaslogo.gif b/advocacy/images/gif/afiliaslogo.gif Binary files differnew file mode 100644 index 00000000..5a88a141 --- /dev/null +++ b/advocacy/images/gif/afiliaslogo.gif diff --git a/advocacy/images/gif/box.gif b/advocacy/images/gif/box.gif Binary files differnew file mode 100644 index 00000000..e5ceac49 --- /dev/null +++ b/advocacy/images/gif/box.gif diff --git a/advocacy/images/gif/cross.gif b/advocacy/images/gif/cross.gif Binary files differnew file mode 100644 index 00000000..57231f5b --- /dev/null +++ b/advocacy/images/gif/cross.gif diff --git a/advocacy/images/gif/ddgfslogo4.gif b/advocacy/images/gif/ddgfslogo4.gif Binary files differnew file mode 100644 index 00000000..f6c0f6bd --- /dev/null +++ b/advocacy/images/gif/ddgfslogo4.gif diff --git a/advocacy/images/gif/huborg.gif b/advocacy/images/gif/huborg.gif Binary files differnew file mode 100644 index 00000000..02fdb64e --- /dev/null +++ b/advocacy/images/gif/huborg.gif diff --git a/advocacy/images/gif/pgsqlicon2.gif b/advocacy/images/gif/pgsqlicon2.gif Binary files differnew file mode 100644 index 00000000..f23afba5 --- /dev/null +++ b/advocacy/images/gif/pgsqlicon2.gif diff --git a/advocacy/images/gif/pgsqlicon3.gif b/advocacy/images/gif/pgsqlicon3.gif Binary files differnew file mode 100644 index 00000000..8f4568e4 --- /dev/null +++ b/advocacy/images/gif/pgsqlicon3.gif diff --git a/advocacy/images/gif/rhlogo.gif b/advocacy/images/gif/rhlogo.gif Binary files differnew file mode 100644 index 00000000..d9b148a1 --- /dev/null +++ b/advocacy/images/gif/rhlogo.gif diff --git a/advocacy/images/gif/sralogo.gif b/advocacy/images/gif/sralogo.gif Binary files differnew file mode 100644 index 00000000..cb71f360 --- /dev/null +++ b/advocacy/images/gif/sralogo.gif diff --git a/advocacy/images/gif/tick4.gif b/advocacy/images/gif/tick4.gif Binary files differnew file mode 100644 index 00000000..82b02fa4 --- /dev/null +++ b/advocacy/images/gif/tick4.gif diff --git a/advocacy/images/jpg/forestvalley001bottom.jpg b/advocacy/images/jpg/forestvalley001bottom.jpg Binary files differnew file mode 100644 index 00000000..8572905a --- /dev/null +++ b/advocacy/images/jpg/forestvalley001bottom.jpg diff --git a/advocacy/images/jpg/forestvalley001top.jpg b/advocacy/images/jpg/forestvalley001top.jpg Binary files differnew file mode 100644 index 00000000..77facacb --- /dev/null +++ b/advocacy/images/jpg/forestvalley001top.jpg diff --git a/advocacy/images/jpg/geyser001bottom.jpg b/advocacy/images/jpg/geyser001bottom.jpg Binary files differnew file mode 100644 index 00000000..c33576fc --- /dev/null +++ b/advocacy/images/jpg/geyser001bottom.jpg diff --git a/advocacy/images/jpg/geyser001top.jpg b/advocacy/images/jpg/geyser001top.jpg Binary files differnew file mode 100644 index 00000000..843cacb8 --- /dev/null +++ b/advocacy/images/jpg/geyser001top.jpg diff --git a/advocacy/images/jpg/giraffes001bottom.jpg b/advocacy/images/jpg/giraffes001bottom.jpg Binary files differnew file mode 100644 index 00000000..461594cd --- /dev/null +++ b/advocacy/images/jpg/giraffes001bottom.jpg diff --git a/advocacy/images/jpg/giraffes001top.jpg b/advocacy/images/jpg/giraffes001top.jpg Binary files differnew file mode 100644 index 00000000..bd5be7e0 --- /dev/null +++ b/advocacy/images/jpg/giraffes001top.jpg diff --git a/advocacy/images/jpg/illinoiswatchwidenedbtm001.jpg b/advocacy/images/jpg/illinoiswatchwidenedbtm001.jpg Binary files differnew file mode 100644 index 00000000..09d1f740 --- /dev/null +++ b/advocacy/images/jpg/illinoiswatchwidenedbtm001.jpg diff --git a/advocacy/images/jpg/illinoiswatchwidenedtop001.jpg b/advocacy/images/jpg/illinoiswatchwidenedtop001.jpg Binary files differnew file mode 100644 index 00000000..ca4e547a --- /dev/null +++ b/advocacy/images/jpg/illinoiswatchwidenedtop001.jpg diff --git a/advocacy/images/jpg/lily001bottom.jpg b/advocacy/images/jpg/lily001bottom.jpg Binary files differnew file mode 100644 index 00000000..535b8304 --- /dev/null +++ b/advocacy/images/jpg/lily001bottom.jpg diff --git a/advocacy/images/jpg/lily001top.jpg b/advocacy/images/jpg/lily001top.jpg Binary files differnew file mode 100644 index 00000000..db1ca7f5 --- /dev/null +++ b/advocacy/images/jpg/lily001top.jpg diff --git a/advocacy/images/jpg/mountain001bottom.jpg b/advocacy/images/jpg/mountain001bottom.jpg Binary files differnew file mode 100644 index 00000000..5a958826 --- /dev/null +++ b/advocacy/images/jpg/mountain001bottom.jpg diff --git a/advocacy/images/jpg/mountain001top.jpg b/advocacy/images/jpg/mountain001top.jpg Binary files differnew file mode 100644 index 00000000..80cee634 --- /dev/null +++ b/advocacy/images/jpg/mountain001top.jpg diff --git a/advocacy/images/jpg/road001bottom.jpg b/advocacy/images/jpg/road001bottom.jpg Binary files differnew file mode 100644 index 00000000..9c45f991 --- /dev/null +++ b/advocacy/images/jpg/road001bottom.jpg diff --git a/advocacy/images/jpg/road001top.jpg b/advocacy/images/jpg/road001top.jpg Binary files differnew file mode 100644 index 00000000..daeeaaac --- /dev/null +++ b/advocacy/images/jpg/road001top.jpg diff --git a/advocacy/images/jpg/snow001bottom.jpg b/advocacy/images/jpg/snow001bottom.jpg Binary files differnew file mode 100644 index 00000000..1ff86357 --- /dev/null +++ b/advocacy/images/jpg/snow001bottom.jpg diff --git a/advocacy/images/jpg/snow001top.jpg b/advocacy/images/jpg/snow001top.jpg Binary files differnew file mode 100644 index 00000000..cb7ae737 --- /dev/null +++ b/advocacy/images/jpg/snow001top.jpg diff --git a/advocacy/images/jpg/spikything001bottom.jpg b/advocacy/images/jpg/spikything001bottom.jpg Binary files differnew file mode 100644 index 00000000..3d12c5b8 --- /dev/null +++ b/advocacy/images/jpg/spikything001bottom.jpg diff --git a/advocacy/images/jpg/spikything001top.jpg b/advocacy/images/jpg/spikything001top.jpg Binary files differnew file mode 100644 index 00000000..390c0b92 --- /dev/null +++ b/advocacy/images/jpg/spikything001top.jpg diff --git a/advocacy/images/jpg/stoneglade001bottom.jpg b/advocacy/images/jpg/stoneglade001bottom.jpg Binary files differnew file mode 100644 index 00000000..dccb5ddd --- /dev/null +++ b/advocacy/images/jpg/stoneglade001bottom.jpg diff --git a/advocacy/images/jpg/stoneglade001top.jpg b/advocacy/images/jpg/stoneglade001top.jpg Binary files differnew file mode 100644 index 00000000..6b8bc717 --- /dev/null +++ b/advocacy/images/jpg/stoneglade001top.jpg diff --git a/advocacy/images/jpg/sunset001botton.jpg b/advocacy/images/jpg/sunset001botton.jpg Binary files differnew file mode 100644 index 00000000..9b76f681 --- /dev/null +++ b/advocacy/images/jpg/sunset001botton.jpg diff --git a/advocacy/images/jpg/sunset001top.jpg b/advocacy/images/jpg/sunset001top.jpg Binary files differnew file mode 100644 index 00000000..7c0defb5 --- /dev/null +++ b/advocacy/images/jpg/sunset001top.jpg diff --git a/advocacy/images/jpg/sunset002bottom.jpg b/advocacy/images/jpg/sunset002bottom.jpg Binary files differnew file mode 100644 index 00000000..dabd4bd2 --- /dev/null +++ b/advocacy/images/jpg/sunset002bottom.jpg diff --git a/advocacy/images/jpg/sunset002top.jpg b/advocacy/images/jpg/sunset002top.jpg Binary files differnew file mode 100644 index 00000000..cb164b4e --- /dev/null +++ b/advocacy/images/jpg/sunset002top.jpg diff --git a/advocacy/images/jpg/sunset003bottom.jpg b/advocacy/images/jpg/sunset003bottom.jpg Binary files differnew file mode 100644 index 00000000..685a7ad5 --- /dev/null +++ b/advocacy/images/jpg/sunset003bottom.jpg diff --git a/advocacy/images/jpg/sunset003top.jpg b/advocacy/images/jpg/sunset003top.jpg Binary files differnew file mode 100644 index 00000000..7a248542 --- /dev/null +++ b/advocacy/images/jpg/sunset003top.jpg diff --git a/advocacy/images/jpg/threepeaks001bottom.jpg b/advocacy/images/jpg/threepeaks001bottom.jpg Binary files differnew file mode 100644 index 00000000..139e863c --- /dev/null +++ b/advocacy/images/jpg/threepeaks001bottom.jpg diff --git a/advocacy/images/jpg/threepeaks001top.jpg b/advocacy/images/jpg/threepeaks001top.jpg Binary files differnew file mode 100644 index 00000000..02a5a5dc --- /dev/null +++ b/advocacy/images/jpg/threepeaks001top.jpg diff --git a/advocacy/images/jpg/watch001bottom.jpg b/advocacy/images/jpg/watch001bottom.jpg Binary files differnew file mode 100644 index 00000000..b93b9f61 --- /dev/null +++ b/advocacy/images/jpg/watch001bottom.jpg diff --git a/advocacy/images/jpg/watch001top.jpg b/advocacy/images/jpg/watch001top.jpg Binary files differnew file mode 100644 index 00000000..b3a11c31 --- /dev/null +++ b/advocacy/images/jpg/watch001top.jpg diff --git a/advocacy/index.php b/advocacy/index.php new file mode 100644 index 00000000..4ad38489 --- /dev/null +++ b/advocacy/index.php @@ -0,0 +1,87 @@ +<?php include_once("shared/global.php"); +include_once("local.php"); + +/* Get the text strings for the present page */ +$txtarray = get_page_text('firstpage', $final_lang); + +if (isset($newstxtarray) == FALSE) +{ + $newstxtarray = get_page_text('news', $final_lang); +} + +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +?> +<html><head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"><center> +<?php include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"><tr><td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/lily001top.jpg" width="600" height="76" border="0"></td> +</tr></table> +</td></tr></table> +</td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center" height="170"> +<tr><td valign="middle"> +<div align="center"><br><font size="+1"><strong><?php echo rawurldecode($txtarray['frnttxt1']) ?></strong></font></div> +<p><font size="-1"><?php echo rawurldecode($txtarray['frnttxt2']) ?></font></p> +<p><font size="-1"><?php echo rawurldecode($txtarray['frnttxt3']) ?></font></p> +<ul> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt15']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt4']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt5']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt6']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt7']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt8']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt9']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt10']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt11']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt12']) ?></font></li> +<li><font size="-1"><?php echo rawurldecode($txtarray['frnttxt13']) ?></font></li> +</ul> +<font size="-1"><?php echo rawurldecode($txtarray['frnttxt14']) ?></font><br><br> +<div align="center"><a href="/download<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1"><?php echo rawurldecode($txtarray['frnttxt16']) ?></font></a></div><br><br> +</td></tr></table> +</td></tr></table> +</td></tr></table> +</td></tr><tr><td <?php /* width="79%" */ ?>valign="top" bgcolor="#FFFFFF"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF" valign="top"> +<table width="100%" height="252" border="0" align="center" cellpadding="2" cellspacing="5"> +<?php include $localroot . 'shared/bottommenu.php' ?></table> +</td></tr></table></td></tr></table> +</td><td width="21%" valign="top" bgcolor="#FFFFFF"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF" valign="top"> +<table width="100%" height="252" border="0" align="right" cellpadding="2" cellspacing="5"> +<tr><th align="left" valign="top"> +<p align="left"><b><a href="/news<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($newstxtarray['nwlatestnews']) ?></a></b></p> +</th></tr><?php include $localroot . 'shared/latestnews.php' ?></table> +</td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/lily001bottom.jpg" width="600" height="74" border="0"></td> +</tr></table> +</td></tr></table> +</td></tr></table> +<?php include $localroot . 'shared/pagecopyright.php' ?> +</center></body></html> diff --git a/advocacy/join/index.php b/advocacy/join/index.php new file mode 100644 index 00000000..6c7d7a15 --- /dev/null +++ b/advocacy/join/index.php @@ -0,0 +1,55 @@ +<?php include_once("../shared/global.php"); +include_once("../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($jointxtarray) == FALSE) +{ + $jointxtarray = get_page_text('joinus', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"><tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<br> +<div align="center"><b><font size="+1"><?php echo rawurldecode($jointxtarray['joinus']) ?></font></b></div> +<br> +<div align="left"><font size="-1"><?php echo rawurldecode($jointxtarray['pleaseemail']) ?><br> +<br> +<?php echo rawurldecode($jointxtarray['ourteam']) ?><br> +<br> +<?php echo rawurldecode($jointxtarray['likecoding']) ?><br> +<br> +<?php echo rawurldecode($jointxtarray['press']) ?></font></div> +<br> +</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/local.php b/advocacy/local.php new file mode 100644 index 00000000..7ae9677b --- /dev/null +++ b/advocacy/local.php @@ -0,0 +1,5 @@ +<?php +// Local variables to override the global variables +$localroot = '/usr/local/www/advocacy/'; +$webmaster = 'xzilla@users.sourceforge.net'; +?> diff --git a/advocacy/manage/index.php b/advocacy/manage/index.php new file mode 100644 index 00000000..21191278 --- /dev/null +++ b/advocacy/manage/index.php @@ -0,0 +1 @@ +<html><head><title>Site Management Area</title></head><body> </body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/br/index.php b/advocacy/manage/translation/br/index.php new file mode 100644 index 00000000..d60904b0 --- /dev/null +++ b/advocacy/manage/translation/br/index.php @@ -0,0 +1,174 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 17th September 2002 ** +// ** Translation page version 1.03 ** + +// ** Target language is Brazilian Portuguese ** +$targlang = 'br'; +$language = 'Brasilian Portuguese'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $sqlstuff = "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"; + echo $sqlstuff; +// $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + $pg_result = pg_exec($dbconn, $sqlstuff); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/de/index.php b/advocacy/manage/translation/de/index.php new file mode 100644 index 00000000..63e4edf9 --- /dev/null +++ b/advocacy/manage/translation/de/index.php @@ -0,0 +1,171 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 17th September 2002 ** +// ** Translation page version 1.03 ** + +// ** Target language is German ** +$targlang = 'de'; +$language = 'Deutsch'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="100" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html> diff --git a/advocacy/manage/translation/en/index.php b/advocacy/manage/translation/en/index.php new file mode 100644 index 00000000..5071f4c4 --- /dev/null +++ b/advocacy/manage/translation/en/index.php @@ -0,0 +1,185 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 14th September 2002 ** +// ** Translation page version 1.02 ** + +// ** Target language is English ** +$targlang = 'en'; +$language = 'English'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html> +<head> +<title>Translation Page - Update String</title> +<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<br> +<?php include $globalroot . 'shared/headingstart.php' ?> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +<?php include $globalroot . 'shared/headingend.php' ?> +<br> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/es/index.php b/advocacy/manage/translation/es/index.php new file mode 100644 index 00000000..ce625d21 --- /dev/null +++ b/advocacy/manage/translation/es/index.php @@ -0,0 +1,171 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 14th September 2002 ** +// ** Translation page version 1.02 ** + +// ** Target language is Spanish ** +$targlang = 'es'; +$language = 'Spanish'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/fr/index.php b/advocacy/manage/translation/fr/index.php new file mode 100644 index 00000000..6bad1907 --- /dev/null +++ b/advocacy/manage/translation/fr/index.php @@ -0,0 +1,171 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 17th September 2002 ** +// ** Translation page version 1.03 ** + +// ** Target language is French ** +$targlang = 'fr'; +$language = 'French'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/hu/index.php b/advocacy/manage/translation/hu/index.php new file mode 100644 index 00000000..698f0281 --- /dev/null +++ b/advocacy/manage/translation/hu/index.php @@ -0,0 +1,174 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Robert Treat ** +// ** Last updated, 28th March 2003 ** +// ** Translation page version 1.03 ** + +// ** Target language is Hungarian ** +$targlang = 'hu'; +$language = 'Hungarian'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $sqlstuff = "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"; + echo $sqlstuff; +// $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + $pg_result = pg_exec($dbconn, $sqlstuff); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($pg_result == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html> diff --git a/advocacy/manage/translation/it/index.php b/advocacy/manage/translation/it/index.php new file mode 100644 index 00000000..818450c4 --- /dev/null +++ b/advocacy/manage/translation/it/index.php @@ -0,0 +1,171 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 14th September 2002 ** +// ** Translation page version 1.02 ** + +// ** Target language is Italian ** +$targlang = 'it'; +$language = 'Italian'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/nl/index.php b/advocacy/manage/translation/nl/index.php new file mode 100644 index 00000000..f97d43e1 --- /dev/null +++ b/advocacy/manage/translation/nl/index.php @@ -0,0 +1,175 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 15th October 2002 ** +// ** Translation page version 1.03 ** + +// ** Target language is Dutch ** +$targlang = 'nl'; +$language = 'Dutch'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title> +<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9"> +</head> + +<body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/ro/index.php b/advocacy/manage/translation/ro/index.php new file mode 100644 index 00000000..e888ca20 --- /dev/null +++ b/advocacy/manage/translation/ro/index.php @@ -0,0 +1,175 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 15th October 2002 ** +// ** Translation page version 1.03 ** + +// ** Target language is Romanian ** +$targlang = 'ro'; +$language = 'Romanian'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title> +<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2"> +</head> + +<body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/sv/index.php b/advocacy/manage/translation/sv/index.php new file mode 100644 index 00000000..91894f86 --- /dev/null +++ b/advocacy/manage/translation/sv/index.php @@ -0,0 +1,171 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 28th October 2002 ** +// ** Translation page version 1.03 ** + +// ** Target language is Swedish ** +$targlang = 'sv'; +$language = 'svenska'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/manage/translation/tr/index.php b/advocacy/manage/translation/tr/index.php new file mode 100644 index 00000000..cc41a801 --- /dev/null +++ b/advocacy/manage/translation/tr/index.php @@ -0,0 +1,171 @@ +<?php include_once('../../../shared/global.php'); +include_once('../../../local.php'); + +// ** Created by Justin Clift ** +// ** Last updated, 14th September 2002 ** +// ** Translation page version 1.02 ** + +// ** Target language is Turkish ** +$targlang = 'tr'; +$language = 'Turkish'; + +if (isset($_POST['targpage'])) { $targpage = $_POST['targpage']; }; +if (isset($_POST['targstr'])) { $targstr = $_POST['targstr']; }; +if (isset($_POST['strname'])) { $strname = $_POST['strname']; }; + +// If a target language string has been sent, then update it in the database +if ((isset($_POST['targstr'])) AND (isset($_POST['strname'])) AND (isset($_POST['targpage']))) { + + // ** Find out if we need to use INSERT or UPDATE to put the string in the database ** + $pg_result = pg_exec($dbconn, "SELECT idnum FROM textstrings WHERE lang = '{$targlang}' AND strname = '{$_POST['strname']}' AND page = '{$_POST['targpage']}'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN002: There was an error when connecting to the database.'); + exit(); + }; + + if (pg_num_rows($pg_result) == 0) { + $pg_result = pg_exec($dbconn, "INSERT INTO textstrings (strname, strtext, lang, page) VALUES ('{$_POST['strname']}', '" . rawurlencode($_POST['targstr']) . "', '{$targlang}', '{$_POST['targpage']}')"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN003: There was an error when connecting to the database.'); + exit(); + }; + } else { + $pgidnum = pg_fetch_result($pg_result, 0, 'idnum'); + $pg_result = pg_exec($dbconn, "UPDATE textstrings set strtext = '" . rawurlencode($_POST['targstr']) . "' WHERE idnum = $pgidnum"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN004: There was an error when connecting to the database.'); + exit(); + }; + } +} + +// ** Make a list of all the pages which are in the database ** +$pg_result = pg_exec($dbconn, "SELECT pagename FROM page ORDER BY pagename"); +if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN007: There was an error when connecting to the database.'); + exit(); +}; + +$pgnumpages = pg_num_rows($pg_result); +for ($i = 0; $i < $pgnumpages; $i++) { + $pagenames[] = pg_fetch_result($pg_result, $i, 'pagename'); +} + +if (isset($targpage)) { + + // ** Get a list of all the English text strings which are in the database ** + $pg_result = pg_exec($dbconn, "SELECT strname, strtext, page FROM textstrings WHERE lang = 'en' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN005: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strename = pg_fetch_result($pg_result, $i, 'strname'); + $stretext = pg_fetch_result($pg_result, $i, 'strtext'); + $engarray["$strename"] = rawurldecode($stretext); + } + + // ** Get a list of all the target language text strings which are in the database for the selected page ** + $pg_result = pg_exec($dbconn, "SELECT DISTINCT strname, strtext FROM textstrings WHERE lang = '{$targlang}' AND page = '{$targpage}' ORDER BY strname"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Database error', 'Database error', 'FRN006: There was an error when connecting to the database.'); + exit(); + }; + + $pgnumstrs = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumstrs; $i++) { + $strlname = pg_fetch_result($pg_result, $i, 'strname'); + $strltext = pg_fetch_result($pg_result, $i, 'strtext'); + $targarray["$strlname"] = rawurldecode($strltext); + } +} + +// Put the string name in a temporary variable +$strfoo = $_POST['strname']; + +?> +<html><head><title>Translation Page - Update String</title></head><body> +<table width="800" border="0"> +<tr><td valign="top"><b>Target Language:</b> <?php echo $language ?></td><td> </td></tr> +<tr><td valign="top"><b>Current Page:</b> <?php if (isset($targpage) OR ($targpage != "")) { echo $targpage; } else { echo 'None'; } ?></td> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<b>Select New Page:</b> <select name="targpage" id="targpage2"> +<?php +foreach ($pagenames as $pageinstance) { + echo '<option value="' . $pageinstance . '"'; + if ($targpage == $pageinstance) { + echo " selected"; + } + echo ">{$pageinstance}</option>"; +} ?> +</select> +<input name="Submit" type="submit" id="Submit10" value="Change Page"> +</form> +</td> +</tr> +</table> +<?php + if (isset($targpage)) { +?> +<table width="800" border="0"> +<tr> +<td valign="top"><form action="/manage/translation/<?php echo $targlang ?>/" method="POST"><b>String Name:</b> +<select name="strname" id="strname"> +<?php + foreach ($engarray as $langkey => $langvalue) { + echo '<option value="' . $langkey . '"'; + if ($langkey == $strfoo) { + echo " selected"; + } + echo ">{$langkey}</option>"; + } +?> +</select> +<input name="Submit" type="submit" id="Submit" value="Show string"> +<input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"> +</form></td><td> +</td> +</tr> +</table> +<?php + } + + if (isset($_POST['strname'])) { +?> +<form action="/manage/translation/<?php echo $targlang ?>/" method="POST"> +<input name="strname" type="hidden" id="strname" value="<?php echo $strfoo ?>"><br> +<table width="100%" border="0"> +<tr> +<td><b>English Version:</b><br><br></td> +<td> +<?php + echo htmlentities($engarray["$strfoo"], ENT_QUOTES); +?> +<br><br></td></tr> +<tr> +<td valign="top"><b><?php echo $language ?>:</b></td><td><?php echo $targarray["$strfoo"] ?></td></tr> +<tr><td valign="top"><b>Source:</b></td> +<td> +<textarea name="targstr" cols="120" rows="10" wrap="VIRTUAL" id="targstr"><?php echo htmlentities($targarray["$strfoo"], ENT_NOQUOTES) ?></textarea> +<br> +</td> +</tr> +<tr> +<td> + <input name="targpage" type="hidden" id="targpage" value="<?php echo $targpage ?>"></td> +<td><input type="submit" name="Submit2" value="Update string"> <input name="Reset" type="reset" id="Reset" value="Reset"></td> +</tr> +<?php + } +?> +</table> +</form> +</body></html>
\ No newline at end of file diff --git a/advocacy/news/2002100101/index.php b/advocacy/news/2002100101/index.php new file mode 100644 index 00000000..7ce4a143 --- /dev/null +++ b/advocacy/news/2002100101/index.php @@ -0,0 +1,77 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the news info +if (isset($newstxtarray) == FALSE) +{ + $newstxtarray = get_page_text('news', $final_lang); +} +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td> +</tr> +<tr> +<td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr> +<td valign="middle" align="left"> +<br> +<font size="+1"><b><?php echo rawurldecode($newstxtarray['nw02091401a']) ?></b></font><br><br> +<font size="-1"><?php echo rawurldecode($newstxtarray['nw02091401b']) ?></font><br><br> +<font size="-1"><?php echo rawurldecode($newstxtarray['nw02091401c']) ?></font><br><br> +</td> +</tr> +</table> +</td></tr></table> +</td></tr></table> +</td> +</tr> +<tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/news/2002100102/index.php b/advocacy/news/2002100102/index.php new file mode 100644 index 00000000..e9d3990b --- /dev/null +++ b/advocacy/news/2002100102/index.php @@ -0,0 +1,77 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the news info +if (isset($newstxtarray) == FALSE) +{ + $newstxtarray = get_page_text('news', $final_lang); +} +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td> +</tr> +<tr> +<td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr> +<td valign="middle" align="left"> +<br> +<font size="+1"><b><?php echo rawurldecode($newstxtarray['nw02091402a']) ?></b></font><br><br> +<font size="-1"><?php echo rawurldecode($newstxtarray['nw02091402b']) ?></font><br><br> +<font size="-1"><?php echo rawurldecode($newstxtarray['nw02091402c']) ?></font><br><br> +</td> +</tr> +</table> +</td></tr></table> +</td></tr></table> +</td> +</tr> +<tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html>
\ No newline at end of file diff --git a/advocacy/news/2002112801/index.php b/advocacy/news/2002112801/index.php new file mode 100644 index 00000000..8194db24 --- /dev/null +++ b/advocacy/news/2002112801/index.php @@ -0,0 +1,77 @@ +<?php include_once("../../shared/global.php"); +include_once("../../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the news info +if (isset($newstxtarray) == FALSE) +{ + $newstxtarray = get_page_text('news', $final_lang); +} +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001top.jpg" width="600" height="81" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td> +</tr> +<tr> +<td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr> +<td valign="middle" align="left"> +<br> +<b><?php echo rawurldecode($newstxtarray['nw02112801a']) ?></b><br><br> +<?php echo rawurldecode($newstxtarray['nw02112801b']) ?><br><br> +<?php echo rawurldecode($newstxtarray['nw02112801c']) ?><br><br> +</td> +</tr> +</table> +</td></tr></table> +</td></tr></table> +</td> +</tr> +<tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr> +<td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/mountain001bottom.jpg" width="600" height="82" border="0"></td> +</tr> +</table> +</td> +</tr> +</table> +</td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html> diff --git a/advocacy/news/index.php b/advocacy/news/index.php new file mode 100644 index 00000000..895b8870 --- /dev/null +++ b/advocacy/news/index.php @@ -0,0 +1,94 @@ +<?php include_once("../shared/global.php"); +include_once("../local.php"); + +// Get the text strings for the present page + +if (isset($txtarray) == FALSE) +{ + $txtarray = get_page_text('news', $final_lang); +} + +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<?php include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/spikything001top.jpg" width="600" height="90" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"> +<br> +<font size="+1"><b><?php echo rawurldecode($txtarray['nwlatestnews']) ?></b></font> +<br><br> + +<?php + +// Display the third news item if it exists +if (isset($txtarray['nwthirddate'])) { + echo '<br><u>' . rawurldecode($txtarray['nwthirddate']) . '</u><br><br>'; + echo '<font size="-1">' . rawurldecode($txtarray['nwthirdshorta']) . ' <a href="' . rawurldecode($txtarray['nwthirdshortb']); + if ($lang_override) { echo "?lang={$final_lang}"; } + echo '" target="_self">' . rawurldecode($txtarray['nwthirdshortc']) . '</a>' . rawurldecode($txtarray['nwthirdshortd']) . '</font><br><br>'; +} +// Display the first news item if it exists +if (isset($txtarray['nwfirstdate'])) { + echo '<br><u>' . rawurldecode($txtarray['nwfirstdate']) . '</u><br><br>'; + echo '<font size="-1">' . rawurldecode($txtarray['nwfirstshorta']) . ' <a href="' . rawurldecode($txtarray['nwfirstshortb']); + if ($lang_override) { echo "?lang={$final_lang}"; } + echo '" target="_self">' . rawurldecode($txtarray['nwfirstshortc']) . '</a>' . rawurldecode($txtarray['nwfirstshortd']) . '</font><br><br>'; +} + +// Display the second news item if it exists +if (isset($txtarray['nwseconddate'])) { + echo '<br><u>' . rawurldecode($txtarray['nwseconddate']) . '</u><br><br>'; + echo '<font size="-1">' . rawurldecode($txtarray['nwsecondshorta']) . ' <a href="' . rawurldecode($txtarray['nwsecondshortb']); + if ($lang_override) { echo "?lang={$final_lang}"; } + echo '" target="_self">' . rawurldecode($txtarray['nwsecondshortc']) . '</a>' . rawurldecode($txtarray['nwsecondshortd']) . '</font><br><br>'; +} + +// Display the fourth news item if it exists +if (isset($txtarray['nwfourthdate'])) { + echo '<br><u>' . rawurldecode($txtarray['nwfourthdate']) . '</u><br>'; + echo '<font size="-1">' . rawurldecode($txtarray['nwfourthshorta']) . ' <a href="' . rawurldecode($txtarray['nwfourthshortb']); + if ($lang_override) { echo "?lang={$final_lang}"; } + echo '" target="_self">' . rawurldecode($txtarray['nwfourthshortc']) . '</a>' . rawurldecode($txtarray['nwfourthshortd']) . '</font><br><br>'; +} + +// Display the fifth news item if it exists +if (isset($txtarray['nwfifthdate'])) { + echo '<br><u>' . rawurldecode($txtarray['nwfifthdate']) . '</u><br>'; + echo '<font size="-1">' . rawurldecode($txtarray['nwfifthshorta']) . ' <a href="' . rawurldecode($txtarray['nwfifthshortb']); + if ($lang_override) { echo "?lang={$final_lang}"; } + echo '" target="_self">' . rawurldecode($txtarray['nwfifthshortc']) . '</a>' . rawurldecode($txtarray['nwfifthshortd']) . '</font><br><br>'; +} + +// Display a link to the Archives +/* <font size="-1"><a href="/news/archives" target="_self">Old News...</a></font><br><br></td> */ ?> +<br><br></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/spikything001bottom.jpg" width="600" height="90" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<?php include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body> +</html> diff --git a/advocacy/privacy/index.php b/advocacy/privacy/index.php new file mode 100644 index 00000000..c8fcc64d --- /dev/null +++ b/advocacy/privacy/index.php @@ -0,0 +1,51 @@ +<? include_once("../shared/global.php"); +include_once("../local.php"); + +// Get the text strings for the headers, footers, etc. +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($privtxtarray) == FALSE) +{ + $privtxtarray = get_page_text('privacy', $final_lang); +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<? include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/giraffes001top.jpg" width="600" height="80" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"> +<tr><td valign="middle" align="left"><br> +<div align="center"><font size="+1"><strong><?php echo rawurldecode($privtxtarray['privourpol']) ?></strong></font></div> +<br> +<font size="-1"><?php echo rawurldecode($privtxtarray['privwhen']) ?> +<br><br> +<?php echo rawurldecode($privtxtarray['privstore']) ?><br> +<br> +<?php echo rawurldecode($privtxtarray['privcollect']) ?></font><br><br> +</td></tr></table></td></tr></table></td></tr></table></td></tr> +<tr><td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/giraffes001bottom.jpg" width="600" height="86" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<? include $localroot . 'shared/pagecopyright.php' ?> +</center></body></html>
\ No newline at end of file diff --git a/advocacy/request/index.php b/advocacy/request/index.php new file mode 100644 index 00000000..4b3b4577 --- /dev/null +++ b/advocacy/request/index.php @@ -0,0 +1,268 @@ +<?php include_once("../shared/global.php"); +include_once("../local.php"); + +// Define the error constants used by this page +define(NAME, 1); +define(EMAIL, 2); +define(LANG, 4); +define(NATURE, 8); +//define(URGENCY, 16); + +// Undefine the local variables used internally by this page +unset($errorreason); +unset($name); +unset($email); +unset($lang); +unset($nature); +unset($urgency); +unset($region); +unset($compname); +unset($people); + +// Get the text strings for the headers, footers, etc. +if (empty($logotxtarray)) +{ + global $logotxtarray; + $logotxtarray = get_page_text('logostrip', $final_lang); +} + +// Get the text strings for the page +if (isset($requesttxtarray) == FALSE) +{ + global $requesttxtarray; + $requesttxtarray = get_page_text('request', $final_lang); +} + +// Check if the user is sending us a request, and if so then process it +if ($_POST['requested'] == 'yes') { + + // Check if all the required fields are present + if (empty($_POST['name']) OR empty($_POST['email']) OR empty($_POST['lang']) + OR empty($_POST['nature']) /* (OR empty($_POST['urgency'])*/ OR (verify_email($_POST['email']) != 0)) { + // Figure out which fields the user missed + if (empty($_POST['name'])) { $errorreason = NAME; }; + if (empty($_POST['email']) OR (verify_email($_POST['email']) != 0)) { $errorreason = $errorreason | EMAIL; }; + if (empty($_POST['lang'])) { $errorreason = $errorreason | LANG; }; + if (empty($_POST['nature'])) { $errorreason = $errorreason | NATURE; }; +// if (empty($_POST['urgency'])) { $errorreason = $errorreason | URGENCY; }; + } else { + // Everything seems to be alright thus far so sanitise the incoming fields + $name = preg_quote($_POST['name'], "'"); + $email = $_POST['email']; + $lang = preg_quote($_POST['lang'], "'"); + $nature = preg_quote($_POST['nature'], "'"); + $urgency = preg_quote($_POST['urgency'], "'"); + $region = preg_quote($_POST['region'], "'"); + $compname = preg_quote($_POST['compname'], "'"); + $people = preg_quote($_POST['people'], "'"); + + // Create the email to send to the designated recipient + $to = 'josh@agliodbs.com'; +// switch ($urgency) { + // case '1': + // $subject = 'Casual'; + // break; + // case '2': + $subject = 'A within the next day or two'; +// break; + // case '3': + // $subject = 'Today please'; + //break; +// case '4': + // $subject = 'Urgent'; + // break; + // default: +// unset($urgency); +// } + + $subject .= " request for a PostgreSQL contact from advocacy.postgresql.org"; + $message = $name . " has requested to be contacted in regards to PostgreSQL.\n\n" + . 'Email address : ' . $email . "\n\n" + . 'Preferred language : ' . $lang . "\n\n" + . 'The nature of the request : ' . $nature . "\n\n"; + if (isset($region)) { $message .= 'The region of the requester : ' . $region . "\n\n"; } + if (isset($compname)) { $message .= 'The name of the requester\'s company : ' . $compname . "\n\n"; } + if (isset($people)) { $message .= 'The number of people in the requester\'s company : ' . $people . "\n\n"; } +// if (isset($urgency)) { $message .= 'The urgency of the request is : ' . $urgency . "\n\n"; } + + $headers = "From: Advocacy Website <josh@agliodbs.com>\r\n"; + + // Send the email to the designated recipient + $mailret = mail($to, $subject, $message, $headers); + + // Check if an error occured in the emailing, and if so, notify the appropriate person + if ($mailret != TRUE) { + error_page('RQ01: Error sending email', 'RQ01: Error sending email', 'There was an error in sending the request.'); + exit; + } + + // Thank the user for their request, then let them know someone will contact them as appropriate + // Josh has requested all contact emails be responded to 'in a couple of days' +// switch ($urgency) { +// case '1': + $responsemsg .= rawurldecode($requesttxtarray['nextfewdays']); +// break; +// case '2': +// $responsemsg .= rawurldecode($requesttxtarray['nextday']); +// break; +// case '3': +// $responsemsg .= rawurldecode($requesttxtarray['sometoday']); +// break; +// case '4': +// $responsemsg .= rawurldecode($requesttxtarray['withinhours']); +// } + $responsemsg = '<font size="-1">' . rawurldecode($requesttxtarray['someresp']) . $responsemsg; + $responsemsg .= '<br><br>' . rawurldecode($requesttxtarray['plsfeel']) . '<br><br>'; + $responsemsg .= rawurldecode($requesttxtarray['interacdoc']) . '<br><br>'; + $responsemsg .= rawurldecode($requesttxtarray['techdoc']) . '<br><br>'; + $responsemsg .= rawurldecode($requesttxtarray['jdbcsite']) . '<br><br>'; + $responsemsg .= rawurldecode($requesttxtarray['odbcsite']) . '<br><br>'; + $responsemsg .= rawurldecode($requesttxtarray['pgadminsite']) . '<br><br>'; + $responsemsg .= rawurldecode($requesttxtarray['mlarchives']); + $responsemsg .= '</font>'; + + error_page(rawurldecode($requesttxtarray['rqst1']), rawurldecode($requesttxtarray['rqst2']), '<font size="-1">' . rawurldecode($requesttxtarray['rqst3']) . '</font>', $responsemsg, $final_lang); + exit; + } +} + +?> +<html> +<head> +<title><?php echo rawurldecode($logotxtarray['logotext']) ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"> +<center> +<?php include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"> +<tr><td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/road001top.jpg" width="600" height="69" border="0"></td> +</tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"> +<tr><td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"><tr> +<td valign="middle" align="left"> +<br> +<div align="center"><b><font size="+1"><?php echo rawurldecode($requesttxtarray['reqcont']) ?></font></b></div> +<br> +<?php +// Check if the user forgot to fill out one of the required variables +if (isset($errorreason)) { + echo '<font color="#FF0000"><strong>' . rawurldecode($requesttxtarray['youdidnt']) . '</strong>'; +} else { + echo '<font size="-1">' . rawurldecode($requesttxtarray['ifyoud']); + ?> <font size="-1"><?php echo rawurldecode($requesttxtarray['beaware']) ?></font><?php +} +?> +</font><br> +<form action="/request/<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" method="post" target="_self"> +<input name="requested" type="hidden" id="requested" value="yes"> +<table width="80%" border="0" cellspacing="15" cellpadding="0"> +<tr> +<td> +<?php +if ($errorreason & NAME) { + echo '<font color="#FF0000"><strong>' . rawurldecode($requesttxtarray['yourname']) . '</strong> (' . rawurldecode($requesttxtarray['required']) . ')'; +} else { + echo '<font size="-1"><strong>' . rawurldecode($requesttxtarray['yourname']) . '</strong></font> <font size="-1" color="#FF0000">(' . rawurldecode($requesttxtarray['required']) . ')'; +} +?> +</font><br> +<input name="name" type="text" id="name" size="40" maxlength="60"<?php if (isset($_POST['name'])) { echo 'value="' . $_POST['name'] . '"'; } ?>> +</font></td></tr> +<tr><td> +<?php +if ($errorreason & EMAIL) { + echo '<font color="#FF0000"><strong>' . rawurldecode($requesttxtarray['youremail']) . '</strong> (' . rawurldecode($requesttxtarray['required']) . ')'; +} else { + echo '<font size="-1"><strong>' . rawurldecode($requesttxtarray['youremail']) . '</strong></font> <font size="-1" color="#FF0000">(' . rawurldecode($requesttxtarray['required']) . ')'; +} +?> +</font><br> +<input name="email" type="text" id="email" size="40" maxlength="80"<?php if (isset($_POST['email'])) { echo 'value="' . $_POST['email'] . '"'; } ?>> +</font></td> +</tr> +<tr> +<td> +<?php +if ($errorreason & LANG) { + echo '<font color="#FF0000"><strong>' . rawurldecode($requesttxtarray['preflang']) . '</strong> (' . rawurldecode($requesttxtarray['required']) . ')'; +} else { + echo '<font size="-1"><strong>' . rawurldecode($requesttxtarray['preflang']) . '</strong></font> <font size="-1" color="#FF0000">(' . rawurldecode($requesttxtarray['required']) . ')'; +} +?> +</font><br> +<input name="lang" type="text" id="lang" size="20" maxlength="30"<?php if (isset($_POST['lang'])) { echo 'value="' . $_POST['lang'] . '"'; } ?>> +</font></td> +</tr> +<tr> +<td> +<?php +if ($errorreason & NATURE) { + echo '<font color="#FF0000"><strong>' . rawurldecode($requesttxtarray['whyrequest']) . '</strong> (' . rawurldecode($requesttxtarray['required']) . ')'; +} else { + echo '<font size="-1"><strong>' . rawurldecode($requesttxtarray['whyrequest']) . '</strong></font> <font size="-1" color="#FF0000">(' . rawurldecode($requesttxtarray['required']) . ')'; +} +?> +</font><br> +<textarea name="nature" cols="50" rows="7" wrap="VIRTUAL" id="nature"><?php if (isset($_POST['nature'])) { echo $_POST['nature']; } ?></textarea> +<br> +</td> +</tr> +<tr> +<td> +<?php +/* +<font size="-1"><strong><?php echo rawurldecode($requesttxtarray['urgencyof']) ?></strong></font> <font size="-1" color="#FF0000">(<?php echo rawurldecode($requesttxtarray['required']) ?>)</font><br> +<select name="urgency" id="urgency"> +<option value="1"<?php if ($_POST['urgency'] == '1') { echo ' selected'; } ?>><?php echo rawurldecode($requesttxtarray['casualint']) ?></option> +<option value="2"<?php if (($_POST['urgency'] == '2') OR empty($_POST['urgency'])) { echo ' selected'; } ?>><?php echo rawurldecode($requesttxtarray['ansnextday']) ?></option> +<option value="3"<?php if ($_POST['urgency'] == '3') { echo ' selected'; } ?>><?php echo rawurldecode($requesttxtarray['anstoday']) ?></option> +<option value="4"<?php if ($_POST['urgency'] == '4') { echo ' selected'; } ?>><?php echo rawurldecode($requesttxtarray['ansasap']) ?></option> +</select> +*/ +?> +</font></td> +</tr> +<tr> +<td><font size="-1"><strong><?php echo rawurldecode($requesttxtarray['compname']) ?></strong><br> +<input name="compname" type="text" id="compname" size="40" maxlength="80"<?php if (isset($_POST['compname'])) { echo 'value="' . $_POST['compname'] . '"'; } ?>> +</font></td> +</tr> +<tr> +<td><font size="-1"><strong><?php echo rawurldecode($requesttxtarray['comploc']) ?></strong><br> +<input name="region" type="text" id="region"<?php if (isset($_POST['region'])) { echo 'value="' . $_POST['region'] . '"'; } ?>> +</font></td> +</tr> +<tr> +<td><font size="-1"><strong><?php echo rawurldecode($requesttxtarray['numpeople']) ?></strong><br> +<select name="people" id="people"> +<option value="1"<?php if ($_POST['people'] == '1') { echo ' selected'; } ?>>1</option> +<option value="5"<?php if ($_POST['people'] == '5') { echo ' selected'; } ?>>2-5</option> +<option value="20"<?php if ($_POST['people'] == '20') { echo ' selected'; } ?>>6-20</option> +<option value="50"<?php if ($_POST['people'] == '50') { echo ' selected'; } ?>>21-50</option> +<option value="200"<?php if ($_POST['people'] == '200') { echo ' selected'; } ?>>51-200</option> +<option value="1000"<?php if ($_POST['people'] == '1000') { echo ' selected'; } ?>>201-1000</option> +<option value="5000"<?php if (($_POST['people'] == '5000') OR empty($_POST['people'])) { echo ' selected'; } ?>>1001-5000</option> +<option value="15000"<?php if ($_POST['people'] == '15000') { echo ' selected'; } ?>>5000-15000</option> +<option value="50000"<?php if ($_POST['people'] == '50000') { echo ' selected'; } ?>>15001-50000</option> +<option value="200000"<?php if ($_POST['people'] == '200000') { echo ' selected'; } ?>>50000-200000</option> +<option value="200001"<?php if ($_POST['people'] == '200001') { echo ' selected'; } ?>>200000+</option> +</select> +</font></td></tr><tr><td><input name="requestbutton" type="submit" id="requestbutton" value="<?php echo rawurldecode($requesttxtarray['sendreq']) ?>"></td></tr></table> +</form> +<br> +</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"> +<tr><td><table width="100%" border="0" cellspacing="1" cellpadding="0"> +<tr><td bgcolor="#FFFFFF"><img src="/images/jpg/road001bottom.jpg" width="600" height="70" border="0"></td> +</tr></table></td></tr></table></td></tr></table> +<?php include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body></html> diff --git a/advocacy/shared/bottommenu.php b/advocacy/shared/bottommenu.php new file mode 100644 index 00000000..81ca3e51 --- /dev/null +++ b/advocacy/shared/bottommenu.php @@ -0,0 +1,15 @@ +<?php + +// Get the text strings for the present page +if (isset($outtxtarray) == FALSE) +{ + $outtxtarray = get_page_text('outmenu', $final_lang); +} + +?> +<tr><td valign="top" align="left" width="50%"><font size="-1"><b><a href="http://<?php echo $serv_name ?>/about<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($outtxtarray['omabout']) ?></a></b><br><?php echo rawurldecode($outtxtarray['omabouttxt']) ?></font></td> +<td align="left" valign="top" width="50%"><font size="-1"><b><a href="http://<?php echo $serv_name ?>/request<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($outtxtarray['omrequest']) ?></a></b><br><?php echo rawurldecode($outtxtarray['omrequesttxt']) ?><br> </font></td></tr> +<tr><td valign="top" align="left" width="50%"><font size="-1"><b><a href="http://<?php echo $serv_name ?>/advantages<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($outtxtarray['omadvantages']) ?></a></b><br><?php echo rawurldecode($outtxtarray['omadvantagestxt']) ?></font><br> </td> +<td align="left" valign="top" width="50%"><font size="-1"><b><a href="http://<?php echo $serv_name ?>/casestudies<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($outtxtarray['omcasestud']) ?></a></b><br><?php echo rawurldecode($outtxtarray['omcasestudtxt']) ?></font></td></tr> +<tr><td valign="top" align="left" width="50%"><font size="-1"><b><a href="http://<?php echo $serv_name ?>/news<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($outtxtarray['omnews']) ?></a></b><br><?php echo rawurldecode($outtxtarray['omnewstxt']) ?></font></td> +<td align="left" valign="top" width="50%"><font size="-1"><b><a href="http://<?php echo $serv_name ?>/join<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($outtxtarray['omjoinus']) ?></a></b><br><?php echo rawurldecode($outtxtarray['omjoinustxt']) ?></font></td></tr>
\ No newline at end of file diff --git a/advocacy/shared/cookiestart.php b/advocacy/shared/cookiestart.php new file mode 100644 index 00000000..e9f2faee --- /dev/null +++ b/advocacy/shared/cookiestart.php @@ -0,0 +1,148 @@ +<? +// Version 2.03 of this page +// Justin Clift, 2002-09-13 + +// Ensure this page isn't generally cached +header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 +header ("Pragma: no-cache"); // HTTP/1.0 + +// Clear variables so the calling program can't maliciously set them. +$cookiedata = ""; +$dbconn = 0; +$dbresult = 0; +$dberrmsg = ""; +$dbnum = 0; +$dbrow = FALSE; +$suggestion = ""; + +// These variables added for the user registration code by Justin Clift, 8th March 2002 +$logged_in = FALSE; +$udbconn = 0; +$udbresult = 0; +$udbfirst_name = ""; +$udblogged_out = ""; +$udblast_used = ""; +$udbipaddr = ""; + +// Need to better sanity check the incoming SiteUser2 variable, at present we're not doing it well enough +if (isset($_COOKIE['SiteUser2'])) { + $suggestion = preg_quote(preg_quote(preg_quote($_COOKIE['SiteUser2'], "'"), '|'), "\\"); + if ($suggestion != $_COOKIE['SiteUser2']) { + // There is something wrong with the SiteUser2 cookie. Probably hacked. Drop it and continue. + unset($SiteUser2); + } else { + $SiteUser2 = $suggestion; + }; +}; + +// Connect to the database in preparation for allocating or authenticating the cookie +$dbconn = pg_pconnect("host=db.svr2.postgresql.org port=5432 dbname=techdocs user=techdocs password=furd0jus"); + +if ($dbconn == FALSE) { + error_page('Database error', 'Database error', 'There was a problem when connecting to the users database.'); + exit; +} else { + // Check if the user has been allocated a SiteUser2 already + if ($SiteUser2 != "") { + // We've been sent a cookie, authenticate it + $dbresult = pg_exec($dbconn, "SELECT userid FROM siteusers WHERE cookie = '$SiteUser2'"); + if ($dbresult == FALSE) { + // Users' SiteUser2 has something wrong with it, set a flag to allocate them a new one + $SiteUser2 = FALSE; + } else { + // Ensure the SiteUser2 really is alright + $dbnum = pg_numrows($dbresult); + if ($dbnum != 1) { + // User's SiteUser2 has something wrong with it, set a flag to allocate them a new one + $SiteUser2 = FALSE; + }; + // The user has a correct SiteUser2, allow them to continue with it and update their lastvisted field + $dbresult = pg_exec($dbconn, "UPDATE siteusers SET lastvisited = timestamp 'now' WHERE cookie = '$SiteUser2'"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Cookie error', 'Cookie error', 'Updating your cookie didn\'t work.'); + exit(); + }; + }; + } else { + // User hasn't been allocated a SiteUser2 before, set a flag to allocate them one + $SiteUser2 = FALSE; + }; + + if ($SiteUser2 == FALSE) { + // Seed the random number generator + mt_srand ((double) microtime() * 1000000); + + // Loop until the user has a unique cookie + $dbresult = FALSE; + $uniqCookie = FALSE; + while ($uniqCookie == FALSE) { + + // The user doesn't seem to have been here before, generate a cookie, insert it into the database, send it to the user + $cookiedata = mt_rand(105892104, 2146012148); + + // Check if the cookie is unique + $dbresult = pg_exec($dbconn, "SELECT userid FROM siteusers WHERE cookie = '$cookiedata'"); + + if ($dbresult == FALSE) { // Check if an error occured + + // Something went wrong connecting to the database. Abort and notify the client + error_page('Cookie error', 'Cookie error', 'Checking the uniqueness of your Cookie didn\'t work.'); + exit(); + + }; + if (pg_numrows($dbresult) == 0) { + $dbresult = pg_exec($dbconn, "INSERT INTO siteusers (cookie, firstvisited) VALUES ('{$cookiedata}', now())"); + if ($dbresult == FALSE) { + // Something went wrong connecting to the database. Abort and notify the client + error_page('Cookie error', 'Cookie error', 'Inserting a new cookie into the database for you didn\'t work.'); + exit(); + }; + // Send the cookie to the user and continue on + setcookie ("SiteUser2", "$cookiedata", time()+220898483, "/", "postgresql.org"); + $uniqCookie = TRUE; + }; + }; + }; +}; + +// ** The user has a SiteUser2 cookie, so now we should check if they're in the users database and logged in ** + +// Connect to the Users database +$udbconn = pg_pconnect("host=db.svr2.postgresql.org port=5432 dbname=users user=techdocs password=furd0jus"); + +if ($udbconn == FALSE) { + // There was an error in doing the select on the database, so generate an error then exit + error_page('Database error', 'Database error', 'There was a problem when querying the users database.'); + exit; +} + +// Find out if the user exists in the users database +$udbresult = pg_exec($udbconn, "SELECT idnum, first_name FROM users WHERE cookie = '$SiteUser2' AND last_used >= now() - '{$login_timeout} minutes'::interval AND ipaddr = '{$_SERVER['REMOTE_ADDR']}' AND logged_out = 'f'"); + +if ($udbresult == FALSE) { + // There was an error in doing the select on the database, so generate an error then exit + error_page('Database error', 'Database error', 'There was a problem when querying the users database.'); + exit; +} + + $udbrows = pg_numrows($udbresult); + if ($udbrows == 1) { + + // Assign the returned values to variables + $udbidnum = pg_result($udbresult, 0, 'idnum'); + $udbfirst_name = pg_result($udbresult, 0, 'first_name'); + + // User is still logged in, so update the last_used entry in the users database + $udbresult = pg_exec("UPDATE users SET last_used = now() WHERE idnum = $udbidnum"); + if ($udbresult == FALSE) { + // There was an error when updating the database, so generate an error then exit + error_page('Database error', 'Database error', 'There was a problem when updating the users database.'); + exit; + } + $logged_in = TRUE; + } else { + // User is logged out + $logged_in = FALSE; + } +?> diff --git a/advocacy/shared/copyrightnotice.php b/advocacy/shared/copyrightnotice.php new file mode 100644 index 00000000..ee5d9964 --- /dev/null +++ b/advocacy/shared/copyrightnotice.php @@ -0,0 +1,12 @@ +<?php + +// Get the text strings for the present page +if (isset($logotxtarray) == FALSE) +{ + global $logotxtarray; + $logotxtarray = get_page_text('logostrip', $final_lang); +} +?> +<div align="center"><? include $globalroot . 'shared/pgsqlcopyright.php' ?><br> +<font size="-2" color="#999999"><?php echo rawurldecode($logotxtarray['someimages']) ?> © 2001-2002 <a href="http://www.arttoday.com" target="_blank">www.arttoday.com</a><br> +<a href="/privacy<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><?php echo rawurldecode($logotxtarray['privacypolicy']) ?></a> <a href="mailto:justin@postgresql.org"><?php echo rawurldecode($logotxtarray['contactus']) ?></a></font></div>
\ No newline at end of file diff --git a/advocacy/shared/entrybreak.php b/advocacy/shared/entrybreak.php new file mode 100644 index 00000000..7ecd2035 --- /dev/null +++ b/advocacy/shared/entrybreak.php @@ -0,0 +1 @@ +</td></tr><tr><td bgcolor="FFFFFF">
\ No newline at end of file diff --git a/advocacy/shared/entryend.php b/advocacy/shared/entryend.php new file mode 100644 index 00000000..27e7356e --- /dev/null +++ b/advocacy/shared/entryend.php @@ -0,0 +1 @@ +</td></tr></table></td></tr></table>
\ No newline at end of file diff --git a/advocacy/shared/entrystart.php b/advocacy/shared/entrystart.php new file mode 100644 index 00000000..2d8c1598 --- /dev/null +++ b/advocacy/shared/entrystart.php @@ -0,0 +1 @@ +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="000000" align="center"><tr><td><table border="0" cellspacing="1" cellpadding="3" width="100%"><tr><td colspan="1" bgcolor="CDDDEB">
\ No newline at end of file diff --git a/advocacy/shared/global.php b/advocacy/shared/global.php new file mode 100644 index 00000000..d2ca1ecf --- /dev/null +++ b/advocacy/shared/global.php @@ -0,0 +1,311 @@ +<?php + +// Define the global contants that can be altered and have a sitewide affect +global $globalroot, $localroot, $final_lang, $serv_prot, $serv_name; + +// Set the global constants +# $globalroot = '/usr/local/www/'; +$globalroot = '/usr/local/skunkworks/htdocs/cvs/advmess/advocacy/'; +$localroot = $globalroot; +$login_timeout = 30; // This is in minutes +$maxlength_password = 12; +$maxlength_pwprompt = 80; +$maxlength_fname = 24; +$maxlength_lname = 24; +$maxlength_phone = 20; +$maxlength_street = 60; +$maxlength_city = 40; +$maxlength_state = 20; +$maxlength_pcode = 10; +$maxlength_country = 3; +$maxlength_email = 60; +$maxlength_emailtoken = 10; +$maxlength_display = 4; +$maxlength_memperiod = 5; +$max_wronglogins = 5; +$password_lockout_hrs = 12; +$webmaster = "webmaster@postgresql.org"; + +// ** Determine if this is a HTTP or HTTPS request, then set the $serv_prot variable ** +if ($_SERVER['SERVER_PORT'] == 443) { + $serv_prot = 'https'; +} else { + $serv_prot = 'http'; +}; + +// ** Set the server name ** +$serv_name = $_SERVER['SERVER_NAME']; + +// ** Global functions that can be altered, and have a sitewide affect ** + +// Contributed by Dave Page, 28th January 2002. Updated and fixed by Justin Clift, 4th March 2002 +function verify_email($Address) { + // Check the email address structure + // Returns 0 if the email is correctly structured and has a valid MX record + // Returns 1 if incorrectly structured (i.e. invalid and could never work) + // Returns 2 if it seems alright but there is no valid dns entry + + if (eregi("^([-!#\$%&'*+./0-9=?A-Z^_`a-z{|}~])+@([-!#\$%&'*+/0-9=?A-Z^_`a-z{|}~ ]+\\.)+[a-zA-Z]{2,4}\$", $Address) == 0) + { + return 1; + } + + // Get the user/domain + $User = strtok($Address,"@"); + $Domain = strtok("") . "."; + + // Check for the domain MX records + if (getmxrr($Domain, $Servers)) { + return 0; + } + + // No MX record, so maybe it's a host + if (gethostbyname($Domain) == $Domain) { + return 2; + } else { + return 0; + } +} + + +/* Function to get all of the text strings for a page (taking into account + the correct language for display) from a database and return them as an + array. + Written by : Justin Clift, 29th June 2002 + Version : 1.00 +*/ +function get_page_text($pagename, $pagelang) { + global $dbconn; + + $pg_result = pg_exec($dbconn, "SELECT strname, strtext FROM textstrings WHERE page = '{$pagename}' AND lang = '{$pagelang}'"); + if ($pg_result == FALSE) { + /* Something went wrong connecting to the database. Abort and notify the client */ + error_page('Database Error', 'Database Error', 'ERRWEB01 : Error in connecting to the database.'); + exit(); + }; + + // Put the pages' text strings into an array + unset($gpttxtarray); + $pgnumtxt = pg_num_rows($pg_result); + for ($i = 0; $i < $pgnumtxt; $i++) { + $strname = pg_fetch_result($pg_result, $i, 'strname'); + $strtext = pg_fetch_result($pg_result, $i, 'strtext'); + $gpttxtarray["$strname"] = "$strtext"; + } + + // Return the array to the user + return $gpttxtarray; +} + + +/* Need to update the error_page function to be multi-lingual */ +function error_page($title, $heading, $messagea, $messageb = "Please <a href=\"mailto:xzilla@users.sourceforge.net\">email the webmaster</a> <xzilla@users.sourceforge.net>, and let us know the error message.", $lang = 'en') { + global $logged_in, $siteroot, $login_timeout, $maxlength_password, $maxlength_pwprompt, $maxlength_fname; + global $maxlength_lname, $webmaster, $globalroot, $localroot, $maxlength_city, $maxlength_state; + global $maxlength_country, $maxlength_email, $maxlength_street, $maxlength_emailtoken, $maxlength_display; + global $maxlength_memperiod, $logotxtarray, $serv_prot, $serv_name; + +$doc_encoding = 'iso-8859-1'; +switch ($lang) { + case 'br': + $lang_override = TRUE; + $final_lang = 'br'; + break; + case 'de': + $lang_override = TRUE; + $final_lang = 'de'; + break; + case 'en': + $final_lang = 'en'; + break; + case 'es': + $lang_override = TRUE; + $final_lang = 'es'; + break; + case 'fr': + $lang_override = TRUE; + $final_lang = 'fr'; + break; + case 'it': + $lang_override = TRUE; + $final_lang = 'it'; + break; + case 'pl': + $lang_override = TRUE; + $final_lang = 'pl'; + $doc_encoding = 'windows-1250'; + break; + case 'pt': + $lang_override = TRUE; + $final_lang = 'pt'; + break; + case 'ro': + $lang_override = TRUE; + $final_lang = 'ro'; + $doc_encoding = 'iso-8859-2'; + break; + case 'tr': + $lang_override = TRUE; + $final_lang = 'tr'; + $doc_encoding = 'iso-8859-9'; + break; + case 'hu': + $lang_override = TRUE; + $final_lang = 'hu'; + $doc_encoding = 'iso-8859-2'; + break; + default: + $final_lang = 'en'; +} +?> +<html><head><title><?php echo $title ?></title> +<meta http-equiv="Content-Type" content="text/html; charset=<? echo $doc_encoding ?>"> +<meta name="keywords" content="<?php echo rawurldecode($logotxtarray['keywords']) ?>"> +</head> + +<body bgcolor="#FFFFFF" text="#000000"><center> +<?php include $localroot . 'shared/pageheader.php' ?> +<table width="600" border="0" cellspacing="1" cellpadding="0"><tr><td colspan="2" valign="top"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"><tr><td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/spikything001top.jpg" width="600" height="90" border="0"></td></tr></table> +</td></tr></table></td></tr><tr><td colspan="2"> +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="#000000"><tr><td> +<table border="0" cellspacing="1" cellpadding="0" width="100%"><tr> +<td bgcolor="#FFFFFF" valign="middle" align="center"> +<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center"><tr> +<td valign="middle" align="left"><br> +<div align="center"><b><font size="+1"><?php echo $heading ?></font></b></div> +<br><div align="center"><table border="0" width="80%" cellpadding="10" cellspacing="0"> +<tr><td><?php echo $messagea ?></td></tr> +<tr><td><?php echo $messageb ?></td></tr></table></div><br> +</td></tr></table> +</td></tr></table> +</td></tr></table> +</td></tr><tr><td colspan="2"> +<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000"><tr><td> +<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr> +<td bgcolor="#FFFFFF"><img src="/images/jpg/spikything001bottom.jpg" width="600" height="90" border="0"></td></tr></table> +</td></tr></table> +</td></tr></table> +<?php include $localroot . 'shared/pagecopyright.php' ?> +</center> +</body> +</html> +<?php +} + +include_once($globalroot . 'shared/cookiestart.php'); + +// For now (while doing initial development) assume the language to be displayed is English +if ($logged_in == TRUE) { + $final_lang = 'en'; +} else { + $final_lang = 'en'; +} + +// Determine if the user is overriding the language they want to view things in +$doc_encoding = 'iso-8859-1'; +if (isset($_POST['lang']) OR isset($_GET['lang'])) { + $lang_override = TRUE; + if (isset($_GET['lang'])) { + switch ($_GET['lang']) { + case 'br': + $final_lang = 'br'; + break; + case 'de': + $final_lang = 'de'; + break; + case 'en': + $final_lang = 'en'; + break; + case 'es': + $final_lang = 'es'; + break; + case 'fr': + $final_lang = 'fr'; + break; + case 'it': + $final_lang = 'it'; + break; + case 'nl': + $final_lang = 'nl'; + $doc_encoding = 'iso-8859-15'; + break; + case 'pl': + $final_lang = 'pl'; + $doc_encoding = 'windows-1250'; + break; + case 'pt': + $final_lang = 'pt'; + break; + case 'ro': + $final_lang = 'ro'; + $doc_encoding = 'iso-8859-2'; + break; + case 'hu': + $final_lang = 'hu'; + $doc_encoding = 'iso-8859-2'; + break; + case 'sv': + $final_lang = 'sv'; + break; + case 'tr': + $final_lang = 'tr'; + $doc_encoding = 'iso-8859-9'; + break; + default: + $final_lang = 'en'; + } + } else { + switch ($_POST['lang']) { + case 'br': + $final_lang = 'br'; + break; + case 'de': + $final_lang = 'de'; + break; + case 'en': + $final_lang = 'en'; + break; + case 'es': + $final_lang = 'es'; + break; + case 'fr': + $final_lang = 'fr'; + break; + case 'it': + $final_lang = 'it'; + break; + case 'nl': + $final_lang = 'nl'; + $doc_encoding = 'iso-8859-15'; + break; + case 'pl': + $final_lang = 'pl'; + $doc_encoding = 'windows-1250'; + break; + case 'pt': + $final_lang = 'pt'; + break; + case 'ro': + $final_lang = 'ro'; + $doc_encoding = 'iso-8859-2'; + break; + case 'hu': + $final_lang = 'hu'; + $doc_encoding = 'iso-8859-2'; + break; + case 'sv': + $final_lang = 'sv'; + break; + case 'tr': + $final_lang = 'tr'; + $doc_encoding = 'iso-8859-9'; + break; + default: + $final_lang = 'en'; + } + } +} +?> diff --git a/advocacy/shared/header.php b/advocacy/shared/header.php new file mode 100644 index 00000000..d9b11aea --- /dev/null +++ b/advocacy/shared/header.php @@ -0,0 +1 @@ +<meta content="text/html; charset=windows-1252" http-equiv=Content-Type><meta name="keywords" content="postgresql, advocacy, marketing, open source, database, sql, community, justin, clift">
\ No newline at end of file diff --git a/advocacy/shared/headingend.php b/advocacy/shared/headingend.php new file mode 100644 index 00000000..27e7356e --- /dev/null +++ b/advocacy/shared/headingend.php @@ -0,0 +1 @@ +</td></tr></table></td></tr></table>
\ No newline at end of file diff --git a/advocacy/shared/headingstart.php b/advocacy/shared/headingstart.php new file mode 100644 index 00000000..5e0236ad --- /dev/null +++ b/advocacy/shared/headingstart.php @@ -0,0 +1 @@ +<table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="000000" align="center"><tr><td><table border="0" cellspacing="1" cellpadding="3" width="100%"><tr><td bgcolor="FFFFFF">
\ No newline at end of file diff --git a/advocacy/shared/index.php b/advocacy/shared/index.php new file mode 100644 index 00000000..4d56b91e --- /dev/null +++ b/advocacy/shared/index.php @@ -0,0 +1,5 @@ +<html><head> +<meta http-equiv="REFRESH" content="3; url=/index.php"> +<title>PostgreSQL - The worlds most advanced Open Source database</title></head> + +<body bgcolor="#FFFFFF"><div align="center">Sorry, this page doesn't exist so you're now being automatically redirected to the <a href="/" target="_self">main page</a>.<br>Please click on the link if this page doesn't automatically go there.</div></body></html>
\ No newline at end of file diff --git a/advocacy/shared/latestnews.php b/advocacy/shared/latestnews.php new file mode 100644 index 00000000..ae0b37c9 --- /dev/null +++ b/advocacy/shared/latestnews.php @@ -0,0 +1,40 @@ +<?php +// Get the text strings for the present page +if (isset($newstxtarray) == FALSE) +{ + $newstxtarray = get_page_text('news', $final_lang); +} +// Display the third news element if it exists +if (isset($newstxtarray['nwthirddate'])) { + echo '<tr><td align="left" valign="top"><u><font size="-1"><a href="http://' . $serv_name . '/news/2002112801'; + if ($lang_override) { + echo '?lang=' . $final_lang; + } + echo '" target="_self">' . rawurldecode($newstxtarray['nwthirddate']) . '</a></font></u><br>'; + echo '<font size="-1"> ' . rawurldecode($newstxtarray['nwthirddatetext']) . '</font></td></tr>'; +} + +// Display the first news element if it exists +if (isset($newstxtarray['nwfirstdate'])) { + echo '<tr><td align="left" valign="top"><u><font size="-1"><a href="http://' . $serv_name . '/news/2002100102'; + if ($lang_override) { + echo '?lang=' . $final_lang; + } + echo '" target="_self">' . rawurldecode($newstxtarray['nwfirstdate']) . '</a></font></u><br>'; + echo '<font size="-1"> ' . rawurldecode($newstxtarray['nwfirstdatetext']) . '</font></td></tr>'; +} + +// Display the second news element if it exists +if (isset($newstxtarray['nwseconddate'])) { + echo '<tr><td align="left" valign="top"><u><font size="-1"><a href="http://' . $serv_name . '/news/2002100101'; + if ($lang_override) { + echo '?lang=' . $final_lang; + } + echo '" target="_self">' . rawurldecode($newstxtarray['nwseconddate']) . '</a></font></u><br>'; + echo '<font size="-1"> ' . rawurldecode($newstxtarray['nwseconddatetext']) . '</font></td></tr>'; +} + + +// Display the appropriate amount of padding for this language +echo '<tr><td>' . rawurldecode($newstxtarray['nwpadding']) . '</td></tr>'; +?> diff --git a/advocacy/shared/logostrip.php b/advocacy/shared/logostrip.php new file mode 100644 index 00000000..728ac6a8 --- /dev/null +++ b/advocacy/shared/logostrip.php @@ -0,0 +1,11 @@ +<?php + +// Get the text strings for the present page +global $logotxtarray; +$logotxtarray = get_page_text('logostrip', $final_lang); + +?> +<table border="0" cellspacing="1" cellpadding="0" width="600" bgcolor="#FFFFFF" align="center"><tr> +<td valign="bottom" align="left"><div align="left"><img src="/images/gif/pgsqlicon2.gif" width="23" height="18"></div></td> +<td valign="bottom" align="right"><div align="right"><font color="#10006B" size="-1"><?php echo rawurldecode($logotxtarray['logotext']) ?></font></div> +</td></tr></table>
\ No newline at end of file diff --git a/advocacy/shared/menubar.php b/advocacy/shared/menubar.php new file mode 100644 index 00000000..503b068f --- /dev/null +++ b/advocacy/shared/menubar.php @@ -0,0 +1,31 @@ +<?php +// Define the global variables begun in this page +global $menutxtarray; + +// Get the text strings for the present page +if (isset($menutxtarray) == FALSE) { + $menutxtarray = get_page_text('menubar', $final_lang); +} + +// Check if the user is logged in or not, and display the appropriate menu +/* if ($logged_in == TRUE) { */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="https://<?php echo $serv_name ?>/accounts/logout<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['logout']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="https://<?php echo $serv_name ?>/olc<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['learningcenter']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="https://<?php echo $serv_name ?>/olc/home<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['home']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="https://<?php echo $serv_name ?>/accounts/editprofile<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['account']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/support<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['support']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/about<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['aboutus']) ?></font></a></td> */ ?> + +<?php /* } else { */ ?> +<td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['home']) ?></font></a></td> +<td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/about<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['aboutus']) ?></font></a></td> +<td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/request<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['request']) ?></font></a></td> +<td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/advantages<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['advantages']) ?></font></a></td> +<td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/casestudies<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['casestud']) ?></font></a></td> +<td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/join<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['joinus']) ?></font></a></td> +<td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/news<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['news']) ?></font></a></td> +<?php /* <td align="center" bgcolor="#10006B"><a href="https://<?php echo $serv_name ?>/accounts/join<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['join']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="https://<?php echo $serv_name ?>/accounts/login<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['login']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/about/courses<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['courselist']) ?></font></a></td> */ ?> +<?php /* <td align="center" bgcolor="#10006B"><a href="http://<?php echo $serv_name ?>/support<?php if ($lang_override) { echo "?lang={$final_lang}"; } ?>" target="_self"><font size="-1" color="#FFFFFF"><?php echo rawurldecode($menutxtarray['support']) ?></font></a></td> */ ?> +<?php /* } */ ?>
\ No newline at end of file diff --git a/advocacy/shared/pagecopyright.php b/advocacy/shared/pagecopyright.php new file mode 100644 index 00000000..7c168018 --- /dev/null +++ b/advocacy/shared/pagecopyright.php @@ -0,0 +1,3 @@ +<table width="600" border="0" cellspacing="5" cellpadding="0" align="center"><tr><td> +<?php include $globalroot . "shared/copyrightnotice.php" ?> +</td></tr></table>
\ No newline at end of file diff --git a/advocacy/shared/pageheader.php b/advocacy/shared/pageheader.php new file mode 100644 index 00000000..49a34546 --- /dev/null +++ b/advocacy/shared/pageheader.php @@ -0,0 +1,19 @@ +<?php include $globalroot . "shared/logostrip.php" ?> +<table width="602" border="0" cellspacing="0" cellpadding="1" bgcolor="#10006B" align="center"><tr valign="middle"> +<td align="center" bgcolor="#10006B"><a href="?lang=de" target="_self"><font size="-1" color="#FFFFFF">Auf Deutsch</font></a></td> +<td align="center" bgcolor="#10006B"><a href="?lang=en" target="_self"><font size="-1" color="#FFFFFF">In English</font></a></td> +<td align="center" bgcolor="#10006B"><a href="?lang=es" target="_self"><font size="-1" color="#FFFFFF">En Español</font></a></td> +<td align="center" bgcolor="#10006B"><a href="?lang=fr" target="_self"><font size="-1" color="#FFFFFF">En Français</font></a></td> +</tr><tr> +<td align="center" bgcolor="#10006B"><a href="?lang=it" target="_self"><font size="-1" color="#FFFFFF">In Italiano</font></a></td> +<td align="center" bgcolor="#10006B"><a href="?lang=br" target="_self"><font size="-1" color="#FFFFFF">Em Português</font></a></td> +<td align="center" bgcolor="#10006B"><a href="?lang=ro" target="_self"><font size="-1" color="#FFFFFF">În Românã</font></a></td> +<td align="center" bgcolor="#10006B"><a href="?lang=sv" target="_self"><font size="-1" color="#FFFFFF">På svenska</font></a></td> +<td align="center" bgcolor="#10006B"><a href="?lang=tr" target="_self"><font size="-1" color="#FFFFFF">In Turkish</font></a></td> +</tr></table> +<table width="602" border="0" cellspacing="0" cellpadding="1" bgcolor="#FFFFFF" align="center"> +<tr valign="middle"><td></td></tr></table> +<table width="602" border="0" cellspacing="0" cellpadding="1" bgcolor="#10006B" align="center"> +<tr valign="middle"> +<?php include $localroot . "shared/menubar.php" ?> +</tr></table>
\ No newline at end of file diff --git a/advocacy/shared/pgsqlcopyright.php b/advocacy/shared/pgsqlcopyright.php new file mode 100644 index 00000000..a6234632 --- /dev/null +++ b/advocacy/shared/pgsqlcopyright.php @@ -0,0 +1,12 @@ +<?php + +// Get the text strings for the present page +if (isset($logotxtarray) == FALSE) +{ + $logotxtarray = get_page_text('logostrip', $final_lang); +} + + +// Display the copyright limitations for people wanting to copy sections of the site +echo '<font size="-2" color="#999999">' . rawurldecode($logotxtarray['allrights']) . '</font>'; +?>
\ No newline at end of file diff --git a/advocacy/shared/titleend.php b/advocacy/shared/titleend.php new file mode 100644 index 00000000..27e7356e --- /dev/null +++ b/advocacy/shared/titleend.php @@ -0,0 +1 @@ +</td></tr></table></td></tr></table>
\ No newline at end of file diff --git a/advocacy/shared/titlestart.php b/advocacy/shared/titlestart.php new file mode 100644 index 00000000..90857ecd --- /dev/null +++ b/advocacy/shared/titlestart.php @@ -0,0 +1,2 @@ +<table border="0" cellspacing="0" cellpadding="0" width="98%" bgcolor="000000" align="center"><tr><td> +<table border="0" cellspacing="1" cellpadding="3" width="100%"><tr><td colspan="1" bgcolor="CDDDEB">
\ No newline at end of file |
