i still don't know anything woo woo woo la la la

[stuartcow]

ok, i followed the guide step by step and got my server working. i can log into eq and look at all the eq servers, my server is on there but locked. I can still log into my server and create a character but when i try to log in with a character it says zone not available...

now i am really scared to post. but i have spent hours (no joke) of just searching through the forums, dumping databases, creating databases, downloading sql files, playing with openzone, sourcing .sql files... but alas... nothing!

if anyone could tell me (or whip up a (or redirect me) to a guide on) what to do right after the server setup guide ends that would be great!

i just felt like the guide kinda left me hanging (no offence, it was an awesome, easy to follow guide). I need to know how to add zones, and that is pretty much it... i have downloaded all the EQEMu Database Releases but i can't find anywhere that says how to use them and such.

I'm retarded

Originally Posted by mattmeck

Post copys of EVERYTHING world, zones, anything that you had to edit, also include the output of world and zones when you run them, you didnt give us enough info to even begin to help you.

If you cant log on there is an issue somewhere so adding more the the 5 zones wont help, lets fix the issue befor you move onto other things.

[toolh3]

Did you run Boot5zones.bat?

ok, i followed the guide step by step and got my server working.

If he followed the guidee he did

4. Start up Boot5zones.bat, this will start 5 zone servers in 5 different windows

[stuartcow]

well, here is what my stuff looks like

db.ini

# READ README.TXT!

[Database]
host=localhost
user=test
password=**** (it says my password, i just censored it)
database=eq
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

loginserver.ini

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Bailcrap Testy (Non-Legit)
worldaddress=24.175.75.83
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

boot5zones.bat

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone.exe . 24.175.75.83 7995 192.168.1.2
start zone.exe . 24.175.75.83 7996 192.168.1.2
start zone.exe . 24.175.75.83 7997 192.168.1.2
start zone.exe . 24.175.75.83 7998 192.168.1.2
start zone.exe . 24.175.75.83 7999 192.168.1.2
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

i have downloaded the MyraDB.sql and MyraItems.sql. from what i understand this contains all kinda zones and good stuff but i don't know how to add them...

like i said... i'm retarded

still didnt post the output of world and zones when you run them

4. Now you need to source in your SQL files into your database, So move db.sql from the EQEmu folder to mysql\bin

5. Type in:
use eq;
source db.sql;

source blabla ......blabla = filename

[stuartcow]

oh and my world.exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2
' in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking linux compiles....
TCP listening on: 24.175.75.83:9000
World server listening on: 24.175.75.83:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

and i did do the boot5zones.bat all of them say

[Status] CURRENT_WORLD_VERSION: EQEMu 0.5.3-DR3
[Status] Loading variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded

[toolh3]

You need to source your database, like mattmeck said.

Error] DBLoadItems query 'SELECT ...ect ect

DB error we know that cause you dont have one sourced in

[quote][Status] CURRENT_WORLD_VERSION: EQEMu 0.5.3-DR3 
[Status] Loading variables 
[Status] Loading zone names 
[Status] Loading items 
[Status] EMuShareMem loaded[/quote]

hhmm there should be a LOT more there, a lot more.

[stuartcow]

ok guys, things are starting to fall together, thanks a bunch... the only think i really wanna know now is how to add the MyraDB.sql and MyraItems.sql and get them working.

p.s. the pc speaker beeping is driving me crazy... gotta unplug it.. can't take much more... aaaaaaggggghhhhhhh

Quote:

4. Now you need to source in your SQL files into your database, So move db.sql from the EQEmu folder to mysql\bin

5. Type in:
use eq;
source db.sql;


source blabla ......blabla = filename

if you have a lot of beeping then you have already sourced in another DB.

[stuartcow]

so what you are saying is that i should do that but replace the db.sql with the Myradb.sql and MyraItems.sql? just sorce them both like that and i'm done? i figured i would have to mess with the boot5zones.exe or something

[toolh3]

Copy MyraDB.sql and MyraItems.sql to your mysql\bin directory. Then run mysql. When you get the mysql> prompt type:

use eq; <hit enter>
source MyraDB.sql; <hit enter and wait until you get the prompt again.>
source MyraItems.sql <hit enter and wait again>
exit <hit enter>

Now your DB should be populated.

[stuartcow]

and do i need to change to boot5zones.bat at all?

[toolh3]

and do i need to change to boot5zones.bat at all?

No, that has nothing to do with updating your database.