Compiled source and combined database

[blastoma]

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

________________________________________________


All EQEMu files and programs have been taken down. Thanks for all your support. Hope to rejoin everyone sometime in the future. Peace out... :D


________________________________________________

Hey all,

In an effort to help ease the pain of newcomers I decided to host the latest compiled source code and sql for quick and easy installations. I compile the latest cvs releases and update them as nessicary. I also combined the MW_057DR2_alpha_1 database release with the many small updates and Govtcheese's faction updates. The setup program is ment for new users who would like a windows for to easily modify the ini/bat files. It still requires alot more work but hopefully it will become a tool for quick, easy, self-installing eqemu's. For install steps read the README.txt. If you have a problem leave me a private message. Visit eqemu.chiroplus.ca (http://eqemu.chiroplus.ca/) for a listing of eqemu files.

Latest cvs release:

(07-31-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-07-31-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-31-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-31-04-PERL.zip) (1080 k).
Download the server setup program: EQEMu-Setup-06-21-04.zip (http://eqemu.chiroplus.ca/EQEMu-Setup-06-21-04.zip) (68 k).
Download the combined sql: EQEMu-SQL-06-26-04.zip (http://eqemu.chiroplus.ca/EQEMu-SQL-06-26-04.zip) (4751 k).

Previous cvs releases:

(07-25-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-07-25-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-25-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-25-04-PERL.zip) (1080 k).
(07-17-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-07-17-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-17-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-17-04-PERL.zip) (1080 k).
(07-10-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-07-10-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-10-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-10-04-PERL.zip) (1080 k).
(07-03-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-07-03-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-03-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-07-03-04-PERL.zip) (1080 k).
(06-26-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-06-26-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-06-26-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-06-26-04-PERL.zip) (1080 k).
(06-21-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-06-21-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-06-21-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-06-21-04-PERL.zip) (1080 k).
(06-16-04) Source (http://eqemu.chiroplus.ca/EQEMu-Source-06-16-04.zip) (754 k), Compiled (http://eqemu.chiroplus.ca/EQEMu-Compiled-06-16-04.zip) (1070 k), Compiled with PERL enabled (http://eqemu.chiroplus.ca/EQEMu-Compiled-06-16-04-PERL.zip) (1080 k).

***USE AT YOUR OWN RISK***
***ALWAYS CHECK THE EQEMULATOR.NET FORUM FOR ANSWERS BEFORE YOU POST***

[jorikinn]

Thanks for those packages, blastoma.
I installed all on my EQEmu server, and they work fine.

When you install the PERL enabled server (which is needed to run the quests i think), you need also to download ActivePerl from http://www.perl.com

The server is a 0.5.7-DR6.
The databases package sources fine, without beeps. I installed the databases with:
c:\mysql\bin\mysql -u username -p
drop database eq;
create database eq;
use eq;
source EQEMu-SQL-06-16-04.sql;
INSERT INTO account (id, name, charname, packencrypt, sharedplat, password, status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '', '', 0, 'eqemu', 250, NULL, 0, 0);
quit

(I needed the "insert into" stuff because I am running this as a local server with minilogin).

The mob logic and population seems to be not quite ready yet:
- No mobs in uqua, inktuta (probably no mobs in other high end GoD zones either).
- The factions seems to be a bit too "unkos". Freeport guards, western wastes dragons and other mobs, seems to be all indiff or dubious. The only KoS mobs I found was VP dragons. I was a DE Wiz with SolRo faction myself.
- Mobs seem to have a bit too little HP, I could nuke WW and old world dragons to 20% with one single SoS (2740 hit).

Anyone got more eqlive style faction databases?

[blastoma]

Things should shape up to be more eq-live like once the next db is released. (www.ProjectEQ.net)

As for the faction I noticed that too, I used v0.4 faction from govtcheese. I havent looked at it but its possible it could not have sourced right on my end, Ill check and update it.

Also, soon to be released, installer/walkthrough program to get your ini and .bat files setup correctly. From me, compiling code and editing ini files and db's and stuff is easy as pie. But for new people that come around just to play around by themselves or with some friends... they dont want to sit there and figure out every little setting. (Although they should imo :))

So I look forward to finishing it up, maybe be up before the end of the day.

[blastoma]

Added server setup program.

Targeted at new users who wish to use a windows form to quickly and easily setup the ini/bat files. Also, it can copy your spells .txt files from your everquest directory for you if your too lazy. :)

Ultimatly I hope to develop a program in which will help new and expirenced eqemu users to quickly and easily setup/update a server.

If you have a problem just leave me a private message.

[molimo140]

Using the compiled World.exe that you have it is refusing to connect to the login server, it just stops after

World server listening on: localhost:9000

Any ideas on how to remedy?

[blastoma]

Are you using the minilogin.exe? If so, then this setup doesnt really support that ..... yet. :)

If your trying to setup a server to work thru the eqemu login servers then your going to need to change that localhost to your real ip address.

So grab your ip and re-run the program. Fill everything out like you did before. Once your at the "EQEMu Server" section, where it says "Server IP", enter your real IP. Not 127.0.01 or localhost.

[devn00b]

Blastoma, while im no longer a developer here, I will tell you this.

By you releasing the binary's YOU get to answer ANY/ALL support questions related to them. EQEMu devs/helpers offer no help in binaries passed arround by other people. And is generaly NOT a good idea to run any binary not given out by a developer.

All n00b questions To Blastoma please.

[blastoma]

Yeah I'm aware of that. I dont mind at all.

[blastoma]

Updated with latest 06-21-04 cvs release.

Also fixed perl plugin in 06-16-04 release.

[Virus11]

You can find the guide to install PERL onto your server at:
http://www.eqemulator.net/forums/viewtopic.php?t=12020

[Merq]

Is it me or are the links not working?

[Merq]

:D

[Tangeleno]

They work for me.

[blastoma]

I am nearly completed an all-inclusive installer for eqemu. By the time I'm done it should automatically download and install perl, Mysql 4.0.20, compiled eqemu, eqemu sql database, and run you through a series of steps to setup your server. Also, I hope to complete a patcher for un-edited cvs releases sometime in the future.

Keep your eye on this thread for updates. (will also put it in 3rd party tools when done)

[Merq]

Make it have options to install perl and mysql... in case you already have it. :)

[blastoma]

I have mysql ready, but not perl (which is just as easy).

I figured some people may not want to download the full 20mb for mysql so I skimmed it down to a very basic package. Just enough to run eqemu.

The setup program will still be a little rough but I hope to include as many options as possible without sacrificing simplicity.

Setup might be available before the night is out. :)

