kostantinosftw Posted September 29, 2011 Posted September 29, 2011 Insert to all mobs a common skill insert into npcskills (npcId, skillid, level) select id, MY_SKILL, LEVEL_OF_MY_SKILL from npc where type='L2Monster'; Quote
kposkrobko Posted September 3, 2012 Posted September 3, 2012 UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe'); how to delete a specific ID??? Quote
dymek1984 Posted September 4, 2012 Posted September 4, 2012 DELETE FROM droplist WHERE itemId='1864'; (replace 1864 with your ID) Quote
<< Masterio >> Posted September 17, 2012 Posted September 17, 2012 just learn SQL! it will be useful:D Quote
snopzito Posted September 17, 2012 Posted September 17, 2012 Thanks for the great contribution friend. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.