EQEMU -Codename Apophis-
 

hehe... wonder how many will open this JUST for the title...

ok check it out I had a LOT of trouble setting up the Server Emulator, I had even more trouble getting a DB that had something worth working with ( I dont know about the rest of you, but the 74 tables that come in the PEQ distro dont seem to work with Cavedude's 3.52 pack at all) then I saw that if you add the items from 13th floor it makes tha game SO MUCH better... and I decided to see what would happen if I took the trouble to merge CaveDude's stock DB with the PEQ DB, then add Azodia's and JustPEQ3's mix em all together always adding the larger tables and changing columns/row where necessary.

the result is what I am calling Apophis (ok so my server name is apophis and I like the name (mytholgoical Dark Dragon God of the Egyptians) In any case, this is a fully functional 0.7.845 Windows Server release, if you download the server package and the Database included in the following links and you follow the README files included in the RAR's there is absolutely NO reason this set shouldnt work on your computer

I have already tested it on Windows Server 2003 (both the original release and Service Pack 1) and tried it on several low end machines:

233mhz IBMServer 256mb EDO/ECC ram
400mhz Celeron 256mb pc100ram
450mhz P-II 384Mb Pc133 ram
225mhz Cyrix pc100 ram
1.4ghz Celeron pc133 ram

all systems functioned smooth as a babys ass.

if you have any questions at all feel free to message me


http://x3-systems.com/EQ/EQEmu_ApophisEdition.rar
http://x3-systems.com/EQ/eq_db_apophis.rar

I have been having tons of problems getting an emulator to work. I have been searching the forums, and am now gunshy to ask a question due to the flaming that has happened to some people.

I will try your download and see what happens. A scripted install would be nice, but that would be easy. Or I guess people would thank that would be lazy, not all people are technical.

you don't want to make it too easy other wise there'd be ./configure in the compile :D

Probably, if you included a note with your post that you did look for your answer first - then people won't be so hard on you.
Alot of people really don't even try and search first.

I'll have a look through this and see how it plays.

GeorgeS

Ok to make it .840 compat, here's the sql you need

ALL SQL to get from 0.7.0 to 0.7.0.840

[code]
ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT
NULL DEFAULT '0';
alter table account DROP packencrypt;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;
ALTER TABLE `npc_types` CHANGE `hp_regen_rate` `hp_regen_rate` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `npc_types` CHANGE `mana_regen_rate` `mana_regen_rate` INT( 11 ) NOT NULL DEFAULT '0';
UPDATE `npc_types` SET `hp_regen_rate` = '0' WHERE `hp_regen_rate` = '-1';
UPDATE `npc_types` SET `mana_regen_rate` = '0' WHERE `mana_regen_rate` = '-1';
ALTER TABLE `npc_types` CHANGE `hp_regen_rate` `hp_regen_rate` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `npc_types` CHANGE `mana_regen_rate` `mana_regen_rate` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `account` ADD `rulesflag` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `npc_types` DROP walkspeed;
ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
CREATE TABLE rule_sets (ruleset_id TINYINT UNSIGNED NOT NULL auto_increment, name VARCHAR(255) NOT NULL, PRIMARY KEY(ruleset_id));
INSERT INTO rule_sets VALUES(0, "default");
UPDATE rule_sets SET ruleset_id=0;
CREATE TABLE rule_values (ruleset_id TINYINT UNSIGNED NOT NULL, rule_name VARCHAR(64) NOT NULL, rule_value VARCHAR(10) NOT NULL, INDEX(ruleset_id), PRIMARY KEY(ruleset_id,rule_name));

actually you dont need this one scripted... just open the archives and plop em into your drives of choice, they are pre-packed and ready to rock

oh.. I should probably add that I use this server configuration to play the game in 6.2 mode... I wont go into detail as to WHY I have to run it in 6.2 instead of Titanium (as I would get burned by someone for sure) but thats the deal.. I cant say if it works with titanium, but I cant see why it wouldnt.

on a side note, I downloaded Angelox's DB and did a fresh install of 854 and his system works like a dream (aside from small discrepancies which I have already noted to angelox)

as for getting flamed for asking questions, send me a private message I would be glad to work things through with you.. pity you'd have to private message me for the answers but there ARE those around here that feel it is thier sworn duty to chastise those who wish to get advice.

I disagree. First off, the "flaming" you see here is like an afternoon at church compared to other places I visit. Consider this a nice community. Secondly, people are inherently lazy and do no searching, and post immediately when they have a question, THEN go searching in hopes that some good samaritan will answer and save them the trouble.

You want advice? This forum is over-loaded. Yes, it takes some time to get used to finding stuff... and the acronyms people use render the search function useless (grin). But I think mostly, people are fair and helpful when questers can articulate their needs coherently.

(btw, this was not a flame)

I would agree on a part to that.. there ARE helpful people but the flaming is ignorant.. if the complaint is that people are wasting server space by asking questions that are already answered elsewhere in the forum, then it is equally ignorant to post a flame and waste more space when you can just ignore the post entirely.

if the flaming is just to be cynical then those responsible for flaming well deserve those of us who complain about it.

really there is no reasonable answer, there might be an underlying reason, but as they say two wrongs dont make a right.

As long as well all agree that you posting everywhere about flaming being wrong, and that you are in fact right, winds up canceling each other out.

Trying to get in touch with you Abaddon to ask you questions about your server pack.

Click his name and send him an email. Not sure how long til he reads this.

1 day 17 hours left on his one week ban.

I day 17 hours 1 second until he makes some reference to phantom flamers.

Ah - didn't realize he had been banned - that would explain why I can't send him PM's across the forums.

ok... it seems I am no longer banned... (and nope, times up on that 1 sec guess)

as for why I was, could care less... as for being unbanned.. same answer... as for if I get banned again... same again.

but you wont here me complain about things I disagree with anymore either as it obviously doesnt matter.

in other news, I found the most iteresting link concerning the patch.everquest.com URL, but I wonder if I should post it since it gives direct download ability on patches... would that be against TOS since it is literally AT the patch.everquest.com site? (full address withheld due to pending decision)

Just get SOE's ok to post it and use it, then you can post it here.

err how would I do that?

here... I'll send you the link info and then you can decide

if its a worthwhile posting link matt, it has updates for all the oldworld, plus planes of power, LoY and Luclin

really it's mostly just s3d files for the most part, but I dunno about you, but it solved issues in my LOGS about my files not being able to find things like grass.s3d and such

Sup, i have acouple questions about this EQEmu version and DB.

First, will this DB work with MySql? i noticed you mentioned windows server in the first post.

Second, Can i merge this DB with my current one? or will this make things go crazy?

Third, How can i transport my current account info to this new EMU?

This db works fine regarding gameplay and of course it works with mysql .

I would not attempt mergers - it's pretty complicated, and unless you understand the related table structs, you will bork up your db fast.

Next, to transfer account info - assuming the table's structs are the same, then copy the mysql tables to the destination db. Look at the mysql\data\ folders and you'll see what I mean. I routinely do this.

ok.. time for an update I think...

since we are now up to .866 I have made an 866 release, this release also feature considerably MORE quests, and and many of which have been corrected so that they actually work.

another important thing is that I systematically went through each and every zone drop in the SQL and corrected the placement so that you dont get caught in walls etc.

there is a lot of changes, use it and see what you think.

I should mention however, the new release is using MySQL 4.1.18

Download HERE

all future releases have are now being worked on in combination of Cavedude and Angelox, to find the MOST COMPREHENSIVE release using our combined force, check either the Sesmar site or Angelox's site.

the files listed in this thread are still on the server however for those who require them.

Just a request...

In the future - if possible - please release the files for a public server and not a mini login.

This database is working well with my eqemu ( EQEmu-0.7.0-845 Minilogin with MySQL 5.0.24 ). The only prob i got is the starting zone witch is bugged atm.
All char are starting in Qeynos ( not a really prob but if you wanna start a necro lizard ( wink ! ) ....
So if you have the SQL line to update the good starting places it will be cool.
This apophis look stable ( i have tried a magician in qeynos ). ).
Good job on it btw.


VC

Ok... I have had MULTIPLE upon MULTIPLE reports from the less than knowledgable that people just cannot figure out how to correctly setup MySQL to work with the server, or they can't source the files right, or this or that pertaining to MySQL.

so to solve a lot of headaches and/or explanations I have decided to make it foolproof and easy for all the windows users out there.

IF you have already installed MySQL on your system just follow the instructions in the COMMENT file of the RAR in the included link.

IF you have not installed mysql yet:

1.) unarchive the file in the included link to an easy directory (my suggestion is C: but it isnt absolutely necessary)

2.) go to a DOS/COMMAND prompt and navigate to the BIN directory (i.e. C:\MySQL\BIN)

