Web Design & Development Blog

This blog covers a lot of technical web development issues, focusing especially on Joomla, Drupal, and other open-source CMSes & platforms. Not all our posts are for web developers; we also make sure to write posts for those who are not technical.

20 December 2010 Downgrading from SQL Server 2008 to Express

category:
Web Design and Development

Ever needed to downgrade from SQL Server 2008 to SQL Server 2008 Express, but ran into problems, such as application framework authentication (aspnet) problems? Try this simple fix; delete the files/folders from C:\Users\{YourUserName}\AppData\Local\Microsoft\Microsoft SQL Server Data.

This may also helps those upgrading from Express to the full-fledged SQL server. This trick was the only thing that worked for me after many hours of debugging.

I hope it helps someone!

   

15 December 2010 Joomla 1.6 RC1 Now Available

category:
Website Owners

Joomla has finally announced the first release candidate of Joomla 1.6. The final release is due January 11, 2011, with no current plans for a second release candidate. So, the end (of 1.5) is near!

   

19 November 2010 ASP.net MenuItem mouseovers? Not so fast ..

category:
Web Design and Development

I had some ASP.net 4.0 Hyperlinks and Images and tried converting them to MenuItems, but it’s not possible to set a mouseover without some REALLY clunky workarounds (see here .. and other examples as well). Also, you can’t assign an ID to a MenuItem, nor a class, so you can’t do it with CSS either. Well, you could (using CSS’s nth-child selector) … but not cross-browser. I’m a bit baffled that the MenuItems don’t take an ID, CSS class, OR mouseover easily!! It’s a very common requirement or at least a commonly used design feature / effect, and ASP.net’s been around long enough to have added this at some point!

Maybe I’m missing something obvious here .. ?

Also, since I was using images for the menu items, I needed to hide the text. I managed to hide the text from the menu items, keeping only the image. But when you edit the menu, you can no longer see the menu item names, so you may get lost when trying to edit the menu items. It isn’t ideal, especially if you need to hand the project off to a customer who wants to edit the menu on their own. Again … why the lack of elegance when .net can do so many great things otherwise? There should be a simple option to hide the text.

   

12 November 2010 Stop Skype plugin from messing up your phone numbers!

category:
Web Design and Development

Ever see a phone number get all messed up by the Skype plugin for Firefox and Internet Explorer? It’s annoying. You’re thinking “I’ll just add this phone number, save the page / module / block / whatever” and be done with it, but you’d be wrong. Many Skype users unwittingly see many phone numbers displayed as clickable Skype links that let them place a call directly to that number.

You can stop this from happening in a couple ways:

  • You could make the phone number a graphic
  • Insert some hidden code into the phone number that prevents the Skype plugin from detecting it as a phone number.

Example

Before:

Phone: (555) 123-4567

After:

Phone: (555)<span style="display: none;">.</span> 123-4567

The hidden period is enough to stop the Skype plugin from workings its magic / evil. This technique was tested using Joomla but will work anywhere.

   

08 October 2010 Phoca Download CB Plugin

category:
Joomla Developers

A Community Builder plugin for Joomla 1.5 that displays a user’s files. If the user is viewing his/her own profile, the user can also delete the file from the frontend, which is not yet supported officially by Phoca Download itself!  Download it here

   

15 July 2010 Free Generation International Wins Grant from Chase Giving

category:
News

FGI has received a $20,000 grant from Chase Giving.

Free Generation International / EXIHT International are actively engaged in putting an end to human trafficking, and recently won $20,000 from Chase Giving. Find out more about FGI at freegenerationintl.org or read about our design of the FGI site.  

Read more about the grant at FGI's Facebook page.

   

11 July 2010 Easy tab highlighting with included PHP menu

category:
Web Design and Development

I recently reworked a simple PHP site that uses standalone PHP files containing only HTML. We needed to redesign the navigation bar, which was simple a series of clickable images. These files were not generated by a Dreamweaver template or anything like that, meaning that we would have had to manually change each file every time there was a change to the menu. That seemed very annoying to me, so I created a file called navbar.php and included it into all the pages, using the standard PHP include;

<?php include(‘navbar.php’);?>
{codecitation}
The tabs are highlighted for the current page, so if you are on “About Us”, the About Us tab should be highlighted. To accomplish this, I wrote a simple function;
{codecitation}
function isactive($filename){
$urlfilename = basename($_SERVER['SCRIPT_FILENAME']);
if($filename == $urlfilename){
echo “-hover”;
}
}
?>

A sample navigation tab would then look like this;

<a href=”consulting.php”><img src=”images/navbar-consulting<?php isactive(‘consulting.php’);?>.gif” name=”consulting” width=”104″ height=”35″ border=”0″ id=”consulting” onmouseover=”MM_swapImage(‘consulting’,”,’images/navbar-consulting-hover.gif’,1)” onmouseout=”MM_swapImgRestore()” /></a>

That simply uses the function to tell it which file name to match to the current page’s file name:

isactive(‘consulting.php’);

The end result is that on consulting.php, the HTML output for that tab would look like this:

<a href=”consulting.php”><img src=”images/navbar-consulting-hover.gif” name=”consulting” width=”104″ height=”35″ border=”0″ id=”consulting” onmouseover=”MM_swapImage(‘consulting’,”,’images/navbar-consulting-hover.gif’,1)” onmouseout=”MM_swapImgRestore()” /></a>

.. and that is done automatically using a single included file.

   

06 July 2010 please vote for EXIHT in Africa

category:
Web Design and Development

please vote for EXIHT in Africa.. an anti human trafficking nonprofit. Your vote will help with their funding: http://bit.ly/d3p5Ip

Update: your votes helped EXIHT in Africa raise $20,000 from Chase!!

   

30 June 2010 Email Links vs. web-based e-mail clients

category:
Web Design and Development

Take a look at http://www.lunarpages.com/sales-questions/. Their “Send us your question” button is nice … but they really ought to list the email address on the page too. Clicking it will launch your default e-mail program, even if you don’t use one. For many people that means it will try to open Windows Mail, Outlook, or Thunderbird, even if they only use Gmail or Hotmail.

Not everyone uses Outlook, Thunderbird, etc (e-mail clients), and assuming that can cost you potential leads and business.

Someone who uses only web-based e-mail will want to be able to quickly copy and paste the e-mail address. Now, you can of course right-click and copy the link address, but then you still have to remove the “mailto:” part. Why put your visitors through so much unnecessary trouble if you really want them to contact you?

There are some valid concerns about attracting spam, but those can be mostly overcome using JavaScript cloaking. I think it would be preferable to receive some spam AND more e-mails from your site visitors, than it would be to receive less spam and fewer e-mails from your site visitors, but maybe it’s just me.

   

28 June 2010 Field Length Dependent MySQL Text Replacement

category:
Web Design and Development

Suppose you have a MySQL database table containing US 5-digit zip codes, except some of them are just three or four digits long because they had leading zeros, and those sometimes get dropped. Here’s how to add them back in;

For 3-digit zip codes:

UPDATE zipcodes SET zip = CONCAT(’00′, zip) WHERE LENGTH(zip) = 3

This will turn ’123′ into ’00123′.

For 4-digit zip codes:

UPDATE zipcodes SET zip = CONCAT(’0′, zip) WHERE LENGTH(zip) = 4

This will turn ’1234′ into ’01234′.

   

Page 3 of 5

request-a-quote

© 2003-2012 Plethora Design, LLC · Contact Us · Make a Payment · Search

877-51_Skype5-6682 / 703-291-8022. Northern Virginia web design company convenient to Washington, D.C. and Maryland.