db.sql and drwade's

malnutrition · #1 03-18-2002, 10:16 AM

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 · #2 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 · #3 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 · #4 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 · #5 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 · #6 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 · #7 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 · #8 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 · #9 03-19-2002, 08:11 AM

Quote:

Originally Posted by malnutrition

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?

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 · #10 03-19-2002, 08:33 AM

!!!
OMG WHERE CAN I GET IT?

Please

h37lion · #11 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 · #12 03-19-2002, 08:02 PM

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

irageon · #13 12-02-2002, 01:37 PM

Quote:

Originally Posted by h37lion

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.

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 ??