The Internet Pinball Serial Number Database or IPSND collects serial numbers of pinball machines and publishes a database of these on the Internet. Our goal is to make available a registration of all pinball machines in existence and allow tools for slicing, dicing and visualization of the data.

Games: 6,096  Serials: 42,624  Visitors: 20,023,191  Members: 4,070  Photos: 20,246  Lat/Lng: 20,723  Masks: 3,137(51.46 %)  Traits: 455  Nudges: 103,229  Backglasses: 1,836
  Most Serials: Twilight Zone(912)  Most Submissions: Rod McLarge(2,837)  Most Points: Rod McLarge(24,294)  Highest Quality: EM-fan(9.17)  Most Nudges: King of Pinball(13,663)
News Items:

6/20/2017 - 20,000,000 visitors since we started!
Thanks for your support everyone. Cheers!

5/29/2017 - Dick Lineberry is a Nudge-Master!
5000 nudges and counting... Congratulations!

5/3/2017 - 42,000 Submissions... Woo Hoo!
Fun House submitted the 42,000th serial number today. Thanks for everyone's support... Keep the serial numbers coming!

2/23/2017 - Ice Storm Downtime...
It was pretty exciting here in Northern Colorado this morning... windy and icy... with that also was the first time we lost power for an extended period (3 hours) in about 7 years. The site was down most of the day after my VMWARE box finally drained the last power from the UPS batteries. 

2/23/2017 - 41,000 Submissions... Woo Hoo!
Dennis Braun submitted the 41,000th serial number today. Thanks for everyone's support... Keep the serial numbers coming!

1/31/2017 - pinballservice-nl really needs a new hobby!
10000 nudges and counting... Congratulations!

12/24/2016 - Happy Holiday's Everyone!
Thank you all for another great year of serial number submissions... who would have thought that we could have collected 40,000 serial numbers in 10 years!!! (BTW... the site has been up for 10 years too)... Be safe and Cheers to you all! 

11/28/2016 - Seal Clubber is a Nudge-Master!
5000 nudges and counting... Congratulations!

9/11/2016 - 39,000 Submissions... Woo Hoo!
Antti Peltonen submitted the 39,000th serial number today. Thanks for everyone's support... Keep the serial numbers coming!

8/2/2016 - FONZIE'S NIP IT!
Goodwill Industries of Southern California posted a Nip It pinball machine for sale they claim was owned by Henry Winkler.  Mr. Winkler's iconic Happy Days character, The Fonz, was known to play a Nip It machine throughout the show's run.  So theoretically, you could own Fonzie's personal Nip It!  It doesn't look like provenance is offered or if this was one of the actual machines used on Happy Days, but the site says that Mr. Winkler himself donated the machine to be sold.  Regardless, a serial number was visible in the photos, and is now a part of the IPSND!

7/22/2016 - New Trait for Jacks to Open!
Thanks to IPSND member Lenny Esposito, we have added a new trait to the Gottlieb/Mylstar game Jacks to Open to identify test units that featured an alpha-numeric display.  To read more about the test units, head over to the Jacks to Open page on the IPDB.

7/2/2016 - Matías N. Brusa is a Nudge-Master!
5000 nudges and counting... Congratulations!

5/29/2016 - 38,000 Submissions... Woo Hoo!
Thelma submitted the 38,000th serial number today. Thanks for everyone's support... Keep the serial numbers coming!

5/26/2016 - PSA: The 'right' domain name...
I own 3 domains for this site... ipsnd.net, ipsnd.org and ipsnd.com. All of which redirect you to this site. With the increase in domain costs, Im dropping the ipsnd.com domain so that will no longer work after this month. The best domain to use in your browser is http://www.ipsnd.net. Cheers!

5/12/2016 - Jon Mclean is a Nudge-Master!
5000 nudges and counting... Congratulations!

5/6/2016 - Mobile App Updates
The app has been running a few months now. I have a handful of issues to start digging into. Definitely use your WiFi if you can for the best success on submissions. I will post another announcement once I release a new version. The news within the app also has more info since that is a separate feed from this one. Happy Friday!

3/25/2016 - King of Pinball really needs a new hobby!
10,000 nudges and counting... Congratulations!

2/2/2016 - IPSND App now in Google Play Store!
With the help of our IPSND Admin Rob M., the Android App is tested enough to be official.... aka 'I think it is working now'. You can check it out on the GOOGLE Play IPSND App Page and download it from there. Also, when I publish new versions, you will now get them automatically via the store which will be nice since Im sure there will be more bugs. The app lets you browse existing submissions, plus makes it super easy to submit new serial numbers... like 30 seconds easy. 

1/26/2016 - Photo Editor Fixed...
It seems that when Adobe acquired Aviary for their online photo editor, that the API changed a little and it broke the Photo Editor (hint, if you edit your submission and then click on the 'edit photo' you get access to all kinds of cool cropping, rotation and other image tools that can help your submission photo look a bit nicer).. So, I just finally noticed that and got it fixed tonight.

12/24/2015 - Added Williams Shuffle Alley's to Database
Because we were getting serial numbers for them.. I added the 6 later model Shuffle Alley games from Williams... IPSND#30000, IPSND#30001, IPSND#30002, IPSND#30003, IPSND#30004  and IPSND#30005. These are not in the IPDB for now, but if they are ever added for any reason, we can merge them up.

12/22/2015 - Robots Ate My Brain!
Seems like a few robots have figured out how to post garbage serial numbers in order to put crappy website links in the comment text... fun stuff. So..... I had to make a change to the submission pages, this only affects NON-Members (or anyone that doesn't have login) in that, those two pages now have CAPTCHA's at the bottom. So, if you don't have a free account here, then you will have to verify that you are human now and proove you have a brain. Members will not have any differences on the submission pages. Keep it real, Humans!

12/21/2015 - Happy Holidays Everyone!!
Thanks to everyone that participates on the site regularly and especially to our fine Admins... Pete, Jay and Rob. Hope you all get an MM, AFM, CV, BBB, WOZ, or something fun and exciting for Xmas. It is stuff like THIS (read the nudge comments at the bottom)... that make this numbers-centric site so freakin' hilarious. Cheers!

12/14/2015 - New Type of Trait Collection
I have added a new type of Trait that can be defined for traits that aren't 'pre-defined'... the best way to explain is with an example... IPSND#21  came with a brass plaque that was individually numbered.. so did IPSND#4445  and finally IPSND#3169  had a handwritten number on the ball lift motor . This new trait allows people to submit their numeric plaque/ball-lift numbers with their serial number. 

12/2/2015 - Added new Trait for Hyperball
I added a new trait for IPSND#3169  after noticing that of my two Hyperballs, that one had a perfectly flat Acrylic playfield while the other one was curved in the center to make the balls naturally roll towards the edges of the playfield and reduce congestion. So, if you have a Hyperball registered, go check out your game and update the trait data by editing your submission (hint: you get another serialbot point for that data too).

To learn more about game specific properties, click on the 'Game Traits' tab of any game.


11/3/2015 - 36,000 Submissions!
Larry Le Feuvre submitted the 36,000 serial number today. Thanks for everyone's support... Keep the serial numbers coming!

10/22/2015 - Image uploads from IPhones...
I got some feedback recently from one of our members that he wasn't able to upload photos from his IPhone due to the file extension being .jpeg rather than .jpg (which is what I expected). After some quick digging, the site now allows uploading of .jpg and .jpeg files now for submissions. IPhone users rejoice!!

9/11/2015 - 15,000,000 visitors!
Thanks for your support everyone.

9/6/2015 - 35,000 Submissions!
Clive Pedersen submitted the 35,000th serial number today. Thanks for everyone's support... Keep the serial numbers coming!

7/27/2015 - Some good ole' Internet Downtime
Looks like we had some Centurylink downtime this morning. Hurray! Sorry for the interruptions and thanks for everyone for checking in when the site was down.

6/29/2015 - New Games in the Database!
Stern's Kiss Pro and Legends of Wrestlemania Limited Edition, as well as Planetary Pinball's Medieval Madness Remake are now available in the IPSND. Go ahead and submit your NIB serial numbers!

3/23/2015 - 14,000,000 visitors!
Thanks for your support everyone.

2/20/2015 - Shameless Self Promotion
Hello all!  In addition to helping out with some admin duties around here, I also run a pinball blog called Credit Dot Pinball.  I had the opportunity to interview our beloved IPSND head honcho Jess Askey last week, and in my humble opinion it is one of the best interviews ever to appear on Credit Dot.  Very informative with a specific emphasis on the history of the IPSND!  Take a look by following this link.  Thanks for your time, and keep submitting those serial numbers!

2/15/2015 - Hardware Work Today
Im going to be moving my database server over to a new Virtual Windows Server 2008R2 box running SQL Server 2012 today, so the site may pop up and down over the day. Im also going to try and upgrade my ESXi machine from 5.0 to 5.5 today if I have time. That could go south pretty quick so I may put that off until I do some super-due-diligence and get all my backups in order first.

1/8/2015 - Serial Philosophies Run Deep
It has been a fun week with us getting lots and lots of submissions so thanks for everyone finding all these numbers. A few things have come up on the nudging the past few days so I wanted to put something up here about it and also talk about some upcoming changes. Firstly, be sure to hover over the little 'question mark' if you are a nudger and don't like the serial submisson, there may be notes in there that explain it a little better and us ADMIN's may even put some notes in there. I am going to change the nudge queue form, so that if there is a comment, that it will be visible with the serial number too.  Also, please be sure to NOT submit game parts as games, even if you see the part is from a Flash by it's ROM's or something, that unfortunately doesn't guarantee that the serial number was actually from a Flash at the factory. Don't worry about the points and anyway, one of us ADMIN's will probably remove the game association anyway. More to come on that topic in the future!! Thanks everyone!

1/5/2015 - 1500 Backglasses
Rob uploaded the 1500th backglass image over the weekend.... Gay Time by Bally. We have most of the mainstream American and European games done and are just working backwards into the more obscure stuff now. We are prioritizing by games that already have submissions to fill in the remaining ones, but those get more and more challenging to find decent flyer images that can be used.

1/2/2015 - Happy New Year!
Hope that your 2014 was pretty decent and that 2015 is better... a couple updates for the new year...
  1. New Font for site: I liked Trebuchet and all, but I saw this new one and it actually seemed easier to read and was pretty snazzy looking too. Let me know if you have an opinion on it.
  2. We are up to 1410 Backglasses thanks to Rob's constant work.. everyone owes Rob a beer if you see him.


12/7/2014 - 750 Backglasses
With the immense help of Rod McLarge (aka Rob M.), we now have about 750 backglass (the 1400 I had posted earlier was our two-size thumbnail count) images on the site. I think that this is really going to help people correctly identify the correct game as there are lots of instances where a game is both EM and SS and even multiple editions (recent Stern's, Bally home vs arcade, Fireball's, etc). Since the backglass really is the thing that humans perceive when looking to identify a particular game, I hope this will help. Plus it makes the site look a little snazzier! More to come...

11/22/2014 - More backglass locations...
I have updated the site so that available backglass images will now show on the Game Page, Search Results, Manufacturer game listings and also the game listings by MPU. I will be slowly churning through the process of adding images as best I can. Big thanks to Rob M. for helping with the process too!

11/16/2014 - Heyo... Backglass Images Comin'
Im starting simple, but in the search results for games, there will now be a backglass image shown for each game. This is something that has been in the Android Mobile app for quite awhile but I figured I would move them over to the main site because it will help submitters get the correct game more often. I only have about 350 backglass images so far and I will slowly be adding more. If anyone has an archive of backglass images, I will need both a 100x100 and a 300x300 version for each game. Contact me if you want to help make thumbnails. Cheers!

10/30/2014 - 32,000 Submissions!
Felix submitted the 32,000 serial number today. Thanks for everyone's support... Keep the serial numbers coming!

8/24/2014 - 13,000,000 visitors!
Thanks for your support everyone.

7/21/2014 - pinballservice-nl is a Nudge-Master
5000 nudges and counting... Congratulations!

7/18/2014 - Serial number questions...
...can be submitted to me (Pistol Pete).  I usually respond within a day or two.

I'll answer questions about mismatches, formats, etc.  If your serial number doesn't match a mask, or if no mask is defined, let me know and I'll be happy to update the serialbot as necessary.

Thanks for your submissions and support!


7/4/2014 - Server Outage Today...
Im going to move up to a new RAID storage controller today and off my 8+year old non-RAID drives. Im doing this *before* I leave town so the server is less likey to go down over my upcoming holiday. Fingers crossed!  thanks. Jess

6/27/2014 - 31,000 Submissions!
Steven Saril submitted the 31,000 serial number today. Thanks for everyone's support... Keep the serial numbers coming!

6/3/2014 - More scrutiny :(
Jess asked back in April for nudgers to take a more critical look before clicking thumbs up. I am asking again.

The same picture, submitted under two different game names (both incorrect), was voted thumbs up under both games, even though the picture showed a slightly different cabinet stamp compared to the text entered for the serial number.

The numbers submitted and its accompanying photograph must match.  The photograph must be clear enough that you can read the number without influence from looking at the text entry. The serial number entry should be for one game only for a head or cabinet.

All of these conditions must be met for a thumbs up vote.

Thanks!


4/25/2014 - Photo Nudging Scrutiny
Hey all you nudgers! Just a reminder to really scrutinize those photos going through when you nudge them. We have had a couple fly through nudging with all up votes when the serial number was wrong. Remember to put on your critical thinking cap when nudging. I typically attempt to figure out the serial number by looking at the photo *before* seeing the submitted number and then I see if they match. thanks!!

2/28/2014 - 30,000 Submissions!
Rich Rowan submitted the 30,000 serial number today. Thanks for everyone's support... Keep the serial numbers coming!

2/26/2014 - R.I.P. Harold Ramis...
I wouldn't put this here except that Harold Ramis created or was involved in so many films that I hold in severely high regard. Keep laughing everyone!!! Cheers to you Mr. Ramis!

2/10/2014 - 12,000,000 visitors!
Thanks for your support everyone.

12/7/2013 - I need your old smartphones!
Hey you techy people out there... Since I have released the mobile app, I personally found that it makes submitting serial numbers massively easier (auto GeoLocation, Bar Code Scanner for those WMS/Bally serial labels, built in camera, etc). However, many of the top submitters on the IPSND don't have smartphones. In this day and age, we are obviously on two year tracks for our phones.... so, when you upgrade, don't throw away or give back your older smartphone, send them to me!  What I will do is give them out to our top IPSND submitters to help their cause. Keep in mind, we can use stuff that is severely old... like Motorola Droids or Pre-IPhone-3 phones. Stuff like Androids running v3 (Honeycomb, release Feb 2011) or higher or IPhone 3S, 4 or 4s' are still good. Whatdaya think? Email me if you have a source for recycled phones!! Thank you.

12/3/2013 - Server Migration Complete
The site is now running on a new 4-core, 16GB Virtual Server under ASP.NET 4.5. That should solve the issues with any login problems under IE 11 now. Here over the next week, I will continue to tweak the server to get better performance and also monitor things. If you run into any issues on the site or have any general feedback, shoot me an email. Thanks.

12/2/2013 - Login issues with Internet Explorer 11 (Windows 8)
There are some issues with Internet Explorer 11 which ships with Windows 8. I am going to have to deploy a newer web server in order to properly deal with the newest browser which I am in the process of doing tonight. There may be some intermittent outages during the evening. Stay tuned!

11/12/2013 - 3,000 Masks Defined!
Pistol Pete submitted the 3,000 game serial mask today. That means that as of today, 52.47 % of the games in the database have a mask defined.

11/9/2013 - 29,000 Submissions!
Marco Albus submitted the 29,000 serial number today. Thanks for everyone's support... Keep the serial numbers coming!

11/8/2013 - Boom!
BETA Versions are on the Downloads page


11/5/2013 - New Logo
I freshened up the logo a bit in prep for releasing the mobile app. I also finally moved to Google Maps API v3 which was important since Google was finally going to shut off the v2 API later this month. :-0

11/4/2013 - Image Issues
Had some odd photo issues today where some images where not rendering in the preview and nudge sections. It looks like the site was getting a good amount of evening traffic and the last photos uploaded were all pretty high resolution (3200x3000 px). This was causing the server to run out of memory due to a variety of 'image' processing functions that I do on the fly to resize and put on a watermark. Since my server is pretty old (Windows Server 2003) I think it is just a little bit underpowered these days. I applied a few tweaks to try and help out, so keep your fingers crossed. Anyone have a source of cheap server hosting? :-)

10/15/2013 - Beta Testers for Android + WinPhones
I have been working pretty hard the last 6 weeks on a mobile app for the site. Obviously, it will be targeted at members that want to submit serial numbers really quickly and easily as the primary function. Im adding a couple other little goodies to the site which will be a consequence of the mobile app, but Im not giving those secrets away quite yet.

Either way, for you techies, Im using Phonegap and Phonegap Build so I will be targeting I*devices, Androids and Windows Phones to start. I don't have an Apple Dev license ($99 for that... jerks) yet but I have an Android dev account and to be honest, I don't think I need anything special for the Windows phone.

If you have an Android or Windows Phone and submit at least 1 serial number a week, shoot me an email (webmaster@ipsnd.net) and let me know if you want to help get things running. Once things are tested, I will push the builds into the public stores, Im sure that will be at least 4 weeks however.


9/18/2013 - Please double-check your submissions
Please double-check your submissions.  Many submissions are being associated with an improper game.  Some leading examples were found in the current production run of Metallica.  Eight entries were placed under a one-off custom game entry for a re-themed game.  Other examples are for Eight Ball Deluxe, where there were several different production runs, each with their own unique range of serial numbers, and Captain Fantastic and Fireball where there were Novelty-only home versions.  If you have difficulty deciding where your game serial number belongs you can always refer to the photos at the Internet Pinball Database at http://www.IPBD.org to help determine the proper game listing.  Jess, Jay and I can also provide assistance via email.  Thanks and keep submitting those numbers!

9/15/2013 - Survey Says...
So you have all seen that blue bar on the side of the IPSND asking you to take the survey... well it has been up there for like 9 months now, so I figured I would give you the results as of now.

52% of you use IPhones while 43% use Android and 5% use Windows phones.

I was curious because I wanted to see if there was an overwhelming unbalance, but it fits most global data. Who Knew?  Anyway, it is valuable to see this because I have started working on the IPSND Mobile App this past week. It is based upon Phonegap and I will be using the Phonegap Build service so I should be releasing versions for all 3 platforms mentioned above when it is done (Im not guessing on that date quite yet tho).

The app will do some basics for now...

1. Submissions
2. Nudging
3. Viewing serial number lists

That last one will be interesting on the small screen so things will start pretty basic for now. Obviously, the value in having the app would be for easy submissions of new serials since phones have those fancy cameras on them!

More info in the coming weeks...


9/11/2013 - Fixin some bugs..
Jay @ IPDB pointed out a few bugs around the serial number edit page for members. There was an issue where if you deleted your existing image, it wouldn't allow you to upload a new one unless you reloaded the edit page. Additionally, if you deleted your existing photo,the nudge close date was not being cleared so if you re-uploaded, there wouldn't be any nudges, but the nudging would be closed still. In light of that last bug, I did a query for serials that where nudge closed but didn't have any actual nudges and found zero, so luckily that bug didn't seem to have abandoned many submissions! Cheers!

8/18/2013 - Whew... that was painful!
Well.. go figure, I leave town for 2+ weeks and my database server decided to forget all it's allowed firewall rules as soon as I left. What that means is that it refused to talk to any other server trying to communicate with it... like the web server and my remote desktop connection attempts. So... we were down for awhile. Sorry for the inconvenience..  I hope you didn't find any other hobbies in the interim... thanks for being patient!  Jess

7/18/2013 - 11,000,000 visitors!
It happened today... cheers!  This technically counts bot visits too so it is a bit skewed, if there were that many pin collectors, we might be able to populate Delaware!

7/16/2013 - 28,000 Submissions!
Petteri Kaakinen submitted the 28,000 serial number today. Thanks for everyone's support... Keep the serial numbers coming!

7/11/2013 - Photo Zooming in Internet Explorer 10
If you are having issues using Internet Explorer 10 and using the hover/zoom on the photos, your browser may be stuck in a non-compatible rendering mode (sounds fun doesn't it!). I made a change to the site, but you might have the information cached in your browser. You can try Clearing Your Cache. If you still are having issues, let me know!!

6/30/2013 - King of Pinball is a Nudge-Master
5000 nudges and counting... Congratulations!

4/28/2013 - Showdown Thank you!

It was great to see many of you at the Rocky Mountain Pinball Showdown this past weekend. Many of us have never met in person so it was good to put faces with names and talk about the site and what you think is the most useful path forward. I got great info from both Jay Stafford and Basil LeBlanc on some issues and a big amount of interest in the IPSND mobile app. Im not going to promise a date but I will start working on the app soon!

Thanks to Dan and Holly for a great showdown as usual. The new venue was rockin and I even got to beat Dan Gutchess on his own Firepower which was smokin fast!



3/21/2013 - 27,000 Submissions!
Antti Peltonen submitted the 27,000 serial number today. Thanks for everyone's support... Keep the serial numbers coming!

1/23/2013 - 10,000,000 visitors!
Thanks for your support everyone.

1/7/2013 - New Inline Image Editor Added...
As a first step, there is now an image editor under the submission editor that members have. It allows you to tweak your base uploaded image in several ways. Zoom, Crop, Sharpen, Brightness, Contrast etc. These are nice because you can preview each as you slide the values around and get something that shows off the serial number the best. I will be working on adding it to the main submission pages next so you can do the edits right away rather than having to go back in and edit them. Let me know if you run into any problems with it.

12/19/2012 - Member Submission Alerts...
I just added some alerts to member MyIPSND pages that notify you when you have submissions either with missing trait data (perhaps the trait was defined after you submitted the serial) or has been Nudged downwards for some reason. These alerts now link you to a list of those serials so you can update them if you wish. I will be adding more functionality to this soon that will allow you to hide alerts if you don't want to see them or if some submissions you just don't have the info for.

11/16/2012 - Mobile App Survey... Please!
If you use the site and have a smartphone, I would be interested in your feedback on a mobile app. I have been creating one but I figured that before I got too deep, that I should ask you guys your opinion first... novel really. :-)  http://www.surveymonkey.com/s/65VNXD7

11/16/2012 - A little submission cleanup...
Im going through and auditing games with serial numbers that don't match the defined masks using this stat table. I do this about once a year to either adjust any already defined serial masks for the games so that submissions with photos are all correct. If there are serials that don't match and they are blatantly different from other submissions, then I will make a judgement call on them... if they came from the old Internet Pinball Project, they will most likely be deleted since there is a lot of garbage data that came in, but it just wasn't verifiable in any way at the time. If the submissions don't match and they came from a person, then I look to see if it is blatantly wrong... like a part number, or a zip code or a phone number from the game. Believe it or not, those DO get submitted sometimes. Anyway, Im also making new mask definitions so that people that submitted rare serials will start to get a little more points for those submissions now that there is a matching mask. Happy Friday! Go drink a beer!

11/13/2012 - Grid Updates
On the grids that have paging enabled, it was always a PITA if you had paged a few times and then followed a link to somewhere else on the site. If you hit your 'back' button to go back to the grid, it would go back to the first page and you would have to remember where you were and page back up to where you originally were. I added functionality for most paged grids so that if you come back to the page, it should put you back on the same page where you left it. Schweeeeet!

11/11/2012 - A few bugs fixed...
Im not sure when, but the image rotating in the submission editor wasn't working, well technically it was working, but it wasn't saving. That is fixed now. Also fixed a problem with Nudge comments being too long caused an overflow in the database, comments are now limited to 500 characters... yes, we are 3.57 times better than Twitter. There was an issue on the nudge queue where the little 'info' icon I added was empty when hovering and that should be better now too. Happy Monday!

11/4/2012 - Trait Chart Added...
Im going to be spending a little more time focused on the Game Traits management so I added a new stat chart showing who has been submitting traits in recent history. Thanks to both Jay St@fford and Pistol Pete for helping me get traits defined for the vast number of games with funny nuances throughout their production run.

11/2/2012 - We've got scrolling...
I added 'forward' and 'back' arrow buttons to the latest photo uploads chart so it is easy to go through recent photo submissions. I found myself having to look at the statistics table to review recent submissions, so this makes it a little easier and obviously more visual.

10/13/2012 - Another Game Grid update...
I added the new clustering graphics to the game trait listing on the game grids. I also updated the way the data is loaded so it loads asynchronously just like the main serial number listing. It actually seems to load much quicker now. In addition, I added the 'Country' field to the trait listings because I had a feeling that some trends were country bound. As an example, take a look at KISS, it seems that all the plastic playfields except for one have been found outside of the USA.... interesting no?

10/3/2012 - Game Grids updated (again)
I made a substantial change to the way that the game serial listings load that will make them faster as the number of serial numbers get larger. For Doozie's like Twilight Zone which currently has 659 serial numbers, the page was taking up to 20 seconds to load while the server churned on all the data. I made the loads happen in chunks asynchronously so things are a bit zippier. I will be working on the Game Traits listing next to add the clustering graphics and also update the loading method. Cheers!

9/20/2012 - Chart GeoMaps Updated...
Believe it or not, these 3 GeoMaps that have been on the site since 2007  where some old but nice looking Flash based maps that I heisted from Google Analytics way back when and hacked into the IPSND. Google released public doman GeoMap controls recently so I converted over to those now. They look the same, but you don't need a weird archiac version of the Shoockwave player to view them anymore.

9/15/2012 - Game Grid Fixes + Masks
As with all things, there were some oddities with the new game serial number grids. Serials that didn't match a serial mask were all being grouped together into one group and serials with multiple submissions had one of those submission missing in the expando section. Also, in hopes of following in Pistol Pete's footsteps, I added about 400 more serial masks this week. The masks help the new clustering engine work better when serial numbers have Letters or other formatting oddites.

9/11/2012 - Big update to Game Serial Lists
I completely re-wrote the grid that displays the main list of serial numbers for any particular game. The biggest change is that there is a graphical representation of how the SerialBot clusters serial sequences for production calculations. It should make the concept a little more clear and my hopes are to update the grids on the other tabs next. One aspect Im particularly interested in trying is to map game trait values to clusters to see if a particular trait value correlates to a particular cluster in a production run or if the trait values are outside consecutive clusters.

9/4/2012 - 'Welcome' to the rest of the world
I finally got a Google translate drop down on the site... good thing since they deprecated translate last year, lets see how long it lasts. PS - It is all the way down in the footer, but that was the best place I could find for it layout-wise. Hope that helps some of you out there!

9/3/2012 - Total Serial Coverage?
I just added a new snippet of information to each game specific listing in the summary area which is called 'Coverage' (hence the Total Serial Coverage headline). I have been working on this over the past couple months to start doing a little deeper interpretation of the serial data. Im not going to go into it completely but there is a handy little 'help icon' next to the section that describes what it does and how it works. In a nutshell, it basically lets the SerialBot make an educated guess on the range of serial numbers submitted and really helps us understand a potential production run, even if there are skips and gaps in the serial number sequence. This whole process is a step towards making another layer of the site that allows a graphical representation of the serial numbers and their associated properties etc. Please give me your thoughts!

EDIT: I just added extended explanations of this to the FAQ.


8/28/2012 - Downtime...
We had some downtime as I had to switch IP addresses from my ISP on Monday... it seems the DNS took a bit to get through to everyone and I didn't have the old IP routed to the new location. If you are having troubles seeing the site.... well then... you aren't reading this... but tell your friends that can't see the site to clear their DNS cache or reboot their computer. :-)

8/19/2012 - 9,000,000 visitors!
Thanks for your support everyone. That number includes bots and is just a counter of active sessions on the site. According to Google, we have had about 264,294 actual people visit the site in that time and that breaks down to 170,824 unique visitors over the past 6+ years. Our average visit per day was about 40 people until the IPDB started linking to us in June 2008, after that, that average visits per day jumped up to 109 and our average visits per day this past week was 198.

8/11/2012 - Charts Changed a bit...

I have grander plans for the 'Last Photo Submitted' chart, so it is now a permanant resident at the top of the 3 charts shown on the homepage. The NEXT/PREV only effect the 2nd/3rd charts now. When I get a little more time, I will make the last photo chart a slider where you can scroll through the submitted photos in order.

On top of those changes, I made some 'updates' to structure of the site by removing some really old HTML tags and structures that were holdovers from when tables ruled the internet along with BR and HR. Also, the ZOOM window is now on the photo chart and it has been fixed in IE9 Browsers to put the zoom window in the correct place under the cursor.



7/29/2012 - Skipping Nudges...
After a good discussion with member Bif, he brought up the need for members to be able to skip past nudging of serial numbers if for some reason you just don't want to mess with it... maybe you can't decide, maybe you want to see what someone else thinks first, maybe you just want to pass and move on to others in your queue. Well, I think I have it implemented now and I tested it pretty quickly and it seems to work, so try it out and let me know if you run into any issues. Enjoy!

7/24/2012 - 25,000 Submissions!
Antti Peltonen submitted the 25,000th serial number today. Thanks for everyone's support... Keep the serial numbers coming!

7/22/2012 - Pre 25,000 Submission Upgrades...
I just rolled out some big changes on the site... hope they make things better, if you have issues, email me.
  1. The serial bot scoring range got an update... since various members have been busy adding game traits to many games, any submission that gives information on the submitted traits, now get an additional point for each trait. That makes the max point value for submissions dynamic...  so if a game has two traits defined, and you make a submission that gives data for both traits, you get an additional +2 points. This also makes the 'Highest Quality' chart a little more interesting. I may tweak this a little depending on how it pans out in the big picture, stay tuned and enjoy your new points.
  2. The Serial Bot scoring graphics have been revamped, they are clearer and hopfully easier to read by being a little crisper, plus they are transparent so they don't have an ugly block behind them.
  3. I moved several of the site styles up to CSS3 which should make the pages load a little quicker. If your pages look funny now, please upgrade to the latest version of your preferred browser (IE9+ suggested).

Because of the changes, it looks like John Vorwerk jumped over 10K points... congrats John!!!



7/14/2012 - A Few Updates...
Fixed a few bugs that had been around awhile. The one that is probably the most impactful is for those of you that print off the serial number certificates. On some manufacturers which had very long 'official' names, that name would run off the right side of the page. I made short names for manufacturers so this would not happen. Print away!

I also had a bug where you could nudge serials even if they were closed, I won't go into the details on how to do that tho. :-)


7/11/2012 - Lots of Masks and a new statistic
Pistol Pete has been helping out a bunch on the site by going through and critiquing many games to define and refine serial masks for the different games. If you don't know what serial masks are and how they help the database, here is a quick summary.

The serial mask defines one or many different formats for a serial number specific to a game. This tells the SerialBot if the submitted serials are the expected format, and shows example serial numbers on the submission page to help you all understand the best way to submit your serial numbers.

Just so you can start to see the amount of work that Pistol Pete has been doing, I also created a new statistic table that shows recently defined serial number masks.

Thanks Pete!


7/7/2012 - Please revisit your submissions...
Even if you have an 8 for a serialbot score, please revisit your submissions from time to time.  As more information on games becomes available there may be new traits you can add to a game's log.

There are also some submissions where there is an obvious typo in the entered serial number yet the photo was summarily given a thumbs up.  The result is a serial number that, though close to the photo, does not match.

Nudgers:  Please don't look only at the serial number, but at the background to be sure the photo is of the named game.  If you're not sure, check IPDB.org for additional photographs.  Sometimes a submission for one game can have a photo from another by mistake.

Submitters: It happens.  Late at night, distracted, whatever.  The number you typed, well, it's one digit short but still passes the serial number mask.  Maybe the number is from game "A" but the photo is for game "B".  Please check your submission after it's uploaded.  If you're registered you can make your own corrections.  If you're not registered then email the webmaster who can correct the serial number on your behalf.

To all:  Thanks for your efforts!


7/3/2012 - Congrats to 'King of Pinball', 3999 nudges and counting
Our 'Nudge Masters' play an important role on the site. They make sure that photos match the submissions and put that critical eye on everything. They keep the data clean, which makes the data more valuable. One thing that is fun to see are the submissions where there is a nudge war, it only takes a swing of +/- 3 nudges to close out a nudge, but there have been photos where the balance stayed even up through 25 nudges with heated debates on the accuracy of the submission photo. I made up a handy little query that shows the most contentious nudges in celebration of our esteemed QC masters.

7/1/2012 - Another chart...
I added another stat chart showing submissions in the last 90 days by serial bot score. It currently shows some terrific numbers mostly due to Antti's awesome run of submissions all with photos and geolocations. Im going to start turning my focus to getting more serial masks defined in the coming months since only 38% have masks defined currently. I will also go through and make game part auto-assign masks for all the Data East games as I have noticed that there are lots of game parts belonging to those Data East games. Of course, for specific manufacturers (Williams most notably excluded), the PCB serial numbers can be identified to a specific game by a 'game model' prefix or suffix.

6/20/2012 - Two New Charts
I added two new charts into the rotation which show some information on serial submissions and how many have extra information like a Photo and/or GeoLocation data... it is definitely getting more common to get both of those pieces of info with newer submissions. The other chart shows submissions which contain trait data. As the traits grow, we are collecting more and more production oddity data which allows us to understand minor differences in a game through the production run.

6/17/2012 - Updated some Manufacturer Stats...
I fixed a bug on the Manufacturers page which was causing game counts to not show. While I was fixing it, I added a few new columns showing serial counts, production date, production run as well, this is now a pretty nice summary and all columns are sortable if you want to see the data differently. In addition, I added some more details on the specific Manufacturer pages linked off that page, a little more info on each manufacturer now too.

6/13/2012 - Game Part Submissions and assigned Game
It is pretty common for me to get questions about why game part submissions don't let you specify the game (if you want to know more read the FAQ). In the past I sort of manually went through the game part submissions to see if they happened to be for a game that had the game explicitly defined in the serial number (generally a prefix number, see here for more info and examples). Well, I made a little routine that runs after every game part submission that looks to see if the submitted serial number matches one of these well known serial formats and it gets assigned automatically. This will do two things for y'all...
  1. It will get your part submissions showing up in the game listing ASAP.
  2. It will get you another point from the SerialBot.
I will keep monitoring this new 'feature' to make sure it doesn't go awry, but I think it should work out okay. Upon first run tonight, it assigned about 300 game part serial submissions a matching game.


6/12/2012 - Fixed some IE9 Compatibility Issues
Looks like a few things were acting funny in IE9. Most notably the Zoom window on the serial number submissions and the Nudge Queue were pretty much unusable. I fixed these today and I have been working on several new stats now that the database is about to cross 25,000 serials!!!  Thanks for the participation!

3/9/2012 - See you at the Showdown!
It's that time of year again, time for the Rocky Mountain Pinball Showdown... in south Denver from April 27-29th, 2012. Dan and Holly organize a great show and there are so many great games brought by collectors in the area. Keep watch on their website for updates, and start practicing for the tournaments.

1/19/2012 - Whew!!
Hey everyone... sorry about the downtime... I had a hard drive fail on my brand new (2 weeks old) database server and oddly, since it was raid, took a lot more time to get fixed than normal. I thought I was going to have to fall back to a database copy from 2 weeks ago, but I managed to get everything back to normal now.

12/25/2011 - Happy Holidays!!
Merry Xmas and Happy Holidays to all 2297 members and other pinheads out there. Thanks for supporting the site and the hobby. Be safe and see you next year. 23, 295 submissions and counting.

11/23/2011 - Site Outage...
The site was down for about a day and a half due to some database issues. The database grew and used up my drive space so I had to give it a little more allocation. Seems to be feeling better now.

10/28/2011 - Logo Contest!
It is time... time for my mediocre photoshop logo to improve, however I just can't do it. I need your help. If you fancy yourself a pinball aficionado AND someone with graphical skills, send in your logos for the month of November and I will post them into a survey where everyone can vote on their favorites. You will get credit of course on the 'About' page and your work will be on display to everyone and something to be proud of. Logos bring demz! Email logos to webmaster@ipsnd.net.

10/20/2011 - Submit/Edit Interfaces Improved
I put in some new functionality on the serial number submission pages and the member edit for that fixed an issue with the Google Map and also took care of some weird things happening if you put in information in a specific order. Basically, I made the photos and location sections work via AJAX which makes it a little more user friendly. Also, another thing that always annoyed me (and slowed the site down), is that the user stats in the login box now loads asynchronously and should always be accurate on your current nudges remaining.

10/13/2011 - Several Bugs Fixed...
Since I was stuck in bed for a few days after knee surgery, I responded to about 15 emails that I had sitting in my inbox and also fixed a few items that had been broken for a while. Nothing super big except I will say, some pages should look better in Internet Explorer now. Thanks.

10/3/2011 - A note on photos...
I just wanted to remind everyone that photos can be a touchy subject on the internet with copyright etc. Over the years, many photos from the IPDB have made their way into the serial number database which is useful, however, sometimes the owners of those photos don't appreciate the heisting of the image without their permission so please don't post images that are not yours to share. I want to operate the IPSND with as much transparency as possible so Im going to implement a few 'reminders' on the submission pages and also make it easier for copyright owners to request images be removed from the site if they feel strongly about it. Some existing IPDB image will also be removed based upon some feedback I have received. However, with ~5000 images in the database you all have done some amazing work documenting serials... thanks!

7/23/2011 - Downtime on Sunday...
It has been a crazy summer, Im getting all my pinball machines back (including two which have been down at New Belgium Brewing for the past year). I have also been working on my server infrastructure here a little. I finally have ESXi set up and will be transferring all my servers into their new virtual environment on Sunday night. Not sure this will do much for performance of the site right now, but it will help my sanity (and my backups). Im going to put the IPSND into maintenance mode sometime on Sunday night until the transfer is complete. Apologies for the interruption!


4/6/2011 - Complete Genius!
Okay, this is sort of a no-brainer when you really think about it, but Wes M. beat everyone to the punch in showing his ingenuity and quick wit by submitting a serial photo that included a paper rubbing of the serial above the actual serial. As we all know, those impression serials can be much easier to read in person rather than via a photo and Wes' method helps take away any ambiguity I think. Check out his photo here... http://www.ipsnd.net/details.aspx?id=20953. Thanks Wes!


3/6/2011 - Server Down this Weekend...
I had some issues with my NIC on my webserver this weekend so the site was down Saturday and Sunday. Im going to look into virtualizing all my servers this month to solve several issues so we will see how that improves things. Also, on a side note, I change my Internet Speeds in the past couple of weeks which increased my upload limit from 1Mbit to 5Mbit so site speed should be a bit snappier. Thanks to everyone who has given me donations recently as I am applying this directly to a new server!!


2/25/2011 - Zaccaria Gen II Serial Masks Defined
After talking to Marco A. about the Zaccaria games and their various serial number formats. He pointed me to Federico's Italian Owners List Site which has a nice collection of serials that can help me get the masks defined for these games. I have the Gen II games defined and will continue working on the earlier games over this weekend.


2/13/2011 - Submissions by Year
I queried this out of curiosity and everything is lookin good...

2006 - 1046 Submissions (doesn't include IPP serials)
2007 - 1528 Submissions
2008 - 3223 Submissions
2009 - 2849 Submissions
2010 - 3277 Submissions
2011 - 500 (as of Feb 13th)

Keep em coming!!!


2/6/2011 - Woo Hoo!!!! 20,000 Serials!
Not sure what it exactly means but 20,000 sounds like a lot at least. The 20,000th serial was submitted by Bob Romeo today for Time Fantasy... ah, so close to my heart (Time Fantasy, not Bob... Sorry Bob). Thanks to everyone that supports the site and keeps it lively. We will just keep chuggin' away at these things!! :-)


2/5/2011 - Stern/Sega Serial Fixes
We had a handful of Stern/Sega submissions that were prefixed with an 'E', seemingly meaning that it was an 'Export Game'. The problem was that the game definition in the database only had one serial number mask defined which did not give the option of the E. It seems many of the games that went to Canada or Europe and had serials submitted had the E dropped in the submission. This problem came to light because of a recent submission by Marco Albus for Viper Night Drivin' in which he dropped the E since it was saying that by including it, the submission didn't match any masks. Luckily some of the nudgers were debating the accuracy of the submission and I caught it. I added 'Export Game' masks for all Sega/Stern games so this will not be a problem any more. I also changed Marco's submission (thanks Marco, I still own you an email too) to include the E and went through and tried to find all other submissions that had a photo to verify they should have had an E and changed those. So... great job being strict on the nudging everyone, plus if you ever see 'problems' like this, let me know via email and I will gladly try and get things put in proper order for sanity. Cheers!


1/8/2011 - Nudge adjustment (nudge?)
Based upon some feedback I received from Jim Smith, I changed the way the nudge queue looks on the screen. His suggestion was to move the comment field up above the voting buttons since it wasn't apparent that you had to put a comment in *before* clicking the thumbs-up or thumbs-down buttons. So, I think he makes a great point, so it has been moved. Additionally, I changed the way that the 'My Nudges' page works under your profile... not only does this list all the nudges you have completed but it also allows you to see what your nudge was and what everyone else has nudged. In addition, you can also *delete* your nudges if you want to change anything about your first attempt. I think this should help out everyone on the nudging front... thanks Jim!


12/1/2010 - Updated FAQ
I added a few new questions and answers to the FAQ based upon the fact that the nudging feature isn't very well explained on the site anywhere. I also added some answers to some other questions concerning submitting serial numbers multiple times (as the same person). John V posed an interesting question about re-submitting a serial again rather that editing it in the case of selling a game. What I did was allow duplicate serial number submissions by the same person as long as it is more than 90 days after the first submission. I don't think people are going to abuse this loophole and try to rack up tons of points on the same serial, but please don't try as I run reports to monitor that sort of stuff anyway. :-)


11/30/2010 - Bugs vs. Features
Well, Im pretty sure that the concept of members having my personal nudges listed under theirs on the MyIPSND nudge page was fairly interesting, John V. pointed out that it might not be. I fixed that issue tonight so you can actually see your own nudges. I still need to add some more fields so you can see your nudge along with the final vote for comparison.

Also, I added 'Social Media' links on the homepage and the game pages. Mostly for fun since my day job incorporates lots of social media. I was sort of wondering if we can dis-prove the perception that pinball collectors are anti-social!!??  Let the experiment begin!

ipsnd.net vs www.ipsnd.net - Both of these URL's work, but I added some code so everyone will be gently nudged to using www.ipsnd.net. Having both URL's available was really making the social media links work poorly, so now the fully qualified name is where you will end up automagically even if you type in the short version.


11/20/2010 - 5 Million Visitors!
We crossed the 5 mil mark this past week. Pretty cool considering the site runs on a crappy old computer that I paid $300 for about 6 years ago and I did this in my free time. Thanks for everyone that participates on the site.. we will be coming to 20K serials here pretty soon... maybe that requires a pinball party at my house when it happens! :-)


10/5/2010 - Bulk Import Complete
I just imported over 500 serials from our esteemed friend Daina P. who had gathered these numbers from his repair jobs over the last 10 years. Remember, if you have lots of serials to import, I can help make it a little less painful. I should probably write a little Droid application to make submitting pics easier ehh? Better put that one on the development queue.


9/20/2010 - Game Traits 'Enhanced'
Due to a flurry of Game Trait submissions by Jay Stafford and a great discussion on how to accurately describe some of them, I have added the ability for users to upload a photo with each new Game Trait defined. After trying to describe a trait for Capt. Fantastic, using words only, it became clear that a picture can truly be 1000 words. Keep watch for some more development around this idea in the next few weeks. Thanks Jay!


7/18/2010 - Updated new submission rss feed
The original feed only showed the top 25 feeds. After using this for awhile, it was a little annoying actually since somedays there are quite a few submissions and I was missing them in the feed and had to go back to the statistics page to see the rest. Anyway, I changed the list to show the last 100 submissions instead based upon that reasoning. Plus, since some nudgers are now using this feature, you can also adjust the feed URL to only show submissions with photos (http://www.ipsnd.net/submissions.rss?photos=1). I will be adding some more functionality to all the feeds over the coming weeks that allow better versatility on getting what you want to see. If you have any specific suggestions, let me know. thanks.

7/14/2010 - New RSS Feed
I just created a new RSS feed that shows the latest submissions on the site. I did this so that with my handy Windows 7 sidebar, I can subscribe to the feed and see what is going on pretty easily from work or where-ever. I also thought it would be handy for those 'super-nudgers' that keep watch for submissions with nudge-ready photos. The info is on the RSS Page and the direct link to the new RSS channel is http://ipsnd.net/submissions.rss


6/22/2010 - Network Migration Completed Strikes Back!
Looks like Qwest didn't quite have things set up correctly as my static IP started changing on me. Some of you may have been unable to reach the site over the course of the past 2 days. They fixed my account and I have just updated DNS again to the new hopefully static IP address. Things should smooth out in the next 24 hours. They also informed me that my 40Mb/s line is only set up for 12Mb/s so I will see if I can get that put back where it should be tomorrow. Since my connection is VDSL2 rather than ATM, I should have upload speeds around 10Mb/s (which is download speeds for you)... that is 10x faster than I had in Laramie.


6/19/2010 - Network Migration Completed!
If you are reading this, then the migration of the site from Laramie, WY to Fort Collins, CO has been successful. I am now running on a Qwest VDSL2 connection with a theoretical speed of 40Mbits/second down (up for you) and 20Mbits/second up (down for you). That is a pretty hefty improvement over what I had up in Laramie with ATM DSL so we will see how it goes. If you notice that the sites is better (or worse!), drop me a line and let me know.... Im curious to see if this connection is actually any better. Thanks... jess


6/12/2010 - Submission Page Updates
I added a little new logic to the serial number submission page that dynamically checks the serial number against any defined serial number masks in the database. If the submission doesn't match, you get a little more information right up front rather that not knowing until after you submit the serial. I also fixed some dumb typos on the Game Part submission page and added some links to the reasoning behind not associating game parts with a specific game.


5/26/2010 - A couple milestones...
Looks like while I wasn't paying attention, that we crossed the 17,000 serial mark and also 4 Million Visitors on May 15th. I have been working on a few new charts that show the trendlines for both of these metrics since the site started, they are unusually constant which I didn't really expect to see. I should get them up here in the next few weeks into the regular statistic charts.


5/8/2010 - Whew, that was a long one...
We had a pretty massive wind storm here on Thursday night and lost power for about 8 hours. My database server didn't come back up after that little downtime incident (looks like the motherboard is the issue), so I had to transfer to the database over to a different machine and get everything configured. Things will run this way for a few weeks and then Im planning to move to a virtual environment which will make servers a little more manageable (I think!). Everything *should* be up and running now. Let me know if you run into any issues. Thanks.


4/21/2010 - See you at the Showdown!!!
Don't forget to swing by the Rocky Mountain Pinball Showdown from Friday-Sunday this weekend in Golden, CO. Dan and Holly put on a great show and there are lots of unique games slated to show up this year!!!! I will be giving a presentation on the Internet Pinball Serial Number Database on Saturday @ 4PM to go over features and get feedback from all you!!!


4/20/2010 - Account Bug Fix
Fixed a small issue where accounts that were locked out due to too many invalid passwords couldn't be re-enabled via the automated system of emails. I also had a fairly entertaining postfix mail server issue on April 15th due to ClamAV disabling their daemon if the version was too old. That is the problem with Linux, it works so well that you never really have to touch the box.... who knew it had been on and functional for 3 years without a reboot!!!


3/21/2010 - Small GUI Update and a Bug Fix
The statistical charts that show on the right have classically been .jpgs for maximum compatibility. Being that Google Analytics is showing that over 95% of you have Flash installed, I changed them into .swf format now. The one nice thing this give is that the data points can now have a URL associated with them. So for instance, most of the bar charts are now clickable on the bar and will take you to the page for that member or game. I will keep trying to enhance these little graphs more in the future too.

Also, I fixed an issue with the Affiliate pages that was causing an odd error on sites that linked to the 'real time IPSND data grids'. If anyone is still having any issues, send me an email and I will take a deeper look.


2/6/2010 - IE Fixes
I fixed some issues with the login form (upper right corner) that was preventing IE 7 + 8 users from being able to just hit the 'Return' key for logging in. The old form always seemed to work for Firefox users but for IE 7 + 8, you would have to explicitly click on the login button. Either way, this should now be fixed so you IE users shouldn't be as confused anymore. :-)


2/5/2010 - New Site Security Roles Defined
It has become apparent over the last year that some users would really like to help participate in the site in various areas. I didn't have a lot of security driven functionality outside of one superuser (me) and then members having access to their own info. I have created three new security roles and assigned some users into those groups based upon conversations I have had. The two new roles are 'Mask Moderator' which allows a user to create, edit and delete any serial number mask in the database. The next one is a 'Serial Snooper' and this role allows the user to edit and/or delete any serial submission in the IPSND. The final one is a typical 'Administrator' and allows the user to do user maintenance, assign roles and run Synchronizations with the Internet Pinball Database. If you are interested in learning about these roles and their responsibilities drop me an email.

2/4/2010 - Development Tasks added
I added a new main menu item called 'Development Tasks' that shows the current queue of stuff that I am trying to work on and what I am planning on working on in the near or not-so-near future. The idea is that members can submit topics here and if they cut the mustard, they will go onto the development list. There have been some great topics coming up about deeper questions on how the IPSND should interpret and collect data and hopefully those lead to more insight and more development on my end.

1/28/2010 - Skin Updates
I deployed new code today that has the newest version of Telerik RadControls for ASP.NET AJAX this morning. So, some of the grids look a little different at this point. My goal is to soon give members the ability to choose their skin in the member preferences which would allow members to customize the way the IPSND looks for them. The 'big picture' goal is to take this to the point where even the background images can be selected by category... so for example, a member might select 'EM Games' as their preference on backgrounds, and so they would only get older EM games showing for their random backgrounds.

1/18/2010 - Silverlight Experimentation
I am starting to experiment wtih Silverlight as there are several areas where some client side processing might work better and to be honest with you, I don't like Javascript. :-) Right now, the top logo is built with Silverlight and so in order to see the logo at all, you will need Silverlight installed. I will be working on fixing the logo to be 'Non-Silverlight' compatible this week again. So... what does this fancy new Silverlight logo do for you? Well... not much. However, you if you rotate your mouse wheel upwards when hovering over the logo, you can cycle through some random colors. The color you leave it on, is the color that it should remain on the entire site forever (I think), so pick a nice color and enjoy. I will get the default color set back to the Yellow that it used to be rather than the ugly red that is currently there!!!!!

12/8/2009 - 10,000 Nudges
We have had a total of 10,000 nudges in just under 1 year since I added the Nudging feature. It has been interesting to see how the submissions started getting photo's attached more often now that nudging can directly affect the scoring of a submission. We will see how the new commenting feature works for nudging over the coming year. Just to mark a milestone the current leading member of nudges is 'King of Pinball' who currently has 925 nudges.

12/8/2009 - Nudge Comments Added...
One more quick feature for the evening before I start to do 'real' work. I added the ability for members to add a comment to their nudges in the main nudge queue. You can also see all the other nudges that exist with their score and comment for comparison purposes before you vote. I added this because on some of the more controversial nudging threads, I really couldn't see why some people voted a certain way. Even tho it is optional, maybe this will allow members to 'vent' along with their vote! Have fun!

12/7/2009 - Bug Fixed in Submission Form plus Nudge Counter improved
I fixed a bug in the submission edit form that was changing the submission type (Full Game, Body Only, Head Only or Game Part) when you would edit any GamePart. The bug was changing the type from a Part submission to a 'Body Only' submission. John Vorwerk noticed this issue on his submissions... thanks John. Another change I made today was with the Nudges Remaining counter in the member stats box. This number was updating every 15 minutes just like the rest of the stats and was a bit misleading especially if you were in the process of nudging a bunch of serials and the box still said you had X number of nudges remaining. Im working on getting the entire stats engine to be realtime rather than batch processes every 15 minutes. The process is time consuming just because the counters require queries that span about 15 tables and as the site grows, these tables only get bigger and hence take longer to execute.

12/4/2009 - Statistics Fixed
When I deployed that last 'upgrade' several of the other statistics pages broke due to a ViewState issue. I have fixed the issue and the stats should all be feeling much better now. More stats to come soon!! Keep watch!

11/30/2009 - Manufacturer Listing Bug Fixed...
Looks like the page showing games lists by manufacturer had a bug in it that excluded games without any serial submissions. This came to light due to a question from Jay Stafford about Alvin G. and Company serial numbers and their formats. For these games being fairly new, we definitely don't seem to have many serials registered so far. Out of the 12 games manufactured, there are only serials for 5 of those games. If you have any Alvin G. games, please register the serials so we can start to understand the formats for these games. One item of distinction is that these games sometimes have both a 'serial number' and a 'cabinet number', please register the 'serial number'!

11/23/2009 - Statistics Update
I just added two new statistics to the stats page that show top submitters by total points and top members by most nudges. I am in the process of overhauling the stats page and the engine behind the statistics to make it more accurate. There is actually a bug in the statistics engine that a few of you have pointed out to me and I have known about it, but just didn't have the time to get it fixed. Since Basil LeBlanc is now moving up the charts so strongly, I should get it fixed as it will not give him credit for several rankings. In the past, it only affected me since I had so many points, so I didn't mind. :-)

11/1/2009 - Site Downtime
The site was down today for 4-5 hours while I played around with some hardware issues. I thought I would improve the server a bit today by adding some more memory and it all fell apart from there.... after reboot, none of my network interfaces existed and they just wouldn't come back. I threw in a temporary one and it worked fine, so we are running on auxilliary NIC right now. I should be able to get this resolved today still. My apologies for any interruptions if you get booted from the site. Thanks for the patience.

8/29/2009 - 3,000,000 Visitors!!!
Looks like we crossed the 3 million visitor mark earlier today. Thanks everyone for your support, the serials are pouring in at a faster rate than ever before!!

8/28/2009 - IPDB Synchronization
I just finished a fairly large database synchronization with the IPDB that included about 600 database updates. I try and synchronize with those guys every now and again to keep my database up to date with all the great info they collect. Overall, the IPSND gets the game name, manufacturer, manufactured date, mpu type, game type, abbreviations, production run and associated flags. Without the excellent quality and data normalization of the IPDB, this entire process would be much more difficult. Thanks again guys!

7/7/2009 - Photo's Photo's Everywhere!
Just an update on the serial number photos... since this feature was rolled out in Feb 2008, we have collected over 1000 photos of serial submissions. That is about 1 in 4 submissions that have an attached photo. This is pretty damn nice and I appreciate all you that are taking the extra effort to get that camera into sometimes difficult positions and lighting situations to grab that high quality photo. In addition, our average nudge balance is 2 positives for every 1 negative nudge so that means the photo quality is also edging much better than it is worse. I thought these numbers were interesting enough to share with everyone... thanks all... keep the photos coming!

7/5/2009 - Site Downtime
We had a power outage here in Laramie once again while out of town for the week... for some reason my router didn't reboot properly when power came back up so the site was down for the last day... my aplogies. All should be well now.

5/16/2009 - Edits of Game Traits
Pete Knoll requested that the member submission editor form allow members to update their custom game traits (for example... Playfield Plastics Artwork Style on BK2k). I finally got a little bit of time to take care of this so the edit form now has a section for updating and/or removing these fields. This should be nice as submissions that were entered prior to the trait being defined can now go back and update their trait. Thanks Pete!

4/24/2009 - Member Password Changes
I received an email from Heinz Ostlund this week asking how he could change his IPSND member password, as I was logging into the site to get the direct link to the 'change password' page, I discovered that there wasn't a 'change password' page... hmmmmm. I really thought I had done that, but low-and-behold, I apparently had not. So, for all of you members that have silently dealt with this lacking feature for so long (and Heinz too), I just got one put out there. It is accessible under the 'MyIPSND' link in the account summary box in the upper right of the screen.

4/14/2009 - More Google Maps
There is a new tab on each game detail page now simply called 'Map' which will show a very pretty Google Map of all submissions that had a GeoLocation entered. It is pretty basic now but it does look pretty cool. This ties into the new statistic I added a few days ago showing games with most Geolocations submitted. Currently there are 517 distinct games and 1100 locations which using current totals is about 10% of the games and about 7% of the total submissions. Keep those GeoLocations coming in!!

4/13/2009 - Image Tools 'Fixed'
Based upon a conversation with Pete Knoll last week about the quality of the uploaded images, it was deemed that the ipsnd image processor was affecting the quality of images even under the magnification tool. I reworked this code so that under magnification, the image shown will be exactly as the uploaded photo was without any degradation effects from processing. I think Pete made a good point in seeing this issue and hopefully it will affect nudges in a positive way. Thanks Pete!!

4/12/2009 - New Statistic Added
There is a new statistic showing games listed by number of submissions with a geolocation. You can see the stat on the Statistics Page to get an idea of games with the most Lattitude/Longitude data available. This feature is the first in a slew of related features I will be rolling out this week.... keep watch for more info.

3/26/2009 - Earth Hour Downtime
We will be down on Saturday March 28th for one hour from 8:30-9:30PM Mountain Standard Time (GMT -7:00) in order to participate in Earth Hour. Please take the time to participate in this global event whereever you live!! As long as my servers come back up after cooling down we should be up and running pretty quick afterwards, if Im not back up, then the capacitors on my motherboards have probably dried up to the point of too much AC ripple!!

2/1/2009 - Nudge Adjustments
Now that the nudging has been running a while I have been looking a the data and it has been pretty nice so far. Members are doing a terrific job of weeding out the bad photos by consistently nudging them down. In some instances submitters have re-submitted a new clearer photo in order to reset the bad nudges their bad nudges and start fresh. One thing that I have noticed however is that on those submissions that are quite clear and close, that the nudging was very one-sided and it was getting silly to allow people to keep nudging since it was clear that the photo was accurate. So, I have implemented a new rule on nudging... if a serial has received more than 5 nudges and the sum of those nudges is more than 4 or less than -4, then the nudge will automatically close. This should keep things a little cleaner from a storage standpoint. We will see how it goes, Im guessing the nudge rules will still be changing in the future. If you have any questions or suggestions, drop me an email.

1/12/2009 - System 1 Updates
I went through and cleaned up the serial masks for all the Gottlieb System One games in order to better classify them and due to lots of submissions by 'Roller Disco Rocks'. The System 1 games have fairly straighforward serial formats but since it is clear that sample games start at 1000 and production games always start at numbers greater than 2000, it is very possible to define very strict masks for these games. Additionally, since the game PCB's contain the serial number *plus* the Game ROM Letter as a suffix, these serials can also be defined quite nicely.

1/4/2009 - A little downtime
Seems like my ISP had some issues last night and we were down from midnight until 11AM MST (-7:00 GMT). In this process I also discovered that I am still reliant on the Qwest DSLAM so I will work on changing that so I go directly to my ISP's DSLAM which will help with troubleshooting in the future. Hat's off to Visionary Communications who is my ISP and always takes very good care of me.

12/29/2008 - More Nudge Data
At the request of Mark Gibson, I have added two new ways for you to view stats about nudges that have happened. The first is a simple table in the Stats Page that shows up to 250 of the most recent nudges. The second is a section at the bottom of the detail page for any submission. If there has been a photo uploaded, then of course the SerialBot score box on the right shows the summed totals of all the nudges, but now, down below, there is a grid that actually shows all the nudges.. the date, who nudged and the nudge direction. In theory, these should always add up to the nudge total shown at the top of the form even tho they are being calculated in two completely seperate ways. :-)

12/27/2008 - SerialBot Scoring Adjusted
Now that the nudging feature has been rolled out and based upon some stats, I have modified the algorithim for calculating SerialBot scores and adjusted the 'Physically Viewed' property to only gain the submission +1 point instead of +2 points. After looking at submissions, it was apparent that while physically viewing a serial might give some advantage to accuracy, it might also not as people are just as hasty on reading actual serial numbers off games and might even pay less attention and give less scrutiny to the number than reading a number off a photo. So, for now, I have changed this. Everyone's scores will reflect this change immediately and you can see the average pretty much dropped by 1 point.

12/26/2008 - Member Nudge Queue
There is a new page (accessible in the login box for members) that gives a really easy to use interface to members in order to quickly move through all the photos that a user has not yet nudged. Since I want to make nudging as easy as possible, this should really help. Remember, members get an additional point for each nudge so it is really simple to gain lots of points simply by reviewing the submitted photos to see if they match the submitted serial number.

12/19/2008 - We put the NUDGE back in pinball!
There is a new feature on the site for members that I just deployed. I call it 'Nudging' and it basically means that members can vote on photos that have been uploaded with other people's submissions, if they feel the photo accurately shows the serial number and is correct, they can 'nudge' the SerialBot score up by one point. If the photo is innacurate or does not show the serial number clearly, then they can 'nudge' it down a point. Any number of members can 'nudge' any serial but the total points that can be gained or lost is currently limited to 3. We will see how it goes. Im still working on all the scoring algorithims so things may be a little out of whack for a couple days till I catch the bugs.

12/18/2008 - Site Speed Updates
I have been added background worker processes to the website to do things like generating the quickstats at the top of the page as well as the user stats that display when a member is logged in. Unfortunately, these worker process were taking up huge amounts of memory and bogging down the CPU when they ran and conglomerated all the data. Either way, I spent some time this week learning about threading and additionally using exclude fields in LLBLGen. After some improvements the aggregation processes now run substantially faster and with much memory consumption. This should make the site snappy like it used to be and maybe even faster since the quickstats don't run on each page load now.

12/16/2008 - FAQ Updated
I added 4 new answers to the Frequently Asked Questions that dealt with some of the newer features and some member questions that I received alot. If you have other questions, feel free to email me.

12/11/2008 - 2 Million Visitors!
Thanks for everyone's support over the last few years... the site has really come along and we are getting great traffic. Special thanks to the Internet Pinball Database as they refer so many pinheads this way!!!!

12/6/2008 - Member Edits Overhauled
I completely overhauled the interface that members use to edit their submissions. The old way used inline forms and that was becoming slow and clunky. I moved the edits to it's own page which allows members to edit all aspects of their submissions including photos and Lat/Lng locations.

12/3/2008 - Another New Stat
I put anther stat in the chart rotation that shows members with the most serialbot points. I thought this was fairly interesting because although 'pinballeric' currently has the most submissions by quite a bit, he doesn't have a huge lead over #2 Dan Gutchess as far as total points. This is because the serial numbers that Eric gave me (from the Pinball Price Guide) don't have any photos and were not physically viewed so that dropped the points per submission that Eric had. Dan you only need like 350 more points to catch up to Eric now!!!!

