[Release] Alex scripts

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 View Post
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 -------------------


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


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


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



------------------- Auto Notice -------------------
I Couldn't Do It Can You Help Me Out
01/10/2020 13:15 vovan681#19
Quote:
Originally Posted by JujiPoli View Post
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 -------------------


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


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


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

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




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 View Post
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

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.