This thread is what you're looking for! Remember, it's always better to just make threads in the Beginner's Lounge here http://www.pokecommunity.com/forumdisplay.php?f=284 when you have a question because that way many people can see your query and you're more likely to get an accurate and fast response. :D
I don't index sprites. I don't even know why people bother indexing. Wichu's editor inserts sprites whether they're indexed or not.
Feel free to post them on the thread, I'll look at them there and decide there.
Yow! I have noticed your sprites.rar on MrDS' profile. Your sprites are truly awesome but I think they should be resized in 64x64 pixels for GBA importing. Love your Mega Diancie. Can I use it as a base for the Emerald second frame?
0x860 - Pokemon Menu
0x861 - Pokedex Menu
0x862 - Pokenav Menu
We don't know very much of Emerald's flags. But, we do advise you Emerald hackers to try Ruby's and Sapphire's flags to see if anything comes up. And if something does, please report them to me.
For the fanfare... I don't know honestly... Depending in which case you're referring to, is it for a pokemon battle or the give pokemon command? I would look at one of those two scripts and find the fanfare command with 0xNUMBERS numbers being the offsets etc.