Jump to content
Sign in to follow this  
Fhelipe

Login System Using Autoit And MYSQL

Recommended Posts

Fhelipe

Nothing More

Edited by Fhelipe

Share this post


Link to post
Share on other sites
genius257

Hi @Fhelipe.

I'm not sure if you realize MySQL requires a server.

I've made an example in SQLite, however it's almost the same with the queries for MySQL.

I know the passwords SHOULD be hashed, but this is just a bare bones example.

#include <SQLite.au3>
#include <Array.au3>

$sSQLite = _SQLite_Startup("sqlite3.dll")
If @error<>0 Then Exit MsgBox(0, "", "SQLite Error", "SQLite3.dll Can't be Loaded!")
$hSQLiteDB = _SQLite_Open(@ScriptName&".sqlite3")
If @error<>0 Then Exit MsgBox(0, "", "Can't open or create a Database!")
_SQLite_Exec($hSQLiteDB, "CREATE TABLE IF NOT EXISTS `Users` (`ID` INTEGER PRIMARY KEY AUTOINCREMENT, `username` TEXT NOT NULL, `password` TEXT NOT NULL)")

;LOGIN example
$username = "Zummey"
$password = "xd90fe10"

Login($username, $password);will fail upon first run
If @error<>0 Then ConsoleWrite("Login failed"&@CRLF)

;inserts user if not exist
Create_User($username, $password)


_ArrayDisplay(Login($username, $password))

_SQLite_Close($hSQLiteDB)
_SQLite_Shutdown()

;Success:
;   Found: Array(ID, username)
;   Not Found: 0
;Failure: -1
Func Login($username, $password)
    Local $hQuery = 0
    Local $aRow = 0
    ;~ _SQLite_Query($hSQLiteDB, "INSERT INTO `Users` values ()"
    _SQLite_Query($hSQLiteDB, "SELECT `ID`, `username` FROM `Users` WHERE `username`=? AND `password`=? LIMIT 1", $hQuery)
    _SQLite_BindText($hQuery, 1, $username)
    _SQLite_BindText($hQuery, 2, $password)
    Local $iResult = _SQLite_FetchData($hQuery, $aRow)
    If $iResult = $SQLITE_OK Then Return $aRow
    Return SetError($iResult, 0, ($iResult=$SQLITE_DONE)?0:-1)
EndFunc

Func Create_User($username, $password)
    Local $hQuery = 0
    _SQLite_Query($hSQLiteDB, "INSERT INTO `Users` (`username`, `password`) SELECT ?, ? WHERE NOT EXISTS (SELECT 1 FROM `Users` WHERE `username`=?)", $hQuery)
    _SQLite_BindText($hQuery, 1, $username)
    _SQLite_BindText($hQuery, 2, $password)
    _SQLite_BindText($hQuery, 3, $username)
    Local $iRval_Step = DllCall($__g_hDll_SQLite, "int:cdecl", "sqlite3_step", "ptr", $hQuery)
    If @error Then Return SetError(1, @error, $SQLITE_MISUSE) ; DllCall error
    $iChanges = _SQLite_Changes($hSQLiteDB)
    _SQLite_QueryFinalize($hQuery)
    If $iRval_Step=$SQLITE_DONE And $iChanges>0 Then Return 1
    Return SetError($iRval_Step, 0, 0)
EndFunc

;Source: https://autoit-script.ru/index.php?topic=21090.15#msg_124711
Func _SQLite_BindText($hQuery, $iRowID, $sTextRow)
    Local $iRval = DllCall($__g_hDll_SQLite, "int:cdecl", "sqlite3_bind_text16", _
            "ptr", $hQuery, _
            "int", $iRowID, _
            "wstr", $sTextRow, _
            "int", -1, _
            "ptr", NULL)
    If @error Then Return SetError(1, @error, $SQLITE_MISUSE) ; DllCall error
    If $iRval[0] <> $SQLITE_OK Then
        Return SetError(-1, 0, $iRval[0])
    EndIf
    Return $iRval[0]
EndFunc

Hope this can help you getting started.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • nooneclose
      By nooneclose
      Good morning everyone, I thought I had already solved this issue but it turns out I did not. 
      My code finds unread emails with this specific subject line of "request" but when I change the subject to SKIPPED + "request" = ("SKIPPED request") the program still finds the email and tries to process it. I only want to process emails with the exact match subject of "request".
      Here is my code that "finds" the unread emails with the subject of "request" or so I thought. 
      Func ListUnreadEmails() ;******************************************************************************* ; Lists all unread E-mails from the folder Outlook-UDF-Test ;******************************************************************************* ; Stores all the unRead emails into an array Global $aItems = _OL_ItemFind($oOutlook, "*\Outlook-UDF-Test", $olMail, _ "[UnRead]=True", "Subject", "request", "EntryID,Subject", "", 1) ; Displays the array of unRead emails If IsArray($aItems) Then ;_ArrayDisplay($aItems, "OutlookEX UDF: _OL_ItemFind - Unread mails") Else MsgBox(48, "OutlookEX UDF: _OL_ItemFind Example Script", _ "Could not find an unread mail. @error = " & @error & ", @extended: " & @extended) EndIf ; Gets the number of unread emails Global $numberOfUnRead = UBound($aItems, $UBOUND_ROWS) - 1 ;MsgBox("", "Number of Unread emails", $numberOfUnRead) EndFunc It acts as if any part of the subject containing the word "request" and the email is unread that it will try to process it. (I think)
    • KhalidAnsari
      By KhalidAnsari
      Hi,
      I need to automate Java application using AutoIt, I have refer forum for the same, as per forum I am using Java Access Bridge to finding control name. But could not set value to control. Below is my sample code 
      Send("#r")
      sleep(1500)
      Send("D:\javaapplication\javaapplication\Hello.jar{Enter}")
      WinActivate("Penjumlahan")
      sleep(1500)
      ControlSetText("Penjumlahan", "", "Name:  A :", "demo")
      Java Application and Java Ferret screen

    • QaisBsharat
      By QaisBsharat
      Hello, 
      May i know how can i automation qt application?
      Using controlclick not mouse and positions
       
      Thanks
    • nooneclose
      By nooneclose
      Good afternoon, I am in need of some help. I am sure this is a stupid question requiring only one or two lines of code. However, I would greatly appreciate the help I cannot figure this out. I also tried searching for the answer on the internet but no one except me apparently seems to be having a hard time figuring this out and or is asking about it. 
      I simply want to change the "status" of an email from unread to read once I have processed it. My code is over 500 lines and I would like not to clutter this post with it. Assume I have all my includes and connections properly defined and stuff. 
      Here is the bit of code where I am trying to change the email that was used from unread to read:
      Func ChangeEmailStatus() ;******************************************************************************* ; changes the status of an email from unread to Read ;******************************************************************************* Local $iRows = UBound($aItems, $UBOUND_ROWS) MsgBox("", "Number of Unread emails (Before Change)", $iRows) _OL_ItemModify($oOutlook,$aItems[$i][0], Default, "Read=True") MsgBox("", "Array Display 1", $aItems[1][0]) MsgBox("", "Array Display 2", $aItems[2][0]) Local $iRows = UBound($aItems, $UBOUND_ROWS) MsgBox("", "Number of Unread emails (After Change)", $iRows) EndFunc  
    • SharpDressedMan
      By SharpDressedMan
      Hello,
      Is there any way to check for validity of a pointer to a DllStruct ?
      In the above code, a DllStruct is created from an invalid pointer. How to prevent from doing this ?
      local $tStruct = DllStructCreate("int i") DllStructSetData($tStruct, "i", 123) local $pStruct = DllStructGetPtr($tStruct) $tStruct = 0 ; destroy DllStruct ==> $pStruct becomes invalid ; how to check here for validity of $pStruct and prevent from doing the following ? $tStruct = DllStructCreate("int i", $pStruct) ; create DllStruct from invalid pointer... MsgBox(0, @ScriptName, @error) ; displays '0' : invalid pointer is not detected by DllStructCreate() MsgBox(0, @ScriptName, IsDllStruct($tStruct)) ; displays '1' : tStruct is assumed as a valid DllStruct object, which is not Thanks for help
×