[Release] Alex scripts

Page 2 of 2

02/14/2019 07:11 edsonne2020#16

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'.

02/14/2019 16:31 JujiPoli#17

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

02/14/2019 18:45 RebirthEpic#18

Quote:
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- [Only registered and activated users can see links. Click Here To Register...] (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- [Only registered and activated users can see links. Click Here To Register...] ([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
Code:
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
Code:
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
Code:
-- Insert the date notice

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok, Date)
VALUES ('None', 0, GETDATE())
Now we will add 3 notice
Code:
-- 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

01/10/2020 13:15 vovan681#19

Quote:
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- [Only registered and activated users can see links. Click Here To Register...] (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- [Only registered and activated users can see links. Click Here To Register...] ([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
Code:
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
Code:
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
Code:
-- Insert the date notice

INSERT INTO PS_ChatLog.dbo.Notice
		(Notice, Ok, Date)
VALUES ('None', 0, GETDATE())
Now we will add 3 notice
Code:
-- 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 [Only registered and activated users can see links. Click Here To Register...]

08/17/2020 00:49 Elessar2#20

modified version but works fine

Spoiler

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

01/17/2022 16:14 development021#21

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 bitch , didn't know anything, learned from developers, cried in their pm and now humiliates people who want to learn

sorry bad english

01/18/2022 04:15 vanthong132#22

Quote:

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 bitch , 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 ! :feelsbadman:

04/06/2022 14:21 09061998#23

Spoiler

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.

Page 2 of 2