Jump to content
  • 0

[Help] Den mporw n vrw Buffer :/


Question

Recommended Posts

  • 0
Posted

pfffff nai dax prosexe esy error otan kanw execute batch file se oles oses exw perasei vgazei errors

 

Tote 2 pragmata mporoun na simbenoun.

 

1) Iparxi syntax error (an kai siga mn einai auto alla tespa to lew pliroforiaka)

2) Ta column einai la8os(99.9% auto einai)

diladi: mesa sto sql arxeio leei as poume:

INSERT INTO `npc` VALUES('54000', '56454', bla bla );

 

kai, mesa sto diko sou table(to npc.sql px) iparxoun perisotera/ligotera column.

(column = stiles, dld ekei p leei npc id, template id ktlp)

 

ara 8a prepei na metrisis ta column sto sql arxeio kai sto navicat kai na prospa8isis na to ftiaksis aferontas/proste8ontas kati. an kai dn 8a einai kai toso eukolo an eisai arxarios alla entaksi, prospa8ise. (note: dn aferi oti na nai. px an dis sto npc to table sto navicat sto telos kapou na leei px: true, 0, 0 , 0, kai sto sql arxeio sto telos leei true, 0, 0, 0, 0, sini8os bgazis ena 0 kai ftiaxni, kapos etc kanto, elpizo na katalabes)

  • 0
Posted

Palikaria kala ola afta alla xerete ti pezei?? perasa tin buffer kai tin kanw spawn kanonika sto l2 alla dn pernw buffs, dld dn leitourgoun pl apla to buff_tamplates einai table tou navicat to opio dn exw... i an dn einai afto ta buff na xerete dn m pernaei alla klasika ekei error. sto exute.

  • 0
Posted

koita file, den douleuoun oles oi buffer/paketa to idio. Katarxas pes mou ligo ti errors exeis ktlp. Sou bgazi as poume sto gameserver oti den iparxi to table auto sto navicat? i mipos sou leei mesa stin buffer otan patas you dont meet the criteria kt tetio?(klasiko problima).

Eksigise mas gia na se help. Pantos an sou lipi to table 8a elega na breis kamia alli buffer kalitera :P

  • 0
Posted

Tote 2 pragmata mporoun na simbenoun.

 

1) Iparxi syntax error (an kai siga mn einai auto alla tespa to lew pliroforiaka)

2) Ta column einai la8os(99.9% auto einai)

pia i diafora tou prwtou me tou deuterou?boreis n m e3hghseis gia na ktlvw dld.

 

@strenght an sou leipei to buff_templates table pare auto

