App for connecting to zKillboard websocket, listen to kill stream and pushing kill mails to TELEGRAM channels by having events related to different categories
- PHP =>7.3.2
- PostgreSQL
TODO
CREATE TABLE public.killmails
(
attackers json NOT NULL,
victim json NOT NULL,
killmail_id bigint NOT NULL,
solar_system_id bigint NOT NULL,
war_id bigint,
victim_id bigint,
killmail_time timestamp without time zone,
hash text COLLATE pg_catalog."default" NOT NULL,
CONSTRAINT killmails_pkey PRIMARY KEY (killmail_id)
)
CREATE TABLE public.killmail_subscriber
(
scope text COLLATE pg_catalog."default" NOT NULL,
driver text COLLATE pg_catalog."default" NOT NULL,
chat_id text COLLATE pg_catalog."default" NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
id integer NOT NULL DEFAULT nextval('killmail_subscriber_id_seq'::regclass)
)
By default app creating events related for different values in kill mail like character id, corporation id,alliance id,
solar system id, war id and ship type id
attackers:alliance_id:{id}
attackers:corporation_id:{id}
attackers:character_id:{id}
attackers:faction_id:{id}
attackers:ship_type_id:{id}
victim:alliance_id:{id}
victim:corporation_id:{id}
victim:character_id:{id}
victim:ship_type_id:{id}
space:solar_system_id:{id}
war_id:{id}
For having killmail pushed to telegram you need to have record in killmail_subscriber table.
Like this:
scope | driver | chat_id | created_at | updated_at | id
--------------------------------+----------+------------+----------------------------+----------------------------+----
attackers:alliance_id:99009584 | telegram | -323123241 | 2020-01-14 14:05:35.973328 | 2020-01-14 14:05:35.973328 | 2
Where scope = your event, driver = at this moment doesnt matter, i have this in case if i want to extend amount of services
, chat_id = where you want to send kill