vl4d Posted November 25, 2011 Posted November 25, 2011 πιστεύω ότι είναι πολύ χρήσιμο για όσους δεν ξέρουν.. για να μην έχουμε πρόβλημα με το link θα κατεβάζετε από το oficial http://www.navicat.com/en/download/download.html key: NAVL-X2W5-8G4R-5QT4 (κάνει για όλα τα rev 10) US $ 599.00 einai kanonika mazi me to key.. http://navicat.com/buynow/store.html Twra εχω δει πολλα share me sql και ακομα το κανουν με τον παλιο τροπο :P για παράδειγμα τετοιους κώδικες : 0 Weight for items/armors/weapons: Quote UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id); UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id); UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id); Drop Adena 100%: Quote UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57'; When you sell, everything will cost 0 adena: Quote UPDATE `armor` SET price=0 where price > 1; UPDATE `etcitem` SET price=0 where price > 1; UPDATE `weapon` SET price=0 where price > 1; Update all RaidBoss 5000k hp: Quote UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss'; Delete all mobs under 40 lvl: Quote DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster'; Delete all materials and recipes from db: Quote DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' ); Increase drop rate for recipes: Quote UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe'); Delete characters and accounts if they do not connect for 3 months: Quote DELETE FROM characters WHERE lastAccess < 466560000; DELETE FROM accounts WHERE lastactive < 466560000; Add for all monsters in drop: Coins Quote insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster'; Top No-Grade in start:(Need to modif for kamaels) Quote REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588); REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588); REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588); Add RaidBoss jewels if you have deleted them: Quote INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000'); INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000'); INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000'); INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000'); INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000'); INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000'); INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000'); Thx to 1tm Delete all spellbooks from db: Code: DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' ); Increases Guards (p.def, m.def, p.atk, hp) by 50%: Code: UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard'; Decreases Raidboss defense by 40%: Code: UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss'; UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss'; UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss'; All new player chars spawn loc: Code: UPDATE char_templates SET x=yourXcoordinate; UPDATE char_templates SET y=yourYcoordinate; UPDATE char_templates SET z=yourZcoordinate; Increases all chars p.def/m.def by 10%: Code: UPDATE char_templates SET P_DEF = P_DEF * 1.1; UPDATE char_templates SET M_DEF = M_DEF * 1.1; Increases all chars speed by 20%: Code: UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2; Increases all chars CP. At 20lv by 22%, at 40lv by 44%, at 76lv by 66%: This one good one for longer pvps.. Code: UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76'; UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40'; UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20'; MP rengerates 10 times more(unlimited mp): Good one for high servers who has mp potions etc.. Code: UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0; Teleports cost 0 adena: Code: UPDATE teleport SET price=0; Create common item skill delete: It used as bug at olympiad, with it you can buff with soes, mental dagers etc in secs... Code: DELETE FROM skill_trees WHERE skill_id = 1320; DELETE FROM skill_trees WHERE skill_id = 1322; Grade penality delete: Disables grade penality... Code: DELETE FROM skill_trees WHERE skill_id = 239; Raidbosses always spawns with 70% hp: More realistic that new spawned rb has not full hp. Good one for organized clans or parties... Code: UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7; Dies adding price reduced to 5 adena (or increased to 100kk): Good one for faction servers. Code: UPDATE henna SET price=5; ..or to 100kk (good one for high rates servers). Code: UPDATE henna SET price=100000000; Newbie npc buffer buffes all buffs from 1lv to 62lv: Really use full newbie characters to have all buffs from 1lv (if yuo want U may change upper level to 85, for daily bufer). Code: UPDATE helper_buff_list SET lower_level=1; UPDATE helper_buff_list SET upper_level=62; 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; Auto server restart: Every week.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360"); Every two days.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360"); Every 24h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360"); Every 12h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360"); Every 6h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360"); Every 3h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360"); Thx to lekino 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) Code: 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 ; δεν χρειάζεται να κάνουμε new sql file να τα κανουμε paste εκει και μετα στην database.. δείτε μερικές foto. 1.Ανοιγουμε navicat meta thn db που θέλουμε και παταμε Qwerty 2.Παταμε New Querty http://i43.tinypic.com/4j44m1.png[/img] 3.Kανουμε paste τον κώδικα που θέλουμε, εγώ έβαλα ένα παράδειγμα update npc SET title = 'MaxCheaTeRs' where id between 1 and 99999; και μετα παταμε Run http://i41.tinypic.com/dw8m54.png[/img] 4.τέλος ;) http://i41.tinypic.com/33mr87s.png[/img] δεν ειναι απαραιτητο να τα κανουμε ενα ενα μπορουμε να τα βαζουμε ολα μάζη http://i42.tinypic.com/9jzs4z.png[/img] navicat+key by me για τους κώδικες δεν ξερω τους βρηκα καπου απο παλια ;)
TheVip Posted November 25, 2011 Posted November 25, 2011 πιστεύω ότι είναι πολύ χρήσιμο για όσους δεν ξέρουν einai to last version : http://www.multiupload.com/3UCRW2DK33 key: NAVL-X2W5-8G4R-5QT4 εχω δει πολλα share me sql και ακομα το κανουν με τον παλιο τροπο :P για παράδειγμα τετοιους κώδικες : 0 Weight for items/armors/weapons: Quote UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id); UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id); UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id); Drop Adena 100%: Quote UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57'; When you sell, everything will cost 0 adena: Quote UPDATE `armor` SET price=0 where price > 1; UPDATE `etcitem` SET price=0 where price > 1; UPDATE `weapon` SET price=0 where price > 1; Update all RaidBoss 5000k hp: Quote UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss'; Delete all mobs under 40 lvl: Quote DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster'; Delete all materials and recipes from db: Quote DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' ); Increase drop rate for recipes: Quote UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe'); Delete characters and accounts if they do not connect for 3 months: Quote DELETE FROM characters WHERE lastAccess < 466560000; DELETE FROM accounts WHERE lastactive < 466560000; Add for all monsters in drop: Coins Quote insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster'; Top No-Grade in start:(Need to modif for kamaels) Quote REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588); REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588); REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588); Add RaidBoss jewels if you have deleted them: Quote INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000'); INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000'); INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000'); INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000'); INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000'); INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000'); INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000'); Thx to 1tm Delete all spellbooks from db: Code: DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' ); Increases Guards (p.def, m.def, p.atk, hp) by 50%: Code: UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard'; Decreases Raidboss defense by 40%: Code: UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss'; UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss'; UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss'; All new player chars spawn loc: Code: UPDATE char_templates SET x=yourXcoordinate; UPDATE char_templates SET y=yourYcoordinate; UPDATE char_templates SET z=yourZcoordinate; Increases all chars p.def/m.def by 10%: Code: UPDATE char_templates SET P_DEF = P_DEF * 1.1; UPDATE char_templates SET M_DEF = M_DEF * 1.1; Increases all chars speed by 20%: Code: UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2; Increases all chars CP. At 20lv by 22%, at 40lv by 44%, at 76lv by 66%: This one good one for longer pvps.. Code: UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76'; UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40'; UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20'; MP rengerates 10 times more(unlimited mp): Good one for high servers who has mp potions etc.. Code: UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0; Teleports cost 0 adena: Code: UPDATE teleport SET price=0; Create common item skill delete: It used as bug at olympiad, with it you can buff with soes, mental dagers etc in secs... Code: DELETE FROM skill_trees WHERE skill_id = 1320; DELETE FROM skill_trees WHERE skill_id = 1322; Grade penality delete: Disables grade penality... Code: DELETE FROM skill_trees WHERE skill_id = 239; Raidbosses always spawns with 70% hp: More realistic that new spawned rb has not full hp. Good one for organized clans or parties... Code: UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7; Dies adding price reduced to 5 adena (or increased to 100kk): Good one for faction servers. Code: UPDATE henna SET price=5; ..or to 100kk (good one for high rates servers). Code: UPDATE henna SET price=100000000; Newbie npc buffer buffes all buffs from 1lv to 62lv: Really use full newbie characters to have all buffs from 1lv (if yuo want U may change upper level to 85, for daily bufer). Code: UPDATE helper_buff_list SET lower_level=1; UPDATE helper_buff_list SET upper_level=62; 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; Auto server restart: Every week.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360"); Every two days.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360"); Every 24h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360"); Every 12h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360"); Every 6h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360"); Every 3h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360"); Thx to lekino 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) Code: 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 ; δεν χρειάζεται να κάνουμε new sql file να τα κανουμε paste εκει και μετα στην database.. δείτε μερικές foto. 1.Ανοιγουμε navicat meta thn db που θέλουμε και παταμε Qwerty 2.Παταμε New Querty 3.Kανουμε paste τον κώδικα που θέλουμε, εγώ έβαλα ένα παράδειγμα update npc SET title = 'MaxCheaTeRs' where id between 1 and 99999; και μετα παταμε Run 4.τέλος ;) δεν ειναι απαραιτητο να τα κανουμε ενα ενα μπορουμε να τα βαζουμε ολα μάζη navicat+key by me για τους κώδικες δεν ξερω τους βρηκα καπου απο παλια ;) Nice!! ty :D
Papaditsa Posted December 21, 2011 Posted December 21, 2011 Wraio to share sou alla apo oti xerw apagoreuontai ta Cracked program sto site !
Roronoa Posted December 21, 2011 Posted December 21, 2011 giati oxi ? poly psaxnoun gia key sto navicat
l22expert Posted January 8, 2012 Posted January 8, 2012 giati oxi ? poly psaxnoun gia key sto navicat apagorebete kanonika file afto. file ise apithanos thanks an kai apagorebete ta warez pou to thimithika tora to warezakias. leo apithanos gt to mirazese mazimas kai den les poulao navikat me serial brabo
vl4d Posted February 25, 2012 Author Posted February 25, 2012 poli apla katevazeis apo to official site to last rev oti einai version 10 kanei to key..(vrm na anevazo sinexeia, ka8e mera ginonte dead)
pirama Posted February 25, 2012 Posted February 25, 2012 apla den katalabenw giati aneyazete serial ktl eno ta apagoreyh to site edw......ektos an ta epitrepi... an kanete mia anazitisi sto google me leksis klidia tha brite oti thelete apo programata/serial/crack ktl....
AbsolutePower Posted March 31, 2012 Posted March 31, 2012 πιστεύω ότι είναι πολύ χρήσιμο για όσους δεν ξέρουν.. για να μην έχουμε πρόβλημα με το link θα κατεβάζετε από το oficial http://www.navicat.com/en/download/download.html key: NAVL-X2W5-8G4R-5QT4 (κάνει για όλα τα rev 10) US $ 599.00 einai kanonika mazi me to key.. http://navicat.com/buynow/store.html Twra εχω δει πολλα share me sql και ακομα το κανουν με τον παλιο τροπο :P για παράδειγμα τετοιους κώδικες : 0 Weight for items/armors/weapons: Quote UPDATE `etcitem` SET `weight`=0 WHERE (SELECT item_id); UPDATE `armor` SET `weight`=0 WHERE (SELECT item_id); UPDATE `weapon` SET `weight`=0 WHERE (SELECT item_id); Drop Adena 100%: Quote UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57'; When you sell, everything will cost 0 adena: Quote UPDATE `armor` SET price=0 where price > 1; UPDATE `etcitem` SET price=0 where price > 1; UPDATE `weapon` SET price=0 where price > 1; Update all RaidBoss 5000k hp: Quote UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss'; Delete all mobs under 40 lvl: Quote DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level<40 AND npc.type='L2Monster'; Delete all materials and recipes from db: Quote DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' ); Increase drop rate for recipes: Quote UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe'); Delete characters and accounts if they do not connect for 3 months: Quote DELETE FROM characters WHERE lastAccess < 466560000; DELETE FROM accounts WHERE lastactive < 466560000; Add for all monsters in drop: Coins Quote insert into droplist (mobId, itemid, chance, min, max,category) select id, 4037, 1000000, 1, 1, 52 from npc where type='L2Monster'; Top No-Grade in start:(Need to modif for kamaels) Quote REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588); REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588); REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588); REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588); REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588); Add RaidBoss jewels if you have deleted them: Quote INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000'); INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000'); INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000'); INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000'); INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000'); INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000'); INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000'); Thx to 1tm Delete all spellbooks from db: Code: DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' ); Increases Guards (p.def, m.def, p.atk, hp) by 50%: Code: UPDATE npc SET pdef = pdef * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET hp = hp * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET patk = patk * 1.5 WHERE type = 'L2Guard'; UPDATE npc SET mdef = mdef * 1.5 WHERE type = 'L2Guard'; Decreases Raidboss defense by 40%: Code: UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss'; UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss'; UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss'; All new player chars spawn loc: Code: UPDATE char_templates SET x=yourXcoordinate; UPDATE char_templates SET y=yourYcoordinate; UPDATE char_templates SET z=yourZcoordinate; Increases all chars p.def/m.def by 10%: Code: UPDATE char_templates SET P_DEF = P_DEF * 1.1; UPDATE char_templates SET M_DEF = M_DEF * 1.1; Increases all chars speed by 20%: Code: UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2; Increases all chars CP. At 20lv by 22%, at 40lv by 44%, at 76lv by 66%: This one good one for longer pvps.. Code: UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76'; UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40'; UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20'; MP rengerates 10 times more(unlimited mp): Good one for high servers who has mp potions etc.. Code: UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0; Teleports cost 0 adena: Code: UPDATE teleport SET price=0; Create common item skill delete: It used as bug at olympiad, with it you can buff with soes, mental dagers etc in secs... Code: DELETE FROM skill_trees WHERE skill_id = 1320; DELETE FROM skill_trees WHERE skill_id = 1322; Grade penality delete: Disables grade penality... Code: DELETE FROM skill_trees WHERE skill_id = 239; Raidbosses always spawns with 70% hp: More realistic that new spawned rb has not full hp. Good one for organized clans or parties... Code: UPDATE raidboss_spawnlist SET currentHp = currentHp * 0.7; Dies adding price reduced to 5 adena (or increased to 100kk): Good one for faction servers. Code: UPDATE henna SET price=5; ..or to 100kk (good one for high rates servers). Code: UPDATE henna SET price=100000000; Newbie npc buffer buffes all buffs from 1lv to 62lv: Really use full newbie characters to have all buffs from 1lv (if yuo want U may change upper level to 85, for daily bufer). Code: UPDATE helper_buff_list SET lower_level=1; UPDATE helper_buff_list SET upper_level=62; 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; Auto server restart: Every week.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "604800000", "86400000", "360"); Every two days.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "172800000", "86400000", "360"); Every 24h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "86400000", "86400000", "360"); Every 12h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "43200000", "43200000", "360"); Every 6h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "21600000", "21600000", "360"); Every 3h.. Code: INSERT INTO `global_tasks` VALUES ("5", "restart", "TYPE_SHEDULED", "2147483647", "10800000", "10800000", "360"); Thx to lekino 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) Code: 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 ; δεν χρειάζεται να κάνουμε new sql file να τα κανουμε paste εκει και μετα στην database.. για τους κώδικες δεν ξερω τους βρηκα καπου απο παλια ;) NICE NICE SKYLOPSARO ME STOLH :)
SMAKOPS Posted May 26, 2012 Posted May 26, 2012 Αν θες να μην γίνονται dead τα links,απλά κανε acc στο mediafire/sendspace και δεν θα ξαναγίνουν(σηνιστώ sendspace) Από το share μόνο το query δεν ήξερα,n1!
vl4d Posted June 23, 2012 Author Posted June 23, 2012 Αν θες να μην γίνονται dead τα links,απλά κανε acc στο mediafire/sendspace και δεν θα ξαναγίνουν(σηνιστώ sendspace) Από το share μόνο το query δεν ήξερα,n1! emm les na ekana share gia to navicat? gia to query to ekana e kai prostesa kai to navicat..
Recommended Posts