• Home
  • @Spotd – Realtime stuff
  • about
  • chicago dive bars
  • tamale guy tracker
  • the current playlist widget
Blue Orange Green Pink Purple

@Spotd – Realtime stuff

Have you ever seen something happen and wish you could inform the rest of your community about it instantely? I see things happen all over the city and I tweet about them, but I wanted to create something where everyone had a common source of breaking news or other interesting things going on in the city without having to wait for major media outlets to cover them. I wanted to share a new project I just started working on using the same technology as the @tamaletracker . I spend a lot of time walking around Chicago and always notice interesting things going on – from people getting arrested, to celebrity sightings and news-worthy events.

Read More 0 Comments   |   Posted by djskinnyfat
Apr 06

Delete all comments from Wordpress

I recently ran into the need to delete all the comments from my wordpress site. I had 11,000 comments submitted and the majority of them were spam. Here is a quick and simple way to delete all the comments from wordpress and reset the comment count on each post.

If you do not know what you are doing in regards to sql or the wordpress database I suggest you do not do this. I do not know any repercussions this might cause and haven’t tested it very much other than just deleting comments. So use this at your own risk.

Open your SQL environment and follow these two steps.

1)Run the delete query on the wp_comments table – “delete from wp_comments”.
2)Run the update query to reset your post comment count to 0 – “update wp_posts set comment_count = 0″;

Done

Read More 0 Comments   |   Posted by djskinnyfat
Feb 15

45/365 Clear Crisp City




45/365 Clear Crisp City

Originally uploaded by [clint]

I crossed over the Kinzie bridge a couple days ago and wanted to come back to get a picture of the city. So before our Valentine’s Day dinner we took a walk down Kinzie to get some pictures. I forgot my tripod so I had to manually hold my camera on the bridge while trying to get shots in between cars rolling over and shaking me.

Read More 0 Comments   |   Posted by djskinnyfat
Jan 27

Tamale Guy Tracker

Everyone loves tamales and everyone loves late night situations where a friendly stranger delivers hot fresh tamales right to your bar stool. So, after some intense conversations surrounding the Tamale Guy here in Chicago, we came up with a great idea. What if it were some how possible to follow the Tamale Guy via Twitter as he made his rounds? A user community that would tweet when and where they saw the tamale guy and then users could be able to follow the progress by following the twitter.com/tamaletracker (tamaleguy was already taken).

How it works:

- twitter users send a @Reply to @tamaletracker when they see the Tamale Guy at their favorite pub in Chicago.
- then a scheduled listening service looks for any @Replies that have come into twitter.com/tamaletracker. – when a new tweet comes in, the twitter.com/tamaletracker account then ReTweets on their behalf.
- twitter users sign up to follow twitter.com/tamaletracker or simply go to twitter.com/tamaletracker.
- choose to recieve sms alerts when twitter.com/tamaletracker tweets.

Consider this the Alpha phase.

Read More 0 Comments   |   Posted by djskinnyfat
Jan 25

Slowly Fade Into The Darkness



Slowly Fade Into The Darkness, originally uploaded by [clint].

I was walking through a frozen parking lot at Chicago and State yesterday admiring the frozen cityscape when I noticed the sun cast a wicked shadow onto the buildings to the right. Since I was listening to Burial I thought it was appropriate to go with a darker theme.

Read More 0 Comments   |   Posted by djskinnyfat
Jan 24

Day 20 of Project 365 – Rays of light



20/365 Rays of light, originally uploaded by [clint].

I started playing with night shots and exposures a little more today and while looking north down Wabash towards Trump tower as I waited for the Brown Line, I set up my Gorrilla Pod and tried it out.

I think the next time I will use less exposure sine the street lights look like they are on fire.

Much love to Chicagoist for featuring another one of my photos. http://chicagoist.com/2009/01/21/extra_extra_387.php

Read More 0 Comments   |   Posted by djskinnyfat
Jan 24

KO



KO, originally uploaded by [clint].

Read More 0 Comments   |   Posted by djskinnyfat
Jan 24

Flickr

This is a test post from flickr, a fancy photo sharing thing.

Read More 0 Comments   |   Posted by djskinnyfat
Jan 23

Mobile CTA Bus Tracker

