leeleatherwood

ohh, nice. Too easy! Thanks.

How can i define activeChar in L2J or use an alternate method?

There is no definition for activeChar, atleast not in L2JServer.

Nice, thanks. Im sure one of those 2 methods will work. I am using Hi5 so I will try the broadcast first. EDIT: The broadcast method works great on Hi5.

I have an event that I need to play a sound to everyone on the server when the event happens. Currently I am using this command: PlaySound soundcase30 = new PlaySound(1, "30", 0, 0, 0, 0, 0); but that only plays the sound to the person doing the action, I need to play the sound to everyone on the server. What command do i use? Thanks! EDIT: Forgot to mention this is in L2PcInstance.java if that matters.

He forgot to mention in his guide you need to change the NPC ID. The NPC_ID is the first number after VALUES, in your case its 1, change it to any number that is not already in use, for instance 77701. Then you will be working.

I switched to MySQL Server and uninstalled XAMPP, it did not help. yeah i did not write any of that stuff, I downloaded it from these forums. Anyways, I am fixing what i can and using it. Thanks for the reply.

Hey guys, new here. Browsed around a bit, very nice forum. Anyways, I am having trouble with my L2J server, I am trying to install a Gatekeeper, Buffer and GM Shop but every single time i try to execute a SQL file I get an error message. Server is latest L2J Nightly (Gracia Epilogue) with latest datapack. I running XAMMP for MySQL, Apache and PHPMyAdmin. I have tried using Navicat and PHPMyAdmin to execute SQL files and neither of them work. Anyways, for instance, this will not work: INSERT INTO `custom_npc` (`id`,`idTemplate`,`name`,`serverSideName`,`title`,`serverSideTitle`,`class`,`collision_radius`,`collision_height`,`level`,`sex`,`type`,`attackrange`,`hp`,`mp`,`hpreg`,`mpreg`,`str`,`con`,`dex`,`int`,`wit`,`men`,`exp`,`sp`,`patk`,`pdef`,`matk`,`mdef`,`atkspd`,`aggro`,`matkspd`,`rhand`,`lhand`,`armor`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`,`ss`,`bss`,`ss_rate`,`AI`) VALUES ('50023','30080','GK','1','Gatekeeper','1','LineageNPC.a_teleporter_FHuman','8','25',','70','female','L2Teleporter','40','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0','0','1','0','1','1','1','0','LAST_HIT','false' this is the error message i get: [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '70','female','L2Teleporter','40','1','1','1','1','1','1','1','1','1','1','1','1'' at line 2 [Err] INSERT INTO `custom_npc` (`id`,`idTemplate`,`name`,`serverSideName`,`title`,`serverSideTitle`,`class`,`collision_radius`,`collision_height`,`level`,`sex`,`type`,`attackrange`,`hp`,`mp`,`hpreg`,`mpreg`,`str`,`con`,`dex`,`int`,`wit`,`men`,`exp`,`sp`,`patk`,`pdef`,`matk`,`mdef`,`atkspd`,`aggro`,`matkspd`,`rhand`,`lhand`,`armor`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`,`ss`,`bss`,`ss_rate`,`AI`) VALUES ('50023','30080','GK','1','Gatekeeper','1','LineageNPC.a_teleporter_FHuman','8','25',','70','female','L2Teleporter','40','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0','0','1','0','1','1','1','0','LAST_HIT','false' [Msg] Finished - Unsuccessfully -------------------------------------------------- It is doing this with every SQL file i try. This is really pissing me off, all of the NPC's i am trying are said to be working or designed for Epilogue so i dont get what the problem is. I am starting to think XAMPP sucks and maybe i should go with standalone MySQL server. Any help is appreciated, thanks!