I dunno how fix this (Xampp: Apache stop working windows will find the solutions)
Printable View
I dunno how fix this (Xampp: Apache stop working windows will find the solutions)
It worked fine.Quote:
Originally Posted by megsking2
Quote:
Originally Posted by Treachery
Then how come it doesn't work in either wamp, or Xamp?
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],I got this messageCode:, [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
I get this on every browser,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 tried deleting and re-installing Wamp, i uninstalled xamp.
Ive checked everything else I believe.
What am I doing wrong?
That thingo, you posted, it worked. LOL. You no go to like... 127.0.0.1 << or 127.0.0.1/install.phpQuote:
Originally Posted by megsking2
=x
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...
HELP ME PLEASEE!!!! T_T SATAN, I've send you a PM! u.u
Added some error troubleshooters to the original post.
@wishly: It should be coming as soon as I can get it done. School FTL.
Some people are getting errors while executing the .sql,
First create WEBSITE_DBF and then execute this script:
Spoiler:
Worked for me :O
Oops, double posted because my browser was acting douchy :O Sorry.
Thanks a lot. I really wanted to use this program when I saw it looked good.
The only snag I've come across is there appears to code or error messages all over the pages is there a way to fix this?
I Cannot because there are some errors!! T_T Please U.u
Code:Esecuzione DBCC completata. Se sono stati visualizzati messaggi di errore DBCC, rivolgersi all'amministratore di sistema.
Messaggio 102, livello 15, stato 1, procedura sp_createAccount, riga 13
Sintassi non corretta in prossimità di 'ame'.
Messaggio 102, livello 15, stato 1, procedura sp_createAccount, riga 15
Sintassi non corretta in prossimità di 'e'.
Messaggio 102, livello 15, stato 1, procedura sp_sendItem, riga 22
Sintassi non corretta in prossimità di 'er'.
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
(Righe interessate: 1)
Added two more bug fixes to the main post.
@megsking2: You can find a fix to that bug there, too.
Also, I hope you don't mind that I used the screenshot you provided. I can remove it if you'd like.
Teachery, could you help me plz? I need a Website, but WAMP have a problem with 5.3.1 T_T
could you help me via MSN?? u.u
---------- Post added at 02:28 AM ---------- Previous post was at 02:01 AM ----------
yeee now the "Proceed" Works :D thanks all :P
ehm... not... it doesn't Work T_T
in the step 2, what i must insert in "SQL Server" ? if I insert the PC-Alex\SQLEXPRESS
the whem site say me this:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: PC-Alex\SQLEXPRESS in C:\wamp\www\install.php on line 151
what to do?
Did you enter your SQL Server's username and password?