Hallo Leute
ich beschäftige mich erst seit kurzem mit SQL...
wollte mir selbst eine Viren Datenbank erstellen.
Mein Versuch:
Spoiler anzeigen
#include <GUIConstants.au3>
#include <EditConstants.au3>
#include <SQLite.au3>
#include <SQLite.dll.au3>
#Region ### START Koda GUI section ### Form=
$Form1 = GUICreate("AAV", 223, 359, 267, 119)
$lname = GUICtrlCreateLabel("Name:", 8, 48, 48, 17)
$iname = GUICtrlCreateInput("", 64, 48, 145, 21)
$ltype = GUICtrlCreateLabel("Type:", 8, 88, 45, 17)
$itype = GUICtrlCreateInput("Malware", 64, 88, 145, 21)
$imd5 = GUICtrlCreateInput("", 8, 128, 145, 21)
$bchoose = GUICtrlCreateButton("Choose File",8,168,145,21)
$bload = GUICtrlCreateButton("Load",8,198,145,21)
$badd = GUICtrlCreateButton("Add", 48, 312, 75, 25, 0)
$bdel = GUICtrlCreateButton("Delete", 128, 312, 75, 25, 0)
GUISetState(@SW_SHOW)
#EndRegion ### END Koda GUI section ###
_SQLite_Startup()
If NOT FileExists("md5.aav") Then
$dbn=_SQLite_Open("md5.aav")
_SQLite_Exec($dbn,"CREATE TABLE datas (md5,type,name);")
Else
$dbn=_SQLite_Open("md5.aav")
EndIf
While 1
$nMsg = GUIGetMsg()
Switch $nMsg
Case $GUI_EVENT_CLOSE
progend()
Case $badd
IF GUICtrlRead($iname) == "" Then
MsgBox(0,"ERORR","Empty name!")
Else
dataadd(GUICtrlRead($imd5))
EndIf
Case $bdel
datadel(GUICtrlRead($imd5))
Case $bload
dataquery(GUICtrlRead($imd5))
EndSwitch
WEnd
Func progend()
_SQLite_Close()
_SQLite_Shutdown()
Exit
EndFunc
Func dataadd($id)
Local $retarr
$str1 = GUICtrlRead($iname)
$str2 = GUICtrlRead($itype)
_SQLite_QuerySingleRow($dbn,"SELECT id FROM datas WHERE md5='"&$id&"'",$retarr)
If $retarr[0] <> "" Then
_SQLite_Exec($dbn,"UPDATE datas SET name='"&$str1&"', type='"&$str2&"' WHERE md5='"&$id&"'")
Else
_SQLite_Exec($dbn,"INSERT INTO datas (md5,type,name) VALUES ('"&$id&"','"&$str1&"','"&$str2&"');")
EndIf
EndFunc
Func dataquery($id)
GUICtrlSetData($iname,"")
GUICtrlSetData($itype,"")
Local $retarr
If _SQLite_QuerySingleRow($dbn,"SELECT * FROM datas WHERE md5='"&$id&"'",$retarr) == $SQLITE_OK Then
If $retarr[0] == "" Then
;MsgBox(0,"ERROR","Query error!")
Else
GUICtrlSetData($iname,$retarr[1])
GUICtrlSetData($itype,$retarr[2])
EndIf
EndIf
EndFunc
Func datadel($id)
Local $retarr
GUICtrlSetData($iname,"")
GUICtrlSetData($itype,"")
_SQLite_QuerySingleRow($dbn,"SELECT id FROM datas WHERE md5='"&$id&"'",$retarr)
If $retarr[0] <> "" Then
_SQLite_Exec($dbn,"DELETE FROM datas WHERE md5='"&$id&"'")
EndIf
EndFunc
Fehler:
Zitatmd5_hash.au3 (66) : ==> Subscript used with non-Array variable.:
If $retarr[0] <> "" Then
If $retarr^ ERROR
Danke mal im Voraus
mfg. Andi