Author Information
Name: Shutter Zor锛堝乏绁ュお锛?br>Email: Shutter_Z@outlook.com

鐩綍

• 0 鑳屾櫙

• 1 瀵笰pple涓嶢ndroid鐨勪笉鍚屽鐞嗘柟娉?/p>

• 2 灏嗗浠芥枃浠舵嫹璐濊嚦鐢佃剳

• 3 瑙ｅ瘑鏁版嵁搴?/p>

• 4 瀵煎嚭鏁版嵁

• 5 娓呮礂鏁版嵁

• 6 缁撴灉

• 鍙傝€冭祫鏂?/p>

姝ｆ枃

0 鑳屾櫙

鏈€杩戞崏鎽哥潃寰皟涓€涓ぇ璇█妯″瀷锛圠arge Language Model锛?strong>LLM锛夛紝瀵绘€濈潃鎶婁竴浜涚鍗氫氦娴佸井淇＄兢鐨勮亰澶╀俊鎭兘瀵煎嚭锛岀劧鍚庝綔涓哄井璋冪殑棰勬枡涓婅浇鑷冲師濮嬫ā鍨嬶紝鎵€浠ュ氨鍋氫簡涓€浜涜鏂欐暣鐞嗙殑宸ヤ綔銆?/p>

鍦ㄥ鍑哄井淇￠鏂欑殑杩囩▼褰撲腑锛屼篃鍑虹幇浜嗕竴浜涢潪甯告湁鎰忔€濈殑浜嬫儏锛屾晠绠€鍗曞仛涓€浜涜褰曘€?/p>

1 瀵笰pple涓嶢ndroid鐨勪笉鍚屽鐞嗘柟娉?/h2>

涓嶅緱涓嶈锛屽鑻规灉鎵嬫満鐨勫鐞嗙‘瀹炲湪姝ラ涓婁細绠€鍗曞緢澶氾紝鐩存帴閫氳繃鐖辨€濆姪鎵?iTools鍏ㄥ浠絠Phone涔嬪悗锛屾敮鎸佸鍑虹函鏂囨湰鏍煎紡鐨勮亰澶╄褰曪紙鏉ヨ嚜浜掕仈缃戠殑璇存硶锛屾湭楠岃瘉锛夈€?/p>

瀵逛簬Android鎵嬫満锛屽垯闇€瑕佸厛鑾峰彇鍔犲瘑鏁版嵁搴撴枃浠躲€傝繖涓€姝ュ彲鑳介渶涓嶉渶瑕乺oot鏉冮檺鍙栧喅浜庝綘鐨勬墜鏈烘槸鍚︽彁渚涗簡寰俊鐨勬暟鎹浠藉姛鑳姐€?/p>

鎴戜娇鐢ㄧ殑鏄?strong>灏忕背MIX4锛岄€氳繃锛氳缃煈夋垜鐨勮澶囸煈夊浠戒笌鎭㈠馃憠鎵嬫満澶囦唤鎭㈠锛岃緭鍏ラ攣灞忓瘑鐮佸悗灏辫兘鐩存帴澶囦唤寰俊鑱婂ぉ鐨勬暟鎹俊鎭€?/p>

鎵€浠ユ帴涓嬫潵灏嗕互灏忕背MIX4涓轰緥璁茶В鑱婂ぉ鏁版嵁瀵煎嚭鐨勬柟娉曘€?/p>

2 灏嗗浠芥枃浠舵嫹璐濊嚦鐢佃剳

鍦?strong>灏忕背MIX4涓紝澶囦唤鍚庣殑鏁版嵁浼氫互.bak鐨勬枃浠跺舰寮忓瓨鍌ㄤ笌锛氭枃浠剁鐞嗮煈夋墜鏈吼煈塎IUI馃憠backup馃憠AllBackup馃憠澶囦唤鏃堕棿锛?0230719_101011锛夝煈夊井淇?com.tencent.mm).bak

灏嗚繖浠?code>.bak鏂囦欢鎷疯礉鑷崇數鑴戯紝骞朵娇鐢?strong>7zip杩涜瑙ｅ帇銆備竴瀹氳浣跨敤7zip瑙ｅ帇锛屼娇鐢?strong>Bandizip瑙ｅ帇浼氭樉绀烘枃浠跺凡鎹熷潖锛屼粠鑰屾棤娉曟壘鍒版纭殑鏁版嵁淇℃伅銆?/p>

