Help about console log in c#

[HatersDAD]

hello best community!,
i wanna make log to table in db.
example: if gm drop item, my filter log it in db (Charname,Code,Date).
any help pls!
thanks.

[KingDollar]

then you should create sql table first

create table _GM_Log (Charname varchar(64),Command varchar(50),Date Datetime)

after you will have to parse 7010 packet which is gm command packet

this enum would help you
it doesn't have the all commands but that what i have parsed, you can parse more if you need just use any packet analyzer, send command , check what byte you received

public enum GameCommands : byte
{
    FindUser = 1,
    GoTown = 2,
    ToTown = 3,
    WorldStatus = 4,
    LoadMonster = 6,
    MakeItem = 7,
    MoveToUser = 8,
    WP = 10,
    Zoe = 12,
    Ban = 13,
    Invisible = 14,
    Invincible = 15,
    Recalluser = 17,
    Recallguild = 18,
    Liename = 19,
    Mobkill = 20,
    resetq = 28,
    Movetonpc = 31,
    Makerentitem = 38,
    Spawnunique_loc = 42
}

now let's parse the packet it self

byte action = pck.ReadUInt8();
GameCommands commandsEnum = (GameCommands)action;
string commandName = commandsEnum.ToString();

//exceute your sqlfunction with parsed paramters and charname

[HatersDAD]

Originally Posted by KingDollar

then you should create sql table first

create table _GM_Log (Charname varchar(64),Command varchar(50),Date Datetime)

after you will have to parse 7010 packet which is gm command packet

this enum would help you
it doesn't have the all commands but that what i have parsed, you can parse more if you need just use any packet analyzer, send command , check what byte you received

public enum GameCommands : byte
{
    FindUser = 1,
    GoTown = 2,
    ToTown = 3,
    WorldStatus = 4,
    LoadMonster = 6,
    MakeItem = 7,
    MoveToUser = 8,
    WP = 10,
    Zoe = 12,
    Ban = 13,
    Invisible = 14,
    Invincible = 15,
    Recalluser = 17,
    Recallguild = 18,
    Liename = 19,
    Mobkill = 20,
    resetq = 28,
    Movetonpc = 31,
    Makerentitem = 38,
    Spawnunique_loc = 42
}

now let's parse the packet it self

byte action = pck.ReadUInt8();
GameCommands commandsEnum = (GameCommands)action;
string commandName = commandsEnum.ToString();

//exceute your sqlfunction with parsed paramters and charname

Thanks my hero

Originally Posted by KingDollar

then you should create sql table first

create table _GM_Log (Charname varchar(64),Command varchar(50),Date Datetime)

after you will have to parse 7010 packet which is gm command packet

this enum would help you
it doesn't have the all commands but that what i have parsed, you can parse more if you need just use any packet analyzer, send command , check what byte you received

public enum GameCommands : byte
{
    FindUser = 1,
    GoTown = 2,
    ToTown = 3,
    WorldStatus = 4,
    LoadMonster = 6,
    MakeItem = 7,
    MoveToUser = 8,
    WP = 10,
    Zoe = 12,
    Ban = 13,
    Invisible = 14,
    Invincible = 15,
    Recalluser = 17,
    Recallguild = 18,
    Liename = 19,
    Mobkill = 20,
    resetq = 28,
    Movetonpc = 31,
    Makerentitem = 38,
    Spawnunique_loc = 42
}

now let's parse the packet it self

byte action = pck.ReadUInt8();
GameCommands commandsEnum = (GameCommands)action;
string commandName = commandsEnum.ToString();

//exceute your sqlfunction with parsed paramters and charname

hello best, thats save only command name i want to save command who is typed like if he type (/makeitem item_scroll_01) thats save in table (charname,item_scroll_01,date). thanks in advance.

[KingDollar]

it depends then on action
as example if make item

if(commandsEnum == GameCommands.MakeItem)
{
 uint itemid = pck.ReadUint32();
 byte itemplus = pck.ReadUint8();
}

[HatersDAD]

Originally Posted by KingDollar

it depends then on action
as example if make item

if(commandsEnum == GameCommands.MakeItem)
{
 uint itemid = pck.ReadUint32();
 byte itemplus = pck.ReadUint8();
}

thank you my hero.