View Single Post
  #38  
Old 07-17-2009, 11:21 PM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

Quote:
Originally Posted by nosfentora View Post
Beh, don't know where it went, but i had just posted asking about how to add a ls to the db.

i'm assuming that everything is done by hand through sql?

what's the formula for the pass? straight sha1(pass) or sha1(loginpass), etc?
KLS had this in one of the SQL dont remember what one now but here it is
Code:
insert into tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) values('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');
after the last commit KLS made everything is working fine here, it compiles and works. I'm still having 1 issue if someone could shed some light on this I would really appreciate it. If I connect my server to the login anonymously I can log in and play, but when I fill in this "tblserveradminregistration" to match my eqemu_config.xml to get legend status it will not alllow my server to connect.
Reply With Quote