Page 1 of 1

can it be sent as one

PostPosted: Sat Mar 11, 2017 1:13 pm
by lion228
hello what c# code will send the two Guids as one is it possible ? in navicat database I have 2 guid with the same but it only sends one my two guid numbers is this in the db . both guid numbers are 766 but it only prints out the name david

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 1:15 pm
by PlanarChaosRvrtwo
you want keep 2 guilds but want em share an guild chat or what is your question exactly?

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 1:23 pm
by lion228
it only prints out the first name david i need to print out on console both names but what c# code used to print it with same guid number . I using this code but it only prints out the first name from the db
Code: Select all
if Guid == (ushort)0x02FE) { Out.WritePascalString(Name); }

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 2:00 pm
by PlanarChaosRvrtwo
I still dont understand you want see all players with given guild id?

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 2:24 pm
by lion228
yes something like that

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 2:47 pm
by PlanarChaosRvrtwo
do in heidisql (dunno how it is in navicat)
Code: Select all
SELECT * FROM dolcharacters WHERE GuildID LIKE somethin
and look for guild id in the guild table

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 3:04 pm
by lion228
no im trying to make the c# code to send both the code I posted above only shows david on console screen whith that guid number I need it to print both names out using the same guid number

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 3:45 pm
by PlanarChaosRvrtwo
Ah nvm well i dont think you can do this without changing something in client

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 3:49 pm
by lion228
ok im trying to work out how to send this as code http://pastebin.com/zW3nB19Q
the guid is 03 85 and it has two names that it sends Norse raiders and Norse ravagers when sent you get this
https://postimg.org/image/ft46jaq5h/ but im only getting one https://postimg.org/image/rudbkiz57/

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 6:19 pm
by Graveen
You are working the wrong way... Your check is correct, but the Guid came from a code that is retrieving the records, and this is where you must specify the select for the records.

In DOL this would have to be done with GameServer.Database.SelectObjects<T>()

Re: can it be sent as one

PostPosted: Sat Mar 11, 2017 8:10 pm
by lion228
ok I see that in world manger in this but it already here
Code: Select all
#region Public Quests static public Dictionary<uint, PQuest_Info> _PQuests; [LoadingFunction(true)] static public void LoadPQuest_Info() { _PQuests = new Dictionary<uint, PQuest_Info>(); IList<PQuest_Info> PQuests = Database.SelectObjects<PQuest_Info>("PinX != 0 AND PinY != 0"); foreach (PQuest_Info Info in PQuests) { _PQuests.Add(Info.Entry, Info); } Log.Success("WorldMgr", "Loaded " + _PQuests.Count + " Public Quests Info"); } static public Dictionary<uint, List<PQuest_Objective>> _PQuest_Objectives; [LoadingFunction(true)] static public void LoadPQuest_Objective() { _PQuest_Objectives = new Dictionary<uint, List<PQuest_Objective>>(); IList<PQuest_Objective> PObjectives = Database.SelectObjects<PQuest_Objective>("Type != 0"); foreach (PQuest_Objective Obj in PObjectives) { List<PQuest_Objective> Objs; if (!_PQuest_Objectives.TryGetValue(Obj.Entry, out Objs)) { Objs = new List<PQuest_Objective>(); _PQuest_Objectives.Add(Obj.Entry, Objs); } Objs.Add(Obj); } Log.Success("WorldMgr", "Loaded " + PObjectives.Count + " Public Quest Objectives");