labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
f_CWAESDecrypt
Parameters
Name
Type
Mode
encryptLevel
int
IN
decryptString
varbinary(255)
IN
Definition
BEGIN DECLARE serverId VARCHAR(255); DECLARE decryptedOutput VARCHAR(255); IF decryptString IS NULL OR decryptString ='' THEN RETURN ''; END IF; SELECT `config`.`serverId` FROM `config` INTO serverId; SET decryptedOutput = AES_DECRYPT(decryptString, serverId); IF decryptedOutput IS NULL THEN RETURN ''; END IF; RETURN decryptedOutput; END