December 2005 - Development - lists.drupal.org

Re: [development] auto_increment
by Joe Murray 13 Dec '05

13 Dec '05

I confirm for the MySQL part, this is the way I would do it. Joe Murray, PhD President, JMA Consulting 57 Grandview Ave, Toronto, Ontario, Canada M4K 1J1 416.466.1281, 416.466.1277 (f) joe.murray(a)jmaconsulting.biz Skype: josephpmurray Message: 11 Date: Tue, 13 Dec 2005 09:09:22 -0600 From: "Nicolas Tostin" <nicolast(a)logis.com.mx> Subject: Re: [development] auto_increment To: <development(a)drupal.org> Message-ID: <005c01c5fff7$33a82630$b400a8c0@Nikko> Content-Type: text/plain; charset="iso-8859-1" > You can get a sequence just inserted. This also can be done with > PostgreSQL, and probably Oracle. Don't know about MSSQL. > > I confirm for the Oracle part, this is the way I would do this.

1 0

Drupal 4.6.5 and 4.5.7 released
by Dries Buytaert 13 Dec '05

13 Dec '05

Hello world, the Drupal project has released version 4.6.5 and 4.5.7 of its open- source content management platform. These are not security releases but regular maintenance releases that fix problems reported using the bug tracking system. Details at http://drupal.org/drupal-4.6.5. Thanks and rock on! :) -- Dries Buytaert :: http://www.buytaert.net/

1 0

CVS log mailings down?
by Syscrusher 13 Dec '05

13 Dec '05

Is the drupal-cvs list down, or is it just me? I'm getting mail normally from development(a)drupal.org, but nothing all day from the CVS list. I know there have been commits today, because I've done a few myself. I went to the list subscription page, and tried to resubscribe myself (in case it had somehow unsubscribed me), but I got a privacy notice from Mailman to let me know I was already subscribed. This proves that (1) I've not been unsubscribed, and (2) Mailman is not having trouble getting mail to my server. I tried to check the archives for today to see if there really were no messages, but there are apparently no December 2005 archives, either. Anyone else having problems? Scott -- ------------------------------------------------------------------------------- Scott Courtney Drupal user name: "syscrusher" http://drupal.org/user/9184 scott at 4th dot com Drupal projects: http://drupal.org/project/user/9184 Sandbox: http://cvs.drupal.org/viewcvs/drupal/contributions/sandbox/syscrusher

3 2

language used by the update process
by Gabor Hojtsy 12 Dec '05

12 Dec '05

Hi, I am on testing out the 4.5 -> 4.7 update path on the drupal.hu database (yes, we are going to span this route). I have found quite some problems, which I will go into detail later (to some of them in the form of patches against the update scripts :), now I just would like to start some discussion, or get the answer to this simple question. What is the intended interface language of the update process? Some interface elemnts are translated, but most are not. The update script is especially buggy in this manner, since there is a t('Update') button, but then the 'Update' op is checked for (without the t() wrapper). So my first experience with the update process was that it does not work, and this needs to be fixed (I am much farther away in testing, but let us begin with this question). If we are going to have the update process translated (which would be a good thing from the UI point of view), we should remember, that the new code (the new update system) runs on the old database, so that the translations of the update interface elements are not available. On the long run, if the update process does not change, the translations will be there, but they are mostly not there at this time (update used to be an English only process). If translation support is put forward, many texts in the update scripts need to be updated to properly t(). Otherwise IMHO none should t(). Goba

2 1

Yahoo!
by Dries Buytaert 12 Dec '05

12 Dec '05

Yahoo! is about to offer MT and WordPress blogs. http://news.yahoo.com/s/nm/20051212/wr_nm/media_yahoo_blogs_dc -- Dries Buytaert :: http://www.buytaert.net/

6 7

Drupal 4.6.4 / 4.5.6 released
by Dries Buytaert 12 Dec '05

12 Dec '05

Hello world, Drupal 4.6.4 is available for download. Drupal 4.6.4 is a maintenance release that fixes problems reported using the bug tracking system, as well as 3 security vulnerabilities (two "less critical", one "not critical") that affect all previous versions of Drupal. Since the vulnerabilities are also present in the Drupal 4.5 series, Drupal 4.5.6 is released as well. Upgrading your existing Drupal sites is strongly recommended. More information about the Drupal 4.6.4 and 4.5.6 release is available at http://drupal.org/drupal-4.6.4. Security advisories are available at http://drupal.org/security. Kudos to the security team for their work on getting these releases out, -- Dries Buytaert :: http://www.buytaert.net/

