X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 493483A566D for ; Tue, 16 Nov 2004 05:45:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87615-03 for ; Tue, 16 Nov 2004 05:45:21 +0000 (GMT) Received: from minbar.tinysofa.org (rememberthemilk.com [209.59.132.142]) by svr1.postgresql.org (Postfix) with ESMTP id D3F793A5669 for ; Tue, 16 Nov 2004 05:45:21 +0000 (GMT) Received: from localhost (minbar.tinysofa.org [127.0.0.1]) by minbar.tinysofa.org (Postfix) with ESMTP id D3B373440FD for ; Tue, 16 Nov 2004 00:45:19 -0500 (EST) Received: from minbar.tinysofa.org ([127.0.0.1]) by localhost (minbar.tinysofa.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23648-07 for ; Tue, 16 Nov 2004 00:45:17 -0500 (EST) Received: from [131.229.165.128] (unknown [131.229.165.128]) by minbar.tinysofa.org (Postfix) with ESMTP id E4DA93440EC for ; Tue, 16 Nov 2004 00:45:16 -0500 (EST) Message-ID: <419993F4.60609@tinysofa.org> Date: Tue, 16 Nov 2004 00:45:24 -0500 From: Omar Kilani User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-www@postgresql.org Subject: [PATCH] Events Reorganization X-Enigmail-Version: 0.89.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at rememberthemilk.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/216 X-Sequence-Number: 5947 Hello, Patches and table dumps pertinent to this email are at: http://postgresql.tinysofa.com/files/patches/01-event/ Database Dumps ============== 000-events.dump --------------- Dump of 'events' table, with: * New field additions: city, state, country. * All entries assigned a city, state (if applicable) and country. * All entries with proper start and end dates. 001-events_text.dump -------------------- Dump of 'events_text' table, with: * Entries edited to remove redundant information addressed by above changes to 'events'. * Any translations found in archived entries has been properly inserted as a translation (see our pgweb, go to the events archive, and switch to "Turkish" to see some of Devrim's entries translated.) 002-countries.dump ------------------ Dump of new 'countries' (note: plural names for tables are bad) table, with: * Fields: id, country, tld * Information is taken from the CIA World Facts book. Patches ======= 01-pgweb-ts-events-admin-template.patch --------------------------------------- * Change the events output in the admin system to show location. 02-pgweb-ts-events-admin.patch ------------------------------ * Change the events edit screen to allow entry of city, state and country. * Add templating function 'format_location' to... format location. 03-pgweb-ts-events-system.patch ------------------------------- * Change user event submission form to feature city, state and country. * Add 'fetch_countries_list' to database functions. * Provide a 'location' template variable to the events templates. 04-pgweb-ts-events-template.patch --------------------------------- * Change event-related templates to show a "Location". * Fix event detail screen to show proper posted_by. Omar