August 2022 - Fixed statistics - Fixed payment flow - Fixed Stripe gateway - Fixed midnight cron - Fixed resetting lookup requests - Added yearly plans - Ability to delete account - Fixed 404 page - Fixed API calculator - Changed database encoding to utf8mb4 May 2021 - Missing changelog March 2020 - Fixed items not being able to be added - Fixed images not showing Sep 20, 2018 - Force HTTPS Jun 11, 2018 - Moved to a new server Feb 26, 2018 - Fixed API (Sorry this was broken for so long) - Fixed demo API links - Minor site tweaks - Enabled AnSc (R) Jan 10, 2017 - Recoded entire site from scratch - New site is build on Bootstrap - Removed legacy search - Rebuilt API (v3) Mar 31, 2015 - Added NoCaptcha ReCAPTCHA to the site. - Simplified signup process. Dec 08, 2014 - Recoded mobile detection from scratch. Mobile detection: - Now uses PHP instead of JavaScript. - Now uses cookies instead of session variables - Remembers your choice for 1 week. - Should speed up load time for mobile users. - Fixed the add code page on the mobile site. - Thank you Adam for letting us know! Nov 15, 2014 - Added spam protection to subcron. Nov 11, 2014 - Random codes come back much faster. Nov 10, 2014 - Free API access may be limited during times of high server load. - Changed API page to reflect these changes. Nov 09, 2014 - Fixed typo and link on API page. Thanks Ben! - Reworded about page. - Removed background image. - Added alias, manufacturer, and category to the modify item page. Nov 07, 2014 - Added PayPal donate button to home and about pages. - You can now buy additional API requests via the UCP API page. Apr 27, 2014 - Worked on server load issues. Apr 08, 2014 - Spell check on statistics page. - Images added to the site were not being counted on the scoreboard. - Added scoring information on moderation page. - Changed font color from 363636 to 323232. But who cares about that?! Mar 25, 2014 - Fixed new members not being allocated API requests. - Changed high CPU load limit to 135% Mar 24, 2014 - Added quota for API requests. - API quota is default to 1000 requests per day. - Added new error code for API interface. - Because of the spike in the API request graph, it has been changed to LOG scale. Mar 16, 2014 - Image uploads were not working properly. It has been fixed. Mar 15, 2014 - Fixed scoreboard doing weird things when you're not logged in. - Scoreboard can now show the top 50. Mar 02, 2014 - It's been down for a long time, but the scoreboard is back up again! - Instant search is now MUCH faster! Mar 01, 2014 - Completley recoded the image uploaded on the product page. - You can click to upload as well. - Increased supported image size to 240x300 - Less annoying ads. Feb 28, 2014 - Over-capacity error message was affecting API calls. The API will now work regardless of load. - Member count now updates every 30 minutes instead of every 24 hours. - Subcron was causing high server loads every 30 minutes. Load has been reduced about 40%. - Codes not found via instant search are now added to the resolve table - Added "Moderation Tools" to the menu and moved some things around a bit. Feb 26, 2014 - Search has been greatly improved. Search now searches 12 and 13 digit barcodes. - Rewrote the home page. - Minor bug fixes and CSS inconsistencies. Feb 25, 2014 - Added 'Unknown' codes display to stats page - Fixed redirect loop when server running over capacity. Oops. - Removed the barcode graphic from the website. - Want to see an easter egg? Search 'barcode' in the top right search bar. Feb 24, 2014 - Changed homepage. - Started design of public moderation system. - Deleted the upc_holddelete table. - Items pending deletion are now based on user votes. - CPU load in the footer is now realtime. - Implemented a 'fail-whale' type overload page. - This is important because the site sometimes goes over 100% during the work day. - Now, the site will redirect users to an overload page until the load is reduced. Feb 20, 2014 - Tightened security on the API - Fixed API log database table Feb 19, 2014 - Removed a lot of unused files. - Deleted some old database tables. - Increased security on the QR code generator. - Completley reworked actions table. Sorry for the errors for a while. - Page built in xx ms was not being calculated correctly. Feb 18, 2014 - Made the `add code page` a little bit better. Feb 17, 2014 - Removed logging of codes added per week. - Fixed sidebar. Turns out 'codes added this week' were really this 'month' all along! - Added 'Alias' field to code lookup pages - XML API was broken. No one told me! - UPC Codes must be entered exactly into the API. Partial codes will no longer be accepted. - Changed random link from /search/random to /random - Random items are not so random. Random now tends towards higher-quality items. - Removed legacy API - Added a moving average to the daily lookups chart - Removed secondary two-million code countdown. Feb 15, 2014 - Alias' were not being added correctly. - Fixed images not showing up correctly with UPC-6 barcodes - Changed image background CSS from 'auto' to 'contain' Feb 13, 2014 - Noticed I was using the wrong dates in the change log this past month. - Removed st1 from the upc table. 'newupc' will superceed all of this. - Searches will be faster. - Database will be smaller. - Item searches will be MUCH more intelligent. - Started a rather large database import Feb 11, 2014 - Completley redesigned the "Latest Codes" page. Dropped datatable scripts. - Started first step in validating all UPC codes in database. Feb 09, 2014 - Added tooltips to code add page. Feb 08, 2014 - Cleared barcode 'type' column from upctable. - Added 'category' column to upctable - Bug fixes on stats page. - Uploaded 13,000 new images for consideration - Instant search now requires 3 characters for search. (Previously 4) - Instant search now requires 5 digits for search. (Previously 4) - Added support for new categories on /add page - Link to add page from instant search page if no results are found. - Added new manufacturer table. - Started official support for 'alias' column Feb 07, 2014 - Fixed total number of codes not showing up in statistics. - Removed ip column from database table. The actions table stores this. Jan 22, 2014 - Created new changelog page. - Rewrote changelog.txt to eliminate long lines and word wraps. - Changed changelog footer href from changelog.txt to /changelog - Removed twitter from footer. Jan 20, 2014 - The site had a weird load problem today. Issue should be fixed now. - Cron diddn't run last night so stats were caught up today. - Require instant search to have at least three characters. Jan 07, 2014 - Ads don't appear on product pages if you're logged in Jan 06, 2014 - Launched Instant Search! - Ads don't appear on product pages if you're logged in Jan 05, 2014 - Fixed msrp not being added via cURL API. (Thanks Mike!) - Removed "Random" from search page. (Thanks James!) - Added and verified over 1000 new items. (Thanks Peter!) - Removed old code from stats page. Cleared up wording. Jan 03, 2014 - Added months to two million codes countdown. - Added new graph to stats page, "Daily Lookups". - Code cleanup on stats page. - Banned a spam IP address. - Fixed a major issue with code search. (st0s not updating) - Removed logging of visitors and removed subsequent tables. Jan 02, 2014 - Removed "With Images" from codes graph. - Fixed horizontal axis on the graphs on the stats page. Jan 01, 2014 - Started loggin daily code views. - Fixed UPC Snacker - Fixed links not working on latest page. Whoops! Oct 07, 2013 - Godaddy didn't automatically renew the domain?!? May 08, 2013 - Changed pagetime and queries in footer. - Errors on the site today as hard drive hit 100% capacity. Apr 11, 2013 - Updated RGraph from November 2012 release to March 2013 release - Added API usage to statistics page. Apr 10, 2013 - Statistics now record API usage. - Changed 'ailias' to 'alias'. Whoops - Removed "Total Codes" from codes graph and made it it's own graph. Apr 09, 2013 - Added 'ailias' to upcdatabase table. -This is a short description of the product. - Added cURL API so members can insert items via API. - Added api.upcdatabase.org and changed the way this API is handled. - Added msrp table. This will handle pricing from now on. Apr 06, 2013 - Changed the way UPC searches are handled. - This resulted in a much needed server load reduction. - Preceeding 0's may be omitted from codes. - Added st0s and st1 columns to upcdatabase table for indexing. - Started processing the machine table. Dec 04, 2012 - The scoreboard is back! - I think that's going to be it for a while! Dec 02, 2012 - Replaced air.upcdatabase.org with m.upcdatabase.org - Added "Add Code" page to m.upcdatabase.org - Recompiled scores for scoreboard. This was a mission. Dec 01, 2012 - The 'Remember Me' function now works when you login. - Purged the codes pending deletion. - Deleted codes are now moved (immediatley) to a separate table. - cron now monitors unresolved codes. (Searches with no products) - Database changes. Nov 30, 2012 - Finally fixed the mobile site! The new URL is m.upcdatabase.org - The mobile site now has a new theme, and is much faster. - Fixed a MAJOR security bug in the way password changes were made. - Finally finished the password recovery script. /recover - actionlog is now actions, which now logs all user database changes. Nov 28, 2012 - Added persistant login support, with the help of cookies. Nov 25, 2012 - Coded and released the first of the moderator tools, comparison. Nov 23, 2012 - Added EAN-8 support to the code page. - Changed the way the days to two million codes is calculated. Nov 20, 2012 - Fixed the API page, and the date modified for the API interface. - Fixed the JSON API not delivering item names (since November 4th) - Added a new image upload feature to the code page. - Added support for .png and .gif images to code page. Nov 15, 2012 - Congratulations to our 1,000 th member, srgsm*****! - Fixed member count not displaying correctly on stats page. - Added code management (Delete, Modify, Verify) tools to the code page. Nov 13, 2012 - Fixed statistics page not showing deleted and pending codes correctly. - Changed how cron marks codes for deletion. Nov 12, 2012 - Significantly random item seek time. Nov 11, 2012 - Fixed codes added per day in sidebar. Nov 5, 2012 - Recoded Barkley Addition Software. - Dropped 'cashe' column from statistics database. - Added ean and upc columns to statistics database. - Just a few days to 1000 members! - Added experimental graphs to statistics page. - Statistic "weekly added" now updates every 30 minues, not once a day. Nov 5, 2012 - Added meta information to the pages. - Fixed random button on search page. - Fixed statistics in sidebar. Nov 4, 2012 - Site recoded from scratch. - Added bootswatch CSS3 bootstrap for all new stylings. - The site has dropped all .php filenames. index.php now controls the site. - Upgraded from mysql to mysqli - Significant database improvments. - New product page layout. - New background image. - Added a new QR code generator, including one you can use from your browser. - Moved the blog to it's own page. - Changed the QR wallpaper page to a QR quote page. - A new Check Digit calculator - All new barcode facts. - A new User Control Panel. - Fixed code lookup - Fixed add code page - Fixed signup issues Jan 21, 2012 - Added Out of Milk and Site5 ad squares to sidebar. Jan 18, 2012 - Home page was replaced by an anti-SOPA banner for the day. Jan 14, 2012 - Optimized 'Latest Codes' page. It was not efficient. - Resource usage remains high, searching for additional ways to cut CPU usage. Jan 8, 2012 - BRAND NEW voting script for product pages. - Entire cache has been purged to accomodate the new product page and voting mechanism. - Switched to search powered by Google. Jan 6, 2012 - Fixed sine wave. - Added number of image files stored to statistics page. - Added comma separated thousands to all the numbers. - BRAND NEW product table layout and theme. Jan 5, 2012 - Added a sine wave with a day interval to the load graph for comparison. - Fixed the sidebar scoreboard in the user control panel. (ucp.php) - Added a description in the moderator panel of the UCP. - Removed "Admin notes" from the UCP. Jan 4, 2012 - Date on search results page would always show up as January 9. ?? Jan 1, 2012 - Happy new year! - Changed the way raw statistic data is generated for display. Much faster now. - Added a 7 day moving average algorithm to the "Codes Added" graph. - Deletion pending codes are no longer counted. - Cron is now more aggressive with cache purges. - Updated RGraph to latest version. - Redesigned the charts on the statistics page. - Statistics no longer show on lookup.php - Sitemaps are now generated once a week instead of on-the-fly. - Text is no longer justified. - Hourly cron has been greatly optimized. - Scores now update correctly. Scores now reflect item and image changes. - Fixed scoreboard to display the fixed scores above. - Hidden users are now hidden. - Fixed comment box not displaying correctly. Dec 31, 201 1 - Patched 'One Million Codes' banner. - Fixed issue with statistics not working sometimes. - Removed days to one million codes. - Updated cron to run smoother. - Removed and cleaned up old moderator panel code. Dec 29, 201 1 - Set up a little surprise for when we hit one million. - Removed pre VPS resource restrictions. - Image API broke since the move. - Google images are no longer showed on lookup page. - Coded a new moderator panel from scratch. - Image selection now works. - Editing does not. - Removed the old moderator panel from the lookup page. - Cron has been fixed since the move to the new server. - Added "Server load" to footer. Dec 28, 201 1 - Some VPS problems, moved to a new VPS server. Dec 25, 201 1 - Site has moved over to a new VPS server. Dec 07, 201 1 - Password recovery tool is now in beta. Dec 05, 201 1 - Database malfunction caused all member passwords to be reset. A backup was loaded. - 40 member passwords are still unaccounted for since the last backup. - A password recovery tool is being conceived. Dec 04, 201 1 - Added security for account creation. - Added security checks for account modification - Ability to change password via the User Control Panel. Nov 21, 201 1 - 20 Days until 1,000,000 codes! - Updated search page (search.php) - Removed the beta notices on the statistics page (stats.php) - Changed barcodeinfo.php to barcode-info.php for SEO - Changed qr_wallpaper.php to qr-code-wallpaper.phpfor SEO Nov 12, 201 1 - Removed old file cache statistics from the database, stats page. Nov 10, 201 1 - Fixed users not being able to register afer the November 4th update. Whoops. - Fixed the way the latest codes are displayed. The item names wouldn't show up sometimes. - Fixed 1540 codes containing stray html. - Pushed the scoreboard live. Nov 9, 201 1 - Started a new scoreboard to show member and moderator scores. - Added "View All" range to statistics page. - Added days to one million codes on the top right of the site when you're not logged in. Nov 4, 201 1 - Changed the way certain statistics are displayed. - Updated UPC Collector. - Added a check for existing usernames at signup. Oct 31, 201 1 - Happy Halloween! - Cached results now show in percent on sidebar. Oct 20, 201 1 - Fixed statistics graphs always starting with 0. - Updated latency chart. Oct 14, 201 1 - Misc edits. - Started database collector again. - Removed front page ad for logged-in users. Sept 17th, 2011 - Fixed database size showing up incorrectly. - Database changes/backup. - Deleted old cache. (Revision 0) - Removed 'revision' column from cache table. All new revision will result in a cache dump. July 23rd, 2011 - Changed the way the recommendation bar is displayed (2 rows instead of 1) - New rating system has additional ajax, but no graphics (images). - Added 'revision' column to cache table so lookup.php knows how to display - Edits with the moderator control panel now clear that page's cache. July 17th, 2011 - Added a new UPC sniffer to the site. Codes added per day should increase significantley. - Added Google +1 to the footer. July 13th, 201 1 - 100 Members! - Added one million code ETA to statistics page. July 12th, 201 1 - Fixed not being able to change your username. - Added filter for username changes. July 9th, 201 1 - Added file time check to changelog. - Merged the "Cached Results" graph with "Total Codes" graph on the statistics page. July 8th, 201 1 - Cron optimization. - Cleaned up code. - Completed comment system! July 2nd, 201 1 - .htaccess SEO optimization. June 29th, 201 1 - Some database optimization. - Cron optimization. - Updated header image. - Put the database caching system into full effect. This new system is much faster. - The file caching system has been depreciated. June 28th, 201 1 - The old header has now been depreciated. - New vote in the UCP. June 27th, 201 1 - A JSON API service has been added to the site. - The API page has been updated. - Statistics page has been updated and some bugs fixed. - Added option to show 14 or 28 week statistic period. June 22nd, 201 1 - Added code to CRON to delete cache files older than 50 days. June 19, 201 1 - Finished work on the JSON API. - The XML API has been modified to show rate up's and rate down's. - The XML API was missing a XML type and had superfluous tabs. (Thanks mike) - A new XML API has been created. - Updated User Control Panel API page. June 15, 201 1 - Cron still was not running on schedule. Problem should be resolved now. - Added "Cron last run XXX minutes ago" to footer. - This value should never go over 1440. June 7th, 201 1 - Fixed cron not running again. - It's having a hard time analyzing all the statistics. June 3rd, 201 1 - API has been fixed. - Started the move from the flatfile caches to a database cache system. - Added statistics for this now cache system to the statistics page June 1, 201 1 - Database import is complete! May 30, 201 1 - Improved the search result page after searching by item name. - Search results appear much faster. - Removed the "Feature Workshop" - Optimized images and CSS, saved over 400kb. - Improved CRON speed. May 29, 2011 - Major Fix: No codes could be entered into the system from May 26th! - Database import at 95%, 2 days left. May 28, 201 1 - Fixed a major error where no results would be show. - The error started a few days ago and was attributed to MySQL - trying to pull the now removed 'total_rating' field. May 27, 201 1 - Added "Remember me!" to login widget. - Simplified the "Autologin" secion of the user control panel. May 26, 201 1 - Forced new rating system. - Cached results show a "Refresh page to vote" message. - Fixed redirection bug to upc_beta.php in the new ucp.php page. - Removed 'total_ratings' and 'rating' columns from database. - Added more focus to statistics in the sidebar - Added 'Added yesterday' and 'Added yesterday' to statistics widget. - Statistics widget does not show on statistics page. - Added statistics widget info plus other info onto statistics page. May 24, 201 1 - Fixed content possibly being misplaced on older browsers. - Added "API Key" section to the User Control Panel. - API now check for valid API key and API key length. - Updated "API Services" page with updated API information. - Added Tesla wallpaper, made by yours truly :) - Moved the new UCP out of beta. It's now the new UCP - New swirly blue highlight for the UCP. - Made improvements to the rating system, added like and dislike buttons. - Database import at 83%, 7 days left. Database passes 300,000 rows. May 23rd, 201 1 - Added "Support us!" section to About page. - Added "Extras" heading to sidebar and moved some links there. - Added extras page with Vladstudio QR wallpapers. - Fixed: hiding statistics would hide ad's as well. May 22, 201 1 - Completely redesigned the rating stem on product pages. - Added 'rate_up' and 'rate_down' columns to database. - Some highlights of the new rating system: - It works on a like/dislike system instead of stars. - It will allow an easier look into the rating of a product. - It is now integrated into each page, instead of using iFrames. - The old rating system will still be used on cached pages. - Old ratings are copied over to the new system every 15 minutes using: - UPDATE TABLE SET rate_up=((rating/5)*total_ratings)-0.5; - UPDATE TABLE SET rate_down=(((5-rating)/5)*total_ratings)-0.5; May 21, 201 1 - Started working on mobile accounts. - Changed cookie path to allow the mobile site to work with the main site. ! - Pushed mobile accounts live! (1 hour!) - account.php to handle both mobile and regular logins and logouts. May 20, 201 1 - Added "General Stats" to statistics page. May 19, 201 1 - Adding images from Google in the MCP upload much more clearly. - Updated cron to identify and delete useless codes more effectively. - Primary database import at 75%, 10 days left. May 18, 201 1 - Sitemaps are now fully automated. - Updated 'query time' graph. - Fixed 404 errors from the old /air/123456 to the new air...org/air/code/123456 ! - Fixed a nasty error when a user was logged in and tried to view a non-cached page. - Link to mobile site was broken, type. :( - Started a beta version of the User Control Panel. - More SEO tweaks. - Administrator/Moderator names are now highlighted on the leaderboard. - The UCP now shows the number of codes you've added images for/modified. May 16, 201 1 - Made significant changes to AIR search: ! - "AIR Search" has now become the mobile version of the site. - AIR Search URL has moved from http://www.upcdatabase.org/air to http://air.upcdatabase.org/ ! - A brand new theme has been imported and customized for this new mobile version. - Links to this mobile version have been updated in the sidebar. - A link to this mobile version has been added to the footer. - .htaccess files have been created/modified to accommodate this new subdomain. - /air/ results now point to the new submain. - A touch icon for iPhones, iPads, etc has been added to the site. ! - Fix: Pages were being cached, but no cached pages were being shown. - Changed homepage layout to show introduction and poll at the top, blog below. - Added screenshot of mobile site! - Added times back to the "Latest Codes" page. May 15, 201 1 - Moderator Panel now displays 6 images instead of 3. - Optimized how product views are updated. - Product views are now counted even if the page is cached. - Added "show_modpanel" to the database. (Visible to users with rank > 5) - Added "Rank" to the user control panel. - A products cache is deleted when an image is added from Google. - Added moderator section to the UCP ! - Accidentally left a query in the leaderboard script that was causing high page load times! - Database import is now at 66%. - The action-logging database now logs the modifying of codes. - CRON removes rows from the action database that do not have rows in the upc database. - Actions are now logged for user adding codes that are NOT logged in. ! - The leaderboard is now updated from the actions-logging database, not the upc database. - Added "Query Time" graph to statistics page. May 13, 201 1 - Sped up database query time by adding date and code indexes - Changed the default font's on the site for users with older computers. - Optimized the database further by reducing certain field sizes. - We now only pull the fields we need from the database, instead of all of them. - Random items are now handled by search.php, not /meta/lookup.php ! - Random item lookup time had been greatly improved. - Database import is now at 64% (16 days remaining) - Reduced whitespace on results page, as well as some other pages. May 12, 201 1 - CRON now counts codes added in the past day as well as past week. - Updated statistics page to show codes entered in a given day, not week. - Changed the color of the link from purple to blue. May 11, 201 1 - Fixed CRON not counting 'total views' for that day. - Removed 'total views' from the statistics page. It's still in the sidebar. - Moved 'Added Codes' from the main graph to the deleted and pending graph. - The subtitle of the logo images changes every time you refresh the page! (5) - Added cookie support to the site (Beta). Information is in the UCP. May 10, 201 1 - Fixed the moderator control panel: OneClick image add from Google. - Added a new feature to the fetcher. (chunk.php) (Admin) May 9, 2011 - meta/lookup.php now checks if search is numeric or not, and redirects accordingly. - Product search page (search by name) updates: - - Page now has red and green highlighting like search.php - - A message is now given if there is no match. - - Duplicate results have been removed via array_search - Database import is now at 57% ! - Cache files are split between multiple directories for performance. (S5T) - Cron now runs at a lower priority. (S5T) ! - Whoops, fixed code insert. Again! May 8, 2011 - Leaderboard is now controlled by subcron, updating every 15 minutes. - Leaderboard is now shown to the public. - Sitemap updates. - Database import is now at 54% - New Feature! Product search by name! May 6, 201 1 - Modified CRON. Increased limit values on deleted code marking. - Updated barcodeinfo.php and faq.php - Added 'status' column to database. - Wrote this line into the changelog. May 5, 201 1 - Fixed redirect error after entering a code. - Changed the way images are uploaded to the site. - Switched from database storage back to files. - Changed image storage location. - Encountered error while backing up database. As a result: - Lost a small percentage of product names. - A workaround to this problem has been developed - Removed 'imagename' and 'image' fields from database. - Search performance has increased by ~ 40% as a result of the above change. - GREATLY improved the performance of cron by removing the code check loop. (S5T) - CRONs check of invalid codes has significantly been improved. - By adding DELANO and BALANCES to table. - Cron now marks invaldi codes for deletion, and questionable codes as "Pending". - CRON now has authority to delete 20 rows it finds invalid without a doubt. - CRON now also monitors how many image files there are. May 4, 201 1 - Fixed displaying of cached results on statistics page. - lookup.php now handles results only, search.php handles searches only. As a result: - All error handling has been moved from lookup.php to search.php - Changed the way caching is handled. lookup.php will now handle caching automatically. - Small modifications to image search for performance. - Added option to not display cached results in user control panel. - Added javascript "member since" counter in user control panel. Apr 29, 201 1 - Results are now cached for perfomance reasons. Cache time has been set to one month. - CRON now monitors cache results. - Statistics now show cache results. Apr 25, 201 1 - CRON runs automatically via cronjob, instead of relying on a page load to activate it. - Stylesheets moved and updated. Green has now been added as a color. - Search and results page change background color when displaying errors. - Debugged the site with ini_set('error_reporting', E_ALL); - Database import was halted for a while. It's resuming now, 40% complete. - Enabled gzip compression. - Fixed star rating system. Apr 17, 201 1 - Updated Search form. - Revised sitemap generator. - Updated some meta content. - Changed menu font size from 13 to 12.5 Apr 13, 201 1 - Happy Birthay to me! - Changed color of sidebar headers from 000 to 444 - Repaired the database, there was a corrupt upc code. - Reduced sitemap count from 40,000 to 20,000 (for now) Apr 11, 201 1 - Added Page: QR Code Generator! - Rewrote the sitemap generation script. - The Leaderboard will remain hidden to non logged-in users for the time being. - Database import is now at 32% (32 days left) Apr 9, 201 1 - AIR Search now has a random feature. - AIR Search results are now presented as http://www.upcdatabase.org/air/ - The AIR Search lookup format has taken over code_infotext.php - Dynamically generated and submitted 4 sitemaps to Google. 40,000 URL's each. - Added © to AIR - CRON now tracks airviews. - Rewrote CRON. CRON now runs in 1 query instead of 7. ! - Sidebar statistics now update daily, instead of every page load. - As a result of the above change, pages now load 10 to 20 times faster. - (From 2-6 seconds to less than 200 ms.) - Rewrote mysql script for statistics page to work with the new interface. Apr 7, 201 1 - Cleaned up the 404 page, http://www.upcdatabase.org/notfound - Error messages are now handled by session variables rather than GET data in the URL - Changed random link from lookup.php?random=true to meta/lookup.php?random - Split lookup.php into lookup.php and search.php. Both pages now load faster. - Improved the code behind lookup.php and search.php - lookup.php is more SEO friendly by making it display a search box if no code is inputted. - MAJOR CHANGE: Codes are now displayed as http://www.upcdatabase.org/code/1234567890 - New feature: AIR Search http://www.upcdatabase.org/air - Codes that do not exist that are searched for with /code/ return an error and new search. Apr 6, 201 1 - Secured admin page. - CRON now checks if you've cheated with code entry. - Updated how preferences work. - Added the options "Show Footer" and "Show Name in Leaderboard" - Set max length on username to 16 chars. - Improved the way images are handled on lookup.php - Added support for database images on lookup.php - Fixed incorrect time being saved on new codes. - Working on support for themes in the UCP - Added red theme for lookup page. - Database import is now 28% - Added separate database table to log user actions. - Fixed meta tags - Registrations now log IP addresses - Created submission.php and populated it with useful information. - Introduced jquery to the site for the first time. - Changed upload method for pictures. - Photos are now stored in the database rather than a folder. - Fixed rating system. Apr 5, 201 1 - Fixed registrations. - Modified leaderboard. - Database import is now at 26% - Moved "Debug" from sidebar to hidden location in footer. - Reduced the size of the menu images from 140 to 120. More room on the page. - Wrote terms and conditions page. - Added "Site Terms" to footer - Added "Personal Preferences" to UCP - Added "Change your username" to UCP - Cleaned up Workshop. - Introduced 'blue' scheme to ucp.php - Gave users its own graph in stats.php ! - CRON now runs once a day instead of once a week. - Found a bug in CRON. Performance has greatly been improved. - CRON now monitors views, pending codes, and deleted codes. Apr 3, 201 1 - Removed session_start() from all pages. ! - Required connect.php to all pages. (Which now contains session_start) - Removed connect.php on sidebar, as it is now contained in the head. - Upgraded to PHP 5.3.x - Fixed the header error that sprung up. - Completed the login check script for connect.php. - connect.php now redirects you based on if you're logged in or not. - Fixed the link to terms.php - Added "Registered users" to statistics sidebar. - "User Login" on sidebar turns into "Your Account" if you are logged in. - "Your Account" only has links to control panel and logout. - Revised beta.php page. Renamed "Beta Workshop" to "Feature Workshop" - Moved "Query time" from sidebar to "Page built" time in footer. - Improved accuracy and speed of query timer. - Wrote a neat mysql query for the leaderboard. - Reduced the header image and bar by 10px - Database import at 22% ! - Whoops! Fixed the problem with users not being able to enter codes. - Started logging the number of users in cron. - Added Ads to lookup.php They remove when you are logged in. - Moved "Your Account" from sidebar to the top-right of the page. - Added users to statistics page graph. - Reduced the space between sidebar items by half. Apr 2, 201 1 - More work on the register script. - Added a neat feature to the 404. ! - Created ucp.php - Finished signup.php - Code import is now at 21 percent. 32 days remaining. - Pushed signup.php live. It's still in beta. - Added a login prompt to the sidebar. ! - Added session_start() to all pages and pushed the login script live! Mar 30, 201 1 - Cleaned up barcodeinfo.php a little bit. - Database import is now at 16 percent. - Passed 100,000 a few days ago! Mar 25, 201 1 - Switched the sidebar style headers to actual h3 headers. - Removed "System Load" statistic. - Bugfix: Added code_information.php to .htaccess redirect - The server now keeps track of the modified time. - Added primary content to the check digit page. - New page: barcodeinfo.php Pushing it live on the new menu. - New page: faq.php Pushing it live on the new menu. - Added a new sidebar menu, "Main Menu". - Fixed the title display on the lookup.php page. - Changed contact.php to about.php and updated links. - Updated services.php - Bugfix: Added about.php to .htaccess redirect - Added a custom 404 page. Try it out! - Added the "Beta Workshop" page. Mar 24, 201 1 - Finished the script for the check digit calculators. - Finished the images for the new checkdigit.php page. Horray! Mar 23, 201 1 - Switched the page "headers" style to actual

