November 2009 - Development - lists.drupal.org

db_last_insert_id
by Jeff Greenberg 05 Nov '09

05 Nov '09

I'm confused with the db_last_insert_id function in database.mysql-common.inc. The function is: function db_last_insert_id($table, $field) { return db_result(db_query('SELECT LAST_INSERT_ID()')); } and I see no reason whatsoever for there to be any parameters, let alone required ones.

4 4

how to use use 2 fields in a views join
by Lluís 03 Nov '09

03 Nov '09

I need to join a table using 2 fields: SELECT * FROM a LEFT JOIN b ON a.field1 = b.field1 AND a.field2 = b.field2 How must I tell to views to use 2 fields to do the join? $data['table2']['table']['join'] = array( 'node' => array( array( 'left_field' => 'compte_comptable_codi', 'left_table' => 'cc_comptes_comptables', 'field' => 'compte_comptable', 'table' => 'node_cc_assentaments_linies6', ), array( 'left_field' => 'pla_comptable_codi', 'left_table' => 'cc_comptes_comptables', 'field' => 'pla_comptable', 'table' => 'node_cc_assentaments_linies6', ), ); -- *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.

1 0

Security Around Setting Up a Sandbox
by Daniel F. Kudwien 03 Nov '09

03 Nov '09

Reposting this from the consulting list to the proper list: ---------------------------------------------------------------------- Date: Mon, 2 Nov 2009 13:09:08 -0500 From: Shai Gluskin <shai(a)content2zero.com> Gang, I'm real excited about Drupal 7. Just listened to the Lullabot podcast and it's amazing how much has gotten in. I want to help increase the number of people looking at D7 who don't have to install it themselves in order to get more people: 1. Finding bugs 2. Finding UI issues 3. Helping with documentation 4. Getting excited about D7 I'm thinking of providing a sandbox on my server. I have found one other D7 sandbox at http://drupal7.socialconstruction.ca/. The D7 version at that site was a month old. In addition, he wasn't letting people into administration sections, just letting people create content. He said the reason was "for security." I had planned to give people a LOT more access than that. I certainly was *not *going to give folks FTP or administer users permissions, but otherwise I was thinking of giving authenticated users a lot of permissions. I'm planning on having the Demonstration Site module <http://drupal.org/project/demo>running to take snapshots on cron (and I wouldn't give people admin privileges on that, obviously). So I could set the site back if someone comes along and messes things up. I'm not particular worried about cpu capacity or bandwidth. This sandbox will not get a lot of traffic. So the question is: is there a security concern that opening up such a sandbox would endanger the client accounts I have set up on the same dedicated server. The d7sandbox account would share an IP, a hard drive, and the same server configuration with my client accounts, but nothing else. Is there a danger with this? Would giving that account a dedicated IP make it any safer? Other thoughts??? Thanks, Shai

3 3

how to set nid argument in views so it works as "not equal to"?
by Zhang Xiao 03 Nov '09

03 Nov '09

Hi, What I want here is a list of latest nodes which are in same type as current node (assuming in node/123 page). I create a node view and set some filters, fields, etc... then i go to the argument section. I choose "Provide default argument" and set to "Node ID from URL". Then I do not know how to continue so that views can load nodes which nid does not equal to the argument.... thanks :)

3 3

How to add menu entry for certain node type?
by Zhang Xiao 03 Nov '09

03 Nov '09

Hi, For example I have 2 node types: 1. company 2. employee I hope for company node I have a path like "node/123/employees" which goes to the page display an employee list of this company. But i do not hope nodes in other types have this path, how to do that? thanks!

6 8

_preprocess_ issues
by Matt Funk 02 Nov '09

02 Nov '09

Hi, I tried the support forum first, but no one seems to answer there, so forgive me if this is thread is misplaced. I am trying a simple thing: I declare (straight from pro drupal development): function phptemplate_preprocess_breadcrumb(&$variables) { drupal_set_message(print_r("some message,true)); } After clearing the cache, i also check the theme-registry (via the developer module) and it is listed under breadcrumb->phptemplate_preprocess_breadcrumb as: 2 (String, 33 characters ) phptemplate_preprocess_breadcrumb | (Callback) phptemplate_preprocess_breadcrumb(); However, it is NEVER called as far as i can tell. Variables set in there are always empty and message set as shown above never show either. I am sorry to bother the list with this, but WHAT am i doing wrong? thanks matt

2 2

Re: [development] Adding   to output strings.
by Anth 01 Nov '09

01 Nov '09

Sorry about that, sent in HTML by accident. Original problem was as below. I'm not sure why I couldn't get the   characters to display, but I solved my particular problem by adding to the CSS: white-space: nowrap; Thanks, Anthony. -- Hi, I've written a small module that outputs some list data using theme_item_list() and I've styled the items so that they are inline. My problem is that my actual list items are breaking and ruining the indent I've set up and individual items are wrapping over more than one line. I thought I could use   characters to stop this, so used a str_replace to replace spaces with the string   but now the literal " " string is appearing instead of the non breaking space I wanted. Any ideas? TIA, Anthony.

1 0

Adding   to output strings.
by Anth 01 Nov '09

01 Nov '09

1 0