.html

<ion-header>
  <ion-toolbar color="primary" mode="ios">
      <ion-buttons slot="start">
          <ion-back-button mode="ios"></ion-back-button>
      </ion-buttons>
      <ion-title>
          快速定位
      </ion-title>
      <ion-buttons slot="end">
          <ion-button icon-only (click)="backHome()">
              <ion-icon name="home"></ion-icon>
          </ion-button>
      </ion-buttons>
  </ion-toolbar>

  <ion-slides #slider class="top_slides" pager="false" [options]="slideOpts">
    <ion-slide *ngFor="let slide of slides; let i = index;" (click)="changeCurrentTab(i)">
      <span [ngClass]="{'high-light': i == current_tab}"  class="slide-title-unit"> {{slide}} </span>
    </ion-slide>
  </ion-slides>

</ion-header>


<ion-content scrollEvents="true" (ionScrollEnd)="contentScroll($event)">
  <ion-card class="section_0">
    <ion-card-content>
      第一部分
    </ion-card-content>
  </ion-card>
  <ion-card class="section_1">
    <ion-card-content>
      第二部分
    </ion-card-content>
  </ion-card>
  <ion-card class="section_2">
    <ion-card-content>
      第三部分
    </ion-card-content>
  </ion-card>
  <ion-card class="section_3">
    <ion-card-content>
      第四部分
    </ion-card-content>
  </ion-card>
  <ion-card class="section_4">
    <ion-card-content>
      第五部分
    </ion-card-content>
  </ion-card>
  <ion-card class="section_5">
    <ion-card-content>
      第六部分
    </ion-card-content>
  </ion-card>
  <ion-card class="section_6">
    <ion-card-content>
      第七部分
    </ion-card-content>
  </ion-card>
</ion-content>

.ts

import { Component, OnInit, ElementRef,ViewChild} from '@angular/core';
import { ActivatedRoute } from '@angular/router';

@Component({
  selector: 'app-fast-positioning',
  templateUrl: './fast-positioning.page.html',
  styleUrls: ['./fast-positioning.page.scss'],
})
export class FastPositioningPage implements OnInit {

  //反向快速定位解决方案
  // 页面滚动时动态更新TAB的高亮状态
  // 1.需要在constructor 中声明 private elementRef: ElementRef,
  // 2.把HTML模板中的每一个区块加上class="section_*"（不要用ID）
  // 3. ion-content 加属性 <ion-content scrollEvents="true" (ionScrollEnd)="contentScroll($event)">
  @ViewChild("slider", { static: false }) private slider;
  contentScroll(e) {
    let sections = this.elementRef.nativeElement.querySelectorAll(
      "[class^=section]"
    );
    const header_height = (this.elementRef.nativeElement.querySelector(
      "ion-header"
    ) as HTMLElement).offsetHeight;
    for (let index = 0; index < sections.length; index++) {
      if (sections[index].getBoundingClientRect().bottom >= header_height) {
        this.slider.slideTo(index);
        this.current_tab = index;
        break;
      }
    }
  }

  //快速定位
  public slides: any[] = [
    "第一部分",
    "第二部分",
    "第三部分",
    "第四部分",
    "第五部分",
    "第六部分",
    "第七部分",
  ];

  //默认显示第一个tab
  public current_tab: any = 0;

  //页面状态
  public pageType:string;

  constructor(
    public route: ActivatedRoute,
    private elementRef: ElementRef,
  ) {
    
  }

  ngOnInit() {
  }

  ionViewDidEnter(){
     //取值
     this.route.queryParams.subscribe((data) => {
      this.pageType = data.type;
    });
  }

  changeCurrentTab(index: any) {
    this.current_tab = index;
    this.scrollIntoView(index);
  }

  scrollIntoView(id: string) {
    let element = this.elementRef.nativeElement.querySelector(`.section_${id}`);
    if (element) {
      element.scrollIntoView();
    }
  }
}


 

