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:
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!


  1. Few people know this site simply best rated online casinos and I know it will not deceive you for sure. Withdraw money whenever you want, play different gambling and slots Cool site and beautiful design.

    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  2. Flutter Programming is one of the most popular in the cross platforms industry. We build excellent flutter mobile app and also learn how to overcome performance issues. Hire Flutter Developer
    is the best choice for all startups to discuss and get their project quotation. We also enable many startups to do Proof of concept and help them to learn about business decisions.

  3. Flutter Programming is one of the most popular in the cross platforms industry. We build excellent flutter mobile app and also learn how to overcome performance issues. Offshore Flutter Development Service
    is the best choice for all startups to discuss and get their project quotation. We also enable many startups to do Proof of concept and help them to learn about business decisions.

  4. Crossplatform app development is challenging nowadays. many tools like a flutter and react-native are doing work really awesome. App development in Austin in cross-platform also have challenges like performance and network issue.

  5. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. Kopar at Newton at Newton Hawker Centre

  6. Those who are keen to make a great career as software programmers are definite to find Python live up to their expectations. unindent does not match any outer indentation level python

  7. You understand your projects stand out of the crowd. There is something unique about them. It seems to me all of them are brilliant. nemzetközi áruszállítás Europa-Road Kft.