Help Mysql Help

[criss22]

What MySql ( Version ) i need for l2jserver? (Higi Five)

['Baggos']

Download the latest version and will be ok.

Visit l2jserver's site and check how to make compile from git url.

[milosvamp]

Hello, here are the links of MySQL Setups that u can use:

 

 

 

MySQL 5.5 Setup --- >>   x64 bit   -------- >  http://elolift.com/l2j/mysql/mysql-5.5.15-win32.msi

 

MySQL 5.5 Setup --- >>   x32 bit   -------- >  http://elolift.com/l2j/mysql/mysql-5.5.15-winx64.msi

[criss22]

thx for all...(for compile l2jserver need money? :D i want a free version)

[criss22]

https://github.com/L2J/L2J_Server      doesn't work

[criss22]

i need a guide to how compile with git l2jserver...

[milosvamp]

First of all download Eclipse: https://www.eclipse.org/downloads/packages/eclipse-ide-java-developers/neon3

 

Then follow this guide:

 

 

1. Eclipse -> Window -> Show View -> Other

Image:   http://prnt.sc/c24qfk 

 

2. Choose Git -> Git Repositories 

Image:   http://prnt.sc/c24qxu 

 

3. At the Git Repositories view click on "Clone a Git Repository" 

Image:   http://prnt.sc/c24qps 

 

4. At the URI field put "https://bitbucket.or.../l2j_server.git" and click Next > 

Image:  http://prnt.sc/c24r8z 

 

5. Click "Deselect All", check "master" only and click Next > 

Image:  http://prnt.sc/c24rgm 

 

6. Select a folder for your project and click Finish 

Image:  http://prnt.sc/c24rnf 

 

7. When you clone the repository, click on the second icon from left to right the type hint says "Clone a Git Repository and add the clone to this view" 

Image:  http://prnt.sc/c24rtz 

 

8.  Repeat steps 4 "https://bitbucket.or...2j_datapack.git", 5 and 6 

Image:  http://prnt.sc/c24s1j 

 

9. After it's finished, right click somewhere in the Package Explorer view and choose "Import..." 

Image:  http://prnt.sc/c24s6j 

 

10. Choose Gradle -> Gradle Project

Image:  http://prnt.sc/c24sc3 

 

11. In the Project root directory choose the datapack project folder 

Image:  http://prnt.sc/c24sv9 

 

12. Wait for eclipse to finish importing the l2j_server and l2j_datapack projects 

Image:  http://prnt.sc/c24t1a 

 

13. At the bottom, a Gradle Tasks view will appear... l2j_datapack -> build -> right click on build -> Run Gradle Tasks 

Image:  http://prnt.sc/c24t7v

 

 

 

 

Server:        https://bitbucket.org/l2jserver/l2j_datapack

Datapack:   https://bitbucket.org/l2jserver/l2j_datapack

 

Credits to:  Solomun.

 

Or follow this guide:    http://www.l2jserver.com/forum/viewtopic.php?t=32261

 

 

Goodluck.

 

Edited July 21, 2017 by milosvamp

['Baggos']

thx for all...(for compile l2jserver need money? :D i want a free version)

As I said, download the latest mysql version. 

Visit the website of l2jserver --> Get Started --> The hard way. Follow the guide and you will success.

[criss22]

Thanks milosvamp !!!

[milosvamp]

You are welcome. :)

[criss22]

10) Choose Gradle -> Gradle Project i don't have this option

[milosvamp]

Right click on PACKAGE EXPLORER and then IMPORTand then GRADLE and then GRADLE PROJECT.

[milosvamp]

Otherwise go to Help -> Eclipse Marketplace -> Search -> Gradle Integration -> then download and install it -> restart Eclipse. 

You are done.

[criss22]

http://imgur.com/a/wYmhJ what error is that? i get when i try to start login

[criss22]

what folders i have to extract from compiled pack? (i mean from datapack and l2jserver

[criss22]

[22/07 22:01:15] GameServerTable: Error loading registered game servers!

java.sql.SQLSyntaxErrorException: Table 'l2jls.gameservers' doesn't exist

        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav

a:536)

        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav

a:513)

        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(

SQLExceptionsMapping.java:115)

        at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)

        at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936)

        at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)

 

        at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.jav

a:111)

        at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyS

tatement.java)

        at com.l2jserver.loginserver.GameServerTable.loadRegisteredGameServers(G

ameServerTable.java:118)

        at com.l2jserver.loginserver.GameServerTable.<init>(GameServerTable.java

:65)

        at com.l2jserver.loginserver.GameServerTable$SingletonHolder.<clinit>(Ga

meServerTable.java:684)

        at com.l2jserver.loginserver.GameServerTable.getInstance(GameServerTable

.java:676)

        at com.l2jserver.loginserver.L2LoginServer.<init>(L2LoginServer.java:109

)

        at com.l2jserver.loginserver.L2LoginServer.main(L2LoginServer.java:61)

 

 

 

What is that?