thanks mam!!!!
ill gonna test it later.. and ill post for the update!! XD
: DB error - Data truncated for column 'identify' at row 1[Debug]: at ..\src\map\script.c:14407 - insert into auction_item values ( null,150025, 'Perfection', now(), 25149, 1, 0, 0, 0, 0, 0, 0, 0 ) [Debug]: Source (NPC): kjsdhfksh at prontera (155,186) [Error]: script:delitem2: failed to delete 1 items (AID=2000000 item_id=25149). [Debug]: Source (NPC): kjsdhfksh at prontera (155,186) [color=#880000]create table auction_item ( auction_id int(11) primary key auto_increment, seller_id int(11), seller_name varchar(23), time datetime, nameid smallint(6), amount smallint(6), identify enum('0','1'), refine tinyint(3), attribute enum('0','1'), card0 smallint(6), card1 smallint(6), card2 smallint(6), card3 smallint(6) ) engine = innodb; drop table auction_item; create table auction_bidder ( id int(11) primary key auto_increment, auction_id int(11), buyer_id int(11), buyer_name varchar(23), time datetime, nameid smallint(6), amount smallint(6), identify enum('0','1'), refine tinyint(3), attribute enum('0','1'), card0 smallint(6), card1 smallint(6), card2 smallint(6), card3 smallint(6) ) engine = innodb; drop table auction_bidder;[/color] i remove the drop table in the end