118 queries on forum home? You are killing the server! My server starts to die at 100!

thank you great hack
/me hits install.

Here's a couple of things I'm curious about...

-Would a Item Trading or PvM feature be possible to create?
-What is the query used to purchase an item?

Help would be appreciated. :)

Edit:
Another question. :) Item categories (with exception of the top one) are automatically collapsed if you are "Generic Type". If you are another RPG type, the rows are automatically expanded. How would I go about having them collapsed to begin with, rather than expanded?

Anyone know / think this hack is stable enough for a production environment?

Also, does this come with a clan system?

Several large message boards already utilize this hack. I would say it's good enough for a production board.

And there is somewhat of a clan system. They're called "Alignments" in this case. I believe the default alignments are "Good" and "Evil" but you can set the clan name as an option. If you have a clan called "RPGers" add a new alignment called "RPGers" and anyone will be able to choose to be Good, Evil, or RPGers. :)

I'm personally waiting to see how stable the next update is and to help with any bugs, but I think it's getting close to production server level.

Depends on how well you know php/mysql/html editing your self, to fix anything that still might be buggy.

Alright, thanks for the help guys. So these alignments can only be created by admins? Might work... I take it there's also a money system.

I got the password problem solved by doing that key to key1 variable change. I did install it on a production board because my friends thought the hack kicked ass. After testing out the battle system (which went with no problem!), my friends all want to battle each other (I had to ban one of my friends for spamming the forums though. I even gave him a second chance to repent).

Great work on a great hack :D

Alright, I've installed it on my boards and everything seems to be running smoothly. Had a small problem with the battle though, it said I didn't have a weapon....

You have to go to "Edit Item Type" (or something simliar) via your Admin CP, and check each item to fit your type. The default type = Generic.