CREATE TABLE IF NOT EXISTS `buff_templates` (
  `id` int(11) unsigned NOT NULL,
  `name` varchar(35) NOT NULL default '',
  `skill_id` int(10) unsigned NOT NULL,
  `skill_name` varchar(35) default NULL,
  `skill_level` int(10) unsigned NOT NULL default '1',
  `skill_force` int(1) NOT NULL default '1',
  `skill_order` int(10) unsigned NOT NULL,
  `char_min_level` int(10) unsigned NOT NULL default '0',
  `char_max_level` int(10) unsigned NOT NULL default '0',
  `price_adena` decimal(10,0) NOT NULL default '-1',
  PRIMARY KEY  (`id`,`name`,`skill_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `buff_templates` */

insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (150,'FullbuffbyUsweer',1204,'Wind Walk',2,1,1,0,80,'-1'),(150,'FullbuffbyUsweer',1032,'Invigore',3,1,2,0,80,'-1'),(150,'FullbuffbyUsweer',1035,'Mental Shield',4,1,3,0,80,'-1'),(150,'FullbuffbyUsweer',1036,'Magic Barrier',2,1,4,0,80,'-1'),(150,'FullbuffbyUsweer',1040,'Shield',3,1,5,0,80,'-1'),(150,'FullbuffbyUsweer',1043,'Hily Weapon',1,1,6,0,80,'-1'),(150,'FullbuffbyUsweer',1044,'Regeneration',3,1,7,0,80,'-1'),(150,'FullbuffbyUsweer',1045,'Blessed Body',6,1,8,0,80,'-1'),(150,'FullbuffbyUsweer',1048,'Blessed Soul',6,1,9,0,80,'-1'),(150,'FullbuffbyUsweer',1062,'Berserker Spirit',2,1,10,0,80,'-1'),(150,'FullbuffbyUsweer',1068,'Might',3,1,11,0,80,'-1'),(150,'FullbuffbyUsweer',1077,'Focus',3,1,12,0,80,'-1'),(150,'FullbuffbyUsweer',1078,'Concentration',6,1,13,0,80,'-1'),(150,'FullbuffbyUsweer',1085,'Acumen',3,1,14,0,80,'-1'),(150,'FullbuffbyUsweer',1086,'Haste',2,1,15,0,80,'-1'),(150,'FullbuffbyUsweer',1087,'Agility',3,1,16,0,80,'-1'),(150,'FullbuffbyUsweer',1182,'Resist Aqua',3,1,17,0,80,'-1'),(150,'FullbuffbyUsweer',1189,'Resist Wind',3,1,18,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (150,'FullbuffbyUsweer',1191,'Resist Fire',3,1,19,0,80,'-1'),(150,'FullbuffbyUsweer',1033,'Resist Potion',3,1,20,0,80,'-1'),(150,'FullbuffbyUsweer',1240,'Guidance',3,1,21,0,80,'-1'),(150,'FullbuffbyUsweer',1242,'Death Whisper',3,1,22,0,80,'-1'),(150,'FullbuffbyUsweer',1243,'Bless Shield',6,1,23,0,80,'-1'),(150,'FullbuffbyUsweer',1257,'Decrease Weight',3,1,24,0,80,'-1'),(150,'FullbuffbyUsweer',1259,'Resist Shock',4,1,25,0,80,'-1'),(150,'FullbuffbyUsweer',1303,'Wild Magic',2,1,26,0,80,'-1'),(150,'FullbuffbyUsweer',1304,'Advanced Block',3,1,27,0,80,'-1'),(150,'FullbuffbyUsweer',1352,'Elemental Protection',1,1,28,0,80,'-1'),(150,'FullbuffbyUsweer',1353,'Divine Protection',1,1,29,0,80,'-1'),(150,'FullbuffbyUsweer',1354,'Arcane Protection',1,1,30,0,80,'-1'),(150,'FullbuffbyUsweer',1392,'Holy Resistance',1,1,31,0,80,'-1'),(150,'FullbuffbyUsweer',1393,'UnHoly Resistance',1,1,32,0,80,'-1'),(150,'FullbuffbyUsweer',1397,'Clarity',3,1,33,0,80,'-1'),(150,'FullbuffbyUsweer',1059,'Greater Empower',3,1,34,0,80,'-1'),(150,'FullbuffbyUsweer',1268,'Vampiric Rage',4,1,35,0,80,'-1'),(150,'FullbuffbyUsweer',1073,'Kiss of Eve',2,1,36,0,80,'-1'),(151,'FulldancebyUsweer',271,'Dance of Warior',1,1,1,0,80,'-1'),(151,'FulldancebyUsweer',272,'Dance of Inspiration',1,1,2,0,80,'-1'),(151,'FulldancebyUsweer',273,'Dance of Mystic',1,1,3,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (151,'FulldancebyUsweer',274,'Dance of Fire',1,1,4,0,80,'-1'),(151,'FulldancebyUsweer',275,'Dance of Fury',1,1,5,0,80,'-1'),(151,'FulldancebyUsweer',276,'Dance of Concentration',1,1,6,0,80,'-1'),(151,'FulldancebyUsweer',277,'Dance of Light',1,1,7,0,80,'-1'),(151,'FulldancebyUsweer',307,'Dance of Aqua Guard',1,1,8,0,80,'-1'),(151,'FulldancebyUsweer',309,'Dance of Earth Guard',1,1,9,0,80,'-1'),(151,'FulldancebyUsweer',310,'Dance of the Vampire',1,1,10,0,80,'-1'),(151,'FulldancebyUsweer',311,'Dance of Protection',1,1,11,0,80,'-1'),(151,'FulldancebyUsweer',365,'Sirens Dance',1,1,12,0,80,'-1'),(151,'FulldancebyUsweer',366,'Dance of Shadow',1,1,13,0,80,'-1'),(152,'FullsongbyUsweer',264,'Song of Earth',1,1,1,0,80,'-1'),(152,'FullsongbyUsweer',265,'Song of Life',1,1,2,0,80,'-1'),(152,'FullsongbyUsweer',266,'Song of Water',1,1,3,0,80,'-1'),(152,'FullsongbyUsweer',267,'Song of Warding',1,1,4,0,80,'-1'),(152,'FullsongbyUsweer',268,'Song of Wind',1,1,5,0,80,'-1'),(152,'FullsongbyUsweer',269,'Song of Hunter',1,1,6,0,80,'-1'),(152,'FullsongbyUsweer',270,'Song of Invocation',1,1,7,0,80,'-1'),(152,'FullsongbyUsweer',304,'Song of Vitality',1,1,8,0,80,'-1'),(152,'FullsongbyUsweer',305,'Song of Vengeance',1,1,9,0,80,'-1'),(152,'FullsongbyUsweer',306,'Song of Flame Guard',1,1,10,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (152,'FullsongbyUsweer',308,'Song of Storm Guard',1,1,11,0,80,'-1'),(152,'FullsongbyUsweer',349,'Song of Renewal',1,1,12,0,80,'-1'),(152,'FullsongbyUsweer',363,'Song of Meditation',1,1,13,0,80,'-1'),(152,'FullsongbyUsweer',364,'Song of Champion',1,1,14,0,80,'-1'),(153,'FulldominatorbyUsweer',1003,'Pa agrian Gift',3,1,1,0,80,'-1'),(153,'FulldominatorbyUsweer',1005,'Blessing of Pa agrio',3,1,2,0,80,'-1'),(153,'FulldominatorbyUsweer',1004,'The Wisdom of Pa agrio',3,1,3,0,80,'-1'),(153,'FulldominatorbyUsweer',1008,'The Glory  of Pa agrio',3,1,4,0,80,'-1'),(153,'FulldominatorbyUsweer',1249,'The Vision of Pa agrio',3,1,5,0,80,'-1'),(153,'FulldominatorbyUsweer',1250,'Under The Protection  of Pa agrio',3,1,6,0,80,'-1'),(153,'FulldominatorbyUsweer',1260,'The Tact  of Pa agrio',3,1,7,0,80,'-1'),(153,'FulldominatorbyUsweer',1261,'The Rage  of Pa agrio',2,1,8,0,80,'-1'),(153,'FulldominatorbyUsweer',1282,' Pa agrio Haste',2,1,9,0,80,'-1'),(153,'FulldominatorbyUsweer',1364,'The Eye of Pa agrio',1,1,10,0,80,'-1'),(153,'FulldominatorbyUsweer',1365,'The Soul of Pa agrio',1,1,11,0,80,'-1'),(153,'FulldominatorbyUsweer',1414,'Victories  of Pa agrio',1,1,12,0,80,'-1'),(153,'FulldominatorbyUsweer',1416,' Pa agrio Fist',1,1,13,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1002,'Flame Chant',3,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (154,'FulldoomcryerbyUsweer',1006,'Chant of Fire',3,1,2,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1007,'Chant of Battle',3,1,3,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1009,'Chant of Shielding',3,1,4,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1251,'Chant of Fury',2,1,5,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1252,'Chant of Evasion',3,1,6,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1253,'Chant of Rage',3,1,7,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1284,'Chant of Revenge',3,1,8,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1308,'Chant of Predator',3,1,9,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1309,'Chant of Eagle',3,1,10,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1310,'Chant of Vampire',4,1,11,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1362,'Chant of Spirit',1,1,12,0,80,'-1'),(155,'WindWalkbyUsweer',1204,'Wind Walk',2,1,1,0,80,'-1'),(156,'InvigorebyUsweer',1032,'Invigore',3,1,1,0,80,'-1'),(157,'MentalShieldbyUsweer',1035,'Mental Shield',4,1,1,0,80,'-1'),(158,'MagicBarrierbyUsweer',1036,'Magic Barrier',2,1,1,0,80,'-1'),(159,'ShieldbyUsweer',1040,'Shield',3,1,1,0,80,'-1'),(160,'HilyWeaponbyUsweer',1043,'Hily Weapon',1,1,1,0,80,'-1'),(161,'RegenerationbyUsweer',1044,'Regeneration',3,1,1,0,80,'-1'),(162,'BlessedBodybyUsweer',1045,'Blessed Body',6,1,1,0,80,'-1'),(163,'BlessedSoulbyUsweer',1048,'Blessed Soul',6,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (164,'BerserkerSpiritbyUsweer',1062,'Berserker Spirit',2,1,1,0,80,'-1'),(165,'MightbyUsweer',1068,'Might',3,1,1,0,80,'-1'),(166,'FocusbyUsweer',1077,'Focus',3,1,1,0,80,'-1'),(167,'ConcentrationbyUsweer',1078,'Concentration',6,1,1,0,80,'-1'),(168,'AcumenbyUsweer',1085,'Acumen',3,0,1,0,80,'-1'),(169,'HastebyUsweer',1086,'Haste',2,1,1,0,80,'-1'),(170,'AgilitybyUsweer',1087,'Agility',3,1,1,0,80,'-1'),(171,'ResistAquabyUsweer',1182,'Resist Aqua',3,1,1,0,80,'-1'),(172,'ResistWindbyUsweer',1189,'Resist Wind',3,1,1,0,80,'-1'),(173,'ResistFirebyUsweer',1191,'Resist Fire',3,1,1,0,80,'-1'),(174,'ResistPotionbyUsweer',1033,'Resist Potion',3,1,1,0,80,'-1'),(175,'GuidancebyUsweer',1240,'Guidance',3,1,1,0,80,'-1'),(176,'DeathWhisperbyUsweer',1242,'Death Whisper',3,1,1,0,80,'-1'),(177,'BlessShieldbyUsweer',1243,'Bless Shield',6,1,1,0,80,'-1'),(178,'DecreaseWeightbyUsweer',1257,'Decrease Weight',3,1,1,0,80,'-1'),(179,'ResistShockbyUsweer',1259,'Resist Shock',4,1,1,0,80,'-1'),(180,'WildMagicbyUsweer',1303,'Wild Magic',2,1,1,0,80,'-1'),(181,'AdvancedBlockbyUsweer',1304,'Advanced Block',3,1,1,0,80,'-1'),(182,'ElementalProtectionbyUsweer',1352,'Elemental Protection',1,1,1,0,80,'-1'),(183,'DivineProtectionbyUsweer',1353,'Divine Protection',1,1,1,0,80,'-1'),(184,'ArcaneProtectionbyUsweer',1354,'Arcane Protection',1,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (185,'HolyResistancebyUsweer',1392,'Holy Resistance',1,1,1,0,80,'-1'),(186,'UnHolyResistancebyUsweer',1393,'UnHoly Resistance',1,1,1,0,80,'-1'),(187,'ClaritybyUsweer',1397,'Clarity',3,1,1,0,80,'-1'),(188,'GreaterEmpowerbyUsweer',1059,'Greater Empower',3,1,1,0,80,'-1'),(189,'VampiricRagebyUsweer',1268,'Vampiric Rage',4,1,1,0,80,'-1'),(190,'KissofEvebyUsweer',1073,'Kiss of Eve',2,1,1,0,80,'-1'),(191,'DanceofWariorbyUsweer',271,'Dance of Warior',1,1,1,0,80,'-1'),(192,'DanceofInspirationbyUsweer',272,'Dance of Inspiration',1,1,1,0,80,'-1'),(193,'DanceofMysticbyUsweer',273,'Dance of Mystic',1,1,1,0,80,'-1'),(194,'DanceofFirebyUsweer',274,'Dance of Fire',1,1,1,0,80,'-1'),(195,'DanceofFurybyUsweer',275,'Dance of Fury',1,1,1,0,80,'-1'),(196,'DanceofConcentrationbyUsweer',276,'Dance of Concentration',1,1,1,0,80,'-1'),(197,'DanceofLightbyUsweer',277,'Dance of Light',1,1,1,0,80,'-1'),(198,'DanceofAquaGuardbyUsweer',307,'Dance of Aqua Guard',1,1,1,0,80,'-1'),(199,'DanceofEarthGuardbyUsweer',309,'Dance of Earth Guard',1,1,1,0,80,'-1'),(200,'DanceoftheVampirebyUsweer',310,'Dance of the Vampire',1,1,1,0,80,'-1'),(201,'DanceofProtectionbyUsweer',311,'Dance of Protection',1,1,1,0,80,'-1'),(202,'SirensDancebyUsweer',365,'Sirens Dance',1,1,1,0,80,'-1'),(203,'DanceofShadowbyUsweer',366,'Dance of Shadow',1,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (204,'SongofEarthbyUsweer',264,'Song of Earth',1,1,1,0,80,'-1'),(205,'SongofLifebyUsweer',265,'Song of Life',1,1,1,0,80,'-1'),(206,'SongofWaterbyUsweer',266,'Song of Water',1,1,1,0,80,'-1'),(207,'SongofWardingbyUsweer',267,'Song of Warding',1,1,1,0,80,'-1'),(208,'SongofWindbyUsweer',268,'Song of Wind',1,1,1,0,80,'-1'),(209,'SongofHunterbyUsweer',269,'Song of Hunter',1,1,1,0,80,'-1'),(210,'SongofInvocationbyUsweer',270,'Song of Invocation',1,1,1,0,80,'-1'),(211,'SongofVitalitybyUsweer',304,'Song of Vitality',1,1,1,0,80,'-1'),(212,'SongofVengeancebyUsweer',305,'Song of Vengeance',1,1,1,0,80,'-1'),(213,'SongofFlameGuardbyUsweer',306,'Song of Flame Guard',1,1,1,0,80,'-1'),(214,'SongofStormGuardbyUsweer',308,'Song of Storm Guard',1,1,1,0,80,'-1'),(215,'SongofRenewalbyUsweer',349,'Song of Renewal',1,1,1,0,80,'-1'),(216,'SongofMeditationbyUsweer',363,'Song of Meditation',1,1,1,0,80,'-1'),(217,'SongofChampionbyUsweer',364,'Song of Champion',1,1,1,0,80,'-1'),(218,'PaagrianGiftbyUsweer',1003,'Pa agrian Gift',3,1,1,0,80,'-1'),(219,'BlessingofPaagriobyUsweer',1005,'Blessing of Pa agrio',3,1,1,0,80,'-1'),(220,'TheWisdomofPaagriobyUsweer',1004,'The Wisdom of Pa agrio',3,1,1,0,80,'-1'),(221,'TheGloryofPaagriobyUsweer',1008,'The Glory  of Pa agrio',3,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (222,'TheVisionofPaagriobyUsweer',1249,'The Vision of Pa agrio',3,1,1,0,80,'-1'),(223,'UnderTheProtectionofPaagriobyUsweer',1250,'Under The Protection  of Pa agrio',3,1,1,0,80,'-1'),(224,'TheTactofPaagriobyUsweer',1260,'The Tact  of Pa agrio',3,1,1,0,80,'-1'),(225,'TheRageofPaagriobyUsweer',1261,'The Rage  of Pa agrio',2,1,1,0,80,'-1'),(226,'PaagrioHastebyUsweer',1282,' Pa agrio Haste',2,1,1,0,80,'-1'),(227,'TheEyeofPaagriobyUsweer',1364,'The Eye of Pa agrio',1,1,1,0,80,'-1'),(228,'TheSoulofPaagriobyUsweer',1365,'The Soul of Pa agrio',1,1,1,0,80,'-1'),(229,'VictoriesofPaagriobyUsweer',1414,'Victories  of Pa agrio',1,1,1,0,80,'-1'),(230,'PaagrioFistbyUsweer',1416,' Pa agrio Fist',1,1,1,0,80,'-1'),(231,'FlameChantbyUsweer',1002,'Flame Chant',3,1,1,0,80,'-1'),(232,'ChantofFirebyUsweer',1006,'Chant of Fire',3,1,1,0,80,'-1'),(233,'ChantofBattlebyUsweer',1007,'Chant of Battle',3,1,1,0,80,'-1'),(234,'ChantofShieldingbyUsweer',1009,'Chant of Shielding',3,1,1,0,80,'-1'),(235,'ChantofFurybyUsweer',1251,'Chant of Fury',2,1,1,0,80,'-1'),(236,'ChantofEvasionbyUsweer',1252,'Chant of Evasion',3,1,1,0,80,'-1'),(237,'ChantofRagebyUsweer',1253,'Chant of Rage',3,1,1,0,80,'-1'),(238,'ChantofRevengebyUsweer',1284,'Chant of Revenge',3,1,1,0,80,'-1'),(239,'ChantofPredatorbyUsweer',1308,'Chant of Predator',3,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (240,'ChantofEaglebyUsweer',1309,'Chant of Eagle',3,1,1,0,80,'-1'),(241,'ChantofVampirebyUsweer',1310,'Chant of Vampire',4,1,1,0,80,'-1'),(242,'ChantofSpiritbyUsweer',1362,'Chant of Spirit',1,1,1,0,80,'-1'),(243,'ProphecyofFirebyUsweer',1356,'Prophecy of Fire',1,1,1,0,80,'-1'),(244,'ProphecyofWaterbyUsweer',1355,'Prophecy of Water',1,1,1,0,80,'-1'),(245,'ProphecyofWindbyUsweer',1357,'Prophecy of Wind',1,1,1,0,80,'-1'),(246,'ChantofVictorybyUsweer',1363,'Chant of Victory',1,1,1,0,80,'-1'),(247,'GreateMightbyUsweer',1388,'Greate Might',3,1,1,0,80,'-1'),(248,'GreateShieldbyUsweer',1389,'Greate Shield',3,1,1,0,80,'-1'),(249,'WarChantbyUsweer',1390,'War Chant',3,1,1,0,80,'-1'),(250,'EarthChantbyUsweer',1391,'Earth Chant',3,1,1,0,80,'-1'),(251,'BlessingofSeraphimbyUsweer',4702,'Blessing of Seraphim',8,1,1,0,80,'-1'),(252,'GiftofSeraphimbyUsweer',4703,'Gift of Seraphim',8,1,1,0,80,'-1'),(253,'BlessingofQueenbyUsweer',4699,'Blessing of Queen',8,1,1,0,80,'-1'),(254,'GiftofQueenbyUsweer',4700,'Gift of Queen',8,1,1,0,80,'-1'),(255,'SummonLifebyUsweer',67,'Summon Life',7,1,1,0,80,'-1'),(256,'SummonAquabyUsweer',1280,'Summon Aqua',9,1,1,0,80,'-1'),(257,'SummonStormbyUsweer',1328,'Summon Storm',8,1,1,0,80,'-1'),(258,'SummonBindingbyUsweer',1279,'Summon Binding',9,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (259,'SummonSparkbyUsweer',1281,'Summon Spark',9,1,1,0,80,'-1'),(260,'SummonPhantombyUsweer',33,'Summon Phantom',8,1,1,0,80,'-1');

insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (261,'MagnusChantbyUsweer',1413,'Magnus Chant',1,1,1,0,80,'-1')

einai to buff_template table tou l2jfrozen

dwse feedback kai pes mou an einai symvato.

  • 0
Posted

Tote 2 pragmata mporoun na simbenoun.

 

1) Iparxi syntax error (an kai siga mn einai auto alla tespa to lew pliroforiaka)

2) Ta column einai la8os(99.9% auto einai)

pia i diafora tou prwtou me tou deuterou?boreis n m e3hghseis gia na ktlvw dld.

 

@strenght an sou leipei to buff_templates table pare auto

CREATE TABLE IF NOT EXISTS `buff_templates` (
  `id` int(11) unsigned NOT NULL,
  `name` varchar(35) NOT NULL default '',
  `skill_id` int(10) unsigned NOT NULL,
  `skill_name` varchar(35) default NULL,
  `skill_level` int(10) unsigned NOT NULL default '1',
  `skill_force` int(1) NOT NULL default '1',
  `skill_order` int(10) unsigned NOT NULL,
  `char_min_level` int(10) unsigned NOT NULL default '0',
  `char_max_level` int(10) unsigned NOT NULL default '0',
  `price_adena` decimal(10,0) NOT NULL default '-1',
  PRIMARY KEY  (`id`,`name`,`skill_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `buff_templates` */

insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (150,'FullbuffbyUsweer',1204,'Wind Walk',2,1,1,0,80,'-1'),(150,'FullbuffbyUsweer',1032,'Invigore',3,1,2,0,80,'-1'),(150,'FullbuffbyUsweer',1035,'Mental Shield',4,1,3,0,80,'-1'),(150,'FullbuffbyUsweer',1036,'Magic Barrier',2,1,4,0,80,'-1'),(150,'FullbuffbyUsweer',1040,'Shield',3,1,5,0,80,'-1'),(150,'FullbuffbyUsweer',1043,'Hily Weapon',1,1,6,0,80,'-1'),(150,'FullbuffbyUsweer',1044,'Regeneration',3,1,7,0,80,'-1'),(150,'FullbuffbyUsweer',1045,'Blessed Body',6,1,8,0,80,'-1'),(150,'FullbuffbyUsweer',1048,'Blessed Soul',6,1,9,0,80,'-1'),(150,'FullbuffbyUsweer',1062,'Berserker Spirit',2,1,10,0,80,'-1'),(150,'FullbuffbyUsweer',1068,'Might',3,1,11,0,80,'-1'),(150,'FullbuffbyUsweer',1077,'Focus',3,1,12,0,80,'-1'),(150,'FullbuffbyUsweer',1078,'Concentration',6,1,13,0,80,'-1'),(150,'FullbuffbyUsweer',1085,'Acumen',3,1,14,0,80,'-1'),(150,'FullbuffbyUsweer',1086,'Haste',2,1,15,0,80,'-1'),(150,'FullbuffbyUsweer',1087,'Agility',3,1,16,0,80,'-1'),(150,'FullbuffbyUsweer',1182,'Resist Aqua',3,1,17,0,80,'-1'),(150,'FullbuffbyUsweer',1189,'Resist Wind',3,1,18,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (150,'FullbuffbyUsweer',1191,'Resist Fire',3,1,19,0,80,'-1'),(150,'FullbuffbyUsweer',1033,'Resist Potion',3,1,20,0,80,'-1'),(150,'FullbuffbyUsweer',1240,'Guidance',3,1,21,0,80,'-1'),(150,'FullbuffbyUsweer',1242,'Death Whisper',3,1,22,0,80,'-1'),(150,'FullbuffbyUsweer',1243,'Bless Shield',6,1,23,0,80,'-1'),(150,'FullbuffbyUsweer',1257,'Decrease Weight',3,1,24,0,80,'-1'),(150,'FullbuffbyUsweer',1259,'Resist Shock',4,1,25,0,80,'-1'),(150,'FullbuffbyUsweer',1303,'Wild Magic',2,1,26,0,80,'-1'),(150,'FullbuffbyUsweer',1304,'Advanced Block',3,1,27,0,80,'-1'),(150,'FullbuffbyUsweer',1352,'Elemental Protection',1,1,28,0,80,'-1'),(150,'FullbuffbyUsweer',1353,'Divine Protection',1,1,29,0,80,'-1'),(150,'FullbuffbyUsweer',1354,'Arcane Protection',1,1,30,0,80,'-1'),(150,'FullbuffbyUsweer',1392,'Holy Resistance',1,1,31,0,80,'-1'),(150,'FullbuffbyUsweer',1393,'UnHoly Resistance',1,1,32,0,80,'-1'),(150,'FullbuffbyUsweer',1397,'Clarity',3,1,33,0,80,'-1'),(150,'FullbuffbyUsweer',1059,'Greater Empower',3,1,34,0,80,'-1'),(150,'FullbuffbyUsweer',1268,'Vampiric Rage',4,1,35,0,80,'-1'),(150,'FullbuffbyUsweer',1073,'Kiss of Eve',2,1,36,0,80,'-1'),(151,'FulldancebyUsweer',271,'Dance of Warior',1,1,1,0,80,'-1'),(151,'FulldancebyUsweer',272,'Dance of Inspiration',1,1,2,0,80,'-1'),(151,'FulldancebyUsweer',273,'Dance of Mystic',1,1,3,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (151,'FulldancebyUsweer',274,'Dance of Fire',1,1,4,0,80,'-1'),(151,'FulldancebyUsweer',275,'Dance of Fury',1,1,5,0,80,'-1'),(151,'FulldancebyUsweer',276,'Dance of Concentration',1,1,6,0,80,'-1'),(151,'FulldancebyUsweer',277,'Dance of Light',1,1,7,0,80,'-1'),(151,'FulldancebyUsweer',307,'Dance of Aqua Guard',1,1,8,0,80,'-1'),(151,'FulldancebyUsweer',309,'Dance of Earth Guard',1,1,9,0,80,'-1'),(151,'FulldancebyUsweer',310,'Dance of the Vampire',1,1,10,0,80,'-1'),(151,'FulldancebyUsweer',311,'Dance of Protection',1,1,11,0,80,'-1'),(151,'FulldancebyUsweer',365,'Sirens Dance',1,1,12,0,80,'-1'),(151,'FulldancebyUsweer',366,'Dance of Shadow',1,1,13,0,80,'-1'),(152,'FullsongbyUsweer',264,'Song of Earth',1,1,1,0,80,'-1'),(152,'FullsongbyUsweer',265,'Song of Life',1,1,2,0,80,'-1'),(152,'FullsongbyUsweer',266,'Song of Water',1,1,3,0,80,'-1'),(152,'FullsongbyUsweer',267,'Song of Warding',1,1,4,0,80,'-1'),(152,'FullsongbyUsweer',268,'Song of Wind',1,1,5,0,80,'-1'),(152,'FullsongbyUsweer',269,'Song of Hunter',1,1,6,0,80,'-1'),(152,'FullsongbyUsweer',270,'Song of Invocation',1,1,7,0,80,'-1'),(152,'FullsongbyUsweer',304,'Song of Vitality',1,1,8,0,80,'-1'),(152,'FullsongbyUsweer',305,'Song of Vengeance',1,1,9,0,80,'-1'),(152,'FullsongbyUsweer',306,'Song of Flame Guard',1,1,10,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (152,'FullsongbyUsweer',308,'Song of Storm Guard',1,1,11,0,80,'-1'),(152,'FullsongbyUsweer',349,'Song of Renewal',1,1,12,0,80,'-1'),(152,'FullsongbyUsweer',363,'Song of Meditation',1,1,13,0,80,'-1'),(152,'FullsongbyUsweer',364,'Song of Champion',1,1,14,0,80,'-1'),(153,'FulldominatorbyUsweer',1003,'Pa agrian Gift',3,1,1,0,80,'-1'),(153,'FulldominatorbyUsweer',1005,'Blessing of Pa agrio',3,1,2,0,80,'-1'),(153,'FulldominatorbyUsweer',1004,'The Wisdom of Pa agrio',3,1,3,0,80,'-1'),(153,'FulldominatorbyUsweer',1008,'The Glory  of Pa agrio',3,1,4,0,80,'-1'),(153,'FulldominatorbyUsweer',1249,'The Vision of Pa agrio',3,1,5,0,80,'-1'),(153,'FulldominatorbyUsweer',1250,'Under The Protection  of Pa agrio',3,1,6,0,80,'-1'),(153,'FulldominatorbyUsweer',1260,'The Tact  of Pa agrio',3,1,7,0,80,'-1'),(153,'FulldominatorbyUsweer',1261,'The Rage  of Pa agrio',2,1,8,0,80,'-1'),(153,'FulldominatorbyUsweer',1282,' Pa agrio Haste',2,1,9,0,80,'-1'),(153,'FulldominatorbyUsweer',1364,'The Eye of Pa agrio',1,1,10,0,80,'-1'),(153,'FulldominatorbyUsweer',1365,'The Soul of Pa agrio',1,1,11,0,80,'-1'),(153,'FulldominatorbyUsweer',1414,'Victories  of Pa agrio',1,1,12,0,80,'-1'),(153,'FulldominatorbyUsweer',1416,' Pa agrio Fist',1,1,13,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1002,'Flame Chant',3,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (154,'FulldoomcryerbyUsweer',1006,'Chant of Fire',3,1,2,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1007,'Chant of Battle',3,1,3,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1009,'Chant of Shielding',3,1,4,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1251,'Chant of Fury',2,1,5,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1252,'Chant of Evasion',3,1,6,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1253,'Chant of Rage',3,1,7,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1284,'Chant of Revenge',3,1,8,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1308,'Chant of Predator',3,1,9,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1309,'Chant of Eagle',3,1,10,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1310,'Chant of Vampire',4,1,11,0,80,'-1'),(154,'FulldoomcryerbyUsweer',1362,'Chant of Spirit',1,1,12,0,80,'-1'),(155,'WindWalkbyUsweer',1204,'Wind Walk',2,1,1,0,80,'-1'),(156,'InvigorebyUsweer',1032,'Invigore',3,1,1,0,80,'-1'),(157,'MentalShieldbyUsweer',1035,'Mental Shield',4,1,1,0,80,'-1'),(158,'MagicBarrierbyUsweer',1036,'Magic Barrier',2,1,1,0,80,'-1'),(159,'ShieldbyUsweer',1040,'Shield',3,1,1,0,80,'-1'),(160,'HilyWeaponbyUsweer',1043,'Hily Weapon',1,1,1,0,80,'-1'),(161,'RegenerationbyUsweer',1044,'Regeneration',3,1,1,0,80,'-1'),(162,'BlessedBodybyUsweer',1045,'Blessed Body',6,1,1,0,80,'-1'),(163,'BlessedSoulbyUsweer',1048,'Blessed Soul',6,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (164,'BerserkerSpiritbyUsweer',1062,'Berserker Spirit',2,1,1,0,80,'-1'),(165,'MightbyUsweer',1068,'Might',3,1,1,0,80,'-1'),(166,'FocusbyUsweer',1077,'Focus',3,1,1,0,80,'-1'),(167,'ConcentrationbyUsweer',1078,'Concentration',6,1,1,0,80,'-1'),(168,'AcumenbyUsweer',1085,'Acumen',3,0,1,0,80,'-1'),(169,'HastebyUsweer',1086,'Haste',2,1,1,0,80,'-1'),(170,'AgilitybyUsweer',1087,'Agility',3,1,1,0,80,'-1'),(171,'ResistAquabyUsweer',1182,'Resist Aqua',3,1,1,0,80,'-1'),(172,'ResistWindbyUsweer',1189,'Resist Wind',3,1,1,0,80,'-1'),(173,'ResistFirebyUsweer',1191,'Resist Fire',3,1,1,0,80,'-1'),(174,'ResistPotionbyUsweer',1033,'Resist Potion',3,1,1,0,80,'-1'),(175,'GuidancebyUsweer',1240,'Guidance',3,1,1,0,80,'-1'),(176,'DeathWhisperbyUsweer',1242,'Death Whisper',3,1,1,0,80,'-1'),(177,'BlessShieldbyUsweer',1243,'Bless Shield',6,1,1,0,80,'-1'),(178,'DecreaseWeightbyUsweer',1257,'Decrease Weight',3,1,1,0,80,'-1'),(179,'ResistShockbyUsweer',1259,'Resist Shock',4,1,1,0,80,'-1'),(180,'WildMagicbyUsweer',1303,'Wild Magic',2,1,1,0,80,'-1'),(181,'AdvancedBlockbyUsweer',1304,'Advanced Block',3,1,1,0,80,'-1'),(182,'ElementalProtectionbyUsweer',1352,'Elemental Protection',1,1,1,0,80,'-1'),(183,'DivineProtectionbyUsweer',1353,'Divine Protection',1,1,1,0,80,'-1'),(184,'ArcaneProtectionbyUsweer',1354,'Arcane Protection',1,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (185,'HolyResistancebyUsweer',1392,'Holy Resistance',1,1,1,0,80,'-1'),(186,'UnHolyResistancebyUsweer',1393,'UnHoly Resistance',1,1,1,0,80,'-1'),(187,'ClaritybyUsweer',1397,'Clarity',3,1,1,0,80,'-1'),(188,'GreaterEmpowerbyUsweer',1059,'Greater Empower',3,1,1,0,80,'-1'),(189,'VampiricRagebyUsweer',1268,'Vampiric Rage',4,1,1,0,80,'-1'),(190,'KissofEvebyUsweer',1073,'Kiss of Eve',2,1,1,0,80,'-1'),(191,'DanceofWariorbyUsweer',271,'Dance of Warior',1,1,1,0,80,'-1'),(192,'DanceofInspirationbyUsweer',272,'Dance of Inspiration',1,1,1,0,80,'-1'),(193,'DanceofMysticbyUsweer',273,'Dance of Mystic',1,1,1,0,80,'-1'),(194,'DanceofFirebyUsweer',274,'Dance of Fire',1,1,1,0,80,'-1'),(195,'DanceofFurybyUsweer',275,'Dance of Fury',1,1,1,0,80,'-1'),(196,'DanceofConcentrationbyUsweer',276,'Dance of Concentration',1,1,1,0,80,'-1'),(197,'DanceofLightbyUsweer',277,'Dance of Light',1,1,1,0,80,'-1'),(198,'DanceofAquaGuardbyUsweer',307,'Dance of Aqua Guard',1,1,1,0,80,'-1'),(199,'DanceofEarthGuardbyUsweer',309,'Dance of Earth Guard',1,1,1,0,80,'-1'),(200,'DanceoftheVampirebyUsweer',310,'Dance of the Vampire',1,1,1,0,80,'-1'),(201,'DanceofProtectionbyUsweer',311,'Dance of Protection',1,1,1,0,80,'-1'),(202,'SirensDancebyUsweer',365,'Sirens Dance',1,1,1,0,80,'-1'),(203,'DanceofShadowbyUsweer',366,'Dance of Shadow',1,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (204,'SongofEarthbyUsweer',264,'Song of Earth',1,1,1,0,80,'-1'),(205,'SongofLifebyUsweer',265,'Song of Life',1,1,1,0,80,'-1'),(206,'SongofWaterbyUsweer',266,'Song of Water',1,1,1,0,80,'-1'),(207,'SongofWardingbyUsweer',267,'Song of Warding',1,1,1,0,80,'-1'),(208,'SongofWindbyUsweer',268,'Song of Wind',1,1,1,0,80,'-1'),(209,'SongofHunterbyUsweer',269,'Song of Hunter',1,1,1,0,80,'-1'),(210,'SongofInvocationbyUsweer',270,'Song of Invocation',1,1,1,0,80,'-1'),(211,'SongofVitalitybyUsweer',304,'Song of Vitality',1,1,1,0,80,'-1'),(212,'SongofVengeancebyUsweer',305,'Song of Vengeance',1,1,1,0,80,'-1'),(213,'SongofFlameGuardbyUsweer',306,'Song of Flame Guard',1,1,1,0,80,'-1'),(214,'SongofStormGuardbyUsweer',308,'Song of Storm Guard',1,1,1,0,80,'-1'),(215,'SongofRenewalbyUsweer',349,'Song of Renewal',1,1,1,0,80,'-1'),(216,'SongofMeditationbyUsweer',363,'Song of Meditation',1,1,1,0,80,'-1'),(217,'SongofChampionbyUsweer',364,'Song of Champion',1,1,1,0,80,'-1'),(218,'PaagrianGiftbyUsweer',1003,'Pa agrian Gift',3,1,1,0,80,'-1'),(219,'BlessingofPaagriobyUsweer',1005,'Blessing of Pa agrio',3,1,1,0,80,'-1'),(220,'TheWisdomofPaagriobyUsweer',1004,'The Wisdom of Pa agrio',3,1,1,0,80,'-1'),(221,'TheGloryofPaagriobyUsweer',1008,'The Glory  of Pa agrio',3,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (222,'TheVisionofPaagriobyUsweer',1249,'The Vision of Pa agrio',3,1,1,0,80,'-1'),(223,'UnderTheProtectionofPaagriobyUsweer',1250,'Under The Protection  of Pa agrio',3,1,1,0,80,'-1'),(224,'TheTactofPaagriobyUsweer',1260,'The Tact  of Pa agrio',3,1,1,0,80,'-1'),(225,'TheRageofPaagriobyUsweer',1261,'The Rage  of Pa agrio',2,1,1,0,80,'-1'),(226,'PaagrioHastebyUsweer',1282,' Pa agrio Haste',2,1,1,0,80,'-1'),(227,'TheEyeofPaagriobyUsweer',1364,'The Eye of Pa agrio',1,1,1,0,80,'-1'),(228,'TheSoulofPaagriobyUsweer',1365,'The Soul of Pa agrio',1,1,1,0,80,'-1'),(229,'VictoriesofPaagriobyUsweer',1414,'Victories  of Pa agrio',1,1,1,0,80,'-1'),(230,'PaagrioFistbyUsweer',1416,' Pa agrio Fist',1,1,1,0,80,'-1'),(231,'FlameChantbyUsweer',1002,'Flame Chant',3,1,1,0,80,'-1'),(232,'ChantofFirebyUsweer',1006,'Chant of Fire',3,1,1,0,80,'-1'),(233,'ChantofBattlebyUsweer',1007,'Chant of Battle',3,1,1,0,80,'-1'),(234,'ChantofShieldingbyUsweer',1009,'Chant of Shielding',3,1,1,0,80,'-1'),(235,'ChantofFurybyUsweer',1251,'Chant of Fury',2,1,1,0,80,'-1'),(236,'ChantofEvasionbyUsweer',1252,'Chant of Evasion',3,1,1,0,80,'-1'),(237,'ChantofRagebyUsweer',1253,'Chant of Rage',3,1,1,0,80,'-1'),(238,'ChantofRevengebyUsweer',1284,'Chant of Revenge',3,1,1,0,80,'-1'),(239,'ChantofPredatorbyUsweer',1308,'Chant of Predator',3,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (240,'ChantofEaglebyUsweer',1309,'Chant of Eagle',3,1,1,0,80,'-1'),(241,'ChantofVampirebyUsweer',1310,'Chant of Vampire',4,1,1,0,80,'-1'),(242,'ChantofSpiritbyUsweer',1362,'Chant of Spirit',1,1,1,0,80,'-1'),(243,'ProphecyofFirebyUsweer',1356,'Prophecy of Fire',1,1,1,0,80,'-1'),(244,'ProphecyofWaterbyUsweer',1355,'Prophecy of Water',1,1,1,0,80,'-1'),(245,'ProphecyofWindbyUsweer',1357,'Prophecy of Wind',1,1,1,0,80,'-1'),(246,'ChantofVictorybyUsweer',1363,'Chant of Victory',1,1,1,0,80,'-1'),(247,'GreateMightbyUsweer',1388,'Greate Might',3,1,1,0,80,'-1'),(248,'GreateShieldbyUsweer',1389,'Greate Shield',3,1,1,0,80,'-1'),(249,'WarChantbyUsweer',1390,'War Chant',3,1,1,0,80,'-1'),(250,'EarthChantbyUsweer',1391,'Earth Chant',3,1,1,0,80,'-1'),(251,'BlessingofSeraphimbyUsweer',4702,'Blessing of Seraphim',8,1,1,0,80,'-1'),(252,'GiftofSeraphimbyUsweer',4703,'Gift of Seraphim',8,1,1,0,80,'-1'),(253,'BlessingofQueenbyUsweer',4699,'Blessing of Queen',8,1,1,0,80,'-1'),(254,'GiftofQueenbyUsweer',4700,'Gift of Queen',8,1,1,0,80,'-1'),(255,'SummonLifebyUsweer',67,'Summon Life',7,1,1,0,80,'-1'),(256,'SummonAquabyUsweer',1280,'Summon Aqua',9,1,1,0,80,'-1'),(257,'SummonStormbyUsweer',1328,'Summon Storm',8,1,1,0,80,'-1'),(258,'SummonBindingbyUsweer',1279,'Summon Binding',9,1,1,0,80,'-1');
insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (259,'SummonSparkbyUsweer',1281,'Summon Spark',9,1,1,0,80,'-1'),(260,'SummonPhantombyUsweer',33,'Summon Phantom',8,1,1,0,80,'-1');

insert into `buff_templates` (`id`,`name`,`skill_id`,`skill_name`,`skill_level`,`skill_force`,`skill_order`,`char_min_level`,`char_max_level`,`price_adena`) values (261,'MagnusChantbyUsweer',1413,'Magnus Chant',1,1,1,0,80,'-1')

einai to buff_template table tou l2jfrozen

dwse feedback kai pes mou an einai symvato.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...