Driana

I mean, I like the idea. I'm not sure how popular it would be. Like how many people do you think would join? Perhaps instead, Elysium should make clear RP rules and ask GM's to enforce action against antisocial behavior (which Blizzard also did). This would allow RP to coexist comfortably on the existing realms.

It's very simple: .report <playername> That's it, in a nutshell. I think a simple change like this would do wonders to combat spam and abuse. =============== How should it work? When a player is reported enough times, his account will be automatically silenced (muted) and a GM ticket will be opened. When a GM checks the ticket, he'll review what happened and ban the player, or remove the mute. ================ I got this idea from the mangos commands. Once I learned that mangos tiers their commands via a "gm level", then I realized players can also use certain commands. For example, if you type .commands On Elysium, you will see this (LINK), if you are a normal player like me. Since the structure for these commands already exists, and is already being used, it will be very simple to add another one of these "dot commands" to the list. ================= Now, how can we build upon this? Create an addon, which adds a "report spam" menu, just like Blizzard eventually did. Like this: (LINK). It's a very simple addon. And it's not mandatory, because anyone can just type ".report" and shift+click a player's name. But by having this addon, means that people who care enough will use it, and it'll make the realm better for everyone. This addon will be very simple, acting as a front-end for the command ".report playername" ================== Another variation: .report <playername> <reason> <reason> is Optional, but can be: Spaming Language Name Cheating

@Josipbroz Great thank you. That works too. I just solved it: The password hash is the SHA1 hash of your uppercase username, followed by a colon, followed by the uppercase password. When setting this, you must clear the 'v' and 's' values in the database entry. That was my issue... these values must be blanked upon updating the password. In short, the structure of the password hash is: SHA1(CONCAT(UPPER(`username`),':',UPPER('your new password'))) And an example MySQL query to change your password is: UPDATE `account` SET `sha_pass_hash`=SHA1(CONCAT(UPPER(`username`),':',UPPER('your new password'))), `v`=0, `s`=0 WHERE `id` = 'your account id'; In the above query, only replace the words "your new password" and "your account id" ... because the username will be retrieved automatically via the user id. I hope this helps somebody in the future.

I've taken to your public github to create my own copy of this realm, for educational purposes. Everything works great so far. Except, I can't login to it, because I don't know how to store the password hashes in the database. The first thing I tried was sha1("password"), which did not work. The next thing I tried was working-backwards using your authentication script. But that is too complicated for me, because I am not so good at cryptography. It seems you do have a sophisticated password hash. Could you explain to me how to produce it?

I love this idea. I'll add you.

My idea is to introduce a /report <player name> feature. Since it's easy to shift-click someone's name into chat, this could be a practical way to stop them. After enough players submit a report, the account will be temporarily silenced, and a GM ticket automatically opened. Once the GM reviews the chat logs, he will either ban the player or un-silence them (if they were innocent). You could also use this feature to record IP-adresses and ban IP ranges that bring abuse. Another idea is to ban entire nations, or ranges of historical abuse, from accessing the log-on server.

Practically speaking, what measures could the dev team take to stop the gold-selling spam? Ideas about preventing the actual sale of gold are also allowed... I am trying to brainstorm here. This thread is dedicated to anti-spam and anti-abuse.

Why don't you call your friends over to help you? This is how PvP realms work... you should join a PvE realm if this is not something you can handle. It's not the fault of others, the responsibility is on you.

This. The experience is already there, available to you. Simple go do it, or roll an alt.

I agree. At least make it a bit longer. I got booted 3 times while making my character. It think it's quite normal to take your time designing your character. You want to feel like you have "enough" time, because it's such an important, primordial decision. Edit: Also my IRL friend struggled with the character-creating boot, so it's not just me either!

That's an interesting perspective. Not blizzlike with the items, but blizzlike with the experience. I could get on board with this idea.