any database that works with eqemu 4.3 ?

[sandy]

if yes could you explain what we have to source exactly steps by steps to make it works without errors in the process when we start from create database eq ?
thx

[thedavee]

Create database

download the lastest database from telmet
http://www.darkangel.net/eqemunews/
EQEmu-0.4.4-DR1+Telmet-DB-Test
unzip all file to mysql/bin folder

run mysqladmin.exe
run mysql.exe
Tape:
create database eq ;
use eq ;
source db.sql ;
source books.sql ;
source class_skill.sql ;
source doors.sql ;
source InitialEquipment.sql ;
source items.sql ;
source newitems.sql ;
source npc_spells.sql ;
source npcupdate.sql ;
source spawns.sql ;
source tradeskillupgrade.sql ;
source weather.sql ;
source zonepoints.sql ;
source zpoints-3-4-2003.sql ;
**create your account**
insert into account set name="youname", password="yourpass", status="200" ;
exit ;



@++

[jbb]

Does this add any faction information to the database?
I've not seen any so far with faction so I'm looking for either a database dump with faction in, or an explanation of how faction works - I can't quite figure it out from the database tables.

[thedavee]

Use that fix for faction update

http://forums.eqemu.net/viewtopic.ph...ght=fixfaction

At this time i dont know really how to confirure the faction.

[jbb]

Thanks but that seems to just update existing faction. I can't figure out how to set what faction an npc is on, or what faction hits you get by killing it.... Assuming this is implemented?

[IAdragonflyy]

The source zpoints .... doesn't seem to work.

ERROR 1136: Column count doesn't match value count at row 1

is the error i get over and over

[thedavee]

zpoints-3-4-2003.sql
that error is a miss match of the zone table structure in the db.sql or structure of zpoint.
2 colums missing in the bd.sql table zone.

db.sql

-- Dumping data for table 'zone'
--


INSERT INTO zone (short_name, file_name, long_name, safe_x, safe_y, safe_z, minium_level, minium_status, zoneidnumber) VALUES ('qeynos',NULL,'South Qeynos',0,10,3,0,0,1);

zpoints-3-4-2003.sql

# Dumping data for table `zone`
#

REPLACE INTO zone VALUES ('qeynos', NULL, 'South Qeynos', '0', '10', '3', 0, 0, 1, 0, 0);

i dont know what that can do really, but you can remove this file if you want eqemu is working without.
Maybe a correction to the spawn point?

[devlor]

I have just gotten started in using EQEmu, & have only just today finally gotten it working in a local setup, so forgive my inexperience.

I started out using EQEmu-0.4.4-DR1+Telmet-Win32, along with the included db.sql, & while there were no NPCs, items, or whatnot, at least the doors seemed to work reasonably well. Upon integrating the various *.sql's in EQEmu-0.4.4-DR1+Telmet-DB-Test, the doors ceased to function. Is this expected behavior in the current version of these files? Are there any known workarounds (such as leaving out doors.sql in the database) at this time?

Thanks for your help &/or info.