Elysium Core 1.12 Repack - Including MMaps and Optional Vendors

[Poppycock]

Well if they login to your mysql server they can do anything. If you don't want to change it then don't open the mysql port. It is also possible to edit the database from a browser if Apache is running as it includes Adminer. They can go to your_ip/adminer.php and login if they know the user and password for mysql.

Thanks for the helpful info!

I removed adminer.php from the server, changed the SQL password, and then updated realmd.conf, mangosd.conf, index.php and info.php with the new SQL credentials.

Hopefully we're a lot less likely to suffer from "h@xX0r" shenanigans now.

[weavil]

Hey Brotalnia, I took a stab at building from source and I'm a bit lost at the sql migrations. I've tried world.sql from release/development/bropack all seem to have migrations that need to be added.

when I ./merge.sh from the migrations folder and try to bring them in ~-/$mysql -u root -p world < 'merge.sql'

I get errors about duplicate entries.

I also tried to just the full database 218.3mB. Those too seem to be missing migrations.

any tips for me? thanks

[brotalnia]

Simply get the last full db from here:
GitHub - LightsHope/database

And then apply the migration to it. Do not use world.sql that is an empty db, it creates only the structure.

[weavil]

Simply get the last full db from here:
GitHub - LightsHope/database

And then apply the migration to it. Do not use world.sql that is an empty db, it creates only the structure.

I'm failing at the migration part. I don't have much experience with with sql but this is what I'm doing

I dropped the existing schema of world

I created database world and imported in the database from lightshope

I then merged the sql files in the migrations folder using merge.sh

Then tried to import that in to world when I get

ERROR 1062 (23000) at line 19: Duplicate entry '909-3456' for key 'PRIMARY'

[brotalnia]

I think you are trying to apply old migrations. You only need to apply those in this folder:
server/sql/migrations at development * LightsHope/server * GitHub

[weavil]

I think you are trying to apply old migrations. You only need to apply those in this folder:
server/sql/migrations at development * LightsHope/server * GitHub

using the newest database at lightshope, then merging the sql files in /migrations I can import that with no errors however it still leaves with 60 files left to be migrated. those i see are in the old_migrations folder i merge those and try to bring them in and get the duplicate error msg again. lol this is last step too i need.

thanks brotalnia

[brotalnia]

using the newest database at lightshope, then merging the sql files in /migrations I can import that with no errors however it still leaves with 60 files left to be migrated. those i see are in the old_migrations folder i merge those and try to bring them in and get the duplicate error msg again. lol this is last step too i need.

thanks brotalnia

I do not understand what you are trying to do. Everything in old_migrations is already part of the full database release. Migrations get moved to old_migrations whenever a new database release is made. Maybe i should just delete the old migrations folder so nobody can get confused and try to apply them on latest db which already has them. Do not attempt to apply old migrations on latest database.

[weavil]

I do not understand what you are trying to do. Everything in old_migrations is already part of the full database release. Migrations get moved to old_migrations whenever a new database release is made. Maybe i should just delete the old migrations folder so nobody can get confused and try to apply them on latest db which already has them. Do not attempt to apply old migrations on latest database.

I don't think you understood problem, in any case since thepparker last commit I now have a working vanilla server for ubuntu xenial, all is well now.

thanks

[Noituri]

Which guide do you suggest if I want to compile for Debian?

[doomwalkerzx]

i started war effort AQ event on patch 1.9 and for some reason i cannot turn in items to finish the requirement, any ideas how to start the war effort event from scratch ?

[brotalnia]

Which guide do you suggest if I want to compile for Debian?

I use only Windows so i can't help you with that. Try asking on the developer discord.

Discord

i started war effort AQ event on patch 1.9 and for some reason i cannot turn in items to finish the requirement, any ideas how to start the war effort event from scratch ?

To properly reset the AQ event you need to empty the `variables` table in `mangos` database.

[seebaby]

Heyho brotalnia nice repack


Can you make a video for the core compilation of Lightshope Core

and list the programs you need with versions or links.

How to Compile the Elysium Core - YouTube not work for me

Thank you

sry for my bad english

[brotalnia]

Heyho brotalnia nice repack


Can you make a video for the core compilation of Lightshope Core

and list the programs you need with versions or links.

How to Compile the Elysium Core - YouTube not work for me

Thank you

sry for my bad english

Read the wiki - Compiling on Windows * LightsHope/server Wiki * GitHub

[seebaby]

oh sry ty for link

[weavil]

Which guide do you suggest if I want to compile for Debian?

just fyi, i used the instructions here:

server/.travis.yml at development * LightsHope/server * GitHub

everything else is pretty much the same. setup mysql create db's.

ive built a few times in the past week with no issues.