Beiträge von gmmg

Local $ADMINUSER = ""
Local $DOMAIN = @LogonDomain
Local $ADMINPASS = ""




If Not IsAdmin() Then
    ; Bis Version 3.2.10.0
;~    RRunAsSet($ADMINUSER, @LogonDomain, $ADMINPASS)
;~    Run(@ScriptFullPath, @ScriptDir, @SW_HIDE)
;~     RunAsSet()
    ; AB Version 3.2.12.0
    RunAs($ADMINUSER, $DOMAIN, $ADMINPASS, 0, @ScriptFullPath, @ScriptDir, @SW_HIDE)
    Exit
EndIf




If IsAdmin() Then
     ;MsgBox(0, "", "Admin-Rechte erkannt.",1)
EndIf

; auschnitt aus dem Skript Quelltext ...	
        $ro_label3 = GUICtrlRead($Label3)
	$ro_edit2 = _GUICtrlEdit_GetText($Edit2)
	$ro_combo2 = GUICtrlRead($Combo2)
	IF $ro_label3 <> "" Then
		IF $ro_edit2 = "" Then
			IF $ro_combo2 = "" Then
				_ArrayAdd($aArray, $ro_label3 & "|" & $ro_edit2 & "|leer")
			Else
				_ArrayAdd($aArray,  $ro_label3 & "|" & $ro_combo2 & "|CB")
			EndIf
		Else
			;_ArrayDisplay($aArray, "1")
			_ArrayAdd($aArray,  $ro_label3 & "|" & $ro_edit2 & "|EB")
		EndIf
	Else
		_ArrayAdd($aArray, $ro_label3 & "|" & $ro_edit2 & "|nv")
	EndIf
	_ArrayDisplay($aArray, "2")
; auschnitt aus der Array.au3 ...
_ArrayAdd(ByRef $avArray, $vValue, $iStart = 0, $sDelim_Item = "|", $sDelim_Row = @CRLF, $hDataType = 0)


; erstellt wird das Editfeld wie folgt ...
$Edit2 = _GUICtrlEdit_Create($hGui, "", 460, 350, 280, 100)

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


Local $oExcelapp = _Excel_Open(false) ;true=normal ,false=im hintergrund geöffnet
Local $oExcel = _Excel_BookOpen($oExcelapp, @scriptdir & "\datei.xlsx")


_Excel_RangeWrite ($oExcel,Default, $wert , "D2")


Local $aArray = _Excel_RangeRead($oExcel,Default,Default)
_ArrayDisplay($aArray, "Array using Default Parameters")


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

# Automatically answer all prompts negatively not to stall
# the script on errors
option batch on
# Disable overwrite confirmations that conflict with the previous
option confirm off
# Connect using a password
open User:pass@server-IP
# Change remote directory
cd /home/
# Force binary mode transfer
option transfer binary
# Download file to the local directory d:\
get -delete *.txt D:\Data\Download
# Upload the file to current working directory
put D:\Data\*.txt
# Disconnect
close
# Exit WinSCP
exit

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


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


Local $ADMINUSER = "user")
Local $DOMAIN = @LogonDomain
Local $ADMINPASS = "passwort")


;----ini---
$ini = @scriptdir & "\config.ini"


$from = IniRead($ini, "Variablen", "from", "NotFound")
$to = IniRead($ini, "Variablen", "to", "NotFound")
$cc = IniRead($ini, "Variablen", "cc", "NotFound")
$bcc = IniRead($ini, "Variablen", "bcc", "NotFound")
$subject = IniRead($ini, "Variablen", "subject", "NotFound")
$body = IniRead($ini, "Variablen", "body", "NotFound")
$attachment = IniRead($ini, "Variablen", "attachment", "NotFound")
;MsgBox(0,"",$attachment)
;----------
If Not _FileReadToArray(@ScriptDir & "\" & $body, $aRecords) Then
   MsgBox(0,"Error1", " Error reading log to Array     error:" & @error,2)
   Exit
EndIf
For $x = 1 to $aRecords[0]


	$body_txt &= $aRecords[$x] & @CRLF


	 ;Msgbox(0,'Record:' & $x, $body02)
Next


;Msgbox(0,'Record:' & $x, $body_txt)


If $attachment = "" Then
	;Sendmail()
Else
	$attachment_files = StringSplit($attachment,";")
	$allfilesok = 1
	For $i = 1 To $attachment_files[0]
        ;MsgBox(0, $attachment_files[0], $attachment_files[$i])
		;ConsoleWrite($attachment_files[$i] & @CRLF)
		$iFileExists = FileExists($attachment_files[$i])
		IF $iFileExists = 0 Then $allfilesok = 0
    Next
	;MsgBox(0,"allfilesok",$allfilesok)


	;MsgBox(0,"",$file01[0])
;~ 	IF FileExists($file01[1]) Then
	If $allfilesok = 1 Then
		Sendmail()
	Else
		$to = "support@test.de"
		$subject = "ReportFile nicht vorhanden"
		$body_txt = $attachment
		$attachment = ""
		Sendmail()
	EndIf
EndIf


;MsgBox(0,"test",$body_txt)


sleep (2000)


Func Sendmail()


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


	Global $oMyError = ObjEvent("AutoIt.Error", "MyErrFunc")
	;##################################
	; Variables
	;##################################
	$s_SmtpServer = "server" 	; 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 <Misc.au3>
#include <FTPEx.au3>
#Include <File.au3>
#Include <Array.au3>


; FTP Download --> SFTP Upload


If Not FileExists (@ScriptDir & "\Temp") Then DirCreate (@ScriptDir & "\Temp")


$Zielpfad = @ScriptDir & "\Temp\"
;-----------FTP--------------
$server = '192.x.x.x'
$username = 'user'
$pass = 'pwd'


$path = '/'


$Open = _FTP_Open('server')
$Conn = _FTP_Connect($Open, $server, $username, $pass, true)
;MsgBox(0,"",$Conn)
$setdir = _Ftp_DirSetCurrent($Conn, $path)
;MsgBox(0,"set dir",$setdir)


;$Dirlist = _FTPFilesListToArray($Conn, 1)
;_ArrayDisplay($Dirlist, 'Directorys List')


$Dirlist = _FTP_ListToArray2D($Conn, 0)
;MsgBox(0,"files vorhanden?",$Dirlist[0])
;_ArrayDisplay($Dirlist, 'File List')


	If $Dirlist[0][0] = 0 Then
		MsgBox(0,"", "keine Files vorhanden",1)
		Exit
	Else
		For $i = 1 To $Dirlist[0][0]
			MsgBox(0,"files ++++",$Dirlist[$i][0])
			IF $Dirlist[$i][1] = 0 Then 			;prüfung auf fehler
				;MsgBox(0,"files ++++",$Dirlist[$i][1])
			Else
				_Download_Del()
			EndIf
	Next
EndIf


_FTP_Close($Open)


Func _Download_Del()
	_FTP_FileGet($Conn, $Dirlist[$i][0], $Zielpfad & $Dirlist[$i][0]) ; lädt file vom ftp server
	Sleep(1000)
	_FTP_FileDelete($Conn, $Dirlist[$i][0])  ; löscht file vom ftp server
EndFunc