November 2009 - Development - lists.drupal.org

Consolidating duplicate contrib modules for D7
by Brian Vuyk 05 Dec '09

05 Dec '09

I know the whole 'duplication in contrib' issue has been discussed to death on this list, so I will try to keep this short. Obviously, the duplication in contrib is something we are working hard as a community to avoid. Nevertheless, in some cases, duplication has still crept in, and this leads to a poorer user experience, and user confusion. One prime example is the node access modules, which all perform nearly identical functions with more or less polish: Node Access: http://drupal.org/project/node_access Nodeaccess: http://drupal.org/project/nodeaccess Content Access: http://drupal.org/project/content_access Now, is there anything we as a community can do to clean up this sort of issue in contrib? I realize that in individual cases, the best policy is to post in the issue queues for the individual projects, but on a larger scale, is it worth starting something along the lines of #D7CX to consolidate the dupes in the name of a better user experience?

12 16

Ctools form wizard
by Dipen 01 Dec '09

01 Dec '09

Hi list, Can I mix system form with a custom form in ctools form wizard, I wish to create a wizard containing 1 node add form and 2 custom forms. I have briefly looked at advanced help of form wizard and I think there would be problem in dealing with _submit of node add form in module space. Has anyone encountered this before? I am trying to create multistep form with 1 node add form and 2 custom forms and ctools looks like the cleanest way but not sure how would I get around the _submit handler problem for node add form. >From ctools help: " The primary difference between these forms and a normal Drupal form is that the submit handler should not save any data. Instead, it should make any changes to a cached object (usually placed on the $form_state) and only the _finish or _return handler should actually save any real data. " Any pointers appreciated. Thanks Dipen

2 2

Getting SVN to deal with orphaned and new files
by Shai Gluskin 27 Nov '09

27 Nov '09

I get modules from d.o. from CVS, then I commit them to my own repository with SVN. When updating modules I've doing SVN del, CVS co, SVN add instead of simply CVS up because of orphaned and new files. SVN freaks out over orphans and the new files are just a pain since you need to SVN add for each one. But I just installed Drush and I'm so excited about making all this easy. So I'm motivated to finally ask for help around this. So if you commit CVS versions of contrib to SVN, what is your method for dealing with orphans and new files? Thanks, Shai

7 12

Imagecache : File is cached by browser.
by Dipen 25 Nov '09

25 Nov '09

Hi, I am using imagecache for my user profile page, when i update image with a new image imagecache doesn't rename the image file name but successfully update the image on the server. Browser cached the image and shows the old image upon refresh, I wanted to ask if I can programmatically get around this problem? have u had problems with stale image showing even after updating the image with new one? Any ways to get around it? Cheers Dipen

1 2

Re: [development] new dev q: are mysql queries possible within drupal?
by Alfonso Montero López 24 Nov '09

24 Nov '09

