[digitalpoint]

A few scalability issues...

- As someone else mentioned, you need $specialtemplates = array(); in your PHP files if you want them to work when people are using datastores.

- user.itrader_total needs an index if you want to sort the entire user table on it (you are in itrader_main.php).

- itrader table has 2 identical indexes (get rid of one of them)

- Not using the proper methods for SQL queries. Read queries should (usually) use $vbulletin->db->query_first_slave and $vbulletin->db->query_read_slave in place of $vbulletin->db->query_first and $vbulletin->db->query_read. The way it's setup now, all queries go to the master DB server instead of properly offloading the read queries to slaves DB servers.