[blastoma]

New server setup program available Here (http://www.chiroplus.ca/EQEMu-Setup-06-21-04.zip) (68 k).

Features:

*Automatically downloads/extracts latest precompiled EQEMu release.
*Automatically downloads/installs latest precombined SQL Database release.
*Automatically downloads/installs MySQL 4.0.20a (minimal).
*Assists in ini/bat setup for your server.

Note: Only tested in Windows XP Pro. If you encounter any problems please let me know with a private message.

***USE AT YOUR OWN RISK***
***ALWAYS CHECK THE EQEMULATOR.NET FORUM FOR ANSWERS BEFORE YOU POST***

[blastoma]

Updated with latest (06-26-04) cvs release.
Updated SQL database with 'unknown008=1'. (right click items should work again)

[Spunge16]

how do you actually use that programme? i downloaded and clicked it , and it wouldnt load

[blastoma]

Need an active connection to the internet for sure. And .net framework 1.0 at least. The setup program is very rough. I have a much better and smoother program in the works but will take awhile to finish up.

If the setup doesnt work for you then I suggest that you download a compiled source and run through the setup steps in the readme. With all the documentation found on these forums it isnt that hard to do.

If your getting an error message of some sort then send me a private message of the error your getting.

[blastoma]

Updated with 07-03-04 cvs release.

[Spunge16]

Had used your previous version and it worked a treat :) Lets hope this goes nice and simple for me :p

