change <ADVNCD_SITE_VISITORNUMBER>

[kvdv]

Hi,

I'd like to subtract the number of bots from my current <ADVNCD_SITE_VISITORNUMBER> stat.

I know the correct number of real visitors now, but i still need to know *how* to change the number?

thanks
Kris

[Dkozikowski]

Changing the number can be as easy or as complicated as you make it.

You could easily start from zero but to actually alter the number would be a slightly more involved task.

If you're anything like me though, you love your stats and will slave to get them where they need to be :p

So, if you really wish to fix the problem, you're going to have to dive head first into the visitors database table.

Before altering any data though, make a full backup of your database. (Better to be safe than sorry.)

Now, to start from zero, simply erase all data from inside the visitors table. (That was easy :) )

To actually alter the total, you will have to remove the specified # of visitors to bring the total down. You can delete any ole visitor or find the bots and erase them.
So, if your total is 5,600 and it needs to be 4,700, you must remove 900 visitor entries.

[kvdv]

Thanks dwilkinsjr+ !

The old <ADVNCD_SITE_VISITORNUMBER> tag i was using: does it use the pixelpost_stats or the pixelpost_visitors table?

And how can i search the spiders/bots ?

Thanks again!
Kris

[Dkozikowski]

It uses the visitors table. As for identifying bots. You need to look at the UA column of the visitors table.

You'll see something like, msnbot/1.0 (+http://search.msn.com/msnbot.htm) or Mozilla/5.0 (compatible; Yahoo! Slurp; http://help... , etc.