rule win_tabmsgsql_auto {

    meta:
        author = "Felix Bilstein - yara-signator at cocacoding dot com"
        date = "2026-09-17"
        version = "1"
        description = "Detects win.tabmsgsql."
        info = "autogenerated rule brought to you by yara-signator"
        tool = "yara-signator v0.6.0"
        signator_config = "callsandjumps;datarefs;binvalue"
        malpedia_reference = "https://malpedia.caad.fkie.fraunhofer.de/details/win.tabmsgsql"
        malpedia_rule_date = "20260916"
        malpedia_hash = "53a643781c18e08f4a50949af60172d837a0b6f6"
        malpedia_version = "20260917"
        malpedia_license = "CC BY-SA 4.0"
        malpedia_sharing = "TLP:WHITE"

    /* DISCLAIMER
     * The strings used in this rule have been automatically selected from the
     * disassembly of memory dumps and unpacked files, using YARA-Signator.
     * The code and documentation is published here:
     * https://github.com/fxb-cocacoding/yara-signator
     * As Malpedia is used as data source, please note that for a given
     * number of families, only single samples are documented.
     * This likely impacts the degree of generalization these rules will offer.
     * Take the described generation method also into consideration when you
     * apply the rules in your use cases and assign them confidence levels.
     */


    strings:
        $sequence_0 = { ffd6 8d842408010000 68???????? 50 ffd6 8d4c2404 6804010000 }
            // n = 7, score = 100
            //   ffd6                 | call                esi
            //   8d842408010000       | lea                 eax, [esp + 0x108]
            //   68????????           |                     
            //   50                   | push                eax
            //   ffd6                 | call                esi
            //   8d4c2404             | lea                 ecx, [esp + 4]
            //   6804010000           | push                0x104

        $sequence_1 = { 0500008000 0d40004004 84c9 7505 0d00002000 8b4e18 }
            // n = 6, score = 100
            //   0500008000           | add                 eax, 0x800000
            //   0d40004004           | or                  eax, 0x4400040
            //   84c9                 | test                cl, cl
            //   7505                 | jne                 7
            //   0d00002000           | or                  eax, 0x200000
            //   8b4e18               | mov                 ecx, dword ptr [esi + 0x18]

        $sequence_2 = { 8dbdc803feff 83c9ff f2ae f7d1 68???????? }
            // n = 5, score = 100
            //   8dbdc803feff         | lea                 edi, [ebp - 0x1fc38]
            //   83c9ff               | or                  ecx, 0xffffffff
            //   f2ae                 | repne scasb         al, byte ptr es:[edi]
            //   f7d1                 | not                 ecx
            //   68????????           |                     

        $sequence_3 = { 7477 8d4c2410 51 68???????? }
            // n = 4, score = 100
            //   7477                 | je                  0x79
            //   8d4c2410             | lea                 ecx, [esp + 0x10]
            //   51                   | push                ecx
            //   68????????           |                     

        $sequence_4 = { 89442418 0f8da6000000 8b460c 8d4c2428 8d542414 51 52 }
            // n = 7, score = 100
            //   89442418             | mov                 dword ptr [esp + 0x18], eax
            //   0f8da6000000         | jge                 0xac
            //   8b460c               | mov                 eax, dword ptr [esi + 0xc]
            //   8d4c2428             | lea                 ecx, [esp + 0x28]
            //   8d542414             | lea                 edx, [esp + 0x14]
            //   51                   | push                ecx
            //   52                   | push                edx

        $sequence_5 = { 668945ed 8845ef e8???????? 8b35???????? 8d55dc 68???????? 52 }
            // n = 7, score = 100
            //   668945ed             | mov                 word ptr [ebp - 0x13], ax
            //   8845ef               | mov                 byte ptr [ebp - 0x11], al
            //   e8????????           |                     
            //   8b35????????         |                     
            //   8d55dc               | lea                 edx, [ebp - 0x24]
            //   68????????           |                     
            //   52                   | push                edx

        $sequence_6 = { 894c241c 8b2d???????? 8d4c2428 68???????? }
            // n = 4, score = 100
            //   894c241c             | mov                 dword ptr [esp + 0x1c], ecx
            //   8b2d????????         |                     
            //   8d4c2428             | lea                 ecx, [esp + 0x28]
            //   68????????           |                     

        $sequence_7 = { 83d8ff 85c0 750d 8d44240c 50 e8???????? 83c404 }
            // n = 7, score = 100
            //   83d8ff               | sbb                 eax, -1
            //   85c0                 | test                eax, eax
            //   750d                 | jne                 0xf
            //   8d44240c             | lea                 eax, [esp + 0xc]
            //   50                   | push                eax
            //   e8????????           |                     
            //   83c404               | add                 esp, 4

        $sequence_8 = { 68???????? ff15???????? 83c404 a1???????? 50 ff15???????? b940000000 }
            // n = 7, score = 100
            //   68????????           |                     
            //   ff15????????         |                     
            //   83c404               | add                 esp, 4
            //   a1????????           |                     
            //   50                   | push                eax
            //   ff15????????         |                     
            //   b940000000           | mov                 ecx, 0x40

        $sequence_9 = { 50 51 e8???????? 83c420 eb53 }
            // n = 5, score = 100
            //   50                   | push                eax
            //   51                   | push                ecx
            //   e8????????           |                     
            //   83c420               | add                 esp, 0x20
            //   eb53                 | jmp                 0x55

    condition:
        7 of them and filesize < 163840
}