#include <Excel.au3>
#include <Array.au3>

$sExcelFile = @ScriptDir & "\test.xlsx"

; excel auslesen
Local $oExcelapp = _Excel_Open(0,0,1,1,1)
Local $oExcel = _Excel_BookOpen($oExcelapp, $sExcelFile)

If @error = 1 Then
    MsgBox(0, "Error!", "Unable to Create the Excel Object")
    Exit
ElseIf @error = 2 Then
    MsgBox(0, "Error!", "File does not exist - Shame on you!")
    Exit
EndIf

Local $aArray = _Excel_RangeRead($oExcel,Default,Default)

_Excel_BookClose($oExcel, False)
_Excel_Close($oExcelapp, Default, True)

_ArrayDisplay($aArray, "Array using Default Parameters")

For $i = 0 To UBound($aArray) -1

    MsgBox(0,"Zeile " & $i , $aArray[$i][0] & @crlf & $aArray[$i][1] & @crlf & $aArray[$i][2])

Next

#include <File.au3>
#include <String.au3>
#Include <Array.au3>
#include <WindowsConstants.au3>

Local $oMyRet, $oMyError, $to, $cc, $bcc, $subject, $body, $attachment, $aRecords, $body_txt

$MAILSERVER = ""
$ADMINUSER = ""
$ADMINPASS = ""

$from = ""
$to = ""
$cc = ""
$bcc = ""
$subject = ""
$body = ""
$attachment = ""

Sendmail()

sleep (2000)

Func Sendmail()

    ;MsgBox(0,"", $strData2)  ;mailadresse prüfen

    Global $oMyError = ObjEvent("AutoIt.Error", "MyErrFunc")
    ;##################################
    ; Variables
    ;##################################
    
    $s_SmtpServer = $MAILSERVER                 ; address for the smtp-server to use - REQUIRED
    $s_FromName = $from                         ; name from who the email was sent
    $s_FromAddress = $from                         ; address from where the mail should come
    $s_ToAddress = $to                            ; destination address of the email - REQUIRED
    $s_Subject = $subject                        ; subject from the email - can be anything you want it to be
    $as_Body = $body_txt                        ; the messagebody from the mail - can be left blank but then you get a blank mail
    $s_AttachFiles = $attachment                ; the file you want to attach- leave blank if not needed
    $s_CcAddress = $cc                             ; address for cc - leave blank if not needed
    $s_BccAddress = $bcc                         ; address for bcc - leave blank if not needed
    $s_Username = $ADMINUSER                      ; username for the account used from where the mail gets sent  - Optional (Needed for eg GMail)
    $s_Password = $ADMINPASS                      ; password for the account used from where the mail gets sent  - Optional (Needed for eg GMail)
    $IPPort = 25                                 ; port used for sending the mail
    $ssl = 0                                     ; enables/disables secure socket layer sending - put to 1 if using httpS
    ;~ $IPPort=465                                ; GMAIL port used for sending the mail
    ;~ $ssl=1                                     ; GMAILenables/disables secure socket layer sending - put to 1 if using httpS

    ;##################################
    ; Script
    ;##################################
    Global $oMyRet[2]
    ;MsgBox(0,"", $s_SmtpServer& $s_FromName& $s_FromAddress& $s_ToAddress& $s_Subject& $as_Body& $s_AttachFiles& $s_CcAddress& $s_BccAddress& $s_Username& $s_Password& $IPPort& $ssl)
    $rc = _INetSmtpMailCom($s_SmtpServer, $s_FromName, $s_FromAddress, $s_ToAddress, $s_Subject, $as_Body, $s_AttachFiles, $s_CcAddress, $s_BccAddress, $s_Username, $s_Password, $IPPort, $ssl)
    If @error Then
        MsgBox(0, "Error sending message", "Error code:" & @error & "  Description:" & $rc,1)
    EndIf

EndFunc   ;==>Sendmail


