We need a custom ISAPI filter coded in either MFC or Visual C++, for IIS 5.0 and MS SQL 2K Server that can: 1) Parse a user ID from the URL requested 2) Look up that user in an existing SQL Server database using an ODBC connection, or connection string, either to be specified in registry or INI file. 3) Verify using status isn't locked or account disabled 4) Parse filename from URL 5) Get privacy settings, file size, valid URL and other values for that file, from existing SQL Server database 6) Update "hit" counter for the file 7) Update user's daily usage and validate against daily usage limit 8) If a valid URL is specified, validate it against the referer 9) Proceed with delivering the file if all above criteria are passed. The filter must be thread-safe, and will get between 60 and 120 hits per second. This is currently being done in highly tweaked ASP with no performance problems on a dual P4 Xeon server. (UPDATE) This filter must also be able to be used in multiple instances on the same server. We want to be able to maintain this code going forward, so source code is required. We can handle the majority of the above logic if the rest of the filter is built, and a few initial DB calls are coded.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) No installation package required 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows 2000 Server, IIS 5.0.