#41 Database Improvements
Hi,
I've just downloaded and install phphelpdesk and think
it is really good. I have spotted a few minor
improvements that you could make though.
1. The passwords are currently unencrypted in the
database. While the database itself should be secure,
it may well be a prudent step to store the passwords
as MD5 hashes. It is then easy to compare any
passords that are entered in a login box by MD5ing the
entered password and comparing it to the MD5 hash in
the database.
2. The other security features that are stored in the
security table could all be entered in one field using
binary logic. ie have one field with a value such as
1110010010011, you can then use bitwise operators to
distinguish what security level/features a user has,
this will then allow the database to run more
efficiently.
3. The date and times have been entered in the
standard MySQL DateTime method. This is good but the
way i prefer to use is to have the date and time field
set up as a varchar of 10 width and store the
timestamp and a PHP/Unix timestamp. You can then use
the PHP Date fucnction to output dates and times in a
nicer looking format. Asthetics i know, but those big
dates and times are always needed.
Logged In: NO
How do you co about setting up the md5 hash for the
passwords?