October 2010 - Development - lists.drupal.org

custom notification system
by Aldo Martinez Selleras 04 Nov '10

04 Nov '10

I'm working on a system developed in drupal. In this system create trophies to be assigned to users according to the behavior of these in different ways. Trophies will have categories related to aspects. I need each time you create one of these categories will send a notification to the user webmaster and this will give permission to be believed or not the proposed category. The problem I see is that all these modules I created without using precisely the nodes in drupal, I mean, use separate tables, and I think that the application of the actions and triggers will not adequate as i need, using the hook_nodeapi. Someone can give me any suggestions on how we could create a notifications system that meets my expectations?

7 8

Re: [development] Cluster with drupal ?
by Kevin O 03 Nov '10

03 Nov '10

If you set up a cluster using ndbcluster tables then some modifications are necessary. Since we use such an architecture, I have written about it here: http://www.coderintherye.com/drupal-mysql-cluster-ndbcluster-high-availabil… On that note, there are some issues in core a while back that could use some looking at relating to get ndbcluster support out of the box with Drupal (filed against 8.x): http://drupal.org/node/703916 and http://drupal.org/node/391130 Cheers, Kevin O'Brien Drupal Developer http://www.coderintherye.com 415-754-0112 ------------------------------ > > Message: 2 > Date: Sat, 30 Oct 2010 18:17:00 -0600 > From: Cameron Eagans <cweagans(a)gmail.com> > Subject: Re: [development] Cluster with drupal ? > To: development(a)drupal.org > Message-ID: > <AANLkTikHOpyUr_ps8B5Fy+BwRu8sPSecCWTYU42AHVLj(a)mail.gmail.com<AANLkTikHOpyUr_ps8B5Fy%2BBwRu8sPSecCWTYU42AHVLj(a)mail.gmail.com> > > > Content-Type: text/plain; charset="iso-8859-1" > > I actually just set something like this up for a client. Master-master > replication works well. The only thing we had problems with is making sure > that uploaded files get replicated to all of the web servers. We ended up > using Dropbox (I know - there's better solutions out there, but we wanted > to > put something together quickly). > > Future plans were to implement something like the Andrews File System to > replace Dropbox. > > Thanks, > Cameron > > > > On Sat, Oct 30, 2010 at 14:13, Justin Edwards <justin(a)telelanguage.com > >wrote: > > > This doesn't seem like something Drupal would need to be modified for. > Use > > a master-master mysql installation, replicate the database, and use rsync > to > > keep your drupal front end files updated on all webservers. > > > > Make sure all uploaded files are pointed at the right server, you could > use > > a reverse proxy to make sure it is going to the right location(s). > > > > > > Justin Edwards > > TeleLanguage Inc, > > Network Administrator > > > > > > > > > > On Sat, Oct 30, 2010 at 1:57 PM, Blake Senftner <bsenftner(a)earthlink.net > >wrote: > > > >> Take a look at the Services module, if you are not familiar with it. > >> Allows one to expose APIs, which could be used for cluster node > >> communications. > >> I've made such a setup for a few clients, and am building one now at the > >> RackSpace cloud that is planned to hook into their scaling API to > >> dynamically scale. > >> > >> Sincerely, > >> -Blake > >> www.BlakeSenftner.com > >> > >> On Oct 30, 2010, at 5:25 AM, Damian Adriel Perez Valdes wrote: > >> > >> Hi: > >> > >> Can I make a something like a cluster with Drupal ? > >> > >> I need to install Drupal some servers, and that information of one > drupal > >> sync with a center server, and the others servers too. > >> > >> Exits some module to do it ? > >> > >> Thanks. > >> > >> > >> > > >

3 2

Ranking in a query
by nan wich 31 Oct '10

31 Oct '10

I have a query that counts comments and all is well with it. But I'd like add a ranking column to the display. The problem is that it uses tablesort, so the ranking has to be in the query because I don't know which column will be used to sort the display. Oh, it is also paged so I can't count on the first row being #1 and so on. Has anyone got an idea on how to add a ranking column to the query? (MySql only.) Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

