Pull data from Dude sqlite database

RouterOS The Dude
1

I’ve wrote a simple php class to extract some data (Devices, Maps, Types and, partially, Links) directly from The Dude database file.

The idea came from this topic: http://forum.mikrotik.com/t/pulling-data-direct-from-dude-database-proof-of-concept/128177/1 and the main decode method is a port of the python code wrote by 0ki here: https://github.com/0ki/mikrotik-tools/blob/master/mt_dat_decoder.py

Feel free to clone my github repository and use/modify/improve the code.

I’ll be happy to accept any pull request (there’s a ton of things that can be done…)

Repo url: https://github.com/diegotibi/dude

2

hmmm would it also connect to a live dude db file?
If yes have you also tried to modify it and see the changes live in the Dude?

3

Opening the DB “live” is possibile, in theory, it’s only matter of sharing the media where the database is stored.

Modify the database is also possible, since it’s known how to decode the data it’s also possible to encode it back.
I’ve no plans on writing an encode method since I don’t need one, feel free to do by yourself if you want.