Guide Usefull Sql Scripts !

[evilgenx]

Nice. Saves a buncha time!  Tnx a bunch for these queries!

[ksipos]

Nc share but i have a question...

How can i add this scripts in my server????

[t0p3a]

make new text document write the code inside after go to save as and save it like name.sql or whatever u want ...after drop the sql file in navicat and click the pop-up run batch file

[1tm]

make new text document write the code inside after go to save as and save it like name.sql or whatever u want ...after drop the sql file in navicat and click the pop-up run batch file

Or you just can press F6 (open console) at navicat, paste text to console and click enter...

[ksipos]

Or you just can press F6 (open console) at navicat, paste text to console and click enter...

 

ty for your help bro :)

[mariucha]

usefull for noobs like me hahaha

[badriniki]

ahaha :P

[badriniki]

Now you found it ^^

[badriniki]

To enchant skill doesn't need exp/sp:

Good one for high rates servers or faction servers..

Code:

UPDATE enchant_skill_trees SET sp=0;

UPDATE enchant_skill_trees SET exp=0;

 

Don't work i have tested, write don't have items to enchant skill(but i have the books and sp/xp) ^^

[bauwbas]

This sql split min and max adena from 4 (from droplist. usefull for servers which want low adena drop, like in l2gold)

 

UPDATE droplist SET min = min / 4 WHERE itemId = '57';
UPDATE droplist SET max = max / 4 WHERE itemId = '57';

 

sorry, for terible english :D

[AwakenDemon]

nice guide but.. not 100% completed keep it updated!

[MrPerfect20]

very nice share dude ^_^

I tested and it all works good !!!

Keep up the good work :D

[badriniki]

very nice share dude ^_^

I tested and it all works good !!!

Keep up the good work :D

Thanks =)

[bauwbas]

Thanks =)

its for my code :D

[EdenEternal]

Custom Spawn in Giran Castle Town & items.(For Fighters Theca Leather Armor Set and Crystal Dagger.For Mystics Karmian Robe Set and Homunkulus's Sword)

UPDATE `char_templates` SET `x` = '83400',
`y` = '147943',
`z` = '-3404';
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =0 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =18 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =31 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =44 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '420',
`items2` = '400',
`items3` = '2436',
`items4` = '6358',
`items5` = '2460' WHERE `char_templates`.`ClassId` =53 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =10 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =25 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =38 LIMIT 1 ;
UPDATE `char_templates` SET `items1` = '439',
`items2` = '471',
`items3` = '2430',
`items4` = '2454',
`items5` = '6313' WHERE `char_templates`.`ClassId` =49 LIMIT 1 ;