11/25/2008 - Stats Updated
The Most Recent Submissions statistic works more like the rest of the grids now in that it shows icons next to the serial number if there is a photo and/or and Lat/Lng submitted. This makes it easy to see in that list which items might be interesting to look at. I will be removing the stat page that lists submissions with Photo's since that stat is now easily seen via this page change.

11/23/2008 - Submission Details
I changed the way the 'details' about submissions are viewed. I had about 3 different pages that all had something to do with showing summary information on a single submission plus most of the details were shown in-line with the sumission grids. The grids were getting slow as games started to get 200+ serials and they were just sorta clunky. I made the details link go to a new page now that gives all the submission specific info along with the submitted Lattitude/Longitide and the photo if available. This page also shows the history of a serial number in case there were other submissions in the past. Hopefully this should make things work a bit cleaner. I will be working on making the 'edit' process easier for members next. Stay tuned!

11/23/2008 - Site Maintenance
I had to install a new router today and reconfigure my firewall so the site was down a couple of hours today. All seems to be running fine now. I will keep watch for any issues. If you get any strange errors, please let me know. Thanks.

11/4/2008 - Americans... Go Vote!!!
Don't let this tuesday go by without voting!!! It is your right and privilege, don't squander it. Get your ass out there!!!

11/3/2008 - Several Updates
There are two new 'quickstats' in the page header... Masks which show the number of games that have a valid game serial format mask defined. This is a regular expression that defines what is a good vs. bad serial number for each game. Right now we only have about 34% of the games defined and I will be working on slowly improving that number as more serials show up. If submissions have a photo, it makes defining a mask even easier as the picture never lies. The other quickstat is Traits, these used to be called 'Community Defined Fields' but that was long and boring, they are now called 'Traits', this is a count of the number of traits defined on all games. Additionally, there is a new statistic on the Stat page that shows number of games without a mask defined by the number of submissions, this gives me a really easy way to see games that might have enough serials (generally 3-4) to try and guess on a serial format mask.

10/20/2008 - Two for the price of one!
Yes, that's right... for a perpetual time, you get two charts on the right side of this screen for the same low low price of the one that used to be there. You will see incredible improvements on your ability to absorb new and informative statistics about the usage of this site along with subconscious needs to submit more serial numbers. Call Now!

10/17/2008 - Site Downtime...
In my haste to deploy the new 'Lat/Lng' quickstat this morning before I went to work, I accidentally broke most of the site. All should be up and running now.

10/16/2008 - Calculation Bug Fixed
There was a problem with the query that calculated the top submitters by submission quality that is now fixed. The issue was for people that had photos submitted and was causing those SerialBot points not to be tallied properly. You will now see that our quality of submissions is drifting upwards!!! Thanks everyone!!

10/14/2008 - Finally, a submission map!
There is a new chart in the rotation that shows submissions for the past week. It will of course only show submissions that have a Lat/Lng associated with them, so remember that when you submit. It took me 3 weeks to get the Flash file to display the dots as blue rather than the default Google Analytics Orange color but finally it works. If anyone out there is proficient in Flash Actionscript 1.0 with massive amounts of prototyping, I could use your help. Going from C# to AS1 is not pretty!!! Enjoy!

10/13/2008 - Maps on Game Parts Page...
I added the new google map locator to the Game Parts page now too. You may now submit your Lat/Lng with any game part serial submission just like full game serials.

9/28/2008 - Google Maps Integration
There is a new section on the game serial submission page that allows you to set the location of the game serial number you are submitting. While there currently is not a way to view this information. I will be working on that over the next few weeks. What I hope to accomplish with this is to see how a game travels over the years as it is bought and sold etc. My next step will be to get this map interface onto the game parts submission page.

9/17/2008 - Web Server Upgraded
I have moved the site over to a new web server which is a bit more capable than my old Athlon XP 1900+ and has more memory as well. It was getting to the point where I had to reboot the server every week due to memory leaks (thanks ASP.NET or Windows Server). There were some interuptions this weekend while I did the switchover but I think that all is well now.

8/10/2008 - New Quickstat Plus Another Chart
There is a new obscure quickstat listed in the header... 'Highest Quality'... this shows the person that has the highest overall average of serial bot scores across all their submissions. You have to have at least 10 submissions to get in this stat as it is easy to have a high score on one submission. I added this to give credit to those submitters that take the time to submit only 'in person' serials and accompany them with a picture (the best way to get a high serialbot score). Also, there is a new chart in the rotation that shows the top 5 highest averages by submitter!!

8/9/2008 - Bad Servers Documented
I threw another chart into the rotation that displays the number of servers that have been blacklisted by me by day. While this isn't probably the most interesting statistic to everyone, it is good for me to see and also gives you an idea of the number of crappy bots that are out there attempting to inject and expliot my servers on a regular basis. These logs only show the attacks that make it past my Packet Inspection Firewall and generally attempt to post data with flagged keywords such as 'Viagra' :-)

