Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

[Share]Navicat Premium + key ;)

vl4d
 Share

Recommended Posts

vl4d Newbie

vl4d

Posted
Posted

πιστεύω ότι είναι πολύ χρήσιμο για όσους δεν ξέρουν..

για να μην έχουμε πρόβλημα με το 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

 

zl3cm.png

 

2.Παταμε New Querty

 

width=1024 height=576http://i43.tinypic.com/4j44m1.png[/img]

 

3.Kανουμε paste τον κώδικα που θέλουμε, εγώ έβαλα ένα παράδειγμα

update npc SET title = 'MaxCheaTeRs' where id between 1 and 99999;

και μετα παταμε Run

 

width=1024 height=576http://i41.tinypic.com/dw8m54.png[/img]

 

4.τέλος ;)

 

width=1024 height=576http://i41.tinypic.com/33mr87s.png[/img]

 

δεν ειναι απαραιτητο να τα κανουμε ενα ενα μπορουμε να τα βαζουμε ολα μάζη

 

width=1024 height=576http://i42.tinypic.com/9jzs4z.png[/img]

 

navicat+key by me

για τους κώδικες δεν ξερω τους βρηκα καπου απο παλια ;)

TheVip Newbie

TheVip

Posted
Posted

πιστεύω ότι είναι πολύ χρήσιμο για όσους δεν ξέρουν

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

 

zl3cm.png

 

2.Παταμε New Querty

 

4j44m1.png

 

3.Kανουμε paste τον κώδικα που θέλουμε, εγώ έβαλα ένα παράδειγμα

update npc SET title = 'MaxCheaTeRs' where id between 1 and 99999;

και μετα παταμε Run

 

dw8m54.png

 

4.τέλος ;)

 

33mr87s.png

 

δεν ειναι απαραιτητο να τα κανουμε ενα ενα μπορουμε να τα βαζουμε ολα μάζη

 

9jzs4z.png

 

navicat+key by me

για τους κώδικες δεν ξερω τους βρηκα καπου απο παλια ;)

Nice!! ty :D
  • 4 weeks later...
  • 3 weeks later...
l22expert Newbie

l22expert

Posted
Posted

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

  • 1 month later...
vl4d Newbie

vl4d

Posted
  • Author
Posted

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 Newbie

pirama

Posted
Posted

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

  • 4 weeks later...
AbsolutePower Contributor

AbsolutePower

Posted
Posted

πιστεύω ότι είναι πολύ χρήσιμο για όσους δεν ξέρουν..

για να μην έχουμε πρόβλημα με το 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 :)
  • 1 month later...
SMAKOPS Newbie

SMAKOPS

Posted
Posted

Αν θες να μην γίνονται dead τα links,απλά κανε acc  στο mediafire/sendspace και δεν θα ξαναγίνουν(σηνιστώ sendspace)

Από το share μόνο το query δεν ήξερα,n1!

  • 4 weeks later...
vl4d Newbie

vl4d

Posted
  • Author
Posted

Αν θες να μην γίνονται 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..
Guest
This topic is now closed to further replies.
 Share
