Elysium Core 1.12 Repack - Including MMaps and Optional Vendors

[wownic]

Just make a custom item with the stats you want.

now one need to recreate the dbc file in order to get the new icon for the custom item and not the question mark icon, for instance, i create a new 28 slot bag but i couldnt change the icon in the bags slots. It only shows up like a red "?".
Searching on the web i just found how to change this, modifying the item.dbc and building & applying a personal patch but since item.dbc file is only present on 335 repacks, i cant achieve this. could you tell me which file replaces it in the vanilla repack? i got only itemclass.dbc, itembagfamily.dbc, itemdisplayinfo.dbc, itemgroupsounds.dbc, itempetfood.dbc, itemrandomproperties.dbc, itemset.dbc, itemsubclass.dbc, itemsubclassmask.dbc, itemvisualeffects.dbc, itemvisuals.dbc. And none of them has the structure or items alike the bags to work with.

[brotalnia]

There is no need to edit dbc files in vanilla. Just change the displayid column in item_template and clear your game cache by deleting the WDB folder.

[Mantigora]

And as far as I can tell TimeZoneOffset = in mangosd.conf does not seem to have any effect.

[Mantigora]

Hello Brotalnia,

Thanks a lot for makeing a new update to your great repack.

It took me the best part of an evening to figure out why the new Apache did not want to run,
it seems it needs both the 64 and 32 bit (or at least the x86-version) of vc-redist (C++ 2010 redistribution-pack) to be able to run on my Win7 64 bit machine.
That was a bit unexpected for me. I had already installed the C++ 2015 version, needed to make realmd.exe to run.

There is still a little thing with that new version of apache, it does not seem to want to do https, only http.
Could you give me a hint on where to look for to make it do https?

Another thing I am looking for is a guide to compile this for linux, since I rather run the server on Linux than on windows.
(This is not urgent, but I like to get to it in due time.)
Do you know if there is something for that? I have seen your YT vid on how to compile it for windows, that helps a bit.

Ending with a congrats on your work, well rounded and the care you put into it really shows.
If someone would need an IT-guy, they should hire you.


Cheers!

P.S. How can i make the .xp work? In-game it says that there is no such command. (Neither GM level 6 nor 0)
P.P.S. It looks like the MySQL-server time as read by the @now command is 1 hour off. Is this in UTC? (My time is 1 hour earlier than UTC.)
How can this be changed? It was not like that in Bropack 12.
Also, TimeZoneOffset = in mangosd.conf seems to have no effect. In-game it shows the time that is the time on the server-machine.

[brotalnia]

It took me the best part of an evening to figure out why the new Apache did not want to run,
it seems it needs both the 64 and 32 bit (or at least the x86-version) of vc-redist (C++ 2010 redistribution-pack) to be able to run on my Win7 64 bit machine.
That was a bit unexpected for me. I had already installed the C++ 2015 version, needed to make realmd.exe to run.

Both MySQL and Apache are 32 bit versions, so that they can run on any PC.
You should not need the x64 version of visual c++ redistributable for them.

There is still a little thing with that new version of apache, it does not seem to want to do https, only http.
Could you give me a hint on where to look for to make it do https?

Did it work with the old version of apache? Beause the old version was from around 2007.
Check if there is some setting to enable https in website\apache\conf\httpd.portable.conf
Also you can get an even newer version here Apache VC15 binaries and modules download
The one used in the repack is from 2016, because it's the latest i could find that works for XP as well.

Another thing I am looking for is a guide to compile this for linux, since I rather run the server on Linux than on windows.

Come to the development discord, this was just talked about there. Discord

P.S. How can i make the .xp work? In-game it says that there is no such command. (Neither GM level 6 nor 0)

Which version of the repack are you using? The command is not in v12.
Type "server info" in the server console and tell me what it shows.

P.P.S. It looks like the MySQL-server time as read by the @now command is 1 hour off. Is this in UTC? (My time is 1 hour earlier than UTC.)

Are you sure you are talking about the MySQL time, or the PHP time?
Check the date.timezone setting in website\php\php.portable.ini

[Mantigora]

Hi, thanks for replying.
I had some troubles with the quotes, so it has to be like this now.

----------------------------------------------------------------------

I am running the revision 13:
Core revision: e5f4304b679a92cf57dd / 2018-11-11 18:05:20 +0200 / Win64 (little-endian)

----------------------------------------------------------------------

The old version of Apache (in bropack 12) was able to do https.
I had to change my links back from https to http to make it work again in Bropack 13.
I have not looked into the conf-files yet.

----------------------------------------------------------------------

On Bropack 13 the server-time that is shown in the server info page is 1 hour too low. Showing 09:22 when it is in fact 10:22.
It is indeed not related to MySQL, since it is like this when MySQL is not even running.

Hmm.. the date.timezone setting in website\php\php.portable.ini
is set to:
date.timezone = "Universal"

in version 12 it was set to not used:
;date.timezone =

I went to set it to Europe/(My Capital) and it is ok now.

----------------------------------------------------------------------

The setting
TimeZoneOffset = 9 (or any other number)
in mangosd.conf does not seem to have any effect. The time in-game is still the same time of the server-machine.
(I just checked the Bropack 12 and there it is the same, no effect. Perhaps I am useing it wrong?)

----------------------------------------------------------------------

typing in-game
.xp
will give: there is no such command
(I checked this as GM Brotalnia in Bropack 13)

----------------------------------------------------------------------

Discord is still doing things to open the Discord app, for hours now.
(I had discord in the past but had it removed, since I felt it is rather intrusive.)
When it works again, I will come and visit in that channel. (Thanks for the invite.)

----------------------------------------------------------------------

[EasyKevin]

Version 13 released
127.0.0.1/adminer.php
Login error prompt: Session expired, please login again.
System:MySQL
Server:localhost
Username:root
Password:root
Database:empty and mangos
All hints: Session expired, please login again.
How to solve?
20181122022134~.png

[IndianaJones]

I cant manage to get it working so that my friend can connect. I've tried multiple different IPs (from whatsmyip.com and from typing ipconfig in cmd), changing with both HeidiSQL and the batchscript you kindly provided and I've opened the ports in my firewall that you've written in previous posts that you should open for others to be able to connect.

Any tips? I think i've properly followed all the instructions but it won't work :/

[Mantigora]

Check if your firewall is blocking it.
And there should be ONLY 1 IP that you need, the one that you get from whatsmyip.com.

<quote>
All you need to do in order to make your server public is open ports 3724, 8085, 3306 in your firewall or router, and change the realm's ip address to your real one in the “realmd” database, inside the “realmlist” table. Just the “address” column, not “localAddress”. If you don't know how to connect to the database, you can use this batch file instead. Just put it in the server folder and use it to change the ip of the realm. But don't forget to start MySQL first!
</quote>

[EasyKevin]

################################################################################ ###################################
# PLAYER INTERACTION
#
# AllowTwoSide.Accounts
# Allow accounts to create characters in both teams in any game type.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# AllowTwoSide.Interaction.Chat
# AllowTwoSide.Interaction.Channel
# AllowTwoSide.Interaction.Group
# AllowTwoSide.Interaction.Guild
# AllowTwoSide.Interaction.Trade
# AllowTwoSide.Interaction.Auction
# AllowTwoSide.Interaction.Mail
# Allow or not common :chat(say,yell);channel(chat)group(join)guild(join);trade with different team,
# merge all auction houses for players from different teams, send mail to different team.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# AllowTwoSide.WhoList
# Allow show player from both team in who list.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# AllowTwoSide.AddFriend
# Allow adding friends from other team in friend list.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# TalentsInspecting
# Allow other players see character talents in inspect dialog (Characters in Gamemaster mode can
# inspect talents always)
# Default: 1 (allow)
# 0 (not allow)
#
################################################################################ ###################################

[IndianaJones]

how do I check if my firewall is blocking his connection? mangosd or is there some kind of log for firewall actions?

[Mantigora]

That depends on which firewall you use. The simple thing to do would be to temporarily switch off the the firewall and see if it works then. If still not, then that is not the problem.

[EasyKevin]

The following problems occurred after the server started.

FindScriptTargets: Failed to find buddy for script with id 6 (target_param1: 2532), (target_param2: 30), (target_type: 8.).

[DungeonReset] Instance 0 [map 249]: ScheduleReset 2 for unknown instance.

[brotalnia]

Those are not problems.

[kingz1000]

thank you for the great (best in my opinion vanilla core) Repack and your work.

I have some questions about the newest Repack. When i created a new account with a new charakter and i log in to the game, the character has not the standart spells and items. there are some GM spells and GM gear. the Acc is an normal Player acc with no Admin permissions. how can i remove that? hat how can i change that GM's have with their first logins the GM clothes equiped and the GM spells? i checked already the CharakterCreate Template
but I do not understand exactly what I have to change. I think i have have to change the DBC's?

Keep up the great work!