Azerothcore-wotlk: [BUG] discussion channel

Created on 23 Mar 2020 · 27Comments · Source: azerothcore/azerothcore-wotlk

SMALL DESCRIPTION:

When we create a new character, we are not directly included in channels /1 and /3 except for the races :

Undead
Tauren

EXPECTED BLIZZLIKE BEHAVIOUR:

From the first connection of a newly created character, it must integrate the /1 and /3 discussion channels.

CURRENT BEHAVIOUR:

When we create a new character, we are not directly included in channels /1 and /3 except for the races :

Undead
Tauren
This problem only occurs the first time the character connects.

STEPS TO REPRODUCE THE PROBLEM:

create new charecter (no undead and taurent)
connect first time (skip or not introduction video)
look your chat

EXTRA NOTES:

BRANCH(ES):

master

AC HASH/COMMIT: 686984836470+

OPERATING SYSTEM:

MODULES:

OTHER CUSTOMIZATIONS:

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Confirmed Priority - Low

Source

Maurowin

All 27 comments

Not confirmed. / working well.

I got 1 and 3 as normal for all races.

draeneiyes
elfyes
enanoyes
gnomeyes
humanyes
nocelfyes
orcyes
taurenyes
trolyes
undeadyes

I got all channels when in the town/city.
all

AC HASH/COMMIT: 846f786

Si1ker on 24 Mar 2020

Do u see something on the chat box?
I does a fresh install (DB and compilation) always same trouble with b868f0ad04e7

Maurowin on 24 Mar 2020

@FrancescoBorzi look this video : https://youtu.be/4Lcrir6yjk0
I just compiled, clean database.
Master branch: b868f0ad04e7

Maurowin on 24 Mar 2020

I only confirm for first login not autojoin all channels, if player relogin join normal.
For @Si1ker images this is a normal mode no bug. Comerce, lfgroup, lfguild channels only work in city.

solidmaxtor on 24 Mar 2020

I only confirm for first login not autojoin all channels, if player relogin join normal.
For @Si1ker images this is a normal mode no bug. Comerce, lfgroup, lfguild channels only work in city.

yes, that's the problem I'm pointing out, it's at the first connection you don't reach /1 and /3, you have to disconnect and reconnect to be able to have those channels there. I'm not talking about the cities, but about the starting points at the first connection of the character in question.

So @FrancescoBorzi u can remove "Not confirmed" tag :)

Maurowin on 24 Mar 2020

@solidmaxtor As I said, I'm getting all channels while in town/city, just like an extra note.
@Maurowin First-ever login with every single race and I got channels 1 and 3, as you can see in the pictures. Tha's what you said "it's not working" on this issue.

Si1ker on 25 Mar 2020

@Si1ker There are two of us who have this problem, I don't know how to explain it in any case.
I recompiled several b868f0a on a VM especially dedicated to AC. Look my video https://youtu.be/4Lcrir6yjk0
Iam in Ubuntu 18.04 and you?

Maurowin on 25 Mar 2020

If one of us with the same core get a error, and another one with the same core doesn't, probably the error could be related to the client or server modules (which maybe we forgot to remove/clean) but not to the core I think,

Helias on 25 Mar 2020

maxtor you're on linux too?

BarbzYHOOL on 25 Mar 2020

Ubuntu 18.04, I got the same issue.

Helias on 25 Mar 2020

I bet Silker is on windows and Maxtor on linux, so it could possibly be a linux only issue o_0

BarbzYHOOL on 25 Mar 2020

👍1

I am thinking about worldserver.conf instead.

Helias on 25 Mar 2020

i think its bad itr in locale choose

Viste on 25 Mar 2020

👍1

Yes, it's the client.

I just tested this with a esES client (should be the same of @solidmaxtor ) and I didn't get the issue.

So I am closing this issue because is not related to the server.

Helias on 25 Mar 2020

what? i didn't understand

BarbzYHOOL on 25 Mar 2020

the bug depends on the Client, on esES it does not happen, in enUS yes.
It's not an AC bug, we can't do anything in the core to improve this

Helias on 25 Mar 2020

@Helias i use same client to AC and Warmane, and i have no issue with Warmane. i think we need to search a little bit

Maurowin on 25 Mar 2020

Ok, I will keep this open, we need to investigate and understand if the server can improve this kind of bug

Helias on 26 Mar 2020

i think its bad itr in locale choose

this

Viste on 26 Mar 2020

👀2 👍1

Up :)

Maurowin on 11 Apr 2020

i think its bad itr in locale choose

this

For me Viste is right but iam not dev ^^

Maurowin on 16 Nov 2020

can someone show account table with bugged account

Viste on 17 Nov 2020

can someone show account table with bugged account

I don't understand. It doesn't depend on an account but on the language of the client used. In my case FR and EN

Maurowin on 18 Nov 2020

can someone show account table with bugged account

I don't understand. It doesn't depend on an account but on the language of the client used. In my case FR and EN

first time when server deteccts locale is in Auth

