Lỗi RS VIP Web nbb phiên bản NWebMU v4.12.0308

[cubao91]

Lỗi Query SELECT gcoin, gcoin_km, vpoint FROM MEMB_INFO WHERE memb___id='123123' , MÌnh xài database gốc của nbb. ai biết lỗi này fix sao k vậy

[sunhide]

Lỗi Query SELECT gcoin, gcoin_km, vpoint FROM MEMB_INFO WHERE memb___id='123123' , MÌnh xài database gốc của nbb. ai biết lỗi này fix sao k vậy

Thiếu Querry nà.......................

[cubao91]

sunhie mình đã chay query và nó báo đã có vậy bây giờ phải làm sao

[Domino9990]

lấy DB này về xem ....................

[Only registered and activated users can see links. ]

[cubao91]

DB này đã có người chơi và mình sắp open mình k muốn bỏ phí PRo nào giúp mình với
Query Error : SELECT gcoin, gcoin_km, vpoint FROM MEMB_INFO WHERE memb___id='123123'

[MuVietGroup]

lấy DB này về xem ....................

[Only registered and activated users can see links. ]

Cho link down mà ko cho pass thì down = gì bạn

[MuVietGroup]

Domino vào cho cái pass download cái nào bạn ơi

[thangvp]

Domino vào cho cái pass download cái nào bạn ơi

Pass là domino9990 nhé.30charrrrrrrrr

[khanhdkny]