Using an API engineered by Harper I created this tiny little CTA Bus Tracker page. I was really tired of having to page through three pages to get to the bus that I wanted and then having to page back in order to change bus routes. So using this wonderful tool I was able to create one simple page with three drop downs instead of three pages.

So far it’s only been tested on my Samsung Blackjack that is rocking Windows Mobile 6. So if this doesnt work for you there is always the original developed by the CTA here.

Read More 0 Comments   |   Posted by djskinnyfat
Oct 19

Realtime Playlist for 89.3 The Current from Minnesota Public Radio

89.3The Current is an independent music station in Minneapolis that I listen to all the time. It is part of Minnesota Public Radio and broadcasts an eclectic music format of independent artists and a solid rotation of songs by local artists. The station is comparable to KEXP in Seattle and WOXY in Cincinnati.

The widget uses an XMLHttpRequest to checked against the Current�s web service. This Interval can be configured in the getplaylist.php page. The widget will automatically update itself with the most current song being played, since its using a javascript ajax call the page does not need to be refreshed to see the updated song.

Simply activate the plug in and choose where on your site the plug in should live. Once the the plug in has been actived the current song should be displayed with a link to The Currents “Now Playing” page

You can see the plug in working in the upper right corner of this page. Watch it for a while and the song will automatically refresh without a page refresh. This is the first version of this widget so please email me with any questions/comments/bugs that you come across.

Click here to download The Current realtime playlist widget from the Wordpress project home.

Read More 0 Comments   |   Posted by djskinnyfat
Oct 11

Usefull SharePoint web parts

In the past couple months I’ve come across a couple really good web parts that have made my life a little easier. These are parts that I’ve found on the net while searching for the solutions that they provide. I suggest checking them out if you are in need of a easy to set up RSS web part, smooth looking/international weather and clock web part and/or a easy to use and customizable tabbed web part.

The first one is a tabbed zone web part called ZoneTabs for SharePoint.

The ZoneTabs web part provides a group of tabs that control other web parts in a zone, so users can view them in groups rather than scrolling.

As a code sample, ZoneTabs illustrates:
- Creating a ListView server control
- Creating a web part as a composite control
- Using cascading style sheets and images to render tabs
- Creating an editor part to provide custom configuration options
- Using the ASP.NET 2.0 API to manage and control web parts at runtime

The part is available at http://code.msdn.microsoft.com/zonetabs and you can read more about it at Bob German’s blog http://blogs.msdn.com/bobgerman/archive/2008/02/19/back-in-the-zone-with-zonetabs.aspx

The second part that I started using is the BinaryWave Rss Aggregator.

RSS aggregation web part for SharePoint 2007.  Use it to display one or more feeds as a single list of article links.  Updated with stability improvements and options to open links in a new window and display/hide summary text.

The third part is a cool weather/global clock web part that I found on CodePlex.

The CKS World Clock and Weather web part allows users to display local time and weather for selected major cities from around the globe. Many of the weather and clock display settings are configurable. The weather information is fetched from the MSN Weather service at http://weather.msn.com

Read More 0 Comments   |   Posted by djskinnyfat
Previous Page 1 of 3

scrrd panda

  • recently written
    • @Spotd – Realtime stuff
    • Delete all comments from Wordpress
    • 45/365 Clear Crisp City
    • Tamale Guy Tracker
    • Slowly Fade Into The Darkness
  • Flickr Photostream

    Oops, there seems to be a problem accessing the Flickr photos.

  • categories
    • amsterdam
    • arsenal
    • chicago
    • code
    • excursions
    • internet
    • life
    • music
    • sharepoint
    • sport
    • trance
    • Uncategorized
    • web
  • Archives
    • April 2009 (2)
    • February 2009 (1)
    • January 2009 (6)
    • October 2008 (2)
    • September 2008 (1)
    • August 2008 (3)
    • July 2008 (2)
    • June 2008 (3)
    • May 2008 (4)
    • April 2008 (2)
  • Archives
    • April 2009
    • February 2009
    • January 2009
    • October 2008
    • September 2008
    • August 2008
    • July 2008
    • June 2008
    • May 2008
    • April 2008
  • Search






  • Home
  • @Spotd – Realtime stuff
  • about
  • chicago dive bars
  • tamale guy tracker
  • the current playlist widget

© Copyright scrrd panda. All rights reserved.
Designed by FTL Wordpress Themes brought to you by Smashing Magazine

Back to Top