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?