FlyffStorm CMS v1

demz123 · Aug 22, 2010

does anyone know how to make the stop working apache..

to make it not stop....

Regardz...
demz123

x-ZeniRith · Aug 22, 2010

I guess v2 won't be up for us until later ? :tongue:
http://storm.flyffdev.co.cc//img/storm/background.png
Yes , direct from your site .

Code:

http://storm.flyffdev.co.cc/css/storm.css ?

megsking2 · Aug 22, 2010

Satan i did what you said still came up with this. oh btw I followed your guide on the patcher I'm going to pm you if thats ok because something came up with the fame.exe that wasn't in your guide.

Code:

Hey you said to pm you if we were having issues. I tried again with the code you provided. Got a new error message.

[CODE]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 102, Level 15, State 1, Procedure sp_createAccount, Line 13
Incorrect syntax near 'ame'.
Msg 102, Level 15, State 1, Procedure sp_createAccount, Line 15
Incorrect syntax near 'e'.
Msg 102, Level 15, State 1, Procedure sp_sendItem, Line 22
Incorrect syntax near 'er'.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
[/code]

dvd70 · Aug 22, 2010

megsking2 said:
didn't work for me still I get the same error message

In the top replace use [master] for use [WEBSITE_DBF] remember to create the database manually previously.

Treachery · Aug 22, 2010

x-ZeniRith said:
I guess v2 won't be up for us until later ? :tongue:

To view the content, you need to sign in or register

Yes , direct from your site .

Code:

http://storm.flyffdev.co.cc/css/storm.css ?

I still have a lot of work to do on it.
I need to finish the nav area, add page content, add some fixes to the vote script, then integrate the shop.

There might be more, but we'll see.

megsking2 · Aug 22, 2010

dvd70 said:
In the top replace use [master] for use [WEBSITE_DBF] remember to create the database manually previously.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

I did that, I tried with the sql in the file and the code that satan posted above. I run the query, it never stops. after 3 hours I stopped it gave me that error.

dvd70 · Aug 22, 2010

Treachery said:
I still have a lot of work to do on it.
I need to finish the nav area, add page content, add some fixes to the vote script, then integrate the shop.

There might be more, but we'll see.

Is there any way of creating a page in panel?

axel0422 · Aug 22, 2010

thanks dvd70, but i've another problem... when I put on WAMP server the PHP 5.3.1, the icon is yellow, but php_mssql is unactive and i cannot active it... why

plz help me T_T

Treachery · Aug 23, 2010

megsking2 said:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

I did that, I tried with the sql in the file and the code that satan posted above. I run the query, it never stops. after 3 hours I stopped it gave me that error.

Remove all of the ALTER DATABASE lines, too.

dvd70 said:
Is there any way of creating a page in panel?

As of right now, no. They may be in the future.

megsking2 · Aug 23, 2010

Treachery said:
Remove all of the ALTER DATABASE lines, too.
.

I get the feeling MSSQL is being stubborn

Code:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

demz123 · Aug 23, 2010

I dunno how fix this (Xampp: Apache stop working windows will find the solutions)

Treachery · Aug 23, 2010

megsking2 said:
I get the feeling MSSQL is being stubborn

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

It worked fine.

megsking2 · Aug 23, 2010

Treachery said:
It worked fine.

Then how come it doesn't work in either wamp, or Xamp?

megsking2 · Aug 23, 2010

I deleted the database I made, re-made it.

I put this code in

Code:

USE [WEBSITE_DBF]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'WEBSITE_DBF', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [WEBSITE_DBF].[dbo].[sp_fulltext_database] @action = 'enable'
end

IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_NEWS_TBL_m_szImage]') AND parent_object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]'))
Begin
ALTER TABLE [dbo].[NEWS_TBL] DROP CONSTRAINT [DF_NEWS_TBL_m_szImage]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_width]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_smiley_width]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_height]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_smiley_height]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_order]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_smiley_order]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_display_on_posting]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_display_on_posting]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nUrgency]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nUrgency]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nState]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nState]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nInformed]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nInformed]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nRead]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nRead]

End
GO
IF  EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nFromGM]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nFromGM]

End
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_Ticket]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_Ticket]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_updateConfig]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_updateConfig]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CONFIG_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[CONFIG_TBL]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VOTE_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[VOTE_TBL]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[NEWS_TBL]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PAGES_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[PAGES_TBL]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[TICKET_TBL]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[SMILEY_TBL]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_News]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_News]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_accountAuth]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_accountAuth]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_sendItem]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_sendItem]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_createAccount]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_createAccount]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_createAccount]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[sp_createAccount]
@account varchar(32),
@pw varchar(32),
@email varchar(100) = ''''
as
set nocount on
set xact_abort on

if not exists (select * from [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] where account = @account)
begin

	begin tran
	INSERT [ACCOUNT_DBF].dbo.[ACCOUNT_TBL](account,password,isuse,member,id_no1,id_no2,realname, cash)
	VALUES(@account, @pw, ''T'', ''A'', '''', '''', '''', ''0'')
	INSERT [ACCOUNT_DBF].dbo.[ACCOUNT_TBL_DETAIL](account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email)
	VALUES(@account,''A000'',''2'',''F'',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),''T'',NULL, @email)

	if @@error <> 0
	begin
		rollback tran
		select -1
	end
	else
	begin
		commit tran
		select 1
	end
end
else
begin
	select 0
