983 SQL fix!

number6 · #1 02-16-2007, 02:57 AM

Thank you Mr WildcardX

Paul.

gernblan · #2 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** · #3 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 · #4 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 · #5 02-16-2007, 06:47 AM

Oh and was I right about the cost_inc purpose?

**KLS** · #6 02-16-2007, 06:52 AM

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

gernblan · #7 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** · #8 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.