This site makes extensive use of JavaScript.
Please enable JavaScript in your browser.
Live
PTR
10.2.7
PTR
10.2.6
Beta
SELECT MAX(Id) FROM Spells
Post Reply
Return to board index
Post by
pelf
SELECT MAX(Id) FROM Spells
What's the result of that for your database?
EDIT
: And don't take me literally if that's not what your columns or tables are named
:)
.
Post by
Koper
The result is:
#1146 - Table 'Spells' doesn't exist
Just kidding it's 96,539 and 98,000 on the PTR.. Almost 100,000 spells!
But I'm curious now, why do you want to know?(##RESPBREAK##)2##DELIM##Koper##DELIM##
Post by
Erorus
it goes up to spell id 96539 in the live version, but there are only about 66,234 actual spells by my count. Many IDs were skipped or removed.
Post by
Koper
67,469 to be precise.. Some spells were removed, while others are server-only and while we know that they exist, we have no way to get the data for them.
Post by
pelf
X-Perl needs to be updated. They have a constant for the highest spell ID that they use for their raid debuff highlighter thing that's currently set to 80000. I advised them to use 100000, but I was curious what the answer actually was
:)
. Changed my advice to 120000. Thanks!
Post Reply
You are not logged in. Please
log in
to post a reply or
register
if you don't already have an account.