got 0.70 working barely by guessing whats needed in conjunction with my mysql skills

[redwing26]

Yes it does and thanks ....I must say though I got the wrong build that I mentioned above for titanium

I got the beta version and its working

so anyone reading this post DO NOT get the quests and db I said if your using titanium e.g DO NOT GET PEQ Velious RC1 DB∞ and the quest pack it must be the beta one for titanium from what I can see If you have the same config as me e.g titanium and 0.7-0-843 eqemu. If you have put Velious RC1 DB on then do

source drop_users.sql;
source drop_system.sql;
and do drop database dbname; and recreate a blank db
next copy system and users.sql from the beta RC1 database(in the zip file) to mysql\bin folder
next source load the system and users.sql (to get the relevant db setup for titanium and eqemu 0.70-843)

--------UPDATED TASK
get the database from(with sql files to source ): from
http://prdownloads.sourceforge.net/p...1.zip?download

and get the quests from http://prdownloads.sourceforge.net/e...s.zip?download
--------UPDATED TASK

Finally do
INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Minilogin');
alter table account add minilogin_ip varchar(32) not null;
insert into account (name,status, minilogin_ip) values('accountname',250,'127.0.0.1');

//i think you need to add a password field to accounts as well and fill the actual field with your mysqladmin password

I also had a problem with traps not being loaded to fix that do:
ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;

make sure youve copied spells_en.txt && spells_us.txt from your everquest folder to your eqemu folder

finally run:
minilogin.exe
world.exe
zone.exe (after world.exe is loaded)

Sorry about writing about the change at the end folks its just this is the first time ive set up the latest version manually and I decided to document it because as a newb I can see where people are having problems and where there is not enough emphasis on certain parts of the docs .........yeah the

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;

command is hidden in a thread or 2 on the forums but I dont see it in any docs .......and thats key to getting the latest version working! Yep its in the changelog but how many newbs:

1: look at the change log
2: are confident enough to know which sql stuff in the changelog is actually fixing bugs that cause crashes(relevant to there problem). The would prbably be worried they would make things worse if they didnt have sql knowledge.





Thanks alot for your config inis crab claw every little bit of info helps ......can you tell me is it possible to get the npc dialougue and quest journals working? when I get quests of npcs it doesnt get logged

[redwing26]

Crab claw I acknowledge what you sid about the ips and I will definately do that in the future but Im am quite frankly scared to have anyone on my server until I have it setup correctly hehe

edit------
One final question for the night .......sorry about the inquisition but I just like eqemu and want to be able to use it efficiently and to its full potential ......must be the geek in me Anyway I would really like to know:

Whats the biggest DB quest wise for eq titanium is it eq or peq?

thanks again!
redwing

[CrabClaw]

Hmm I've only used th EQ database, I haven't played much with the PEQ one. I do know the Cavedude one is supposed to have more zones spawned though.

[Zengez]

Neither database comes with quests, you have to add them in, go to the PEQ website and download the PEQ Quest Pack, not sure how compatible it is with cavedude's right off the bat, but thats where all the quests are....

[redwing26]

yeah I have downloaded the peq quest pack the quests seems quite sparse and the quest log , waypoint or npc journal doesnt update is there any fix to get the way point and journal updated? to install the quests I just copied the folders to c:\eqemu\quests .....Im assuming thats all I need to do to get them working? Still really need to know about the npc journal , waypoints and stuff