[Help] Save Chat In SQL!

[HatersDAD]

hello awesome community,
first: thanks for kingdollar and all ppls for solve my last topic help.
second: i want to make log from filter (AllChat,PrivateChat,GlobalChat,GuildChat) .
what is packet? and how i can save this chats into my sql db.
thanks a lot.

[chipno0p]

I think u can use a Game Server which has chat log function. As I remembered, there is a Game Server has this function.

[HatersDAD]

Originally Posted by chipno0p

I think u can use a Game Server which has chat log function. As I remembered, there is a Game Server has this function.

yes iknow,
but i want to make this function in my filter. thanks for reply.

[KingDollar]

you can handle client chat packet

this enum would help you for chatType

public enum ChatType : byte
{
    All = 1,
    PM = 2,
    AllGM = 3,
    Party = 4,
    Guild = 5,
    Global = 6,
    Notice = 7,
    Stall = 9,
    Union = 11,
    NPC = 13,
    Accademy = 16,
}

and here is packet structure

byte msgTypeId = pck.ReadUInt8();
byte msgCount = pck.ReadUInt8();
ChatType msgType = (ChatType)(msgTypeId);
string msg = string.Empty;
switch (msgType)
{
    case ChatType.All:
	case ChatType.AllGM:
	case ChatType.Party:
	case ChatType.Guild:
	case ChatType.Accademy:
	case ChatType.Union:
	case ChatType.Stall:
            msg = pck.ReadAscii();
        break;

    case ChatType.PM:
        {
            string name = pck.ReadAscii();
            msg = pck.ReadAscii();
        }
        break;
}

[#HB]

KingDollar is the second Goofie baby

[HatersDAD]

Originally Posted by KingDollar

you can handle client chat packet

this enum would help you for chatType

public enum ChatType : byte
{
    All = 1,
    PM = 2,
    AllGM = 3,
    Party = 4,
    Guild = 5,
    Global = 6,
    Notice = 7,
    Stall = 9,
    Union = 11,
    NPC = 13,
    Accademy = 16,
}

and here is packet structure

byte msgTypeId = pck.ReadUInt8();
byte msgCount = pck.ReadUInt8();
ChatType msgType = (ChatType)(msgTypeId);
string msg = string.Empty;
switch (msgType)
{
    case ChatType.All:
	case ChatType.AllGM:
	case ChatType.Party:
	case ChatType.Guild:
	case ChatType.Accademy:
	case ChatType.Union:
	case ChatType.Stall:
            msg = pck.ReadAscii();
        break;

    case ChatType.PM:
        {
            string name = pck.ReadAscii();
            msg = pck.ReadAscii();
        }
        break;
}

thanks again .

Originally Posted by #HB

KingDollar is the second Goofie baby

hhahahaha, right [King] <3