Diff
13 years ago
.htaccess
14 years ago
Diff.php
13 years ago
IPTraf.php
13 years ago
diffResult.php
13 years ago
email_genericAlert.php
13 years ago
email_newIssues.php
14 years ago
email_unlockRequest.php
14 years ago
menu_activity.php
14 years ago
menu_blockedIPs.php
13 years ago
menu_options.php
13 years ago
menu_scan.php
13 years ago
sysinfo.php
13 years ago
viewFullActivityLog.php
13 years ago
wf503.php
13 years ago
wfAPI.php
13 years ago
wfAction.php
14 years ago
wfArray.php
13 years ago
wfBrowscap.php
14 years ago
wfBrowscapCache.php
14 years ago
wfConfig.php
13 years ago
wfCrawl.php
13 years ago
wfDB.php
13 years ago
wfDict.php
14 years ago
wfIssues.php
13 years ago
wfLockedOut.php
14 years ago
wfLog.php
13 years ago
wfModTracker.php
14 years ago
wfRate.php
14 years ago
wfScanEngine.php
13 years ago
wfSchema.php
13 years ago
wfUnlockMsg.php
14 years ago
wfUtils.php
13 years ago
wfViewResult.php
13 years ago
wordfenceClass.php
13 years ago
wordfenceConstants.php
13 years ago
wordfenceHash.php
13 years ago
wordfenceScanner.php
13 years ago
wordfenceURLHoover.php
13 years ago
wfSchema.php
182 lines
| 1 | <?php |
| 2 | require_once('wfDB.php'); |
| 3 | class wfSchema { |
| 4 | private $tables = array( |
| 5 | "wfBadLeechers" => "( |
| 6 | eMin int UNSIGNED NOT NULL, |
| 7 | IP int UNSIGNED NOT NULL, |
| 8 | hits int UNSIGNED NOT NULL, |
| 9 | PRIMARY KEY k1(eMin, IP) |
| 10 | ) default charset=latin1", |
| 11 | "wfVulnScanners" => "( |
| 12 | IP int UNSIGNED PRIMARY KEY, |
| 13 | ctime int UNSIGNED NOT NULL, |
| 14 | hits int UNSIGNED NOT NULL |
| 15 | )", |
| 16 | "wfBlocks" => "( |
| 17 | IP int UNSIGNED PRIMARY KEY, |
| 18 | blockedTime int UNSIGNED NOT NULL, |
| 19 | reason varchar(255) NOT NULL, |
| 20 | lastAttempt int UNSIGNED default 0, |
| 21 | blockedHits int UNSIGNED default 0, |
| 22 | wfsn tinyint UNSIGNED default 0, |
| 23 | permanent tinyint UNSIGNED default 0, |
| 24 | KEY k1(wfsn) |
| 25 | ) default charset=utf8", |
| 26 | "wfConfig" => "( |
| 27 | name varchar(100) PRIMARY KEY NOT NULL, |
| 28 | val longblob |
| 29 | ) default charset=utf8", |
| 30 | "wfCrawlers" => "( |
| 31 | IP INT UNSIGNED NOT NULL, |
| 32 | patternSig binary(16) NOT NULL, |
| 33 | status char(8) NOT NULL, |
| 34 | lastUpdate int UNSIGNED NOT NULL, |
| 35 | PTR varchar(255) default '', |
| 36 | PRIMARY KEY k1(IP, patternSig) |
| 37 | ) default charset=latin1", |
| 38 | "wfFileChanges" => "( |
| 39 | filenameHash char(64) NOT NULL PRIMARY KEY, |
| 40 | file varchar(1000) NOT NULL, |
| 41 | md5 char(32) NOT NULL |
| 42 | ) default charset=utf8", |
| 43 | "wfHits" => "( |
| 44 | id int UNSIGNED auto_increment PRIMARY KEY, |
| 45 | ctime DOUBLE(17,6) UNSIGNED NOT NULL, |
| 46 | IP int UNSIGNED NOT NULL, |
| 47 | jsRun tinyint default 0, |
| 48 | is404 tinyint NOT NULL, |
| 49 | isGoogle tinyint NOT NULL, |
| 50 | userID int UNSIGNED NOT NULL, |
| 51 | newVisit tinyint UNSIGNED NOT NULL, |
| 52 | URL text, |
| 53 | referer text, |
| 54 | UA text, |
| 55 | HTTPHeaders text, |
| 56 | KEY k1(ctime), |
| 57 | KEY k2(IP, ctime) |
| 58 | ) default charset=latin1", |
| 59 | "wfIssues" => "( |
| 60 | id int UNSIGNED NOT NULL auto_increment PRIMARY KEY, |
| 61 | time int UNSIGNED NOT NULL, |
| 62 | status varchar(10) NOT NULL, |
| 63 | type varchar(20) NOT NULL, |
| 64 | severity tinyint UNSIGNED NOT NULL, |
| 65 | ignoreP char(32) NOT NULL, |
| 66 | ignoreC char(32) NOT NULL, |
| 67 | shortMsg varchar(255) NOT NULL, |
| 68 | longMsg text, |
| 69 | data text |
| 70 | ) default charset=utf8", |
| 71 | "wfLeechers" => "( |
| 72 | eMin int UNSIGNED NOT NULL, |
| 73 | IP int UNSIGNED NOT NULL, |
| 74 | hits int UNSIGNED NOT NULL, |
| 75 | PRIMARY KEY k1(eMin, IP) |
| 76 | ) default charset=latin1", |
| 77 | "wfLockedOut" => "( |
| 78 | IP int UNSIGNED PRIMARY KEY, |
| 79 | blockedTime int UNSIGNED NOT NULL, |
| 80 | reason varchar(255) NOT NULL, |
| 81 | lastAttempt int UNSIGNED default 0, |
| 82 | blockedHits int UNSIGNED default 0 |
| 83 | ) default charset=utf8", |
| 84 | "wfLocs" => "( |
| 85 | IP int UNSIGNED NOT NULL PRIMARY KEY, |
| 86 | ctime int UNSIGNED NOT NULL, |
| 87 | failed tinyint UNSIGNED NOT NULL, |
| 88 | city varchar(255) default '', |
| 89 | region varchar(255) default '', |
| 90 | countryName varchar(255) default '', |
| 91 | countryCode char(2) default '', |
| 92 | lat float(10,7) default 0, |
| 93 | lon float(10,7) default 0 |
| 94 | ) default charset=utf8", |
| 95 | "wfLogins" => "( |
| 96 | id int UNSIGNED auto_increment PRIMARY KEY, |
| 97 | ctime DOUBLE(17,6) UNSIGNED NOT NULL, |
| 98 | fail tinyint UNSIGNED NOT NULL, |
| 99 | action varchar(40) NOT NULL, |
| 100 | username varchar(255) NOT NULL, |
| 101 | userID int UNSIGNED NOT NULL, |
| 102 | IP int UNSIGNED NOT NULL, |
| 103 | UA text, |
| 104 | KEY k1(IP, fail) |
| 105 | ) default charset=utf8", |
| 106 | "wfReverseCache" => "( |
| 107 | IP int UNSIGNED PRIMARY KEY, |
| 108 | host varchar(255) NOT NULL, |
| 109 | lastUpdate int UNSIGNED NOT NULL |
| 110 | ) default charset=latin1", |
| 111 | "wfScanners" => "( |
| 112 | eMin int UNSIGNED NOT NULL, |
| 113 | IP int UNSIGNED NOT NULL, |
| 114 | hits smallint UNSIGNED NOT NULL, |
| 115 | PRIMARY KEY k1(eMin, IP) |
| 116 | ) default charset=latin1", |
| 117 | "wfThrottleLog" => "( |
| 118 | IP int UNSIGNED NOT NULL PRIMARY KEY, |
| 119 | startTime int UNSIGNED NOT NULL, |
| 120 | endTime int UNSIGNED NOT NULL, |
| 121 | timesThrottled int UNSIGNED NOT NULL, |
| 122 | lastReason varchar(255) NOT NULL, |
| 123 | KEY k2(endTime) |
| 124 | ) default charset=utf8", |
| 125 | "wfStatus" => "( |
| 126 | ctime DOUBLE(17,6) UNSIGNED NOT NULL, |
| 127 | level tinyint UNSIGNED NOT NULL, |
| 128 | type char(5) NOT NULL, |
| 129 | msg varchar(1000) NOT NULL, |
| 130 | KEY k1(ctime), |
| 131 | KEY k2(type) |
| 132 | ) default charset=utf8", |
| 133 | 'wfNet404s' => "( |
| 134 | sig binary(16) NOT NULL PRIMARY KEY, |
| 135 | ctime int UNSIGNED NOT NULL, |
| 136 | URI varchar(1000) NOT NULL, |
| 137 | KEY k1(ctime) |
| 138 | ) default charset=utf8", |
| 139 | 'wfHoover' => "( |
| 140 | id int UNSIGNED auto_increment PRIMARY KEY, |
| 141 | owner text, |
| 142 | host text, |
| 143 | path text, |
| 144 | hostKey binary(4), |
| 145 | KEY k2(hostKey) |
| 146 | ) default charset=utf8", |
| 147 | 'wfFileQueue' => "( |
| 148 | id int UNSIGNED NOT NULL auto_increment PRIMARY KEY, |
| 149 | filename text |
| 150 | ) default charset=utf8" |
| 151 | ); |
| 152 | private $db = false; |
| 153 | private $prefix = 'wp_'; |
| 154 | public function __construct($dbhost = false, $dbuser = false, $dbpassword = false, $dbname = false){ |
| 155 | if($dbhost){ //for testing |
| 156 | $this->db = new wfDB(false, $dbhost, $dbuser, $dbpassword, $dbname); |
| 157 | $this->prefix = 'wp_'; |
| 158 | } else { |
| 159 | global $wpdb; |
| 160 | $this->db = new wfDB(); |
| 161 | $this->prefix = $wpdb->base_prefix; |
| 162 | } |
| 163 | } |
| 164 | public function dropAll(){ |
| 165 | foreach($this->tables as $table => $def){ |
| 166 | $this->db->query("drop table if exists " . $this->prefix . $table); |
| 167 | } |
| 168 | } |
| 169 | public function createAll(){ |
| 170 | foreach($this->tables as $table => $def){ |
| 171 | $this->db->query("create table IF NOT EXISTS " . $this->prefix . $table . " " . $def); |
| 172 | } |
| 173 | } |
| 174 | public function create($table){ |
| 175 | $this->db->query("create table IF NOT EXISTS " . $this->prefix . $table . " " . $this->tables[$table]); |
| 176 | } |
| 177 | public function drop($table){ |
| 178 | $this->db->query("drop table if exists " . $this->prefix . $table); |
| 179 | } |
| 180 | } |
| 181 | ?> |
| 182 |