PDA

View Full Version : Cách Làm Server Gunz Có Quest



hongphuc1281441
01-09-2008, 07:34 AM
Các bạn ơi sau một thời gian tìm hiểu minh đã kích quest dc từ cái server cua anh Duong roi
sau day la huong dan cua minh:(lam bang SQL 2005 nha các bạn)
các bạn tải cái link của anh Duong về vào thư mục db xóa tất cả chừa file GunzDB2k lại và nhấp phải vào nó chọn edit sau do thay toàn bọ bàng doạn code sau:
USE [GunzDB]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Items](
[CID] [int] NULL,
[ItemID] [int] NULL,
[CIID] [int] IDENTITY(1,1) NOT NULL,
[RentPeriodRemainder] [int] NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Locator](
[ID] [int] NOT NULL,
[Players] [int] NOT NULL,
[IP] [varchar](50) NOT NULL,
[Port] [int] NOT NULL,
[code] [int] NOT NULL,
[Time] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Accounts](
[AID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](50) NOT NULL,
[Password] [varchar](50) NOT NULL,
[UGradeID] [int] NULL CONSTRAINT [DF_Accounts_UGradeID] DEFAULT ((1))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MPLVL](
[AID] [int] NULL,
[CharacterName] [varchar](50) NULL,
[AccountName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CharMakingLog](
[AID] [int] NULL,
[CharName] [varchar](32) NULL,
[Type] [varchar](32) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Clans](
[CLID] [int] IDENTITY(1,1) NOT NULL,
[Level] [int] NOT NULL,
[Name] [varchar](50) NOT NULL,
[ClanMaster] [varchar](10) NOT NULL,
[EmblemURL] [varchar](100) NULL,
[TotalPoint] [int] NOT NULL,
[Point] [int] NOT NULL,
[Wins] [int] NOT NULL,
[Losses] [int] NOT NULL,
[MemberCount] [int] NOT NULL,
[Ranking] [int] NOT NULL,
[EmblemChecksum] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LocatorLog](
[IP] [int] NOT NULL,
[Port] [int] NOT NULL,
[Count] [int] NOT NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Mythical
-- Create date: Dec 25, 2006
-- Description: Merry XMAS!
-- =============================================
CREATE PROCEDURE [dbo].[spGetCharList]
-- Add the parameters for the stored procedure here
@nAID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT Level,CharNum,Name
FROM Character
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateEquipItem]
@nCID INT,
@parts INT,
@nCIID INT,
@nItemID INT
AS
BEGIN
SET NOCOUNT ON;

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

Select 1 Ret
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetAccountCharInfo]
@nAID INT,
@nCharIndex INT
AS
BEGIN
SET NOCOUNT ON;

SELECT custom2_itemid, custom1_itemid, secondary_itemid, primary_itemid, melee_itemid, fingerr_itemid, fingerl_itemid, feet_itemid, legs_itemid, hands_itemid, chest_itemid, head_itemid, BP, XP, Face, Hair, Sex, Level, CharNum, ClanName, Name
FROM Character
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spDeleteChar]
@nAID INT,
@nCharIndex INT,
@szCharName nvarchar(32)
AS
BEGIN
SET NOCOUNT ON;

[Only registered and activated users can see links]
[Only registered and activated users can see links]
COUNT(*)
FROM Character
[Only registered and activated users can see links]

[Only registered and activated users can see links]
DELETE
FROM Character
[Only registered and activated users can see links]

[Only registered and activated users can see links]

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetCharInfoByCharNum]
@nAID INT,
@nCharIndex INT
AS
BEGIN
SET NOCOUNT ON;

SELECT custom2_slot,custom1_slot,secondary_slot,primary_s lot,melee_slot,fingerl_slot,fingerr_slot,feet_slot ,legs_slot,hands_slot,chest_slot,head_slot,ClanCon tPoint,ClanGrade,ClanName,CLID,PlayTime,DeathCount ,KillCount,CharNum,WR,ER,CR,FR,AP,HP,BP,XP,Face,Ha ir,Sex,Level,Name,CID
FROM Character
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharLevel]
@nLevel INT,
@nCID INT
AS
BEGIN
SET NOCOUNT ON;

UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharBP]
@nBP INT,
@nCID INT
AS
BEGIN
SET NOCOUNT ON;

UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharPlayTime]
@nPlayTime INT,
@nCID INT
AS
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetFriendList]
@CID INT
AS
BEGIN
SET NOCOUNT ON;
SELECT Name, Favorite, FriendCID
FROM Friend
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spAddFriend]
@nCID INT,
@nFriendCID INT,
@nFavorite INT
AS
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
FROM Friend
[Only registered and activated users can see links]

[Only registered and activated users can see links]
[Only registered and activated users can see links]
FROM Character
[Only registered and activated users can see links]

[Only registered and activated users can see links]
INSERT INTO Friend
[Only registered and activated users can see links]

[Only registered and activated users can see links]

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spRemoveFriend]
@nCID INT,
@nFriendCID INT
AS
DELETE
FROM Friend
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateServerStatus]
@CurrPlayer INT,
@ServerID INT
AS
UPDATE ServerStatus
[Only registered and activated users can see links]
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[InsertServerLog](
[ID1] [varchar](50) NOT NULL,
[ID2] [varchar](50) NOT NULL,
[ID3] [varchar](50) NOT NULL,
[ID4] [varchar](50) NOT NULL,
[ID5] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Friend](
[CID] [int] NULL,
[FriendCID] [int] NULL,
[Favorite] [int] NULL,
[Name] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spCreateClan]
@zClanName varchar(15),
@nMasterCID int,
@nMember1CID int,
@nMember2CID int,
@nMember3CID int,
@nMember4CID int
AS
--Get the name of the clan.
[Only registered and activated users can see links]
[Only registered and activated users can see links]
--Add the clan to the database.
INSERT INTO Clans
[Only registered and activated users can see links]
--Request the clan id.
[Only registered and activated users can see links]
[Only registered and activated users can see links]
--Update the ClanMaster And all 4 members to be in the crew.
[Only registered and activated users can see links]
--Update the ClanMaster to be the ClanMaster in the database.
[Only registered and activated users can see links]
BEGIN
SET NOCOUNT ON;
--Request the clanid i guess for the server?
[Only registered and activated users can see links]
[Only registered and activated users can see links]
FROM Clans
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetCharClan]
@nCID INT
AS
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[InsertGameLog](
[Game] [varchar](32) NULL,
[Map] [varchar](32) NULL,
[GameType] [varchar](32) NULL,
[Rounds] [varchar](32) NULL,
[How Many Rounds Played] [varchar](32) NULL,
[TotalUsers] [varchar](32) NULL,
[Users] [varchar](32) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetClanInfo]
@CLID INT
AS
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetCLIDFromClanName]
@nClanName varchar(10)
AS
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spUpdateClanGrade]
@nCLID INT,
@nCID INT,
@nLEVEL INT
AS

[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlayerLog](
[CID] [int] NULL,
[PlayTime] [int] NULL,
[KillCount] [int] NULL,
[DeathCount] [int] NULL,
[EXPEarned] [int] NULL,
[TotalEXP] [int] NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spTeam4WinTheGame]
@nCLID INT,
@nTID INT,
@nUser1 INT,
@nUser2 INT,
@nUser3 INT,
@nUser4 INT
AS

[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertCharMakingLog]
@nAID INT,
@nCharName varchar(32),
@nType varchar(32)
AS
--Add new log infomation to db.
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KillLog](
[KillerID] [int] NULL,
[KilledID] [int] NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spUpdateCharClanContPoint]
@nCLID INT,
@nCID INT,
@nContPoint INT
AS
BEGIN
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LevelUpLog](
[A] [int] NULL,
[b] [int] NULL,
[C] [int] NULL,
[D] [int] NULL,
[E] [int] NULL,
[F] [int] NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ConnLog](
[AID] [int] NULL,
[IPString1] [int] NULL,
[IPString2] [int] NULL,
[IPString3] [int] NULL,
[IPString4] [int] NULL,
[Alert] [nchar](32) NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LadderTeam](
[TID] [int] IDENTITY(1,1) NOT NULL,
[CLID] [int] NOT NULL,
[User1] [int] NOT NULL,
[User2] [int] NOT NULL,
[User3] [int] NULL,
[User4] [int] NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSelectCharQuestItemInfoByCID]
@nCID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

