public inbox for [email protected]help / color / mirror / Atom feed
Software catalog section improvements 4+ messages / 2 participants [nested] [flat]
* Software catalog section improvements @ 2008-06-16 18:01 Greg Sabino Mullane <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Greg Sabino Mullane @ 2008-06-16 18:01 UTC (permalink / raw) To: pgsql-www -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 On the new Software Catalog er..."Catalogue" page, how does one edit an existing entry? There is no contact email to do so. While I know I can just bug Dave on this list, the public should be told an email address. I messed up entering "Spree", it should be under Applications and has an open source, not a commercial license. Also, it might be nice if the "Procedural Languages" section mentioned that the builtin languages that are already available, lest people stumble across this page and not be aware that C, plpgsql, perl, python, and tcl are all available in core. -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkhWqjIACgkQvJuQZxSWSsgXhgCg51OjCUPY1fttXRmb4n29nV2j A0oAoLRpstXCwvaqk/JtxG46kBucLXbT =OBPg -----END PGP SIGNATURE----- ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Software catalog section improvements @ 2008-06-17 07:56 Dave Page <[email protected]> parent: Greg Sabino Mullane <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Dave Page @ 2008-06-17 07:56 UTC (permalink / raw) To: Greg Sabino Mullane <[email protected]>; +Cc: pgsql-www On Mon, Jun 16, 2008 at 7:01 PM, Greg Sabino Mullane <[email protected]> wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: RIPEMD160 > > > On the new Software Catalog er..."Catalogue" page, how does > one edit an existing entry? There is no contact email to > do so. While I know I can just bug Dave on this list, the > public should be told an email address. Most people will simply email webmaster@ no? We don't list a contact address on any other forms on the site that I can see. > I messed up entering "Spree", it should be under Applications > and has an open source, not a commercial license. Fixed. > Also, it might be nice if the "Procedural Languages" section > mentioned that the builtin languages that are already available, > lest people stumble across this page and not be aware that > C, plpgsql, perl, python, and tcl are all available in core. There's no code for including additional text on each category at present. We can either add that (noting that the admin interface for categories is a highly advanced SQL based one) - patches welcome - or add those languages to the list with a note saying they're in the core product. Or consider it a non-issue. Thoughts? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Software catalog section improvements @ 2008-06-17 23:29 Greg Sabino Mullane <[email protected]> parent: Dave Page <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Greg Sabino Mullane @ 2008-06-17 23:29 UTC (permalink / raw) To: pgsql-www -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 >> On the new Software Catalog er..."Catalogue" page, how does >> one edit an existing entry? There is no contact email to >> do so. While I know I can just bug Dave on this list, the >> public should be told an email address. > Most people will simply email webmaster@ no? We don't list a contact > address on any other forms on the site that I can see. I think there should be an email on all the form pages, or at the last on a clearly marked contact page. >> I messed up entering "Spree", it should be under Applications >> and has an open source, not a commercial license. > Fixed. Thanks! >> Also, it might be nice if the "Procedural Languages" section >> mentioned that the builtin languages that are already available, >> lest people stumble across this page and not be aware that >> C, plpgsql, perl, python, and tcl are all available in core. > There's no code for including additional text on each category at > present. We can either add that (noting that the admin interface for > categories is a highly advanced SQL based one) - patches welcome - or > add those languages to the list with a note saying they're in the core > product. Or consider it a non-issue. I'll take "Patches" for $100, Alex. Index: portal/tools/add_products_blurb.sql =================================================================== - --- portal/tools/add_products_blurb.sql (revision 0) +++ portal/tools/add_products_blurb.sql (revision 0) @@ -0,0 +1,15 @@ +BEGIN; + +ALTER TABLE product_categories ADD blurb TEXT NOT NULL DEFAULT ''; + +UPDATE product_categories SET blurb = +$$Note: Postgres has four languages that are part of the core distribution: +<a href="http://www.postgresql.org/docs/current/interactive/plpgsql.html">PL/pgSQL</a;, +<a href="http://www.postgresql.org/docs/current/interactive/pltcl.html">PL/Tcl</a;, +<a href="http://www.postgresql.org/docs/current/interactive/plperl.html">PL/Perl</a;, +and +<a href="http://www.postgresql.org/docs/current/interactive/plpython.html">PL/Python</a;. +$$ +WHERE name = 'Procedural languages'; + +COMMIT; Index: portal/system/page/products.php =================================================================== - --- portal/system/page/products.php (revision 2127) +++ portal/system/page/products.php (working copy) @@ -13,15 +13,17 @@ throw new Exception(gettext('Category ID not specified')); } - - $rs = $this->pg_query_params('SELECT name AS category FROM product_categories WHERE id=$1', array(intval($_GET['id']))); + $rs = $this->pg_query_params('SELECT name AS cateogory, blurb FROM product_categories WHERE id=$1', array(intval($_GET['id']))); if (pg_num_rows($rs) == 0) { header('HTTP/1.0 404 Not found'); throw new Exception (gettext('The specified category does not exist')); } - - $category = pg_fetch_result($rs, 0, 0); + $category = pg_fetch_result($rs, 0, 0); + $blurb = pg_fetch_result($rs, 0, 1); $this->tpl->setVariable('category_title', $category); $this->tpl->setVariable('category_header', $category); + $this->tpl->setVariable('category_blurb', $blurb); // Products $rs = $this->pg_query_params( Index: portal/template/download/products.html =================================================================== - --- portal/template/download/products.html (revision 2127) +++ portal/template/download/products.html (working copy) @@ -4,7 +4,7 @@ <h1>Software Catalogue - {category_header}</h1> - -<p>{product_count} product(s) were found in this category.</p> +<p>{product_count} product(s) were found in this category. {category_blurb}</p> <!-- BEGIN product-loop --> - -- Greg Sabino Mullane [email protected] PGP Key: 0x14964AC8 200806171927 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkhYSG4ACgkQvJuQZxSWSsjhTACfa/8YKO7uWoYGDrc06+sPWIrC QNIAoI1HrWcfKaW1TsKH601t+VECcabv =+huP -----END PGP SIGNATURE----- ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Software catalog section improvements @ 2008-06-18 09:07 Dave Page <[email protected]> parent: Greg Sabino Mullane <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Dave Page @ 2008-06-18 09:07 UTC (permalink / raw) To: Greg Sabino Mullane <[email protected]>; +Cc: pgsql-www On Wed, Jun 18, 2008 at 12:29 AM, Greg Sabino Mullane <[email protected]> wrote: > >> Most people will simply email webmaster@ no? We don't list a contact >> address on any other forms on the site that I can see. > > I think there should be an email on all the form pages, or at the > last on a clearly marked contact page. Patches welcome :-) (well, it worked once, you can't blame a guy for trying again!) > I'll take "Patches" for $100, Alex. Hah - bet you feel all dirty after playing in PHP! Thanks, patch applied. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-06-18 09:07 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-06-16 18:01 Software catalog section improvements Greg Sabino Mullane <[email protected]> 2008-06-17 07:56 ` Dave Page <[email protected]> 2008-06-17 23:29 ` Greg Sabino Mullane <[email protected]> 2008-06-18 09:07 ` Dave Page <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox