evilgenx Posted November 1, 2009 Posted November 1, 2009 Nice. Saves a buncha time! Tnx a bunch for these queries! Quote
ksipos Posted November 1, 2009 Posted November 1, 2009 Nc share but i have a question... How can i add this scripts in my server???? Quote
t0p3a Posted November 1, 2009 Posted November 1, 2009 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 Quote
1tm Posted November 1, 2009 Posted November 1, 2009 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... Quote
ksipos Posted November 1, 2009 Posted November 1, 2009 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 :) Quote
badriniki Posted November 22, 2009 Author Posted November 22, 2009 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) ^^ Quote
bauwbas Posted November 30, 2009 Posted November 30, 2009 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 Quote
AwakenDemon Posted November 30, 2009 Posted November 30, 2009 nice guide but.. not 100% completed keep it updated! Quote
MrPerfect20 Posted December 1, 2009 Posted December 1, 2009 very nice share dude ^_^ I tested and it all works good !!! Keep up the good work :D Quote
badriniki Posted December 6, 2009 Author Posted December 6, 2009 On 12/1/2009 at 8:24 AM, MrPerfect20 said: very nice share dude ^_^ I tested and it all works good !!! Keep up the good work :D Thanks =) Quote
bauwbas Posted December 7, 2009 Posted December 7, 2009 On 12/6/2009 at 3:14 PM, badriniki said: Thanks =) its for my code :D Quote
EdenEternal Posted April 15, 2010 Posted April 15, 2010 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 ; 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.