it is not easy to create "good", "accurate" data about a whole month.
If you would try it, you can try SQL Scripts like this:
INSERT INTO jos_vvisitcounter ( tm, ip ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('127.0.0.1')) ); ( for unix_timestamp(NOW()) you must insert the correct date , e.g. unix_timestamp( '2012-11-21 13:00:00' ) )
But before : you must insert a row with the current count (your current counter value before a month). This is because you need the correct counter value. The max id is then the current counter value. INSERT INTO jos_vvisitcounter ( id, tm, ip ) VALUES ( 12345, unix_timestamp(NOW()) , UNHEX(SHA1('127.0.0.1')) );
It is a little bit work to put that in an file and copy-paste some lines.. then correct the dates..
Greetings Micha
|