BannedIP Call
Description: Reads the ClientIP and checks against the IgnoreIPs table. Not sure what this is used for..

SQLCommand To Run:

Select IgnoreIP from dbo.IgnoreIPs where IgnoreIP = @ClientIP

@ClientIP:

10.43.4.198

This IP is banned:

False

Successfully Checked Blocked IP

ParseURL
Description: Reads the URL and parses it into the different data elements.
Full URL: 404;https://devsite.usf.edu:443/test-jessieg/ui-component-library/images/seaglass-gradient.jpg
Protocol: https://
Domain: devsite.usf.edu

CleanQueryStr: devsite.usf.edu
CleanQueryStrVDFullTail:
Actual URL Entered by User: https://devsite.usf.edu/test-jessieg/ui-component-library/images/seaglass-gradient.jpg

Not :80 (http)

IIS 404 Error Path (:443): /test-jessieg/ui-component-library/images/seaglass-gradient.jpg
IIS 404 URL Start Position: 27

No QueryString Parameter Found

Find Campus from URL
SQL Command To Run: SELECT TOP(1) Name FROM dbo.Campus WHERE @Path LIKE '%' + Path + '%' AND IsActive=1 ORDER BY DispOrder
@Path: https://devsite.usf.edu/test-jessieg/ui-component-library/images/seaglass-gradient.jpg
Campus: Tampa

Folder Count: 4
First Folder: test-jessieg

CleanQueryStr Value: https://devsite.usf.edu/test-jessieg/ui-component-library/images/seaglass-gradient.jpg
CleanQueryStrFullTail Value: /test-jessieg/ui-component-library/images/seaglass-gradient.jpg

Variables
GenericURL: /system-error/error.aspx
Campus: Tampa
Proto: https://
PassThru: False

CheckforBadSyntax Call
Description: Takes the QueryString and identifies if any of the blackList strings are found. If so, the user is auto-redirected to the Generic 404 Page.
What is being checked:

/test-jessieg/ui-component-library/images/seaglass-gradient.jpg

QueryStrFix Scrub:

No Bad Syntax Found

CheckIgnoreURL Call
Description: Checks the URL against the IgnoreURL table, if a match is found the user will be directed straight to the 404 Page Not Found page and the URL will not be logged in ErrorPageLog.

SQLCommand To Run:

SELECT IgnoreURL FROM dbo.IgnoreURLs WHERE Campus = @Campus and '/' + IgnoreURL = @URL

@Campus:

Tampa

@URL:

/test-jessieg/ui-component-library/images/seaglass-gradient.jpg

URL is not ignored

RedirectGoLive Call -- File Level Redirects
Description: Check the File Redirects table for a matching file; if one exists return the redirect URL.
URL Full VD Tail: /test-jessieg/ui-component-library/images/seaglass-gradient.jpg
URL Full: https://devsite.usf.edu/test-jessieg/ui-component-library/images/seaglass-gradient.jpg
URL Full Minus Protocol: devsite.usf.edu/test-jessieg/ui-component-library/images/seaglass-gradient.jpg

SQLCommand To Run:

SELECT FilePath,RedirectURL FROM dbo.FileRedirect WHERE Campus= @Campus and FilePath=@filepath and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))

@Campus:

Tampa

@filepath:

/test-jessieg/ui-component-library/images/seaglass-gradient.jpg

No FilePath Match

No real URL in DB for FileRedirect.

DBSearchVD Call for Tampa
Description: Takes the search string, compares it to the URLNinja DB and returns the RedirectURL field. Also takes into consideration if the Expiration Date has arrived.
Checking Folder: 1 -- test-jessieg

SQLCommand To Run:

SELECT RedirectURL,PassThru,FolderPath FROM dbo.FolderRedirect WHERE FolderPath = @BadVDName and Campus=@Campus and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))

@Campus:

Tampa

@BadVDName:

test-jessieg

No Match

No real URL in DB.

DBReturnURLPath was empty... moving on!

Check for Multi Folder Redirect
Description: Check number of / in the URL, loop through each folder starting from last to check if the path exists.
Full Path: test-jessieg/ui-component-library/images/seaglass-gradient.jpg
The path contains 3 /s

File Found in Folders
Skip because it is a file (seaglass-gradient.jpg)

SQLCommand To Run:

SELECT RedirectURL,PassThru,FolderPath FROM dbo.FolderRedirect WHERE FolderPath = @BadVDName and Campus=@Campus and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))

@Campus:

Tampa

@BadVDName:

test-jessieg/ui-component-library/images

No Match

No real URL in DB.

SQLCommand To Run:

SELECT RedirectURL,PassThru,FolderPath FROM dbo.FolderRedirect WHERE FolderPath = @BadVDName and Campus=@Campus and (ExpDate is null or ExpDate > CAST(FLOOR(CAST(GETDATE() as float)) as datetime))

@Campus:

Tampa

@BadVDName:

test-jessieg/ui-component-library

No Match

No real URL in DB.

DBWriteBadURL Function Call
Description: Writes valid 404 Errors to the URLNinja DB.

SQLCommand To Run:

INSERT INTO dbo.ErrorPageLog (BadAddr, ClientIP, EntryDateTime, Campus) VALUES (@BadAddr, @ClientIP, GETDATE(), @Campus)

@BadAddr:

https://devsite.usf.edu/test-jessieg/ui-component-library/images/seaglass-gradient.jpg

@ClientIP:

10.43.4.198

@Campus:

Tampa

Successfully Inserted URL into the ErrorPageLog DB

Status of 404 Write: Success

RedirectURLPath Call
Description: Determine if the Redirect URL is Null or has a real URL
Null URL

GoURL Call
Description: Redirects the end user to the URL provided.
Final redirect path: /system-error/error.aspx

Would have done:

Response.Status = 'File Not Found'
Response.AddHeader('Location', /system-error/error.aspx)
Response.Flush()

Function Returned - Real URL