[Only registered and activated users can see links]

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ClanLog](
[WinnerCLID] [int] NULL,
[LoserCLID] [int] NULL,
[IsDrawGame] [int] NULL,
[WinnerPoint] [int] NULL,
[LoserPoint] [int] NULL,
[WinnerClanName] [varchar](max) NULL,
[LoserClanName] [varchar](max) NULL,
[RoundWins] [int] NULL,
[RoundLosses] [int] NULL,
[MapID] [int] NULL,
[GameType] [int] NULL,
[WinnerMembers] [varchar](max) NULL,
[LoserMembers] [varchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetCharInfoByAID]
@nAID INT
AS
BEGIN
SELECT custom2_slot,custom1_slot,secondary_slot,primary_s lot,melee_slot,fingerl_slot,fingerr_slot,feet_slot ,legs_slot,hands_slot,chest_slot,head_slot,ClanCon tPoint,ClanGrade,ClanName,CLID,PlayTime,DeathCount ,KillCount,CharNum,WR,ER,CR,FR,AP,HP,BP,XP,Face,Ha ir,Sex,Level,Name,CID
FROM Character
WITH (nolock)
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ConnectionLog](
[AccountName] [varchar](50) NULL,
[Date] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ItemPurchaseLog](
[A] [int] NULL,
[b] [int] NULL,
[C] [int] NULL,
[D] [int] NULL,
[E] [nchar](32) NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CountryCode](
[IPFrom] [varchar](50) NULL,
[IPTo] [varchar](50) NULL,
[CountryCode3] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LocatorStatus](
[LocatorID] [int] NULL,
[IP] [nvarchar](4000) NOT NULL,
[Port] [int] NULL,
[StatusTime] [int] NULL,
[UpdateTime] [int] NULL,
[RecvUDP] [varchar](4000) NULL,
[SendUDP] [varchar](4000) NULL,
[BlockUDP] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSelectAccountItem]
@AID INT
AS
BEGIN