Go to topic listing


  • Posts

    • STAX
      L2Editor

      By STAX · Posted

      Hi! I downloaded the Topic's files but i have the same issue as others with black gras. but i do not have Illumination at Server Info in F6. Someone could help me with it? im using L2C4 client and L2Julvius. Thank you all!
    • galekos
      Geodata for Gracia Final project.

      By galekos · Posted

      WTB GEODATA FOR GRACIA FINAL PROJECT.
    • ZOUMHS
      [C4][L2OFF]Lineage II Eternal Sin

      By ZOUMHS · Posted

      Server is not Classic, is C4 Scions of Destiny.   http://eternalsinl2.com   https://l2network.eu/details/2458/Lineage-II-Eternal-SIn/#google_vignette
    • SadLittlePiggg
      🚀 Novproxy |🔥FROM $0.5/GB 🔥100M+ Active Residential proxy

      By SadLittlePiggg · Posted

      Dynamic traffic, static ISP, unlimited traffic and bandwidth packages HTTP, HTTPS, SOCKS5 Over 195 countries/regions Over 100 million real residential IP address pools, with a normal uptime of 99.9%. Special discount code：VIP999
    • MiaCodeWEB
      MOD L2 Phantom AI Manager (Bots Inteligentes + Gemini AI)

      By MiaCodeWEB · Posted

      Here is the translation, formatted to look professional, clean, and highly scannable for your forum post: Hello L2JBrasil community! I present to you the newest development from MiaCodeWeb. We have created a robust and advanced adaptation of the Phantom system for aCis / L2JAcis 409, focused on Interlude C6 servers. Our main goal was to transform traditional "ornamental bots" into highly realistic, autonomous players. They are capable of creating themselves, restoring themselves, farming, auto-equipping, using skills, responding in chat using Artificial Intelligence, and being managed directly via an in-game panel. GitHub: https://github.com/miacodeweb/L2-Phantom-AI Video Demonstration: [Insert link here]   ## Main Features and Implementation We implemented the core of the Phantom system directly into the aCis gameserver. The architecture was divided into independent modules for AI, combat, chat, equipment, inventory, progression, logs, and administration. In-Game Admin Panel: Fully functional //phantom command. It allows you to create new phantoms, restore saved ones, reload configs, start/stop the AI, view online phantoms, kill bugged phantoms, delete them individually, and navigate through pages. Data Persistence: Created phantoms can be registered in phantoms.properties, allowing them to be restored later while maintaining all their progress directly from the database. Centralized Configuration: Everything is controlled by the phantoms.properties file, organized by sections: AI, Loot, Skills, Equipment, Zones, PVP/PK, Gemini (Chat), Logs, Respawn, and Anti-Stuck system. ## Phantom Skills and Behavior Smart Combat: They patrol, search for mobs, and claim targets to prevent multiple phantoms from attacking the same monster. Mages rest when they run out of MP and avoid hitting with physical weapons unnecessarily. Automatic Progression: Auto-learning of skills, automatic class changes following the logical tree of the chosen profession, receiving buffs, and inventory clearing when reaching a certain weight/space percentage. Dynamic Equipment System: They auto-equip based on class and level, using varying item combinations so they don't all look the same. Optimized Loot: Each phantom focuses on picking up drops/herbs from its own mob, avoiding that ugly scene of 10 phantoms chasing the same adena. PVP/PK Behavior (Configurable): Immediate response to attacks, detection of PK players in the visible area, and an optional "PK Rage Mode". ## AI and Movement Navigation and Anti-Stuck: Patrol system, free wandering, obstacle and stuck detection, with Geodata validation (when enabled on the server). Respawn: Automatic return to town after death, alongside safety rules to prevent them from getting permanently stuck in textures. Leveling Zones: Configurable leveling zones (automatic teleports to farm zones are disabled by default, as in Interlude/aCis they rely heavily on geodata accuracy and the real coordinates of your server). ## AI Chat Integration (Gemini 2.5 Flash) We integrated a Whisper system via the Gemini 2.5 Flash API, making the phantoms respond like real Lineage 2 players. Support for both free and paid API tiers. Configurable parameters: GeminiApiTier, Keys, Cooldowns, and DailyLimits. The system detects connection failures, API limits, and empty responses, and logs everything. The prompt has been adjusted so that the phantom doesn't reply with empty or robotic phrases when asked where to level up or what it's doing. ## Dedicated Log System We created an exclusive log file located at gameserver/log/phantoms.log. It records: loading of phantoms, auto-skills, buffs, Gemini API errors/successes, anti-stuck actions, kills/deletes by admin, and configuration issues. ## Simplified Distribution and Installation Thinking about ease of use for administrators, the mod is delivered in a ready-to-use package: phantom-acis-installer-client.zip. Includes an automatic PowerShell installer that injects the code into your Eclipse project. Contains README.md, INSTALL_MAP.md, and the payload/ folder with ready-made routes for aCis. Clean configuration files (without my API keys). Just run the installer over your copy of aCis, refresh Eclipse, compile, and test. ## Custom Jobs The project already has a solid and functional base for aCis 409. The ideal next steps would be to refine the farm routes by level and social behavior with long-term testing on live servers. I accept custom jobs! If you need this system adapted for another revision, exclusive modules, or any other development for your server, get in touch. Through MiaCodeWeb, I also offer complete services involving geodata optimization, advanced VPS administration (Linux), and Java backend management for L2J. Send a PM or visit the GitHub!   https://www.l2jbrasil.com/applications/core/interface/file/attachment.php?id=17801&key=135fc8d831b84c05089851b18bfca58a   Link dowload:https://github.com/miacodeweb/L2-Phantom-Acis-409

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..