[Bitsys]

Velocd:
I have optomised the queries as best I can, including re-doing parts of the itemshop to make it more query efficient. For example, if you look at the picture title "itemshop_generic.jpg", you will notice that there is only one item category displayed. For each item category, there is one query that must be made. In order to save queries, I made it so that you have to click the "expand" link next to the Category name (in the picture, the link is yellow). When you click the link, the page refreshes with the selected category appearing in an "expanded" view at the top of the other categories, and the category that was expanded before becomes "compressed". The reason I did this is because the Generic Item Type page is the default page whenever someone visits itemshop.php. Some people were noticing that itemshop.php eats up quite a few queries. My solution was to have the Generic Items get contracted and all other item types (see itemshop_warrior.jpg) to be automatically all-expanded.

Also, the files that I made (the battle hack files) have been optimised as compared to earlier version. I believe I eventually got battlefight.php down to 18 and battle.php to 7 or 8. Battle browse is 9 I think. I don't know about battleupdate.php though, since there are so many combinations of things that it could do based on how a user attacks. Also, whenever you view the bank, there are now around 8 queries, whereas before there were 21, I think. Overall, there may be some more places for improvement and I will be looking into that a little more.

geniuscrew:
Could you post the exact error message you are getting?