Giúp em chạy query Mu NWebMU v5.13.1117

[IUDONPHUONG]

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]

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]

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]

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]

đú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]

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 ạ

mình ko rõ tại sao nbb làm thế nhưng bạn cứ copy all rồi chạy thôi ko cần copy từng cái chi cho lâu , chạy query thôi cần gì phải team @@
bạn chạy file query này nhé : [Only registered and activated users can see links. ]

[loveoggy]

Mod up lai link cho e voi ^^. Cam On

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

mình ko rõ tại sao nbb làm thế nhưng bạn cứ copy all rồi chạy thôi ko cần copy từng cái chi cho lâu , chạy query thôi cần gì phải team @@
bạn chạy file query này nhé : [Only registered and activated users can see links. ]

Mod up lai link cho e voi . 30 charrrrrrrrrrrrrrrrr

[LHB_LOVE]

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