2009/11/19 <development-request(a)drupal.org>: >>> Thanks to everyone that replied. >>> >>> >>> To summarise then: >>> >>> 1) I need to make a custom module. >>> 2) The module should have a block for displaying the query and a menu >>> hook >>> 3) I can add the module to either primary links or navigation as a menu >>> item >>> 4) Rendered HTML using mysql commands is quite straight forward >>> 5) The tables being queried are easier to access within the main drupal >>> d/b but i can use a different db >>> >>> Regarding a different db, does this command: >>> >>> db_set_active('customerdb'); >>> >>> make *all* db queries go through customerdb or just the ones for my >>> module? >>> ie will drupal have any issues accessing the data it needs from say >>> "drupaldb" if I dont change >>> the active db back again? >>> Maybe Table Wizard (http://drupal.org/project/tw) module can help you to do it, also. In the docs there's info about querying external db's. Then you will be able to views-enable any table and from this on, you can do all sort of things, if I understood you well. HTH. Regards, -- Alfonso.

1 0

problem with db_rewrite_sql
by Lluís 24 Nov '09

24 Nov '09

I am using group by module, and db_rewrite_sql is giving me problems because it cause rows to be selected twice and SUM reports double their value. After doing some research I have found that if I change: function node_db_rewrite_sql($query, $primary_table, $primary_field) { if ($primary_field == 'nid' && !node_access_view_all_nodes()) { $return['join'] = _node_access_join_sql($primary_table); $return['where'] = _node_access_where_sql(); $return['distinct'] = 1; return $return; } } to: function node_db_rewrite_sql($query, $primary_table, $primary_field) { if ($primary_field == 'nid' && !node_access_view_all_nodes()) { if (($where=_node_access_where_sql('view','new_na'))!='') { $return['where'] = "".$primary_table.".".$primary_field." IN (SELECT new_na.nid FROM {node_access} new_na WHERE ".$where.")"; return $return; } } } everything works as expected. Is there any reason why using "INNER JOIN" is better than using " WHERE nid IN (SELECT ... FROM {node_access} ... )"? -- *Les normes hi són perquè hi pensis abans de saltar-te-les *La vida és com una taronja, què esperes a exprimir-la? *Si creus que l'educació és cara, prova la ignorància. *La vida és com una moneda, la pots gastar en el que vulguis però només una vegada. *Abans d'imprimir aquest missatge, pensa en el medi ambient.

4 5

new features in D6 core?
by Andrew Schulman 24 Nov '09

24 Nov '09

Are new features still being considered for Drupal 6 core? I've coded a new "Set language" option for the bulk node update form at admin/content/node. I filed an issue report with a patch and screenshot, at http://drupal.org/node/609262 . But from my reading of other issue reports, it seems that the 6.x API is considered to be frozen at this point. If I understand correctly, that would rule out including my patch, which adds some hooks to the locale module. Can someone please tell me if this is true, or even better, point me to a definitive statement? Thanks, Andrew.

33 59

Doing hook_update_N() when module is installed
by Randy Fay 23 Nov '09

23 Nov '09

I'm doing a module for infrastructure which is all about applying configuration updates, and it does only configuration, nothing else. I'd like to create hook_update_N() functions, but I'd also like all of them to be run when the module is installed. Is there any "correct" way to do this? Many modules implement the functionality in both hook_install and hook_update_N, and that's fine for database-only issues, which is what these were built around (like schema changes). But it doesnt' really make sense for site config changes. Obviously, I can run the hook functions from hook_install(), in direct or indirect ways. Suggestions? Thanks, -Randy -- Randy Fay Drupal Development, troubleshooting, and debugging randy(a)randyfay.com +1 970.462.7450

8 13

creating a new usermanagement things
by Kees Scherpenhuijzen 23 Nov '09

23 Nov '09

Hey all, When using drupal for a site where users can register themself for a event; what is the best way to store the data when you have different modules to manipulate them? By manipulating i mean: - Managing some fields like if the person have payed. - Managing multiple users to assign them to groups - Just show lists of users - Printing lists of each user data I'm right now looking a the module profile which is provided by drupal it self. but is see it is data stored in a separate table. Is it then the best way to create code which uses the "API" from profile? Is there anyone who has more experience with this? TIA, -- Kees

3 2

Creative querying
by Brian Vuyk 23 Nov '09

23 Nov '09

Hello all. I am trying to write a MySQL query for users and roles, and could use a little help along. Basically, I need to compile a list of users who have certain roles. On this site, users can have 4-5 roles which represent ascending privilege levels, and we need to find the highest privilege level a user can get. The problem is, the highest privilege level in terms of functionality isn't the highest numerically by role id. In essence, as output, I am trying to get results that show a user id in one column, and rid 6 if they have it, otherwise rid 8, otherwise rid 5, otherwise 7, otherwise 4. Edit: As I was typing this, I thought of another thing to try, and it seems to have worked: SELECT DISTINCT u.uid, ur.rid FROM {users} u RIGHT JOIN {users_roles} ur ON ur.uid = u.uid WHERE rid = 6 OR rid = 8 OR rid = 5 OR rid = 7 OR rid = 4 GROUP BY uid; This depends on MySQL's query evaluation to stop on the first match from the OR'd conditions that apply. Without the GROUP BY condition, this still returns a list of all uid / rid combinations... Since this email was already written, I thought I would send it along with the solution I have both so that: 1. If anyone else is trying to do something similar, they can see what I did. 2. It goes into the list archives for the same reason as #1. Brian

7 11