What do you think about making a mod that would make SMF work with only the newest version of PHP and MySQL. It would make use of their functions and features.
Foreign Key Constraints, InnoDB, stored procedures, triggers, INSERT ... SELECT, lots of PHP and MySQL functions.
I'm not a big fan of foreign keys, but some of the other things would be nice.
-[Unknown]
Anyone interested in helping me create this mod? It will require a lot of work.
To start, prepared statements and multi-table queries (UDPATE & DELETE specifically). Not sure where to start with PHP usage.