Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2002, 04:32 AM
joecow
Fire Beetle
 
Join Date: Apr 2002
Posts: 7
Default can't think of title

looking for lists of which zones have spawns in which dbs, I've seen screenshots of popped Sleeper's and VP, but the ones I have gone to are empty...
Reply With Quote
  #2  
Old 05-02-2002, 05:37 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

For VP, sleepers and ToV use either Ariak's or mine. I know Drawde's does not have it, and I am not sure what is in any other DB's out there.
Reply With Quote
  #3  
Old 05-02-2002, 06:20 AM
joecow
Fire Beetle
 
Join Date: Apr 2002
Posts: 7
Default

ok, changed over to Ariak's db, but now I get 1017 errors, do I need to change any settings beyond telling db.ini which db to read from? (did the whole source db9.sql for my new eq db)

(edit) watching world.exe window, shows "Wrong name/pass: name='eqemu'
Reply With Quote
  #4  
Old 05-02-2002, 06:30 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

His database probably doesnt include the eqemu/eqemu local id/password.

Take a look at the original db.sql that came with the emulator, look at the db.sql file, find the account table, and go into mysql and copy the insert line in from the db.sql... insert into accounts (xxxxxx);
Reply With Quote
  #5  
Old 05-02-2002, 06:59 AM
joecow
Fire Beetle
 
Join Date: Apr 2002
Posts: 7
Default

*deer in headlights*

am I looking at the db.sql file through WinMySQLAdmin?

not sure what I am supposed to see there, or what I am going to use in place of xxxxx, or even how to insert it

I really don't want to be a nuisance about this, I just know nothing about SQL, and it was a big enough operation to finally get myself up and running with eqemu...
Reply With Quote
  #6  
Old 05-02-2002, 07:06 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Nope... Its a text file.. Open it with wordpad or something...

The 1st or 2nd table should be accounts.. Look at where it starts the inserts.. find the one with eqemu in it..

go to a dos prompt.. type c:/mysql/bin/mysql

then use eq;
then that insert line you find in the db.sql file.. it will insert eqemu into your database..
Reply With Quote
  #7  
Old 05-02-2002, 07:14 AM
joecow
Fire Beetle
 
Join Date: Apr 2002
Posts: 7
Default

no inserts under accounts, also did a search for eqemu, couldn't find that either

also found this thread:

http://forums.eqemu.net/showthread.p...;threadid=1361

where he states this db will not work with the latest version, so I guess I'm out of luck until a compatible one is available
Reply With Quote
  #8  
Old 05-02-2002, 07:24 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

Ariak's DB9.sql works with the current emu. That thread was talking about a previous DB release.

Open the db.sql that came with eqemu 3.1+ and search for the line with eqemu in it. Note where it is in the file, and copy and paste it into db9.sql Then resource db9.sql into your database.
Reply With Quote
  #9  
Old 05-02-2002, 08:50 AM
joecow
Fire Beetle
 
Join Date: Apr 2002
Posts: 7
Default

got it working =) thanks for the help guys
Reply With Quote
Reply


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 10:57 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