CREATE TABLE `account` 
(
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
  `username` varchar(32) NOT NULL DEFAULT '',
  `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
  `sessionkey` varchar(80) NOT NULL DEFAULT '',
  `v` varchar(64) NOT NULL DEFAULT '',
  `s` varchar(64) NOT NULL DEFAULT '',
  `token_key` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `reg_mail` varchar(255) NOT NULL DEFAULT '',
  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
  `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
  `failed_logins` int(10) unsigned NOT NULL DEFAULT '0',
  `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `lock_country` varchar(2) NOT NULL DEFAULT '00',
  `last_login` timestamp NULL DEFAULT NULL,
  `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2',
  `mutetime` bigint(20) NOT NULL DEFAULT '0',
  `mutereason` varchar(255) NOT NULL DEFAULT '',
  `muteby` varchar(50) NOT NULL DEFAULT '',
  `locale` tinyint(3) unsigned NOT NULL DEFAULT '0', -------------------------- THIS

Viste on 18 Nov 2020

can someone show account table with bugged account

I don't understand. It doesn't depend on an account but on the language of the client used. In my case FR and EN

first time when server deteccts locale is in Auth

CREATE TABLE `account` 
(
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
  `username` varchar(32) NOT NULL DEFAULT '',
  `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
  `sessionkey` varchar(80) NOT NULL DEFAULT '',
  `v` varchar(64) NOT NULL DEFAULT '',
  `s` varchar(64) NOT NULL DEFAULT '',
  `token_key` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `reg_mail` varchar(255) NOT NULL DEFAULT '',
  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
  `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
  `failed_logins` int(10) unsigned NOT NULL DEFAULT '0',
  `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `lock_country` varchar(2) NOT NULL DEFAULT '00',
  `last_login` timestamp NULL DEFAULT NULL,
  `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2',
  `mutetime` bigint(20) NOT NULL DEFAULT '0',
  `mutereason` varchar(255) NOT NULL DEFAULT '',
  `muteby` varchar(50) NOT NULL DEFAULT '',
  `locale` tinyint(3) unsigned NOT NULL DEFAULT '0', -------------------------- THIS

ooh ok, do u need structure or datas ?

Maurowin on 18 Nov 2020

can someone show account table with bugged account

I don't understand. It doesn't depend on an account but on the language of the client used. In my case FR and EN

first time when server deteccts locale is in Auth

CREATE TABLE `account` 
(
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
  `username` varchar(32) NOT NULL DEFAULT '',
  `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
  `sessionkey` varchar(80) NOT NULL DEFAULT '',
  `v` varchar(64) NOT NULL DEFAULT '',
  `s` varchar(64) NOT NULL DEFAULT '',
  `token_key` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `reg_mail` varchar(255) NOT NULL DEFAULT '',
  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
  `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
  `failed_logins` int(10) unsigned NOT NULL DEFAULT '0',
  `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `lock_country` varchar(2) NOT NULL DEFAULT '00',
  `last_login` timestamp NULL DEFAULT NULL,
  `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `expansion` tinyint(3) unsigned NOT NULL DEFAULT '2',
  `mutetime` bigint(20) NOT NULL DEFAULT '0',
  `mutereason` varchar(255) NOT NULL DEFAULT '',
  `muteby` varchar(50) NOT NULL DEFAULT '',
  `locale` tinyint(3) unsigned NOT NULL DEFAULT '0', -------------------------- THIS

ooh ok, do u need structure or datas ?

i already send you table struct... I need it, yeah....
data ofc

Viste on 18 Nov 2020

>
>

i already send you table struct... I need it, yeah....
data ofc

My server run on Ubuntu server 20.04

With EN client :
'11', 'MAUROWIN', 'hash of my password (deleted intentionaly)', 'hash of my session (deleted intentionaly)', 'hash of my "v" column (deleted intentionaly)', 'hash of my "s" column (deleted intentionaly)', '', '', '', '2020-05-11 00:07:16', '192.168.1.33', '192.168.1.33', '0', '0', '00', '2020-11-18 17:25:21', '0', '2', '0', '', '', '0', 'Win', '0', '9120'

With FR client :
'11', 'MAUROWIN', 'hash of my password (deleted intentionaly)', 'hash of my session (deleted intentionaly)', 'hash of my "v" column (deleted intentionaly)', 'hash of my "s" column (deleted intentionaly)', '', '', '', '2020-05-11 00:07:16', '192.168.1.33', '192.168.1.33', '0', '0', '00', '2020-11-18 17:31:39', '0', '2', '0', '', '', '2', 'Win', '0', '9120'

Maurowin on 18 Nov 2020

Was this page helpful?

0 / 5 - 0 ratings

Related issues

Crash# Strand of Ancients

Franklampardst · 4Comments

[NPC][WotlK] Heldgarr Steelbeard - Unable to cast shoot

STARRHELD · 4Comments

[NPC] Zenn Foulhoof

Maurowin · 3Comments

[Drunken Haze] Spell doesn't work

CyberFoxHax · 3Comments

Delete AzerothCore motd

fallen26 · 3Comments