SELECT RentPeriodRemainder,AIID,ItemID
FROM
AccountItems
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
[AID] [int] NULL,
[Name] [varchar](10) NULL,
[CharIndex] [int] NULL,
[Level] [int] NULL,
[Sex] [int] NULL,
[Costume] [int] NULL,
[Face] [int] NULL,
[Hair] [int] NULL,
[ClanName] [varchar](16) NULL,
[XP] [int] NULL,
[BP] [money] NULL,
[head_itemid] [int] NULL,
[chest_itemid] [int] NULL,
[hands_itemid] [int] NULL,
[legs_itemid] [int] NULL,
[feet_itemid] [int] NULL,
[fingerl_itemid] [int] NULL,
[fingerr_itemid] [int] NULL,
[melee_itemid] [int] NULL,
[primary_itemid] [int] NULL,
[secondary_itemid] [int] NULL,
[custom1_itemid] [int] NULL,
[custom2_itemid] [int] NULL,
[CharNum] [int] NULL,
[CID] [int] IDENTITY(1,1) NOT NULL,
[HP] [int] NULL,
[AP] [int] NULL,
[FR] [int] NULL,
[CR] [int] NULL,
[ER] [int] NULL,
[WR] [int] NULL,
[KillCount] [int] NULL,
[DeathCount] [int] NULL,
[PlayTime] [int] NULL,
[CLID] [int] NULL,
[ClanGrade] [int] NULL,
[ClanContPoint] [int] NULL,
[head_slot] [int] NULL,
[chest_slot] [int] NULL,
[hands_slot] [int] NULL,
[legs_slot] [int] NULL,
[feet_slot] [int] NULL,
[fingerl_slot] [int] NULL,
[fingerr_slot] [int] NULL,
[melee_slot] [int] NULL,
[primary_slot] [int] NULL,
[secondary_slot] [int] NULL,
[custom1_slot] [int] NULL,
[custom2_slot] [int] NULL,
[QuestItemInfo] [nvarchar](max) NULL,
[LastActive] [datetime] NULL,
[LevelTime] [datetime] NULL,
[PLvlCount] [int] NOT NULL CONSTRAINT [DF_Character_PLvlCount] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BanTable](
[AID] [int] NULL,
[AccountName] [varchar](50) NULL,
[CharacterName] [varchar](50) NULL,
[Reason] [varchar](50) NULL,
[Admin] [varchar](50) NULL,
[Action] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AccountItems](
[AID] [int] NULL,
[ItemID] [int] NULL,
[AIID] [int] IDENTITY(1,1) NOT NULL,
[RentPeriodRemainder] [int] NULL
) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BlockCountryCode](
[IPFrom] [varchar](4000) NULL,
[IPTo] [varchar](4000) NULL,
[CountryCode3] [varchar](4000) NULL,
[RoutingURL] [varchar](4000) NULL,
[IsBlock] [int] NULL,
[Comment] [varchar](4000) NULL,
[code] [varchar](4000) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
[ServerID] [int] NULL,
[ServerName] [nvarchar](32) NULL,
[PlayerCount] [int] NULL,
[MaxPlayer] [int] NULL,
[CurrPlayer] [int] NULL,
[Time] [datetime] NULL,
[IP] [varchar](50) NULL,
[Port] [int] NULL,
[Opened] [varchar](50) NULL,
[StatusTime] [int] NULL,
[UpdateTime] [int] NULL,
[RecvUDP] [varchar](max) NULL,
[SendUDP] [varchar](max) NULL,
[BlockUDP] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QuestGameLog](
[StageName] [varchar](max) NULL,
[ScenarioID] [int] NULL,
[MasterCID] [int] NULL,
[Player1] [int] NULL,
[Player2] [int] NULL,
[Player3] [int] NULL,
[TotalRewardQItemCount] [int] NULL,
[ElapsedPlayTime] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharInfoData]
@nAddedXP BIGINT,
@nAddedBP BIGINT,
@nAddedKillCount INT,
@nAddedDeathCount INT,
@nCID INT
AS

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

SET NOCOUNT ON;

-- //BEGIN POWERLEVEL AUTOBAN//

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

-- =============================================
-- Author: Mackintosh [Only registered and activated users can see links]
-- Description: This piece of code will autoban powerlevelers
-- depending on how fast they kill/die by creating timestamps
-- between deaths.
-- =============================================

-- If player, kills someone within under 2 seconds enter if statement.
[Only registered and activated users can see links]
BEGIN
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

-- If player has killed 5 people in under 2 seconds, autoban.
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
[Only registered and activated users can see links]

INSERT INTO MPLVL (Aid,AccountName,CharacterName)
[Only registered and activated users can see links]
--UPDATE BanTable
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
END
-- //END POWERLEVL AUTOBAN//

ELSE
BEGIN
UPDATE Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
PlvlCount = 0,
[Only registered and activated users can see links]

[Only registered and activated users can see links]

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSellBountyItem]
@nCID INT,
@nItemID INT,
@nCIID INT,
@nPrice INT,
@nCharBP INT
AS
BEGIN
SET NOCOUNT ON;

DELETE FROM Items
[Only registered and activated users can see links]

[Only registered and activated users can see links]
Select 1 Ret
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSelectCharItem]
@CID INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE Character SET BP = 108512564.0000
SELECT RentPeriodRemainder,CIID,ItemID
FROM
Items
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spBuyBountyItem]
@nCID INT,
@nItemID INT,
@nPrice INT
AS
BEGIN
SET NOCOUNT ON;

[Only registered and activated users can see links]
INSERT INTO Items
[Only registered and activated users can see links]
SELECT 0 OrderCIID



END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spBringBackAccountItem]
-- Add the parameters for the stored procedure here
@nAID INT,
@nCID INT,
@nCIID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

[Only registered and activated users can see links]
[Only registered and activated users can see links]
FROM Items
[Only registered and activated users can see links]

DELETE FROM Items
[Only registered and activated users can see links]

[Only registered and activated users can see links]

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spBringAccountItem]
-- Add the parameters for the stored procedure here
@nAID INT,
@nCID INT,
@nAIID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

