xin query foresetweb

[Yahoo.com]

mình đang mò 1 bản share trên mạng về foreset bản 2012 . trong source lại ko có query lên chạy toàn lỗi - anh em ai có lòng tốt share mình xin nhé . Không nhận gạch đá vì nhà đã có . mình xin chân thành cảm ơn

[896588...]

Use MuOnline

CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
RETURNS BINARY(16) AS
BEGIN
DECLARE @hash BINARY(16)
EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
RETURN @hash
END

USE master
exec sp_addextendedproc 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'


Use MuOnline

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_Card]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_Card]
CREATE TABLE [dbo].[FW_Card] (
[AccountID] [varchar] (16) default NULL,
[Card_Code] [varchar] (15) default NULL,
[Card_Seri] [varchar] (15) default NULL,
[Card_Ammount] [int] default Null ,
[Card_Type] [varchar] (10) default NULL,
[Time_Charge] [int] default null,
[Time_Process] [int] default null,
[Status] [tinyint] NOT NULL default 0,
[KnpTransID] [varchar] (10) default NULL
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_Card_Fake]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_Card_Fake]
CREATE TABLE [dbo].[FW_Card_Fake] (
[AccountID] [varchar] (16) default NULL,
[Card_Code] [varchar] (15) default NULL,
[Card_Seri] [varchar] (15) default NULL,
[Card_Ammount] [int] default Null ,
[Card_Type] [varchar] (10) default NULL,
[Time_Charge] [int] default null,
[Time_Process] [int] default null,
[Status] [tinyint] NOT NULL default 0,
[KnpTransID] [varchar] (10) default NULL
) ON [PRIMARY]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_ChoTroi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_ChoTroi]
CREATE TABLE [dbo].[FW_ChoTroi] (
[id] INT IDENTITY(1,1),
[item_code] varchar(32) default NULL,
[item_price] int default NULL ,
[item_type] tinyint default NULL,
[item_sell] tinyint default NULL,
[seller] nvarchar(10) default NULL ,
[current_type] varchar(5) default NULL ,
[time_sell] int default null,
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_Log_Action]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_Log_Action]
CREATE TABLE [dbo].[FW_Log_Action] (
[AccountID] [varchar] (16) default NULL,
[IP] [varchar] (20) default NULL,
[Action] tinyint default NULL,
[Time] [int] DEFAULT NULL
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_OTP_SMS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_OTP_SMS]
CREATE TABLE [dbo].[FW_OTP_SMS] (
[AccountID] [varchar] (16) default NULL,
[OTP] [varchar] (10) default NULL,
[Time] [int] default NULL ,
[Status] [tinyint] NOT NULL DEFAULT (0)
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopResetInMonth]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TopResetInMonth]
CREATE TABLE [TopResetInMonth] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL ,
[Resets] [int] NOT NULL DEFAULT (0),
[MonthYear] [varchar] (10) NULL
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopResetInWeek]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TopResetInWeek]
CREATE TABLE [TopResetInWeek] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL ,
[Resets] [int] NOT NULL DEFAULT (0),
[WeekYear] [varchar] (10) NULL
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopResetInTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TopResetInTime]
CREATE TABLE [TopResetInTime] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL ,
[Resets] [int] NOT NULL DEFAULT (0),
[Code] [tinyint] NULL,
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopDanhVongInTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TopDanhVongInTime]
CREATE TABLE [TopDanhVongInTime] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL ,
[DanhVong] [int] NOT NULL DEFAULT (0),
[Code] [varchar] (10) NULL,
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopPointInTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TopPointInTime]
CREATE TABLE [TopPointInTime] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL ,
[Points] [int] NOT NULL DEFAULT (0),
[Code] [tinyint] NULL,
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_Event_Goblin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_Event_Goblin]
CREATE TABLE [FW_Event_Goblin] (
[id] [int] IDENTITY (1, 1) NOT NULL,
[Name] [varchar] (10) NULL,
[Item_Code] varchar(32) default NULL,
[Item_Serial] varchar(8) default NULL,
[Item_Level] [tinyint] null,
[UpTime] [int] null,
[Code] [tinyint] NULL,
[NotFair] [tinyint] not null default (0)
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_GiaiTri_LoDe]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_GiaiTri_LoDe]
CREATE TABLE [dbo].[FW_GiaiTri_LoDe] (
[ID] INT IDENTITY(1,1),
[Account] varchar(10) default NULL,
[Num_Bet1] varchar(2) default NULL,
[Num_Bet2] varchar(2) default NULL,
[Num_Bet3] varchar(2) default NULL,
[Num_Bet4] varchar(2) default NULL,
[Num_Point] int not null default 0,
[Type_play] varchar(7) default NULL,
[Type_MoneyBet] varchar(6) default NULL,
[Date_Bet] varchar(10) default NULL,
[Bet_Status] tinyint not null default 0
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_GiftCode]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_GiftCode]
CREATE TABLE [dbo].[FW_GiftCode](
[STT] [int] IDENTITY(1,1) NOT NULL,
[GiftCode] [varchar](10) NULL DEFAULT (null),
[Date_Create] [varchar](20) NULL DEFAULT (null),
[Date_Exp] [varchar](20) NULL DEFAULT (null),
[Date_Use] [varchar](20) NULL DEFAULT (null),
[Date_Give] [varchar](20) NULL DEFAULT (null),
[Acc_Use] [varchar](10) NULL DEFAULT (null),
[type] [tinyint] NOT NULL DEFAULT (0),
[Status] [tinyint] NOT NULL DEFAULT (0),
[Comment] [varchar](30) NULL DEFAULT (null)
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_FBAppLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_FBAppLog]
CREATE TABLE [dbo].[FW_FBAppLog](
[STT] [int] IDENTITY(1,1) NOT NULL,
[Fbuserid] [varchar](20) NULL DEFAULT (null),
[AccountID] [varchar](20) NULL DEFAULT (null),
[Time] [varchar](20) NULL DEFAULT (null),
[Count] [int] NOT NULL DEFAULT (0),
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopManhTuongInTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TopManhTuongInTime]
CREATE TABLE [TopManhTuongInTime] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL,
[Points] [int] NOT NULL DEFAULT (0),
[Week] [varchar] (10) NULL,
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ShopManhTuongBuyLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ShopManhTuongBuyLog]
CREATE TABLE [ShopManhTuongBuyLog] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL ,
[Week] [varchar] (10) NULL,
[TimeBuy] [tinyint] NULL,
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_DaiLy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_DaiLy]
CREATE TABLE [FW_DaiLy] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[AccountID] [varchar] (10) NULL ,
[DateCreate] [varchar] (20) NULL,
[BuLicense_Img] [varchar] (200) NULL,
[PhoneNum] [varchar] (15) default null,
[Yahoo] [varchar] (30) default null,
[Password] [varchar] (10) default null,
[Status] [tinyint] not null default 0,
[Money] [int] not null default 0,
[DisCount] [tinyint] not null default 0,
[DaiLyName] [varchar] (30) default null
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_DaiLy_Log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_DaiLy_Log]
CREATE TABLE [FW_DaiLy_Log] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[AccountID] [varchar] (10) NULL ,
[Number] [int] not null default 0,
[TimeTrans] [varchar] (20) NULL,
[Type] [varchar] (1) NULL,
[Content] [nvarchar] (200) NULL,
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_DaiLy_Order]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_DaiLy_Order]
CREATE TABLE [FW_DaiLy_Order] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[AccountID] [varchar] (10) NULL ,
[Number] [int] not null default 0,
[BankName] [varchar] (100) NULL,
[Time] [int] not null default 0,
[Status] [tinyint] not null default 0,
[TimeDuyet] [int] null
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopResetMiniInTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TopResetMiniInTime]
CREATE TABLE [TopResetMiniInTime] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (10) NULL ,
[Resets] [int] NOT NULL DEFAULT (0),
[WeekYear] [varchar] (10) NULL
) ON [PRIMARY]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FW_CheckTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FW_CheckTime]
CREATE TABLE [dbo].[FW_CheckTime](
[TimeCheck] [varchar](30) NULL DEFAULT (null)
) ON [PRIMARY]
Insert Into FW_CheckTime(TimeCheck) values(convert(varchar, getdate(), 25))


