1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
$Id: README,v 1.1 2000/06/05 21:13:42 kiwi Exp $
README for SQLCounter
Introduction
============
This is an remplacement of the <counter> tag with accessed database
stored into an SQL database instead of the traditionnal <accessed> database.
Required
========
It need the following modules installed and configured in order to have a
correctly working system
o A SQLmodule setup with a default database whith r/w access eg :
mysql://user:passwd@localhost/counter
o A graphics counter module that can work (with all digits)
Format of the database
======================
=> NOTE : the module was tested **ONLY** with a mysql database and was _not_
tested on other databases.
Use the following with your mysql server to create the database :
create table counter (
id int(15) not null default '0' auto_increment,
file char(250) NOT NULL default '',
server char(250) NOT NULL default '',
count BIGINT UNSIGNED NOT NULL default '0',
total_count BIGINT UNSIGNED NOT NULL default '0',
created DATETIME,
reset DATETIME,
INDEX(server(10),file(10)),
PRIMARY KEY(id)
);
How to use it
=============
This is basicaly like the traditionnal <accessed> or <counter> tag.
Just type <sqlcount> in one page and the system will check and/or create and
entry in the SQL Server, add some stuff in the database.
To have a graphical counter, use <sqlcount style=a> to have the equivalent of
the default <counter> tag.. :)
Feedback
========
Send feedback to Xavier Beaudouin <kiwi@oav.net>, comments, patches etc... :)
Thanks to
=========
o The Roxen team :)
o Isdnet :)
o Also I really wishes to thanks David Hedbor that give me a start of
sqlcounter I had hacked and modified a bit :) Thanks
|
