· 7 years ago · Oct 13, 2018, 08:48 PM
1--First install tamper monkey, iitc(ingress Intel total conversion), add one of the export scripts to tamper monkey. Do not run this if you don't understand what it does, I'm not responsible for you breaking your database.
2
3CREATE DATABASE IF NOT EXISTS ingress;
4USE ingress;
5
6CREATE TABLE IF NOT EXISTS ingress_portals (
7 id int(11) NOT NULL AUTO_INCREMENT,
8 external_id varchar(35) DEFAULT NULL,
9 lat double(18,14) DEFAULT NULL,
10 lon double(18,14) DEFAULT NULL,
11 name varchar(128) DEFAULT NULL,
12 url varchar(200) DEFAULT NULL,
13 updated bigint(11) NOT NULL,
14 imported BIGINT NULL DEFAULT NULL,
15 PRIMARY KEY (id),
16 UNIQUE KEY external_id (external_id)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1;
18
19--Stop and paste gyms/stops scraped from ingress intel scraper at this point
20
21UPDATE rdmdb.gym rdmdb, ingress.ingress_portals ingress SET rdmdb.name = ingress.name, rdmdb.url = ingress.url WHERE rdmdb.id = ingress.external_id;