Jump to content

Recommended Posts

Posted

Πώς αλλάζω μέσω της db το Starting Zone

 

DELETE FROM char_templates WHERE ClassId=0; 
DELETE FROM char_templates WHERE ClassId=10; 
DELETE FROM char_templates WHERE ClassId=18; 
DELETE FROM char_templates WHERE ClassId=25; 
DELETE FROM char_templates WHERE ClassId=31; 
DELETE FROM char_templates WHERE ClassId=38; 
DELETE FROM char_templates WHERE ClassId=44; 
DELETE FROM char_templates WHERE ClassId=49; 
DELETE FROM char_templates WHERE ClassId=53; 

INSERT INTO `char_templates` VALUES 
(0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 300, 333, 33, 44, 33, 115, 81900, 140425, -124265, -1929, 0, 1.10, 1.188000, 9.0, 23.0, 1.10, 1.188000, 8.0, 23.5, 1147, 1146, 10, 2369, 5588), 
(10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 300, 333, 28, 40, 28, 120, 62500, 140425, -124265, -1929, 0, 1.01, 0.872640, 7.5, 22.8, 1.01, 0.872640, 6.5, 22.5, 425, 461, 6, 5588, 0), 
(18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 300, 333, 36, 46, 36, 125, 73000, 140425, -124265, -1929, 0, 1.15, 1.242000, 7.5, 24.0, 1.15, 1.242000, 7.5, 23.0, 1147, 1146, 10, 2369, 5588), 
(25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 300, 333, 30, 41, 30, 122, 62400, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.5, 24.0, 1.04, 0.898560, 7.5, 23.0, 425, 461, 6, 5588, 0), 
(31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 300, 333, 35, 45, 35, 122, 69000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.14, 1.231200, 7.0, 23.5, 1147, 1146, 10, 2369, 5588), 
(38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 300, 333, 29, 41, 29, 122, 61000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.03, 0.889920, 7.0, 23.5, 425, 461, 6, 5588, 0), 
(44, 'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 300, 333, 31, 42, 31, 117, 87000, 140425, -124265, -1929, 0, 1.06, 1.144800, 11.0, 28.0, 1.06, 1.144800, 7.0, 27.0, 1147, 1146, 2368, 2369, 5588), 
(49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 300, 333, 30, 41, 30, 121, 68000, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.0, 27.5, 1.04, 0.898560, 8.0, 25.5, 425, 461, 2368, 5588, 0), 
(53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 300, 333, 33, 43, 33, 115, 83000, 140425, -124265, -1929, 1, 1.09, 1.487196, 9.0, 18.0, 1.09, 1.487196, 5.0, 19.0, 1147, 1146, 10, 2370, 5588);

 

Πως κάνουμε να πετάνε όλα τα mobs adena ή αυτό το item που θέλουμε εμείς.

 

DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')

 

Πως μπορούμε να βάλουμε Auto Restart..

 

INSERT INTO global_tasks (task,type,last_activation,param1,param2,param3) VALUES ('restart','TYPE_GLOBAL_TASK','0','1','04:50:00','600');

 

Πιστεύω να είναι χρήσιμα για newbies. Αν έχει ξανα γίνει share, κλειδώστε το (αν και δεν νομίζω να έχει ξαναγίνει).

Posted

έχουν γίνει πάνω απο 35-40 scripts(~) στον αγγλικό τομέα,αλλά καλό είναι να υπάρχουν κάποια(!) και εδώ.

 

 

Posted

έχουν γίνει πάνω απο 35-40 scripts(~) στον αγγλικό τομέα,αλλά καλό είναι να υπάρχουν κάποια(!) και εδώ.

 

 

Εγώ πάντως τα έκανα share γιατί κι εγώ κάποτε τα χρειαζόμουν αλλά τα "έμαθα".!

Posted

Πώς αλλάζω μέσω της db το Starting Zone

 

DELETE FROM char_templates WHERE ClassId=0; 
DELETE FROM char_templates WHERE ClassId=10; 
DELETE FROM char_templates WHERE ClassId=18; 
DELETE FROM char_templates WHERE ClassId=25; 
DELETE FROM char_templates WHERE ClassId=31; 
DELETE FROM char_templates WHERE ClassId=38; 
DELETE FROM char_templates WHERE ClassId=44; 
DELETE FROM char_templates WHERE ClassId=49; 
DELETE FROM char_templates WHERE ClassId=53; 

INSERT INTO `char_templates` VALUES 
(0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 300, 333, 33, 44, 33, 115, 81900, 140425, -124265, -1929, 0, 1.10, 1.188000, 9.0, 23.0, 1.10, 1.188000, 8.0, 23.5, 1147, 1146, 10, 2369, 5588), 
(10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 300, 333, 28, 40, 28, 120, 62500, 140425, -124265, -1929, 0, 1.01, 0.872640, 7.5, 22.8, 1.01, 0.872640, 6.5, 22.5, 425, 461, 6, 5588, 0), 
(18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 300, 333, 36, 46, 36, 125, 73000, 140425, -124265, -1929, 0, 1.15, 1.242000, 7.5, 24.0, 1.15, 1.242000, 7.5, 23.0, 1147, 1146, 10, 2369, 5588), 
(25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 300, 333, 30, 41, 30, 122, 62400, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.5, 24.0, 1.04, 0.898560, 7.5, 23.0, 425, 461, 6, 5588, 0), 
(31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 300, 333, 35, 45, 35, 122, 69000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.14, 1.231200, 7.0, 23.5, 1147, 1146, 10, 2369, 5588), 
(38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 300, 333, 29, 41, 29, 122, 61000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.03, 0.889920, 7.0, 23.5, 425, 461, 6, 5588, 0), 
(44, 'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 300, 333, 31, 42, 31, 117, 87000, 140425, -124265, -1929, 0, 1.06, 1.144800, 11.0, 28.0, 1.06, 1.144800, 7.0, 27.0, 1147, 1146, 2368, 2369, 5588), 
(49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 300, 333, 30, 41, 30, 121, 68000, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.0, 27.5, 1.04, 0.898560, 8.0, 25.5, 425, 461, 2368, 5588, 0), 
(53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 300, 333, 33, 43, 33, 115, 83000, 140425, -124265, -1929, 1, 1.09, 1.487196, 9.0, 18.0, 1.09, 1.487196, 5.0, 19.0, 1147, 1146, 10, 2370, 5588);

 

Πως κάνουμε να πετάνε όλα τα mobs adena ή αυτό το item που θέλουμε εμείς.

 

DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')

 

Πως μπορούμε να βάλουμε Auto Restart..

 

INSERT INTO global_tasks (task,type,last_activation,param1,param2,param3) VALUES ('restart','TYPE_GLOBAL_TASK','0','1','04:50:00','600');

 

Πιστεύω να είναι χρήσιμα για newbies. Αν έχει ξανα γίνει share, κλειδώστε το (αν και δεν νομίζω να έχει ξαναγίνει).

Bravo file moy ! Omws pisteuw prepei na valeis merika akoma ....

Posted

έχουν γίνει πάνω απο 35-40 scripts(~) στον αγγλικό τομέα,αλλά καλό είναι να υπάρχουν κάποια(!) και εδώ.

dose link einai xrisima afta :)

  • 4 months later...
  • 1 year later...
  • 5 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • 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