Search Results

Found 1 results for "20256debc67b2da39e94e4b35b5ce1cb" across all boards searching md5.

Anonymous /t/1233456#1327116
9/1/2024, 9:15:05 AM
>>1327098
>rarbg_db.zip
You'll find several magnets/hashes of this throughout the thread, but they should all contain the same .sqlite file, 775 MiB, CRC32 checksum = 3F03CB95.

It's an _SQLite database_. In basic terms, it's "kinda like" a bunch of interconnected excel tables, in a format that allows efficient search operations to be done on it.
(to tech savvy anons: yes I know this is a shitty explanation, but it's one that would make sense for normies)

You need https://sqlitebrowser.org/ or any other similar tool that can view SQLite databases.

Open the .sqlite file in this Browser. Go to the "Execute SQL" tab there.

Write the following and press Ctrl+Enter or the "Play" button:

SELECT printf("%.2f GiB", CAST(size AS FLOAT) / 1073741824.0) AS size_gib, title, dt, printf("magnet:?xt=urn:btih:%s&dn=%s", hash, title) AS magnet_link FROM items WHERE imdb = "tt1745960" ORDER BY size DESC;

> SELECT
A request to pick certain rows ("entries") from the entire table of torrents in this db
> printf("%.2f GiB", CAST(size AS FLOAT) / 1073741824.0) AS size_gib,
the first column will be the size of the torrent, it's stored in the db in bytes, so this formats it to gigabytes to be readable
> title,
the second column is the title of the magnet/torrent
> dt,
next: date of the upload to RARBG (it can help you guess whether it still has seeds)
> printf("magnet:?xt=urn:btih:%s&dn=%s", hash, title) AS magnet_link
next: a ready-to-use MAGNET LINK which you can COPY from the table of results with RIGHT CLICK. It's assembled from hash and title.
> FROM items
this tells the command the name of the table in the db in which to search
> WHERE imdb = "tt1745960"
You want only the entries which have the "imdb" field matching Top Gun Maverick.
Alternatively: WHERE title LIKE "%Top%Gun%Maverick%" if some uploads don't have an imdb field. This is considerably slower, but useful for obscure torrents. "%" is like "*" - a wildcard for search.
> ORDER BY size DESC;
Results are ordered by size.