headers with CSS. Mar 21, 201 1 - Updated the "UPC Collector" program to version 12.1 - Just began a large database import. Expected to take 29 days. - Optimized a few scripts as to reduce the number of mysql queries. Mar 18, 201 1 - Updated the "System load" and the way total lookups were added. - Further optimized statistics page. - Changed the random item link from the one below to the following: - upcdatabase.org/meta/lookup.php?random=true - upcdatabase.org/lookup.php?random=true - Improved security on lookup.php - Further improved the way error messages are handled on lookup.php Mar 16, 201 1 - Updated the way the API system works. - The API link has also changed to the following: - http://upcdatabase.org/meta/api.php?apikey=KEY&code=UPCCODE - Changed the way codes are searched. - Invalid ncorrect codes are now displayed in a more user-friendly way. - Optimized a lot of backend PHP for performance. - Updated sitemap.txt to reflect the above changes. ! - Check if a code exists before adding a new one with the same UPC. - Made small adjustments to the statistics page. - Cron now runs twice a week. - Added "System load" in sidebar, just for fun. It actually works though. Mar 13, 201 1 - Working on "Statistics" page. Started logging statistical data. - Cleaned up obsolete code around site, should run quicker. - Added background image. - Added "More Statistics" link to sidebar. - Really starting work on user account creation. Mar 9, 201 1 - Revised the sidebar. Added Adsense. - Started working on user logins! - Cron status now shows up in the page footer. Mar 8, 201 1 - Fixed issue where codes missing leading 0's were not searched for. - Spaces can now be entered into the API search URL. - Updated the latest codes page. Increased the count from 100 to 250. - You can now search for partial codes. Mar 7, 201 1 - Spaces can now be entered into search feilds. - Cron file created to watch for bogus UPC codes. Mar 5, 2011 - Changelog started to keep track of, well, changes. :) - Started a 'blog' format home screen for better news releases.