end

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_sendItem]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Treachery>
-- Description:	<Send an item to a player in-game.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_sendItem]
	@m_idPlayer			char(7),
	@serverindex		char(2),
	@item_name			text,
	@item_count			int,
	@item_id			int,
	@m_idSender			char(7) = ''0000000''
AS
set nocount on
set xact_abort on

if exists (SELECT * FROM CHARACTER_01_DBF.dbo.CHARACTER_TBL WHERE m_idPlayer=@m_idPlayer AND serverindex=@serverindex AND isblock!=''D'')
begin

	begin tran
		INSERT [CHARACTER_01_DBF].dbo.[ITEM_SEND_TBL]
			(
				m_idPlayer,serverindex,Item_Name,Item_count,idSender,adwItemId0
			)
		VALUES
			(
				@m_idPlayer,@serverindex,@item_name,@item_count,@m_idSender,@item_id
			)

	if @@error <> 0
	begin
		rollback tran
		select -1
	end
	else
	begin
		commit tran
		select 1
	end
end
else
begin
	select 0
end' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_accountAuth]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[sp_accountAuth]
@account varchar(32),
@auth char(1) = ''F''
as
set nocount on
set xact_abort on

if exists (select * from [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] where account = @account)
begin

	begin tran
	UPDATE [ACCOUNT_DBF].dbo.[ACCOUNT_TBL_DETAIL] SET m_chLoginAuthority = @auth WHERE account = @account

	if @@error <> 0
	begin
		rollback tran
		select -1
	end
	else
	begin
		commit tran
		select 1
	end
end
else
begin
	select 0
