L2J L2j Preconfigured by moxos12 interlude

[DaRkAnGeL]

i made it ... buy if i log on the admin account (i set access_level to 100) i cant use any gm command.... it doesn't react ..

you need to add 100 to accesslevel in character sqls

 

[tommzy2]

i dont know which ini to edit (to make the ip 127.0.0.1)

 

[Donus]

wow !!

 

[ciroxx]

Hello, i am really a newbye

I have the GameServer and the LoginServer started and listening, what i need to do to login in the server? (I mean play)

I'm not sure I have to do now, I guess I have to download a interlude's client, install it, and replace with the files that are in the pack. If someone can confirm if that's what I have to do thanks

Sorry bad english :S

 

[DelEnter]

how fix skills bug add me msn del_enter@live.com or skype morgan_hacker

 

[Exoster]

errors!

LoginServer:

Starting Line][Age Moxos12 Login Server.

INFO : loading login config
INFO : MLog clients using log4j logging.
INFO : Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; tra
ce: 10]
INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ jav
a.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [las
tAcquisitionFailureDefaultUser] ]
WARN : SQL Error: 1045, SQLState: 28000
ERROR : Access denied for user 'root'@'localhost' (using password: YES)
WARN : Could not obtain connection metadata java.sql.SQLException: Access denied
for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1292)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession
Factory(LocalSessionFactoryBean.java:804)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:744)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:131)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:429)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:250)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:141)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:247)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:161)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:270)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:346)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:92)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:77)
at net.sf.l2j.tools.L2Registry.loadRegistry(L2Registry.java:65)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:104)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

INFO : Loaded 127 server names
INFO : LoginManager initiating
INFO : Cached 10 KeyPairs for RSA communication
INFO : Stored 20 keys for Blowfish communication
WARN : SQL Error: 1045, SQLState: 28000
ERROR : Access denied for user 'root'@'localhost' (using password: YES)
WARN : SQL Error: 1045, SQLState: 28000
ERROR : Access denied for user 'root'@'localhost' (using password: YES)
Exception in thread "main" org.springframework.transaction.CannotCreateTransacti
onException: Could not open Hibernate Session for transaction; nested exception
is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:424)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:349)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:255)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversServices$$EnhancerByCGLIB$
$831c4d79.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.load(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.<init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.getInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi
ng password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:421)
... 16 more

Server terminated abnormaly


server terminated

Drücken Sie eine beliebige Taste . . .

Gameserver:

Starting Line][Age Moxos12 Login Server.

INFO : loading login config
INFO : MLog clients using log4j logging.
INFO : Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; tra
ce: 10]
INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ jav
a.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [las
tAcquisitionFailureDefaultUser] ]
WARN : SQL Error: 1045, SQLState: 28000
ERROR : Access denied for user 'root'@'localhost' (using password: YES)
WARN : Could not obtain connection metadata java.sql.SQLException: Access denied
for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1292)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession
Factory(LocalSessionFactoryBean.java:804)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:744)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:131)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:429)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:250)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:141)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:247)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:161)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:270)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:346)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:92)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:77)
at net.sf.l2j.tools.L2Registry.loadRegistry(L2Registry.java:65)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:104)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)

INFO : Loaded 127 server names
INFO : LoginManager initiating
INFO : Cached 10 KeyPairs for RSA communication
INFO : Stored 20 keys for Blowfish communication
WARN : SQL Error: 1045, SQLState: 28000
ERROR : Access denied for user 'root'@'localhost' (using password: YES)
WARN : SQL Error: 1045, SQLState: 28000
ERROR : Access denied for user 'root'@'localhost' (using password: YES)
Exception in thread "main" org.springframework.transaction.CannotCreateTransacti
onException: Could not open Hibernate Session for transaction; nested exception
is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:424)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:497)
at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:349)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:255)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:616)
at net.sf.l2j.loginserver.services.GameserversServices$$EnhancerByCGLIB$
$831c4d79.getAllGameservers(<generated>)
at net.sf.l2j.loginserver.manager.GameServerManager.load(GameServerManag
er.java:208)
at net.sf.l2j.loginserver.manager.GameServerManager.<init>(GameServerMan
ager.java:111)
at net.sf.l2j.loginserver.manager.GameServerManager.getInstance(GameServ
erManager.java:82)
at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:113)
at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:77)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi
ng password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:421)
... 16 more

Server terminated abnormaly


server terminated

Drücken Sie eine beliebige Taste . . .

Please help me with that

 

[DaRkAnGeL]

Exoster : Access denied for user 'root'@'localhost' (using password: YES) check your configs

 

[StreetNet]

need add gm in the server ?? What need and add items? Have Editor?

 

[DaRkAnGeL]

