L2J Server

L2J Server Discussion Board
https://l2jserver.com/forum/

Sql file to insert drops

https://l2jserver.com/forum/viewtopic.php?t=15292

Page 1 of 1

Sql file to insert drops

Posted: Thu Jan 21, 2010 1:29 pm
by 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

Re: Sql file to insert drops

Posted: Thu Jan 21, 2010 2:17 pm
by 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 :)

Re: Sql file to insert drops

Posted: Thu Jan 21, 2010 2:33 pm
by tropheo

Code: Select all

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

Re: Sql file to insert drops

Posted: Sat Jan 23, 2010 1:57 am
by 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.

Re: Sql file to insert drops

Posted: Sat Jan 23, 2010 2:04 am
by ADONES
okok (: i got it already..

ty in advance

Re: Sql file to insert drops

Posted: Fri Jan 29, 2010 9:09 am
by 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

Re: Sql file to insert drops

Posted: Fri Jan 29, 2010 9:19 am
by 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 .

Re: Sql file to insert drops

Posted: Fri Jan 29, 2010 10:09 am
by ADONES
can i use replace for all? or only for them they are already inside?

Re: Sql file to insert drops

Posted: Fri Jan 29, 2010 10:19 am
by janiii
ADONES wrote: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.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited