983 SQL fix!

[gernblan]

983 as it is on the site right now does NOT work.

More SQL is needed than what is just in the changelog, because a new column must be added to altadv_vars otherwise if you try to log in you get an endless loop of zone crashing.

Here's the SQL:

alter table altadv_vars add column cost_inc tinyint(4) not null default 0;

This may not be exactly what the developer had in mind (hard to tell since this is undocumented so far what this column is for but MY GUESS IS that it tells the server how much to charge for AA trains above the first point in any particular skill. For example, if the first train is 3 and the cost_inc is also 3, then the next level is 6 AA's to buy. This is JUST A GUESS!)

At any rate, can always delete and recreate the column later if I am wrong about this.. it DOES allow the server to run on 983 though so I'm happy.

Peace.

[WildcardX]

Did you source in this sql from the "aa_data.sql" file?


DROP TABLE IF EXISTS altadv_vars;
CREATE TABLE altadv_vars (
skill_id int(11) NOT NULL default '0',
name varchar(128) default NULL,
cost int(11) default NULL,
max_level int(11) default NULL,
hotkey_sid int(10) unsigned NOT NULL default '0',
hotkey_sid2 int(10) unsigned NOT NULL default '0',
title_sid int(10) unsigned NOT NULL default '0',
desc_sid int(10) unsigned NOT NULL default '0',
type tinyint(3) unsigned NOT NULL default '1',
spellid int(10) unsigned NOT NULL default '0',
prereq_skill int(10) unsigned NOT NULL default '0',
prereq_minpoints int(10) unsigned NOT NULL default '0',
spell_type int(10) unsigned NOT NULL default '0',
spell_refresh int(10) unsigned NOT NULL default '0',
classes int(10) unsigned NOT NULL default '65534',
berserker int(10) unsigned NOT NULL default '0',
class_type int(10) unsigned NOT NULL default '0',
cost_inc int(10) unsigned NOT NULL default '0',
PRIMARY KEY (skill_id)
) TYPE=MyISAM;

[number6]

Maybe I'm being daft but I can't find aa_data.sql anywhere, can anyone help?

Thanks

Paul.

[WildcardX]

Download from here. I'll remove this from my website in 72 hours.

http://www.queluum.net/AA_Data.sql

[number6]

Thank you Mr WildcardX :)

Paul.

[gernblan]

Thanks! Was tough to source in something I couldn't find.

Very much appreciated, thank you!

Oh and as these get fixed again, is it possible they can put it with the source or something? I mean, the SQL?

This SQL will cause quite a loss of AA abilities in my players (well, 983 already did as a lot of skills they had are now turned off, I imagine, while they work on the rest of them).

What I am asking is, as they get fixed, could they please supply the updated records to us?

[KLS]

Yeah the CVS is a little messed right now, forgot people without direct access wont get it for a bit doh.

[gernblan]

Yeah the CVS is a little messed right now, forgot people without direct access wont get it for a bit doh.

Yes, thank you KLS and WildcardX... GREAT WORK!

See my last post, I'm asking if you could toss that SQL in with the source from now on as things change, please?

So that we get it on time?

[gernblan]

Oh and was I right about the cost_inc purpose? :)

[KLS]

Yes, you were. Cost = Initial level + (Cost Inc * Subsequent levels)

[gernblan]

Oh and looking at this SQL you gave us WildcardX, is it intended that it will pretty much wipe out most of the AA tiers if I use this?

I can assume that if I use this, as the AAs are fixed page by page again, the SQL to make them work will be given to us again as they are fixed? I'm really scared to wipe them out and replace what I have in the db already, I'm going to have a lot of upset players and I need to be able to explain this to them. :)

Thank you.

[KLS]

That will wipe it out, if you know how you can manually add in the new AA stuff and keep your old. The SQL should update as more AAs are implemented.

[gernblan]

Thank you.

I will do that.

[Angelox]

Heres a new problem for me , I've had for the past 2-3 versions; if I set a static zone, it won't log in, just hangs and times out, but If I leave them all dynamic, no problem.

[KLS]

I was told about that today.. but I've been unable to reproduce it, static zones are working fine for me =/

[Angelox]

Well, if it helps anyone , the problem was me - I had shut the ports down on my firewall since I wasn't using them and forgot to open them again.

[gernblan]

Ahhh yep, that'll do it, heh.

[Kayot]

I'm just happy that I held back from adding the AA editor into my program ^-^' I had this feeling that touching it would be a bad idea.

[gernblan]

I provided very complete (through OOW) db sources to KLS who will now be working off of those, which will really make things easier for him, since our Jest ][ sources are quite thorough.

I'm very excited that I was able to help out this way! :)

So when you see the new SQL sources posted (I'm not posting them so that in case he wants to tweak something he can), they will be the ones you'll want to use.

[number6]

Hi again guys,

I see there's a new release of Emu source (988) but the AA sql file still isn't part of the download - is it possible please to have it included in the tar file, or can someone please link the latest and greatest file? I have some AA fans on my server who are very keen to try this stuff out :)

Thanks

Paul.

[GeorgeS]

Here's my sql

http://66.159.225.58/eqemu/sql_changelog_to0.7.0.985.txt

GeorgeS

[Angelox]

Thanks George - nice to see you around still, I still use most of your editors :)

[KLS]

latest AA_data.sql: Here (http://hmproject.org/files/aadata.zip)

Since people have been asking.

[GeorgeS]

I've been busy at work. Tough time during the first quarter.


Anyway, I updated the file with this sql.

I'm a bit of a pack rat...

GeorgeS

[number6]

Cheers KLS, much appreciated.

Paul.