Counter

[jamestec]

How do I reset the visitors counter on the bottom of the page?

[orosanto]

How do I reset the visitors counter on the bottom of the page?

<{POST_SNAPBACK}>

 

You will need to get into the MySQL database for your site. The table to modify is called counter. If you have this access you can make it anything that you want. You can also change the start date for your site here also. I have the phpAdmin on my server, so this pretty easy. I don't know of any other way.

[ritDesign]

I need to change the starting date. How can I do that through phpMyAdmin?

[Flyer5]

I need to change the starting date. How can I do that through phpMyAdmin?

<{POST_SNAPBACK}>

 

 

you may need to run some sql. If i remember correctly the counter table may not allow editing.

Make a backup of your database.

Copy this below and run it in the "run sql" window on your database admin.

Change the values to suit, pay attention to the format of the date, yearmonthday

ie today would be 20050105

 

#---------COPY FROM HERE--------------------------------------

 

#

# Table structure for table 'counter'

#

DROP TABLE IF EXISTS counter;

CREATE TABLE counter (

startdate char(8) ,

counter int(12)

);

 

#

# Dumping data for table 'counter'

#

 

INSERT INTO counter (startdate,counter) VALUES('20040914','69192');

 

# ----------- Dump ends -----------

 

 

hope that helps!

F5

one more thing -

 

BACKUP BACKUP!!

[ChrF]

It works!

 

BACKUP ANYWAY!!!

 

ChrF

[Guest]

I have a quick question..... How would you remove the counter altogether?