Auto Notice!

02/13/2019 09:47 [PH]KEO(DEV)#1

Hi epvp! anyone can guide me how to make auto notice?
example Welcome notice.

Thanks in advance!

02/13/2019 10:00 [GM]-RazoR-*#2

I'm selling a program for automatic notice.
If you want to get this, type Skype.

--------------------------------------------------

If you want to make it free.

[Only registered and activated users can see links. Click Here To Register...]

Example;

/notice 10 "test message

10 second

/notice 15 "test message2

15 second

02/13/2019 10:04 XareL#3

if you wanna make like welcome or etc.. notices , first you need the sql guide.
And then you can easily make the kind of notices you want.

02/13/2019 10:37 [PH]KEO(DEV)#4

Quote:

Originally Posted by XareL

if you wanna make like welcome or etc.. notices , first you need the sql guide.
And then you can easily make the kind of notices you want.

yes sir! and i see Server Extended by trayne but its hard to understand for me :(
that's why im asking if someone can guide me how to setup properly ..

02/13/2019 11:23 RebirthEpic#5

[Only registered and activated users can see links. Click Here To Register...]
Developers Can Help As Much As Possible
It's Bad To Sell An Existing File

02/13/2019 11:31 [PH]KEO(DEV)#6

Quote:

Originally Posted by RebirthEpic

[Only registered and activated users can see links. Click Here To Register...]
Developers Can Help As Much As Possible
It's Bad To Sell An Existing File

Yes sir. i see that too but i dont have OMG_GameWEB on my db so i can't run this
[Only registered and activated users can see links. Click Here To Register...]

02/13/2019 11:42 RebirthEpic#7

Quote:

Originally Posted by [PH]KEO(DEV)

Yes sir. i see that too but i dont have OMG_GameWEB on my db so i can't run this
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

Restart The Setup File
Missing Database Will Exit
You can add SQL and continue editing from where you left off

02/13/2019 15:21 [GM]-RazoR-*#8

Quote:

Originally Posted by RebirthEpic

[Only registered and activated users can see links. Click Here To Register...]
Developers Can Help As Much As Possible
It's Bad To Sell An Existing File

Don't comment unless you know what I'm selling.

It's a program I sell. SQL is not a linked system. It's the automatic notice that the guy upstairs says. It's not a welcome message. The program that I sell is simple, functional, and you can add any announcement you want. You can also add time to it and stop it at any time.

02/13/2019 15:46 SnickQ#9

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

Or:

Spoiler

02/13/2019 16:00 [PH]KEO(DEV)#10

Quote:

Originally Posted by SnickQ

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

Or:

Spoiler

USE [master]
GO
/****** Object: Database [OMG_GameWEB] Script Date: 02/13/2019 15:33:55 ******/
CREATE DATABASE [OMG_GameWEB] ON PRIMARY
( NAME = N'OMG_GameWeb_Data', FILENAME = N'C:\ShaiyaServer\OMG_GameWeb_Data.MDF' , SIZE = 1792KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'OMG_GameWeb_Log', FILENAME = N'C:\ShaiyaServer\OMG_GameWeb_Log.LDF' , SIZE = 2816KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
ALTER DATABASE [OMG_GameWEB] SET COMPATIBILITY_LEVEL = 80
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [OMG_GameWEB].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [OMG_GameWEB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [OMG_GameWEB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [OMG_GameWEB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [OMG_GameWEB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [OMG_GameWEB] SET ARITHABORT OFF
GO
ALTER DATABASE [OMG_GameWEB] SET AUTO_CLOSE ON
GO
ALTER DATABASE [OMG_GameWEB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [OMG_GameWEB] SET AUTO_SHRINK ON
GO
ALTER DATABASE [OMG_GameWEB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [OMG_GameWEB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [OMG_GameWEB] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [OMG_GameWEB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [OMG_GameWEB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [OMG_GameWEB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [OMG_GameWEB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [OMG_GameWEB] SET ENABLE_BROKER
GO
ALTER DATABASE [OMG_GameWEB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [OMG_GameWEB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [OMG_GameWEB] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [OMG_GameWEB] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [OMG_GameWEB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [OMG_GameWEB] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [OMG_GameWEB] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [OMG_GameWEB] SET READ_WRITE
GO
ALTER DATABASE [OMG_GameWEB] SET RECOVERY SIMPLE
GO
ALTER DATABASE [OMG_GameWEB] SET MULTI_USER
GO
ALTER DATABASE [OMG_GameWEB] SET PAGE_VERIFY TORN_PAGE_DETECTION
GO
ALTER DATABASE [OMG_GameWEB] SET DB_CHAINING OFF
GO
USE [OMG_GameWEB]
GO
/****** Object: Table [dbo].[GameAccountTBL] Script Date: 02/13/2019 15:33:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GameAccountTBL](
[UserUID] [int] NOT NULL,
[GameAccount] [varchar](18) NOT NULL,
[OneTimePassword] [varchar](32) NOT NULL,
[OTPExpireDate] [datetime] NOT NULL,
[DelCharPWD] [varchar](50) NOT NULL,
[CreateDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[sp_UpdateGameAccount] Script Date: 02/13/2019 15:34:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.sp_UpdateGameAccount Script Date: 2008-6-7 18:29:10 ******/

CREATE PROCEDURE [dbo].[sp_UpdateGameAccount]
@[Only registered and activated users can see links. Click Here To Register...]ID int,
@[Only registered and activated users can see links. Click Here To Register...] varchar(18),
@[Only registered and activated users can see links. Click Here To Register...]Password varchar(32),
@DelCharPwd varchar(50)
AS

Declare
@[Only registered and activated users can see links. Click Here To Register...]Counts int

BEGIN

--SET NOCOUNT OFF;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @[Only registered and activated users can see links. Click Here To Register...] )
BEGIN
Update GameAccountTBL Set OneTimePassword = @[Only registered and activated users can see links. Click Here To Register...]Password , OTPExpireDate = DATEADD(mi, 10, getdate()),DelCharPwd=@DelCharPwd Where GameAccount @[Only registered and activated users can see links. Click Here To Register...];
SET @[Only registered and activated users can see links. Click Here To Register...]Counts = @@ROWCOUNT;

IF NOT EXISTS(Select * From PS_UserData.dbo.Users_Master with (nolock) Where UserUID @[Only registered and activated users can see links. Click Here To Register...]ID)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...]Password = Right @[Only registered and activated users can see links. Click Here To Register...]Password + 'gg' ,18);
exec PS_UserData.dbo.usp_Optisp_Create_ShaiyaAccount_Ta iwan @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]Password
END

Return @[Only registered and activated users can see links. Click Here To Register...]Counts
END
ELSE
BEGIN
Insert Into GameAccountTBL (UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPwd)
Values @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]Password,DATEADD(mi, 10, getdate()),@DelCharPwd)

SET @[Only registered and activated users can see links. Click Here To Register...]Counts = @@ROWCOUNT;

IF NOT EXISTS(Select * From PS_UserData.dbo.Users_Master with (nolock) Where UserUID @[Only registered and activated users can see links. Click Here To Register...]ID)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...]Password = Right @[Only registered and activated users can see links. Click Here To Register...]Password + 'gg' ,18);
exec PS_UserData.dbo.usp_Optisp_Create_ShaiyaAccount_Ta iwan @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]Password
END

Return @[Only registered and activated users can see links. Click Here To Register...]Counts
END

END
GO
/****** Object: StoredProcedure [dbo].[sp_OmgLoginSuccessCheck] Script Date: 02/13/2019 15:34:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.sp_OmgLoginSuccessCheck Script Date: 2008-6-7 18:29:10 ******/

-- =============================
-- @[Only registered and activated users can see links. Click Here To Register...]_Success : 1-Success , 0-Fail
-- =============================

CREATE PROCEDURE [dbo].[sp_OmgLoginSuccessCheck]
@[Only registered and activated users can see links. Click Here To Register...] varchar(18),
@[Only registered and activated users can see links. Click Here To Register...]Password varchar(32),
@[Only registered and activated users can see links. Click Here To Register...]_Success int OUTPUT
AS

BEGIN

SET NOCOUNT ON;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @[Only registered and activated users can see links. Click Here To Register...] And OneTimePassword @[Only registered and activated users can see links. Click Here To Register...]Password And OTPExpireDate >= getdate())
BEGIN
--Login Success
SET @[Only registered and activated users can see links. Click Here To Register...]_Success = 1
END
ELSE
BEGIN
--Login Fail
SET @[Only registered and activated users can see links. Click Here To Register...]_Success = 0
END
RETURN @[Only registered and activated users can see links. Click Here To Register...]_Success

END
GO
/****** Object: StoredProcedure [dbo].[sp_OmgDelCharNameSuccessCheck] Script Date: 02/13/2019 15:34:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.sp_OmgDelCharNameSuccessCheck Script Date: 2008-6-7 18:29:10 ******/

-- =============================
-- @[Only registered and activated users can see links. Click Here To Register...]_Success : 1-Success , 0-Fail
-- =============================

CREATE PROCEDURE [dbo].[sp_OmgDelCharNameSuccessCheck]
@[Only registered and activated users can see links. Click Here To Register...] varchar(18),
@DelCharPWD varchar(50),
@[Only registered and activated users can see links. Click Here To Register...]_Success int OUTPUT
AS

BEGIN

SET NOCOUNT ON;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @[Only registered and activated users can see links. Click Here To Register...] And DelCharPWD=@DelCharPWD )
BEGIN
--Delete Password Check Success
SET @[Only registered and activated users can see links. Click Here To Register...]_Success = 1
END
ELSE
BEGIN
--Delete Password Check Fail
SET @[Only registered and activated users can see links. Click Here To Register...]_Success = 0
END
RETURN @[Only registered and activated users can see links. Click Here To Register...]_Success

END
GO
/****** Object: StoredProcedure [dbo].[sp_CreateOmgGMGameAccount] Script Date: 02/13/2019 15:34:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.sp_CreateOmgGMGameAccount Script Date: 2008-6-7 18:29:10 ******/
CREATE PROCEDURE [dbo].[sp_CreateOmgGMGameAccount]
@[Only registered and activated users can see links. Click Here To Register...]ID int,
@[Only registered and activated users can see links. Click Here To Register...] varchar(18),
@[Only registered and activated users can see links. Click Here To Register...]Password varchar(32),
@DelCharPwd varchar(50)

AS

Declare
@[Only registered and activated users can see links. Click Here To Register...]Counts int

BEGIN
--SET NOCOUNT OFF;

IF NOT EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @[Only registered and activated users can see links. Click Here To Register...] )
BEGIN
Insert Into GameAccountTBL (UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPwd)
Values @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]Password,'2050/1/1',@DelCharPwd)

SET @[Only registered and activated users can see links. Click Here To Register...]Counts = @@ROWCOUNT;

SET @[Only registered and activated users can see links. Click Here To Register...]Password = Right @[Only registered and activated users can see links. Click Here To Register...]Password + 'gyyg' ,18);

Return @[Only registered and activated users can see links. Click Here To Register...]Counts
END

END
GO
/****** Object: Default [DF_GameAccountTBL_CreateDate] Script Date: 02/13/2019 15:33:58 ******/
ALTER TABLE [dbo].[GameAccountTBL] ADD CONSTRAINT [DF_GameAccountTBL_CreateDate] DEFAULT (getdate()) FOR [CreateDate]
GO

Thanks but when i query i get this error

Spoiler

02/13/2019 16:42 [GM]-RazoR-*#11

Quote:

Originally Posted by [PH]KEO(DEV)

Thanks but when i query i get this error

Spoiler

Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 22
Incorrect syntax near '@gameaccount'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 24
Incorrect syntax near '@gameaccount'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 27
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 29
Incorrect syntax near '@onetimePassword'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 30
Incorrect syntax near '@UserUID'.
Msg 156, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 35
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 38
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 42
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 44
Incorrect syntax near '@onetimePassword'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 45
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_OmgLoginSuccessCheck, Line 19
Incorrect syntax near '@gameaccount'.
Msg 156, Level 15, State 1, Procedure sp_OmgLoginSuccessCheck, Line 24
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure sp_OmgDelCharNameSuccessCheck, Line 19
Incorrect syntax near '@gameaccount'.
Msg 156, Level 15, State 1, Procedure sp_OmgDelCharNameSuccessCheck, Line 24
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure sp_CreateOmgGMGameAccount, Line 16
Incorrect syntax near '@gameaccount'.
Msg 102, Level 15, State 1, Procedure sp_CreateOmgGMGameAccount, Line 19
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_CreateOmgGMGameAccount, Line 23
Incorrect syntax near '@onetimePassword'.

Vir�s Total: [Only registered and activated users can see links. Click Here To Register...]

Download;

02/13/2019 17:13 [PH]KEO(DEV)#12

Quote:

Originally Posted by [GM]-RazoR-*

Vir�s Total: [Only registered and activated users can see links. Click Here To Register...]

Download;

can't attach on SQL 2008 R2 sir

02/13/2019 17:25 SnickQ#13

Quote:

Originally Posted by [PH]KEO(DEV)

Thanks but when i query i get this error

Spoiler

Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 22
Incorrect syntax near '@gameaccount'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 24
Incorrect syntax near '@gameaccount'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 27
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 29
Incorrect syntax near '@onetimePassword'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 30
Incorrect syntax near '@UserUID'.
Msg 156, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 35
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 38
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 42
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 44
Incorrect syntax near '@onetimePassword'.
Msg 102, Level 15, State 1, Procedure sp_UpdateGameAccount, Line 45
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_OmgLoginSuccessCheck, Line 19
Incorrect syntax near '@gameaccount'.
Msg 156, Level 15, State 1, Procedure sp_OmgLoginSuccessCheck, Line 24
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure sp_OmgDelCharNameSuccessCheck, Line 19
Incorrect syntax near '@gameaccount'.
Msg 156, Level 15, State 1, Procedure sp_OmgDelCharNameSuccessCheck, Line 24
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure sp_CreateOmgGMGameAccount, Line 16
Incorrect syntax near '@gameaccount'.
Msg 102, Level 15, State 1, Procedure sp_CreateOmgGMGameAccount, Line 19
Incorrect syntax near '@UserUID'.
Msg 102, Level 15, State 1, Procedure sp_CreateOmgGMGameAccount, Line 23
Incorrect syntax near '@onetimePassword'.

Then why you did not follow instructions from screen? xD
That is sooooooo easy:
Step 1 click on "database" then "new database then name it OMG_GameWEB
That all.

02/13/2019 19:03 arjulie#14

u know guys they will sale this script to their client if they learn this. so stop making tutorial if already have much better give the old tutorial and try them to understand the tutorial to be them good developer. give them a time to understand not always you give privilege. shaiya community going down and down.

sorry for my bad english.

02/13/2019 20:41 [MXD]Takeshi#15

why post a database ???

not is necessary run the script "Call PSMagent Commands via sql" in omg, you can attach it in every database, need only change the database use o.o

then you can see many script here, and try to understand for make your own script with the necessary command etc....

not is so hard, so, in 5-10mins this will do done, fell free to contact me on skype, i can show you HOW do it, and a bit of help if necessary...