May 2007 - Development - lists.drupal.org

Re: [development] Accessing CCK field data (single, multiple, or shared) from another module
by Karen Stevenson 04 Jun '07

04 Jun '07

To find the right table for a field for a SQL query, use the API, like this: $db_info = content_database_info($field); $table = $db_info['table']; That will always return the right table for the requested field. $field needs to be the complete field array, not just the field name, so if you only have the field name, you would do: $field = content_fields(my_field_name); $db_info = content_database_info($field); $table = $db_info['table']; content_database_info($field) also contains info about the columns declared by the field so you know what field names to use in a SQL query. It returns an array that looks like: Array ( [table] => content_type_story [columns] => Array ( [value] => Array ( [type] => varchar [length] => 50 [not null] => 1 [default] => '' [sortable] => 1 [column] => field_phone_value ) [value2] => Array ( [type] => int [length] => 10 [unsigned] => 1 [not null] => 1 [default] => 0 [column] => field_phone_type ) ) ) ----- Original Message ---- From: Rob Barreca <rob(a)electronicinsight.com> To: development(a)drupal.org Sent: Thursday, March 22, 2007 7:55:31 PM Subject: Re: [development] Accessing CCK field data (single, multiple, or shared) from another module > > Is there a function for getting the data that you can just give a node > type and a field name and it handles the rest? This is something I've just run into as well. I have a hardcoded to query the DB for the multiple field table, but have a TODO in there to find the right API call. Rob Roy Barreca Founder and COO Electronic Insight Corporation http://www.electronicinsight.com rob(a)electronicinsight.com Benjamin Melançon wrote: > Gracious developers, CCK people especially... > > I wrote an access control module that works with the node relativity > module to cascade permissions to all nodes lower in a hierarchy. I > hard-coded a query for a userreference field on a custom content type > as one way to give a user access to a node (and its descendants). > > In generalizing this, the current stumbling block is the way CCK > stores single instances in the content data table and shared instances > of a field in a separate table. > > Is there a function for getting the data that you can just give a node > type and a field name and it handles the rest? > > Or is there a place to check what the case is for a particular field? > (Even a "column_exists()" function would do it for me, but haven't > found one in PHP...) > > It's being developed in Drupal 5 and fixing this (as well as saving > explicitly permitted users when creating a new node) is all that's > needed for posting the project for general use. > > Many thanks, > > ben > > Agaric Design Collective > Open Source Web Development > http://AgaricDesign.com/ > > People Who Give a Damn > building the infrastructure of a network for everyone > http://pwgd.org/

5 4

Fun CCK idea.
by adrian rossouw 04 Jun '07

04 Jun '07

I was thinking it would be cool if we could have a way for CCK node types to be defined by modules. The same way that modules can provide default views. A quick way to do this would be to just have a module that generates a module for node types, generating the .info, and the .install .. and probably a dummy .module. this could really help with install profiles.

10 16

Drupal 6 code freeze
by Dries Buytaert 03 Jun '07

03 Jun '07

Hello world, we're moving forward at full speed, and it would be a pity to suddenly abrupt that, wouldn't it? As there are still many interesting patches in the queue that are almost there, and because we cranked out new stuff like crazy, I decided that it would be best to postpone the code freeze for 4 weeks. This is a one-time extension that leaves us some more time to finish some of the work that we started, and to put some more polish in place. Even with another 4 weeks, it is unlikely that all the key patches will make it into Drupal 6 so let's not waste time and keep up the steady pace of contributions (good job!). Also, keep in mind that towards the end of June, I'll be traveling a fair bit so I won't be able to review as many patches as usual. Last but not least, I'm going to give priority to those patches that were already in the works before today. Happy hacking, -- Dries Buytaert :: http://www.buytaert.net/

5 5

Google Gears
by Dries Buytaert 03 Jun '07

03 Jun '07

http://radar.oreilly.com/archives/2007/05/google_releases.html http://gears.google.com/ -- Dries Buytaert :: http://www.buytaert.net/

14 21

Re: [development] Google Gears
by Michelle Cox 03 Jun '07

03 Jun '07

