View Single Post
  #16  
Old 12-13-2013, 09:19 PM
khalathas
Sarnak
 
Join Date: Jun 2007
Posts: 67
Default

when you add a user to the tblloginServerAccounts table, you have to use a query because you can't just add a plaintext password, you have to set password = sha('password') to encrypt it.

Try this:
use peqlogindb;
INSERT INTO tblloginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress)
VALUES('acctname', sha('password'), 'email@domain.com', now(), '192.168.1.2');

LastIPAddress and LastLoginDate don't really matter, they get updated when they log in anyway.
Reply With Quote