end
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_News]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Treachery>
-- Description:	<Creates or deletes a news message.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_News]
	@iGu			CHAR(2) = ''S1'',
	@m_idNews		int		= ''0'',
	@title			text	= '''',
	@message		text	= '''',
	@image			text	= ''NULL'',
	@author			text	= ''Admin'',
	@timestamp		int		= ''0'',
	@uid			char(8)	= ''''

AS
BEGIN
	SET NOCOUNT ON;
	IF @iGu = ''S1'' -- Create news message
		BEGIN

		INSERT INTO [NEWS_TBL] ([m_szTitle],[m_szMessage], [m_szImage], [m_szAuthor], [m_nTimestamp], [m_szUID])
			VALUES (@title, @message, @image, @author, @timestamp, @uid)

		END
	ELSE
	IF @iGu = ''S2'' -- Delete news message
		IF EXISTS (SELECT * FROM NEWS_TBL WHERE m_idNews = @m_idNews)
		BEGIN

		DELETE FROM NEWS_TBL WHERE m_idNews = @m_idNews

		END
END
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SMILEY_TBL](
	[smiley_id] [int] NOT NULL,
	[code] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[emotion] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[smiley_url] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[smiley_width] [int] NOT NULL,
	[smiley_height] [int] NOT NULL,
	[smiley_order] [int] NOT NULL,
	[display_on_posting] [int] NOT NULL,
 CONSTRAINT [PK_SMILEY_TBL] PRIMARY KEY CLUSTERED 
(
	[smiley_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (1, N':D', N'Very Happy', N'icon_e_biggrin.gif', 15, 17, 1, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (2, N':-D', N'Very Happy', N'icon_e_biggrin.gif', 15, 17, 2, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (3, N':grin:', N'Very Happy', N'icon_e_biggrin.gif', 15, 17, 3, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (4, N':)', N'Smile', N'icon_e_smile.gif', 15, 17, 4, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (5, N':-)', N'Smile', N'icon_e_smile.gif', 15, 17, 5, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (6, N':smile:', N'Smile', N'icon_e_smile.gif', 15, 17, 6, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (7, N';)', N'Wink', N'icon_e_wink.gif', 15, 17, 7, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (8, N';-)', N'Wink', N'icon_e_wink.gif', 15, 17, 8, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (9, N':wink:', N'Wink', N'icon_e_wink.gif', 15, 17, 9, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (10, N':(', N'Sad', N'icon_e_sad.gif', 15, 17, 10, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (11, N':-(', N'Sad', N'icon_e_sad.gif', 15, 17, 11, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (12, N':sad:', N'Sad', N'icon_e_sad.gif', 15, 17, 12, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (13, N':o', N'Surprised', N'icon_e_surprised.gif', 15, 17, 13, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (14, N':-o', N'Surprised', N'icon_e_surprised.gif', 15, 17, 14, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (15, N':eek:', N'Surprised', N'icon_e_surprised.gif', 15, 17, 15, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (16, N':shock:', N'Shocked', N'icon_eek.gif', 15, 17, 16, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (17, N':?', N'Confused', N'icon_e_confused.gif', 15, 17, 17, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (18, N':-?', N'Confused', N'icon_e_confused.gif', 15, 17, 18, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (19, N':???:', N'Confused', N'icon_e_confused.gif', 15, 17, 19, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (20, N'8-)', N'Cool', N'icon_cool.gif', 15, 17, 20, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (21, N':cool:', N'Cool', N'icon_cool.gif', 15, 17, 21, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (22, N':lol:', N'Laughing', N'icon_lol.gif', 15, 17, 22, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (23, N':x', N'Mad', N'icon_mad.gif', 15, 17, 23, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (24, N':-x', N'Mad', N'icon_mad.gif', 15, 17, 24, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (25, N':mad:', N'Mad', N'icon_mad.gif', 15, 17, 25, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (26, N':P', N'Razz', N'icon_razz.gif', 15, 17, 26, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (27, N':-P', N'Razz', N'icon_razz.gif', 15, 17, 27, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (28, N':razz:', N'Razz', N'icon_razz.gif', 15, 17, 28, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (29, N':oops:', N'Embarrassed', N'icon_redface.gif', 15, 17, 29, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (30, N':cry:', N'Crying or Very Sad', N'icon_cry.gif', 15, 17, 30, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (31, N':evil:', N'Evil or Very Mad', N'icon_evil.gif', 15, 17, 31, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (32, N':twisted:', N'Twisted Evil', N'icon_twisted.gif', 15, 17, 32, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (33, N':roll:', N'Rolling Eyes', N'icon_rolleyes.gif', 15, 17, 33, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (34, N':!:', N'Exclamation', N'icon_exclaim.gif', 15, 17, 34, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (35, N':?:', N'Question', N'icon_question.gif', 15, 17, 35, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (36, N':idea:', N'Idea', N'icon_idea.gif', 15, 17, 36, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (37, N':arrow:', N'Arrow', N'icon_arrow.gif', 15, 17, 37, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (38, N':|', N'Neutral', N'icon_neutral.gif', 15, 17, 38, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (39, N':-|', N'Neutral', N'icon_neutral.gif', 15, 17, 39, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (40, N':mrgreen:', N'Mr. Green', N'icon_mrgreen.gif', 15, 17, 40, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (41, N':geek:', N'Geek', N'icon_e_geek.gif', 17, 17, 41, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (42, N':ugeek:', N'Uber Geek', N'icon_e_ugeek.gif', 17, 18, 42, 1)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TICKET_TBL](
	[m_idTicket] [varchar](8) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_account] [varchar](16) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szSubject] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_nUrgency] [int] NOT NULL,
	[m_szMessage] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_nState] [int] NOT NULL,
	[m_idReplyTo] [varchar](8) COLLATE Korean_Wansung_CI_AS NULL,
	[m_nTimestamp] [int] NOT NULL,
	[m_nInformed] [int] NOT NULL,
	[m_nRead] [int] NOT NULL,
	[m_nFromGM] [int] NOT NULL,
 CONSTRAINT [PK_TICKET_TBL] PRIMARY KEY CLUSTERED 
(
	[m_idTicket] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PAGES_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PAGES_TBL](
	[m_idPage] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szTitle] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_nNav] [int] NOT NULL,
	[m_szNav] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szPageBody] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_UID] [varchar](8) COLLATE Korean_Wansung_CI_AS NULL,
	[m_nEnabled] [int] NOT NULL,
	[m_nLink] [int] NULL,
	[m_szURL] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_idOrder] [int] NOT NULL,
 CONSTRAINT [PK_PAGES_TBL] PRIMARY KEY CLUSTERED 
(
	[m_idOrder] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
INSERT [dbo].[PAGES_TBL] ([m_idPage], [m_szTitle], [m_nNav], [m_szNav], [m_szPageBody], [m_UID], [m_nEnabled], [m_nLink], [m_szURL], [m_idOrder]) VALUES (N'events', N'{SERVER_NAME} :: Events', 1, N'Events', N'The website admin still has to set up the events page!

This page is a default page that comes with the website.
The website admin may delete this page if they would like, or they can keep it and list events that are going on here.

Thanks for using [b:3nb55gpc]FlyffStorm[/b:3nb55gpc]!', N'3nb55gpc', 1, NULL, NULL, 1)
INSERT [dbo].[PAGES_TBL] ([m_idPage], [m_szTitle], [m_nNav], [m_szNav], [m_szPageBody], [m_UID], [m_nEnabled], [m_nLink], [m_szURL], [m_idOrder]) VALUES (N'downloads', N'{SERVER_NAME} :: Downloads', 1, N'Downloads', N'The website admin still has to set up the downloads page!

This page is a default page that comes with the website.
The website admin should set this page up so players can download either a full client or just a patcher.

Thanks for using [b:1w8if934]FlyffStorm[/b:1w8if934]! 


Website admin notes:
You can put a download button image on this page by using the following code, but replacing [your_host_here] with your actual host...
[i]http://[your_host_here]/img/download_btn.png[/i]

There\’s other kinds of information you can list here, but this is mainly what you would need.', N'1w8if934', 1, NULL, NULL, 2)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[NEWS_TBL](
	[m_idNews] [int] IDENTITY(1,1) NOT NULL,
	[m_szTitle] [varchar](40) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szMessage] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szImage] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_szAuthor] [varchar](16) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_nTimestamp] [int] NOT NULL,
	[m_szUID] [char](8) COLLATE Korean_Wansung_CI_AS NOT NULL,
 CONSTRAINT [PK__NEWS_TBL__7D78A4E7] PRIMARY KEY CLUSTERED 
(
	[m_idNews] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VOTE_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[VOTE_TBL](
	[character] [varchar](16) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[ip] [varchar](15) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[time] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL
)
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CONFIG_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CONFIG_TBL](
	[m_szField] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szValue] [varchar](255) COLLATE Korean_Wansung_CI_AS NULL,
 CONSTRAINT [PK_CONFIG_TBL] PRIMARY KEY CLUSTERED 
(
	[m_szField] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_ban', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_item', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_news', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_support', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_account', N'ACCOUNT_DBF')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_character', N'CHARACTER_01_DBF')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_logging', N'LOGGING_01_DBF')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_salt', N'kikugalanet')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'forums_enabled', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'forums_nav', N'Forums')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'forums_url', N'http://')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_ban', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_item', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_news', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_support', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'index_nav', N'Home')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'index_title', N'{SERVER_NAME} :: Home')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'install_step', N'2')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'login_nav', N'Login')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'login_title', N'{SERVER_NAME} :: Login')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'logout_nav', N'Logout')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'panel_enabled', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'panel_nav', N'Panel')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'panel_title', N'{SERVER_NAME} :: Panel')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'rand_seed', N'3335dbd83aed7f6121c2a4285d3d45da')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_disclaimer', N'Please hereby recognize that the staff here at {SERVER_NAME} have full ownership over your account, characters, items, etc. and can and will confiscate any said virtual possessions with or without reason.')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_enabled', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_nav', N'Register')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_title', N'{SERVER_NAME} :: Register')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_accounts', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_admin', N'Z')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_characters', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_drop', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_exp', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_gm', N'O')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_ip', N'127.0.0.1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_name', N'FlyffStorm')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_online', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_peak', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_peak_en', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_penya', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_player', N'F')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_port', N'15400')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_slogan', N'The Fast and Easy Flyff Website!')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_status', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_time', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'smilies_allow', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'smilies_path', N'/img/smilies')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_enabled', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_image', N'http://')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_rcount', N'3000000')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_reward', N'penya')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_time', N'12')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_url', N'http://')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_admin', N'')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_footer', N'짤2010 {SERVER_NAME} :: {SERVER_SLOGAN}')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_newsmax', N'5')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_scheme', N'flyff')
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_updateConfig]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Treachery>
-- Description:	<Updates the website configuration settings.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_updateConfig]
	@m_szField varchar(50),
	@m_szValue varchar(255)
as
set nocount on
set xact_abort on

if exists (SELECT * FROM CONFIG_TBL WHERE m_szField = @m_szField)
begin

	begin tran
	UPDATE CONFIG_TBL SET m_szValue = @m_szValue WHERE m_szField = @m_szField

	if @@error <> 0
	begin
		rollback tran
		select -1
	end
	else
	begin
		commit tran
		select 1
	end
end
else
begin
	select 0
end
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_Ticket]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Treachery>
-- Description:	<Creates or replies to a suppport ticket.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_Ticket]
	@iGu			CHAR(2) = ''S1'',
	@m_idTicket		VARCHAR(8),
	@m_szSubject	TEXT	= '''',
	@m_nUrgency		INT		= ''2'',
	@m_szMessage	TEXT	= '''',
	@m_account		VARCHAR(16)	= '''',
	@m_nTimestamp	INT		= ''0'',
	@m_idReplyTo	VARCHAR(8)	= ''NULL'',
	@m_nFromGM		INT		= ''0''

