thats a good infomation to me

Thankz Link:D

Okay I'll be integrating all this new information into the next version of this hack, so stay tooned! :D

How will I make it into one query, why don't you just post the one query so I can use that instead :)

Okay the instructions have been updated slightly to be able to incorporate the phrases feature of vB 3. This update is strictly optional, so you do not have to install it, but if you want to have this hack in a different language, then you can install the hack with the updated instructions :)

Thanks to Bernd Glasstett for the idea of using phrases and Link14716 because I'm actually using the phrases that he suggested :p

It can easily be done with one query. My version in vBindex 3 which uses origional code only uses one query for new threads, posts and updated subscribed threads.

ok, i'm really stupid.... i just managed to upgrade to rc2 myself with no prior experience and it worked out good. i didn't install this hack into it yet cause i was probably going to upgrade first. now i did look for the global.php file and found it in the admincp folder but i couldn't find this text:

******************************

OPEN global.php AND FIND

******************************

echo "End call of global.php: $aftertime\n";

echo "\n<hr />\n\n";

and i looked in the same directory and i looked in the templates folder and i couldn't find this text either:

<if condition="$show['pmstats']"><br /><a

href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a>: $vbphrase[unread] <if

condition="$bbuserinfo['pmunread']"><strong>$bbuserinfo[pmunread]</strong><else

/>$bbuserinfo[pmunread]</if>, $vbphrase[total] $bbuserinfo[pmtotal].</if>

can someone give me step by step where everything is and how it's done. thanks a lot.

i put it here so its easier for users to understand :)

Good idea.

Which one do I use if I don't want the thread count to go up if someone posts into a thread?

just use the second query

Okay I never meant said that it's impossible, and I never had something like "if you're good enough then show me the query" :)

I just asked for the query, instead of just saying it's possible to do in one query :)

Also, I can't seem to find the COUNT() function in your code?