Submitted by cableman on Sat, 12/14/2013 - 22:14
I needed to add a outer select query to a view query to remove double rows in the output, which came form the same node being related to two different Organic groups.
Tags
Drupal 7
views
query
alter
sql
MySQL
Submitted by admin on Tue, 07/09/2013 - 16:56
When using drush make on projects where each repository (or module) have their own makefiles and these declares the same modules over and over again drush will download the same data more than once. The code here will utilize drush's cache to only download a module or library once.
Tags
drush
make
makefiles
Drupal 7
Submitted by cableman on Sun, 10/14/2012 - 17:35
Sometimes you may want the login form or a contact form to be displayed in a more dynamic way. It could be in modal window and using ajax to submit the form for better user experience. This post provides example modules for Drupal 6 and 7.
Tags
Drupal 7
Drupal 6
jQuery
UI
forms
Submitted by cableman on Sat, 02/04/2012 - 20:57
I have been working with OpenLayers 2.x in Drupal 7 where I needed polygons, loaded from a KML file, to link to Drupal pages when clicked. I ended up create a module that adds a new behaviour to the layer containing the polygons.
Tags
Drupal 7
Openlayers
JavaScript
PHP
Submitted by cableman on Mon, 01/02/2012 - 19:41
The users browser don't cache static content, if your web-server don't sets the right expire or max-age headers. Drupal sets these headers for static content in the .htaccess file that comes with Drupal, if you have the expire Apache extension enabled.
Tags
Drupal 7
performance
cache
expire
apache2
server
Submitted by cableman on Sun, 12/18/2011 - 20:44
In Drupal you can log message to the database, which is the standard way to log system events. On high traffic sites this can be come a bottleneck for the database server, so an alternative is to send the log message to the systems logging service.
Tags
Drupal 7
Debian
logging
performance
Submitted by cableman on Mon, 12/05/2011 - 22:18
I had big problems synchronizing MySQL database form the staging and production servers to my laptop. It could take up to 15 minutes for an simple site... now it only takes around 35 seconds.
Tags
MySQL
Drupal 7
SSD
performance
Submitted by cableman on Tue, 11/15/2011 - 14:15
When using the context in-line editor to allow editors to add blocks (nodespotbox) to regions you can lock regions, so editors can't drag & drop blocks into locked regions.
Tags
Drupal 7
context
nodespotbox
Submitted by cableman on Mon, 10/10/2011 - 21:35
This post explains how to use panels preprocess function to create template suggestions for panes in Drupal 7.
Tags
Drupal 7
panels
theming
PHP