Actually, I would love the ability to have my site offline synched easily to my site online. There aren't a lot of hotspots in my town, especially at the places that have kiddie stuff to keep my son entertained. I made a local copy of my site, but it's a PITA to keep it updated so I usually don't bother. Something like what has been talked about here would be awesome. Not something I'm in a position to help create, though, so it's just a wish on my part. Michelle On 5/31/2007 7:16:58 AM, Robin Monks (robin(a)civicspacelabs.org) wrote: > The weird thing is, with the dawn of cheap broadband, and wifi-covered > cities, planes, trains and buses, noone is actually offline to enjoy this > now. > > Robin > > On 5/31/07, Victor Kane <victorkane(a)gmail.com> wrote: > > > > well, one possibility is php gtk, see http://gtk.php.net/ (there is a > > data persistence layer in gears) > > But I > wasn't speaking only of using Gears itself, but rather of the > > paradigm shift to rich clients, with offline support. > > On the one hand stuff like Apollo, on the other ... if we have Drupal on > > a > > stick, we can have Drupal on a rich client. > > The paradigm shift of web apps recycled as rich client apps can be seen > > on > > many fronts, for example in the world of light, agile J2EE, the Spring > > Framework has the Rich Client sub-project (see > > http://www.springframework.org/spring-rcp) > > > > Victor Kane > > http://awebfactory.com.ar > > > > On 5/31/07, adrian rossouw <adrian(a)bryght.com> wrote: > > > > > > > > > On 31 May 2007, at 11:05 AM, Victor Kane wrote: > > > > > > use case is manage content, prepare a new edition of a site all ready > > > to > > > synchronize with on line edition...

4 4

To make Drupal even more SEO friendly...
by Karoly Negyesi 01 Jun '07

01 Jun '07

and get a per language path alias interface AND gain some wiki-like features as a nice side effect, we need http://drupal.org/node/147143 Please take a look! Moshe already RTBC'd it but at this time I really would like to see more support for it so we can squeeze this in to D6. Also, thanks goes to Gurpartap Singh for taking my patch and running with it. Regards, NK

2 1

$node namespace woes -- can we fix this in D6?
by Derek Wright 01 Jun '07

01 Jun '07

hello world, i've had a series of bugs in the project* issue queues[1] caused by the fact that the project* modules use $node->pid just like "pid" always means in the project* codebase: the project id, or the nid of the project node that the (release|issue|...) belongs to. however, book.module thinks $node->pid is the nid of the parent page in the book hierarchy. :( so, all hell breaks loose when you try to put a release node into a book outline. certainly other contribs might use $node->pid to mean all sorts of things, too, which would conflict with both project* and book.module. i could always just hack project* to always prefix everything it tries to stuff into or read from $node with some kind of custom variable name prefix, like calling this "$node->project_issue_pid" instead of just "$node->pid". however, given that the API isn't quite frozen for D6 yet, i'm wondering if there's anything smarter and better we could do via the core API, instead of relying on convention and luck to avoid this problem... 1) what's the right way to handle variable namespaces in the $node object? can/should we change hook_nodeapi('load') to force people to use a namespace of some kind when populating $node? maybe $node should be a nested array instead of an object, so that everyone touches: $node[$module_name][$variable_name] instead of just: $node->variable_name ?? that probably sucks for all sorts of reasons, i'm just quickly brainstorming here... 2) presumably this has come up before? anyone have pointers to relevant old issues or threads? i don't remember seeing anything like this come up before, but i've been known to miss the occasional thread on this list. ;) 3) anyone else interested in making a little push to try to do this for D6? 4) would the D6 core maintainers be willing to commit a patch if it materialized and was properly reviewed/tested/RTBC'ed? thanks, -derek (dww) [1] for the interested reader: http://drupal.org/node/98278 http://drupal.org/node/124846 http://drupal.org/node/145782

12 19

PHP5 going forward
by Ken Rickard 31 May '07

31 May '07

All- I received a private note from Larry Garfield this morning based on something I posted online, so it's time to make it more public. Jonah Braun, who is on Joomla's security team and the 1,5 core team works in my office. When I came back from DrupalCON, I toid him that Rasmus had asked Drupal to drop support for PHP4. Jonah immediately took to the idea, and here's what he saw as the challenges. Two problems with dropping PHP4 support: 1) Many hosts (including mine) only support 4.x 2) If one project (Drupal) drops it but the other doesn't (Joomla), the audience (both developers and users) may abandon the project that drops PHP4. Jonah's modest proposal: An agreement to set a release version (or date) where major PHP-based projects drop PHP4 support. Larry, always ambitious, suggested that we get WordPress and Galley involved, too. I can very clearly see the advantage to projects setting an arbitrary date (say, January 1, 2008) after which we don't officially support PHP4. THis wouldn't say that we try to break PHP4, simply that new feature development (and patch support and security updates) require PHP 5. So consider this a modest proposal to get folks thinking about how to move forward together. I already passed Larry on to Jonah to see who might make that decision on the Joomla side. - Ken Rickard agentrickard

18 24

User Password Hashing
by Doug Green 31 May '07

31 May '07

There's been a rather long discussion of password security related to the hash algorithm. Given that this discussion began during the 5.x push and given its security implications, I'm risking breaking protocol and asking for a review. The thread has reached some agreement, but there are some implementation questions, one of which can really only be answered by a handful of people. http://drupal.org/node/29706 Thanks! Doug Green 904-583-3342 www.douggreenconsulting.com www.civicactions.com <http://www.civicactions.com/> Changing the world one node at a time!

1 0

Wordpress HyperDB
by James Walker 30 May '07

30 May '07

Hey folks, interesting (I think) announcement in the wordpress world this week that we may want to keep an eye on: http://comox.textdrive.com/pipermail/wp-hackers/2007-May/012893.html They're releasing the DB class used on wordpress.com which includes some of the following features: * Replication * Failover * Redundant (public/private) networks * Local and remote datacenters * Partitioning * Different tables on different DBs * Advanced stats for profiling That'd be a great list (for large-scale drupal sites) to have in our own abstraction layer, I think. One to keep an eye on... -- James Walker :: http://walkah.net/ :: xmpp:walkah@walkah.net

2 1