Jump to content
MaxCheaters Official Group at Discord
ad: Discord - Global Boosts - 14 server boosts (3 months) for 14$ - 14 server boosts for (1 Month) 6$
L2Aqua.net - LIVE 06/10, BETA 29/09 - The Best Upcoming PvP Server!
  • 0

[Help] Den mporw n vrw Buffer :/

strenght

Asked by strenght,

 Share

Question

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)

Link to comment
Share on other sites
  • 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.

Link to comment
Share on other sites
  • 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

Link to comment
Share on other sites
  • 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.

Link to comment
Share on other sites
  • 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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

×
 Share
Go to question listing


  • Posts

    • execas12
      Web developer/php coding

      By execas12 · Posted

      Hello,   I am looking for someone who understands about websites, knows coding etc.   I am dealing with situation where after i bought web hosting my website is loading really slowly or not loading at all at some points. I have tried dealing with the company who provides the web hosting but they could not find issue on their end so i am asking for help, someone who knows their thing about this.   Drop your discord details i will contact you.   Thank you
    • milozare
      ⭐ LIST OF FORUMS FOR YOUR NEEDS ⭐ [OVER 100 RUSSIAN FORUMS]

      By milozare · Posted

      Good afternoon I am selling a list of forums, which contains more than 100 lines of active and current RU forums.   - topics: dark, crypto, SMM, programming, services, cheats, etc.; - sorting from more popular to less popular (by traffic, by the number of new posts per day);   Are you looking for where to advertise your services? This base will definitely suit you! In addition, on the forums you can find a bunch of useful information, software, as well as advertisements about sales and services from other users.   Payment: 12 USTD   After payment you receive a text document with a list of forums (PS. all information is provided for informational purposes only); TELEGRAM - https://t.me/milozare
    • FossilGamer
      Lineage 2 will die if admins continue scamming the community

      By FossilGamer · Posted

      I strongly concur with some opinions shared. As I've previously mentioned on different posts, it's shocking to see how seasonal servers gather this much population. However, being back in the game some months I did start understanding how the current community of L2 plays and thinks.   It's a huge problem, but in my opinion the guilt is shared between server owners and community. To keep a long term project running (more than a year on) you need to have the equivalent community that will support the project, which unfortunately is not that big. The current player community of L2 hops on new servers with such a haste to get full and "dominate" which does indeed give a lot of activity for some weeks but after that it's just downfall, population gets reduced drastically day by day. The reason is, while the community is busy "grinding" to win on their current server, a "new" server is being advertised which most likely is from the same owner. As I've mentioned, the guilt is shared since the server-owners focus on bringing up "new" servers for the cash grab but also since the community doesn't have the patience to support a long-term project. Besides, let's not forget about clans/CPs being invited directly to the server with some benefits. I'll give an example. An admin opens a server, invites 3 groups (either CPs or clans) by promising them some small benefits. Those three groups will invite more players and so on. It's like an investment, they spent 5$ to earn 20$. Therefore, most admins willing to play "fair" do not succeed, except for a few. Most of us "old-timers" play for nostalgia trips and are fine with low populated servers but lets take a step back and think about the owners that really want to provide a good server, no income will slowly dry out the server and eventually die.   Don't get me wrong, there are some great servers out there, but not everything is for everyone. I'll finish by quoting someone I saw few days ago on YouTube, he said something along the lines that we shouldn't expect fair play while we play an "illegal" version of the game.
    • Bru7aLMike
      Bypass Voiced Command

      By Bru7aLMike · Posted

      You have to create the "voiced" handler in the core too, or at the very least make sure that the delimiter is underscore and not an empty space. Alternatively, you can try changing all references of the strings below to start with "voiced_", or remove the "voiced_" portion from the button bypass.   private static final String[] VOICED_COMMANDS = { "siege", "siege_gludio", "siege_dion", "siege_giran", "siege_oren", "siege_aden", "siege_innadril", "siege_goddard", "siege_rune", "siege_schuttgart" };
    • Orochy
      Bypass Voiced Command

      By Orochy · Posted

      Hi maxcheaters, I recently added some code to my l2jacis revision and everything works fine with the .siege commands but when I click on the html options to open the registry I don't succeed!   registerHandler(new Castles());   package net.sf.l2j.gameserver.handler.voicedcommandhandlers;   import net.sf.l2j.Config; import net.sf.l2j.gameserver.handler.IVoicedCommandHandler; import net.sf.l2j.gameserver.data.manager.CastleManager; import net.sf.l2j.gameserver.model.actor.Player; import net.sf.l2j.gameserver.model.entity.Castle; import net.sf.l2j.gameserver.network.SystemMessageId; import net.sf.l2j.gameserver.network.serverpackets.NpcHtmlMessage; import net.sf.l2j.gameserver.network.serverpackets.SiegeInfo;   public class Castles implements IVoicedCommandHandler { private static final String[] VOICED_COMMANDS = { "siege", "siege_gludio", "siege_dion", "siege_giran", "siege_oren", "siege_aden", "siege_innadril", "siege_goddard", "siege_rune", "siege_schuttgart" };   @Override public boolean useVoicedCommand(String command, Player player, String target) { if (command.equals("siege") && Config.ENABLE_MENU) showHtm(player); else if (command.startsWith("siege_")) { if (player.getClan() != null && !player.isClanLeader()) { player.sendPacket(SystemMessageId.YOU_ARE_NOT_AUTHORIZED_TO_DO_THAT); return false; }   int castleId = 0; if (command.startsWith("siege_gludio") && Config.SIEGE_GLUDIO) castleId = 1; else if (command.startsWith("siege_dion") && Config.SIEGE_DION) castleId = 2; else if (command.startsWith("siege_giran") && Config.SIEGE_GIRAN) castleId = 3; else if (command.startsWith("siege_oren") && Config.SIEGE_OREN) castleId = 4; else if (command.startsWith("siege_aden") && Config.SIEGE_ADEN) castleId = 5; else if (command.startsWith("siege_innadril") && Config.SIEGE_INNADRIL) castleId = 6; else if (command.startsWith("siege_goddard") && Config.SIEGE_GODDARD) castleId = 7; else if (command.startsWith("siege_rune") && Config.SIEGE_RUNE) castleId = 8; else if (command.startsWith("siege_schuttgart") && Config.SIEGE_SCHUT) castleId = 9; else player.sendMessage("This Castle has been disabled");   Castle castle = CastleManager.getInstance().getCastleById(castleId); if ((castle != null) && (castleId != 0)) player.sendPacket(new SiegeInfo(castle)); } return true; }   private static void showHtm(Player player) { NpcHtmlMessage htm = new NpcHtmlMessage(0); htm.setFile(player.isLang() + "mods/menu/CastleManager.htm"); player.sendPacket(htm); }   @Override public String[] getVoicedCommandList() { return VOICED_COMMANDS; } }     <button value="Giran" action="bypass voiced_siege_giran" width=75 height=22 back="L2UI_ch3.Btn1_normalOn" fore="L2UI_ch3.Btn1_normal">

  • Topics

×
×
  • Create New...