summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-ipb_range_start.sql
blob: c31e2d9cc919ebe8a3f2e841e49458247dc7a917 (plain)
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
-- Add the range handling fields
ALTER TABLE /*$wgDBprefix*/ipblocks 
  ADD ipb_range_start varchar(32) NOT NULL default '',
  ADD ipb_range_end varchar(32) NOT NULL default '',
  ADD INDEX ipb_range (ipb_range_start(8), ipb_range_end(8));


-- Initialise fields
-- Only range blocks match ipb_address LIKE '%/%', this fact is used in the code already
UPDATE /*$wgDBprefix*/ipblocks 
  SET 
    ipb_range_start = LPAD(HEX( 
        (SUBSTRING_INDEX(ipb_address, '.', 1) << 24)
      + (SUBSTRING_INDEX(SUBSTRING_INDEX(ipb_address, '.', 2), '.', -1) << 16)
      + (SUBSTRING_INDEX(SUBSTRING_INDEX(ipb_address, '.', 3), '.', -1) << 24)
      + (SUBSTRING_INDEX(SUBSTRING_INDEX(ipb_address, '/', 1), '.', -1)) ), 8, '0' ),

    ipb_range_end = LPAD(HEX( 
        (SUBSTRING_INDEX(ipb_address, '.', 1) << 24)
      + (SUBSTRING_INDEX(SUBSTRING_INDEX(ipb_address, '.', 2), '.', -1) << 16)
      + (SUBSTRING_INDEX(SUBSTRING_INDEX(ipb_address, '.', 3), '.', -1) << 24)
      + (SUBSTRING_INDEX(SUBSTRING_INDEX(ipb_address, '/', 1), '.', -1))
      + ((1 << (32 - SUBSTRING_INDEX(ipb_address, '/', -1))) - 1) ), 8, '0' )

  WHERE ipb_address LIKE '%/%';