chatty
|
Last Activity: 01/01/2025 14:29
Mentions
| 05/26/2020 |
| 18:05 - Kripteks mentioned chatty in post My Statistic Notice System ...o /ntplayer command.
Shaiya Server Extended
Put it in PS_ChatLog > usp_Insert_Chat_Log_E.
Procedure:
-- Statistics
IF chatData like '%!mystatistic%' and chattype = '1') -- General Chat !mystatistic
BEGIN
DECLARE kill varchar(150), statistic varchar(150), Death varchar(150), win varchar(150)
SET kill = (SELECT... |
| 02/23/2019 |
| 12:42 - JujiPoli mentioned chatty in post [Small-Guide] Remove Chat Emote BEGIN
SET sql = N'
INSERT INTO PS_ChatLog.dbo.ChatLog
(UserUID, CharID, ChatType, TargetName, ChatData, MapID, ChatTime)
VALUES UserUID, @CharID, chattype, targetName, @ChatData, MapiD, @ChatTime)'
EXEC sp_executesql sql,
N UserUID int, @CharID int... |
| 05/04/2018 |
| 02:37 - XareL mentioned chatty in post [RELEASE]Show in-game DP with Commands ...GameData.dbo.Chars WHERE CharID = @CharID)
SET @Puanbak = (SELECT top 1 Point FROM PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID)
-- now we select the chat type
-- ChatType : 1 = Normal Chat | 2 = Whisper (!) | 3 = Guild | 4 = Group (@) (/raid) | 5 = Trade | 6 = /yelling | 7 = Area
IF (@Chatdata like '!pointlook' and @ChatType = '1') -- Chan... |
| 04/28/2018 |
| 23:13 - XareL mentioned chatty in post [RELEASE]Config EXP Rate via in game ...------- EXP Boost ------------*/
DECLARE @Admin varchar(max)
SET @Admin = (SELECT ADM FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
IF (@Chatdata like '%!expboost%' and @ChatType = '1' AND @Admin=1)
/* this query can be improved */
BEGIN
DECLARE @expboost varchar(max)
SET @expboost = (select REPLACE (@chatdata, '!expboost', '' )) -- < space to specif... |
| 04/29/2017 |
| 15:16 - JujiPoli mentioned chatty in post [Release] Alex scripts ...ith the /ntplayer (notice to player):
-- fist we select the bad words
IF (@ChatData like '%bitch%' or @ChatData like '%idiot%')
BEGIN -- 1
-- now we select the chat type
-- ChatType : 1 = Normal Chat | 2 = Whisper (!) | 3 = Guild | 4 = Group (@) (/raid) | 5 = Trade | 6 = /yelling | 7 = Area
IF (@ChatType = '1' or @ChatType = '4' or @ChatType = '5' or @... |
