Server Connect, Client connected until...

Arag · #1 07-20-2006, 05:23 AM

thanks alot i wil go to the download page and get all the mysql codes from the log til the last release..
i let you know if it works when ready.
thanks alot for your help!!

btw is there a way so i can use your Db ?
if so.
may you be so kind to share it with me
?

Much Respect for your help and intrest!

Makwa · #2 07-20-2006, 05:31 AM

Absolutely you can have mine. I am all for sharing the wealth. Let me pack it, zip it, and i will email it to you. I have to check the size of the zip file after i do it though. If its too big to email, i will give you a link to the file on my website, and you can download it there.

Makwa

Arag · #3 07-20-2006, 05:40 AM

cool! that wil help alot~!!
i have do the comands into mysql now it ony keep saying zone unavailebel :(
so i i keep doing thing wrong or something :(
i followed the wikki for the 7.0 step by step and befor i did all the comands the mini was working 25% hahahah ,
now i cant log in anny more so there is some thing not correct :(

may you can tell me how to instal your Db correctly when i downloaded it?

thx

btw i get this in zone.exe when i try to enter world

Path File ./Maps/freportw.path not found.
[Status] Weather should change in 6728 seconds
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.wa
lkspeed' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error3 in PopulateZoneLists query 'SELECT spawnentry.spawngroupID, npcid, chance
, spawnentry.spawn_limit AS gsl, npc_types.spawn_limit AS sl FROM spawnentry, s
pawn2 LEFT JOIN npc_types ON spawnentry.npcID = npc_types.id WHERE spawnentry.sp
awngroupID=spawn2.spawngroupID AND zone='freportw' ORDER by chance' #1054: Unkno
wn column 'spawnentry.spawn_limit' in 'field list'
[Error] Loading spawn groups failed.
Zone->Init failed

Makwa · #4 07-20-2006, 06:48 AM

That error means that you dont have spawnentry table in the database.

To use this new DB that i will give you, you just do this:

1. mysql -u root
2. create database eq < - - name it whatever you want.
3. use eq;
4. source db.sql;

Let it run all the way.

5. do the grant all privileges command.
6. do the insert into account (name, status, minilogin_ip) VALUES ('mini',250,'127.0.0.1');
Make sure that the minilogin_ip is what your using everywhere else.
name is the name of the login into Everquest.

Your DB is probably good, just needs a few tweaks.

If you want to try your DB first, source this in yours:

CREATE TABLE spawnentry (
spawngroupID int(11) NOT NULL default '0',
npcID int(11) NOT NULL default '0',
chance smallint(4) NOT NULL default '0',
PRIMARY KEY (spawngroupID,npcID)
) TYPE=MyISAM;

Or type that in dos, once your in mysql, using your db.

Let me know if that works any better.

Makwa

Makwa · #5 07-20-2006, 06:53 AM

Can you post me the contents of your eqemu_config.xml file, and your loginserver.ini?

Thanks,

Makwa

Arag · #6 07-20-2006, 07:34 AM

Quote:

Originally Posted by Makwa

Can you post me the contents of your eqemu_config.xml file, and your loginserver.ini?

Thanks,

Makwa

sure il post them first and then create the Db
when you have it ready 4 me

login.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

------------------------------------------------------------------------

eqeum_config

<?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>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>

<launcher>




</launcher>

<files>




</files>

<directories>



</directories>

Makwa · #7 07-20-2006, 07:46 AM

I have my DB dumped, but it's 96MB. Way to big to email. Try creating that table in your first from my last post, see if that works at all.

If not, let me know. I will post my db on my site.

I will email you the path to the file to your email address in your profile here, when it is up.

Makwa