Jump to content

Recommended Posts

Posted

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

Posted
  On 11/1/2009 at 11:01 AM, t0p3a said:

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...

Posted
  On 11/1/2009 at 11:51 AM, 1tm said:

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

 

ty for your help bro :)

  • 2 weeks later...
Posted

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) ^^

Posted

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

  • 4 months later...
Posted

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 ;

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock