Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

GameServer Record Chat Log

Skilled Illusionist
Joined
Sep 7, 2012
Messages
390
Reaction score
35
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 :):



Press If I Helped
 
Last edited:
Joined
Oct 12, 2011
Messages
554
Reaction score
318
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:

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.

Code:
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
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS


DECLARE  [USER=237450]GuiL[/USER]dName VARCHAR(255),
	  [USER=237450]GuiL[/USER]dID VARCHAR(255),
		@StrToCheck VARCHAR(255),
	  [USER=203234]union[/USER]Leader VARCHAR(255)
		
SELECT  [USER=237450]GuiL[/USER]dID = ID,  [USER=237450]GuiL[/USER]dName = Name FROM SRO_VT_SHARD.dbo._Guild WHERE ID = (SELECT GuildID FROM SRO_VT_SHARD.dbo._GuildMember WHERE CharName =  [USER=551894]Char[/USER]Name)

SELECT @StrToCheck = '-' +  [USER=237450]GuiL[/USER]dName +'): '

SELECT  [USER=203234]union[/USER]Leader = Name 
FROM SRO_VT_SHARD.dbo._Guild 
WHERE ID = (
			SELECT Ally1 FROM SRO_VT_SHARD.dbo._AlliedClans WHERE 
					Ally1 =  [USER=237450]GuiL[/USER]dID OR
					Ally2 =  [USER=237450]GuiL[/USER]dID OR
					Ally3 =  [USER=237450]GuiL[/USER]dID OR
					Ally4 =  [USER=237450]GuiL[/USER]dID OR
					Ally5 =  [USER=237450]GuiL[/USER]dID OR
					Ally6 =  [USER=237450]GuiL[/USER]dID OR
					Ally7 =  [USER=237450]GuiL[/USER]dID OR
					Ally8 =  [USER=237450]GuiL[/USER]dID
			)

IF  [USER=215285]mess[/USER]age LIKE '%' + @StrToCheck + '%')
	BEGIN
		DECLARE  [USER=203234]union[/USER]Message VARCHAR(255) = REPLACE  [USER=215285]mess[/USER]age, @StrToCheck, '')
		INSERT INTO _UnionChat (UnionLeader, Guild, CharName, Message, Time) VALUES   [USER=203234]union[/USER]Leader   [USER=237450]GuiL[/USER]dName,  [USER=551894]Char[/USER]Name,  [USER=203234]union[/USER]Message, GETDATE())
	END
ELSE
	BEGIN
		INSERT INTO _GuildChat (Guild, CharName, Message, Time) VALUES   [USER=237450]GuiL[/USER]dName,  [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
	END
GO
CREATE PROCEDURE _LogGlobalChat
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
INSERT INTO _GlobalChat (CharName, Message, Time) VALUES   [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogAllChat
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
INSERT INTO _AllChat (CharName, Message, Time) VALUES   [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogPrivateChat
@SenderName VARCHAR(255),
  [USER=2000011403]Receiver[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
INSERT INTO _PrivateChat (Sender, Receiver, Message, Time) VALUES (@SenderName,  [USER=2000011403]Receiver[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogAcademyChat
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
DECLARE  [USER=3606]Guardian[/USER]Name VARCHAR(255) =	(
										SELECT CharName 
										FROM SRO_VT_SHARD.dbo._TrainingCampMember 
										WHERE CampID = 
											(
												SELECT CampID 
												FROM SRO_VT_SHARD.dbo._TrainingCampMember 
												WHERE CharName =  [USER=551894]Char[/USER]Name
											) AND MemberClass = 0
										)
										
INSERT INTO _AcademyChat (GuardianName, CharName, Message, Time) VALUES   [USER=3606]Guardian[/USER]Name ,  [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogUniques
  [USER=551894]Char[/USER]Name VARCHAR(255),
@MonsterCodeName VARCHAR(255)
AS
INSERT INTO _Uniques (CharName, MonsterCodeName, Time) VALUES   [USER=551894]Char[/USER]Name, @MonsterCodeName, GETDATE())
 
Skilled Illusionist
Joined
Sep 7, 2012
Messages
390
Reaction score
35
yes, I coded it long ago, but I still have the source. Thanks for mentioning me.

Here is a part of code:

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.

Code:
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
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS


DECLARE  [USER=237450]GuiL[/USER]dName VARCHAR(255),
	  [USER=237450]GuiL[/USER]dID VARCHAR(255),
		@StrToCheck VARCHAR(255),
	  [USER=203234]union[/USER]Leader VARCHAR(255)
		
SELECT  [USER=237450]GuiL[/USER]dID = ID,  [USER=237450]GuiL[/USER]dName = Name FROM SRO_VT_SHARD.dbo._Guild WHERE ID = (SELECT GuildID FROM SRO_VT_SHARD.dbo._GuildMember WHERE CharName =  [USER=551894]Char[/USER]Name)

SELECT @StrToCheck = '-' +  [USER=237450]GuiL[/USER]dName +'): '

SELECT  [USER=203234]union[/USER]Leader = Name 
FROM SRO_VT_SHARD.dbo._Guild 
WHERE ID = (
			SELECT Ally1 FROM SRO_VT_SHARD.dbo._AlliedClans WHERE 
					Ally1 =  [USER=237450]GuiL[/USER]dID OR
					Ally2 =  [USER=237450]GuiL[/USER]dID OR
					Ally3 =  [USER=237450]GuiL[/USER]dID OR
					Ally4 =  [USER=237450]GuiL[/USER]dID OR
					Ally5 =  [USER=237450]GuiL[/USER]dID OR
					Ally6 =  [USER=237450]GuiL[/USER]dID OR
					Ally7 =  [USER=237450]GuiL[/USER]dID OR
					Ally8 =  [USER=237450]GuiL[/USER]dID
			)

IF  [USER=215285]mess[/USER]age LIKE '%' + @StrToCheck + '%')
	BEGIN
		DECLARE  [USER=203234]union[/USER]Message VARCHAR(255) = REPLACE  [USER=215285]mess[/USER]age, @StrToCheck, '')
		INSERT INTO _UnionChat (UnionLeader, Guild, CharName, Message, Time) VALUES   [USER=203234]union[/USER]Leader   [USER=237450]GuiL[/USER]dName,  [USER=551894]Char[/USER]Name,  [USER=203234]union[/USER]Message, GETDATE())
	END
ELSE
	BEGIN
		INSERT INTO _GuildChat (Guild, CharName, Message, Time) VALUES   [USER=237450]GuiL[/USER]dName,  [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
	END
GO
CREATE PROCEDURE _LogGlobalChat
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
INSERT INTO _GlobalChat (CharName, Message, Time) VALUES   [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogAllChat
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
INSERT INTO _AllChat (CharName, Message, Time) VALUES   [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogPrivateChat
@SenderName VARCHAR(255),
  [USER=2000011403]Receiver[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
INSERT INTO _PrivateChat (Sender, Receiver, Message, Time) VALUES (@SenderName,  [USER=2000011403]Receiver[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogAcademyChat
  [USER=551894]Char[/USER]Name VARCHAR(255),
  [USER=215285]mess[/USER]age VARCHAR(255)
AS
DECLARE  [USER=3606]Guardian[/USER]Name VARCHAR(255) =	(
										SELECT CharName 
										FROM SRO_VT_SHARD.dbo._TrainingCampMember 
										WHERE CampID = 
											(
												SELECT CampID 
												FROM SRO_VT_SHARD.dbo._TrainingCampMember 
												WHERE CharName =  [USER=551894]Char[/USER]Name
											) AND MemberClass = 0
										)
										
INSERT INTO _AcademyChat (GuardianName, CharName, Message, Time) VALUES   [USER=3606]Guardian[/USER]Name ,  [USER=551894]Char[/USER]Name,  [USER=215285]mess[/USER]age, GETDATE())
GO
CREATE PROCEDURE _LogUniques
  [USER=551894]Char[/USER]Name VARCHAR(255),
@MonsterCodeName VARCHAR(255)
AS
INSERT INTO _Uniques (CharName, MonsterCodeName, Time) VALUES   [USER=551894]Char[/USER]Name, @MonsterCodeName, GETDATE())

cuz of the PHP code u put the query in it totally fucked up :D
so here is the corrected one :):
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 ?



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 :D:
 
Skilled Illusionist
Joined
Sep 7, 2012
Messages
390
Reaction score
35
@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 ?
 
Initiate Mage
Joined
Jun 7, 2017
Messages
3
Reaction score
0
I copied in my vsro file, executed query but when I used it, the following message appeared

And not log chat in database

thebigbody - GameServer Record Chat Log - RaGEZONE Forums
 
Last edited:
Skilled Illusionist
Joined
Sep 7, 2012
Messages
390
Reaction score
35
I copied in my vsro file, executed query but when I used it, the following message appeared

And not log chat in database

thebigbody - GameServer Record Chat Log - RaGEZONE Forums

O.O that's really wired i have never seen something like that before
 
Back
Top