PDA

View Full Version : [MU] Giúp web NBB :(



kubi.l0v3
23-03-12, 03:18 PM
Hiện mình đang làm SS2.
Dùng Db của NBB và web NBB
Khi cài xong đăng kí thành công
Gửi thông tin tk cho mình
NHưng khi đăg nhập website thì bị lỗi này:
<b><font color=red>[Chỉ có thành viên mới xem link được. <a href="register.php"> Nhấp đây để đăng ký thành viên......</a>]</font></b>
Mong mọi người giúp đỡ với
Xin cảm ơn

kubi.l0v3
23-03-12, 04:01 PM
ANh e giúp với ạ
đang cần quá a

Domino9990
23-03-12, 04:51 PM
chạy hết query này đi bạn..........

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

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 SCFMasterSkills 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
23-03-12, 05:58 PM
gấp lắm thì gửi db lên mình làm cho!
lẹ và đơn giản :>