need add gm in the server ?? What need and add items? Have Editor?

go the characters.sql and change your accesslvl to 100

 

[StreetNet]

thanks.. and need add npc ?? guide?

what its the map to gm npc?

 

[DaRkAnGeL]

thanks.. and need add npc ?? guide?

what its the map to gm npc?

npc.sql

 

[StreetNet]

Wow -.- GUIDE?

 

[hemsick600]

Can I have the guide for this ? please anybody add me to make this work

You must be registered to see links

 

[PrinceNikos]

I have 2 problems with this pack 1st with moxos12 skill trees the installation stops at skill trees... its at this point for about 20 mins now and with the other skill trees someone posted some pages before i cant learn skills... it says that skill doesnt exist at any skill i tried to add... also i noone else can join my server through my external ip... i change some point at config files like i previous have done but nothing... if anyone knows more about this 2 topics and can help me i would be gratefull...

Thanks in Advance....

 

[xal3r]

Moxos12 thanks for your very good server but is there anyway that you can edit your custom npc becouse i dont want blessed enhants in that npc so maybe you can help me solve this problem :]

ok i solved this problem by editing html in merhants folder but then i got second problem now i would like to edit that shop prices and item wich is used to buy item for example now if i want to buy dynasty armor i need to have 50kk adena and 10k acient adena i would like to change it to other item. anyone can help me to do that?

Problem solved just now i see an error in my gameserver.exe somthing with skills probably some skills might not be working

Good server, however I still cannot figure out how to adjust Raid Boss Drop Rates. There is a modifier for a RateDropItems, but it affects every monster, so it's pretty much out of the question, because setting it to 10 means Antharas and other Dungeon Bosses would drop 10 Earrings, and in the droplist there doesn't seem to be the chances for raid boss drops. Or did I miss something, maybe the droplist and chances for raidbosses are in some other table?

EDIT: Ok, i found a way to do it

man were did you found it ? i cant find it :]

Is this forum dead? coz i get no respone to my questions

 

[DaRkAnGeL]

man were did you found it ? i cant find it :]

Is this forum dead? coz i get no respone to my questions

what questions? you do not ask something as you do not show your errors

 

[xal3r]

what questions? you do not ask something as you do not show your errors

Sorry for my bad posts i got big problem now. Today i shut down my pc not properly and my all database crashed. When im starting my server many of sql tables are missing. So i deleted everything from l2jdb and instaled sql files one by one using program navicat. But the problem is that when i start the server again i cant spawn custom shop buffer and other custom npc like before i did. I tried to downloaud again compiled files by moxos12 extract them and try to louch server but things went the same.I dont get it first time when i downlouded thouse files there was nothing to config to play and there was account allready maded but now when im extracting and lounching it there is many erors whats the problem could be?

i think i got the same problem just dont know now hot to fix it :

maybe he had already a sql running and pressed start.bat the the database won't be installed and the phpmyadmin will just be like navicat in the old database.so if you have any mysql running stop it!​

 

[DaRkAnGeL]

Sorry for my bad posts i got big problem now. Today i shut down my pc not properly and my all database crashed. When im starting my server many of sql tables are missing. So i deleted everything from l2jdb and instaled sql files one by one using program navicat. But the problem is that when i start the server again i cant spawn custom shop buffer and other custom npc like before i did. I tried to downloaud again compiled files by moxos12 extract them and try to louch server but things went the same.I dont get it first time when i downlouded thouse files there was nothing to config to play and there was account allready maded but now when im extracting and lounching it there is many erors whats the problem could be?

i think i got the same problem just dont know now hot to fix it :

maybe he had already a sql running and pressed start.bat the the database won't be installed and the phpmyadmin will just be like navicat in the old database.so if you have any mysql running stop it!​

if navicat connects to your database you should check your npc.sql. if you cannot spawn them then they do not exist in your database. create a new database with name l2jdb1 and import all moxos database. then go to your configs and change the database name to l2jdb1

 

[xal3r]

if navicat connects to your database you should check your npc.sql. if you cannot spawn them then they do not exist in your database. create a new database with name l2jdb1 and import all moxos database. then go to your configs and change the database name to l2jdb1

tnx i will try and then i will write comments tnaks a lot

 

[xal3r]

Ok everything now wokrs fine just a few problems till my best shape of server so i will try to explain my next problems
1st problem i would like to change login name to my own as it shown in picture. How to do it? i tried to change it with registergame.exe i choosed number 60 for example but when i starting gameserver.exe its saying wrong hexid.
2second problem is i cant find gold bar in etcitems and change from quest item to normal item that i could have it in inventory not in the quest inventory and i wana make them sellable ant tradable.I know how to do it just like i said i cant find it in etcitems.

Pictures of my problems :

You must be registered to see links