AS
BEGIN
	SET NOCOUNT ON;
	IF @iGu = ''S1'' -- New ticket
		BEGIN

		INSERT INTO [TICKET_TBL] ([m_idTicket], [m_account],[m_szSubject], [m_nUrgency], [m_szMessage], [m_nTimestamp])
			VALUES (@m_idTicket, @m_account, @m_szSubject, @m_nUrgency, @m_szMessage, @m_nTimestamp)

		END
	ELSE
	IF @iGu = ''S2'' -- Respond to ticket
		IF EXISTS (SELECT * FROM TICKET_TBL WHERE m_idTicket = @m_idReplyTo)
		BEGIN

		INSERT INTO [TICKET_TBL] ([m_idTicket], [m_account],[m_szSubject], [m_nUrgency], [m_szMessage], [m_nTimestamp], [m_idReplyTo], [m_nFromGM])
		VALUES (@m_idTicket, @m_account, @m_szSubject, @m_nUrgency, @m_szMessage, @m_nTimestamp, @m_idReplyTo, @m_nFromGM)

		END
	ELSE
	IF @iGu = ''S3'' -- Delete ticket
		IF EXISTS (SELECT * FROM TICKET_TBL WHERE m_idTicket = @m_idTicket)
		BEGIN

		DELETE FROM TICKET_TBL WHERE m_idTicket = @m_idTicket OR m_idReplyTo = @m_idTicket

		END
END
' 
END
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_NEWS_TBL_m_szImage]') AND parent_object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]'))
Begin
ALTER TABLE [dbo].[NEWS_TBL] ADD  CONSTRAINT [DF_NEWS_TBL_m_szImage]  DEFAULT ('http://') FOR [m_szImage]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_width]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_smiley_width]  DEFAULT ((0)) FOR [smiley_width]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_height]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_smiley_height]  DEFAULT ((0)) FOR [smiley_height]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_order]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_smiley_order]  DEFAULT ((0)) FOR [smiley_order]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_display_on_posting]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_display_on_posting]  DEFAULT ((1)) FOR [display_on_posting]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nUrgency]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nUrgency]  DEFAULT ((2)) FOR [m_nUrgency]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nState]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nState]  DEFAULT ((1)) FOR [m_nState]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nInformed]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nInformed]  DEFAULT ((0)) FOR [m_nInformed]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nRead]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nRead]  DEFAULT ((0)) FOR [m_nRead]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nFromGM]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nFromGM]  DEFAULT ((0)) FOR [m_nFromGM]

End
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
USE [CHARACTER_01_DBF]
GO
ALTER PROCEDURE [dbo].[uspChangeMultiServer]
	@pserverindex   				CHAR(2) 			= '01',
	@pidPlayer   				CHAR(7) 				= '0000001',
	@pMultiServer   			INT 					= 0
