Register for your free account! | Forgot your password?

You last visited: Today at 13:20

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Missing Characters in Guilds?!

Discussion on Missing Characters in Guilds?! within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2018
Posts: 4
Received Thanks: 0
Exclamation Missing Characters in Guilds?!

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
[ADM]Zayn is offline  
Old 11/19/2018, 14:36   #2
 
Fordmondeo20's Avatar
 
elite*gold: 0
Join Date: Jan 2013
Posts: 72
Received Thanks: 26
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
Fordmondeo20 is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
[HELP] Russian Characters and Guilds
07/13/2018 - Flyff Private Server - 5 Replies
Hi epvp. I need help. Where can I change the values ​​so that I can create characters and guilds in Russian lang. now I can create them only in English lang. Sorry for my english, thank you in advance :rolleyes:
[Release] Fix missing guilds
02/03/2014 - Shaiya PServer Guides & Releases - 3 Replies
Many people have the issue with guilds not being read and remaking the table will not solve it. This may solve your issue. Default DB's on epvper all have this error and SQL 2012 reads it where other versions tend to miss it. 1. Navigate to your dbo.usp_Read_Guild2_R stored procedure ( PS_GameData > Programmability > Stored Procedures ) 2. Right click and select "Modify" to enable editing 3. Locate the line containing "ORDER BY G. DESC
Guilds-Recruiting Thread (Join/Announce Guilds Here!!)
07/13/2011 - Silkroad Online - 95 Replies
Guilds-Recruiting === ===== ======= ========= =========== =============
Missing dbmon.exe file missing
11/05/2009 - Dekaron Private Server - 2 Replies
Can somone give me a download link or somthing just for dbmon.exe please and thank you



All times are GMT +1. The time now is 13:21.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.