tin vui cho máy cấu hình thấp

[boy9000]

tui kiếm dc cái này lâu lắm rồi uplen mediafire gần 1 năm rồi mây h mới nhớ ra liền share cho mọi người đây là phiên bản CoLinux (giống cái bản 1.4.0 ấy)
nói rông dài quá link đêy ( các bạn tự tìm hỉu cách làm nha có gì thác mắc tui trả lời cả tuần mới on lần bận thi mọi người thông cảm nếu có chậm trễ)
[Only registered and activated users can see links. ]
ưu điểm dễ cài chỉ cần down về sau 15' có dùng luôn và server chạy nhẹ hơn so với dung VM ware nhìu dảm bảo máy 512 chạy bon
tất cả phần mềm cần thiêt có trong cung thư mục rồi iên thể cài Colinus thì cài lên ổ C chứ không dc để măc định vổi copy thư mục pwserver vào thư mục vừa cài là ổn
post lại cái cliet : [Only registered and activated users can see links. ]
nhớ thank nha cái cliet up lau lắm mấy pa ơi

[Nghia123123]

Thank bác nha đợi đem về xem sao.
Mà nó co' khuyết điểm gì so với cái đang sử sụng không vậy bác

[boy9000]

nó giống y hệt ccs loại sevver tạo bang mâyor kiẻu kia va chất lượng tốt có khả năng tự fix lỗi khi DB bị lỗi khả nang chống lỗi khi gặp sự cố duy chủ có tương tác của mình vào sevver bj hạn chế

[Nghia123123]

1)Xin hỏi khi mình tắt server ngang mà không dùng lệnh shutdown.sh thì máy có bị ảnh hưởng gì không?
2)Bác có thể hướng dẫn sơ qua cái thằng bác share được không.down về rồi không biết làm gì nữa

[boy9000]

tăt ngang chả sao nhưng nếu đang thoát game ma (cụ thể là đang ghi dữ liệu lên DB thì ko nên ) nếu bị lỗi thì dùng lênh path có tong phần khởi đọng ấy thế là DB bnhf thường trở lại

[Nghia123123]

Bác boy ơi sao khi download xong rồi không biết làm gì nữa bác hướng dẫn cách sử dụng [Only registered and activated users can see links. ] được không?

[boy9000]

có người khác làm dc đó bạn chiu khó post câu hỏi lên nha tui bân ôn thi ko giúp dc mong bạn thông cảm

[silverwing1205]

Bác boy ơi sao khi download xong rồi không biết làm gì nữa bác hướng dẫn cách sử dụng [Only registered and activated users can see links. ] được không?

bạn qua bên ragezone có 1 bài hướng dẫn set server bằng colinux đó
đây nè [Only registered and activated users can see links. ]

[Nghia123123]

bạn qua bên ragezone có 1 bài hướng dẫn set server bằng colinux đó
đây nè [Only registered and activated users can see links. ]

Hix mình không rành tiếng anh cho lắm được thì bạn giúp mình và các thành viên khác luôn đi ( Như vậy topic này mới có giá trị chứ mình tin nhùi người không biết cài )
Thank nhiều

[boy9000]

