encrypted fields in db

PieterK · **encrypted fields in db -** 05-09-2008, 03:10 PM

There are some encrypted fields in the kayako db in mysql.. like the "dateline" field on the "swauditlogs" table.. also "contents" field on the swchatdata table.. how do I get to this data to write some reports?

**Jamie Edwards** · 05-09-2008, 03:14 PM

Hi Pieter,

The "dateline" isn't encrypted; it is the time in seconds since the epoch. Date/Epoch Time Converter - JavaScript Utilities/Tools - ESQSoft

The data in swchatdata is indeed base64 encrypted. To decrypt it, take a look at PHP's PHP: base64_decode - Manual function.

PieterK · 08-09-2008, 08:51 AM

thanks for the info Jamie

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to set up custom fields that are not viewable by users but editable by staff?	adamv	How do I?	4	17-07-2008 02:56 PM
Custom registration fields do not display	russmichaels	SupportSuite, eSupport and LiveResponse	6	12-10-2007 02:07 PM
Custom fields prior to starting chat session needed badly!!!!!	Doug I.	LiveResponse Desktop Application	3	25-05-2007 02:21 PM

PieterK Offline New Member Posts: 15 Join Date: Jul 2008	encrypted fields in db - 05-09-2008, 03:10 PM There are some encrypted fields in the kayako db in mysql.. like the "dateline" field on the "swauditlogs" table.. also "contents" field on the swchatdata table.. how do I get to this data to write some reports?

PieterK Offline New Member Posts: 15 Join Date: Jul 2008	08-09-2008, 08:51 AM thanks for the info Jamie