Em 18/09/2015 em 02:02, peckface disse:

DROP TABLE IF EXISTS `player_skills`;

CREATE TABLE `player_skills`

(

    `player_id` INT NOT NULL,

    `skillid` TINYINT(2) NOT NULL DEFAULT 0,

    `value` INT UNSIGNED NOT NULL DEFAULT 0,

    `count` INT UNSIGNED NOT NULL DEFAULT 0,

    KEY (`player_id`), UNIQUE (`player_id`, `skillid`),

    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

DROP TABLE IF EXISTS `player_skills` ;# MySQL não retornou nenhum registo.

CREATE TABLE `player_skills` (

`player_id` INT NOT NULL ,

`skillid` TINYINT( 2 ) NOT NULL DEFAULT 0,

`value` INT UNSIGNED NOT NULL DEFAULT 0,

`count` INT UNSIGNED NOT NULL DEFAULT 0,

KEY ( `player_id` ) ,

UNIQUE (

`player_id` ,

`skillid`

),

FOREIGN KEY ( `player_id` ) REFERENCES `players` ( `id` ) ON DELETE CASCADE

) ENGINE = INNODB;# MySQL não retornou nenhum registo.

testa agora no game

  Em 18/09/2015 em 02:09, peckface disse:

testa agora no game

Agora da outro tipo de erro

`skill_fist` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_club` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_sword` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_sword_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_axe` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_axe_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_dist` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_dist_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_shielding` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_shielding_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  Em 18/09/2015 em 02:33, peckface disse:

 

`skill_fist` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_club` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_sword` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_sword_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_axe` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_axe_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_dist` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_dist_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

  `skill_shielding` int(10) unsigned NOT NULL DEFAULT '10',

  `skill_shielding_tries` bigint(20) unsigned NOT NULL DEFAULT '0',

 

o seguinte 

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`skill_fist` int(10) unsigned NOT NULL DEFAULT '10', `skill_fist_tries` bigin' at line 1