User registration:
Page required 9 database queriesQuery 1: SELECT * FROM users WHERE username='Anonymous' LIMIT 1;Query 2: SELECT * FROM config WHERE `key`='reuse_emails';Query 3: SELECT username FROM users WHERE username='Steve' LIMIT 1;Query 4: SELECT value FROM config WHERE `key`='register_type';Query 5: DELETE users, user_activations from users, user_activations WHERE user_activations.expires <= 1181654020 AND users.username <> 'Anonymous'Query 6: SELECT * FROM config WHERE `key`='forum_name' OR `key`='forum_addr';Query 7: INSERT INTO users (`username`, `password`, `email`, `theme`, `active`, `register_time`, `register_ip`) VALUES ('Steve', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'test@test.com', 'default', '0', '1181654020', '1382862578');Query 8: INSERT INTO user_activations (`id`, `key`, `expires`) VALUES ('10', '10f1a21ea75204aa3fde2b13155b022f', 1182258820);Query 9: SELECT * FROM config WHERE `key`='email_from_addr' OR `key`='forum_name' OR `key`='mail_server_addr' OR `key`='mail_server_port' OR `key`='hostname';
That could be cut down a little if I read the entire "config" table at script startup, but that sounds like a bad idea. Suggestions?