AS
BEGIN
	SET NOCOUNT ON;

	UPDATE [CHARACTER_TBL] SET MultiServer = @pMultiServer WHERE m_idPlayer = @pidPlayer AND serverindex = @pserverindex
	RETURN
END

I got this message

Code:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

I get this on every browser,

I've tried deleting and re-installing Wamp, i uninstalled xamp.
Ive checked everything else I believe.

What am I doing wrong?

Satan · Aug 23, 2010

megsking2 said:
Then how come it doesn't work in either wamp, or Xamp?

That thingo, you posted, it worked. LOL. You no go to like... 127.0.0.1 << or 127.0.0.1/install.php
=x

wishly · Aug 23, 2010

tested its work in AppServ....

---------- Post added at 09:01 AM ---------- Previous post was at 09:00 AM ----------

when the v2 release? cuz im excited to see it...

axel0422 · Aug 23, 2010

HELP ME PLEASEE!!!! T_T SATAN, I've send you a PM! u.u

Treachery · Aug 23, 2010

Added some error troubleshooters to the original post.

@wishly: It should be coming as soon as I can get it done. School FTL.

Jelle · Aug 23, 2010

Some people are getting errors while executing the .sql,
First create WEBSITE_DBF and then execute this script:

USE [WEBSITE_DBF]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'WEBSITE_DBF', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [WEBSITE_DBF].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [WEBSITE_DBF] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET ANSI_NULLS OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET ANSI_PADDING OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET ARITHABORT OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [WEBSITE_DBF] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [WEBSITE_DBF] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [WEBSITE_DBF] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET ENABLE_BROKER
GO
ALTER DATABASE [WEBSITE_DBF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [WEBSITE_DBF] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [WEBSITE_DBF] SET READ_WRITE
GO
ALTER DATABASE [WEBSITE_DBF] SET RECOVERY SIMPLE
GO
ALTER DATABASE [WEBSITE_DBF] SET MULTI_USER
GO
ALTER DATABASE [WEBSITE_DBF] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [WEBSITE_DBF] SET DB_CHAINING OFF

IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_NEWS_TBL_m_szImage]') AND parent_object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]'))
Begin
ALTER TABLE [dbo].[NEWS_TBL] DROP CONSTRAINT [DF_NEWS_TBL_m_szImage]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_width]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_smiley_width]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_height]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_smiley_height]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_order]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_smiley_order]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_display_on_posting]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] DROP CONSTRAINT [DF_SMILEY_TBL_display_on_posting]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nUrgency]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nUrgency]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nState]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nState]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nInformed]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nInformed]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nRead]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nRead]

End
GO
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nFromGM]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] DROP CONSTRAINT [DF_TICKET_TBL_m_nFromGM]

End
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_Ticket]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_Ticket]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_updateConfig]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_updateConfig]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CONFIG_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[CONFIG_TBL]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VOTE_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[VOTE_TBL]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[NEWS_TBL]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PAGES_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[PAGES_TBL]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[TICKET_TBL]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]') AND type in (N'U'))
DROP TABLE [dbo].[SMILEY_TBL]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_News]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_News]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_accountAuth]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_accountAuth]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_sendItem]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_sendItem]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_createAccount]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_createAccount]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_createAccount]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[sp_createAccount]
@account varchar(32),
@pw varchar(32),
@email varchar(100) = ''''
as
set nocount on
set xact_abort on

if not exists (select * from [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] where account = @account)
begin

begin tran
INSERT [ACCOUNT_DBF].dbo.[ACCOUNT_TBL](account,password,isuse,member,id_no1,id_no2,realname, cash)
VALUES(@account, @pw, ''T'', ''A'', '''', '''', '''', ''0'')
INSERT [ACCOUNT_DBF].dbo.[ACCOUNT_TBL_DETAIL](account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email)
VALUES(@account,''A000'',''2'',''F'',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),''T'',NULL, @email)

if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_sendItem]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author: <Treachery>
-- Description: <Send an item to a player in-game.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_sendItem]
@m_idPlayer char(7),
@serverindex char(2),
@item_name text,
@item_count int,
@item_id int,
@m_idSender char(7) = ''0000000''
AS
set nocount on
set xact_abort on

if exists (SELECT * FROM CHARACTER_01_DBF.dbo.CHARACTER_TBL WHERE m_idPlayer=@m_idPlayer AND serverindex=@serverindex AND isblock!=''D'')
begin

begin tran
INSERT [CHARACTER_01_DBF].dbo.[ITEM_SEND_TBL]
(
m_idPlayer,serverindex,Item_Name,Item_count,idSender,adwItemId0
)
VALUES
(
@m_idPlayer,@serverindex,@item_name,@item_count,@m_idSender,@item_id
)

if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_accountAuth]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[sp_accountAuth]
@account varchar(32),
@auth char(1) = ''F''
as
set nocount on
set xact_abort on

if exists (select * from [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] where account = @account)
begin

begin tran
UPDATE [ACCOUNT_DBF].dbo.[ACCOUNT_TBL_DETAIL] SET m_chLoginAuthority = @auth WHERE account = @account

