This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT u.url AS [Сайт], u.title AS [Заголовок], | |
DATETIME(v.visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch','localtime') AS [Дата] | |
FROM visits AS v | |
JOIN urls AS u ON v.url = u.id | |
ORDER BY v.visit_time |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# Asus Routers Exploit (ARE) | |
# Coded by : 4TT4CK3R # Category : Local and Remote | |
# Reuirements : Opening ports 80,8080,443 | |
# Models that affect : DSL-RT N13 | |
$ chmod ugo+x are2.sh #делает скрипт исполняемым | |
reset | |
dir = "/opt/" | |
rm -rf /opt/a.htm clear | |
echo "" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * FROM( | |
SELECT SUBSTR(mes.key_remote_jid, 1,12) AS [Контакт], DATETIME(SUBSTR(cal.timestamp , 1,10), 'unixepoch', 'localtime') AS [Дата], | |
TIME(cal.duration,'unixepoch') AS [Продолжительность], CASE mes.key_from_me | |
WHEN "1" THEN 'Набранный' | |
WHEN "0" THEN 'Принятый' | |
END AS [Тип] | |
FROM call_logs cal | |
JOIN messages mes ON mes._id = cal.message_row_id | |
Union all | |
SELECT SUBSTR(mes.key_remote_jid, 1,12) AS [Контакт], DATETIME(SUBSTR(mcall.timestamp , 1,10), 'unixepoch', 'localtime') AS [Дата], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * FROM (SELECT CASE mes.key_from_me | |
WHEN "1" THEN 'Сообщение пользователя' | |
WHEN "0" THEN 'Сообщение контакта' | |
END AS [Источник сообщения], | |
SUBSTR(mes.key_remote_jid, 1,12) AS [Контакт], data, | |
DATETIME(SUBSTR(mes.timestamp , 1,10), 'unixepoch', 'localtime') AS [Дата], media_caption AS [Подпись к медиа файлам], | |
mes.media_hash, NULL AS [Hex] | |
FROM messages mes | |
LEFT JOIN missed_call_logs mcl ON mes._id = mcl.message_row_id | |
WHERE mcl._id IS Null AND mes.key_id NOT LIKE 'call:%' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import time | |
import sys | |
from subprocess import Popen, PIPE #Для работы с командной строкой Windows. | |
class ExplorerProsess(): | |
def case(self): | |
print("Процессы какой порграммы вывести:") | |
p = input() | |
if p.lower().endswith('.exe'): |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.ComponentModel; | |
using System.Data; | |
using System.Drawing; | |
using System.Linq; | |
using System.Text; | |
using System.Threading.Tasks; | |
using System.Windows.Forms; | |
using System.Data.SQLite; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
------------Поиск по номеру и вывод сообщений--------------------------------------------- | |
SELECT CASE type | |
WHEN '1' THEN 'Принятый' | |
WHEN '2' THEN 'Набранный' | |
WHEN '3' THEN 'Пропущенный' | |
END AS [Тип], | |
number,DATETIME(SUBSTR(date , 1,10), 'unixepoch', 'localtime') AS [Дата], TIME(duration,'unixepoch') AS [Продолжительность] | |
FROM calls | |
WHERE calls.canonized_number = '*************'--фильтруем таблицу по номеру |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
------------Поиск по номеру и вывод сообщений--------------------------------------------- | |
SELECT par_inf.number AS [Номер],par_inf.contact_name AS [Имя],mes.body AS [Сообщение], | |
DATETIME(SUBSTR(mes.msg_date , 1,10), 'unixepoch', 'localtime') AS [Дата]/*так как в ячейке mes.msg_date содержется дата и время в секундах, преобразуем его в | |
читабельный формат и выбор времени для текущей локации */ | |
FROM conversations AS con | |
JOIN messages AS mes ON con._id = mes.conversation_id | |
JOIN participants AS par ON par.conversation_id = con._id | |
JOIN participants_info AS par_inf ON par.participant_info_id = par_inf._id | |
WHERE par_inf.number = '*************'-- фильтруем таблицу по номеру | |
ORDER BY mes.msg_date DESC--устанавливает порядок сортирования по убыванию, от больших значений к меньшим |