GameServer Record Chat Log

[thebigbody]

hey guys first of all idk if it's already released or no but i searched for it and i couldn't find it
anyway here it is

setup is so easy just
1 - setup the needed files includes the database which you just have to query it on any SQL version
2 - edit the Config file with your INFO and enjoy

GameServer Record ChatLog

Press If I Helped

[MentaL]

[CandyQ]

Old :D but Good

[RenePunik]

lol, at least give credits to team24-7.net

[thebigbody]

Old :D but Good

sorry i searched for it and i couldn't find it so i tried to help

lol, at least give credits to team24-7.net

iam sorry i don't know who is the creator and even though i didn't give any credit for myself

[RenePunik]

sorry i searched for it and i couldn't find it so i tried to help



iam sorry i don't know who is the creator and even though i didn't give any credit for myself

NP, I just said the credits goes to who, anyway. it's not a war :)

[egyhunter]

NP, I just said the credits goes to who, anyway. it's not a war :)

all credits goes to sladlejrhfpg not anyone else. he is the creator of that dll. if you don't know who is the person who created something, then don't give credits to another random one. okay?

[RenePunik]

all credits goes to sladlejrhfpg not anyone else. he is the creator of that dll. if you don't know who is the person who created something, then don't give credits to another random one. okay?

And who is owner of team24-7.net ?

[egyhunter]

And who is owner of team24-7.net ?

makaveli.

[sladlejrhfpq]

all credits goes to sladlejrhfpg not anyone else. he is the creator of that dll. if you don't know who is the person who created something, then don't give credits to another random one. okay?

yes, I coded it long ago, but I still have the source. Thanks for mentioning me.

Here is a part of code:

void LogGuildMsg()
{
	sprintf(buffer, "exec %s.dbo._LogGuildAndUnionChat :1, :2", sql->DBName);
	sql->ExecuteQuery(buffer, GuildSenderName, GuildMessage);
}

_declspec(naked) void onGuildMsg()
{
	_asm
	{
		PUSH EBP;
		POP GuildMessage;
		PUSH EDI;
		POP GuildSenderName;
		CALL LogGuildMsg;

use the original install.sql file, the one in the rar is kinda fkd up. also add in the title that it is for the vsro 188 files.

Spoiler:

USE SRO_VT_SHARD
GO
CREATE TABLE _Uniques
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	CharName VARCHAR(255),
	MonsterCodeName VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_UniqueKills PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _GlobalChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_GlobalChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _AllChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_AllChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _PrivateChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	Sender VARCHAR(255),
	Receiver VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_PrivateChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _GuildChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	Guild VARCHAR(255),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_GuildChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _AcademyChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	GuardianName VARCHAR(255),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_AcademyChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _UnionChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	UnionLeader VARCHAR(255),
	Guild VARCHAR(255),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_UnionChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE PROCEDURE _LogGuildAndUnionChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS


DECLARE  @GuiLdName VARCHAR(255),
	  @GuiLdID VARCHAR(255),
		@StrToCheck VARCHAR(255),
	  @unionLeader VARCHAR(255)
		
SELECT  @GuiLdID = ID,  @GuiLdName = Name FROM SRO_VT_SHARD.dbo._Guild WHERE ID = (SELECT GuildID FROM SRO_VT_SHARD.dbo._GuildMember WHERE CharName =  @CharName)

SELECT @StrToCheck = '-' +  @GuiLdName +'): '

SELECT  @unionLeader = Name 
FROM SRO_VT_SHARD.dbo._Guild 
WHERE ID = (
			SELECT Ally1 FROM SRO_VT_SHARD.dbo._AlliedClans WHERE 
					Ally1 =  @GuiLdID OR
					Ally2 =  @GuiLdID OR
					Ally3 =  @GuiLdID OR
					Ally4 =  @GuiLdID OR
					Ally5 =  @GuiLdID OR
					Ally6 =  @GuiLdID OR
					Ally7 =  @GuiLdID OR
					Ally8 =  @GuiLdID
			)

IF  @message LIKE '%' + @StrToCheck + '%')
	BEGIN
		DECLARE  @unionMessage VARCHAR(255) = REPLACE  @message, @StrToCheck, '')
		INSERT INTO _UnionChat (UnionLeader, Guild, CharName, Message, Time) VALUES   @unionLeader   @GuiLdName,  @CharName,  @unionMessage, GETDATE())
	END