[Only registered and activated users can see links]
[Only registered and activated users can see links]
FROM AccountItems
[Only registered and activated users can see links]

DELETE FROM AccountItems
[Only registered and activated users can see links]

[Only registered and activated users can see links]
[Only registered and activated users can see links]

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertCharItem]
@nItemID INT,
@nCID INT,
@nRentPeriodRemainder INT
AS
BEGIN
INSERT INTO Items (CID,ItemID, RentPeriodRemainder) VALUES
[Only registered and activated users can see links]
END
--maybe it just that. we can see there
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spClearAllEquipedItem]
@nCharID INT
AS
DELETE FROM Items
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetLoginInfo]
@szAccountName varchar(50)
AS
BEGIN
SET NOCOUNT ON;

SELECT AID, Password
FROM Accounts
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetAccountInfo]
@nAID INT
AS
BEGIN
SET NOCOUNT ON;

SELECT AID,UGradeID,UserID
FROM Accounts
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertServerLog]
@test int,
@test2 int,
@test3 int,
@test4 int,
@test5 int
AS

[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertGameLog]
@Game varchar(32),
@Map varchar(32),
@GameType varchar(32),
@Rounds varchar(32),
@Users varchar(32),
@TotalUsers varchar(32),
@NickName varchar(32)
AS
INSERT INTO InsertGameLog
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertPlayerLog]
@nCID INT,
@nPlayTime INT,
@nKillCount INT,
@nDeathCount INT,
@nEXPEarned INT,
@nTotalEXP INT
AS
BEGIN
INSERT INTO PlayerLog
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertConnLog]
@nA INT,
@nB INT,
@nC INT,
@nD INT,
@nE INT,
@nF varchar(32)
AS
BEGIN
INSERT INTO ConnLog
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- CALL spGetLadderTeamMemberByCID (%d) // CharID
CREATE PROC [dbo].[spGetLadderTeamMemberByCID]
@nCID INT
AS
BEGIN
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetTeamID4]
@nUser1 INT,
@nUser2 INT,
@nUser3 INT,
@nUser4 INT
AS
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertLevelUpLog]
@nA INT,
@nB INT,
@nC INT,
@nD INT,
@nE INT,
@nF INT
AS
BEGIN
INSERT INTO LevelUpLog
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--- CALL spUpdateLastConnDate ('%s', '%s') // AccountName, Date

CREATE PROC [dbo].[spUpdateLastConnDate]
@nAccountName varchar(10),
@nDate INT
AS

INSERT INTO ConnectionLogDate
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spWinTheClanGame]
@nWinnerCLID INT,
@nLoserCLID INT,
@bIsDrawGame INT,
@nWinnerPoint INT,
@nLoserPoint INT,
@szWinnerClanName varchar(MAX),
@szLoserClanName varchar(MAX),
@nRoundWins INT,
@nRoundLosses INT,
@nMapID INT,
@nGameType int,
@szWinnerMembers varchar(MAX),
@szLoserMembers varchar(MAX)
AS
BEGIN
-- Update Losses/Wins + Points.
[Only registered and activated users can see links]
[Only registered and activated users can see links]
-- Insert data into ClanLog.
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertItemPurchaseLogByBounty]
@nA INT,
@nB INT,
@nC INT,
@nD INT,
@nE varchar(32)
AS
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
INSERT INTO ItemPurchaseLog
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spRemoveClanMemberFromCharName]
@nCLID INT,
@nEvilPersonWhoKickedYou INT,
@nCharName varchar(10)


