| @@ 18-31 (lines=14) @@ | ||
| 15 | $user = Utilities::getAccount(); |
|
| 16 | $mysql = new _MySQL(); |
|
| 17 | $mysql->connect(Setup::$connectionArray); |
|
| 18 | if($host != ''){ |
|
| 19 | if($toggle==0){ |
|
| 20 | $mysql->runQuery(" |
|
| 21 | update blockLists |
|
| 22 | set isActive = '0' |
|
| 23 | where md5(host) = '".$mysql->escape($host)."'"); |
|
| 24 | }else{ |
|
| 25 | $mysql->runQuery(" |
|
| 26 | update blockLists |
|
| 27 | set isActive = '1' |
|
| 28 | where md5(host) = '".$mysql->escape($host)."'"); |
|
| 29 | } |
|
| 30 | exit(); |
|
| 31 | } |
|
| 32 | ||
| 33 | $sql = " |
|
| 34 | select * |
|
| @@ 218-235 (lines=18) @@ | ||
| 215 | $d = str_ireplace('https://', '', $d); |
|
| 216 | $d = str_ireplace('/', '', $d); |
|
| 217 | $d = preg_replace('/[[:^print:]]/', '', $d); |
|
| 218 | if($d != ''){ |
|
| 219 | $mysql->runQuery(" |
|
| 220 | update monitors set |
|
| 221 | keepOnUpdate = 1 |
|
| 222 | where |
|
| 223 | monitorGroupId = $monitorGroupId |
|
| 224 | and ipDomain = '".$mysql->escape($d)."' |
|
| 225 | and isDomain = 1 |
|
| 226 | "); |
|
| 227 | if($mysql->affectedRows == 0){ |
|
| 228 | $mysql->runQuery("insert ignore into monitors set |
|
| 229 | monitorGroupId = $monitorGroupId, |
|
| 230 | ipDomain = '".$mysql->escape($d)."', |
|
| 231 | isDomain = 1, |
|
| 232 | keepOnUpdate = 1 |
|
| 233 | "); |
|
| 234 | } |
|
| 235 | } |
|
| 236 | } |
|
| 237 | $mysql->runQuery("delete from monitors where keepOnUpdate = 0 and isDomain = 1 and monitorGroupId = $monitorGroupId"); |
|
| 238 | $mysql->close(); |
|