• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[ C#/.NET](Source) Complete HWID Login System with Admin Controls

Wrapzii

New member
The database....

Glad you like it. There is a SQL file in /sql/ that you use to import in your database.

If it's not in the .rar, then run this query on your DB:
Code:
CREATE DATABASE IF NOT EXISTS `accounts` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `accounts`;

CREATE TABLE IF NOT EXISTS `keys` (
  `keystring` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `user` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(85) NOT NULL,
  `password` varchar(45) NOT NULL,
  `keystring` varchar(12) NOT NULL,
  `hwid` text NOT NULL,
  `status` tinyint(2) NOT NULL,
  PRIMARY KEY (`Id`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

The Database doesnt specifically need to named 'accounts' right?
Because i get this error when trying to add it to my database on my site
082ed7cdd34c48bf9ba5b4d15785db27.png


but i have the tables and everything and i put my info into the config yet it still wont connect/retrieve....
 

Tommy

Founder
The Database doesnt specifically need to named 'accounts' right?
Because i get this error when trying to add it to my database on my site
082ed7cdd34c48bf9ba5b4d15785db27.png


but i have the tables and everything and i put my info into the config yet it still wont connect/retrieve....

That's on your side since it is denying access.
 

Hyperion

Founder
so you're saying that the database needs to be called 'Accounts'?

The database can be called whatever you'd like. You just have to make sure it matches the DB information you put in the config.
Remember that names and passwords will be CaSe SeNSiTiVe.
 

Wrapzii

New member
The database can be called whatever you'd like. You just have to make sure it matches the DB information you put in the config.
Remember that names and passwords will be CaSe SeNSiTiVe.

yea.. i figured i've changed the password like 3 times still not working :p its whatever maybe my host is just dumb....
 
Top