定位模式为PAGE_CUR_L，反向定位,想定位到最后一行然后使用handler::ha_index_prev扫描上一行。
但是5.7的代价比8.0的逆序索引高。
- 0x4e    0x20 为20000
```
mysql> desc  select * from sortdescpart1 where a1=4 and a2>100 and a2<20000 order by a2  desc limit 10 ;
+----+-------------+---------------+------------+-------+---------------+------+---------+------+-------+----------+-----------------------+
| id | select_type | table         | partitions | type  | possible_keys | key  | key_len | ref  | rows  | filtered | Extra                 |
+----+-------------+---------------+------------+-------+---------------+------+---------+------+-------+----------+-----------------------+
|  1 | SIMPLE      | sortdescpart1 | p5         | range | a1            | a1   | 10      | NULL | 15151 |   100.00 | Using index condition |
+----+-------------+---------------+------------+-------+---------------+------+---------+------+-------+----------+-----------------------+
1 row in set, 1 warning (2.92 sec)
*************************** 1. row ***************************
Table: sortdescpart1
Create Table: CREATE TABLE `sortdescpart1` (
`id` int(11) DEFAULT NULL,
`a1` int(11) DEFAULT NULL,
`a2` int(11) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL,
KEY `a1` (`a1`,`a2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (a1)
(PARTITION p1 VALUES LESS THAN (1) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (2) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (3) ENGINE = InnoDB,
PARTITION p4 VALUES LESS THAN (4) ENGINE = InnoDB,
PARTITION p5 VALUES LESS THAN (5) ENGINE = InnoDB,
PARTITION p6 VALUES LESS THAN (6) ENGINE = InnoDB,
PARTITION p7 VALUES LESS THAN (7) ENGINE = InnoDB,
PARTITION p8 VALUES LESS THAN (8) ENGINE = InnoDB,
PARTITION p9 VALUES LESS THAN (9) ENGINE = InnoDB,
PARTITION p10 VALUES LESS THAN (10) ENGINE = InnoDB,
PARTITION p11 VALUES LESS THAN (11) ENGINE = InnoDB) */
```
定位：
```
#0  btr_cur_search_to_nth_level (index=0x7ffebd313ae0, level=0, tuple=0x7ffebd2cd118, mode=PAGE_CUR_L, latch_mode=1, cursor=0x7ffebd2d0a68, has_search_latch=0,
file=0x22b7150 "/home/mysql/soft/percona-server-5.7.29-32/storage/innobase/row/row0sel.cc", line=5274, mtr=0x7fffe83ddaf0)
at /home/mysql/soft/percona-server-5.7.29-32/storage/innobase/btr/btr0cur.cc:798
#1  0x0000000001af45c4 in btr_pcur_open_with_no_init_func (index=0x7ffebd313ae0, tuple=0x7ffebd2cd118, mode=PAGE_CUR_L, latch_mode=1, cursor=0x7ffebd2d0a68, has_search_latch=0,
file=0x22b7150 "/home/mysql/soft/percona-server-5.7.29-32/storage/innobase/row/row0sel.cc", line=5274, mtr=0x7fffe83ddaf0)
at /home/mysql/soft/percona-server-5.7.29-32/storage/innobase/include/btr0pcur.ic:544
#2  0x0000000001afedb9 in row_search_mvcc (buf=0x7ffebd2c9ee0 "\377", mode=PAGE_CUR_L, prebuilt=0x7ffebd2cccf0, match_mode=0, direction=0)
at /home/mysql/soft/percona-server-5.7.29-32/storage/innobase/row/row0sel.cc:5272
#3  0x0000000001961dfa in ha_innobase::index_read (this=0x7ffebd2c9860, buf=0x7ffebd2c9ee0 "\377", key_ptr=0x7ffebcd312b0 "", key_len=10, find_flag=HA_READ_BEFORE_KEY)
at /home/mysql/soft/percona-server-5.7.29-32/storage/innobase/handler/ha_innodb.cc:9970
#4  0x0000000000eb8e04 in handler::index_read_map (this=0x7ffebd2c9860, buf=0x7ffebd2c9ee0 "\377", key=0x7ffebcd312b0 "", keypart_map=3, find_flag=HA_READ_BEFORE_KEY)
at /home/mysql/soft/percona-server-5.7.29-32/sql/handler.h:2990
#5  0x000000000199246c in ha_innopart::index_read_map_in_part (this=0x7ffebd2c9860, part=4, record=0x7ffebd2c9ee0 "\377", key=0x7ffebcd312b0 "", keypart_map=3,
find_flag=HA_READ_BEFORE_KEY) at /home/mysql/soft/percona-server-5.7.29-32/storage/innobase/handler/ha_innopart.cc:2221
#6  0x00000000013d38e8 in Partition_helper::handle_ordered_index_scan (this=0x7ffebd2c9d60, buf=0x7ffebd2c9ee0 "\377")
at /home/mysql/soft/percona-server-5.7.29-32/sql/partitioning/partition_handler.cc:3286
#7  0x00000000013d2360 in Partition_helper::common_index_read (this=0x7ffebd2c9d60, buf=0x7ffebd2c9ee0 "\377", have_start_key=true)
at /home/mysql/soft/percona-server-5.7.29-32/sql/partitioning/partition_handler.cc:2583
#8  0x00000000013d20bb in Partition_helper::ph_index_read_map (this=0x7ffebd2c9d60, buf=0x7ffebd2c9ee0 "\377", key=0x7ffebcd312b0 "", keypart_map=3, find_flag=HA_READ_BEFORE_KEY)
at /home/mysql/soft/percona-server-5.7.29-32/sql/partitioning/partition_handler.cc:2497
#9  0x00000000019980db in ha_innopart::index_read_map (this=0x7ffebd2c9860, buf=0x7ffebd2c9ee0 "\377", key=0x7ffebcd312b0 "", keypart_map=3, find_flag=HA_READ_BEFORE_KEY)
at /home/mysql/soft/percona-server-5.7.29-32/storage/innobase/handler/ha_innopart.h:1317
#10 0x0000000000ea9ead in handler::ha_index_read_map (this=0x7ffebd2c9860, buf=0x7ffebd2c9ee0 "\377", key=0x7ffebcd312b0 "", keypart_map=3, find_flag=HA_READ_BEFORE_KEY)
at /home/mysql/soft/percona-server-5.7.29-32/sql/handler.cc:3261
#11 0x0000000001725fda in QUICK_SELECT_DESC::get_next (this=0x7ffebc002c90) at /home/mysql/soft/percona-server-5.7.29-32/sql/opt_range.cc:11604
#12 0x00000000013d82ff in rr_quick (info=0x7ffebcd2eac8) at /home/mysql/soft/percona-server-5.7.29-32/sql/records.cc:406
#13 0x00000000014767dc in join_init_read_record (tab=0x7ffebcd2ea78) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_executor.cc:2507
#14 0x0000000001473949 in sub_select (join=0x7ffebcd2d020, qep_tab=0x7ffebcd2ea78, end_of_records=false) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_executor.cc:1284
#15 0x00000000014732dc in do_select (join=0x7ffebcd2d020) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_executor.cc:957
#16 0x0000000001471243 in JOIN::exec (this=0x7ffebcd2d020) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_executor.cc:206
#17 0x000000000150d2d5 in handle_query (thd=0x7ffebc012a40, lex=0x7ffebc0150f0, result=0x7ffebcd2c8e0, added_options=0, removed_options=0)
at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_select.cc:192
#18 0x00000000014c1097 in execute_sqlcom_select (thd=0x7ffebc012a40, all_tables=0x7ffebc021d48) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_parse.cc:5490
#19 0x00000000014ba323 in mysql_execute_command (thd=0x7ffebc012a40, first_level=true) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_parse.cc:3016
#20 0x00000000014c2025 in mysql_parse (thd=0x7ffebc012a40, parser_state=0x7fffe83e04a0, update_userstat=false) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_parse.cc:5927
#21 0x00000000014b6c5f in dispatch_command (thd=0x7ffebc012a40, com_data=0x7fffe83e0c90, command=COM_QUERY) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_parse.cc:1539
#22 0x00000000014b5a94 in do_command (thd=0x7ffebc012a40) at /home/mysql/soft/percona-server-5.7.29-32/sql/sql_parse.cc:1060
#23 0x00000000015e9d32 in handle_connection (arg=0x63a8fb0) at /home/mysql/soft/percona-server-5.7.29-32/sql/conn_handler/connection_handler_per_thread.cc:325
#24 0x00000000018b97f2 in pfs_spawn_thread (arg=0x6359f60) at /home/mysql/soft/percona-server-5.7.29-32/storage/perfschema/pfs.cc:2198
#25 0x00007ffff7bc6ea5 in start_thread () from /lib64/libpthread.so.0
#26 0x00007ffff5f2b8dd in clone () from /lib64/libc.so.6
(gdb) p *tuple->fields
$12 = {data = 0x7ffebd2ccf08, ext = 0, spatial_status = 3, len = 4, type = {prtype = 1027, mtype = 6, len = 4, mbminmaxlen = 0}}
(gdb) x/16bx 0x7ffebd2ccf08
0x7ffebd2ccf08: 0x80    0x00    0x00    0x04    0x80    0x00    0x4e    0x20
0x7ffebd2ccf10: 0x80    0x00    0x00    0x04    0x80    0x00    0x4e    0x20

