PDA

View Full Version : Help with Vale's server setup tutorial? Pleasie? :)


drewh313
06-18-2010, 06:58 PM
So I'm just getting into EQemu after years away from the game. I started using Vale's tutorial to set up a little server to play around on alone,

http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ

but I seem to be stuck on step 10 and 11.... While the language of the rest of the tutorial was pretty clear, this business with HeidiSQL frightens and confuses me.

"10) Here's an SQL file to make accounts. Make sure your PEQLoginDB is selected, and import this query.
You can save this as an .sql file, or copy/paste it in the Query window in HeidiSQL and import it.

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');"

I can set up the "EQEmuLoginServerDBInstall.sql" in HeidiSQL just fine. I can even paste the line into a new query tab next to the "EQEmuLoginServerDBInstall.sql" in HeidiSQL, but there is no option to "import" the query.

The next step (11) is the same story.

Does he mean to simply alter the necessary line within the first HeidiSQL query (EQEmuLoginServerDBInstall.sql)?

I have searched the forums and tried to read up on this program. It seems other people have had trouble on the same steps.

I'm sure it's something very simple.

Thanks! Forgive me for a flagrant computer illiteracy.

:)

pfyon
06-18-2010, 07:35 PM
That query can be executed as is (or once you've modified the entry to suit you) from the gui or command line. I think importing just refers to sourcing a .sql file.