if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_News]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author: <Treachery>
-- Description: <Creates or deletes a news message.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_News]
@iGu CHAR(2) = ''S1'',
@m_idNews int = ''0'',
@title text = '''',
@message text = '''',
@image text = ''NULL'',
@author text = ''Admin'',
@timestamp int = ''0'',
@uid char(8) = ''''

AS
BEGIN
SET NOCOUNT ON;
IF @iGu = ''S1'' -- Create news message
BEGIN

INSERT INTO [NEWS_TBL] ([m_szTitle],[m_szMessage], [m_szImage], [m_szAuthor], [m_nTimestamp], [m_szUID])
VALUES (@title, @message, @image, @author, @timestamp, @uid)

END
ELSE
IF @iGu = ''S2'' -- Delete news message
IF EXISTS (SELECT * FROM NEWS_TBL WHERE m_idNews = @m_idNews)
BEGIN

DELETE FROM NEWS_TBL WHERE m_idNews = @m_idNews

END
END
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SMILEY_TBL](
[smiley_id] [int] NOT NULL,

Code:

 [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[emotion] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[smiley_url] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[smiley_width] [int] NOT NULL,
	[smiley_height] [int] NOT NULL,
	[smiley_order] [int] NOT NULL,
	[display_on_posting] [int] NOT NULL,
 CONSTRAINT [PK_SMILEY_TBL] PRIMARY KEY CLUSTERED 
(
	[smiley_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (1, N':D', N'Very Happy', N'icon_e_biggrin.gif', 15, 17, 1, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (2, N':-D', N'Very Happy', N'icon_e_biggrin.gif', 15, 17, 2, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (3, N':grin:', N'Very Happy', N'icon_e_biggrin.gif', 15, 17, 3, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (4, N':)', N'Smile', N'icon_e_smile.gif', 15, 17, 4, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (5, N':-)', N'Smile', N'icon_e_smile.gif', 15, 17, 5, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (6, N':smile:', N'Smile', N'icon_e_smile.gif', 15, 17, 6, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (7, N';)', N'Wink', N'icon_e_wink.gif', 15, 17, 7, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (8, N';-)', N'Wink', N'icon_e_wink.gif', 15, 17, 8, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (9, N':wink:', N'Wink', N'icon_e_wink.gif', 15, 17, 9, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (10, N':(', N'Sad', N'icon_e_sad.gif', 15, 17, 10, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (11, N':-(', N'Sad', N'icon_e_sad.gif', 15, 17, 11, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (12, N':sad:', N'Sad', N'icon_e_sad.gif', 15, 17, 12, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (13, N':o', N'Surprised', N'icon_e_surprised.gif', 15, 17, 13, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (14, N':-o', N'Surprised', N'icon_e_surprised.gif', 15, 17, 14, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (15, N':eek:', N'Surprised', N'icon_e_surprised.gif', 15, 17, 15, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (16, N':shock:', N'Shocked', N'icon_eek.gif', 15, 17, 16, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (17, N':?', N'Confused', N'icon_e_confused.gif', 15, 17, 17, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (18, N':-?', N'Confused', N'icon_e_confused.gif', 15, 17, 18, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (19, N':???:', N'Confused', N'icon_e_confused.gif', 15, 17, 19, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (20, N'8-)', N'Cool', N'icon_cool.gif', 15, 17, 20, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (21, N':cool:', N'Cool', N'icon_cool.gif', 15, 17, 21, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (22, N':lol:', N'Laughing', N'icon_lol.gif', 15, 17, 22, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (23, N':x', N'Mad', N'icon_mad.gif', 15, 17, 23, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (24, N':-x', N'Mad', N'icon_mad.gif', 15, 17, 24, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (25, N':mad:', N'Mad', N'icon_mad.gif', 15, 17, 25, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (26, N':P', N'Razz', N'icon_razz.gif', 15, 17, 26, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (27, N':-P', N'Razz', N'icon_razz.gif', 15, 17, 27, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (28, N':razz:', N'Razz', N'icon_razz.gif', 15, 17, 28, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (29, N':oops:', N'Embarrassed', N'icon_redface.gif', 15, 17, 29, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (30, N':cry:', N'Crying or Very Sad', N'icon_cry.gif', 15, 17, 30, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (31, N':evil:', N'Evil or Very Mad', N'icon_evil.gif', 15, 17, 31, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (32, N':twisted:', N'Twisted Evil', N'icon_twisted.gif', 15, 17, 32, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (33, N':roll:', N'Rolling Eyes', N'icon_rolleyes.gif', 15, 17, 33, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (34, N':!:', N'Exclamation', N'icon_exclaim.gif', 15, 17, 34, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (35, N':?:', N'Question', N'icon_question.gif', 15, 17, 35, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (36, N':idea:', N'Idea', N'icon_idea.gif', 15, 17, 36, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (37, N':arrow:', N'Arrow', N'icon_arrow.gif', 15, 17, 37, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (38, N':|', N'Neutral', N'icon_neutral.gif', 15, 17, 38, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (39, N':-|', N'Neutral', N'icon_neutral.gif', 15, 17, 39, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (40, N':mrgreen:', N'Mr. Green', N'icon_mrgreen.gif', 15, 17, 40, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (41, N':geek:', N'Geek', N'icon_e_geek.gif', 17, 17, 41, 1)
INSERT [dbo].[SMILEY_TBL] ([smiley_id], [code], [emotion], [smiley_url], [smiley_width], [smiley_height], [smiley_order], [display_on_posting]) VALUES (42, N':ugeek:', N'Uber Geek', N'icon_e_ugeek.gif', 17, 18, 42, 1)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TICKET_TBL](
	[m_idTicket] [varchar](8) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_account] [varchar](16) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szSubject] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_nUrgency] [int] NOT NULL,
	[m_szMessage] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_nState] [int] NOT NULL,
	[m_idReplyTo] [varchar](8) COLLATE Korean_Wansung_CI_AS NULL,
	[m_nTimestamp] [int] NOT NULL,
	[m_nInformed] [int] NOT NULL,
	[m_nRead] [int] NOT NULL,
	[m_nFromGM] [int] NOT NULL,
 CONSTRAINT [PK_TICKET_TBL] PRIMARY KEY CLUSTERED 
(
	[m_idTicket] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PAGES_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PAGES_TBL](
	[m_idPage] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szTitle] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_nNav] [int] NOT NULL,
	[m_szNav] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szPageBody] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_UID] [varchar](8) COLLATE Korean_Wansung_CI_AS NULL,
	[m_nEnabled] [int] NOT NULL,
	[m_nLink] [int] NULL,
	[m_szURL] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_idOrder] [int] NOT NULL,
 CONSTRAINT [PK_PAGES_TBL] PRIMARY KEY CLUSTERED 
(
	[m_idOrder] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
INSERT [dbo].[PAGES_TBL] ([m_idPage], [m_szTitle], [m_nNav], [m_szNav], [m_szPageBody], [m_UID], [m_nEnabled], [m_nLink], [m_szURL], [m_idOrder]) VALUES (N'events', N'{SERVER_NAME} :: Events', 1, N'Events', N'The website admin still has to set up the events page!

This page is a default page that comes with the website.
The website admin may delete this page if they would like, or they can keep it and list events that are going on here.

Thanks for using [b:3nb55gpc]FlyffStorm[/b:3nb55gpc]!', N'3nb55gpc', 1, NULL, NULL, 1)
INSERT [dbo].[PAGES_TBL] ([m_idPage], [m_szTitle], [m_nNav], [m_szNav], [m_szPageBody], [m_UID], [m_nEnabled], [m_nLink], [m_szURL], [m_idOrder]) VALUES (N'downloads', N'{SERVER_NAME} :: Downloads', 1, N'Downloads', N'The website admin still has to set up the downloads page!

This page is a default page that comes with the website.
The website admin should set this page up so players can download either a full client or just a patcher.

Thanks for using [b:1w8if934]FlyffStorm[/b:1w8if934]! 


Website admin notes:
You can put a download button image on this page by using the following code, but replacing [your_host_here] with your actual host...
[i]http://[your_host_here]/img/download_btn.png[/i]

There\’s other kinds of information you can list here, but this is mainly what you would need.', N'1w8if934', 1, NULL, NULL, 2)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[NEWS_TBL](
	[m_idNews] [int] IDENTITY(1,1) NOT NULL,
	[m_szTitle] [varchar](40) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szMessage] [text] COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szImage] [text] COLLATE Korean_Wansung_CI_AS NULL,
	[m_szAuthor] [varchar](16) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_nTimestamp] [int] NOT NULL,
	[m_szUID] [char](8) COLLATE Korean_Wansung_CI_AS NOT NULL,
 CONSTRAINT [PK__NEWS_TBL__7D78A4E7] PRIMARY KEY CLUSTERED 
(
	[m_idNews] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VOTE_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[VOTE_TBL](
	[character] [varchar](16) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[ip] [varchar](15) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[time] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL
)
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CONFIG_TBL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CONFIG_TBL](
	[m_szField] [varchar](50) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[m_szValue] [varchar](255) COLLATE Korean_Wansung_CI_AS NULL,
 CONSTRAINT [PK_CONFIG_TBL] PRIMARY KEY CLUSTERED 
(
	[m_szField] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_ban', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_item', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_news', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'admin_support', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_account', N'ACCOUNT_DBF')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_character', N'CHARACTER_01_DBF')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_logging', N'LOGGING_01_DBF')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'db_salt', N'kikugalanet')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'forums_enabled', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'forums_nav', N'Forums')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'forums_url', N'http://')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_ban', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_item', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_news', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'gm_support', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'index_nav', N'Home')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'index_title', N'{SERVER_NAME} :: Home')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'install_step', N'2')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'login_nav', N'Login')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'login_title', N'{SERVER_NAME} :: Login')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'logout_nav', N'Logout')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'panel_enabled', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'panel_nav', N'Panel')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'panel_title', N'{SERVER_NAME} :: Panel')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'rand_seed', N'3335dbd83aed7f6121c2a4285d3d45da')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_disclaimer', N'Please hereby recognize that the staff here at {SERVER_NAME} have full ownership over your account, characters, items, etc. and can and will confiscate any said virtual possessions with or without reason.')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_enabled', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_nav', N'Register')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'register_title', N'{SERVER_NAME} :: Register')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_accounts', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_admin', N'Z')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_characters', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_drop', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_exp', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_gm', N'O')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_ip', N'127.0.0.1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_name', N'FlyffStorm')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_online', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_peak', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_peak_en', N'0')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_penya', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_player', N'F')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_port', N'15400')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_slogan', N'The Fast and Easy Flyff Website!')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_status', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'server_time', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'smilies_allow', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'smilies_path', N'/img/smilies')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_enabled', N'1')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_image', N'http://')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_rcount', N'3000000')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_reward', N'penya')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_time', N'12')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'vote_url', N'http://')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_admin', N'')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_footer', N'짤2010 {SERVER_NAME} :: {SERVER_SLOGAN}')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_newsmax', N'5')
INSERT [dbo].[CONFIG_TBL] ([m_szField], [m_szValue]) VALUES (N'website_scheme', N'flyff')
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_updateConfig]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Treachery>
-- Description:	<Updates the website configuration settings.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_updateConfig]
	@m_szField varchar(50),
	@m_szValue varchar(255)
as
set nocount on
set xact_abort on

if exists (SELECT * FROM CONFIG_TBL WHERE m_szField = @m_szField)
begin

	begin tran
	UPDATE CONFIG_TBL SET m_szValue = @m_szValue WHERE m_szField = @m_szField

	if @@error <> 0
	begin
		rollback tran
		select -1
	end
	else
	begin
		commit tran
		select 1
	end
end
else
begin
	select 0
end
' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_Ticket]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author:		<Treachery>
-- Description:	<Creates or replies to a suppport ticket.>
-- =============================================
CREATE PROCEDURE [dbo].[sp_Ticket]
	@iGu			CHAR(2) = ''S1'',
	@m_idTicket		VARCHAR(8),
	@m_szSubject	TEXT	= '''',
	@m_nUrgency		INT		= ''2'',
	@m_szMessage	TEXT	= '''',
	@m_account		VARCHAR(16)	= '''',
	@m_nTimestamp	INT		= ''0'',
	@m_idReplyTo	VARCHAR(8)	= ''NULL'',
	@m_nFromGM		INT		= ''0''

