Đăng nhập

View Full Version : [MU] Giúp em chạy query Mu NWebMU v5.13.1117


IUDONPHUONG
27-01-15, 03:35 PM
Em mới tham gia diễn đàn ..
mọi người biết hướng dẫn Teamwiear giúp em chạy query Mu ạ
em có xem hướng dẫn trên netbanbe nhưng query khác hay sao nhỉ .. bản NWebMU v5.13.1117 nó nhùi query nên em không biết chạy
cảm ơn mọi người
freepro921
27-01-15, 03:40 PM
Em mới tham gia diễn đàn ..
mọi người biết hướng dẫn Teamwiear giúp em chạy query Mu ạ
em có xem hướng dẫn trên netbanbe nhưng query khác hay sao nhỉ .. bản NWebMU v5.13.1117 nó nhùi query nên em không biết chạy
cảm ơn mọi người

bạn cứ copy all rồi paste vào khung query rồi F5 thôi , để chừng 5p là xong hết
IUDONPHUONG
27-01-15, 03:55 PM
bạn cứ copy all rồi paste vào khung query rồi F5 thôi , để chừng 5p là xong hết


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character_back]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Character_back];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Card_Vpoint]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Card_Vpoint];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CardPhone]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CardPhone];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DoanhThu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DoanhThu];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Check_Action]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Check_Action];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_TOP_RS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_TOP_RS];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_TOP_Point]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_TOP_Point];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_TOP_Card]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_TOP_Card];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PassRan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PassRan];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Invite];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Log_TienTe]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Log_TienTe];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bongda_giaidau]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bongda_giaidau];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bongda_tran]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bongda_tran];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bongda_dudoankq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bongda_dudoankq];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[IPBonus]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IPBonus];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[IPBonus_acc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[IPBonus_acc];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dupe_Scan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Dupe_Scan];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dupe_Scan_Online]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Dupe_Scan_Online];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dupe_Online]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Dupe_Online];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[item_vpoint_changed]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[item_vpoint_changed];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EventEpItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[EventEpItem];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ItemLock]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ItemLock];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopReset]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TopReset];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopResetScore]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TopResetScore];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGiaNguoc_Item]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGiaNguoc_Item];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGiaNguoc_Bid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGiaNguoc_Bid];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGiaNguoc_TheHe]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGiaNguoc_TheHe];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[daugia_dudoankq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[daugia_dudoankq];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[daugia_tran]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[daugia_tran];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[daugia_giaidau]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[daugia_giaidau];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Event_QWEBMU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Event_QWEBMU];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character_Top1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Character_Top1];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[quaysomienphi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[quaysomienphi];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GiftCode]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[GiftCode];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GiftLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[GiftLog];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Log_chuyensv]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Log_chuyensv];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OnePassDay]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[OnePassDay];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NBB_Award]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[NBB_Award];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SMS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[SMS];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGia_Item]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGia_Item];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DauGia_Bid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DauGia_Bid];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ChoTroi_Item]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ChoTroi_Item];
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ChoTroi_Bid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ChoTroi_Bid];
CREATE TABLE [dbo].[Card_Vpoint] (
[stt] [int] NOT NULL ,
[accdl] [varchar] (20) NULL ,
[menhgia] [int] NULL ,
[card_num] [varchar] (20) NULL ,
[card_serial] [varchar] (20) NULL ,
[time_create] [int] NULL ,
[accused] [varchar] (20) NULL ,
[time_nap] [int] NULL ,
[status] [tinyint] NULL
) ON [PRIMARY];
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];
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];
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];
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];
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),
[reset_score] [int] NOT NULL DEFAULT (0) ,
[time] [smalldatetime] NOT NULL DEFAULT (2013-01-01)
) ON [PRIMARY];
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),
[slg] [int] NOT NULL DEFAULT (0) ,
[type] [tinyint] NOT NULL DEFAULT (1) ,
[time] [smalldatetime] NOT NULL DEFAULT (2013-01-01)
) ON [PRIMARY];
CREATE TABLE [Event_TOP_Card] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (20) NULL ,
[gcoin] [bigint] NOT NULL DEFAULT (0),
[time] [smalldatetime] NOT NULL DEFAULT (2013-01-01)
) ON [PRIMARY];
CREATE TABLE [PassRan] (
[acc] [varchar] (10) NULL ,
[pass] [varchar] (10) NULL,
[pass_md5] [varchar] (50) NULL
) ON [PRIMARY];
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];
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];
CREATE TABLE [bongda_giaidau] (
[giai_id] [int] identity Primary Key NOT NULL ,
[giai_name] [nvarchar] (200) NOT NULL ,
[status] [tinyint] DEFAULT (0),
) ON [PRIMARY];
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];
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];
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];
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];
CREATE TABLE [Dupe_Scan] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[vitri] [tinyint] NOT NULL DEFAULT(0),
[isdupe] [tinyint] NOT NULL DEFAULT(0),
CONSTRAINT uc_DupeScan UNIQUE (acc,name,seri,vitri)
) ON [PRIMARY];
CREATE TABLE [Dupe_Scan_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[vitri] [tinyint] NOT NULL DEFAULT(0),
[isdupe] [tinyint] NOT NULL DEFAULT(0),
CONSTRAINT uc_DupeScanOnline UNIQUE (acc,name,seri,vitri)
) ON [PRIMARY];
CREATE TABLE [Dupe_Online] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[item] [varchar] (32) NULL ,
[seri] [varchar] (8) NOT NULL ,
[vitri] [tinyint] NOT NULL DEFAULT(0),
[time] [int] NULL,
CONSTRAINT uc_DupeScanDupeOnline UNIQUE (acc,name,seri,vitri)
) ON [PRIMARY];
CREATE TABLE [item_vpoint_changed] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NULL ,
[itemtype] [varchar] (50) NULL ,
[seri] [varchar] (8) NOT NULL ,
[value] [int] NOT NULL DEFAULT(0),
[time] [int] NULL,
CONSTRAINT uc_item_vpoint_changed UNIQUE (acc,name,seri)
) ON [PRIMARY];
CREATE TABLE [EventEpItem] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[item] [varchar] (32) NOT NULL ,
[seri] [varchar] (8) NOT NULL ,
[lvl] [tinyint] NOT NULL ,
[image] [varchar] (255) NULL ,
[time_reg] [int] NOT NULL ,
[info] [text] NULL ,
[time_finish] [int] NULL ,
[infoend] [text] NULL ,
[status] [tinyint] NOT NULL DEFAULT 0
) ON [PRIMARY];
CREATE TABLE [ItemLock] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[item] [varchar] (32) NOT NULL ,
[seri] [varchar] (8) NOT NULL ,
[lvl] [tinyint] NOT NULL ,
[image] [varchar] (255) NULL ,
[info] [text] NULL ,
[time] [int] NOT NULL,
[status] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [OnePassDay] (
[acc] [varchar] (10) NOT NULL ,
[opd] [varchar] (32) NOT NULL ,
[time] [int] NOT NULL
) ON [PRIMARY];
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];
CREATE TABLE [TopReset] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[reset] [int] NOT NULL DEFAULT(1) ,
[year] [int] NOT NULL DEFAULT(2012) ,
[month] [tinyint] NOT NULL DEFAULT(1) ,
[week] [tinyint] NOT NULL DEFAULT(1) ,
[day] [tinyint] NOT NULL DEFAULT(1) ,
[time] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [TopResetScore] (
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[reset_score] [bigint] NOT NULL DEFAULT(1) ,
[year] [int] NOT NULL DEFAULT(2012) ,
[month] [tinyint] NOT NULL DEFAULT(1) ,
[week] [tinyint] NOT NULL DEFAULT(1) ,
[day] [tinyint] NOT NULL DEFAULT(1) ,
[time] [int] NOT NULL
) ON [PRIMARY];
CREATE TABLE [DauGiaNguoc_Item] (
[bid_id] [int] IDENTITY (1, 1) NOT NULL ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[price_min] [int] NOT NULL DEFAULT (0) ,
[bid_mod] [int] NOT NULL DEFAULT (0) ,
[time_begin] [int] NOT NULL DEFAULT (0) ,
[time_end] [int] NOT NULL DEFAULT (0) ,
[bid_status] [tinyint] NOT NULL DEFAULT (1),
[reward_status] [tinyint] NOT NULL DEFAULT (0),
[reward_time] [int] NULL
) ON [PRIMARY];
CREATE TABLE [DauGiaNguoc_Bid] (
[bid_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[bid_vpoint] [int] NOT NULL DEFAULT (0) ,
[bid_time] [int] NOT NULL DEFAULT (0) ,
[win] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [DauGiaNguoc_TheHe] (
[bid_id] [int] NOT NULL ,
[thehe] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [DauGia_Item] (
[bid_id] [int] IDENTITY (1, 1) NOT NULL ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[item_group] [tinyint] NOT NULL ,
[price_min] [int] NOT NULL DEFAULT (100) ,
[price_max] [int] NOT NULL DEFAULT (200) ,
[bid_end] [int] NOT NULL ,
[acc_own] [varchar] (10) NOT NULL ,
[char_own] [varchar] (10) NOT NULL ,
[bid_status] [tinyint] NOT NULL DEFAULT (1),
[reward_status] [tinyint] NOT NULL DEFAULT (0),
[reward_time] [int] NULL
) ON [PRIMARY];
CREATE TABLE [DauGia_Bid] (
[bid_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[bid_vpoint] [int] NOT NULL DEFAULT (0) ,
[bid_time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [ChoTroi_Item] (
[bid_id] [int] IDENTITY (1, 1) NOT NULL ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[item_group] [tinyint] NOT NULL ,
[price_max] [int] NOT NULL DEFAULT (200) ,
[bid_end] [int] NOT NULL ,
[acc_own] [varchar] (10) NOT NULL ,
[char_own] [varchar] (10) NOT NULL ,
[bid_status] [tinyint] NOT NULL DEFAULT (1),
[reward_status] [tinyint] NOT NULL DEFAULT (0),
[reward_time] [int] NULL
) ON [PRIMARY];
CREATE TABLE [ChoTroi_Bid] (
[bid_id] [int] NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[bid_vpoint] [int] NOT NULL DEFAULT (0) ,
[bid_time] [int] NOT NULL DEFAULT (0) ,
[status] [tinyint] NOT NULL DEFAULT (1)
) ON [PRIMARY];
CREATE TABLE [dbo].[daugia_dudoankq] (
[dudoan_id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (10) NOT NULL ,
[daugia_id] [int] NULL ,
[dudoan_kq] [smallint] NOT NULL ,
[dudoan_slg] [int] NOT NULL ,
[time] [int] NOT NULL ,
[status] [tinyint] NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[daugia_tran] (
[daugia_id] [int] IDENTITY (1, 1) NOT NULL ,
[daugia_doi1] [nvarchar] (200) NOT NULL ,
[daugia_doi2] [nvarchar] (200) NOT NULL ,
[giai_id] [int] NULL ,
[daugia_kq1] [smallint] NULL ,
[daugia_kq2] [smallint] NULL ,
[time] [int] NOT NULL ,
[status] [tinyint] NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[daugia_giaidau] (
[giai_id] [int] IDENTITY (1, 1) NOT NULL ,
[giai_name] [nvarchar] (200) NOT NULL ,
[status] [tinyint] NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[Event_QWEBMU] (
[event_id ] [int] NOT NULL ,
[event_name] [nvarchar] (100) NOT NULL ,
[event_image] [varchar] (20) NULL ,
[event_des] [nvarchar] (2000) NULL ,
[event_level] [varchar] (10) NOT NULL ,
[item_event] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[event_award] [tinyint] NOT NULL DEFAULT (0),
[event_point] [int] NOT NULL DEFAULT (0),
[event_status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[Character_Top1] (
[name] [varchar] (50) NOT NULL ,
[resets] [int] NOT NULL DEFAULT (0),
[NoResetInDay] [int] NOT NULL DEFAULT (0)
) ON [PRIMARY];
CREATE TABLE [dbo].[quaysomienphi] (
[STT] [int] IDENTITY (1, 1) NOT NULL ,
[AccountID] [nvarchar] (50) NOT NULL ,
[Socap_Free] [int] NOT NULL DEFAULT (0),
[Trungcap_Free] [int] NOT NULL DEFAULT (0),
[Caocap_Free] [int] NOT NULL DEFAULT (0),
[Sieucap_Free] [int] NOT NULL DEFAULT (0),
[No_nv_rs_50] [int] NOT NULL DEFAULT (0),
[No_nv_rs_100] [int] NOT NULL DEFAULT (0),
[No_nv_rs_200] [int] NOT NULL DEFAULT (0),
) ON [PRIMARY];
CREATE TABLE [NBB_Award] (
[award_id] [int] IDENTITY (1, 1) NOT NULL ,
[award_info] [varchar] (250) NULL ,
[item_slg] [tinyint] NOT NULL DEFAULT (1) ,
[item_name] [varchar] (100) NOT NULL ,
[item_code] [varchar] (32) NOT NULL ,
[item_info] [text] NULL ,
[item_image] [varchar] (20) NULL ,
[seri_block] [tinyint] NOT NULL DEFAULT (0),
[acc] [varchar] (10) NOT NULL ,
[name] [varchar] (10) NOT NULL ,
[status] [tinyint] NOT NULL DEFAULT (0),
[create_time] [int] NULL,
[receive_time] [int] NULL,
[hsd_time] [int] NULL,
[thuhoi] [tinyint] NULL
) ON [PRIMARY];
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]
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];
CREATE TABLE [Log_chuyensv] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[acc] [varchar] (10) NOT NULL,
[char] [varchar] (10) NOT NULL,
[accnew] [varchar] (10) NOT NULL,
[charnew] [varchar] (10) NOT NULL
) ON [PRIMARY];
INSERT INTO Check_Action (action) VALUES ('ResetInDay');
INSERT INTO Check_Action (action) VALUES ('ResetInMonth');
INSERT INTO Check_Action (action) VALUES ('Top50');
INSERT INTO Character_Top1 (name) VALUES ('QWEBMU');


như đoạn này mình ctr+A rồi chép query vào MuOnline hả a
freepro921
27-01-15, 04:03 PM
như đoạn này mình ctr+A rồi chép query vào MuOnline hả a

đúng rồi bạn
30cccccccccccccccccccccccc
IUDONPHUONG
27-01-15, 04:14 PM
đúng rồi bạn
30cccccccccccccccccccccccc

cho em hỏi khôn tí nữa nha :"> sao em thấy clip trên netbanbe nó copy từng cái gì đó a ơi
a team giúp e 1 lần đựoc không ạ
freepro921
27-01-15, 04:39 PM
cho em hỏi khôn tí nữa nha :"> sao em thấy clip trên netbanbe nó copy từng cái gì đó a ơi
a team giúp e 1 lần đựoc không ạ
<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>
bạn chạy file query này nhé : <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>
loveoggy
16-08-15, 06:27 PM
Mod up lai link cho e voi ^^. Cam On

--- Chế độ gộp bài viết ---


<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>
bạn chạy file query này nhé : <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>
Mod up lai link cho e voi . 30 charrrrrrrrrrrrrrrrr
LHB_LOVE
16-08-15, 09:29 PM
cho em hỏi khôn tí nữa nha :"> sao em thấy clip trên netbanbe nó copy từng cái gì đó a ơi
a team giúp e 1 lần đựoc không ạ

cái clip đó làm từ lâu rồi :) sau này Nbb viết lại chạy 1 lần cũng như job cũng ko cần phải tạo thủ công mà chạy query cũng xong khõe re :)