db.sql and drwade's

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