Missing Characters in Guilds?!

[[ADM]Zayn]

Dear Community.

Somehow some Characters are missing from a Guild.

They are Listed in the Database as member (rank 1 for example) but no Guild Name above their heads neither they can read the Guild messages.

Even after a Server Restart this problem did not get solved.
A light character was able to read the Chat of a Fury Guild..


Anyone know where the problem is or got a working fix by any chance?

Best regards, [ADM]Zayn

[Fordmondeo20]

Heya,

I think there are some ****** relations in database! Check following database tables:

• dbo.GuildChars
• dbo.Guilds

Some topics with guilds are a tricky thing...

dbo.GuildChars
Ensure that there is assigned the right CharID from the guild leader char

dbo.Guilds
There are some columns starting with 'Master' (MasterUserID, MasterCharID, MasterName). These have to be the right data of the guild leader char! Otherwise the guild name above isn't displayed right at the leader.
Make also sure that the 'Country'-column is set right (0 for light and 1 for dark)! If there is typed a wrong country for a certain guild and in dbo.GuildChars there are wrong charID - guildID relations then i think it is technically possible to read wrong guild chats.
And why there are some characters missing in some guilds could be the aspect that there is a wrong 'TotalCount'.

Also check some Stored Procedures (here you gotta know something about SQL):

• dbo.usp_CreateGuild_E
• dbo.usp_CreateGuild2_E
• dbo.usp_CreateGuildChar_E
• dbo.usp_DeleteGuild_E
• dbo.usp_DeleteGuildChar_E
• dbo.usp_Read_Char_GuildJoinDate_R
• dbo.usp_Read_Guild_R
• dbo.usp_Read_Guild2_R
• dbo.usp_Read_GuildChar_R
• dbo.usp_Save_GuildChar_E
• dbo.usp_Save_GuildInfo_E

Maybe there are some mistakes in your SP's so that there is some data that won't be stored (well) or not stored in a right way.


I hope I could help you and let us know sth bout that.
Sorry for my english.


Cheers