rule win_tabmsgsql_auto {

    meta:
        author = "Felix Bilstein - yara-signator at cocacoding dot com"
        date = "2022-04-08"
        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 = "20220405"
        malpedia_hash = "ecd38294bd47d5589be5cd5490dc8bb4804afc2a"
        malpedia_version = "20220411"
        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 = { 33c0 8d7c2456 8d542454 f3ab 8b8e2c800000 51 68???????? }
            // n = 7, score = 100
            //   33c0                 | xor                 eax, eax
            //   8d7c2456             | lea                 edi, dword ptr [esp + 0x56]
            //   8d542454             | lea                 edx, dword ptr [esp + 0x54]
            //   f3ab                 | rep stosd           dword ptr es:[edi], eax
            //   8b8e2c800000         | mov                 ecx, dword ptr [esi + 0x802c]
            //   51                   | push                ecx
            //   68????????           |                     

        $sequence_1 = { 53 6a02 6a02 68???????? e8???????? 83c420 e9???????? }
            // n = 7, score = 100
            //   53                   | push                ebx
            //   6a02                 | push                2
            //   6a02                 | push                2
            //   68????????           |                     
            //   e8????????           |                     
            //   83c420               | add                 esp, 0x20
            //   e9????????           |                     

        $sequence_2 = { ffd6 8b3d???????? 8b4c2414 51 ffd7 8b1d???????? }
            // n = 6, score = 100
            //   ffd6                 | call                esi
            //   8b3d????????         |                     
            //   8b4c2414             | mov                 ecx, dword ptr [esp + 0x14]
            //   51                   | push                ecx
            //   ffd7                 | call                edi
            //   8b1d????????         |                     

        $sequence_3 = { 52 ffd7 50 e8???????? b900f40100 33c0 8bfe }
            // n = 7, score = 100
            //   52                   | push                edx
            //   ffd7                 | call                edi
            //   50                   | push                eax
            //   e8????????           |                     
            //   b900f40100           | mov                 ecx, 0x1f400
            //   33c0                 | xor                 eax, eax
            //   8bfe                 | mov                 edi, esi

        $sequence_4 = { 68???????? 6a01 49 56 8d95c803feff 51 8d85c8f7ffff }
            // n = 7, score = 100
            //   68????????           |                     
            //   6a01                 | push                1
            //   49                   | dec                 ecx
            //   56                   | push                esi
            //   8d95c803feff         | lea                 edx, dword ptr [ebp - 0x1fc38]
            //   51                   | push                ecx
            //   8d85c8f7ffff         | lea                 eax, dword ptr [ebp - 0x838]

        $sequence_5 = { eb05 1bc0 83d8ff 85c0 7515 8d8424e8f40100 }
            // n = 6, score = 100
            //   eb05                 | jmp                 7
            //   1bc0                 | sbb                 eax, eax
            //   83d8ff               | sbb                 eax, -1
            //   85c0                 | test                eax, eax
            //   7515                 | jne                 0x17
            //   8d8424e8f40100       | lea                 eax, dword ptr [esp + 0x1f4e8]

        $sequence_6 = { 33c0 eb05 1bc0 83d8ff 3bc3 7558 8b15???????? }
            // n = 7, score = 100
            //   33c0                 | xor                 eax, eax
            //   eb05                 | jmp                 7
            //   1bc0                 | sbb                 eax, eax
            //   83d8ff               | sbb                 eax, -1
            //   3bc3                 | cmp                 eax, ebx
            //   7558                 | jne                 0x5a
            //   8b15????????         |                     

        $sequence_7 = { ffd5 83c40c 83c602 83c303 8a4701 47 84c0 }
            // n = 7, score = 100
            //   ffd5                 | call                ebp
            //   83c40c               | add                 esp, 0xc
            //   83c602               | add                 esi, 2
            //   83c303               | add                 ebx, 3
            //   8a4701               | mov                 al, byte ptr [edi + 1]
            //   47                   | inc                 edi
            //   84c0                 | test                al, al

        $sequence_8 = { eba7 5f 5e 5d b801000000 }
            // n = 5, score = 100
            //   eba7                 | jmp                 0xffffffa9
            //   5f                   | pop                 edi
            //   5e                   | pop                 esi
            //   5d                   | pop                 ebp
            //   b801000000           | mov                 eax, 1

        $sequence_9 = { 33c0 68???????? f2ae f7d1 2bf9 8d442434 8bd1 }
            // n = 7, score = 100
            //   33c0                 | xor                 eax, eax
            //   68????????           |                     
            //   f2ae                 | repne scasb         al, byte ptr es:[edi]
            //   f7d1                 | not                 ecx
            //   2bf9                 | sub                 edi, ecx
            //   8d442434             | lea                 eax, dword ptr [esp + 0x34]
            //   8bd1                 | mov                 edx, ecx

    condition:
        7 of them and filesize < 163840
}