Guide Usefull Sql Scripts !

[kostantinosftw]

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';

 

[Mhoska]

Thx very useful :D

[xussof]

thx muy amable

[Kupuka]

Nice.

Thank for share.

[ShitPvP]

cool share ;)

[darkprince83]

very nice script

[charcters]

very good!! :)

[Pariaz]

Very usefull, ty!

[SkySkase]

Ok thats realy nice i need that

[dymek1984]

good share ty

 

[kposkrobko]

UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe');

 

how to delete a specific ID???

 

[dymek1984]

DELETE FROM droplist WHERE itemId='1864';    (replace 1864 with your ID)

[<< Masterio >>]

just learn SQL! it will be useful:D

[snopzito]

Thanks for the great contribution friend.

[padz]

thank you... this is very helpful!