Skip to content

Instantly share code, notes, and snippets.

@Jackster
Jackster / VBpostarchive.py
Created April 17, 2024 03:04
A basic Python script to archive posts from a Vbulletin forum into a local DB. Specify the URL and range of threads you want to crawl. Detects multiple pages and saves the content of each post along with the post data (user, timedate, post ID, thread ID) to a SQLite DB. Does not extract media. Created as a proof of concept for a larger scale for…
import re
import requests
from bs4 import BeautifulSoup
import sqlite3
from datetime import datetime
# Function to create a SQLite database and table for storing scrape details
# Function to create a SQLite database and table for storing scrape details
def create_scrape_table():
conn = sqlite3.connect('forum_scrape_info.db')
@Jackster
Jackster / gist:febe3f608e5b53e8f431cc5b0994414d
Created May 14, 2023 00:03
Marantz AOI software passwords
Here are the passwords to Marantz AOI software and PDFs found on http://www.marantz-mek.co.jp/en/downloads/software.html
Might work for the manuals on http://www.marantz-mek.co.jp/en/downloads/manual.html as well.
6.6.1 - 221125
6.6.0 - 221125
6.5.2 - 220531
6.5.1 - 220531
6.4.0 - 211111
6.3.0 - 210630
4.9.9 - 150515
@Jackster
Jackster / C3DLow_dx9_MatUtil.cpp
Last active December 23, 2022 23:29
C3DLow_dx9_MatUtil.cpp
#define DBLOCATION2 ,"C3DLow_dx9_matutil.cpp",0
#include "options_3d.h" //
#include "options_d.h" //
#include "C3DLow_dx9_MatUtil.h"
#include "File/IFile.h"
#ifdef PROFILE_SAVE_TIME_C3DLOW
#define PROFILE_SAVE_TIME
@Jackster
Jackster / translate.py
Last active December 19, 2022 02:39
Python to translate ProjectTorque dialogue files into whatever language you want using AWS Translate SDK
import boto3
import html
import re
# Set your AWS access key and secret key
ACCESS_KEY = "your_access_key"
SECRET_KEY = "your_secret_key"
# Set the region you want to use
REGION = "eu-west-2" # London region