CMS Made Simple Forums

Hi,

I have two questions which will help me better understand and selectively clear my adminlog via phpMyAdmin.

1. What format is the timestamp column in cms_adminlog? With examples like '111477407' this is clearly doing my head in.

2. I have several entries with a user_id of 0 and no username associated. And the same username also has entries with different user_id values.

Are user_id and username usually tied to a unique id and the user login name? What's the relationship here?

1. They're Unix timestamps.  # of seconds after Jan 1, 1970.  Unfortunatly, you have to do a little math, but there are functions built into mysql to do that.

2. This looks like it might be a bit buggy.  You might want to ignore some of the stuff in there. 

1. 86400 seconds in one day...I feel a song coming on. I only ask becaue this table has the potential to get HUGE if left unchecked.

2. It's nice to know I'm not the only one who can make mistakes.