Jump to content

mercy4darkness

Members
  • Posts

    7
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

About mercy4darkness

Contact Methods

  • Skype
    mercy4darkness90

Profile Information

  • Current Mood
    Hungry
  • Gender
    Male
  • Country
    Germany
  • Interests
    Gaming, Boxing, Bodybuilding

mercy4darkness's Achievements

Newbie

Newbie (1/16)

0

Reputation

  1. 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
  2. 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!
  3. 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
  4. i would love to use a clean one, but all links are down and i didnt find one.....
  5. 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 :)
×
×
  • Create New...