Several Problems while creating a DDNet based server
-
- Posts: 57
- Joined: Mon Jul 13, 2015 1:43 pm
- Location: IR
- Player profile: http://ddnet.tw/players/Sv3N/
- Mapper profile: http://ddnet.tw/mappers/FlushA/
- Clan: I.R.T
Several Problems while creating a DDNet based server
Hello,
I have a problem with sql_score for use from points in ddnet.
I don't know anything about sql and how to make a sql file.
please help me to enable sql in my DDNet server.
I have a problem with sql_score for use from points in ddnet.
I don't know anything about sql and how to make a sql file.
please help me to enable sql in my DDNet server.
✟Տ℣ʒN✟
- Ryozuki
- Posts: 1748
- Joined: Tue Feb 24, 2015 7:28 am
- Location: Catalonia
- Player profile: http://ddnet.tw/players/Ryozuki/
- Mapper profile: http://ddnet.tw/mappers/Ryozuki/
- Clan: Unique
- Website: https://edgarluque.com
- Discord: Ryozuki#2188
Re: sql file for DDNet
https://en.wikipedia.org/wiki/SQL
maybe this program helps too: http://sqlitebrowser.org/
i rly don't know but maybe this helps (?)
maybe this program helps too: http://sqlitebrowser.org/
i rly don't know but maybe this helps (?)
- deen
- Posts: 3576
- Joined: Mon May 05, 2014 2:30 pm
- Player profile: https://ddnet.org/players/deen/
- Discord: deen#5910
Re: sql file for DDNet
You need MySQL, first learn how that works.
Then you can use
Building instructions here: https://github.com/ddnet/ddnet#building
SQL settings here (search for sql): http://ddnet.tw/settingscommands/
Then you can use
mysql database < sql_score
to load the scores into your DB.Building instructions here: https://github.com/ddnet/ddnet#building
SQL settings here (search for sql): http://ddnet.tw/settingscommands/
-
- Posts: 57
- Joined: Mon Jul 13, 2015 1:43 pm
- Location: IR
- Player profile: http://ddnet.tw/players/Sv3N/
- Mapper profile: http://ddnet.tw/mappers/FlushA/
- Clan: I.R.T
Re: sql file for DDNet
So what you mean is that DDNet does not need import a .sql file to a mysql database?
✟Տ℣ʒN✟
- deen
- Posts: 3576
- Joined: Mon May 05, 2014 2:30 pm
- Player profile: https://ddnet.org/players/deen/
- Discord: deen#5910
Re: sql file for DDNet
right, DDNet SQL server can create its own database and table. I assumed you want to import the official DDNet database.
-
- Posts: 400
- Joined: Sat Apr 11, 2015 5:05 pm
- Player profile: http://ddnet.tw/players/Chairn/
- Clan: QuintessenZ
Re: sql file for DDNet
Is there any reason for not including MySQL server in the binary releases?
- deen
- Posts: 3576
- Joined: Mon May 05, 2014 2:30 pm
- Player profile: https://ddnet.org/players/deen/
- Discord: deen#5910
Re: sql file for DDNet
Most don't need it and it's ~30 MB that you would have to download with every update. If you can't compile the SQL server, you'll have even bigger trouble using it.Chairn wrote:Is there any reason for not including MySQL server in the binary releases?
-
- Posts: 57
- Joined: Mon Jul 13, 2015 1:43 pm
- Location: IR
- Player profile: http://ddnet.tw/players/Sv3N/
- Mapper profile: http://ddnet.tw/mappers/FlushA/
- Clan: I.R.T
Re: sql file for DDNet
Hello again,
I am get some error in bam server_sql_release
errors
other/mysql/include\cppconn/connection.h(31) : fatal error C1083: Cannot open in
clude file: 'boost/variant.hpp': No such file or directory
bam: 'objs/game/server/gamecontext_sql.obj' error 2
and 31 line is #include <boost/variant.hpp>
how fix this error?
I am get some error in bam server_sql_release
errors
other/mysql/include\cppconn/connection.h(31) : fatal error C1083: Cannot open in
clude file: 'boost/variant.hpp': No such file or directory
bam: 'objs/game/server/gamecontext_sql.obj' error 2
and 31 line is #include <boost/variant.hpp>
how fix this error?
✟Տ℣ʒN✟
- deen
- Posts: 3576
- Joined: Mon May 05, 2014 2:30 pm
- Player profile: https://ddnet.org/players/deen/
- Discord: deen#5910
Re: sql file for DDNet
apt-get install libboost-dev
Who is online
Users browsing this forum: No registered users and 2 guests