<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-17265341</id><updated>2011-04-21T13:35:29.779-05:00</updated><title type='text'>Multimedia Design &amp; Tech</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>12</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-17265341.post-2333722223029897931</id><published>2007-01-23T14:37:00.000-05:00</published><updated>2007-01-23T15:21:57.886-05:00</updated><title type='text'>Digg.com: Welcome to the Republic</title><content type='html'>Recently my digg account, bluephoenix has been disabled by the digg admin.  Being that I'm not a spammer or a digg gamer and the fact that I've been a user since August of 2005... I was wondering what could possibly have caused this to happen.&lt;br /&gt;&lt;br /&gt;Now, the safe explanation that I imagine I'll receive from the digg staff (which I've yet to receive) will be something along the lines of "You've violated the website's terms of use".  My opinion is that digg banned me for submitting a link to a direct competitor....a first offense for my account and far from a malicious action on my part.   This all started when I noticed a post on &lt;a href="http://feeds.feedburner.com/%7Er/Techcrunch/%7E3/80248388/"&gt;Techcrunch&lt;/a&gt; about &lt;a href="http://www.wikio.com/"&gt;Wikio.com.&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Arrington claims "Europes Digg Killer Raises 4 million" in this article and naturally I was interested in anything claiming to be a digg killer.  I use digg and other rss enabled tech sites to keep me on top of the tech world for my job, being that I'm in the website/database/multimedia field and the site has always provided me with relevant links and articles to good content that I can use daily.  So upon reading techcrunch's iclaim, I decided to give wikio.com a look.&lt;br /&gt;&lt;br /&gt;First impressions of the site were so-so, the UI wasn't laid out as nice as the digg interface...although I did immediately notice the load times for the content and for the interactive features was much better then the javascript bogged down digg homepage.  Regardless, what caught my attention was the technology section of wikio.  The tech homepage upon first glance immediately had 4 or 5 stories that I hadn't seen that day...which is amazing considering the amount of RSS feeds I currently monitor in my reader.  Typically when I visit the digg homepage, it is full of stories that I've already read about via slashdot, metafilter, boing boing, etc....but wikio.com was different.  The content was recent, relevant and free from biased flame wars supporting one company over another. (it is well known that digg leans toward apple, from Kevin Roses's secret contacts there to the fact that there is no "windows" category under technology, only linux and apple)&lt;br /&gt;&lt;br /&gt;The subject matter was the next thing that caught my eye.  Gone were the numerous stories praising Steve Jobs and arguing why Windows users absolutely must switch to Ubuntu....instead I saw relevant tech stories with almost no commentary from 15 year old world of warcraft junkies.....it was refreshing to say the least.  Granted, wikio is in beta and clearly does not have the user base that digg has, but here's hoping that they learn from the mistakes of those that came before them.&lt;br /&gt;&lt;br /&gt;So I bookmarked wikio's homepage and submitted the story to digg with the title &lt;a href="http://digg.com/tech_news/Attention_Digg_Users_Who_Are_Tired_of_What_Digg_Has_Become"&gt;"Attention all digg users who are tired of what digg has become"&lt;/a&gt;&lt;br /&gt;The story went nowhere with only about 2 or 3 diggs and a few comments....most written by myself explaining that while I am promoting another site ...I still will use digg for what it is.  This is typical fare these days on the site, most stories won't go to the homepage anymore unless you have amassed a hoard of friends on the site that will blindly digg your content. Whether this is unavoidable due to the immense number of stories submitted each day or not, I simply wanted to show other frustrated digg users that there is another valid tech option.&lt;br /&gt;In the past I had tried netscape.com, reddit.com and a few others....but the tech sections left much to be desired.  I could've gone back to slashdot for the community, but the interface for comments is just too messy....that's why wikio appealed to me.....simple layout, great content....no drama.&lt;br /&gt;&lt;br /&gt;1 hour after submitting the story linking to wikio.com...digg had banned my account...no explanation, no warning.....I tell this story because I think it speaks volumes about what is happening to the digg community and the site itself.  It is my belief that the site it getting too big for it's own good.....while it is understandable to protect your credibility by blocking users that use the site to further their own needs, it is unacceptable to alienate your core user base that has been there since the beginning.&lt;br /&gt;&lt;br /&gt;Digg claims to be a "democratic" website, where the user controls the content. In my opinion, digg is more of a republican society now, as opposed to the democratic system they claim to be....and we all know how well that policy works with the general public.&lt;br /&gt;&lt;br /&gt;Here's my e-mail to them:&lt;br /&gt;&lt;span style="font-style: italic;"&gt;I was wondering why you disabled my  account.(&lt;/span&gt;&lt;a style="font-style: italic;" class="moz-txt-link-freetext" href="http://www.digg.com/users/bluephoenix/"&gt;http://www.digg.com/users/bluephoenix/&lt;/a&gt;&lt;span style="font-style: italic;"&gt;)...I can only  attribute this to my recent posts regarding wikio.com.  It is my  understanding that in your terms of use you state it is wrong to: &lt;/span&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;"submit stories or comments linking to affiliate programs, multi-level  marketing schemes, sites/blogs repurposing existing stories (source  hops), or off-topic content;" &lt;/span&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;I'm at a loss as to why my recent submissions and comments would cause  someone to disable the account....what harm do my actions cause to  your website? &lt;/span&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;I would like you to fully explain your reasoning for disabling the  account, as while my statements in the aforementioned stories clearly  imply that I'm tired of the existing digg website, it does not imply  that I wish to stop using it entirely.  I've been a member of the site  since august of 05 I believe and I've never broken any of your  "democratic" terms of use.  Whether or not you reinstate the account  is irrelevent, I simply would like to know the reasons behind  it.....thanks in advance.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;UPDATE:&lt;br /&gt;The digg staff has responded:&lt;br /&gt;&lt;span style="font-style: italic;"&gt;Your account was banned for using a re-direct to a banned website,  cybernetnews.com.  We will unban your account if you agree to not  circumvent our banned URLs.  We understand you may not have realized  that it was banned, which is why we are willing to unban it.  Just let  us know the circumstances and we'll work with you.&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;To which I responded:&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;The redirect was a right click "save target as" from a link on  wikio.com.  I don't think anyone knows which site have been  banned....have you released a list of "black listed" websites? I saw  nothing in your terms of use. Your decision to unban my account is  strictly up to you, I'm pretty disenchanted these days anyways with the  site (not that you personally care) but I'd like to continue to interact  with the community as opposed to just using the rss feed.  I just wanted  to know why my account had been banned after being a member for so long.  You can look at my digging history yourself if you question my  intentions on the site. Cheers.&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;It looks as if my digging days are done...&lt;span style="font-style: italic;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-2333722223029897931?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/2333722223029897931/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=2333722223029897931' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/2333722223029897931'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/2333722223029897931'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2007/01/diggcom-welcome-to-republic.html' title='Digg.com: Welcome to the Republic'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-995586922782320520</id><published>2006-12-29T12:44:00.000-05:00</published><updated>2006-12-29T13:23:29.824-05:00</updated><title type='text'>Digg democracy still not perfect?</title><content type='html'>While perusing the upcoming stories page I couldn't help but notice that the top 10 stories were submitted by the same digg user.&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.khaodyn.com/digggaming_lrg.jpg"&gt;&lt;img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://4.bp.blogspot.com/_Chahg1t9lY8/RZVWR6NRegI/AAAAAAAAAAM/HtDAc72LpYY/s320/digggaming_small.jpg" alt="" id="BLOGGER_PHOTO_ID_5014008625829607938" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;While gaming digg is now old news, with the recent updates to the site I thought they they would have corrected this problem. The  first 4 stories listed in the most popular upcoming queue were all submitted by&lt;a href="http://www.digg.com/users/MrBabyMan/"&gt; Mr. Baby Man&lt;/a&gt; , who seems innocent enough&lt;span style="font-size:100%;"&gt;,  without any clear ties to marketing firms or suspicious activity on digg in general....however when you examine the aforementioned 4 stories and view the peopl&lt;/span&gt;&lt;span style="font-size:100%;"&gt;e who dugg this story initially, it becomes apparent that something is clearly still flawed with digg.&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size:100%;"&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.khaodyn.com/dups_lrg.jpg"&gt;&lt;img style="margin: 0pt 0pt 10px 10px; float: right; cursor: pointer;" src="http://1.bp.blogspot.com/_Chahg1t9lY8/RZVXSKNRehI/AAAAAAAAAAU/YJ4fYXZeV3Y/s320/dup_sm.jpg" alt="" id="BLOGGER_PHOTO_ID_5014009729636203026" border="0" /&gt;&lt;/a&gt;&lt;span style="font-size:100%;"&gt;Look at the image on the right (click for larger) Highlighted names are members who dugg these 4 stories (I included a 5th story from the same timeframe) around the same time (seeing as these stories were all submitted around the same time) .  While the exact order is not the same, there is a clear link between most of these members and the member&lt;/span&gt;&lt;span style="font-size:100%;"&gt; who submitted the stories.  To be fair, most of these submitted stories are pointing to established websites, and not to a personal blog, however, it still shows that the digg site is capable of being gamed, for better or worse.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;At the time of this writing, only one of these stories in the upcoming queue (under "most popular") have gone to the front page, but if all of them do indeed make it, I think it's time for the digg crew to look at their promotion algorithm once again.&lt;br /&gt;Understandably, as the site grows in popularity, I suppose this type of behavior becomes more and more difficult to control without the use of moderators, but if digg is still going to stick to its guns as a total democracy then these issues must be addressed.....if only to satisfy the core user base that has been there since the beginning.&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.khaodyn.com/gaming2_lrg.jpg"&gt;&lt;img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://1.bp.blogspot.com/_Chahg1t9lY8/RZVc1KNReiI/AAAAAAAAAAk/Q1cFsoVNu9U/s320/gaming2_small.jpg" alt="" id="BLOGGER_PHOTO_ID_5014015828489763362" border="0" /&gt;&lt;/a&gt;&lt;span style="font-size:100%;"&gt;UPDATE:&lt;br /&gt;Further down the queue I found this as well.  Four more stories in a row by Mr Baby Man, I didn't have time to check the people who dugg but I'd be willing to bet it was most of the same members form above.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-size:100%;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-995586922782320520?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/995586922782320520/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=995586922782320520' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/995586922782320520'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/995586922782320520'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2006/12/digg-democracy-still-not-perfect.html' title='Digg democracy still not perfect?'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_Chahg1t9lY8/RZVWR6NRegI/AAAAAAAAAAM/HtDAc72LpYY/s72-c/digggaming_small.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-114856354564113774</id><published>2006-05-25T08:06:00.000-05:00</published><updated>2006-05-25T08:25:45.666-05:00</updated><title type='text'>The Future of RSS in Windows</title><content type='html'>I recently downloaded and tested the 2007 beta version of Microsoft Office , and I have to say I do like the new look and features that it offers.  However, there is one feature in particular that really stands out for me, and that's the RSS functionality of Outlook.&lt;br /&gt;While other mail apps such as Thunderbird have had RSS features built in for quite some time now, the new Outlook 2007 will revolutionize the industry and make RSS as mainstream as e-mail is today.  Here's the reason why: (This text is directly from the main interface of Outlook)&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;How does RSS work in Outlook 2007?&lt;/span&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;RSS readers, such as the one built into Microsoft Outlook 2007, allow&lt;/span&gt; &lt;span style="font-style: italic;"&gt;you to find feeds and subscribe to them. Whenever you see (rss icon), or&lt;/span&gt; &lt;span style="font-style: italic;"&gt;a similar ico&lt;/span&gt;&lt;span style="font-style: italic;"&gt;n, click that icon. Outlook 2007 will automatically&lt;/span&gt; &lt;span style="font-style: italic;"&gt;subscribe you to that feed. Others require you to copy and paste the&lt;/span&gt; &lt;span style="font-style: italic;"&gt;address of the feed in order to subscribe. Using Outlook 2007 to&lt;/span&gt; &lt;span style="font-style: italic;"&gt;subscribe to an RSS feed takes only a couple of clicks and does not&lt;/span&gt; &lt;span style="font-style: italic;"&gt;involve a registration process or fee. After you subscribe to an RSS&lt;/span&gt; &lt;span style="font-style: italic;"&gt;Feed, headlines will appear in your RSS folders. When you see a headline&lt;/span&gt; &lt;span style="font-style: italic;"&gt;that interests you, just click it to view a por&lt;/span&gt;&lt;span style="font-style: italic;"&gt;tion of the article and a&lt;/span&gt; &lt;span style="font-style: italic;"&gt;l&lt;/span&gt;&lt;span style="font-style: italic;"&gt;ink to the complete article. For more information, read the complete&lt;/span&gt; &lt;span style="font-style: italic;"&gt;instructions&lt;br /&gt;&lt;/span&gt;The implications here are enormous.  Finally the average pc user will be able to click on rss icons from their browser and windows will detect it, and automatically subscribe them to the feed within Outlook.  The main issue with RSS adoption today is that for the most part, only tech savvy people are using it.  While it doesn't require much effort to copy and paste the XML link into your favorite Reader software, the average internet user doesn't have the attention span nor the software / web based account to take advantage of RSS at this point.  This will all change if it's already built into their operating system and default e-mail application. Due to the huge market share that Windows has on the average consumer, I think it's safe to say that RSS will finally become a common practice, and the implications on business and communication in general will be huge.  The only concern I have is that Windows Vista may have a slow adoption rate due to it's high system requirements, but that will eventually be overcome in time.  I've included some screen shots below of the general interface and functionality. Click for larger images.&lt;br /&gt;&lt;br /&gt;&lt;div style="text-align: left;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.khaodyn.com/rss2.gif"&gt;&lt;img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://photos1.blogger.com/blogger/5016/1660/320/rss2_thumb.gif" alt="" border="0" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;The default RSS page&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.khaodyn.com/rss1.gif"&gt;&lt;img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://photos1.blogger.com/blogger/5016/1660/320/rss1_thumb.0.gif" alt="" border="0" /&gt;&lt;/a&gt;An example of browsing a feed&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.khaodyn.com/rssadd.gif"&gt;&lt;img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer;" src="http://photos1.blogger.com/blogger/5016/1660/320/rssadd_thumb.0.gif" alt="" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;An example of adding a feed&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-114856354564113774?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/114856354564113774/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=114856354564113774' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/114856354564113774'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/114856354564113774'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2006/05/future-of-rss-in-windows.html' title='The Future of RSS in Windows'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-114417875610969940</id><published>2006-04-04T14:04:00.000-05:00</published><updated>2006-04-04T14:25:56.160-05:00</updated><title type='text'>Interesting Conversation with Rob Malda</title><content type='html'>Ok this is not a post about any web tips or advice, it's about an interesting conversation I had with Rob Malda at the Linuxworld Conference in Boston.  In case you don't know, Malda is the founder of the tech news site slashdot.org .  The conference itself was rather boring, despite the early excitement when a server caught on fire at the unisys display, (That's a good way to show your server's capabilities)  so after walking in circles for an hour I decided to check out the slashdot lounge.  It consisted of zonk, Malda and some other slashdot writers sitting on couches and playing risk or updating the slashdot site while people from the conference watched.  It was almost interesting for awhile except not too much was going on, and there were no booth babes to speak of (go figure) so I decided to move on, but not before approaching Malda and asking him if he used digg.com.  At first he kind of looked at me like"You've gotta be kidding me" but he went on to say that he occassionally checks it out but he prefers sites that are more controlled (edited) then digg.  He also went on to say that both digg and slashdot aren't really original sites as they just report on news from other sources.   He said "&lt;em&gt;Everyone seems to think that we have some kind of rivalry with digg, when the truth is ..we don't give a shit.  I prefer our site because of the content control, which prevents stories like "Here's a picture of my armpit!" from reaching the main page.  I also don't have time to read 30 or 40 stories a day, so I think they have too much content right now.  It's too wide open&lt;/em&gt;."  Frankly I couldn't agree with Malda more, digg used to be such a great resource for all that is tech and it's main page seemed to be consistently full of interesting and useful stories. These days it does seem to be clogged with random "armpit" stories that somehow make it to the main page.  It only appears it will get worse too as they plan on opening up more categories for story submission, most of which have no relevance to technology, but are more akin to stories that you'd see on shoutcast or newsvine. I hope that doesn't happen too soon.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-114417875610969940?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/114417875610969940/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=114417875610969940' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/114417875610969940'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/114417875610969940'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2006/04/interesting-conversation-with-rob.html' title='Interesting Conversation with Rob Malda'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-114080903964206498</id><published>2006-02-24T14:04:00.000-05:00</published><updated>2006-02-24T14:24:43.446-05:00</updated><title type='text'>Web Accessibility</title><content type='html'>&lt;span style="font-size:100%;"&gt;&lt;span style="font-family:arial;"&gt;With the up and coming release of Internet Explorer 7  (currently in beta 2) , it may be time to review your website and to consider moving all your code to strict (or at least transitional)XHTML and CSS layouts.  Besides being immensely easier to edit and display, CSS and XHTML also allow your site to conform to web accessibility standards, such as the W3C WAI-AAA and Seciton 508 validations. &lt;/span&gt;&lt;br /&gt;&lt;span style="font-family:arial;"&gt;Recently, &lt;/span&gt;&lt;a style="font-family: arial;" href="http://www.dcexaminer.com/articles/2006/02/20/opinion/editorial/06edit20target.txt"&gt;Target Stores had a lawsuit filed against them&lt;/a&gt;&lt;span style="font-family:arial;"&gt; because their website wasn't accessible enough for blind and visually impaired viewers.  So while I'm sure most of us out there don't have the same traffic or e-commerce demands that the target website does, it's still a good idea to start moving your site over now anyways, as you'll open up to a whole new demographic.  While I can't get too in depth here on this topic, I can give you a head start on what to consider for your website to move forward into a more accessible design and layout.  Here are some key features to consider&lt;/span&gt;&lt;br /&gt;&lt;/span&gt; &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span  lang="EN" style="color:black;"&gt;XHTML 1.0&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  lang="EN" &gt;The Extensible HyperText Markup Language (XHTML™) is a family of current and future document types and modules that reproduce, subset, and extend HTML, reformulated in &lt;a href="http://www.w3.org/XML/"&gt;XML&lt;/a&gt;. XHTML Family document types are all XML-based, and ultimately are designed to work in conjunction with XML-based user agents. XHTML is the successor of HTML, and a &lt;a href="http://www.w3.org/MarkUp/#recommendations#recommendations"&gt;series of specifications&lt;/a&gt; has been developed for XHTML.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;    &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span  lang="EN" style="color:black;"&gt;CSS&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span lang="EN"  style="font-size:100%;"&gt;Style sheets describe how documents are presented on screens, in print, or perhaps how they are pronounced. By attaching style sheets to structured documents on the Web (e.g. HTML), authors and readers can influence the presentation of documents without sacrificing device-independence or adding &lt;a href="http://www.w3.org/Style/customdtd"&gt;new HTML tags&lt;/a&gt;.  CSS can be validated through the W3C's free online service.&lt;span style="color:black;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;    &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;&lt;span style="color:black;"&gt;Access keys&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;Most browsers support jumping to specific links by typing keys defined on the web site. On Windows, you can press &lt;b&gt;ALT &lt;/b&gt;+ an access key; on Macintosh, you can press &lt;b&gt;Control &lt;/b&gt;+ an access key.  Access keys can be scripted within the XHTML.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;    &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;span style="font-size:100%;"&gt;&lt;br /&gt;&lt;b style=""&gt;&lt;span style="color:black;"&gt;Relative font sizes&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;Relative font sizes (em as opposed to pixels) allow the web user to adjust the font size of the page through their browser, which is handy for low vision users.&lt;br /&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span style=""&gt;Embedded Skip navigation link&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;By adding a link which allows the user to skip over the navigation bar on each page, it allows them to quickly get to your content, without having to listen to their screen reader list each link over and over again.  This can be implemented using CSS to hide the link  and XHTML anchors for placement.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="margin-left: 0.25in;font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span style=""&gt;Page language declaration&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;span style="font-size:100%;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;        &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;Screen reader software (&lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;JAWS&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;) needs to know what language your pages are&lt;o:p&gt;&lt;/o:p&gt; written in, so it can pronounce your words properly when it reads them aloud. If you don't identify&lt;o:p&gt;&lt;/o:p&gt; your language, JAWS will try to guess what language you're using, and it can guess incorrectly,&lt;o:p&gt;&lt;/o:p&gt; especially if you quote source code or include other non−language content in your pages.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;span style="font-size:100%;"&gt;&lt;b  style="font-family:arial;"&gt;&lt;span style="color:black;"&gt;Meaningful page titles&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;    &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;JAWS &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;has a special keyboard shortcut (INSERT + F10) which displays (and reads)&lt;o:p&gt;&lt;/o:p&gt; a list of the currently open windows, by window title. In the case of web pages, this would be your page title. It also reads the window title while ALT−TABbing through open windows. Other screen readers, like &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;Home Page Reader&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;, read the page title out load as soon as you visit the page.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;    &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;Lynx &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;displays the page title in the first line of output, so it's always the first thing&lt;o:p&gt;&lt;/o:p&gt; that the user reads in Braille. Google displays the page title in its search results, and &lt;/span&gt;&lt;span style="font-size:100%;"&gt;it ranks keywords higher when they appear in the page title. &lt;span style="color:black;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;    &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span style="color:black;"&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;br /&gt;Semantic Mark-up&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;All pages should use structured semantic markup. H2 tags are used for main titles, H3 tags for subtitles. For example JAWS users can skip to the next section within the accessibility statement by pressing &lt;b&gt;ALT+INSERT+3&lt;/b&gt;.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;    &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span style=""&gt;Titled links&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;        &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;JAWS &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;has an option to read the title of a link along with the link text. When the cursor moves over the link in a browser, it displays the title of the link as a tooltip.&lt;o:p&gt;&lt;/o:p&gt; When you press "&lt;/span&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;&lt;span style="color:black;"&gt;l&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;", &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;Lynx &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;displays a list of links on the current page. The list&lt;o:p&gt;&lt;/o:p&gt; includes the title of each link, if present.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span style=""&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p  class="MsoNormal" style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b style=""&gt;&lt;span style=""&gt;Descriptive ALT tags for images&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;    &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;JAWS &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;reads the &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;alt &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;text. Without valid &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;alt &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;text, the user hears the filename&lt;o:p&gt;&lt;/o:p&gt; instead, &lt;/span&gt;&lt;span style="font-size:100%;"&gt;which is confusing.&lt;span style="color:black;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;          &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;Lynx&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;, as a text−only browser, doesn't display any images, only &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;alt &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;text. Without&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt; alt &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;text, Lynx displays the filename, which looks as bad as JAWS sounds.&lt;o:p&gt;&lt;/o:p&gt; When browsing with images turned off, the ALT text displays instead of the image.&lt;o:p&gt;&lt;/o:p&gt; Internet Explorer displays the &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;alt &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;text as a tooltip &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt; Google &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;also benefits. The Googlebot indexes &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;alt &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;text, which is used not only in matching keywords in normal searches, but also in &lt;/span&gt;&lt;span style="font-size:100%;"&gt;image searches.&lt;span style="color:black;"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;Complex images include LONGDESC attributes or inline descriptions to explain the significance of each image to non−visual readers.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;&lt;span style="color:black;"&gt;Standards compliance&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;All pages should be &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;Bobby AAA approved&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;, complying with &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;all the Bobby guidelines&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;. &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;1. All pages should also be WCAG AAA approved, complying with &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;all priority 1, 2, and 3 guidelines &lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;of the &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;W3C Web Content Accessibility Guidelines&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;. Again, this is a judgement call; many guidelines are intentionally vague and can not be tested automatically.You should review all the guidelines to make sure these pages are in compliance.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;2. All pages should be &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;Section 508 approved&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;, complying with all of the &lt;st1:country-region st="on"&gt;&lt;st1:place st="on"&gt;U.S.&lt;/st1:place&gt;&lt;/st1:country-region&gt; Federal Government &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;Section 508 Guidelines&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;. Again, a judgement call.  Don't claim the  little 508 web badge unless you have validated  your site yourself using the guidelines.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;3. All pages should &lt;/span&gt;&lt;span style="font-size:100%;"&gt;validate as XHTML 1.0 Strict&lt;span style="color:black;"&gt;. This can be tested using the W3C free online validator. &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:black;"  &gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style="font-size:100%;"&gt;&lt;b&gt;&lt;span style="color:black;"&gt;Accessibility references&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;W3 accessibility guidelines&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;, which explains the reasons behind each guideline. &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;W3 accessibility techniques&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;, which explains how to implement each guideline. &lt;/span&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;W3 accessibility checklist&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;, a busy developer's guide to accessibility&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal"  style="font-family:arial;"&gt;&lt;span style=";font-size:100%;color:blue;"  &gt;U.S. Federal Government Section 508 accessibility guidelines&lt;/span&gt;&lt;span style=";font-size:100%;color:black;"  &gt;.&lt;/span&gt;&lt;/p&gt;&lt;span style="font-size:100%;"&gt;&lt;br /&gt;&lt;span style="font-family:arial;"&gt;Most of this information was adapted from "Dive into Accessibility", a free manual which covers this topic in great detail. I believe that section 508 also offers free online training through  &lt;/span&gt;&lt;a style="font-family: arial;" href="http://www.section508.gov/"&gt;section 508.gov&lt;/a&gt;&lt;span style="font-family:arial;"&gt;  I have done extensive research on this topic, feel free to e-mail me with questions not covered in this blog  &lt;/span&gt;&lt;a style="font-family: arial;" href="mailto:bluephoenixstudio@gmail.com"&gt;email-me&lt;/a&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-114080903964206498?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/114080903964206498/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=114080903964206498' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/114080903964206498'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/114080903964206498'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2006/02/web-accessibility.html' title='Web Accessibility'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-113459373186876466</id><published>2005-12-14T15:49:00.000-05:00</published><updated>2005-12-14T15:55:31.890-05:00</updated><title type='text'>Adding RSS functionality to PHPBB</title><content type='html'>Here's a little MOD for users of PHPBB.  Make sure you have an RSS webbadge named rss_icon.gif and make sure you install &lt;span style="font-size: 9pt; font-family: Arial;"&gt;RSS Content Syndicator Mod V2.02 by &lt;/span&gt;&lt;span class="postbody"&gt;&lt;a href="http://www.phpbb.com/phpBB/profile.php?mode=viewprofile&amp;u=67861" target="_blank" class="postlink"&gt;nschindler&lt;/a&gt; In case you have no idea what I'm talking baout so far, phpBB is an open source bulletin board system developed with PHP and MySQL. &lt;a href="http://www.phpbb.com"&gt;http://www.phpbb.com&lt;/a&gt; I haven't actually submitted this MOD to their site yet due to time restraints.  Enjoy&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;1.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Install the RSS Content Syndicator Mod V2.02 (http://www.phpbb.com/phpBB/catdb.php?mode=download&amp;id=816665)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;2.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Open /templates/index_body.tpl&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;3.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Find “&lt;!—BEGIN switch_user_logged_in --&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;4.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Insert the following AFTER:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;      &lt;span style="font-weight: bold;"&gt;  &lt;/span&gt;&lt;/span&gt;&lt;span style="font-weight: bold;"&gt;&lt;a href="rss.php"&gt;&lt;img src="templates/subSilver/images/rss_icon.gif" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;5.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Save and close&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;6.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Open /templates/viewforum_body.tpl&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;7.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Find &lt;span style=""&gt;   &lt;/span&gt;&lt;a class="nav" href="{U_VIEW_FORUM}"&gt;{FORUM_NAME}&lt;/a&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;8.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Insert the following AFTER:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;       &lt;span style="font-weight: bold;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;span style="font-weight: bold;"&gt; &lt;a class="nav" href="{U_VIEW_RSS}"&gt;&lt;img src="templates/subSilver/images/rss_icon.gif" border="0" /&gt;&lt;/a&gt;&lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;9.&lt;span style=""&gt;     &lt;/span&gt;Save and close&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;10.&lt;span style=""&gt;  &lt;/span&gt;Open viewforum.php&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;11.&lt;span style=""&gt;  &lt;/span&gt;Find 'U_VIEW_FORUM' =&gt; append_sid("viewforum.$phpEx?" . POST_FORUM_URL ."=$forum_id"),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;12.&lt;span style=""&gt;  &lt;/span&gt;Insert the following AFTER:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;     &lt;span style="font-weight: bold;"&gt;   &lt;/span&gt;&lt;/span&gt;&lt;span style="font-weight: bold;"&gt;'U_VIEW_RSS' =&gt; append_sid("rss.$phpEx?" . POST_FORUM_URL ."=$forum_id"),&lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;13.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;    &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Save and close&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;14.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;    &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Open rss.php&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;15.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;    &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Find&lt;span style=""&gt;    &lt;/span&gt;$l_topic_replies = $lang['Topic'] . ' ' . $lang['Replies'];&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.5in; text-indent: -0.25in;"&gt;&lt;!--[if !supportLists]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;16.&lt;span style="font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"&gt;    &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;Insert the following after:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;      &lt;span style="font-weight: bold;"&gt;  &lt;/span&gt;&lt;/span&gt;&lt;span style="font-weight: bold;"&gt;if ($forum_id &gt; 0) {&lt;/span&gt;&lt;o:p style="font-weight: bold;"&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in; font-weight: bold;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;$specialforum_query = 'select forum_name from &lt;span style="color: rgb(255, 0, 0);"&gt;phpbb_forums&lt;/span&gt; where forum_id = ' . $forum_id&lt;span style=""&gt;  &lt;/span&gt;.';';&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in; font-weight: bold;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;$forums_query = mysql_query($specialforum_query) or die("Error: ".mysql_error()) ;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in; font-weight: bold;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;        &lt;/span&gt;while ($result = mysql_fetch_array($forums_query)) {&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in; font-weight: bold;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;        &lt;/span&gt;$this_forum_name = $result["forum_name"];&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in; font-weight: bold;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style=""&gt;        &lt;/span&gt;}&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style="font-weight: bold;"&gt;}&lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;&lt;span style="color: rgb(204, 0, 0); font-weight: bold;"&gt;NOTE FOR ABOVE:&lt;/span&gt; change &lt;b style="color: rgb(255, 0, 0);"&gt;phpbb_forums&lt;/b&gt; to the name of your forums table&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;17.&lt;span style=""&gt;  &lt;/span&gt;Find the following&lt;span style=""&gt;    &lt;/span&gt;'BOARD_TITLE' =&gt; $site_name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;18.&lt;span style=""&gt;  &lt;/span&gt;Change it to&lt;span style=""&gt;    &lt;/span&gt;&lt;span style="font-weight: bold;"&gt;'BOARD_TITLE' =&gt; $site_name . ':' . $this_forum_name,&lt;/span&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;19.&lt;span style=""&gt;  &lt;/span&gt;Save and close&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class="MsoNormal" style="margin-left: 0.25in;"&gt;&lt;span style="font-size: 9pt; font-family: Arial;"&gt;20.&lt;span style=""&gt;  &lt;/span&gt;Each forum will now display an RSS button linking to a feed as well as a  main page  feed displaying all new entries&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-113459373186876466?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/113459373186876466/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=113459373186876466' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/113459373186876466'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/113459373186876466'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2005/12/adding-rss-functionality-to-phpbb.html' title='Adding RSS functionality to PHPBB'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-113336804892400568</id><published>2005-11-30T11:18:00.000-05:00</published><updated>2005-11-30T11:27:28.936-05:00</updated><title type='text'>Where to draw the line with online forms</title><content type='html'>Honestly, never ever let user preferences interfere with online form functionality.  If you are using sessions on a web app, do not let the client have any personal preferences that would compromise the integrity of the system.  I just recently ran into this, and it is causing more headaches then you can imagine.  Our problem is that we built in a ridiculously complicated error checking system that allows the client to check individual field values against preprogrammed ranges.  When the system detects an out of range value, it allows the user to 1) either fix the problem, or 2) override the value and log this override in a seperate table.  Things were going fine until they started multiple overrides on a given form, sometimes overriding data and then continuing data entry while in the "error" state (in other words data was still hanging around in $_POST limbo)....needless to say things got complicated and the error handling function and table ballooned out to ridiculous levels.  The lesson learned? Never let the client get picky with onine session based forms, if possible ..be as restrictive as possible and enforce 1 time data entry, don't allow them to half fill out a form and then return, because it's just bad practice.  Incorporate a FAQ that states all of the things they shouldn't be doing, like navigating with browser buttons (which drives me ballistic) or submitting a field with a blank space (ie hitting the spacebar).  As long as you state these things from the get go, you're not accountable for their user entry mistakes.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-113336804892400568?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/113336804892400568/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=113336804892400568' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/113336804892400568'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/113336804892400568'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2005/11/where-to-draw-line-with-online-forms.html' title='Where to draw the line with online forms'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-112982487464901806</id><published>2005-10-20T11:07:00.000-05:00</published><updated>2005-10-20T11:16:15.966-05:00</updated><title type='text'>dumping an excel file into your Mysql Database</title><content type='html'>Another handy little bit of code. Sometimes people have data that they want incorporated into the shiny new web app you've designed for them. The following is the code necessary to dump a comma delimited file into a mysql table. You can get comma delimited files by exporting them from any spreadsheet/database program (like Excel or Access). A couple of things to consider, make sure your columns match up in both the csv file and the Mysql database, otherwise things get really messy. Also, if you have columns of data that include comma seperated items, they will be enclosed within " " marks in the csv file, and you'll have to specify this to mysql when dumping:&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Protocol for loading excel files into mysql databases&lt;br /&gt;&lt;br /&gt;Save the excel file as a comma de-limited (csv) format&lt;br /&gt;&lt;br /&gt;Make sure that you don’t have any empty rows.&lt;br /&gt;&lt;br /&gt;The following mysql statement will load the file into the specified table. Change "file.csv" to your file name. Change yourtableDB to the table you need to load into. Change "yourtableDB" to your mysql table name.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;load data local infile 'file.csv' into table yourtableDB&lt;br /&gt;fields terminated by ","&lt;/strong&gt; &lt;span style="font-size:85%;"&gt;&lt;- This specifies that the fields will be separated by commas &lt;/span&gt;&lt;strong&gt;optionally enclosed by '"'&lt;/strong&gt; &lt;span style="font-size:85%;"&gt;&lt;- in case you have multiple values per column&lt;/span&gt;&lt;span style="font-size:85%;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;strong&gt;lines terminated by '\n'&lt;/strong&gt; &lt;span style="font-size:85%;"&gt;&lt;- start a new record every time it encounters a new line in the csv file&lt;/span&gt;&lt;br /&gt;&lt;strong&gt;(column1, column2, column3….etc);&lt;/strong&gt; &lt;- Specify the columns you wish to load into&lt;br /&gt;&lt;em&gt;An example of this in use&lt;/em&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;load data local infile '/Documents and Settings/Adminsistrator/Desktop/list.csv'&lt;br /&gt;into table newtableDB&lt;br /&gt;fields terminated by "," optionally enclosed by '"' lines terminated by '\n'&lt;br /&gt;(authors, title, journal, year, number, pages, URL);&lt;br /&gt;&lt;/strong&gt;&lt;br /&gt;I hope this helps....if you run into problems, make sure the comma delimited file is properly formatted.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-112982487464901806?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/112982487464901806/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=112982487464901806' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112982487464901806'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112982487464901806'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2005/10/dumping-excel-file-into-your-mysql.html' title='dumping an excel file into your Mysql Database'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-112965676458109492</id><published>2005-10-18T11:58:00.000-05:00</published><updated>2005-10-18T12:32:44.586-05:00</updated><title type='text'>DVD to AVI</title><content type='html'>Here's a simple method for converting DVD's to AVI files.  Alot of times I've run into clients that like to drop off videos on a DVD disk, here's a quick protocol for converting the DVD to editable clips.&lt;br /&gt;Handling VOB files&lt;br /&gt;&lt;br /&gt;If you are extracting VOB from DVD, refer to Protocol #1.  If you already have the VOB extracted, refer to Protocol #2.&lt;br /&gt;&lt;br /&gt;PROTOCOL #1 - Extracting a VOB file from a DVD disk.&lt;br /&gt;&lt;br /&gt;·Begin by opening the DVD Decrypter software.  You can download it for free at - http://www.dvddecrypter.com&lt;br /&gt;·Insert the DVD disk into the DVD drive on the computer.&lt;br /&gt;·Choose FILE - BROWSE from the menu.&lt;br /&gt;·Locate the DVD via the menu and click OK.&lt;br /&gt;·Choose a destination by clicking icon next to "Please select a folder"&lt;br /&gt;·Change the "Mode" to "FILE"&lt;br /&gt;·Select "Decrypt" from the "FILE" menu and follow instructions.&lt;br /&gt;·Proceed to Protocol #2&lt;br /&gt;&lt;br /&gt;PROTOCOL #2 - CONVERTING VOB TO AVI&lt;br /&gt;&lt;br /&gt;Open Auto Gordian Knot.  You can download it for free at - http://www.softpedia.com/get/Multimedia/Video/Codec-Packs-Video-Codecs/AutoGK-Auto-Gordian-Knot.shtml&lt;br /&gt;&lt;br /&gt;·Select "File Input"&lt;br /&gt;·Choose input directory where VOB files are located&lt;br /&gt;·Change predefined size to maximum quality&lt;br /&gt;·Check the Advanced settings to ensure you are using the correct codec (divx or xvid)&lt;br /&gt;·Select "Add Job"&lt;br /&gt;·Select "Start"&lt;br /&gt;·Sit back and wait, depending on the file size this could take awhile.&lt;br /&gt;·When it's complete check the output directory for the AVI.&lt;br /&gt;&lt;br /&gt;Be sure to check the audio and make sure it is synched to the video.  If not you can extract it seperately with Auto GK.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-112965676458109492?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/112965676458109492/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=112965676458109492' title='4 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112965676458109492'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112965676458109492'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2005/10/dvd-to-avi.html' title='DVD to AVI'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>4</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-112809810373859265</id><published>2005-09-30T11:04:00.000-05:00</published><updated>2005-09-30T11:35:03.743-05:00</updated><title type='text'>What every web designer needs to know today</title><content type='html'>When I first graduated from college with my shiny degree, I thought I would have no problem finding a job in my field.  I would just walk out the door, spend the summer partying, and then get hired in a nice design firm making $40K a year to start out.  Wrong.  I realize now looking back how stupid I was back then, thinking that stuff would just fall into my lap.  The reality of it is, I graduated and then spent a year as an assistant manager at Walgreens.  I actually got so desperate at one point that I enrolled in pharmacy school to try out another 6 years of school (and well over $120000) in debt. &lt;br /&gt;The one thing that saved me was a phone call from a job I applied for online months before that.  During the entire year working as a slave in retail, I did occasionally post my resume online via bostonworks.com, an extension of the local newspapers job listings.  By sheer luck, this turned out as a great idea and I was hired a week later, finally getting my foot in the door of the design world.  Because of this experience and many more since then, I've come up with a list of things every prospective designer should know these days. &lt;br /&gt;1.  If you use an online resume / job listing (ex monster), be sure to update your skill set and resume as much as possible.  Each time you update it, your name goes back to the top of their lists on the site, and you'll get more exposure. &lt;br /&gt;2.  Learn a scripting language, as many as possible.  Chances are you can find a job without this knowledge, but you'll get left in the dust eventually by someone else who does know it.  You don't necessarily have to be an expert either, even if you know enough of a language simply to read it, it 's enough to put that skill on your resume.  Key languages to know these days are PHP, ASP, Java, MySql, and Actionscript / Lingo.  Any and all of these will help your career potential immensely.&lt;br /&gt;3.  Learn about databases.  Whether you use Filemaker Pro, Mysql, Access, Oracle or even excel (which shares the basic theme), knowing how a database works sometimes can get you a job in itself.  A buddy of mine knew how to use Microsoft Access enough to build very small applications, as well as just enough VB script to get by.  By chance he applied for a job down in Florida at Office Depot as a Database Adminstrator, knowing he wasn't completely qualified at all.  However, because he was able to talk about his experience in Access, his knowledge of Access and SQL (which he learned about a week before his first interview) he ended up with the job.  They even gave him a $2000 sign on bonus to help him move and started him at $45K a year, for a job he had little or no experience in!  They also agreed to train him in advanced SQL.  I can't stress the value of knowing how a databse works any better.&lt;br /&gt;4.  Lastly, don't get caught up in worrying about how good of a designer you actually are.  Very few graphic designers make a lot of money just doing static design.  This field requires that you be well rounded.  Here's a list of things I believe every designer should begin to familiarize themselves with.....WYSIWYG Design software (Dreamweaver, Golive, etc), dynamic web software (Flash), Multimedia software (Director), Video editing (Premiere), basic 3D (Maya, 3DS Max, etc), video optimizing (Cleaner, etc) and illustration / image editing obviously. &lt;br /&gt;PS.  Before I forget, get on the RSS / podcasting bandwagon as soon as possible.  This is the future of communication and advertising and now is the time to capitalize on the technology.  Learn all about it as soon as you can.  Utilizing RSS is also a great way to stay ahead of the technology curve.  That's, all I hope this information helps you in the career.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-112809810373859265?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/112809810373859265/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=112809810373859265' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112809810373859265'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112809810373859265'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2005/09/what-every-web-designer-needs-to-know.html' title='What every web designer needs to know today'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-112801281821709768</id><published>2005-09-29T11:15:00.000-05:00</published><updated>2005-09-29T11:53:38.223-05:00</updated><title type='text'>The nightmare that is web applications</title><content type='html'>Anyone that has developed a web application for a client knows this.  It can be lead to alcoholism.  The beginning of the process usually goes smoothly.  Once you have the database designed and the UI setup, things start to get complicated.  Recently on a project, we completed the beta preview, which allowed the client to test the site out, enter records, test out our spiffy error handling and field correction functions, and overall just make sure the thing works.  Our next project meeting resulted in a pretty long list of bugs, which can be expected on a project of this magnitude. So we delegated out the list to our programmers and patted ourselves on the back for a successful beta release.  Then next week another list of bugs, and another, and another, this time consisting of the same bugs as the first week, a completely personalized tweak on this system here and there and every other imaginable problem that is every programmers worst nightmare.  Without boring you with the endless details, suffice to say that I've learned alot from this project thus far, and plan on going about it differently next time.&lt;br /&gt;Here's my plan for the next major dynamic site:&lt;br /&gt;1.  &lt;strong&gt;Log EVERYTHING related to the project from day one&lt;/strong&gt;&lt;br /&gt;This includes every version of pages created, every brainstorming session, every conversation and interaction with outside people (including consultants &amp; anyone in attendance with client meetings) The more you have on record, the easier it is to deal with the clients problems later (or the clients accusations)&lt;br /&gt;2. &lt;strong&gt;Make sure each person in your web team has dedicated consistent roles throughout the project.&lt;/strong&gt;&lt;br /&gt;Someone should handle aestheic design, someone should handle HTML related scripting (CSS, forms), someone should handle dynamic scripting (PHP, ASP, etc), someone should handle security issues (SESSIONS, COOKIES, DB security), and someone should be in charge of errorhandling ($_POST checking, DB field communication), .  On the database side, one person alone should handle any changes to Tables and Columns, and should be in constant communication with the rest of the team anytime ANYTHING changes in the structure of the database.  Lastly one person should lead the client meetings and delegate work as needed.&lt;br /&gt;3.  &lt;strong&gt;Back up EVERYTHING&lt;/strong&gt;&lt;br /&gt;This is similar to number one, except it's more detailed.  My suggestion is to create a Master log of everything on a dedicated and scheduled backup hard drive AND in paper form.  Each table in the database should have word documents and paper print outs of the structure of each table and the language used to build the tables (ex. CREATE TABLE statements).  Each web page should have the entire code printed out and stored on the backup drive, this also goes for "include" files and the like, especially if you tend to optimize code later on (ex ZEND optimizer). &lt;br /&gt;4.  &lt;strong&gt;Seperate the system reliant bugs from the user preference bugs during debugging&lt;/strong&gt;&lt;br /&gt;Alot of times during the debugging sessions you might come across things that really don't affect the function of the system, rather the "bug" is simply that particular user's problem with the system.  You cannot create a perfect application (ex Windows) This is well known and documented throughout the world, so don't kill yourself trying to fix every little nuance that the client suggests.  Any application whether web based or not will have bugs, and require maintenance or updates /patches.  As long as the system does what it is supposed to at the most basic form, you're safe to release it.  Plus by doing this, you ensure a maintenance contract with the client in the future to address these "bugs" as they come up in the future. &lt;br /&gt;5.  &lt;strong&gt;Remember what worked and what didn't and write protocols for new functions and unique system attributes&lt;/strong&gt;&lt;br /&gt;Alot of times, I've reused old code and ideas from past projects either to enhance the current site or to save time.  If this particular project asks for a unique function to be written, save it and keep it in a protocol book.  After a couple projects you'll have a nice compendium of both commonly used functions (ex date computation) and customized functions (ex numerical field ranges for forms) that you can use in the future and that you can show to prospective clients.  It can also go into your portfolio.&lt;br /&gt;That should be enough for now, while I'm by no means an expert...I've pulled out enough hair in my life to know that these things work.  Good luck.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-112801281821709768?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/112801281821709768/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=112801281821709768' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112801281821709768'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112801281821709768'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2005/09/nightmare-that-is-web-applications.html' title='The nightmare that is web applications'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-17265341.post-112800431987677111</id><published>2005-09-29T09:28:00.000-05:00</published><updated>2005-09-29T09:31:59.880-05:00</updated><title type='text'>Introduction</title><content type='html'>I am a multimedia designer working in Boston.  I am also self employed on the side and looking at the possibility of starting an LLC.  This blog will hopefully serve as a guide to people that are looking to get into the industry of design; web, graphic and multimedia.  I graduated from Endicott College in 03 with a BFA in Visual Communications.  My user name on digg.com is bluephoenix.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/17265341-112800431987677111?l=bluephoenixmedia.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://bluephoenixmedia.blogspot.com/feeds/112800431987677111/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=17265341&amp;postID=112800431987677111' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112800431987677111'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/17265341/posts/default/112800431987677111'/><link rel='alternate' type='text/html' href='http://bluephoenixmedia.blogspot.com/2005/09/introduction.html' title='Introduction'/><author><name>bluephoenix</name><uri>http://www.blogger.com/profile/04838610501317657885</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>
