ok looking at Kavren's thread here:
http://www.eqemulator.org/forums/showthread.php?t=31783
And Huppy's thread here:
http://www.eqemulator.org/forums/showthread.php?t=32980
I'm trying to piece together the info I need.
When I get down to where I'm trying to setup the database and login info (looking at Kavren's post where he says "Setup PEQLoginDB DB and Logins") I start to get a little confused.
This is what he says:
Quote:
Setup PEQLoginDB DB and Logins
• Open Navicat lite
• double click on local
• right click on local and create a new database
• name it PEQLoginDB
• Now open a command prompt and go to the below folder
• (C:\EQEmuSVNFiles\EQEmu\trunk\EQEmuServer\EQEmuLog inServer\login_util)
• run this command:
• mysql -uUSERNAME -pPASSWORD PEQLoginDB < EQEmuLoginServerDBInstall.sql
• Here's an SQL statement to make accounts. Save the below statement as accounts.sql onto your server’s desktop.
• INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');
• Edit the above statement as follows:
• After “VALUES”, edit 'Admin' and 'password' to what you would like the login information to be. Edit 127.0.0.1 to the i.p. address of the client machine you will be logging in from.
• For security purposes, you can delete the Admin account that's entered by default in tlbloginserveraccounts by left-clicking on it so it's yellow, and then pressing CTRL+DEL.
• On to Setting up the world server. Here's the sql statement to make the world server entry. Save the below statement as worldreg.sql onto your servers desktop.
• INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'NameOfServer', 'ServerTagDescription', 'ShortNameOfServer', '2', NULL, NULL, '1', NULL);
• Edit the above statement as follows:
• After VALUES, edit the following:
• NameOfServer is the actual name of the server.
• ShortNameOfServer is the shortname for client files in your game directory (i.e. UI_Soandso_ShortNameOfServer.ini).
• ServerTagDescription is what you will see in parenthesis after the server's name - i.e. NameOfServer(Come and have fun!)
• The number 2 signifies what kind of server it is. 1 = Legends, 2 = Preferred, 3 = Standard.
• In navicat, right click the PEQLoginDB DB and select “Execute SQL File…” and choose accounts.sql from your desktop. Do the same again but choosing worldreg.sql from your desktop.
|
Now, I'm sure I'm missing something here. Where he says "Here's an SQL statement to make accounts. Save the below statement as accounts.sql onto your server’s desktop." How? How do I make an SQL statement?
on the next line he mentions tblLoginServerAccounts which I don't see anywhere.
Also farther down the list he mentions "INSERT INTO `tblworldserverregistration`"
I also noticed, Uleat, where you mention in your post here:
http://www.eqemulator.org/forums/showthread.php?t=35222 that in your database under PEQ I should have a heading called tblserveradminregistration. Same thing here, and I'm sure you are both talking about the same thing. For some reason, I don't see that under my PEQ database. Is it something I need to add? and if so, how? You mentioned this a few posts back but I didn't quite understand. Do I need the tblserveradminregistration or no?
I apologize for being so dense. I'm really trying to understand these steps but am having difficulty.
I'm thinking maybe this is where my issues are coming into play as there are discrepancies between Huppy's post and Kavren's. I'm sure both posts are excellent sources of information, but I must be overlooking something obvious. Usually that's my problem.
Hybrid Mode
