EQEmulator Forums
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Development (https://www.eqemulator.org/forums/forumdisplay.php?f=590)
-   -   983 SQL fix! (https://www.eqemulator.org/forums/showthread.php?t=22427)

gernblan 02-15-2007 10:35 PM
983 SQL fix!
 
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 02-16-2007 02:34 AM
Did you source in this sql from the "aa_data.sql" file?

Code:
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 02-16-2007 02:39 AM
Maybe I'm being daft but I can't find aa_data.sql anywhere, can anyone help?

Thanks

Paul.

WildcardX 02-16-2007 02:42 AM
Download from here. I'll remove this from my website in 72 hours.

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

number6 02-16-2007 02:57 AM
Thank you Mr WildcardX :)

Paul.

gernblan 02-16-2007 06:26 AM
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 02-16-2007 06:43 AM
Yeah the CVS is a little messed right now, forgot people without direct access wont get it for a bit doh.

gernblan 02-16-2007 06:46 AM
Quote:
Originally Posted by KLS
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 02-16-2007 06:47 AM
Oh and was I right about the cost_inc purpose? :)

KLS 02-16-2007 06:52 AM
Yes, you were. Cost = Initial level + (Cost Inc * Subsequent levels)

gernblan 02-16-2007 07:13 AM
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 02-16-2007 10:35 AM
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 02-16-2007 10:43 AM
Thank you.

I will do that.

Angelox 02-16-2007 11:07 AM
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 02-16-2007 11:59 AM
I was told about that today.. but I've been unable to reproduce it, static zones are working fine for me =/


All times are GMT -4. The time now is 10:51 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.