April 2007 - Development - lists.drupal.org

Check if files is empty
by Johan Forngren 23 Apr '07

23 Apr '07

Hi all, I need help with turning this query into something useful SELECT fid FROM {files} WHERE filepath LIKE 'files/%' LIMIT 1 if (count(db_fetch_object(db_query("SELECT fid FROM {files} WHERE filepath LIKE 'files/%' LIMIT 1"))) == 1) { The purpose is to determine if there is some files within the dir 'files' registered in the db. I'm stuck at the db_* stuff, any help would be greatly appreciated. See also http://drupal.org/node/98824 . Thank you -- Regards, Johan Forngren johan(a)forngren.com :: http://johan.forngren.com/

2 3

Re: [development] db_rewrite_sql
by Chad Phillips -- Apartment Lines 23 Apr '07

23 Apr '07

would now be a good time to re-introduce the idea of a query builder in core?? :) On Apr 18, 2007, at 4:52 PM, Doug Green wrote: > +1 on rethinking this.

3 2

Re: [development] Check if files is empty
by Matt Farina 23 Apr '07

23 Apr '07

1 0

Avoiding sub-queries
by Darren Oh 23 Apr '07

23 Apr '07

I am trying to find the highest node ID in a range of the node table. So far, the only query that works requires a sub-query: $nid = db_result(db_query(db_rewrite_sql(" SELECT MAX(r.nid) FROM ( SELECT n.nid FROM {node} n ORDER BY n.nid LIMIT %d ) r "), $count)); I would prefer for my module to continue working for users stuck with MySQL versions lower than 4.1. Is there any way to rewrite this query so it doesn't use a sub-query?

5 8

links
by Ashraf Amayreh 23 Apr '07

23 Apr '07

Hello all, Don't know if this is the best place for this, so if it's already discussed elsewhere, I'll be thankful if you could point me to the URL cause I couldn't find anything myself. I'm really having a tough time when creating URLs to other parts of a Drupal site. Especially when I'm using clean URLs and even more when I have Drupal as a subfolder like http://example.com/mydrupalsite (in which case the internal node page could be something like http://example.com/drupal/node/5) As far as I've noticed, there are three cases of referencing, this is how I do it, but I'm positive that there's something wrong or else I wouldn't get broken links and/or images when I toggle clean-urls on and off and when I have my site as a domain opposed to a subfolder: 1. Referencing another page, in this case I use l() or url() with relative paths to get the link 2. Referencing a file in the themes folder in which case I use src="<?php print path_to_theme().'/images/whatever.gif';?> 3. Referencing a file in the files folder in which case I use href="<?php print file_directory_path().'/whatever.zip';?> The main headache cause is the second one. If I have clean URLs on and the site as a domain (http://example.com/) then the paths are wrong on node pages. Although this may be a bug or something, I need to know the standard way of referencing any and all paths before I jump to conclusions. Would be grateful if someone could shed the light on this :-)

2 3

Re: [development] [Ubuntu-zh] Gaim经常崩溃
by Huisi Wang 23 Apr '07

23 Apr '07

在 07-4-23，zhan<ustczhan(a)gmail.com> 写道： > 和新版旧版倒是没有什么关系，个人认为可能是 scim 的原因。 > 我以前也用 scim 上 msn ,没有什么问题,不过我是使用的 fcitx 输入法，并且在 kde 环 > 境下面。谢谢！我一直都用debian unstable，用scim/gaim/gnome，没什么问题。刚开始用ubuntu，什么都好，就是觉得这个老是崩溃，有点不好。 -- Best regards, Huisi

1 0

theme('table')
by Karoly Negyesi 23 Apr '07

23 Apr '07

Hi, I would like to ask everyone not to use literal <table> <tr> and <td> tags ongoing. We have a theme('table'). Trivial example: zebra. Instead of striping everything separately we can do it centrally. Thanks, Karoly Negyesi

7 9

Announce Coder 6.x
by Doug Green 21 Apr '07

21 Apr '07

For anyone doing any 6.x development, I spent this afternoon making coder (http://drupal.org/project/coder) compatible with Drupal HEAD (6.x). I also added a new upgrade review for 5.x to 6.x (which is available in both the HEAD and DRUPAL-5 branches). The 6.x upgrade review is better than my past upgrade reviews, and (I think) catches everything except the url() and l() argument changes. (I hope to add these checks before the code freeze.) While I'm announcing the coder 6.x availability, I should also mention that I created a core style review patch (http://drupal.org/node/134493) If you're interesting in making Drupal core coding standards compliant (http://drupal.org/node/318) then review of this patch would be helpful. It's mostly spaces - add an extra one here - remove an extraneous one there; but it's a moderate sized patch- 173 changes throughout core. Doug Green 904-583-3342 www.douggreenconsulting.com Bringing Ideas to Life with Software Artistry and Invention... Providing open source software political solutions

3 4

Installation Profiles
by Fernando Cosso 21 Apr '07

21 Apr '07

Hi I am trying to make a custom installation and I can't find how to take the database type, the db user, pass and port in the myprofile.profile, is it possible? Or I will have to tweak the installation script's code?, if that is the case, any hint will be really appreciate Best Regards -- yo(a)fernandocosso.com.ar http://www.fernandocosso.com.ar

5 10

Request for new module cagetory: Multilingual
by Jose A. Reyero 20 Apr '07

20 Apr '07

Hello, I'd like to propose a new module category to collect all language related modules and tools, with the name 'Multilingual', 'Language tools' or similar. Some modules that may go right away into that category are 'localizer', 'i18n' and 'xliff'... In the case of localizer and i18n they're a big collection of modules, some of which may make sense to spin off from the main package, as long as there's some easy way to have them listed and related. Also, it is my intention to create some more independent modules, like a 'language icons' collection, that then may be reused by the other packages. And there's Gabor's SoC project, which is likely to produce some tools that fit also into this category, http://code.google.com/soc/drupal/appinfo.html?csaid=CCB11E7904E4B8C5 So, not sure this is the place to ask, but I'd also would like to read some opinions about whether this makes sense, and also to know whether there are other related modules that may fit into this category. Regards, Jose A. Reyero

6 8