ELSE
	BEGIN
		INSERT INTO _GuildChat (Guild, CharName, Message, Time) VALUES   @GuiLdName,  @CharName,  @message, GETDATE())
	END
GO
CREATE PROCEDURE _LogGlobalChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS
INSERT INTO _GlobalChat (CharName, Message, Time) VALUES   @CharName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogAllChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS
INSERT INTO _AllChat (CharName, Message, Time) VALUES   @CharName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogPrivateChat
@SenderName VARCHAR(255),
  @ReceiverName VARCHAR(255),
  @message VARCHAR(255)
AS
INSERT INTO _PrivateChat (Sender, Receiver, Message, Time) VALUES (@SenderName,  @ReceiverName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogAcademyChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS
DECLARE  @GuardianName VARCHAR(255) =	(
										SELECT CharName 
										FROM SRO_VT_SHARD.dbo._TrainingCampMember 
										WHERE CampID = 
											(
												SELECT CampID 
												FROM SRO_VT_SHARD.dbo._TrainingCampMember 
												WHERE CharName =  @CharName
											) AND MemberClass = 0
										)
										
INSERT INTO _AcademyChat (GuardianName, CharName, Message, Time) VALUES   @GuardianName ,  @CharName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogUniques
  @CharName VARCHAR(255),
@MonsterCodeName VARCHAR(255)
AS
INSERT INTO _Uniques (CharName, MonsterCodeName, Time) VALUES   @CharName, @MonsterCodeName, GETDATE())

[thebigbody]

yes, I coded it long ago, but I still have the source. Thanks for mentioning me.

Here is a part of code:

void LogGuildMsg()
{
	sprintf(buffer, "exec %s.dbo._LogGuildAndUnionChat :1, :2", sql->DBName);
	sql->ExecuteQuery(buffer, GuildSenderName, GuildMessage);
}

_declspec(naked) void onGuildMsg()
{
	_asm
	{
		PUSH EBP;
		POP GuildMessage;
		PUSH EDI;
		POP GuildSenderName;
		CALL LogGuildMsg;

use the original install.sql file, the one in the rar is kinda fkd up. also add in the title that it is for the vsro 188 files.

Spoiler:

USE SRO_VT_SHARD
GO
CREATE TABLE _Uniques
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	CharName VARCHAR(255),
	MonsterCodeName VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_UniqueKills PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _GlobalChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_GlobalChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _AllChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_AllChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _PrivateChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	Sender VARCHAR(255),
	Receiver VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_PrivateChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _GuildChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	Guild VARCHAR(255),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_GuildChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _AcademyChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	GuardianName VARCHAR(255),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_AcademyChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _UnionChat
(
	ID BIGINT NOT NULL IDENTITY (1,1),
	UnionLeader VARCHAR(255),
	Guild VARCHAR(255),
	CharName VARCHAR(255),
	Message VARCHAR(255),
	Time DATETIME,
	CONSTRAINT PK_UnionChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE PROCEDURE _LogGuildAndUnionChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS


DECLARE  @GuiLdName VARCHAR(255),
	  @GuiLdID VARCHAR(255),
		@StrToCheck VARCHAR(255),
	  @unionLeader VARCHAR(255)
		
SELECT  @GuiLdID = ID,  @GuiLdName = Name FROM SRO_VT_SHARD.dbo._Guild WHERE ID = (SELECT GuildID FROM SRO_VT_SHARD.dbo._GuildMember WHERE CharName =  @CharName)

SELECT @StrToCheck = '-' +  @GuiLdName +'): '

SELECT  @unionLeader = Name 
FROM SRO_VT_SHARD.dbo._Guild 
WHERE ID = (
			SELECT Ally1 FROM SRO_VT_SHARD.dbo._AlliedClans WHERE 
					Ally1 =  @GuiLdID OR
					Ally2 =  @GuiLdID OR
					Ally3 =  @GuiLdID OR
					Ally4 =  @GuiLdID OR
					Ally5 =  @GuiLdID OR
					Ally6 =  @GuiLdID OR
					Ally7 =  @GuiLdID OR
					Ally8 =  @GuiLdID
			)

IF  @message LIKE '%' + @StrToCheck + '%')
	BEGIN
		DECLARE  @unionMessage VARCHAR(255) = REPLACE  @message, @StrToCheck, '')
		INSERT INTO _UnionChat (UnionLeader, Guild, CharName, Message, Time) VALUES   @unionLeader   @GuiLdName,  @CharName,  @unionMessage, GETDATE())
	END
