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 :roll:

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

[mattmeck]

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

:D

[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 :shock:

[mattmeck]

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.

[mattmeck]

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 :x

[mattmeck]

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.

[mattmeck]

check PM stuartcow

[stuartcow]

i know, but in order to load the zones, wouldn't you have to change the boot5zones.bat to add something like;

start zone.exe . 24.175.75.83 ZONE ID 192.168.1.2

[mattmeck]

No


start zone.exe . 24.175.75.83 7995 192.168.1.2
start zone.exe . 24.175.75.83 7996 192.168.1.2

Will run ANY 2 zones 1 or the one your in one for whatever zone your going into

start zone.exe Halas 24.175.75.83 7997 192.168.1.2

would keep halas up 100% of the time.

[mattmeck]

as a better explination as I understand it



start zone.exe . 24.175.75.83 7995 192.168.1.2

In this example the "." is a wile card...you type #zone halas from NK.

you have a zone up for NK (your in it) when you type #zone halas world looks for a zone that is aval to boot up "." will allow that zone to become any zone thats needed.

start zone.exe Halas 24.175.75.83 7997 192.168.1.2

Will keep halas up even if there isnt anyone in the zone, BUT it wont allow this zone to become any other zone.

[mattmeck]

another thing you may want to know

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

to add more zones

see the #'s in between your IP adresses?

7995
7996
7997
7998
7999


to get more then 5 zones running keep upping that # by 1 so the next zone would be
start zone.exe . 24.175.75.83 8000 192.168.1.2

[stuartcow]

ok, thank you guys sooo much!!!! :P

i totaly understand it (for now)!!!

the only thing i have left to do now is to finish sourcing the other .sql files and i should be all good!

:P THANK YOU SOOO MUCH!!!!! :P

[Sk8ordiek2k1]

A quick question about the zones, when you move from NK to Halas, will the zone that was previously NK become a wild card again or will it stay as NK? I ask because it seems that if it stayed as NK it would mean that after 5 zones are booted by clients, (say, Gfaydark, Nexus, Arena, Halas, and Nk) that anyone trying to log into (or zone into) and other zone would have problems.

also is it possible to run 1 static zone and 4 variable zones? Say i wanted to have the Arena stay open all the times and leave 4 variable zones.

and my boot5zones would look like this...
start zone 77 MyIpAdress 7995 MyIpAddress
start zone . MyIpAddress 7996 MyIpAddress
start zone . MyIpAddress 7997 MyIpAddress
start zone . MyIpAddress 7998 MyIpAddress
start zone . MyIpAddress 7999 MyIpAddress

is that doable?

[Tertiary]

A quick question about the zones, when you move from NK to Halas, will the zone that was previously NK become a wild card again or will it stay as NK? I ask because it seems that if it stayed as NK it would mean that after 5 zones are booted by clients, (say, Gfaydark, Nexus, Arena, Halas, and Nk) that anyone trying to log into (or zone into) and other zone would have problems.

also is it possible to run 1 static zone and 4 variable zones? Say i wanted to have the Arena stay open all the times and leave 4 variable zones.

and my boot5zones would look like this...
start zone 77 MyIpAdress 7995 MyIpAddress
start zone . MyIpAddress 7996 MyIpAddress
start zone . MyIpAddress 7997 MyIpAddress
start zone . MyIpAddress 7998 MyIpAddress
start zone . MyIpAddress 7999 MyIpAddress

is that doable?

Yes, after about 30 secs to a minute with no players in it, a dynamic zone will shut down and will be available to boot up any new zone. Static zones are started up with a zone shortname, so, assuming the shortname for the arena is 'arena', your boot5zones would be:

start zone arena MyIpAdress 7995 MyIpAddress
start zone . MyIpAddress 7996 MyIpAddress
start zone . MyIpAddress 7997 MyIpAddress
start zone . MyIpAddress 7998 MyIpAddress
start zone . MyIpAddress 7999 MyIpAddress

[wize_one]

when the zone is empty it resets and waits for a new zone to be loaded.

you can run as many static as your system will hold. start with 7995 and go up one port per. i have 5 static and 5 avil atm.