AS
[Only registered and activated users can see links]
[Only registered and activated users can see links]
-- Check if user aint owner of clan.
[Only registered and activated users can see links]
BEGIN
-- Remove user from clan.
[Only registered and activated users can see links]
-- Set clan member count -1
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spReserveCloseClan]
@nCLID INT,
@nClanName varchar(15),
@nMasterCID INT
AS
BEGIN
-- Delete clan from db.
[Only registered and activated users can see links]
-- Remove clan members.
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spAddClanMember]
@nCLID INT,
@nJoinerCID INT,
@nClanGrade INT
AS
--Request the clanname from the database by using the clanid.
[Only registered and activated users can see links]
[Only registered and activated users can see links]
--Update the play to be part of the clan and give him the correct grade/level.
[Only registered and activated users can see links]
[Only registered and activated users can see links]
--Update the clan to have 1 more member.
UPDATE Clans SET MemberCount = MemberCount + 1
[Only registered and activated users can see links]
--Return the clanid to the server.
SELECT 1 Ret
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spRemoveClanMember]
@nCLID INT,
@nCID INT
AS
BEGIN
--Set user clan less.
[Only registered and activated users can see links]
--Set clanmember count -1.
[Only registered and activated users can see links]
--Return clan id to server.
SELECT 1 Ret
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

[Only registered and activated users can see links]
[Only registered and activated users can see links]
FROM Character
[Only registered and activated users can see links]

[Only registered and activated users can see links]
[Only registered and activated users can see links]
FROM Character

INSERT INTO Character
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spStartUpLocatorStatus]
@nLocatorID int,
@dwIP nvarchar(4000),
@nPort int,
@nStatusTime varchar(4000)
AS
DELETE FROM LocatorStatus
[Only registered and activated users can see links]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateLocatorStatus]
@nLocatorID INT,
@RecvUDP VARCHAR,
@SendUDP VARCHAR,
@BlockUDP INT,
@UpdateTime INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE LocatorStatus
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetIPCountryCode]
AS
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetIPtoCountryList]
AS
BEGIN
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetIPtoCountryCode]
AS
BEGIN
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertQuestGameLog]
@pszStagename varchar(max),
@nScenarioID INT,
@nMasterCID INT,
@nPlayer1 INT,
@nPlayer2 INT,
@nPlayer3 INT,
@nTotalRewardQItemCount INT,
@nElapsedPlayTime INT
AS
BEGIN
INSERT INTO QuestGameLog
[Only registered and activated users can see links]
SELECT 0 ORDERQGLID
END
GO

***** TẢI CÁC PHẦN MỀM SAU**************
MsSQL 2005 Express Edition
Code:
[Only registered and activated users can see links]
MsSQL Server Managment Studio và tìm msxml6 tải về lun

Code:
[Only registered and activated users can see links]
.NET Framework 2.0
Code:
[Only registered and activated users can see links]
*********CÁCH LÀM**********************
Bước 1 :cài MSSQL 2005
luu ý cài .NET Framework 2.0 truóc khi cài SQL
- Chạy Install MsSQL Server 2005 Express Edition cư nhấn nẽt cho tới khi đến bảng Feature Selection
- Nhấn Client Components và chọn Entire Feature will be installed on local hard drive
- Nhấn Next tiếp tục cho đến bảng chọn giữa "SQL Server Authentication" và "Windows Authentication"
- Chọn SQL Server Authentication và nhập mật mà cho sasa
- Cứ tiếp tục nhấn next cho đến khi cài xong
- cài msxml6 nhấn next dến kết thúc
- MsSQL Server Managment Studio thì chỉ cần nhấn Next cho đến khi cài xong

Bước 2 : Tạo DB
- Vào Start->Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express
- Bạn sẽ thấy một bảng kết nối: copy dong sever name lại

- Vào Databases, nhấp phài, chọn New Database:

- Sau đó open file GunzDB2k.sql nhấn f5.
Bước 3 : Tạo ODBC
- Vào Start>Settings>Control Panel>Administrative Tools>Data Sources (ODBC)
- Nhấn Add>SQL Server>Finish
- Trong mục Name nhập GunzDB
- Trong mục Server nhập paste dòng chữ đã copy từ trước vào -> Next -> next
- Nhấn vào nút đầu tiên, ở ô thứ nhất, chọn GunzDB -> Next -> Finish -> OK

* Hướng dẫn cài đặt Quest Mode cho GunZ Offline
_ Kết nối tới DB Server -> GunZDB -> Tables -> Column -> accounts-> Chuột phải vao Column chọn New Column , đánh vào QuestItemInfo
_ Tiếp theo Chuột phải vào GunZDB -> New Query , dán đoạn mã này vào , sau đó nhấn chuột phải -> Excute SQL

