-
ahhh alright! than i try to find something like that :) Ty!
-
Sorry to bother, but could one of you ladies or some1 else explain me why i can´t add this SQL for npc buffer at navicat? http://www.maxcheaters.com/topic/150892-interlude-buffer-l2frozen/?hl=%2Binterlude+%2Bbuffer -> always gives me this error: [Err] 1146 - Table 'acis.npc' doesn't exist [Err] INSERT INTO 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`) VALUES (9999, 31855, 'Galatea', 1, "[-> Buffer <-]", 1, 'NPC.a_traderA_MHuman', 08.00, 24.00, 70, 'Male', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 333, 0, 0, 0, 55, 132, NULL, 0, 1, 0, 'LAST_HIT'); [Msg] Finished - Unsuccessfully
-
I didint mind how long it takes, i am glad there was Vid + explanation. Finally managed to get out the Errors =) ! thx to you as well!
-
thanks so much! you´re my heroine ^_^
-
Nice, thanks alot. Downloaded it and trying to get something to run, but on all the tutorials it looks kinda diffrent. You happen to know a tutorial for this clean pack? Would mean alot to me. thanks for all the effort
-
i would love to use a clean one, but all links are down and i didnt find one.....
-
Yo Guyz, its been quiet some time since i was here or at L2 at all. So i wanted to create a little Server for myself and friends (Just playing Lan and stuff) cause privat servers nowdays kinda suck. I played this game for about 12 years but never tryed to create a server at all, so i ll admit i am kind of a total noob in this. Anyway. I followed tons of diffrent guides since 99% of the Links postet in them are broken due their age but ended up succeding. The Main Problem now is that i cant get past the Character Selection Screen, i can create one but as soon i want to log-in - nothing happens. Game Server Console gives me this error: Client was not online --> New Client Connection Could not restore char data: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastV oteHopzone' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2119) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 2281) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr oxyPreparedStatement.java:76) at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.restore(L2 PcInstance.java:10243) at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.load(L2PcI nstance.java:1728) at com.l2jfrozen.gameserver.network.L2GameClient.loadCharFromDisk(L2Game Client.java:575) at com.l2jfrozen.gameserver.network.clientpackets.CharacterSelected.runI mpl(CharacterSelected.java:67) at com.l2jfrozen.gameserver.network.clientpackets.L2GameClientPacket.run (L2GameClientPacket.java:75) at com.l2jfrozen.gameserver.network.L2GameClient.run(L2GameClient.java:1 196) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) DEBUG [C] 0D CharacterSelected: Character could not be loaded (slot:0) Could not restore char data: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastV oteHopzone' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.Util.getInstance(Util.java:382) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2119) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 2281) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr oxyPreparedStatement.java:76) at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.restore(L2 PcInstance.java:10243) at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.load(L2PcI nstance.java:1728) at com.l2jfrozen.gameserver.network.L2GameClient.loadCharFromDisk(L2Game Client.java:575) at com.l2jfrozen.gameserver.network.clientpackets.CharacterSelected.runI mpl(CharacterSelected.java:67) at com.l2jfrozen.gameserver.network.clientpackets.L2GameClientPacket.run (L2GameClientPacket.java:75) at com.l2jfrozen.gameserver.network.L2GameClient.run(L2GameClient.java:1 196) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) DEBUG [C] 0D CharacterSelected: Character could not be loaded (slot:0) As i already mentioned - i dont understand to much of this yet. Seems to me that there is something fuked up on my Java? For recreation - this was used: -http://dev.mysql.com/downloads/mysql/ (MYSQL 5.5) -http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html (java SE development Kit 8u101 - windows 64x ) -Navicat Premium Essentials Followed this guides (mainly): https://l2topzone.com/forum/l2-guides/6/guidehow-to-setup-your-own-l2server-plus-images/44/ https://www.youtube.com/watch?v=5e8qceHjrnA If any1 knows where i fuked up, i would realy appreciate some help (SkypeID: Mercy4darkness90) Ty :)
