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:
|
CREATE TABLE bb1_statsinfo_ip (
ip_adresse varchar(15) NOT NULL default '000.000.000.000',
userid int(11) NOT NULL default '0',
time_date int(8) NOT NULL default '0'
) TYPE=MyISAM;
CREATE TABLE bb1_statsinfo_useragent (
id int(255) NOT NULL auto_increment,
name varchar(150) NOT NULL default '',
identify int(1) NOT NULL default '0',
counter int(255) NOT NULL default '0',
http varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=27 ;
INSERT INTO bb1_statsinfo_useragent VALUES (1, 'Windows', 1, 0, 'http://www.microsoft.com/germany/windows/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (2, 'Windows 3.11', 1, 0, 'http://de.wikipedia.org/wiki/Windows_3.11');
INSERT INTO bb1_statsinfo_useragent VALUES (3, 'Windows 95', 1, 0, 'http://www.microsoft.com/windows95/default.asp');
INSERT INTO bb1_statsinfo_useragent VALUES (4, 'Windows 98', 1, 0, 'http://www.microsoft.com/windows98/default.asp');
INSERT INTO bb1_statsinfo_useragent VALUES (5, 'Windows ME', 1, 0, 'http://www.microsoft.com/windowsme/default.asp');
INSERT INTO bb1_statsinfo_useragent VALUES (6, 'Windows NT', 1, 0, 'http://www.microsoft.com/ntserver/');
INSERT INTO bb1_statsinfo_useragent VALUES (7, 'Windows 2000', 1, 0, 'http://www.microsoft.com/germany/windows2000/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (8, 'Windows XP', 1, 0, 'http://www.microsoft.com/germany/windowsxp/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (9, 'Windows Vista', 1, 0, 'http://www.microsoft.com/germany/windowsvista/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (10, 'FreeBSD', 1, 0, 'http://www.freebsd.org/');
INSERT INTO bb1_statsinfo_useragent VALUES (11, 'MacOSX', 1, 0, 'http://www.apple.com/macosx/');
INSERT INTO bb1_statsinfo_useragent VALUES (12, 'SunOS', 1, 0, 'http://www.sun.com/software/solaris/index.jsp');
INSERT INTO bb1_statsinfo_useragent VALUES (13, 'Linux', 1, 0, 'http://www.linux.de/');
INSERT INTO bb1_statsinfo_useragent VALUES (14, 'Unix', 1, 0, 'http://de.wikipedia.org/wiki/UNIX');
INSERT INTO bb1_statsinfo_useragent VALUES (15, 'Firefox', 0, 0, 'http://www.mozilla-europe.org/de/products/firefox/');
INSERT INTO bb1_statsinfo_useragent VALUES (16, 'Opera', 0, 0, 'http://www.opera.com/');
INSERT INTO bb1_statsinfo_useragent VALUES (17, 'Konqueror', 0, 0, 'http://www.konqueror.org/');
INSERT INTO bb1_statsinfo_useragent VALUES (18, 'Lynx', 0, 0, 'http://lynx.browser.org/');
INSERT INTO bb1_statsinfo_useragent VALUES (19, 'Avant', 0, 0, 'http://www.avantbrowser.com/');
INSERT INTO bb1_statsinfo_useragent VALUES (20, 'Internet Explorer', 0, 0, 'http://www.microsoft.com/windows/ie_intl/de/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (21, 'Internet Explorer 5.0', 0, 0, 'http://www.microsoft.com/windows/ie_intl/de/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (22, 'Internet Explorer 5.5', 0, 0, 'http://www.microsoft.com/windows/ie_intl/de/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (23, 'Internet Explorer 6.0', 0, 0, 'http://www.microsoft.com/windows/ie_intl/de/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (24, 'Internet Explorer 7.0', 0, 0, 'http://www.microsoft.com/windows/ie_intl/de/default.mspx');
INSERT INTO bb1_statsinfo_useragent VALUES (25, 'Mozilla', 0, 0, 'http://www.mozilla-europe.org/de/products/mozilla1x/');
INSERT INTO bb1_statsinfo_useragent VALUES (26, 'Other', 0, 0, '');
INSERT INTO bb1_statsinfo_useragent VALUES (27, 'Other', 1, 0, '');
|