2 5

Cluster with drupal ?
by Damian Adriel Perez Valdes 31 Oct '10

31 Oct '10

Hi: Can I make a something like a cluster with Drupal ? I need to install Drupal some servers, and that information of one drupal sync with a center server, and the others servers too. Exits some module to do it ? Thanks.

5 4

Re: [development] hook_views_query_alter
by Ashraf Amayreh 30 Oct '10

30 Oct '10

Hello Earl, I doubt that would work because I can't structure any view that would add a filter/argument on the files.filename at all. I'll explain my view a bit more. The view takes two arguments, content_type/tid. For example news/5,6. I've managed to also control the sort using a 3rd argument, so a call would look like news/5,6/latest or news/5,6/most-viewed The special case I have is in a term that designates a document type, let's say the term name is "doc" (meaning get the document nodes that have an attachment ending with .doc). So the view here would be document/6,7/latest. 6 would be the tid for document type, and 7 would be a tid for something else from another vocabulary that doesn't have any special case. Let's presumably say the query generated was: SELECT n.nid, n.title FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.type = 'document' AND tn.tid IN (6,7) ORDER BY n.created DESC Now with my special case, the query would need to change to: SELECT n.nid, n.title FROM node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN content_type_document ctd ON n.nid = ctd.nid INNER JOIN files f ON ctd.field_documet_file_fid = f.fid WHERE n.type = 'document' AND tn.tid IN (7) AND f.filename like '%.doc' ORDER BY n.created DESC So I would need to add two more tables to the join, and would need to add a where clause, and remove part of the tid argument (removing 6). I was able to add the join to content_type_document by adding a field from this table to the fields list (although I can't be sure of the effect this will have on the calls that are for a content type other than document which do not have this field in their cck, but I would think views handles this by doing a LEFT JOIN rather than INNER JOIN as I have presumed in the above example). I hope this clarifies what I'm attempting to do, if I got the approach to this problem totally wrong then any other approach to this is highly appreciated. > On 10/29/2010 4:18 PM, Ashraf Amayreh wrote: > > Hello all, > > > > I've searched the net all over for the particular case I have but > > couldn't find an answer. I have a view with an argument, based on this > > argument, I would like to either pass it through, or join to two more > > tables and add a where clause to my query that is pretty unrelated to > > the argument type. For example, let's say the argument is a tid and I > > want to add a where clause to the files table if this tid was equal to > > 5, otherwise, I want it to function normally. For this I looked into the > > hook_views_query_alter hook > > > > The problems I faced in order: > > > > 1. The cck file field that contains the fid was not in the fields list, > > so the table wasn't even in the joins, I resolved this by adding the cck > > file field to the fields list although I have no use for it. But this at > > least added the table to the view object in this hook (I didn't really > > want to add a field in vain just to get its table to show up in the > > view->query object). > > 2. After doing that, I needed to do a join from the table in #1 to the > > files table, again, the files table was not inside the view->query and > > this is where I got stuck. > > 3. Assuming #2 works, I will finally add a where clause to the files > table. > > 4. Let's say I did all this successfully, I would need to remove the tid > > that was passed in the argument so that it would not be rendered inside > > the query (i.e. where tid = 5). > > > > Is there any guidelines on how to fully handle the view, view->query > > objects? All I could find were hacks to add sort by, add simple wheres > > to tables that were already in the views object, and to create aliases > > for tables that are, again, already in the view object. None of them > > with the complexity I need. > > > > I've hesitated on weather this should be in the views issue queue or > > here, but I think many agree views is no longer an optional module. If I > > do get this resolved I'll be more than happy to post it on our site or > > to create a views issue with the details. > > Can you accomplish what you want to do with two different views? Create > your own page handler, examine your argument, and pick which display to > use? Or write an access plugin, which is really very rare, which does > this, and let Views pick the display based upon the access status? >

2 1

Hooking views_data_alter
by jeff＠ayendesigns.com 30 Oct '10

30 Oct '10

Still trying to get this field handler working. Not hooking views_data_alter with the correct $data index. When I used $data[field_data_field_test] [entity_id] [field] [handler] the options form part worked (options listed, etc.), but the render function was receiving the entity value and not the field data. What is the correct reference? Jeff

1 2

hook_views_query_alter
by Ashraf Amayreh 30 Oct '10

30 Oct '10

Hello all, I've searched the net all over for the particular case I have but couldn't find an answer. I have a view with an argument, based on this argument, I would like to either pass it through, or join to two more tables and add a where clause to my query that is pretty unrelated to the argument type. For example, let's say the argument is a tid and I want to add a where clause to the files table if this tid was equal to 5, otherwise, I want it to function normally. For this I looked into the hook_views_query_alter hook The problems I faced in order: 1. The cck file field that contains the fid was not in the fields list, so the table wasn't even in the joins, I resolved this by adding the cck file field to the fields list although I have no use for it. But this at least added the table to the view object in this hook (I didn't really want to add a field in vain just to get its table to show up in the view->query object). 2. After doing that, I needed to do a join from the table in #1 to the files table, again, the files table was not inside the view->query and this is where I got stuck. 3. Assuming #2 works, I will finally add a where clause to the files table. 4. Let's say I did all this successfully, I would need to remove the tid that was passed in the argument so that it would not be rendered inside the query (i.e. where tid = 5). Is there any guidelines on how to fully handle the view, view->query objects? All I could find were hacks to add sort by, add simple wheres to tables that were already in the views object, and to create aliases for tables that are, again, already in the view object. None of them with the complexity I need. I've hesitated on weather this should be in the views issue queue or here, but I think many agree views is no longer an optional module. If I do get this resolved I'll be more than happy to post it on our site or to create a views issue with the details. -- Ashraf Amayreh CEO | O-Minds Cell. 962 78 8099997 Tel. 962 6 5655150 Fax. 962 6 5675150 Skype: aamayreh www.o-minds.com web development | web design user experience | branding design Connect with us on Twitter http://twitter.com/ominds Connect with us on LinkedIn http://www.linkedin.com/in/aamayreh

2 1

some secret to using theme('table'...) ?
by Blake Senftner 29 Oct '10

29 Oct '10

Hmmm... I have the following logic in a module's hook_view() creating a table out of programmatically generated information: $header = array(t($node->title), t('Values:')); $rows = array(array('Project status:', $statusMarkup), array('Notes:', $node->content['body']['#value']), array('Images:', $imagesMarkup), array('Image Tags:', $imageTagMarkup), array('Reconstructions:',$reconsMarkup), array('Actions:', $actionsMarkup)); $table = theme('table', $header, $rows, array('style' => 'width: 770px', 'class' => 'form-item')); $node->content['body']['#value'] = $table; Notice that portion where I declare the width of the table to only be 770px? That is being ignored... I've tried variations like: array( 'width' => '770px', ...) [note not 'style' here] and array( 'style' => 'width: 77px;', ...) [note added semicolon here] When I don't use the 'style' attribute, the sticky-header gets a style setting with the width set to '877.617px;', so it looks like the 'style' usage is what I need, but I'm not finding the magic combination... any advice? Sincerely, -Blake

3 2

Need feedback on HEAD dev releases post-Git migration
by Angela Byron 28 Oct '10

28 Oct '10

Derek has a proposal at http://drupal.org/node/953916 for how to deal with dev releases pointing to HEAD post-Git migration that would massively help reduce the coding required. Feedback welcome (there, not here).

1 0

$content shows in devel but not in page.tpl.php
by Lluís Forns 28 Oct '10

28 Oct '10

My theme (a mod of acquia_prosper) don't show node content. With devel I see $content; if I insert a die($content) in node.tpl.php everything is correct; but when inserting die($conent) in page.tpl.php content is gone Any hint? I have no idea of where to look. -- *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.

2 2