[Release] Alex scripts

[edsonne2020]

Msg 155, Level 15, State 2, Procedure Welcome_Message, Line 18
'UserU' is not a recognized CURSOR option.
Msg 155, Level 15, State 2, Procedure Welcome_Message, Line 19
'faction' is not a recognized CURSOR option.
Msg 102, Level 15, State 1, Procedure Welcome_Message, Line 19
Incorrect syntax near 'UserU'.
Msg 4145, Level 15, State 1, Procedure Welcome_Message, Line 22
An expression of non-boolean type specified in a context where a condition is expected, near 'faction'.
Msg 156, Level 15, State 1, Procedure Welcome_Message, Line 24
Incorrect syntax near the keyword 'else'.
Msg 155, Level 15, State 2, Procedure Welcome_Message, Line 28
'welcome' is not a recognized CURSOR option.
Msg 155, Level 15, State 2, Procedure Welcome_Message, Line 31
'ReTuRn_' is not a recognized CURSOR option.
Msg 102, Level 15, State 1, Procedure Welcome_Message, Line 33
Incorrect syntax near '/MENTION'.

[JujiPoli]

The error come from elitepvpers Mentions..... Ask to the owner of the script to give you on pastebin.

[RebirthEpic]

Originally Posted by JujiPoli

Hello Shaiya,

Today I am releasing my custom scripts (sql)

All the scripts I'm releasing here are my ideas and written by me

What you need for the script to work correctly:

1- (won't work if you don't have it)


2- Go in PS_ChatLog -> Programmability -> Stored Procedures -> usp_Insert_Chat_Log_E click on modify

After this:

IF( LEN(@dd) = 1 )
BEGIN
SET @dd = '0' + @dd
END

Put this:



3- ([OPTIONAL] Needed for the notice to player)



1 - First script is a bad word filter,
How does it work? Every time a player says a bad word like "bitch"
it will give a warning to the player.
Once the player has received 3 warnings they will be kicked.

2 - Second script is a Transfer DP
How does it work? PM a player and say the amount to transfer (! Alex !transfer 1000)

3 - Third script is a Auto Notice spawner
How does it work? It will spawn a random notice selected via a table each 1 hour

4 - Fourth script is my custom ChatLog with the scripts ^


------------------- BAD WORD FILTER -------------------

 Bad Word Filter Script

1 - First we create a new table named Warning in PS_ChatLog

USE [PS_ChatLog]
GO

