Probably a week, we are working on getting a few more basic features working. For example, spells are still being debugged, and we would like to get those working properly before we release the source.

Excellent.

new db.sql
 

hi all, has the new and improved db structure been released to the public yet? i wanted to help in debugging but, i have db issues...missing fields/tables?

kabalah

Yes, the new db.sql should be available from CVS. I haven't touched CVS in a while, so if you don't see it, let us know.

cvs
 

ok, i checked cvs and i don't see the db.sql file anywhere in the eqemu/NewSource tree.
kabalah

it show be under eqemu release

hmm
 

nope, not under NewSource, do you mean directly under eqemu tree?
kabalah

the db.sql is in NightDumps/EQEMu Release/ and likely not upto date

alter table character_ add inventory blob default NULL after profile;
CREATE TABLE start_zones (
x float NOT NULL default '0',
y float NOT NULL default '0',
z float NOT NULL default '0',
zone_id int(4) NOT NULL default '0',
player_deity int(4) NOT NULL default '0',
player_race int(4) NOT NULL default '0',
player_class int(2) NOT NULL default '0',
player_choice int(2) NOT NULL default '0'
) TYPE=MyISAM;

Is that the only change needed so far?
Do we need to wipe accts and start fresh?

Accounts are fine character_ is another matter, untill/unless someone writes a converter, you may want to dump them to a .sql or temp table

thanks
 

thanks bigpull!
kabalah

additional i need to add timeleft in the spawn2 table to join zones.

added it this way:
timeleft int(11) NOT NULL default '0',

seems working, i can login.
npcs are there too
there seems something wrong with the items always getting :"got a bogus item, deleting it " when i want to trade with a npc, but im sure thats something with the DB, im using Drawde's Worlddata 1.1 final for CVS.