CREATE PROCEDURE [dbo].[QuestItemInfo]
@nCID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

[Only registered and activated users can see links]
END

Bước 4 : Config Server
- Vào GunzServer\MatchServer\server.ini
- Ở hàng PASSWORD, nhập password của sasa
- Ở hàng FREELOGINIP, nhập IP của bạn -> Save
- tìm dòng ;MODE="test" bỏ dấu ";" di (de chúng ta kích quest)

Bước 5 : Kết nối Client
- Vào \Gunz\config.xml (mở bằng Notepad)
- Hàng IP nhập IP của bạn
- Thế là xong, bạn có thể vào chơi được rồi ở dòng match chọn quest de bắn quest vô tư(bắn ko nỗi đâu ít nhất 3 nguoi cùng bắn mới nỗi)
*************config web nhw vầy mới đuoc nè**********

<!-------------------------------------
GunZ Web Evolution
0.2
By OmOiYuMe
[Only registered and activated users can see links]
DONT REMOVE THIS CREDIT, RESPECT
MY HARD WORK!
--------------------------------------->
<?php
include "lang/langs.php"; //DONT EDIT THIS! - NO EDITES ESTO!
//General
$srvip = "127.0.0.1";
$srvport = "6000";
$DBHost = '127.0.0.1'; //The host of your DB - Donde esta instalada la DB (I.E: MACHINE\SQL2005)
$mssql_host = "MAYCHU\SQLEXPRESS";
$DBUser = 'sa'; //Your DB User - El Usuario de la DB
$mssql_user = "sa";
$DBPass = 'sasa'; //Your DB Password - El Password de tu DB
$mssql_pass = "sasa";
$DB = 'GunZDB'; //Your GunZ DB - Tu DB de GunZ
$mssql_database = "GunzDb";
$Server = 'SG GunZ'; //Your Server's Name - El Nombre de tu Servidor
$Slogan = "SG Gunz Web Powered by OmOiYuMe's GunZ Web Evolution 0.2"; //Slogan of your server - Eslogan de tu server
$ClientL = '[Only registered and activated users can see links]';
$PatchL = '[Only registered and activated users can see links]';
$NoADM = '1'; //Dont show Admin accounts in rankings - No mostrar cuentas Admin en rankings
$RankNu = '10'; //Number of ranks to show in clan and character rankings - Numero de puestos para mostrar en el clan de players y clanes
$Lang = $Por; //Your Language - Tu Idioma ($Eng, $Spa, $Por, $Fre)
$conn = mssql_connect($mssql_host, $mssql_user, $mssql_pass);
mssql_select_db($mssql_database);
?>
****LUU Ý************
dong màu đỏ chúng ta copy ở mục server của bảng connect SQL 2005 đó và past vào đó
chúng ta nên dung phần mềm xampp-win32-1.6.6a-installer để làm web khỏi đăng kí

Suolrock
01-09-2008, 08:52 AM
bạn ơi làm thử trên cái SQL 2000 đi mình đang sài cái đó và đang cài Mu nữa:102:

hongphuc1281441
03-09-2008, 07:43 AM
Mu van chay duoc tren SQL 2005 ma. minh chay Au, Mu, Gunz, Vo Lam tren SQL 2005 dc mà. mình chỉ cho bạn lam MU bằng SQL 2005 nha ( Chay nhanh hon sql 2000 rat nhiu)

hongphuc1281441
03-09-2008, 08:33 AM
Bạn đang chạy Mu bằng SQL 2000 thi wa dễ, bạn chỉ cần gỡ bỏ SQL 2000 ra và cài vào SQL 2005 y huong dãn trên.
Vào Start->Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express
- Bạn sẽ thấy một bảng kết nối: copy dong sever name lại
sau đó nhấp vào connect
- Nhấp Phải vào Datbases chọn attach.... chọn dường dẫn đến: MU2003_EVENT_DATA.mdf,ranking_Data.MDF,muonline_Da ta.MDF của bạn đó. thế là xong.
Bạn chỉnh (ODBC) lại như vầy nè: ODBC Ranking bạn nhấp đôi vào nó va past dòng vừa copy vào muc server chọn Finish và tuong tự cho các OBDC khác. thế là xong ra chạy binh thường nhân vật trong games vẫn tồn tại ko mất đồ ko mất cấp.
Mình lúc trước cũng sài sql 2000 và chuyển qua sql 2005 bạn làm thư xem.
luu ý: Những cái bạn attach trên sql 2005 bạn đừng nên xóa vì no đỗng nghĩa với việc xóa dư liệu database trên đĩa của mình lun đóa, copy data thương xuyên lại để dành khi có sự cố.

