Buffer Problem

[rev0]

EleoC Re Paidia Ston Oneo Dn M Douleuei O Buffer Ala3a Pack Evala Tou Archid Kai Dn Mou Ton Pernaei Stin Database!!!! Help Dild

[xXSkillerXx]

Κανε C/p εδω το SQL σου να σου κανω ενα για archid.

 

Εdit :

 

@SuBzZ3Ro

 

http://www.maxcheaters.com/forum/index.php?topic=44248.0

[کpooKNοF®]

einai ta imports.. kai ta imports den ta xero gia tis oneo :S kane ena search kai 8a bris buffer gia oneo genikotera oi oneo exei pe8ani..

[rev0]

/*

L2J-Archid Alternative Buffer

*/

 

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `Npc_Buffer`;

CREATE TABLE `Buffer` (

  `npc_id` int(5) NOT NULL,

  `skill_id` int(5) NOT NULL,

  `skill_level` int(5) NOT NULL default '1',

  `skill_fee_id` int(5) NOT NULL default '0',

  `skill_fee_amount` int(5) NOT NULL default '0',

  PRIMARY KEY  (`npc_id`,`skill_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

-- ----------------------------

-- Records

-- ----------------------------

INSERT INTO Npc_Buffer

  (`npc_id`, `skill_id`, `skill_level`, `skill_fee_id`, `skill_fee_amount`)

VALUES

  (51, 264, 1, 57, 100),

  (51, 265, 1, 57, 100),

  (51, 266, 1, 57, 100),

  (51, 267, 1, 57, 100),

  (51, 268, 1, 57, 100),

  (51, 269, 1, 57, 100),

  (51, 270, 1, 57, 100),

  (51, 271, 1, 57, 100),

  (51, 272, 1, 57, 100),

  (51, 273, 1, 57, 100),

  (51, 274, 1, 57, 100),

  (51, 275, 1, 57, 100),

  (51, 276, 1, 57, 100),

  (51, 277, 1, 57, 100),

  (51, 304, 1, 57, 100),

  (51, 305, 1, 57, 100),

  (51, 306, 1, 57, 100),

  (51, 307, 1, 57, 100),

  (51, 308, 1, 57, 100),

  (51, 309, 1, 57, 100),

  (51, 310, 1, 57, 100),

  (51, 311, 1, 57, 100),

  (51, 349, 1, 57, 100),

  (51, 363, 1, 57, 100),

  (51, 364, 1, 57, 100),

  (51, 365, 1, 57, 100),

  (51, 366, 1, 57, 100),

  (51, 1355, 1, 57, 100),

  (51, 1356, 1, 57, 100),

  (51, 1357, 1, 57, 100),

  (51, 1363, 1, 57, 100),

  (51, 1413, 1, 57, 100),

  (51, 4342, 2, 57, 100),

  (51, 4343, 3, 57, 100),

  (51, 4344, 3, 57, 100),

  (51, 4345, 3, 57, 100),

  (51, 4346, 4, 57, 100),

  (51, 4347, 6, 57, 100),

  (51, 4348, 6, 57, 100),

  (51, 4349, 2, 57, 100),

  (51, 4350, 4, 57, 100),

  (51, 4351, 6, 57, 100),

  (51, 4352, 2, 57, 100),

  (51, 4353, 6, 57, 100),

  (51, 4354, 4, 57, 100),

  (51, 4355, 3, 57, 100),

  (51, 4356, 3, 57, 100),

  (51, 4357, 2, 57, 100),

  (51, 4358, 3, 57, 100),

  (51, 4359, 3, 57, 100),

  (51, 4360, 3, 57, 100);

 

[rev0]

AUto EnoeiC? Br0 an 9ec stile m me pm to msn s

[rev0]

Paidia Protimo Na Exo To Archid Alla opws sas eipa dn m pernaei tin buffer stn database...An EinaI Kapoios!

[xXSkillerXx]

Για δοκιμασε αυτο :

 

/*
L2J-Archid Alternative Buffer
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `Npc_Buffer`;
CREATE TABLE `Npc_Buffer` (
  `npc_id` int(5) NOT NULL,
  `skill_id` int(5) NOT NULL,
  `skill_level` int(5) NOT NULL default '1',
  `skill_fee_id` int(5) NOT NULL default '0',
  `skill_fee_amount` int(5) NOT NULL default '0',
  PRIMARY KEY  (`npc_id`,`skill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO Npc_Buffer
   (`npc_id`, `skill_id`, `skill_level`, `skill_fee_id`, `skill_fee_amount`)
VALUES
   (51, 264, 1, 57, 100),
   (51, 265, 1, 57, 100),
   (51, 266, 1, 57, 100),
   (51, 267, 1, 57, 100),
   (51, 268, 1, 57, 100),
   (51, 269, 1, 57, 100),
   (51, 270, 1, 57, 100),
   (51, 271, 1, 57, 100),
   (51, 272, 1, 57, 100),
   (51, 273, 1, 57, 100),
   (51, 274, 1, 57, 100),
   (51, 275, 1, 57, 100),
   (51, 276, 1, 57, 100),
   (51, 277, 1, 57, 100),
   (51, 304, 1, 57, 100),
   (51, 305, 1, 57, 100),
   (51, 306, 1, 57, 100),
   (51, 307, 1, 57, 100),
   (51, 308, 1, 57, 100),
   (51, 309, 1, 57, 100),
   (51, 310, 1, 57, 100),
   (51, 311, 1, 57, 100),
   (51, 349, 1, 57, 100),
   (51, 363, 1, 57, 100),
   (51, 364, 1, 57, 100),
   (51, 365, 1, 57, 100),
   (51, 366, 1, 57, 100),
   (51, 1355, 1, 57, 100),
   (51, 1356, 1, 57, 100),
   (51, 1357, 1, 57, 100),
   (51, 1363, 1, 57, 100),
   (51, 1413, 1, 57, 100),
   (51, 4342, 2, 57, 100),
   (51, 4343, 3, 57, 100),
   (51, 4344, 3, 57, 100),
   (51, 4345, 3, 57, 100),
   (51, 4346, 4, 57, 100),
   (51, 4347, 6, 57, 100),
   (51, 4348, 6, 57, 100),
   (51, 4349, 2, 57, 100),
   (51, 4350, 4, 57, 100),
   (51, 4351, 6, 57, 100),
   (51, 4352, 2, 57, 100),
   (51, 4353, 6, 57, 100),
   (51, 4354, 4, 57, 100),
   (51, 4355, 3, 57, 100),
   (51, 4356, 3, 57, 100),
   (51, 4357, 2, 57, 100),
   (51, 4358, 3, 57, 100),
   (51, 4359, 3, 57, 100),
   (51, 4360, 3, 57, 100);

 

Kαντο execute και μετα πατα ενα refresh.

BTW στο SQL του NPC σου βγαζει error?

[rev0]

FTL Na C Pw Re Ci Bro Pira Enan Allo Buffer Tou Kelin 9a Try Auton Kai 8a sou pw Ty Gia To Help PadoC