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

redwing26 · #1 08-17-2006, 03:36 AM

Hiya again folks,

I managed to get 0.70 installed manually by picking parts out of new guides and out dated ones and guessing which threads on the forum and relevant to my problem. Anyway I am going to do a fresh install of the peq release 1 beta database and I will list the steps as I do them an show my configs and I was wandering if people could keep me right with the small amount Im unsure of now........I tried the irc support channel and hardly anyone is there , its no wander considerinmg know one speaks or answers any questions, I dont know where they get the word support from because they are not doing anything near supportive.

Anyways what is the best version of minilogin for 0.70? Im thinking I need minilogin.exe and sleep (I will do this now correct me if im wrong and name a version thats good with 0.70) later I will also need to know how to get the quest npc journal working

redwing26 · #2 08-17-2006, 03:44 AM

okay minlogin had file opcodes.conf minlogin.exe and loginserver.ini I only extracted minilogin.exe as I didnt want to replace the eq-0.70 opcodes . I also have a previously working login server.ini , db.ini and the config xml file

Next I am downloading Download PEQ Velious RC1 DB∞ and the quest pack .......is this version compatible with titanium?

-----edit
Also at this point I have installed mysql,mysqlcc and perl via the cavedude tutorial and I created a peq database as well as a mysqladmin user and pass , this is myuname and mypass referrenced in the file.
----edit

Okay I will take that as a yes I have also put the quests into the quests folder and run the drop_*.sql files to start anew. Next I sourced the load_system and users.sql

next I do

INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Minilogin');

then

alter table account add minilogin_ip varchar(32) not null;

then

insert into account (name,password,status, minilogin_ip) values('myuname','mypass',250,'127.0.0.1');

Now Im getting to the point where I need help on extra config to get the most out of my game any help would be appreciated

redwing26 · #3 08-17-2006, 04:01 AM

heres my eqemu_config.xml

<?xml version="1.0">
<server>
<world>
<shortname>minilogin</shortname>
<longname>My Minilogin</longname>


<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>


<database>
<host>localhost</host>
<port>3306</port>
<username>myuname</username>
<password>mypass</password>
<db>peq</db>
</database>
</server>

redwing26 · #4 08-17-2006, 04:04 AM

heres my loginserver.ini

###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=My Minilogin
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

next my eqhosts.txt
[LoginServer]
Host=127.0.0.1:5999

then my eqhost.legit.txt
[LoginServer]
Host=newlogin1.eqemulator.net:5998

^^correct me if im wrong with anything if anyone can be bothered , failing that hopefully this will help some newbs

heres my db.ini , not sure if both db.ini and the xml file are needed as I havent had that clarified from anyone

###Your current database configuration is as follows:
##db.ini:

[Database]
host=127.0.0.1
user=myuname
password=mypass
database=peq

Also another important file ive founf that I havent seen mentioned in any guide is config.ini which tells eqemu where to look for the quest, once again Im not sure how accurate my info is as its all assumptions but I dont see any docs that clearly spell things out so heres what my config.ini looks like on my working manual install

[Database]
host=localhost
user=myuname
password=mypass
database=peq
compression=off

[General]
quests=C:\EQEmu\quests

wordwrap=1

next I got the maps files .......I downloaded them via the link in cavedudes tutorial ......Im not sure if theres specific maps for specific releases so once again im making the assumtion that this is the way to go.

CrabClaw · #5 08-17-2006, 05:39 AM

If you are going to play on the same maching as your server is running and have freinds log in too. This is a copy of my eqemu_config.xml. Notice where I put my server computers local LAN IP, 192.168.1.51.

<?xml version="1.0">
<server>
<world>
<shortname>minilogin</shortname>
<longname>Happy Fun Server</longname>


<address>192.168.1.51</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>
<host>192.168.1.51</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>


<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>
</server>

This is my Logingserver.ini:

###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=192.168.1.51
loginport=5999
worldname=Happy Fun Server
worldaddress=192.168.1.51
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

This is my db.ini:

###Your current database configuration is as follows:
##db.ini:

[Database]
host=127.0.0.1
user=eq
password=eq
database=eq

This is my ehost.txt in the client directory:

[LoginServer]
Host=192.168.1.51:5999

You can find you LAN IP by doing a ipcong at the command line. This setup allows me on the host machine and everyone else on the network play.

The last step is to change your list of users in your database. Make sure no one has 127.0.0.1 as thier log in IP in the accounts table in the database.

So if the first account is on the local machine it would look like this in the 'accounts' table in the database. This is assuming you made the LAN IP on all the machines sequential. When in doubt do a IPCONFIG on each machine to make sure the IP is correct:

First user login IP> 192.168.1.51
Second user login IP> 192.168.1.52
Third user login IP> 192.168.1.53

and so on....

Cool tools that are a must to get are the MySQL Administrator, Query Browser off the http://dev.mysql.com/ site. They will save you a lot of time and errors, they also can do backups or manage timed backups too.

I hope this helps

redwing26 · #6 08-17-2006, 08:02 AM

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 · #7 08-17-2006, 08:32 AM

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 · #8 08-17-2006, 12:16 PM

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 · #9 08-17-2006, 01:42 PM

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 · #10 08-17-2006, 01:47 PM

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