web

Important MySQL Queries to Run After Changing Drupal Multi-site Directory

Change file paths to new directory name:

UPDATE files SET filepath = REPLACE (filepath, "sites/oldDomain", "sites/newDomain")

If ssers have uploaded avatars:

UPDATE users SET picture = REPLACE (picture, "sites/oldDomain", "sites/newDomain")

Been making some updates to 2cool2miss.net

Project: 
2 Cool 2 Miss

Site is looking great!

And that is all...

I haven't posted anything on this site in forever... so yeah, there ya go.

What is Drupal?

I've been asked what Drupal is a few dozen times now and I would like to answer this question for those who've asked as simply as possible. Drupal is a Content Management System (CMS). In short, it allows content to be stored in a database away from the actual web page and the CMS (Drupal in this case) is designed to pull the information from inside that database and display that information to its users depending on the developer's and/or owner's needs and wants. A Drupal website is not an out-of-the-box system like the home theatre systems you'd find for less than a couple thousand dollars at Best Buy. It is more like the twenty-thousand dollar systems a home theatre system designer would create.

Drupal itself is just like an apple core or the chassis of your car, and in simple web terms all it really does is tie PHP (web page) and SQL (database) together, but from there it is up to the developer and his/her immagination and abilities. You could build a Facebook or an Ebay using Drupal... The sky is the limit.

I've spent over two years learning Drupal and I have only just begun to utilize what Drupal can do. If you'd like to learn more about Drupal check out drupal.org.

Nik Software Dfine 2.0 plus Photoshop

Project: 
Justin Daniels

This photo was taken for me to be used on Justin Daniel's new website I'm building and it is not very good. Not the photographer's fault but the camera's (it looks as though the image is exposed for the table lights). Here is what I was able to do with Nik's Dfine 2.0 and Photoshop CS3.


(original)


(Dfine 2.0 + levels + highlights/shadows)

100% Crop:


(original)


(Dfine 2.0 + levels + highlights/shadows)

As you can see the Dfine 2.0 Photoshop plugin does wonders for noise reduction especially when you've only got photos like this to work with. If you want to learn more about the software go to http://www.niksoftware.com/dfine/usa/entry.php. It truly is amazing.

Facebook posts?

Trying to make my my blog posts show on my facebook wall... will it work?

CSS Menu-style Mouseover (hover)

I added a new feature to the gallery photos which is a mouseover that displays the photos technical details when you hover over an image in a CSS menu style. Let me tell you how I got it to work...
 
First-off since I'm using drupal I'm obviously using views, so what I did was add the content fields in views and excluded the display on each field and created a global field to piece them together in an HTML format using the fields' tokens (these fields are my camera/lens info and aperture, shutter, and ISO fields). I put them all inside a main div container  and put the photo details inside it's own.
 
So I've got this to work with:

<div class="gallery-photo">
     [field_image_fid]
     <div class="photo-details">
          <p>[field_camera_nid] w/ [field_lens_nid]</p>
          <p>[field_focal_length_value] - [field_aperture_value]@[field_shutter_speed_value] ISO [field_iso_value]</p>
     </div>
</div>
 
All I needed to do was set the image to be visible, and the details to be hidden unless the the user hovers over the image, and that code looks like this:
 
.gallery-photo img {
visibility:visible;
}

.gallery-photo {
font-size:0.75em;
line-height:12px;
visibility:hidden;
}
.photo-details {
background:#FFFFE0;
margin-top:-10px;
position:absolute;
width:148px;
border:1px solid #CCCCCC;
padding:1px;
}
.gallery-photo:hover {
visibility:visible;
}

 
And presto... A nice little CSS add-on. Took me a couple hours with some trial and error and tweaking so I hope it works for you as well. Now I've just got to go through the photos and add the details.

2cool2miss.net finished

Project: 
2 Cool 2 Miss

Well folks 2cool2miss.net is finished and take a look at what I got in exchange! It is a Paul Dayton Hoppe style cue. Both shafts have ivory ferrules and the ring in the butt and the joint is also ivory. I love that shade of green in the veneers. Beautiful cue... I love it! Thanks Terry!

2cool2miss.net finished
2cool2miss.net finished

New Website!

Project: 
2 Cool 2 Miss

Started only last week and its nearly done!

New Website!

Martha's site is finished!

Project: 
B.Radley

It sure did take a while... only because Ubercart 2 is not quite finished itself.

Check it out! - http://www.thatsbradley.com

Martha's site is finished!

Galleries section back up

Have been working on my own galleries section (instead of using a Galleries 2 portal) and I've established my first gallery.

Couple things to note:

  1. I can now reference the gallery link while creating a blog post via a drop-down list (which results in the link below) that allows me to select from any gallery that I've made.
  2. Commenting is enabled! This means you may comment on an entire gallery or individual photos.

Enjoy! (I know I will)