• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Need Help Player_charms doesnt exist help

SQL:
CREATE TABLE `player_charms` (
  `id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `charm` varchar(20) DEFAULT NULL,
  `monster` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
SQL:
CREATE TABLE `player_charms` (
  `id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `charm` varchar(20) DEFAULT NULL,
  `monster` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Found it, will post it in here, if someone has the same problem.
SQL:
CREATE TABLE IF NOT EXISTS `player_charms` (
`player_guid` INT(250) NOT NULL ,
`charm_points` VARCHAR(250) NULL ,
`charm_expansion` BOOLEAN NULL ,
`rune_wound` INT(250) NULL ,
`rune_enflame` INT(250) NULL ,
`rune_poison` INT(250) NULL ,
`rune_freeze` INT(250) NULL ,
`rune_zap` INT(250) NULL ,
`rune_curse` INT(250) NULL ,
`rune_cripple` INT(250) NULL ,
`rune_parry` INT(250) NULL ,
`rune_dodge` INT(250) NULL ,
`rune_adrenaline` INT(250) NULL ,
`rune_numb` INT(250) NULL,
`rune_cleanse` INT(250) NULL ,
`rune_bless` INT(250) NULL ,
`rune_scavenge` INT(250) NULL ,
`rune_gut` INT(250) NULL ,
`rune_low_blow` INT(250) NULL ,
`rune_divine` INT(250) NULL ,
`rune_vamp` INT(250) NULL ,
`rune_void` INT(250) NULL ,
`UsedRunesBit` VARCHAR(250) NULL ,
`UnlockedRunesBit` VARCHAR(250) NULL,
`tracker list` BLOB NULL ) ENGINE = InnoDB DEFAULT CHARSET=utf8;
 
Last edited:
Back
Top