Showing posts with label SQLite. Show all posts
Showing posts with label SQLite. Show all posts

Wednesday, October 11, 2023

Viber Analyzer History

Viber Analyzer is application to explore Viber database. Beta

Version 1.0.1.2 of Viber Analyzer Demo on FMSoft uniGui released on 15 November 2023.

Viber Analyzer version 1.5.3.0 and Viber Analyzer Demo on FMSoft uniGui 1.0.1.0 was released on 26 October 2023.
The release are due to the fact that Viber began to encrypt the local database file.
Viber running under Windows 7 does not still encrypt database.

Version 1.0.0.0 of Viber Analyzer Demo on FMSoft uniGui released on 11 October 2023.

Version 1.5.2.0 was released on 13 August 2023.
The Contact Name was added to table with messages in the Chats page.
The Chat [Name] was added to table with messages in the Contacts page.

Version 1.5.1.0 was released on 29 July 2023.
The field "Viber Contact" in Contact table was removed by the very Viber. It provoked the error message in program Viber analyzer.
The second change was made for the situation wheh Viber was not installed in the system but user could open the Viber database files in Viber analyzer.

Version 1.5.0.2 was released on 16 April 2023.
Some graphic was changed for modern OS requirements. Changed the compiler from Delphi 7 to Delphi 2007.

Version 1.5.0.1 was released on 16 March 2023.
Check is made whether the file sqlite3.dll exists in program directory

Version 1.5.0.0 was released on 04 March 2023.
The "Activity" tab has been added to the Viber analyzer. The tab contains settings, authentication and where the last actions happened.

Version 1.4.2.0 was released on 24 February 2023.
Added changing hint for the edit window in the data filter.

Viber Analyzer ScreenShot
Version 1.4.1.0 was released on 29 January 2023.
Rulers' ranks in groups instead of Groups and Contacts relationship: superadmins and admins were added.

Version 1.4.0.0 was released on 28 January 2023.
The relations between Groups and Contacts were added.

Version 1.3.0.1 was released on 22 January 2023.
Some bugs fixed.

Version 1.3.0.0 was released on 25 December 2022.
Filter on substring was added.
Due to the filter, it became possible to take a screenshot without deleting personal data.

Version 1.2.5.0 was released on 12 December 2022.
MS Excel columns width autofit was added.

Version 1.2.4.0 was released on 08 December 2022.
A ban on running two copies at the same time has been implemented.
Added a crutch for loss of encoding when exporting to Excel.

Viber Analyzer Chats SQL ScreenShot
Version 1.2.3.0 was released on 06 December 2022.
The changes affected the output of the group and personal chats contents.
To pull out the Chats' names, the query of the fourth level of nesting was created.


Version 1.2.2.2 was released on 27 November 2022.
Some improvements to the Export to MS Excel were made.


Version 1.2.2.1 was released on 23 November 2022.
The check for MS Excel installed in system was added.


Version 1.2.2.0 was released on 22 November 2022.
Progress Bar to Export to Excel routine was added.
Some improvement to block refresh grids while exporting.


Version 1.2.1.0 was released on 17 July 2022.
Bug with external Viber DB-file opening was fixed.


Next version 1.2.0.0 was released on 05 July 2022.
Export to Excel through OLE was added.


Next version 1.1.1.0 was released on 20 June 2022.
The change affected the SystemID definiton.


Next version 1.1.0.0 was released on 15 June 2022.
Added Events counters for Chats and Contacts to show activity.


First version 1.0.0.0 was released on 08 June 2022.
There is timebomb in application. It does not affect functionality, just a reminder that the program may need to get updated.
Double click copies the selected cell in the clipboard.

Viber Analyzer Demo on FMSoft uniGui

Viber Analyzer Demo FMSoft UniGUI StandAlone Server ScreenShot
Viber Analyzer Demo on FMSoft uniGui is Standalone WebServer.
All messages output. Made using FMSoft uniGUI, Embarcadero Delphi 10.4 Sydney, ZEOS Library, SQL for SQLite database.

Software requirement to the system will fit any of Windows 32-bit version (Windows 7/8/8.1/10/11) where Viber messenger works and sqlite3.dll file presence in the same directory.
Viber must be installed and activated.


After Viber Analyzer Demo on FMSoft uniGui launch, type the localhost:8077 URL in the browser

Viber Analyzer Demo FMSoft UniGUI ScreenShot

Viber Analyzer Demo FMSoft UniGUI ScreenShot

Download
Viber Analyzer Demo Setup
ZEOS Library on Github
At the same time I solved another problem: made the support for Embarcadero Delphi 11, uploaded to Github to ZEOS Library

Thursday, June 9, 2022

About Viber Analyzer

Viber Analyzer Logo
Hello. I have Viber database on a PC. I need to extract messages, time and who created these messages.
How can I do it?
Use Viber Analyzer!
Viber Analyzer ScreenShot
Why Viber is to be explored?
Because Viber is one of the most popular instant messengers in our country (87% of respondents in 2020).
The second reason is how data storage is implemented in it - a great tool to practice SQL!
Let the third reason stay untold!
Viber stores data in a local SQLite database format 3.
Delphi 7, Delphi 2007, ZEOS Library, SQL for SQLite database, SQLite Database Browser for the development were used.


Software requirement to the system will fit any of Windows 32-bit version (Windows 7/8/8.1/10/11) where Viber messenger works and sqlite3.dll file presence in the same directory.