Drupal tips and tricks
Drupal tips and tricks
- Better taxonomy term selection in Drupal-
This page on drupal.org shows how to use checkboxes and option boxes instead of the drop-down selectors for taxonomy terms when submitting content.
- Mollom.com: another spam prevention mechanism for Drupal admins- When trying to keep web site content clean and on-topic, the site administrators often face monumental challenges from spammers. Mollom.com is an alternative to using the Spam or Akismet modules. It's in beta at present, and it is free of charge at present. It is expected to remain free for low-volume users (for details, please refer to the mollom.com web site - link below.)
- Useful Drupal 4.7 Administrative SQL Queries-
Quite often, it is necessary to perform batch operations on a drupal-based site - operations on multiple users, or multiple nodes, for example, and the administrative interfaces don't support the desired operation.
I've put together a list of my favorite queries on this page. I'll update these as time permits.
- Multi-site compatible apache rewrite rules- When using multi-site configurations in Drupal 4.7, and you want to use URL rewriting in .htaccess to force 'www.' or non-'www.' subdomain access, the rewrite rules used in the standard .htaccess file may be problematic.
# If you want the site to be accessed WITH the www. only, adapt and uncomment the following: # RewriteCond %{HTTP_HOST} !^www\.example\.com$ [NC] # RewriteRule .* http://www.example.com/ [L,R=301] # # If you want the site to be accessed only WITHOUT the www. , adapt and uncomment the following: # RewriteCond %{HTTP_HOST} !^example\.com$ [NC] - Simple classified ads module for Drupal 4.7 and Drupal 5- I've created a simple classified ads module for Drupal 4.7 and Drupal 5. It is now in use on a large number of Drupal-based sites.
Background
My classified module creates a new node type ('ed_classified') and associates an expiration timestamp with all nodes of that type. Borrowing from the image.module image gallery scheme, it creates and associates a custom taxonomy with the classified ads. Site administrators then need to create child taxonomy terms for each classified ad category. As with any Drupal taxonomy, ad categories may be nested to arbitrary depth. - Drupal 4.7 Site and Database Backups-
How do I keep my Drupal 4.7 site(s) backed up?
There are several modules to help you:- backup.module Creates an on-demand tarball backup of your database and site files, and downloads them to your browser.
- Database Administration module Allows interactive backup of database tables (among other things.)
- Location, gmap, and gmap_location module interactions- If you want nodes to appear on a google map provided by the gmap_location module, you need to set up your system correctly.
from gmap_location function gmap_location_node_page() :
So, the only nodes that will appear in a gmap_location-provided map are those where the type is 'node' and the longitude or latitude are non-zero in the location table. Ok, how do we get a lat/long value in that table?$result=db_query("SELECT oid, longitude, latitude FROM {location} WHERE (longitude!=0 OR latitude !=0) AND type='node'"); - Why can't A Drupal user edit a node they created?-
Why can't a Drupal user edit a node they created?
Symptoms: An authorized Drupal user loses "edit" access to nodes they've created, even if they have appropriate node (or other module) access permissions. Or, user cannot edit a node that should be editable by them, based on access control or node access settings. No errors or warnings appear in the Drupal log. Possible Cause: The user does not have permission to use the input filter assigned to the node. (Input filter permissions may have been changed since the node was created. As a result, the user never had, or no longer has permission to use the input filter associated with the node.) This excerpt from Drupal node.module node_access() function tells the tale: - Placing "read more" inline with teaser - AngryDonuts.com-
This posting on angrydonuts.com (merlinofchaos' excellent site) shows how to customize the placement of the 'read more' link on your site. Most excellent!
December 13, 2006 Update I've created a drop-in Drupal module (ed_readmore.module) that implements this handy feature and adds some admin settings to enable/disable, and control placement. Read more about ed_readmore.module.
- Using Event module with jscalendar (jstools)- When using event.module with JSCalendar (part of jstools module), you might experience problems with event times being stored incorrectly. This appears to be due to an obscure configuration requirement when using JSCalendar - apparently, the event module must be configured to use 12 hour format. (This one bit me in the behind today, so I thought I'd jot this down somewhere...)
Be sure to set event.module time notation to 12 hour format:
administer >> settings >> event >> "Time Notation Preference" = 12h
Related info:
http://drupal.org/node/65125#comment-106269 - Interesting spammer pattern - how they find sites- Some our our sites that feature free classified ads (amadorable.com, goatseeker.com, and bunnytrade.com) have been hit with a few recurring spammers trying to plant ads for various off-topic products (like cell phones, etc.) I guess this is a good sign; our sites are visible and spammers feel it is worth their time and trouble to post an ad (and no, as far as I can tell, these are not bots - they're human-generated spam.) In reviewing the referrer logs, I've noticed that in nearly every case, spammers use search engines to find sites that have been spammed previously using known keywords - or just sites that offer free classified ads or open posting capability. For example, I find these google searches in my logs, just prior to the spammer creating an account and attempting to deposit the spam content.
- Insert AdSense Ads Automatically in Drupal Nodes and Teaser Lists-
Here's a useful Drupal module that tweaks a node's body or teaser to insert an inline AdSense ad, when a node is rendered on a full page or teaser list.
This allows site administrators to enable automatic insertion of an AdSense ad into the page without the content editor having to insert inline [adense] filter tags, or having to edit a site's template.php (or other template files.) This offers a big advantage, as you can change the ad format, group, and channel on the fly without hand-editing each node (which is the only way I can think of doing it if you are using inline filters). Another advantage is that you can enable/disable the inserted AdSense with just a click of the mouse - no need to edit each node.
- Drupal adsense_injector.module download (and source code)- Now hosted on Drupal.org CVS/Project repository. Please visit the Drupal.org project page for latest releases, bug/issue reports, etc.
News flash:
Now hosted on Drupal.org CVS/Project repository. Please visit the Drupal.org project page for latest releases, bug/issue reports, etc. - Customize Drupal's 'read more' teaser link placement (Drupal 4.7 or Drupal 5)-
Here's a standalone module to provide the customization described at AngryDonuts.com. You can see it in use on this site.
- When DID you load that page?-
(0 seconds ago)'; ?>When I'm viewing Drupal administration pages, like referrer logs or other time-sensitive pages, I like to know the time of the last 'refresh' (and therefore how stale the page content is).
So, here's a quick and dirty Drupal block definition. (The javascript is not very idiomatic, but it'll do for now until I can update it. In fact, I plan on making it a pure client-side javascript widget, but that's another post for another day.)
It will display the date and time the page was last loaded, and the 'age' of the page in seconds - it uses a javascript interval timer to update this every second.
In order to use this on your drupal site, create a new block, paste the code into the block content text field, configure it to use the PHP input filter (so the php code can be interpreted by Drupal), position it in the left sidebar area of your theme (you can place it wherever you wish), and set it to be shown only on admin and admin/* pages.
Here's the code:
<div style="float:right; border: red 1px solid;background-color:orange;color:yellow;text-align:center;padding:.5em;"> <?php // todo: make this all client javascript! // but, for now, I use the php/Drupal format_date() function to simplify the process of getting a local date/timestamp $t = time(); echo 'Page generated on ' . format_date(time()) . ' <span style="color:white;"> <br/%gt;(<span id="page_render_age">0</span> seconds ago)</span>'; ?> </div> <script type="text/javascript"> var page_render_time=new Date().getTime(); function page_render_format_interval(now,start) { return parseInt((now - start)/1000); } function page_render_update() { var now = new Date(); var et = page_render_format_interval(now.getTime(), page_render_time); var elem = document.getElementById('page_render_age'); if (elem && elem.textContent) elem.textContent = et; // ff/mozilla if (elem && elem.innerText) elem.innerText = et; // ie compatibility } window.setInterval("page_render_update()", 1000); </script>
- MyBlogLog for Drupal 4.7- I've created a simple MyBlogLog module for Drupal 4.7. This module provides the following features:
- Inserts the MyBlogLog tracking javascript into generated pages - no need to hand-edit your template's page.tpl.php file, or manually create a block to inject the tracking javascript.
- Provides the "Recent Reader" widget block (includes configuration options - color, width, # rows, etc.)
- Disable visitor tracking for Administrators and other users on a per-role basis (prevent skewed stats due to admin or other roles' visits.)
... and more
- Help for the weary Drupal developer: api.drupal.org and drupal.org OpenSearch plugins - I've created some Drupal-specific OpenSearch plugins for Firefox (and IE7, too!). They provide Drupal.org and api.drupal.org search integration in browsers supporting the OpenSearch search plugin protocol. They are useful when searching for Drupal API routines or other Drupal development subjects. Install them as you would any other OpenSearch plugin...



![cover of Prototype and Scriptaculous in Action [Ajax]](http://ecx.images-amazon.com/images/I/51i%2BlUTDmbL._SL160_.jpg)
Recent comments
6 hours 40 min ago
5 days 11 hours ago
1 week 13 hours ago
1 week 1 day ago
1 week 5 days ago
2 weeks 1 day ago
2 weeks 3 days ago
2 weeks 4 days ago
2 weeks 5 days ago
4 weeks 2 days ago