AS
BEGIN
	SET NOCOUNT ON;
	IF @iGu = ''S1'' -- New ticket
		BEGIN

		INSERT INTO [TICKET_TBL] ([m_idTicket], [m_account],[m_szSubject], [m_nUrgency], [m_szMessage], [m_nTimestamp])
			VALUES (@m_idTicket, @m_account, @m_szSubject, @m_nUrgency, @m_szMessage, @m_nTimestamp)

		END
	ELSE
	IF @iGu = ''S2'' -- Respond to ticket
		IF EXISTS (SELECT * FROM TICKET_TBL WHERE m_idTicket = @m_idReplyTo)
		BEGIN

		INSERT INTO [TICKET_TBL] ([m_idTicket], [m_account],[m_szSubject], [m_nUrgency], [m_szMessage], [m_nTimestamp], [m_idReplyTo], [m_nFromGM])
		VALUES (@m_idTicket, @m_account, @m_szSubject, @m_nUrgency, @m_szMessage, @m_nTimestamp, @m_idReplyTo, @m_nFromGM)

		END
	ELSE
	IF @iGu = ''S3'' -- Delete ticket
		IF EXISTS (SELECT * FROM TICKET_TBL WHERE m_idTicket = @m_idTicket)
		BEGIN

		DELETE FROM TICKET_TBL WHERE m_idTicket = @m_idTicket OR m_idReplyTo = @m_idTicket

		END
