[dfighter]

So I git tired of having over 9000 warnings during startup because my DB is old (NCDB r101), and put them into a box, then put the box into a bigger box, and threw it into the ocean with some simple SQL queries I wrote up.

First and most importantly it's necessary to import the `spellids` table that I provided here in this post as a download:
 spellids.zip (113.98K)
Number of downloads: 21

This tabled contains all the spellids for patch 3.3.5a, maybe when we progress with patches I will update it with the latest.

Then you can run these:

DELETE FROM `ai_agents` WHERE `spell` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `ai_threattospellid` WHERE `spell` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `playercreateinfo_spells` WHERE `spellid` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `spell_coef_override` WHERE `id` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `spell_proc` WHERE `spellID` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `spellfixes` WHERE `spellId` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `spelloverride` WHERE `overrideID` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `spelloverride` WHERE `spellId` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `SpellTargetConstraints` WHERE `SpellID` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `totemspells` WHERE `spell` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `totemspells` WHERE `castspell1` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `totemspells` WHERE `castspell2` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `totemspells` WHERE `castspell3` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `trainer_spells` WHERE `cast_spell` NOT IN ( SELECT `Id` FROM `spellids` );
DELETE FROM `trainer_spells` WHERE `learn_spell` NOT IN ( SELECT `Id` FROM `spellids` );

Enjoy

[Marforius]

nice

[sip]

Bump bump:) Nice nice Work

[iEzri]

sip, on 25 October 2010 - 12:40 PM, said:

Bump bump:) Nice nice Work

we are all as excited as you, but please don't bump.

[dfighter]

iEzri, on 26 October 2010 - 06:33 AM, said:

we are all as excited as you, but please don't bump.

Are you jealous because he has bigger bumpers than you?

[iEzri]

dfighter, on 26 October 2010 - 10:44 PM, said:

Are you jealous because he has bigger bumpers than you?

you wanna push them?

/makes pussycat-doll-move

[dfighter]

iEzri, on 27 October 2010 - 07:04 AM, said:

you wanna push them?

/makes pussycat-doll-move

iEzri is multitouch, huh?
Making that move has just made you #6 prostitute in Kazakhstan!

EDIT:

Some more cleanup:

DELETE FROM `creature_proto`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `creature_quest_starter`
WHERE `id` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `creature_quest_finisher`
WHERE `id` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `ai_agents`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `battlemasters`
WHERE `creature_entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `loot_creatures`
WHERE `entryid` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `loot_skinning`
WHERE `entryid` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `loot_pickpocketing`
WHERE `entryid` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `npc_gossip_textid`
WHERE `creatureid` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `npc_monstersay`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `reputation_creature_onkill`
WHERE `creature_id` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `trainer_defs`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `trainer_spells`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `vendor_restrictions`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `vendors`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `zoneguards`
WHERE `horde_entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `zoneguards`
WHERE `alliance_entry` NOT IN ( SELECT `entry` FROM `creature_names` );


DELETE FROM `creature_spawns`
WHERE `entry` NOT IN ( SELECT `entry` FROM `creature_names` );

DELETE FROM `creature_formations`
WHERE `spawn_id` NOT IN ( SELECT `id` FROM `creature_spawns` );

DELETE FROM `creature_waypoints`
WHERE `spawnid` NOT IN ( SELECT `id` FROM `creature_spawns` );

DELETE FROM `creature_timed_emotes`
WHERE `spawnid` NOT IN ( SELECT `id` FROM `creature_spawns` );

EDIT:

and some more cleanup

DELETE FROM `gameobject_quest_starter`
WHERE `id` NOT IN ( SELECT `entry` FROM `gameobject_names` );

DELETE FROM `gameobject_quest_finisher`
WHERE `id` NOT IN ( SELECT `entry` FROM `gameobject_names` );

DELETE FROM `gameobject_quest_item_binding`
WHERE `entry` NOT IN ( SELECT `entry` FROM `gameobject_names` );

DELETE FROM `gameobject_quest_pickup_binding`
WHERE `entry` NOT IN ( SELECT `entry` FROM `gameobject_names` );

DELETE FROM `gameobject_teleports`
WHERE `entry` NOT IN ( SELECT `entry` FROM `gameobject_names` );

DELETE FROM `gameobject_spawns`
WHERE `entry` NOT IN ( SELECT `entry` FROM `gameobject_names` );

DELETE FROM `loot_gameobjects`
WHERE `entryid` NOT IN ( SELECT `entry` FROM `gameobject_names` );

Going to commit these.