3.) enter the command: mysqld -install

4.) THAT should cover everything.... this post should once and for all KILL any questions regarding MySQL.

-- Abaddon / Erazare

http://rapidshare.com/files/5332208/...QEMU_7.x.x.rar

come to think of it... if you download the last release of my apophis edition, and download this foolproof release of MySQL, it is impossible for you to not have a functional server **UNLESS** you screwup on PERL... hmm I need to make something foolproof for that now I guess huh?

Don't say foolproof - cause you just KNOW I'll manage to throw a monkey wrench into it somehow. lol

hmm I noticed that the package I just put up yesterday (the mysql one) has already been downloaded 5 times... so, of you who have taken it, everything ok? any questions? (really shouldnt be, but I'll ask anyway)

Anyone who uses the term "fool proof" is the proof of fools.

Someone will always f'it up. But cocky is "in". Knock yourself out. ;)

Un monkey wrenched it.. SQL is the suXorZ.. even managed to convert it back to a public server.. now to iron out the other details.

I have a general question...

to me LOGIC is everything.. if you follow the rules laid out Verbetim you cant have an illogical result... problem is, mankind has the tendancy to skip things thinking *hey, I know what I am doing* and thus fucking something up and then (especially if they are American like me) blaming someone else for thier own mistake.

this is even MORE common in the southern states.. I tell you all those redneck jokes are TRUE... I was born and bred in the Yankee kingdom, I hearda lot about the south and took most of it as sarcastic humor... it wasnta joke, these rednecks are MORONS.. and they say those of us in Massachusettes cannot drive... MY ASS.. at least we cant tell the difference between the color RED and the color GREEN...

anyway.. enough ranting... My point is, how is it that no matter how well we lay out a DETAILED way to make something work, we get 500 idiots that still manage to fuck it up... sorry for the language but quite honestly, if you dont pinpoint to these fucking idiots that they are FUCKING idoits... they just dont seem to get the point

Wow, I did not miss you.