DZone Snippets: Nothingless's Code Snippets

Compress file in SSH

nothingless (Sasha) — Mon, 22 Oct 2007 11:38:10 GMT

The below will compress a file or folder in .tar.gz format in SSH.



tar -zcvf .tar.gz

Run a simple Update Query

nothingless (Sasha) — Thu, 26 Apr 2007 11:48:06 GMT

In PHP.



$result = mysql_query("UPDATE example SET age='22' WHERE age='21'") 

or die(mysql_error());

Consistent Thumbnail Width

nothingless (Sasha) — Mon, 16 Apr 2007 10:22:40 GMT

download system/core/core.image_lib.php, open it up in and editor and change:



var $master_dim            = 'height';



var $master_dim            = 'width';

This will resize all thumbnails to have the same width, regardless of their height (the EE default resizes them all to the same height, regardless of their width.)

Display list of Links (using LinkList Module)

nothingless (Sasha) — Thu, 11 Jan 2007 21:41:43 GMT

Requires the LinkList module.





{exp:linklist:entries linklist="links" orderby="url_title" sort="ASC" status="open" limit="30" paginate="both"}



 {linklist:url_title}


    {linklist:url}


   {keywords}{keyword} {/keywords}



{paginate}

			Page {current_page} of {total_pages} Pages {pagination_links}

		{/paginate}

{/exp:linklist:entries}

Gallery: Display a list of parent categories only

nothingless (Sasha) — Thu, 11 Jan 2007 18:00:57 GMT

The below displays a list of all parent categories for a certain Gallery. Be sure to change the gallery_id if yours doesn't have an id of 1.



{exp:query sql="SELECT cat_id, cat_name FROM exp_gallery_categories WHERE gallery_id='1' AND parent_id='0' ORDER BY cat_order"}

{cat_name}

{/exp:query}

Filter entries by custom field

nothingless (Sasha) — Mon, 08 Jan 2007 16:34:26 GMT

It goes in mod.weblog.php.

Inside the build_sql_query() function.

Sandwiched between the ‘Add status declaration’ block and the ‘Build sorting clause’ block.



// ----------------------------------------------

//  Limit by custom weblog field

// ----------------------------------------------

if ($custom_field = $TMPL->fetch_param('custom_field'))

{

$custom_field_array= explode('|',$custom_field);



if ($custom_field_name = $custom_field_array['1'] AND $custom_field_value = $custom_field_array['0'])

{

if (isset($this->cfields[$custom_field_value]))

{

$custom_field_id = $this->cfields[$custom_field_value];

}



$sql .= "AND exp_weblog_data.field_id_".$custom_field_id." = '".$custom_field_name."' ";

}

}

You use it by passing string that looks like this:
custom_field_name|value

In the weblog tag parameter: custom_field

{exp:weblog:entries weblog="blog" custom_field="custom_field_name|value"}

Replace ‘custom_field_name’ with the name of the custom field your evaluating for. And replace ‘value’ with the value that the field needs to contain in order to fetch the relevant entries.

Hack at your own risk. No warranties, quarantees, or doggie fleas.

(code written by Solspace / http://www.pmachine.com/forums/viewthread/29199/)

Change the EE date fields to dropdown pickers

nothingless (Sasha) — Thu, 31 Aug 2006 19:23:47 GMT

You can use the code below to change Expression Engine's custom date fields to easy dropdowns, instead of the confusing text fields.

JS in the head of your document:

Code for the actual fields:

Full credit for this goes to Solspace!

Generate a dropdown with months in a year

nothingless (Sasha) — Thu, 31 Aug 2006 17:08:18 GMT

The below code will generate a form dropdown for all 12 months, with the current month selected. Handy for those date pickers!

Generate a dropdown with days of the month

nothingless (Sasha) — Thu, 31 Aug 2006 17:06:21 GMT

The below code will generate a form dropdown for all the days of the month, with today's day selected. Handy for those date pickers!

Restricr Search to a Member's Own Posts

nothingless (Sasha) — Sat, 26 Aug 2006 20:57:51 GMT

Insert the below code just below the opening search form tags to restrict the search to a member's own posts if they are not a Super Admin.



{if group_id != "1"}

{if:else}You are logged in as a Super Admin, so all entries will be visible to you.{/if}