ISO database with old splitpaw or old lavastorm mobs

[NostalgiaEQ]

Does anyone know of open source databases that have old splitpaw mobs or old lavastorm mobs in them? Or does anyone have a personal database save with any of these mobs in them that they would be willing to share? I plan to open the database with heidisql and extract the applicable rows into excel then reload my database and paste the excel rows into my database.

[GRUMPY]

Was that advice I gave you (on the other thread) about how to put gnolls back in the paw too much work ? By the time you posted
this, I had most of it done already on my server, so it goes quick. But I will understand if you're schedule is too busy to develop a
server. It's a lot of ongoing tedious work.

[Maze_EQ]

Was that advice I gave you (on the other thread) about how to put gnolls back in the paw too much work ? By the time you posted
this, I had most of it done already on my server, so it goes quick. But I will understand if you're schedule is too busy to develop a
server. It's a lot of ongoing tedious work.

Negative, it's really not that bad (I do have a database that pre-dates the elemental change and full CT.)

It's the "I'm entitled" trophy.

[GRUMPY]

Negative, it's really not that bad (I do have a database that pre-dates the elemental change and full CT.)

It's the "I'm entitled" trophy.

Does it have everything developed and done in it that Nostagia needs for his server ? I am sure he would appreciate it :)
I got my own project, plus continuing on Secrets work, so I'm swamped already.

[Maze_EQ]

It has everything he needs, but as I believe, if you hand somebody something without them at least making a conscious effort, you effectively cripple them.

[GRUMPY]

It has everything he needs, but as I believe, if you hand somebody something without them at least making a conscious effort, you effectively cripple them.

My mom stopped letting me crash at her place when I was 21. I get that now :)

[NostalgiaEQ]

Lots I could say but I wont; anyway these two things are pretty much the last things I need to complete my server. I do have a job and splitpaw may not be a huge deal but lavastorm is; especially when I have to work around using 1999 map files that don't have every npc model we are used to.

I figured I would ask, we are in an open source community after all which some seem to conveniently forget. We all just have to endlessly reinvent the wheel it seems.

[Maze_EQ]

Since everyone wants a classic server, yet noone wants to do the work.

Here you go.

Do not ask me any questions on how to make it compatible with newer databases, nor ask me for binaries.

https://www.dropbox.com/s/u2auv3j16rvm5sa/NLPreKunark.sql?dl=0

if anything is wrong, oh well. Should have classic paw, nektulos, lavastorm, and cazic thule.

[NostalgiaEQ]

Since everyone wants a classic server, yet noone wants to do the work.

Here you go.

Do not ask me any questions on how to make it compatible with newer databases, nor ask me for binaries.

https://www.dropbox.com/s/u2auv3j16rvm5sa/NLPreKunark.sql?dl=0

if anything is wrong, oh well. Should have classic paw, nektulos, lavastorm, and cazic thule.

Wow thank you! I didn't expect that. I won't forget it. I definitly know enough to get it to work I'll just copy the parts into excel, add the necessary columns then go in heidi and import it. It will be all nice and pretty in a database compatible with akkas pack when I'm done and I'll post my database for download.

[Uleat]

In the long term, it will behoove you to acquire at least some basic sql skills.

This import aside, a lot of work can be done with a minimal query.


For instance, you could use the information from the second script here: http://www.eqemulator.org/forums/showpost.php?p=253221&postcount=2
to build a query for importing from a database with different table/column schema.

[GRUMPY]

Do not ask me any questions on how to make it compatible with newer databases, nor ask me for binaries.

I poked into that just to get an idea of how old it is. I noticed the 'character_' table, haha
I have binaries that I used for a DB of that "Emu dev era", which used a seperate DB for LS.
I think the infamous "mini login" was common back then as well.

[GRUMPY]

Haha, got this up and running, created a halfling and starting zone was guild lobby.

[NostalgiaEQ]

Thanks Uleat, I'll take a look at that and I do plan on learning a lot more in all aspects of game design and I will definitely look into queries but for now heidisql has been powerful enough to do anything I have yet wanted.

Grumpy is what you're saying is that the only way this database will work "off the shelf" is to use old binaries? My database is akka pack so I plan on getting it into my database. Is there any other benefit to using old binaries?

[GRUMPY]

This older DB will not work with current binaries. There has been so many changes since then. For example,
simply copying lines/columns from the old db in npctypes table, there is about 83 values, where the modern
db has over 100. Could be a chore just simply doing it that way.

[NostalgiaEQ]

Before I went to work I started loading the DB and the akka intelligent installer said it would begin a conversion process! So I'll see what happens lol.

[Maze_EQ]

Akka conversion will fuck that DB hard.

Also Grumpy, you'll most likely end up with tons of crashes due to custom binaries.

I wouldn't recommend running that DB as a production server.

Pretty sure some rules are custom and some other things yadda yadda

[GRUMPY]

I just loaded it up for amusement. Love what you did with the place. The "whiskers" guard name in lobby, that's funny. haha

[Maze_EQ]

I just loaded it up for amusement. Love what you did with the place. The "whiskers" guard name in lobby, that's funny. haha

logon the new nagafen's lair.

Exact clone of the most recent DB/Source lol.

[GRUMPY]

Is the content on that one based off the DB you just posted ?

[Maze_EQ]

Nah completely new source and db

[NostalgiaEQ]

well I deleted my lavastorm mobs from spawn2 and threw yours in and they were all still off the map :/. I saw a cinder goblin among the mobs in the ether so that is at least a good sign lol. Are these just not for the old old 1999 lavastorm map? s3d.

[GRUMPY]

You also add them from npc_types and spawn_entries ?

[NostalgiaEQ]

You also add them from npc_types and spawn_entries ?

Nah but I just wanted to see if they were on the map which they weren't. Spawn2 placed the mobs off the map, I used goto to go to them and the locations were off the map.

I went in paw and it was very strange. Still water elementals but with dead gnolls standing up strewn throughout the place lol. For paw I did use the database's spawngroup and spawnentry.

[Maze_EQ]

Nah but I just wanted to see if they were on the map which they weren't. Spawn2 placed the mobs off the map, I used goto to go to them and the locations were off the map.

I went in paw and it was very strange. Still water elementals but with dead gnolls standing up strewn throughout the place lol. For paw I did use the database's spawngroup and spawnentry.


When I stand the actual server up, all of these zones are fine for me.

[Didymus]

What about the old peq databases like kunark or velious.
Could does not be updated?

[Kingly_Krab]

To answer your question, depending upon exactly how old the database is, you may be able to. Just make a copy or backup and try to see if the SVN updates will work and then use the built in database-updater in the executables.