END
' 
END
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_NEWS_TBL_m_szImage]') AND parent_object_id = OBJECT_ID(N'[dbo].[NEWS_TBL]'))
Begin
ALTER TABLE [dbo].[NEWS_TBL] ADD  CONSTRAINT [DF_NEWS_TBL_m_szImage]  DEFAULT ('http://') FOR [m_szImage]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_width]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_smiley_width]  DEFAULT ((0)) FOR [smiley_width]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_height]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_smiley_height]  DEFAULT ((0)) FOR [smiley_height]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_smiley_order]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_smiley_order]  DEFAULT ((0)) FOR [smiley_order]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_SMILEY_TBL_display_on_posting]') AND parent_object_id = OBJECT_ID(N'[dbo].[SMILEY_TBL]'))
Begin
ALTER TABLE [dbo].[SMILEY_TBL] ADD  CONSTRAINT [DF_SMILEY_TBL_display_on_posting]  DEFAULT ((1)) FOR [display_on_posting]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nUrgency]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nUrgency]  DEFAULT ((2)) FOR [m_nUrgency]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nState]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nState]  DEFAULT ((1)) FOR [m_nState]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nInformed]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nInformed]  DEFAULT ((0)) FOR [m_nInformed]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nRead]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nRead]  DEFAULT ((0)) FOR [m_nRead]

End
GO
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_TICKET_TBL_m_nFromGM]') AND parent_object_id = OBJECT_ID(N'[dbo].[TICKET_TBL]'))
Begin
ALTER TABLE [dbo].[TICKET_TBL] ADD  CONSTRAINT [DF_TICKET_TBL_m_nFromGM]  DEFAULT ((0)) FOR [m_nFromGM]

End
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
USE [CHARACTER_01_DBF]
GO
ALTER PROCEDURE [dbo].[uspChangeMultiServer]
	@pserverindex   				CHAR(2) 			= '01',
	@pidPlayer   				CHAR(7) 				= '0000001',
	@pMultiServer   			INT 					= 0
AS
BEGIN
	SET NOCOUNT ON;

	UPDATE [CHARACTER_TBL] SET MultiServer = @pMultiServer WHERE m_idPlayer = @pidPlayer AND serverindex = @pserverindex
	RETURN
END
[/SPOILER]

Worked for me :O

Jelle · Aug 23, 2010

Oops, double posted because my browser was acting douchy :O Sorry.

FlyffStorm CMS v1

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Junior Spellweaver

Experienced Elementalist

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Skilled Illusionist

Experienced Elementalist

Newbie Spellweaver

Newbie Spellweaver

Attachments

Experienced Elementalist

Socius Decennalis

Newbie Spellweaver

Experienced Elementalist

the sound's resound echo

the sound's resound echo

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners