AC <-> TC SmartAI diff

[Helias]

I compared the TC 335a database with the AC database about the SmartAI.
I've found that TC has 1913 SmartAI that we do not have.

Here the full list: https://paste.ubuntu.com/p/3J6rKNPfP9/

I used the following SQL script to get them.

SELECT entry, name, AIName FROM TC.creature_template WHERE AIName != '' AND entry NOT IN (
	SELECT entry FROM AC.creature_template WHERE AIName != ''
) LIMIT 20000;

This could be a good list of "missing SAI", feel free to port them on AC ;-)

@Kitzunu @Knindzagxg

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[Kitzunu]

You also need to check if we have core scripts assigned to them

[Knindzagxg]

My guild mates from retail did full checking of classic zones and so far a lot of problems.
But during this and next monht i should be able to sort all of them xP

[LichKing255]

I compared the TC 335a database with the AC database about the SmartAI.
I've found that TC has 1913 SmartAI that we do not have.

Here the full list: https://paste.ubuntu.com/p/3J6rKNPfP9/

I used the following SQL script to get them.

SELECT entry, name, AIName FROM TC.creature_template WHERE AIName != '' AND entry NOT IN (
	SELECT entry FROM AC.creature_template WHERE AIName != ''
) LIMIT 20000;

This could be a good list of "missing SAI", feel free to port them on AC ;-)

@Kitzunu @Knindzagxg

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

your query is not true. it's true :

SELECT entry, name, AIName FROM TC.creature_template WHERE AIName != '' AND entry NOT IN (
	SELECT entry FROM AC.creature_template WHERE AIName = '' AND (ScriptName = NULL OR ScriptName = '')
) LIMIT 20000;

[FrancescoBorzi]

this is more of a forum talk, moved