Whatsapp database structure 

 1 Message
 2 _id: integer #
 3 key_remote_jid: text #Identificador da conversa (-1 se de nenhuma)
 4 key_from_me: integer #1 para mensagens minhas, 0 para mensagens de terceiros
 5 key_id: text # identificador
 6 status: integer #[0,4,5,6,8,10] 
 7 #0,10 Não enviado por mim
 8 #4,5,6,8  Enviado por mim
 9 #4 enviado para grupos conseituais(nem sempre reais) 
10 #5 para PVT
11 #6 Criação de grupos, adições de usuários
12 #8 Envio áudio
13 #10 envio de áudio
14 needs_push: integer #
15 data: text #Texto se foi uma conversa
16 timestamp: integer #data de criação (unix)
17 media_url: text #URL para download externo da mídia
18 media_mime_type: text #tipo da mídia
19 media_wa_type: text #[1,2,3,4,5]: 0 - Texto ou evento do WA,1- imagem, 2-audío,  3 - Vídeo, 4-Contato, 5-Localização
20 media_size: integer #tamanho da mídia (se áudio ou vídeo)
21 media_name: text #nome da mídia se existir
22 media_hash: text #ID da mídia
23 media_duration: integer #duração se 2 ou 3
24 origin: integer #[1,2,3]: 2 não recebidas pelo server e normalmente midia, 
25 latitude:  # se localização
26 longitude:  # se localização
27 thumb_image: text # endereço da miniatura
28 remote_resource: text #ID do usuário caso este esteja em um grupo (tanto meu quanto de terceiros)
29 #para caso de PVT o valor poder ser nulo (me) ou blank (others)
30 received_timestamp: integer #data de recebimento (unix)
31 send_timestamp: integer #data de envio (unir)
32 receipt_server_timestamp: integer #data de recebimento no servidor
33 receipt_device_timestamp: integer #data de recebimento no dispositivo (-1 se eu enviei)
34 raw_data: binary #caso mídia os dados
35 recipient_count: integer)  #quantidade de usuários do grupo que receberam minha mensagem
36 
37 
38 
39 ChatList
40 _id: integer #
41 key_remote_jid: text #
42 message_table_id: integer #
43 subject: text #
44 creation: integer #

Comentários

Postar um comentário

Postagens mais visitadas deste blog

Rails CanCan

CanCan is an authorization library for Ruby on Rails which restricts what resources a given user is allowed to access. All permissions are defined in a single location (the Ability class) and not duplicated across controllers, views, and database queries. Installation In Rails 3 , add this to your Gemfile and run the bundle command. gem "cancan" In Rails 2 , add this to your environment.rb file. config.gem "cancan" Alternatively, you can install it as a plugin. rails plugin install git://github.com/ryanb/cancan.git Getting Started CanCan expects a current_user method to exist in the controller. First, set up some authentication (such as Authlogic or Devise ). See Changing Defaults if you need different behavior. 1. Define Abilities User permissions are defined in an Ability class. CanCan 1.5 includes a Rails 3 generator for creating this class. rails g cancan:ability In Rails 2.3, just add a new class in `app/models/ability.rb` with
Leia mais

Meus insights mais valiosos sobre criptomoedas para 2018 e além

Since I started to study the crypto world, I spent hundreds and hundreds of hours — if not thousands — collecting, assimilating, and reflecting on everything I could in order to better understand this market (virus?) that fascinates me more everyday. I found extremely valuable information that I would like to share with you today.  Whether you are a newbie or a veteran in the crypto space, I hope that by the end of this post you will get new perspectives,   and ideas you’ve never heard or thought about before . “The most valuable type of economists are cryptoeconomists, as they can actually create, manage, and analyze economies.” — Naval Ravikant In case you want to directly jump to a section, the post is composed of 8 parts: Decentralized Exchange Protocols Will Be Game Changers Coinbase (and The Other Centralized Exchanges) Have HUGE Opportunities To Evolve Protocols and Scalability: In Progress… But Still Waiting For The Killer Apps Crypto Geopolitics: Why The Crypto W
Leia mais

Como pegar a senha do Whatsapp de um Android ou Iphone

Imagem
WhatsApp is a very popular SMS-like messenger for smartphones, but it’s unfortunately only available for smartphones right now. If you want to use other tools or write web applications that send or receive WhatsApp messages (e.g. WhatsAPI ), you have to find a way to sniff the WhatsApp password from your smartphone. Until recently, this password was just an MD5 hash of your IMEI (or MAC address), but that has changed when that was uncovered. Since then, the WhatsApp server assigns a password to each device/account when it first registers. This tutorial demonstrates how to capture the WhatsApp password of your WhatsApp account using the SSL/TLS proxy mitmproxy . Once you have this password, you can use it to communicate with the WhatsApp servers directly or via a framework. This is the first part of a two-part tutorial. The second part demonstrates how to send and receive WhatsApp messages via PHP . Contents Updates 1. Introduction 1.1. Please note:
Leia mais