something i made

[Memener]

i got something that might help someone please i got my sever working by typing all of those commands i took and made it easyer for those people that dont know anything about mysql
also this is my frist program it is also a .BAT file

[Memener]

just tested it... it dose not work if someone can tell me why it dosent work please let me know

it gets to the part to run msql.exe it loads up and then it just sits there i dont know why lol

[Mauritius]

ok

the problem is msql doesn't accept a set of dos batch commands :lol:

my suggestion is:
1. cut out from databasehelp.bat and paste the following txt in a new file (I called mine dbupgrade.txt)
DROP DATABASE EQ;
create database eq;
use eq;
source db.sql;
source books.sql;
source class_skill.sql;
source doors.sql;
source InitialEquipment.sql;
source items.sql;
source newitems.sql;
Source npc_spells.sql;
source npcupdate.sql;
source resource.sql;
source spawns.sql;
source tradeskillupgrade.sql;
source weather.sql;
source zonepoints.sql;
source zpoints-3-4-2003.sql;
insert into account set name="eqemu", password="eqemu", status="200";

2. then refer to the new file (dbupgrade.txt) in databasehelp.batusing adding the following command where you call msql.exe:
mysql.exe < dbupgrade.txt
or
msql.exe -f < dbupgrade.txt

The -f flag is used to continue the batch input even if we get an sql error (although we shouldn't have sql errors) :?
----

Your databasehelp.bat should look like this:
@ECHO OFF
ECHO - THIS BAT FILES WAS MADE UP Memener(Memenerr or Nu in EQemu)
ECHO - PLEASE DO NOT EDIT THIS FILE DOING SO MY MESS UP YOUR COMPUTER
ECHO - EQEMU is a trademark of The EQEMu Team
ECHO - Everquest is a registered trademark of EVERQUEST, Inc
ECHO - Memener, Memenerr are is registered to David Jacobs
ECHO - Unauthorized redistribution is forbidden.
PAUSE
CLS
ECHO THIS PROGRAM IS MENT TO WORK WITH THE EQEmu-0.4.4-DR1+Telmet-DB-Test.zip AND THE EQEmu-0.4.4-DR1+Telmet-Win32.zip FILES!
ECHO - This program will try to fix the database make sure this file is in you MySql\bin folder befor you start also this program will show you what is it about to do
CHOICE /N /C:12 WHAT DO YOU WANT TO DO? 1=FIX 2=EXIT %1
IF ERRORLEVEL ==2 GOTO ONE
IF ERRORLEVEL ==1 GOTO TWO
:TWO
ECHO YOU PICKED FIX
CLS
ECHO GETTING READY TO SET UP
PAUSE
CLS
ECHO PLEASE MAKE SURE YOU PUT THE FILE IN YOUR MYSQL\BIN FOLDER!
@ECHO ON
<---
@ECHO OFF
ECHO THIS SHOULD SAY MYSQL\BIN!
CHOICE /N /C:12 DOSE IT SAY MSQL\BIN? 1=YES 2=NO %1
IF ERRORLEVEL ==2 GOTO NOPE
IF ERRORLEVEL ==1 GOTO YEP
:YEP
ECHO IS THERE A STOPLIGHT NEXT TO THE CLOCK?
CHOICE /N /C:12 1=YES 2=NO %1
IF ERRORLEVEL ==2 GOTO NO1
IF ERRORLEVEL ==1 GOTO YES1
:YES1
GOTO NEXT1
:NO1
WINMYSQLADMIN.EXE
ECHO PLEASE WAIT TELL YOU SEE A STOPLIGHT NEXT TO THE CLOCK
PAUSE
GOTO NEXT1
:NEXT1
CLS
ECHO THIS RECREATE YOUR EQ DATABASE AND CREATE THE EQEMU LOGIN ACCOUNT !
PAUSE
MYSQL.EXE < DBUPGRADE.TXT

PAUSE
CLS
ECHO IF YOU DIDNT GET ANY ERRORS YOUR DONE! WTG ENJOY
ECHO IF YOU GOT ERRORS AND DONT KNOW WHY EMAIL ME AT EQEMU_DATABASE@HOTMAIL.COM
PAUSE
EXIT
:ONE
CLS
ECHO YOU PICKED EXIT!
EXIT
:NOPE
ECHO YOU DIDNT PUT THIS FILE IN THE RIGHT SPOT TRY AGAIN!
EXIT

----

your dbupgrade.txt should look like this:
DROP DATABASE EQ;
create database eq;
use eq;
source db.sql;
source books.sql;
source class_skill.sql;
source doors.sql;
source InitialEquipment.sql;
source items.sql;
source newitems.sql;
Source npc_spells.sql;
source npcupdate.sql;
source resource.sql;
source spawns.sql;
source tradeskillupgrade.sql;
source weather.sql;
source zonepoints.sql;
source zpoints-3-4-2003.sql;
insert into account set name="eqemu", password="eqemu", status="200";

TROUBLESHOOTING:
:arrow: If you get "ERROR 1008 at line 1", it's because your mysql don't have a eq database to drop.
:arrow: If you get "ERROR 1007 at line 2", it'S because your mysql did not drop the eq database, and can't recreate it.