Spell book ID's

[Dello0000]

It is a weird one alright. Am i right in thinking you just drag and drop EQ2DBProject_Current.sql into the database and let it import its tables yeah?
1, Ok done it all again and still in the same position, it seems to be wanting files from eq2world/spells that i don't have, so ill check the svn.
2, Right, updated the world with https://svn.vgoemulator.net/svn/eq2cont ... k/scripts/.
3, Its found the missing lua files but wont load spells from DB.
4, Checked DB and all spell tables have content in them apart from "spell_aa" and "spell_traits". Checking for update.
5, Update found, files contain no data, restarting server.
6,


https://svn.vgoemulator.net/svn/eq2cont ... ase/dumps/ and https://svn.vgoemulator.net/svn/eq2cont ... k/scripts/ These are the up to date dev files?

1, Unrar EQ2DBProject_Current.sql and drag and drop it into the database and install everything from the second link. (scripts)
2, eq2_data Vs eq2_tables - Whats the difference between them? one seems to have no data in the tables, the other one does but should i ignore them due to the EQ2DBProject_Current.sql?
3, How do i install eq2world_coe_items?

Well that's where im at just now. Thought id combine my mornings work into the one post instead of all over the place. Hopefully should give you more info to go on than 1 question at a time


[EDIT] Are https://svn.vgoemulator.net/svn/eq2serv ... rldServer/ up to date? if so where do i install them?
I see heroic op and rules and i remember heroic op didn't work with my server before hand and the servers always moaning about rules (see above pic) so i may need them?!

[Dello0000]

Yeah serverpack1.5 came out end of last year so ill wait for the next serverpack, as it will be fully updated as apposed to having to manually update it. I think when I'm updating some parts its messing up other parts until it breaks because i dunno what I'm don't hahaha

[EDIT] So adding the eq2content\trunk\scripts seems to break things, no doubt because some of the files are up to date and some aren't.

[Jabantiz]

The unknown rules are rules in the DB that the server doesn't recognize, server will ignore them and it won't effect anything.

The sql error is why you have no spells, they are failing to load because you spells table is out of date as it doesn't have the `uncurable` field, not sure why you are not getting it with the current DB but you can manually run the following sql to update the tables.

Code: Select all

ALTER TABLE `spells` 
CHANGE COLUMN `uncurable` `incurable` TINYINT(1) NOT NULL DEFAULT '0' ;

ALTER TABLE `spells` 
ADD COLUMN `cast_while_moving` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `interruptable`,
ADD COLUMN `not_maintained` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `linked_timer_id`,
ADD COLUMN `casting_flags` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `not_maintained`,
ADD COLUMN `persist_through_death` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `casting_flags`;

ALTER TABLE `spells`
	ADD COLUMN `savage_bar` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `persist_through_death`,
	ADD COLUMN `savage_bar_slot` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `savage_bar`;

[Dello0000]

Thanks!

That works but now the spells DB must be outdated because warlocks still only have the first spell lol.

[Dello0000]

Right, ok last update from me until the 1.6 server pack lol.

The current database john linked me must be out of date, i can see no other explanation, every time i add it, it breaks the spells. in such a way that the only spells/skills/ability's a char gets is 8 basic skills (melee, ranged, Yell, Help ect ect) nothing else. Not even tradeskills.

That being said, in the database there's the spells table WITH spell info inside it, there's also lua spells in the worldserver folder however when i launch the server it loads 0 spells. No error messages tho, so i guess that's good? lol

starting_spells and starting_skills both have tables with content in them so I'm at a complete loss here, i assume im doing it right but because it takes 2-3h just to add the EQ2DBProject_Current.sql update I'm reluctant to keep going at it. Who knows, maybe I'm doing it all arse from elbow haha, but there's no way to know unless i strike it lucky and get them loading.

So ill wait until the next server pack comes out and it should work first time.

Thanks for all your help, I know iv been a big pain in the arse lol so thanks for putting up with it

Cya's soon!

[Jabantiz]

The current database john linked me must be out of date, i can see no other explanation

This is not the case, it was just updated Sunday (yesterday) and is the same place I get my DB and I do not have this issue, I am not sure what is going on to be honest.

You can try an updated server exe, attached one I built earlier today, just replace the one the server pack installed.

[Dello0000]

Damn you and your helpful advice lol, now ill have to try again tomorrow *Shakes fist*

exe doesnt work however it must be some old outdated bit that's conflicting with the new db.

Ill try again tomorrow i suppose lol.

[Dello0000]

Last question on spells and skills due to the fact that the latest DB makes everything work.

Adding focus to a monk was easy enough, "/skill add focus"
Adding Disruption to a monk was easy too, "/skill add disruption"
Adding a spell "Vacuum Field" doesn't seem to work. So is there a way to actually ADD the spell to the players spell book or is it just done with "/useability [Spell_ID] (tier)"?

*Also the berserker class doesn't have skills past level 1 (apart from heroic op)*

Thanks