Go Back   EQEmulator Home > EQEmulator Forums > General > General::General Discussion

General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-21-2017, 03:38 AM
NostalgiaEQ
Banned
 
Join Date: Sep 2016
Location: us
Posts: 201
Default ISO database with old splitpaw or old lavastorm mobs

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.
Reply With Quote
  #2  
Old 03-21-2017, 12:18 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

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.
Reply With Quote
  #3  
Old 03-21-2017, 12:20 PM
Maze_EQ
Demi-God
 
Join Date: Mar 2012
Posts: 1,106
Default

Quote:
Originally Posted by GRUMPY View Post
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.
__________________
"No, thanks, man. I don't want you fucking up my life, too."

Skype:
Comerian1
Reply With Quote
  #4  
Old 03-21-2017, 12:30 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Quote:
Originally Posted by Maze_EQ View Post
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.
Reply With Quote
  #5  
Old 03-21-2017, 12:54 PM
Maze_EQ
Demi-God
 
Join Date: Mar 2012
Posts: 1,106
Default

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.
__________________
"No, thanks, man. I don't want you fucking up my life, too."

Skype:
Comerian1
Reply With Quote
  #6  
Old 03-21-2017, 01:31 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Quote:
Originally Posted by Maze_EQ View Post
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
Reply With Quote
  #7  
Old 03-21-2017, 02:45 PM
NostalgiaEQ
Banned
 
Join Date: Sep 2016
Location: us
Posts: 201
Default

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.
Reply With Quote
  #8  
Old 03-21-2017, 03:18 PM
Maze_EQ
Demi-God
 
Join Date: Mar 2012
Posts: 1,106
Default

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/u2auv3j16r...unark.sql?dl=0

if anything is wrong, oh well. Should have classic paw, nektulos, lavastorm, and cazic thule.
__________________
"No, thanks, man. I don't want you fucking up my life, too."

Skype:
Comerian1
Reply With Quote
  #9  
Old 03-21-2017, 03:45 PM
NostalgiaEQ
Banned
 
Join Date: Sep 2016
Location: us
Posts: 201
Default

Quote:
Originally Posted by Maze_EQ View Post
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/u2auv3j16r...unark.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.
Reply With Quote
  #10  
Old 03-21-2017, 04:08 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

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/sho...21&postcount=2
to build a query for importing from a database with different table/column schema.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #11  
Old 03-21-2017, 06:00 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Quote:
Originally Posted by Maze_EQ View Post
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.
Reply With Quote
  #12  
Old 03-21-2017, 06:20 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

Haha, got this up and running, created a halfling and starting zone was guild lobby.
Reply With Quote
  #13  
Old 03-21-2017, 08:19 PM
NostalgiaEQ
Banned
 
Join Date: Sep 2016
Location: us
Posts: 201
Default

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?
Reply With Quote
  #14  
Old 03-21-2017, 08:31 PM
GRUMPY
Discordant
 
Join Date: Oct 2016
Posts: 445
Default

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.
Reply With Quote
  #15  
Old 03-22-2017, 10:07 AM
NostalgiaEQ
Banned
 
Join Date: Sep 2016
Location: us
Posts: 201
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:55 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3