Source L2-Scripts Owned By Mardok

[yeiij]

 

Help please with error ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot 

 

All files are properly poured, at character creation, this error.

 

import /authserver/sql/install/*.sql   to  db newcore

[shark13]

still waiting for the highfive :P

[Cray-Z]

Why do u thing u will get the files for free ? High Five too.
Also no sources = useless

[SpirakosDafuq™]

Why do u thing u will get the files for free ? High Five too.

Also no sources = useless

true that..

[kassane]

I would really like to have the valiance version! :-[

[hanzo]

 

I have Error :/

 

Starting GameServer.

 

[19:26:01]  INFO =================================================

[19:26:01]  INFO Project Revision: ........ L2s [8508]

[19:26:01]  INFO Build Revision: .......... 'F:\tools' doesn't exist

[19:26:01]  INFO Update: .................. Chapter 3: Lindvior

[19:26:01]  INFO Build date: .............. 2013.10.02 23:27

[19:26:01]  INFO Compiler version: ........ 23.21-b01 (Oracle Corporation)

[19:26:01]  INFO =================================================

Exception in thread "main" java.lang.NoClassDefFoundError: l2s/gameserver/utils/

Clients

        at l2s.gameserver.GameServer.<init>(GameServer.java:158)

        at l2s.gameserver.GameServer.main(GameServer.java:399)

Caused by: java.lang.ClassNotFoundException: l2s.gameserver.utils.Clients

        at java.net.URLClassLoader$1.run(Unknown Source)

        at java.net.URLClassLoader$1.run(Unknown Source)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.net.URLClassLoader.findClass(Unknown Source)

        at java.lang.ClassLoader.loadClass(Unknown Source)

        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

        at java.lang.ClassLoader.loadClass(Unknown Source)

        ... 2 more

 

Server terminated abnormaly ...

 

 

Server terminated ...

 

Press any key to continue . . .

 

 exact the same issue  .... 

 

Solved -=C/Paste the gameserver into libs=- Cheers

Edited July 23, 2014 by hanzo

[Nightw0lf]

Why do u thing u will get the files for free ? High Five too.

Also no sources = useless

 

true that..

its java you can make source :poker face: 

 

and about the error lol i didnt tryed and i wont because i am on interlude mostly but for newbies i have to say dont use packs that you dont know who coded them and what he coded inside.

packs like this are only for ripping porpuses :dat:

[remixed]

Nice job

[Epyhon]

Server works only in local when trying online gserver gives this err

 

 

[10.10.14 23:04:04:188] ERROR dao.CharacterDAO:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot be null
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at l2s.gameserver.dao.CharacterDAO.insert(CharacterDAO.java:79)
at l2s.gameserver.model.Player.create(Player.java:4820)
at l2s.gameserver.network.l2.c2s.CharacterCreate.runImpl(CharacterCreate.java:64)
at l2s.gameserver.network.l2.c2s.L2GameClientPacket.run(L2GameClientPacket.java:49)
at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:39)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

 

[TheMark147]

that's works fine but i dont know how to set access level because i try add to character acc lvl 100,1000,1 and this acc lvls dont works u know how this works? or u knows this values for admin privileges?

[Eurytus]

that's works fine but i dont know how to set access level because i try add to character acc lvl 100,1000,1 and this acc lvls dont works u know how this works? or u knows this values for admin privileges?

can you share the newcore db please becouse im stuck at char creation problem after inporting  , ,,,

[Eurytus]

import /authserver/sql/install/*.sql   to  db newcore

Same error here

[Stereotype]

 

Help please with error ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot 

 

 

Same error. And i added login sqls also from Install and such...

[mircowwwa]

"ERROR com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'account_name' cannot be null"

Go to database and with PHPMyAdmin or Navicat or other software that you are using(i use PHPMyAdmin) and search 'characters' table...open table structure and where there is 'account_name' field modify it with NOT NULL; after it should work :P

Edited November 25, 2014 by mircowwwa

[mircowwwa]

xception in thread "main" java.lang.NoClassDefFoundError: l2s/gameserver/utils/
Clients
        at l2s.gameserver.GameServer.<init>(GameServer.java:158)
        at l2s.gameserver.GameServer.main(GameServer.java:399)
Caused by: java.lang.ClassNotFoundException: l2s.gameserver.utils.Clients
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        ... 2 more

This is a class modify error,class has been editated with notepad XD,L2Script use this class,Clients.java,for save Server "License" IP,so with this control one IP per Pack,you need to extrat .class form jar modify only an existing ip string and re-put into jar...easy :D

this is from another shared L2Script-Hi5 Pack

package l2s.gameserver.utils;

import java.util.ArrayList;
import java.util.List;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class Clients
{
  private static final Logger _log = LoggerFactory.getLogger(Clients.class);
  private static List<String> _knownIps = new ArrayList();
  private static String client1 = "178.32.250.206";
  private static String client2 = "127.0.0.1";
  private static String client3 = "127.0.0.1";
  private static String client4 = "176.99.5.239";
  private static String client5 = "195.211.222.28";
  private static String client6 = "127.0.0.1";
  private static String client7 = "83.69.139.146";
  private static String client8 = "23.92.221.138";
  private static String client9 = "173.238.156.79";
  private static String client10 = "186.2.165.168";
  private static String client11 = "178.32.56.74";
  private static String client12 = "62.140.234.96";
  private static String client13 = "127.0.0.1";
  private static String client14 = "127.0.0.1";
  private static String client15 = "94.198.109.166";
  
  public static void Load()
  {
    _knownIps.add(client1);
    _knownIps.add(client2);
    _knownIps.add(client3);
    _knownIps.add(client4);
    _knownIps.add(client5);
    _knownIps.add(client6);
    _knownIps.add(client7);
    _knownIps.add(client8);
    _knownIps.add(client9);
    _knownIps.add(client10);
    _knownIps.add(client11);
    _knownIps.add(client12);
    _knownIps.add(client13);
    _knownIps.add(client14);
    _knownIps.add(client15);
  }
  
  public static List<String> getIps()
  {
    return _knownIps;
  }
}