[blastoma]

Any problems make sure you leave a message. Thanks! :D

[Spunge16]

does this newest upgrade have the latest loots? My current db doesnt have a lot of the high end god armour

[blastoma]

No, this is the basic MW_057DR2_alpha_1 database that only has items up to planes of power. You will either need to get an item dump sql file and update your items in the mysql database OR wait till another database is released. I believe www.projecteq.net is working on another release, keep an eye on their forum/website for any new releases. Naturally, if a new database is released I will have a copy here ready for you to download once it becomes available.

[blastoma]

I know alot of people here have tried the eqemu setup program. If anyone has any suggestions on what they would like to see included/changed in it then please let me know. I have a new version that I am working on that will include detailed help on setting up your server, as well as setup for your in-game gm command levels.

Feel free to post suggestions here or just leave me a private message. Thanks!

[runn1n0n3mpty]

the links wont work for me

[blastoma]

Make sure that if your copying the shortcut and paste it into another browser that you preserve the character casing. The server is sometimes case sensetive. The links work so its something on your end. :)

[runn1n0n3mpty]

http://www.chiroplus.ca/EQEMu-Compiled-07-03-04.zip i copy that link and put it in my web adress and it comes up with cannot find server

[Spunge16]

works fine for me :)

[runn1n0n3mpty]

does anyone know why the links do not work for me..? can someone send me the compiled 7-3 version to rac3r101@sbcglobal.net

[vapidead]

geeez...thanks for the time you've put into this blastoma. makes me wish i had something to contribute as well...just wanted to say it certainly doesn't go unappreciated...

[blastoma]

Glad to help in any way I can. If there is anything I can do to help anyone dont hesitate to ask.

Im looking to further eqemu by providing an administrative interface. Some goals I hope to achieve is running commands from outside of your server, managing accounts, server options, seeing statistics about your server, etc. I have heard some talk about this and am not sure if anyone is currently working on a project like this. In any event, once completed I hope it will prove to be a valuable resource to new and experienced eqemu admins.

As usual, keep your eye here for updates. :!:

[x-scythe]

blastoma: i believe the program you are referring to is called EQAdmin :P

[blastoma]

I am familiar with EQAdmin. A great program but I wanted more functionality. Windcatcher did a fantastic job with EQAdmin. But my approach is actually a little bit different.

[blastoma]

Updated with latest cvs source downloads.
Updated with 07-10-04 cvs release.

Enjoy!

[blastoma]

Added eqemu.chiroplus.ca (http://eqemu.chiroplus.ca) to mirror cvs releases and to keep a list of compiled eqemu releases, sql files, and misc programs. Any problems just leave me a private message. Thanks! :D

[Kode Black]

I think theres something wrong with the faction in your combined DB, Qeynos guards give no hits when they are killed.

[blastoma]

Ok, I will take a look and see whats going on there.

[blastoma]

Updated with 07-17-04 cvs release.

[blastoma]

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

[blastoma]

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

[Bladees1739]

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:

[blastoma]

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

[runn3r12]

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 thisERROR 1054: Unknown column 'unknown122' in 'field list'can you help me..?

[runn3r12]

nvm dude i got it your the best =)

[sotonin]

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.

[lord_aiden]

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:

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

[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

[killspree]

Are you using an EQLive patched client?

[lord_aiden]

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.

[lord_aiden]

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:

[gottasummer]

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)

[aridale]

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?

[monalin crusader]

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.

[blastoma]

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! :)

[blastoma]

*** Updated with 7/31/04 release

[aridale]

Tyvm =D

[monalin crusader]

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

[blastoma]

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

[blastoma]

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

[blastoma]

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.