maaduukaar’s gists

maaduukaar / keyword-checker.py

Last active August 25, 2025 15:33

Script to check HTML pages for specific keywords and export results to Excel.

	import requests
	from bs4 import BeautifulSoup
	import pandas as pd
	import os
	import argparse
	import re

	# CLI arguments
	parser = argparse.ArgumentParser(description="Check WordPress posts for keywords.")
	parser.add_argument("-w", "--whole", action="store_true", help="Match whole words only")

maaduukaar / create_backup.php

Created August 12, 2025 14:54

PHP script to create a ZIP archive of the entire website, excluding the script itself and the backup folder. ⚠️ Delete after use!

	<?php
	/**
	* ⚠️ IMPORTANT! SECURITY WARNING! ⚠️
	* DELETE THIS FILE FROM THE SERVER AFTER USE!
	* Leaving this script on the server poses a security risk,
	* as attackers can use it to create archives
	* containing sensitive data from your website.
	*/

	// Check if ZipArchive class is available

maaduukaar / combine_images.py

Created August 1, 2025 14:49

A Python script to combine multiple images onto a single A4 page, useful for printing. Supports various layouts: 2 or 4 images per page, in both horizontal and vertical orientations. Features natural sorting for filenames and an interactive confirmation prompt.

	#!/usr/bin/env python3
	# -- coding: utf-8 --

	import os
	import sys
	from PIL import Image
	import argparse
	from pathlib import Path
	import re

maaduukaar / wp-category-articles-to-excel.py

Last active July 28, 2025 10:54

Python script to fetch articles from a WordPress parent category and all its subcategories via REST API, then export to Excel with clickable titles and modification dates. Supports recursion for nested categories. Example usage: Enter a category URL, and it generates an XLSX file.

	import requests
	from urllib.parse import urlparse
	from datetime import datetime
	from openpyxl import Workbook
	from openpyxl.styles import Font

	# — Function: date formatting
	def format_date(date_str):
	dt = datetime.fromisoformat(date_str.replace('Z', '+00:00'))
	return dt.strftime('%d.%m.%Y')

maaduukaar / get_rate.txt

Last active July 10, 2025 08:23

Get Toncoin rate to Google Spreadsheets

	EN:
	=VALUE(SUBSTITUTE(IMPORTXML("https://coinmarketcap.com/currencies/toncoin/"; "//span[@data-test='text-cdp-price-display']"); "$"; ""))

	RU:
	=ЗНАЧЕН(ПОДСТАВИТЬ(ПОДСТАВИТЬ(IMPORTXML("https://coinmarketcap.com/currencies/toncoin/"; "//span[@data-test='text-cdp-price-display']"); "$"; ""); "."; ","))

maaduukaar / window_info.py

Last active July 1, 2025 09:47

Get window titles, positions, and sizes on Windows using Python.

	import pygetwindow as gw

	# Get a list of all windows with non-empty titles
	windows = [w for w in gw.getAllWindows() if w.title.strip() != '']

	# Check if there are any available windows
	if not windows:
	print("No windows with non-empty titles were found.")
	exit()

maaduukaar / code_update_regex.py

Created June 30, 2025 11:56

	import os
	import re

	def replace_in_html_files(pattern, replacement, folder_path):
	# Компилируем регулярное выражение
	regex = re.compile(pattern, re.DOTALL \| re.IGNORECASE)

	# Счетчики для статистики
	total_files = 0
	processed_files = 0

maaduukaar / code_update_copypaste.py

Created June 30, 2025 11:56

	import os

	def replace_in_html_files(pattern, replacement, folder_path):
	# Счетчики для статистики
	total_files = 0
	processed_files = 0
	files_with_matches = 0
	files_without_matches = 0
	total_matches = 0

maaduukaar / check_urls_status.py

Last active June 27, 2025 12:04

Python script to check URLs for 404 errors with CSV export

	import requests
	import csv
	import time
	from collections import Counter

	# Settings
	input_file = 'urls.txt'
	output_file = 'result.csv'
	timeout = 10 # Request timeout in seconds
	delay = 0.5 # Delay between requests to avoid overloading servers

maaduukaar / index.html

Last active March 29, 2025 11:18

Тестовое для Leadwork

	<!DOCTYPE html>
	<html lang="ru">
	<head>
	<meta charset="UTF-8">
	<title>Септик Танк - купить в Москве у официального дилера</title>
	<meta name="description" content="Купить септик Танк в Москве с установкой под ключ. Официальный дилер. Надежная, энергонезависимая и долговечная автономная канализация по выгодной цене.">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta name="robots" content="index, follow">
	<link rel="canonical" href="https://example.com/septik-tank">
	</head>

Max Shvedov maaduukaar