[Help]Gameserver Error

[Devilfenix]

Καλημερα παιδες, εχω ενα προβλημα στο gameserver console , κατι παιζει με τον skill enchanter...δειτε μερικες photo παρακατω

 

 

 

[Zake]

πέρασες κάποιο custom skill enchanter ίσως;

[Devilfenix]

custom skill enchanter ειναι...

[Devilfenix]

bump

[Zake]

custom skill enchanter ειναι...

δε φαίνεται ολόκληρο το error, αν μπορείς βάλε μια άλλη φώτο, προφανώς κάτι δεν πέρασες σωστά.

[Devilfenix]

δε φαίνεται ολόκληρο το error, αν μπορείς βάλε μια άλλη φώτο, προφανώς κάτι δεν πέρασες σωστά.

 

Εβαλα

[UnSponsored]

same problem here with a sex changer found on maxc.....

[Devilfenix]

bump

[Devilfenix]

bump

[Dulens.]

πρέπει να περάσεις το sql για να τον δηλώσεις στην database.

[Devilfenix]

πρέπει να περάσεις το sql για να τον δηλώσεις στην database.

 

to exw perasei to sql,to thema einai oti dn kserw gt m vgazei auto to error...

 

oriste to sql :

 

INSERT INTO `custom_npc`
(`id`,`idTemplate`,`name`,`serverSideName`,`title`,`serverSideTitle`,`class`,`collision_radius`,`collision_height`,`level`,`sex`,`type`,`attackrange`,`hp`,`mp`,`hpreg`,`mpreg`,`str`,`con`,`dex`,`int`,`wit`,`men`,`exp`,`sp`,`patk`,`pdef`,`matk`,`mdef`,`atkspd`,`aggro`,`matkspd`,`rhand`,`lhand`,`armor`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`)
VALUES
('50021', '30513', 'Skill Enchanter', '1', '[url=http://www.l2.med-net.us]www.l2.med-net.us[/url]', '1', 'NPC.e_patriarch_MOrc', '8.00', '25.00', '70', 'female', 'L2Merchant', '40', '3862', '1493', null, null, '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '1', '0', 'LAST_HIT');
INSERT INTO `skill_learn` (`npc_id`, `class_id`) VALUES 
(50021, 0),
(50021, 1),
(50021, 2),
(50021, 3),
(50021, 4),
(50021, 5),
(50021, 6),
(50021, 7),
(50021, 8),
(50021, 9),
(50021, 10),
(50021, 11),
(50021, 12),
(50021, 13),
(50021, 14),
(50021, 15),
(50021, 16),
(50021, 17),
(50021, 18),
(50021, 19),
(50021, 20),
(50021, 21),
(50021, 22),
(50021, 23),
(50021, 24),
(50021, 25),
(50021, 26),
(50021, 27),
(50021, 28),
(50021, 29),
(50021, 30),
(50021, 31),
(50021, 32),
(50021, 33),
(50021, 34),
(50021, 35),
(50021, 36),
(50021, 37),
(50021, 38),
(50021, 39),
(50021, 40),
(50021, 41),
(50021, 42),
(50021, 43),
(50021, 44),
(50021, 45),
(50021, 46),
(50021, 47),
(50021, 48),
(50021, 49),
(50021, 50),
(50021, 51),
(50021, 52),
(50021, 53),
(50021, 54),
(50021, 55),
(50021, 56),
(50021, 57),
(50021, 58),
(50021, 59),
(50021, 60),
(50021, 61),
(50021, 62),
(50021, 63),
(50021, 64),
(50021, 65),
(50021, 66),
(50021, 67),
(50021, 68),
(50021, 69),
(50021, 70),
(50021, 71),
(50021, 72),
(50021, 73),
(50021, 74),
(50021, 75),
(50021, 76),
(50021, 77),
(50021, 78),
(50021, 79),
(50021, 80),
(50021, 81),
(50021, 82),
(50021, 83),
(50021, 84),
(50021, 85),
(50021, 86),
(50021, 87),
(50021, 88),
(50021, 89),
(50021, 90),
(50021, 91),
(50021, 92),
(50021, 93),
(50021, 94),
(50021, 95),
(50021, 96),
(50021, 97),
(50021, 98),
(50021, 99),
(50021, 100),
(50021, 101),
(50021, 102),
(50021, 103),
(50021, 104),
(50021, 105),
(50021, 106),
(50021, 107),
(50021, 108),
(50021, 109),
(50021, 110),
(50021, 111),
(50021, 112),
(50021, 113),
(50021, 114),
(50021, 115),
(50021, 116),
(50021, 117),
(50021, 118),
(50021, 119),
(50021, 120),
(50021, 121),
(50021, 122),
(50021, 123),
(50021, 124),
(50021, 125),
(50021, 126),
(50021, 127),
(50021, 128),
(50021, 129),
(50021, 130),
(50021, 131),
(50021, 132),
(50021, 133),
(50021, 134),
(50021, 135),
(50021, 136);

[Dulens.]

την επόμενη φορά διάβασε πιο προσεχτικά το error.

 

το max των class είναι 118 και εσύ το πήγες μέχρι 136. (λογικά είναι για άλλο client)

 

INSERT INTO `skill_learn` (`npc_id`, `class_id`) VALUES
(50020, 0),
(50020, 1),
(50020, 2),
(50020, 3),
(50020, 4),
(50020, 5),
(50020, 6),
(50020, 7),
(50020, 8),
(50020, 9),
(50020, 10),
(50020, 11),
(50020, 12),
(50020, 13),
(50020, 14),
(50020, 15),
(50020, 16),
(50020, 17),
(50020, 18),
(50020, 19),
(50020, 20),
(50020, 21),
(50020, 22),
(50020, 23),
(50020, 24),
(50020, 25),
(50020, 26),
(50020, 27),
(50020, 28),
(50020, 29),
(50020, 30),
(50020, 31),
(50020, 32),
(50020, 33),
(50020, 34),
(50020, 35),
(50020, 36),
(50020, 37),
(50020, 38),
(50020, 39),
(50020, 40),
(50020, 41),
(50020, 42),
(50020, 43),
(50020, 44),
(50020, 45),
(50020, 46),
(50020, 47),
(50020, 48),
(50020, 49),
(50020, 50),
(50020, 51),
(50020, 52),
(50020, 53),
(50020, 54),
(50020, 55),
(50020, 56),
(50020, 57),
(50020, 88),
(50020, 89),
(50020, 90),
(50020, 91),
(50020, 92),
(50020, 93),
(50020, 94),
(50020, 95),
(50020, 96),
(50020, 97),
(50020, 98),
(50020, 99),
(50020, 100),
(50020, 101),
(50020, 102),
(50020, 103),
(50020, 104),
(50020, 105),
(50020, 106),
(50020, 107),
(50020, 108),
(50020, 109),
(50020, 110),
(50020, 111),
(50020, 112),
(50020, 113),
(50020, 114),
(50020, 115),
(50020, 116),
(50020, 117),
(50020, 118);

 

βάλε αυτό, δουλεύει 100%.

[Devilfenix]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `skill_learn` (`npc_id`, `class_id`) VALUES
(50020, 0),
(50020, 1)' at line 2
[Err] INSERT INTO `skill_learn` (`npc_id`, `class_id`) VALUES
INSERT INTO `skill_learn` (`npc_id`, `class_id`) VALUES
(50020, 0),
(50020, 1),
(50020, 2),
(50020, 3),
(50020, 4),
(50020, 5),
(50020, 6),
(50020, 7),
(50020, 8),
(50020, 9),
(50020, 10),
(50020, 11),
(50020, 12),
(50020, 13),
(50020, 14),
(50020, 15),
(50020, 16),
(50020, 17),
(50020, 18),
(50020, 19),
(50020, 20),
(50020, 21),
(50020, 22),
(50020, 23),
(50020, 24),
(50020, 25),
(50020, 26),
(50020, 27),
(50020, 28),
(50020, 29),
(50020, 30),
(50020, 31),
(50020, 32),
(50020, 33),
(50020, 34),
(50020, 35),
(50020, 36),
(50020, 37),
(50020, 38),
(50020, 39),
(50020, 40),
(50020, 41),
(50020, 42),
(50020, 43),
(50020, 44),
(50020, 45),
(50020, 46),
(50020, 47),
(50020, 48),
(50020, 49),
(50020, 50),
(50020, 51),
(50020, 52),
(50020, 53),
(50020, 54),
(50020, 55),
(50020, 56),
(50020, 57),
(50020, 88),
(50020, 89),
(50020, 90),
(50020, 91),
(50020, 92),
(50020, 93),
(50020, 94),
(50020, 95),
(50020, 96),
(50020, 97),
(50020, 98),
(50020, 99),
(50020, 100),
(50020, 101),
(50020, 102),
(50020, 103),
(50020, 104),
(50020, 105),
(50020, 106),
(50020, 107),
(50020, 108),
(50020, 109),
(50020, 110),
(50020, 111),
(50020, 112),
(50020, 113),
(50020, 114),
(50020, 115),
(50020, 116),
(50020, 117),
(50020, 118);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Devilfenix]

solved

[Justice]

solved