hongphuc1281441
04-09-2008, 10:16 AM
mình ko có đoạn query để kích hoạt quét trên sql 2000 nên không thể làm bằng sql 2000 dc. minh dang tìm đaọn query đó nè. có ai pro tìm giúp mình đi

hongphuc1281441
04-09-2008, 10:50 AM
anh Dưong cho Ý kiến đi, anh nghiên cứu sữa lai SQL 2000 dc ko

Suolrock
05-09-2008, 04:03 PM
anh Dưong cho Ý kiến đi, anh nghiên cứu sữa lai SQL 2000 dc ko

Dù sao cũng cảm ơn bạn đã nhiệt tình giúp mình, nhưng cái Mu mình đang sài làm lâu lắm,vì nếu mà xóa cái SQL 2000 thì tất cả các dữ liệu của Mu mất hết ý mình nói là phần acc đó, làm biếng add lại lắm và dạo này mắc học rồi nên không có thời gian, nếu bạn kiếm dc cái code gì đó trên SQL2000 thì tốt biết mấy, nhưng dù sao cũng cảm ơn bạn nha...:15:

hongphuc1281441
05-09-2008, 06:49 PM
có cần phẩi vậy kô, bạn chỉ cần ko cho sql 2000 chạy rồi copy mấy file dữ liệu trong database lại là đâu có mất acc. xóa sql 2000 rồi cài cái 2005 lại rồi bạn attach la xong ko cần restor database

hlxuyen2000
21-12-2008, 11:50 AM
bạn ơi mình chơi được rùi nhưng bằng tài khoảng admin có sẵn,minh download xampp-win32-1.6.6a-installer về rùi nhưng không biết dùng làm sao bạn chỉ mình với

dhnguyen
26-12-2008, 03:28 PM
ê ông anh ơi xem lại bảo kỹ dùm cái tôi thấy sau khi kết nối database .... rồi ấn F5 nó báo lỗi lằng nhằng ra à.
mới lại cái PHP của ông không chạy được đâu có báo dòng lỗi và lập nick cũng không được à báo "có lỗi xảy ra, xin đăng ký lại" cái này như củ anh
Dương thì vẫn chơi được nhưng của ông thì chịu,

hongphuc1281441
14-01-2009, 08:34 AM
xin lỗi các bạn nha lâu wá mình ko len nen ko bit co nhieu cau hoi nhu vậy. đê minh nghien cứu lại ròi huóng dãn cho

hongphuc1281441
21-01-2009, 07:03 PM
bạn ơi mình chơi được rùi nhưng bằng tài khoảng admin có sẵn,minh download xampp-win32-1.6.6a-installer về rùi nhưng không biết dùng làm sao bạn chỉ mình với

Tải xampp-win32-1.6.6a-installer về rồi cài vào ổ đĩa c:\,ban giải nén web về rồi chỉnh sửa theo hướng dẫn, rồi sao đó bạn copy web và pass vào C:\xampp\htdocs. ok the là xong. truy cập web bình thường, coi chừng bị đụng lộn với web asp đó. nếu ko rành thì xài 1 loại thôi nha. nêu có thì gỡ mọi cài đặt của web asp ra.

hongphuc1281441
21-01-2009, 07:20 PM
minh úp lên cho các ban db sql 2005 tải về lam khỏi đánh mã code gi cho no mất công [Only registered and activated users can see links] các bạn tải về làm

a1shoot
24-04-2011, 09:42 PM
mình làm thử sever gunz online
ngoài mang vào được gunz , tao phòng được nhưng khi vào phòng thì đúng im không đánh
sever va cliet đã cài net framework 3.5
pro nào biết xin chỉ mình với