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?

[John C]

When you open Heidi, you should see...




Everything that is populated should already be there. If not, what you see here are the default values for all of it. You then have to enter the password (where the red arrow is) and the default should be "eqemu".

You should then be able to hit "open" to access the DB. If not, it might be time to start looking at additional details such as, are you running on Windows or Linux? Did you change any setting during the install? Are you running the DB on the same box as you are running Heidi?

Fingers crossed.

[djeryv]

Source it the same...but first delete the lines that get rid of the nearby POK books.

[Element D]

I feel i'm missing something very easy here, but when i open Heidi with the shortcut on the desktop that was put there during installation, all the fields are empty including the session name. The only tab i have has is a start tab. New, import settings, cancel, and more are my only options.

Sorry I forgot to add I'm on windows 10, no changes other than the IP for the login server. Opening Heidi on same box as server install.

[John C]

Great. Hit NEW, give your session a name, and configure the rest just like is shown in the picture above. Hopefully then you should be able to OPEN it and see the DB.

[Element D]

That did it! Sorry if this is basic stuff, but it's all new to me.

I deleted the two lines for removing the pok books and when i hit F9 it says "unsafe queries found" "your query contains UPDATEs and/or DELETEs without a WHERE clause.". "please confirm that you know what you're doing" I think it's quite clear at this point I do not fully.

I've not made any other changes other than deleting those two lines.

[John C]

That warning is just telling you that there are not any restrictions on some of the queries to restrict which rows they will impact. It is just trying to make sure that you really want to update every record in the database. And that is exactly what you are trying to do, so just tell it to go ahead.

Making progress. You are almost there.

[Element D]

So it did come up with an error 1109 "unknown table 'npc_types' in information schema"

I decided to try clicking on the mysql that's on the left and hitting F9 again. Got the error again.

Do i need to click on the peq on the left and F9 again?

I appreciate your patients.

[djeryv]

Yes...you were in the wrong database when you ran that.

Also keep in mind that this is your initial server setup. So if you mess up the SQL stuff...you can wipe the peq database and resource it without losing anything. I am just mentioning this to put you at ease that you will not ruin anything you can't recover from.

[John C]

Yep. You want to select the PEQ database (which stands for Project EQ). See below.



You can actually see all the EQ related tables. And djeryv is right, you can always restore your database if you mess something up but I would recommend against repeatedly trying to run a failing script.

Let's use an example to illustrate the point. Assume that a script has 4 lines. The first line reduces all monster HPs by 25%. The second line inserts a new NPC. The third line adds an item - and has an error that causes it to fail.

You run the script the first time. Hit points are reduced to 75% of the original value. The NPC is added. And then you get an error on line 3. So you run it again, and the HPs are reduced by another 25%. They are now 56% of the original value instead of 75% as intended, and a second NPC is added, before you hit the same error again.

[djeryv]

To further add onto this, for anyone pursing using custom content some of us provide, I would suggest get a server up and running first. If you can login, make a character, and run around...great. Then shut down the emulator and backup the database. Then run the custom stuff you downloaded and make sure it works fine. If not, you can just wipe the database and restore your backup and try again...or throw out the custom content entirely.

[Bruser555]

Where are the installer files for this solo server package? Was looking to possibly help my SQL poor skills while making a solo server for me and a friend.

Do you have specific instructions from start to finish? Maybe I am missing the location...

Sounds like the type of start I need for a server.

[Element D]

Original post from djeryv has a Google drive Link in it. There is a readme.txt file in the zip file. If you can't figure it out from that (as I could not) pretty much every post from John C in this thread is gold.