[Help] CoEmu v2 GuildDirector

[Jresyn]

Well, I've looked all over... I tried to make this NPC on my own but I'm still a novice at C#.

This is as far as I got on my own.
I'm trying to make the Create Guild function...

#region GuildDirector
                case 10003:
                    {
                        if (LinkBack == 0)
                        {
                            Text("Greetings! I am the guild director, in charge of administrating and managing guilds. What business do you have with me?", CSocket);
                            Link("Create a guild", 1, CSocket);
                            Link("Disband my guild", 2, CSocket);
                            Link("Donate money", 3, CSocket);
                            Link("Pass my leadership", 4, CSocket);
                            Link("Assign Deputy Guild Leader", 5, CSocket);
                            Link("Remove sb. from office", 6, CSocket);
                            Link("Inquire about a guilde", 7, CSocket);
                            Link("Others", 8, CSocket);
                            Face(30, CSocket);
                            End(CSocket);
                        }
                    }
#endregion

I thought I could do something like

 public static void NewGuild(string Name, int Client)
        {
            MySqlCommand Cmd = new MySqlCommand("INSERT INTO guilds(Name, Leader) VALUES(" + Name + "," + Client + "", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose();
        }

in the Database.cs but I'm not too sure if that's correct...
Then having

if (LinkBack == 1)
              {
                   Text("Please input the desired Guild name", CSocket);
                   Input(3, CSocket);
                   Database.Database.NewGuild(Name, Client);
                   Face(30, CSocket);
                   End(CSocket);
              }

Or something to that effect... If anyone has done this already could you give me some hints/tips if I'm on the right path or possibly help me entirely?

Thanks in advance

-Jresyn

[ImmortalYashi]

The right syntax should be :
else if (LinkBack == 1)
{
Text("Please input the desired Guild name.", CSocket);
Input("something here", 3, CSocket);
Database.Database.NewGuild(Name, Client);
Face(30, CSocket);
End(CSocket);
}

[Jresyn]

Ok, so am I going in the right direction with this?

[ImmortalYashi]

Pretty much yes. But you need the packets and the packet structure and the handlers for it to eh?

Cya'round,
Yashi.

[Jresyn]

So does this mean I have to sniff the packets myself and figure out the structure on my own?

Or is this posted on the forums somewhere?

If anyone cares to help me on this it'd be appreciated

Edit: I actually did some more searching... and found a thread on this D=...

Thanks for your help though Yashi

[ImmortalYashi]

Press thanks if i helped you out.

Cya'round,
Yashi.

[samehvan]

Originally Posted by Jresyn

Well, I've looked all over... I tried to make this NPC on my own but I'm still a novice at C#.

This is as far as I got on my own.
I'm trying to make the Create Guild function...

#region GuildDirector
                case 10003:
                    {
                        if (LinkBack == 0)
                        {
                            Text("Greetings! I am the guild director, in charge of administrating and managing guilds. What business do you have with me?", CSocket);
                            Link("Create a guild", 1, CSocket);
                            Link("Disband my guild", 2, CSocket);
                            Link("Donate money", 3, CSocket);
                            Link("Pass my leadership", 4, CSocket);
                            Link("Assign Deputy Guild Leader", 5, CSocket);
                            Link("Remove sb. from office", 6, CSocket);
                            Link("Inquire about a guilde", 7, CSocket);
                            Link("Others", 8, CSocket);
                            Face(30, CSocket);
                            End(CSocket);
                        }
                    }
#endregion

I thought I could do something like

 public static void NewGuild(string Name, int Client)
        {
            MySqlCommand Cmd = new MySqlCommand("INSERT INTO guilds(Name, Leader) VALUES(" + Name + "," + Client + "", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose();
        }

in the Database.cs but I'm not too sure if that's correct...
Then having

if (LinkBack == 1)
              {
                   Text("Please input the desired Guild name", CSocket);
                   Input(3, CSocket);
                   Database.Database.NewGuild(Name, Client);
                   Face(30, CSocket);
                   End(CSocket);
              }

Or something to that effect... If anyone has done this already could you give me some hints/tips if I'm on the right path or possibly help me entirely?

Thanks in advance

-Jresyn

1-you have to get the name the player entered first , usually it starts from Data 14 to (Data.length -11) and that would be the name
2-the MySql command should be

VALUES([COLOR="Red"]'[/COLOR]" + Name + "[COLOR="Red"]'[/COLOR],

Originally Posted by Jresyn

Ok, so am I going in the right direction with this?

Originally Posted by Jresyn

So does this mean I have to sniff the packets myself and figure out the structure on my own?

Or is this posted on the forums somewhere?

If anyone cares to help me on this it'd be appreciated

Edit: I actually did some more searching... and found a thread on this D=...

Thanks for your help though Yashi

the data u need is already there and decrypted u just need to convert it from hexa to characters to get the r8 name and then the Client should be CSocket.Client.ID