divinity76

SQLite is kinda shite at handling programmer errors.
If you store music blobs as TEXT or STRING or even just a typo in BLOB,
you will get silent corruption, like missing null bytes.
Be very careful to actually add the datatype `BLOB` to anything containing binary data.

Furthermore, SQLite CLI is a piece of shit when it comes to handling binary data.
I have complained to the SQLite developers about it,
and they just shrug it off as "no can fix, would require massive refactor of the sqlite cli"

look at this shit:

divinity76

// for use on "Account API Tokens" -> "Create Custom Token", 
// https://dash.cloudflare.com/<uid>/api-tokens
function injectJQuery() {
  // Avoid double-injecting
  if (window.jQuery || document.getElementById("jqueryElement")) return;

  let xhr = new XMLHttpRequest();
  xhr.open("GET", "https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js", false);
  xhr.send();
  const script = document.createElement("script");

divinity76

#!/bin/bash
while IFS= read -r -d '' sofile; do
  echo "$sofile"
  strings "$sofile" | grep -E '[0-9]+\.[0-9]+\.[0-9]+'
done < <(find / -type f -iname "*curl.so*" -print0 2>/dev/null)

divinity76

#!/usr/bin/php
<?php
// how to include these bash functions in a bash script:
// eval "$(/usr/bin/php /path/to/functions.sh.php)";
declare(strict_types=1);
function quote($str)
{
    if (str_contains($str, "\x00")) {
        throw new \LogicException("null byte found in string");
    }

divinity76

<?php

declare(strict_types=1);
<<<'EXPLANATION'
We need to process all /home/*/conf/web/*/apache2.conf
replacing sections
    <FilesMatch \.php$>
        SetHandler "proxy:unix:/run/php/php8.2-fpm-idn-tést.eu.sock|fcgi://localhost"
    </FilesMatch>"
with

divinity76

function getManaPercent()
    return (player:getMana() / player:getMaxMana()) * 100
end

function getHealthPercent()
    return (player:getHealth() / player:getMaxHealth()) * 100
end

function hasManashield()
    -- return (player:getStates() & (1 << 4)) ~= 0

divinity76

<?php

declare(strict_types=1);
return (static function (\Rector\Config\RectorConfig $rectorConfig): void {
    $rectorConfig->phpVersion(\Rector\ValueObject\PhpVersion::PHP_84);
    if (1) {
        $timeout = 10 * 60;
        $maxNumberOfProcess = (int)shell_exec('nproc');
        $jobSize = 10;
        $rectorConfig->parallel($timeout, $maxNumberOfProcess, $jobSize);

divinity76

<?php

declare(strict_types=1);

function fix_encoding(string $str): string
{
    //return $str;
    return mb_convert_encoding($str, 'UTF-8', 'ISO-8859-1');
}

divinity76

#define _GNU_SOURCE
#include <iostream>
#include <pthread.h>
#include <chrono>
#include <vector>
#include <unistd.h>
#include <sched.h>
#include <stdexcept>
#include <climits>

divinity76

# see https://github.com/php/php-src/issues/12450
FROM ubuntu:20.04
ENV DEBIAN_FRONTEND=noninteractive 
RUN apt-get update -y
RUN apt-get -y full-upgrade;
RUN apt-get -y install apt-utils
RUN apt-get -y install golang build-essential git autoconf bison re2c make cmake automake libtool libpsl-dev libpsl5
RUN bash -c 'set -e;\
git clone -b curl-8_6_0 --single-branch --depth 1 https://github.com/curl/curl.git; \
cd curl; \