hỏi người share web!Bạn thiếu querry của web này!Mình trước cũng bị thế lấy query của người share web chạy là OK
Thử Query này xem
CREATE TABLE [Character_back] (
[AccountID] [varchar] (10) NOT NULL ,
[Name] [varchar] (10) NOT NULL ,
[LevelUpPoint] [int] NULL DEFAULT (0),
[Class] [tinyint] NULL ,
[Leadership] [smallint] NULL DEFAULT (0),
[Resets] [int] NOT NULL DEFAULT (0),
[Relifes] [int] NOT NULL DEFAULT (0),
[NoResetInDay] [int] NOT NULL DEFAULT (0),
[NoResetInMonth] [int] NOT NULL DEFAULT (0),
[PointUyThac] [int] NOT NULL DEFAULT (0),
[point_event] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [CardPhone] (
[stt] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[Name] [varchar] (10) NULL ,
[menhgia] [int] NULL ,
[card_type] [varchar] (20) NULL ,
[card_num] [varchar] (20) NULL ,
[card_num_md5] [varchar] (32) NULL ,
[card_serial] [varchar] (20) NULL ,
[ngay] [smalldatetime] NULL ,
[status] [tinyint] NOT NULL DEFAULT (0) ,
[addvpoint] [varchar] (20) NULL ,
[timenap] [int] NULL ,
[timeduyet] [int] NULL ,
[teknet_check_wait] [tinyint] NOT NULL DEFAULT (0),
[teknet_check_last] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [DoanhThu] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[year] [int] NOT NULL DEFAULT (2008),
[month] [int] NOT NULL DEFAULT (1),
[money] [int] NOT NULL DEFAULT (0),
[card_type] [varchar] (20) NULL
) ON [PRIMARY]
GO

CREATE TABLE [Check_Action] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[action] [varchar] (20) NULL ,
[time] [int] NOT NULL DEFAULT (0),
[status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO
INSERT INTO Check_Action (action) VALUES ('ResetInDay')
INSERT INTO Check_Action (action) VALUES ('ResetInMonth')
INSERT INTO Check_Action (action) VALUES ('Top50')

CREATE TABLE [Event_TOP_RS] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[name] [varchar] (20) NULL ,
[resets] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Event_TOP_Point] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[name] [varchar] (20) NULL ,
[points] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Event_TOP_Card] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[gcoin] [bigint] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [SMS] (
[acc] [varchar] (20) NOT NULL ,
[KeyXuLy] [varchar] (20) NOT NULL ,
[time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (0),
[Code] [int] NOT NULL DEFAULT (0),
[dulieu1] [varchar] (50) NULL ,
[dulieu2] [varchar] (50) NULL ,
[dulieu3] [varchar] (50) NULL ,
[dulieu4] [varchar] (50) NULL ,
[dulieu5] [varchar] (50) NULL
) ON [PRIMARY]
GO

CREATE TABLE [PassRan] (
[acc] [varchar] (10) NULL ,
[pass] [varchar] (10) NULL,
[pass_md5] [varchar] (50) NULL
) ON [PRIMARY]
GO

CREATE TABLE [Invite] (
[acc_invite] [varchar] (10) NOT NULL ,
[acc_accept] [varchar] (10) NOT NULL ,
[time_invite] [int] NOT NULL DEFAULT (0) ,
[vpoint_invite] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Log_TienTe] (
[acc] [varchar] (10) NOT NULL,
[gcoin] [int] DEFAULT (0),
[gcoin_km] [int] DEFAULT (0),
[vpoint] [int] DEFAULT (0),
[price] [nvarchar] (250),
[Des] [ntext],
[time] [int] DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [bongda_giaidau] (
[giai_id] [int] identity Primary Key NOT NULL ,
[giai_name] [nvarchar] (200) NOT NULL ,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY]
GO

CREATE TABLE [bongda_tran] (
[tran_id] [int] identity Primary Key NOT NULL ,
[tran_doi1] [nvarchar] (200) NOT NULL ,
[tran_doi2] [nvarchar] (200) NOT NULL ,
[giai_id] [int] DEFAULT(0) ,
[tran_kq1] [smallint] DEFAULT (0),
[tran_kq2] [smallint] DEFAULT (0),
[time] [int] NOT NULL,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY]
GO

CREATE TABLE [bongda_dudoankq] (
[dudoan_id] [int] identity Primary Key NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[tran_id] [int] DEFAULT(0) ,
[dudoan_kq] [smallint] NOT NULL ,
[dudoan_slg] [int] NOT NULL DEFAULT (0),
[time] [int] NOT NULL,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY]
GO

CREATE TABLE [IPBonus] (
[ipbonus_id] [int] identity Primary Key NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[ip] [varchar] (50) NOT NULL ,
[InternetName] [nvarchar] (200) NOT NULL ,
[Address] [nvarchar] (250) NOT NULL,
[QuanHuyen] [nvarchar] (100) NOT NULL,
[ThanhPho] [nvarchar] (100) NOT NULL,
[totalacc] [int] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [IPBonus_acc] (
[ipbonus_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
CONSTRAINT pk_IPBonus_acc PRIMARY KEY (ipbonus_id,acc)
) ON [PRIMARY]
GO

CREATE TABLE [GiftCode] (
[gift_code] [varchar] (10) NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[reset] [int] NULL ,
[type] [tinyint] NOT NULL DEFAULT(0) ,
[gift_time] [int] NOT NULL ,
[gift_timeuse] [int] NULL ,
[ngay] [smalldatetime] NOT NULL ,
[status] [tinyint] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [GiftLog] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[reset] [int] NULL ,
[type] [tinyint] NOT NULL DEFAULT(0) ,
[time] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [Dupe_Scan] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[slgitem] [tinyint] NOT NULL DEFAULT(1) ,
[isdupe] [tinyint] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [Dupe_Scan_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[slgitem] [tinyint] NOT NULL DEFAULT(1) ,
[isdupe] [tinyint] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [Dupe_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[slgitem] [tinyint] NOT NULL DEFAULT(1),
[time] [int] NULL
) ON [PRIMARY]
GO

Alter TABLE MEMB_INFO ADD bank bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD vpoint bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD gcoin bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD gcoin_km bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD memb__pwd2 char(10)
Alter TABLE MEMB_INFO ADD memb__pwdmd5 char(50)
Alter TABLE MEMB_INFO ADD pass2 char(10)
Alter TABLE MEMB_INFO ADD jewel_chao int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD jewel_cre int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD jewel_blue int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD passran tinyint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD checklogin varchar(50) null
Alter TABLE MEMB_INFO ADD time_checksms int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD checksms_status tinyint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD admin_block tinyint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD time_reg datetime NOT NULL DEFAULT GetDate()
Alter TABLE MEMB_INFO ADD ip varchar(20) NULL
Alter TABLE MEMB_INFO ADD thehe tinyint NOT NULL DEFAULT 1
Alter TABLE MEMB_INFO ADD BlockTime int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD BlockSlg int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD IPBonusPoint int NOT NULL DEFAULT 0

Alter TABLE Character ADD Resets int NOT NULL DEFAULT 0
Alter TABLE Character ADD ResetNBB int NOT NULL DEFAULT 0
Alter TABLE Character ADD ResetVIP int NOT NULL DEFAULT 0
Alter TABLE Character ADD Resets_Time int NOT NULL DEFAULT 0
Alter TABLE Character ADD NoResetInDay int NOT NULL DEFAULT 0
Alter TABLE Character ADD SCFMasterSkill varbinary(180) null
Alter TABLE Character ADD DGT_Time int NOT NULL DEFAULT 0

Alter TABLE Character ADD TopMonth01 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth02 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth03 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth04 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth05 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth06 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth07 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth08 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth09 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth10 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth11 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth12 int NOT NULL DEFAULT 0
Alter TABLE Character ADD Top50 int NOT NULL DEFAULT 0

alter TABLE Character ADD Relifes int NOT NULL DEFAULT 0
alter TABLE Character ADD khoado tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD makhoado varchar(50)
alter TABLE Character ADD IsThuePoint tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD TimeThuePoint int NOT NULL DEFAULT 0
alter TABLE Character ADD PointThue int NOT NULL DEFAULT 0
alter TABLE Character ADD ErrorSubBlock tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD pointdutru int NOT NULL DEFAULT 0

alter TABLE Character ADD UyThac tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD uythacoffline_stat int NOT NULL DEFAULT 0
alter TABLE Character ADD uythacoffline_time int NOT NULL DEFAULT 0
alter TABLE Character ADD UyThacOffline_Daily int NOT NULL DEFAULT 0
alter TABLE Character ADD PointUyThac int NOT NULL DEFAULT 0
alter TABLE Character ADD Onlinetime int NOT NULL DEFAULT 0

Alter TABLE Character ADD point_event int NOT NULL DEFAULT 0
Alter TABLE Character ADD event1_type1 int NOT NULL DEFAULT 0
Alter TABLE Character ADD event1_type2 int NOT NULL DEFAULT 0
Alter TABLE Character ADD event1_type3 int NOT NULL DEFAULT 0

[bistro007_hp]

hỏi người share web!Bạn thiếu querry của web này!Mình trước cũng bị thế lấy query của người share web chạy là OK
Thử Query này xem
CREATE TABLE [Character_back] (
[AccountID] [varchar] (10) NOT NULL ,
[Name] [varchar] (10) NOT NULL ,
[LevelUpPoint] [int] NULL DEFAULT (0),
[Class] [tinyint] NULL ,
[Leadership] [smallint] NULL DEFAULT (0),
[Resets] [int] NOT NULL DEFAULT (0),
[Relifes] [int] NOT NULL DEFAULT (0),
[NoResetInDay] [int] NOT NULL DEFAULT (0),
[NoResetInMonth] [int] NOT NULL DEFAULT (0),
[PointUyThac] [int] NOT NULL DEFAULT (0),
[point_event] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [CardPhone] (
[stt] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[Name] [varchar] (10) NULL ,
[menhgia] [int] NULL ,
[card_type] [varchar] (20) NULL ,
[card_num] [varchar] (20) NULL ,
[card_num_md5] [varchar] (32) NULL ,
[card_serial] [varchar] (20) NULL ,
[ngay] [smalldatetime] NULL ,
[status] [tinyint] NOT NULL DEFAULT (0) ,
[addvpoint] [varchar] (20) NULL ,
[timenap] [int] NULL ,
[timeduyet] [int] NULL ,
[teknet_check_wait] [tinyint] NOT NULL DEFAULT (0),
[teknet_check_last] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [DoanhThu] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[year] [int] NOT NULL DEFAULT (2008),
[month] [int] NOT NULL DEFAULT (1),
[money] [int] NOT NULL DEFAULT (0),
[card_type] [varchar] (20) NULL
) ON [PRIMARY]
GO

CREATE TABLE [Check_Action] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[action] [varchar] (20) NULL ,
[time] [int] NOT NULL DEFAULT (0),
[status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO
INSERT INTO Check_Action (action) VALUES ('ResetInDay')
INSERT INTO Check_Action (action) VALUES ('ResetInMonth')
INSERT INTO Check_Action (action) VALUES ('Top50')

CREATE TABLE [Event_TOP_RS] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[name] [varchar] (20) NULL ,
[resets] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Event_TOP_Point] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[name] [varchar] (20) NULL ,
[points] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Event_TOP_Card] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[gcoin] [bigint] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [SMS] (
[acc] [varchar] (20) NOT NULL ,
[KeyXuLy] [varchar] (20) NOT NULL ,
[time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (0),
[Code] [int] NOT NULL DEFAULT (0),
[dulieu1] [varchar] (50) NULL ,
[dulieu2] [varchar] (50) NULL ,
[dulieu3] [varchar] (50) NULL ,
[dulieu4] [varchar] (50) NULL ,
[dulieu5] [varchar] (50) NULL
) ON [PRIMARY]
GO

CREATE TABLE [PassRan] (
[acc] [varchar] (10) NULL ,
[pass] [varchar] (10) NULL,
[pass_md5] [varchar] (50) NULL
) ON [PRIMARY]
GO

CREATE TABLE [Invite] (
[acc_invite] [varchar] (10) NOT NULL ,
[acc_accept] [varchar] (10) NOT NULL ,
[time_invite] [int] NOT NULL DEFAULT (0) ,
[vpoint_invite] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [Log_TienTe] (
[acc] [varchar] (10) NOT NULL,
[gcoin] [int] DEFAULT (0),
[gcoin_km] [int] DEFAULT (0),
[vpoint] [int] DEFAULT (0),
[price] [nvarchar] (250),
[Des] [ntext],
[time] [int] DEFAULT (0)
) ON [PRIMARY]
GO

CREATE TABLE [bongda_giaidau] (
[giai_id] [int] identity Primary Key NOT NULL ,
[giai_name] [nvarchar] (200) NOT NULL ,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY]
GO

CREATE TABLE [bongda_tran] (
[tran_id] [int] identity Primary Key NOT NULL ,
[tran_doi1] [nvarchar] (200) NOT NULL ,
[tran_doi2] [nvarchar] (200) NOT NULL ,
[giai_id] [int] DEFAULT(0) ,
[tran_kq1] [smallint] DEFAULT (0),
[tran_kq2] [smallint] DEFAULT (0),
[time] [int] NOT NULL,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY]
GO

CREATE TABLE [bongda_dudoankq] (
[dudoan_id] [int] identity Primary Key NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[tran_id] [int] DEFAULT(0) ,
[dudoan_kq] [smallint] NOT NULL ,
[dudoan_slg] [int] NOT NULL DEFAULT (0),
[time] [int] NOT NULL,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY]
GO

CREATE TABLE [IPBonus] (
[ipbonus_id] [int] identity Primary Key NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[ip] [varchar] (50) NOT NULL ,
[InternetName] [nvarchar] (200) NOT NULL ,
[Address] [nvarchar] (250) NOT NULL,
[QuanHuyen] [nvarchar] (100) NOT NULL,
[ThanhPho] [nvarchar] (100) NOT NULL,
[totalacc] [int] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [IPBonus_acc] (
[ipbonus_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
CONSTRAINT pk_IPBonus_acc PRIMARY KEY (ipbonus_id,acc)
) ON [PRIMARY]
GO

CREATE TABLE [GiftCode] (
[gift_code] [varchar] (10) NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[reset] [int] NULL ,
[type] [tinyint] NOT NULL DEFAULT(0) ,
[gift_time] [int] NOT NULL ,
[gift_timeuse] [int] NULL ,
[ngay] [smalldatetime] NOT NULL ,
[status] [tinyint] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [GiftLog] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[reset] [int] NULL ,
[type] [tinyint] NOT NULL DEFAULT(0) ,
[time] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [Dupe_Scan] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[slgitem] [tinyint] NOT NULL DEFAULT(1) ,
[isdupe] [tinyint] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [Dupe_Scan_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[slgitem] [tinyint] NOT NULL DEFAULT(1) ,
[isdupe] [tinyint] NOT NULL DEFAULT(0)
) ON [PRIMARY]
GO

CREATE TABLE [Dupe_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[slgitem] [tinyint] NOT NULL DEFAULT(1),
[time] [int] NULL
) ON [PRIMARY]
GO

Alter TABLE MEMB_INFO ADD bank bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD vpoint bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD gcoin bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD gcoin_km bigint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD memb__pwd2 char(10)
Alter TABLE MEMB_INFO ADD memb__pwdmd5 char(50)
Alter TABLE MEMB_INFO ADD pass2 char(10)
Alter TABLE MEMB_INFO ADD jewel_chao int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD jewel_cre int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD jewel_blue int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD passran tinyint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD checklogin varchar(50) null
Alter TABLE MEMB_INFO ADD time_checksms int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD checksms_status tinyint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD admin_block tinyint NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD time_reg datetime NOT NULL DEFAULT GetDate()
Alter TABLE MEMB_INFO ADD ip varchar(20) NULL
Alter TABLE MEMB_INFO ADD thehe tinyint NOT NULL DEFAULT 1
Alter TABLE MEMB_INFO ADD BlockTime int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD BlockSlg int NOT NULL DEFAULT 0
Alter TABLE MEMB_INFO ADD IPBonusPoint int NOT NULL DEFAULT 0

Alter TABLE Character ADD Resets int NOT NULL DEFAULT 0
Alter TABLE Character ADD ResetNBB int NOT NULL DEFAULT 0
Alter TABLE Character ADD ResetVIP int NOT NULL DEFAULT 0
Alter TABLE Character ADD Resets_Time int NOT NULL DEFAULT 0
Alter TABLE Character ADD NoResetInDay int NOT NULL DEFAULT 0
Alter TABLE Character ADD SCFMasterSkill varbinary(180) null
Alter TABLE Character ADD DGT_Time int NOT NULL DEFAULT 0

Alter TABLE Character ADD TopMonth01 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth02 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth03 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth04 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth05 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth06 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth07 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth08 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth09 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth10 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth11 int NOT NULL DEFAULT 0
Alter TABLE Character ADD TopMonth12 int NOT NULL DEFAULT 0
Alter TABLE Character ADD Top50 int NOT NULL DEFAULT 0

alter TABLE Character ADD Relifes int NOT NULL DEFAULT 0
alter TABLE Character ADD khoado tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD makhoado varchar(50)
alter TABLE Character ADD IsThuePoint tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD TimeThuePoint int NOT NULL DEFAULT 0
alter TABLE Character ADD PointThue int NOT NULL DEFAULT 0
alter TABLE Character ADD ErrorSubBlock tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD pointdutru int NOT NULL DEFAULT 0

alter TABLE Character ADD UyThac tinyint NOT NULL DEFAULT 0
alter TABLE Character ADD uythacoffline_stat int NOT NULL DEFAULT 0
alter TABLE Character ADD uythacoffline_time int NOT NULL DEFAULT 0
alter TABLE Character ADD UyThacOffline_Daily int NOT NULL DEFAULT 0
alter TABLE Character ADD PointUyThac int NOT NULL DEFAULT 0
alter TABLE Character ADD Onlinetime int NOT NULL DEFAULT 0

Alter TABLE Character ADD point_event int NOT NULL DEFAULT 0
Alter TABLE Character ADD event1_type1 int NOT NULL DEFAULT 0
Alter TABLE Character ADD event1_type2 int NOT NULL DEFAULT 0
Alter TABLE Character ADD event1_type3 int NOT NULL DEFAULT 0

DB này mình thấy kì lạ.
Còn việc trên db này của nbb.Mà nbb mình đã so sánh chạy hết querry rồi
kêu chủ topic thay db thì ko chịu nên mình cũng chưa có thời gian test nên cũng ko biết