[Guide] Item mall

[wayzer]

Re: [GUIDE] Item mall

Can I add in the Item Mall armors of astral ?

 

[Maxcom]

Re: [GUIDE] Item mall

yes you can

 

[wayzer]

Re: [GUIDE] Item mall

So armor to be in the Shop, me need copy file *.xdb of the arrmor in the derrictory of the shop ?

 

[Kreeate]

Re: [GUIDE] Item mall

Here is the Item Mall SQL again : View attachment allods_online_billing_trunk_rc2.rar

Specially for wayzer :

 

[wayzer]

Re: [GUIDE] Item mall

Here is the Item Mall SQL again : View attachment 97657

Specially for wayzer :

I thankful roud:

 

[Kreeate]

I thankful roud:

You are very welcome!

 

[wayzer]

Re: [GUIDE] Item mall

deleted

php scripts for fast add item in the item mall, here

 

[kyle788]

Re: [GUIDE] Item mall

There is an error in the SQL script that makes you unable to access the 'Teleporters' section in the item mall.

To fix this problem, change:
INSERT INTO `item` VALUES ('64', '108144692', '1', '12', '1', '2');
INSERT INTO `item` VALUES ('65', '8144670', '1', '12', '1', '3');
to:
INSERT INTO `item` VALUES ('64', '108144692', '1', '12', '1', '1');
INSERT INTO `item` VALUES ('65', '108144670', '1', '12', '1', '2');

Or if you already have used the script update the database manually through an editor.

 

[someonewhy]

Re: [GUIDE] Item mall

works pretty good

 

[sananebak]

Re: [GUIDE] Item mall

Billing Server

[01-19 15:48:13,308, 211] main - INFO launch.main.LauncherMain : loading config from ../cfg/shard.xml[01-19 15:48:14,345, 1248] main - INFO launch.main.LauncherMain : loading from cfg "../cfg/shard.xml", server "billingServer", deploy = 127.0.0.1
[01-19 15:48:14,346, 1249] main - INFO launch.main.LauncherMain : Server type is "billingServer"
[01-19 15:48:14,391, 1294] main - INFO tools.reflection.ClassesLoader : loading classess from [server\bin, \jars\, \jars_local\]...
[01-19 15:48:28,260, 15163] main - INFO tools.reflection.ClassesLoader : 16715 classes loaded in 13.867 seconds
[01-19 15:48:31,492, 18395] Thread-3 - INFO logging.channels.BackgroundChannelWriter : Background channel logger started
[01-19 15:48:31,564, 18467] main - INFO DatabaseService : Database "jdbc:mysql://127.0.0.1/allods_online_billing_trunk_rc2?useUnicode=yes&characterEncoding=UTF-8&rewriteBatchedStatements=false&allowMultiQueries=false&connectTimeout=500000&socketTimeout=500000" is used.
[01-19 15:48:31,971, 18874] main - ERROR verify : unable to start server
system.base.LaunchException: org.apache.commons.configuration.ConfigurationException: dbcommons.exception.DBContextCreationException: dbcommons.jdbc.exception.SchemeCreationException: dbcommons.jdbc.dao.exception.ReadingFailedException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'allods_online_billing_trunk_rc2.params' doesn't exist
at billingserver.BillingServerStarter.startSync(BillingServerStarter.java:32)
at launch.CommonStarterImpl.start(CommonStarterImpl.java:36)
at launch.main.LauncherMain.run(LauncherMain.java:75)
at launch.main.LauncherMain.launch(LauncherMain.java:108)
at billingserver.BillingServerMain.main(BillingServerMain.java:16)
Caused by: org.apache.commons.configuration.ConfigurationException: dbcommons.exception.DBContextCreationException: dbcommons.jdbc.exception.SchemeCreationException: dbcommons.jdbc.dao.exception.ReadingFailedException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'allods_online_billing_trunk_rc2.params' doesn't exist
at billingserver.BillingServer.createDBContext(BillingServer.java:84)
at billingserver.BillingServer.<init>(BillingServer.java:90)
at billingserver.BillingServerStarter.startSync(BillingServerStarter.java:26)
... 4 more
Caused by: dbcommons.exception.DBContextCreationException: dbcommons.jdbc.exception.SchemeCreationException: dbcommons.jdbc.dao.exception.ReadingFailedException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'allods_online_billing_trunk_rc2.params' doesn't exist
at billingserver.billingdb.jdbcimpl.BillingDBContextFactoryJDBCImpl.createContext(BillingDBContextFactoryJDBCImpl.java:46)
at billingserver.BillingServer.createDBContext(BillingServer.java:80)
... 6 more
Caused by: dbcommons.jdbc.exception.SchemeCreationException: dbcommons.jdbc.dao.exception.ReadingFailedException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'allods_online_billing_trunk_rc2.params' doesn't exist
at dbcommons.jdbc.JDBCContext.initScheme(JDBCContext.java:90)
at dbcommons.jdbc.JDBCContext.<init>(JDBCContext.java:110)
at billingserver.billingdb.jdbcimpl.BillingDBContextJDBCImpl.<init>(BillingDBContextJDBCImpl.java:24)
at billingserver.billingdb.jdbcimpl.BillingDBContextFactoryJDBCImpl.createContext(BillingDBContextFactoryJDBCImpl.java:42)
... 7 more
Caused by: dbcommons.jdbc.dao.exception.ReadingFailedException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'allods_online_billing_trunk_rc2.params' doesn't exist
at dbcommons.jdbc.dao.sqlexecutor.SQLExecutor.executeReadQuery(SQLExecutor.java:256)
at dbcommons.jdbc.schemecreator.propertyfileimpl.SchemeCreatorPropertyFileImpl.readProperties(SchemeCreatorPropertyFileImpl.java:162)
at dbcommons.jdbc.schemecreator.propertyfileimpl.SchemeCreatorPropertyFileImpl.checkVersion(SchemeCreatorPropertyFileImpl.java:149)
at dbcommons.jdbc.JDBCContext.initScheme(JDBCContext.java:76)
... 10 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'allods_online_billing_trunk_rc2.params' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at dbcommons.jdbc.dao.sqlexecutor.SQLExecutor.readResult(SQLExecutor.java:576)
at dbcommons.jdbc.dao.sqlexecutor.SQLExecutor.executeReadQuery(SQLExecutor.java:251)
... 13 more