ALTER TABLE character ADD TanThu_CheckCapDo1 tinyint not null default 0
ALTER TABLE character ADD TanThu_CheckCapDo2 tinyint not null default 0
ALTER TABLE character ADD TanThu_CheckCapDo3 tinyint not null default 0
ALTER TABLE character ADD TanThu_CheckCapDo4 tinyint not null default 0
ALTER TABLE character ADD TanThu_CheckCapDo5 tinyint not null default 0
ALTER TABLE character ADD mu_id int IDENTITY

alter table dbo.character add Resets int not null default 0
alter table dbo.character add Day_Reset int not null default 0
alter table dbo.character add Last_Reset int default null
alter table dbo.character add Relifes int not null default 0
alter table dbo.character add Point_UyThac int not null default 0
alter table dbo.character add Status_UyThac tinyint not null default 0
alter table dbo.character add Time_UyThac int default null
alter table dbo.character add PointDuTru int not null default 0

Alter table Character add Point_Event_Add int not null default 0
Alter table Character add Event_ItemPoint_Type1 int not null default 0
Alter table Character add Event_ItemPoint_Type2 int not null default 0
Alter table Character add Event_ItemPoint_Type3 int not null default 0

Alter table Character add Event_MoneyvsUT_UTType int not null default 0
Alter table Character add Event_MoneyvsUT_MoneyType int not null default 0
Alter table Character add Event_MoneyvsUT_ItemType int not null default 0
Alter table Character add Event_MoneyvsUT_UTType_Day int not null default 0
Alter table Character add Event_MoneyvsUT_MoneyType_Day int not null default 0
Alter table Character add Event_MoneyvsUT_ItemType_Day int not null default 0
alter table character add DanhVong_Day tinyint not null default 0
alter table dbo.character add DiemDanhVong int not null default 0
alter table dbo.character add DiemManhTuong int not null default 0
alter table dbo.character add GHRSExtended int not null default 0
alter table dbo.character add QuestUpBack tinyint not null default 0

