Pryd & Lorac,
A couple of observations on my part. Never had any worthwhile things to contribute until now, but I must start by saying I do appreciate all the hard work on your part.
First off, in the fun DB (for the 8070 & 8074 releases), paladins start with almost all of their spells by default at level 1. They are the only class that has this. I dug through the playercreateinfo_spell table, and can fix it with:
Code:
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48942');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48782');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='53736');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48932');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='62124');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='53601');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='10308');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='10278');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48788');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48950');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48936');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='31789');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='54043');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='25780');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='1044');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='61411');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48819');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48801');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48785');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='5502');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='19746');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='53407');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='54428');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='1038');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48943');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='19752');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48945');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='642');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48947');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='4987');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48806');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48817');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48934');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='10326');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='48938');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='25898');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='32223');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='31884');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='642');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48947');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='4987');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48806');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='27139');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48934');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='10326');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48938');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='25898');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='32223');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='31884');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='31884');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='4987');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='498');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='498');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='20217');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='20164');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='20165');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='6940');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48942');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48782');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='53736');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48932');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='20271');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='53601');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='10308');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='10278');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48788');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48950');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48936');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='31789');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='54043');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='25780');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='1044');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='61411');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48819');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48801');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48785');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='5502');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='19746');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='53407');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='54428');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='1038');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48943');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='19752');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='48945');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='498');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='20217');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='20164');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='20165');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='6940');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48942');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48782');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='53736');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48932');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='62124');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='53601');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='10308');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='10278');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48788');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48950');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48936');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='31789');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='54043');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='25780');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='1044');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='61411');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48819');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48801');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48785');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='5502');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='19746');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='53407');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='54428');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='1038');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48943');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='19752');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48945');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='642');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48947');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='4987');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48806');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48817');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48934');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='10326');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48938');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='25898');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='32223');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='31884');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='498');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='20217');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='20164');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='20165');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='6940');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48942');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48782');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='53736');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48932');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='62124');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='53601');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='10308');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='10278');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48788');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48950');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48936');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='31789');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='54043');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='25780');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='1044');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='61411');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48819');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48801');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48785');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='5502');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='19746');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='53407');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='54428');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='1038');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48943');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='19752');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48945');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='642');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48947');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48806');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48817');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48934');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='10326');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='48938');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='25898');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='32223');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='20217');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='20164');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='20165');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='6940');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='34769');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='34767');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='13819');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='23214');
DELETE FROM `playercreateinfo_spell` WHERE (race='1' AND class='2' AND spell='31801');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='13819');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='23214');
DELETE FROM `playercreateinfo_spell` WHERE (race='3' AND class='2' AND spell='31801');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='13819');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='23214');
DELETE FROM `playercreateinfo_spell` WHERE (race='11' AND class='2' AND spell='31801');
The relevant lines in the TDB_rev29_FUN.sql file are #1143153-1143335.
Second, I grabbed the source code and tried compiling it with Visual C++ 2010 just for kicks. You may want to give it a serious look, because I have noticed a serious speedup in loading times for TrinityCore.
Here's my benchmarks for a comparison of the 8074 release (x64) versus the source in the Lorac13 compiled with VC++ 2010 (x64):
Rev 8074 x64 Bin Distro: 4m 58s , 4m 49s, 4m 54s
Rev 8074 x64 Lorac13 Compiled w/ Visual C++ 2010: 1m 1s, 0m 59s, 1m 00s
Can you confirm this? It seems too good to be true, but the VC++ 2010 core loads and runs just fine. Also, the CPU load on MySQL is much higher for the VC++ 2010 core as opposed to the regular version, and it reports loading the correct number of items for each table. The version I compiled will push the mysql process up the max CPU usage when working on the big tables, while the regular never does so.
I have been playing with this version for a while, and it seems to be just as stable. I haven't changed any of the compiler options - I just updated the project to VC10.