View Single Post
  #6  
Old 03-18-2002, 04:10 PM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

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% < faction_list.txt
%mysqlpath%\mysql -f %eqdb% < loot.txt
%mysqlpath%\mysql -f %eqdb% < merchantlist.txt
%mysqlpath%\mysql -f %eqdb% < npc_faction.txt
%mysqlpath%\mysql -f %eqdb% < npc_types.txt
%mysqlpath%\mysql -f %eqdb% < spawn2.txt
%mysqlpath%\mysql -f %eqdb% < spawnentry.txt
%mysqlpath%\mysql -f %eqdb% < spawngroup.txt
%mysqlpath%\mysql -f %eqdb% < zone_points.txt
goto exit


:help
cls
echo usage:
echo        import <database name> <mysql path>
echo.
echo  <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
Reply With Quote