Dim s_server_data_name, s_server_host, s_server_user, s_server_password, s_server_port As String
s_server_data_name = "staff_phone_data_record"
s_server_host="xx.xx.xx.xx"
s_server_user="user"
s_server_password="password"
s_server_port="4000"
Dim b_server_data_name() As Byte
Dim b_server_host() As Byte
Dim b_server_user() As Byte
Dim b_server_password() As Byte
Dim b_server_port() As Byte
Dim crypt_s_server_data_name As String = ""
Dim crypt_s_server_host As String = ""
Dim crypt_s_server_user As String = ""
Dim crypt_s_server_password As String = ""
Dim crypt_s_server_port As String = ""
b_server_data_name = Encrypt(s_server_data_name)
crypt_s_server_data_name = BytesToString(b_server_data_name, 0, b_server_data_name.Length, "UTF8")
b_server_host = Encrypt(s_server_host)
crypt_s_server_host = BytesToString(b_server_host, 0, b_server_host.Length, "UTF8")
b_server_user = Encrypt(s_server_user)
crypt_s_server_user = BytesToString(b_server_user, 0, b_server_user.Length, "UTF8")
b_server_password = Encrypt(s_server_password)
crypt_s_server_password = BytesToString(b_server_password, 0, b_server_password.Length, "UTF8")
b_server_port = Encrypt(s_server_port)
crypt_s_server_port = BytesToString(b_server_port, 0, b_server_port.Length, "UTF8")
Dim Query As String = "INSERT INTO tbl_server_detail VALUES (NULL,?,?,?,?,?)"
sql1.ExecNonQuery2(Query,Array As String(crypt_s_server_data_name,crypt_s_server_host,crypt_s_server_user,crypt_s_server_password,crypt_s_server_port))
End Sub
Sub btn_generate_MouseClicked (EventData As MouseEvent)
If File.Exists(File.DirApp,"data/server.db3")=False Then
sql1.InitializeSQLite(File.DirApp, "data/server.db3", True)
CreateData
Create_server_detail
sql1.close
Else
File.Delete(File.DirApp,"data/server.db3")
sql1.InitializeSQLite(File.DirApp, "data/server.db3", True)
CreateData
Create_server_detail
sql1.close
End If
Dim message, title As String
message = "Server Database Generated Successful."
title = "Successful"
Msgbox.Show(message, title)
End Sub
Sub Encrypt(testo As String) As Byte()
Dim ByteArray() As Byte
ByteArray=cifro.Encrypt(testo.GetBytes("UTF8"), "xxxx")
Return ByteArray
End Sub