alter table dbo.memb_info add sid varchar(32) default null
alter table dbo.memb_info add PassCap1 varchar(32) default null
alter table dbo.memb_info add PassCap2 varchar(32) default null
alter table dbo.memb_info add Bank_Zen bigint NOT NULL default 0
alter table dbo.memb_info add Bank_MoneyC1 int NOT NULL default 0
alter table dbo.memb_info add Bank_MoneyC2 int NOT NULL default 0
alter table dbo.memb_info add Bank_Chaos int NOT NULL default 0
alter table dbo.memb_info add Bank_Cre int NOT NULL default 0
alter table dbo.memb_info add Bank_Blue int NOT NULL default 0
alter table dbo.memb_info add Block_End_Time int default null
alter table dbo.memb_info add IP_Secure varchar(200) default null
alter table dbo.memb_info add SecureQuestion int default null
alter table dbo.memb_info add SecureAnswer varchar(100) default null
alter table dbo.memb_info add Phone_No varchar(15) default null
alter table dbo.memb_info add Email_Address varchar(50) default null
alter table dbo.memb_info add Active_GCode tinyint not null default 0
alter table dbo.memb_info add Time_GiveCode int not null default 0
alter table dbo.memb_info add IPLoginCheck varchar(20) default null
alter table dbo.memb_info add Pass_Original varbinary(50) default null
alter table dbo.memb_info add Pass_Temp_Random varchar(10) default null
alter table dbo.memb_info add PendingBlock tinyint not null default 0
alter table dbo.memb_info add BlockInfo varchar(100) default null

ALTER TABLE warehouse ADD mu_wid int IDENTITY

Ủy Thác Online

1. Run Script

Create PROCEDURE UyThacOnline
As
Begin
Declare
@PointUyThac int,
@SubUyThac varchar(50)
SET @PointUyThac=5 -- So PointUyThac tang
SET @SubUyThac='Sub-1' --Ten Sub cho phep Uy Thac


UPDATE CHARACTER
SET Point_UyThac = Point_UyThac + @PointUyThac
FROM memb_stat, AccountCharacter, Character
Where MEMB_STAT.ConnectStat = 1 and MEMB_STAT.ServerName = @SubUyThac and MEMB_STAT.memb___id = AccountCharacter.Id and AccountCharacter.GameIDC = Character.Name

End

2. Create a JOB run every 5 minute bat dau tu 0h5'
exec UyThacOnline

[alobabyday]

mình cũng đang cần cái soucer web này bạn share mình với

[896588...]

mình cũng đang cần cái soucer web này bạn share mình với

scoure thấy share ở gamezone rồi mà

[heroviet2301]

Nên dùng NBB ấy, FW khó dùng lắm, mở rồi sập như chơi

[alobabyday]

scoure thấy share ở gamezone rồi mà

toàn link chết không bạn ơi................................

[n4poleong]

update link di bạn tìm ko ra

[heroviet2301]

Làm gì có ai share trên clb này đâu

[chicken1]

Vài hôm nữa mình sửa dc cái laptop
Mình gửi link cho
Ức quá mới sửa dc 1thang mât 3tr mà h nó hư tiếp
Demo:[Only registered and activated users can see links. ] nhé
Ai thích inbox mình gửi cho

[heroviet2301]

Khuyên dùng NBB đi, dùng FW chết lúc nào không biết với lại phải fix các lỗi tồn đọng của bản FW mặc định từ lamphuong như bug điểm ủy thác, ... thì mới dùng được, và FW mặc định có lối chơi khác NBB nhiều lắm và cần fix lại để mem nó thích ứng, FW mặc định GHRS cập nhập liên tục, điểm ủy thác thì ko giới hạn khiến game rất nhàm đó mem nó chỉ ủy thác ofline mà ko vào game thành ra Mu rất vắng người