Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

GameWeb

Initiate Mage
Joined
Sep 7, 2005
Messages
82
Reaction score
4
Anyone has a copy of GameWeb formatted for SQL server 2000. The one with darkxl seems to be in sql 2005 version because im getting a version error while restoring it.

Thank you in advance.
 
Junior Spellweaver
Joined
Sep 22, 2006
Messages
154
Reaction score
0
Anyone has a copy of GameWeb formatted for SQL server 2000. The one with darkxl seems to be in sql 2005 version because im getting a version error while restoring it.

Thank you in advance.

I am getting error too...
I must use 2005?
 
Upvote 0
The Dinosaur
Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
All the ones i have seen are in 2005 format. I converted it to a 2000 script so create the database and run the script and it should create the tables/procedures for you. The PingMac_AddUser procedure is how you add users.

Code:
USE [gameweb]
GO
/****** Object:  Table [dbo].[Game_DownLoad]    Script Date: 07/20/2008 10:56:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_DownLoad](
	[DownId] [int] IDENTITY(1,1) NOT NULL,
	[DownClass] [int] NULL DEFAULT (0),
	[DownType] [int] NULL DEFAULT (0),
	[DownTitle] [nvarchar](50) NULL,
	[DownContent] [text] NULL,
	[DownTime] [datetime] NULL,
	[DownUrl1] [nvarchar](50) NULL,
	[DownUrl2] [nvarchar](50) NULL,
	[DownUrl3] [nvarchar](50) NULL,
	[Focus] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_UserPhoto]    Script Date: 07/20/2008 10:57:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_UserPhoto](
	[PhotoId] [int] IDENTITY(1,1) NOT NULL,
	[PhotoType] [int] NULL,
	[PhotoTitle] [nvarchar](50) NULL,
	[PhotoContent] [text] NULL,
	[PhotoTime] [datetime] NULL,
	[PhotoUrl] [nvarchar](50) NULL,
	[PhotoUser] [nvarchar](50) NULL,
	[PhotoHist] [int] NULL DEFAULT (0),
	[Focus] [int] NULL DEFAULT (0),
	[ShenHe] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_System]    Script Date: 07/20/2008 10:57:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_System](
	[WebName] [nvarchar](50) NULL,
	[WebUrl] [nvarchar](50) NULL,
	[WebMail] [nvarchar](50) NULL,
	[WebQQ] [nvarchar](50) NULL,
	[WebCopy] [text] NULL,
	[WebSm] [text] NULL,
	[SvrIp] [nvarchar](50) NULL,
	[SvrPort] [int] NULL,
	[UpFile] [nvarchar](50) NULL,
	[UpMax] [int] NULL DEFAULT (200)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_GameSet]    Script Date: 07/20/2008 10:57:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_GameSet](
	[Set1] [int] NULL DEFAULT (0),
	[Set2] [int] NULL DEFAULT (0),
	[Set3] [int] NULL DEFAULT (0),
	[Set4] [int] NULL DEFAULT (0),
	[Set5] [int] NULL DEFAULT (0),
	[Set6] [int] NULL DEFAULT (0),
	[Set7] [int] NULL DEFAULT (0),
	[Set8] [int] NULL DEFAULT (0),
	[Set9] [int] NULL DEFAULT (0),
	[Set10] [int] NULL DEFAULT (0),
	[Set11] [int] NULL DEFAULT (0),
	[Set12] [int] NULL DEFAULT (0),
	[Set13] [int] NULL DEFAULT (0),
	[Set14] [int] NULL DEFAULT (0),
	[Set15] [int] NULL DEFAULT (0),
	[Set16] [int] NULL DEFAULT (0),
	[Set17] [int] NULL DEFAULT (0),
	[Set18] [int] NULL DEFAULT (0),
	[Set19] [int] NULL DEFAULT (0),
	[Set21] [int] NULL DEFAULT (0),
	[Set22] [int] NULL DEFAULT (0),
	[Set23] [int] NULL DEFAULT (0),
	[Set24] [int] NULL DEFAULT (0),
	[Set25] [int] NULL DEFAULT (0),
	[Set26] [int] NULL DEFAULT (0),
	[Set27] [int] NULL DEFAULT (0),
	[Set28] [int] NULL DEFAULT (0),
	[Set29] [int] NULL DEFAULT (0),
	[Set30] [int] NULL DEFAULT (0)
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_Cards]    Script Date: 07/20/2008 10:56:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_Cards](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CardCon] [nvarchar](50) NULL,
	[CardTime] [datetime] NULL,
	[CardUser] [nvarchar](50) NULL,
	[UserTime] [datetime] NULL,
	[CardFlag] [int] NULL,
	[CardWorth] [int] NULL,
	[CardType] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_WebLog]    Script Date: 07/20/2008 10:57:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_WebLog](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Logs] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_WebIp]    Script Date: 07/20/2008 10:57:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_WebIp](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Head_Ip] [nvarchar](50) NULL,
	[Foot_Ip] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_FAQ]    Script Date: 07/20/2008 10:56:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_FAQ](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Issue] [text] NULL,
	[Answer] [text] NULL,
	[AddTime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  StoredProcedure [dbo].[PingMac_AddUser]    Script Date: 07/20/2008 10:56:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE  [PingMac_AddUser]

@UserName               varchar(50),
@PassWord          varchar(50),
@PassWord2          varchar(50),
@RealName        varchar(32),
@IDcard               varchar(64),
@Email          varchar(32),
@Sex        integer,
@Qicq                 varchar(32),
@Phone                 varchar(32),
@Household  varchar(32),
@Signed            varchar(64),
@LoginIp              varchar(32),
@Recommended              integer


AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON
SET XACT_ABORT  ON

	BEGIN TRAN
	INSERT INTO PingMac_User (UserName,PassWord,PassWord2,UserLv,RealName,IDcard,Email,Sex,Qicq,Phone,Household,Signed,RegTime,LoginIp,Recommended) VALUES(@UserName,@PassWord,@PassWord2,1,@RealName,@IDcard,@Email,@Sex,@Qicq,@Phone,@Household,@Signed,getdate(),@LoginIp,@Recommended)
commit
GO
/****** Object:  Table [dbo].[PingMac_User]    Script Date: 07/20/2008 10:57:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_User](
	[Id] [int] NOT NULL CONSTRAINT [DF__PingMac_User__Id__60A75C0F]  DEFAULT ((0)),
	[UserName] [nvarchar](50) NULL,
	[PassWord] [nvarchar](50) NULL,
	[PassWord2] [nvarchar](50) NULL,
	[UserLv] [int] NULL CONSTRAINT [DF__PingMac_U__UserL__619B8048]  DEFAULT ((0)),
	[UserVip] [int] NULL CONSTRAINT [DF__PingMac_U__UserV__628FA481]  DEFAULT ((0)),
	[MacNum] [int] NULL CONSTRAINT [DF__PingMac_U__MacNu__6383C8BA]  DEFAULT ((0)),
	[RealName] [nvarchar](50) NULL,
	[IDcard] [nvarchar](50) NULL,
	[Email] [nvarchar](50) NULL,
	[Sex] [int] NULL CONSTRAINT [DF__PingMac_Use__Sex__6477ECF3]  DEFAULT ((0)),
	[Qicq] [nvarchar](50) NULL,
	[Phone] [nvarchar](50) NULL,
	[Household] [nvarchar](50) NULL,
	[Signed] [text] NULL,
	[RegTime] [datetime] NULL,
	[LoginNum] [int] NULL CONSTRAINT [DF__PingMac_U__Login__656C112C]  DEFAULT ((0)),
	[LoginTime] [datetime] NULL,
	[LoginIp] [nvarchar](50) NULL,
	[NewUser] [int] NULL CONSTRAINT [DF__PingMac_U__NewUs__66603565]  DEFAULT ((0)),
	[Recommended] [int] NULL CONSTRAINT [DF__PingMac_U__Recom__6754599E]  DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PingMac_Acting]    Script Date: 07/20/2008 10:57:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_Acting](
	[ID] [int] NOT NULL,
	[ACTname] [nvarchar](50) NOT NULL,
	[UserId] [nvarchar](50) NOT NULL,
	[ACTEffective] [int] NOT NULL,
	[ACTAbout] [text] NULL,
	[ACTWealth] [money] NOT NULL,
	[ACTContact] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PingMac_Cards]    Script Date: 07/20/2008 10:57:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_Cards](
	[ID] [int] NOT NULL,
	[ActingID] [int] NULL,
	[CardCon] [nvarchar](50) NULL,
	[CardTime] [datetime] NULL,
	[CardUser] [nvarchar](50) NULL,
	[UserTime] [datetime] NULL,
	[CardFlag] [int] NULL,
	[CardWorth] [int] NULL,
	[CardType] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PingMac_Items]    Script Date: 07/20/2008 10:57:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [PingMac_Items](
	[ID] [int] NOT NULL,
	[ItemMain] [int] NULL,
	[ItemSub] [int] NULL,
	[ItemName] [nvarchar](50) NULL,
	[ItemCons] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ShopItemMap]    Script Date: 07/20/2008 10:57:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [ShopItemMap](
	[ProductNum] [int] NOT NULL,
	[ItemMain] [int] NULL,
	[ItemSub] [int] NULL,
	[ItemName] [varchar](100) NULL,
	[ItemType] [int] NULL,
	[ItemTj] [int] NULL,
	[ItemMac] [int] NULL,
	[ItemMoney] [money] NULL,
	[ItemNum] [int] NULL,
	[ItemCon] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Game_Admin]    Script Date: 07/20/2008 10:56:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_Admin](
	[AdminId] [int] IDENTITY(1,1) NOT NULL,
	[LevelInt] [int] NULL DEFAULT (0),
	[AdminName] [nvarchar](50) NULL,
	[AdminPassword] [nvarchar](50) NULL,
	[AdminLoginIp] [nvarchar](50) NULL,
	[AdminLoginTime] [nvarchar](50) NULL,
	[LoginNum] [int] NULL DEFAULT (0),
	[UserOnline] [int] NULL DEFAULT (0)
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_TempLogin]    Script Date: 07/20/2008 10:57:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Game_TempLogin](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[SessionID] [varchar](50) NULL,
	[UserName] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Game_News]    Script Date: 07/20/2008 10:57:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_News](
	[NewsId] [int] IDENTITY(1,1) NOT NULL,
	[NewsClass] [int] NULL DEFAULT (0),
	[NewsType] [int] NULL DEFAULT (0),
	[NewsTitle] [nvarchar](50) NULL,
	[NewsContent] [text] NULL,
	[NewsUser] [nchar](10) NOT NULL,
	[NewsTime] [datetime] NULL,
	[NewsHist] [int] NULL DEFAULT (0),
	[Focus] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Game_Userarticle]    Script Date: 07/20/2008 10:57:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Game_Userarticle](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Class] [int] NULL DEFAULT (0),
	[Type] [int] NULL DEFAULT (0),
	[Title] [nvarchar](50) NULL,
	[Content] [text] NULL,
	[User] [nchar](10) NOT NULL,
	[AddTime] [datetime] NULL,
	[Hist] [int] NULL DEFAULT (0),
	[Focus] [int] NULL DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  StoredProcedure [dbo].[PingMac_UserLogin]    Script Date: 07/20/2008 10:56:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc  [PingMac_UserLogin] 
(
   @UserID varchar(50) , 
   @Password varchar(50), 
   @UserIp varchar(50), 
   @OptDescription  int output 
   )
AS 
begin tran

         select UserName from PingMac_User where  UserName = @UserID 
         if (@@RowCount<1) 
            begin ----1 
                set  @OptDescription =-1 
              rollback
             end------1 
         else  
                begin  ----2        
        SELECT   UserName    FROM PingMac_User  WHERE (UserName = @UserID) AND (PassWord = @Password ) 
                     if (@@RowCount<1) 
                        begin -----3 
                         set  @OptDescription =-1 
                      rollback
                        end-------3 
                    else 
                         begin -----4 
                       UPDATE PingMac_User SET LoginNum=LoginNum+1,LoginTime=getdate(),LoginIp=@UserIp where UserName= @UserID ---登陆纪录
                         set  @OptDescription=0 
                       commit 
                        end  ------4     
                                 
                end------2
GO
/****** Object:  StoredProcedure [dbo].[PingMac_AdminLogin]    Script Date: 07/20/2008 10:56:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc  [PingMac_AdminLogin] 
(
   @UserID varchar(50) , 
   @Password varchar(50), 
   @Level  int  output , 
   @OptDescription  int output 
   )
AS 
begin tran

         select AdminName from Game_Admin where  AdminName = @UserID 
         if (@@RowCount<1) 
            begin ----1 
                set  @OptDescription =-1 
              rollback
             end------1 
         else  
                begin  ----2        
        SELECT   AdminName ,LevelInt  FROM Game_Admin  WHERE (AdminName = @UserID) AND (AdminPassword = @Password ) 
                     if (@@RowCount<1) 
                        begin -----3 
                         set  @OptDescription =-1 
                      rollback
                        end-------3 
                    else 
                         begin -----4 
                         set  @OptDescription=0 
                         set    @Level =20
                       commit 
                        end  ------4     
                                 
                end------2
GO
 
Upvote 0
Back
Top