8/8/2008 - Fully ASP AJAX Implemented
It took me about a month but I have now switched over to Telerik's newest WebControl suite which sits on top of the Microsoft AJAX framework instead of utilizing Telerik's own AJAX framework. What this actually means is that some of the skins look a little more modern and most of the advanced AJAX calls work *much* faster (especially noticeable in the member's MyIPSND edit grid). Overall, this should be a good stepping stone into the future for ASP. Since this was a fairly major overhaul, if you run into any issues, PLEASE send me an email so I can get it fixed up as quickly as possible.

7/20/2008 - New Chart in Rotation
I added a new chart that shows top referring sites as extracted from Google Analytics. I figured this would help show the benefit this site gets from some of the other popular pinball sites such as The Internet Pinball Database and Pinside.

7/7/2008 - All the charts you ever wanted...
I am going to start adding a few more charts and also making them available on the Statistics page. For those of you that don't want to cycle through all the front page charts one-by-one, there is now a link in the lower right corner of the charts that allows you to see them all on one page.

6/28/2008 - Pinball Price Guide Serial Numbers
Special thanks to Eric Kantor who donated all the serial numbers that Steve Young compiled over the years for The Pinball Price Guide. There were over 1100 serial numbers in the spreadsheet that Eric sent me covering Gottlieb and Williams EM games. Since the price guide only tracked high and low serials, you can see that they are often the highest and lowest serial numbers in the submissions. Thanks again Eric!!

6/27/2008 - Database Downtime
Looks like we were down for most of today due to my SQLServer running out of disk space. I apparently need to learn how to clean up my database backups a little better as I ran out of disk space on the SQL box. Luckily SQL 2005 behaves better than SQLServer v7.0 when disk space mysteriously dissapears and everything is up and running again without even a reboot.

6/24/2008 - Internet Pinball Database Links!!
Thanks to Wolf and Jay at the The Internet Pinball Database who have added matching links on every game in their database to the IPSND game page. This will help keep even more traffic coming our way and should encourage more people to submit their serial numbers. Thanks again guys!!

6/3/2008 - SerialBot Scoring Explained
You can now click on the SerialBot score for each submission and get a detailed explanation of that score and the color code. As the scoring has gotten a little more complicated, it seems that this information would be useful to submitters or serial number compilers.

6/2/2008 - Game Part Photos
You may now submit photos directly in the game part submission form instead of having to go into your MyIPSND submissions to edit the entry. This should make it much easier than before for the couple of you that are submitting game parts with photos on a regular basis.

5/26/2008 - Email Updates
I have changed the way that the site sends emails due to some problems with the way the larger domains (yahoo, hotmail, gmail, etc) configure their mailservers. The update also takes care of getting mail sucessfully sent to a server that uses greylisting as SPAM prevention. As a reminder too, if you become a member, you will not have to verify your serial number submissions via email which will keep your inbox healthier!

5/24/2008 - Back Online
Another side effect of the large storms that rolled through the area was that a stream washed out some qwest fiber around the Douglas area. Apparently three OC48's were cut by debris on Thursday afternoon. We are finally back up with internet service on Saturday morning.

5/22/2008 - Power Outage
Laramie had some tornado issues this Thursday and our power was out overnight due to those and some heavy snow. I'm bringing the servers back up right now so we should be good to go in a few minutes.

5/9/2008 - Now linked up with Pinside.com
After emailing a few times with Robin at pinside.com, we have both agreed to change our sites a little to provide links off each game page to each other. This wasn't quite as easy as linking up to the IPDB but Robin and I figured out a way to make it work. You will now see links to Pinside on most games produced after 1975 on each game page. Thanks Robin!

5/8/2008 - Member Benefits!!
I changed the way the site works a little based on feedback at the Rocky Mountain Pinball Showdown last month. Instead of mailing out verification emails for every submission for everyone, now, they only go out to non-members. So, if you become a member, your submission will automatically be set to a status of 'verified' without needing to deal with checking your email for every submission. Since members already have their identity known, it is safe for us to assume that those submissions have a certain level of integrity.

4/21/2008 - See you at the Showdown
I will be doing a pin-chat at the Rocky Mountain Pinball Showdown next week, the chat will be a tour of the IPSND, how it is built, the database and all the interesting stuff that I can show from the site. You will also learn some advanced usage of the site features.

4/20/2008 - 1,000,000 Visitors
Well it has been just about 2 years now and we have crossed the million visitor mark. Looking deeper into the stats, most of those visits are by bots it appears but it is a legitimate session count when the visit I suppose. Thanks to everyone that has continued to support the site and keep the submissions coming!!

4/12/2008 - Added Statistic
There is a new statistic that lists latest submissions that include a photo. A nice way to browse all the pretty pictures everyone submits!

3/23/2008 - Game Search Results
I have updated the logic for the search results so that it does two new things. Now, the number of players is also listed in the results to better clarify the games from each other, plus the results are now sorted descending by number of submissions for that game so that the post popular games exist at the top of the list. Since I don' really have a fancy search engine, this should give back more applicable results at the top of the list.

3/5/2008 - Image Uploads
Members may now upload photos for existing submissions by going to their member profile page and editing the submission. You can also replace existing photo uploads via the same interface. Right now, there is only 1 photo per submission however.

3/2/2008 - New 'Chart', Sortof
In the area to the right where the charts and the google analytics exist, there is a new item in the rotation that shows the most recent member uploaded photo that has been put into the database. FYI, there are currently 9 different items that rotate in the chart panel on the front page.

3/1/2008 - Photo Edits
Members can now do some basic editing of uploaded photos, right now there are tools for rotating and flipping images. I will also be monitoring images uploaded by non-members and doing rotations etc to get them presented properly.

2/27/2008 - Several Bugfixes
Based on the traffic and feedback from my post on RGP last night, I have fixed several bugs relating to the Emailing issue, login accounts and Activation processes and the Affiliate configuration script. There is also a new 'remember me' checkbox in the login control so you can keep your default email on a computer by computer basis.

2/27/2008 - Email Fixes
There are some issues with the confirmation email going out to yahoo, gmail and other large ISP's. Im changing the code now but the site will be a bit flaky for the next 10 minutes while I deploy the updates. Thanks for your patience.

2/26/2008 - Photo's of Serial Numbers Supported
We will call this a BETA test for now, but you can now attach photo's to your serial number submissions that show the serial number explicitly. This will potentially solve so may problems over time as we get more and more submissions and error's gradually pile up. This is only the first step in a bigger picture solution but it is pretty cool to see them for now. You can either upload a photo from your local PC or specify a web URL for the photo. The image is stored in our local IPSND database so it is archived along with the submission. Submissions that have an attached photo are 'starred' in the serial number listings.

2/23/2008 - Serial Bot Updates
The Serial Bot has been improved to not only categorize submissions into various 'status' levels but it now assigns a point value to each submission that ranges from 1-5. This value basically shows how accurate a submission is based on several factors. More details can be found on the Serial Bot Page and this functionality will be getting more improvements in the weeks to come.

2/17/2008 - Sorting Bug Fixed
There was a bug in the serial number sorting algorithm that appeared to effect games that had alpha characters in them (Early Bally Electronics most notably). This has now been fixed so that they are again sorted in numeric order.

2/10/2008 - Submitters vs. Members
In several tables that list submitters, there is now a 'member' icon that appears similar to the way an icon appears if a person has given a donation. Clicking this icon will take you to the member profile page that shows some summary info about the member, a link to their website and a listing of their submissions. It is fairly similar to the regular submitter page, however I will continue to develop this page and probably not develop the submitter page beyond the basics.

1/24/2008 - Become a Member
You can now register on the IPSND if you are here regularly and would like a little more power over your information and ease of use. The big advantage is that you can now edit your submissions to a certain degree if you want to correct them or update them. Registration is free and we of course do not share any information.

1/5/2008 - IPP Serial Status Change
When I started this database, I imported all the known serials that had be registered with the old Internet Pinball Project as the basis. That was about 7500 serial numbers (3/4 of where we are now at 10,000 serials). I changed the 'Status' of these serials to 'Unvalidated' since they technically have not been validated. I also wanted these submissions to have a 'lower' value than submission by people that have personall submitted games and verified them through the email link. This doesn't really change much except you now see much more 'blue' in the serial number listings.

12/31/2007 - Statistics Drilldown
I updated the Statistics Page with a feature that allows you to view entire datasets instead of just the top 25 or 50 rows which I commonly limited the stats to in the past. This allows you to drill down into the data if you really want to and also do full exports of the data instead of having just the top.

12/24/2007 - Movin' on Up!
The site is now running ASP.NET 3.5 under IIS. Im not technically using any of the fancy 3.5 features yet (except one simple LINQ OrderBy function but Im working on it.

12/22/2007 - Community Defined Fields
I sat down the other night and did a search for 'prototype' on RGP to come up with threads discussing odd features of games (generally due to someone posting that they had a 'prototype'). What came of this was that I added game custom properties to about a dozen games this week. Two examples are... Cleopatra and Sinbad: SheetMetal vs. Plywood cabinets. Bally's Wizard!: two different playfield arch artwork styles. I really encourage everyone to add more custom properties for games that you collect or are interested in... it really starts making the serial number submissions a little more interesting than doing simple existance tracking. More info on the Community Defined Fields page. You can see examples on the Games with the most Community Defined Fields statistics page.

12/15/2007 - Site Data Layer Updated
I have given the site's Data Abstraction Layer a major overhaul and deployed it this evening. It was about a two week process but the changes should optimize the communication between the web server and the SQL server which should give better speed to the site overall.

12/9/2007 - Site Downtime
It never fails, every time I leave town, I have power problems in Laramie and a server goes down. This time it was the SQL server due to the old UPS battery. I will get a new battery ordered this week so things should at least improve in the future. Im also not going to be out of the country for a full week anytime soon either.

11/27/2007 - Ray Tops the Chart!
I think that Dan has held the title of 'Top Submitter' for over a year now but today Ray Johnson made a dash into the front. Nothing like a healthy rivalry between my favorite submitters to get all these lovely serial numbers! Nice job Mr. J.

11/18/2007 - Production Database Online
The original SQL database server is now back online. The site should be back to being somewhat fast now. Im in the process of migrating all databases over to the new server and things should be pretty stable from here on out. I apologize for the interruptions this past week!!

11/17/2007 - Site Slowness
I am running the site of my backup database server this weekend while I build a new SQL box. Until I get switched back over, the site will be running a bit slower and may experience intermittent timeouts as a single proc machine doesn't do too well with both IIS and MS-SQL. :-) Someday I will move this beasty over to MySQL.

11/11/2007 - Database Maintenance
The site was down Saturday night due to some 'unexpected' server maintenance. Bottom line, don't promote your SQL server to a domain controller and then demote it. Bad Idea!

11/7/2007 - More Stats
I added a new statistic on the statistics page that displays a breakdown of serial number submissions by Manufacturer. Also, on the stat pages that show IP addresses, clicking on the IP will take you to the whois record.

11/3/2007 - 10,000 Submissions!!!!
Dan Gutchess submitted the 10,000th serial number into the database today. Thanks to everyone who has been contributing and keep the serial numbers coming. Dan wins a free IPSND T-Shirt as soon as I get them made. ;-)

11/2/2007 - New Analytics Chart
There is a new Google Analyic chart in the rotation, this one is similar to the breakdown by city but instead does the breakdown by country and color codes the various levels of visitorship. Similar to the city chart, it has fancy floating info panels for each country.

10/30/2007 - Analytics Updated
I have included the newest version of the Google Analytics geomap in the stats to the right. Basic functionality is the same but it definely looks prettier and loads a little faster. I will be working on this some more to get different aspects of analytics showing here on the front page.

10/24/2007 - Countermeasure Statistics
Just to keep track of those pesky IP address that use bots to auto-submit web links into our sacred database, there are now two new stats on the Statisics Page that allow you to see what IP's are currently banned and a listing of all IP's aggregated by count that have been banned in the past.

10/23/2007 - Countermeasures Deployed
In my passionate attempt to keep the site free from bot porn and viagra submissions I have deployed a few new countermeasures to prevent the bots from filling the database with crap data. I put these in place in lieu of using the 'captcha' verification images as those images were causing a few people submission grief. So, if any IP address submits porn links or lame-o data, that IP will now be banned for 48 hours from the site. Huray!!

9/30/2007 - Search by IPDB/IPSND Id
If you know exactly which game you are looking for, you can quickly type in the ipdbid with a pound symbol in front, so, for example... #1976 will take you directly to Robocop and #311 will take you to Black Knight 2000

9/28/2007 - Validation Images Removed
The validation images (captcha) were removed from both the sumission page and the parts submission page due to continued problems with some people's browsers. I had added them to prevent bots from posting invalid serial numbers but I will look into other measures for preventing that from happening.

9/19/2007 - Verification Summary
When you click on the verification link that the site emails after every submission, that resulting page will now display all the serial numbers that were marked as verified. It wasn't very apparent in the past but even if you had submitted 25 serials, clicking any single one of the verification links would mark all 25 submissions as 'Verified'. That meant that you didn't have to click every single email that was sent to you in a single batch (defined by session which is equal to 30 minutes in this case).

9/18/2007 - Game Part Graph
I added a new front page graph that shows a pie chart of the distribution of all game part submissions on the site. I may change this to be only the last 90 days as I want the front page charts to sort of constantly morph based on time and the way it looks now, most part submissions might be CPU or display PCB's. We will see what happens with the data before I change anything tho.

9/17/2007 - New Game Part Statistic
There is a new statistic that shows games with most number of submitted game parts on the statistics page.

9/16/2007 - Game Part Types
When submitting a game part, there is now a drop down that lets you define what type of part it is (CPU, Driver, Display, etc). When viewing the game part listings under each game, you can then see this information.

9/11/2007 - Game Parts Expanded
I have added a new tab to the game details page that explicitly lists all game parts that have been calculated to belong to that specific game. Some game part serials can be associated with a specific model simply by the structure of the serial number and others cannot. As I manually find these game part serials, I will assign them to a game and they will start showing up in the 'Game Part' lists. The concept is not quite complete but you can read more about it under any game detail 'Game Parts' tab.

9/5/2007 - Under-the-Hood Upgrade
I upgraded my entire Data Abstraction layer to full .NET 2.0 compliant code that takes advantage of nullable types and gives me an easy way to audit all database changes. While this doesn't technically effect the site, it will probably introduce a few bugs. I have already fixed about 4 issues tonight after watching the exception log, so if you do have any problems, bear with me and I will get them fixed asap.

8/27/2007 - Game Part Submission Bug Fixed
There was an issue with the GamePart submission page that was causing some issues accepting submissions, this was due to some old code that tried to prevent duplicate submissions caused by double-clicking the submit button. A big thanks to John Duchi for helping to troubleshoot the problem.

8/25/2007 - Site Downtime
The site was down for 4 days this past week due to me being out of town and Laramie losing power for more than 20 minutes. Since my UPS' can only deal with that much power outage, the servers were down until I got back into town. All should be good now however and Im going to start saving for a bigger UPS. :-)

8/17/2007 - Bally German Games
I went through and defined a custom game property for the dozen or so Bally games that came in both English and German versions. Maybe we can start to see a trend in the serial numbers now.

8/15/2007 - Web-Bot Countermeasures
Well, it was bound to happen sooner or later but the web bots have officially found us and are attempting to submit all kinds of crappy information including URL's of malicious web sites. So, you will find that some submission forms will require image validation (also known as captcha images) to prevent me from getting a mailbox full of 'Improperly formed submission' errors every day.

7/15/2007 - Search Results Expanded
When searching for games the results now return a column that specifiies the number of submissions on record for that game, this is helpful for games that might have been made for home use orfor games licensed to other manufacturers. Overall, it allows you to see the potentially most popular or common game amongst all the results.

7/15/2007 - Manufacturer Stat Charts Added
I added the standard 3 charts for viewing submissions by Country, Condition and GamePart to the manufacturer pages. An example can be see at the Stern Electronics Manufacturer Page. I also added a column that summarizes the number of submissions for that game in the table.

7/15/2007 - Serial Bot Updates
There are now 5 different 'status' levels that a serial number can have defined by the Serial Bot. They are now a little more defined and include a status for games that don't yet have a serial mask defined.

7/9/2007 - New Serials Flagged
When viewing game serial number lists, if any serials have been submitted in the last 90 days, they are now flagged with a small 'new' icon. This lets you see the activity on specific games you might be watching.

7/7/2007 - New Logo
After some playing around with photoshop, I think I have improved the logo a bit for full browsers. Mobile users still have the same old 'compact & flat' version but it works better on limited bandwidth.

6/30/2007 - Speed Improvements
I'm starting to experiment with ASP.NET caching and have also been working on optimizing my database trips from the web application. This should help improve page load times in the future.

6/28/2007 - Submission Page Errors
There was a problem with the submission page today due to a change I made in the code that displays example serial numbers. I have things fixed now so all should be back to normal.

6/27/2007 - More Pretty Tabs
I added pretty icons to the tabs within the game detail page. Also, there is a new tab that explains any known serial number format for a specific game... an example would be Sample Game serials and Production Game serials. Read the previous news item for more info.

6/26/2007 - Serial Definitions
I broke the serial masks into a seperate table that now allows me to track multiple formats using regular expressions. This allows the database to have different masks for Sample vs. Production games for example. I was having issues with making a single regular expression that covered all the different known formats since in addition to the literal format, the actual numeric range was often constrained as well. For example, 80's Gottlieb games had sample games that were typically prefixed with an 'S' and started in the one thousands; Production games did not have the 'S' but also started in the two (or greater) thousands. Hence... a serial number of 'S02438' would not be a valid serial number based on this information.

6/18/2007 - Serial Validation Mode
Now that we are on the virge of collecting 10,000 serials, I am starting to fully audit the database with validation masks. These masks allow me to flag serial numbers that look suspect according the best known information on the format of a specific game serial number and the range of known serials. To go along with this, I have created a new Statistics category called 'Quality Control'. There is one available statistic right now that lists the games with the most suspect serial numbers.

6/18/2007 - Better Functionality
The GamePart submisson form now remembers your default values for 6 months using any prior submission, just the way the main submission form works.

6/15/2007 - Defining Serial Masks
I have just added serial number mask definitions for about 1000 games. What this gives me is a method to start determining if submitted serial numbers are in an expected format. I previously only had about 1000 serial masks defined, but we are now at a total of 1880 games out of ~5000 defined. After doing this, I now have about 200 existing serial number submissions that are showing up as 'possibly innacurate'. So, I will start cleaning those up this week.

6/10/2007 - New Database Server
I have purchased a new server for SQL 2005 and am running Windows 2003 64-bit Edition along with SQL 2005 64-bit. It might be slight overkill but I wanted to support AMD and since their new Athlon's are all 64-bit, I figured I would give it a go. All my drivers were good and the machine is up and running. You should see substantial improvements on the page load times now. I will be working on optimizing indexes and server cache info over the next month to get things as snappy as possible.

6/9/2007 - New Tab on Game Detail Page
I added a new tab on the game detail page that is called 'Find your Serial Number' which basically is a blog style interface for posting tips on finding serial numbers for the *manufacturer*. Posts to this are global to the manufacturer so they aren't necessarily game specific.

6/4/2007 - Affiliate Update
I added a new Stats section with a listing of all the current affilate sites, ordered by ranking. GameArchive is the only current affilate so Im hoping to get at least one other site to try out the new feature sometime soon. Come on Webmasters!!!! Also, I added a new feature to the Affilate serial submission process based on a comment by Jesse at Pinball Magic. What happens is that when a new serial is sumbitted via the Affilate include, upon submission, you are now taken back to the Affiliate site to make the process much more streamlined so that submitters don't end up leaving the affiliate's site.

6/3/2007 - 2 New Statistics
There are two new stats on the Statistics Page that show games with the most current Community Defined fields and then a list of games that have the most community defined field values submitted.

6/2/2007 - Community Defined Field Results
I modified the way the Community Defined Field data is displayed in the second tab of a game's details to show only serials with registered information. This makes the data much easier to read. Since many community defined fields have been defined after-the-fact, the resulting data was pretty sparse generally and involved lots of scrolling. This will also make pages load a tad bit faster.

5/6/2007 - Added Statisic Rankings
On most of the Statistics pages, there is a new column called rank that shows the appropriate row number. This makes it easier to see that statistical rank, an example as of right now... 'joust' is the 7th most popular search.

5/6/2007 - Include Live IPSND Data in your own web site!!
This is a 'feature' that I have been working on for quite a few months now. Due to the really flexible nature, it took awhile but I think it is finally release-able. You can get substantially more info by clicking on the Become an Affiliate link at the top of the page but the basic jist is that now people that have 'owners list' pages, can actually stop trying to maintain static lists of serial numbers that they get submitted via emai and instead simply 'include' data directly from the IPSND using a really simple line of HTML that is similar to the way Google Analytics works.

5/2/2007 - Community Defined Field Datagrids
For games that have Community Defined Fields, there is now a basic data grid underneath the graphs that were previously not there (see Star Gazer for an example). The grid is basic and generally sparse right now but it is a little more useful than the graphs which showed totals but no distribution data. I also fixed a bug in the graphing code that was skewing totals for each property so the grid and graphs numbers now make sense together.

5/1/2007 - Owner Tracking Added
I have added a new field to the serial number database that tracks if the submitter is the 'current owner' of a game or not. This came to my attention from games appearing at shows like the Rocky Mountain Pinball Showdown where non-owners may submit a serial number of a game that was on display. The reason I wanted to distinguish the difference was simply so that I could make a report filter to only show registrations by owners etc. All the existing registrations are marked as 'non-owner' submissions for now.

4/30/2007 - Showdown Lowdown
A big thank you to Dan and Holly for organizing the Rocky Mountain Pnball Showdown again this year. I had a great time and got to hang out and chat with everyone I haven't seen in awhile. The show had a great variety of games and I was happy to see a nice lineup of Bally's including a Xenon and Medusa. I have a list of about 100 serial numbers that I collected there so I will work on inputting them to the DB this week. See you next year!!

3/21/2007 - Server Upgrades/Fixes
It seems like I have had a failing stick of memory in my server that was making it *extremely* flakey this past month. It is now removed and running stable again. I also upgraded the database server to SQL 2005 from SQL 2000 so we will see if that gives any performance improvements.

3/21/2007 - See you at the Showdown!
For everyone in the Rocky Mountain Region, don't forgot to come over to the Rocky Mountain Pinball Showndown from April 27th-29th in Jefferson County, Colorado (just west of Denver). There will be over 100 games set on free play along with a Pinball Tournament and guest speakers. I have volunteered to do the 'Pinball Shopping 101' session and will be bringing my Williams Cosmic Gunfight and Warlok to the show. The Pinball Showdown website is at http://www.pinballshowdown.com.

3/20/2007 - Search Improvements
The game search algorithm has been improved a little by ignoring 'special characters' in game names like hyphens, colons, asterisks, etc. This was a request from Dan G. because when typing in 'Pinbot' you would not get any matches due to the official game name being 'PIN*BOT'.

I also have made search tokens logically AND'ed together so that searches like 'time line' dont return 150 matches but only game names that have substrings of both terms somewhere in the official name or game abbreviation.


3/16/2007 - Frequently Asked Questions Added
Since there seemed to be many common questions about serial numbers and the database, I made up a little FAQ that attempts to give some feedback and guidance. Hopefully they help answer some of *your* big questions in life.

3/13/2007 - Fixed Timeout Issue
There were some issues with some of the statistics pages that would cause them to time out. This was because I was tracking hits in the DB from the IIS log and the table was enormous. I moved away from logging IIS traffic in the database and have stored hit values for each game in the database.

3/11/2007 - Community Defined Field Charts
There are now some basic pie charts on the game serial pages that summarize the collected data for the community defined fields. I have changed the interface to have tabs across the top so that I can store more info here in the future. Also, I will be adding a data grid that displays the community defined field info in a table below the charts similar to the main serial number registration table.

2/27/2007 - Williams Video Games Added
I came to the realization this weekend that the serial numbers that Williams used for their video games are in the same sequence of serial numbers that they used for their pinball machines. This actually addresses some concerns of mine on the big gaps in their pinball serial numbers since there were large seqences of numbers missing during the 1982 era when pinball was waning and video games were still popular. Because of this interdependency, I have added the 12 video games that Williams manufactured in the early 80's. Please tell all your video game collector friends to register their serials if possible.

2/17/2007 - Community Defined Fields
Okay, I think this new feature is pretty neat. You may now add additional properties to a game so that when people register a serial, they are asked for some more game specific info. A really good example is with Jungle Lord... there are two different cabinet colors that were produced from the factory... RED and BLUE, by using the Community Defined Fields, I was able to submit the property and define the different allowed values that submitters may choose. Now, we can track game specific production properties to serial ranges to better figure out when these 'features' existed in the production run. Several other examples are... Captain Fantastic... Starred Backglass or not, Twilight Zone... 3rd Magnet. For those of you that are really into specific games, I challenge you to get some good community defined fields submitted so we can track these trends as early as possible. It took me about two weeks to get it up and running so please test it out and give me any feedback you might have on how to improve it.

2/5/2007 - RSS Feeds
I created two RSS channels that are described on the RSS Feeds Page. Im not sure where these will go but I thought it would be interesting to be able to see the IPSND announcements available on my Slim Devices Squeezebox in my living room. This is also my cheap way of providing a semi 'web service' interface to the data. Please let me know if you would like to see anything else with the RSS feeds.

2/4/2007 - New Stat Chart
I added a new chart in the front page chart rotation that shows top submitters in the last 90 days. I'm trying to come up with charts that change regularly so there is always something interesting to see and you will become hopelessly addicted to visiting the site and submitting serial numbers.

2/3/2007 - Game MPU Statistics Added
If a game is electronic and has a known MPU (Master Processing Unit) board, there is a link under that game to the MPU details page. The MPU detail page lists all games using that MPU and the aggregate stats associated with it. Header columns on data tables are clickable and allow sorting. Most tables are like this but I will work to make this more consistent across the site.

1/20/2007 - Statistics Graphs
In addition to the Google Analytics map that normally appears on the right side of the main page, there are now a few more charts you can view that show the following data... Submissions per day in the last 90 days, a breakdown of all submissions by country, pinball machine models produced by year and total pinball machine production by year. I will add more as I get time. Enjoy.

1/14/2007 - Game Serial Graphs
I added 3 pie charts to the game serial pages that show distributions of registrations based on Country, Game Condition and the Game Part. This is still a work in progress and I have to pretty up the layout a bit but they are interesting to see as an alternative to browsing the entire registration table in raw format. I will be experiementing more with the Dundas charting tools and also trying to figure out a way to pay for them over the next few months. If you have any suggestions on what may be useful to visualize, drop me an email.

1/13/2007 - Serial Number Blog
There is a new link in the top navigation header called 'Serial Number Blog' that is a revamp of the old static page describing how to find serial numbers for the various manufacturers. The page is now formatted more like a blog with each manufacturer having posts from collectors that can comment on where and how to accurately find serial numbers on games by that manufacturer. I have initially populated the blog with the info that Bill Ung had written for the original Internet Pinball Project and added a couple of my own. There are lots of manufacturers to go and Im sure more info on the manufacturers that are already posted so please add as many useful comments as possible.

1/9/2007 - Easier Submitting
If you have submitted lots of serials, you probably have thought it was a bit repetitive to constantly have to re-type your name, email, website and country. I have added cookies to the site so that if your browser allows them, these fields will be remembered from the last submission you entered. The cookies are valid for 6 months and will keep your 'default' values stored in your computer. I don't use cookies for any tracking code so you won't have to worry about me slamming your machine with tons of sweet chewy delights.

1/8/2007 - Learn your flags!
Countries are now shown as the appropriate flag graphic in the serial tables. Hovering will let you know what country it is if you don't know all 240 by heart. Looks a little flashier.

12/22/2006 - Pre-Holiday Maintenance
I have had an issue with my root partition on this box for about a year now in that it was only 10Gig and I was woefully low on space for a long time. I made lots of temporary fixes by moving the swap file and other files to 'accessory' drives but finally found a good tool to move existing partitions to different drives under Windows Server 2003. So now I have a fresh 160gig C partition with lots of space to grow. This will allow me to install Telerik Q3 2006 widgets from the Q1 2006 version Im using now. I will be utiliting ajax more to minimize page loads. Im also going to start playing with Dundas charting tools which I didn't have enough space to install previously. Now I just need to get the backups working again. ;-)

12/16/2006 - Statistics Exports
All of the statistics tables available on the Statistics Page are now easily exportable to either Text CSV, XML or XLS file formats. Once you view a statistics table, look in the upper right hand corner of the table for the export functions. If you would like information on how to automate exports, let me know.

12/12/2006 - Site Screen Size Increased
Based on the data I have been pulling from Google Analytics it looks like only 7% of the visitors to this site have less than 1024x768 screen resolution. So, I have made the main site layout optimized for 1024x768 or larger. There are some tables I have been using that are hardcoded for the smaller screen size so I will be updating those in the next few weeks to take full advantage of the new real estate. Please let me know if you have any problems with formatting or sizing.

12/10/2006 - New Statistics Table
I added a new table that shows 'Serial Registrations by Game Manufactured Year'. It also shows the number of games manufactured that year. Plotting it gives interesting results. I will start working on an easy way to graph all statisics here in the new year. Merry Xmas!!

12/4/2006 - Individual Game Stats
Im going to start adding some stats for individual games to the game summary pages. For now, it simply lists the number of serials registered against the total production and gives a percent registered. I will expand this a bit more in the future.

11/21/2006 - Major 'Under the Hood' improvement
I had this strange process of making pages post back to themselves the first time a person would visit the site so that I could get the screen resolution of the computer you were browsing on. This allowed me to make the background image fit your screen perfectly. Well, it had some side effects in that I used the URL to send the resolution which made my server loggin completely useless with all the different URL's and it caused everyone to hit a page twice. Through the joys of javascript I have found a better way to do this. It works in both Firefox and IE 7.0 too. Hurray!

11/16/2006 - Return of the Factoid
Yes, all my sites seem to have one... the factoid... well it is challenging for me to come up with interesting facts to put in there. While most were taken from the IPDB, some are truly original or taken from digging through all my old pinball books.

11/15/2006 - Some CSS Updates
I have been converting the site to be driven more by CSS instead of classic HTML based layouts so you might see some more 'pretty' things, or you might just see more broken formats due to the browser differences, if you are using IE 7, you are on your own for a bit until I can get it installed on a computer without crashing it. :-)