我这里只说针对我的问题以及我的解决办法：



因为使用windet过久之后会无意中点击了最下方栏中"--src"，如果这一栏没有了，双击sumatrapdf并不会反向定位到windet中。


	
 
	

文章目录
前言
解决过程
利用日志文件反向定位
后记

前言
前段时间给用discuz框架搭了个在线论坛(搭建过程)，由于discuz框架是开源的， 用起来也比较方便，所以用户基础还是挺多的。但这个框架的洞也比较多，经常被打…我那个论坛连域名还没解析，不知道咋被盯上的。直接从论坛变成了线上赌场… 就是输入地址能正常打开论坛，但是点击按钮之后就会跳转到如下博彩页面。


解决过程
今天有空上午一边查资料一边找web大佬帮忙弄了一下

先查了下相关资料

然后推测他的跳转网址应该写进了服务器某个文件里面，于是用他的网址进行grep搜索，命令如下
grep 'XXX.cn' -r ./

然后找到了他挂马的地方，也就修改了一下跳转，估计是用哪个discuz的洞getshell来打的，看了下log发现还打了好几天…(不过这意识估计不是专业出身，log文件都没动，连扫描的IP都不加代理，后面直接能通过IP反向定位他)

然后修改一下重定向代码(修改完要删一下浏览器对该网站的记录，不然又缓存还会跳转)



之后再重新点击就能正常显示了。
利用日志文件反向定位
前面说到攻击者很水，基本的意识都没有。查了一下access.log日志可以很明显的看到扫描记录，顺藤摸瓜就能查到攻击者的IP地址。



通过这一条可以看到攻击者的IP地址！！他竟然代理都不挂，真的头铁。

通过这个ip地址就能定位到攻击者地区(具体过程不说了,放一张大致的定位图)


后记
考完试放假明天就出去浪了，本来还想报个案把这个赌场打了的，但也没造成什么损失就不想太麻烦了。出于种种原因，很多细节写不了。大家看着就图个乐，最后还想提醒大家一下：嫌疑人定位在云南，并不是所谓的缅甸境外，网页做的再好看也是骗人的，网络赌博不可信，希望大家能警惕网络犯罪，远离杀猪盘！