Вот код создания бд. (не полный, только saga_login)
| Код |
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
CREATE SCHEMA IF NOT EXISTS `saga_login` ;
USE `saga_login`;
-- -----------------------------------------------------
-- Table `saga_login`.`list_worlds`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `saga_login`.`list_worlds` ;
CREATE TABLE IF NOT EXISTS `saga_login`.`list_worlds` (
`Id` TINYINT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,
`Name` VARCHAR(128) NOT NULL ,
`Proof` VARCHAR(128) NOT NULL ,
PRIMARY KEY (`Id`) );
-- -----------------------------------------------------
-- Table `saga_login`.`list_worldcharacters`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `saga_login`.`list_worldcharacters` ;
CREATE TABLE IF NOT EXISTS `saga_login`.`list_worldcharacters` (
`UserId` TINYINT(3) UNSIGNED NOT NULL ,
`WorldId` TINYINT(3) UNSIGNED NOT NULL ,
`CharacterCount` TINYINT(3) UNSIGNED NOT NULL ,
INDEX Index_1 (`UserId` ASC) );
-- -----------------------------------------------------
-- Table `saga_login`.`login`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `saga_login`.`login` ;
CREATE TABLE IF NOT EXISTS `saga_login`.`login` (
`UserId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`Username` VARCHAR(32) NOT NULL ,
`Password` VARCHAR(32) NOT NULL ,
`Gender` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' ,
`LastUserIP` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' ,
`LastSession` INT(10) UNSIGNED NOT NULL DEFAULT '0' ,
`ActiveSession` INT(10) UNSIGNED NOT NULL DEFAULT '0' ,
`LastLoginDate` DATETIME NULL DEFAULT NULL ,
`IsActivated` TINYINT(1) NOT NULL DEFAULT '0' ,
`IsBanned` TINYINT(1) NOT NULL DEFAULT '0' ,
`HasAgreed` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' ,
`DateOfBirth` DATE NOT NULL ,
`DateOfRegistration` DATE NOT NULL ,
`IsTestAccount` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' ,
`LastPlayedWorld` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' ,
`GmLevel` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' ,
`GameTime` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' ,
PRIMARY KEY (`UserId`, `Username`) ,
UNIQUE INDEX Username (`Username` ASC) );
|
P.S. На C# вот так код проходит на ура :
| Код |
public void CreateAcc(string name, string pass, int gender)
{
MySqlCommand command =
new MySqlCommand("INSERT INTO login (`Username`,`Password`,`Gender`, `IsActivated`, `DateOfBirth`, `DateOfRegistration`) VALUES (?AccName,?AccPass,?AccGender, 1, ?Date, ?RegDate);", conn);
command.Parameters.AddWithValue("AccName", name);
command.Parameters.AddWithValue("AccPass", CreateHash(pass));
command.Parameters.AddWithValue("AccGender", gender);
command.Parameters.AddWithValue("Date", "2000-01-01");
command.Parameters.AddWithValue("RegDate", DateTime.Today);
command.ExecuteNonQuery();
}
|
Добавлено @ 20:36
| Цитата |
@$login = mysqli_real_escape_string($dbconnect,$_POST['login']);
надо заменить на
$login = $dbconnect->real_escape_string($_POST['login']);
|
Поменял, спасибо.  |
)