Библиотека знаний - blog
Заметки IT программиста
http://178.140.10.58:8080/
2026-04-17T13:21:55+00:00
Библиотека знаний
http://178.140.10.58:8080/
http://178.140.10.58:8080/lib/exe/fetch.php?media=wiki:dokuwiki.svg
-
text/html
2015-04-28T16:51:21+00:00
Anonymous (anonymous@undisclosed.example.com)
Блог
http://178.140.10.58:8080/doku.php?id=blog:blog
<h1 class="sectionedit1" id="блог">Блог</h1>
<div class="level1">
<p>
blog
</p>
</div>
-
text/html
2015-09-15T09:58:14+00:00
Anonymous (anonymous@undisclosed.example.com)
Skype
http://178.140.10.58:8080/doku.php?id=blog:skype
<div class="tags"><span>
<a href="http://178.140.10.58:8080/doku.php?id=tag:skype&do=showtag&tag=skype" class="wikilink1" title="tag:skype" rel="tag">skype</a>,
<a href="http://178.140.10.58:8080/doku.php?id=tag:blog&do=showtag&tag=blog" class="wikilink1" title="tag:blog" rel="tag">blog</a>
</span></div>
<h1 class="sectionedit1" id="skype">Skype</h1>
<div class="level1">
</div>
<!-- EDIT{"target":"section","name":"Skype","hid":"skype","codeblockOffset":0,"secid":1,"range":"21-41"} -->
<h2 class="sectionedit2" id="поиск_по_истории_чата">Поиск по истории чата</h2>
<div class="level2">
<p>
Для хранения сообщений skype в последних версиях использует SqlLite.
Как правило файлы находятся
</p>
</div>
<!-- EDIT{"target":"section","name":"\u041f\u043e\u0438\u0441\u043a \u043f\u043e \u0438\u0441\u0442\u043e\u0440\u0438\u0438 \u0447\u0430\u0442\u0430","hid":"\u043f\u043e\u0438\u0441\u043a_\u043f\u043e_\u0438\u0441\u0442\u043e\u0440\u0438\u0438_\u0447\u0430\u0442\u0430","codeblockOffset":0,"secid":2,"range":"42-263"} -->
<h3 class="sectionedit3" id="mac_os">Mac OS</h3>
<div class="level3">
<pre class="code">/Users/[system_user_name]/Library/Application Support/Skype/[my skype username]/main.db</pre>
</div>
<!-- EDIT{"target":"section","name":"Mac OS","hid":"mac_os","codeblockOffset":0,"secid":3,"range":"264-372"} -->
<h3 class="sectionedit4" id="windows">Windows</h3>
<div class="level3">
<pre class="code">%appdata%\Skype\[my skype username]\main.db</pre>
<p>
Где my skype username это имя вашего skype аккаунта
</p>
</div>
<!-- EDIT{"target":"section","name":"Windows","hid":"windows","codeblockOffset":0,"secid":4,"range":"373-515"} -->
<h2 class="sectionedit5" id="пример_запроса_на_поиск_интересуемых_сообщений">Пример запроса на поиск интересуемых сообщений</h2>
<div class="level2">
<pre class="code sql"> <span class="kw1">SELECT</span> datetime<span class="br0">(</span><span class="kw1">TIMESTAMP</span><span class="sy0">,</span> <span class="st0">'unixepoch'</span><span class="sy0">,</span> <span class="st0">'localtime'</span><span class="br0">)</span><span class="sy0">,</span> chatname<span class="sy0">,</span> author<span class="sy0">,</span> from_dispname<span class="sy0">,</span> body_xml <span class="kw1">FROM</span> Messages <span class="kw1">WHERE</span> id <span class="sy0">></span> <span class="nu0">95000</span> <span class="kw1">AND</span> body_xml <span class="kw1">LIKE</span> <span class="st0">'%завтра%'</span> <span class="kw1">ORDER</span> <span class="kw1">BY</span> <span class="kw1">TIMESTAMP</span> <span class="kw1">LIMIT</span> <span class="nu0">10000</span>;</pre>
</div>
<!-- EDIT{"target":"section","name":"\u041f\u0440\u0438\u043c\u0435\u0440 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043d\u0430 \u043f\u043e\u0438\u0441\u043a \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0443\u0435\u043c\u044b\u0445 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439","hid":"\u043f\u0440\u0438\u043c\u0435\u0440_\u0437\u0430\u043f\u0440\u043e\u0441\u0430_\u043d\u0430_\u043f\u043e\u0438\u0441\u043a_\u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0443\u0435\u043c\u044b\u0445_\u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439","codeblockOffset":0,"secid":5,"range":"516-"} -->