Bring up server....
 

FIRST - went to mysql and created a new database with db.sql. Called it eq52. (text flew by and It said it was done.

SECOND - Copied my spells_en.txt file from my Everquest folder and pasted it into the same folder as the world.exe and boot5zones.bat files were in.

THIRD - Changed the db.ini file to say this...

[Database]
host=localhost
user=(mysql username)
password=(mysql password)
database=eq52
compression=off

FOURTH - went to 192.168.1.1 in my web browser (I have a router) and I enabled DMZ routing.

FIFTH - went to LoginServer.ini file and put this in it...

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5999
worldname=(my server name)
worldaddress=(my external IP address)
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

SIXTH - clicked on world.exe and it told me this...

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[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..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: (my external IP address):9000
World server listening on: (my external IP address):9000

SEVENTH - I click on boot5zones.bat and it tells me this...


C:\Documents and Settings\Jacob\Desktop\EQEmu\5.2 server>REM: ****Read this firs
t!!!****

C:\Documents and Settings\Jacob\Desktop\EQEmu\5.2 server>REM: This file requires
your real IP in the place of "YourIP" when you are connecting

C:\Documents and Settings\Jacob\Desktop\EQEmu\5.2 server>REM: To the EQEmu Login
server.

C:\Documents and Settings\Jacob\Desktop\EQEmu\5.2 server>REM: When you are using
minilogin, Replace all IP Addresses to say 127.0.0.1

C:\Documents and Settings\Jacob\Desktop\EQEmu\5.2 server>REM: If you still get e
rrors try using localhost instead of 127.0.0.1

C:\Documents and Settings\Jacob\Desktop\EQEmu\5.2 server>REM:--------------Start
-----------------------
You did not copy the spells_en.txt from your everquest directory to this one. P
lease do so or zones will crash on startup.
Press any key to continue . . .

now something is not right here, can someone help me out here? please... :cry:

you also have to copy the file spells_us.txt into the same file as world.exe and boot5zones.

i had the same problem hope that helps

for the item error you need the latest item dump/

where can you get the item dump?

Here is where the item dump .sql.gz file is. Winzip should be able to unzip it in Windows.

heh sry to bother you again but where would i put the dumpeditems?

You source them into your database. Unzip them into your bin folder of mysql and source them in.

Thanks much =) really appreciated