Products Services


 Home » Products » Software » Query Spree

Query Spree

  - Forum
  - FAQ
  - Wiki
  - Troubleshoot
  - Team

  - Version Log

Make donations with PayPal - its fast, free and secure!

Bookmark and Share

Version History & Change Log

Listed below is a fairly detailed look at where Query Spree started, and the path that made it into what it has become today. Each public release is accounted for highlighting certain bug fixes, feature adds, and so on. Major upgrades versus fixes/patches are marked with appropriate icons.

 2.00.B11 - Released on September 25, 2009
  • Updated parsing engine to work with changes
  • Added code to download data for custom games

 2.00.B10 - Released on April 15, 2009
  • Fixed the four ultimate queries that had ApG being reported same as KpG
  • Updated parsing engine to work with changes
  • Fixed bug with players in multiple circles causing extra download sequence
  • Added a new filter to allow reporting by player or circle
  • Modified the performance rating query

 2.00.B9 - Released on March 8, 2009
  • Added one new console query
  • Updated parsing engine to work with changes

 2.00.B8 - Released on November 4, 2008
  • Added query filters
  • Added features to allow software updates
  • Rewrote and condensed all queries to use new filters efficiently
  • Updated parsing engine to work with changes

 2.00.B7 - Released on April 15, 2008
  • Possibly fixed issues with non-US style dates for games
  • Added the new console queries from BlueHoopedMoose
  • Added export to XML feature for full database
  • Enabled the minimize to systemTray option
  • Color coded options that do not currently work to red
  • Enabled the auto run timer feature
  • Added a SQL query editor for those of you that dont have Access but want to write queries
  • Corrected some of the weapon information

 2.00.B6 - Released on March 28, 2008
  • Possibly fixed issues with non-US style dates
  • Fixed issue with gamercards with recently played game titles containing a single quote
  • Added two variations of the Ultimate player summary query, for customs and matchmaking

 2.00.B5 - Released on March 23, 2008
  • Possibly fixed issues with non-US style dates
  • Added code to parse data from player gamercard, not used anywhere yet, but will be in future
  • Added session logging to help with bugs
  • Added code to allow full game scans

 2.00.B4 - Released on March 11, 2008
  • Fixed the express game list feature so that you can specify a list of game IDs to download instead of grabbing games by player
  • Fixed some error trapping issues in the event of a bad gamertag
  • Fixed issues with rank promotion dates for skipped ranks
  • Added a few new fields to the database to help another developer working on a game viewer
  • Fixed issue with run/stop buttons not being enabled and disabled properly

 2.00.B3 - Released on January 8, 2008
  • Executing a run now happens in a new thread
  • Fixed some spelling mistakes
  • Fixed issue with finding missing games
  • Added features to stop a run in mid-process

 2.00.B1 - Released on December 20, 2007
  • Brand new code base re-written from scratch in VB.NET
  • Many new concepts, very few of them completely implemented
  • Only supports download of Halo 3 game data

 1.1.4.R9D - Released on May 25, 2007
  • Tweaked the parsing engine to handle some small changes made on which was causing medals data to be all zeros, implement data missing, and player most killed(by) to also be blank.

 1.1.4.R9C - Released on May 14, 2007
  • Tweaked the parsing engine to handle some small changes made on which was causing medals data not to be dowlonaded
  • Removed marksmanship from the visible EGR, and scaled Honor up to 500 points so that the max EGR is back to 1000. All the structure still remains for marksmanship just in case Bungie makes more data available that would allow us to re-instate that feature.
  • Added a new export feature that creates SQL insert statements

 1.1.4.R9B - Released on May 8, 2007
  • Tweaked the parsing engine to handle some small changes made on
  • Added 2 new queries that show breakdown by weapon and kill method

 1.1.4.R9A - Released on April 16, 2007
  • Re-wrote the parsing engine to handle the new layout, presentation, and data elements
  • Changed EGR to set the Accuracy component to zero due to Bungie no longer providing shots fired and shots hit data. The maximum EGR for now is 750.
  • Added a printing feature that allows query results to be sent to a printer
  • Changed the options dialog to be more modular, allowing for a cleaning screen when additional options are added in the future.
  • Added some features to the collection manager dialog to allow for pattern based selections which should make things easier when enabling/disabling tags in mass.
  • Made Team SWAT unqualified for the EGR.
  • Added new data elements: Betrayals, Kills_Weapons, Kills_Grenade, Kills_Melee, Kills_Vehicle, Kills_Other, Implement_Name, Kills_Implement, Best_Spree, Player_Most_Killed, Player_Most_Killed_By

 1.1.4.R9 - Released on November 2, 2006
  • Added extra database fields to handle Team SWAT now ranked
  • Enabled Team SWAT ranked games to be included in EGR
  • Added new TPS query tag parameter for 'order'
  • Renamed some of the options to make them more clear

 1.1.4.R8 - Released on September 27, 2006
  • Fixed TPS templates that needed to handle new playlists
  • Added logic to prevent error #13 due to bad TPS parameters
  • Added new option that allows user to pick how/when they want database optimization to run
  • Fixed issue with database going invalid after manual optimization via menu
  • Fixed error #6 (overflow) when viewing the event log

 1.1.4.R7 - Released on September 12, 2006
  • Added new 'team carnage' playlist
  • Added new TPS query tag parameter for 'rows'
  • Fixed issue with upload not working if run was manually stopped
  • Fixed issue with freezing due to unknown error on
  • Fixed issue with other sporatic freezing and high CPU usage

 1.1.4.R6 - Released on August 20, 2006
  • Fixed error #5 and freezing due to change on
  • Added new TPS template 1009

 1.1.4.R5 - Released on June 25, 2006
  • Added a 'mode=clan' within TPS query calls to allow clan stats
  • Added new table to hold an event log, and corresponding viewer
  • Fixed error #5 when adding multiple tags to collection
  • Added new playlists (BTB Skirmish/Slayer & SWAT), and deactivated old playlists to sync with Bungie
  • Added new query to look at totals by 'finished place'
  • Added menu option to allow user to optimize database on demand
  • Added option to hold off validation until application is closed
  • Added new TPS template 1008 that shows a basic clan overview

 1.1.4.R4 - Released on May 19, 2006
  • Added a progress meter to the splash screen and main screen for validation
  • Fixed right click #381 error when adding tag from grid
  • Added button to change TPS template for all tags
  • Added option to backup the database file after a successful validation
  • Allow for more intervals within the scheduler; every 2,3,4,6,8,12 hours
  • Added the new 'rumble hardcore' playlist to the database
  • Added timeout and connection checks when uploading to Shatterock
  • Fixed error #3075 when dates were in format containing 'a.m.'
  • Fixed the issue causing Honor to be greater than 250

 1.1.4.R3 - Released on March 11, 2006
  • Note: This version is built from a completely re-structured code base, so there are too many fixes and new things to list, but some of the highlights are below:
  • Much more data is uploaded the Shatterock database for use on the new leaderboards, player pages, clan pages, and collection pages.
  • New interface design that shows EGR data, level data and has a much better way of showing application status messages
  • Queries were enhanced to fix some bugs and add KillsPerGame, AssistsPerGame and DeathsPerGame.
  • New EGR logic that takes only last 100 qualified games into the sample. Also bonecrackers are given 1 honor point instead of zero. More enhancements are in process to better refine the calculation and make things more accurate.
  • You can apply any of 7 templates to a TPS report to get a different look and stats data. You can create your own TPS templates if you wish using the special tags provided. A list and instructions will be posted later.
  • Database validation is now in place to prevent manually chaning of data and preventative measures for sending bogus data to the leaderboards have been implemented.
  • New options for checking for Query Spree software updates, toggling images in query results grid, showing line numbers, and controlling TPS output are now available.
  • New tag collection manager allows easier addition and removal of tags from your collection. Tags can be enabled/disabled from download runs, allow you to specify and upload TPS report URLs, clan URLs, and each tag can have its own TPS template preference.
  • Better database management, optimization, and integrity checking is in place to make running a tag as quick as possible.

 1.1.3.P4 - Released on October 26, 2005
  • This is a cummulative patch to fix the TPS report not showing all the playlist levels correctly, and to fix the issue with playlist ranks not being dowloaded correctly due to a change on the Bungie site.

 1.1.3.P3 - Released on September 24, 2005
  • This is a cummulative patch to fix the TPS report not showing all the playlist levels correctly, and to remove the new unranked playlists from the EGR.

 1.1.3.P2 - Released on June 25, 2005
  • This is a cummulative patch to fix the TPS report not showing all the playlist levels correctly.

 1.1.3.P1 - Released on May 4, 2005
  • This is a cummulative patch to fix the issue with not finding all games due to a change made on Bungie.

 1.1.3 - Released on April 6, 2005
  • Fixed issue with random hangs. Each game will be tried twice (30 seconds apart), if both attempts fail, then the game is skipped and flagged to be tried during your next download session.
  • If you haven't seen it yet, be sure to check out the new Flash Stats Signature (thanks to El Bastard).
  • There is also now a Forum available (thanks to NavySniper) for getting updates and troubleshooting, etc.
  • Fixed issue with error #91 after downloads.
  • Fixed issue with query filters not being preserved after a download, so they no longer reset to default.
  • Fixed bug with the clipboard icon not holding to the bottom of the form.
  • Fixed issue causing the #9 error (thanks to 'TheGarbageMan' for tracking it down).
  • Fixed issue with tags being dropped from the list. If a tag fails, you will have to manually remove it now.
  • Added some new fields to the 'time played' query (thanks to SpartanOmega).
  • Removed the game type specific queries temporarily until we can keep them from causing errors.

 1.1.2 - Released on March 16, 2005
  • Added a Query Spree Leaderboard. Be sure to enable the option in Query Spree to allow certain pieces of your TPS data to be uploaded.
  • Added 'ranked' and 'unranked' filters.
  • Added 'my clan' filter.
  • Added 'last 3 hours' and 'last 24 hours' filters.
  • Added 'last 50/100/200' filter. Be careful with these as the query can take upto 5 minutes to run if you have lots of players. Make sure to always at least restrict it to your tag list.
  • Changed all images from BMP to GIF.
  • Fixed bug with missing games for players that were not in tag list originally are got purged out.
  • Made the pop-up dialogs modal.
  • Fixed error #3437.
  • Fixed error #6.
  • Fixed error #3201.
  • Fixed error #3010.
  • Added toolip for the map names in the TPS report.
  • Changed a few things in the EGR, to exclude training games, and adjusted some Honor Factors, along with a new honor and efficiency curve.
  • Added a copy query results to clipboard button.
  • Added a reset filters button.
  • Fixed bug with filters resetting everytime you changed tags.
  • Changed format of time played on TPS to D/M/H/S
  • Added new EGR icons with new level definitions and special ones you can get indicated your primary strength.
  • Fixed the issues with European style dates.
  • Made some small changes to handle the new formatting of the game list on Bungie.
  • Added new options that allow the TPS report to be auto created after a download, and it can be placed in any folder you want, and you can specify the path for all the images in the HTML, which should make things easier for you when publishing to the web.

 1.1.1 - Released on February 14, 2005
  • Enhanced the EGR calculation, as many people were getting scores that were too high. To get a score in the 900's you would have to absolutely unbelievable, but it seemed rather easy to get that score before, so we fixed it.
  • Possibly fixed bug causing the #3204 errors.
  • Fixed bug with removing entries from Tag List causing #380 errors.
  • Changed terminology on the TPS Report to read Matchmaking instead of Ranked.
  • Fixed bug with stopping a download when applying the 'download all' feature. Now pressing the button will stop the entire string of downloads.
  • Changed the way guests are stored in the database.
  • Fixed bug with single quotes in the personal quote.
  • Fixed bug that now allows you to run a TPS report with only purged games, if that is all you have.
  • Changed the mini avatar on the TPS report to the full color one, instead of black and white.
  • Added a button on the main form to create a TPS report.
  • Added feature to allow you to mass upload a list of gamertags to the Tag List.
  • Added option to force auto-retries if the connection fails.
  • Added option to minimize the app to the system tray.
  • Added option to allow scheduled downloads. You must keep the app running though, you cannot close it and expect it to popup and begin running. So, just minimize it to the system tray and let it run in the background.
  • Added option to allow you to change the timezone.
  • Made another attempt to get a connection thru a proxy server.
  • Added a bunch more filtering options for onscreen queries.
  • Added four new queries that show game type specific stats, along with a summary by playlist.
  • Added a spash screen so that the main form can load in the background without appearing to hang.
  • Changed the format of the Trophy Room on the TPS report a little to show a better breakout.

 1.1.0 - Released on January 30, 2005
  • Re-Fixed bug that was possibly causing errors #3136, #3421.
  • Fixed bug with corrupt avatars causing #481 errors.
  • Fixed bug with stopping download before first game would cause error #9.
  • Fixed bug with 'running' query without actually selecting one causing error #3420.
  • Fixed bug with single quotes in the personal quote.
  • Added first pass of Total Player Stats (TPS) Report
  • Added first pass at the Elite Gamer Rating (EGR)
  • Added additional level icons for 43-50, thanks to one of our fans.

 1.0.9 - Released on January 23, 2005
  • Fixed bug that was possibly causing errors #3136, #3421. This dealt with having a personal firewall which would change the encoding of the data received.
  • Fixed bug with the avatars incorrectly labeled as BMPs, there are actully JPEGs.
  • Fixed bug with connection timeout.
  • Fixed bug detecting bad gamertags.
  • Added a new options dialog. See the FAQ for information on how to use it.
  • Added ability to pull back historical games that are now available on Bungie.
  • Added ability to just download experience level data without doing full download.
  • Added proxy support.
  • Added ability to change output format of the query results grid.
  • Added column highlighting to the grid upon sorting.
  • Added medal icons to the Summary of Medal query.
  • Added new query to show win percentage by team color.
  • Added additional database structure for colors, clans, and extra player data.
  • Added additional avatar download of a smaller black and white version for the Ownage Outline.
  • Added standard KpD ratio to all queries along side the KApD.
  • Added a query that outputs a graph.

 1.0.8 - Released on January 15, 2005
  • Fixed bug with finding new games after upgrade install.
  • Added sort arrow in the grid header to indicate direction.
  • Added right-click option in grid to add gamertags to Tag List.
  • Added feature to import data from version 1.0.4 - 1.0.7 only.
  • Added feature to purge data for all players that are NOT in your tag list. This should help reduce database size and speed up query response.
  • Added feature to allow multiple queued downloads for all players in your Tag List. Use the checkbox under the 'Download' button.
  • Added two filtering options based on player type (all/list/me) and game type (all/ranked/unranked). The number of queries has been reduced because of this.
  • Added the percent downloaded to the application title, so you can view it in the Windows task bar.
  • Added additional database structure to store 'experience level' data from Bungie. A new query and icons have been added to view this data. This data is only downloaded for players in your Tag List.
  • Added feature to timeout the connection to Bungie if the site does not respond. A message box will pop up letting you know that you need to try again later.
  • Changed the 'Kill to Death' ratio in the queries to 'KApD - Kills + Assists per Death', which provides a more accurate measure of effectiveness.
  • Added a feature that when an unexpected error occurs, a 'debug.log' file will be created containing detail about the state of the application when the error happened, which will allow us to better diagnose things. So please be sure to send us that file if you encounter errors.
  • Added ability to turn on/off the row highlighting in the grid for the current Gamertag.

 1.0.7 - Released on January 5, 2005
  • Fixed bug where if you pressed the run button with and no data was returned.
  • Fixed bug with exporting empty query.
  • Fixed bug with clearing grid between queries.
  • Fixed bug with alignments of text fields that begin with numbers.
  • Added additional sorting options to the grid.
  • Added record count and query time label under the grid.

 1.0.6 - Released on January 3, 2005
  • Fixed bug with duplicate games causing error #3022.
  • Fixed bug with the DBGrid, now using the FlexGrid.
  • Fixed bug with counting games incorrectly due to purging.
  • Added additional formatting to the grid.
  • Added additional option the export the query grid to Excel.

 1.0.5 - Released on January 1, 2005
  • Fixed bug with entering in an invalid gamertag as first item in list.
  • Fixed bug with resizing the grid columns that was causing the error #9.
  • Fixed bug with being able to tab to the avatar image control.
  • Fixed bug with query #19 where it wasn't running for correct gamertag.
  • Added additional check for missing stats for a gamertag on Bungie's site.

 1.0.4 - Released on December 30, 2004
  • Fixed bug with error #3356 due to exclusive locking of the database.
  • Fixed bug with corrupt download of an avatar image.
  • Fixed bug with resizing the form window.
  • Added additional queries, #19, #20, #21.
  • Added additional database structure to handle data from the Hits and Medals pages.
  • Added additional start menu link to

 1.0.3 - Released on December 28, 2004
  • Fixed bug with winsock errors due to invalid state conditions.
  • Fixed bug with game count for multiple gamertags.
  • Fixed bug with stopping a download in progress.
  • Fixed bug with storing the last succesfully downloaded game for each gamertag.
  • Fixed bug with 256th place as a finished place.
  • Fixed bug with install program error when trying to create a URL link.
  • Added additional check for winsock errors 10054 and 10061.
  • Added additional code and sub-folder to download and display avatars.
  • Added additional queries, #17, #18.

 1.0.2 - Released on December 23, 2004
  • Fixed bug with winsock data buffer.
  • Fixed bug with progress meter not getting to 100%.
  • Added additional indicator showing bytes downloaded.
  • Added additional code to allow for multiple gamertags to be downloaded.
  • Added additional queries, #4 through #16.

 1.0.1 - Released on December 19, 2004
  • Initial public release to a group of 25 people.

 0.9.1 - Born on December 4, 2004
  • Programming begins on a simple stat ripper based in Microsoft Access, while waiting for a delayed flight in the Chicago O'Hare airport. A small group of people found a program called H2SA and thought it was very cool in that it was getting data from Bungie and displaying career stats for a player. From that starting point, ideas ran wild on things that could be done beyond what H2SA provided. The original concept was to create an application completely based in Access, with no user interface, that by running a macro would grab a player's stats, and then with the use of queries in depth analysis could be performed. Enough demand was present to convert the database macro into a real distributable application, with an interface and all the trimmings.

  Contact Us |  Privacy |  Terms & Conditions © 1999 - 2013 Shatterock Technologies