- Development - lists.drupal.org

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

db_rewrite_sql
by Ashraf Amayreh 19 Apr '07

19 Apr '07

Looking at this function which raps db_query calls and allows modules to alter the query, I was wondering how a hook_db_rewrite_sql is supposed to distinguish the queries that it wants to alter from the queries that it wants to leave alone? Only way I can think of is to do a string match on large parts of the original query, but isn't this quite messy, or am I missing something? Could someone please shed the light on this issue?

5 4

HTML5, XHTML2, and the Future of the Web
by Karoly Negyesi 19 Apr '07

19 Apr '07

http://www.digital-web.com/articles/html5_xhtml2_and_the_future_of_the_web/ Quotes: The fact that Internet Explorer doesn’t really support XHTML as XML in any way, and the problems XML can cause when not all tools in the authoring chain are XML tools, means that there has been little incentive for using XML on the web. This is compounded by search engines not indexing XHTML as XML documents; very few XHTML authoring tools for XML; very few CMS or blogging tools supporting XML correctly all the way from input through database to generation; and very few ad suppliers supporting XML. While HTML 4.01 is formally SGML-based, HTML5 accepts the reality of all browsers using error-correcting tag-soup parsers, and instead describes a specific non-SGML parsing model that includes a defined error correction model. Turning an HTML 4.01 document into HTML5, on the other hand, is in most cases just a question of replacing the DOCTYPE declaration. If a document doesn’t use any of the new elements or APIs introduced by HTML5, the browser just sends it to its tag-soup parser. For most current content-management systems and authoring tools, the change to generate HTML5 instead of HTML 4.01 is simple, and the new HTML5 features can be added to them easily. In addition, many of the new HTML5 features can be emulated using JavaScript for browsers that don’t support them, allowing for a gradual change from HTML 4.01 to HTML5.

6 6