Sunday, March 31, 2019

Development Plan and Classic TAK database digested for you

So I'm going to teach you here how I went about doing this last time and what I plan to do this time.  I am MarcusD from Eqemulator (also NostalgiaEQ who was banned).  You can look at my old posts especially around when AdrianD (Similar name but we are not the same person) was on the forums.  Basically what I learned from him before he presumably quit was that you need to learn HeidiSQL.  So I did that.  I searched around for good starting material.  A unnamed past dev for EQEmu contacted me and helped me find lots of old databases.  It seemed to me like the best one to use was TAK projects database release.

FYI: in the database tab above in the TAK zip file there is the TAK database and digested version...I'll explain using that below.

Anyway the problem is if you run TAK database in current EQEmu server (the installer or whatever) the server doesn't work.  So you have to basically modify the tables to fit with current EQEmu code.  The way I do that is have all the TAK data in excel files then load up a fresh PEQ database (the one that comes with the installer).  Next I insert my excel data into that new database and make sure it continues working.  Last time when I uploaded the TAK items table, the items stopped showing up in the game.  So there must be an issue with the table format that I need to fix.  So anyway that is my same plan this time around.  I will now take the excel files in the database tab above, and try to get them inside the current PEQ database.

How you get the database into excel is (after running the server installer) you install and open heidisql then enter password: eqemu.  First you want to save the database that came with the installer so skip to the the * part below, then continue. Then you see peq on the left hand side.  Expand it and click on one of the tables.  Now on the right side of the screen you go to "data" tab.  now go to tools->export grid rows.  Hit ok.  Then go to excel and hit paste.  You now have exported your database table to excel and you can work with this and import parts or all of it into another database.

When you have all the data you need, you right click the peq table on the left side of the screen and click drop.  Close heidisql and reopen it.  Now right click in the empty spot in the left side of the screen below where peq used to be.  Create a new database.  If you can't then click the "unnamed" thing at the top of the area first.  Name the new database peq.  now click the cylinder so it has a green check.  Now go to file and load sql file.  You can load the tak database or NEQ or whatever.  After a while it will finish.  Now if you click the down arrow to the left of peq, you will see a bunch of tables.  If you don't then close and restart heidisql.  Now if you click a table on the left side of the screen under peq, on the right side of the screen click the data tab.  This is where everything important is.  You can import excel files to this data.  you may want to delete the current data, then click the little paper button with the green plus sign, it is down and right from the help menu on the top of the screen.  This is how you get data from excel to your database.

*Anyway now you know how to work with heidi sql.  You also want to save your progress often by going to the peq and right clicking it and clicking export database as sql.  The settings you should use are as follows:
Database: create
Tables: create
Data: insert
max insert size: 9,999,999
output: single sql file
then choose a location and name.

So basically I am currently using TAK data to start with a classic database.  Then I will go into the server and use gm commands like #npcspawn delete and such to remove spawns and there are also gm commands here: http://wiki.eqemulator.org/p?Command_Reference_N0ctrnl
to change the pathing and stuff like that.  Then I will go around and make sure everything is working.  Are the npc stores looking ok?  Are mobs dropping correct loot?  Are there npcs from expansions higher than what I want? etc.  Also doing research making sure spells are right etc.  So anyway that process will take a couple months before beta.  Beta will not be perfect and will be where you can help me find stuff that wasn't in the release version of EQ.  So for a timeline, it will take me lets say 1 month to get all the TAK tables integrated in a working way into a current PEQ database so everything is compatible.  Then it will take me 2 months to tidy things up best I can in game.  Then it will take me another month to finalize the client.  For the client I also want to look into using aspects of the TAK client, not sure how titanium compatible it is.  But I will also pull original files from my 989 copy of EQ.  So we are about 4 months out and lets expect beta by the end of July.

The TAK tables aren't perfect as I have said before.  Firstly the items table will take some major tweaking to get it compatible with current eqemulator.  Many of the other tables also will take some decent work to get them functioning.  Secondly the zone points are bad and the rule values are bad.  The zone points and rule values I will pull from my old NEQ release as I did a lot of work on those before.  I will try to set most of the rulevals back to default unless a changed value is required for classic eq.  I will set expansions to 0 but this can be reverted by you easily.

Anyway there is an update and check the database tab at the top of the screen for the digested TAK database tables!

Friday, March 22, 2019

Development restarted! Join our Discord.

We are at it again! This project is now officially a project of Hack Our World 501c3 Nonprofit! Hack Our World is devoted to non-profit game production and publishing focusing on Persistant Open World games.

Join our discord, link is on the right side bar.

NostalgiaEQ is back and is slated for an Open Beta July 2019.  Progress is going well as is compatibility of the Database with current eqemulator server installer and code.  We are using the same client that is posted in the above but the database will be releasing as NEQ200xx so keep an eye out for that and it will be first poated when the Beta launches.

Looking forward to continuing this journey together! FYI this server will be pre-expansion, version "1.1" Vanilla EQ.  Yes that means no Temple of Solsek Ro!