[Milad]

As i am not the perfect coder any further advise will be taken seriously for optimizing the product.

For sure, this product can be optimized.

You used three queries and that's too much.

First of all you need to run a cron job to save those stats in the datastore table. use the hook cron_script_cleanup in includes/cron/cleanup.php

Then you need to get the information via the hook init_stratup in includes/init.php

PHP Code:

if (THIS_SCRIPT == 'forumhome')
{
    $datastore_fetch[] = "'here_your_datastore_title'";
} 


and then use $vbulletin->here_your_datastore_title to access your info.

Then you can bypass the template edits by joining your info to a variable ex: $totalposts

regards