nếu bạn ko dùng mạng thì có thểnoiis vắn tắt như sau (10' là chơi dc)
1. trươc hết cài Colinux trên ổ C:\
2. cài cái WinPcap (mặc định nó hoàn toàn)
3. cài SQL 2k có mở rộng SP4 (có lần tui ko mở rộng cũng chạy )
4. tạo DB vói tên là dbo
chạy SQL Query Analyzer với 2 bảng sau ( theo thứ tự )

/************************************************** *
addForbid
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE addForbid

@userid integer,
@type integer,
@forbid_time integer,
@reason varbinary(255),
@gmroleid integer

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE forbid SET ctime=getdate(),forbid_time=@forbid_time,reason=@r eason,gmroleid=@gmroleid WHERE userid=@userid AND type=@type
IF @@rowcount = 0 INSERT INTO forbid VALUES(@userid,@type,getdate(),@forbid_time,@reaso n,@gmroleid)
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/************************************************** *
addUserPriv
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE addUserPriv

@userid integer,
@zoneid integer,
@rid integer

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
INSERT INTO auth VALUES( @userid, @zoneid, @rid )
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/************************************************** *
acquireuserpasswd
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE acquireuserpasswd

@name varchar(64),
@uid integer out,
@passwd varchar(64) out

AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
DECLARE @passwdtemp binary(16)
SELECT @uid = id, @passwdtemp = passwd FROM users WHERE name = @name
SELECT @passwd = master.dbo.fn_varbintohexsubstring(1,@passwdtemp,1 ,0)
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/************************************************** *
adduser
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE adduser

@name varchar(64),
@passwd binary(16),
@prompt varchar(32),
@answer varchar(32),
@truename varchar(32),
@idnumber varchar(32),
@email varchar(64),
@mobilenumber varchar(32),
@province varchar(32),
@city varchar(32),
@phonenumber varchar(32),
@address varchar(64),
@postalcode varchar(8) ,
@gender integer,
@birthday varchar(32),
@qq varchar(32),
@passwd2 binary(16)

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
DECLARE @id integer
SELECT @id = ISNULL(max(id), 16) + 16 FROM users HOLDLOCK
INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,em ail,mobilenumber,province,city,phonenumber,address ,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( @id, @name, @passwd, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, getdate(), @qq, @passwd2 )
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
adduserpoint
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE adduserpoint

@uid integer,
@aid integer,
@time integer

AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE point SET time=ISNULL(time,0)+@time WHERE @uid=uid AND @aid=aid
IF @@rowcount = 0 INSERT INTO point (uid,aid,time) VALUES (@uid,@aid,@time)
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
changePasswd
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE changePasswd

@name varchar(64),
@passwd binary(16)

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE users SET passwd=@passwd WHERE name=@name
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
changePasswd2
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE changePasswd2

@name varchar(64),
@passwd2 binary(16)

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE users SET passwd2=@passwd2 WHERE name=@name
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
clearonlinerecords
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE clearonlinerecords
@zoneid integer,
@aid integer

AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE point SET zoneid = NULL, zonelocalid = NULL WHERE aid = @aid AND zoneid = @zoneid
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
delUserPriv
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE delUserPriv

@userid integer,
@zoneid integer,
@rid integer,
@deltype integer

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
IF @deltype = 0 DELETE FROM auth WHERE userid = @userid AND zoneid = @zoneid AND rid = @rid
ELSE IF @deltype = 1 DELETE FROM auth WHERE userid = @userid AND zoneid = @zoneid
ELSE IF @deltype = 2 DELETE FROM auth WHERE userid = @userid
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
deleteTimeoutForbid
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE deleteTimeoutForbid

@userid integer

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
DELETE FROM forbid WHERE userid=@userid AND datediff(ss,ctime,getdate())>forbid_time
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
enableiplimit
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE enableiplimit

@uid integer,
@enable char(1)

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE iplimit SET enable=@enable WHERE uid=@uid
IF @@rowcount = 0 INSERT INTO iplimit (uid,enable) VALUES (@uid,@enable)
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
lockuser
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE lockuser

@uid integer,
@lockstatus char(1)

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE iplimit SET lockstatus=@lockstatus WHERE uid=@uid
IF @@rowcount = 0 INSERT INTO iplimit (uid,lockstatus,enable) VALUES (@uid,@lockstatus,'t')
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
recordoffline
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE recordoffline

@uid integer,
@aid integer,
@zoneid integer out,
@zonelocalid integer out,
@overwrite integer out

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE point SET zoneid = NULL, zonelocalid = NULL WHERE uid = @uid AND aid = @aid AND zoneid = @zoneid
SELECT @overwrite = @@rowcount
IF @overwrite = 0 SELECT @zoneid = zoneid, @zonelocalid = zonelocalid FROM point WHERE uid = @uid AND aid = @aid
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
recordonline
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE recordonline

@uid integer,
@aid integer,
@zoneid integer out,
@zonelocalid integer out,
@overwrite integer out

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
DECLARE @tmp_zoneid integer
DECLARE @tmp_zonelocalid integer
SELECT @tmp_zoneid = zoneid, @tmp_zonelocalid = zonelocalid FROM point WHERE uid = @uid AND aid = @aid
IF @@rowcount = 0
INSERT INTO point (uid,aid,time,zoneid,zonelocalid,lastlogin) VALUES (@uid,@aid,0,@zoneid,@zonelocalid,getdate())
ELSE IF @tmp_zoneid = NULL OR @overwrite = 1
UPDATE point SET zoneid = @zoneid, zonelocalid = @zonelocalid, lastlogin = getdate() WHERE uid = @uid AND aid = @aid
IF @tmp_zoneid = NULL
SELECT @overwrite = 1
ELSE
SELECT @zoneid = @tmp_zoneid, @zonelocalid = @tmp_zonelocalid
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
remaintime
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE remaintime

@uid integer,
@aid integer,
@remain integer out,
@freetimeleft integer out

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
DECLARE @enddate datetime
DECLARE @now datetime
SELECT @now = getdate()
IF @aid = 0
BEGIN
SELECT @remain = 86313600
SELECT @enddate = dateadd(day,30,@now)
END
ELSE
BEGIN
SELECT @remain=time, @enddate=ISNULL(enddate,@now) FROM point WHERE @uid = uid AND @aid = aid
IF @@rowcount = 0
BEGIN
SELECT @remain = 0
INSERT INTO point (uid,aid,time) VALUES (@uid,@aid,@remain)
END
END
SELECT @freetimeleft = 0
IF @enddate > @now SELECT @freetimeleft = datediff(second, @now, @enddate )
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
setiplimit
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE setiplimit

@uid integer,
@ipaddr1 integer,
@ipmask1 varchar(2),
@ipaddr2 integer,
@ipmask2 varchar(2),
@ipaddr3 integer,
@ipmask3 varchar(2)
--@enable char(1)

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
UPDATE iplimit SET ipaddr1=@ipaddr1,ipmask1=@ipmask1,ipaddr2=@ipaddr2 ,ipmask2=@ipmask2,ipaddr3=@ipaddr3,ipmask3=@ipmask 3 WHERE uid=@uid
IF @@rowcount = 0 INSERT INTO iplimit (uid,ipaddr1,ipmask1,ipaddr2,ipmask2,ipaddr3,ipmas k3,enable) VALUES (@uid,@ipaddr1,@ipmask1,@ipaddr2,@ipmask2,@ipaddr3 ,@ipmask3,'t')
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
updateUserInfo
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE updateUserInfo

@name varchar(32),
@prompt varchar(32),
@answer varchar(32),
@truename varchar(32),
@idnumber varchar(32),
@email varchar(64),
@mobilenumber varchar(32),
@province varchar(32),
@city varchar(32),
@phonenumber varchar(32),
@address varchar(64),
@postalcode varchar(8),
@gender integer,
@birthday varchar(32),
@qq varchar(32)

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
update users set prompt=@prompt,answer=@answer,truename=@truename,i dnumber=@idnumber,email=@email,mobilenumber=@mobil enumber,province=@province,city=@city,phonenumber= @phonenumber,address=@address,postalcode=@postalco de,gender=@gender,birthday=@birthday,qq=@qq where name=@name
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/************************************************** *
usecash
************************************************** */

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE usecash

@userid integer,
@zoneid integer,
@sn integer,
@aid integer,
@point integer,
@cash integer,
@status integer,
@error integer out

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON

BEGIN TRAN
DECLARE @sn_old integer
DECLARE @aid_old integer
DECLARE @point_old integer
DECLARE @cash_old integer
DECLARE @status_old integer
DECLARE @creatime_old datetime
DECLARE @time_old integer
DECLARE @need_restore integer
DECLARE @exists integer

SELECT @error = 0
SELECT @need_restore = 0
SELECT @sn_old=sn,@aid_old=aid,@point_old=point,@cash_old =cash,@status_old=status,@creatime_old=creatime FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND sn>=0

IF @@rowcount = 1 SELECT @exists = 1
ELSE SELECT @exists = 0

IF @status = 0
BEGIN
IF @exists = 0
BEGIN
SELECT @aid=aid,@point=point FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn=sn
SELECT @point = ISNULL(@point,0)
UPDATE point SET time=time-@point WHERE @userid=uid AND @aid=aid AND time>=@point
IF @@rowcount = 1
UPDATE usecashnow SET sn=0, status=1 WHERE userid=@userid AND zoneid=@zoneid AND sn=@sn
ELSE
SELECT @error = -8
END
ELSE
SELECT @error = -7
END
ELSE IF @status = 1
BEGIN
IF @exists = 0
BEGIN
UPDATE point SET time=time-@point WHERE @userid=uid AND @aid=aid AND time>=@point
IF @@rowcount = 1
INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES(@userid, @zoneid, @sn, @aid, @point, @cash, @status, getdate() )
ELSE
BEGIN
INSERT INTO usecashnow SELECT @userid, @zoneid, ISNULL(min(sn),0)-1, @aid, @point, @cash, 0, getdate() FROM usecashnow WHERE userid=@userid and zoneid=@zoneid and 0>=sn
SELECT @error = -8
END
END
ELSE
BEGIN
INSERT INTO usecashnow SELECT @userid, @zoneid, ISNULL(min(sn),0)-1, @aid, @point, @cash, 0, getdate() FROM usecashnow WHERE userid=@userid and zoneid=@zoneid and 0>=sn
SELECT @error = -7
END
END
ELSE IF @status = 2
BEGIN
IF @exists = 1 AND @status_old = 1 AND @sn_old = 0
BEGIN
UPDATE usecashnow set sn = @sn, status=@status WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn
END
ELSE
BEGIN
SELECT @error = -9
END
END
ELSE IF @status = 3
BEGIN
IF @exists = 1 AND @status_old = 2
UPDATE usecashnow set status=@status WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn
ELSE
BEGIN
SELECT @error = -10
END
END
ELSE IF @status = 4
BEGIN
IF @exists = 1
BEGIN
DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn
INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES(@userid, @zoneid, @sn_old, @aid_old, @point_old, @cash_old, @status, @creatime_old, getdate() )
END
IF NOT (@exists = 1 AND @status_old = 3) SELECT @error = -11
END
ELSE
BEGIN
SELECT @error = -12
END

IF @need_restore = 1
BEGIN
UPDATE point SET time=time+@point_old WHERE @userid=uid AND @aid_old=aid
DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn
INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES(@userid, @zoneid, @sn_old, @aid_old, @point_old, @cash_old, @status, @creatime_old, getdate() )
END
COMMIT TRAN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

-- # table auth

CREATE TABLE [dbo].[auth] (
[userid] [int] NOT NULL ,
[zoneid] [int] NOT NULL ,
[rid] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[auth] WITH NOCHECK ADD
CONSTRAINT [PK_auth] PRIMARY KEY CLUSTERED
(
[userid],
[zoneid],
[rid]
) ON [PRIMARY]
GO

-- # table forbid

CREATE TABLE [dbo].[forbid] (
[userid] [int] NOT NULL ,
[type] [int] NOT NULL ,
[ctime] [datetime] NOT NULL ,
[forbid_time] [int] NOT NULL ,
[reason] [varbinary] (255) NOT NULL ,
[gmroleid] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[forbid] WITH NOCHECK ADD
CONSTRAINT [PK_forbid] PRIMARY KEY CLUSTERED
(
[userid],
[type]
) ON [PRIMARY]
GO

-- # table iplimit

CREATE TABLE [dbo].[iplimit] (
[uid] [int] NOT NULL ,
[ipaddr1] [int] NULL ,
[ipmask1] [varchar] (2) NULL ,
[ipaddr2] [int] NULL ,
[ipmask2] [varchar] (2) NULL ,
[ipaddr3] [int] NULL ,
[ipmask3] [varchar] (2) NULL ,
[enable] [char] (1) NULL ,
[lockstatus] [char] (1) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[iplimit] WITH NOCHECK ADD
CONSTRAINT [PK_iplimit] PRIMARY KEY CLUSTERED
(
[uid]
) ON [PRIMARY]
GO

-- # table point

CREATE TABLE [dbo].[point] (
[uid] [int] NOT NULL ,
[aid] [int] NOT NULL ,
[time] [int] NOT NULL ,
[zoneid] [int] NULL ,
[zonelocalid] [int] NULL ,
[accountstart] [datetime] NULL ,
[lastlogin] [datetime] NULL ,
[enddate] [datetime] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[point] WITH NOCHECK ADD
CONSTRAINT [PK_point] PRIMARY KEY CLUSTERED
(
[uid],
[aid]
) ON [PRIMARY]
GO

CREATE INDEX [IX_point_aidzoneid] ON [dbo].[point]([aid], [zoneid]) ON [PRIMARY]
GO

-- # table usecashlog

CREATE TABLE [dbo].[usecashlog] (
[userid] [int] NOT NULL ,
[zoneid] [int] NOT NULL ,
[sn] [int] NOT NULL ,
[aid] [int] NOT NULL ,
[point] [int] NOT NULL ,
[cash] [int] NOT NULL ,
[status] [int] NOT NULL ,
[creatime] [datetime] NOT NULL ,
[fintime] [datetime] NOT NULL
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [IX_usecashlog_uzs] ON [dbo].[usecashlog]([userid], [zoneid], [sn]) ON [PRIMARY]
GO

CREATE INDEX [IX_usecashlog_creatime] ON [dbo].[usecashlog]([creatime]) ON [PRIMARY]
GO

-- # table usecashnow

CREATE TABLE [dbo].[usecashnow] (
[userid] [int] NOT NULL ,
[zoneid] [int] NOT NULL ,
[sn] [int] NOT NULL ,
[aid] [int] NOT NULL ,
[point] [int] NOT NULL ,
[cash] [int] NOT NULL ,
[status] [int] NOT NULL ,
[creatime] [datetime] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[usecashnow] WITH NOCHECK ADD
CONSTRAINT [PK_usecashnow_1] PRIMARY KEY CLUSTERED
(
[userid],
[zoneid],
[sn]
) ON [PRIMARY]
GO

CREATE INDEX [IX_usecashnow_status] ON [dbo].[usecashnow]([status]) ON [PRIMARY]
GO

CREATE INDEX [IX_usecashnow_creatime] ON [dbo].[usecashnow]([creatime]) ON [PRIMARY]
GO

-- # table users

CREATE TABLE [dbo].[users] (
[ID] [int] NOT NULL ,
[name] [varchar] (32) NOT NULL ,
[passwd] [binary] (16) NOT NULL ,
[Prompt] [varchar] (32) NOT NULL ,
[answer] [varchar] (32) NOT NULL ,
[truename] [varchar] (32) NOT NULL ,
[idnumber] [varchar] (32) NOT NULL ,
[email] [varchar] (64) NOT NULL ,
[mobilenumber] [varchar] (32) NULL ,
[province] [varchar] (32) NULL ,
[city] [varchar] (32) NULL ,
[phonenumber] [varchar] (32) NULL ,
[address] [varchar] (64) NULL ,
[postalcode] [varchar] (8) NULL ,
[gender] [int] NULL ,
[birthday] [datetime] NULL ,
[creatime] [datetime] NOT NULL ,
[qq] [varchar] (32) NULL ,
[passwd2] [binary] (16) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[users] WITH NOCHECK ADD
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO

CREATE UNIQUE INDEX [IX_users_name] ON [dbo].[Users]([name]) ON [PRIMARY]
GO

CREATE INDEX [IX_users_creatime] ON [dbo].[Users]([creatime]) ON [PRIMARY]
GO

5. copy cái pwserver mới giải nén dc vaod C:\Colinux
6. vào C:\Colinux\pwserver chạy pwserver.bat (hình như thế đại khái là chạu file bat)
nó hiện cử sổ như cmd
chờ nó chạy xong sau dấu nhắc đánh nano /etc/hosts
thay địa chỉ 172.20.13.16 thành địa chỉ của mình nếu ko có mạng thi thay bang địa chỉ IP của card ảo (tham khảo cài card ảo ở đây http://vnsharing.net/forum/showthread.php?p=1723834)
muốn chạy sevver đánh ./start.sh
chọn 1 trong các lụa chọn 1->3 (để chạy server tui ko nhơ nãu)
vào cliet\element\usedata\server\serverlist.txt thêm dòng test 29000:127.0.0.1 1
thê là vào game choi thôi bạn rồi bảo thàng klhacs chỉ can kẽ hơn đi bb