Location: 102 Webster, Amherst College
https://www.amherst.edu/users/H/dhamilton/drupal_meetings
Thanks to David Hamilton for arranging the room.
We've established the third Wednesday of the month as out new meeting day.
May's agenda includes:
6:00 Introductions
6:10 New Business/Old Business
6:20 Drupal Tool Tips - (OPEN) If you have some tools that make it easier to work with Drupal, this is the place to give us a demonstration.
6:40 What are you working on? Show the site you're working on or ask for help in an area where you may be stuck.
7:00 Presentation One - (Jim Skowyra/Al Nutile) Site Configuration Basics. A look at initial site configuration including security, users, and themes.
7:25 Presentation Two (Kelly Albrecht) DRUSH
7:50 Wrap-up and ideas for next meeting
Comments
Full time opening webmaster/developer (Drupal)
This ad will appear shortly in the Daily Hampshire Gazette:
The Daily Hampshire Gazette (Northampton, MA.) has a full-time opening for a Webmaster/developer to redevelop and manage its Web sites. A successful track record developing and installing in Drupal is a must.
We seek motivated multi-tasker with previous webmaster experience in commercial web sites, who can work in a fast-paced environment. We want someone who can provide leadership as well as technical skills to redevelop an existing Drupal site and build new ones for our affiliated publications.
Ideal candidates will have at least three years in web related technologies, with experience in both client-side UI development (Javascript, Flash, DOM, structured CSS) and server technologies (PHP, SQL, XML, UNIX/Linux, Python scripting). Coldfusion helpful.
We are a small team and you will work closely with editorial and advertising staff to design and implement solutions. We make use of web and software development best practices (open source software, web standards, source version control, issue tracking software, etc.) in our working process.
The Gazette is one of the regions largest employers and offers comprehensive benefits including health and dental insurance and a 401k.
If you are passionate about the web, about news, and would like your work to touch people's daily lives, email a letter, resume, references and links to 3 samples of your work to publisher@gazettenet.com. Please include "Web Developer Opening" in the email subject line.
[About ariostel: "My nickname is a nod to my dad, who wrote poetry in the 40's under the pseudonym 'Arioste Londechard'--Paris Finley, Charlemont, MA]
Anybody interested in DRUSH?
Anybody interested in DRUSH? We could do something on Drush for either the Drupal Tool Tip or for the Second Presentation.
DRUSH Demo
That would be great. Let's plan on that for Presentation 2
Drush
I second going over Drush for the second presentation
Jim here is the view hook sql code
I made a quick module to put it in but you should be able to use the template.php file as well. I put some notes on each line after the second set of //.
The first set of // is code I did not need after or just there to test.
function rvtcoverrides_views_pre_execute(&$view) {//drupal_set_message($view->name); //This I used to see the name of the view
if($view->name=="events") {
//drupal_set_message($view->build_info['query']); //This I used to output the query to the screen
//drupal_set_message($this->build_info['query'][1]); //Here I am trying to see some of the args etc
//drupal_set_message($view->build_info['query_args'][0]); //Here I am trying to see some of the args etc
//drupal_set_message($view->build_info['query_args'][1]); //Here I am trying to see some of the args etc
//if($view->build_info['query_args'][1]==0) { // <Any> is the current choice, so, show everything
//$view->build_info['query']="SELECT node.nid AS nid FROM node WHERE node.type='%s'";
//} else { //Not sure why I had this? But you can see how you can replace the SQL
$view->build_info['query']="SELECT node.nid AS nid, node_data_field_event_image.field_event_image_fid AS node_data_field_event_image_field_event_image_fid, node_data_field_event_image.field_event_image_list AS node_data_field_event_image_field_event_image_list, node_data_field_event_image.field_event_image_data AS node_data_field_event_image_field_event_image_data, node_data_field_event_image.delta AS node_data_field_event_image_delta, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node_data_field_date.field_date_rrule AS node_data_field_date_field_date_rrule, node_data_field_date.delta AS node_data_field_date_delta, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid FROM {node} node LEFT JOIN {content_field_date} node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN {content_field_event_image} node_data_field_event_image ON node.vid = node_data_field_event_image.vid LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid LEFT JOIN {term_node} term_node ON node.vid = term_node.vid LEFT JOIN {term_data} term_data ON term_node.tid = term_data.tid WHERE ((node.status <> 0) AND (node.type in ('%s'))) AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%%dT%T'), SEC_TO_TIME(-14400)), '%Y-%m-%%d') >= '2009-10-13') GROUP BY node.nid ORDER BY node_data_field_date_field_date_value ASC ";
//Here is the sql above I added the group by node-nid which was missing.
//But you can add more items based
//the args, user etc it really is up to you.
}
}
That is is, maybe clear the view cache in the Views-->Tool tab and the system cache as well.
Alfred Nutile
alfrednutile@gmail.com
http://www.alfrednutile.info/about
http://twitter.com/alnutile
Modifying View SQL
Thanks Al. This looks a bit more straightforward than hook_db_rewrite_sql which I had been considering.