How to get file id through fileficket in sql
http://dnndev.me/LinkClick.aspx?fileticket=EA6QHBAkI2I%3d&portalid=0
On the server, DNN calls UrlUtils.DecryptParameter, which calls PortalSecurity.Decrypt, which calls CryptographyProvider.DecryptParameter, ultimately using the DESCryptoServiceProvider (by default). SQL Server does provide cryptographic functions, so you can see whether it's possible to replicate that logic in the database. If it's possible to handle it on the web server, that's probably going to be quite a bit easier than doing it in SQL.
UrlUtils.DecryptParameter
PortalSecurity.Decrypt
CryptographyProvider.DecryptParameter
DESCryptoServiceProvider
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.