Database - User/Pw

[zxtnt09]

hi all ,

it's my gui for user/password : 

#include <ButtonConstants.au3>
#include <EditConstants.au3>
#include <GUIConstantsEx.au3>
#include <ProgressConstants.au3>
#include <StaticConstants.au3>
#include <WindowsConstants.au3>

$LOGIN = GUICreate("The SW-Robot - Login", 371, 132, 400, 400)
GUISetBkColor(0xFFFFFF)
$usernametxt = GUICtrlCreateLabel("Username:", 8, 16, 55, 17)
GUICtrlCreateInput("", 88, 16, 161, 21)
GUICtrlCreateInput("", 88, 48, 161, 21, BitOR($GUI_SS_DEFAULT_INPUT,$ES_PASSWORD))
GUICtrlCreateInput("", 88, 80, 73, 21, BitOR($GUI_SS_DEFAULT_INPUT,$ES_PASSWORD))
$ok = GUICtrlCreateButton("OK", 280, 8, 81, 25)
GUICtrlSetBkColor(-1, 0xA6CAF0)
$cancel = GUICtrlCreateButton("Cancel", 280, 48, 81, 25)
GUICtrlSetBkColor(-1, 0xA6CAF0)
$passwordtxt = GUICtrlCreateLabel("Password:", 8, 48, 53, 17)
$Progress1 = GUICtrlCreateProgress(0, 112, 369, 17)
GUICtrlSetColor(-1, 0xA6CAF0)
$PIN = GUICtrlCreateLabel("PIN:", 8, 80, 25, 17)
GUISetState(@SW_SHOW)


;Loop Info
While 1
    $nMsg = GUIGetMsg()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit
         Case $exit
            Exit
    EndSwitch
WEnd

it's sql (if similar like that is good) : 

expandcollapse popup

-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 02, 2015 at 12:58 PM
-- Server version: 5.5.42-cll
-- PHP Version: 5.4.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `user-pass`
--

-- --------------------------------------------------------

--
-- Table structure for table `qa_users`
--

CREATE TABLE IF NOT EXISTS `qa_users` (
  `userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `createip` int(10) unsigned NOT NULL,
  `email` varchar(80) NOT NULL,
  `handle` varchar(20) NOT NULL,
  `avatarblobid` bigint(20) unsigned DEFAULT NULL,
  `avatarwidth` smallint(5) unsigned DEFAULT NULL,
  `avatarheight` smallint(5) unsigned DEFAULT NULL,
  `passsalt` binary(16) DEFAULT NULL,
  `passcheck` binary(20) DEFAULT NULL,
  `level` tinyint(3) unsigned NOT NULL,
  `loggedin` datetime NOT NULL,
  `loginip` int(10) unsigned NOT NULL,
  `written` datetime DEFAULT NULL,
  `writeip` int(10) unsigned DEFAULT NULL,
  `emailcode` char(8) CHARACTER SET ascii NOT NULL DEFAULT '',
  `sessioncode` char(8) CHARACTER SET ascii NOT NULL DEFAULT '',
  `sessionsource` varchar(16) CHARACTER SET ascii DEFAULT '',
  `flags` smallint(5) unsigned NOT NULL DEFAULT '0',
  `wallposts` mediumint(9) NOT NULL DEFAULT '0',
  `oemail` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`userid`),
  KEY `email` (`email`),
  KEY `handle` (`handle`),
  KEY `level` (`level`),
  KEY `created` (`created`,`level`,`flags`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `qa_users`
--

INSERT INTO `qa_users` (`userid`, `created`, `createip`, `email`, `handle`, `avatarblobid`, `avatarwidth`, `avatarheight`, `passsalt`, `passcheck`, `level`, `loggedin`, `loginip`, `written`, `writeip`, `emailcode`, `sessioncode`, `sessionsource`, `flags`, `wallposts`, `oemail`) VALUES
(1, '2015-04-22 23:09:10', 0, 'test@test.com', 'user1', NULL, NULL, NULL, 'slerghuszc1h4mq7', '·P¬Yµmb5y;آ&Prsخ', 0, '2015-04-23 02:46:04', 1495437458, '2015-04-23 02:47:52', 1495437458, '', '8ecelb1o', NULL, 1, 0, NULL);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

and mysql for xampp (example) has been attached,

how can i create a user/password connection ( by xampp and or cpanel )

thanks

mysql.zip

Edited May 7, 2015 by zxtnt09
Attached / Add Ex Url