11/10/2006 - Trip to the Pinball Hall Of Fame
I was in Las Vegas this week for a conference and got to spend hours playing pinball at Tim Arnold's Pinball Hall Of Fame. He let me crawl around and collect as many serial numbers as I could. I felt like Sam Harvey but Tim pointed out that since I was using a pocket PC to record the serials, there was no way I could be compared to Sam.

I finally got to play Pinball Circus and plenty of other favorites over the evening. Im slowly getting all the serials from the PHoF into the database.

11/4/2006 - Analytics Extraction
If all went successfully, you should now see a world map to the right of this with the past weeks hits mapped on it. This data is from my Google Analytics urchin tracker, it was an interesting process to get the data and display it here since there is no native API. I will keep playing with it to see if I can publish more data here directly.

10/18/2006 - Google Analytics Mining
Im using Google Analytics to track visitors to my site now. The visitor hits that are currently shown in the header are unique sessions however, they include bots that scan the site and it seems that that number isn't really that accurate in comparison to Analytics. Im in the process of trying to 'extract' data from Analytics to show directly on the site but Analytics does not have an API yet, so it will be an interesting hack.

10/17/2006 - Added More Stats
I added a stat view that shows the most popular searches now. I also fixed an issue with the 'Submissions by Month' query that was sorting the months incorrectly.

