Server help.

[fearpb]

ok

i went to zone
and the value was 6 so i changed it to 5

and when i tried to execute items i got this msg at the bottom of mysql

"Table 'peq.items' doesn't exist"


so
what now hah?

[fearpb]

here is a screenshot of it

[Inspiration]

Having the zone value as 6 is fine too, that number is how many dynamic zones it will create. If you are just playing by yourself or with a couple of friends on a lan then 5 or 6 dynamic zones is fine.

How did you create your PEQ database? Did you download the peq-ykesha-release file and source load_system.sql? If so it should have created 'items' and populated it with 62000+ rows. I suggest you recreate your database for starters.

Do you have anything in 'account' in your database? If not you need to set this up as well.

INSERT INTO account (name,STATUS, minilogin_ip) VALUES('LOGIN',250,'IP OF COMPUTER');

Replace LOGIN with the login name you want and IP OF COMPUTER with your IP which from your previous post was 161.109.232.159 (this assumes you will be playing from the computer the server is running on).

If you didnt find 'account' then you need to first source in load_empty_users.sql from the peq-ykesha-release download.

Also in 'variables' you should have a LoginType which should have the value Minilogin. If you have nothing in 'variables' run this:

INSERT INTO VARIABLES (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin or Public :)');

[fearpb]

i did my database with PeQ
i used wincvs

just like it said in the guide

but i guess some things didnt work.

oh and i changed it to minilogin and i still cant log in

[fearpb]

Ok a quick update

I redid my whole database from scratch
I did everything again.
the world loads perfectly. Thanks for the help with that

Now I try to log in and i get a invalid user name or password

but here is my world if you want to take a look at it

[fearpb]

BREAKING NEWS

I got the server up and running.
BUT
I need to go out and buy me everquest titanium. because i cant find mine.
i was going to see if anything was updated for anniversary but i guess not lol.

damn
i wish there was just a good torrent out for eq titanium or a file somewhere on the net of it that i could just DL

oh well

Thank you to everyone that helped me.
I really appreciate it

Thank you,
Fear

[Inspiration]

Your dynamic zones still dont appear to be initializing properly which might be database related.

Also, you are still getting the items error which shouldnt prevent you from logging into your server but it does mean your world will contain no items (and that you havent created the database fully). When you used wincvs you would have downloaded a lot of *.sql files one of which was items.sql which is almost 40Mb in size. There should be 85 *.sql files in the peq_db folder if you downloaded them via wincvs. If you dont have all of these files sourced then your database will not function properly.

Im assuming you have Titanium installed and unpatched and that you are launching EQ using a shortcut to eqgame.exe and that you have changed your eqhost.txt to say

[LoginServer]
Host=161.109.232.159:5999

What does your LoginServer.ini contain?

[fearpb]

Sorry I uploaded the wrong screenshot

here is the new one

[Inspiration]

Looks good now, have fun.

[fearpb]

Thanks for the help guys, I really appreciate it.