Hi,
habe vor 2-3 Jahren schonmal etwas ähnliches gebastelt, was extern gehostet wurde und nun nicht mehr da ist ^^.
Bin gerade an einem etwas größerem Projekt, wobei dies ein Feature sein wird, welches ich benötige.
- Generieren von 6x6stelligen Seriennummern (Groß & Kleinbuchstaben sowie Zahlen)
- Anzeige in Listview
- direkter MySQL Datenbankupload [Seriennummer,Used]
- Editierbare Config für Zugangsdaten zum MySQL Server
Die Usedflag sitzt standardmäßig auf '0' für unbenutzt.
Screenshots
Spoiler anzeigen
[Blockierte Grafik: http://img696.imageshack.us/img696/6163/77126790.png]
[Blockierte Grafik: http://img715.imageshack.us/img715/4362/unbenanntxq.png]
Die Abfrage ob der Key benutzt wird und die Änderung in der Datenbank:
Spoiler anzeigen
#cs ----------------------------------------------------------------------------
[/autoit] [autoit][/autoit] [autoit]AutoIt Version: 3.3.9.0 (beta)
Author: Kev.K
Script Function:
Template AutoIt script.
#ce ----------------------------------------------------------------------------
[/autoit] [autoit][/autoit] [autoit]; Script Start - Add your code below here
#include <GUIConstantsEx.au3>
#include <WindowsConstants.au3>
#include <mysql.au3>
trialcheck()
[/autoit] [autoit][/autoit] [autoit]GUICreate("Produkt Activation",300,200)
GuictrlcreateLabel("Please activate your Product with the purchased license",15,20,300,25)
$serial = GuictrlcreateInput("",10,50,280,25)
$activate = GuictrlcreateButton("Activate",20,150,100,25)
$trial = GuictrlcreateButton("Trial",180,150,100,25)
$purchase = GuictrlcreateButton("Purchase now !",100,100,100,25)
GUISetState(@SW_SHOW)
While 1
$msg = GUIGetMsg()
Switch $msg
case $purchase
ShellExecute("http://www.paypal.com")
case $activate
activate()
case $trial
trial_Date()
Endswitch
If $msg = $GUI_EVENT_CLOSE Then ExitLoop
WEnd
func activate()
$username = "root"
$pass = ""
$host = "localhost"
$db = "serialdb"
_MySQL_InitLibrary()
$MysqlConn = _MySQL_Init()
$connected = _MySQL_Real_Connect($MysqlConn,$host,$username,$pass,$db)
If $connected = 0 Then Exit MsgBox(16, 'Connection Error', _MySQL_Error($MysqlConn))
$qur = "select `serial` from serialdb where (serial) =(" & "'" & Guictrlread($serial) & "'" & ")"
;ClipPut($qur)
$solution = _MySQL_Real_Query($MysqlConn, $qur)
$res = _MySQL_Store_Result($MysqlConn)
$rows = _MySQL_Num_Rows($res)
if $rows = "1" Then
$usedcheck = "select `used` from serialdb where (serial,used) =(" & "'" & Guictrlread($serial) & "'" & ",0)"
;ClipPut($usedcheck)
$solution = _MySQL_Real_Query($MysqlConn, $usedcheck)
$res = _MySQL_Store_Result($MysqlConn)
$fields = _MySQL_Num_Fields($res)
[/autoit] [autoit][/autoit] [autoit]$x = _MySQL_Num_Rows($res)
if $x = "1" Then
$quer = "UPDATE `serialdb` SET used =" & '"' & 1 & '"' & " WHERE `serial` = (" & "'" & Guictrlread($serial) & "'" & ")"
Clipput($quer)
_MySQL_Real_Query($MysqlConn, $quer)
Traytip("Activation","Activation complete ! Thanks for purchasing the Product",2,1)
_startProg()
Endif
Else
msgbox(0,"Error","The Productkey you have entered is unavailable !")
Endif
Endfunc
Func _startProg()
msgbox(0,"","start Prog here")
Endfunc
func trial_date()
$date = @MDAY & ":" & @MON & ":" & @YEAR
$xs = RegWrite("HKEY_CURRENT_USER\SOFTWARE\YourTOOL\", "Registration", "REG_SZ",$date)
Msgbox(0,"Trial Active","Your Trial is now running for 1 Month")
Endfunc
func trialcheck()
$date = @MDAY & ":" & @MON & ":" & @YEAR
$regread = RegRead("HKEY_CURRENT_USER\SOFTWARE\YourTOOL\","Registration")
;selfcreating Timediff.
Endfunc
[Blockierte Grafik: http://img803.imageshack.us/img803/928/unbenanntpn.png]
Falls wer fragen hat, einfach her damit