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");