灏?code>.bak鏂囦欢瑙ｅ帇涓烘枃浠跺す鍚庯紝鍦ㄦ枃浠跺す锛氬井淇?com.tencent.mm)馃憠apps馃憠com.tencent.mm馃憠r馃憠MicroMsg涓嬶紝浼氭湁寰堝鏁板瓧鍔犲瓧姣嶇粍鍚堢殑澶ф枃浠跺す锛屼唬琛ㄧ潃涓嶅悓鐨勫井淇″彿锛屽崰鐢ㄥ唴瀛樻渶澶х殑涓轰綘鐨勫父鐢ㄥ井淇″彿銆?/p>

鍦ㄨ繖涓敤鎴蜂笅锛屼細鏈変竴浜涙枃浠讹紝鍏朵腑EnMicroMsg.db涓哄姞瀵嗙殑鑱婂ぉ淇℃伅鏁版嵁銆?/p>

3 瑙ｅ瘑鏁版嵁搴?/h2>

涓嬭浇sqlcipher杞欢锛岀敤浜庤鍙栨暟鎹簱鏂囦欢锛岃鍙栧悗鍙戠幇闇€瑕佸瘑鐮佹墠鑳芥墦寮€EnMicroMsg.db銆?/p>

闇€瑕佽幏鍙栦綘鏁版嵁搴撶殑涓撳睘瀵嗙爜锛岃繖涓彇鍐充簬浣犲井淇＄涓€娆＄櫥闄嗙殑璁惧鐨勪俊鎭互鍙?strong>default_uin鐨勫€笺€?/p>

鍥炲埌锛氬井淇?com.tencent.mm)馃憠apps馃憠com.tencent.mm馃憠sp锛屾壘鍒?code>system_config_prefs.xml骞舵墦寮€锛岄噷闈㈣褰曚簡default_uin銆?/p>

棣栧厛鑰冭檻浣跨敤1234567890ABCDEF鍔?strong>default_uin鐨勫€硷紝浣跨敤MD5杩涜鍔犲瘑锛岃幏鍙栧姞瀵嗗悗鐨?2浣峓灏廬鐨勫€肩殑鍓嶄竷浣嶄綔涓哄瘑鐮侊紝鐪嬬湅鑳藉惁鎵撳紑鏁版嵁搴撱€傛瘮濡備綘鐨?strong>IMEI鐮?/strong>涓?234567890ABCDEF锛?strong>default_uin涓?234567890锛屽垯浣犻渶瑕佸皢1234567890ABCDEF1234567890涓€鍚屼娇鐢?strong>MD5鍔犲瘑銆?/p>

濡傛灉涓嶈兘锛屽垯闇€瑕佸湪鎵嬫満涓婅緭鍏?#06#锛屾煡鐪嬫墜鏈虹殑IMEI鐮?/strong>锛屼竴鑸湁涓や釜锛岄兘閲嶅涓婇潰鐨勬楠わ紝涓?strong>default_uin鐨勫€肩洿鎺ユ嫾鎺ュ悗鍙栧姞瀵嗗悗鐨?2浣峓灏廬鐨勫€肩殑鍓嶄竷浣嶄綔涓哄瘑鐮侊紝杩欎笁绉嶅瘑鐮佹€绘湁涓€涓兘鎵撳紑浣犵殑杩欎釜鏁版嵁搴撱€?/p>

4 瀵煎嚭鏁版嵁

鑳藉鎵撳紑鏁版嵁搴撲箣鍚庯紝渚濇鐐瑰紑sqlcipher涓殑File馃憠export馃憠Table as CSV File锛岄€夋嫨灏?strong>message琛ㄦ牸瀵煎嚭涓?code>.csv鏂囦欢銆?/p>

鍦ㄨ繖涓€姝ユ垜鑾峰緱浜嗕竴涓?15M鐨勬枃浠讹紝褰撶劧锛岃繖涓噷闈㈠寘鍚簡浣犳墜鏈轰笂鎵€鏈夌殑寰俊娑堟伅锛屽寘鎷帹閫佺瓑銆?/p>