ELSE
	BEGIN
		INSERT INTO _GuildChat (Guild, CharName, Message, Time) VALUES   @GuiLdName,  @CharName,  @message, GETDATE())
	END
GO
CREATE PROCEDURE _LogGlobalChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS
INSERT INTO _GlobalChat (CharName, Message, Time) VALUES   @CharName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogAllChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS
INSERT INTO _AllChat (CharName, Message, Time) VALUES   @CharName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogPrivateChat
@SenderName VARCHAR(255),
  @ReceiverName VARCHAR(255),
  @message VARCHAR(255)
AS
INSERT INTO _PrivateChat (Sender, Receiver, Message, Time) VALUES (@SenderName,  @ReceiverName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogAcademyChat
  @CharName VARCHAR(255),
  @message VARCHAR(255)
AS
DECLARE  @GuardianName VARCHAR(255) =	(
										SELECT CharName 
										FROM SRO_VT_SHARD.dbo._TrainingCampMember 
										WHERE CampID = 
											(
												SELECT CampID 
												FROM SRO_VT_SHARD.dbo._TrainingCampMember 
												WHERE CharName =  @CharName
											) AND MemberClass = 0
										)
										
INSERT INTO _AcademyChat (GuardianName, CharName, Message, Time) VALUES   @GuardianName ,  @CharName,  @message, GETDATE())
GO
CREATE PROCEDURE _LogUniques
  @CharName VARCHAR(255),
@MonsterCodeName VARCHAR(255)
AS
INSERT INTO _Uniques (CharName, MonsterCodeName, Time) VALUES   @CharName, @MonsterCodeName, GETDATE())

cuz of the PHP code u put the query in it totally fucked up :D
so here is the corrected one

Spoiler:

