Jump to content
The Best Lineage 2 Mods – Free & Custom
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

[Help] Den mporw n vrw Buffer :/

strenght

Asked by strenght,

 Share

Question

strenght Newbie

strenght

Posted
Posted

Re guys dn xerw ti na pw exw dokimasei sxedon oles alla oles vgazoun errors alles dn vgazoun alla dn mpenoun :/ ti mporei na ftei??? gia gracia final milame

17 answers to this question

Recommended Posts

  • 0
[DEV]DjSt3rios Newbie

[DEV]DjSt3rios

Posted
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
strenght Newbie

strenght

Posted
  • Author
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
[DEV]DjSt3rios Newbie

[DEV]DjSt3rios

Posted
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
sτrίkε- Newbie

sτrίkε-

Posted
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
sτrίkε- Newbie

sτrίkε-

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

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
 Share
Go to question listing


  • Posts

    • TeleLoopPulse
      Telegram Member Add — 1K for $55 | Targeted - Telegram: @Tel

      By TeleLoopPulse · Posted

      We can help your Telegram group or channel grow fast with real, targeted Telegram members, safely and efficiently.   Our Telegram Member Add service lets you add members to Telegram group or channel from real, active communities — not bots or fakes.   With this Telegram group growth service, you’ll see results within hours, backed by clear reporting and safe automation.   ✅ What We Offer   • Done-for-you Telegram Member Add campaigns (Groups · Channels) • Targeted Telegram members from real, active users • Fast growth — up to 10K members in 24 hours • English-speaking or regional audiences (US · UK · EU) • Fully managed Telegram channel growth service with reports & analytics   💡 Why Choose Us   We don’t use spam or fake accounts. Our process safely adds members to your Telegram group or channel through verified multi-account setups, proxy rotation, and opt-out compliance. This ensures lasting growth and minimizes churn. Every campaign is managed by experts using tested Telegram infrastructure and growth systems. We also recommend combining Member Add with Telegram Mass DM for better engagement and retention after join.   🧩 Works Best For   • Businesses or communities launching new Telegram channels • Crypto, SaaS, and marketing projects needing visibility • Influencers and agencies growing multiple Telegram groups • Anyone seeking a reliable Telegram group growth service with real members 📩 To Get More Information   Telegram : @TeleLoopPulse   Website : https://telegramgrowthstudio.com/telegram-member-add.html
    • RMTgold
      Buying & Selling GW2 Gold / Items

      By RMTgold · Posted

      PAYPAL& BINANCE
    • sandeagle
      Guytis Interlude Extender v201 codes

      By sandeagle · Posted

      well,its SharedCreatureData.h problem.   /* 0398 */ //WCHAR m_sResurrectSpellerName[25];   this variable will cause L2server.exe crash...  
    • kreis
      L2insolence Custom H5 server

      By kreis · Posted

      Custom High Five server L2insolence will open 2025-10-17 21:00 GMT+2 ! ! ! Web site: http://www.l2insolence.eu All info updates on Discord: https://discord.gg/duMjnj3y9A Last wipe was more then 1 year ago. We have custom skill, farm zones, materials for items to buy. Custom wepons, armor, jewels and more. All items in game have own stats. With custom looks. Glowing etc. Rates XP, SP: 25x Spoil and Drop: 10x Adena: 20x Server Hard Farm Enchantment Safe enchant Weapon: +20099 Safe enchant Armor: +20099 Max enchant Weapon: +20099 Max enchant Armor: +20099 Normal scrolls: 100% Blessed scrolls: 100% You can use scrolls or item enchant NPC to make +++ abd life beter. NPC Buffer There's an NPC buffer in all of our main towns: Aden, Giran and Goddard. It supplies Prophet Buffs, Songs and Dances for a small fee. Include all buff. We have custom self buffs learned with npc with custom stats. Global Gatekeeper GM Shop with normal items and custom ones, vote NPC, Event NPC, item upgrader NPC. Raid Bosses, every zone have its own boss and drops for rare mats. Olympiad The olympiad is ongoing every two weeks. Meaning if you become a hero you will have your hero status for two weeks. And hero have own custom stats on items.
    • RMTgold
      Buying & Selling WOW Gold

      By RMTgold · Posted

      PAYPAL& BINANCE

  • Topics

×
×
  • 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