FlyffStorm CMS v1

Re: FlyffStorm CMS v1

Quote:

Originally Posted by axel0422

ok, I've try, but not create tables!!! .-.

I've this!!!

http://i35.tinypic.com/ix81w7.png

http://forum.ragezone.com/f457/get-w...-mssql-673301/

Re: FlyffStorm CMS v1

It Don't Work Too (I've yet do it, but I forgot the PHP 5.3.1 lol XD)

Re: FlyffStorm CMS v1

Quote:

Originally Posted by axel0422

It Don't Work Too (I've yet do it, but I forgot the PHP 5.3.1 lol XD)

Hum.... The problem is in the php.ini go there and take the ; from ;php_mssql or something

Re: FlyffStorm CMS v1

I must delete ; from ;exstension=php_mssql and ;exstension=php_pdo_mssql ?

Re: FlyffStorm CMS v1

I have the same problem as McSpeedy had but in my case the problem persisted for the "Notice: Use of undefined constant STORM_VER - assumed 'STORM_VER' in C:\wamp\www\config.php on line 15" error
Lol everything is working but that annoying thing persists how can I fix that crap?

---------- Post added at 06:58 PM ---------- Previous post was at 06:57 PM ----------

Quote:

Originally Posted by axel0422

I must delete ; from ;exstension=php_mssql and ;exstension=php_pdo_mssql ?

yes you must.

Re: FlyffStorm CMS v1

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've been trying to do this, It creates teh database but still doesn't work. I go to the install.php still says install the database

Re: FlyffStorm CMS v1

Quote:

Originally Posted by megsking2

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've been trying to do this, It creates teh database but still doesn't work. I go to the install.php still says install the database

Umm.. Copy this..

Quote:

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...
http://[your_host_here]/img/download_btn.png

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

Okay. Steps.

1) Make a new database manually named WEBSITE_DBF
2) New Query on WEBSITE_DBF
3) Copy/Paste
4) Execute
5) Common sense lead the way.
6) Thank if I helped ;>

Quote:

Originally Posted by axel0422

I must delete ; from ;exstension=php_mssql and ;exstension=php_pdo_mssql ?

Yeah, in your php.ini you have to remove the ";" from them.

Edit: My erros are like.. weird. I get

Quote:

Deprecated: Function eregi() is deprecated in C:\xampp\htdocs\inc\reload.php on line 199

and like, says my apache keeps crashing. Any help would be awesome. That quote if when trying to register.

For logout I get:

Quote:

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\inc\template\template.head.php:39) in C:\xampp\htdocs\inc\template\template.content.php on line 137

And for Login I get..

Quote:

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\inc\template\template.head.php:39) in C:\xampp\htdocs\inc\template\template.content.php on line 124

Thanks for any help in advance.

Re: FlyffStorm CMS v1

Code:

Deprecated: Function eregi() is deprecated in C:\xampp\htdocs\inc\reload.php on line 199

This is because the eregi function no longer works in the version of PHP you are running (5.3+). Storm v2 will not allow greater than 5.2.13 due to this.

Code:

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\inc\template\template.head.php:39) in C:\xampp\htdocs\inc\template\template.content.php on line 137

This and the other Warning for modifying headers are due to something in your PHP configuration. Why this happens, I don't know. I may make a Storm config for v2 so you can choose to use JavaScript redirects instead of PHP directs for those who get this error.

Re: FlyffStorm CMS v1

Quote:

Originally Posted by Treachery

Code:

Deprecated: Function eregi() is deprecated in C:\xampp\htdocs\inc\reload.php on line 199

This is because the eregi function no longer works in the version of PHP you are running (5.3+). Storm v2 will not allow greater than 5.2.13 due to this.

Code:

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\inc\template\template.head.php:39) in C:\xampp\htdocs\inc\template\template.content.php on line 137

This and the other Warning for modifying headers are due to something in your PHP configuration. Why this happens, I don't know. I may make a Storm config for v2 so you can choose to use JavaScript redirects instead of PHP directs for those who get this error.

Epic thanks, extra info about it. It logins in/out if you click on it twice ;P

Edit: Pretty elementary question, I searched around the files.. cant seem to setup the vote script, help would be appreciated =]

Re: FlyffStorm CMS v1

E_DEPRECATED is a distinct notice class about a potential _future_ problem. There are no problems with ereg in PHP 5.3 itself.

Deprecated notice can be cured with correct error reporting(:

Re: FlyffStorm CMS v1

Quote:

Originally Posted by Error 404

E_DEPRECATED is a distinct notice class about a potential _future_ problem. There are no problems with ereg in PHP 5.3 itself.

Deprecated notice can be cured with correct error reporting(:

You lost me ;)

Re: FlyffStorm CMS v1

You can edit the vote script in the Web Configuration area.

Re: FlyffStorm CMS v1

Awesome, and apache keeps coming up saying not responding or crashed or something the error report, but works after I press don't send. << LOl'ed =]

Re: FlyffStorm CMS v1

I've always had bad experiences with XAMPP.

Try WampServer2.0c or IIS if you can.

Re: FlyffStorm CMS v1

Quote:

Originally Posted by Treachery

I've always had bad experiences with XAMPP.

Try WampServer2.0c or IIS if you can.

Sweet, thanks. GOtta find that guide on how to setup Wamp with MSSQL =P

With WAMP I get..

Quote:

Notice: Use of undefined constant STORM_VER - assumed 'STORM_VER' in C:\wamp\www\config.php on line 15

'

Edit, fixed by removing idk if I should've, but I did. LOL.