Tokolosh Posted February 12, 2017 Share Posted February 12, 2017 Hello First off, i'm a fairly new AutoIT User and so far i have found everything i need on this Forum. Secondly i seem to have cornered myself into a tough spot. I have made myself a little automated backup app that works well so far. But now that i have added a licensing feature in connection with obsidium, i would like to add issued licenses to a mysql database to keep track of them. I have already created a Web Licensing Feature using the Obsidium SDK and an App that uses this and creates a License File (License.lic) containing 3 Lines which look like this: Customer Name XXXXX-XXXXX-XXXXX-XXXXX-XXXXX-XXXXX-XXXXX-XXXXX-XXX (Alphanumeric) SystemID (Alphanumeric) The Code for the LicenseFetching Tool, which works well, looks like this: #include <GUIConstants.au3> GUICreate("MyApp Licensing Tool", 320, 120, @DesktopWidth / 2 - 160, @DesktopHeight / 2 - 45) $info1 = GUICtrlCreateInput("CustomerName", 10, 5, 300, 20) GUICtrlSetState(-1, $GUI_ACCEPTFILES) $systemid = GUICtrlCreateInput("SystemID", 10, 35, 300, 20) $btn = GUICtrlCreateButton("Ok", 40, 75, 60, 20) $project = "SomeFileNameHere" $type = "aSettingComesHere" $legacy = "aSettingComesHere" $advanced = "aSettingComesHere" GUISetState() $msg = 0 While $msg <> $GUI_EVENT_CLOSE $msg = GUIGetMsg() Select Case $msg = $Btn ;MsgBox(262144, '', ' 1 : ' & GUICtrlRead($info1) & ' 2: ' & GUICtrlRead($systemid)) $sStr = BinaryToString(InetRead("https://some.URL.here/web-cgi/something.cgi?info1="&GUICtrlRead($info1)&"&systemid="&GUICtrlRead($systemid)&"&project="&$project&"&type="&$type&"&legacy="&$legacy&"&advanced="&$advanced, 1)) FileWrite(@ScriptDir &"\License.lic", $sStr) Exit EndSelect WEnd This is where i would somehow like to add a Check to see if Customer already exists, as well as enter the Issued License to the Database. So my current Questions are: 1. How would i read these 3 Lines and enter them to a MySQL Database? 2. Which would be the best way to set up the Tables in MySQL to use these 3 Lines Any Tips and/or ideas are more than welcome Link to comment Share on other sites More sharing options...
Rex Posted February 12, 2017 Share Posted February 12, 2017 For the file read line part, you could either FileReadLine or user the UDF _FIleReadToArray. If you wants to insert into the MySql database, you need to connect to it first, there is some UDF's that can help you with that. For the Mysql part I can't help newer worked with that, only Sqlite. Cheers /Rex Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now