EQEmulator Forums - Compiled source and combined database

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=616)

- - Compiled source and combined database (https://www.eqemulator.org/forums/showthread.php?t=14430)

Updated with 07-25-04 cvs release. :D

Updated with 07-31-04 cvs release. :P

Any idea of a new database or an updated one been tring to find one and tring to do the collector. Great job on everything Blastoma. The setup program works great. I have a thought on the commands. What if the commands had a window in the game rather then typing in the help and it spamming u out. Like take the help out and put in the help for eqemu. Just a thought. :idea:

I havent got around to updating the items yet. But its pretty straight forward. Get the newitemsdump.sql file from Http://www.peqserver.com and source that into your database. Then rename the table Items_New (?) to Items. Something like that... I think someone had posted that update and how to do it but I dont have the link on hand. But if you know anything about mysql then it shouldnt be a problem.

As for your "#help" request... I figure you can probably make your own xml ui with all the commands in it. Shouldnt be very hard at all. I cant commit myself to any other projects at the moment but when I get some time freed up I'll make an effort to make something to help out with the commands. But really, take a few minutes and read thru them... you'll memorize them in no time. :D

hey blast..love your compiling=) keep up the work..hey when i source in allitems.sql from peqserver.com or whatever it comes up with this

Code:

ERROR 1054: Unknown column 'unknown122' in 'field list'

can you help me..?

nvm dude i got it your the best =)

The allitems.sql from peqserver.com is both new and old item dumps merged into 1.

you have to delete your items table completely and let it build it with the correct structure.

Hi there, I want to say, great job with what you've done so far.

I have an issues with the Perl-enabled compliations. Previously, I had used your non-perl enabled compilations, and got them to work with little problem. I've decided to try the perl-enabled ones to learn how to quest scripts.

I've installed PERL with no problems. I can get the World and Zone servers up with no problems. However when I try to connect with a character that I've made or just created, I get a message about "The server is not responding" and "You have been disconnected."

I've enclosed the logs for the World and Zone files that was utilized

WORLD:

Code:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6

[Status] Loading variables..

[Status] Loading zones..

[Status] Loading items..

[Status] EMuShareMem loaded

[Status] Loading items from database: count=28731, max id=69304