Func _INetSmtpMailCom($s_SmtpServer, $s_FromName, $s_FromAddress, $s_ToAddress, $s_Subject = "", $as_Body = "", $s_AttachFiles = "", $s_CcAddress = "", $s_BccAddress = "", $s_Username = "", $s_Password = "", $IPPort = 25, $ssl = 0)
    $objEmail = ObjCreate("CDO.Message")
    $objEmail.From = '"' & $s_FromName & '" <' & $s_FromAddress & '>'
    $objEmail.To = $s_ToAddress
    Local $i_Error = 0
    Local $i_Error_desciption = ""
    If $s_CcAddress <> "" Then $objEmail.Cc = $s_CcAddress
    If $s_BccAddress <> "" Then $objEmail.Bcc = $s_BccAddress
    $objEmail.Subject = $s_Subject
    If StringInStr($as_Body, "<") And StringInStr($as_Body, ">") Then
        $objEmail.HTMLBody = $as_Body
    Else
        $objEmail.Textbody = $as_Body & @CRLF
    EndIf
    If $s_AttachFiles <> "" Then
        Local $S_Files2Attach = StringSplit($s_AttachFiles, ";")
        For $x = 1 To $S_Files2Attach[0]
            $S_Files2Attach[$x] = _PathFull($S_Files2Attach[$x])
            If FileExists($S_Files2Attach[$x]) Then
                $objEmail.AddAttachment($S_Files2Attach[$x])
            Else
                $i_Error_desciption = $i_Error_desciption & @LF & 'File not found to attach: ' & $S_Files2Attach[$x]
                SetError(1)
                Return 0
            EndIf
        Next
    EndIf
    $objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
    $objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = $s_SmtpServer
    $objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = $IPPort
    ;Authenticated SMTP
    If $s_Username <> "" Then
        $objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
        $objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = $s_Username
        $objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = $s_Password
    EndIf
    If $ssl Then
        $objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True
    EndIf
    ;Update settings
    $objEmail.Configuration.Fields.Update
    ; Sent the Message
    $objEmail.Send
    If @error Then
        SetError(2)
        Return $oMyRet[1]
    EndIf
EndFunc   ;==>_INetSmtpMailCom

Func MyErrFunc()
    $HexNumber = Hex($oMyError.number, 8)
    $oMyRet[0] = $HexNumber
    $oMyRet[1] = StringStripWS($oMyError.description, 3)
    ConsoleWrite("### COM Error !  Number: " & $HexNumber & "   ScriptLine: " & $oMyError.scriptline & "   Description:" & $oMyRet[1] & @LF)
    SetError(1); something to check for when this function returns
    Return
EndFunc   ;==>MyErrFunc

#include <array.au3>
#include <mysql.au3>

; db verbindungsvariablen
$ipadd = "server"
$sname = "user"
$spasswort = "pwd"
$db = "datenbank"

_MySQL_InitLibrary()
If @error Then Exit MsgBox(0, "Fehler", "libmysql.dll nicht gefunden")

$MysqlConn = _MySQL_Init()

$connected = _MySQL_Real_Connect($MysqlConn,$ipadd,$sname,$spasswort,$db)

If $connected = 0 Then
    $errno = _MySQL_errno($MysqlConn)
    MsgBox(0,"Fehler","Login Server ist nicht Erreichbar")
    Exit
Endif

Local $sQuery = "SELECT * FROM `Tabelle1`"
;MsgBox(0,"",$sQuery)

_MySQL_Real_Query($MysqlConn, $sQuery)

$res = _MySQL_Store_Result($MysqlConn)
$array = _MySQL_Fetch_Result_StringArray($res)
_MySQL_Free_Result($res)

_ArrayDisplay($array)


For $i = 0 To UBound($array) - 1
        
    Local $sQuery1 = 'SELECT * FROM Tabelle2 where Feld2="' & $array[$i][4] & '"' ;Der wert aus Feld2 wird auf Übereinstimmung mit dem ArrayFeld 4 (erste Abfrage) geprüft.
    
    _MySQL_Real_Query($MysqlConn, $sQuery1)

    $res1 = _MySQL_Store_Result($MysqlConn)
    $array1 = _MySQL_Fetch_Result_StringArray($res1)
    _MySQL_Free_Result($res1)

    _ArrayDisplay($array1)

Next


; Verbindung beenden
_MySQL_Close($MysqlConn)
; MYSQL beenden
_MySQL_EndLibrary()

Func _Putty()

    $hPid = Run(@ScriptDir & '\putty.exe -load "Programm" -l user -pw ' & $pwd,"",@SW_HIDE)
    WinWait("[CLASS:PuTTY]", "", 5)
    $hChild = WinGetHandle("[CLASS:PuTTY]", "")
    $NEXSTYLE = DllCall("user32.dll", "int", "GetWindowLong", "hwnd", $hChild, "int", 236)
    DllCall("user32.dll", "int", "SetWindowLong", "hwnd", $hChild, "int", 236, "int", BitOR($NEXSTYLE[0], $WS_EX_MDICHILD))
    DllCall("user32.dll", "int", "SetParent", "hwnd", $hChild, "hwnd", $hGui)

    $iOldStyle = _WinAPI_GetWindowLong($hChild, $GWL_STYLE)
    $iNewStyle = BitXOr($iOldStyle, $WS_SYSMENU);$WS_MINIMIZEBOX, $WS_MAXIMIZEBOX)
    _WinAPI_SetWindowLong($hChild, $GWL_STYLE, $iNewStyle)

    _WinAPI_SetWindowRgn(WinGetHandle($hChild), _WinAPI_CreateRectRgn(0, 30, 1024, 768)) ; Cut off Window Border

    WinMove($hChild, "", -8, 50,675,424)
    _WinAPI_ShowWindow($hChild, @SW_SHOW)

EndFunc

Global $ActiveCheck, $result

If @OSVersion = "WIN_2000" Or @OSVersion = "WIN_2003" Or @OSVersion = "WIN_XP" Or @OSVersion = "WIN_XPe" Then
$ActiveCheck = _XPActivationCheck()
Else
$ActiveCheck = _ActivationStatus()
EndIf

Func _ActivationStatus() ; Vista + Only ~ author trancexx
    Local $oWMIService = ObjGet("winmgmts:\\.\root\cimv2")
    If IsObj($oWMIService) Then
    Local $oCollection = $oWMIService.ExecQuery("SELECT Description, LicenseStatus, GracePeriodRemaining FROM SoftwareLicensingProduct WHERE PartialProductKey <> null")
    If IsObj($oCollection) Then
    For $oItem In $oCollection
    Switch $oItem.LicenseStatus
    Case 0, 2 To 4, 6
    $result = "Windows Is NOT Activated"
    Case 1
    $result = "Windows Is Activated"
    Case 5
    $result = "Possible Fixed Windows (Notification Mode)"
    EndSwitch
    ;~ Return ConsoleWrite( $result & @CRLF)
    Return MsgBox(0, "Activation Result", $result & @CRLF)
    Next
    EndIf
    EndIf
EndFunc ;==>_ActivationStatus

Func _XPActivationCheck() ; XP only
    Local $x = ObjGet("winmgmts:{impersonationLevel=impersonate}")
    Local $y = $x.InstancesOf("win32_WindowsProductActivation")
    For $Obj In $y
    If $Obj.ActivationRequired Then
    $result = 'Windows Is NOT Activated'
    Else
    $result = 'Windows Is Activated'
    EndIf
    Next
    ;~ Return ConsoleWrite( $result & @CRLF)
    Return MsgBox(0, "Activation Result", $result & @CRLF)
EndFunc ;==>_XPActivationCheck



$WMI = ObjGet("winmgmts:\\.\root\cimv2")
$aLicenses = $WMI.ExecQuery("Select * From SoftwareLicensingProduct")

   For $element In $aLicenses
      If StringInStr($element.Description, "Windows Operating System") Then
         If $element.GracePeriodRemaining = 0 Then
            MsgBox(0, "", "Product is Activated")
            ExitLoop
         Else
            ;Call SLMgr.vbs with your selected options
            ;http://technet.microsoft.com/en-us/library/ff793433.aspx
         EndIf
      EndIf
   Next