Updated Solo Server Package

[John C]

ElementD -
Just open the SQL file in any text editor. Select All and Copy the full text. Then open HeidiSQL, which gets loaded with the game. You will have to enter the password to connect to the database. The default is "eqemu" and hit (open). Once you are in the database, you'll see a little button in the upper middle that has a blue triangle and says "query". Click there to bring up the query window. Paste the SQL command text that you copied from his script and hit F9 to execute it.

In the bottom window you'll see it run through all of the commands. Assuming it all works and you get no errors, you're done. Just exit out (and you don't have to save the script within Heidi).

Good Luck!

[djeryv]

I just updated this and added a new NPC called the Artisan of Norrath. They are in all of the cities and they have the same items that Brother Dremel has...except he accepts payment for the items. Like the sage, you can search for an item he carries and he will show you what he has and the price. He sells about 2,800 different crafting items that are hard to get on a solo server.

[Element D]

John C -

Thanks for the help, but I'm unfortunately still a little confused. The install did place a HeidiSQL shortcut on my desktop, but when run it doesn't show any database and the open command is grey.

djeryv -

Thank you so much for the work on this solo package! I noticed the update and the new sql, does that also get sourced in the same way John C is explaining?

edit - also forgot to ask. If i leave step 2 out am i still able to use the plane of knowledge from any book location?