[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

Abort/retry/cancel?

TCP listening on: 66.188.135.171 :9000

World server listening on: 66.188.135.171 :9000

Connected to LoginServer: eqemulator.net:5995

14906 New TCP connection: 127.0.0.1:3184

New zoneserver: #1 127.0.0.1:3184

Zoneserver SetConnectInfo: 127.0.0.1:3184: YourIP:7998

15109 New TCP connection: 127.0.0.1:3185

15109 New TCP connection: 127.0.0.1:3186

15109 New TCP connection: 127.0.0.1:3187

15109 New TCP connection: 127.0.0.1:3188

New zoneserver: #2 127.0.0.1:3188

New zoneserver: #3 127.0.0.1:3187

New zoneserver: #4 127.0.0.1:3186

New zoneserver: #5 127.0.0.1:3185

Zoneserver SetConnectInfo: 127.0.0.1:3185: YourIP:7999

Zoneserver SetConnectInfo: 127.0.0.1:3186: YourIP:7997

Zoneserver SetConnectInfo: 127.0.0.1:3187: YourIP:7995

Zoneserver SetConnectInfo: 127.0.0.1:3188: YourIP:7996

50890 New client from ip: 66.188.135.171 port: 3193

Account Attempting to be created:lord_aiden 0

Logged in: FirstLogin LS#13221: lord_aiden

Received unknown opcode: 0x02eb size:0 bytes

Name approval request for:Aiden race:5 class:3

Character creation request from lord_aiden LS#13221 (66.188.135.171:3193) :

Name: Aiden

Race: 5  Class: 3  Gender: 0  Deity: 215  Start zone: 10

STR  STA  AGI  DEX  WIS  INT  CHA    Total

 85   70   85   70  100   92   90     592

Face: 30  Eye colors: 7 7

Hairstyle: 0  Haircolor: 255

Beard: 255  Beardcolor: 11

Validating char creation info...

Found 0 errors in character creation request

[Status] Found starting location in start_zones

Current location: felwithea  8.00, -317.00, 9.00

Bind location: felwithea  8.00, -317.00, 9.00

Character creation successful: Aiden

Attempting autobootup of felwithea (61) for Aiden

Zoneserver SetZone: YourIP:7999 felwithea (61)

Enter world: Aiden: felwithea (61)

Zoneserver SetZone: YourIP:7999 felwithea (61)

Client disconnected

Removing client from ip:66.188.135.171 port:3193

Zoneserver SetZone: YourIP:7999  (0)

Zoneserver SetZone: YourIP:7999  (0)

ZONE:

Code:



[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR6

[Status] Loading Variables

[Status] Loading zone names

[Status] Loading items

[Status] EMuShareMem loaded

[Status] Loading npcs

[Status] Loading npc faction lists

[Status] Loading NPC Faction Lists from database...

[Status] Loading loot tables

[Status] Loading Loot tables from database...

[Status] Loading doors

[Status] Loading Doors from database...

[Status] Loading guilds

[Status] Loading factions

[Status] Loading corpse timers

[Status] Loading what ever is left

[Status] Loading commands

[Status] 168 commands loaded

[Status] Loading embedded perl

[Status] Loading perlemb plugins.

[Status] Warning - plugin.pl: Perl runtime error: open 'plugin.pl' No such file

or directory at (eval 3) line 1.



[Status] Entering sleep mode

Connected to worldserver: localhost:9000

[Status] Weather should change in 13264 seconds

Init: Loading zone lists, zone state or spawn list, player corpses

Zonepoints loaded into memory

, timezone data - Done. ZoneID = 61; Time Offset = 0

Reading zhdr file './cfg/felwithea.cfg'

Using database for safe coords.

Zone safe coords are x = 94; y = -25; z= 3.75

[Status] Loading Objects from DB...

[Status] Loading Ground Spawns from DB...

[Status] Loading doors for felwithea ...

[Status] Done loading doors for felwithea ...

[Status] Zone Bootup: felwithea (61)

[Status] Zone Shutdown: felwithea (61)

Thanks in advance

Are you using an EQLive patched client?

Quote:

Originally Posted by killspree

Are you using an EQLive patched client?

It was patched to live, but I've worked around that and have been able to connect to other servers, and my server before I switched to Blastoma's Perl-enabled compilations.

Ok I resolved the issue on my own. I had replaced my current copy of the boot5zone.bat with an older one, and it wasn't connecting to the zone servers properly.

::smacks self:: :oops:

very odd.. boot5zones is just a batch file... it shouldnt involve that file... glad to hear you got everything to work. Now, you can help others that need help now that you got yours working 8)

I see the newest version here is 7/25/04 do you think itd be possible to get a dr6 version from 7/31/04 or later with perl enabled?

Quote:

very odd.. boot5zones is just a batch file... it shouldnt involve that file...

Actualy its got everything to do with that file just because its a batch file means absolutely nothing even it if was a txt file it would still be significant. Its the file that starts all of the zone.exe files and if you dont put in the right IP, which he didnt, then its not gona find the world server and thus it will never connect. If it does not connect then you cant login you can get on the character selection screen because until that point its all in world.exe and as long as your loginserver.ini is set up like it should be then you can see it on the server selection screen. Anyways nuff of that all i'm saying is that just because a file is a certian type doesnt mean it is worthless. If you know what a batch file is it takes cmd commands and runs them so its basicaly like starting a program, yes you can go withought it but if your using it and the contents of it are messed up then it wont work.

My apolagies, I forgot to update the main post on the thread with the 31st release. But you can still get it from eqemu.chiroplus.ca

I'll update it a little later. Thanks! :)

*** Updated with 7/31/04 release

Shoudlnt this be moved to like General Support or something its not really about development anymore.

Hey everyone.

First off I'd like to thank EVERYONE for the great comments and support I've been given. Im glad I was able to help so many get started in EQEMu. Hopefully it will continue progressing as well as it has and so far it really looks great.

It seems that the devs have so kindly precompiled the latest code releases thru sourceforge. Therefore it doesnt make much sense to keep all the old versions up on my server. In a couple days Im going to remove all of them, if you still need them feel free to pm me and I can hook you up.

The setup program is not really nessicary considering that all the help you ever need is in the tutorial/support forums. I know alot of people really liked it but due to a couple small changes in EQEMu it... no.... longer.... writes the files correctly. *cough* I really should have written that program better, anyhow, sorry 'bout that.

After I finish up with some other projects I hope to come back to a bigger and better EQEMu which I can dedicate some of my skill to.

Bye for now, be back soon!~ :P

All sql and eqemu files taken down. Thanks again for all the support! 8)

Back again, I've recieved alot of great comments and requests so I've decided to use the very small amount of spare time to once again help out the newcomers to EQEMu. I have a new website that I will host everything on. Source, Compiled code, sql, and some new tools for eqemu will be available soon. Thanks once again.

Website: Http://www.lotsoflobster.com/eqemu

***As usual Ill notify everyone on updates here as well.