USE SRO_VT_SYSTEMS
GO
CREATE TABLE _Uniques
(
ID BIGINT NOT NULL IDENTITY (1,1),
CharName VARCHAR(255),
MonsterCodeName VARCHAR(255),
Time DATETIME,
CONSTRAINT PK_UniqueKills PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _GlobalChat
(
ID BIGINT NOT NULL IDENTITY (1,1),
CharName VARCHAR(255),
Message VARCHAR(255),
Time DATETIME,
CONSTRAINT PK_GlobalChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _AllChat
(
ID BIGINT NOT NULL IDENTITY (1,1),
CharName VARCHAR(255),
Message VARCHAR(255),
Time DATETIME,
CONSTRAINT PK_AllChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _PrivateChat
(
ID BIGINT NOT NULL IDENTITY (1,1),
Sender VARCHAR(255),
Receiver VARCHAR(255),
Message VARCHAR(255),
Time DATETIME,
CONSTRAINT PK_PrivateChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _GuildChat
(
ID BIGINT NOT NULL IDENTITY (1,1),
Guild VARCHAR(255),
CharName VARCHAR(255),
Message VARCHAR(255),
Time DATETIME,
CONSTRAINT PK_GuildChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _AcademyChat
(
ID BIGINT NOT NULL IDENTITY (1,1),
GuardianName VARCHAR(255),
CharName VARCHAR(255),
Message VARCHAR(255),
Time DATETIME,
CONSTRAINT PK_AcademyChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE TABLE _UnionChat
(
ID BIGINT NOT NULL IDENTITY (1,1),
UnionLeader VARCHAR(255),
Guild VARCHAR(255),
CharName VARCHAR(255),
Message VARCHAR(255),
Time DATETIME,
CONSTRAINT PK_UnionChat PRIMARY KEY CLUSTERED (ID)
)
GO
CREATE PROCEDURE _LogGuildAndUnionChat
@CharName VARCHAR(255),
@message VARCHAR(255)
AS


DECLARE @GuiLdName VARCHAR(255),
@GuiLdID VARCHAR(255),
@StrToCheck VARCHAR(255),
@unionLeader VARCHAR(255)

SELECT @GuiLdID = ID, @GuiLdName = Name FROM SHARD_VICTOR.dbo._Guild WHERE ID = (SELECT GuildID FROM SHARD_VICTOR.dbo._GuildMember WHERE CharName = @CharName)

SELECT @StrToCheck = '-' + @GuiLdName +'): '

SELECT @unionLeader = Name
FROM SHARD_VICTOR.dbo._Guild
WHERE ID = (
SELECT Ally1 FROM SHARD_VICTOR.dbo._AlliedClans WHERE
Ally1 = @GuiLdID OR
Ally2 = @GuiLdID OR
Ally3 = @GuiLdID OR
Ally4 = @GuiLdID OR
Ally5 = @GuiLdID OR
Ally6 = @GuiLdID OR
Ally7 = @GuiLdID OR
Ally8 = @GuiLdID
)

IF (@message LIKE '%' + @StrToCheck + '%')
BEGIN
DECLARE @unionMessage VARCHAR(255) = REPLACE (@message, @StrToCheck, '')
INSERT INTO _UnionChat (UnionLeader, Guild, CharName, Message, Time) VALUES (@unionLeader, @GuiLdName, @CharName, @unionMessage, GETDATE())
END
ELSE
BEGIN
INSERT INTO _GuildChat (Guild, CharName, Message, Time) VALUES (@GuiLdName, @CharName, @message, GETDATE())
END
GO
CREATE PROCEDURE _LogGlobalChat
@CharName VARCHAR(255),
@message VARCHAR(255)
AS
INSERT INTO _GlobalChat (CharName, Message, Time) VALUES (@CharName, @message, GETDATE())
GO
CREATE PROCEDURE _LogAllChat
@CharName VARCHAR(255),
@message VARCHAR(255)
AS
INSERT INTO _AllChat (CharName, Message, Time) VALUES (@CharName, @message, GETDATE())
GO
CREATE PROCEDURE _LogPrivateChat
@SenderName VARCHAR(255),
@ReceiverName VARCHAR(255),
@message VARCHAR(255)
AS
INSERT INTO _PrivateChat (Sender, Receiver, Message, Time) VALUES (@SenderName, @ReceiverName, @message, GETDATE())
GO
CREATE PROCEDURE _LogAcademyChat
@CharName VARCHAR(255),
@message VARCHAR(255)
AS
DECLARE @GuardianName VARCHAR(255) = (
SELECT CharName
FROM SHARD_VICTOR.dbo._TrainingCampMember
WHERE CampID =
(
SELECT CampID
FROM SHARD_VICTOR.dbo._TrainingCampMember
WHERE CharName = @CharName
) AND MemberClass = 0
)

INSERT INTO _AcademyChat (GuardianName, CharName, Message, Time) VALUES (@GuardianName , @CharName, @message, GETDATE())
GO
CREATE PROCEDURE _LogUniques
@CharName VARCHAR(255),
@MonsterCodeName VARCHAR(255)
AS
INSERT INTO _Uniques (CharName, MonsterCodeName, Time) VALUES (@CharName, @MonsterCodeName, GETDATE())

but what is the difference ?

- - - Updated - - -

oh 1 more thing since you are the creator and you still have the source why don't you add the arena reward into it

[concucu021]

why not have party chat log ?

[sladlejrhfpq]

@thebigbody it didnt really fk up, just copy paste to a text file. It was long ago, I'm not really interested in silkroad any more.

@concucu021 I could log the party chat, but I thought it would be pointless, because the parties change really often

[thebigbody]

@sladlejrhfpq no the PHP code made the query wrong it removed some ( beacause of the mentions in it .... just check it
PS : what about the arena reward and the party it's not pointless at all ?

[concucu021]

@concucu021 I could log the party chat, but I thought it would be pointless, because the parties change really often

can you code with GS Csro r ?

[toanmk91]

I copied in my vsro file, executed query but when I used it, the following message appeared

And not log chat in database