/****** Object:  Table [dbo].[Warning]    Script Date: 4/29/2017 14:51:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Warning](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[UserUID] [int] NOT NULL,
	[Warning] [int] NOT NULL
) ON [PRIMARY]

GO

2 - Now we will put the script in usp_Insert_Chat_Log_E
Put this after the insert of Chat Log:

The sentence: "Do not say bad words please" is an example, you can change the sentence to whatever you want

With the /ntplayer (notice to player):


With the /nt (public notice):

------------------- DP Transfer -------------------

 DP TRANSFER Script

1 - First we create a new table named Transfer in PS_ChatLog

USE [PS_ChatLog]
GO

/****** Object:  Table [dbo].[Transfer]    Script Date: 4/29/2017 18:35:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Transfer](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Charname] [varchar](max) NOT NULL,
	[TotalTransfer] [int] NOT NULL,
	[TransferName] [varchar](max) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

2 - Now we will put the script in usp_Insert_Chat_Log_E
Put this after the insert of Chat Log:

With the /ntplayer (notice to player):



With the /nt (public notice):

------------------- Auto Notice -------------------

 Auto Notice

1 - First we create a new table named Notice in PS_ChatLog



2 - Now we will put the script in usp_Insert_Chat_Log_E
Put this after the insert of Chat Log:



3 - Make it work Correctly
Open a New Query in SQL

-- Insert the date notice

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok, Date)
VALUES ('None', 0, GETDATE())

Now we will add 3 notice

-- Insert the notice

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok)
VALUES ('[AUTO] Hello 1', 0)

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok)
VALUES ('[AUTO] Hello 2', 0)

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok)
VALUES ('[AUTO] Hello 3', 0)

If you inserted with the "Hello 1 2 3"
Open the notice table and just dit the sentence
If you want to put more than 3 notices just edit the script

------------------- Custom Chat Log -------------------

 Custom Chat Log

1 - First we create the new table ChatLog in PS_ChatLog

WARNING : it will drop (delete) your old ChatLog table!

 Make sure you read the warning!

2 - Open a new query table and execute this:

------------------- Auto Notice -------------------
I Couldn't Do It Can You Help Me Out

[vovan681]

Originally Posted by JujiPoli

Hello Shaiya,

Today I am releasing my custom scripts (sql)

All the scripts I'm releasing here are my ideas and written by me

What you need for the script to work correctly:

1- (won't work if you don't have it)


2- Go in PS_ChatLog -> Programmability -> Stored Procedures -> usp_Insert_Chat_Log_E click on modify

After this:

IF( LEN(@dd) = 1 )
BEGIN
SET @dd = '0' + @dd
END

Put this:



3- ([OPTIONAL] Needed for the notice to player)



1 - First script is a bad word filter,
How does it work? Every time a player says a bad word like "bitch"
it will give a warning to the player.
Once the player has received 3 warnings they will be kicked.

2 - Second script is a Transfer DP
How does it work? PM a player and say the amount to transfer (! Alex !transfer 1000)

3 - Third script is a Auto Notice spawner
How does it work? It will spawn a random notice selected via a table each 1 hour

4 - Fourth script is my custom ChatLog with the scripts ^


------------------- BAD WORD FILTER -------------------

 Bad Word Filter Script

1 - First we create a new table named Warning in PS_ChatLog

USE [PS_ChatLog]
GO

/****** Object:  Table [dbo].[Warning]    Script Date: 4/29/2017 14:51:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Warning](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[UserUID] [int] NOT NULL,
	[Warning] [int] NOT NULL
) ON [PRIMARY]

GO

2 - Now we will put the script in usp_Insert_Chat_Log_E
Put this after the insert of Chat Log:

The sentence: "Do not say bad words please" is an example, you can change the sentence to whatever you want

With the /ntplayer (notice to player):


With the /nt (public notice):

------------------- DP Transfer -------------------

 DP TRANSFER Script

1 - First we create a new table named Transfer in PS_ChatLog

USE [PS_ChatLog]
GO

/****** Object:  Table [dbo].[Transfer]    Script Date: 4/29/2017 18:35:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Transfer](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Charname] [varchar](max) NOT NULL,
	[TotalTransfer] [int] NOT NULL,
	[TransferName] [varchar](max) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

2 - Now we will put the script in usp_Insert_Chat_Log_E
Put this after the insert of Chat Log:

With the /ntplayer (notice to player):



With the /nt (public notice):

------------------- Auto Notice -------------------

 Auto Notice

1 - First we create a new table named Notice in PS_ChatLog



2 - Now we will put the script in usp_Insert_Chat_Log_E
Put this after the insert of Chat Log:



3 - Make it work Correctly
Open a New Query in SQL

-- Insert the date notice

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok, Date)
VALUES ('None', 0, GETDATE())

Now we will add 3 notice

-- Insert the notice

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok)
VALUES ('[AUTO] Hello 1', 0)

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok)
VALUES ('[AUTO] Hello 2', 0)

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok)
VALUES ('[AUTO] Hello 3', 0)

If you inserted with the "Hello 1 2 3"
Open the notice table and just dit the sentence
If you want to put more than 3 notices just edit the script

------------------- Custom Chat Log -------------------

 Custom Chat Log

1 - First we create the new table ChatLog in PS_ChatLog

WARNING : it will drop (delete) your old ChatLog table!

 Make sure you read the warning!

2 - Open a new query table and execute this:

Hello, I ran into a problem. Instead of giving the player 3 warnings, I have one that speaks to the second immediately and the third that speaks and throws.

Screen shot by link

[Elessar2]

modified version but works fine

 Spoiler

DECLARE @ int

IF(@ChatData IN (Select BadWords From PS_GameDefs.dbo.BadWords))
BEGIN
IF (@ChatType = '1' or @ChatType = '4' or @ChatType = '5' or @ChatType = '6' or @ChatType = '7')
BEGIN
UPDATE PS_GameData.dbo.Chars SET Warning=Warning+1 WHERE CharID=@CharID
END

SET @ =(Select Warning From PS_GameData.dbo.Chars WHERE CharID=@CharID)

IF @ < 4)
BEGIN

DECLARE @Warning varchar(max),
@WarningMessage varchar(max)

SET @WarningMessage = 'do not write a bad words'

SET @Warning = N'/ntplayer;'+@CharName+';' @WarningMessage
EXEC [PS_Agent].[dbo].[Command]
@Name = N'ps_game',
@d = @Warning
END


IF @ > 3)
BEGIN

SET @=N'/kickcn '+@CharName
EXEC [PS_Agent].[dbo].[Command]
@Name = N'ps_game',
@d = @

UPDATE PS_GameData.dbo.Chars SET Warning =0 WHERE CharID=@CharID
END

END

 Spoiler

USE [PS_GameDefs]
GO

/****** Object: Table [dbo].[BadWords] Script Date: 17.08.2020 01:48:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BadWords](
[BadWords] [varchar](max) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

creating a table for dbo.chars only "warning"> int

[development021]

I really like to review nubness's posts, he was very humble and nub, now that he knows a lot of things, he doesn't help anyone and besides that it gets in the way of a big son of a ***** , didn't know anything, learned from developers, cried in their pm and now humiliates people who want to learn

sorry bad english

[vanthong132]

Originally Posted by development021

I really like to review nubness's posts, he was very humble and nub, now that he knows a lot of things, he doesn't help anyone and besides that it gets in the way of a big son of a ***** , didn't know anything, learned from developers, cried in their pm and now humiliates people who want to learn

sorry bad english

Give Up man !

[09061998]

 Spoiler

Originally Posted by development021

I really like to review nubness's posts, he was very humble and nub, now that he knows a lot of things, he doesn't help anyone and besides that it gets in the way of a big son of a ***** , didn't know anything, learned from developers, cried in their pm and now humiliates people who want to learn

sorry bad english

It's not that he doesn't want to help the community, it's that our REAL developers feel betrayed by the community and distance themselves.

Their work is taken for granted and scripts that cost a lot of money (since they require a lot of work) are sold by others, stolen or built into servers without giving credits to the creator.

OUR pathetic behavior as a community has led to the situation as it is. There is no need to insult Nubness, rather put yourself in his shoes and ask yourself : would you still care?

If anyone wants to learn these days, all they have to do is use elitepvpers' search function and they will find pretty much anything they need.