600澶歁鐨?code>.csv鏂囦欢锛?strong>Excel鏃犳硶鐩存帴澶勭悊锛屾墍浠ヨ浆鐢?strong>Python杩涜鏁版嵁娓呮礂涓庡鍑恒€?/p>

5 娓呮礂鏁版嵁

鏍规嵁鍙橀噺鍚嶇О浠ュ強鍐呭绠€鍗曠寽娴嬪彉閲忕殑鍚箟鍚庯紝浣跨敤Python杩涜娓呮礂锛屼唬鐮佸涓嬨€?/p>

# -*- coding: utf-8 -*-
"""
Created on Wed Jul 19 13:25:03 2023

@author: Shutter Zor
@blog:   shutterzor.cn
@email:  Shutter_Z@outlook.com
"""

import re
import pandas as pd

# 璇诲叆csv鏂囦欢
Msg = pd.read_csv(Msg.csv, encoding=latin1)

# 淇濈暀鏈夋晥鍒?/span>
MsgNew = Msg.loc[:,[msgId, msgSvrId, type, isSend, createTime, talker, content, talkerId]]

# 浠呬繚鐣欒亰澶╂枃鏈俊鎭?/span>
MsgNew = MsgNew[MsgNew[type] == 1]

# 閲嶇疆绱㈠紩
MsgNew.reset_index(drop=True, inplace=True)

# 浠呬繚鐣欑兢鑱婁俊鎭?/span>
for line in range(len(MsgNew)):
    if len(re.findall(d+@chatroom, MsgNew.loc[line, talker])) > 0 :
        MsgNew.loc[line, isChatroom] = 1

MsgNew = MsgNew[MsgNew[isChatroom] == 1]

# 閲嶇疆绱㈠紩
MsgNew.reset_index(drop=True, inplace=True)

for line in range(len(MsgNew)):
    MsgNew.loc[line, content] = MsgNew.loc[line, content].encode(latin1).decode(gbk, errors=ignore)

# 瀵煎嚭淇濆瓨鏆傛椂鐗?/span>
MsgNew.to_csv(tempClean.csv, index=False, encoding=gbk)

鍦ㄨ繖涓€姝ヤ腑锛屾垜淇濈暀浜嗕竴浜涘鎴戣€岃█鏆傛椂鏈夌敤鐨勫彉閲忥細[msgId, msgSvrId, type, isSend, createTime, talker, content, talkerId]锛岃繖鍒嗗埆琛ㄧず鐫€瀵瑰簲淇℃伅鐨処D銆佹秷鎭殑绫诲瀷銆佹槸鍚︿负鍙戦€佷汉銆佸彂閫佹椂闂淬€佸潶绾冲崕瀵硅薄銆佹秷鎭唴瀹癸紝浠ュ強璋堣瘽浜篒D銆?/p>

杩涗竴姝ュ湴锛屾垜浠呬繚鐣欎簡鏂囨湰娑堟伅浠ュ強缇よ亰娑堟伅锛屽鏂囧瓧涔辩爜杩涜浜嗙炕璇戯紝鏈€鍚庡皢鍏跺彟瀛樹负.csv鏂囦欢銆?/p>

6 缁撴灉

鏈€鍚庯紝鎴戝緱鍒颁簡涓€涓叿鏈?34712鏉¤娴嬪€硷紝9涓彉閲忕殑锛屽崰鐢ㄥ唴瀛?2.7M鐨?code>.csv鏂囦欢锛屽涓嬨€?/p>

鍙傝€冭祫鏂?/h2>

• [1] 鏃跺厜(鐭ヤ箮鐢ㄦ埛). 2023鏈€鏂板井淇¤亰澶╄褰曞鍑烘柟寮廩EB/OL] (2023-3-22)[2023-7-19]. https://zhuanlan.zhihu.com/p/616008078.
• [2] Greycode(涓汉鍗氬). 瑙ｅ瘑瀹夊崜寰俊鑱婂ぉ淇℃伅瀛樺偍[EB/OL] (2022-6-20)[2023-7-19]. https://blog.greycode.top/posts/android-wechat-bak/.
• [3] 鐜嬪崕(鐭ヤ箮鐢ㄦ埛). 璁颁竴娆″井淇¤亰澶╂枃瀛楄褰曞鍑哄埌Excel宸ヤ綔[EB/OL] (2021-5-11)[2023-7-19]. https://zhuanlan.zhihu.com/p/28935173.