6 8

Setting taxonomy term titles
by Gordon Heydon 12 Dec '05

12 Dec '05

Hi, I have a site in which we use the taxonomy/term to display a number of different terms. What I would like to do is set the title to be something a little more meaningful that the list of all the terms that are being included. so a list like "aaa, bbb, ccc" could be changed to "the abc's" which looks a better. So I need a hook that is called after the the print theme('page', $output); and before the drupal_get_title(); so I can set it to something else. Looking through the phptemplate at the page my choices seem quite limited. I noticed the theme('closure') but this is run after the drupal_get_title(). The other option was to create a non-block which will set the title for me, but not actually display any block. This would be a little kludgy but would work, or I could move the setting of the title to lower in the list. Does anyone have any ideas of how I can change the title on the taxonomy/term page to something nicer without having to hack too much of core. Thanks in advance. Gordon.

3 2

no DROP TABLE in sql files
by Moshe Weitzman 12 Dec '05

12 Dec '05

folks - when you are making .mysql or .pgsql files for your modules, please don't add risky statements like: DROP TABLE IF EXISTS subscriptions; someone started this trend years ago and it gets repeated like a parrot. don't be a parrot. thanks. -moshe

9 13

new form api: dates works?
by Fabio Varesano 12 Dec '05

12 Dec '05

Hi everybody! I'm developing a module were I need to store a date inserted by the user who create the new node type. The problem is that I can't use the date inserted by the user... I just get a '1' instead of a formatted data or an integer representing dates. Is this date api working? Or maybe I'm doing things not good? My function looks like this: function goods_request_form(&$node, &$param) { ... $form['closing_date'] = array( '#type' => 'date', '#title' => t('closing date'), '#default_value' => $node->closing_date, '#description' => t('Insert here the date were the request will be closed'), '#required' => TRUE, '#weight' => -1 ); .... } function goods_request_insert($node) { print_r($node); die(); db_query('INSERT INTO {goods_request} (nid, vid, tid, closing_date, shipping_address) VALUES (%d, %d, %d, %d, %s)', $node->nid, $node->vid, $node->tid, $node->closing_date, $node->shipping_address); } the debugging putput of the print_r is stdClass Object ( [nid] => 6 [vid] => 6 [uid] => 1 [created] => 1134402069 [changed] => 1134402709 [type] => goods_request [title] => aaa [body] => aaa [closing_date] => 1 [shipping_address] => aaa [name] => administrator [date] => 2005-12-12 15:41:09 +0000 [status] => 1 [moderate] => 0 [promote] => 1 [sticky] => 0 [revision] => 0 [preview] => Preview [submit] => Submit [form_id] => goods_request_node_form [comment] => 2 [menu] => Array ( [title] => [description] => [pid] => 1 [path] => [weight] => 0 [mid] => 0 [type] => 86 ) [teaser] => aaa [validated] => 1 [is_new] => 1 ) Thanks Fabio

1 0

Re: image node type
by Ken Rickard 12 Dec '05

12 Dec '05

>> And because this is consistent trouhout your site, you need CCK or Flexinode plus a specially developed theme for presentation. But not a 'story' filled with the same HTML everywhere. Hm... I wrote the answer below and then thought about it. It all comes down to the question: where does layout get handled? If the answer is in themeing, then I agree with Ber. My thought was to move some of the design customization out of themes. (Which may or may not be heresy, depending on your point of view. I think there is a large group of users who would like to move some theme elements out of theme files and into admin.) So below is what I just wrote: --- Yes and no: That's why I proposed admins setting defaults and allowing access control for certain user types to set tokens (or other interface elements) to override those settings on certain posts. (I'm thinking of the path/pathauto relationship here or the teaser settings for posts.) What I thought of this morning, and would mockup it it were deemed valuable, is a system where the admin could define a variable set of media insertion layouts (think content filters). Drupal would ship with two or three standard (like Filtered HTML vs. PHP code). The current implementation of upload.module (placing a link of the file title in a table at the bottom of the post) would be the default. Each defined media type could have one or more layout options available (at the admin's discretion). Users would have the options available to them as set by the admin when posting media to their nodes. Admins could extend the media formats through the admin screen; we'd share media layouts like PHP snippets or theme files (? maybe ?). Anyway, that's just where my head was at. I think it would allow for a great deal of flexibility -- admins would have control through a UI, advanced/privileged users could still do custom posting. But I suppose I need to go read up on CCK (which means _nothing_ to me at this point) before I go any further. -- Ken Rickard agentken

1 0