Boa noite, estou com problema quando o player desloga, ele apresenta erro na distro.

 

Spoiler

mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `item
type`, `count`, `attributes`, `serial`) VALUES (7,3,101,2000,1,'','HV2OI-DJCD3-5
3CDH-4DLT0') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `item
type`, `count`, `attributes`, `serial`) VALUES (7,3,101,2000,1,'','GKCMX-H1B1R-2
CO5D-WCUDT') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)
mysql_real_query(): INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `item
type`, `count`, `attributes`, `serial`) VALUES (7,3,101,2000,1,'','M8T78-YUDSC-1
VNBC-KQWMU') - MYSQL ERROR: Unknown column 'serial' in 'field list' (1054)

 

 

 

@eunaosei123 Vai no seu banco de dados e executa essa query:

ALTER TABLE player_items ADD serial VARCHAR(255) NOT NULL;
ALTER TABLE player_items ADD KEY (`player_id`), UNIQUE (`player_id`, `sid`);

ALTER TABLE player_depotitems ADD serial VARCHAR(255) NOT NULL;
ALTER TABLE player_depotitems ADD KEY (`player_id`), UNIQUE (`player_id`, `sid`);