Sql file to insert drops

[ADONES]

Hello everybody,

i wanted to ask if someone can tell me how to whrite a sql file to add drops to some mobs...

for example i want to add 10 Stem to the drop of Antharas..

ty in advance
yours Adones

[janiii]

you can also insert drops in game from admin menu. just shift-click the mob and then edit it's droplist. for category explanation read the droplist.sql file comments

[tropheo]

Code: Select all

INSERT INTO `droplist` VALUES ('NpcID, 'ItemID', 'MinDrop', 'MaxDrop', 'Category', 'Chance'); 

[ADONES]

thank you very much for ur help...

i added 3 items to the drop but the mobs drop only 1 item each time thay get killed.. how can i setup them to drop all my added items? all mine are category 1.

[ADONES]

okok (: i got it already..

ty in advance

[ADONES]

Hello,

I still got a problem with my sql file... If i try to load them into my databank, I get the error "Unsuccessfully" ...

can someone take a look at my file please..

Code: Select all

INSERT INTO `droplist` VALUES ('29028, '10552', '1', '1', '601', '70000'),INSERT INTO `droplist` VALUES ('29028, '10553', '1', '1', '602', '70000'),INSERT INTO `droplist` VALUES ('29028, '10554', '1', '1', '603', '70000'),INSERT INTO `droplist` VALUES ('29028, '10555', '1', '1', '604', '70000'),INSERT INTO `droplist` VALUES ('29028, '10556', '1', '1', '605', '70000'),INSERT INTO `droplist` VALUES ('29028, '10559', '1', '1', '606', '70000'),INSERT INTO `droplist` VALUES ('29028, '10560', '1', '1', '607', '70000'),INSERT INTO `droplist` VALUES ('29028, '10561', '1', '1', '608', '70000'),INSERT INTO `droplist` VALUES ('29028, '10562', '1', '1', '609', '70000'),INSERT INTO `droplist` VALUES ('29028, '10563', '1', '1', '610', '70000'),INSERT INTO `droplist` VALUES ('29028, '10564', '1', '1', '611', '70000'),INSERT INTO `droplist` VALUES ('29028, '10565', '1', '1', '612', '70000'),INSERT INTO `droplist` VALUES ('29028, '10566', '1', '1', '613', '70000'),INSERT INTO `droplist` VALUES ('29028, '10567', '1', '1', '614', '70000'),INSERT INTO `droplist` VALUES ('29028, '10568', '1', '1', '615', '70000'),INSERT INTO `droplist` VALUES ('29028, '10569', '1', '1', '616', '70000'),INSERT INTO `droplist` VALUES ('29028, '10570', '1', '1', '617', '70000'),INSERT INTO `droplist` VALUES ('29028, '10571', '1', '1', '618', '70000'),INSERT INTO `droplist` VALUES ('29028, '10572', '1', '1', '619', '70000'),INSERT INTO `droplist` VALUES ('29028, '10573', '1', '1', '620', '70000'),INSERT INTO `droplist` VALUES ('29028, '10574', '1', '1', '621', '70000'),INSERT INTO `droplist` VALUES ('29028, '10575', '1', '1', '622', '70000'),INSERT INTO `droplist` VALUES ('29028, '10576', '1', '1', '623', '70000'),INSERT INTO `droplist` VALUES ('29028, '10577', '1', '1', '624', '70000'),INSERT INTO `droplist` VALUES ('29028, '10578', '1', '1', '625', '70000'),INSERT INTO `droplist` VALUES ('29028, '10585', '1', '1', '626', '70000'),INSERT INTO `droplist` VALUES ('29028, '10586', '1', '1', '627', '70000'),INSERT INTO `droplist` VALUES ('29028, '10587', '1', '1', '628', '70000'),INSERT INTO `droplist` VALUES ('29028, '10588', '1', '1', '629', '70000'),INSERT INTO `droplist` VALUES ('29028, '10589', '1', '1', '630', '70000'),INSERT INTO `droplist` VALUES ('29028, '10591', '1', '1', '631', '70000'),INSERT INTO `droplist` VALUES ('29028, '10592', '1', '1', '632', '70000'),INSERT INTO `droplist` VALUES ('29028, '10593', '1', '1', '633', '70000'),INSERT INTO `droplist` VALUES ('29028, '10594', '1', '1', '634', '70000'),INSERT INTO `droplist` VALUES ('29028, '10595', '1', '1', '635', '70000'),INSERT INTO `droplist` VALUES ('29028, '14197', '1', '1', '636', '70000'),INSERT INTO `droplist` VALUES ('29028, '14198', '1', '1', '637', '70000'),INSERT INTO `droplist` VALUES ('29028, '14199', '1', '1', '638', '70000'),INSERT INTO `droplist` VALUES ('29028, '14200', '1', '1', '639', '70000'),INSERT INTO `droplist` VALUES ('29028, '14201', '1', '1', '640', '70000'),INSERT INTO `droplist` VALUES ('29028, '14202', '1', '1', '641', '70000'),INSERT INTO `droplist` VALUES ('29028, '14204', '1', '1', '642', '70000'),INSERT INTO `droplist` VALUES ('29028, '14205', '1', '1', '643', '70000'),INSERT INTO `droplist` VALUES ('29028, '14026', '1', '1', '644', '70000'),INSERT INTO `droplist` VALUES ('29028, '14207', '1', '1', '645', '70000'),INSERT INTO `droplist` VALUES ('29028, '14208', '1', '1', '646', '70000'),INSERT INTO `droplist` VALUES ('29028, '14209', '1', '1', '647', '70000'),INSERT INTO `droplist` VALUES ('29028, '14210', '1', '1', '648', '70000'),INSERT INTO `droplist` VALUES ('29028, '14211', '1', '1', '649', '70000'),INSERT INTO `droplist` VALUES ('29028, '14212', '1', '1', '650', '70000'),INSERT INTO `droplist` VALUES ('29028, '14213', '1', '1', '651', '70000'),INSERT INTO `droplist` VALUES ('29028, '14218', '1', '1', '652', '70000'),INSERT INTO `droplist` VALUES ('29028, '14219', '1', '1', '653', '70000'),INSERT INTO `droplist` VALUES ('29028, '14227', '1', '1', '654', '70000'),INSERT INTO `droplist` VALUES ('29028, '10549', '1', '1', '655', '70000'),INSERT INTO `droplist` VALUES ('29028, '10550', '1', '1', '656', '70000'),INSERT INTO `droplist` VALUES ('29028, '10551', '1', '1', '657', '70000'),INSERT INTO `droplist` VALUES ('29020, '10552', '1', '1', '601', '70000'),INSERT INTO `droplist` VALUES ('29020, '10553', '1', '1', '602', '70000'),INSERT INTO `droplist` VALUES ('29020, '10554', '1', '1', '603', '70000'),INSERT INTO `droplist` VALUES ('29020, '10555', '1', '1', '604', '70000'),INSERT INTO `droplist` VALUES ('29020, '10556', '1', '1', '605', '70000'),INSERT INTO `droplist` VALUES ('29020, '10559', '1', '1', '606', '70000'),INSERT INTO `droplist` VALUES ('29020, '10560', '1', '1', '607', '70000'),INSERT INTO `droplist` VALUES ('29020, '10561', '1', '1', '608', '70000'),INSERT INTO `droplist` VALUES ('29020, '10562', '1', '1', '609', '70000'),INSERT INTO `droplist` VALUES ('29020, '10563', '1', '1', '610', '70000'),INSERT INTO `droplist` VALUES ('29020, '10564', '1', '1', '611', '70000'),INSERT INTO `droplist` VALUES ('29020, '10565', '1', '1', '612', '70000'),INSERT INTO `droplist` VALUES ('29020, '10566', '1', '1', '613', '70000'),INSERT INTO `droplist` VALUES ('29020, '10567', '1', '1', '614', '70000'),INSERT INTO `droplist` VALUES ('29020, '10568', '1', '1', '615', '70000'),INSERT INTO `droplist` VALUES ('29020, '10569', '1', '1', '616', '70000'),INSERT INTO `droplist` VALUES ('29020, '10570', '1', '1', '617', '70000'),INSERT INTO `droplist` VALUES ('29020, '10571', '1', '1', '618', '70000'),INSERT INTO `droplist` VALUES ('29020, '10572', '1', '1', '619', '70000'),INSERT INTO `droplist` VALUES ('29020, '10573', '1', '1', '620', '70000'),INSERT INTO `droplist` VALUES ('29020, '10574', '1', '1', '621', '70000'),INSERT INTO `droplist` VALUES ('29020, '10575', '1', '1', '622', '70000'),INSERT INTO `droplist` VALUES ('29020, '10576', '1', '1', '623', '70000'),INSERT INTO `droplist` VALUES ('29020, '10577', '1', '1', '624', '70000'),INSERT INTO `droplist` VALUES ('29020, '10578', '1', '1', '625', '70000'),INSERT INTO `droplist` VALUES ('29020, '10585', '1', '1', '626', '70000'),INSERT INTO `droplist` VALUES ('29020, '10586', '1', '1', '627', '70000'),INSERT INTO `droplist` VALUES ('29020, '10587', '1', '1', '628', '70000'),INSERT INTO `droplist` VALUES ('29020, '10588', '1', '1', '629', '70000'),INSERT INTO `droplist` VALUES ('29020, '10589', '1', '1', '630', '70000'),INSERT INTO `droplist` VALUES ('29020, '10591', '1', '1', '631', '70000'),INSERT INTO `droplist` VALUES ('29020, '10592', '1', '1', '632', '70000'),INSERT INTO `droplist` VALUES ('29020, '10593', '1', '1', '633', '70000'),INSERT INTO `droplist` VALUES ('29020, '10594', '1', '1', '634', '70000'),INSERT INTO `droplist` VALUES ('29020, '10595', '1', '1', '635', '70000'),INSERT INTO `droplist` VALUES ('29020, '14197', '1', '1', '636', '70000'),INSERT INTO `droplist` VALUES ('29020, '14198', '1', '1', '637', '70000'),INSERT INTO `droplist` VALUES ('29020, '14199', '1', '1', '638', '70000'),INSERT INTO `droplist` VALUES ('29020, '14200', '1', '1', '639', '70000'),INSERT INTO `droplist` VALUES ('29020, '14201', '1', '1', '640', '70000'),INSERT INTO `droplist` VALUES ('29020, '14202', '1', '1', '641', '70000'),INSERT INTO `droplist` VALUES ('29020, '14204', '1', '1', '642', '70000'),INSERT INTO `droplist` VALUES ('29020, '14205', '1', '1', '643', '70000'),INSERT INTO `droplist` VALUES ('29020, '14026', '1', '1', '644', '70000'),INSERT INTO `droplist` VALUES ('29020, '14207', '1', '1', '645', '70000'),INSERT INTO `droplist` VALUES ('29020, '14208', '1', '1', '646', '70000'),INSERT INTO `droplist` VALUES ('29020, '14209', '1', '1', '647', '70000'),INSERT INTO `droplist` VALUES ('29020, '14210', '1', '1', '648', '70000'),INSERT INTO `droplist` VALUES ('29020, '14211', '1', '1', '649', '70000'),INSERT INTO `droplist` VALUES ('29020, '14212', '1', '1', '650', '70000'),INSERT INTO `droplist` VALUES ('29020, '14213', '1', '1', '651', '70000'),INSERT INTO `droplist` VALUES ('29020, '14218', '1', '1', '652', '70000'),INSERT INTO `droplist` VALUES ('29020, '14219', '1', '1', '653', '70000'),INSERT INTO `droplist` VALUES ('29020, '14227', '1', '1', '654', '70000'),INSERT INTO `droplist` VALUES ('29020, '10549', '1', '1', '655', '70000'),INSERT INTO `droplist` VALUES ('29020, '10550', '1', '1', '656', '70000'),INSERT INTO `droplist` VALUES ('29020, '10551', '1', '1', '657', '70000'),INSERT INTO `droplist` VALUES ('29019, '10552', '1', '1', '601', '70000'),INSERT INTO `droplist` VALUES ('29019, '10553', '1', '1', '602', '70000'),INSERT INTO `droplist` VALUES ('29019, '10554', '1', '1', '603', '70000'),INSERT INTO `droplist` VALUES ('29019, '10555', '1', '1', '604', '70000'),INSERT INTO `droplist` VALUES ('29019, '10556', '1', '1', '605', '70000'),INSERT INTO `droplist` VALUES ('29019, '10559', '1', '1', '606', '70000'),INSERT INTO `droplist` VALUES ('29019, '10560', '1', '1', '607', '70000'),INSERT INTO `droplist` VALUES ('29019, '10561', '1', '1', '608', '70000'),INSERT INTO `droplist` VALUES ('29019, '10562', '1', '1', '609', '70000'),INSERT INTO `droplist` VALUES ('29019, '10563', '1', '1', '610', '70000'),INSERT INTO `droplist` VALUES ('29019, '10564', '1', '1', '611', '70000'),INSERT INTO `droplist` VALUES ('29019, '10565', '1', '1', '612', '70000'),INSERT INTO `droplist` VALUES ('29019, '10566', '1', '1', '613', '70000'),INSERT INTO `droplist` VALUES ('29019, '10567', '1', '1', '614', '70000'),INSERT INTO `droplist` VALUES ('29019, '10568', '1', '1', '615', '70000'),INSERT INTO `droplist` VALUES ('29019, '10569', '1', '1', '616', '70000'),INSERT INTO `droplist` VALUES ('29019, '10570', '1', '1', '617', '70000'),INSERT INTO `droplist` VALUES ('29019, '10571', '1', '1', '618', '70000'),INSERT INTO `droplist` VALUES ('29019, '10572', '1', '1', '619', '70000'),INSERT INTO `droplist` VALUES ('29019, '10573', '1', '1', '620', '70000'),INSERT INTO `droplist` VALUES ('29019, '10574', '1', '1', '621', '70000'),INSERT INTO `droplist` VALUES ('29019, '10575', '1', '1', '622', '70000'),INSERT INTO `droplist` VALUES ('29019, '10576', '1', '1', '623', '70000'),INSERT INTO `droplist` VALUES ('29019, '10577', '1', '1', '624', '70000'),INSERT INTO `droplist` VALUES ('29019, '10578', '1', '1', '625', '70000'),INSERT INTO `droplist` VALUES ('29019, '10585', '1', '1', '626', '70000'),INSERT INTO `droplist` VALUES ('29019, '10586', '1', '1', '627', '70000'),INSERT INTO `droplist` VALUES ('29019, '10587', '1', '1', '628', '70000'),INSERT INTO `droplist` VALUES ('29019, '10588', '1', '1', '629', '70000'),INSERT INTO `droplist` VALUES ('29019, '10589', '1', '1', '630', '70000'),INSERT INTO `droplist` VALUES ('29019, '10591', '1', '1', '631', '70000'),INSERT INTO `droplist` VALUES ('29019, '10592', '1', '1', '632', '70000'),INSERT INTO `droplist` VALUES ('29019, '10593', '1', '1', '633', '70000'),INSERT INTO `droplist` VALUES ('29019, '10594', '1', '1', '634', '70000'),INSERT INTO `droplist` VALUES ('29019, '10595', '1', '1', '635', '70000'),INSERT INTO `droplist` VALUES ('29019, '14197', '1', '1', '636', '70000'),INSERT INTO `droplist` VALUES ('29019, '14198', '1', '1', '637', '70000'),INSERT INTO `droplist` VALUES ('29019, '14199', '1', '1', '638', '70000'),INSERT INTO `droplist` VALUES ('29019, '14200', '1', '1', '639', '70000'),INSERT INTO `droplist` VALUES ('29019, '14201', '1', '1', '640', '70000'),INSERT INTO `droplist` VALUES ('29019, '14202', '1', '1', '641', '70000'),INSERT INTO `droplist` VALUES ('29019, '14204', '1', '1', '642', '70000'),INSERT INTO `droplist` VALUES ('29019, '14205', '1', '1', '643', '70000'),INSERT INTO `droplist` VALUES ('29019, '14026', '1', '1', '644', '70000'),INSERT INTO `droplist` VALUES ('29019, '14207', '1', '1', '645', '70000'),INSERT INTO `droplist` VALUES ('29019, '14208', '1', '1', '646', '70000'),INSERT INTO `droplist` VALUES ('29019, '14209', '1', '1', '647', '70000'),INSERT INTO `droplist` VALUES ('29019, '14210', '1', '1', '648', '70000'),INSERT INTO `droplist` VALUES ('29019, '14211', '1', '1', '649', '70000'),INSERT INTO `droplist` VALUES ('29019, '14212', '1', '1', '650', '70000'),INSERT INTO `droplist` VALUES ('29019, '14213', '1', '1', '651', '70000'),INSERT INTO `droplist` VALUES ('29019, '14218', '1', '1', '652', '70000'),INSERT INTO `droplist` VALUES ('29019, '14219', '1', '1', '653', '70000'),INSERT INTO `droplist` VALUES ('29019, '14227', '1', '1', '654', '70000'),INSERT INTO `droplist` VALUES ('29019, '10549', '1', '1', '655', '70000'),INSERT INTO `droplist` VALUES ('29019, '10550', '1', '1', '656', '70000'),INSERT INTO `droplist` VALUES ('29019, '10551', '1', '1', '657', '70000'),INSERT INTO `droplist` VALUES ('29099, '10552', '1', '1', '601', '70000'),INSERT INTO `droplist` VALUES ('29099, '10553', '1', '1', '602', '70000'),INSERT INTO `droplist` VALUES ('29099, '10554', '1', '1', '603', '70000'),INSERT INTO `droplist` VALUES ('29099, '10555', '1', '1', '604', '70000'),INSERT INTO `droplist` VALUES ('29099, '10556', '1', '1', '605', '70000'),INSERT INTO `droplist` VALUES ('29099, '10559', '1', '1', '606', '70000'),INSERT INTO `droplist` VALUES ('29099, '10560', '1', '1', '607', '70000'),INSERT INTO `droplist` VALUES ('29099, '10561', '1', '1', '608', '70000'),INSERT INTO `droplist` VALUES ('29099, '10562', '1', '1', '609', '70000'),INSERT INTO `droplist` VALUES ('29099, '10563', '1', '1', '610', '70000'),INSERT INTO `droplist` VALUES ('29099, '10564', '1', '1', '611', '70000'),INSERT INTO `droplist` VALUES ('29099, '10565', '1', '1', '612', '70000'),INSERT INTO `droplist` VALUES ('29099, '10566', '1', '1', '613', '70000'),INSERT INTO `droplist` VALUES ('29099, '10567', '1', '1', '614', '70000'),INSERT INTO `droplist` VALUES ('29099, '10568', '1', '1', '615', '70000'),INSERT INTO `droplist` VALUES ('29099, '10569', '1', '1', '616', '70000'),INSERT INTO `droplist` VALUES ('29099, '10570', '1', '1', '617', '70000'),INSERT INTO `droplist` VALUES ('29099, '10571', '1', '1', '618', '70000'),INSERT INTO `droplist` VALUES ('29099, '10572', '1', '1', '619', '70000'),INSERT INTO `droplist` VALUES ('29099, '10573', '1', '1', '620', '70000'),INSERT INTO `droplist` VALUES ('29099, '10574', '1', '1', '621', '70000'),INSERT INTO `droplist` VALUES ('29099, '10575', '1', '1', '622', '70000'),INSERT INTO `droplist` VALUES ('29099, '10576', '1', '1', '623', '70000'),INSERT INTO `droplist` VALUES ('29099, '10577', '1', '1', '624', '70000'),INSERT INTO `droplist` VALUES ('29099, '10578', '1', '1', '625', '70000'),INSERT INTO `droplist` VALUES ('29099, '10585', '1', '1', '626', '70000'),INSERT INTO `droplist` VALUES ('29099, '10586', '1', '1', '627', '70000'),INSERT INTO `droplist` VALUES ('29099, '10587', '1', '1', '628', '70000'),INSERT INTO `droplist` VALUES ('29099, '10588', '1', '1', '629', '70000'),INSERT INTO `droplist` VALUES ('29099, '10589', '1', '1', '630', '70000'),INSERT INTO `droplist` VALUES ('29099, '10591', '1', '1', '631', '70000'),INSERT INTO `droplist` VALUES ('29099, '10592', '1', '1', '632', '70000'),INSERT INTO `droplist` VALUES ('29099, '10593', '1', '1', '633', '70000'),INSERT INTO `droplist` VALUES ('29099, '10594', '1', '1', '634', '70000'),INSERT INTO `droplist` VALUES ('29099, '10595', '1', '1', '635', '70000'),INSERT INTO `droplist` VALUES ('29099, '14197', '1', '1', '636', '70000'),INSERT INTO `droplist` VALUES ('29099, '14198', '1', '1', '637', '70000'),INSERT INTO `droplist` VALUES ('29099, '14199', '1', '1', '638', '70000'),INSERT INTO `droplist` VALUES ('29099, '14200', '1', '1', '639', '70000'),INSERT INTO `droplist` VALUES ('29099, '14201', '1', '1', '640', '70000'),INSERT INTO `droplist` VALUES ('29099, '14202', '1', '1', '641', '70000'),INSERT INTO `droplist` VALUES ('29099, '14204', '1', '1', '642', '70000'),INSERT INTO `droplist` VALUES ('29099, '14205', '1', '1', '643', '70000'),INSERT INTO `droplist` VALUES ('29099, '14026', '1', '1', '644', '70000'),INSERT INTO `droplist` VALUES ('29099, '14207', '1', '1', '645', '70000'),INSERT INTO `droplist` VALUES ('29099, '14208', '1', '1', '646', '70000'),INSERT INTO `droplist` VALUES ('29099, '14209', '1', '1', '647', '70000'),INSERT INTO `droplist` VALUES ('29099, '14210', '1', '1', '648', '70000'),INSERT INTO `droplist` VALUES ('29099, '14211', '1', '1', '649', '70000'),INSERT INTO `droplist` VALUES ('29099, '14212', '1', '1', '650', '70000'),INSERT INTO `droplist` VALUES ('29099, '14213', '1', '1', '651', '70000'),INSERT INTO `droplist` VALUES ('29099, '14218', '1', '1', '652', '70000'),INSERT INTO `droplist` VALUES ('29099, '14219', '1', '1', '653', '70000'),INSERT INTO `droplist` VALUES ('29099, '14227', '1', '1', '654', '70000'),INSERT INTO `droplist` VALUES ('29099, '10549', '1', '1', '655', '70000'),INSERT INTO `droplist` VALUES ('29099, '10550', '1', '1', '656', '70000'),INSERT INTO `droplist` VALUES ('29099, '10551', '1', '1', '657', '70000'),INSERT INTO `droplist` VALUES ('29047, '10552', '1', '1', '601', '70000'),INSERT INTO `droplist` VALUES ('29047, '10553', '1', '1', '602', '70000'),INSERT INTO `droplist` VALUES ('29047, '10554', '1', '1', '603', '70000'),INSERT INTO `droplist` VALUES ('29047, '10555', '1', '1', '604', '70000'),INSERT INTO `droplist` VALUES ('29047, '10556', '1', '1', '605', '70000'),INSERT INTO `droplist` VALUES ('29047, '10559', '1', '1', '606', '70000'),INSERT INTO `droplist` VALUES ('29047, '10560', '1', '1', '607', '70000'),INSERT INTO `droplist` VALUES ('29047, '10561', '1', '1', '608', '70000'),INSERT INTO `droplist` VALUES ('29047, '10562', '1', '1', '609', '70000'),INSERT INTO `droplist` VALUES ('29047, '10563', '1', '1', '610', '70000'),INSERT INTO `droplist` VALUES ('29047, '10564', '1', '1', '611', '70000'),INSERT INTO `droplist` VALUES ('29047, '10565', '1', '1', '612', '70000'),INSERT INTO `droplist` VALUES ('29047, '10566', '1', '1', '613', '70000'),INSERT INTO `droplist` VALUES ('29047, '10567', '1', '1', '614', '70000'),INSERT INTO `droplist` VALUES ('29047, '10568', '1', '1', '615', '70000'),INSERT INTO `droplist` VALUES ('29047, '10569', '1', '1', '616', '70000'),INSERT INTO `droplist` VALUES ('29047, '10570', '1', '1', '617', '70000'),INSERT INTO `droplist` VALUES ('29047, '10571', '1', '1', '618', '70000'),INSERT INTO `droplist` VALUES ('29047, '10572', '1', '1', '619', '70000'),INSERT INTO `droplist` VALUES ('29047, '10573', '1', '1', '620', '70000'),INSERT INTO `droplist` VALUES ('29047, '10574', '1', '1', '621', '70000'),INSERT INTO `droplist` VALUES ('29047, '10575', '1', '1', '622', '70000'),INSERT INTO `droplist` VALUES ('29047, '10576', '1', '1', '623', '70000'),INSERT INTO `droplist` VALUES ('29047, '10577', '1', '1', '624', '70000'),INSERT INTO `droplist` VALUES ('29047, '10578', '1', '1', '625', '70000'),INSERT INTO `droplist` VALUES ('29047, '10585', '1', '1', '626', '70000'),INSERT INTO `droplist` VALUES ('29047, '10586', '1', '1', '627', '70000'),INSERT INTO `droplist` VALUES ('29047, '10587', '1', '1', '628', '70000'),INSERT INTO `droplist` VALUES ('29047, '10588', '1', '1', '629', '70000'),INSERT INTO `droplist` VALUES ('29047, '10589', '1', '1', '630', '70000'),INSERT INTO `droplist` VALUES ('29047, '10591', '1', '1', '631', '70000'),INSERT INTO `droplist` VALUES ('29047, '10592', '1', '1', '632', '70000'),INSERT INTO `droplist` VALUES ('29047, '10593', '1', '1', '633', '70000'),INSERT INTO `droplist` VALUES ('29047, '10594', '1', '1', '634', '70000'),INSERT INTO `droplist` VALUES ('29047, '10595', '1', '1', '635', '70000'),INSERT INTO `droplist` VALUES ('29047, '14197', '1', '1', '636', '70000'),INSERT INTO `droplist` VALUES ('29047, '14198', '1', '1', '637', '70000'),INSERT INTO `droplist` VALUES ('29047, '14199', '1', '1', '638', '70000'),INSERT INTO `droplist` VALUES ('29047, '14200', '1', '1', '639', '70000'),INSERT INTO `droplist` VALUES ('29047, '14201', '1', '1', '640', '70000'),INSERT INTO `droplist` VALUES ('29047, '14202', '1', '1', '641', '70000'),INSERT INTO `droplist` VALUES ('29047, '14204', '1', '1', '642', '70000'),INSERT INTO `droplist` VALUES ('29047, '14205', '1', '1', '643', '70000'),INSERT INTO `droplist` VALUES ('29047, '14026', '1', '1', '644', '70000'),INSERT INTO `droplist` VALUES ('29047, '14207', '1', '1', '645', '70000'),INSERT INTO `droplist` VALUES ('29047, '14208', '1', '1', '646', '70000'),INSERT INTO `droplist` VALUES ('29047, '14209', '1', '1', '647', '70000'),INSERT INTO `droplist` VALUES ('29047, '14210', '1', '1', '648', '70000'),INSERT INTO `droplist` VALUES ('29047, '14211', '1', '1', '649', '70000'),INSERT INTO `droplist` VALUES ('29047, '14212', '1', '1', '650', '70000'),INSERT INTO `droplist` VALUES ('29047, '14213', '1', '1', '651', '70000'),INSERT INTO `droplist` VALUES ('29047, '14218', '1', '1', '652', '70000'),INSERT INTO `droplist` VALUES ('29047, '14219', '1', '1', '653', '70000'),INSERT INTO `droplist` VALUES ('29047, '14227', '1', '1', '654', '70000'),INSERT INTO `droplist` VALUES ('29047, '10549', '1', '1', '655', '70000'),INSERT INTO `droplist` VALUES ('29047, '10550', '1', '1', '656', '70000'),INSERT INTO `droplist` VALUES ('29047, '10551', '1', '1', '657', '70000');  

thank you in advance
ADONES

[janiii]

probably you are also overwriting some values of existing droplist (mobid, itemid, category is same as in the already existing entry). if you want to overwrite the values, use REPLACE INTO instead of INSERT INTO .

[ADONES]

can i use replace for all? or only for them they are already inside?

[janiii]

can i use replace for all? or only for them they are already inside?

you can use replace for all. a replace inserts new lines and replaces existing/conflicting lines and leaves without change that do not conflict at all.