ItemMall Server

[01-19 15:43:51,480, 359] main - INFO launch.main.LauncherMain : loading config from ../cfg/shard.xml[01-19 15:43:52,544, 1423] main - INFO launch.main.LauncherMain : loading from cfg "../cfg/shard.xml", server "itemMallServer", deploy = 127.0.0.1
[01-19 15:43:52,546, 1425] main - INFO launch.main.LauncherMain : Server type is "itemMallServer"
[01-19 15:43:52,593, 1472] main - INFO tools.reflection.ClassesLoader : loading classess from [server\bin, \jars\, \jars_local\]...
[01-19 15:44:06,923, 15802] main - INFO tools.reflection.ClassesLoader : 16829 classes loaded in 14.298 seconds
[01-19 15:44:11,163, 20042] Thread-3 - INFO logging.channels.BackgroundChannelWriter : Background channel logger started
[01-19 15:44:24,420, 33299] main - INFO billingserver.connector.BillingServerConnectorImpl : Can't connect to billing server: 127.0.0.1/9320
[01-19 15:44:24,422, 33301] Thread-4 - INFO billingserver.connector.BillingServerConnectorImpl : Start reconnecting to billing server.
[01-19 15:44:25,378, 34257] main - INFO itemmall.server.AssortmentCache : Banners in cache: 0
[01-19 15:44:25,378, 34257] main - INFO itemmall.server.AssortmentCache : Assortment cache refresh seconds: 3600
[01-19 15:44:25,408, 34287] main - INFO itemmall.netimpl.ItemMallServiceNetImpl : Net version: 11
[01-19 15:44:25,409, 34288] main - INFO itemmall.netimpl.ItemMallServiceNetImpl : Service started at 127.0.0.1/9321
[01-19 15:44:29,211, 38090] net_worker_0 - INFO itemmall.netimpl.ItemMallServiceNetImpl : Client 1 connected: 127.0.0.1.
[01-19 15:44:29,214, 38093] net_worker_0 - INFO itemmall.netimpl.ItemMallServiceNetImpl : Client 1 is trunk_local

 

[sananebak]

Re: [GUIDE] Item mall

i do not understand Help me pls

 

[witcherivan]

Re: [GUIDE] Item mall

i do not understand Help me pls

Look here: Guides Itemmall eng & ru I helped with the solution of the problem.
arhive XDB_Itemmall

 

[Dragganta]

Re: [GUIDE] Item mall

where this item mall.. seemed it was in /game folder and also in mysql.. so wich one fist i have change and do it upload self by start server..?

by the way i got my all server work game and shop.. but also want understand way of thinking.. llol
maybe someone explain all this folder was in server files.. but this was other thread then

 

[Jinjer LC]

Re: [GUIDE] Item mall

Look here: Guides Itemmall eng & ru I helped with the solution of the problem.
arhive XDB_Itemmall

can you re upload the files

 

[witcherivan]

Re: [GUIDE] Item mall

can you re upload the files

держи
======
keep

attached

p.s. - although the old links still work