EQEmulator Forums - db.sql and drwade's

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - db.sql and drwade's (https://www.eqemulator.org/forums/showthread.php?t=791)

malnutrition

03-18-2002 10:16 AM

db.sql and drwade's

Is there a reason noone has posted a db.sql that's already got drawde's info cut and pasted in already for the noob's? Can this be posted in the Files section? I have a copy that I'd be happy to send or host somewhere?

PaulieWalnutz

03-18-2002 11:49 AM

the reason is..

is because it's so easy to copy the info from drwades DB to the bd.sql

all you have to do it Open mysql.exe type use eq and then source the text files over.

source faction_list.txt

ect....

h37lion

03-18-2002 12:14 PM

That is exactly how I imported the lists, and it worked fine. It was also a lot quicker than option # 1 (which is to cut/paste by hand the info tables in notepad..bah)

maybe for some people, a readme on the subject may help... heh

TheClaus

03-18-2002 12:24 PM

Actually the real reason is that Drawde's DB addon pack has all orginal verant content which is something that the devs of the board do not want. It would give verant something to say if they wanted to fight the emu. Paulie is right though. Just source the db then source the addons.

Lurker_005

03-18-2002 03:07 PM

Perhaps Drwade can include something like this in his next release

Code:

mysql -f &lt; npc_types.txt

mysql -f &lt; merchants.txt

... 

cls

@echo off

echo Clean up imported files? (delete them)

Choice [y,n]

if errorcode goto

I forget all the file names but you get the idea. Name it import.bat and add instructions to copy the files to the mysql\bin dir and run the bat file. I am not sure if it would be better to use the -f option or not...

I'll try an post a working batch file up later.

anyhow my 2cp

Lurker_005

03-18-2002 04:10 PM

Here is a pretty functional install batch file for drwade's data, reasonable easy to edit if anything changes too.

Drwade, feel free to include this in your next release if you want, or anyone for that matter.

Code:

@echo off

IF "%1"=="" goto help

IF "%1"=="/?" goto help

IF "%1"=="-h" goto help

IF "%1"=="--help" goto help

set eqdb=%1





IF "%2"=="" goto defaultdir

set mysqlpath=%2

goto importdb



:defaultdir

set mysqlpath=c:\mysql\bin



:importdb

IF not exist %mysqlpath%\mysql.exe goto help

%mysqlpath%\mysql -f %eqdb% &lt; faction_list.txt

%mysqlpath%\mysql -f %eqdb% &lt; loot.txt

%mysqlpath%\mysql -f %eqdb% &lt; merchantlist.txt

%mysqlpath%\mysql -f %eqdb% &lt; npc_faction.txt

%mysqlpath%\mysql -f %eqdb% &lt; npc_types.txt

%mysqlpath%\mysql -f %eqdb% &lt; spawn2.txt

%mysqlpath%\mysql -f %eqdb% &lt; spawnentry.txt

%mysqlpath%\mysql -f %eqdb% &lt; spawngroup.txt

%mysqlpath%\mysql -f %eqdb% &lt; zone_points.txt

goto exit





:help

cls

echo usage:

echo        import &lt;database name> &lt;mysql path>

echo.

echo  &lt;mysql path> Path to mysql.exe

echo        may be ommited if it is c:\mysql\bin

echo.

echo  Example: import eq25 c:\mysql\bin

echo.

echo  or

echo        import /? for this help



:exit

Drawde

03-18-2002 11:08 PM

My world data doesn't include any "original Verant content", the NPC data is derived from ShowEQ data but has been extensively modified and added to, the only "Verant content" is the names of the NPCs, and I don't believe any of those are copyrighted.
If someone wants to make a compiled DB with my addons available on their FTP server or similar that's fine by me.

TheClaus

03-19-2002 02:34 AM

Any proper name is orginal content. I think you would be safe with skellies, gnolls, goblins, etc... but any proper name is something they thought up and could be fought if they wanted to. That is my take on it. I could be wrong though.

mythren

03-19-2002 08:11 AM

Re: db.sql and drwade's

Quote:

Originally Posted by malnutrition

Mal, could you (or anyone else) send that DB to: mythren@magiclink.com ?

Everyone has said how easy it is just to copy/paste it, but I can't find it in the first place :).

Thanks!

Ariak

03-19-2002 08:33 AM

!!!
OMG WHERE CAN I GET IT?

Please

h37lion

03-19-2002 08:01 PM

honestly, it takes no time to do yourself..

take all the .txt files drwade was cool enough to offer.. then put them in your mysql/bin directory

open mysql.exe

for example, if you have a faction_lists.txt file, to import it to the db, you type at the mysql prompt

mysql\ source faction_lists.txt

then it should run through it's thing. Just do this for each list. This is how I did it, and it worked perfectly.

Shawn319

03-19-2002 08:02 PM

txt files source fine just as .sql's do.

irageon

12-02-2002 01:37 PM

Quote:

Originally Posted by h37lion

not work for me :-(( ...... my history :
When I first time install EQemu , I install DB addon and world data fine....

but now after 3 days when I completely reinstall Eqemu + mysql..
I can't install DB addon to sql :((
I use install.bat or manually update but result is same..
books.sql - imported fine
doors.sql - fine
items.sql - fine
spawns.sql - problems :( I get MANY errors
like error.. syntax..] blabla..line xy ...
and I have 0 spawns/ncp type/entry in my db and only few starting items.. for class shopkeeper..

Where is problem ? I using commands from install.bat
(mysql.exe use eq; source nameoffile.sql; )
or I must type now
-f eq < nameoffile.sql ??

All times are GMT -4. The time now is 03:58 PM.