10/6/2006 - More Sorting Improvements
I extended the ability of my SerialComparer class to deal with games that don't explicity have a numeric range mask defined for their serials. What I did was convert the serial number into a Base36 number so that the serial strings would get sorted numerically even if there were Alpha characters in the serial. Leading zero's are trimmed off and non-alphanumeric characters equal zero. Im sure this can be improved further but this really helped and effected 4248 games.

9/12/2006 - Registration Certificates
Since the IPSND is my project site to better learn new technologies, I wanted to dynamically generate .pdf documents that contained default content along with data linked content and do that in realtime. Viola! You can now download a fancy schmancy 'IPSND Registration Certificate' (suitable for framing) that has the game details, serial number and submitter info on it. The certificates can be viewed under the 'details' section of an individual serial number.

9/11/2006 - Mobile Device Tweaks
I enhanced the page presentation for mobile devices to hopefully squeeze the content into a much smaller area and also to optimize for bandwidth saving. Don't forget to use your pocket PC or Palm device to register those serials when you are out and about.

9/10/2006 - New Logo
Yes, I pulled out my 'creative' hand and made a really simple logo that brightens up the page a bit. Nothing fancy, but it works for now.

9/8/2006 - Page Improvements
I previously had a little javascript redirection page that allowed me to detect the screen resolution that you were running so that the background image would fit perfectly to your screen. Well, the javascript was messing up search engines etc and causing all pages to be crawled with no content. So, I fixed that my making my master page a little more intelligent about the current session. Because of the way it worked out, you should get the correct background image resolution no matter which page you enter the site on as well, previously, the detection was only happening on the home page.

8/29/2006 - Manufacturer List Page
There is a new Manufacturer List page that allows you to browse all the manufacturers in the database and also summarizes total games produced. I put this in here for the bots primarily so that there was a direct path to every game entry in the database, but it is also more useful to browse sometime.

8/27/2006 - Manufacturer Detail Page
I have added a new page that allows listing of all games by a specific manufacturer. In general, you will see this on every game page, the manufacturer name (if known) is now a hyperlink. Im not exactly sure what use this will be but it seemed useful to have around.

8/25/2006 - Firefox Search Plug-in Added
I have created a Firefox Search Plug-in for the IPSND on the Downloads page. It allows you to easily do IPSND searches directly from the firefox search box. Enjoy!

8/22/2006 - Book 'em Dan-O!
Not only has Dan Gutchess taken over with most submissions, but he also pointed out a couple of nuances with the search functionality that didn't work quite right under IE. So, I have fixed the issue with pressing enter not properly searching and have added a little extra feature that automatically sets focus to the search boxes on page load. I will do the same with other forms over the following few days to make data entry as easy as possible.

8/18/2006 - Ray has been topped...
Our fearless prior submission leader Ray Johnson has been out-submitted by Bill Ung today. Nice job Bill... Ray, you must have more serials!?

8/17/2006 - Serial Bot Enhancements
The serial bot now attempts to calculate valid serial number ranges for a particular game based on serial number submissions for other games manufactured during the same time period. Williams games were tricky since there could be sample game runs that were interlaced with other games. Im not going to go into severe detail here on how it works but as with everything else, we will let it run awhile and see what the bot can ascertain over time.

8/16/2006 - Serial Masks
For games that have a serial number format mask defined, the submission page will no longer accept serials that do not validate against it. I was getting lots of mistyped serial numbers and instead of me trying to guess what the typo is, I figured it would be best to point out the issue at submission time and have the submitter double check. We will see how this works out.

8/15/2006 - Serial Bot
I have created a little routine that meticulously goes through each serial number and looks for any 'oddities' associated with it. For instance, if a game submission has not ever been 'verified' by email then the bot will show a yellow icon and the tooltip will tell you why the bot has marked the serial as suspect. Other reasons why the bot may mark serials as suspect are for serial number formatting issues or serial number ranges that don't make any sense. We will see how this little beasty develops. The serial bot results are viewable on the serial number listing for each game.

8/15/2006 - Game Serial History
There is a column the game serial number lists called 'history' that if present, will link to a page showing that the serial number has multiple submissions. This is useful if a game changes owners over time and another person registers the same game more recently. This little feature allows tracking of a games history over time if you are curious.

8/4/2006 - Serial Format Info
In the process of creating serial number masks, I have made a short summary page about some of the different formats that serial numbers exist amongst the various manufacturers over time. The Serial Number Format page has this text and is also given as a link on games that have a serial mask for them if you are attempting to submit a serial number for that game. The nice part about the mask is that on games that do have a serial mask format rule, I have added a small panel on the submission page that explains this and also gives examples of valid serials for that specific game to help make the submission process as clear as possible while still letting us have some integrity on the submissions.

8/3/2006 - Serial Sorting Improved
I have started implementing serial number format masks which allows me to sort game serial numbers properly even if they have special characters in them for the most part. For now I have defined sort masks for all post 1984 Bally/WMS games that have a specific game prefix and optional I and X characters. I will be working on Earlier model Bally games with the 3-Letter prefix next.

8/2/2006 - Site Downtime
Qwest had a fiber line cut today so the site was down for about 9 hours. Seems that the cut took out ISP's across all of northern Wyoming and several 911 services as well. Ironically, Im in southern Wyoming. :-)

8/1/2006 - Submitter Search Added
You may now search for submitter names in order to see the details of submissions by a specific person. The search only looks at the person's name and does not return any email info.

7/30/2006 - More Crosslinking
I have started improving the result grids on other pages so you you can link to other data from page to page, for instance, in the statistics pages, the results how have hyperlinks to the various games, owners and serials that they contain. I will be working on improving this slowly over the next month as well.

7/22/2006 - PDA Friendly
The main interfaces of the IPSND are PocketPC and PDA friendly so if you have a cell phone with the ability to browse, don't forget you can submit serials while out in the field!! Give me feedback on any improvements that can be made when running a small screen if you want.

7/22/2006 - 'Date Of Manufacture' Added
I have added a new optional field to the submission form that allows you to specify a Date of Manufacture which is a common item stamped on the front edge of many playfields during the 80's +. I have also added some more verbose explanations of the submision fields on the submission page using some nice little javascripts to give a tooltip effect.

7/20/2006 - Serial Number Search
I just finished a fairly large update to the site in that you may now search for serial numbers specifically. Since I wanted the ability to let people look for 'lost' parts from their games, it was important to have this functionality. That way, if you were missing the factory tagged driver board from your 1980 Williams Black Knight game, you could type in your serial, and see if someone has registered that 'spare' part in the database. If so, you have a way of possibly contacting the submitter and making a deal (I am going to add private submitter contacting in a few weeks). So, try it out and let me know if you find any bugs or issues. Have fun. S

7/17/2006 - Download Fix
There was an issue that Russ Jensen found with the Database download function, basically, the database delivered did not have any EM games whatsoever due to the fact that they did not have an electronic MPU defined. I have fixed the flattened view of the database that is available through the downloads section so that all games are now included. Thanks Russ!

7/10/2006 - Serial History and GamePart Expanded
At the request of Peter Hall and for the purpose of completeness, you may now submit serial numbers for game parts. It is common to have game PCB's especially with valid serial number stickers on them, for this reason, the database now allows multiple serial number registrations per game. This basically expands the ability of the IPSND to track not only seperate head and cabinet game parts, but also any other part. Maybe we will hear some success stories of people getting back an original CPU board to match their cabinet serial number. Another side effect of this is that since a single serial number can be in the database more than once, it allows tracking of a specific game serial number over time... so you can see that Joe Smith owned Jungle Lord 123456 on 1/1/2005 yet that Jane Doe owned that same game as of 1/1/2006. Anyway, it will be interesting to see what happens with it.

6/28/2006 - DB Download Available
There is a new section 'Downloads' that allows you to get a current copy of the IPSND database in a flattened format. Right now, I only support CSV downloads but it will be trivial to get the other two options (Native XLS and XML) working soon. This was actually a pretty cool exercise because the way the downloads work, the database is emailed to you in .zip format. So, I had to generate the datafile and then .zip it on the fly in memory. It was actually pretty easy in C#. Enjoy!!

6/20/2006 - Bulk Upload Form
I have completed a bulk upload form that allows uploading of multiple serial numbers per game now (up to 20 at a time). I will be working on another form soon that allows uploading of serial number data in a predetermined format so that if you already have serial numbers in electronic format, it should be quite easy to get them into the IPSND by putting them into a simple delimited format and then uploading the file.

6/11/2006 - Some Notes...
I don't have the current list of games from IPDB yet. My list is from about 3 years ago so I still have to synchronize with them to get
some of the more current games.

I have about 90% of the old Internet Pinball Project imported now. I will continue to work on getting the rest imported.

If you have corrections, just send me an email for now and I will update the DB directly.

The site was down last week because of a configuration error I had that I should have known about but since I was in a
rush, missed it. All should be good now!


5/31/2006 - Site Goes Live!
I think the site is mostly bug free for now. There isn't really much to cause bugs as the feature list is quite small. You can however add Serial Numbers to the database fairly easily and do a basic search for games by name. There are IPP serial numbers imported into the database for Level 7 games only right now. I received the complete IPP serial number list today from D.P. and will get the old serial numbers imported when I get back from Chicago next week. Thats all for now... if anyone has questions or comments you can email me at webmaster@ipsnd.net


Supported Browsers
Back 5 | Random | Forward 5 | List ]