Auto Notice!

[[PH]KEO(DEV)]

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

Thanks in advance!

[[GM]-RazoR-*]

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

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

If you want to make it free.




Example;

/notice 10 "test message

10 second

/notice 15 "test message2

15 second

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

[[PH]KEO(DEV)]

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

[RebirthEpic]

Developers Can Help As Much As Possible
It's Bad To Sell An Existing File

[[PH]KEO(DEV)]

Originally Posted by RebirthEpic

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

[RebirthEpic]

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

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

[[GM]-RazoR-*]

Originally Posted by RebirthEpic

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.

[SnickQ]

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]
@ID int,
@ varchar(18),
@Password varchar(32),
@DelCharPwd varchar(50)
AS

Declare
@Counts int

BEGIN

--SET NOCOUNT OFF;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ )
BEGIN
Update GameAccountTBL Set OneTimePassword = @Password , OTPExpireDate = DATEADD(mi, 10, getdate()),DelCharPwd=@DelCharPwd Where GameAccount @;
SET @Counts = @@ROWCOUNT;

IF NOT EXISTS(Select * From PS_UserData.dbo.Users_Master with (nolock) Where UserUID @ID)
BEGIN
SET @Password = Right @Password + 'gg' ,18);
exec PS_UserData.dbo.usp_Optisp_Create_ShaiyaAccount_Ta iwan @ID @ @Password
END

Return @Counts
END
ELSE
BEGIN
Insert Into GameAccountTBL (UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPwd)
Values @ID @ @Password,DATEADD(mi, 10, getdate()),@DelCharPwd)

SET @Counts = @@ROWCOUNT;

IF NOT EXISTS(Select * From PS_UserData.dbo.Users_Master with (nolock) Where UserUID @ID)
BEGIN
SET @Password = Right @Password + 'gg' ,18);
exec PS_UserData.dbo.usp_Optisp_Create_ShaiyaAccount_Ta iwan @ID @ @Password
END

Return @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 ******/



-- =============================
-- @_Success : 1-Success , 0-Fail
-- =============================

CREATE PROCEDURE [dbo].[sp_OmgLoginSuccessCheck]
@ varchar(18),
@Password varchar(32),
@_Success int OUTPUT
AS

BEGIN

SET NOCOUNT ON;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ And OneTimePassword @Password And OTPExpireDate >= getdate())
BEGIN
--Login Success
SET @_Success = 1
END
ELSE
BEGIN
--Login Fail
SET @_Success = 0
END
RETURN @_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 ******/



-- =============================
-- @_Success : 1-Success , 0-Fail
-- =============================

CREATE PROCEDURE [dbo].[sp_OmgDelCharNameSuccessCheck]
@ varchar(18),
@DelCharPWD varchar(50),
@_Success int OUTPUT
AS

BEGIN

SET NOCOUNT ON;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ And DelCharPWD=@DelCharPWD )
BEGIN
--Delete Password Check Success
SET @_Success = 1
END
ELSE
BEGIN
--Delete Password Check Fail
SET @_Success = 0
END
RETURN @_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]
@ID int,
@ varchar(18),
@Password varchar(32),
@DelCharPwd varchar(50)

AS

Declare
@Counts int

BEGIN
--SET NOCOUNT OFF;

IF NOT EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ )
BEGIN
Insert Into GameAccountTBL (UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPwd)
Values @ID @ @Password,'2050/1/1',@DelCharPwd)

SET @Counts = @@ROWCOUNT;

SET @Password = Right @Password + 'gyyg' ,18);

Return @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

[[PH]KEO(DEV)]

Originally Posted by SnickQ

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]
@ID int,
@ varchar(18),
@Password varchar(32),
@DelCharPwd varchar(50)
AS

Declare
@Counts int

BEGIN

--SET NOCOUNT OFF;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ )
BEGIN
Update GameAccountTBL Set OneTimePassword = @Password , OTPExpireDate = DATEADD(mi, 10, getdate()),DelCharPwd=@DelCharPwd Where GameAccount @;
SET @Counts = @@ROWCOUNT;

IF NOT EXISTS(Select * From PS_UserData.dbo.Users_Master with (nolock) Where UserUID @ID)
BEGIN
SET @Password = Right @Password + 'gg' ,18);
exec PS_UserData.dbo.usp_Optisp_Create_ShaiyaAccount_Ta iwan @ID @ @Password
END

Return @Counts
END
ELSE
BEGIN
Insert Into GameAccountTBL (UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPwd)
Values @ID @ @Password,DATEADD(mi, 10, getdate()),@DelCharPwd)

SET @Counts = @@ROWCOUNT;

IF NOT EXISTS(Select * From PS_UserData.dbo.Users_Master with (nolock) Where UserUID @ID)
BEGIN
SET @Password = Right @Password + 'gg' ,18);
exec PS_UserData.dbo.usp_Optisp_Create_ShaiyaAccount_Ta iwan @ID @ @Password
END

Return @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 ******/



-- =============================
-- @_Success : 1-Success , 0-Fail
-- =============================

CREATE PROCEDURE [dbo].[sp_OmgLoginSuccessCheck]
@ varchar(18),
@Password varchar(32),
@_Success int OUTPUT
AS

BEGIN

SET NOCOUNT ON;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ And OneTimePassword @Password And OTPExpireDate >= getdate())
BEGIN
--Login Success
SET @_Success = 1
END
ELSE
BEGIN
--Login Fail
SET @_Success = 0
END
RETURN @_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 ******/



-- =============================
-- @_Success : 1-Success , 0-Fail
-- =============================

CREATE PROCEDURE [dbo].[sp_OmgDelCharNameSuccessCheck]
@ varchar(18),
@DelCharPWD varchar(50),
@_Success int OUTPUT
AS

BEGIN

SET NOCOUNT ON;

IF EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ And DelCharPWD=@DelCharPWD )
BEGIN
--Delete Password Check Success
SET @_Success = 1
END
ELSE
BEGIN
--Delete Password Check Fail
SET @_Success = 0
END
RETURN @_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]
@ID int,
@ varchar(18),
@Password varchar(32),
@DelCharPwd varchar(50)

AS

Declare
@Counts int

BEGIN
--SET NOCOUNT OFF;

IF NOT EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount @ )
BEGIN
Insert Into GameAccountTBL (UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPwd)
Values @ID @ @Password,'2050/1/1',@DelCharPwd)

SET @Counts = @@ROWCOUNT;

SET @Password = Right @Password + 'gyyg' ,18);

Return @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

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

[[GM]-RazoR-*]

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:

Download;

[[PH]KEO(DEV)]

Originally Posted by [GM]-RazoR-*

Virüs Total:

Download;

can't attach on SQL 2008 R2 sir

[SnickQ]

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.

[arjulie]

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.

[[MXD]Takeshi]

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