Snipplr - theroamingcoder

(Bash) DotCloud MongoDB Backup Script

Fri, 03 Jun 2011 05:32:49 GMT

(PHP) Website Backup To Amazon S3 Storage (PHP Edition)

Tue, 29 Mar 2011 00:57:04 GMT

This handy little script will backup your website's database (MySQL) and files and put them into an amazon s3 bucket.

(Ruby) Website Backup To Amazon S3 Storage

Wed, 13 Oct 2010 14:39:05 GMT

This handy little script will backup your website\'s database (MySQL) and files and put them into an amazon s3 bucket. You will need to make sure your host has the aws/s3 ruby gem installed. Can easily be extended to include the email folders as well. MAKE SURE TO PLACE IN A NON-WEB-ACCESSIBLE FOLDER! And don\'t forget to schedule the task to run via cron.

(Ruby) Rails Delayed Job Script For Use On Shared Hosting

Thu, 16 Sep 2010 06:16:19 GMT

Add this code to /script/jobrunner in your rails app (be sure to make it executable with chmod 775) Then setup a normal cron job to run the script

(jQuery) jquery ui autocomplete us states

Fri, 03 Sep 2010 13:19:25 GMT

(PHP) Drupal hide block for content type

Wed, 09 Jun 2010 18:23:44 GMT

This example is specific to where the "Show on every page except the listed pages." item was selected, but then we needed to also make sure the block did not show for any page of a certain type.

(Java) Java create PHP timestamp

Tue, 04 May 2010 11:42:44 GMT

This specific snippet was for converting a sqlserver database export to a MySQL database where PHP timestamps from time() are used.

(SQL) Get row count from MySQL query

Mon, 29 Mar 2010 16:38:22 GMT

This trick is useful in scenarios where you already have a count in the SELECT along with a GROUP BY that is preventing you from getting a total count of the rows returned. Great for use in the $count_query parameter of pager_query() function calls in Drupal.

(Groovy) Groovy Read CSV File

Thu, 04 Mar 2010 18:55:31 GMT

To use, first add the opencsv .jar to .groovy/lib.

(PHP) Drupal 6 CCK Get Allowed Fields List

Sat, 20 Feb 2010 23:57:48 GMT

Only tested for Text and Number field types.

(C#) Embedding IronRuby

Mon, 25 Jan 2010 18:22:30 GMT

Add references to : IronRuby.dll, IronRuby.Libraries.dll, Microsoft.Scripting.dll and Microsoft.Scripting.Core.dll

(PHP) Drupal 6 Show Child Primary Links In Page

Fri, 22 Jan 2010 19:11:42 GMT

This code is ideal for situations where you have expandable primary links that don't particularly need their own page, but you would like to have links to the child menu items for users that do not have javascript enabled, or so on...

(JavaScript) Google Analytics - jQuery - track all outbound link clicks

Mon, 18 Jan 2010 15:58:21 GMT

This code uses jQuery to add on onclick event tracker to all the links in a specific section of the page. Can easily be modified for additional uses. Note that this does not use the custom page view tracker like mentioned here : http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55527 so that it does not skew your actual page views count.

(C#) state abbreviations list (dictionary)

Wed, 13 Jan 2010 17:59:27 GMT

Dictionary for converting state names to their abbreviations

(PHP) Display database query (MySQL / Drupal 5.x)

Mon, 30 Nov 2009 20:43:20 GMT

Great for generating quick reports from your drupal database in a PHP page. Note that you will have to use the appropriate _num_fields and _fetch_field functions for your database.

(PHP) (php sql to array tree) Convert parent child database structure to a tree and then print it as html

Tue, 10 Nov 2009 10:54:58 GMT

This code is meant to take it easy on the database by only requiring one query. It also prints nicely indented html and can be used in pretty much any situation where you have a flat parent/child structure that needs to be converted into a tree. This method can also build the tree in a single pass in some cases. Note - I have also added code to have it ignore orphaned children.

(PHP) Ensure array b contains all values from array a

Wed, 21 Oct 2009 18:32:00 GMT

I needed to ensure that a user in Drupal was a member of all groups (og module) that a node was posted into.

(SQL) MySQL group by week

Mon, 05 Oct 2009 18:20:41 GMT

Using MySQL you can group date data by week. This is much easier than trying to add up the daily values for each week in a code loop.

(C#) Remove empty values and extra whitespace from a list

Tue, 22 Sep 2009 16:44:12 GMT

This is useful for handling user provided, comma separated data. For example, in the case where the user inputs " 1, 2,3,4,, 5, 6, " you would want to remove the whitespace around each item as well as the empty items to produce "1,2,3,4,5,6".

(PHP) Add google analytics tag to all links in email body

Tue, 22 Sep 2009 13:12:32 GMT

This code can be used to add Google Analytics tracking tags to all links back to your site in email messages that you send. You can then track the referrals back to your site from those emails. See http://www.google.com/support/analytics/bin/answer.py?answer=55578&hl=en for a tool to help you build the tags.