Project LID Homepage: Distributable Modules
lccROAR Homepage

Update 1/20/2021: Bug fix: IP and IP Wildcard based filtering issue when using both fixed.

Update 10/1/2020: Upgrade: Added new flag to 'lcc:portalSetLoginColumnFlag' for 'ValidateAgainstQuery'. Added Portal Set Id section at the bottom of portals.

Update 9/1/2020: Upgrade: added more detail on debug statement for debug level #6.

Update 8/26/2020: Upgrade: changed style on 'Welcome' bar to blue-ish. Upgraded data return for key "lcc:portalSetReturnDataFileDisplayColumnAsList" to remove duplicates (i.e. if returning email addresses, only return one for each).

Update 8/12/2020: Fix: changed Debug Flag '14' to output SQL, was outputting under '15' (mySQL).

Update 7/15/2020: Upgrade: Added new flag to 'lcc:portalSetLoginColumnFlag' for 'MultiLine', 'MultiLineRows', 'MultiFilters'. New key 'lcc:maxFilterSize', new flags to 'lcc:portalSetFlag' for 'APIResponseFormat', 'APIDownloadOption'.

Update 7/14/2020: Upgrade: Added new flag to 'lcc:portalSetLoginColumnFlag' for 'SuggestedValues' and option ctcLinkTerm.

Update 7/9/2020: Upgrade: Added key 'lcc:portalSetReturnDataFileDisplayColumnAsList'.

Update 7/6/2020: Upgrade: Added key 'lcc:LDAPSecurityGroupsMustMatchAll'.

Update 4/9/2020: Upgrade: Added option on lcc:SQLSetQuery for loading from file, see "FromFile:".

Update 11/15/2018: Upgrade: SQL injection attack preventive measures expanded.

Update 11/9/2018: Upgrade: updated program on reading system environment variables differntly in support of use on Apache.

Update 9/27/2018: Upgrade: auto mark filters as wildcard.

Update 9/11/2018: Upgrade: added flag to ‘lcc:portalSetFlag’ for ‘MaxRecordsCeiling’, note about lccUserCol# in key ‘lcc:SQLSetQuery’.

Update 8/29/2018: Upgrade: added more flags to 'lcc:portalSetFlag' for 'PortalThreshold'.

Update 8/7/2018: Upgrade: added keys 'lcc:portalPageTopper', 'lcc:portalPageTailer','lcc:portalSetLoginGlobalColumn'.

Update 8/6/2018: Changed: changed key 'PrependRecordNumber' to return the Record # of matched records, not record # in all records. Upgrade: now displays how many records displayed out of how many matched at the end of the records. If the amount displayed is less than found, will provide link to Show All Matches.

Update 7/18/2018: Upgrade: modified 'max records' logic to compare to 'matched' records, not all read. Added flag 'authorizedIPWildcardLeft'.

Update 6/1/2018: Upgrade: added support for special characters in LDAP values, i.e. passwords/etc.

Update 5/22/2018: Upgrade: added more flags to 'lcc:portalSetFlag' for 'ResponseModeAuthorized', 'APIResponseFormat'.

Update 5/14/2018: Upgrade: added key "lcc:adminIP', flag 'authorizedIP'.

Update 2/27/2018: Upgrade: added keys 'lcc:portalSetWebResourceBrowsingDataType', 'lcc:portalSetWebResourceBrowsingIncludeFilename', 'WebResourceBrowsingDirectoryReverseOrderOnCookieTrail', 'WebResourceBrowsingFileReverseOrderOnCookieTrail' and Flag 'WebResourceBrowsingDataType'. Added wildcard values.

Update 3/27/2018: Upgrade: added more flags to 'lcc:portalSetReturnDataFileDisplayColumnFlag' for decimals

Update 1/11/2018: added resources to PDF to accessibility standards.

Update 12/6/2017: Upgrade: Convert/added keys to 'flags', like lcc:portalSetFlag.

Update 12/1/2017: Upgrade: updated CSS file.

Update 11/30/2017: Upgrade: added key 'lcc:portalSetAndOr', mySQL Sets.

Update 11/17/2017: Upgrade: added LDAP, Back End Requests/Responses and Admin Decryption modules.

Update 10/17/2017: Upgrade: added key 'lcc:portalSetCSS'

Update 9/21/2017: Code Released


Created to ask for information (like credentials, or other), verify that information against one to many validation lists, then return records from one to many return lists.

The program has the following capabilities:

Screenshots Documents Application Files
The programs, scripts and documentation are provided AS IS without warranty of any kind. Lower Columbia College further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the programs, scripts and documentation remains with you. In no event shall Lower Columbia College, its authors, or anyone else involved in the creation, production, or delivery of the programs, scripts or documentation be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the programs, scripts or documentation, even if Lower Columbia College has been advised of the possibility of such damages.